Schema for knownToU95
  Database: hg17    Primary Table: knownToU95    Row Count: 17,555   Data last updated: 2005-06-04
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 NM_000451varchar(255) values primary ID
value 35073_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToU95.name)
      hg17.ccdsKgMap.geneId (via knownToU95.name)
      hg17.ceBlastTab.query (via knownToU95.name)
      hg17.dmBlastTab.query (via knownToU95.name)
      hg17.drBlastTab.query (via knownToU95.name)
      hg17.dupSpMrna.mrnaID (via knownToU95.name)
      hg17.foldUtr3.name (via knownToU95.name)
      hg17.foldUtr5.name (via knownToU95.name)
      hg17.gladHumESDistance.query (via knownToU95.name)
      hg17.gladHumESDistance.target (via knownToU95.name)
      hg17.gnfAtlas2Distance.query (via knownToU95.name)
      hg17.gnfAtlas2Distance.target (via knownToU95.name)
      hg17.gnfU95Distance.query (via knownToU95.name)
      hg17.gnfU95Distance.target (via knownToU95.name)
      hg17.humanHprdP2P.query (via knownToU95.name)
      hg17.humanHprdP2P.target (via knownToU95.name)
      hg17.humanVidalP2P.query (via knownToU95.name)
      hg17.humanVidalP2P.target (via knownToU95.name)
      hg17.humanWankerP2P.query (via knownToU95.name)
      hg17.humanWankerP2P.target (via knownToU95.name)
      hg17.keggPathway.kgID (via knownToU95.name)
      hg17.kgAlias.kgID (via knownToU95.name)
      hg17.kgProtAlias.kgID (via knownToU95.name)
      hg17.kgSpAlias.kgID (via knownToU95.name)
      hg17.kgTargetAli.qName (via knownToU95.name)
      hg17.kgXref.kgID (via knownToU95.name)
      hg17.knownBlastTab.query (via knownToU95.name)
      hg17.knownBlastTab.target (via knownToU95.name)
      hg17.knownCanonical.transcript (via knownToU95.name)
      hg17.knownExpDistance.query (via knownToU95.name)
      hg17.knownExpDistance.target (via knownToU95.name)
      hg17.knownGene.name (via knownToU95.name)
      hg17.knownGeneLink.name (via knownToU95.name)
      hg17.knownGeneMrna.name (via knownToU95.name)
      hg17.knownGenePep.name (via knownToU95.name)
      hg17.knownIsoforms.transcript (via knownToU95.name)
      hg17.knownToAllenBrain.name (via knownToU95.name)
      hg17.knownToEnsembl.name (via knownToU95.name)
      hg17.knownToGnf1h.name (via knownToU95.name)
      hg17.knownToGnfAtlas2.name (via knownToU95.name)
      hg17.knownToHInv.name (via knownToU95.name)
      hg17.knownToHprd.name (via knownToU95.name)
      hg17.knownToKeggEntrez.name (via knownToU95.name)
      hg17.knownToLocusLink.name (via knownToU95.name)
      hg17.knownToPfam.name (via knownToU95.name)
      hg17.knownToRefSeq.name (via knownToU95.name)
      hg17.knownToSuper.gene (via knownToU95.name)
      hg17.knownToU133.name (via knownToU95.name)
      hg17.knownToU133Plus2.name (via knownToU95.name)
      hg17.knownToVisiGene.name (via knownToU95.name)
      hg17.mmBlastTab.query (via knownToU95.name)
      hg17.rankProp.query (via knownToU95.name)
      hg17.rankProp.target (via knownToU95.name)
      hg17.rnBlastTab.query (via knownToU95.name)
      hg17.scBlastTab.query (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)
      hg17.affyRatio.name (via knownToU95.value)
      hg17.affyU95.qName (via knownToU95.value)

Sample Rows
 
namevalue
NM_00045135073_at
NM_00688335073_at
NM_0021831185_at
NM_00508834215_at
L0342634215_at
BC02815134215_at
NM_00404335447_s_at
BC00162035447_s_at
NM_00241441138_at
CR61119941138_at

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