Tree Display

AceDB Schema

XML Display

Feedback

Class Report for: AQL Queries


Species

select g,c,d,f from g in class Gene_locus where g like "myctu*", c in count(select g->Trembl), d in count(select g->TremblExtra), f in g->Family order by :f

select a,nam from a in class Gene_locus where a->Family like "*ChE",nam in a->Name

select a, fam2, nam from a in class Gene_locus, fam in a->Family->Family where fam.name like "Cholinesterase", fam2 in a->Family, tax in a->Species->Tax_id->Tax_name where tax like "Vertebrata", nam in a->Name order by :a

select a, fam, nam from a in class Gene_locus, spec in a->Species where spec.name like "Caenorhabditis*",fam in a->Family,nam in a->Name sort by : fam

select a, fam, nam from a in class Gene_locus, spec in a->Species where spec.name like "Mus musculus",fam in a->Family,nam in a->Name sort by : fam

select a, fam, nam from a in class Gene_locus, spec in a->Species where spec.name like "Homo sapiens",fam in a->Family,nam in a->Name sort by : fam

select a, fam2, nam from a in class Gene_locus, fam in a->Family->Family where fam.name like "Cholinesterase", fam2 in a->Family, tax in a->Species->Tax_id->Tax_name where tax like "Insecta", nam in a->Name order by :a

select g,s,f,b from g in class Gene_locus, t in g->Species->Tax_id->Tax_name where t like "Amoebozoa*", s in g->Species, f in g->Family, b in g->Family->Block where b like "C" order by:f

select a, fam, nam from a in class Gene_locus, spec in a->Species where spec.name like "*sapiens*", fam in a->Family, nam in a->Name order by :fam

select a, fam, nam from a in class Gene_locus, spec in a->Species where spec.name like "Drosophila*",fam in a->Family,nam in a->Name sort by : fam

select a from a in Gene_locus, where a like "*-ACHE*" or a like "*-BCHE*", n in a->Species->Tax_id->Tax_name where n like "Insecta"










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