Schema for knownToMupit
  Database: hg38    Primary Table: knownToMupit    Row Count: 63,895   Data last updated: 2022-05-15
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name ENST00000000233.10varchar(255) values primary ID
value 2B6Hvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000000233.102B6H
ENST00000001008.61N1A
ENST00000001008.61P5Q
ENST00000001008.61Q1C
ENST00000001008.61QZ2
ENST00000002596.61ZRH
ENST00000003084.112PZE
ENST00000003084.112PZF
ENST00000003084.112PZG
ENST00000003084.113GD7

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