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) -2.78 -6.57 -13.85 4 8 0 133 242.187 0
Hi High (pH 8-9.5) -2.78 -5.21 -105.64 2 8 -2 139 240.171 0
Hi High (pH 8-9.5) -2.78 -4.62 -103.97 2 8 -2 139 240.171 0

Parameters Provided:

ring.id = 197827
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 = 197827 AND c.free = 1 AND c.purchasable = 0    LIMIT 50

Permalink

Embed Link to Results