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 MER0625299

>MER0625299 - liver carboxylesterase [S09.982] peptidase unit: 110-472 (Aplysia californica) (Source: ProtID XP_005094077) 
1        MAAAWLLHALYTSMLGSSGLQGGQGGQGGGQVGRNDVYLMANTSYGTVRGKVDFTTQVPV       60
61       AKFLGIPYAKSPTGKLRFKAPEAPDAWSGVKDAFQFGHTCMQMRYPLYTPSDMSEDCLFL      120
121      NVYTPTTKTSPGAIPVMVWIHGGGYVTGSSSLYDGTLLAAKEVIVVTINYRLDVFGFLST      180
181      GDDVIPGNYGMMDQIAALQWVRKNIGAFGGDPNQVTIFGESAGSSSVSLLTISPLSKGLF      240
241      QRAIMESGASLSPFGFQHPGNRISALTNARLIATGVMCGNLDDPKKLLSCLQNVDVQRLL      300
301      NVSVAVSKALDVNLIMCPRVEKTFGFLPDLPGTLLSRGEFNHVDTIRGFNTDETGAFIRN      360
361      LIKRPISPEVADDILHYWLKQMSSLAQEQAATILKSRYMKDELNVVNLQRDAMEAQDDFA      420
421      FIGPTIIEANEFSRRAPEKSHYLYEFNYRPSYSMYPKWMSATHSDEIGYVFGVQQLVWIY      480
481      GILPTKDDFSVSKQIMDLWTNFAKTGNPTPTVHAGSVQWNQYSATMPNYLLIKLNSQQKT      540
541      WQRPEAADVFSQVLQKLDGTRQTPVDTIIG                                    570