Schema for wgEncodeGencodeGeneSymbolVM27
  Database: mm39    Primary Table: wgEncodeGencodeGeneSymbolVM27    Row Count: 139,235   Data last updated: 2021-06-29
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 ENSMUST00000193812.2varchar(255) values GENCODE transcript identifier
symbol 4933401J01Rikvarchar(255) values HGNC/MGI gene symbol
geneId MGI:1918292varchar(255) values HGNC/MGI symbol id used by database

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM27.transcriptId (via wgEncodeGencodeGeneSymbolVM27.transcriptId)

Sample Rows
 
transcriptIdsymbolgeneId
ENSMUST00000193812.24933401J01RikMGI:1918292
ENSMUST00000082908.3Gm26206MGI:5455983
ENSMUST00000162897.2Xkr4MGI:3528744
ENSMUST00000159265.2Xkr4MGI:3528744
ENSMUST00000070533.5Xkr4MGI:3528744
ENSMUST00000192857.2Gm18956MGI:5011141
ENSMUST00000195335.2Gm37180MGI:5610408
ENSMUST00000192336.2Gm37363MGI:5610591
ENSMUST00000194099.2Gm37686MGI:5610914
ENSMUST00000161581.2Gm1992MGI:3780162

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