for example to search all human alpha/beta hydrolase found in human genome enter this search in the window below: select a, fam, nam, c from a in class Gene_locus, spec in a->Species where spec.name like "Homo sapiens", fam in a->Family, nam in a->Name, c in count(select a->Structure) sort by: fam, :nam for more examples from esther go to AQL esther for examples from esther on insecticide resistance go to AQL esther resistance for more examples from wormbase go to AQL wormbase AQL for the supplementary material of the Pucon Poster Pucon Poster select top, mut, sp from mut in class Mutation where mut like "*lepde*" or mut like "*drome*" or mut like "*musdo*" or mut like "*tetur*" or mut like "*tetka*" or mut like "*myzpe*"or mut like "*caeel*" or mut like "*culpi*" or mut like "*anoga*" or mut like "*bacol*" or mut like "*pluxy*" or mut like "*aphgo*" or mut like "*cydpo*", top in mut->Torpedo_number, md in mut->Mode_of_mutation where md like "*Natural*", sp in mut->Gene_locus->Species order by :topHTML outputText output   127 rows returned Mutation Species T682A_culpi-ACHE1 Culex pipiens -6 R30K_lepde-ACHE Leptinotarsa decemlineata -6 R30K/S291G_lepde-ACHE Leptinotarsa decemlineata -6,238 R30K/S291G_lepde-ACHE Leptinotarsa decemlineata 19 K14Q/N354D_aphgo-cxest Aphis gossypii 19,376 K14Q/N354D_aphgo-cxest Aphis gossypii 57 V185M_culpi-ACHE1 Culex pipiens 78 F115S_drome-ACHE Drosophila melanogaster 78 F115S/I199V/G303A/F368Y_drome-ACHE Drosophila melanogaster 78 F139L_aphgo-ACHE2 Aphis gossypii 78,129,227,290 F115S/I199V/G303A/F368Y_drome-ACHE Drosophila melanogaster 83 I82M_musdo-ACHE Musca domestica 83 I82M/G262A/F327Y_musdo-ACHE Musca domestica 83,227,290 I82M/G262A/F327Y_musdo-ACHE Musca domestica 116,141,355,491 H104R/A128V/T333P/K484R_aphgo-cxest Aphis gossypii 119 G137D_musdo-EST23aes07 Musca domestica 119 G119S/A280T/F331W_tetur-ACHE Tetranychus urticae 119 G119S/A280T_tetur-ACHE Tetranychus urticae 119 G119S/F331W_tetur-ACHE Tetranychus urticae 119 G119S_tetur-ACHE Tetranychus urticae 119 G221A_aphgo-ACHE1 Aphis gossypii 119 G119S_culpi-ACHE1 Culex pipiens 119 G119S_anoga-ACHE1 Anopheles gambiae 119,280 G119S/A280T_tetur-ACHE Tetranychus urticae 119,280,331 G119S/A280T/F331W_tetur-ACHE Tetranychus urticae 119,331 G119S/F331W_tetur-ACHE Tetranychus urticae 129 F115S/I199V/G303A/F368Y_drome-ACHE Drosophila melanogaster 129 I199V/G303A_drome-ACHE Drosophila melanogaster 129 I199T/G303A_drome-ACHE Drosophila melanogaster 129 I159V_musdo-ACHE Musca domestica 129 I214V_bacol-ACHE Bactrocera oleae 129 I214V/G488S_bacol-ACHE Bactrocera oleae 129,227 I199V/G303A_drome-ACHE Drosophila melanogaster 129,227 I199T/G303A_drome-ACHE Drosophila melanogaster 129,396 I214V/G488S_bacol-ACHE Bactrocera oleae 131 D131G_pluxy-ACHE1 Plutella xylostella 133 E163K_musdo-ACHE Musca domestica 136 A136T_culpi-ACHE1 Culex pipiens 150 V180L/G262A_musdo-ACHE Musca domestica 150 V180L/G262A/F327Y_musdo-ACHE Musca domestica 150 V180L/G262A/F327Y/D341L_musdo-ACHE Musca domestica 150 V180L_musdo-ACHE Musca domestica 150,227 V180L/G262A_musdo-ACHE Musca domestica 150,227,290 V180L/G262A/F327Y_musdo-ACHE Musca domestica 150,227,290,304 V180L/G262A/F327Y/D341L_musdo-ACHE Musca domestica 195 T230M/G262V/F327Y/A586T_musdo-ACHE Musca domestica 195 T230M_musdo-ACHE Musca domestica 201 A201S_pluxy-ACHE1 Plutella xylostella 201 A302S_aphgo-ACHE1 Aphis gossypii 201 A201S_tetur-ACHE Tetranychus urticae 201 A302S/S431F_aphgo-ACHE1 Aphis gossypii 201 A328S_culpi-ACHE1 Culex pipiens 201 A236S_musdo-ACHE Musca domestica 224,306,428,447 T210M/N294K/G408D/S441F_aphgo-cxest Aphis gossypii 227 F115S/I199V/G303A/F368Y_drome-ACHE Drosophila melanogaster 227 I199V/G303A_drome-ACHE Drosophila melanogaster 227 I199T/G303A_drome-ACHE Drosophila melanogaster 227 G303A_drome-ACHE Drosophila melanogaster 227 G227A_pluxy-ACHE1 Plutella xylostella 227 V180L/G262A_musdo-ACHE Musca domestica 227 V180L/G262A/F327Y_musdo-ACHE Musca domestica 227 V180L/G262A/F327Y/D341L_musdo-ACHE Musca domestica 227 G262A/F327Y_musdo-ACHE Musca domestica 227 G262V/F327Y_musdo-ACHE Musca domestica 227 T230M/G262V/F327Y/A586T_musdo-ACHE Musca domestica 227 G262A_musdo-ACHE Musca domestica 227 G262V_musdo-ACHE Musca domestica 227 I82M/G262A/F327Y_musdo-ACHE Musca domestica 227,290 G262A/F327Y_musdo-ACHE Musca domestica 227,290 G262V/F327Y_musdo-ACHE Musca domestica 232 S250T_musdo-EST23aes07 Musca domestica 233 W251L_musdo-EST23aes07 Musca domestica 233 W251S_musdo-EST23aes07 Musca domestica 233 W251C_musdo-EST23aes07 Musca domestica 238 S291G_lepde-ACHE Leptinotarsa decemlineata 238 S291G/I392T_lepde-ACHE Leptinotarsa decemlineata 238 R30K/S291G_lepde-ACHE Leptinotarsa decemlineata 238,337 S291G/I392T_lepde-ACHE Leptinotarsa decemlineata 257 D273E_musdo-EST23aes07 Musca domestica 262 A391T_culpi-ACHE1 Culex pipiens 280 G119S/A280T/F331W_tetur-ACHE Tetranychus urticae 280 G119S/A280T_tetur-ACHE Tetranychus urticae 280 A280T/F331W_tetur-ACHE Tetranychus urticae 280 A280T_tetur-ACHE Tetranychus urticae 280,331 A280T/F331W_tetur-ACHE Tetranychus urticae 287 M303I_musdo-EST23aes07 Musca domestica 290 F115S/I199V/G303A/F368Y_drome-ACHE Drosophila melanogaster 290 F368Y_drome-ACHE Drosophila melanogaster 290 F399V_cydpo-ACHE1 Cydia pomonella 290 F386V_pluxy-ACHE1 Plutella xylostella 290 V180L/G262A/F327Y_musdo-ACHE Musca domestica 290 V180L/G262A/F327Y/D341L_musdo-ACHE Musca domestica 290 G262A/F327Y_musdo-ACHE Musca domestica 290 G262V/F327Y_musdo-ACHE Musca domestica 290 T230M/G262V/F327Y/A586T_musdo-ACHE Musca domestica 290 F327Y_musdo-ACHE Musca domestica 290 F368A_drome-ACHE Drosophila melanogaster 290 F290V_culpi-ACHE1 Culex pipiens 290 I82M/G262A/F327Y_musdo-ACHE Musca domestica 304 V180L/G262A/F327Y/D341L_musdo-ACHE Musca domestica 328 G365A_musdo-ACHE Musca domestica 328 G328A_tetur-ACHE Tetranychus urticae 330 L354F_musdo-EST23aes07 Musca domestica 331 G119S/A280T/F331W_tetur-ACHE Tetranychus urticae 331 G119S/F331W_tetur-ACHE Tetranychus urticae 331 A280T/F331W_tetur-ACHE Tetranychus urticae 331 F331C_tetur-ACHE Tetranychus urticae 331 F331W_tetur-ACHE Tetranychus urticae 331 F331Y_tetur-ACHE Tetranychus urticae 331 S431F_myzpe-ACHEm Myzus persicae 331 S431F_aphgo-ACHE1 Aphis gossypii 331 A302S/S431F_aphgo-ACHE1 Aphis gossypii 333 S357L_musdo-EST23aes07 Musca domestica 337 S291G/I392T_lepde-ACHE Leptinotarsa decemlineata 337 I392T_lepde-ACHE Leptinotarsa decemlineata 339 A365V_musdo-EST23aes07 Musca domestica 353 W378R_musdo-EST23aes07 Musca domestica 358 S383T_musdo-EST23aes07 Musca domestica 373 I396V_musdo-EST23aes07 Musca domestica 376 K14Q/N354D_aphgo-cxest Aphis gossypii 396 G488S_bacol-ACHE Bactrocera oleae 396 I214V/G488S_bacol-ACHE Bactrocera oleae 441 A441G_pluxy-ACHE1 Plutella xylostella 551 Q642-644del_bacol-ACHE Bactrocera oleae 551,553,554 Q642-644del_bacol-ACHE Bactrocera oleae 553 Q642-644del_bacol-ACHE Bactrocera oleae 554 Q642-644del_bacol-ACHE Bactrocera oleae

Send your questions or comments to :Mail to: Nicolas Lenfant, Thierry Hotelier, Yves Bourne, Pascale Marchot and Arnaud Chatonnet.Please cite: Lenfant 2013 Nucleic.Acids.Res. or Marchot Chatonnet 2012 Prot.Pept Lett. For technical information about these pages see: ESTHER Home Page and ACEDB Home Page AcePerl Lincoln Stein Home Page webmaster Acknowledgements and disclaimer