Schema for knownToGnfAtlas2
  Database: hg16    Primary Table: knownToGnfAtlas2    Row Count: 35,817   Data last updated: 2004-04-15
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 AK124125varchar(255) values primary ID
value gnf1h06179_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      hg16.dmBlastTab.query (via knownToGnfAtlas2.name)
      hg16.drBlastTab.query (via knownToGnfAtlas2.name)
      hg16.dupSpMrna.mrnaID (via knownToGnfAtlas2.name)
      hg16.foldUtr3.name (via knownToGnfAtlas2.name)
      hg16.foldUtr5.name (via knownToGnfAtlas2.name)
      hg16.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      hg16.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      hg16.gnfU95Distance.query (via knownToGnfAtlas2.name)
      hg16.gnfU95Distance.target (via knownToGnfAtlas2.name)
      hg16.hg17Kg.name (via knownToGnfAtlas2.name)
      hg16.keggPathway.kgID (via knownToGnfAtlas2.name)
      hg16.kgAlias.kgID (via knownToGnfAtlas2.name)
      hg16.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      hg16.kgXref.kgID (via knownToGnfAtlas2.name)
      hg16.knownBlastTab.query (via knownToGnfAtlas2.name)
      hg16.knownBlastTab.target (via knownToGnfAtlas2.name)
      hg16.knownCanonical.transcript (via knownToGnfAtlas2.name)
      hg16.knownGene.name (via knownToGnfAtlas2.name)
      hg16.knownGeneLink.name (via knownToGnfAtlas2.name)
      hg16.knownGeneMrna.name (via knownToGnfAtlas2.name)
      hg16.knownGenePep.name (via knownToGnfAtlas2.name)
      hg16.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      hg16.knownToEnsembl.name (via knownToGnfAtlas2.name)
      hg16.knownToHInv.name (via knownToGnfAtlas2.name)
      hg16.knownToLocusLink.name (via knownToGnfAtlas2.name)
      hg16.knownToPfam.name (via knownToGnfAtlas2.name)
      hg16.knownToRefSeq.name (via knownToGnfAtlas2.name)
      hg16.knownToSuper.gene (via knownToGnfAtlas2.name)
      hg16.knownToU133.name (via knownToGnfAtlas2.name)
      hg16.knownToU95.name (via knownToGnfAtlas2.name)
      hg16.scBlastTab.query (via knownToGnfAtlas2.name)
      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)
      hg16.affyGnf1h.qName (via knownToGnfAtlas2.value)
      hg16.gnfAtlas2.name (via knownToGnfAtlas2.value)
      hgFixed.gladHumESOtherData.name (via knownToGnfAtlas2.value)
      hgFixed.gnfHumanAtlas2All.name (via knownToGnfAtlas2.value)
      hgFixed.gnfHumanAtlas2AllRatio.name (via knownToGnfAtlas2.value)
      hgFixed.gnfHumanAtlas2Median.name (via knownToGnfAtlas2.value)
      hgFixed.gnfHumanAtlas2MedianRatio.name (via knownToGnfAtlas2.value)

Sample Rows
 
namevalue
AK124125gnf1h06179_at
AK093438gnf1h06179_at
AY050570gnf1h09215_x_at
AK093239208458_at
BC004366220734_s_at
BC059409218731_s_at
BC003543218731_s_at
AF343078219068_x_at
BC014101219068_x_at
AK091144219068_x_at

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