Schema for knownToRefSeq
  Database: hg38    Primary Table: knownToRefSeq    Row Count: 218,019   Data last updated: 2022-05-15
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name ENST00000387416.2varchar(255) values primary ID
value NR_162149varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToRefSeq.name)
      hg38.ccdsKgMap.geneId (via knownToRefSeq.name)
      hg38.ceBlastTab.query (via knownToRefSeq.name)
      hg38.dmBlastTab.query (via knownToRefSeq.name)
      hg38.drBlastTab.query (via knownToRefSeq.name)
      hg38.foldUtr3.name (via knownToRefSeq.name)
      hg38.foldUtr5.name (via knownToRefSeq.name)
      hg38.gnfAtlas2Distance.query (via knownToRefSeq.name)
      hg38.gnfAtlas2Distance.target (via knownToRefSeq.name)
      hg38.gnfU95Distance.query (via knownToRefSeq.name)
      hg38.gnfU95Distance.target (via knownToRefSeq.name)
      hg38.humanHprdP2P.query (via knownToRefSeq.name)
      hg38.humanHprdP2P.target (via knownToRefSeq.name)
      hg38.humanVidalP2P.query (via knownToRefSeq.name)
      hg38.humanVidalP2P.target (via knownToRefSeq.name)
      hg38.humanWankerP2P.query (via knownToRefSeq.name)
      hg38.humanWankerP2P.target (via knownToRefSeq.name)
      hg38.keggPathway.kgID (via knownToRefSeq.name)
      hg38.kgAlias.kgID (via knownToRefSeq.name)
      hg38.kgColor.kgID (via knownToRefSeq.name)
      hg38.kgProtAlias.kgID (via knownToRefSeq.name)
      hg38.kgSpAlias.kgID (via knownToRefSeq.name)
      hg38.kgTargetAli.qName (via knownToRefSeq.name)
      hg38.kgXref.kgID (via knownToRefSeq.name)
      hg38.knownAttrs.kgID (via knownToRefSeq.name)
      hg38.knownBlastTab.query (via knownToRefSeq.name)
      hg38.knownBlastTab.target (via knownToRefSeq.name)
      hg38.knownCanonical.transcript (via knownToRefSeq.name)
      hg38.knownCds.name (via knownToRefSeq.name)
      hg38.knownGene.name (via knownToRefSeq.name)
      hg38.knownGeneMrna.name (via knownToRefSeq.name)
      hg38.knownGenePep.name (via knownToRefSeq.name)
      hg38.knownIsoforms.transcript (via knownToRefSeq.name)
      hg38.knownToEnsembl.name (via knownToRefSeq.name)
      hg38.knownToGnfAtlas2.name (via knownToRefSeq.name)
      hg38.knownToHprd.name (via knownToRefSeq.name)
      hg38.knownToKeggEntrez.name (via knownToRefSeq.name)
      hg38.knownToLocusLink.name (via knownToRefSeq.name)
      hg38.knownToLynx.name (via knownToRefSeq.name)
      hg38.knownToMrna.name (via knownToRefSeq.name)
      hg38.knownToMrnaSingle.name (via knownToRefSeq.name)
      hg38.knownToMupit.name (via knownToRefSeq.name)
      hg38.knownToNextProt.name (via knownToRefSeq.name)
      hg38.knownToPfam.name (via knownToRefSeq.name)
      hg38.knownToSuper.gene (via knownToRefSeq.name)
      hg38.knownToTag.name (via knownToRefSeq.name)
      hg38.knownToU133.name (via knownToRefSeq.name)
      hg38.knownToU95.name (via knownToRefSeq.name)
      hg38.knownToVisiGene.name (via knownToRefSeq.name)
      hg38.knownToWikipedia.name (via knownToRefSeq.name)
      hg38.mmBlastTab.query (via knownToRefSeq.name)
      hg38.rnBlastTab.query (via knownToRefSeq.name)
      hg38.scBlastTab.query (via knownToRefSeq.name)
      hg38.ucscScop.ucscId (via knownToRefSeq.name)
      hg38.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      hg38.kgXref.refseq (via knownToRefSeq.value)
      hg38.mrnaOrientInfo.name (via knownToRefSeq.value)
      hg38.refFlat.name (via knownToRefSeq.value)
      hg38.refGene.name (via knownToRefSeq.value)
      hg38.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)

Sample Rows
 
namevalue
ENST00000387416.2NR_162149
ENST00000633083.1NM_002929
ENST00000631997.1NM_002929
ENST00000633962.1NR_028064
ENST00000615646.4NM_001367912
ENST00000625471.2NM_001367912
ENST00000612920.2NM_001367912
ENST00000620127.3NM_001367912
ENST00000628976.2NM_001367912
ENST00000619109.1NR_004400

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