Schema for knownToU133Plus2
  Database: hg19    Primary Table: knownToU133Plus2    Row Count: 65,043   Data last updated: 2013-06-14
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 uc031tga.1varchar(255) values primary ID
value 1553538_s_atvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc031tga.11553538_s_at
uc011mfi.21553567_s_at
uc022bqu.21553588_at
uc004cox.41555653_at
uc011mgv.2215160_x_at
uc011mgu.11555369_at
uc002qvo.3222406_s_at
uc021vde.1206095_s_at
uc021vdf.1206095_s_at
uc021vdg.1206095_s_at

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