UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 68 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Z100081-3-O PBMC (Peripheral Blood Mononuclear Cells) (cluster #3 Of 4), Other Other 150 0.96 Functional ≤ 10μM
Z50425-15-O Plasmodium Falciparum (cluster #15 Of 22), Other Other 2000 0.80 Functional ≤ 10μM
Z80064-3-O CCRF-CEM (T-cell Leukemia) (cluster #3 Of 9), Other Other 1000 0.84 Functional ≤ 10μM
Z80068-2-O CCRF-SB (Lymphoblastic Leukemia Cells) (cluster #2 Of 5), Other Other 1000 0.84 Functional ≤ 10μM
Z80125-5-O DU-145 (Prostate Carcinoma) (cluster #5 Of 9), Other Other 2000 0.80 Functional ≤ 10μM
Z80193-6-O L1210 (Lymphocytic Leukemia Cells) (cluster #6 Of 12), Other Other 24 1.07 Functional ≤ 10μM
Z80224-4-O MCF7 (Breast Carcinoma Cells) (cluster #4 Of 14), Other Other 5800 0.73 Functional ≤ 10μM
Z80295-4-O MT4 (Lymphocytes) (cluster #4 Of 8), Other Other 100 0.98 Functional ≤ 10μM
Z80936-3-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #3 Of 4), Other Other 7 1.14 Functional ≤ 10μM
Z81020-5-O HepG2 (Hepatoblastoma Cells) (cluster #5 Of 8), Other Other 8000 0.71 Functional ≤ 10μM
Z81247-5-O HeLa (Cervical Adenocarcinoma Cells) (cluster #5 Of 9), Other Other 4100 0.75 Functional ≤ 10μM
Z80178-1-O J774.A1 (Macrophage Cells) (cluster #1 Of 2), Other Other 3 1.19 ADME/T ≤ 10μM
Z80936-3-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #3 Of 4), Other Other 7 1.14 ADME/T ≤ 10μM
Z81244-2-O J774 (Macrophage Cells) (cluster #2 Of 3), Other Other 3 1.19 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) -0.39 4.06 -18.68 2 4 0 57 152.182 0
Hi High (pH 8-9.5) 0.34 3.67 -44.86 1 4 -1 54 151.174 0
Hi High (pH 8-9.5) 0.34 3.66 -43.68 1 4 -1 54 151.174 0

Analogs

3917708
3917708

Draw Identity 99% 90% 80% 70%

Vendors

And 3 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AURKA-1-E Serine/threonine-protein Kinase Aurora-A (cluster #1 Of 3), Eukaryotic Eukaryotes 40 0.27 Binding ≤ 10μM
MMP2-2-E 72 KDa Type IV Collagenase (cluster #2 Of 3), Eukaryotic Eukaryotes 1100 0.21 Binding ≤ 10μM
TOP2A-1-E DNA Topoisomerase II Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.22 Binding ≤ 10μM
TOP1-1-E DNA Topoisomerase I (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.27 Functional ≤ 10μM
TOP2A-1-E DNA Topoisomerase II Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.27 Functional ≤ 10μM
TOP2B-1-E DNA Topoisomerase II Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.27 Functional ≤ 10μM
Z50643-2-O Hepatitis C Virus (cluster #2 Of 2), Other Other 2600 0.20 Binding ≤ 10μM
Z103196-1-O 22RV1 (cluster #1 Of 2), Other Other 1300 0.21 Functional ≤ 10μM
Z103203-1-O A375 (cluster #1 Of 3), Other Other 130 0.25 Functional ≤ 10μM
Z103205-1-O A431 (cluster #1 Of 4), Other Other 370 0.23 Functional ≤ 10μM
Z103219-1-O Ca9-22 (cluster #1 Of 1), Other Other 1300 0.21 Functional ≤ 10μM
Z50347-3-O Saccharomyces Cerevisiae (cluster #3 Of 3), Other Other 10000 0.18 Functional ≤ 10μM
Z50587-4-O Homo Sapiens (cluster #4 Of 9), Other Other 100 0.25 Functional ≤ 10μM
Z50643-2-O Hepatitis C Virus (cluster #2 Of 5), Other Other 300 0.23 Functional ≤ 10μM
Z80008-1-O 5637 (Epithelial Bladder Carcinoma Cells) (cluster #1 Of 3), Other Other 20 0.28 Functional ≤ 10μM
Z80017-1-O A2780cisR (Cisplatin-resistant Ovarian Carcinoma Cells) (cluster #1 Of 2), Other Other 6 0.30 Functional ≤ 10μM
Z80018-2-O A-375 (Malignant Melanoma Cells) (cluster #2 Of 4), Other Other 70 0.26 Functional ≤ 10μM
Z80021-3-O A498 (Renal Carcinoma Cells) (cluster #3 Of 5), Other Other 53 0.26 Functional ≤ 10μM
Z80025-1-O ACHN (Renal Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 700 0.22 Functional ≤ 10μM
Z80026-1-O AGS (Gastric Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 310 0.23 Functional ≤ 10μM
Z80035-1-O B16 (Melanoma Cells) (cluster #1 Of 7), Other Other 8 0.29 Functional ≤ 10μM
Z80039-1-O BGC-823 (Stomach Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 1000 0.22 Functional ≤ 10μM
Z80052-1-O C8166 (Leukemic T-cells) (cluster #1 Of 3), Other Other 50 0.26 Functional ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 4), Other Other 6700 0.19 Functional ≤ 10μM
Z80064-1-O CCRF-CEM (T-cell Leukemia) (cluster #1 Of 9), Other Other 90 0.25 Functional ≤ 10μM
Z80068-1-O CCRF-SB (Lymphoblastic Leukemia Cells) (cluster #1 Of 5), Other Other 50 0.26 Functional ≤ 10μM
Z80088-1-O CHO (Ovarian Cells) (cluster #1 Of 4), Other Other 6000 0.19 Functional ≤ 10μM
Z80092-1-O CHO-K1 (Ovarian Cells) (cluster #1 Of 2), Other Other 400 0.23 Functional ≤ 10μM
Z80105-2-O COR-L23 (Lung Carcinoma Cells) (cluster #2 Of 2), Other Other 319 0.23 Functional ≤ 10μM
Z80114-1-O Daudi (Burkitts Lymphoma Cells) (cluster #1 Of 4), Other Other 300 0.23 Functional ≤ 10μM
Z80125-1-O DU-145 (Prostate Carcinoma) (cluster #1 Of 9), Other Other 2540 0.20 Functional ≤ 10μM
Z80125-1-O DU-145 (Prostate Carcinoma) (cluster #1 Of 9), Other Other 6240 0.19 Functional ≤ 10μM
Z80126-2-O DuPro (cluster #2 Of 2), Other Other 1800 0.21 Functional ≤ 10μM
Z80138-1-O G-361 (Melanoma Cells) (cluster #1 Of 1), Other Other 90 0.25 Functional ≤ 10μM
Z80145-3-O H69 (cluster #3 Of 4), Other Other 870 0.22 Functional ≤ 10μM
Z80156-2-O HL-60 (Promyeloblast Leukemia Cells) (cluster #2 Of 12), Other Other 920 0.22 Functional ≤ 10μM
Z80156-2-O HL-60 (Promyeloblast Leukemia Cells) (cluster #2 Of 12), Other Other 940 0.22 Functional ≤ 10μM
Z80164-1-O HT-1080 (Fibrosarcoma Cells) (cluster #1 Of 6), Other Other 4700 0.19 Functional ≤ 10μM
Z80164-1-O HT-1080 (Fibrosarcoma Cells) (cluster #1 Of 6), Other Other 9320 0.18 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 92 0.25 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 950 0.22 Functional ≤ 10μM
Z80175-1-O IMR-32 (Neuroblastoma Cells) (cluster #1 Of 2), Other Other 10 0.29 Functional ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 11), Other Other 90 0.25 Functional ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 11), Other Other 430 0.23 Functional ≤ 10μM
Z80188-1-O KB 3-1 (Cervical Epithelial Carcinoma Cells) (cluster #1 Of 2), Other Other 21 0.28 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 900 0.22 Functional ≤ 10μM
Z80211-1-O LoVo (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 200 0.24 Functional ≤ 10μM
Z80211-1-O LoVo (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 9700 0.18 Functional ≤ 10μM
Z80214-2-O M14 (Melanoma Cells) (cluster #2 Of 3), Other Other 820 0.22 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 80 0.25 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 920 0.22 Functional ≤ 10μM
Z80227-1-O MCF7-ADR (Breast Carcinoma Cells) (cluster #1 Of 2), Other Other 6700 0.19 Functional ≤ 10μM
Z80240-1-O MDA-MB-361 (cluster #1 Of 1), Other Other 33 0.27 Functional ≤ 10μM
Z80243-1-O MDA-MB-453 (Breast Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 120 0.25 Functional ≤ 10μM
Z80244-4-O MDA-MB-468 (Breast Adenocarcinoma) (cluster #4 Of 7), Other Other 7 0.29 Functional ≤ 10μM
Z80254-1-O MES-SA (Uterine Sarcoma Cells) (cluster #1 Of 2), Other Other 10 0.29 Functional ≤ 10μM
Z80255-2-O MES-SA/DxS (Uterine Sarcoma Cells) (cluster #2 Of 2), Other Other 704 0.22 Functional ≤ 10μM
Z80267-1-O MKN-1 (cluster #1 Of 1), Other Other 640 0.22 Functional ≤ 10μM
Z80269-1-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 3130 0.20 Functional ≤ 10μM
Z80285-2-O MOLT-4 (Acute T-lymphoblastic Leukemia Cells) (cluster #2 Of 4), Other Other 50 0.26 Functional ≤ 10μM
Z80291-1-O MRC5 (Embryonic Lung Fibroblast Cells) (cluster #1 Of 3), Other Other 100 0.25 Functional ≤ 10μM
Z80295-6-O MT4 (Lymphocytes) (cluster #6 Of 8), Other Other 50 0.26 Functional ≤ 10μM
Z80322-2-O NCI-H358 (Lung Carcinama Cells) (cluster #2 Of 2), Other Other 620 0.22 Functional ≤ 10μM
Z80330-1-O NCI-N87 (cluster #1 Of 1), Other Other 420 0.23 Functional ≤ 10μM
Z80354-4-O OVCAR-3 (Ovarian Adenocarcinoma Cells) (cluster #4 Of 4), Other Other 35 0.27 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 17 0.28 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 830 0.22 Functional ≤ 10μM
Z80364-1-O P388/ADR (Lymphoma Cells) (cluster #1 Of 1), Other Other 90 0.25 Functional ≤ 10μM
Z80367-1-O P388/S (cluster #1 Of 1), Other Other 13 0.28 Functional ≤ 10μM
Z80389-1-O PC-14 (cluster #1 Of 1), Other Other 290 0.23 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 680 0.22 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 912 0.22 Functional ≤ 10μM
Z80414-1-O Raji (B-lymphoblastic Cells) (cluster #1 Of 3), Other Other 30 0.27 Functional ≤ 10μM
Z80433-1-O RPMI-8226 (Multiple Myeloma Cells) (cluster #1 Of 3), Other Other 560 0.22 Functional ≤ 10μM
Z80441-1-O RXF 944 (cluster #1 Of 1), Other Other 60 0.26 Functional ≤ 10μM
Z80466-1-O SF268 (cluster #1 Of 4), Other Other 600 0.22 Functional ≤ 10μM
Z80468-1-O SF-295 (Glioblastoma Cells) (cluster #1 Of 2), Other Other 35 0.27 Functional ≤ 10μM
Z80472-1-O SiHa (Cervical Squamous Cell Carcinoma) (cluster #1 Of 2), Other Other 500 0.23 Functional ≤ 10μM
Z80475-1-O SK-BR-3 (Breast Adenocarcinoma) (cluster #1 Of 3), Other Other 20 0.28 Functional ≤ 10μM
Z80477-1-O SK_HEP1 (Hepatoma Cells) (cluster #1 Of 1), Other Other 100 0.25 Functional ≤ 10μM
Z80479-1-O SK-MEL (Melanoma Cells) (cluster #1 Of 1), Other Other 1730 0.21 Functional ≤ 10μM
Z80481-1-O SK-MEL-1 (Metastatic Melanoma Cells) (cluster #1 Of 1), Other Other 3092 0.20 Functional ≤ 10μM
Z80482-3-O SK-MEL-2 (Melanoma Cells) (cluster #3 Of 4), Other Other 97 0.25 Functional ≤ 10μM
Z80485-1-O SK-MEL-28 (Melanoma Cells) (cluster #1 Of 6), Other Other 600 0.22 Functional ≤ 10μM
Z80490-3-O SK-MES-1 (cluster #3 Of 4), Other Other 30 0.27 Functional ≤ 10μM
Z80491-2-O SK-N-MC (Neuroepithelioma Cells) (cluster #2 Of 4), Other Other 120 0.25 Functional ≤ 10μM
Z80492-1-O SK-N-SH (Neuroblastoma Cells) (cluster #1 Of 2), Other Other 1100 0.21 Functional ≤ 10μM
Z80493-1-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #1 Of 6), Other Other 800 0.22 Functional ≤ 10μM
Z80495-1-O SK-VLB (cluster #1 Of 1), Other Other 6540 0.19 Functional ≤ 10μM
Z80503-1-O SNU1 (cluster #1 Of 2), Other Other 4000 0.19 Functional ≤ 10μM
Z80509-1-O SNU-638 (Gastric Carcinoma Cells) (cluster #1 Of 1), Other Other 690 0.22 Functional ≤ 10μM
Z80526-1-O SW480 (Colon Adenocarcinoma Cells) (cluster #1 Of 6), Other Other 60 0.26 Functional ≤ 10μM
Z80532-1-O T-24 (Bladder Carcinoma Cells) (cluster #1 Of 6), Other Other 640 0.22 Functional ≤ 10μM
Z80559-1-O U251 (cluster #1 Of 3), Other Other 90 0.25 Functional ≤ 10μM
Z80560-1-O U-251 (Glioma Cells) (cluster #1 Of 3), Other Other 90 0.25 Functional ≤ 10μM
Z80563-1-O U-373 MG ( Glioblastoma Cells) (cluster #1 Of 1), Other Other 10 0.29 Functional ≤ 10μM
Z80565-1-O U-87 MG (Glioblastoma Cells) (cluster #1 Of 2), Other Other 60 0.26 Functional ≤ 10μM
Z80574-2-O UMUC3 (cluster #2 Of 2), Other Other 9 0.29 Functional ≤ 10μM
Z80581-1-O VA13 (cluster #1 Of 1), Other Other 400 0.23 Functional ≤ 10μM
Z80581-1-O VA13 (cluster #1 Of 1), Other Other 699 0.22 Functional ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 7), Other Other 5000 0.19 Functional ≤ 10μM
Z80595-1-O WIL2-NS (Lymphoblastoid Cells) (cluster #1 Of 2), Other Other 200 0.24 Functional ≤ 10μM
Z80600-2-O XF498 (Glioma Cells) (cluster #2 Of 2), Other Other 44 0.26 Functional ≤ 10μM
Z80608-1-O ZR-75-1 (Breast Carcinoma Cells) (cluster #1 Of 4), Other Other 9 0.29 Functional ≤ 10μM
Z80640-1-O 786-0 (Renal Carcinoma Cells) (cluster #1 Of 1), Other Other 3100 0.20 Functional ≤ 10μM
Z80661-1-O A704 (Renal Carcinoma Cells) (cluster #1 Of 1), Other Other 2000 0.20 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 540 0.22 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 970 0.22 Functional ≤ 10μM
Z80697-1-O Bel-7402 (Hepatoma Cells) (cluster #1 Of 3), Other Other 1000 0.22 Functional ≤ 10μM
Z80712-2-O T47D (Breast Carcinoma Cells) (cluster #2 Of 7), Other Other 72 0.26 Functional ≤ 10μM
Z80726-1-O TRAMP-C1A (Prostate Carcinoma Cells) (cluster #1 Of 1), Other Other 76 0.26 Functional ≤ 10μM
Z80730-1-O C2D Cell Line (cluster #1 Of 1), Other Other 47 0.26 Functional ≤ 10μM
Z80731-1-O C2G Cell Line (cluster #1 Of 1), Other Other 29 0.27 Functional ≤ 10μM
Z80732-1-O TRAMP-C2H (Prostate Carcinoma Cells) (cluster #1 Of 1), Other Other 30 0.27 Functional ≤ 10μM
Z80735-1-O C38 (Colon Carcinoma) (cluster #1 Of 1), Other Other 10 0.29 Functional ≤ 10μM
Z80768-1-O CH1 (Ovarian Carcinoma Cells) (cluster #1 Of 1), Other Other 6 0.30 Functional ≤ 10μM
Z80784-1-O Col2 (Colon Carcinoma Cells) (cluster #1 Of 2), Other Other 520 0.23 Functional ≤ 10μM
Z80801-2-O CRL-7065 Cell Line (cluster #2 Of 2), Other Other 500 0.23 Functional ≤ 10μM
Z80819-1-O J774.2 (cluster #1 Of 1), Other Other 368 0.23 Functional ≤ 10μM
Z80846-1-O F460pv8/eto Cell Line (cluster #1 Of 2), Other Other 20 0.28 Functional ≤ 10μM
Z80852-1-O A-431 (Epidermoid Carcinoma Cells) (cluster #1 Of 3), Other Other 50 0.26 Functional ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 7), Other Other 60 0.26 Functional ≤ 10μM
Z80887-1-O H2981 Cell Line (cluster #1 Of 1), Other Other 700 0.22 Functional ≤ 10μM
Z80889-1-O NCI-H322M (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 30 0.27 Functional ≤ 10μM
Z80896-1-O NCI-H69 (Small Cell Lung Carcinoma Cells) (cluster #1 Of 1), Other Other 27 0.27 Functional ≤ 10μM
Z80928-1-O HCT-116 (Colon Carcinoma Cells) (cluster #1 Of 9), Other Other 90 0.25 Functional ≤ 10μM
Z80928-1-O HCT-116 (Colon Carcinoma Cells) (cluster #1 Of 9), Other Other 6810 0.19 Functional ≤ 10μM
Z80936-1-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #1 Of 4), Other Other 900 0.22 Functional ≤ 10μM
Z80943-1-O HEL 299 (cluster #1 Of 1), Other Other 1700 0.21 Functional ≤ 10μM
Z80945-1-O HEp-2 (Laryngeal Carcinoma Cells) (cluster #1 Of 4), Other Other 59 0.26 Functional ≤ 10μM
Z81005-1-O HTB-54 Cell Line (cluster #1 Of 1), Other Other 1100 0.21 Functional ≤ 10μM
Z81006-1-O Human Breast 401NL Tumor Cell Line (cluster #1 Of 1), Other Other 10 0.29 Functional ≤ 10μM
Z81017-1-O WiDr (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 620 0.22 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 954 0.22 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 1290 0.21 Functional ≤ 10μM
Z81024-1-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #1 Of 8), Other Other 660 0.22 Functional ≤ 10μM
Z81025-1-O Human Lung LXF 529L Tumor Cell Line (cluster #1 Of 1), Other Other 30 0.27 Functional ≤ 10μM
Z81026-1-O Human Lung LXF 629L Tumor Cell Line (cluster #1 Of 1), Other Other 70 0.26 Functional ≤ 10μM
Z81028-1-O Human Melanoma Cell Line (cluster #1 Of 1), Other Other 280 0.24 Functional ≤ 10μM
Z81034-2-O A2780 (Ovarian Carcinoma Cells) (cluster #2 Of 10), Other Other 10 0.29 Functional ≤ 10μM
Z81043-1-O N592 (cluster #1 Of 2), Other Other 40 0.27 Functional ≤ 10μM
Z81054-1-O SF-268 (Glioblastoma Cells) (cluster #1 Of 3), Other Other 40 0.27 Functional ≤ 10μM
Z81072-1-O Jurkat (Acute Leukemic T-cells) (cluster #1 Of 10), Other Other 90 0.25 Functional ≤ 10μM
Z81101-1-O KBM-3 Cell Line (cluster #1 Of 1), Other Other 26 0.27 Functional ≤ 10μM
Z81102-1-O KBM-3/DOX Cell Line (cluster #1 Of 1), Other Other 490 0.23 Functional ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 6), Other Other 600 0.22 Functional ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 6), Other Other 7010 0.19 Functional ≤ 10μM
Z81133-1-O L1210 (1565) (cluster #1 Of 1), Other Other 315 0.23 Functional ≤ 10μM
Z81134-1-O L2987 (Lung Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 300 0.23 Functional ≤ 10μM
Z81160-1-O Lewis Lung Carcinoma Cell Line (cluster #1 Of 1), Other Other 22 0.27 Functional ≤ 10μM
Z81164-1-O LL Cell Line (cluster #1 Of 2), Other Other 22 0.27 Functional ≤ 10μM
Z81167-1-O LLTC Cell Line (cluster #1 Of 1), Other Other 22 0.27 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 78 0.26 Functional ≤ 10μM
Z81184-1-O LOX IMVI (Melanoma Cells) (cluster #1 Of 5), Other Other 42 0.26 Functional ≤ 10μM
Z81201-1-O HOP-62 (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 4 0.30 Functional ≤ 10μM
Z81211-1-O LXFL529 Cell Line (cluster #1 Of 1), Other Other 40 0.27 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 79 0.25 Functional ≤ 10μM
Z81245-1-O MDA-MB-435 (Breast Carcinoma Cells) (cluster #1 Of 6), Other Other 960 0.22 Functional ≤ 10μM
Z81247-1-O HeLa (Cervical Adenocarcinoma Cells) (cluster #1 Of 9), Other Other 710 0.22 Functional ≤ 10μM
Z81247-1-O HeLa (Cervical Adenocarcinoma Cells) (cluster #1 Of 9), Other Other 730 0.22 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 70 0.26 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 840 0.22 Functional ≤ 10μM
Z81257-1-O MEL-AC Cell Line (cluster #1 Of 1), Other Other 1200 0.21 Functional ≤ 10μM
Z81261-1-O UACC-375 (cluster #1 Of 1), Other Other 112 0.25 Functional ≤ 10μM
Z81277-2-O NCI-N417 (cluster #2 Of 2), Other Other 230 0.24 Functional ≤ 10μM
Z81280-1-O NCI-H226 (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 8 0.29 Functional ≤ 10μM
Z81284-1-O NCI-H647 (cluster #1 Of 2), Other Other 1 0.32 Functional ≤ 10μM
Z81331-1-O SW-620 (Colon Adenocarcinoma Cells) (cluster #1 Of 6), Other Other 80 0.25 Functional ≤ 10μM
Z81335-1-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 820 0.22 Functional ≤ 10μM
Z81335-1-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 2320 0.20 Functional ≤ 10μM
Z81341-1-O Tumor Cell Lines (cluster #1 Of 1), Other Other 74 0.26 Functional ≤ 10μM
Z100081-1-O PBMC (Peripheral Blood Mononuclear Cells) (cluster #1 Of 2), Other Other 500 0.23 ADME/T ≤ 10μM
Z80002-1-O 1A9 (Ovarian Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 100 0.25 ADME/T ≤ 10μM
Z80005-1-O 3T3 (Fibroblast Cells) (cluster #1 Of 2), Other Other 3700 0.19 ADME/T ≤ 10μM
Z80035-1-O B16 (Melanoma Cells) (cluster #1 Of 1), Other Other 100 0.25 ADME/T ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 600 0.22 ADME/T ≤ 10μM
Z80064-1-O CCRF-CEM (T-cell Leukemia) (cluster #1 Of 2), Other Other 60 0.26 ADME/T ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 480 0.23 ADME/T ≤ 10μM
Z80178-2-O J774.A1 (Macrophage Cells) (cluster #2 Of 2), Other Other 20 0.28 ADME/T ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 3), Other Other 60 0.26 ADME/T ≤ 10μM
Z80193-3-O L1210 (Lymphocytic Leukemia Cells) (cluster #3 Of 4), Other Other 29 0.27 ADME/T ≤ 10μM
Z80211-1-O LoVo (Colon Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 33 0.27 ADME/T ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 2), Other Other 70 0.26 ADME/T ≤ 10μM
Z80253-2-O MEF (Embryonic Fibroblast Cells) (cluster #2 Of 2), Other Other 3400 0.20 ADME/T ≤ 10μM
Z80291-1-O MRC5 (Embryonic Lung Fibroblast Cells) (cluster #1 Of 3), Other Other 300 0.23 ADME/T ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 2000 0.20 ADME/T ≤ 10μM
Z80548-2-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #2 Of 4), Other Other 8 0.29 ADME/T ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 3), Other Other 7400 0.18 ADME/T ≤ 10μM
Z80682-2-O A549 (Lung Carcinoma Cells) (cluster #2 Of 3), Other Other 900 0.22 ADME/T ≤ 10μM
Z80704-1-O BJ (Foreskin Fibroblast Cells) (cluster #1 Of 2), Other Other 2700 0.20 ADME/T ≤ 10μM
Z80936-4-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #4 Of 4), Other Other 64 0.26 ADME/T ≤ 10μM
Z81020-1-O HepG2 (Hepatoblastoma Cells) (cluster #1 Of 1), Other Other 420 0.23 ADME/T ≤ 10μM
Z81024-1-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #1 Of 1), Other Other 10 0.29 ADME/T ≤ 10μM
Z81034-2-O A2780 (Ovarian Carcinoma Cells) (cluster #2 Of 2), Other Other 7 0.29 ADME/T ≤ 10μM
Z81057-5-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #5 Of 5), Other Other 30 0.27 ADME/T ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 3), Other Other 400 0.23 ADME/T ≤ 10μM
Z81331-2-O SW-620 (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 178 0.24 ADME/T ≤ 10μM
Q7ZJM1-1-V Human Immunodeficiency Virus Type 1 Integrase (cluster #1 Of 6), Viral Viruses 900 0.22 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) 0.57 -0.88 -58.15 8 12 1 208 544.533 5

Analogs

3830631
3830631

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
AURKA-1-E Serine/threonine-protein Kinase Aurora-A (cluster #1 Of 3), Eukaryotic Eukaryotes 40 0.27 Binding ≤ 10μM
MMP2-2-E 72 KDa Type IV Collagenase (cluster #2 Of 3), Eukaryotic Eukaryotes 1100 0.21 Binding ≤ 10μM
TOP2A-1-E DNA Topoisomerase II Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.22 Binding ≤ 10μM
TOP1-1-E DNA Topoisomerase I (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.27 Functional ≤ 10μM
TOP2A-1-E DNA Topoisomerase II Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.27 Functional ≤ 10μM
TOP2B-1-E DNA Topoisomerase II Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 22 0.27 Functional ≤ 10μM
Z50643-2-O Hepatitis C Virus (cluster #2 Of 2), Other Other 2600 0.20 Binding ≤ 10μM
Z103203-1-O A375 (cluster #1 Of 3), Other Other 130 0.25 Functional ≤ 10μM
Z103205-1-O A431 (cluster #1 Of 4), Other Other 370 0.23 Functional ≤ 10μM
Z103219-1-O Ca9-22 (cluster #1 Of 1), Other Other 1300 0.21 Functional ≤ 10μM
Z50347-3-O Saccharomyces Cerevisiae (cluster #3 Of 3), Other Other 10000 0.18 Functional ≤ 10μM
Z50587-4-O Homo Sapiens (cluster #4 Of 9), Other Other 100 0.25 Functional ≤ 10μM
Z50643-2-O Hepatitis C Virus (cluster #2 Of 5), Other Other 300 0.23 Functional ≤ 10μM
Z80008-1-O 5637 (Epithelial Bladder Carcinoma Cells) (cluster #1 Of 3), Other Other 20 0.28 Functional ≤ 10μM
Z80017-1-O A2780cisR (Cisplatin-resistant Ovarian Carcinoma Cells) (cluster #1 Of 2), Other Other 6 0.30 Functional ≤ 10μM
Z80018-2-O A-375 (Malignant Melanoma Cells) (cluster #2 Of 4), Other Other 70 0.26 Functional ≤ 10μM
Z80021-3-O A498 (Renal Carcinoma Cells) (cluster #3 Of 5), Other Other 53 0.26 Functional ≤ 10μM
Z80025-1-O ACHN (Renal Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 700 0.22 Functional ≤ 10μM
Z80026-1-O AGS (Gastric Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 310 0.23 Functional ≤ 10μM
Z80035-1-O B16 (Melanoma Cells) (cluster #1 Of 7), Other Other 8 0.29 Functional ≤ 10μM
Z80039-1-O BGC-823 (Stomach Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 1000 0.22 Functional ≤ 10μM
Z80052-1-O C8166 (Leukemic T-cells) (cluster #1 Of 3), Other Other 50 0.26 Functional ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 4), Other Other 6700 0.19 Functional ≤ 10μM
Z80064-1-O CCRF-CEM (T-cell Leukemia) (cluster #1 Of 9), Other Other 90 0.25 Functional ≤ 10μM
Z80068-1-O CCRF-SB (Lymphoblastic Leukemia Cells) (cluster #1 Of 5), Other Other 50 0.26 Functional ≤ 10μM
Z80088-1-O CHO (Ovarian Cells) (cluster #1 Of 4), Other Other 6000 0.19 Functional ≤ 10μM
Z80092-1-O CHO-K1 (Ovarian Cells) (cluster #1 Of 2), Other Other 400 0.23 Functional ≤ 10μM
Z80105-2-O COR-L23 (Lung Carcinoma Cells) (cluster #2 Of 2), Other Other 319 0.23 Functional ≤ 10μM
Z80114-1-O Daudi (Burkitts Lymphoma Cells) (cluster #1 Of 4), Other Other 300 0.23 Functional ≤ 10μM
Z80125-1-O DU-145 (Prostate Carcinoma) (cluster #1 Of 9), Other Other 6240 0.19 Functional ≤ 10μM
Z80126-2-O DuPro (cluster #2 Of 2), Other Other 1800 0.21 Functional ≤ 10μM
Z80138-1-O G-361 (Melanoma Cells) (cluster #1 Of 1), Other Other 90 0.25 Functional ≤ 10μM
Z80145-3-O H69 (cluster #3 Of 4), Other Other 870 0.22 Functional ≤ 10μM
Z80156-2-O HL-60 (Promyeloblast Leukemia Cells) (cluster #2 Of 12), Other Other 920 0.22 Functional ≤ 10μM
Z80164-1-O HT-1080 (Fibrosarcoma Cells) (cluster #1 Of 6), Other Other 9320 0.18 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 92 0.25 Functional ≤ 10μM
Z80175-1-O IMR-32 (Neuroblastoma Cells) (cluster #1 Of 2), Other Other 10 0.29 Functional ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 11), Other Other 90 0.25 Functional ≤ 10μM
Z80188-1-O KB 3-1 (Cervical Epithelial Carcinoma Cells) (cluster #1 Of 2), Other Other 21 0.28 Functional ≤ 10μM
Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 900 0.22 Functional ≤ 10μM
Z80211-1-O LoVo (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 9700 0.18 Functional ≤ 10μM
Z80214-2-O M14 (Melanoma Cells) (cluster #2 Of 3), Other Other 820 0.22 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 920 0.22 Functional ≤ 10μM
Z80227-1-O MCF7-ADR (Breast Carcinoma Cells) (cluster #1 Of 2), Other Other 6700 0.19 Functional ≤ 10μM
Z80240-1-O MDA-MB-361 (cluster #1 Of 1), Other Other 33 0.27 Functional ≤ 10μM
Z80243-1-O MDA-MB-453 (Breast Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 120 0.25 Functional ≤ 10μM
Z80244-4-O MDA-MB-468 (Breast Adenocarcinoma) (cluster #4 Of 7), Other Other 7 0.29 Functional ≤ 10μM
Z80254-1-O MES-SA (Uterine Sarcoma Cells) (cluster #1 Of 2), Other Other 10 0.29 Functional ≤ 10μM
Z80255-2-O MES-SA/DxS (Uterine Sarcoma Cells) (cluster #2 Of 2), Other Other 704 0.22 Functional ≤ 10μM
Z80267-1-O MKN-1 (cluster #1 Of 1), Other Other 640 0.22 Functional ≤ 10μM
Z80269-1-O MKN-45 (Gastric Adenocarcinoma Cells) (cluster #1 Of 3), Other Other 3130 0.20 Functional ≤ 10μM
Z80285-2-O MOLT-4 (Acute T-lymphoblastic Leukemia Cells) (cluster #2 Of 4), Other Other 50 0.26 Functional ≤ 10μM
Z80291-1-O MRC5 (Embryonic Lung Fibroblast Cells) (cluster #1 Of 3), Other Other 100 0.25 Functional ≤ 10μM
Z80295-6-O MT4 (Lymphocytes) (cluster #6 Of 8), Other Other 50 0.26 Functional ≤ 10μM
Z80322-2-O NCI-H358 (Lung Carcinama Cells) (cluster #2 Of 2), Other Other 620 0.22 Functional ≤ 10μM
Z80330-1-O NCI-N87 (cluster #1 Of 1), Other Other 420 0.23 Functional ≤ 10μM
Z80354-4-O OVCAR-3 (Ovarian Adenocarcinoma Cells) (cluster #4 Of 4), Other Other 35 0.27 Functional ≤ 10μM
Z80362-1-O P388 (Lymphoma Cells) (cluster #1 Of 8), Other Other 830 0.22 Functional ≤ 10μM
Z80364-1-O P388/ADR (Lymphoma Cells) (cluster #1 Of 1), Other Other 90 0.25 Functional ≤ 10μM
Z80367-1-O P388/S (cluster #1 Of 1), Other Other 13 0.28 Functional ≤ 10μM
Z80389-1-O PC-14 (cluster #1 Of 1), Other Other 290 0.23 Functional ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 10), Other Other 912 0.22 Functional ≤ 10μM
Z80414-1-O Raji (B-lymphoblastic Cells) (cluster #1 Of 3), Other Other 30 0.27 Functional ≤ 10μM
Z80433-1-O RPMI-8226 (Multiple Myeloma Cells) (cluster #1 Of 3), Other Other 560 0.22 Functional ≤ 10μM
Z80441-1-O RXF 944 (cluster #1 Of 1), Other Other 60 0.26 Functional ≤ 10μM
Z80466-1-O SF268 (cluster #1 Of 4), Other Other 600 0.22 Functional ≤ 10μM
Z80468-1-O SF-295 (Glioblastoma Cells) (cluster #1 Of 2), Other Other 35 0.27 Functional ≤ 10μM
Z80472-1-O SiHa (Cervical Squamous Cell Carcinoma) (cluster #1 Of 2), Other Other 500 0.23 Functional ≤ 10μM
Z80475-1-O SK-BR-3 (Breast Adenocarcinoma) (cluster #1 Of 3), Other Other 20 0.28 Functional ≤ 10μM
Z80477-1-O SK_HEP1 (Hepatoma Cells) (cluster #1 Of 1), Other Other 100 0.25 Functional ≤ 10μM
Z80479-1-O SK-MEL (Melanoma Cells) (cluster #1 Of 1), Other Other 1730 0.21 Functional ≤ 10μM
Z80481-1-O SK-MEL-1 (Metastatic Melanoma Cells) (cluster #1 Of 1), Other Other 3092 0.20 Functional ≤ 10μM
Z80482-3-O SK-MEL-2 (Melanoma Cells) (cluster #3 Of 4), Other Other 97 0.25 Functional ≤ 10μM
Z80485-1-O SK-MEL-28 (Melanoma Cells) (cluster #1 Of 6), Other Other 600 0.22 Functional ≤ 10μM
Z80490-3-O SK-MES-1 (cluster #3 Of 4), Other Other 30 0.27 Functional ≤ 10μM
Z80491-2-O SK-N-MC (Neuroepithelioma Cells) (cluster #2 Of 4), Other Other 120 0.25 Functional ≤ 10μM
Z80492-1-O SK-N-SH (Neuroblastoma Cells) (cluster #1 Of 2), Other Other 1100 0.21 Functional ≤ 10μM
Z80493-1-O SK-OV-3 (Ovarian Carcinoma Cells) (cluster #1 Of 6), Other Other 800 0.22 Functional ≤ 10μM
Z80495-1-O SK-VLB (cluster #1 Of 1), Other Other 6540 0.19 Functional ≤ 10μM
Z80503-1-O SNU1 (cluster #1 Of 2), Other Other 4000 0.19 Functional ≤ 10μM
Z80509-1-O SNU-638 (Gastric Carcinoma Cells) (cluster #1 Of 1), Other Other 690 0.22 Functional ≤ 10μM
Z80526-1-O SW480 (Colon Adenocarcinoma Cells) (cluster #1 Of 6), Other Other 60 0.26 Functional ≤ 10μM
Z80532-1-O T-24 (Bladder Carcinoma Cells) (cluster #1 Of 6), Other Other 640 0.22 Functional ≤ 10μM
Z80559-1-O U251 (cluster #1 Of 3), Other Other 90 0.25 Functional ≤ 10μM
Z80560-1-O U-251 (Glioma Cells) (cluster #1 Of 3), Other Other 90 0.25 Functional ≤ 10μM
Z80563-1-O U-373 MG ( Glioblastoma Cells) (cluster #1 Of 1), Other Other 10 0.29 Functional ≤ 10μM
Z80565-1-O U-87 MG (Glioblastoma Cells) (cluster #1 Of 2), Other Other 60 0.26 Functional ≤ 10μM
Z80574-2-O UMUC3 (cluster #2 Of 2), Other Other 9 0.29 Functional ≤ 10μM
Z80581-1-O VA13 (cluster #1 Of 1), Other Other 699 0.22 Functional ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 7), Other Other 5000 0.19 Functional ≤ 10μM
Z80595-1-O WIL2-NS (Lymphoblastoid Cells) (cluster #1 Of 2), Other Other 200 0.24 Functional ≤ 10μM
Z80600-2-O XF498 (Glioma Cells) (cluster #2 Of 2), Other Other 44 0.26 Functional ≤ 10μM
Z80608-1-O ZR-75-1 (Breast Carcinoma Cells) (cluster #1 Of 4), Other Other 9 0.29 Functional ≤ 10μM
Z80661-1-O A704 (Renal Carcinoma Cells) (cluster #1 Of 1), Other Other 2000 0.20 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 970 0.22 Functional ≤ 10μM
Z80697-1-O Bel-7402 (Hepatoma Cells) (cluster #1 Of 3), Other Other 1000 0.22 Functional ≤ 10μM
Z80712-2-O T47D (Breast Carcinoma Cells) (cluster #2 Of 7), Other Other 72 0.26 Functional ≤ 10μM
Z80726-1-O TRAMP-C1A (Prostate Carcinoma Cells) (cluster #1 Of 1), Other Other 76 0.26 Functional ≤ 10μM
Z80730-1-O C2D Cell Line (cluster #1 Of 1), Other Other 47 0.26 Functional ≤ 10μM
Z80731-1-O C2G Cell Line (cluster #1 Of 1), Other Other 29 0.27 Functional ≤ 10μM
Z80732-1-O TRAMP-C2H (Prostate Carcinoma Cells) (cluster #1 Of 1), Other Other 30 0.27 Functional ≤ 10μM
Z80735-1-O C38 (Colon Carcinoma) (cluster #1 Of 1), Other Other 10 0.29 Functional ≤ 10μM
Z80768-1-O CH1 (Ovarian Carcinoma Cells) (cluster #1 Of 1), Other Other 6 0.30 Functional ≤ 10μM
Z80784-1-O Col2 (Colon Carcinoma Cells) (cluster #1 Of 2), Other Other 520 0.23 Functional ≤ 10μM
Z80801-2-O CRL-7065 Cell Line (cluster #2 Of 2), Other Other 500 0.23 Functional ≤ 10μM
Z80819-1-O J774.2 (cluster #1 Of 1), Other Other 368 0.23 Functional ≤ 10μM
Z80846-1-O F460pv8/eto Cell Line (cluster #1 Of 2), Other Other 20 0.28 Functional ≤ 10μM
Z80852-1-O A-431 (Epidermoid Carcinoma Cells) (cluster #1 Of 3), Other Other 50 0.26 Functional ≤ 10μM
Z80874-1-O CEM (T-cell Leukemia) (cluster #1 Of 7), Other Other 60 0.26 Functional ≤ 10μM
Z80887-1-O H2981 Cell Line (cluster #1 Of 1), Other Other 700 0.22 Functional ≤ 10μM
Z80889-1-O NCI-H322M (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 30 0.27 Functional ≤ 10μM
Z80896-1-O NCI-H69 (Small Cell Lung Carcinoma Cells) (cluster #1 Of 1), Other Other 27 0.27 Functional ≤ 10μM
Z80928-1-O HCT-116 (Colon Carcinoma Cells) (cluster #1 Of 9), Other Other 90 0.25 Functional ≤ 10μM
Z80936-1-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #1 Of 4), Other Other 900 0.22 Functional ≤ 10μM
Z80943-1-O HEL 299 (cluster #1 Of 1), Other Other 1700 0.21 Functional ≤ 10μM
Z80945-1-O HEp-2 (Laryngeal Carcinoma Cells) (cluster #1 Of 4), Other Other 59 0.26 Functional ≤ 10μM
Z81005-1-O HTB-54 Cell Line (cluster #1 Of 1), Other Other 1100 0.21 Functional ≤ 10μM
Z81006-1-O Human Breast 401NL Tumor Cell Line (cluster #1 Of 1), Other Other 10 0.29 Functional ≤ 10μM
Z81017-1-O WiDr (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 620 0.22 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 954 0.22 Functional ≤ 10μM
Z81024-1-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #1 Of 8), Other Other 660 0.22 Functional ≤ 10μM
Z81025-1-O Human Lung LXF 529L Tumor Cell Line (cluster #1 Of 1), Other Other 30 0.27 Functional ≤ 10μM
Z81026-1-O Human Lung LXF 629L Tumor Cell Line (cluster #1 Of 1), Other Other 70 0.26 Functional ≤ 10μM
Z81028-1-O Human Melanoma Cell Line (cluster #1 Of 1), Other Other 280 0.24 Functional ≤ 10μM
Z81034-2-O A2780 (Ovarian Carcinoma Cells) (cluster #2 Of 10), Other Other 10 0.29 Functional ≤ 10μM
Z81043-1-O N592 (cluster #1 Of 2), Other Other 40 0.27 Functional ≤ 10μM
Z81054-1-O SF-268 (Glioblastoma Cells) (cluster #1 Of 3), Other Other 40 0.27 Functional ≤ 10μM
Z81072-1-O Jurkat (Acute Leukemic T-cells) (cluster #1 Of 10), Other Other 90 0.25 Functional ≤ 10μM
Z81101-1-O KBM-3 Cell Line (cluster #1 Of 1), Other Other 26 0.27 Functional ≤ 10μM
Z81102-1-O KBM-3/DOX Cell Line (cluster #1 Of 1), Other Other 490 0.23 Functional ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 6), Other Other 7010 0.19 Functional ≤ 10μM
Z81133-1-O L1210 (1565) (cluster #1 Of 1), Other Other 315 0.23 Functional ≤ 10μM
Z81134-1-O L2987 (Lung Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 300 0.23 Functional ≤ 10μM
Z81160-1-O Lewis Lung Carcinoma Cell Line (cluster #1 Of 1), Other Other 22 0.27 Functional ≤ 10μM
Z81164-1-O LL Cell Line (cluster #1 Of 2), Other Other 22 0.27 Functional ≤ 10μM
Z81167-1-O LLTC Cell Line (cluster #1 Of 1), Other Other 22 0.27 Functional ≤ 10μM
Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 78 0.26 Functional ≤ 10μM
Z81184-1-O LOX IMVI (Melanoma Cells) (cluster #1 Of 5), Other Other 42 0.26 Functional ≤ 10μM
Z81201-1-O HOP-62 (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 4 0.30 Functional ≤ 10μM
Z81211-1-O LXFL529 Cell Line (cluster #1 Of 1), Other Other 40 0.27 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 79 0.25 Functional ≤ 10μM
Z81245-1-O MDA-MB-435 (Breast Carcinoma Cells) (cluster #1 Of 6), Other Other 960 0.22 Functional ≤ 10μM
Z81247-1-O HeLa (Cervical Adenocarcinoma Cells) (cluster #1 Of 9), Other Other 730 0.22 Functional ≤ 10μM
Z81252-3-O MDA-MB-231 (Breast Adenocarcinoma Cells) (cluster #3 Of 11), Other Other 70 0.26 Functional ≤ 10μM
Z81257-1-O MEL-AC Cell Line (cluster #1 Of 1), Other Other 1200 0.21 Functional ≤ 10μM
Z81261-1-O UACC-375 (cluster #1 Of 1), Other Other 112 0.25 Functional ≤ 10μM
Z81277-2-O NCI-N417 (cluster #2 Of 2), Other Other 230 0.24 Functional ≤ 10μM
Z81280-1-O NCI-H226 (Non-small Cell Lung Carcinoma Cells) (cluster #1 Of 3), Other Other 8 0.29 Functional ≤ 10μM
Z81284-1-O NCI-H647 (cluster #1 Of 2), Other Other 1 0.32 Functional ≤ 10μM
Z81331-1-O SW-620 (Colon Adenocarcinoma Cells) (cluster #1 Of 6), Other Other 80 0.25 Functional ≤ 10μM
Z81335-1-O HCT-15 (Colon Adenocarcinoma Cells) (cluster #1 Of 5), Other Other 820 0.22 Functional ≤ 10μM
Z81341-1-O Tumor Cell Lines (cluster #1 Of 1), Other Other 74 0.26 Functional ≤ 10μM
Z100081-1-O PBMC (Peripheral Blood Mononuclear Cells) (cluster #1 Of 2), Other Other 500 0.23 ADME/T ≤ 10μM
Z80002-1-O 1A9 (Ovarian Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 100 0.25 ADME/T ≤ 10μM
Z80005-1-O 3T3 (Fibroblast Cells) (cluster #1 Of 2), Other Other 3700 0.19 ADME/T ≤ 10μM
Z80035-1-O B16 (Melanoma Cells) (cluster #1 Of 1), Other Other 100 0.25 ADME/T ≤ 10μM
Z80054-1-O Caco-2 (Colon Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 600 0.22 ADME/T ≤ 10μM
Z80064-1-O CCRF-CEM (T-cell Leukemia) (cluster #1 Of 2), Other Other 60 0.26 ADME/T ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 2), Other Other 480 0.23 ADME/T ≤ 10μM
Z80178-2-O J774.A1 (Macrophage Cells) (cluster #2 Of 2), Other Other 20 0.28 ADME/T ≤ 10μM
Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 3), Other Other 60 0.26 ADME/T ≤ 10μM
Z80193-3-O L1210 (Lymphocytic Leukemia Cells) (cluster #3 Of 4), Other Other 29 0.27 ADME/T ≤ 10μM
Z80211-1-O LoVo (Colon Adenocarcinoma Cells) (cluster #1 Of 1), Other Other 33 0.27 ADME/T ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 2), Other Other 70 0.26 ADME/T ≤ 10μM
Z80253-2-O MEF (Embryonic Fibroblast Cells) (cluster #2 Of 2), Other Other 3400 0.20 ADME/T ≤ 10μM
Z80291-1-O MRC5 (Embryonic Lung Fibroblast Cells) (cluster #1 Of 3), Other Other 300 0.23 ADME/T ≤ 10μM
Z80390-1-O PC-3 (Prostate Carcinoma Cells) (cluster #1 Of 2), Other Other 2000 0.20 ADME/T ≤ 10μM
Z80548-2-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #2 Of 4), Other Other 8 0.29 ADME/T ≤ 10μM
Z80583-1-O Vero (Kidney Cells) (cluster #1 Of 3), Other Other 7400 0.18 ADME/T ≤ 10μM
Z80682-2-O A549 (Lung Carcinoma Cells) (cluster #2 Of 3), Other Other 900 0.22 ADME/T ≤ 10μM
Z80704-1-O BJ (Foreskin Fibroblast Cells) (cluster #1 Of 2), Other Other 2700 0.20 ADME/T ≤ 10μM
Z80936-4-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #4 Of 4), Other Other 64 0.26 ADME/T ≤ 10μM
Z81020-1-O HepG2 (Hepatoblastoma Cells) (cluster #1 Of 1), Other Other 420 0.23 ADME/T ≤ 10μM
Z81024-1-O NCI-H460 (Non-small Cell Lung Carcinoma) (cluster #1 Of 1), Other Other 10 0.29 ADME/T ≤ 10μM
Z81034-2-O A2780 (Ovarian Carcinoma Cells) (cluster #2 Of 2), Other Other 7 0.29 ADME/T ≤ 10μM
Z81057-5-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #5 Of 5), Other Other 30 0.27 ADME/T ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 3), Other Other 400 0.23 ADME/T ≤ 10μM
Z81331-2-O SW-620 (Colon Adenocarcinoma Cells) (cluster #2 Of 2), Other Other 178 0.24 ADME/T ≤ 10μM
Q7ZJM1-1-V Human Immunodeficiency Virus Type 1 Integrase (cluster #1 Of 6), Viral Viruses 900 0.22 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) 0.57 -0.9 -63.19 8 12 1 208 544.533 5

Analogs

6535287
6535287
6535291
6535291
6535292
6535292
34928597
34928597

Draw Identity 99% 90% 80% 70%

Vendors

And 50 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
S100B-2-E S-100 Protein Beta Chain (cluster #2 Of 2), Eukaryotic Eukaryotes 1000 0.34 Binding ≤ 10μM
ST14-1-E Matriptase (cluster #1 Of 1), Eukaryotic Eukaryotes 1160 0.33 Binding ≤ 10μM
TRY1-1-E Trypsin I (cluster #1 Of 5), Eukaryotic Eukaryotes 2300 0.32 Binding ≤ 10μM
Z104302-2-O Glutamate NMDA Receptor (cluster #2 Of 7), Other Other 3060 0.31 Binding ≤ 10μM
Z101865-1-O Leishmania Chagasi (cluster #1 Of 1), Other Other 1110 0.33 Functional ≤ 10μM
Z101870-2-O Leishmania Guyanensis (cluster #2 Of 2), Other Other 900 0.34 Functional ≤ 10μM
Z50339-1-O Pneumocystis Carinii (cluster #1 Of 2), Other Other 84 0.40 Functional ≤ 10μM
Z50380-1-O Mycobacterium Smegmatis (cluster #1 Of 4), Other Other 9100 0.28 Functional ≤ 10μM
Z50418-5-O Trypanosoma Brucei (cluster #5 Of 6), Other Other 6 0.46 Functional ≤ 10μM
Z50420-1-O Trypanosoma Brucei Brucei (cluster #1 Of 7), Other Other 3 0.48 Functional ≤ 10μM
Z50425-9-O Plasmodium Falciparum (cluster #9 Of 22), Other Other 251 0.37 Functional ≤ 10μM
Z50426-1-O Plasmodium Falciparum (isolate K1 / Thailand) (cluster #1 Of 9), Other Other 6 0.46 Functional ≤ 10μM
Z50457-1-O Leishmania Amazonensis (cluster #1 Of 3), Other Other 460 0.35 Functional ≤ 10μM
Z50458-4-O Leishmania Braziliensis (cluster #4 Of 4), Other Other 9800 0.28 Functional ≤ 10μM
Z50459-1-O Leishmania Donovani (cluster #1 Of 8), Other Other 9800 0.28 Functional ≤ 10μM
Z50460-1-O Leishmania Major (cluster #1 Of 4), Other Other 7500 0.29 Functional ≤ 10μM
Z50461-1-O Leishmania Mexicana (cluster #1 Of 3), Other Other 9568 0.28 Functional ≤ 10μM
Z50466-4-O Trypanosoma Cruzi (cluster #4 Of 8), Other Other 7100 0.29 Functional ≤ 10μM
Z50467-2-O Trichomonas Vaginalis (cluster #2 Of 3), Other Other 3815 0.30 Functional ≤ 10μM
Z50468-4-O Giardia Intestinalis (cluster #4 Of 4), Other Other 4079 0.30 Functional ≤ 10μM
Z50473-4-O Plasmodium Berghei (cluster #4 Of 5), Other Other 2942 0.31 Functional ≤ 10μM
Z50594-6-O Mus Musculus (cluster #6 Of 9), Other Other 3 0.48 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 2500 0.31 Functional ≤ 10μM
Z50725-1-O Trypanosoma Brucei Rhodesiense (cluster #1 Of 7), Other Other 50 0.41 Functional ≤ 10μM
Z80682-1-O A549 (Lung Carcinoma Cells) (cluster #1 Of 11), Other Other 40 0.41 Functional ≤ 10μM
Z81135-4-O L6 (Skeletal Muscle Myoblast Cells) (cluster #4 Of 4), Other Other 2100 0.32 Functional ≤ 10μM
Z80178-2-O J774.A1 (Macrophage Cells) (cluster #2 Of 2), Other Other 1030 0.34 ADME/T ≤ 10μM
Z81115-2-O KB (Squamous Cell Carcinoma) (cluster #2 Of 3), Other Other 2700 0.31 ADME/T ≤ 10μM
Z81135-2-O L6 (Skeletal Muscle Myoblast Cells) (cluster #2 Of 6), Other Other 6000 0.29 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) 1.49 5.45 -74.02 8 6 2 122 342.443 10
Hi High (pH 8-9.5) 1.68 1.99 -2.42 1 1 0 20 114.188 1

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
NR1H2-1-E LXR-beta (cluster #1 Of 3), Eukaryotic Eukaryotes 93 0.25 Binding ≤ 10μM
NR1H3-1-E LXR-alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.29 Binding ≤ 10μM
NR1H2-1-E LXR-beta (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.25 Functional ≤ 10μM
NR1H3-1-E LXR-alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 240 0.24 Functional ≤ 10μM
PPARA-1-E Peroxisome Proliferator-activated Receptor Alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 1312 0.21 Functional ≤ 10μM
PPARD-1-E Peroxisome Proliferator-activated Receptor Delta (cluster #1 Of 2), Eukaryotic Eukaryotes 680 0.22 Functional ≤ 10μM
PPARG-1-E Peroxisome Proliferator-activated Receptor Gamma (cluster #1 Of 2), Eukaryotic Eukaryotes 680 0.22 Functional ≤ 10μM
Z80169-1-O Huh-7 (Hepatocellular Carcinoma) (cluster #1 Of 1), Other Other 45 0.26 Functional ≤ 10μM
Z80178-3-O J774.A1 (Macrophage Cells) (cluster #3 Of 3), Other Other 41 0.27 Functional ≤ 10μM
Z80548-1-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #1 Of 5), Other Other 84 0.25 Functional ≤ 10μM
Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 223 0.24 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 41 0.27 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) 7.81 17.18 -54.11 0 4 -1 62 526.534 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
LEF-2-B Anthrax Lethal Factor (cluster #2 Of 2), Bacterial Bacteria 3000 0.26 Binding ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 7943 0.24 Functional ≤ 10μM
Z80178-1-O J774.A1 (Macrophage Cells) (cluster #1 Of 3), Other Other 5000 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) 8.28 -2.01 -13.81 3 4 0 69 417.634 18

Analogs

3978012
3978012
3978013
3978013
3978014
3978014
3978043
3978043
3978044
3978044

Draw Identity 99% 90% 80% 70%

Vendors

And 34 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 1000 0.30 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 22 0.38 Binding ≤ 10μM
MCR-1-E Mineralocorticoid Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.41 Binding ≤ 10μM
PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 1000 0.30 Binding ≤ 10μM
GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 4 0.42 Functional ≤ 10μM
Z50594-7-O Mus Musculus (cluster #7 Of 9), Other Other 5 0.42 Functional ≤ 10μM
Z50597-11-O Rattus Norvegicus (cluster #11 Of 12), Other Other 20 0.38 Functional ≤ 10μM
Z80178-2-O J774.A1 (Macrophage Cells) (cluster #2 Of 3), Other Other 48 0.37 Functional ≤ 10μM
Z80301-2-O N9 (cluster #2 Of 2), Other Other 74 0.36 Functional ≤ 10μM
Z80418-3-O RAW264.7 (Monocytic-macrophage Leukemia Cells) (cluster #3 Of 9), Other Other 860 0.30 Functional ≤ 10μM
Z80548-4-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #4 Of 5), Other Other 7 0.41 Functional ≤ 10μM
Z80954-3-O HFF (Foreskin Fibroblasts) (cluster #3 Of 4), Other Other 2 0.43 Functional ≤ 10μM
Z81247-4-O HeLa (Cervical Adenocarcinoma Cells) (cluster #4 Of 9), Other Other 17 0.39 Functional ≤ 10μM
Z81338-2-O T-cells (cluster #2 Of 3), 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.06 3.98 -16.38 3 5 0 95 392.467 2

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
NR1H2-1-E LXR-beta (cluster #1 Of 3), Eukaryotic Eukaryotes 9000 0.23 Binding ≤ 10μM
NR1H3-1-E LXR-alpha (cluster #1 Of 2), Eukaryotic Eukaryotes 9 0.36 Binding ≤ 10μM
NR1H2-1-E LXR-beta (cluster #1 Of 2), Eukaryotic Eukaryotes 75 0.32 Functional ≤ 10μM
NR1H3-1-E LXR-alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 85 0.32 Functional ≤ 10μM
Z80178-1-O J774.A1 (Macrophage Cells) (cluster #1 Of 3), Other Other 35 0.34 Functional ≤ 10μM
Z80548-1-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #1 Of 5), Other Other 44 0.33 Functional ≤ 10μM
Z81020-4-O HepG2 (Hepatoblastoma Cells) (cluster #4 Of 8), Other Other 67 0.32 Functional ≤ 10μM
Z81244-1-O J774 (Macrophage Cells) (cluster #1 Of 1), Other Other 35 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.12 6.6 -15.78 1 4 0 58 481.336 8
Mid Mid (pH 6-8) 5.12 7.07 -43.66 0 4 -1 60 480.328 8

Analogs

3882018
3882018
3882019
3882019
3882020
3882020
3882021
3882021
3977900
3977900

Draw Identity 99% 90% 80% 70%

Vendors

And 23 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
G6PD-1-E Glucose-6-phosphate 1-dehydrogenase (cluster #1 Of 1), Eukaryotic Eukaryotes 8900 0.34 Binding ≤ 10μM
Q9GRG7-1-E Glucose-6-phosphate 1-dehydrogenase (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.38 Binding ≤ 10μM
GPBAR-2-E G-protein Coupled Bile Acid Receptor 1 (cluster #2 Of 2), Eukaryotic Eukaryotes 3330 0.37 Functional ≤ 10μM
Z80178-2-O J774.A1 (Macrophage Cells) (cluster #2 Of 3), Other Other 141 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) 3.25 6.94 -6.17 1 2 0 37 288.431 0

Parameters Provided:

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

Permalink

Embed Link to Results