Schema for knownToU95
  Database: hg16    Primary Table: knownToU95    Row Count: 18,780   Data last updated: 2004-03-30
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 AK093239varchar(255) values primary ID
value 34462_atvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToU95.name)
      hg16.dmBlastTab.query (via knownToU95.name)
      hg16.drBlastTab.query (via knownToU95.name)
      hg16.dupSpMrna.mrnaID (via knownToU95.name)
      hg16.foldUtr3.name (via knownToU95.name)
      hg16.foldUtr5.name (via knownToU95.name)
      hg16.gnfAtlas2Distance.query (via knownToU95.name)
      hg16.gnfAtlas2Distance.target (via knownToU95.name)
      hg16.gnfU95Distance.query (via knownToU95.name)
      hg16.gnfU95Distance.target (via knownToU95.name)
      hg16.hg17Kg.name (via knownToU95.name)
      hg16.keggPathway.kgID (via knownToU95.name)
      hg16.kgAlias.kgID (via knownToU95.name)
      hg16.kgProtAlias.kgID (via knownToU95.name)
      hg16.kgXref.kgID (via knownToU95.name)
      hg16.knownBlastTab.query (via knownToU95.name)
      hg16.knownBlastTab.target (via knownToU95.name)
      hg16.knownCanonical.transcript (via knownToU95.name)
      hg16.knownGene.name (via knownToU95.name)
      hg16.knownGeneLink.name (via knownToU95.name)
      hg16.knownGeneMrna.name (via knownToU95.name)
      hg16.knownGenePep.name (via knownToU95.name)
      hg16.knownIsoforms.transcript (via knownToU95.name)
      hg16.knownToEnsembl.name (via knownToU95.name)
      hg16.knownToGnfAtlas2.name (via knownToU95.name)
      hg16.knownToHInv.name (via knownToU95.name)
      hg16.knownToLocusLink.name (via knownToU95.name)
      hg16.knownToPfam.name (via knownToU95.name)
      hg16.knownToRefSeq.name (via knownToU95.name)
      hg16.knownToSuper.gene (via knownToU95.name)
      hg16.knownToU133.name (via knownToU95.name)
      hg16.scBlastTab.query (via knownToU95.name)
      knownGeneV39.bioCycPathway.kgID (via knownToU95.name)
      knownGeneV39.ceBlastTab.query (via knownToU95.name)
      knownGeneV39.dmBlastTab.query (via knownToU95.name)
      knownGeneV39.drBlastTab.query (via knownToU95.name)
      knownGeneV39.foldUtr3.name (via knownToU95.name)
      knownGeneV39.foldUtr5.name (via knownToU95.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToU95.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToU95.name)
      knownGeneV39.kgAlias.kgID (via knownToU95.name)
      knownGeneV39.kgColor.kgID (via knownToU95.name)
      knownGeneV39.kgProtAlias.kgID (via knownToU95.name)
      knownGeneV39.kgSpAlias.kgID (via knownToU95.name)
      knownGeneV39.kgTargetAli.qName (via knownToU95.name)
      knownGeneV39.kgXref.kgID (via knownToU95.name)
      knownGeneV39.knownAttrs.kgID (via knownToU95.name)
      knownGeneV39.knownBlastTab.query (via knownToU95.name)
      knownGeneV39.knownBlastTab.target (via knownToU95.name)
      knownGeneV39.knownCanonical.protein (via knownToU95.name)
      knownGeneV39.knownCanonical.transcript (via knownToU95.name)
      knownGeneV39.knownCds.name (via knownToU95.name)
      knownGeneV39.knownGene.name (via knownToU95.name)
      knownGeneV39.knownGeneMrna.name (via knownToU95.name)
      knownGeneV39.knownGenePep.name (via knownToU95.name)
      knownGeneV39.knownIsoforms.transcript (via knownToU95.name)
      knownGeneV39.knownToEnsembl.name (via knownToU95.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToU95.name)
      knownGeneV39.knownToHprd.name (via knownToU95.name)
      knownGeneV39.knownToLocusLink.name (via knownToU95.name)
      knownGeneV39.knownToMrna.name (via knownToU95.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToU95.name)
      knownGeneV39.knownToMupit.name (via knownToU95.name)
      knownGeneV39.knownToPfam.name (via knownToU95.name)
      knownGeneV39.knownToRefSeq.name (via knownToU95.name)
      knownGeneV39.knownToSuper.gene (via knownToU95.name)
      knownGeneV39.knownToTag.name (via knownToU95.name)
      knownGeneV39.knownToU133.name (via knownToU95.name)
      knownGeneV39.knownToU95.name (via knownToU95.name)
      knownGeneV39.knownToVisiGene.name (via knownToU95.name)
      knownGeneV39.knownToWikipedia.name (via knownToU95.name)
      knownGeneV39.mmBlastTab.query (via knownToU95.name)
      knownGeneV39.rnBlastTab.query (via knownToU95.name)
      knownGeneV39.scBlastTab.query (via knownToU95.name)
      knownGeneV39.ucscScop.ucscId (via knownToU95.name)
      hg16.affyRatio.name (via knownToU95.value)
      hg16.affyU95.qName (via knownToU95.value)

Sample Rows
 
namevalue
AK09323934462_at
AB01096238950_r_at
BC02571938950_r_at
AF05706138950_r_at
AF05706231641_s_at
BC014270362_at
BT007082362_at
X1521841499_at
AF15732441550_at
BC00496541550_at

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