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 MER0043628

>MER0043628 - cholinesterase [S09.980] peptidase unit: 167-553 (Bactrocera oleae) (Source: EMBL nucleotide AF452052) 
1        MAHPTSLLAGASLAAASSLSSRQYSVASSSRLSGDIGRGLFAIVVLLLRMSSVYGVIDRL       60
61       VVQTSSGPVRGRSVTVQGREVHVYTGIPYAKPPLDDLRFRKPVPAEPWHGVLDATRLPAT      120
121      CVQERYEYFPGFSGEEIWNPNTNVSEDCLYINVWAPAKARLRHGRGANGGEHSNKADTDH      180
181      LIHNGNPQNITNGLPVLIWIYGGGFMTGTATLDIYNADIMSAVGNVIVASFQYRVGAFGF      240
241      LHLSPAMPGYEEEAPGNVGLWDQALAIRWLKTNAHAFGGNPEWMTLFGESAGSSSVNAQL      300
301      VSPVTAGLVKRGMMQSGTMNAPWSHMTSEKAVEIGKALINDCNCNASLLSENPQAVMACM      360
361      RAVDAKTISVQQWNSYSGILSFPSAPTIDGAFLPDHPMKMMETADLRGYDILMGNVRDEG      420
421      TYFLLYDFIDYFDKDEATSLPRDKYLEIMNNIFGKVKPAERDAIIFRHTSWVGNPGLENQ      480
481      QQIGRAVGDHFFTCPTNEYAQALAERGASVHYYYFTHRTSTSLWGEWMGVLHGDEIEYFF      540
541      GQPSNTSLQYRQVERELGKRMLNAVIEFAKTGNPATDGEEWPYFSKKDPVYYVFSTDDKE      600
601      EKLQRGPLEGRCAFWNEYLREVRKWGSQCEVKPSSASSLQQQQQHLLLQQRSIVAFMLAL      660
661      SLVLKIPSVNAFF                                                     673