Schema for knownToRefSeq
Database: hg19    Primary Table: knownToRefSeq    Row Count: 71,192
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name uc010yif.1varchar(255) values primary ID
value NM_006625varchar(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.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.kg4ToKg5.newId (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.protein (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.knownIsoforms.transcript (via knownToRefSeq.name)
      hg19.knownToAllenBrain.name (via knownToRefSeq.name)
      hg19.knownToEnsembl.name (via knownToRefSeq.name)
      hg19.knownToGnfAtlas2.name (via knownToRefSeq.name)
      hg19.knownToHprd.name (via knownToRefSeq.name)
      hg19.knownToLocusLink.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.knownToVisiGene.name (via knownToRefSeq.name)
      hg19.mmBlastTab.query (via knownToRefSeq.name)
      hg19.rnBlastTab.query (via knownToRefSeq.name)
      hg19.scBlastTab.query (via knownToRefSeq.name)
      hg19.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      hg19.gbCdnaInfo.acc (via knownToRefSeq.value)
      hg19.gbSeq.acc (via knownToRefSeq.value)
      hg19.gbStatus.acc (via knownToRefSeq.value)
      hg19.geneNetworkId.id (via knownToRefSeq.value)
      hg19.imageClone.acc (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.refLink.mrnaAcc (via knownToRefSeq.value)
      hg19.refSeqAli.qName (via knownToRefSeq.value)
      hg19.refSeqStatus.mrnaAcc (via knownToRefSeq.value)
      hg19.refSeqSummary.mrnaAcc (via knownToRefSeq.value)
      hg19.seq.acc (via knownToRefSeq.value)
Sample Rows
namevalue
uc010yif.1NM_006625
uc002qvr.1NM_006625
uc010yig.1NM_054016
uc011mgj.1NM_033178
uc011mgk.1NM_033178
uc011mgl.1NM_033178
uc011mgm.1NM_033178
uc011mgn.1NM_033178
uc011mgo.1NM_033178
uc011mgp.1NM_001127386

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