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 MER0667366

>MER0667366 - family I15 unassigned peptidase inhibitors [I15.UPW] inhibitor unit: 1235-1291 (Crassostrea gigas) (Source: ProtID XP_011413224) 
1        MDLHFCELFLLVFVIGITPSKGTYNLRAGMPNVCPFQDVETRLVQVPCRQAFTRIAKVWK       60
61       PDCGKSGHWCIGHERRTQYFTTYKQDYRRFVVTKYQCCHGWQQLHSQAGCMYRQCSQTAC      120
121      LNGGRCVDGNTQRCVCPSGFQGSRCQYDVNECTKGISGCDQDCLNTMGSFQCKCRQGFRL      180
181      GRDGRTCEDINECDNGKGGCQHECHNTHGGYQCLCPVGYRLRADGRSCEAAGNVRKEKNK      240
241      LETINSFVGEFDKNGDIFQKLEQGVENRNQEKKSHDEHFNKKLAQRTRKRDELTDLASVF      300
301      KSRRLLNYQVESACRVNNGDCEQVCLEGSVRGHYRCGCREGYQLKSDSRTCELTDPCRNR      360
361      NGDCEHTCINNNGNRVCECYRGYKLSADQRHCEDINECLNNNGGCSQECANTQGSFECRC      420
421      HPGFQLGINRKSCYTSCVYEVRKTLSGTIHVPGVELEPVDSCAINNGGCAHSCRHEDGGA      480
481      VCSCRKGYILQIDRKSCLDADECGLEQACCAHHCSNNPGGYTCSCRSGFALNRNDGCSCD      540
541      DVNECLTDNGGCEQECVNKEGSFTCVCKPGYRLAPNNRGCILIDTGPHRGDIPSPLQYKA      600
601      SIRPLPLVESLKLQDELIDADIKYECVRGSFGPDCEWTCDSCQNGASCNHDNPGCLCAPG      660
661      WQGFLCNQTCPLGFYGSGCSKNCTCQNGGTCDHVTGRCTCPPGVRGESCEDGCPAGFFGK      720
721      NCDKICSTPCHSGHCNREFGYCQCPPGFVGPYCNARCPSFNWGSNCVNTCRCNRTTTDYC      780
781      NPENGKCSCKKGFHGDQCEFRCSQGHYGKNCEEKCHCNNNQSCDPENGRCYLRCAQGRMG      840
841      DSCDQICPRGSFGFNCEQKCNCHNSECSPETGRCICRAGMRGRHCNKPCRNGTWGVNCMY      900
901      ECTCKKGECDKVTGECICPDGWYGLECQNACPPNRYGFQCLLQCKCENNAMCNPTDGSCK      960
961      CKEGFRGTFCDQVCPPGTYGPDCIYRCACKNGAECDHITGECICGPGWKGVGCDEMCEPG     1020
1021     TYGAGCKEKCRCANGASCDHIGGGCTCDEGWQGKHCDKPCPQGFFGMDCRGVCNCGNNGA     1080
1081     ECNHVTGECKCSAGWTGMDCSKTCPLGTFGEGCQHQCHCGNGGTCDPVSGACVCAAGWRG     1140
1141     NHCEEECPRGFYGINCLYHCFCRNDAPCNSITGECNCTSGFTGTACEKSCYEGFYGPNCV     1200
1201     HQCKCLHGESCDKETGKCKCLPGYHGEFCDKECPQGFYGEDCDESCGCQNGASCHHVTGT     1260
1261     CTCTAGWRGRQCHRPCMRGFYGKDCMEVCRCEDDKPCDHVSGICECPPGFTGSSCQENCP     1320
1321     EGRFGEGCNKTCDCDQNSVCDPVTGRCSCRPGYSGKNCSRGKKNRKNRKARGKQRNERIS     1380
1381     VVSFENKPKVRPNSGCEEGMFGVSCENKCNCENGATCDPTTGTCMCPLGYIGPTCSEPCP     1440
1441     RGYTGQGCRHVCKCRNEATCDPENGRCLCPPGYHGDRCQFKCDENSFGKDCSGNCNCSEN     1500
1501     GRCDPVTGQCHCDLGWMGDRCDQLCPSGKFGPACVHSCVCQNNGSCDPVSGCCSCLPGFY     1560
1561     GQSCEFSCPEGTHGLYCRETCSCKNGAKCNPINGQCRCKPGYHGDNCQHMCSRGFYGSKC     1620
1621     REECQCGSSHCDHVTGECFCPVGLKGANCTNMCKQGKYGPNCEFFCDCDNQGFCDPESGA     1680
1681     CVCRGGFTGSRCQYISASSSTRRGDIPWNVHYFGRR                             1716