taxonomies
Identifier
Section titled “Identifier”Description
Section titled “Description”Species and genome assemblies covered by the Ensembl annotation in this catalogue.
Small unpartitioned lookup table.
One row per species/release.
Use taxonomy_id (NCBI taxonomy ID) as the partition key for every other ensembl table (e.g. 9606 for human).
Related tables: ensembl.genes (join on taxonomy_id).
Partitions
Section titled “Partitions”release'116'
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
release |
TEXT |
Partition column. Ensembl release number the annotation was drawn from. |
taxonomy_id |
INT |
NCBI taxonomy ID for the species (e.g. 9606 for human). |
scientific_name |
TEXT |
Binomial scientific name (e.g. Homo sapiens). |
common_name |
TEXT |
Common name of the species (e.g. human). May be null. |
assembly |
TEXT |
Reference genome assembly name (e.g. GRCh38). |