# Bulk downloads RNAcentral data can be downloaded in bulk from the FTP Archive, queried through the REST API or the public Postgres database, or exported from the text search. ## Choosing an access method | Task | Recommended access method | | --- | --- | | Download complete release files | [FTP Archive](#ftp-archive) | | Download archived release snapshots | [FTP Archive](#ftp-archive) | | Retrieve one sequence or a small result set | [REST API](api.md) | | Integrate RNAcentral into software | [REST API](api.md) | | Map many identifiers in bulk | [Identifier mapping files](#identifier-mapping-files) | | Run SQL queries across RNAcentral tables | [Public Postgres database](database.md) | | Export a filtered subset of sequences | [Text search export](searching-rnacentral.md#download-search-results) | ## FTP Archive To retrieve **large amounts of data** or to download **archived data snapshots**, use the RNAcentral FTP Archive at (no authentication required). The files are produced during each RNAcentral release. The current release is in [current_release](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/), and every release back to 1.0-beta is kept in [releases](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/releases/). Older releases contain largely the same files, though the data has evolved over time. Most files are compressed with gzip and end in `.gz`; decompress them with `gzip -d `. Most directories also contain a readme file that explains their contents. ### Files available | Name | Description | Format | Link | | --- | --- | --- | --- | | Database files | A dump of the Postgres database, in directory format (`toc.dat` plus one file per table), which can be restored with [pg_restore](https://www.postgresql.org/docs/current/app-pgrestore.html). Removed from older releases. | [pg_dump](https://www.postgresql.org/docs/current/app-pgdump.html) | [database_files](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/database_files/) | | Genome coordinates | Coordinates of RNAs in RNAcentral in each model organism, as annotated by expert databases | [BED](https://genome.ucsc.edu/FAQ/FAQformat.html#format1), [GFF3](https://github.com/The-Sequence-Ontology/Specifications/blob/master/gff3.md) | [BED](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/genome_coordinates/bed/), [GFF3](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/genome_coordinates/gff3/) | | GO annotations | Mappings of RNAcentral entries to [Gene Ontology](https://geneontology.org/) terms | [TSV](https://en.wikipedia.org/wiki/Tab-separated_values) | [rnacentral_rfam_annotations.tsv.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/go_annotations/rnacentral_rfam_annotations.tsv.gz) | | GPI | Gene product information for selected RNAs, with separate species and reference proteome files | [GPI](https://geneontology.org/docs/gene-product-information-gpi-format/) | [gpi](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/gpi/) | | ID mapping | Mapping of RNAcentral IDs to expert database IDs, also available per database | [TSV](https://en.wikipedia.org/wiki/Tab-separated_values) | [id_mapping.tsv.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/id_mapping/id_mapping.tsv.gz), [per database](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/id_mapping/database_mappings/) | | JSON | RNAcentral IDs and their cross-references to Ensembl, 100,000 sequences per file | [JSON](https://en.wikipedia.org/wiki/JSON) | [json](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/json/) | | MD5 | RNAcentral IDs mapped to the [MD5 hash](https://en.wikipedia.org/wiki/MD5) of each sequence | [TSV](https://en.wikipedia.org/wiki/Tab-separated_values) | [md5.tsv.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/md5/md5.tsv.gz) | | Rfam | RNAcentral IDs with their associated [Rfam](https://rfam.org) annotations | [TSV](https://en.wikipedia.org/wiki/Tab-separated_values) | [rfam_annotations.tsv.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/rfam/rfam_annotations.tsv.gz) | | Sequences (active) | Sequences present in at least one expert database | [FASTA](https://en.wikipedia.org/wiki/FASTA_format) | [rnacentral_active.fasta.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/sequences/rnacentral_active.fasta.gz) | | Sequences (inactive) | Sequences no longer present in any expert database | [FASTA](https://en.wikipedia.org/wiki/FASTA_format) | [rnacentral_inactive.fasta.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/sequences/rnacentral_inactive.fasta.gz) | | Sequences (species specific) | Active sequences with species-specific IDs (`URS…_taxid`) | [FASTA](https://en.wikipedia.org/wiki/FASTA_format) | [rnacentral_species_specific_ids.fasta.gz](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/sequences/rnacentral_species_specific_ids.fasta.gz) | | Sequences (by database) | Active sequences, one file per expert database | [FASTA](https://en.wikipedia.org/wiki/FASTA_format) | [by-database](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/sequences/by-database/) | | Sequences (by species) | Species-specific sequences, one file per species, grouped by taxonomic group | [FASTA](https://en.wikipedia.org/wiki/FASTA_format) | [by-species](https://ftp.ebi.ac.uk/pub/databases/RNAcentral/current_release/sequences/by-species/) | ### Identifier mapping files Use the ID mapping files when you need to map many identifiers between RNAcentral and [expert databases](expert-databases.md): - combined file: `current_release/id_mapping/id_mapping.tsv.gz` - per-database files: `current_release/id_mapping/database_mappings/` See [Linking to RNAcentral](linking-rnacentral.md#mapping-between-third-party-identifiers-and-rnacentral-ids) for more on identifier mapping. ### Directory structure ```text RNAcentral | +- current_release | | | +- release_notes.txt | | | +- database_files | | | | | +- toc.dat and one gzip compressed file per table | | | +- genome_coordinates | | | | | +- bed | | | | | | | +- one gzip compressed BED file per model organism | | | | | +- gff3 | | | | | | | +- one gzip compressed GFF3 file per model organism | | | | | +- readme.txt | | | +- go_annotations | | | | | +- rnacentral_rfam_annotations.tsv.gz | | | +- gpi | | | | | +- rnacentral.gpi(.gz) | | | | | +- rnacentral.species.gpi(.gz) | | | | | +- rnacentral.reference_proteome.gpi(.gz) | | | +- id_mapping | | | | | +- database_mappings | | | | | | | +- one uncompressed TSV file per expert database | | | | | +- id_mapping.tsv.gz | | | +- json | | | | | +- ensembl-xref-*.json | | | +- md5 | | | | | +- md5.tsv.gz | | | +- rfam | | | | | +- rfam_annotations.tsv.gz | | | +- sequences | | | +- by-database | | | | | +- one gzip compressed FASTA file per expert database | | | +- by-species | | | | | +- one folder per taxonomic group, one gzip compressed FASTA file per species | | | +- rnacentral_active.fasta.gz | | | +- rnacentral_inactive.fasta.gz | | | +- rnacentral_species_specific_ids.fasta.gz | +- releases | +- archive of releases back to 1.0-beta (2014) ```