Class Report for: AQL Queries

Various

Authors starting with the letters Loc

select all class author where .name like "Loc*"

Participants of meetings who appear in pictures and number of pictures

select a,c from p in class participant where exists_tag p->Photo, a in class Author where a.name like p, c in count(select p->Photo) order by :a

Authors with email addresses

select a from a in class Author where exists_tag a->E_mail order by :a

Entries of genes which are compilation of large amount of very similar sequences

select g,c,d,e from g in class Gene_locus where exists_tag g->TremblExtra, c in count(select g->Trembl), d in count(select g->TremblExtra), e in count(select g->Gene_name)

papers after 2010

select a, tit, yea from a in class Paper, yea in a->Year where yea like "201*", tit in a->Title order by :yea

Authors whose name begins with C, and who have email addresses

select a from a in class Author where a.name like "C*" and exists_tag a->E_mail


Structures
Species
Genes
insecticide resistance
Interactants
Enantioselectivity or thermostability
Various
Mutations

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