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 MER0097740
>MER0097740 - ADAM28 peptidase ({Homo sapiens}-type) [M12.224] peptidase unit: 526-662 ( active site residue(s): 652 metal ligand(s): 651,654,654 ) (Ornithorhynchus anatinus) (Source: EMBL nucleotide XM_001507558)
1 MLPILLFAAVSLISHTQISAISELPGAKQYEVVFPQKLHTLHKRDVKEAEEEANNKEEIY 60
61 ESEVQYHMKVQGEDIVLHLQKNKNLLSPDYTETLYSPTGERITTRPQHKEHCYYQGHIVN 120
121 EKDSTASISTCGGLRGYFKHRDQSYLIEPLKLTDQGEHAVYKYERKEPNRAKRSCGMKYS 180
181 DSKNDLIRTPRAVKSREEQDFLQSEKFIELYLVLDNALYKHHKENQTVIRTLIFDVTNLL 240
241 NVIYNTIKVHVALTGFEIWNDADKIKVVQNSGALFTNFLNWRRRDLLKRKTHDHAQFLTG 300
301 LSFNHQLTGSAASNSICLPTSVSIIEAFRKGKFSLVGVMSHELGHVLGMPDQPHTTKCPS 360
361 GSCVMNQYLSSKFPKDFSPSCRSHFEKFLLSKKPRCLLNVPAPESIVTNPICGNGILERG 420
421 EDCDCGAPEGCSNPCCEAKTCKLKSQASSPYLRPSEIALLGTPRVRQWGFFMHHNQRYQI 480
481 EPLKFTDQEEHAVFRYGDLEGGPANFTCGVKNSDWPENPFTSRLSNRQAFKEYDGNLEEI 540
541 RRTVFETANMINMIYKTIEIYVSLVGLEIWTDGDKIEVVPNASITLARFAFWRYDVLLKR 600
601 KNHDQAHLLTGVGLRYPTVGLSYMNSMCNKNSVAIIEECTDLCCNAKSCRINMWVKCNGD 660
661 CCYRCQIKKKGTLCRPAKHECDVPEVCDGRSTHCPKDQFRANGTPCHNGEGYCFGGECPT 720
721 LQDQCTALWGEGSEVGDDDCYARNQDGKEGGYCKMVKNTFVPCAKKDIKCGKIFCKGGSG 780
781 VTPLHVEVEDYLTCKTFSPTLKAQVAQLPTTGTKCDDDRAAELELKDRTAAQEKCPLLSY 840
841 H 841