Schema for dupSpMrna
  Database: rn3    Primary Table: dupSpMrna    Row Count: 893   Data last updated: 2004-03-23
Format description: Duplicated mRNA/protein IDs corresponding to a Known Genen mRNA
On download server: MariaDB table dump directory
fieldexampleSQL type info description
mrnaID AB000817varchar(20) values Known Gene (mRNA) ID
proteinID SM6C_RATvarchar(20) values protein ID for this Known Gene
dupMrnaID AF175575varchar(20) values mrnaID for the duplicate
dupProteinID Q9ESH1varchar(20) values protein ID for this duplicate

Connected Tables and Joining Fields
        hgFixed.gbCdnaInfo.acc (via dupSpMrna.mrnaID)
      hgFixed.gbSeq.acc (via dupSpMrna.mrnaID)
      hgFixed.imageClone.acc (via dupSpMrna.mrnaID)
      knownGeneV39.bioCycPathway.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.ceBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.dmBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.drBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.foldUtr3.name (via dupSpMrna.mrnaID)
      knownGeneV39.foldUtr5.name (via dupSpMrna.mrnaID)
      knownGeneV39.gnfAtlas2Distance.query (via dupSpMrna.mrnaID)
      knownGeneV39.gnfAtlas2Distance.target (via dupSpMrna.mrnaID)
      knownGeneV39.kgAlias.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.kgColor.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.kgProtAlias.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.kgSpAlias.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.kgTargetAli.qName (via dupSpMrna.mrnaID)
      knownGeneV39.kgXref.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.knownAttrs.kgID (via dupSpMrna.mrnaID)
      knownGeneV39.knownBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.knownBlastTab.target (via dupSpMrna.mrnaID)
      knownGeneV39.knownCanonical.protein (via dupSpMrna.mrnaID)
      knownGeneV39.knownCanonical.transcript (via dupSpMrna.mrnaID)
      knownGeneV39.knownCds.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownGene.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownGeneMrna.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownGenePep.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownIsoforms.transcript (via dupSpMrna.mrnaID)
      knownGeneV39.knownToEnsembl.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToGnfAtlas2.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToHprd.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToLocusLink.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToMrna.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToMrnaSingle.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToMupit.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToPfam.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToRefSeq.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToSuper.gene (via dupSpMrna.mrnaID)
      knownGeneV39.knownToTag.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToU133.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToU95.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToVisiGene.name (via dupSpMrna.mrnaID)
      knownGeneV39.knownToWikipedia.name (via dupSpMrna.mrnaID)
      knownGeneV39.mmBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.rnBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.scBlastTab.query (via dupSpMrna.mrnaID)
      knownGeneV39.ucscScop.ucscId (via dupSpMrna.mrnaID)
      rn3.all_mrna.qName (via dupSpMrna.mrnaID)
      rn3.dmBlastTab.query (via dupSpMrna.mrnaID)
      rn3.drBlastTab.query (via dupSpMrna.mrnaID)
      rn3.gnfAtlas2Distance.query (via dupSpMrna.mrnaID)
      rn3.gnfAtlas2Distance.target (via dupSpMrna.mrnaID)
      rn3.hgBlastTab.query (via dupSpMrna.mrnaID)
      rn3.keggPathway.kgID (via dupSpMrna.mrnaID)
      rn3.kgAlias.kgID (via dupSpMrna.mrnaID)
      rn3.kgProtAlias.kgID (via dupSpMrna.mrnaID)
      rn3.kgSpAlias.kgID (via dupSpMrna.mrnaID)
      rn3.kgXref.kgID (via dupSpMrna.mrnaID)
      rn3.knownBlastTab.query (via dupSpMrna.mrnaID)
      rn3.knownBlastTab.target (via dupSpMrna.mrnaID)
      rn3.knownCanonical.transcript (via dupSpMrna.mrnaID)
      rn3.knownGene.name (via dupSpMrna.mrnaID)
      rn3.knownGeneLink.name (via dupSpMrna.mrnaID)
      rn3.knownGeneMrna.name (via dupSpMrna.mrnaID)
      rn3.knownGenePep.name (via dupSpMrna.mrnaID)
      rn3.knownIsoforms.transcript (via dupSpMrna.mrnaID)
      rn3.knownToEnsembl.name (via dupSpMrna.mrnaID)
      rn3.knownToGnfAtlas2.name (via dupSpMrna.mrnaID)
      rn3.knownToLocusLink.name (via dupSpMrna.mrnaID)
      rn3.knownToPfam.name (via dupSpMrna.mrnaID)
      rn3.knownToRefSeq.name (via dupSpMrna.mrnaID)
      rn3.knownToSuper.gene (via dupSpMrna.mrnaID)
      rn3.mgcFullMrna.qName (via dupSpMrna.mrnaID)
      rn3.mgcGenes.name (via dupSpMrna.mrnaID)
      rn3.mrnaOrientInfo.name (via dupSpMrna.mrnaID)
      rn3.mrnaRefseq.mrna (via dupSpMrna.mrnaID)
      rn3.scBlastTab.query (via dupSpMrna.mrnaID)
      rn3.spMrna.mrnaID (via dupSpMrna.mrnaID)
      go.goaPart.dbObjectSymbol (via dupSpMrna.proteinID)
      knownGeneV39.kgProtAlias.displayID (via dupSpMrna.proteinID)
      knownGeneV39.kgSpAlias.alias (via dupSpMrna.proteinID)
      knownGeneV39.kgXref.spDisplayID (via dupSpMrna.proteinID)
      knownGeneV39.knownCanonical.protein (via dupSpMrna.proteinID)
      proteome.spOldNew.newDisplayId (via dupSpMrna.proteinID)
      proteome.spOldNew.oldDisplayId (via dupSpMrna.proteinID)
      rn3.kgProtAlias.displayID (via dupSpMrna.proteinID)
      rn3.kgSpAlias.alias (via dupSpMrna.proteinID)
      rn3.kgXref.spDisplayID (via dupSpMrna.proteinID)
      rn3.knownCanonical.protein (via dupSpMrna.proteinID)
      rn3.spMrna.spID (via dupSpMrna.proteinID)
      uniProt.displayId.val (via dupSpMrna.proteinID)

Sample Rows
 
mrnaIDproteinIDdupMrnaIDdupProteinID
AB000817SM6C_RATAF175575Q9ESH1
AB002406RUV1_RATAF345897Q8VHY4
AB002406RUV1_RATBC061745AAH61745
AB002466O08984BC061568AAH61568
AB002563SM4F_RATAF027179O54892
AB003504O54771BC058462AAH58462
AB005549PAD3_RATAF275734AAF82799
AB006461O35095BC058487AAH58487
AB007689HOM2_RATBC058484AAH58484
AB008521O35108BC063152AAH63152

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