Schema for wgEncodeGencodeGeneSourceV47
  Database: hg38    Primary Table: wgEncodeGencodeGeneSourceV47    Row Count: 86,402   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 ENSG00000142611.17varchar(255) values GENCODE gene identifier
source ensembl_havana_gene_homo_sa...varchar(255) values Source of gene

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV47.geneId (via wgEncodeGencodeGeneSourceV47.geneId)

Sample Rows
 
geneIdsource
ENSG00000142611.17ensembl_havana_gene_homo_sapiens
ENSG00000284616.1havana_homo_sapiens
ENSG00000157911.11ensembl_havana_gene_homo_sapiens
ENSG00000260972.1havana_homo_sapiens
ENSG00000224340.1havana_homo_sapiens
ENSG00000229280.1havana_homo_sapiens
ENSG00000142655.13ensembl_havana_gene_homo_sapiens
ENSG00000232596.3havana_homo_sapiens
ENSG00000231510.1havana_homo_sapiens
ENSG00000149527.18ensembl_havana_gene_homo_sapiens

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