Schema for knownToRefSeq
  Database: rn3    Primary Table: knownToRefSeq    Row Count: 5,975   Data last updated: 2004-04-06
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 U72620varchar(255) values primary ID
value NM_012760varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        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)
      rn3.dmBlastTab.query (via knownToRefSeq.name)
      rn3.drBlastTab.query (via knownToRefSeq.name)
      rn3.dupSpMrna.mrnaID (via knownToRefSeq.name)
      rn3.gnfAtlas2Distance.query (via knownToRefSeq.name)
      rn3.gnfAtlas2Distance.target (via knownToRefSeq.name)
      rn3.hgBlastTab.query (via knownToRefSeq.name)
      rn3.keggPathway.kgID (via knownToRefSeq.name)
      rn3.kgAlias.kgID (via knownToRefSeq.name)
      rn3.kgProtAlias.kgID (via knownToRefSeq.name)
      rn3.kgSpAlias.kgID (via knownToRefSeq.name)
      rn3.kgXref.kgID (via knownToRefSeq.name)
      rn3.knownBlastTab.query (via knownToRefSeq.name)
      rn3.knownBlastTab.target (via knownToRefSeq.name)
      rn3.knownCanonical.transcript (via knownToRefSeq.name)
      rn3.knownGene.name (via knownToRefSeq.name)
      rn3.knownGeneLink.name (via knownToRefSeq.name)
      rn3.knownGeneMrna.name (via knownToRefSeq.name)
      rn3.knownGenePep.name (via knownToRefSeq.name)
      rn3.knownIsoforms.transcript (via knownToRefSeq.name)
      rn3.knownToEnsembl.name (via knownToRefSeq.name)
      rn3.knownToGnfAtlas2.name (via knownToRefSeq.name)
      rn3.knownToLocusLink.name (via knownToRefSeq.name)
      rn3.knownToPfam.name (via knownToRefSeq.name)
      rn3.knownToSuper.gene (via knownToRefSeq.name)
      rn3.scBlastTab.query (via knownToRefSeq.name)
      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)
      rn3.geneNetworkId.id (via knownToRefSeq.value)
      rn3.kgXref.refseq (via knownToRefSeq.value)
      rn3.mrnaOrientInfo.name (via knownToRefSeq.value)
      rn3.mrnaRefseq.refseq (via knownToRefSeq.value)
      rn3.refFlat.name (via knownToRefSeq.value)
      rn3.refGene.name (via knownToRefSeq.value)
      rn3.refSeqAli.qName (via knownToRefSeq.value)

Sample Rows
 
namevalue
U72620NM_012760
D37951NM_024137
M65251NM_024137
U37058NM_012799
AF361476NM_053698
U15425NM_139039
BC062039NM_053783
U68272NM_053783
J02720NM_017134
U78788NM_019370

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