UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

2284674
2284674

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 1860 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) 5.18 10.01 -11.24 0 5 0 50 393.464 4

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 30 0.28 Binding ≤ 10μM
CDK2-1-E Cyclin-dependent Kinase 2 (cluster #1 Of 5), Eukaryotic Eukaryotes 10000 0.18 Binding ≤ 10μM
CSK-1-E Tyrosine-protein Kinase CSK (cluster #1 Of 1), Eukaryotic Eukaryotes 840 0.22 Binding ≤ 10μM
EGFR-3-E Epidermal Growth Factor Receptor ErbB1 (cluster #3 Of 4), Eukaryotic Eukaryotes 2600 0.21 Binding ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.25 Binding ≤ 10μM
LCK-1-E Tyrosine-protein Kinase LCK (cluster #1 Of 4), Eukaryotic Eukaryotes 4 0.31 Binding ≤ 10μM
PGFRA-1-E Platelet-derived Growth Factor Receptor Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 10000 0.18 Binding ≤ 10μM
SRC-1-E Tyrosine-protein Kinase SRC (cluster #1 Of 3), Eukaryotic Eukaryotes 3 0.31 Binding ≤ 10μM
YES-1-E Tyrosine-protein Kinase YES (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.31 Binding ≤ 10μM
SRC-1-E Tyrosine-protein Kinase SRC (cluster #1 Of 1), Eukaryotic Eukaryotes 76 0.26 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 220 0.25 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 140 0.25 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.46 9.82 -45.05 2 10 1 92 543.044 8
Mid Mid (pH 6-8) 4.46 9.74 -46.9 2 10 1 92 543.044 8
Mid Mid (pH 6-8) 4.46 7.35 -11.91 1 10 0 90 542.036 8

Analogs

6341075
6341075
5129096
5129096

Draw Identity 99% 90% 80% 70%

Vendors

And 7 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 300 0.37 Functional ≤ 10μM
Z80356-1-O OVCAR-5 (Ovarian Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 5650 0.29 Functional ≤ 10μM
Z81201-1-O HOP-62 (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 9610 0.28 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.33 2.21 -14.19 0 6 0 63 342.347 6

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 4 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Q862L2-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.37 Binding ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 1000 0.37 Binding ≤ 10μM
TBA1A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 400 0.39 Functional ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 400 0.39 Functional ≤ 10μM
Z80099-3-O COLO 205 (Colon Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 4860 0.32 Functional ≤ 10μM
Z80120-1-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 83 0.43 Functional ≤ 10μM
Z80125-9-O DU-145 (Prostate Carcinoma) (cluster #9 Of 9), Other Other 34 0.45 Functional ≤ 10μM
Z80156-1-O HL-60 (Promyeloblast Leukemia Cells) (cluster #1 Of 12), Other Other 31 0.46 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 560 0.38 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 41 0.45 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 437 0.39 Functional ≤ 10μM
Z80255-2-O MES-SA/DxS (Uterine Sarcoma Cells) (cluster #2 Of 2), Other Other 394 0.39 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 10 0.49 Functional ≤ 10μM
Z80555-1-O TSGH (cluster #1 Of 1), Other Other 170 0.41 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 300 0.40 Functional ≤ 10μM
Z80798-1-O CPT30 Cell Line (cluster #1 Of 1), Other Other 37 0.45 Functional ≤ 10μM
Z80900-1-O HA22T Cell Line (cluster #1 Of 1), Other Other 3706 0.33 Functional ≤ 10μM
Z80928-6-O HCT-116 (Colon Carcinoma Cells) (cluster #6 Of 9), Other Other 33 0.46 Functional ≤ 10μM
Z80967-2-O Hone-1 Cell Line (cluster #2 Of 2), Other Other 87 0.43 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 35 0.45 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 30 0.46 Functional ≤ 10μM
Z81252-7-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #7 Of 11), Other Other 28 0.46 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.36 4.04 -11.69 1 6 0 74 318.325 6

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.30 Binding ≤ 10μM
ABL2-1-E Tyrosine-protein Kinase ABL2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.35 Binding ≤ 10μM
ACK1-1-E Tyrosine Kinase Non-receptor Protein 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.33 Binding ≤ 10μM
ALK-1-E ALK Tyrosine Kinase Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.26 Binding ≤ 10μM
BCR-1-E Breakpoint Cluster Region Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.30 Binding ≤ 10μM
BLK-1-E Tyrosine-protein Kinase BLK (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.32 Binding ≤ 10μM
BMX-1-E Tyrosine-protein Kinase BMX (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.31 Binding ≤ 10μM
BTK-1-E Tyrosine-protein Kinase BTK (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.33 Binding ≤ 10μM
CSK-1-E Tyrosine-protein Kinase CSK (cluster #1 Of 1), Eukaryotic Eukaryotes 63 0.28 Binding ≤ 10μM
EGFR-1-E Epidermal Growth Factor Receptor ErbB1 (cluster #1 Of 4), Eukaryotic Eukaryotes 53 0.28 Binding ≤ 10μM
EPHB2-1-E Ephrin Type-B Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 9 0.31 Binding ≤ 10μM
EPHB4-1-E Ephrin Type-B Receptor 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.32 Binding ≤ 10μM
FAK1-1-E Focal Adhesion Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 538 0.24 Binding ≤ 10μM
FAK2-1-E Protein-tyrosine Kinase 2-beta (cluster #1 Of 1), Eukaryotic Eukaryotes 134 0.27 Binding ≤ 10μM
FER-1-E Tyrosine-protein Kinase FER (cluster #1 Of 1), Eukaryotic Eukaryotes 490 0.25 Binding ≤ 10μM
FES-1-E Tyrosine-protein Kinase FES (cluster #1 Of 1), Eukaryotic Eukaryotes 358 0.25 Binding ≤ 10μM
FGR-1-E Tyrosine-protein Kinase FGR (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.35 Binding ≤ 10μM
FRK-1-E Tyrosine-protein Kinase FRK (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.34 Binding ≤ 10μM
FYN-1-E Tyrosine-protein Kinase FYN (cluster #1 Of 5), Eukaryotic Eukaryotes 2 0.34 Binding ≤ 10μM
HCK-1-E Tyrosine-protein Kinase HCK (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.33 Binding ≤ 10μM
IRAK4-1-E Interleukin-1 Receptor-associated Kinase 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 574 0.24 Binding ≤ 10μM
KCC1D-1-E CaM Kinase I Delta (cluster #1 Of 2), Eukaryotic Eukaryotes 92 0.27 Binding ≤ 10μM
KCC2G-1-E CaM Kinase II Gamma (cluster #1 Of 1), Eukaryotic Eukaryotes 184 0.26 Binding ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 6313 0.20 Binding ≤ 10μM
KSYK-1-E Tyrosine-protein Kinase SYK (cluster #1 Of 2), Eukaryotic Eukaryotes 52 0.28 Binding ≤ 10μM
LCK-1-E Tyrosine-protein Kinase LCK (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.35 Binding ≤ 10μM
LYN-1-E Tyrosine-protein Kinase Lyn (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.31 Binding ≤ 10μM
M4K2-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 10 0.31 Binding ≤ 10μM
M4K5-1-E Mitogen-activated Protein Kinase Kinase Kinase Kinase 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
MINK1-1-E Misshapen-like Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.30 Binding ≤ 10μM
NPM-1-E Nucleophosmin (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.26 Binding ≤ 10μM
NTRK1-1-E Nerve Growth Factor Receptor Trk-A (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.30 Binding ≤ 10μM
NTRK2-1-E Neurotrophic Tyrosine Kinase Receptor Type 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 27 0.29 Binding ≤ 10μM
SRC-1-E Tyrosine-protein Kinase SRC (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.33 Binding ≤ 10μM
STK10-1-E Serine/threonine-protein Kinase 10 (cluster #1 Of 1), Eukaryotic Eukaryotes 52 0.28 Binding ≤ 10μM
STK24-1-E Serine/threonine-protein Kinase 24 (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.33 Binding ≤ 10μM
STK4-1-E Serine/threonine-protein Kinase MST1 (cluster #1 Of 2), Eukaryotic Eukaryotes 191 0.26 Binding ≤ 10μM
TBK1-1-E Serine/threonine-protein Kinase TBK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 471 0.25 Binding ≤ 10μM
TEC-1-E Tyrosine-protein Kinase TEC (cluster #1 Of 1), Eukaryotic Eukaryotes 282 0.25 Binding ≤ 10μM
TIE2-1-E Tyrosine-protein Kinase TIE-2 (cluster #1 Of 2), Eukaryotic Eukaryotes 1191 0.23 Binding ≤ 10μM
TXK-1-E Tyrosine-protein Kinase TXK (cluster #1 Of 1), Eukaryotic Eukaryotes 40 0.29 Binding ≤ 10μM
UFO-1-E Tyrosine-protein Kinase Receptor UFO (cluster #1 Of 1), Eukaryotic Eukaryotes 174 0.26 Binding ≤ 10μM
YES-1-E Tyrosine-protein Kinase YES (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 2), Eukaryotic Eukaryotes 490 0.25 Functional ≤ 10μM
ABL2-1-E Tyrosine-protein Kinase ABL2 (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.35 Functional ≤ 10μM
ERBB2-2-E Receptor Protein-tyrosine Kinase ErbB-2 (cluster #2 Of 3), Eukaryotic Eukaryotes 2600 0.22 Functional ≤ 10μM
FYN-1-E Tyrosine-protein Kinase FYN (cluster #1 Of 1), Eukaryotic Eukaryotes 410 0.25 Functional ≤ 10μM
PGFRA-1-E Platelet-derived Growth Factor Receptor Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.21 Functional ≤ 10μM
PGFRB-1-E Platelet-derived Growth Factor Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 4000 0.21 Functional ≤ 10μM
SRC-1-E Tyrosine-protein Kinase SRC (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.27 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 100 0.27 Functional ≤ 10μM
Z80036-2-O BaF3 (IL-3-dependent Pro-B-cells) (cluster #2 Of 3), Other Other 200 0.26 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 5000 0.21 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 20 0.30 Functional ≤ 10μM
Z80416-1-O Rat1 (Fibroblast Cells) (cluster #1 Of 1), Other Other 490 0.25 Functional ≤ 10μM
Z81020-7-O HepG2 (Hepatoblastoma Cells) (cluster #7 Of 8), Other Other 3910 0.21 Functional ≤ 10μM
Z81125-1-O KU812 Cell Line (cluster #1 Of 1), Other Other 5 0.32 Functional ≤ 10μM
Z81328-1-O Src-transformed (Fibroblast Cells) (cluster #1 Of 1), Other Other 100 0.27 Functional ≤ 10μM
ABL-1-V Tyrosine-protein Kinase V-ABL (cluster #1 Of 1), Viral Viruses 1 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.98 9.49 -44.8 2 8 1 84 531.464 9
Hi High (pH 8-9.5) 4.98 7.02 -12.44 1 8 0 83 530.456 9
Mid Mid (pH 6-8) 4.98 9.35 -46.97 2 8 1 84 531.464 9

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
TBA1A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 1700 0.31 Functional ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 1700 0.31 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 600 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) 5.17 2.51 -12.5 0 3 0 35 342.394 3

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 8 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
KCNH2-2-E HERG (cluster #2 Of 5), Eukaryotic Eukaryotes 210 0.33 Binding ≤ 10μM
S22A1-1-E Solute Carrier Family 22 Member 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 5000 0.27 Binding ≤ 10μM
TOP2A-1-E DNA Topoisomerase II Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 9940 0.25 Binding ≤ 10μM
TOP2B-1-E DNA Topoisomerase II Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 720 0.31 Binding ≤ 10μM
TOP1-1-E DNA Topoisomerase I (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.38 Functional ≤ 10μM
TOP2A-1-E DNA Topoisomerase II Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.38 Functional ≤ 10μM
TOP2B-1-E DNA Topoisomerase II Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.38 Functional ≤ 10μM
ADO-1-E Aldehyde Oxidase (cluster #1 Of 3), Eukaryotic Eukaryotes 6400 0.26 ADME/T ≤ 10μM
CP2D6-2-E Cytochrome P450 2D6 (cluster #2 Of 3), Eukaryotic Eukaryotes 7500 0.26 ADME/T ≤ 10μM
Z103205-3-O A431 (cluster #3 Of 4), Other Other 5890 0.26 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 600 0.31 Functional ≤ 10μM
Z50460-4-O Leishmania Major (cluster #4 Of 4), Other Other 1500 0.29 Functional ≤ 10μM
Z80064-8-O CCRF-CEM (T-cell Leukemia) (cluster #8 Of 9), Other Other 139 0.34 Functional ≤ 10μM
Z80084-1-O CEM-VLB (Vinblastine-resistant T-cell Leukemia Cells) (cluster #1 Of 2), Other Other 520 0.31 Functional ≤ 10μM
Z80085-1-O CEM-VM1 (Etoposide-resistant T-cell Leukemia Cells) (cluster #1 Of 2), Other Other 1910 0.29 Functional ≤ 10μM
Z80089-1-O CHO-AA8 (cluster #1 Of 2), Other Other 1 0.45 Functional ≤ 10μM
Z80115-1-O DC3F (cluster #1 Of 1), Other Other 4 0.42 Functional ≤ 10μM
Z80117-2-O DC3F/AD-II (cluster #2 Of 2), Other Other 47 0.37 Functional ≤ 10μM
Z80152-1-O HCT-8 (Ileocecal Adenocarcinoma) (cluster #1 Of 2), Other Other 120 0.35 Functional ≤ 10μM
Z80156-1-O HL-60 (Promyeloblast Leukemia Cells) (cluster #1 Of 12), Other Other 6 0.41 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 559 0.31 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 23 0.38 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 50 0.37 Functional ≤ 10μM
Z80224-5-O MCF7 (Breast Carcinoma Cells) (cluster #5 Of 14), Other Other 75 0.36 Functional ≤ 10μM
Z80227-2-O MCF7-ADR (Breast Carcinoma Cells) (cluster #2 Of 2), Other Other 1165 0.30 Functional ≤ 10μM
Z80244-7-O MDA-MB-468 (Breast Adenocarcinoma) (cluster #7 Of 7), Other Other 490 0.32 Functional ≤ 10μM
Z80322-1-O NCI-H358 (Lung Carcinama Cells) (cluster #1 Of 2), Other Other 150 0.34 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 890 0.30 Functional ≤ 10μM
Z80475-3-O SK-BR-3 (Breast Adenocarcinoma) (cluster #3 Of 3), Other Other 60 0.36 Functional ≤ 10μM
Z80601-1-O XRS6 (cluster #1 Of 1), Other Other 240 0.33 Functional ≤ 10μM
Z80608-4-O ZR-75-1 (Breast Carcinoma Cells) (cluster #4 Of 4), Other Other 180 0.34 Functional ≤ 10μM
Z80612-1-O 2008 (Ovarian Carcinoma Cells) (cluster #1 Of 2), Other Other 4310 0.27 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 3520 0.27 Functional ≤ 10μM
Z80712-7-O T47D (Breast Carcinoma Cells) (cluster #7 Of 7), Other Other 220 0.33 Functional ≤ 10μM
Z80819-1-O J774.2 (cluster #1 Of 1), Other Other 1485 0.29 Functional ≤ 10μM
Z80846-2-O F460pv8/eto Cell Line (cluster #2 Of 2), Other Other 40 0.37 Functional ≤ 10μM
Z80889-2-O NCI-H322M (Non-small Cell Lung Carcinoma Cells) (cluster #2 Of 3), Other Other 210 0.33 Functional ≤ 10μM
Z80928-5-O HCT-116 (Colon Carcinoma Cells) (cluster #5 Of 9), Other Other 700 0.31 Functional ≤ 10μM
Z81024-8-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #8 Of 8), Other Other 60 0.36 Functional ≤ 10μM
Z81034-6-O A2780 (Ovarian Carcinoma Cells) (cluster #6 Of 10), Other Other 100 0.35 Functional ≤ 10μM
Z81072-6-O Jurkat (Acute Leukemic T-cells) (cluster #6 Of 10), Other Other 80 0.35 Functional ≤ 10μM
Z81160-1-O Lewis Lung Carcinoma Cell Line (cluster #1 Of 1), Other Other 12 0.40 Functional ≤ 10μM
Z81164-1-O LL Cell Line (cluster #1 Of 2), Other Other 12 0.40 Functional ≤ 10μM
Z81167-1-O LLTC Cell Line (cluster #1 Of 1), Other Other 12 0.40 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 901 0.30 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 9500 0.25 Functional ≤ 10μM
Z81252-10-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #10 Of 11), Other Other 140 0.34 Functional ≤ 10μM
Z81280-1-O NCI-H226 (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 1010 0.30 Functional ≤ 10μM
Z81284-2-O NCI-H647 (cluster #2 Of 2), Other Other 70 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) 4.91 6.33 -44.52 2 6 0 84 393.468 5
Hi High (pH 8-9.5) 4.91 5.83 -16.62 2 6 0 80 393.468 5
Hi High (pH 8-9.5) 4.91 5.94 -47.33 1 6 -1 82 392.46 5

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 27 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.91 5.83 -10.91 0 7 0 68 341.367 6

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 4000 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) 2.49 5.76 -11.12 0 7 0 68 341.367 6

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 4 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
A1Z199-1-E BCR/ABL P210 Fusion Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 267 0.34 Binding ≤ 10μM
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 92 0.36 Binding ≤ 10μM
BCR-1-E Breakpoint Cluster Region Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 92 0.36 Binding ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 273 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.78 6.7 -16.66 3 6 0 90 374.322 6

Analogs

30726947
30726947
30726949
30726949
38146181
38146181
38148193
38148193
40163548
40163548

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 313 0.20 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 8930 0.16 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) 6.24 10.7 -16.43 1 8 0 73 608.735 3
Hi High (pH 8-9.5) 6.24 11.63 -62.9 0 8 -1 76 607.727 3
Lo Low (pH 4.5-6) 6.24 13.37 -56.41 2 8 1 74 609.743 3

Analogs

6341075
6341075
7743645
7743645
8867320
8867320

Draw Identity 99% 90% 80% 70%

Vendors

And 8 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 2900 0.31 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.33 7.06 -15.6 0 6 0 63 342.347 6

Analogs

5733913
5733913

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 280 0.44 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 7000 0.34 Functional ≤ 10μM
Z80224-5-O MCF7 (Breast Carcinoma Cells) (cluster #5 Of 14), Other Other 9300 0.34 Functional ≤ 10μM
Z81020-7-O HepG2 (Hepatoblastoma Cells) (cluster #7 Of 8), Other Other 6000 0.35 Functional ≤ 10μM
Z81252-10-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #10 Of 11), Other Other 8120 0.34 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 3), Other Other 2070 0.38 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.05 -4.51 -93.85 5 4 2 63 303.793 4

Analogs

36766018
36766018
26512439
26512439
26512465
26512465

Draw Identity 99% 90% 80% 70%

Vendors

And 2 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 40 0.40 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 3030 0.30 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 4490 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) 3.11 4.19 -11.43 2 7 0 89 356.378 6
Lo Low (pH 4.5-6) 3.11 4.17 -35.87 3 7 1 90 357.386 6

Analogs

36766018
36766018
34976063
34976063
34976065
34976065

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 22 0.41 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.11 4.14 -11.18 2 7 0 89 356.378 6
Lo Low (pH 4.5-6) 3.11 4.18 -36.28 3 7 1 90 357.386 6

Analogs

4098919
4098919
4098920
4098920
4475321
4475321
11682059
11682059
16969582
16969582

Draw Identity 99% 90% 80% 70%

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%

Vendors

And 25 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Q862F3-1-E Tubulin Alpha Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 1700 0.35 Binding ≤ 10μM
Q862L2-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 1700 0.35 Binding ≤ 10μM
TBA1A-1-E Tubulin Alpha-3 Chain (cluster #1 Of 3), Eukaryotic Eukaryotes 530 0.38 Binding ≤ 10μM
TBA4A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 30 0.46 Binding ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 530 0.38 Binding ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 2900 0.34 Binding ≤ 10μM
Q25270-2-E Beta Tubulin (cluster #2 Of 2), Eukaryotic Eukaryotes 2000 0.35 Functional ≤ 10μM
Q862F3-1-E Tubulin Alpha Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 660 0.38 Functional ≤ 10μM
Q862L2-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 660 0.38 Functional ≤ 10μM
TBA1A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 530 0.38 Functional ≤ 10μM
TBA4A-1-E Tubulin Alpha-1 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 4920 0.32 Functional ≤ 10μM
TBB1-1-E Tubulin Beta-1 Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 530 0.38 Functional ≤ 10μM
TBB2B-1-E Tubulin Beta Chain (cluster #1 Of 2), Eukaryotic Eukaryotes 660 0.38 Functional ≤ 10μM
TBB3-3-E Tubulin Beta-3 Chain (cluster #3 Of 3), Eukaryotic Eukaryotes 1400 0.36 Functional ≤ 10μM
TBB4A-3-E Tubulin Beta-4 Chain (cluster #3 Of 3), Eukaryotic Eukaryotes 1400 0.36 Functional ≤ 10μM
TBB4B-3-E Tubulin Beta-2 Chain (cluster #3 Of 3), Eukaryotic Eukaryotes 1400 0.36 Functional ≤ 10μM
TBB5-1-E Tubulin Beta-5 Chain (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.36 Functional ≤ 10μM
TBB8-3-E Tubulin Beta-8 Chain (cluster #3 Of 3), Eukaryotic Eukaryotes 1400 0.36 Functional ≤ 10μM
Z100495-1-O BMEC (Brain Microvessel Endothelial Cells) (cluster #1 Of 1), Other Other 4 0.51 Functional ≤ 10μM
Z100742-1-O MeWo (Melanoma Cells) (cluster #1 Of 1), Other Other 4 0.51 Functional ≤ 10μM
Z103203-1-O A375 (cluster #1 Of 3), Other Other 2 0.53 Functional ≤ 10μM
Z103205-1-O A431 (cluster #1 Of 4), Other Other 188 0.41 Functional ≤ 10μM
Z103208-1-O AU565 (cluster #1 Of 1), Other Other 4 0.51 Functional ≤ 10μM
Z103407-2-O SW1990 (cluster #2 Of 2), Other Other 250 0.40 Functional ≤ 10μM
Z50591-2-O Bos Taurus (cluster #2 Of 2), Other Other 2000 0.35 Functional ≤ 10μM
Z50594-1-O Mus Musculus (cluster #1 Of 9), Other Other 18 0.47 Functional ≤ 10μM
Z80002-1-O 1A9 (Ovarian Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 4 0.51 Functional ≤ 10μM
Z80013-2-O A10 (cluster #2 Of 2), Other Other 7 0.50 Functional ≤ 10μM
Z80025-1-O ACHN (Renal Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 2 0.53 Functional ≤ 10μM
Z80035-5-O B16 (Melanoma Cells) (cluster #5 Of 7), Other Other 5 0.51 Functional ≤ 10μM
Z80064-4-O CCRF-CEM (T-cell Leukemia) (cluster #4 Of 9), Other Other 2 0.53 Functional ≤ 10μM
Z80071-2-O CEM-0 (T-cell Leukemia) (cluster #2 Of 2), Other Other 2 0.53 Functional ≤ 10μM
Z80099-3-O COLO 205 (Colon Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 2756 0.34 Functional ≤ 10μM
Z80120-1-O DLD-1 (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 36 0.45 Functional ≤ 10μM
Z80121-1-O DMS-79 (Small Cell Lung Carcinoma Cells) (cluster #1 Of 1), Other Other 124 0.42 Functional ≤ 10μM
Z80125-9-O DU-145 (Prostate Carcinoma) (cluster #9 Of 9), Other Other 9 0.49 Functional ≤ 10μM
Z80136-2-O FM3A (Breast Carcinoma Cells) (cluster #2 Of 6), Other Other 42 0.45 Functional ≤ 10μM
Z80156-1-O HL-60 (Promyeloblast Leukemia Cells) (cluster #1 Of 12), Other Other 4 0.51 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 94 0.43 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 5 0.51 Functional ≤ 10μM
Z80193-1-O L1210 (Lymphocytic Leukemia Cells) (cluster #1 Of 12), Other Other 8 0.49 Functional ≤ 10μM
Z80211-2-O LoVo (Colon Adenocarcinoma Cells) (cluster #2 Of 5), Other Other 3 0.52 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 8 0.49 Functional ≤ 10μM
Z80229-1-O MCF7-DOX (Breast Carcinoma Cells) (cluster #1 Of 1), Other Other 2 0.53 Functional ≤ 10μM
Z80254-1-O MES-SA (Uterine Sarcoma Cells) (cluster #1 Of 2), Other Other 13 0.48 Functional ≤ 10μM
Z80255-2-O MES-SA/DxS (Uterine Sarcoma Cells) (cluster #2 Of 2), Other Other 5 0.51 Functional ≤ 10μM
Z80269-1-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 82 0.43 Functional ≤ 10μM
Z80284-3-O MOLT-3 (T-lymphoblastic Leukemia Cells) (cluster #3 Of 3), Other Other 9 0.49 Functional ≤ 10μM
Z80285-2-O MOLT-4 (Acute T-lymphoblastic Leukemia Cells) (cluster #2 Of 4), Other Other 16 0.47 Functional ≤ 10μM
Z80353-1-O OVCAR (cluster #1 Of 1), Other Other 3 0.52 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 3 0.52 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 5400 0.32 Functional ≤ 10μM
Z80471-3-O SH-SY5 (Bone Marrow Neuroblastoma Cells) (cluster #3 Of 3), Other Other 6 0.50 Functional ≤ 10μM
Z80485-3-O SK-MEL-28 (Melanoma Cells) (cluster #3 Of 6), Other Other 3 0.52 Functional ≤ 10μM
Z80493-2-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #2 Of 6), Other Other 6 0.50 Functional ≤ 10μM
Z80555-1-O TSGH (cluster #1 Of 1), Other Other 45 0.45 Functional ≤ 10μM
Z80682-7-O A549 (Lung Carcinoma Cells) (cluster #7 Of 11), Other Other 8 0.49 Functional ≤ 10μM
Z80697-3-O Bel-7402 (Hepatoma Cells) (cluster #3 Of 3), Other Other 10 0.49 Functional ≤ 10μM
Z80711-1-O NCI/ADR-RES (Breast Carcinoma Cells) (cluster #1 Of 2), Other Other 2 0.53 Functional ≤ 10μM
Z80792-1-O Colon 26 (Colon Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 9 0.49 Functional ≤ 10μM
Z80798-1-O CPT30 Cell Line (cluster #1 Of 1), Other Other 7 0.50 Functional ≤ 10μM
Z80847-3-O FaDu (Pharyngeal Carcinoma Cells) (cluster #3 Of 3), Other Other 2 0.53 Functional ≤ 10μM
Z80852-2-O A-431 (Epidermoid Carcinoma Cells) (cluster #2 Of 3), Other Other 4 0.51 Functional ≤ 10μM
Z80874-2-O CEM (T-cell Leukemia) (cluster #2 Of 7), Other Other 12 0.48 Functional ≤ 10μM
Z80896-1-O NCI-H69 (Small Cell Lung Carcinoma Cells) (cluster #1 Of 1), Other Other 2 0.53 Functional ≤ 10μM
Z80900-1-O HA22T Cell Line (cluster #1 Of 1), Other Other 2708 0.34 Functional ≤ 10μM
Z80928-6-O HCT-116 (Colon Carcinoma Cells) (cluster #6 Of 9), Other Other 6 0.50 Functional ≤ 10μM
Z80967-2-O Hone-1 Cell Line (cluster #2 Of 2), Other Other 7 0.50 Functional ≤ 10μM
Z81001-1-O TSGH 9201 (Gastric Carcinoma Cells) (cluster #1 Of 1), Other Other 38 0.45 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 6 0.50 Functional ≤ 10μM
Z81024-5-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #5 Of 8), Other Other 3 0.52 Functional ≤ 10μM
Z81034-3-O A2780 (Ovarian Carcinoma Cells) (cluster #3 Of 10), Other Other 2 0.53 Functional ≤ 10μM
Z81057-1-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #1 Of 4), Other Other 5 0.51 Functional ≤ 10μM
Z81065-3-O IGROV-1 (Ovarian Adenocarcinoma Cells) (cluster #3 Of 3), Other Other 10 0.49 Functional ≤ 10μM
Z81072-1-O Jurkat (Acute Leukemic T-cells) (cluster #1 Of 10), Other Other 5 0.51 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 10 0.49 Functional ≤ 10μM
Z81233-2-O M21 (Melanoma Cells) (cluster #2 Of 2), Other Other 4 0.51 Functional ≤ 10μM
Z81245-1-O MDA-MB-435 (Breast Carcinoma Cells) (cluster #1 Of 6), Other Other 3 0.52 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 4 0.51 Functional ≤ 10μM
Z81252-7-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #7 Of 11), Other Other 43 0.45 Functional ≤ 10μM
Z81331-6-O SW-620 (Colon Adenocarcinoma Cells) (cluster #6 Of 6), Other Other 23 0.46 Functional ≤ 10μM
Z81335-2-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #2 Of 5), Other Other 3 0.52 Functional ≤ 10μM
Z100495-1-O BMEC (Brain Microvessel Endothelial Cells) (cluster #1 Of 1), Other Other 4 0.51 ADME/T ≤ 10μM
Z80013-2-O A10 (cluster #2 Of 2), Other Other 23 0.46 ADME/T ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 3 0.52 ADME/T ≤ 10μM
Z80608-1-O ZR-75-1 (Breast Carcinoma Cells) (cluster #1 Of 1), Other Other 0 0.00 ADME/T ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 4), Other Other 2 0.53 ADME/T ≤ 10μM
Z80928-1-O HCT-116 (Colon Carcinoma Cells) (cluster #1 Of 2), Other Other 0 0.00 ADME/T ≤ 10μM
Z81057-2-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #2 Of 5), Other Other 5 0.51 ADME/T ≤ 10μM
Z81247-1-O HeLa (Cervical Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 3 0.52 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.47 5.32 -10.67 1 5 0 57 316.353 6

Analogs

2014826
2014826

Draw Identity 99% 90% 80% 70%

Vendors

And 44 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
IMDH1-1-E Inosine-5'-monophosphate Dehydrogenase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 55 0.44 Binding ≤ 10μM
IMDH2-1-E Inosine-5'-monophosphate Dehydrogenase 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.50 Binding ≤ 10μM
Z101767-1-O Dengue Virus 2 (cluster #1 Of 1), Other Other 5700 0.32 Functional ≤ 10μM
Z50442-2-O Candida Albicans (cluster #2 Of 4), Other Other 8000 0.31 Functional ≤ 10μM
Z50587-1-O Homo Sapiens (cluster #1 Of 9), Other Other 58 0.44 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 1000 0.37 Functional ≤ 10μM
Z50599-1-O Cowpox Virus (cluster #1 Of 1), Other Other 3200 0.33 Functional ≤ 10μM
Z50641-2-O West Nile Virus (cluster #2 Of 2), Other Other 80 0.43 Functional ≤ 10μM
Z50678-1-O Respiratory Syncytial Virus (cluster #1 Of 2), Other Other 600 0.38 Functional ≤ 10μM
Z80040-1-O BHK-21 (Kidney Cells) (cluster #1 Of 1), Other Other 40 0.45 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 900 0.37 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 80 0.43 Functional ≤ 10μM
Z80193-1-O L1210 (Lymphocytic Leukemia Cells) (cluster #1 Of 12), Other Other 200 0.41 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 500 0.38 Functional ≤ 10μM
Z80401-1-O PSN1 (cluster #1 Of 2), Other Other 700 0.37 Functional ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 7), Other Other 80 0.43 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 400 0.39 Functional ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 7), Other Other 900 0.37 Functional ≤ 10μM
Z81057-1-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #1 Of 4), Other Other 99 0.43 Functional ≤ 10μM
Z81072-1-O Jurkat (Acute Leukemic T-cells) (cluster #1 Of 10), Other Other 128 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.63 7.03 -53.53 1 6 -1 96 319.333 6
Hi High (pH 8-9.5) 2.63 7.8 -109.76 0 6 -2 99 318.325 6
Lo Low (pH 4.5-6) 2.63 5.05 -14.55 2 6 0 93 320.341 6

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z102380-2-O Ileum (cluster #2 Of 3), Other Other 1750 0.47 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 1000 0.49 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), 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) 2.41 -3.9 -8.11 3 3 0 61 230.263 3

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 900 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) 5.42 1.29 -14.19 0 3 0 35 326.351 1

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 15 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CCNB1-1-E G2/mitotic-specific Cyclin B1 (cluster #1 Of 2), Eukaryotic Eukaryotes 56 0.41 Binding ≤ 10μM
CCNB2-1-E G2/mitotic-specific Cyclin B2 (cluster #1 Of 2), Eukaryotic Eukaryotes 56 0.41 Binding ≤ 10μM
CCNB3-1-E G2/mitotic-specific Cyclin B3 (cluster #1 Of 2), Eukaryotic Eukaryotes 56 0.41 Binding ≤ 10μM
CDK1-1-E Cyclin-dependent Kinase 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 56 0.41 Binding ≤ 10μM
CLK3-1-E Dual Specificity Protein Kinase CLK3 (cluster #1 Of 1), Eukaryotic Eukaryotes 41 0.41 Binding ≤ 10μM
CSK21-1-E Casein Kinase II Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 1 0.50 Binding ≤ 10μM
DAPK3-1-E Death-associated Protein Kinase 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 17 0.44 Binding ≤ 10μM
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 55 0.41 Binding ≤ 10μM
HIPK3-1-E Homeodomain-interacting Protein Kinase 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 45 0.41 Binding ≤ 10μM
PIM1-1-E Serine/threonine-protein Kinase PIM1 (cluster #1 Of 1), Eukaryotic Eukaryotes 46 0.41 Binding ≤ 10μM
TBK1-1-E Serine/threonine-protein Kinase TBK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 35 0.42 Binding ≤ 10μM
Z103203-2-O A375 (cluster #2 Of 3), Other Other 3900 0.30 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 5300 0.30 Functional ≤ 10μM
Z80224-5-O MCF7 (Breast Carcinoma Cells) (cluster #5 Of 14), Other Other 8900 0.28 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 2100 0.32 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 3000 0.31 Functional ≤ 10μM
Z80928-5-O HCT-116 (Colon Carcinoma Cells) (cluster #5 Of 9), Other Other 2200 0.32 Functional ≤ 10μM
Z81072-6-O Jurkat (Acute Leukemic T-cells) (cluster #6 Of 10), Other Other 2500 0.31 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 4700 0.30 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 6400 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) 5.14 10.5 -55.54 1 5 -1 78 348.769 3
Hi High (pH 8-9.5) 1.84 5.03 -92.09 7 8 2 122 456.497 5

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z80035-5-O B16 (Melanoma Cells) (cluster #5 Of 7), Other Other 269 0.40 Functional ≤ 10μM
Z80186-6-O K562 (Erythroleukemia Cells) (cluster #6 Of 11), Other Other 218 0.41 Functional ≤ 10μM
Z80193-1-O L1210 (Lymphocytic Leukemia Cells) (cluster #1 Of 12), Other Other 415 0.39 Functional ≤ 10μM
Z80211-1-O LoVo (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 185 0.41 Functional ≤ 10μM
Z80224-12-O MCF7 (Breast Carcinoma Cells) (cluster #12 Of 14), Other Other 19 0.47 Functional ≤ 10μM
Z80244-4-O MDA-MB-468 (Breast Adenocarcinoma) (cluster #4 Of 7), Other Other 47 0.45 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 338 0.39 Functional ≤ 10μM
Z80461-1-O SCL-1 (cluster #1 Of 1), Other Other 383 0.39 Functional ≤ 10μM
Z80475-3-O SK-BR-3 (Breast Adenocarcinoma) (cluster #3 Of 3), Other Other 31 0.46 Functional ≤ 10μM
Z80566-1-O U-937 (Histiocytic Lymphoma Cells) (cluster #1 Of 2), Other Other 320 0.40 Functional ≤ 10μM
Z80852-1-O A-431 (Epidermoid Carcinoma Cells) (cluster #1 Of 3), Other Other 213 0.41 Functional ≤ 10μM
Z80901-1-O HaCaT (Keratinocytes) (cluster #1 Of 2), Other Other 47 0.45 Functional ≤ 10μM
Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 192 0.41 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 470 0.39 Functional ≤ 10μM
Z81252-7-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #7 Of 11), Other Other 428 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) 4.13 1.81 -10.68 1 5 0 65 316.353 7

Parameters Provided:

target.name = Z80186-6-O
target.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 activity AS ac ON ci.sub_id_fk=ac.sub_id_fk INNER JOIN target AS t ON ac.target_fk=t.target_id  WHERE c.free = 1 AND t.code LIKE 'Z80186-6-O' AND t.atype_fk = 5 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

Embed Link to Results