Schema for wgEncodeGencodeGeneSymbolVM34
  Database: mm39    Primary Table: wgEncodeGencodeGeneSymbolVM34    Row Count: 147,515   Data last updated: 2024-01-11
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 ENSMUST00000194081.2varchar(255) values GENCODE transcript identifier
symbol Gm38212varchar(255) values HGNC/MGI gene symbol
geneId MGI:5611440varchar(255) values HGNC/MGI symbol id used by database

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM34.transcriptId (via wgEncodeGencodeGeneSymbolVM34.transcriptId)

Sample Rows
 
transcriptIdsymbolgeneId
ENSMUST00000194081.2Gm38212MGI:5611440
ENSMUST00000194393.2Gm7449MGI:3647895
ENSMUST00000185509.2Gm28283MGI:5578989
ENSMUST00000194605.2Gm37108MGI:5610336
ENSMUST00000191703.2Gm37275MGI:5610503
ENSMUST00000191467.2Gm6679MGI:3648541
ENSMUST00000186289.2Gm29155MGI:5579861
ENSMUST00000185910.2Gm29155MGI:5579861
ENSMUST00000193423.2Gm37225MGI:5610453
ENSMUST00000188261.2Gm17847MGI:5010032

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