UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

19850502
19850502

Draw Identity 99% 90% 80% 70%

Vendors

And 20 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 364 0.69 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 4800 0.57 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 364 0.69 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 4800 0.57 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 40 0.80 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 4800 0.57 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 40 0.80 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 4800 0.57 Binding ≤ 10μM
GRIK1-1-E Glutamate Receptor Ionotropic Kainate 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 740 0.66 Binding ≤ 10μM
GRIK2-3-E Glutamate Receptor Ionotropic Kainate 2 (cluster #3 Of 3), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK3-3-E Glutamate Receptor Ionotropic Kainate 3 (cluster #3 Of 3), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK4-1-E Glutamate Receptor Ionotropic Kainate 4 (cluster #1 Of 2), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK5-1-E Glutamate Receptor Ionotropic Kainate 5 (cluster #1 Of 2), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 3310 0.59 Functional ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 3310 0.59 Functional ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 3), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 800 0.66 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 4800 0.57 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.69 -1.91 -52.1 3 6 -1 117 185.159 3
Lo Low (pH 4.5-6) -2.69 -2.52 -37.61 4 6 0 114 186.167 3

Analogs

19850499
19850499

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
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 22 0.82 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 364 0.69 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 17 0.84 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 364 0.69 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 21 0.83 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 40 0.80 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 40 0.80 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 40 0.80 Binding ≤ 10μM
GRIK1-1-E Glutamate Receptor Ionotropic Kainate 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 740 0.66 Binding ≤ 10μM
GRIK1-1-E Glutamate Receptor Ionotropic Kainate 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 1150 0.64 Binding ≤ 10μM
GRIK2-3-E Glutamate Receptor Ionotropic Kainate 2 (cluster #3 Of 3), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK3-3-E Glutamate Receptor Ionotropic Kainate 3 (cluster #3 Of 3), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK4-1-E Glutamate Receptor Ionotropic Kainate 4 (cluster #1 Of 2), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK5-1-E Glutamate Receptor Ionotropic Kainate 5 (cluster #1 Of 2), Eukaryotic Eukaryotes 12 0.85 Binding ≤ 10μM
GRIK5-1-E Glutamate Receptor Ionotropic Kainate 5 (cluster #1 Of 2), Eukaryotic Eukaryotes 2144 0.61 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 3310 0.59 Functional ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 3310 0.59 Functional ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 3), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 3), Eukaryotic Eukaryotes 3500 0.59 Functional ≤ 10μM
GRIK3-1-E Glutamate Receptor Ionotropic Kainate 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 3800 0.58 Functional ≤ 10μM
Z104302-1-O Glutamate NMDA Receptor (cluster #1 Of 7), Other Other 3500 0.59 Binding ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 800 0.66 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 6700 0.56 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.69 -1.72 -76.52 3 6 -1 117 185.159 3

Analogs

Draw Identity 99% 90% 80% 70%

Vendors

And 8 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
GRIA1-2-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #2 Of 4), Eukaryotic Eukaryotes 70 0.44 Binding ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 70 0.44 Binding ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 4), Eukaryotic Eukaryotes 70 0.44 Binding ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 5), Eukaryotic Eukaryotes 70 0.44 Binding ≤ 10μM
GRIK1-2-E Glutamate Receptor Ionotropic Kainate 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 8000 0.31 Binding ≤ 10μM
GRIK2-1-E Glutamate Receptor Ionotropic Kainate 2 (cluster #1 Of 3), Eukaryotic Eukaryotes 8000 0.31 Binding ≤ 10μM
GRIK3-1-E Glutamate Receptor Ionotropic Kainate 3 (cluster #1 Of 3), Eukaryotic Eukaryotes 8000 0.31 Binding ≤ 10μM
GRIK4-1-E Glutamate Receptor Ionotropic Kainate 4 (cluster #1 Of 2), Eukaryotic Eukaryotes 8000 0.31 Binding ≤ 10μM
GRIK5-1-E Glutamate Receptor Ionotropic Kainate 5 (cluster #1 Of 2), Eukaryotic Eukaryotes 79 0.43 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 6000 0.32 Functional ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 2500 0.34 Functional ≤ 10μM
GRIA3-1-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #1 Of 2), Eukaryotic Eukaryotes 200 0.41 Functional ≤ 10μM
GRIA4-1-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #1 Of 3), Eukaryotic Eukaryotes 200 0.41 Functional ≤ 10μM
GRIK1-1-E Glutamate Receptor Ionotropic Kainate 1 (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.43 Functional ≤ 10μM
GRIK2-1-E Glutamate Receptor Ionotropic Kainate 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 90 0.43 Functional ≤ 10μM
GRIK3-1-E Glutamate Receptor Ionotropic Kainate 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 90 0.43 Functional ≤ 10μM
GRIK4-1-E Glutamate Receptor Ionotropic Kainate 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 90 0.43 Functional ≤ 10μM
GRIK5-1-E Glutamate Receptor Ionotropic Kainate 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 90 0.43 Functional ≤ 10μM
Z104302-4-O Glutamate NMDA Receptor (cluster #4 Of 7), Other Other 200 0.41 Binding ≤ 10μM
Z50594-1-O Mus Musculus (cluster #1 Of 9), Other Other 300 0.40 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 4000 0.33 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) -0.57 1.41 -25.8 4 10 0 172 336.285 2
Mid Mid (pH 6-8) 0.33 -0.74 -49.41 3 10 -1 175 335.277 2
Mid Mid (pH 6-8) 0.33 -0.78 -57.47 3 10 -1 175 335.277 2

Analogs

22066252
22066252

Draw Identity 99% 90% 80% 70%

Vendors

And 9 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
FOLH1-1-E Glutamate Carboxypeptidase II (cluster #1 Of 2), Eukaryotic Eukaryotes 9500 0.54 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 80 0.76 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 80 0.76 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 80 0.76 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 80 0.76 Binding ≤ 10μM
GRIK1-3-E Glutamate Receptor Ionotropic Kainate 1 (cluster #3 Of 3), Eukaryotic Eukaryotes 171 0.73 Binding ≤ 10μM
GRIK2-3-E Glutamate Receptor Ionotropic Kainate 2 (cluster #3 Of 3), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
GRIK3-3-E Glutamate Receptor Ionotropic Kainate 3 (cluster #3 Of 3), Eukaryotic Eukaryotes 1670 0.62 Binding ≤ 10μM
GRIK4-2-E Glutamate Receptor Ionotropic Kainate 4 (cluster #2 Of 2), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
GRIK5-1-E Glutamate Receptor Ionotropic Kainate 5 (cluster #1 Of 2), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
GRM1-2-E Metabotropic Glutamate Receptor 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
GRM3-1-E Metabotropic Glutamate Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.82 Binding ≤ 10μM
GRM5-2-E Metabotropic Glutamate Receptor 5 (cluster #2 Of 5), Eukaryotic Eukaryotes 150 0.73 Binding ≤ 10μM
GRM7-1-E Metabotropic Glutamate Receptor 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.82 Binding ≤ 10μM
GRM8-2-E Metabotropic Glutamate Receptor 8 (cluster #2 Of 2), Eukaryotic Eukaryotes 25 0.82 Binding ≤ 10μM
Q80T35-1-E Metabotropic Glutamate Receptor 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.82 Binding ≤ 10μM
Q80T43-1-E Metabotropic Glutamate Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.82 Binding ≤ 10μM
Q80T47-1-E Metabotropic Glutamate Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.82 Binding ≤ 10μM
XCT-1-E Cystine/glutamate Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 5000 0.57 Binding ≤ 10μM
GRM1-3-E Metabotropic Glutamate Receptor 1 (cluster #3 Of 5), Eukaryotic Eukaryotes 1100 0.64 Functional ≤ 10μM
GRM5-4-E Metabotropic Glutamate Receptor 5 (cluster #4 Of 5), Eukaryotic Eukaryotes 55 0.78 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 7300 0.55 Functional ≤ 10μM

Physical Representations

Type pH range xlogP Des A‑Pol Apolar desolvation (kcal/mol) Des Pol Polar desolvation (kcal/mol) H Don H-bond donors H Acc H-bond acceptors Chg Net charge tPSA (Ų) MWT Molecular weight (g/mol) RB Rotatable bonds DL
Ref Reference (pH 7) -4.04 -4.9 -43.55 3 8 -1 139 188.119 3
Hi High (pH 8-9.5) -4.04 -5.21 -87.71 2 8 -2 137 187.111 3
Mid Mid (pH 6-8) -4.04 -7.81 -15.85 4 8 0 132 189.127 3

Analogs

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
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 170 0.73 Binding ≤ 10μM
GRIA1-1-E Glutamate Receptor Ionotropic, AMPA 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 340 0.70 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 250 0.71 Binding ≤ 10μM
GRIA2-4-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #4 Of 4), Eukaryotic Eukaryotes 340 0.70 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 340 0.70 Binding ≤ 10μM
GRIA3-4-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #4 Of 4), Eukaryotic Eukaryotes 600 0.67 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 340 0.70 Binding ≤ 10μM
GRIA4-4-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #4 Of 5), Eukaryotic Eukaryotes 600 0.67 Binding ≤ 10μM
GRIK1-1-E Glutamate Receptor Ionotropic Kainate 1 (cluster #1 Of 3), Eukaryotic Eukaryotes 4800 0.57 Binding ≤ 10μM
GRM1-2-E Metabotropic Glutamate Receptor 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
GRM1-2-E Metabotropic Glutamate Receptor 1 (cluster #2 Of 3), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
GRM3-1-E Metabotropic Glutamate Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
GRM3-1-E Metabotropic Glutamate Receptor 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
GRM7-1-E Metabotropic Glutamate Receptor 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
GRM7-1-E Metabotropic Glutamate Receptor 7 (cluster #1 Of 1), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
GRM8-2-E Metabotropic Glutamate Receptor 8 (cluster #2 Of 2), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
GRM8-2-E Metabotropic Glutamate Receptor 8 (cluster #2 Of 2), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
Q80T35-1-E Metabotropic Glutamate Receptor 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
Q80T35-1-E Metabotropic Glutamate Receptor 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
Q80T43-1-E Metabotropic Glutamate Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
Q80T43-1-E Metabotropic Glutamate Receptor 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
Q80T47-1-E Metabotropic Glutamate Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.72 Binding ≤ 10μM
Q80T47-1-E Metabotropic Glutamate Receptor 5 (cluster #1 Of 1), Eukaryotic Eukaryotes 220 0.72 Binding ≤ 10μM
GRIA2-1-E Glutamate Receptor Ionotropic, AMPA 2 (cluster #1 Of 4), Eukaryotic Eukaryotes 5400 0.57 Functional ≤ 10μM
GRIA3-2-E Glutamate Receptor Ionotropic, AMPA 3 (cluster #2 Of 2), Eukaryotic Eukaryotes 600 0.67 Functional ≤ 10μM
GRIA4-2-E Glutamate Receptor Ionotropic, AMPA 4 (cluster #2 Of 3), Eukaryotic Eukaryotes 600 0.67 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 200 0.72 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 220 0.72 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.32 -0.57 -40.2 3 6 -1 112 250.028 3
Mid Mid (pH 6-8) -1.86 -2.1 -91.82 2 6 -2 115 249.02 3
Lo Low (pH 4.5-6) -2.32 -0.24 -33.53 4 6 0 114 251.036 3

Parameters Provided:

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

Permalink

Embed Link to Results