Database snapshots

Snapshots of the data portal database are available from the EBI FTP server

For most multi-omics data queries, the API provides a set of endpoints to retrieve the desired filtered dataset. However, users may also download a SQLite file of the data portal database if they prefer to query it directly – e.g. to more quickly retrieve many queries.

The database is a SQLite3 file. Tools to query these databases exist on every platform and for many programming languages. Python has built-in support for them.

As a realistic example of it’s use, the following SQL query would retrieve a list of… TODO

TODO