Schema for knownToAllenBrain
  Database: mm7    Primary Table: knownToAllenBrain    Row Count: 22,072   Data last updated: 2007-02-08
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_008483varchar(255) values primary ID
value RP_050120_02_H03varchar(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)
      mm7.affyGnfU74ADistance.query (via knownToAllenBrain.name)
      mm7.affyGnfU74ADistance.target (via knownToAllenBrain.name)
      mm7.affyGnfU74BDistance.query (via knownToAllenBrain.name)
      mm7.affyGnfU74BDistance.target (via knownToAllenBrain.name)
      mm7.affyGnfU74CDistance.query (via knownToAllenBrain.name)
      mm7.affyGnfU74CDistance.target (via knownToAllenBrain.name)
      mm7.dmBlastTab.query (via knownToAllenBrain.name)
      mm7.drBlastTab.query (via knownToAllenBrain.name)
      mm7.dupSpMrna.mrnaID (via knownToAllenBrain.name)
      mm7.foldUtr3.name (via knownToAllenBrain.name)
      mm7.foldUtr5.name (via knownToAllenBrain.name)
      mm7.gnfAtlas2Distance.query (via knownToAllenBrain.name)
      mm7.gnfAtlas2Distance.target (via knownToAllenBrain.name)
      mm7.hgBlastTab.query (via knownToAllenBrain.name)
      mm7.keggPathway.kgID (via knownToAllenBrain.name)
      mm7.kgAlias.kgID (via knownToAllenBrain.name)
      mm7.kgProtAlias.kgID (via knownToAllenBrain.name)
      mm7.kgSpAlias.kgID (via knownToAllenBrain.name)
      mm7.kgXref.kgID (via knownToAllenBrain.name)
      mm7.knownBlastTab.query (via knownToAllenBrain.name)
      mm7.knownBlastTab.target (via knownToAllenBrain.name)
      mm7.knownCanonical.transcript (via knownToAllenBrain.name)
      mm7.knownGene.name (via knownToAllenBrain.name)
      mm7.knownGeneLink.name (via knownToAllenBrain.name)
      mm7.knownGeneMrna.name (via knownToAllenBrain.name)
      mm7.knownGenePep.name (via knownToAllenBrain.name)
      mm7.knownIsoforms.transcript (via knownToAllenBrain.name)
      mm7.knownToEnsembl.name (via knownToAllenBrain.name)
      mm7.knownToGnfAtlas2.name (via knownToAllenBrain.name)
      mm7.knownToKeggEntrez.name (via knownToAllenBrain.name)
      mm7.knownToLocusLink.name (via knownToAllenBrain.name)
      mm7.knownToPfam.name (via knownToAllenBrain.name)
      mm7.knownToRefSeq.name (via knownToAllenBrain.name)
      mm7.knownToVisiGene.name (via knownToAllenBrain.name)
      mm7.rnBlastTab.query (via knownToAllenBrain.name)
      mm7.scBlastTab.query (via knownToAllenBrain.name)

Sample Rows
 
namevalue
NM_008483RP_050120_02_H03
AK141751RP_050324_03_G01
BC089532RP_050517_03_F04
AB055856RP_050517_03_F04
BC057991RP_050316_01_D03
NM_028245RP_050316_01_D03
NM_011124RP_050120_01_H10
NM_010550RP_050503_02_E11
NM_133847RP_050321_03_D07
BC071208RP_050321_03_D07

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