AQL examples Supplementary materials for the poster 15: Evolution of the Carboxylesterase_B family by Chatonnet Hotelier Cousin

A) Carboxylesterase_B genes appear sporadically in bacterial and plant genomes

See the tables results of these searches in TRY it . Download a table in word format essai
The aql used for these tables are:


1) Bacteria with Carboxylesterase_B

1) select spec from a in class Gene_locus, spec in a->Species, tax in spec->Tax_id, taxname in tax->Tax_name where taxname like "bacteria", bloc in a->Block where bloc.name like "C" order by: spec

2) Gene_locus of Carboxylesterase_B from bacteria

2) select a,spec,pap from a in class Gene_locus, bloc in a->Block where bloc.name like "C", org in a->Organism where org.name like "bacteria", spec in a->Species, pap in a->Paper order by: a

3) Bacteria with complete genomes but with no Carboxylesterase_B

3) @a := select spec from a in class Gene_locus, bloc in a->Block where bloc.name like "C", org in a->Organism where org.name like "bacteria", spec in a->Species ; @b := select spec2 from a2 in class Gene_locus, org2 in a2->Organism where org2.name like "bacteria", spec2 in a2->Species where not spec2.name like "*sp.*", c in count(select spec2->Gene_locus) where c>4 ; @b diff @a order