Schema for spMrna
  Database: mm9    Primary Table: spMrna    Row Count: 40,633   Data last updated: 2011-03-03
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID LYPA1_MOUSEvarchar(255) values SWISS-PROT display ID
mrnaID uc007afh.1varchar(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)
      mm9.kgXref.spDisplayID (via spMrna.spID)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
LYPA1_MOUSEuc007afh.1
P97823-2uc007afg.1
Q3UWX7_MOUSEuc007afi.2
Q3UWX7_MOUSEuc011wht.1
Q3UWX7_MOUSEuc011whu.1
VATH_MOUSEuc007afn.1
Q3U9S9_MOUSEuc007afm.1
Q14AL5_MOUSEuc007afo.1
Q14AL5_MOUSEuc007afp.1
Q14AL5_MOUSEuc007afq.1

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