Schema for knownToAllenBrain
  Database: mm9    Primary Table: knownToAllenBrain    Row Count: 33,759   Data last updated: 2011-03-02
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 uc009vfo.1varchar(255) values primary ID
value RP_050317_01_C03varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        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)
      mm9.affyGnfU74ADistance.query (via knownToAllenBrain.name)
      mm9.affyGnfU74ADistance.target (via knownToAllenBrain.name)
      mm9.affyGnfU74BDistance.query (via knownToAllenBrain.name)
      mm9.affyGnfU74BDistance.target (via knownToAllenBrain.name)
      mm9.affyGnfU74CDistance.query (via knownToAllenBrain.name)
      mm9.affyGnfU74CDistance.target (via knownToAllenBrain.name)
      mm9.bioCycPathway.kgID (via knownToAllenBrain.name)
      mm9.ccdsKgMap.geneId (via knownToAllenBrain.name)
      mm9.ceBlastTab.query (via knownToAllenBrain.name)
      mm9.dmBlastTab.query (via knownToAllenBrain.name)
      mm9.drBlastTab.query (via knownToAllenBrain.name)
      mm9.foldUtr3.name (via knownToAllenBrain.name)
      mm9.foldUtr5.name (via knownToAllenBrain.name)
      mm9.gnfAtlas2Distance.query (via knownToAllenBrain.name)
      mm9.gnfAtlas2Distance.target (via knownToAllenBrain.name)
      mm9.hgBlastTab.query (via knownToAllenBrain.name)
      mm9.keggPathway.kgID (via knownToAllenBrain.name)
      mm9.kgAlias.kgID (via knownToAllenBrain.name)
      mm9.kgColor.kgID (via knownToAllenBrain.name)
      mm9.kgProtAlias.kgID (via knownToAllenBrain.name)
      mm9.kgProtMap2.qName (via knownToAllenBrain.name)
      mm9.kgSpAlias.kgID (via knownToAllenBrain.name)
      mm9.kgTargetAli.qName (via knownToAllenBrain.name)
      mm9.kgTxInfo.name (via knownToAllenBrain.name)
      mm9.kgXref.kgID (via knownToAllenBrain.name)
      mm9.knownBlastTab.query (via knownToAllenBrain.name)
      mm9.knownBlastTab.target (via knownToAllenBrain.name)
      mm9.knownCanonical.protein (via knownToAllenBrain.name)
      mm9.knownCanonical.transcript (via knownToAllenBrain.name)
      mm9.knownGene.name (via knownToAllenBrain.name)
      mm9.knownGeneMrna.name (via knownToAllenBrain.name)
      mm9.knownGenePep.name (via knownToAllenBrain.name)
      mm9.knownIsoforms.transcript (via knownToAllenBrain.name)
      mm9.knownToEnsembl.name (via knownToAllenBrain.name)
      mm9.knownToGnfAtlas2.name (via knownToAllenBrain.name)
      mm9.knownToKeggEntrez.name (via knownToAllenBrain.name)
      mm9.knownToLocusLink.name (via knownToAllenBrain.name)
      mm9.knownToPfam.name (via knownToAllenBrain.name)
      mm9.knownToRefSeq.name (via knownToAllenBrain.name)
      mm9.knownToSuper.gene (via knownToAllenBrain.name)
      mm9.knownToVisiGene.name (via knownToAllenBrain.name)
      mm9.rnBlastTab.query (via knownToAllenBrain.name)
      mm9.scBlastTab.query (via knownToAllenBrain.name)
      mm9.ucscScop.ucscId (via knownToAllenBrain.name)

Sample Rows
 
namevalue
uc009vfo.1RP_050317_01_C03
uc009vfp.1RP_050317_01_C03
uc009vgg.1RP_050317_02_C05
uc009vgx.1RP_050317_01_C03
uc009vhd.2RP_050317_02_C05
uc009vhe.1RP_050317_01_C03
uc009vhq.1RP_051005_02_D07
uc009via.1RP_050317_01_C03
uc009vib.1RP_050317_01_C03
uc009vin.1RP_050317_01_C03

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