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 MER0346063

>MER0346063 - ADAM2 protein [M12.950] peptidase unit: 407-604 ( active site residue(s): 543 metal ligand(s): 542,546,552 ) (Ovis aries) (Source: EMBL nucleotide XM_004021871) 
1        MPWGMFTLVFLTADSETARLQITVPRKIETNTKDGSISETHVSYSIQIDKKTYTFPLEKQ       60
61       SFLDSNLLVYSYNKSRVLYPDSSFIKGHCFYQGYAIEIPNSAATLSICSGLRGLLQFENV      120
121      SYGIEPLESSTTYEHVIYPFRDKKSDFSPISENSSTTQFADQSYKILVKSNKAESRWVAA      180
181      SCIGLGAQVALTEEHTASGVWTQGSPSRPPPAVCVAVRRLLALPNRPVAMLCLLSLLLGL      240
241      TGLQTDDNSERLRVQFTVPEKIRSTSSGGVETHVSYNILIEGKTYTVNLMQKAFLPHNFR      300
301      VYGYSGTGSMKPLEQQFQNFCYYQGYIEGYPNSVAIISTCGGLRGLLQFENVSYGIEPLE      360
361      PSIGFEHMVYQVKPRDSSSSVYTEKEIEPREKPYKIQNVEPLPDFSQYIEMHIVVEKDLY      420
421      NHMGADTTIVIQKIFQLTGLTNAIFTSFNITVILSSLELWIDENKIPVTGDANELLHRFL      480
481      KWKRSYLVLRPHDVAFLLVYREKSNYIGATFQGRMCDKHYGGGVALHSNTISLESLAVII      540
541      AQLLSLSMGIPYDDINKCHCPGEVCIMNPAAVHSSGVKFFSTCSVEDFLHFISKPKSQCL      600
601      QNHPRLDPTYKAAVCGNGQVEEGEQCDCGGQQACDDKTNTCCNPGTCRFLPGSVCDTGLC      660
661      CDSCAFSPKGNICRGSVDECDLHEYCNGSSAECQEDVYIQDGHPCGQNQWLCIRGKCMDG      720
721      GKQCVELFGEGSSFAPLECFKKLNSMKDQSGNCGVTRTGFTPCRSENVKCGKIQCTYSKT      780
781      RIIYVENASVLYSNINGQRCVGLDYAYGTEGSEMMWVKDGTVCGERKVCRNKQCVDSSYL      840
841      NYDCTPEKCNNQGVCNNKKNCHCNPSYLPPNCQHPLPSWEGGSIDSGNFPPSSTGGAATL      900
901      SGPDSRYIENVYRSKPTRWPFFLFIPFFIILCVLIATLVKVYFQRKKWRTEDYTSDEQLE      960
961      SESEPKE                                                           967