Schema for knownToU95
  Database: hg38    Primary Table: knownToU95    Row Count: 99,797   Data last updated: 2024-08-19
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 ENST00000625471.3varchar(255) values primary ID
value 36774_f_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000625471.336774_f_at
ENST00000620127.436774_f_at
ENST00000628976.336774_f_at
ENST00000753504.140406_at
ENST00000753505.140406_at
ENST00000612198.337216_at
ENST00000631948.137216_at
ENST00000622719.237216_at
ENST00000634172.137216_at
ENST00000631689.137216_at

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