Schema for wgEncodeGencodeGeneSourceV45lift37
  Database: hg19    Primary Table: wgEncodeGencodeGeneSourceV45lift37    Row Count: 64,956   Data last updated: 2024-01-11
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000290825.1_1varchar(255) values GENCODE gene identifier
source havana_homo_sapiensvarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV45lift37.geneId (via wgEncodeGencodeGeneSourceV45lift37.geneId)

Sample Rows
 
geneIdsource
ENSG00000290825.1_1havana_homo_sapiens
ENSG00000223972.6_6havana_homo_sapiens
ENSG00000227232.6_6havana_homo_sapiens
ENSG00000243485.5_12havana_homo_sapiens
ENSG00000237613.2_6havana_homo_sapiens
ENSG00000268020.3_5havana_homo_sapiens
ENSG00000290826.1_1havana_homo_sapiens
ENSG00000240361.3_7havana_homo_sapiens
ENSG00000186092.7_9ensembl_havana_gene_homo_sapiens
ENSG00000238009.7_15ensembl_havana_lincrna_homo_sapiens

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