Schema for wgEncodeGencodeGeneSymbolV47lift37

JavaScript is disabled in your web browser

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

Schema for wgEncodeGencodeGeneSymbolV47lift37

Database: hg19 Primary Table: wgEncodeGencodeGeneSymbolV47lift37 Row Count: 267,357 Data last updated: 2024-10-17
Format description: GENCODE transcript to official gene symbol. For human, this is the HUGO Gene Nomenclature Committee (HGNC) gene symbo. For mouse, this is the Mouse Genome Informatics (MGI) gene symbol.
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`transcriptId`	ENST00000450305.2_2	`varchar(255)`	values	GENCODE transcript identifier
`symbol`	DDX11L1	`varchar(255)`	values	HGNC/MGI gene symbol
`geneId`	HGNC:37102	`varchar(255)`	values	HGNC/MGI symbol id used by database

Connected Tables and Joining Fields


	hg19.wgEncodeGencodeAttrsV47lift37.transcriptId (via wgEncodeGencodeGeneSymbolV47lift37.transcriptId)

Sample Rows

transcriptId	symbol	geneId
ENST00000450305.2_2	DDX11L1	HGNC:37102
ENST00000831201.1_1	WASH7P	HGNC:38034
ENST00000831140.1_1	WASH7P	HGNC:38034
ENST00000831141.1_1	WASH7P	HGNC:38034
ENST00000831158.1_1	WASH7P	HGNC:38034
ENST00000831161.1_1	WASH7P	HGNC:38034
ENST00000831165.1_1	WASH7P	HGNC:38034
ENST00000831154.1_1	WASH7P	HGNC:38034
ENST00000831146.1_1	WASH7P	HGNC:38034
ENST00000831145.1_1	WASH7P	HGNC:38034

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