SELECT s.sequence_id, # s.storable, d.mernum, oname.name, s.sequence FROM organism o, domain d, organism_name oname, sequence s WHERE d.mernum = ? AND o.merops_taxonomy_id = oname.merops_taxonomy_id AND oname.recommended_name = 'Yes' AND o.merops_taxonomy_id = s.merops_taxonomy_id AND s.sequence_id = d.sequence_id AND d.for_internet = 'Yes'

Sequence for MER1287464

>MER1287464 - subfamily S8B unassigned peptidases [S08.UPB] peptidase unit: 217-512 ( active site residue(s): 244,285,386,459  ) (Biomphalaria glabrata) (Source: EMBL nucleotide XM_013231516) 
1        MTKAAVPPIKCITLGEIKRIEEESQLRATMSVWANHNLMRVLDIWANHNLMRVLDILANH       60
61       NLMRVLDIWANYNLMRVLDVWANYNLMRVLDVWANYNLMRVLDTRKSLGQSALIDEMNNA      120
121      HKVYHFEMTLSGLHSSSRLLIGSLHDHYLFEAPHRHRRSASPSHEDHATLHQHDQVNWFE      180
181      QQTVKSRKKRDFHPKGTEQFTVLDPYWSNQWYLNKGAFGNNDMNVIKAWQLGFTGKNIVI      240
241      TILDDGLERTHPDLKTNYDPYASYDVNDHDSDPTPRYDPSNENRHGTRCAGEVSAEANNS      300
301      YCTVGIAPNSRIGGVRMLDGEVYDAVEAASLSFNRSHIDIYSASWGPDDDGKVVDGPGTL      360
361      AKKAFINGIEYGRGGKGSIFVWASGNGGSALDSCNCDGYANSIFTLSISSVSENGVKPWY      420
421      LEECSSTLATTYSSGAYNEKQIASTDLHEKCTTSHTGTSASAPLAAGMVALILEANKDLT      480
481      WRDVQYITLMTARPGPIRDGEWVTNGVGRKVSLRYGYGLMDAYEMVKLAQQWITVPEKRE      540
541      CIALSDVKDVPLAPHQRFTSEIVTDGCKGTKLEVTYLEHVQAVISLTYEVRGNVVIFLTS      600
601      PKGTRSQLLPHRPNDVNAGGFKEWPFLSVHFWGENPQGVWTLEVQDGDQYNSQESGGVLT      660
661      SWSLVFHGTVEYPIRFKNETTKTSPPPVTTALPNSDIIKSQENCNAECKGGCRGPLDTDC      720
721      IECKNFHIGHLKKCVPKCPDGYYSKDNMCFSCEVSCASCSGPMLTQCLSCPPGHQLLNPK      780
781      AKQMICSPDCLPGFYLNANTCLPCEPTCKECRHSSADCISCNPNYKLVGDVCLPEKEAQS      840
841      PLDKDSASSLKSLENTAIIIIVVCLSILLITSLIVTLLFARRYSYLCWADKKFYGQIPRD      900
901      EDDADVRFAYSDEIEEY                                                 917