UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

3957104
3957104
8627075
8627075
11681339
11681339
11681341
11681341
13719785
13719785

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
B1WC34-1-E Alpha-glucosidase II Beta Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 5300 0.49 Binding ≤ 10μM
B5THE3-1-E Sucrase-isomaltase (cluster #1 Of 1), Eukaryotic Eukaryotes 600 0.58 Binding ≤ 10μM
D3ZAN3-1-E Alpha-glucosidase II (cluster #1 Of 1), Eukaryotic Eukaryotes 5300 0.49 Binding ≤ 10μM
GBA2-1-E Beta-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 230 0.62 Binding ≤ 10μM
GDE-1-E Glycogen Debranching Enzyme (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.47 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 9000 0.47 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 9000 0.47 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 580 0.58 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.72 -4.65 -34.04 5 5 1 85 220.289 4
Hi High (pH 8-9.5) -0.72 -4.19 -42.06 4 5 0 88 219.281 4

Analogs

3957104
3957104
2562349
2562349
3794711
3794711

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
CEGT-1-E Ceramide Glucosyltransferase (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.47 Binding ≤ 10μM
GBA2-1-E Beta-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 300 0.61 Binding ≤ 10μM
GDE-1-E Glycogen Debranching Enzyme (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.47 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 1500 0.54 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 10000 0.47 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 460 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.72 -3.01 -32.91 5 5 1 85 220.289 4
Hi High (pH 8-9.5) -0.72 -2.52 -40.01 4 5 0 88 219.281 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
LYAG-2-E Alpha-glucosidase (cluster #2 Of 2), Eukaryotic Eukaryotes 7200 0.28 Binding ≤ 10μM
MGA-2-E Maltase-glucoamylase (cluster #2 Of 3), Eukaryotic Eukaryotes 190 0.36 Binding ≤ 10μM
SUIS-2-E Sucrase-isomaltase (cluster #2 Of 3), Eukaryotic Eukaryotes 750 0.33 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

Analogs

3995890
3995890

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
AGAL-1-E Alpha-galactosidase (cluster #1 Of 1), Eukaryotic Eukaryotes 3 1.08 Binding ≤ 10μM
GDE-1-E Glycogen Debranching Enzyme (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.64 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 6000 0.66 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 1500 0.74 Binding ≤ 10μM
Q5DUH8-1-E Alpha-galactosidase (cluster #1 Of 1), Eukaryotic Eukaryotes 3 1.08 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 260 0.84 Binding ≤ 10μM
AGALC-1-F Alpha-galactosidase C (cluster #1 Of 1), Fungal Fungi 3 1.08 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.40 -8.74 -34.63 6 5 1 98 164.181 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
LYAG-2-E Alpha-glucosidase (cluster #2 Of 2), Eukaryotic Eukaryotes 9850 0.35 Binding ≤ 10μM
MGA-2-E Maltase-glucoamylase (cluster #2 Of 3), Eukaryotic Eukaryotes 1000 0.42 Binding ≤ 10μM
SUIS-2-E Sucrase-isomaltase (cluster #2 Of 3), Eukaryotic Eukaryotes 5700 0.37 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) -5.70 -12.62 -52.32 5 9 0 168 334.368 7

Analogs

4165550
4165550
4165583
4165583
4165606
4165606
6385059
6385059
39937087
39937087

Draw Identity 99% 90% 80% 70%

Vendors

And 19 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GDE-1-E Glycogen Debranching Enzyme (cluster #1 Of 1), Eukaryotic Eukaryotes 390 0.64 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 590 0.62 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 6000 0.52 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 1200 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) -2.79 -9.08 -33.07 6 6 1 106 208.234 3
Hi High (pH 8-9.5) -2.79 -8.62 -44.04 5 6 0 108 207.226 3

Analogs

3995890
3995890

Draw Identity 99% 90% 80% 70%

Vendors

And 18 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
B1WC34-1-E Alpha-glucosidase II Beta Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 4600 0.68 Binding ≤ 10μM
D3ZAN3-1-E Alpha-glucosidase II (cluster #1 Of 1), Eukaryotic Eukaryotes 4600 0.68 Binding ≤ 10μM
GANAB-1-E Neutral Alpha-glucosidase AB (cluster #1 Of 2), Eukaryotic Eukaryotes 160 0.86 Binding ≤ 10μM
GANC-1-E Neutral Alpha-glucosidase C (cluster #1 Of 2), Eukaryotic Eukaryotes 300 0.83 Binding ≤ 10μM
GDE-1-E Glycogen Debranching Enzyme (cluster #1 Of 1), Eukaryotic Eukaryotes 190 0.86 Binding ≤ 10μM
GLCM-2-E Glucosylceramidase (cluster #2 Of 2), Eukaryotic Eukaryotes 2000 0.73 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 400 0.81 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 40 0.94 Binding ≤ 10μM
Q43014-2-E Beta-glucosidase (cluster #2 Of 2), Eukaryotic Eukaryotes 9500 0.64 Binding ≤ 10μM
Q9LGC6-1-E Alpha-glucosidase (cluster #1 Of 1), Eukaryotic Eukaryotes 50 0.93 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 650 0.79 Binding ≤ 10μM
P94451-1-B Alpha-glucosidase (cluster #1 Of 1), Bacterial Bacteria 1670 0.74 Binding ≤ 10μM
Z81057-3-O HUVEC (Umbilical Vein Endothelial Cells) (cluster #3 Of 4), Other Other 2000 0.73 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.40 -9.17 -39.08 6 5 1 98 164.181 1

Analogs

2149675
2149675

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
AA1R-2-E Adenosine A1 Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 5000 0.37 Binding ≤ 10μM
ABCG2-1-E ATP-binding Cassette Sub-family G Member 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 8800 0.35 Binding ≤ 10μM
ABL1-1-E Tyrosine-protein Kinase ABL (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.35 Binding ≤ 10μM
AOFA-4-E Monoamine Oxidase A (cluster #4 Of 8), Eukaryotic Eukaryotes 900 0.42 Binding ≤ 10μM
AOFB-4-E Monoamine Oxidase B (cluster #4 Of 8), Eukaryotic Eukaryotes 900 0.42 Binding ≤ 10μM
DHB1-1-E Estradiol 17-beta-dehydrogenase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2210 0.40 Binding ≤ 10μM
EGFR-2-E Epidermal Growth Factor Receptor ErbB1 (cluster #2 Of 4), Eukaryotic Eukaryotes 2600 0.39 Binding ≤ 10μM
ERR1-1-E Estrogen-related Receptor Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 10 0.56 Binding ≤ 10μM
ERR2-1-E Estrogen-related Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 395 0.45 Binding ≤ 10μM
ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 990 0.42 Binding ≤ 10μM
ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 990 0.42 Binding ≤ 10μM
MGA-3-E Maltase-glucoamylase (cluster #3 Of 3), Eukaryotic Eukaryotes 2610 0.39 Binding ≤ 10μM
Q965D7-2-E Fatty Acid Synthase (cluster #2 Of 2), Eukaryotic Eukaryotes 7000 0.36 Binding ≤ 10μM
ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 950 0.42 Functional ≤ 10μM
ESR2-2-E Estrogen Receptor Beta (cluster #2 Of 2), Eukaryotic Eukaryotes 956 0.42 Functional ≤ 10μM
ADO-1-E Aldehyde Oxidase (cluster #1 Of 3), Eukaryotic Eukaryotes 340 0.45 ADME/T ≤ 10μM
Z50420-1-O Trypanosoma Brucei Brucei (cluster #1 Of 7), Other Other 4200 0.38 Functional ≤ 10μM
Z80030-1-O ANN-1 (cluster #1 Of 2), Other Other 8000 0.36 Functional ≤ 10μM
Z80037-1-O Balb/MK (cluster #1 Of 1), Other Other 9100 0.35 Functional ≤ 10μM
Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 1000 0.42 Functional ≤ 10μM
Z81068-1-O Ishikawa (Uterine Carcinoma Cells) (cluster #1 Of 1), Other Other 510 0.44 Functional ≤ 10μM
Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 956 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.27 1.08 -13.3 3 5 0 91 270.24 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
D3ZJF9-1-E Alpha-galactosidase A (cluster #1 Of 1), Eukaryotic Eukaryotes 4500 0.58 Binding ≤ 10μM
GANC-1-E Neutral Alpha-glucosidase C (cluster #1 Of 2), Eukaryotic Eukaryotes 22 0.82 Binding ≤ 10μM
GDE-1-E Glycogen Debranching Enzyme (cluster #1 Of 1), Eukaryotic Eukaryotes 110 0.75 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 8400 0.55 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 8400 0.55 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 700 0.66 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.05 -12.28 -29.67 7 6 1 117 194.207 2

Analogs

4097426
4097426
4165550
4165550
4165583
4165583
4165606
4165606
6385059
6385059

Draw Identity 99% 90% 80% 70%

Vendors

And 1 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
B1WC34-1-E Alpha-glucosidase II Beta Subunit (cluster #1 Of 1), Eukaryotic Eukaryotes 5800 0.61 Binding ≤ 10μM
D3ZAN3-1-E Alpha-glucosidase II (cluster #1 Of 1), Eukaryotic Eukaryotes 5800 0.61 Binding ≤ 10μM
LPH-1-E Lactase-glycosylceramidase (cluster #1 Of 1), Eukaryotic Eukaryotes 4400 0.62 Binding ≤ 10μM
LYAG-1-E Alpha-glucosidase (cluster #1 Of 2), Eukaryotic Eukaryotes 420 0.74 Binding ≤ 10μM
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 120 0.81 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 4400 0.62 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.16 -8.77 -36.29 5 5 1 85 178.208 1

Analogs

5157081
5157081

Draw Identity 99% 90% 80% 70%

Vendors

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 2200 0.61 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 49 0.79 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.61 -10.86 -37.53 8 6 1 129 194.207 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
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 2200 0.61 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 49 0.79 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.61 -11.71 -41.66 8 6 1 129 194.207 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
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 2200 0.61 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 49 0.79 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.61 -10.55 -43.17 8 6 1 129 194.207 1
Hi High (pH 8-9.5) -3.61 -11.15 -5.8 7 6 0 127 193.199 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
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 2200 0.61 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 49 0.79 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.61 -10.09 -46.87 8 6 1 129 194.207 1
Hi High (pH 8-9.5) -3.61 -10.47 -6.02 7 6 0 127 193.199 1

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
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 15 0.61 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 5 0.65 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.98 -15.06 -35.68 9 8 1 158 268.286 5

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
MGA-1-E Maltase-glucoamylase (cluster #1 Of 3), Eukaryotic Eukaryotes 15 0.61 Binding ≤ 10μM
SUIS-1-E Sucrase-isomaltase (cluster #1 Of 3), Eukaryotic Eukaryotes 5 0.65 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.98 -15.71 -34.21 9 8 1 158 268.286 5

Parameters Provided:

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

Permalink

Embed Link to Results