Schema for wgEncodeGencodeGeneSourceV23
  Database: hg38    Primary Table: wgEncodeGencodeGeneSourceV23    Row Count: 66,023   Data last updated: 2015-10-02
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId ENSG00000000003.14varchar(255) values GENCODE gene identifier
source ensembl_havana_genevarchar(255) values Source of gene

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV23.geneId (via wgEncodeGencodeGeneSourceV23.geneId)

Sample Rows
 
geneIdsource
ENSG00000000003.14ensembl_havana_gene
ENSG00000000005.5ensembl_havana_gene
ENSG00000000419.12ensembl_havana_gene
ENSG00000000457.13ensembl_havana_gene
ENSG00000000460.16ensembl_havana_gene
ENSG00000000938.12ensembl_havana_gene
ENSG00000000971.15ensembl_havana_gene
ENSG00000001036.13ensembl_havana_gene
ENSG00000001084.10ensembl_havana_gene
ENSG00000001167.14ensembl_havana_gene

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