Schema for knownToAllenBrain
  Database: hg18    Primary Table: knownToAllenBrain    Row Count: 28,640   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 uc004fon.1varchar(255) values primary ID
value RP_050321_04_G12varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc004fon.1RP_050321_04_G12
uc004foo.1RP_050321_04_G12
uc004fre.1RP_050317_04_F02
uc004fsu.1RP_NM_012008
uc010nwv.1RP_NM_012008
uc004fsv.2RP_NM_012008
uc010nww.1RP_NM_012008
uc010nxp.1RP_050531_04_E10
uc004fxi.1RP_050531_04_E10
uc010nxq.1RP_050531_04_E10

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