Schema for knownToRefSeq
  Database: hg19    Primary Table: knownToRefSeq    Row Count: 73,432   Data last updated: 2013-06-14
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 uc021vde.1varchar(255) values primary ID
value NR_034035varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToRefSeq.name)
      hg19.ccdsKgMap.geneId (via knownToRefSeq.name)
      hg19.ceBlastTab.query (via knownToRefSeq.name)
      hg19.dmBlastTab.query (via knownToRefSeq.name)
      hg19.drBlastTab.query (via knownToRefSeq.name)
      hg19.foldUtr3.name (via knownToRefSeq.name)
      hg19.foldUtr5.name (via knownToRefSeq.name)
      hg19.gnfAtlas2Distance.query (via knownToRefSeq.name)
      hg19.gnfAtlas2Distance.target (via knownToRefSeq.name)
      hg19.gnfU95Distance.query (via knownToRefSeq.name)
      hg19.gnfU95Distance.target (via knownToRefSeq.name)
      hg19.humanHprdP2P.query (via knownToRefSeq.name)
      hg19.humanHprdP2P.target (via knownToRefSeq.name)
      hg19.humanVidalP2P.query (via knownToRefSeq.name)
      hg19.humanVidalP2P.target (via knownToRefSeq.name)
      hg19.humanWankerP2P.query (via knownToRefSeq.name)
      hg19.humanWankerP2P.target (via knownToRefSeq.name)
      hg19.keggPathway.kgID (via knownToRefSeq.name)
      hg19.kgAlias.kgID (via knownToRefSeq.name)
      hg19.kgColor.kgID (via knownToRefSeq.name)
      hg19.kgProtAlias.kgID (via knownToRefSeq.name)
      hg19.kgProtMap2.qName (via knownToRefSeq.name)
      hg19.kgSpAlias.kgID (via knownToRefSeq.name)
      hg19.kgTargetAli.qName (via knownToRefSeq.name)
      hg19.kgTxInfo.name (via knownToRefSeq.name)
      hg19.kgXref.kgID (via knownToRefSeq.name)
      hg19.knownBlastTab.query (via knownToRefSeq.name)
      hg19.knownBlastTab.target (via knownToRefSeq.name)
      hg19.knownCanonical.transcript (via knownToRefSeq.name)
      hg19.knownGene.name (via knownToRefSeq.name)
      hg19.knownGeneMrna.name (via knownToRefSeq.name)
      hg19.knownGenePep.name (via knownToRefSeq.name)
      hg19.knownGeneTxMrna.name (via knownToRefSeq.name)
      hg19.knownGeneTxPep.name (via knownToRefSeq.name)
      hg19.knownIsoforms.transcript (via knownToRefSeq.name)
      hg19.knownToAllenBrain.name (via knownToRefSeq.name)
      hg19.knownToEnsembl.name (via knownToRefSeq.name)
      hg19.knownToGnfAtlas2.name (via knownToRefSeq.name)
      hg19.knownToHInv.name (via knownToRefSeq.name)
      hg19.knownToHprd.name (via knownToRefSeq.name)
      hg19.knownToKeggEntrez.name (via knownToRefSeq.name)
      hg19.knownToLocusLink.name (via knownToRefSeq.name)
      hg19.knownToLynx.name (via knownToRefSeq.name)
      hg19.knownToMupit.name (via knownToRefSeq.name)
      hg19.knownToNextProt.name (via knownToRefSeq.name)
      hg19.knownToPfam.name (via knownToRefSeq.name)
      hg19.knownToSuper.gene (via knownToRefSeq.name)
      hg19.knownToTreefam.name (via knownToRefSeq.name)
      hg19.knownToU133.name (via knownToRefSeq.name)
      hg19.knownToU133Plus2.name (via knownToRefSeq.name)
      hg19.knownToU95.name (via knownToRefSeq.name)
      hg19.knownToVisiGene.name (via knownToRefSeq.name)
      hg19.knownToWikipedia.name (via knownToRefSeq.name)
      hg19.mmBlastTab.query (via knownToRefSeq.name)
      hg19.rnBlastTab.query (via knownToRefSeq.name)
      hg19.scBlastTab.query (via knownToRefSeq.name)
      hg19.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)
      hg19.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      hg19.geneNetworkId.id (via knownToRefSeq.value)
      hg19.kgXref.refseq (via knownToRefSeq.value)
      hg19.mrnaOrientInfo.name (via knownToRefSeq.value)
      hg19.refFlat.name (via knownToRefSeq.value)
      hg19.refGene.name (via knownToRefSeq.value)
      hg19.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
uc021vde.1NR_034035
uc021vdf.1NR_034035
uc021vdg.1NR_034035
uc002qvr.2NR_034035
uc021vdh.1NR_034035
uc021vdj.1NM_054016
uc021vdk.1NM_001191005
uc031tgi.1NM_001177376
uc031tgj.1NM_001177376
uc031tgk.1NM_001177376

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