UCSF

No Substances to Display

BUT WAIT!

No substances matching your criteria were found.

However 42 substances were found by removing the purchasability filter.

If you believe there should have been a result, please tell us what you think is missing. (Vendor ID, Compound ID, URL to where we can find the molecule on line). Thanks!

Parameters Provided:

annotation.name = ATS5_BOVIN
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 'ATS5\\_BOVIN' AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results