ESTHER Database

Home
Search
Tools
Families
Biological
data
Basics on AChE
ESTHER definition
What is up?
Acknowledgments
& disclaimer


AQL insecticide resistance - ESTHER Database

These queries work on the ESTHER Server. Only a small subset of classes are used in order to simplify matters. It is essential to know the class model of any class before writing a query. See the different class with MODEL

Listing objects using conditions on tags and object names

1. List of mutations

The List of mutation in carboxylesterases (Block C, not necessarily natural or related to insecticide resistance)
select m from g in class Gene_locus, m in g->Mutation, f in g->Block where f like "C"
CLICK HERE
Same table with genes and ordered by genes
select m,g from g in class Gene_locus where exists_tag g->Mutation, m in g->Mutation, f in g->Block where f like "C" order by :g
CLICK HERE
If you only want to have the number
select count (select m from g in class Gene_locus, m in g->Mutation, f in g->Block where f like "C")
CLICK HERE
Or only a list of protein
select g from g in class Gene_locus where exists_tag g->Mutation, m in g->Mutation, f in g->Block where f like "C"
CLICK HERE
Or only enzymes (carboxylesterases cholinesterases but not neuroligins for example)
select g from g in class Gene_locus where exists_tag g->Mutation, m in g->Mutation, f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase"
CLICK HERE
and the corresponding mutations
select m from g in class Gene_locus where exists_tag g->Mutation, m in g->Mutation, f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase"
CLICK HERE
Or only cholinesterases or carboxylesterases of "insects" with mutations
select g,s from g in class Gene_locus where exists_tag g->Mutation, m in g->Mutation, f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase", s in g->Species, t in s->Tax_id where t like "50557" order by :s
CLICK HERE
Or only cholinesterases or carboxylesterases of "arthropods" with mutations (including acaria)
select g,s from g in class Gene_locus where exists_tag g->Mutation, m in g->Mutation, f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase", s in g->Species, t in s->Tax_id where t like "6656" order by :s
CLICK HERE
Torpedo numbers of natural mutations related to insecticide resistance (organophosphates carbamates and pyretrenoids) in carboxylesterases and cholinesterases
select x from g in class Gene_locus, m in g->Mutation,n in m->Modification where n like "OP-*" or n like "ins*" or n like "Pyr*", f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase" or f like "Cholinesterase-like", s in g->Species, t in s->Tax_id where t like "33208", u in m->Mode_of_mutation where u like "Nat*", x in m->Torpedo_number order by :x
CLICK HERE
Torpedo numbers of natural mutations related to insecticide resistance (organophosphates carbamates and pyretrenoids) with number of species or genes in which this position was found or analysed
select x,c from g in class Gene_locus, m in g->Mutation,n in m->Modification where n like "OP-*" or n like "ins*" or n like "Pyr*", f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase" or f like "Cholinesterase-like", s in g->Species, t in s->Tax_id where t like "33208", u in m->Mode_of_mutation where u like "Nat*", x in m->Torpedo_number, c in count(select x->Mutation->Gene_locus) order by :x
CLICK HERE
Species in which natural mutations related to insecticide resistance have been described
select s from g in class Gene_locus, m in g->Mutation,n in m->Modification where n like "OP-*" or n like "ins*" or n like "Pyr*", f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase" or f like "Cholin*", s in g->Species, t in s->Tax_id where t like "33208", u in m->Mode_of_mutation where u like "Nat*" order by :s
CLICK HERE
Same liste of species but with number of mutations and number of positions (Torpedo_number)
select s,g,c,c2 from m in class Mutation, g in m->Gene_locus,n in m->Modification where n like "OP-*" or n like "ins*" or n like "Pyr*", f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase" or f like "Cholin*", s in g->Species, t in s->Tax_id where t like "33208", u in m->Mode_of_mutation where u like "Nat*", c in count(select g->Mutation), c2 in count(select g->Mutation->Torpedo_number) order by :s
CLICK HERE
Liste of papers reporting analysis of natural mutations in carboxyl/cholinesterases related to insecticide resistance.
select p,g,s from m in class Mutation, g in m->Gene_locus,n in m->Modification where n like "OP-*" or n like "ins*" or n like "Pyr*", f in g->Family where f like "AChE" or f like "BuChE" or f like "Carboxylesterase" or f like "Cholin*", s in g->Species, t in s->Tax_id where t like "33208", u in m->Mode_of_mutation where u like "Nat*", p in m->Paper order by :p
CLICK HERE
Table of natural mutations in arthropods ordered by Torpedo numbers
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 "*bacdo*" or mut like "*anica*" or mut like "*bemta*" or mut like "*boomi*" or mut like "*cerca*" or mut like "*9neop*" or mut like "*cultr*" or mut like "*cydpo*" or mut like "*colho*" or mut like "*haeir*" or mut like "*luccu*" or mut like "*rhopd*" or mut like "*sitav*" 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 :top
CLICK HERE

2. Find

We can design AQL queries for you.


Queries designed by Arnaud Chatonnet.
INRA Montpellier, 22/Feb/2010
arnaud.chatonnet@inra.fr

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