Schema for spMrna
  Database: mm39    Primary Table: spMrna    Row Count: 50,113   Data last updated: 2022-12-31
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID GNAI3_MOUSEvarchar(255) values SWISS-PROT display ID
mrnaID ENSMUST00000000001.5varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via spMrna.spID)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
GNAI3_MOUSEENSMUST00000000001.5
Q3UV89_MOUSEENSMUST00000000003.14
HXB9_MOUSEENSMUST00000000010.9
CDC45_MOUSEENSMUST00000000028.14
IGF2_MOUSEENSMUST00000000033.12
APOH_MOUSEENSMUST00000000049.6
CAV2_MOUSEENSMUST00000000058.7
Q8BPQ2_MOUSEENSMUST00000000080.8
SCMH1_MOUSEENSMUST00000000087.13
COX5A_MOUSEENSMUST00000000090.8

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