Schema for spMrna
  Database: mm7    Primary Table: spMrna    Row Count: 31,449   Data last updated: 2006-02-02
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID XKR4_MOUSEvarchar(255) values SWISS-PROT display ID
mrnaID NM_001011874varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via spMrna.spID)
      knownGeneV39.kgProtAlias.displayID (via spMrna.spID)
      knownGeneV39.kgSpAlias.alias (via spMrna.spID)
      knownGeneV39.kgXref.spDisplayID (via spMrna.spID)
      knownGeneV39.knownCanonical.protein (via spMrna.spID)
      mm7.dupSpMrna.dupProteinID (via spMrna.spID)
      mm7.dupSpMrna.proteinID (via spMrna.spID)
      mm7.kgProtAlias.displayID (via spMrna.spID)
      mm7.kgSpAlias.alias (via spMrna.spID)
      mm7.kgXref.spDisplayID (via spMrna.spID)
      mm7.knownCanonical.protein (via spMrna.spID)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
XKR4_MOUSENM_001011874
Q3USV4_MOUSEAK140060
RP1_MOUSENM_011283
Q61473-2AK004781
SOX17_MOUSENM_011441
Q9CPP5_MOUSENM_025300
Q9CPR5_MOUSEBC068230
LYPA1_MOUSENM_008866
P97823-2AK050549
TCEA1_MOUSENM_011541

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