Schema for wgEncodeGencodeGeneSourceV27lift37
  Database: hg19    Primary Table: wgEncodeGencodeGeneSourceV27lift37    Row Count: 60,461   Data last updated: 2017-09-14
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000223972.5_2varchar(255) values GENCODE gene identifier
source havanavarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV27lift37.geneId (via wgEncodeGencodeGeneSourceV27lift37.geneId)

Sample Rows
 
geneIdsource
ENSG00000223972.5_2havana
ENSG00000227232.5_2havana
ENSG00000243485.5_3havana
ENSG00000237613.2_2havana
ENSG00000268020.3_3havana
ENSG00000240361.2_3havana
ENSG00000186092.5_3ensembl_havana_gene
ENSG00000238009.6_4ensembl_havana_lincrna
ENSG00000239945.1_4havana
ENSG00000233750.3_2havana

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