UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: CGS-27023A CGS-27023A

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
LEF-1-B Anthrax Lethal Factor (cluster #1 Of 2), Bacterial Bacteria 1200 0.31 Binding ≤ 10μM
ADA10-1-E ADAM10 (cluster #1 Of 1), Eukaryotic Eukaryotes 890 0.31 Binding ≤ 10μM
ADA17-2-E ADAM17 (cluster #2 Of 2), Eukaryotic Eukaryotes 41 0.38 Binding ≤ 10μM
BMP1-1-E Bone Morphogenetic Protein 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 3000 0.29 Binding ≤ 10μM
CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 8600 0.26 Binding ≤ 10μM
CAH9-1-E Carbonic Anhydrase IX (cluster #1 Of 11), Eukaryotic Eukaryotes 7800 0.26 Binding ≤ 10μM
MMP1-1-E Matrix Metalloproteinase-1 (cluster #1 Of 2), Eukaryotic Eukaryotes 96 0.36 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 8 0.42 Binding ≤ 10μM
MMP13-3-E Matrix Metalloproteinase 13 (cluster #3 Of 4), Eukaryotic Eukaryotes 8 0.42 Binding ≤ 10μM
MMP14-2-E Matrix Metalloproteinase 14 (cluster #2 Of 3), Eukaryotic Eukaryotes 9 0.42 Binding ≤ 10μM
MMP16-1-E Matrix Metalloproteinase 16 (cluster #1 Of 1), Eukaryotic Eukaryotes 7 0.42 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 15 0.41 Binding ≤ 10μM
MMP25-1-E Matrix Metalloproteinase-25 (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.45 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 7 0.42 Binding ≤ 10μM
MMP7-1-E Matrix Metalloproteinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 736 0.32 Binding ≤ 10μM
MMP8-1-E Matrix Metalloproteinase 8 (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.42 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 10 0.41 Binding ≤ 10μM
Z50591-2-O Bos Taurus (cluster #2 Of 2), Other Other 50 0.38 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.37 3.65 -24.43 2 8 0 109 393.465 8 ↓
Hi High (pH 8-9.5) 1.55 1.28 -51.2 1 8 -1 115 392.457 8 ↓
Hi High (pH 8-9.5) 1.37 3.89 -61.96 1 8 -1 112 392.457 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-2-[[8-(methoxycarbonylamino)dibenzofuran-3-yl]sulfonylamino]-3-methyl-butanoic (2S)-2-[[8-(methoxycarbonylamino…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 320 0.31 Binding ≤ 10μM
MMP13-1-E Matrix Metalloproteinase 13 (cluster #1 Of 4), Eukaryotic Eukaryotes 120 0.33 Binding ≤ 10μM
MMP14-2-E Matrix Metalloproteinase 14 (cluster #2 Of 3), Eukaryotic Eukaryotes 1100 0.29 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 60 0.35 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 351 0.31 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 1300 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.20 4.42 -55.83 2 9 -1 138 419.435 7 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: (2S)-3-methyl-2-[[8-(2-oxooxazolidin-3-yl)dibenzofuran-3-yl]sulfonylamino]butanoic (2S)-3-methyl-2-[[8-(2-oxooxazol…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MMP1-1-E Matrix Metalloproteinase-1 (cluster #1 Of 2), Eukaryotic Eukaryotes 5460 0.25 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 72 0.33 Binding ≤ 10μM
MMP13-1-E Matrix Metalloproteinase 13 (cluster #1 Of 4), Eukaryotic Eukaryotes 106 0.33 Binding ≤ 10μM
MMP14-2-E Matrix Metalloproteinase 14 (cluster #2 Of 3), Eukaryotic Eukaryotes 2250 0.26 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 66 0.34 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 300 0.30 Binding ≤ 10μM
MMP7-1-E Matrix Metalloproteinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 7830 0.24 Binding ≤ 10μM
MMP8-4-E Matrix Metalloproteinase 8 (cluster #4 Of 4), Eukaryotic Eukaryotes 37 0.35 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 318 0.30 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.30 6.19 -61.75 1 9 -1 129 431.446 6 ↓

Analogs

3441694
3441694
3441697
3441697

Draw Identity 99% 90% 80% 70%

Popular Name: 5-phenylimidazolidine-2,4-dione 5-phenylimidazolidine-2,4-dione

Find On: PubMed — Wikipedia — Google

Vendors

And 28 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 290 0.70 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.51 0.77 -8.25 2 4 0 58 176.175 1 ↓
Hi High (pH 8-9.5) 0.70 -1.86 -42.78 1 4 -1 65 175.167 1 ↓

Analogs

3441694
3441694
3441697
3441697

Draw Identity 99% 90% 80% 70%

Popular Name: 5-phenylimidazolidine-2,4-dione 5-phenylimidazolidine-2,4-dione

Find On: PubMed — Wikipedia — Google

Vendors

And 30 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 290 0.70 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.51 0.77 -8.25 2 4 0 58 176.175 1 ↓
Hi High (pH 8-9.5) 0.70 -1.87 -42.81 1 4 -1 65 175.167 1 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: BRD-K73395020-001-01-5 BRD-K73395020-001-01-5

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MMP1-1-E Matrix Metalloproteinase-1 (cluster #1 Of 2), Eukaryotic Eukaryotes 490 0.32 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
MMP13-3-E Matrix Metalloproteinase 13 (cluster #3 Of 4), Eukaryotic Eukaryotes 4 0.42 Binding ≤ 10μM
MMP14-2-E Matrix Metalloproteinase 14 (cluster #2 Of 3), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
MMP16-1-E Matrix Metalloproteinase 16 (cluster #1 Of 1), Eukaryotic Eukaryotes 51 0.36 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 1 0.45 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 2 0.43 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 50 0.37 Binding ≤ 10μM
MMP8-4-E Matrix Metalloproteinase 8 (cluster #4 Of 4), Eukaryotic Eukaryotes 2 0.43 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 7 0.41 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 20 0.38 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) 3.64 7.24 -15.89 2 7 0 96 406.504 8 ↓
Hi High (pH 8-9.5) 3.83 5.88 -59.91 1 7 -1 102 405.496 8 ↓
Hi High (pH 8-9.5) 3.64 8.44 -65.01 1 7 -1 99 405.496 8 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: GM6001 GM6001

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA10-1-E ADAM10 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.40 Binding ≤ 10μM
ADA12-1-E ADAM12 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.41 Binding ≤ 10μM
ADA17-1-E ADAM17 (cluster #1 Of 2), Eukaryotic Eukaryotes 8 0.40 Binding ≤ 10μM
ADAM9-1-E ADAM9 (cluster #1 Of 1), Eukaryotic Eukaryotes 56 0.36 Binding ≤ 10μM
MMP1-2-E Matrix Metalloproteinase-1 (cluster #2 Of 2), Eukaryotic Eukaryotes 6 0.41 Binding ≤ 10μM
MMP10-1-E Matrix Metalloproteinase 10 (cluster #1 Of 1), Eukaryotic Eukaryotes 26 0.38 Binding ≤ 10μM
MMP11-1-E Matrix Metalloproteinase 11 (cluster #1 Of 1), Eukaryotic Eukaryotes 26 0.38 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.42 Binding ≤ 10μM
MMP13-1-E Matrix Metalloproteinase 13 (cluster #1 Of 4), Eukaryotic Eukaryotes 5 0.42 Binding ≤ 10μM
MMP14-1-E Matrix Metalloproteinase 14 (cluster #1 Of 3), Eukaryotic Eukaryotes 5 0.42 Binding ≤ 10μM
MMP15-1-E Matrix Metalloproteinase 15 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.41 Binding ≤ 10μM
MMP16-1-E Matrix Metalloproteinase 16 (cluster #1 Of 1), Eukaryotic Eukaryotes 8 0.40 Binding ≤ 10μM
MMP17-1-E Matrix Metalloproteinase 17 (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.43 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 7 0.41 Binding ≤ 10μM
MMP26-1-E Matrix Metalloproteinase 26 (cluster #1 Of 1), Eukaryotic Eukaryotes 17 0.39 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 7 0.41 Binding ≤ 10μM
MMP7-1-E Matrix Metalloproteinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 33 0.37 Binding ≤ 10μM
MMP8-1-E Matrix Metalloproteinase 8 (cluster #1 Of 4), Eukaryotic Eukaryotes 10 0.40 Binding ≤ 10μM
MMP9-2-E Matrix Metalloproteinase 9 (cluster #2 Of 3), Eukaryotic Eukaryotes 7 0.41 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.55 3.16 -20.09 5 8 0 123 388.468 9 ↓
Hi High (pH 8-9.5) 1.55 4.38 -63.44 4 8 -1 126 387.46 9 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[3-(hydroxycarbamoyl)tetrahydropyran-4-yl]-4-[(2-methyl-4-quinolyl)methoxy]benzamide N-[3-(hydroxycarbamoyl)tetrahydr…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA17-1-E ADAM17 (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.39 Binding ≤ 10μM
MMP10-1-E Matrix Metalloproteinase 10 (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.31 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 100 0.31 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 100 0.31 Binding ≤ 10μM
MMP7-1-E Matrix Metalloproteinase 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 100 0.31 Binding ≤ 10μM
Z102213-1-O Blood (cluster #1 Of 2), Other Other 130 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.72 -3.53 -24.34 3 8 0 109 435.48 6 ↓
Hi High (pH 8-9.5) 2.91 -2.96 -59.34 2 8 -1 116 434.472 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-[(3R,4R)-3-(hydroxycarbamoyl)tetrahydropyran-4-yl]-4-[[2-(trifluoromethyl)benzimidazol-1-yl]methyl N-[(3R,4R)-3-(hydroxycarbamoyl)t…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA17-1-E ADAM17 (cluster #1 Of 2), Eukaryotic Eukaryotes 130 0.29 Binding ≤ 10μM
ATS4-1-E ADAMTS4 (cluster #1 Of 1), Eukaryotic Eukaryotes 6700 0.22 Binding ≤ 10μM
ATS5-1-E ADAMTS5 (cluster #1 Of 1), Eukaryotic Eukaryotes 1900 0.24 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 8000 0.22 Binding ≤ 10μM
Z102213-1-O Blood (cluster #1 Of 2), Other Other 232 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) 2.55 6.11 -22.99 3 8 0 105 462.428 6 ↓

Analogs

Draw Identity 99% 90% 80% 70%

Popular Name: N-ISOBUTYL-N-[4-METHOXYPHENYLSULFONYL]GLYCYL HYDROXAMIC ACID N-ISOBUTYL-N-[4-METHOXYPHENYLSUL…

Find On: PubMed — Wikipedia — Google

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
ADA17-2-E ADAM17 (cluster #2 Of 2), Eukaryotic Eukaryotes 2300 0.38 Binding ≤ 10μM
MMP1-1-E Matrix Metalloproteinase-1 (cluster #1 Of 2), Eukaryotic Eukaryotes 300 0.43 Binding ≤ 10μM
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 4 0.56 Binding ≤ 10μM
MMP13-2-E Matrix Metalloproteinase 13 (cluster #2 Of 4), Eukaryotic Eukaryotes 3 0.57 Binding ≤ 10μM
MMP14-2-E Matrix Metalloproteinase 14 (cluster #2 Of 3), Eukaryotic Eukaryotes 13 0.53 Binding ≤ 10μM
MMP2-1-E 72 KDa Type IV Collagenase (cluster #1 Of 3), Eukaryotic Eukaryotes 13 0.53 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 133 0.46 Binding ≤ 10μM
MMP8-3-E Matrix Metalloproteinase 8 (cluster #3 Of 4), Eukaryotic Eukaryotes 9 0.54 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 5 0.55 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.22 1.23 -22.17 2 7 0 96 316.379 7 ↓
Hi High (pH 8-9.5) 1.22 2.41 -64.1 1 7 -1 99 315.371 7 ↓

Analogs

11525611
11525611

Draw Identity 99% 90% 80% 70%

Popular Name: PF 00356231 PF 00356231

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
MMP12-1-E Macrophage Metalloelastase (cluster #1 Of 2), Eukaryotic Eukaryotes 14 0.35 Binding ≤ 10μM
MMP13-4-E Matrix Metalloproteinase 13 (cluster #4 Of 4), Eukaryotic Eukaryotes 270 0.30 Binding ≤ 10μM
MMP3-1-E Matrix Metalloproteinase 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 390 0.29 Binding ≤ 10μM
MMP8-1-E Matrix Metalloproteinase 8 (cluster #1 Of 4), Eukaryotic Eukaryotes 1700 0.26 Binding ≤ 10μM
MMP9-1-E Matrix Metalloproteinase 9 (cluster #1 Of 3), Eukaryotic Eukaryotes 980 0.27 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) 3.46 -0.31 -56.05 1 5 -1 82 427.505 7 ↓

Parameters Provided:

target.name = MMP12-1-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 'MMP12-1-E' AND t.atype_fk = 0 AND c.purchasable IN (1,2,4,5)    LIMIT 50

Permalink

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

Embed Link to Results