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 MER0241250

>MER0241250 - family I8 unassigned peptidase inhibitors [I08.UPW] inhibitor unit: 1650-1728 (Ciona intestinalis) (Source: EMBL nucleotide XM_002121617) 
1        MRDRLQELKNGMPGDMDDDDDVAVQVEADGDNMSEFFKQVEEIRGYIDVISTKVQEVKIL       60
61       HSDILSAPQTDDATNEKMEDCMADIKRNANKVRGKLKLIERNMEENSNVLPADLRMQKTQ      120
121      HSTLSRKFIHVMTEYNATQNDYRERCKARIQRQLEITGKQVSDNEIEDMLERGKDGSSAI      180
181      FTGGIIMDTQQTKQALNDIEARHNDIIKLETSIKELHDMFMDMAMLVEQQGEIIDRIEYN      240
241      VEHSVDYVERAVSDTKKAVKYQSKARRKKWMILLCCGLLVILLVITVVLAVVLSISESQN      300
301      EQRNKRNIGELDIPDSLLSIQHQSQSQVSVSCDPPCANGACVGENQCKCEEGYSGPACNE      360
361      FECTESCGHGKCVAPNTCECNTGWGGESCHTATCDDECLNGGSCSAPNTCTCLKGWSGDN      420
421      CGSAVCDVKCANGGTCDSPNVCLCKQGYQGTLCQIAQQPGCKFPFEYNGELYMTCTTVDA      480
481      TDGQPWCSTTTAFEGDKKICDFTSMCSAAGQKLEIPGECGKYYECADDMTVSVVPCPAGT      540
541      VFNALVGGCDTADNVPMCKDDASQEFEASAFEASGCPAPTHSSNVCSYWEKENFYTFDGA      600
601      LFASSGRCNYQLVSDCVGNTFDISLSFTSGGNPSLKLTSQTGVSVVVTGGKAYNEGEEIA      660
661      IPSLSNGFSLYKLPNTDYTIINSSAGFAVAWSGNDNFFIAVHNKNLVGHLCGLCGNFNGF      720
721      TVDDMVPKYGETPTTNVETLMDSWLLASGEECTTGTSTDYCGLLTTQQLSDIAKVCAEVV      780
781      TGLSFTSCNVPTSVLEETCVRDLCQCEGDYKDCLCASATHYSKLCVATGANVKEWRTDKF      840
841      CPKSCPNGMVYSECGTACPRTCKNKGLMHMCASLCVDGCFCPAGTILDVGGCVAEEECSC      900
901      SHLGEVYSSGQKRTEDCRECTCNGGSWSCTDLMCAGECSATGDPHYQTFDGSSYSFNGDC      960
961      RYVLATDSCGSGSNYTFAVVVENVKCEASDSGSCTKSATIVIKNALKETKYKLKQEGVVG     1020
1021     VDENDVTLPYTHGDISIMRLSSMMVQVKTSNGIEVDWDGEMRLYIRLDPLWRNRVCGLCG     1080
1081     NFNGKATDDMKTPQSIVETNPASFGNSWKVSSECAAVPSIPESCSANQEKIEEANQLCDV     1140
1141     IKSDVFKPCHQVVDYELHYSMCRFQQLYLMYADVVATTACVHHCPTNARKCVEKGVVIQW     1200
1201     RSNTTCGVTCESGLEYRECGGDCVSKCSTLGGIMCDRMCHPGCYCPQNLYLNDDGTCVEM     1260
1261     EKCGCIYQGVKYTAGEAMETSSTVCECKDGLMTCHDKQEAPSCEEPLVYIDCVSSSGTAC     1320
1321     QDTCQSKKTFCMAESCVAGCGCPEGTIKDENTNTCVKPDQCSCTHNGQVYEPNSVMSPDS     1380
1381     CNDCTCVEGGWSCTEMACPAECSAVGDPHFTSFDGLRYNFQGACSYVMSQDFCNNKTGGF     1440
1441     RVVVENIPCGNNGVTCTKSVTVHLYNVVIKLTKGDGEPVVSESVSIGSPAPPSGFQYNIR     1500
1501     KGSIYYIVETNNGLSVLWNKENAAKVQLQPNYMGQVCGLCGNYDGDTGNDFQTRDGDIAV     1560
1561     NPNDFGNDWKTDDTCPDGTRDPNPCLESPERAPWAEKKCAIINSEVFAECHAKVDPTHYY     1620
1621     DNCMYDTCGCNFGGDCECFCTAVAVYAQECAAAGVCINWRNNEVCPVMCEVFNPGFGSSY     1680
1681     DNETCEWKYNACGNPCPPTCDNPNPTNCPWESLEGCYVSCKDDEVWDEIKNKCIPKSECP     1740
1741     VVTTTTPVITTTTTEKTTTTTEVTTTTPEPEIITTTPEVTHPDEEITTTTPKWCNCVDSD     1800
1801     GIAHSPGETWPLRNDESLCVDLTCVEEAPGVCKTESVDTTVKCTAENKPTCLNGFPAVAV     1860
1861     TDGCSCQWECQCYCFGQGDPHFFTFDGKYYPFQGNCTFVLSRDMNEHHSNHPHDYEIWME     1920
1921     NEACPEAPETTCTRKMTIRYGPTHVVLYKNYTFTVNGGNLKHRAQMPYTFGDIRIELRGF     1980
1981     NLFYVTIPDLGITLTYTGLDYSWSLIVPYSVYFNKTEGLCGVCNNDQGDDFTTRKGTVVK     2040
2041     DIEIFGESWLVYNESKHCFKEDNKTCFPAAPECDIITSDVFKDCHALVDPEVYLKICRFD     2100
2101     TAQCGNYSYCEALYGYARICQHAGVCVDWRTDSICPMECGDDEIYMACQPNCEQTCDNFI     2160
2161     SGEQCASEEVVEGCFCPPGTVLDGGECVAEETCTDCVDADGNIFGYGESWVSENASCTIC     2220
2221     SCMEGQNVVCTNKPCSPGWTDAVPSCHSCFVPELERGSDPCCPTYKCVCNYELGKGDDEC     2280
2281     DVVTIPTCDPGYIPIQTNPGKCIPSYECTCNASRNPCPVPPTCGELEHLVSTDGECCPTH     2340
2341     KCVCNECPEKSPSCGVCQNTLTTVDKCDCKHYTCENKGVCNINGTEKLPGDSWNTDPCTT     2400
2401     CTCHETSVDNDGCYNVGCVVMSCSTYCPPCSTYTPVAGQCCGMCVQTACSVADENNSTQC     2460
2461     KPIGDHWQDLDKCISSICVANPNGHTTVTTAPITCPPVAMPTCTPCYKIATYTEDCCEKY     2520
2521     HCIPDDVCCLSGPAIKLPGETWEPDACNECQCTNNMNHTSGFHVVDCSPKPCPPFDIDDC     2580
2581     ESHGGQSALSDDGCCMHCVANVCVDAKNQTHSFGETWYPDVCTICSCVAGHEIVCNPVTC     2640
2641     PPSKQAPMNCAPCEVPLRRLSSDPCCPQYDCVCNYELIKGEPNCDAVPVPKCPPGYVASQ     2700
2701     TNVGQCIPDYDCFCNKSRNPCPEAPECPELHELVTTETECCPLYGCVCKKCNEAPTSCSP     2760
2761     CQDAITTIDACGCRHVTCQSKNICYVDDVAHLPGDIWNPDVCTQCVCQSDVTNPDTACHV     2820
2821     ESCFAQSCDPTCPPCHDYVVGAGECCGTCVQRACQVAGANGTVECKNVGDNWWYESTCEQ     2880
2881     YMCTTDNDGNIGIVEVAYACPVPEVPTCSSCYKLESYVEGCCSKLRCVQENVCCADGMGK     2940
2941     LPGSTWAPDACHLCQCTEDKDLDTGFLAEQCYHNPCPPFDSDACVANGGTVISSDDGCCL     3000
3001     KCQETECFECDKRMSTKPEYMLVDGCASNEPVSLSYCDGFCRGHYFWTDHGAENDCSCCN     3060
3061     PTSTATRVVSMKCKNGTEVQYSFTDVLSCGCTATCTPNPPTVTPAPETPAPTTTAPEAPV     3120
3121     PTTTVPVKPTPTTEETGSETGSGETTVPEAPVTTTTVPVKPTPTTEETGSGETTVPEAPV     3180
3181     TTTTVPVKPTPTTEETGSGETTVPEAPVTTTTVPVKPTPTTEETGSGETTVPEAPVTTTT     3240
3241     VPVKPTPTTEETGSGETTVPEAPVTTTTVPVKPTPTTEETGSGETTVPEAPVTTTTVPVK     3300
3301     PTPTTEETGSGETTVPEAPVTTTTVPVKPTPTTEETGSGETTVPEAPVTTTTVPVKPTPT     3360
3361     TEETGSESCYWTDWINSDKPKLPYRDDNETYPHITNNGFDICQHPQDIQCRPVGGTVAQF     3420
3421     KLYQKWQVVSCDVNNGLLCAGDQQTVHPVCEDYEIRVQCCSGSEGAHSPPEVPVDIGGGS     3480
3481     QSQSQTQTQTEGDKEVQAIAEQVQSIIEGIEQGGSSHGGSSSSGSASSGQQQSQSQTQVQ     3540
3541     DQGVQQQHQEQHQVQGGGVQVQHQEQHQSQGQSGQVQHQEQHQVQGTVNRFLGNLETAEN     3600
3601     NEQQIDDNFNNLLNQINSGEWKNNFDVQQQIQNQIQTLDQQVQQQSSVQHQAQVSAQKGL     3660
3661     EKVSNLINSAEQATGGQVPRVLGGKEHAVVEELSEQKAEDVKNEQAIQAQIKDTIHQLSS     3720
3721     AKVEGDSQLQQLVHKTISDLNQLDNNQNDLLKQEQHQLQTLLNFDDTEDLQSVVRNIQSQ     3780
3781     SQSLSSDDLAKEMNDLIN                                               3798