Similarly as [MySQL] Rfam authors is a public MySQL datasource, you can find some public PostgreSQL datasources. In this page, we demonstrate how you can connect to RNAcentral public PostgreSQL database.

Preview

Datasource

Field

Value

Name

RNAcentral

Type

PostgreSQL

JDBC URL

jdbc:postgresql://hh-pgsql-public.ebi.ac.uk:5432/pfmegrnargs

User

reader

Password

NWDMCE5xdipIjRrp

Query

Field

Value

Name

RNA Central

Datasource

RNAcentral

SQL Statement

SELECT id, upi, timestamp, userstamp, crc64, len
FROM RNA
LIMIT 10;
SQL