UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(2,3-dihydro-1,4-benzodioxin-6-yl)-5-[2-(4-pyridylmethylamino)phenyl]-1,3,4-oxadiazol-2-amine N-(2,3-dihydro-1,4-benzodioxin-6…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 210 0.31 Binding ≤ 10μM
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 5 0.39 Functional ≤ 10μM
Z103205-1-O A431 (cluster #1 Of 4), Other Other 9 0.38 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 45 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.35 4.21 -12.86 2 8 0 94 401.426 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 3-[5-(1,3-benzodioxol-5-ylamino)-1,3,4-oxadiazol-2-yl]quinolin-2-amine 3-[5-(1,3-benzodioxol-5-ylamino)…

Find On: PubMed — Wikipedia — Google

Vendors

And 4 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 50 0.39 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.57 1.86 -16.91 3 8 0 108 347.334 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-benzo[1,3]dioxol-5-yl-5-(3,4,5-trimethoxyphenyl)-1,3,4-oxadiazol-2-amine N-benzo[1,3]dioxol-5-yl-5-(3,4,5…

Find On: PubMed — Wikipedia — Google

Vendors

And 3 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 400 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) 3.44 -1.95 -11.66 1 9 0 97 371.349 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(1,3-benzodioxol-5-yl)-5-[4-(4-pyridylmethylamino)isothiazol-3-yl]-1,3,4-oxadiazol-2-amine N-(1,3-benzodioxol-5-yl)-5-[4-(4…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 5 0.42 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.71 1.91 -15.11 2 9 0 107 394.416 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-(4-chlorophenyl)-5-[4-(3-pyridylmethylamino)isothiazol-3-yl]-1,3,4-oxadiazol-2-amine N-(4-chlorophenyl)-5-[4-(3-pyrid…

Find On: PubMed — Wikipedia — Google

Vendors

And 1 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 500 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.55 3.7 -11.04 2 7 0 89 384.852 6 ↓
Lo Low (pH 4.5-6) 3.55 4.17 -39.28 3 7 1 90 385.86 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 5-(4-aminoisothiazol-3-yl)-N-benzo[1,3]dioxol-5-yl-1,3,4-oxadiazol-2-amine 5-(4-aminoisothiazol-3-yl)-N-ben…

Find On: PubMed — Wikipedia — Google

Vendors

And 4 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 500 0.42 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.23 -5.78 -11.76 3 8 0 108 303.303 3 ↓

Analogs

16957840
16957840

Draw Identity 99% 90% 80% 70%

Popular Name: CA4DP CA4DP

Find On: PubMed — Wikipedia — Google

Vendors

And 7 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 5 0.43 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 200 0.35 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 2 0.45 Functional ≤ 10μM
Z80493-2-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #2 Of 6), Other Other 7 0.42 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 0 0.00 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 6 0.43 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.69 2.46 -149.31 0 8 -2 109 394.316 8 ↓

Analogs

17175933
17175933

Draw Identity 99% 90% 80% 70%

Popular Name: (Z)-2-methoxy-5-(2-(7-methoxy-benzo[d][1,3]dioxol-5-yl)vinyl)phenol (Z)-2-methoxy-5-(2-(7-methoxy-be…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 50 0.46 Functional ≤ 10μM
Z100495-1-O BMEC (Brain Microvessel Endothelial Cells) (cluster #1 Of 1), Other Other 48 0.47 ADME/T ≤ 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.51 -0.32 -12.31 1 5 0 57 300.31 4 ↓

Analogs

4098919
4098919
4098920
4098920
4475321
4475321
11682059
11682059
16969582
16969582

Draw Identity 99% 90% 80% 70%

Popular Name: PODOPHYLLOTOXIN PODOPHYLLOTOXIN

Find On: PubMed — Wikipedia — Google

Vendors

And 52 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GCR-1-E Glucocorticoid Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 14 0.37 Binding ≤ 10μM
O46399-1-E Beta Tubulin (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.26 Binding ≤ 10μM
Q862F3-2-E Tubulin Alpha Chain (cluster #2 Of 2), Eukaryotic Eukaryotes 2500 0.26 Binding ≤ 10μM
Q862L2-2-E Tubulin Alpha-1 Chain (cluster #2 Of 2), Eukaryotic Eukaryotes 2500 0.26 Binding ≤ 10μM
Q9MZB0-1-E Tubulin Alpha-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.26 Binding ≤ 10μM
TBA1A-1-E Tubulin Alpha-3 Chain (cluster #1 Of 3), Eukaryotic Eukaryotes 2180 0.26 Binding ≤ 10μM
TBA4A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.27 Binding ≤ 10μM
TBB-1-E Tubulin Beta Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 1560 0.27 Binding ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 460 0.30 Binding ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2500 0.26 Binding ≤ 10μM
TBB3-1-E Tubulin Beta-3 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2180 0.26 Binding ≤ 10μM
TBB4A-1-E Tubulin Beta-4 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBB4B-1-E Tubulin Beta-2 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBB5-1-E Tubulin Beta-5 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBB8-1-E Tubulin Beta-8 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.25 Binding ≤ 10μM
TBG1-1-E Tubulin Gamma-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2180 0.26 Binding ≤ 10μM
Q862F3-1-E Tubulin Alpha Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.29 Functional ≤ 10μM
Q862L2-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.29 Functional ≤ 10μM
TBA1A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 460 0.30 Functional ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 460 0.30 Functional ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.29 Functional ≤ 10μM
Z100695-1-O WRL68 (Embryonic Hepatoma Cells) (cluster #1 Of 1), Other Other 4800 0.25 Functional ≤ 10μM
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 500 0.29 Functional ≤ 10μM
Z50425-1-O Plasmodium Falciparum (cluster #1 Of 22), Other Other 10000 0.23 Functional ≤ 10μM
Z50426-3-O Plasmodium Falciparum (isolate K1 / Thailand) (cluster #3 Of 9), Other Other 12 0.37 Functional ≤ 10μM
Z50602-2-O Human Herpesvirus 1 (cluster #2 Of 5), Other Other 50 0.34 Functional ≤ 10μM
Z50607-1-O Human Immunodeficiency Virus 1 (cluster #1 Of 10), Other Other 3 0.40 Functional ≤ 10μM
Z50651-2-O Vesicular Stomatitis Virus (cluster #2 Of 2), Other Other 100 0.33 Functional ≤ 10μM
Z80002-1-O 1A9 (Ovarian Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 3 0.40 Functional ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 4), Other Other 500 0.29 Functional ≤ 10μM
Z80110-1-O CV-1 (Kidney Cells) (cluster #1 Of 2), Other Other 29 0.35 Functional ≤ 10μM
Z80121-1-O DMS-79 (Small Cell Lung Carcinoma Cells) (cluster #1 Of 1), Other Other 23 0.36 Functional ≤ 10μM
Z80125-1-O DU-145 (Prostate Carcinoma) (cluster #1 Of 9), Other Other 52 0.34 Functional ≤ 10μM
Z80156-1-O HL-60 (Promyeloblast Leukemia Cells) (cluster #1 Of 12), Other Other 2750 0.26 Functional ≤ 10μM
Z80164-1-O HT-1080 (Fibrosarcoma Cells) (cluster #1 Of 6), Other Other 8100 0.24 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 50 0.34 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 30 0.35 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 8500 0.24 Functional ≤ 10μM
Z80284-3-O MOLT-3 (T-lymphoblastic Leukemia Cells) (cluster #3 Of 3), Other Other 14 0.37 Functional ≤ 10μM
Z80354-4-O OVCAR-3 (Ovarian Adenocarcinoma Cells) (cluster #4 Of 4), Other Other 460 0.30 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 50 0.34 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 13 0.37 Functional ≤ 10μM
Z80414-1-O Raji (B-lymphoblastic Cells) (cluster #1 Of 3), Other Other 18 0.36 Functional ≤ 10μM
Z80427-1-O RKO (Colon Carcinoma) (cluster #1 Of 1), Other Other 29 0.35 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 7630 0.24 Functional ≤ 10μM
Z80697-1-O Bel-7402 (Hepatoma Cells) (cluster #1 Of 3), Other Other 9 0.38 Functional ≤ 10μM
Z80819-1-O J774.2 (cluster #1 Of 1), Other Other 13 0.37 Functional ≤ 10μM
Z80847-1-O FaDu (Pharyngeal Carcinoma Cells) (cluster #1 Of 3), Other Other 7 0.38 Functional ≤ 10μM
Z80866-1-O GLC4 Cell Line (cluster #1 Of 1), Other Other 60 0.34 Functional ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 7), Other Other 7 0.38 Functional ≤ 10μM
Z80936-1-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #1 Of 4), Other Other 17 0.36 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 500 0.29 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 8 0.38 Functional ≤ 10μM
Z81135-1-O L6 (Skeletal Muscle Myoblast Cells) (cluster #1 Of 4), Other Other 150 0.32 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 16 0.36 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 69 0.33 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 8 0.38 Functional ≤ 10μM
Z81335-2-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #2 Of 5), Other Other 1000 0.28 Functional ≤ 10μM
Z80052-1-O C8166 (Leukemic T-cells) (cluster #1 Of 1), Other Other 150 0.32 ADME/T ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 34 0.35 ADME/T ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 3), Other Other 23 0.36 ADME/T ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 3), Other Other 5 0.39 ADME/T ≤ 10μM
Z81135-3-O L6 (Skeletal Muscle Myoblast Cells) (cluster #3 Of 6), Other Other 9 0.38 ADME/T ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 1), Other Other 31 0.35 ADME/T ≤ 10μM
VE2-1-V Human Papillomavirus Regulatory Protein E2 (cluster #1 Of 1), Viral Viruses 1050 0.28 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) 1.32 4.95 -16.81 1 8 0 93 414.41 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: Nocodazole Nocodazole

Find On: PubMed — Wikipedia — Google

Vendors

And 19 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TBA1A-2-E Tubulin Alpha-3 Chain (cluster #2 Of 3), Eukaryotic Eukaryotes 5700 0.35 Binding ≤ 10μM
TBA1A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 760 0.41 Functional ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 760 0.41 Functional ≤ 10μM
Z101973-1-O Paracentrotus Lividus (cluster #1 Of 1), Other Other 5 0.55 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 10000 0.33 Functional ≤ 10μM
Z50587-1-O Homo Sapiens (cluster #1 Of 9), Other Other 33 0.50 Functional ≤ 10μM
Z80035-1-O B16 (Melanoma Cells) (cluster #1 Of 7), Other Other 100 0.47 Functional ≤ 10μM
Z80186-10-O K562 (Erythroleukemia Cells) (cluster #10 Of 11), Other Other 82 0.47 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 90 0.47 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 80 0.47 Functional ≤ 10μM
Z80364-1-O P388/ADR (Lymphoma Cells) (cluster #1 Of 1), Other Other 70 0.48 Functional ≤ 10μM
Z80427-1-O RKO (Colon Carcinoma) (cluster #1 Of 1), Other Other 110 0.46 Functional ≤ 10μM
Z80466-4-O SF268 (cluster #4 Of 4), Other Other 300 0.43 Functional ≤ 10μM
Z80493-1-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #1 Of 6), Other Other 80 0.47 Functional ≤ 10μM
Z80526-1-O SW480 (Colon Adenocarcinoma Cells) (cluster #1 Of 6), Other Other 120 0.46 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 87 0.47 Functional ≤ 10μM
Z80928-3-O HCT-116 (Colon Carcinoma Cells) (cluster #3 Of 9), Other Other 173 0.45 Functional ≤ 10μM
Z81024-1-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #1 Of 8), Other Other 68 0.48 Functional ≤ 10μM
Z81054-2-O SF-268 (Glioblastoma Cells) (cluster #2 Of 3), Other Other 300 0.43 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 140 0.46 Functional ≤ 10μM
Z81187-1-O LT12 Tumor Cell Line (cluster #1 Of 1), Other Other 50 0.49 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.96 4.96 -14.18 2 6 0 87 301.327 3 ↓
Ref Reference (pH 7) 2.96 4.96 -10.99 2 6 0 87 301.327 3 ↓

Parameters Provided:

annotation.name = Z101973
anotation.type = F10
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 'Z101973' AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

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

Embed Link to Results