utrs

Identifier

ensembl.utrs

Description

Untranslated region (UTR) annotation — 5’ and 3’ UTR segments of coding transcripts.

One row per UTR segment.

Always filter on taxonomy_id (partition column). end distinguishes the five_prime and three_prime UTR.

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 UTR belongs to.
transcript_id	TEXT	Ensembl transcript ID this UTR belongs to.
end	TEXT	Which UTR this is — five_prime or three_prime.
chromosome	TEXT	Chromosome (or scaffold) the UTR is located on.
start_position	INT	1-based start coordinate of the UTR segment.
end_position	INT	1-based end coordinate of the UTR segment.
strand	TEXT	Strand the UTR is on — forward or reverse.
source	TEXT	Annotation source (e.g. ensembl, havana, ensembl_havana).