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 MER0170004

>MER0170004 - family C44 non-peptidase homologues [C44.UNW] peptidase unit: 2-231 ( active site residue(s): 2  ) (Jannaschia sp. CCS1) (Source: EMBL nucleotide NC_007802) 
1        MCGIIGVLGDHEVAPILVEALKRLEYRGYDSAGIATVQNGVLDRRRAVGKLVNLSDTLVH       60
61       DPLAGKSGIGHTRWATHGGPTVTNAHPHQAGRVAVVHNGIIENYKELRDRLSHRTFVTDT      120
121      DTETVAQLCEDFLDQGLPPREAAVETLKHLDGAYALAFLFHGEEDLIVAARMGSPLAIGH      180
181      GDGEMFVGSDAIALGPMTDRITYLEEGDYAFVTRAGAEIREAHGALANRETLHVPAQAIQ      240
241      LDKGGHKHFMAKEIFEQPVVLADCLKSYSGDGRVALPEPLDFTQTDRLIFVACGTAFYAC      300
301      AVAKYWFEQLAGIPCDVDIASEFRYREPPVSSDATALFVSQSGETADTLAALRYVQEKAA      360
361      RVVSVVNVPGSSIARESDLALPILAGVEVGVASTKAFMNQLGVLANLAILAARQRGRIDA      420
421      DREAELLETLRGMPGLINQALALEGKIAKRTAKLAEAKSVLFLGRGAMYPLAMEGALKLK      480
481      EISYIHAEGYASGELKHGPIALIDKSVPVIVFAPRDALFDKTVSNMQEVMARDGKVWLIT      540
541      DADGAAQAGDGTWDTLVMPKVDPILAPMLYAVAAQLIAYHTAIHKGTDVDQPRNLAKSVT      600
601      VE                                                                602