Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_jifs3sh3judkdla6kegvu55954, 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
Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CNR1-3-E Cannabinoid CB1 Receptor (cluster #3 Of 5), Eukaryotic Eukaryotes 1300 0.34 Binding ≤ 10μM
CNR2-1-E Cannabinoid CB2 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 960 0.35 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
CNR2_HUMAN P34972 Cannabinoid CB2 Receptor, Human 960 0.35 Binding ≤ 1μM
CNR1_HUMAN P21554 Cannabinoid CB1 Receptor, Human 1300 0.34 Binding ≤ 10μM
CNR2_HUMAN P34972 Cannabinoid CB2 Receptor, Human 960 0.35 Binding ≤ 10μM

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) 4.84 8.05 -11.25 2 4 0 59 333.472 12

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.51 4.27 -12.52 2 4 0 59 263.337 8

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CNR1-3-E Cannabinoid CB1 Receptor (cluster #3 Of 5), Eukaryotic Eukaryotes 180 0.38 Binding ≤ 10μM
CNR2-1-E Cannabinoid CB2 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 540 0.35 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
CNR1_HUMAN P21554 Cannabinoid CB1 Receptor, Human 180 0.38 Binding ≤ 1μM
CNR2_HUMAN P34972 Cannabinoid CB2 Receptor, Human 540 0.35 Binding ≤ 1μM
CNR1_HUMAN P21554 Cannabinoid CB1 Receptor, Human 180 0.38 Binding ≤ 10μM
CNR2_HUMAN P34972 Cannabinoid CB2 Receptor, Human 540 0.35 Binding ≤ 10μM

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) 5.81 8.89 -11.88 2 4 0 59 347.499 13

Analogs

Draw Identity 99% 90% 80% 70%

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CNR2-1-E Cannabinoid CB2 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 3570 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
CNR2_HUMAN P34972 Cannabinoid CB2 Receptor, Human 3570 0.31 Binding ≤ 10μM

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) 5.34 8.89 -11.14 2 4 0 59 347.499 13

Parameters Provided:

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

Permalink

Embed Link to Results