Schema for wgEncodeGencodeGeneSymbolVM37

Database: mm39 Primary Table: wgEncodeGencodeGeneSymbolVM37 Row Count: 215,915 Data last updated: 2025-05-31
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`	ENSMUST00000194081.2	`varchar(255)`	values	GENCODE transcript identifier
`symbol`	Gm38212	`varchar(255)`	values	HGNC/MGI gene symbol
`geneId`	MGI:5611440	`varchar(255)`	values	HGNC/MGI symbol id used by database

Connected Tables and Joining Fields


	mm39.wgEncodeGencodeAttrsVM37.transcriptId (via wgEncodeGencodeGeneSymbolVM37.transcriptId)

Sample Rows

transcriptId	symbol	geneId
ENSMUST00000194081.2	Gm38212	MGI:5611440
ENSMUST00000194393.2	Gm7449	MGI:3647895
ENSMUST00000185509.2	Gm28283	MGI:5578989
ENSMUST00000191467.2	Gm6679	MGI:3648541
ENSMUST00000186289.2	Gm29155	MGI:5579861
ENSMUST00000185910.2	Gm29155	MGI:5579861
ENSMUST00000188261.2	Gm17847	MGI:5010032
ENSMUST00000185658.2	Gm28281	MGI:5578987
ENSMUST00000188753.2	Gm29157	MGI:5579863
ENSMUST00000187764.2	Gm29156	MGI:5579862

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