Schema for wgEncodeGencodeGeneSourceV34
  Database: hg38    Primary Table: wgEncodeGencodeGeneSourceV34    Row Count: 67,071   Data last updated: 2020-04-29
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000223972.5varchar(255) values GENCODE gene identifier
source havana_homo_sapiensvarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV34.geneId (via wgEncodeGencodeGeneSourceV34.geneId)

Sample Rows
 
geneIdsource
ENSG00000223972.5havana_homo_sapiens
ENSG00000227232.5havana_homo_sapiens
ENSG00000278267.1ncrna_homo_sapiens
ENSG00000243485.5havana_homo_sapiens
ENSG00000284332.1ncrna_homo_sapiens
ENSG00000237613.2havana_homo_sapiens
ENSG00000268020.3havana_homo_sapiens
ENSG00000240361.2havana_homo_sapiens
ENSG00000186092.6ensembl_havana_gene_homo_sapiens
ENSG00000238009.6ensembl_havana_lincrna_homo_sapiens

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