genes

Identifier

ensembl.genes

Description

Gene-level annotation (one row per Ensembl gene).

One row per gene.

Always filter on taxonomy_id (partition column).

Join to transcripts, exons, cds, etc. on gene_id.

Look up gene_id by symbol to translate a gene name to an Ensembl ID.

Related tables: ensembl.transcripts (join on gene_id); ensembl.mappings (join on gene_id); eqtlgen.genes (join on gene_id); open_targets.targets (join on gene_id); ukb_ppp.genes (join on gene_id, symbol).

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 (e.g. ENSG00000123456).
gene_version	INT	Version suffix of the gene ID. May be null.
symbol	TEXT	Gene symbol (e.g. HGNC symbol for human). May be null.
chromosome	TEXT	Chromosome (or scaffold) the gene is located on.
start_position	INT	1-based start coordinate of the gene on the assembly.
end_position	INT	1-based end coordinate of the gene on the assembly.
strand	TEXT	Strand the gene is on — forward or reverse.
source	TEXT	Annotation source (e.g. ensembl, havana, ensembl_havana).
biotype	TEXT	Gene biotype (e.g. protein_coding, lncRNA, pseudogene).