Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_fbmi7r58vdt7s8qsrr8uba6dr4, 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%

Popular Name: N-[(3R)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-1H-indole-2-carboxamide N-[(3R)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 104 0.32 Binding ≤ 10μM
DRD1-2-E Dopamine D1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 4630 0.24 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 3 0.38 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 3430 0.25 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 4900 0.24 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 18 0.35 Functional ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 495 0.28 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.39 0.40 Binding ≤ 1μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 104 0.32 Binding ≤ 1μM
DRD1_HUMAN P21728 Dopamine D1 Receptor, Human 4630 0.24 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.39 0.40 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 4900 0.24 Binding ≤ 10μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 104 0.32 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 29.9 0.34 Functional ≤ 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) 3.73 6.47 -13.24 3 6 0 72 461.393 7 ↓
Mid Mid (pH 6-8) 3.73 8.74 -49.21 4 6 1 73 462.401 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-1H-indole-2-carboxamide N-[(3S)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 104 0.32 Binding ≤ 10μM
DRD1-2-E Dopamine D1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 4630 0.24 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 17 0.35 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 4900 0.24 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.37 Functional ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 495 0.28 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.39 0.40 Binding ≤ 1μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 104 0.32 Binding ≤ 1μM
DRD1_HUMAN P21728 Dopamine D1 Receptor, Human 4630 0.24 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.39 0.40 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 4900 0.24 Binding ≤ 10μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 104 0.32 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 29.9 0.34 Functional ≤ 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) 3.73 6.52 -13.3 3 6 0 72 461.393 7 ↓
Mid Mid (pH 6-8) 3.73 8.75 -49.24 4 6 1 73 462.401 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-3-hydroxy-4-[4-(2-propoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide N-[(3R)-3-hydroxy-4-[4-(2-propox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4960 0.23 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 62 0.31 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.35 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 62.1 0.31 Binding ≤ 1μM
DRD1_HUMAN P21728 Dopamine D1 Receptor, Human 4960 0.23 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 62.1 0.31 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 6.51 0.35 Functional ≤ 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) 3.36 6.43 -14.84 3 7 0 81 450.583 10 ↓
Mid Mid (pH 6-8) 3.36 8.68 -50.21 4 7 1 82 451.591 10 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-3-hydroxy-4-[4-(2-propoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide N-[(3S)-3-hydroxy-4-[4-(2-propox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4960 0.23 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 62 0.31 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.35 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 62.1 0.31 Binding ≤ 1μM
DRD1_HUMAN P21728 Dopamine D1 Receptor, Human 4960 0.23 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 62.1 0.31 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 6.51 0.35 Functional ≤ 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) 3.36 6.45 -13.99 3 7 0 81 450.583 10 ↓
Mid Mid (pH 6-8) 3.36 8.71 -47.83 4 7 1 82 451.591 10 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-fluoro-N-[(3R)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide 5-fluoro-N-[(3R)-3-hydroxy-4-[4-…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 5060 0.23 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.38 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 967 0.26 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.38 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.41 0.38 Binding ≤ 1μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 967 0.26 Binding ≤ 1μM
DRD1_HUMAN P21728 Dopamine D1 Receptor, Human 5060 0.23 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.41 0.38 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 967 0.26 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.76 0.38 Functional ≤ 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) 1.65 4.77 -14.95 3 7 0 81 440.519 8 ↓
Mid Mid (pH 6-8) 1.65 7.02 -49.77 4 7 1 82 441.527 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-fluoro-N-[(3S)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide 5-fluoro-N-[(3S)-3-hydroxy-4-[4-…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 5060 0.23 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.38 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 967 0.26 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.38 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.41 0.38 Binding ≤ 1μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 967 0.26 Binding ≤ 1μM
DRD1_HUMAN P21728 Dopamine D1 Receptor, Human 5060 0.23 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.41 0.38 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 967 0.26 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.76 0.38 Functional ≤ 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) 1.65 4.8 -15.01 3 7 0 81 440.519 8 ↓
Mid Mid (pH 6-8) 1.65 7.04 -49.78 4 7 1 82 441.527 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-5-fluoro-1H-indole-2-carboxamide N-[(3R)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.38 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 24 0.33 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.61 0.38 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.61 0.38 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 23.9 0.33 Functional ≤ 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) 2.90 6.56 -13.88 3 6 0 72 479.383 7 ↓
Mid Mid (pH 6-8) 2.90 8.81 -51.02 4 6 1 73 480.391 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-5-fluoro-1H-indole-2-carboxamide N-[(3S)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.38 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 24 0.33 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.61 0.38 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.61 0.38 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 23.9 0.33 Functional ≤ 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) 2.90 6.57 -13.92 3 6 0 72 479.383 7 ↓
Mid Mid (pH 6-8) 2.90 8.83 -50.98 4 6 1 73 480.391 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide N-[(3R)-3-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 132 0.31 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 1920 0.26 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 12 0.36 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.4 0.40 Binding ≤ 1μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 132 0.31 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.4 0.40 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 1920 0.26 Binding ≤ 10μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 132 0.31 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 12.1 0.36 Functional ≤ 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) 2.48 4.7 -15.24 3 7 0 81 422.529 8 ↓
Mid Mid (pH 6-8) 2.48 6.95 -50.58 4 7 1 82 423.537 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide N-[(3S)-3-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 132 0.31 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 1920 0.26 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 12 0.36 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.4 0.40 Binding ≤ 1μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 132 0.31 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.4 0.40 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 1920 0.26 Binding ≤ 10μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 132 0.31 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 12.1 0.36 Functional ≤ 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) 2.48 4.73 -14.4 3 7 0 81 422.529 8 ↓
Mid Mid (pH 6-8) 2.48 6.98 -47.9 4 7 1 82 423.537 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-5-iodo-1H-indole-2-carboxamide N-[(3R)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.36 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 38 0.32 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 5.21 0.36 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 5.21 0.36 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 38 0.32 Functional ≤ 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.79 7.59 -12.79 3 6 0 72 587.289 7 ↓
Mid Mid (pH 6-8) 4.79 9.84 -49.76 4 6 1 73 588.297 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-5-iodo-1H-indole-2-carboxamide N-[(3S)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.36 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 38 0.32 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 5.21 0.36 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 5.21 0.36 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 38 0.32 Functional ≤ 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.79 7.6 -12.81 3 6 0 72 587.289 7 ↓
Mid Mid (pH 6-8) 4.79 9.86 -49.7 4 6 1 73 588.297 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-5-iodo-1H-indole-2-carboxamide N-[(3R)-3-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4 0.37 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 455 0.28 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 173 0.30 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 3.6 0.37 Binding ≤ 1μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 455 0.28 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 3.6 0.37 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 455 0.28 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 173 0.30 Functional ≤ 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) 3.54 5.81 -13.76 3 7 0 81 548.425 8 ↓
Mid Mid (pH 6-8) 3.54 8.06 -48.42 4 7 1 82 549.433 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-5-iodo-1H-indole-2-carboxamide N-[(3S)-3-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 4 0.37 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 455 0.28 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 173 0.30 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 3.6 0.37 Binding ≤ 1μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 455 0.28 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 3.6 0.37 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 455 0.28 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 173 0.30 Functional ≤ 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) 3.54 5.83 -13.89 3 7 0 81 548.425 8 ↓
Mid Mid (pH 6-8) 3.54 8.08 -48.43 4 7 1 82 549.433 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-5-methoxy-1H-indole-2-carboxamide N-[(3S)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.37 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.2 0.38 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.2 0.38 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.51 0.37 Functional ≤ 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) 3.76 5.81 -15.29 3 7 0 81 491.419 8 ↓
Mid Mid (pH 6-8) 3.76 8.02 -51.79 4 7 1 82 492.427 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-3-hydroxy-butyl]-5-methoxy-1H-indole-2-carboxamide N-[(3R)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.38 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.37 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.2 0.38 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.2 0.38 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.51 0.37 Functional ≤ 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) 3.76 5.76 -15.23 3 7 0 81 491.419 8 ↓
Mid Mid (pH 6-8) 3.76 8.02 -51.83 4 7 1 82 492.427 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3S)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-5-methoxy-1H-indole-2-carboxamide N-[(3S)-3-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.37 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 1530 0.25 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.37 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.32 0.37 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.32 0.37 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 1530 0.25 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.58 0.37 Functional ≤ 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) 2.51 4.02 -16.31 3 8 0 90 452.555 9 ↓
Mid Mid (pH 6-8) 2.51 6.24 -50.59 4 8 1 91 453.563 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R)-3-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-5-methoxy-1H-indole-2-carboxamide N-[(3R)-3-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.37 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 1530 0.25 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.37 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.32 0.37 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 2.32 0.37 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 1530 0.25 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 1.58 0.37 Functional ≤ 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) 2.51 3.98 -16.23 3 8 0 90 452.555 9 ↓
Mid Mid (pH 6-8) 2.51 6.24 -50.6 4 8 1 91 453.563 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-2-hydroxy-butyl]-1H-indole-2-carboxamide N-[(2R)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 58 0.33 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 1040 0.27 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 26 0.34 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.26 0.43 Binding ≤ 1μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 58.3 0.33 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.26 0.43 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 1040 0.27 Binding ≤ 10μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 58.3 0.33 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 25.7 0.34 Functional ≤ 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) 3.73 8.67 -47.94 4 6 1 73 462.401 7 ↓
Mid Mid (pH 6-8) 3.73 6.45 -11.13 3 6 0 72 461.393 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S)-4-[4-(2,3-dichlorophenyl)piperazin-1-yl]-2-hydroxy-butyl]-1H-indole-2-carboxamide N-[(2S)-4-[4-(2,3-dichlorophenyl…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 58 0.33 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
DRD4-4-E Dopamine D4 Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 1040 0.27 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 26 0.34 Functional ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.26 0.43 Binding ≤ 1μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 58.3 0.33 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.26 0.43 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 1040 0.27 Binding ≤ 10μM
5HT1A_HUMAN P08908 Serotonin 1a (5-HT1a) Receptor, Human 58.3 0.33 Binding ≤ 10μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 25.7 0.34 Functional ≤ 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) 3.73 8.61 -48.27 4 6 1 73 462.401 7 ↓
Mid Mid (pH 6-8) 3.73 6.4 -11.34 3 6 0 72 461.393 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2S)-2-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide N-[(2S)-2-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 176 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.51 0.42 Binding ≤ 1μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 176 0.31 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.51 0.42 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 176 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) 2.48 6.83 -46.26 4 7 1 82 423.537 8 ↓
Mid Mid (pH 6-8) 2.48 4.63 -11.81 3 7 0 81 422.529 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(2R)-2-hydroxy-4-[4-(2-methoxyphenyl)piperazin-1-yl]butyl]-1H-indole-2-carboxamide N-[(2R)-2-hydroxy-4-[4-(2-methox…

Find On: PubMed — Wikipedia — Google

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
DRD4-2-E Dopamine D4 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 176 0.31 Binding ≤ 10μM
ChEMBL Target Annotations
Uniprot Swissprot Description Affinity (nM) LE (kcal/mol/atom) Type
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.51 0.42 Binding ≤ 1μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 176 0.31 Binding ≤ 1μM
DRD3_HUMAN P35462 Dopamine D3 Receptor, Human 0.51 0.42 Binding ≤ 10μM
DRD4_HUMAN P21917 Dopamine D4 Receptor, Human 176 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) 2.48 6.88 -47.94 4 7 1 82 423.537 8 ↓
Mid Mid (pH 6-8) 2.48 4.68 -12.08 3 7 0 81 422.529 8 ↓

Parameters Provided:

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

Permalink

//zinc12.docking.org/results/combination?ring.id=470260&filter.purchasability=annotated

Embed Link to Results