Schema for knownToU95
  Database: hg18    Primary Table: knownToU95    Row Count: 30,329   Data last updated: 2009-03-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 uc004fou.1varchar(255) values primary ID
value 35073_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc004fou.135073_at
uc004fov.135073_at
uc004fpa.133665_s_at
uc004fpb.133665_s_at
uc004fpc.133665_s_at
uc004fpd.133665_s_at
uc010nvt.133665_s_at
uc010nvu.133665_s_at
uc004fpe.133665_s_at
uc010nvv.133665_s_at

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