Schema for dupSpMrna
  Database: hg16    Primary Table: dupSpMrna    Row Count: 5,962   Data last updated: 2004-04-13
Format description: Duplicated mRNA/protein IDs corresponding to a Known Genen mRNA
On download server: MariaDB table dump directory
fieldexampleSQL type info description
mrnaID AB000099varchar(20) values Known Gene (mRNA) ID
proteinID DSR4_HUMANvarchar(20) values protein ID for this Known Gene
dupMrnaID U52153varchar(20) values mrnaID for the duplicate
dupProteinID AAB07044varchar(20) values protein ID for this duplicate

Connected Tables and Joining Fields
        hg16.all_mrna.qName (via dupSpMrna.mrnaID)
      hg16.altGraphX.mrnaRefs (via dupSpMrna.mrnaID)
      hg16.bioCycPathway.kgID (via dupSpMrna.mrnaID)
      hg16.dmBlastTab.query (via dupSpMrna.mrnaID)
      hg16.drBlastTab.query (via dupSpMrna.mrnaID)
      hg16.foldUtr3.name (via dupSpMrna.mrnaID)
      hg16.foldUtr5.name (via dupSpMrna.mrnaID)
      hg16.gnfAtlas2Distance.query (via dupSpMrna.mrnaID)
      hg16.gnfAtlas2Distance.target (via dupSpMrna.mrnaID)
      hg16.gnfU95Distance.query (via dupSpMrna.mrnaID)
      hg16.gnfU95Distance.target (via dupSpMrna.mrnaID)
      hg16.hg17Kg.name (via dupSpMrna.mrnaID)
      hg16.keggPathway.kgID (via dupSpMrna.mrnaID)
      hg16.kgAlias.kgID (via dupSpMrna.mrnaID)
      hg16.kgProtAlias.kgID (via dupSpMrna.mrnaID)
      hg16.kgXref.kgID (via dupSpMrna.mrnaID)
      hg16.knownBlastTab.query (via dupSpMrna.mrnaID)
      hg16.knownBlastTab.target (via dupSpMrna.mrnaID)
      hg16.knownCanonical.transcript (via dupSpMrna.mrnaID)
      hg16.knownGene.name (via dupSpMrna.mrnaID)
      hg16.knownGeneLink.name (via dupSpMrna.mrnaID)
      hg16.knownGeneMrna.name (via dupSpMrna.mrnaID)
      hg16.knownGenePep.name (via dupSpMrna.mrnaID)
      hg16.knownIsoforms.transcript (via dupSpMrna.mrnaID)
      hg16.knownToEnsembl.name (via dupSpMrna.mrnaID)
      hg16.knownToGnfAtlas2.name (via dupSpMrna.mrnaID)
      hg16.knownToHInv.name (via dupSpMrna.mrnaID)
      hg16.knownToLocusLink.name (via dupSpMrna.mrnaID)
      hg16.knownToPfam.name (via dupSpMrna.mrnaID)
      hg16.knownToRefSeq.name (via dupSpMrna.mrnaID)
      hg16.knownToSuper.gene (via dupSpMrna.mrnaID)
      hg16.knownToU133.name (via dupSpMrna.mrnaID)
      hg16.knownToU95.name (via dupSpMrna.mrnaID)
      hg16.mgcFullMrna.qName (via dupSpMrna.mrnaID)
      hg16.mgcGenes.name (via dupSpMrna.mrnaID)
      hg16.mrnaOrientInfo.name (via dupSpMrna.mrnaID)
      hg16.mrnaRefseq.mrna (via dupSpMrna.mrnaID)
      hg16.scBlastTab.query (via dupSpMrna.mrnaID)
      hg16.spMrna.mrnaID (via dupSpMrna.mrnaID)
      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)
      go.goaPart.dbObjectSymbol (via dupSpMrna.proteinID)
      hg16.kgProtAlias.displayID (via dupSpMrna.proteinID)
      hg16.kgXref.spDisplayID (via dupSpMrna.proteinID)
      hg16.knownCanonical.protein (via dupSpMrna.proteinID)
      hg16.spMrna.spID (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)
      uniProt.displayId.val (via dupSpMrna.proteinID)

Sample Rows
 
mrnaIDproteinIDdupMrnaIDdupProteinID
AB000099DSR4_HUMANU52153AAB07044
AB0004623BP2_HUMANAJ304866Q9BQR6
AB0004623BP2_HUMANBC002740AAH02740
AB0004623BP2_HUMANBC002740Q9H682
AB000616Q9UM21AY017215Q9Y4S6
AB001328O14496AF043233O43641
AB002134HATT_HUMANAY392011AAR92228
AB002293O15014BC012448Q96ED7
AB002294Y296_HUMANAK027398Q96K58
AB002347O15057BC024217AAH24217

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