Data mining:AQL tutorial

From WormBaseWiki
Jump to: navigation, search

AQL search [1] is strictly dependent on current database models: one must consult the models to construct a successful query.

Documentation at AceDB web site [2]

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

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.