Strain query

Hi again,
I was wondering if there is a query that I could run that would give me, for each strain, the contents of the “contains” field on the strain report page. For example:

Strain = BC4216

Contains:

Gene: dpy-17
unc-32
let-780

Allele: e189
e164
s2576

Rearrangement: sDp3

all the best,
Lisa

Hi Lisa,

You can generate a table like that with an AQL query ( http://www.wormbase.org/db/searches/aql_query ). For instance, if you want those data for a particular strain (i.e. BC4216), the query might look like this:

select a, b, b[1] from a in class strain where a=“BC4216”, b in a->contains[1]

and if you want a table containing information for all strains in WormBase, the query will be:

select a, b, b[1] from a in class strain, b in a->contains[1]

Igor.

Thanks very much Igor!
Best,
Lisa