Schema for wgEncodeGencodeGeneSourceV24lift37

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for wgEncodeGencodeGeneSourceV24lift37

Database: hg19 Primary Table: wgEncodeGencodeGeneSourceV24lift37 Row Count: 60,308 Data last updated: 2016-03-02
Format description: The source of Gencode gene annotation
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`geneId`	ENSG00000223972.5	`varchar(255)`	values	GENCODE gene identifier
`source`	havana	`varchar(255)`	values	Source of gene

Connected Tables and Joining Fields


	hg19.wgEncodeGencodeAttrsV24lift37.geneId (via wgEncodeGencodeGeneSourceV24lift37.geneId)

Sample Rows

geneId	source
ENSG00000223972.5	havana
ENSG00000227232.5	havana
ENSG00000243485.3	havana
ENSG00000237613.2	havana
ENSG00000268020.3	havana
ENSG00000240361.1	havana
ENSG00000186092.4	ensembl_havana_gene
ENSG00000238009.6	ensembl_havana_lincrna
ENSG00000239945.1	havana
ENSG00000233750.3	havana

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