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 MER1290886

>MER1290886 - subfamily S8B unassigned peptidases [S08.UPB] peptidase unit: 79-399 ( active site residue(s): 102,139,242,360  ) (Aeromonas piscicola) (Source: EMBL nucleotide LYXO01000074) 
1        MRKTSLALAISALLSALPIASVQANESCTPLTGKEAGLDTGRSSAVRCLPGINPLQDQQW       60
61       HLLNSGQNAFSTRGGVAGNDLNLWWAHRTDVLGQGINVAVVDDGMAIAHPDLADNVRPGS      120
121      KNVVTGSSDPTPTDPDSAHGTSVSGIIAAVDNSIGTLGVAPRAQLQGFNLLDDNSQQLQK      180
181      DWLYALGGNAVTADNRVFNQSYGMSLVDPEGANGLDQVQLDRLFEQRTQQAQGAAYIKAA      240
241      GNGFNRIASGNYVLNRTGNLPKLPFENSNIDPSNSNFWNLVVSAINADGVRSSYSSVGSN      300
301      VFLSAPGGEYGTDAPAMVTTDLPGCDMGYNRVDDPSTNRLHNNPQLDASCDYNGVMNGTS      360
361      SATPNTTGAMALLMSAYPDLSVRDLRDLLARNATRLDANQVPVQISYTAANGQRRQVTGL      420
421      EGWERNAAGLWYSPTYGFGLVDVNKTLASAASHEPLPPLVQLPWQKVTVRDRAVGAIPDV      480
481      GSSPTRSSTQVDQSLTVEAVQVMVSLDHQRLPDLLIELVSPSGTRSVLLNPNNSLVGQSL      540
541      DRQQLGYVRTKGLRDMRMLSHKFYGEPAQGEWRLEVTDVANGSRQVSLLDRRTNTRSTLT      600
601      ERNNSQPGQLLDWSLRVLGHDAARS                                         625