Schema for wgEncodeGencodeGeneSourceV27
  Database: hg38    Primary Table: wgEncodeGencodeGeneSourceV27    Row Count: 63,925   Data last updated: 2017-09-15
Format description: The source of Gencode gene annotation
fieldexampleSQL type info description
geneId ENSG00000223972.5varchar(255) values GENCODE gene identifier
source havanavarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV27.geneId (via wgEncodeGencodeGeneSourceV27.geneId)

Sample Rows
 
geneIdsource
ENSG00000223972.5havana
ENSG00000227232.5havana
ENSG00000278267.1ncrna
ENSG00000243485.5havana
ENSG00000284332.1ncrna
ENSG00000237613.2havana
ENSG00000268020.3havana
ENSG00000240361.2havana
ENSG00000186092.5ensembl_havana_gene
ENSG00000238009.6ensembl_havana_lincrna

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