Schema for knownToGnfAtlas2
  Database: hg19    Primary Table: knownToGnfAtlas2    Row Count: 54,261   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 uc011mfi.2varchar(255) values primary ID
value gnf1h00654_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToGnfAtlas2.name)
      hg19.ccdsKgMap.geneId (via knownToGnfAtlas2.name)
      hg19.ceBlastTab.query (via knownToGnfAtlas2.name)
      hg19.dmBlastTab.query (via knownToGnfAtlas2.name)
      hg19.drBlastTab.query (via knownToGnfAtlas2.name)
      hg19.foldUtr3.name (via knownToGnfAtlas2.name)
      hg19.foldUtr5.name (via knownToGnfAtlas2.name)
      hg19.gnfAtlas2Distance.query (via knownToGnfAtlas2.name)
      hg19.gnfAtlas2Distance.target (via knownToGnfAtlas2.name)
      hg19.gnfU95Distance.query (via knownToGnfAtlas2.name)
      hg19.gnfU95Distance.target (via knownToGnfAtlas2.name)
      hg19.humanHprdP2P.query (via knownToGnfAtlas2.name)
      hg19.humanHprdP2P.target (via knownToGnfAtlas2.name)
      hg19.humanVidalP2P.query (via knownToGnfAtlas2.name)
      hg19.humanVidalP2P.target (via knownToGnfAtlas2.name)
      hg19.humanWankerP2P.query (via knownToGnfAtlas2.name)
      hg19.humanWankerP2P.target (via knownToGnfAtlas2.name)
      hg19.keggPathway.kgID (via knownToGnfAtlas2.name)
      hg19.kgAlias.kgID (via knownToGnfAtlas2.name)
      hg19.kgColor.kgID (via knownToGnfAtlas2.name)
      hg19.kgProtAlias.kgID (via knownToGnfAtlas2.name)
      hg19.kgProtMap2.qName (via knownToGnfAtlas2.name)
      hg19.kgSpAlias.kgID (via knownToGnfAtlas2.name)
      hg19.kgTargetAli.qName (via knownToGnfAtlas2.name)
      hg19.kgTxInfo.name (via knownToGnfAtlas2.name)
      hg19.kgXref.kgID (via knownToGnfAtlas2.name)
      hg19.knownBlastTab.query (via knownToGnfAtlas2.name)
      hg19.knownBlastTab.target (via knownToGnfAtlas2.name)
      hg19.knownCanonical.transcript (via knownToGnfAtlas2.name)
      hg19.knownGene.name (via knownToGnfAtlas2.name)
      hg19.knownGeneMrna.name (via knownToGnfAtlas2.name)
      hg19.knownGenePep.name (via knownToGnfAtlas2.name)
      hg19.knownGeneTxMrna.name (via knownToGnfAtlas2.name)
      hg19.knownGeneTxPep.name (via knownToGnfAtlas2.name)
      hg19.knownIsoforms.transcript (via knownToGnfAtlas2.name)
      hg19.knownToAllenBrain.name (via knownToGnfAtlas2.name)
      hg19.knownToEnsembl.name (via knownToGnfAtlas2.name)
      hg19.knownToHInv.name (via knownToGnfAtlas2.name)
      hg19.knownToHprd.name (via knownToGnfAtlas2.name)
      hg19.knownToKeggEntrez.name (via knownToGnfAtlas2.name)
      hg19.knownToLocusLink.name (via knownToGnfAtlas2.name)
      hg19.knownToLynx.name (via knownToGnfAtlas2.name)
      hg19.knownToMupit.name (via knownToGnfAtlas2.name)
      hg19.knownToNextProt.name (via knownToGnfAtlas2.name)
      hg19.knownToPfam.name (via knownToGnfAtlas2.name)
      hg19.knownToRefSeq.name (via knownToGnfAtlas2.name)
      hg19.knownToSuper.gene (via knownToGnfAtlas2.name)
      hg19.knownToTreefam.name (via knownToGnfAtlas2.name)
      hg19.knownToU133.name (via knownToGnfAtlas2.name)
      hg19.knownToU133Plus2.name (via knownToGnfAtlas2.name)
      hg19.knownToU95.name (via knownToGnfAtlas2.name)
      hg19.knownToVisiGene.name (via knownToGnfAtlas2.name)
      hg19.knownToWikipedia.name (via knownToGnfAtlas2.name)
      hg19.mmBlastTab.query (via knownToGnfAtlas2.name)
      hg19.rnBlastTab.query (via knownToGnfAtlas2.name)
      hg19.scBlastTab.query (via knownToGnfAtlas2.name)
      hg19.ucscScop.ucscId (via knownToGnfAtlas2.name)
      hg19.affyGnf1h.qName (via knownToGnfAtlas2.value)
      hg19.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
uc011mfi.2gnf1h00654_at
uc011mgv.2215160_x_at
uc011mgu.1207712_at
uc002qvo.3217779_s_at
uc021vde.1206095_s_at
uc021vdf.1206095_s_at
uc021vdg.1206095_s_at
uc002qvr.2206095_s_at
uc021vdh.1206095_s_at
uc021vdj.1204299_at

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