Schema for knownToAllenBrain
  Database: hg17    Primary Table: knownToAllenBrain    Row Count: 18,187   Data last updated: 2005-10-29
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_004660varchar(255) values primary ID
value RP_NM_012008varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToAllenBrain.name)
      hg17.ccdsKgMap.geneId (via knownToAllenBrain.name)
      hg17.ceBlastTab.query (via knownToAllenBrain.name)
      hg17.dmBlastTab.query (via knownToAllenBrain.name)
      hg17.drBlastTab.query (via knownToAllenBrain.name)
      hg17.dupSpMrna.mrnaID (via knownToAllenBrain.name)
      hg17.foldUtr3.name (via knownToAllenBrain.name)
      hg17.foldUtr5.name (via knownToAllenBrain.name)
      hg17.gladHumESDistance.query (via knownToAllenBrain.name)
      hg17.gladHumESDistance.target (via knownToAllenBrain.name)
      hg17.gnfAtlas2Distance.query (via knownToAllenBrain.name)
      hg17.gnfAtlas2Distance.target (via knownToAllenBrain.name)
      hg17.gnfU95Distance.query (via knownToAllenBrain.name)
      hg17.gnfU95Distance.target (via knownToAllenBrain.name)
      hg17.humanHprdP2P.query (via knownToAllenBrain.name)
      hg17.humanHprdP2P.target (via knownToAllenBrain.name)
      hg17.humanVidalP2P.query (via knownToAllenBrain.name)
      hg17.humanVidalP2P.target (via knownToAllenBrain.name)
      hg17.humanWankerP2P.query (via knownToAllenBrain.name)
      hg17.humanWankerP2P.target (via knownToAllenBrain.name)
      hg17.keggPathway.kgID (via knownToAllenBrain.name)
      hg17.kgAlias.kgID (via knownToAllenBrain.name)
      hg17.kgProtAlias.kgID (via knownToAllenBrain.name)
      hg17.kgSpAlias.kgID (via knownToAllenBrain.name)
      hg17.kgTargetAli.qName (via knownToAllenBrain.name)
      hg17.kgXref.kgID (via knownToAllenBrain.name)
      hg17.knownBlastTab.query (via knownToAllenBrain.name)
      hg17.knownBlastTab.target (via knownToAllenBrain.name)
      hg17.knownCanonical.transcript (via knownToAllenBrain.name)
      hg17.knownExpDistance.query (via knownToAllenBrain.name)
      hg17.knownExpDistance.target (via knownToAllenBrain.name)
      hg17.knownGene.name (via knownToAllenBrain.name)
      hg17.knownGeneLink.name (via knownToAllenBrain.name)
      hg17.knownGeneMrna.name (via knownToAllenBrain.name)
      hg17.knownGenePep.name (via knownToAllenBrain.name)
      hg17.knownIsoforms.transcript (via knownToAllenBrain.name)
      hg17.knownToEnsembl.name (via knownToAllenBrain.name)
      hg17.knownToGnf1h.name (via knownToAllenBrain.name)
      hg17.knownToGnfAtlas2.name (via knownToAllenBrain.name)
      hg17.knownToHInv.name (via knownToAllenBrain.name)
      hg17.knownToHprd.name (via knownToAllenBrain.name)
      hg17.knownToKeggEntrez.name (via knownToAllenBrain.name)
      hg17.knownToLocusLink.name (via knownToAllenBrain.name)
      hg17.knownToPfam.name (via knownToAllenBrain.name)
      hg17.knownToRefSeq.name (via knownToAllenBrain.name)
      hg17.knownToSuper.gene (via knownToAllenBrain.name)
      hg17.knownToU133.name (via knownToAllenBrain.name)
      hg17.knownToU133Plus2.name (via knownToAllenBrain.name)
      hg17.knownToU95.name (via knownToAllenBrain.name)
      hg17.knownToVisiGene.name (via knownToAllenBrain.name)
      hg17.mmBlastTab.query (via knownToAllenBrain.name)
      hg17.rankProp.query (via knownToAllenBrain.name)
      hg17.rankProp.target (via knownToAllenBrain.name)
      hg17.rnBlastTab.query (via knownToAllenBrain.name)
      hg17.scBlastTab.query (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
NM_004660RP_NM_012008
NM_007125RP_050407_04_E12
NM_182660RP_050407_04_E12
NM_013230RP_050426_02_A08
NM_004653RP_050609_01_H08
D87072RP_050609_01_H08
BC032708RP_TC1563680
NM_005647RP_TC1563680
NM_001649RP_050421_01_F02
X83543RP_050421_01_F02

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