Schema for knownToMupit
  Database: mm39    Primary Table: knownToMupit    Row Count: 334   Data last updated: 2024-08-15
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000000001.5varchar(255) values primary ID
value 3AB3varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToMupit.name)
      knownGeneV39.ceBlastTab.query (via knownToMupit.name)
      knownGeneV39.dmBlastTab.query (via knownToMupit.name)
      knownGeneV39.drBlastTab.query (via knownToMupit.name)
      knownGeneV39.foldUtr3.name (via knownToMupit.name)
      knownGeneV39.foldUtr5.name (via knownToMupit.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToMupit.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToMupit.name)
      knownGeneV39.kgAlias.kgID (via knownToMupit.name)
      knownGeneV39.kgColor.kgID (via knownToMupit.name)
      knownGeneV39.kgProtAlias.kgID (via knownToMupit.name)
      knownGeneV39.kgSpAlias.kgID (via knownToMupit.name)
      knownGeneV39.kgTargetAli.qName (via knownToMupit.name)
      knownGeneV39.kgXref.kgID (via knownToMupit.name)
      knownGeneV39.knownAttrs.kgID (via knownToMupit.name)
      knownGeneV39.knownBlastTab.query (via knownToMupit.name)
      knownGeneV39.knownBlastTab.target (via knownToMupit.name)
      knownGeneV39.knownCanonical.protein (via knownToMupit.name)
      knownGeneV39.knownCanonical.transcript (via knownToMupit.name)
      knownGeneV39.knownCds.name (via knownToMupit.name)
      knownGeneV39.knownGene.name (via knownToMupit.name)
      knownGeneV39.knownGeneMrna.name (via knownToMupit.name)
      knownGeneV39.knownGenePep.name (via knownToMupit.name)
      knownGeneV39.knownIsoforms.transcript (via knownToMupit.name)
      knownGeneV39.knownToEnsembl.name (via knownToMupit.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToMupit.name)
      knownGeneV39.knownToHprd.name (via knownToMupit.name)
      knownGeneV39.knownToLocusLink.name (via knownToMupit.name)
      knownGeneV39.knownToMrna.name (via knownToMupit.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToMupit.name)
      knownGeneV39.knownToMupit.name (via knownToMupit.name)
      knownGeneV39.knownToPfam.name (via knownToMupit.name)
      knownGeneV39.knownToRefSeq.name (via knownToMupit.name)
      knownGeneV39.knownToSuper.gene (via knownToMupit.name)
      knownGeneV39.knownToTag.name (via knownToMupit.name)
      knownGeneV39.knownToU133.name (via knownToMupit.name)
      knownGeneV39.knownToU95.name (via knownToMupit.name)
      knownGeneV39.knownToVisiGene.name (via knownToMupit.name)
      knownGeneV39.knownToWikipedia.name (via knownToMupit.name)
      knownGeneV39.mmBlastTab.query (via knownToMupit.name)
      knownGeneV39.rnBlastTab.query (via knownToMupit.name)
      knownGeneV39.scBlastTab.query (via knownToMupit.name)
      knownGeneV39.ucscScop.ucscId (via knownToMupit.name)
      mm39.bioCycPathway.kgID (via knownToMupit.name)
      mm39.ceBlastTab.query (via knownToMupit.name)
      mm39.dmBlastTab.query (via knownToMupit.name)
      mm39.drBlastTab.query (via knownToMupit.name)
      mm39.foldUtr3.name (via knownToMupit.name)
      mm39.foldUtr5.name (via knownToMupit.name)
      mm39.hgBlastTab.query (via knownToMupit.name)
      mm39.kgAlias.kgID (via knownToMupit.name)
      mm39.kgColor.kgID (via knownToMupit.name)
      mm39.kgProtAlias.kgID (via knownToMupit.name)
      mm39.kgSpAlias.kgID (via knownToMupit.name)
      mm39.kgTargetAli.qName (via knownToMupit.name)
      mm39.kgXref.kgID (via knownToMupit.name)
      mm39.knownAttrs.kgID (via knownToMupit.name)
      mm39.knownBlastTab.query (via knownToMupit.name)
      mm39.knownBlastTab.target (via knownToMupit.name)
      mm39.knownCanonical.transcript (via knownToMupit.name)
      mm39.knownCds.name (via knownToMupit.name)
      mm39.knownGene.name (via knownToMupit.name)
      mm39.knownGeneMrna.name (via knownToMupit.name)
      mm39.knownIsoforms.transcript (via knownToMupit.name)
      mm39.knownToEnsembl.name (via knownToMupit.name)
      mm39.knownToLocusLink.name (via knownToMupit.name)
      mm39.knownToMrna.name (via knownToMupit.name)
      mm39.knownToMrnaSingle.name (via knownToMupit.name)
      mm39.knownToNextProt.name (via knownToMupit.name)
      mm39.knownToPfam.name (via knownToMupit.name)
      mm39.knownToRefSeq.name (via knownToMupit.name)
      mm39.knownToSuper.gene (via knownToMupit.name)
      mm39.knownToTag.name (via knownToMupit.name)
      mm39.knownToVisiGene.name (via knownToMupit.name)
      mm39.knownToWikipedia.name (via knownToMupit.name)
      mm39.rnBlastTab.query (via knownToMupit.name)
      mm39.scBlastTab.query (via knownToMupit.name)
      mm39.ucscScop.ucscId (via knownToMupit.name)

Sample Rows
 
namevalue
ENSMUST00000000001.53AB3
ENSMUST00000001479.51UKL
ENSMUST00000002177.92ACL
ENSMUST00000002177.93FAL
ENSMUST00000002708.52WFX
ENSMUST00000002708.52WG4
ENSMUST00000002708.53D1M
ENSMUST00000003038.122JKR
ENSMUST00000003038.122JKT
ENSMUST00000005606.84DIN

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