UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 8.60 19.28 -18.71 2 4 0 57 514.632 6
Mid Mid (pH 6-8) 8.60 19.68 -31.78 3 4 1 59 515.64 6
Mid Mid (pH 6-8) 8.60 20.08 -87.66 4 4 2 60 516.648 6

Parameters Provided:

ring.id = 228477
filter.purchasability = annotated
page.format = targets
page.num = 1

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 hasring AS hr ON ci.sub_id_fk=hr.sub_id_fk INNER JOIN rings AS r ON hr.rings_fk=r.rings_id  WHERE r.rings_id = 228477 AND c.free = 1 AND c.purchasable = 0    LIMIT 50

Permalink

Embed Link to Results