Warning: session_write_close() [function.session-write-close]: open(/tmp/session/sess_8jlg2mba93ghtkjes339n9clk2, O_RDWR) failed: No such file or directory (2) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp/session) in /domains/zinc12/htdocs/lib/zinc/user/ZincAuthentication.php on line 109
Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 1-((4-METHOXYPHENYL)METHYL)-1H-PYRROLE-2,5-DIONE 1-((4-METHOXYPHENYL)METHYL)-1H-P…

Find On: PubMed — Wikipedia — Google

Vendors

And 7 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 2500 0.49 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 2500 0.49 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.44 4.76 -8.95 0 4 0 48 217.224 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 1-(2-Phenylethyl)-1H-pyrrole-2,5-dione 1-(2-Phenylethyl)-1H-pyrrole-2,5…

Find On: PubMed — Wikipedia — Google

Vendors

And 34 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 2000 0.53 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 2000 0.53 Binding ≤ 10μM
MGLL-2-E Monoglyceride Lipase (cluster #2 Of 7), Eukaryotic Eukaryotes 7610 0.48 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.59 6.22 -8.37 0 3 0 39 201.225 3 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 1-(3-phenylpropyl)pyrrole-2,5-dione 1-(3-phenylpropyl)pyrrole-2,5-dione

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 3000 0.48 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 3000 0.48 Binding ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 2.11 7 -8.93 0 3 0 39 215.252 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: ethyl ethyl

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 3000 0.59 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 3000 0.59 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.03 3.76 -11.92 0 5 0 65 183.163 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: 1-Methyl-1H-pyrrole-2,5-dione 1-Methyl-1H-pyrrole-2,5-dione

Find On: PubMed — Wikipedia — Google

Vendors

And 26 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 5000 0.93 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 5000 0.93 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.21 1.45 -8 0 3 0 39 111.1 0 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: SU9516 SU9516

Find On: PubMed — Wikipedia — Google

Vendors

And 1 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CCNB1-2-E G2/mitotic-specific Cyclin B1 (cluster #2 Of 2), Eukaryotic Eukaryotes 22 0.60 Binding ≤ 10μM
CCNB2-2-E G2/mitotic-specific Cyclin B2 (cluster #2 Of 2), Eukaryotic Eukaryotes 22 0.60 Binding ≤ 10μM
CCNB3-2-E G2/mitotic-specific Cyclin B3 (cluster #2 Of 2), Eukaryotic Eukaryotes 22 0.60 Binding ≤ 10μM
CDK1-1-E Cyclin-dependent Kinase 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 55 0.56 Binding ≤ 10μM
CDK2-2-E Cyclin-dependent Kinase 2 (cluster #2 Of 5), Eukaryotic Eukaryotes 35 0.58 Binding ≤ 10μM
CDK4-2-E Cyclin-dependent Kinase 4 (cluster #2 Of 3), Eukaryotic Eukaryotes 300 0.51 Binding ≤ 10μM
CDK5-1-E Cyclin-dependent Kinase 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 65 0.56 Binding ≤ 10μM
E2AK2-1-E Interferon-induced, Double-stranded RNA-activated Protein Kinase (cluster #1 Of 1), Eukaryotic Eukaryotes 5000 0.41 Binding ≤ 10μM
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 350 0.50 Binding ≤ 10μM
GSK3B-1-E Glycogen Synthase Kinase-3 Beta (cluster #1 Of 7), Eukaryotic Eukaryotes 350 0.50 Binding ≤ 10μM
RET-1-E Tyrosine-protein Kinase Receptor RET (cluster #1 Of 1), Eukaryotic Eukaryotes 1600 0.45 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 130 0.54 Binding ≤ 10μM
Z50418-2-O Trypanosoma Brucei (cluster #2 Of 6), Other Other 180 0.52 Functional ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 7943 0.40 Functional ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) 1.39 5.1 -16.01 2 5 0 71 241.25 2 ↓
Lo Low (pH 4.5-6) 1.39 4.84 -40.96 3 5 1 72 242.258 2 ↓

Analogs

2386965
2386965

Draw Identity 99% 90% 80% 70%

Popular Name: 1-[2-(4-Methoxy-phenyl)-ethyl]-pyrrole-2,5-dione 1-[2-(4-Methoxy-phenyl)-ethyl]-p…

Find On: PubMed — Wikipedia — Google

Vendors

And 6 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 3000 0.45 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 3000 0.45 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.65 5.52 -9.54 0 4 0 48 231.251 4 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: Maleimide Maleimide

Find On: PubMed — Wikipedia — Google

Vendors

And 39 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 6000 1.04 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 6000 1.04 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.28 -1 -7.91 1 3 0 50 97.073 0 ↓

Analogs

6251342
6251342

Draw Identity 99% 90% 80% 70%

Popular Name: N-Benzylmaleimide N-Benzylmaleimide

Find On: PubMed — Wikipedia — Google

Vendors

And 60 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 1000 0.60 Binding ≤ 10μM
GSK3B-3-E Glycogen Synthase Kinase-3 Beta (cluster #3 Of 7), Eukaryotic Eukaryotes 1000 0.60 Binding ≤ 10μM
MGLL-2-E Monoglyceride Lipase (cluster #2 Of 7), Eukaryotic Eukaryotes 5140 0.53 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.38 5.46 -8.05 0 3 0 39 187.198 2 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: LL-Z1640-2 LL-Z1640-2

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FLT3-1-E Tyrosine-protein Kinase Receptor FLT3 (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.45 Binding ≤ 10μM
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 1900 0.31 Binding ≤ 10μM
KIT-1-E Stem Cell Growth Factor Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 10 0.43 Binding ≤ 10μM
M3K7-1-E Mitogen-activated Protein Kinase Kinase Kinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.44 Binding ≤ 10μM
MK01-1-E Mitogen-activated Protein Kinase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1300 0.32 Binding ≤ 10μM
MK03-1-E MAP Kinase ERK1 (cluster #1 Of 1), Eukaryotic Eukaryotes 1400 0.32 Binding ≤ 10μM
MP2K1-3-E Dual Specificity Mitogen-activated Protein Kinase Kinase 1 (cluster #3 Of 4), Eukaryotic Eukaryotes 2 0.47 Binding ≤ 10μM
PGFRA-2-E Platelet-derived Growth Factor Receptor Alpha (cluster #2 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
PGFRB-1-E Platelet-derived Growth Factor Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 41 0.40 Binding ≤ 10μM
TAB1-1-E Mitogen-activated Protein Kinase Kinase Kinase 7-interacting Protein 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.44 Binding ≤ 10μM
TF65-1-E Nuclear Factor NF-kappa-B P65 Subunit (cluster #1 Of 3), Eukaryotic Eukaryotes 250 0.36 Binding ≤ 10μM
VGFR1-1-E Vascular Endothelial Growth Factor Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 12 0.43 Binding ≤ 10μM
VGFR2-1-E Vascular Endothelial Growth Factor Receptor 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
VGFR3-2-E Vascular Endothelial Growth Factor Receptor 3 (cluster #2 Of 2), Eukaryotic Eukaryotes 1 0.48 Binding ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 3600 0.29 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 4400 0.29 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 3800 0.29 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 4900 0.29 Functional ≤ 10μM
Z80466-1-O SF268 (cluster #1 Of 4), Other Other 5100 0.28 Functional ≤ 10μM
Z80466-1-O SF268 (cluster #1 Of 4), Other Other 5600 0.28 Functional ≤ 10μM
Z80548-3-O THP-1 (Acute Monocytic Leukemia Cells) (cluster #3 Of 5), Other Other 11 0.43 Functional ≤ 10μM
Z81072-1-O Jurkat (Acute Leukemic T-cells) (cluster #1 Of 10), Other Other 7000 0.28 Functional ≤ 10μM
Z81245-1-O MDA-MB-435 (Breast Carcinoma Cells) (cluster #1 Of 6), Other Other 3300 0.30 Functional ≤ 10μM
Z81245-1-O MDA-MB-435 (Breast Carcinoma Cells) (cluster #1 Of 6), Other Other 5500 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) 1.38 2.34 -12.73 3 7 0 113 362.378 1 ↓
Ref Reference (pH 7) 1.38 1.51 -10.41 3 7 0 113 362.378 1 ↓
Hi High (pH 8-9.5) 1.38 3.43 -52.21 2 7 -1 116 361.37 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: Chrysin Chrysin

Find On: PubMed — Wikipedia — Google

Vendors

And 45 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ABCG2-1-E ATP-binding Cassette Sub-family G Member 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 2600 0.41 Binding ≤ 10μM
ALDR-1-E Aldose Reductase (cluster #1 Of 5), Eukaryotic Eukaryotes 7790 0.38 Binding ≤ 10μM
AOFA-4-E Monoamine Oxidase A (cluster #4 Of 8), Eukaryotic Eukaryotes 1600 0.43 Binding ≤ 10μM
AOFB-4-E Monoamine Oxidase B (cluster #4 Of 8), Eukaryotic Eukaryotes 1600 0.43 Binding ≤ 10μM
CBR1-1-E Carbonyl Reductase [NADPH] 1 (cluster #1 Of 2), Eukaryotic Eukaryotes 670 0.45 Binding ≤ 10μM
CCNB1-1-E G2/mitotic-specific Cyclin B1 (cluster #1 Of 2), Eukaryotic Eukaryotes 6200 0.38 Binding ≤ 10μM
CCNB2-1-E G2/mitotic-specific Cyclin B2 (cluster #1 Of 2), Eukaryotic Eukaryotes 6200 0.38 Binding ≤ 10μM
CCNB3-1-E G2/mitotic-specific Cyclin B3 (cluster #1 Of 2), Eukaryotic Eukaryotes 6200 0.38 Binding ≤ 10μM
CDK1-1-E Cyclin-dependent Kinase 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 6200 0.38 Binding ≤ 10μM
CDK6-1-E Cyclin-dependent Kinase 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 6000 0.38 Binding ≤ 10μM
CP19A-3-E Cytochrome P450 19A1 (cluster #3 Of 3), Eukaryotic Eukaryotes 2600 0.41 Binding ≤ 10μM
CP1B1-1-E Cytochrome P450 1B1 (cluster #1 Of 1), Eukaryotic Eukaryotes 24 0.56 Binding ≤ 10μM
GBRA1-1-E GABA Receptor Alpha-1 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.41 Binding ≤ 10μM
GBRA2-1-E GABA Receptor Alpha-2 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.41 Binding ≤ 10μM
GBRA3-1-E GABA Receptor Alpha-3 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.41 Binding ≤ 10μM
GBRA4-1-E GABA Receptor Alpha-4 Subunit (cluster #1 Of 7), Eukaryotic Eukaryotes 3020 0.41 Binding ≤ 10μM
GBRA5-1-E GABA Receptor Alpha-5 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.41 Binding ≤ 10μM
GBRA6-6-E GABA Receptor Alpha-6 Subunit (cluster #6 Of 8), Eukaryotic Eukaryotes 3020 0.41 Binding ≤ 10μM
GSK3A-2-E Glycogen Synthase Kinase-3 Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 7200 0.38 Binding ≤ 10μM
GSK3B-7-E Glycogen Synthase Kinase-3 Beta (cluster #7 Of 7), Eukaryotic Eukaryotes 7200 0.38 Binding ≤ 10μM
Q965D6-1-E 3-oxoacyl-acyl-carrier Protein Reductase (cluster #1 Of 2), Eukaryotic Eukaryotes 10000 0.37 Binding ≤ 10μM
XDH-2-E Xanthine Dehydrogenase (cluster #2 Of 2), Eukaryotic Eukaryotes 840 0.45 Binding ≤ 10μM
CP1A1-1-E Cytochrome P450 1A1 (cluster #1 Of 3), Eukaryotic Eukaryotes 42 0.54 ADME/T ≤ 10μM
CP1A2-1-E Cytochrome P450 1A2 (cluster #1 Of 3), Eukaryotic Eukaryotes 84 0.52 ADME/T ≤ 10μM
CP1B1-1-E Cytochrome P450 1B1 (cluster #1 Of 3), Eukaryotic Eukaryotes 16 0.57 ADME/T ≤ 10μM
CP2C9-1-E Cytochrome P450 2C9 (cluster #1 Of 3), Eukaryotic Eukaryotes 5225 0.39 ADME/T ≤ 10μM
Z104294-2-O Cyclin-dependent Kinase 5/CDK5 Activator 1 (cluster #2 Of 2), Other Other 3100 0.41 Binding ≤ 10μM
Z104301-4-O GABA-A Receptor; Anion Channel (cluster #4 Of 8), Other Other 920 0.44 Binding ≤ 10μM
Z50607-3-O Human Immunodeficiency Virus 1 (cluster #3 Of 10), Other Other 5000 0.39 Functional ≤ 10μM
Z80166-1-O HT-29 (Colon Adenocarcinoma Cells) (cluster #1 Of 12), Other Other 3100 0.41 Functional ≤ 10μM
Z80470-1-O SGC-7901 (Gastric Carcinoma Cells) (cluster #1 Of 2), Other Other 5800 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) 2.94 3.96 -11.62 2 4 0 71 254.241 1 ↓
Hi High (pH 8-9.5) 2.94 4.94 -56.85 1 4 -1 73 253.233 1 ↓
Mid Mid (pH 6-8) 3.20 4.26 -45.71 1 4 -1 73 253.233 1 ↓

Parameters Provided:

target.name = GSK3A-2-E
target.type = B10
page.format = summary
page.num = 1
filter.purchasability = purchasable

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN 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 'GSK3A-2-E' AND t.atype_fk = 0 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?target.name=GSK3A-2-E&target.type=B10&filter.purchasability=purchasable

Embed Link to Results