genes

Identifier

ukb_ppp.genes

Description

Gene annotations with genomic coordinates (GRCh38).

One row per gene assayed in UKB-PPP.

Use to look up gene locations by symbol or Ensembl ID.

Query by gene_symbol to find genomic coordinates.

This table has coordinates only, not protein IDs.

To find pQTL data for a gene, first map the gene to a protein_id via the assays table, then query pqtls.

Related tables: ukb_ppp.assays (join on gene_symbol); open_targets.targets (join on gene_id); eqtlgen.genes (join on gene_id, gene_symbol).

Partitions

• chromosome
  • '1'
  • '10'
  • '11'
  • '12'
  • '13'
  • '14'
  • '15'
  • '16'
  • '17'
  • '18'
  • '19'
  • '2'
  • '20'
  • '21'
  • '22'
  • '3'
  • '4'
  • '5'
  • '6'
  • '7'
  • '8'
  • '9'
  • 'X'

Schema

Column	Type	Description
gene_id	TEXT	Ensembl gene identifier (e.g. ENSG00000112164).
gene_symbol	TEXT	HGNC gene symbol (e.g. GLP1R, APOE).
chromosome	TEXT	Partition column. Chromosome on which the gene is located.
start_position	INT	Gene start position in assembly GRCh38 coordinates.
end_position	INT	Gene end position in assembly GRCh38 coordinates.
strand	TEXT	Strand of the gene.