Schema for knownToRefSeq
  Database: hg18    Primary Table: knownToRefSeq    Row Count: 59,950   Data last updated: 2009-03-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 uc004fon.1varchar(255) values primary ID
value NM_018390varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToRefSeq.name)
      hg18.ccdsKgMap.geneId (via knownToRefSeq.name)
      hg18.ceBlastTab.query (via knownToRefSeq.name)
      hg18.dmBlastTab.query (via knownToRefSeq.name)
      hg18.drBlastTab.query (via knownToRefSeq.name)
      hg18.foldUtr3.name (via knownToRefSeq.name)
      hg18.foldUtr5.name (via knownToRefSeq.name)
      hg18.gnfAtlas2Distance.query (via knownToRefSeq.name)
      hg18.gnfAtlas2Distance.target (via knownToRefSeq.name)
      hg18.gnfU95Distance.query (via knownToRefSeq.name)
      hg18.gnfU95Distance.target (via knownToRefSeq.name)
      hg18.humanHprdP2P.query (via knownToRefSeq.name)
      hg18.humanHprdP2P.target (via knownToRefSeq.name)
      hg18.humanVidalP2P.query (via knownToRefSeq.name)
      hg18.humanVidalP2P.target (via knownToRefSeq.name)
      hg18.humanWankerP2P.query (via knownToRefSeq.name)
      hg18.humanWankerP2P.target (via knownToRefSeq.name)
      hg18.keggPathway.kgID (via knownToRefSeq.name)
      hg18.kgAlias.kgID (via knownToRefSeq.name)
      hg18.kgColor.kgID (via knownToRefSeq.name)
      hg18.kgProtAlias.kgID (via knownToRefSeq.name)
      hg18.kgProtMap2.qName (via knownToRefSeq.name)
      hg18.kgSpAlias.kgID (via knownToRefSeq.name)
      hg18.kgTargetAli.qName (via knownToRefSeq.name)
      hg18.kgTxInfo.name (via knownToRefSeq.name)
      hg18.kgXref.kgID (via knownToRefSeq.name)
      hg18.knownBlastTab.query (via knownToRefSeq.name)
      hg18.knownBlastTab.target (via knownToRefSeq.name)
      hg18.knownCanonToDecipher.name (via knownToRefSeq.name)
      hg18.knownCanonical.protein (via knownToRefSeq.name)
      hg18.knownCanonical.transcript (via knownToRefSeq.name)
      hg18.knownGene.name (via knownToRefSeq.name)
      hg18.knownGeneMrna.name (via knownToRefSeq.name)
      hg18.knownGenePep.name (via knownToRefSeq.name)
      hg18.knownIsoforms.transcript (via knownToRefSeq.name)
      hg18.knownToAllenBrain.name (via knownToRefSeq.name)
      hg18.knownToDecipher.name (via knownToRefSeq.name)
      hg18.knownToEnsembl.name (via knownToRefSeq.name)
      hg18.knownToGnf1h.name (via knownToRefSeq.name)
      hg18.knownToGnfAtlas2.name (via knownToRefSeq.name)
      hg18.knownToHInv.name (via knownToRefSeq.name)
      hg18.knownToHprd.name (via knownToRefSeq.name)
      hg18.knownToKeggEntrez.name (via knownToRefSeq.name)
      hg18.knownToLocusLink.name (via knownToRefSeq.name)
      hg18.knownToMupit.name (via knownToRefSeq.name)
      hg18.knownToPfam.name (via knownToRefSeq.name)
      hg18.knownToSuper.gene (via knownToRefSeq.name)
      hg18.knownToTreefam.name (via knownToRefSeq.name)
      hg18.knownToU133.name (via knownToRefSeq.name)
      hg18.knownToU133Plus2.name (via knownToRefSeq.name)
      hg18.knownToU95.name (via knownToRefSeq.name)
      hg18.knownToVisiGene.name (via knownToRefSeq.name)
      hg18.mmBlastTab.query (via knownToRefSeq.name)
      hg18.rnBlastTab.query (via knownToRefSeq.name)
      hg18.scBlastTab.query (via knownToRefSeq.name)
      hg18.ucscScop.ucscId (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)
      hg18.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      hg18.kgXref.refseq (via knownToRefSeq.value)
      hg18.mrnaOrientInfo.name (via knownToRefSeq.value)
      hg18.mrnaRefseq.refseq (via knownToRefSeq.value)
      hg18.refFlat.name (via knownToRefSeq.value)
      hg18.refGene.name (via knownToRefSeq.value)
      hg18.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
uc004fon.1NM_018390
uc004foo.1NM_018390
uc004fop.1NM_018390
uc004fou.1NM_000451
uc004fov.1NM_006883
uc004fpa.1NM_006140
uc004fpb.1NM_172245
uc004fpc.1NM_172246
uc004fpd.1NM_172249
uc010nvt.1NM_172245

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