UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

120294
120294
2046798
2046798

Draw Identity 99% 90% 80% 70%

Popular Name: Progesterone Progesterone

Find On: PubMed — Wikipedia — Google

Vendors

And 26 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 37 0.45 Binding ≤ 10μM
ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 5), Eukaryotic Eukaryotes 4 0.51 Binding ≤ 10μM
ESR2-2-E Estrogen Receptor Beta (cluster #2 Of 4), Eukaryotic Eukaryotes 4 0.51 Binding ≤ 10μM
FABPL-1-E Fatty Acid-binding Protein, Liver (cluster #1 Of 4), Eukaryotic Eukaryotes 27 0.46 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 31 0.46 Binding ≤ 10μM
MCR-1-E Mineralocorticoid Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 14 0.48 Binding ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 3 0.52 Binding ≤ 10μM
S5A1-1-E Steroid 5-alpha-reductase 1 (cluster #1 Of 2), Eukaryotic Eukaryotes 2600 0.34 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 2600 0.34 Binding ≤ 10μM
SGMR1-2-E Sigma Opioid Receptor (cluster #2 Of 6), Eukaryotic Eukaryotes 260 0.40 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 37 0.45 Functional ≤ 10μM
ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 10000 0.30 Functional ≤ 10μM
ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 10000 0.30 Functional ≤ 10μM
GPBAR-2-E G-protein Coupled Bile Acid Receptor 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 2770 0.34 Functional ≤ 10μM
MCR-2-E Mineralocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 30 0.46 Functional ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 3 0.52 Functional ≤ 10μM
CP2C9-2-E Cytochrome P450 2C9 (cluster #2 Of 3), Eukaryotic Eukaryotes 5500 0.32 ADME/T ≤ 10μM
ERG2-1-F C-8 Sterol Isomerase (cluster #1 Of 2), Fungal Fungi 4430 0.33 Binding ≤ 10μM
Z50425-4-O Plasmodium Falciparum (cluster #4 Of 22), Other Other 6310 0.32 Functional ≤ 10μM
Z80712-1-O T47D (Breast Carcinoma Cells) (cluster #1 Of 7), Other Other 1 0.55 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.81 10.64 -9.9 0 2 0 34 314.469 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: MEDROXYPROGESTERONE ACETATE MEDROXYPROGESTERONE ACETATE

Find On: PubMed — Wikipedia — Google

Vendors

And 22 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 3 0.43 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 6 0.41 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 6 0.41 Binding ≤ 10μM
ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 5), Eukaryotic Eukaryotes 924 0.30 Binding ≤ 10μM
ESR2-2-E Estrogen Receptor Beta (cluster #2 Of 4), Eukaryotic Eukaryotes 924 0.30 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 13 0.39 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 13 0.39 Binding ≤ 10μM
MCR-1-E Mineralocorticoid Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1197 0.30 Binding ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 6 0.41 Functional ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 6 0.41 Functional ≤ 10μM
ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 924 0.30 Functional ≤ 10μM
ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 924 0.30 Functional ≤ 10μM
ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 924 0.30 Functional ≤ 10μM
ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 924 0.30 Functional ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.40 Functional ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.40 Functional ≤ 10μM
MCR-2-E Mineralocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 1197 0.30 Functional ≤ 10μM
MCR-2-E Mineralocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 1197 0.30 Functional ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 0 0.00 Functional ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 1 0.45 Functional ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 10000 0.25 Functional ≤ 10μM
Z80712-2-O T47D (Breast Carcinoma Cells) (cluster #2 Of 2), Other Other 11 0.40 Binding ≤ 10μM
Z80712-1-O T47D (Breast Carcinoma Cells) (cluster #1 Of 7), Other Other 0 0.00 Functional ≤ 10μM
Z80712-1-O T47D (Breast Carcinoma Cells) (cluster #1 Of 7), Other Other 1 0.45 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.04 11.72 -14.72 0 4 0 60 386.532 3 ↓

Analogs

3874177
3874177
3874178
3874178

Draw Identity 99% 90% 80% 70%

Popular Name: Medroxyprogesterone 17-acetate Medroxyprogesterone 17-acetate

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 6 0.41 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 0 0.00 Functional ≤ 10μM
Z80712-1-O T47D (Breast Carcinoma Cells) (cluster #1 Of 7), Other Other 0 0.00 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.04 3.87 -14.13 0 4 0 60 386.532 3 ↓

Analogs

897408
897408

Draw Identity 99% 90% 80% 70%

Popular Name: BICALUTAMIDE BICALUTAMIDE

Find On: PubMed — Wikipedia — Google

Vendors

And 40 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-4-E Androgen Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 11 0.38 Binding ≤ 10μM
ANDR-4-E Androgen Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 670 0.30 Binding ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 7200 0.25 Binding ≤ 10μM
Q5EM59-1-E Androgen Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 940 0.29 Binding ≤ 10μM
ANDR-3-E Androgen Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 270 0.32 Functional ≤ 10μM
ANDR-3-E Androgen Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 890 0.29 Functional ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1819 0.28 Functional ≤ 10μM
Z80243-1-O MDA-MB-453 (Breast Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 173 0.33 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 870 0.29 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 1000 0.29 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.15 4.05 -16.95 2 6 0 107 430.379 6 ↓

Analogs

538564
538564

Draw Identity 99% 90% 80% 70%

Popular Name: BICALUTAMIDE BICALUTAMIDE

Find On: PubMed — Wikipedia — Google

Vendors

And 30 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-4-E Androgen Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 365 0.31 Binding ≤ 10μM
ANDR-4-E Androgen Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 670 0.30 Binding ≤ 10μM
PRGR-2-E Progesterone Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 7200 0.25 Binding ≤ 10μM
Q5EM59-1-E Androgen Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 940 0.29 Binding ≤ 10μM
ANDR-3-E Androgen Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 890 0.29 Functional ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1819 0.28 Functional ≤ 10μM
Z80243-1-O MDA-MB-453 (Breast Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 173 0.33 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 1000 0.29 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.15 4.04 -16.77 2 6 0 107 430.379 6 ↓

Analogs

517860
517860
3979064
3979064
3979065
3979065
3979066
3979066
4217041
4217041

Draw Identity 99% 90% 80% 70%

Popular Name: Testosterone propionate Testosterone propionate

Find On: PubMed — Wikipedia — Google

Vendors

And 20 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 3 0.48 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.31 11.97 -10.89 0 3 0 43 344.495 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: BMS-564929 BMS-564929

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-1-E Androgen Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 2 0.58 Binding ≤ 10μM
ANDR-1-E Androgen Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 0 0.00 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.33 -1.19 -16.06 1 6 0 84 305.721 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 17 beta-N,N-diethylcarbamoyl-4-methyl-4-aza-5 alpha-androstan-3-one; 17-N,N-diethyl-4-methyl-3-oxo-4-azaandrostane-17-carboxamide; 17-N,N-diethylcarbamoyl-4-methyl-4-azaandrostane-3-one; 17-beta-N,N-Diethylcarbamoyl-4-methyl-4-aza-5-alpha-androstan-3-one 17 beta-N,N-diethylcarbamoyl-4-m…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
3BHS1-2-E 3-beta-hydroxysteroid Dehydrogenase/delta 5-->4-isomerase Type I (cluster #2 Of 2), Eukaryotic Eukaryotes 20 0.38 Binding ≤ 10μM
3BHS2-1-E 3-beta-hydroxysteroid Dehydrogenase/delta 5-->4-isomerase Type II (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.38 Binding ≤ 10μM
S5A1-2-E Steroid 5-alpha-reductase 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 4 0.42 Binding ≤ 10μM
S5A1-2-E Steroid 5-alpha-reductase 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
S5A1-2-E Steroid 5-alpha-reductase 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.41 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 463 0.32 Functional ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 2800 0.28 Functional ≤ 10μM
Z80453-1-O SC-3 (cluster #1 Of 2), Other Other 463 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.07 1.74 -12.57 0 4 0 40 388.596 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 17 beta-N,N-diethylcarbamoyl-4-methyl-4-aza-5 alpha-androstan-3-one; 17-N,N-diethyl-4-methyl-3-oxo-4-azaandrostane-17-carboxamide; 17-N,N-diethylcarbamoyl-4-methyl-4-azaandrostane-3-one; 17-beta-N,N-Diethylcarbamoyl-4-methyl-4-aza-5-alpha-androstan-3-one 17 beta-N,N-diethylcarbamoyl-4-m…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
3BHS1-2-E 3-beta-hydroxysteroid Dehydrogenase/delta 5-->4-isomerase Type I (cluster #2 Of 2), Eukaryotic Eukaryotes 20 0.38 Binding ≤ 10μM
3BHS2-1-E 3-beta-hydroxysteroid Dehydrogenase/delta 5-->4-isomerase Type II (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.38 Binding ≤ 10μM
S5A1-2-E Steroid 5-alpha-reductase 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 4 0.42 Binding ≤ 10μM
S5A1-2-E Steroid 5-alpha-reductase 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
S5A1-2-E Steroid 5-alpha-reductase 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.41 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
S5A2-1-E Steroid 5-alpha-reductase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 11 0.40 Binding ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 463 0.32 Functional ≤ 10μM
ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 2800 0.28 Functional ≤ 10μM
Z80453-1-O SC-3 (cluster #1 Of 2), Other Other 463 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.07 1.63 -12.67 0 4 0 40 388.596 3 ↓

Analogs

36747497
36747497

Draw Identity 99% 90% 80% 70%

Popular Name: Hydroxyflutamide Hydroxyflutamide

Find On: PubMed — Wikipedia — Google

Vendors

And 13 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ANDR-4-E Androgen Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 2100 0.40 Binding ≤ 10μM
ANDR-3-E Androgen Receptor (cluster #3 Of 3), Eukaryotic Eukaryotes 52 0.51 Functional ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 2013 0.40 Functional ≤ 10μM
Z80243-1-O MDA-MB-453 (Breast Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 26 0.53 Functional ≤ 10μM
Z80453-2-O SC-3 (cluster #2 Of 2), Other Other 52 0.51 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.08 3.1 -9.74 2 6 0 95 292.213 4 ↓
Hi High (pH 8-9.5) 3.39 9.26 -58.21 6 8 1 129 493.591 6 ↓

Parameters Provided:

annotation.name = ANDR_MOUSE
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 'ANDR\\_MOUSE' AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?annotation.name=ANDR_MOUSE&filter.purchasability=purchasable

Embed Link to Results