Schema for knownToGnfAtlas2
  Database: rn3    Primary Table: knownToGnfAtlas2    Row Count: 4,472   Data last updated: 2004-05-26
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 U72620varchar(255) values primary ID
value U72620_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)
      rn3.dmBlastTab.query (via knownToGnfAtlas2.name)
      rn3.drBlastTab.query (via knownToGnfAtlas2.name)
      rn3.dupSpMrna.mrnaID (via knownToGnfAtlas2.name)
      rn3.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      rn3.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      rn3.hgBlastTab.query (via knownToGnfAtlas2.name)
      rn3.keggPathway.kgID (via knownToGnfAtlas2.name)
      rn3.kgAlias.kgID (via knownToGnfAtlas2.name)
      rn3.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      rn3.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      rn3.kgXref.kgID (via knownToGnfAtlas2.name)
      rn3.knownBlastTab.query (via knownToGnfAtlas2.name)
      rn3.knownBlastTab.target (via knownToGnfAtlas2.name)
      rn3.knownCanonical.transcript (via knownToGnfAtlas2.name)
      rn3.knownGene.name (via knownToGnfAtlas2.name)
      rn3.knownGeneLink.name (via knownToGnfAtlas2.name)
      rn3.knownGeneMrna.name (via knownToGnfAtlas2.name)
      rn3.knownGenePep.name (via knownToGnfAtlas2.name)
      rn3.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      rn3.knownToEnsembl.name (via knownToGnfAtlas2.name)
      rn3.knownToLocusLink.name (via knownToGnfAtlas2.name)
      rn3.knownToPfam.name (via knownToGnfAtlas2.name)
      rn3.knownToRefSeq.name (via knownToGnfAtlas2.name)
      rn3.knownToSuper.gene (via knownToGnfAtlas2.name)
      rn3.scBlastTab.query (via knownToGnfAtlas2.name)

Sample Rows
 
namevalue
U72620U72620_at
D37951D37951cds_s_at
M65251M65251_s_at
U37058U37058_at
AF361476rc_AA900476_g_at
BC062039U68272_at
U68272U68272_at
S72407S72407_at
J02720J02720_at
U78788D30649mRNA_s_at

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