Difference between revisions of "Data mining:AQL tutorial"
From WormBaseWiki
Jump to navigationJump to search (New page: 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. '''Documentat...) |
m (Protected "Data mining:AQL tutorial": migrated to new website ([edit=sysop] (indefinite) [move=sysop] (indefinite))) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 7: | Line 7: | ||
* Given WBGene names look up Expression Mount (Kim Mountains) the genes are located in. | * Given WBGene names look up Expression Mount (Kim Mountains) the genes are located in. | ||
| − | select a, b, b->gene, e->mountain | + | 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 | 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 | where (b->gene="WBGene00005027" or b->gene="WBGene00007091") and exists e | ||
| Line 15: | Line 15: | ||
* this example concerns only CDS-overlapping probes in SK moutain analysis | * 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. | * this query is not very efficient and likely to crash wormbase if the list of genes are long, the preferred method is AcePerl. | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | [[Category:User Guide]] | ||
Latest revision as of 15:09, 16 June 2011
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.
