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 MER0342407
>MER0342407 - subfamily M10B unassigned peptidases [M10.UPB] peptidase unit: 83-198 ( active site residue(s): 152,190 metal ligand(s): 151,155,161 ) (Pseudomonas sp. Ag1) (Source: EMBL nucleotide NZ_AKVH01000096)
1 MNVFDAISIRPMLQNLPESDPGPTGFGAKAKPTYTTDQAGKQISRDNLRFHDRNGDMKVD 60
61 LSYTVDPSFTAQQQQRVRQAVQSWQDVANINLKEQADGADGTVNIKNNPRGDRGVATSPT 120
121 RSNTSTTATIGTLKAGSRPGLGSHFSVTAVHEIGHAIGLQHPGNYNGGGSAYNSGAVYAG 180
181 DTKARSVMSYWSEKNQAGHDFQSSNPSAPMMDDIAAAQRLYGANHQTRNTDTTYGFNSNT 240
241 EREAMTLKSATDKPVFCVWDGGGDDTLDFSGFSQNQKINLNAESFSDVGGLKGNVSIAKG 300
301 CTIENATGGAGRDTLIGNEAGNRLKGGAGADTLRGGGGADMFIYDKASDSTPQDPDLIED 360
361 FTSGTDKIDLSGALKEAGVGTLVFTDRFTGRAGEALLKYDAATGRSSLEVDLNGSGKAEL 420
421 LINSVGQIKSTDVQWAGATPGFKPVPLPMPNVVPSPAPPPEPDSKTTTLAVLNEMIAKTL 480
481 STLLQLLKGLLQQPGAPG 498