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 MER0306544

>MER0306544 - family C48 unassigned peptidases [C48.UPW] peptidase unit: 337-472 ( active site residue(s): 398,415,460,466  ) (Acyrthosiphon pisum) (Source: EMBL nucleotide XM_003243730) 
1        MVSCFYEASEIKQPISVPLSSHCEQVSTILAIESSKKRKENISNNSKGRGSLVTMLSKST       60
61       VNKVILTILEVIRRKIKVELGDKQFSIQVDSTQDVGSTGQAAVCIRYVFNSEVKEHLFAI      120
121      LEVKNSSGKGKKDAIKLFGLLNRLSTFFSDSYKRMNVWKEQQEQLGTGQNKLRKLKKNCN      180
181      DDNIHEEDDGNNDNLYELNTDIRTGCDKAMRKNNNGHNRDSCLLCGLKLIYLPNMHSPLF      240
241      AYLFTAIEFVLTLSMSQVNCERVFSKLKIIKNRLRSFLGNEHLEAFLLMTVEKEILDEIE      300
301      FEDILEIAEHTVYNLEPIEECEYEFEEVDNSDLFYTDEVINKYMDLITERSPDTVYAFNT      360
361      YFYKALSANGYPYVCRWTKKIDIFSKKKLFIPIHIEDHWCLVCVCLPQKSIKYYDTMGGR      420
421      NFKCLKTILKYLNFEYRDKKKKKFHPRGWLLVNVKDCPQQSYTWDCRVFVCVYAEHISRG      480
481      ASLDFSQEHIEKVRRQIPLEIKKKKLIKSEPSHLFYNEEVINEYMDLITESSPNTVYAFN      540
541      TFFYQGLSENGYSDAGRWTRRIDIFSKKKLFIPIHIEGHWILVYVCFPQKSIKYCDTMGR      600
601      RNLNCLNLILKYLKLEHHDKKGECFNTNGWSMSKKNCPQQLNTRDCGLFICMLIDYFLRG      660
661      TPLDFSQQHMDKYRRQIALEIKKKKLKKSVPSHLFYNDEVINKFMDVITERSPDTVYAFN      720
721      TFFYKALSANGYSHVSRWTKKIDIFSKQKLFIPIHIKNHWCLVYVCFPQKSIKYYDSKGG      780
781      CNMNCLKLIMDYLMFEHIDKKEEVFNPKGWLLMNVKNCPQQLNTWDCGVFVCLFAEHLSK      840
841      SIPLHFSQDHIGTFRRRIELEIKKEKLKKSVPET                                874