Schema for knownToAllenBrain
  Database: hg19    Primary Table: knownToAllenBrain    Row Count: 31,118   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 RP_051219_01_F08varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToAllenBrain.name)
      hg19.ceBlastTab.query (via knownToAllenBrain.name)
      hg19.dmBlastTab.query (via knownToAllenBrain.name)
      hg19.drBlastTab.query (via knownToAllenBrain.name)
      hg19.foldUtr3.name (via knownToAllenBrain.name)
      hg19.foldUtr5.name (via knownToAllenBrain.name)
      hg19.gnfAtlas2Distance.query (via knownToAllenBrain.name)
      hg19.gnfAtlas2Distance.target (via knownToAllenBrain.name)
      hg19.gnfU95Distance.query (via knownToAllenBrain.name)
      hg19.gnfU95Distance.target (via knownToAllenBrain.name)
      hg19.humanHprdP2P.query (via knownToAllenBrain.name)
      hg19.humanHprdP2P.target (via knownToAllenBrain.name)
      hg19.humanVidalP2P.query (via knownToAllenBrain.name)
      hg19.humanVidalP2P.target (via knownToAllenBrain.name)
      hg19.humanWankerP2P.query (via knownToAllenBrain.name)
      hg19.humanWankerP2P.target (via knownToAllenBrain.name)
      hg19.keggPathway.kgID (via knownToAllenBrain.name)
      hg19.kgAlias.kgID (via knownToAllenBrain.name)
      hg19.kgColor.kgID (via knownToAllenBrain.name)
      hg19.kgProtAlias.kgID (via knownToAllenBrain.name)
      hg19.kgProtMap2.qName (via knownToAllenBrain.name)
      hg19.kgSpAlias.kgID (via knownToAllenBrain.name)
      hg19.kgTargetAli.qName (via knownToAllenBrain.name)
      hg19.kgTxInfo.name (via knownToAllenBrain.name)
      hg19.kgXref.kgID (via knownToAllenBrain.name)
      hg19.knownAttrs.kgID (via knownToAllenBrain.name)
      hg19.knownBlastTab.query (via knownToAllenBrain.name)
      hg19.knownBlastTab.target (via knownToAllenBrain.name)
      hg19.knownCanonToDecipher.name (via knownToAllenBrain.name)
      hg19.knownCanonical.transcript (via knownToAllenBrain.name)
      hg19.knownCds.name (via knownToAllenBrain.name)
      hg19.knownGene.name (via knownToAllenBrain.name)
      hg19.knownGeneMrna.name (via knownToAllenBrain.name)
      hg19.knownGenePep.name (via knownToAllenBrain.name)
      hg19.knownGeneTxMrna.name (via knownToAllenBrain.name)
      hg19.knownGeneTxPep.name (via knownToAllenBrain.name)
      hg19.knownIsoforms.transcript (via knownToAllenBrain.name)
      hg19.knownToDecipher.name (via knownToAllenBrain.name)
      hg19.knownToEnsembl.name (via knownToAllenBrain.name)
      hg19.knownToGnfAtlas2.name (via knownToAllenBrain.name)
      hg19.knownToHInv.name (via knownToAllenBrain.name)
      hg19.knownToHprd.name (via knownToAllenBrain.name)
      hg19.knownToKeggEntrez.name (via knownToAllenBrain.name)
      hg19.knownToLocusLink.name (via knownToAllenBrain.name)
      hg19.knownToLynx.name (via knownToAllenBrain.name)
      hg19.knownToMrna.name (via knownToAllenBrain.name)
      hg19.knownToMrnaSingle.name (via knownToAllenBrain.name)
      hg19.knownToMupit.name (via knownToAllenBrain.name)
      hg19.knownToNextProt.name (via knownToAllenBrain.name)
      hg19.knownToPfam.name (via knownToAllenBrain.name)
      hg19.knownToRefSeq.name (via knownToAllenBrain.name)
      hg19.knownToSuper.gene (via knownToAllenBrain.name)
      hg19.knownToTag.name (via knownToAllenBrain.name)
      hg19.knownToTreefam.name (via knownToAllenBrain.name)
      hg19.knownToU133.name (via knownToAllenBrain.name)
      hg19.knownToU133Plus2.name (via knownToAllenBrain.name)
      hg19.knownToU95.name (via knownToAllenBrain.name)
      hg19.knownToVisiGene.name (via knownToAllenBrain.name)
      hg19.knownToWikipedia.name (via knownToAllenBrain.name)
      hg19.mmBlastTab.query (via knownToAllenBrain.name)
      hg19.rnBlastTab.query (via knownToAllenBrain.name)
      hg19.scBlastTab.query (via knownToAllenBrain.name)
      hg19.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
uc031tga.1RP_051219_01_F08
uc022bqu.2RP_051219_02_B05
uc004cox.4RP_051212_04_H07
uc002yjo.4RP_Baylor_103369
uc002yjn.4RP_Baylor_103369
uc002yjp.4RP_Baylor_103369
uc002yjy.1RP_Baylor_103173
uc011aby.1RP_Baylor_103173
uc002yjz.1RP_Baylor_103173
uc010gla.1RP_Baylor_103173

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