Schema for wgEncodeGencodeGeneSourceV47lift37
  Database: hg19    Primary Table: wgEncodeGencodeGeneSourceV47lift37    Row Count: 80,304   Data last updated: 2024-10-17
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000308415.1_1varchar(255) values GENCODE gene identifier
source havana_tagene_homo_sapiensvarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV47lift37.geneId (via wgEncodeGencodeGeneSourceV47lift37.geneId)

Sample Rows
 
geneIdsource
ENSG00000308415.1_1havana_tagene_homo_sapiens
ENSG00000290825.2_2havana_homo_sapiens
ENSG00000223972.6_6havana_homo_sapiens
ENSG00000310526.1_1havana_homo_sapiens
ENSG00000227232.6_7havana_homo_sapiens
ENSG00000243485.6_13havana_homo_sapiens
ENSG00000237613.3_7havana_homo_sapiens
ENSG00000308361.1_1havana_tagene_homo_sapiens
ENSG00000290826.2_2havana_homo_sapiens
ENSG00000268020.3_6havana_homo_sapiens

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