Parameters Provided:
annotation.name = AROA_ECOLI
anotation.type = B10
page.format = summary
page.num = 1
filter.purchasability = purchasable
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN note AS n ON ci.sub_id_fk=n.sub_id_fk INNER JOIN annotation AS a ON n.anno_id_fk=a.anno_id WHERE c.free = 1 AND a.short_desc LIKE 'AROA\\_ECOLI' AND c.purchasable IN (1,2,4,5) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?annotation.name=AROA_ECOLI&filter.purchasability=purchasable
Embed Link to Results