Schema for knownToU95
  Database: hg19    Primary Table: knownToU95    Row Count: 92,144   Data last updated: 2024-08-23
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 ENST00000356275.10_1varchar(255) values primary ID
value 37534_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000356275.10_137534_at
ENST00000400165.5_137534_at
ENST00000400166.5_237534_at
ENST00000284878.12_837534_at
ENST00000400169.1_337534_at
ENST00000486367.1_138557_at
ENST00000461281.1_138557_at
ENST00000484983.1_138557_at
ENST00000284894.8_338557_at
ENST00000400546.6_538557_at

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