Schema for knownToGnfAtlas2
  Database: mm8    Primary Table: knownToGnfAtlas2    Row Count: 22,978   Data last updated: 2006-03-13
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_030175varchar(255) values primary ID
value gnf1m09820_a_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.ceBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.dmBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.drBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.foldUtr3.name (via knownToGnfAtlas2.name)
      knownGeneV39.foldUtr5.name (via knownToGnfAtlas2.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      knownGeneV39.kgAlias.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.kgColor.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.kgTargetAli.qName (via knownToGnfAtlas2.name)
      knownGeneV39.kgXref.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.knownAttrs.kgID (via knownToGnfAtlas2.name)
      knownGeneV39.knownBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.knownBlastTab.target (via knownToGnfAtlas2.name)
      knownGeneV39.knownCanonical.protein (via knownToGnfAtlas2.name)
      knownGeneV39.knownCanonical.transcript (via knownToGnfAtlas2.name)
      knownGeneV39.knownCds.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownGene.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownGeneMrna.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownGenePep.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      knownGeneV39.knownToEnsembl.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToHprd.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToLocusLink.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToMrna.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToMupit.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToPfam.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToRefSeq.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToSuper.gene (via knownToGnfAtlas2.name)
      knownGeneV39.knownToTag.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToU133.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToU95.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToVisiGene.name (via knownToGnfAtlas2.name)
      knownGeneV39.knownToWikipedia.name (via knownToGnfAtlas2.name)
      knownGeneV39.mmBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.rnBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.scBlastTab.query (via knownToGnfAtlas2.name)
      knownGeneV39.ucscScop.ucscId (via knownToGnfAtlas2.name)
      mm8.affyGnfU74ADistance.query (via knownToGnfAtlas2.name)
      mm8.affyGnfU74ADistance.target (via knownToGnfAtlas2.name)
      mm8.affyGnfU74BDistance.query (via knownToGnfAtlas2.name)
      mm8.affyGnfU74BDistance.target (via knownToGnfAtlas2.name)
      mm8.affyGnfU74CDistance.query (via knownToGnfAtlas2.name)
      mm8.affyGnfU74CDistance.target (via knownToGnfAtlas2.name)
      mm8.ccdsKgMap.geneId (via knownToGnfAtlas2.name)
      mm8.ceBlastTab.query (via knownToGnfAtlas2.name)
      mm8.dmBlastTab.query (via knownToGnfAtlas2.name)
      mm8.drBlastTab.query (via knownToGnfAtlas2.name)
      mm8.dupSpMrna.mrnaID (via knownToGnfAtlas2.name)
      mm8.foldUtr3.name (via knownToGnfAtlas2.name)
      mm8.foldUtr5.name (via knownToGnfAtlas2.name)
      mm8.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      mm8.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      mm8.hgBlastTab.query (via knownToGnfAtlas2.name)
      mm8.keggPathway.kgID (via knownToGnfAtlas2.name)
      mm8.kgAlias.kgID (via knownToGnfAtlas2.name)
      mm8.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      mm8.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      mm8.kgTargetAli.qName (via knownToGnfAtlas2.name)
      mm8.kgXref.kgID (via knownToGnfAtlas2.name)
      mm8.knownBlastTab.query (via knownToGnfAtlas2.name)
      mm8.knownBlastTab.target (via knownToGnfAtlas2.name)
      mm8.knownCanonical.transcript (via knownToGnfAtlas2.name)
      mm8.knownGene.name (via knownToGnfAtlas2.name)
      mm8.knownGeneMrna.name (via knownToGnfAtlas2.name)
      mm8.knownGenePep.name (via knownToGnfAtlas2.name)
      mm8.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      mm8.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      mm8.knownToEnsembl.name (via knownToGnfAtlas2.name)
      mm8.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      mm8.knownToLocusLink.name (via knownToGnfAtlas2.name)
      mm8.knownToPfam.name (via knownToGnfAtlas2.name)
      mm8.knownToRefSeq.name (via knownToGnfAtlas2.name)
      mm8.knownToSuper.gene (via knownToGnfAtlas2.name)
      mm8.knownToVisiGene.name (via knownToGnfAtlas2.name)
      mm8.rnBlastTab.query (via knownToGnfAtlas2.name)
      mm8.scBlastTab.query (via knownToGnfAtlas2.name)

Sample Rows
 
namevalue
NM_030175gnf1m09820_a_at
NM_001030293gnf1m21783_a_at
NM_153523gnf1m07354_x_at
NM_027861gnf1m13727_a_at
AK002489gnf1m15847_at
AK015946gnf1m04841_x_at
NM_026136gnf1m04841_x_at
NM_027955gnf1m05232_at
BC091770gnf1m06151_a_at
NM_134114gnf1m06151_a_at

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