Tree Display

AceDB Schema

XML Display

Feedback

Class Report for: AQL Queries


insecticide resistance



select m,t from m in class Mutation, g in m->Modification where g like "OP-resistance", s in m->Gene_locus->Species->Tax_id where s like "6656", t in m->Torpedo_number where not t like "*,*" order by:t

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

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

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

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

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

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









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