View source for Data mining:AQL tutorial

AQL search [http://www.wormbase.org/db/searches/aql_query [1]] is strictly dependent on current database models: one must consult the models to construct a successful query.

'''Documentation at AceDB web site''' [http://www.acedb.org/Software/whelp/AQL/ [2]]

'''WormBase AQL examples:'''

* Given WBGene names look up Expression Mount (Kim Mountains) the genes are located in.

select a, b, b-&gt;gene, e-&gt;mountain
 from a in class pcr_product, b in a-&gt;overlaps_cds, e in  a-&gt;expr_profile-&gt;expr_map
 where (b-&gt;gene="WBGene00005027" or b-&gt;gene="WBGene00007091") and exists e

Notes:

* this example concerns only CDS-overlapping probes in SK moutain analysis
* this query is not very efficient and likely to crash wormbase if the list of genes are long, the preferred method is AcePerl.