Data mining:AQL tutorial
From WormBaseWikiJump to navigationJump to search
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.