cds
Identifier
Section titled “Identifier”Description
Section titled “Description”Coding sequence (CDS) annotation — translated exon segments and their Ensembl protein IDs.
One row per (transcript, CDS segment).
Always filter on taxonomy_id (partition column). protein_id is the Ensembl protein the CDS translates to.
Join to transcripts on transcript_id.
Related tables: ensembl.transcripts (join on transcript_id); ensembl.mappings (join on protein_id).
Partitions
Section titled “Partitions”release'116'
taxonomy_id'10090''10116''7955''9541''9544''9606''9615''9823''9986'
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
release |
TEXT |
Partition column. Ensembl release number the annotation was drawn from. |
taxonomy_id |
INT |
Partition column. NCBI taxonomy ID for the species (partition column). |
gene_id |
TEXT |
Ensembl gene ID this CDS belongs to. |
transcript_id |
TEXT |
Ensembl transcript ID this CDS belongs to. |
exon_number |
INT |
Exon ordinal the CDS segment falls in. |
chromosome |
TEXT |
Chromosome (or scaffold) the CDS is located on. |
start_position |
INT |
1-based start coordinate of the CDS segment. |
end_position |
INT |
1-based end coordinate of the CDS segment. |
strand |
TEXT |
Strand the CDS is on — forward or reverse. |
source |
TEXT |
Annotation source (e.g. ensembl, havana, ensembl_havana). |
protein_id |
TEXT |
Ensembl protein ID the CDS translates to (e.g. ENSP00000123456). |
protein_version |
INT |
Version suffix of the protein ID. May be null. |