Schema for wgEncodeGencodeGeneSymbolVM29
  Database: mm39    Primary Table: wgEncodeGencodeGeneSymbolVM29    Row Count: 140,088   Data last updated: 2022-04-28
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
fieldexampleSQL type info description
transcriptId ENSMUST00000193198.2varchar(255) values GENCODE transcript identifier
symbol Gm37671varchar(255) values HGNC/MGI gene symbol
geneId MGI:5610899varchar(255) values HGNC/MGI symbol id used by database

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM29.transcriptId (via wgEncodeGencodeGeneSymbolVM29.transcriptId)

Sample Rows
 
transcriptIdsymbolgeneId
ENSMUST00000193198.2Gm37671MGI:5610899
ENSMUST00000191430.2Gm19087MGI:5011272
ENSMUST00000181451.2Gm8941MGI:3779824
ENSMUST00000194081.2Gm38212MGI:5611440
ENSMUST00000194393.2Gm7449MGI:3647895
ENSMUST00000132100.2Gm15178MGI:3705132
ENSMUST00000185509.2Gm28283MGI:5578989
ENSMUST00000194605.2Gm37108MGI:5610336
ENSMUST00000191703.2Gm37275MGI:5610503
ENSMUST00000191467.2Gm6679MGI:3648541

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