Skip to main content
Schema for knownToMupit
  Database: hg19    Primary Table: knownToMupit    Row Count: 61,662   Data last updated: 2025-09-29
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 ENST00000000233.10_4varchar(255) values primary ID
value 2B6Hvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToMupit.name)
      hg19.ceBlastTab.query (via knownToMupit.name)
      hg19.dmBlastTab.query (via knownToMupit.name)
      hg19.drBlastTab.query (via knownToMupit.name)
      hg19.foldUtr3.name (via knownToMupit.name)
      hg19.foldUtr5.name (via knownToMupit.name)
      hg19.gnfAtlas2Distance.query (via knownToMupit.name)
      hg19.gnfAtlas2Distance.target (via knownToMupit.name)
      hg19.gnfU95Distance.query (via knownToMupit.name)
      hg19.gnfU95Distance.target (via knownToMupit.name)
      hg19.humanHprdP2P.query (via knownToMupit.name)
      hg19.humanHprdP2P.target (via knownToMupit.name)
      hg19.humanVidalP2P.query (via knownToMupit.name)
      hg19.humanVidalP2P.target (via knownToMupit.name)
      hg19.humanWankerP2P.query (via knownToMupit.name)
      hg19.humanWankerP2P.target (via knownToMupit.name)
      hg19.keggPathway.kgID (via knownToMupit.name)
      hg19.kgAlias.kgID (via knownToMupit.name)
      hg19.kgColor.kgID (via knownToMupit.name)
      hg19.kgProtAlias.kgID (via knownToMupit.name)
      hg19.kgProtMap2.qName (via knownToMupit.name)
      hg19.kgSpAlias.kgID (via knownToMupit.name)
      hg19.kgTargetAli.qName (via knownToMupit.name)
      hg19.kgTxInfo.name (via knownToMupit.name)
      hg19.kgXref.kgID (via knownToMupit.name)
      hg19.knownAttrs.kgID (via knownToMupit.name)
      hg19.knownBlastTab.query (via knownToMupit.name)
      hg19.knownBlastTab.target (via knownToMupit.name)
      hg19.knownCanonical.transcript (via knownToMupit.name)
      hg19.knownCds.name (via knownToMupit.name)
      hg19.knownGene.name (via knownToMupit.name)
      hg19.knownGeneMrna.name (via knownToMupit.name)
      hg19.knownGenePep.name (via knownToMupit.name)
      hg19.knownGeneTxMrna.name (via knownToMupit.name)
      hg19.knownGeneTxPep.name (via knownToMupit.name)
      hg19.knownIsoforms.transcript (via knownToMupit.name)
      hg19.knownToAllenBrain.name (via knownToMupit.name)
      hg19.knownToEnsembl.name (via knownToMupit.name)
      hg19.knownToGnfAtlas2.name (via knownToMupit.name)
      hg19.knownToHInv.name (via knownToMupit.name)
      hg19.knownToHprd.name (via knownToMupit.name)
      hg19.knownToKeggEntrez.name (via knownToMupit.name)
      hg19.knownToLocusLink.name (via knownToMupit.name)
      hg19.knownToLynx.name (via knownToMupit.name)
      hg19.knownToMrna.name (via knownToMupit.name)
      hg19.knownToMrnaSingle.name (via knownToMupit.name)
      hg19.knownToNextProt.name (via knownToMupit.name)
      hg19.knownToPfam.name (via knownToMupit.name)
      hg19.knownToRefSeq.name (via knownToMupit.name)
      hg19.knownToSuper.gene (via knownToMupit.name)
      hg19.knownToTag.name (via knownToMupit.name)
      hg19.knownToTreefam.name (via knownToMupit.name)
      hg19.knownToU133.name (via knownToMupit.name)
      hg19.knownToU133Plus2.name (via knownToMupit.name)
      hg19.knownToU95.name (via knownToMupit.name)
      hg19.knownToVisiGene.name (via knownToMupit.name)
      hg19.knownToWikipedia.name (via knownToMupit.name)
      hg19.mmBlastTab.query (via knownToMupit.name)
      hg19.rnBlastTab.query (via knownToMupit.name)
      hg19.scBlastTab.query (via knownToMupit.name)
      hg19.ucscScop.ucscId (via knownToMupit.name)
      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)

Sample Rows
 
namevalue
ENST00000000233.10_42B6H
ENST00000001008.6_51N1A
ENST00000001008.6_51P5Q
ENST00000001008.6_51Q1C
ENST00000001008.6_51QZ2
ENST00000002596.6_71ZRH
ENST00000003084.11_62PZE
ENST00000003084.11_62PZF
ENST00000003084.11_62PZG
ENST00000003084.11_63GD7

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