Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_86hgr2p6peoe66bokdh82bsi52, O_RDWR) failed: No such file or directory (2) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp/session) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109

Warning: Cannot modify header information - headers already sent by (output started at /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php:109) in /domains/zinc12/htdocs/search/results.php on line 839
Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
UCSF

No Substances to Display

BUT WAIT!

No substances matching your criteria were found.

However 25 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 = CATB_RAT
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 'CATB\\_RAT' AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results