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
|