codons

Identifier

ensembl.codons

Description

Start and stop codon annotation for coding transcripts.

One row per (transcript, codon_type, exon).

Always filter on taxonomy_id (partition column). codon_type is start or stop.

Join to transcripts on transcript_id.

Related tables: ensembl.transcripts (join on transcript_id).

Partitions

• release
  • '116'
• taxonomy_id
  • '10090'
  • '10116'
  • '7955'
  • '9541'
  • '9544'
  • '9606'
  • '9615'
  • '9823'
  • '9986'

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 codon belongs to.
transcript_id	TEXT	Ensembl transcript ID this codon belongs to.
exon_number	INT	Exon ordinal the codon falls in.
codon_type	TEXT	Codon type — start or stop.
chromosome	TEXT	Chromosome (or scaffold) the codon is located on.
start_position	INT	1-based start coordinate of the codon.
end_position	INT	1-based end coordinate of the codon.
strand	TEXT	Strand the codon is on — forward or reverse.
source	TEXT	Annotation source (e.g. ensembl, havana, ensembl_havana).