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 MER0143783

>MER0143783 - subfamily S8B unassigned peptidases [S08.UPB] peptidase unit: 87-379 ( active site residue(s): 111,152,253,326  ) (Drosophila erecta) (Source: EMBL nucleotide CH954182) 
1        IFDDHYHFAHHKVSKRSLSPATHHQTRLDDDDRVHWAKQQRAKSRSKRDFIRMRPSRTSS       60
61       RAMSMVDAMSFNDSKWPQMWYLNRGGGLDMNVIPAWKQGITGKGVVVTILDDGLESDHPD      120
121      IQDNYDPKASYDVNSHDEDPMPHYDMTDSNRHGTRCAGEVAATANNSFCAVGIAYGASVG      180
181      GVRMLDGDVTDAVEARSLSLNPQHIDIYSASWGPDDDGKTVDGPGELASRAFIEGTTKGR      240
241      GGKGSIFIWASGNGGREQDNCNCDGYTNSIWTLSISSATEEGHVPWYSEKCSSTLATTYS      300
301      SGGQGEKQVVTTDLHHSCTVSHTGTSASAPLAAGIAALVLQSNQNLTWRDLQHIVVRTAK      360
361      PANLKDPSWSRNGVGRRVSHSFGYGLMDAAEMVRVARNWKTVPEQQRCEINAPHVDKVIP      420
421      PRTHITMQLTVNHCRSVNYLEHVQAKITLTSQRRGDIQLFLRSPANTSVTLLTPRVHDNS      480
481      RSGFNQWPFMSVHTWGESPQGNWQLEIHNEGRYMGHALLREWSLIFYGTTQSIGPNDPIS      540
541      VPRPSGSEATTPNSSSTTSNLHQAYSPQYPRIPPNNFGSSPSGGSKLPLGKVPPPNKSSY      600
601      VTNNPLLNSAPPKQGYQQISATYGVILGKANGKANNNSKEKTNTKGNKGNGNKGKSGGPG      660
661      GNRKEQTTQSTIIQTSTSKNKYYRISQQQQQKSNKQDRNGVQTQRPKANSGEKSYDEKSR      720
721      KVVGEITASSGNGSIKAAKQVKESTTSSTNSRIPKLFERYEKIQAIFPELEPYESSSPKG      780
781      KPKQAKQGKQFEVDLFRPTTGGNSRQGNTKKSPSVPPPSQTMATLSILPILPAGGSSFLP      840
841      DQKILKKQQLLMAAAGVMAPAQEVEVEMEEVPATPDYEARKDHRKEVNGANAQITQWDLI      900
901      FYGTETPAQSADVANPSQSNQFNLYGNDMAHNDVEYDSTGQWRNMQQVGEVDMTRDHSNT      960
961      AACLKWSDRKCLECNESAYMFEHLCYDVCPVHTYPLDKFQAEEDELDDEVTRGPVNPYSK     1020
1021     TATAHSPLVSNNIDDRQDPLQAEDRRRRSPLTQLVEVPSRICAACDRSCLECYGALASQC     1080
1081     SSCSPGSQLRKILNETFCYAYVVRSTGMASVVDISKMDDKDTQQYLTGTTVLLLLSVIFT     1140
1141     LMGIAVAGGVVYHRKAMARSSELYSRVSLFPGDLSDSDNEDELFTAHFPEVHKYRDEESS     1200
1201     KKISNKDEISHLVP                                                   1214