Schema for knownToRefSeq
  Database: hg17    Primary Table: knownToRefSeq    Row Count: 34,773   Data last updated: 2005-06-04
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 NM_018390varchar(255) values primary ID
value NM_018390varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToRefSeq.name)
      hg17.ccdsKgMap.geneId (via knownToRefSeq.name)
      hg17.ceBlastTab.query (via knownToRefSeq.name)
      hg17.dmBlastTab.query (via knownToRefSeq.name)
      hg17.drBlastTab.query (via knownToRefSeq.name)
      hg17.dupSpMrna.mrnaID (via knownToRefSeq.name)
      hg17.foldUtr3.name (via knownToRefSeq.name)
      hg17.foldUtr5.name (via knownToRefSeq.name)
      hg17.gladHumESDistance.query (via knownToRefSeq.name)
      hg17.gladHumESDistance.target (via knownToRefSeq.name)
      hg17.gnfAtlas2Distance.query (via knownToRefSeq.name)
      hg17.gnfAtlas2Distance.target (via knownToRefSeq.name)
      hg17.gnfU95Distance.query (via knownToRefSeq.name)
      hg17.gnfU95Distance.target (via knownToRefSeq.name)
      hg17.humanHprdP2P.query (via knownToRefSeq.name)
      hg17.humanHprdP2P.target (via knownToRefSeq.name)
      hg17.humanVidalP2P.query (via knownToRefSeq.name)
      hg17.humanVidalP2P.target (via knownToRefSeq.name)
      hg17.humanWankerP2P.query (via knownToRefSeq.name)
      hg17.humanWankerP2P.target (via knownToRefSeq.name)
      hg17.keggPathway.kgID (via knownToRefSeq.name)
      hg17.kgAlias.kgID (via knownToRefSeq.name)
      hg17.kgProtAlias.kgID (via knownToRefSeq.name)
      hg17.kgSpAlias.kgID (via knownToRefSeq.name)
      hg17.kgTargetAli.qName (via knownToRefSeq.name)
      hg17.kgXref.kgID (via knownToRefSeq.name)
      hg17.knownBlastTab.query (via knownToRefSeq.name)
      hg17.knownBlastTab.target (via knownToRefSeq.name)
      hg17.knownCanonical.transcript (via knownToRefSeq.name)
      hg17.knownExpDistance.query (via knownToRefSeq.name)
      hg17.knownExpDistance.target (via knownToRefSeq.name)
      hg17.knownGene.name (via knownToRefSeq.name)
      hg17.knownGeneLink.name (via knownToRefSeq.name)
      hg17.knownGeneMrna.name (via knownToRefSeq.name)
      hg17.knownGenePep.name (via knownToRefSeq.name)
      hg17.knownIsoforms.transcript (via knownToRefSeq.name)
      hg17.knownToAllenBrain.name (via knownToRefSeq.name)
      hg17.knownToEnsembl.name (via knownToRefSeq.name)
      hg17.knownToGnf1h.name (via knownToRefSeq.name)
      hg17.knownToGnfAtlas2.name (via knownToRefSeq.name)
      hg17.knownToHInv.name (via knownToRefSeq.name)
      hg17.knownToHprd.name (via knownToRefSeq.name)
      hg17.knownToKeggEntrez.name (via knownToRefSeq.name)
      hg17.knownToLocusLink.name (via knownToRefSeq.name)
      hg17.knownToPfam.name (via knownToRefSeq.name)
      hg17.knownToSuper.gene (via knownToRefSeq.name)
      hg17.knownToU133.name (via knownToRefSeq.name)
      hg17.knownToU133Plus2.name (via knownToRefSeq.name)
      hg17.knownToU95.name (via knownToRefSeq.name)
      hg17.knownToVisiGene.name (via knownToRefSeq.name)
      hg17.mmBlastTab.query (via knownToRefSeq.name)
      hg17.rankProp.query (via knownToRefSeq.name)
      hg17.rankProp.target (via knownToRefSeq.name)
      hg17.rnBlastTab.query (via knownToRefSeq.name)
      hg17.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)
      hg17.altGraphX.mrnaRefs (via knownToRefSeq.value)
      hg17.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      hg17.dupSpMrna.dupMrnaID (via knownToRefSeq.value)
      hg17.dupSpMrna.mrnaID (via knownToRefSeq.value)
      hg17.kgXref.refseq (via knownToRefSeq.value)
      hg17.mrnaOrientInfo.name (via knownToRefSeq.value)
      hg17.mrnaRefseq.mrna (via knownToRefSeq.value)
      hg17.mrnaRefseq.refseq (via knownToRefSeq.value)
      hg17.refFlat.name (via knownToRefSeq.value)
      hg17.refGene.name (via knownToRefSeq.value)
      hg17.refSeqAli.qName (via knownToRefSeq.value)
      hg17.spMrna.mrnaID (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
NM_018390NM_018390
NM_000451NM_000451
NM_006883NM_006883
NM_002183NM_002183
AK023392NM_025091
NM_005088NM_005088
L03426NM_005088
BC028151NM_005088
NM_004043NM_004043
BC001620NM_004043

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