Schema for knownToRefSeq
  Database: hg16    Primary Table: knownToRefSeq    Row Count: 36,078   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 AK124125varchar(255) values primary ID
value NM_153254varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToRefSeq.name)
      hg16.dmBlastTab.query (via knownToRefSeq.name)
      hg16.drBlastTab.query (via knownToRefSeq.name)
      hg16.dupSpMrna.mrnaID (via knownToRefSeq.name)
      hg16.foldUtr3.name (via knownToRefSeq.name)
      hg16.foldUtr5.name (via knownToRefSeq.name)
      hg16.gnfAtlas2Distance.query (via knownToRefSeq.name)
      hg16.gnfAtlas2Distance.target (via knownToRefSeq.name)
      hg16.gnfU95Distance.query (via knownToRefSeq.name)
      hg16.gnfU95Distance.target (via knownToRefSeq.name)
      hg16.hg17Kg.name (via knownToRefSeq.name)
      hg16.keggPathway.kgID (via knownToRefSeq.name)
      hg16.kgAlias.kgID (via knownToRefSeq.name)
      hg16.kgProtAlias.kgID (via knownToRefSeq.name)
      hg16.kgXref.kgID (via knownToRefSeq.name)
      hg16.knownBlastTab.query (via knownToRefSeq.name)
      hg16.knownBlastTab.target (via knownToRefSeq.name)
      hg16.knownCanonical.transcript (via knownToRefSeq.name)
      hg16.knownGene.name (via knownToRefSeq.name)
      hg16.knownGeneLink.name (via knownToRefSeq.name)
      hg16.knownGeneMrna.name (via knownToRefSeq.name)
      hg16.knownGenePep.name (via knownToRefSeq.name)
      hg16.knownIsoforms.transcript (via knownToRefSeq.name)
      hg16.knownToEnsembl.name (via knownToRefSeq.name)
      hg16.knownToGnfAtlas2.name (via knownToRefSeq.name)
      hg16.knownToHInv.name (via knownToRefSeq.name)
      hg16.knownToLocusLink.name (via knownToRefSeq.name)
      hg16.knownToPfam.name (via knownToRefSeq.name)
      hg16.knownToSuper.gene (via knownToRefSeq.name)
      hg16.knownToU133.name (via knownToRefSeq.name)
      hg16.knownToU95.name (via knownToRefSeq.name)
      hg16.scBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.bioCycPathway.kgID (via knownToRefSeq.name)
      knownGeneV39.ceBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.dmBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.drBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.foldUtr3.name (via knownToRefSeq.name)
      knownGeneV39.foldUtr5.name (via knownToRefSeq.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToRefSeq.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToRefSeq.name)
      knownGeneV39.kgAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgColor.kgID (via knownToRefSeq.name)
      knownGeneV39.kgProtAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgSpAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgTargetAli.qName (via knownToRefSeq.name)
      knownGeneV39.kgXref.kgID (via knownToRefSeq.name)
      knownGeneV39.knownAttrs.kgID (via knownToRefSeq.name)
      knownGeneV39.knownBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.knownBlastTab.target (via knownToRefSeq.name)
      knownGeneV39.knownCanonical.protein (via knownToRefSeq.name)
      knownGeneV39.knownCanonical.transcript (via knownToRefSeq.name)
      knownGeneV39.knownCds.name (via knownToRefSeq.name)
      knownGeneV39.knownGene.name (via knownToRefSeq.name)
      knownGeneV39.knownGeneMrna.name (via knownToRefSeq.name)
      knownGeneV39.knownGenePep.name (via knownToRefSeq.name)
      knownGeneV39.knownIsoforms.transcript (via knownToRefSeq.name)
      knownGeneV39.knownToEnsembl.name (via knownToRefSeq.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToRefSeq.name)
      knownGeneV39.knownToHprd.name (via knownToRefSeq.name)
      knownGeneV39.knownToLocusLink.name (via knownToRefSeq.name)
      knownGeneV39.knownToMrna.name (via knownToRefSeq.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToRefSeq.name)
      knownGeneV39.knownToMupit.name (via knownToRefSeq.name)
      knownGeneV39.knownToPfam.name (via knownToRefSeq.name)
      knownGeneV39.knownToRefSeq.name (via knownToRefSeq.name)
      knownGeneV39.knownToSuper.gene (via knownToRefSeq.name)
      knownGeneV39.knownToTag.name (via knownToRefSeq.name)
      knownGeneV39.knownToU133.name (via knownToRefSeq.name)
      knownGeneV39.knownToU95.name (via knownToRefSeq.name)
      knownGeneV39.knownToVisiGene.name (via knownToRefSeq.name)
      knownGeneV39.knownToWikipedia.name (via knownToRefSeq.name)
      knownGeneV39.mmBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.rnBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.scBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.ucscScop.ucscId (via knownToRefSeq.name)
      hg16.altGraphX.mrnaRefs (via knownToRefSeq.value)
      hg16.kgXref.refseq (via knownToRefSeq.value)
      hg16.mrnaOrientInfo.name (via knownToRefSeq.value)
      hg16.mrnaRefseq.refseq (via knownToRefSeq.value)
      hg16.refFlat.name (via knownToRefSeq.value)
      hg16.refGene.name (via knownToRefSeq.value)
      hg16.refSeqAli.qName (via knownToRefSeq.value)
      hgFixed.gbCdnaInfo.acc (via knownToRefSeq.value)
      hgFixed.gbSeq.acc (via knownToRefSeq.value)
      hgFixed.imageClone.acc (via knownToRefSeq.value)
      hgFixed.refLink.mrnaAcc (via knownToRefSeq.value)
      hgFixed.refSeqStatus.mrnaAcc (via knownToRefSeq.value)
      hgFixed.refSeqSummary.mrnaAcc (via knownToRefSeq.value)
      knownGeneV39.kgXref.refseq (via knownToRefSeq.value)
      knownGeneV39.knownToRefSeq.value (via knownToRefSeq.value)

Sample Rows
 
namevalue
AK124125NM_153254
AK093438NM_153254
AY050570NM_080605
BC015549NM_080605
AK093239NM_002978
BC034304NM_153339
BC004366NM_030575
BC059409NM_022834
BC003543NM_022834
AK094502NM_198466

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