Data mining:AQL tutorial
Jump to navigationJump to search
Revision as of 03:13, 24 September 2007 by Tharris (New page: AQL search [http://www.wormbase.org/db/searches/aql_query ] is strictly dependent on current database models: one must consult the models to construct a successful query. '''Documentat...)
AQL search  is strictly dependent on current database models: one must consult the models to construct a successful query.
Documentation at AceDB web site 
WormBase AQL examples:
- Given WBGene names look up Expression Mount (Kim Mountains) the genes are located in.
select a, b, b->gene, e->mountain
from a in class pcr_product, b in a->overlaps_cds, e in a->expr_profile->expr_map where (b->gene="WBGene00005027" or b->gene="WBGene00007091") and exists e
- 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.