exons

Identifier

ensembl.exons

Description

Exon annotation (one row per exon within a transcript).

One row per (transcript, exon).

Always filter on taxonomy_id (partition column).

Join to transcripts on transcript_id; exon_number gives the exon order within the transcript (5’→3’).

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 exon belongs to.
transcript_id	TEXT	Ensembl transcript ID this exon belongs to.
exon_id	TEXT	Ensembl exon ID (e.g. ENSE00000123456).
exon_version	INT	Version suffix of the exon ID. May be null.
exon_number	INT	Ordinal position of the exon within the transcript (5’→3’).
chromosome	TEXT	Chromosome (or scaffold) the exon is located on.
start_position	INT	1-based start coordinate of the exon.
end_position	INT	1-based end coordinate of the exon.
strand	TEXT	Strand the exon is on — forward or reverse.
source	TEXT	Annotation source (e.g. ensembl, havana, ensembl_havana).