Tree Display

AceDB Schema

XML Display

Feedback

Class Report for: AQL Queries


Structures

select s,n,i,su from s in class Structure, n in s->Name, i in s->Inhibitor, su in s->Substrate order by :s

select g,length,f,s from g in class Gene_locus where exists g->Structure, f in g->Family, length in g->Protein->Peptide[2] where length < 190, s in g->Structure

select s,n,i,su,c,r,f from s in class Structure where exists_tag s->Family and exists_tag s->Inhibitor or exists_tag s->Substrate or exists_tag s->Reactivator or exists_tag s->Chemical, n in s->Name, i in s->Inhibitor, su in s->Substrate, c in s->Chemical, r in s->Reactivator, f in s->Family order by :f, :i, :su, :r

select f,c from f in class Family, c in count(select f->Gene_locus->Structure) order by :c desc

select s,n,d,f from s in class Structure, n in s->Name, d in s->Revelation_date, f in s->Family where exists f order by :f

select f from s in class Structure, f in s->Family order by :f

select g,f,c from g in class Gene_locus where exists_tag g->Structure, c in count(select g->Structure), f in g->family order by :f

select g,n,c,f from g in class Gene_locus, s in g->Species where s like "Homo*", n in g->Name,c in count(select g->Structure), f in g->family order by :f, :g

select g,n,c,f from g in class Gene_locus, s in g->Species where s like "Homo*", n in g->Name,c in count(select g->Structure), f in g->family order by :f, :g










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