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 MER0234792

>MER0234792 - family U69 unassigned peptidases [U69.UPW] peptidase unit: 376-570 (Mesorhizobium ciceri) (Source: EMBL nucleotide NC_014923) 
1        MCVADARDPTQRQAMIFAGRSAIGPAAESLLAAHGGNSMTIRDRRSLIRPLVLLCSTALA       60
61       GSLLLPVILTAPAHAQALYGATGGGGGDGDVDSNGGDGGDAGDAGVAGNGPDAGTGGAAG      120
121      TQAIPDGGNGDNGGSGGGGGGGGGGGGGYSNIIAGDISAPLNGGNGGYGGGFLDGGYGGG      180
181      GAGGDGVRNEEVNPAISVTADVHGGDGGDGNGNGPFAGGGGGGGGGGAGMVLLNNGAITV      240
241      ESSATVAGGNGGNPGANFGGGGGAGIVLNAGGDLTNHGDVLGGTGGALATGGTAIVMGDS      300
301      GSIVNDGRITGGRAGVSASAGAAIDLRNGGTVFNSGVIIGGEGNGGHAGGSNGPAGGTGS      360
361      GGAPGYIPLTPSNGNGGTGIVGANLAVLNVGEITGGDSFFGRANAITFTGGANTLSLRNG      420
421      SIITGNVVVESGATGSLMLGDYDTLPSTPAFDVSKLVNTATVGASDEFVGFTSFNKAGTN      480
481      TVTLTGTGAQDWTIDQGTLVGDTNSFGGNLTFSGVNTGAVVFDQASDGTYAGTITGPGHF      540
541      GKAGAGTLTLSGDASDLAGNLGVMGGTLDIDTQLTSFTGIIATDGTDPDEWATARVSGSA      600
601      TWTADVLRVGDSNGDSKGKGSLIVENGGQVFNDSGVVAYGAGSTGSAVISGNDSGWTLVD      660
661      AIAVGLFGNGSLSIENGGQVSSGNNAIVGWDAQATGIVNITGPGSVWTGDSIIAVGVLGK      720
721      GTLTLSEGGQVSLAGGPAIVGLAAQPGSFGTLNIGAASGEVAKAAGTVDAASIAFGAGTG      780
781      TVVFNHLGNPDGSDLIFSPSLTGLGTILHESGTTVLAADSSSFTGATTVAGGTLLVGNHA      840
841      SAGFLGGTINVEDGATLGGSGTVGTTTVADGGHIAPGNSVGTLTVAGNLGLSSGSILDYE      900
901      FGNPGGSTDSPGISDRIGVSGNLTLDGTLNLAQSGDVADGTAGLGYYRLMTYGGSLTDNG      960
961      LEIGTKPPLSDPAAYEIHAGGGNVDLFIGAAGDDTLQHWQGGDGTWNTTNEKWLNQGGDT     1020
1021     LVSWAGNHAVFKNEPGGFDGGTIAVEGAQSFKGLQFVDSGYRLEGSGTLAIDGSDSADGN     1080
1081     AEIRVLAGTAATIATTITGAGGVSKTQGGTLVLEGSNSYQGGTRLLGGIISVSSDANLGA     1140
1141     ASGALTFDGGTLRNTAAFATARNVTLDAGGGTFQTDADLTANGVISGTGALTKTGAGGLV     1200
1201     LSSANSYAGGTTVSAGFITAATTGALGSGPVNVKAGDLRFINDASAESLDIVMETNATMR     1260
1261     FDGSASAGTATIVTTQSRINFNDETSAGAASITGNGSRTSFNGNSSAANATIGVTIQGTL     1320
1321     DFYDTASAGSAAITNKGGFVGFHGANTADGAAIINDTGGKVDISEMTSDGIAIGSLSGDG     1380
1381     LVFLGSKSLTLGGLDKNDTIGGVIQDGSTGIGGSLVKTGAGTLTLNGVSTYTGLTTIGGG     1440
1441     KLVVDDGSHSGASIAGAIAVAAGGTLGGSGTVGTTTIAYGGTITPGNSIGTLNVSGDYTQ     1500
1501     EIGSTYEVEINPAGNSDLIDVTGKATIQGGTVFALKAPGGYSAGTRYTILSADQGVTGTY     1560
1561     DAFDQNAPFVDLALAYDASNIYLDVARNDVSFCDVAGTRNQCATANGAESAGPGNPIYDA     1620
1621     IAGLPDDETAREAFDALSGEIHASAKSALIEDSHFVRNAINDRLRAAFEGVGIPAIPVLA     1680
1681     YGEGGPVLAPATTDRFAAWGTAFGSWGTFDGDGNAAGLDTSTGGFLTGVDGLVVEDVRLG     1740
1741     IMTGYSHTSFDADGRSSSGSSDNYHLGLYGGTQRGALAFRSGLAYTWHDMKTSRSVAMPG     1800
1801     FADSLSGDYNAGTFQAFGELGYRIDTPVAAFEPFANLAYVNLHTDGFTEKGGAAALTSAS     1860
1861     QTTDATFTTLGLRASAGFTLGAINATARGMLGWRHAYGDVIPTSTHAFSAGDAFTIAGVP     1920
1921     IAKDSAAIEAGLDLNLTDAATLSVAYQGQFGSGVQQNGFNAKLNVEF                  1967