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 MER0347877

>MER0347877 - subfamily C2A unassigned peptidases [C02.UPA] peptidase unit: 59-311 ( active site residue(s): 83,90,244,270  ) (Acyrthosiphon pisum) (Source: EMBL nucleotide XM_003244253) 
1        MLNIGEWGPGLRQRPAGFVQNFHELRDQCLIQKKPFTDPEFDTYDLTLFYDVPKDGFEWR       60
61       RPNEITDDPKFFVEGASRFDVRQGKYIGDCWLLAAIANMTLNKKVFSKVVPHDQGFDNKY      120
121      AGIFHFKFWQYGKWVDVVVDDRLPTHRGKLLSVQSSSKNEFWSALLEKAYAKINGSYEAL      180
181      EGGFTMEAMGDFTGGVSEIYELNNEHPNLFTIMLNSFQRQSLMCGAILNSKSPDTDKRGL      240
241      FKSHAYSITRITYIPLPSSNSIIPLIRLRNPWGKSEWNGRWSDKSDEWKSIPQHLKQSIG      300
301      LIIEDDGEFWMLFDDFVKYFSILEICHLNPGYLDNEQYRVSGGAKWDLSIFEGEWVRGAT      360
361      AGGCDKFKETFSSNPQYYITIVDPDENDNNNMCTVIIALMLKDTRGQQKQKAQSLSFGFY      420
421      VYNLNTSKIVPKPLDTNFFENNDPLDKVHCSEFKPREVCKRFRIPPGKYCIVPYTSNQNE      480
481      EGAFLLRVFSEKKNNLAEFDNEVGMVEIDDKIKKLALYSKKSDDSNEKLKKYFLKVAGSD      540
541      KEVDWMDLKNILDFCMKDTGHTKFSNDVCRCLIAMMDWDRSGKLGFKEFQRLWIDIRQWQ      600
601      DTETNEEIYDGTKPKFVEVNENFTSSPNLFDLDSPLYSRPSSPLTLKSGAIAKVPECNRF      660
661      EPYLKPCSSSNSSTTLHSKYGNFKPMEWTNHTVLELLNTTNDGRYVTANAKLNNGFLSDE      720
721      GQNVLTKLLINHLFQDQHKGTDLFFRKIAKLIVEIFPNELESVYFIPPKTEGSHQTHAKG      780
781      KLVEKWKNVSKRLRAVGALEIQTKIVGSSSGSHTINVFTDQVNLAKEWLKTDGLIASFDD      840
841      VLKNWEITFELRNNEITNSINCNLSDFFESWPILQSPRGYELVEVDFRLKYPNDKSYDFR      900
901      HFISNWGKFTEAILNIRRSSVKDKHANNLLSQYDTAQLMEDYRTCNILKLLLLPYLSPNK      960
961      TQIKGNNKIKSWKPSLEESAAAFVTHVTNLSNLEEDIIRRRLKYTEYGSTIQPFIILVGN     1020
1021     DISSINTSYIRVNDQLWKIQCPLRALNICFKTYFTFHCSYPRECYETWLLLQTHVFNLIF     1080
1081     HNLNNYSLFICNQNFCVRNFRGIGNFRKHLNKEHTASNLTLNLNLNEVTIPNVDIDPTSS     1140
1141     ESILLNPESLISHTEIENKINNSFEDIVTSSAVSFIADLYSNPSMTETLLQKIVTGTNEL     1200
1201     ISNGIICHLKSKIKPLLNKCTPKQIQEIDKLLNVLVNLFAKFDTKFLRMKYLEENNLYVK     1260
1261     PKSVVVGYTKEKKIENGIERLLMVPIEGHLISLKTNLKSFFELPGVFDIALNYLKNSMKS     1320
1321     NLLSSYLNGSSWKYIYSMFPDKIVFPLFLYYDDAEMGNPLGSHSGVHKMGCVYYSVAALP     1380
1381     PEYLSSLNNIFVAFLFHSADRGQSKINNKKMFAALIKELIDIQENGILLSTNVTIYFTLG     1440
1441     LVLGDNLGLNSILGFVESFSANFYCRICYLPKSDLQNLLKESKCIRYKINYEDHINQDNV     1500
1501     SMTGIKERCIFNEVPNYHVVENIVCDFMHDIPEGVARYDMAVIINSLIQAKYFTLDELNS     1560
1561     RIQLFAYGVTEQKNSPPSISLRNLNNGNIIMSASEMLCFIRYFGLIIGELVPLKTEVWYL     1620
1621     YISLRKIVDLCCARTIQPECSVQLDALVAEHNRLYLKYSNSKLKPKHHILTHYGRLLLKN     1680
1681     GPIILTSSIRFEAKHKVLKSIANSIPCRINLGYTLAHKLQMQNVSRLLTQTGLVPDLNVG     1740
1741     KGQDISFCKELFKSFDGVIPQEIMNFSHVVSWCEYKGIYYKPGVILTLGVNLDDCFFGEV     1800
1801     KRIIIGQSKIPYFLVTTIQSVGFDRHFHAYEVLPYDNNNQIMGYYINQLPDATPSVTRVL     1860
1861     GNGKLTPSVATSTELLQSLLVDDSRIATQFRKNIRRYNNTLAFAAFSTDLNQRRLPGRGP     1920
1921     RVLTVHGQVYRRITNDVVRNDDRHPSYCELYFIESGEANRVRMNQNHQGELNETVLTDLD     1980
1981     TMLRQTNPFAMAFSNMRAVWLEEQRIANANPLVQPRRVTMHLVADLNSDPRRRGNFYEPG     2040
2041     SLNHTHARLFRSSSRYGVGGGNTFTVNADGV                                  2071