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 MER0243434

>MER0243434 - subfamily M10B unassigned peptidases [M10.UPB] peptidase unit: 41-201 ( active site residue(s): 153,190 metal ligand(s): 152,156,162 ) (Polymorphum gilvum) (Source: EMBL nucleotide NC_015259) 
1        MIQFSKAASSGSADHAAAGAGSATLASTLPVYSNDQIAHQLTDGYWNHNGYGRHSFNVAP       60
61       GGSITVDITGLTSAGRSLATQALQAWTDVTGINFAQVTGGAQITFDDNNSGAYASTWWSG      120
121      TTITQASVNISTAWLSAYGTSIDSYSFQTYVHEIGHALGLGHAGNYDGSATYGVHNHYAN      180
181      DSWQASIMSYFDQVENTSIAASYAYAITPMVADIIAIQNLYGTPTTIRAGNTVYGDGSTA      240
241      GGYLDSLTSFSRPVAVTIYDNGGFDTLNFGTVSANQTIDLRAEHVSSVRGLTGNLIIARG      300
301      TVIENAIGGSGNDTLIGNAANNILDGGAGFDTAHIGASLAGTRVTVFFEGMTLASSQGND      360
361      VLVNIEMVAFSDTTRSTASFGSSGSIYAYGASYADLITGIGGNALGLLNHYANFAAAEGR      420
421      SITFNGLSYIASHVDLIQAHGANATIGALHYISHGYGEGRTITFDGLAYIASHADLIQAH      480
481      GANATIGALHYVSHGYGEGRTTSFNGLEYIAAYADLRAAYGTNGSIGAEHYINHGFGEGR      540
541      GLRFDTRLYLGAYADLRAAYGTDINQAVTHFIQHGAAEGRSTDRFSALDYIASYGDLIAV      600
601      YGTNTAGALQHYYAHGFTEGRGDNFDGLRYIASYADLILAYGSDATQGTTHFIMHGFGEG      660
661      RSTLFDAAAYINASGNADLLAVYGSNLDGAVLHYVRHGYFEGRNLSGGGSQEAIAFSQAA      720
721      EADSFAFLDIESGQDDQDDDGSFVLTSFEDEAWAADAPADAPVDTQDFLLLAEADLGLLP      780
781      RADDDFQFM                                                         789