Schema for spMrna
  Database: rn4    Primary Table: spMrna    Row Count: 8,202   Data last updated: 2006-06-02
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID Q6AYE9_RATvarchar(255) values SWISS-PROT display ID
mrnaID NM_001013063varchar(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)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
Q6AYE9_RATNM_001013063
KTNA1_RATNM_001004217
Q5U303_RATNM_001012062
MGR1_RATNM_017011
FBX30_RATNM_001007690
O55147_RATNM_013070
P70616_RATNM_012760
Q68FR7_RATNM_001014157
PHAR2_RATNM_214458
FUCO2_RATNM_001004218

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