Skip to main content
Schema for wgEncodeGencodeGeneSourceV49lift37
  Database: hg19    Primary Table: wgEncodeGencodeGeneSourceV49lift37    Row Count: 80,275   Data last updated: 2025-09-09
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000308415.1_2varchar(255) values GENCODE gene identifier
source havana_tagene_homo_sapiensvarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV49lift37.geneId (via wgEncodeGencodeGeneSourceV49lift37.geneId)

Sample Rows
 
geneIdsource
ENSG00000308415.1_2havana_tagene_homo_sapiens
ENSG00000290825.2_3havana_homo_sapiens
ENSG00000223972.6_7havana_homo_sapiens
ENSG00000310526.1_2havana_homo_sapiens
ENSG00000227232.6_8havana_homo_sapiens
ENSG00000243485.6_14havana_homo_sapiens
ENSG00000237613.3_8havana_homo_sapiens
ENSG00000308361.1_2havana_tagene_homo_sapiens
ENSG00000290826.2_3havana_homo_sapiens
ENSG00000268020.3_7havana_homo_sapiens

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.