UCSF
ZINC Item Suppliers, Protomers, & Similar Substances

Analogs

1530611
1530611

Draw Identity 99% 90% 80% 70%

Vendors

And 33 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT1A-1-E Serotonin 1a (5-HT1a) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT1B-1-E Serotonin 1b (5-HT1b) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT1D-1-E Serotonin 1d (5-HT1d) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT1F-1-E Serotonin 1f (5-HT1f) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 94 0.47 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 160 0.45 Binding ≤ 10μM
5HT4R-1-E Serotonin 4 (5-HT4) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT5A-1-E Serotonin 5a (5-HT5a) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT5B-1-E Serotonin 5b (5-HT5b) Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT6R-1-E Serotonin 6 (5-HT6) Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
5HT7R-1-E Serotonin 7 (5-HT7) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 44 0.49 Binding ≤ 10μM
AA3R-3-E Adenosine Receptor A3 (cluster #3 Of 6), Eukaryotic Eukaryotes 4 0.56 Binding ≤ 10μM
ACM5-2-E Muscarinic Acetylcholine Receptor M5 (cluster #2 Of 4), Eukaryotic Eukaryotes 300 0.43 Binding ≤ 10μM
ADA1A-2-E Alpha-1a Adrenergic Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 46 0.49 Binding ≤ 10μM
ADA1B-1-E Alpha-1b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 46 0.49 Binding ≤ 10μM
ADA1D-1-E Alpha-1d Adrenergic Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 46 0.49 Binding ≤ 10μM
ADA2A-3-E Alpha-2a Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
ADA2B-1-E Alpha-2b Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
ADA2C-3-E Alpha-2c Adrenergic Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 4900 0.35 Binding ≤ 10μM
ADCY1-1-E Brain Adenylate Cyclase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 160 0.45 Binding ≤ 10μM
ADCY2-2-E Adenylate Cyclase Type II (cluster #2 Of 2), Eukaryotic Eukaryotes 160 0.45 Binding ≤ 10μM
ADCY8-1-E Adenylate Cyclase Type VIII (cluster #1 Of 2), Eukaryotic Eukaryotes 160 0.45 Binding ≤ 10μM
ADRB1-1-E Beta-1 Adrenergic Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 46 0.49 Binding ≤ 10μM
ADRB2-1-E Beta-2 Adrenergic Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 46 0.49 Binding ≤ 10μM
ADRB3-1-E Beta-3 Adrenergic Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 46 0.49 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 645 0.41 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 645 0.41 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 645 0.41 Binding ≤ 10μM
DRD5-1-E Dopamine D5 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 645 0.41 Binding ≤ 10μM
HRH1-2-E Histamine H1 Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 30 0.50 Binding ≤ 10μM
HRH2-2-E Histamine H2 Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 30 0.50 Binding ≤ 10μM
HRH3-1-E Histamine H3 Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 30 0.50 Binding ≤ 10μM
HRH4-1-E Histamine H4 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 30 0.50 Binding ≤ 10μM
KCNH2-5-E HERG (cluster #5 Of 5), Eukaryotic Eukaryotes 5470 0.35 Binding ≤ 10μM
PRIO-1-E Prion Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.33 Binding ≤ 10μM
Q9WTR4-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 3 0.57 Binding ≤ 10μM
SC6A2-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 74 0.48 Binding ≤ 10μM
SC6A3-1-E Dopamine Transporter (cluster #1 Of 3), Eukaryotic Eukaryotes 42 0.49 Binding ≤ 10μM
SC6A4-3-E Serotonin Transporter (cluster #3 Of 4), Eukaryotic Eukaryotes 5 0.55 Binding ≤ 10μM
SCN1A-1-E Sodium Channel Protein Type I Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 3600 0.36 Binding ≤ 10μM
SCN2A-1-E Sodium Channel Protein Type II Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 3600 0.36 Binding ≤ 10μM
SCN3A-1-E Sodium Channel Protein Type III Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 3600 0.36 Binding ≤ 10μM
SCN8A-1-E Sodium Channel Protein Type VIII Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 3600 0.36 Binding ≤ 10μM
HRH2-1-E Histamine H2 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 1900 0.38 Functional ≤ 10μM
KCNH2-1-E HERG (cluster #1 Of 2), Eukaryotic Eukaryotes 3400 0.36 Functional ≤ 10μM
Q9WTR4-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 60 0.48 Functional ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 1), Eukaryotic Eukaryotes 810 0.41 Functional ≤ 10μM
DRD2-14-E Dopamine D2 Receptor (cluster #14 Of 24), Eukaryotic Eukaryotes 645 0.41 Binding ≤ 10μM
Z104303-1-O Muscarinic Acetylcholine Receptor (cluster #1 Of 7), Other Other 65 0.48 Binding ≤ 10μM
Z104304-1-O Adrenergic Receptor Alpha-1 (cluster #1 Of 3), Other Other 46 0.49 Binding ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 5), Other Other 12 0.53 Binding ≤ 10μM
Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 1259 0.39 Functional ≤ 10μM
Z50594-6-O Mus Musculus (cluster #6 Of 9), Other Other 300 0.43 Functional ≤ 10μM
Z50597-12-O Rattus Norvegicus (cluster #12 Of 12), Other Other 85 0.47 Functional ≤ 10μM
Z81138-1-O ScN2a (Scrapie-infected Neuroblastoma Cells) (cluster #1 Of 3), Other Other 5000 0.35 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.16 12.58 -35.72 1 2 1 8 281.423 4

Analogs

1536780
1536780
22060628
22060628
32112083
32112083
32112085
32112085
32112087
32112087

Draw Identity 99% 90% 80% 70%

Vendors

And 54 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
Q63380-1-E Transporter (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.57 Binding ≤ 10μM
Q9WTR4-2-E Norepinephrine Transporter (cluster #2 Of 2), Eukaryotic Eukaryotes 8 0.54 Binding ≤ 10μM
SC6A2-2-E Norepinephrine Transporter (cluster #2 Of 2), Eukaryotic Eukaryotes 9 0.54 Binding ≤ 10μM
SC6A2-2-E Norepinephrine Transporter (cluster #2 Of 2), Eukaryotic Eukaryotes 20 0.51 Binding ≤ 10μM
SC6A3-3-E Dopamine Transporter (cluster #3 Of 3), Eukaryotic Eukaryotes 870 0.40 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.60 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.60 Binding ≤ 10μM
CP2D6-2-E Cytochrome P450 2D6 (cluster #2 Of 3), Eukaryotic Eukaryotes 1000 0.40 ADME/T ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 5 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.69 9.87 -43.04 2 2 1 26 298.431 6

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
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 1415 0.24 Binding ≤ 10μM
5HT2C-2-E Serotonin 2c (5-HT2c) Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 1000 0.25 Binding ≤ 10μM
CCR1-1-E C-C Chemokine Receptor Type 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.21 Binding ≤ 10μM
CCR2-1-E C-C Chemokine Receptor Type 2 (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.21 Binding ≤ 10μM
CCR3-1-E C-C Chemokine Receptor Type 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 9 0.33 Binding ≤ 10μM
CCR5-1-E C-C Chemokine Receptor Type 5 (cluster #1 Of 4), Eukaryotic Eukaryotes 1000 0.25 Binding ≤ 10μM
CXCR1-1-E Interleukin-8 Receptor A (cluster #1 Of 1), Eukaryotic Eukaryotes 10000 0.21 Binding ≤ 10μM
CXCR2-1-E Interleukin-8 Receptor B (cluster #1 Of 2), Eukaryotic Eukaryotes 10000 0.21 Binding ≤ 10μM
Q9WTR4-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 611 0.26 Binding ≤ 10μM
SC6A2-2-E Norepinephrine Transporter (cluster #2 Of 2), Eukaryotic Eukaryotes 611 0.26 Binding ≤ 10μM
SC6A3-1-E Dopamine Transporter (cluster #1 Of 3), Eukaryotic Eukaryotes 718 0.25 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 2350 0.23 Binding ≤ 10μM
CCR3-1-E C-C Chemokine Receptor Type 3 (cluster #1 Of 1), Eukaryotic Eukaryotes 10 0.33 Functional ≤ 10μM
CP2D6-1-E Cytochrome P450 2D6 (cluster #1 Of 3), Eukaryotic Eukaryotes 240 0.27 ADME/T ≤ 10μM
DRD2-17-E Dopamine D2 Receptor (cluster #17 Of 24), Eukaryotic Eukaryotes 321 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) 5.40 14.84 -55.42 3 6 1 76 487.665 7

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
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 731 0.39 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.57 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 3 0.54 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 5520 0.33 Binding ≤ 10μM
DRD5-1-E Dopamine D5 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 2 0.55 Binding ≤ 10μM
SC6A4-1-E Serotonin Transporter (cluster #1 Of 4), Eukaryotic Eukaryotes 80 0.45 Binding ≤ 10μM
DRD2-2-E Dopamine D2 Receptor (cluster #2 Of 24), Eukaryotic Eukaryotes 980 0.38 Binding ≤ 10μM
DRD2-2-E Dopamine D2 Receptor (cluster #2 Of 24), Eukaryotic Eukaryotes 4115 0.34 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) 4.39 8.44 -43.98 2 2 1 25 314.836 0
Hi High (pH 8-9.5) 4.39 9.19 -65.57 1 2 0 27 313.828 0
Hi High (pH 8-9.5) 4.39 6.23 -4.13 1 2 0 23 313.828 0

Analogs

6117185
6117185

Draw Identity 99% 90% 80% 70%

Vendors

And 33 More

Activity (Go SEA)

Clustered Target Annotations
Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 3 0.54 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 3 0.54 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 11 0.51 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 63 0.46 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 63 0.46 Binding ≤ 10μM
DRD4-3-E Dopamine D4 Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 63 0.46 Binding ≤ 10μM
DRD5-1-E Dopamine D5 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 63 0.46 Binding ≤ 10μM
HRH1-2-E Histamine H1 Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 5400 0.34 Binding ≤ 10μM
SC6A2-1-E Norepinephrine Transporter (cluster #1 Of 2), Eukaryotic Eukaryotes 290 0.42 Binding ≤ 10μM
SC6A4-3-E Serotonin Transporter (cluster #3 Of 4), Eukaryotic Eukaryotes 4100 0.34 Binding ≤ 10μM
SCN1A-1-E Sodium Channel Protein Type I Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.38 Binding ≤ 10μM
SCN2A-1-E Sodium Channel Protein Type II Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.38 Binding ≤ 10μM
SCN3A-1-E Sodium Channel Protein Type III Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.38 Binding ≤ 10μM
SCN8A-1-E Sodium Channel Protein Type VIII Alpha Subunit (cluster #1 Of 2), Eukaryotic Eukaryotes 1000 0.38 Binding ≤ 10μM
DRD2-15-E Dopamine D2 Receptor (cluster #15 Of 24), Eukaryotic Eukaryotes 63 0.46 Binding ≤ 10μM
Z104303-1-O Muscarinic Acetylcholine Receptor (cluster #1 Of 7), Other Other 4 0.53 Binding ≤ 10μM
Z50425-11-O Plasmodium Falciparum (cluster #11 Of 22), Other Other 7943 0.32 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.07 12.93 -39.97 1 1 1 4 288.414 0

Analogs

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
5HT2A-1-E Serotonin 2a (5-HT2a) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 13 0.55 Binding ≤ 10μM
5HT2B-1-E Serotonin 2b (5-HT2b) Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 13 0.55 Binding ≤ 10μM
5HT2C-1-E Serotonin 2c (5-HT2c) Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 13 0.55 Binding ≤ 10μM
AA3R-3-E Adenosine Receptor A3 (cluster #3 Of 6), Eukaryotic Eukaryotes 1 0.63 Binding ≤ 10μM
ADA2A-1-E Alpha-2a Adrenergic Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 74 0.50 Binding ≤ 10μM
ADCY2-2-E Adenylate Cyclase Type II (cluster #2 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ADCY3-2-E Adenylate Cyclase Type III (cluster #2 Of 2), Eukaryotic Eukaryotes 3 0.60 Binding ≤ 10μM
ADCY4-2-E Adenylate Cyclase Type IV (cluster #2 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ADCY5-2-E Adenylate Cyclase Type V (cluster #2 Of 2), Eukaryotic Eukaryotes 3 0.60 Binding ≤ 10μM
ADCY6-2-E Adenylate Cyclase Type VI (cluster #2 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
ADCY8-1-E Adenylate Cyclase Type VIII (cluster #1 Of 2), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
DRD1-1-E Dopamine D1 Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 37 0.52 Binding ≤ 10μM
DRD3-1-E Dopamine D3 Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 768 0.43 Binding ≤ 10μM
DRD5-1-E Dopamine D5 Receptor (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.60 Binding ≤ 10μM
Q8CFM9-1-E Adenylate Cyclase Type VII (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
SC6A4-3-E Serotonin Transporter (cluster #3 Of 4), Eukaryotic Eukaryotes 9 0.56 Binding ≤ 10μM
DRD2-2-E Dopamine D2 Receptor (cluster #2 Of 24), Eukaryotic Eukaryotes 900 0.42 Binding ≤ 10μM
Z50425-11-O Plasmodium Falciparum (cluster #11 Of 22), Other Other 3981 0.38 Functional ≤ 10μM
Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 0 0.00 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.89 8.28 -39.17 2 2 1 25 288.798 1
Hi High (pH 8-9.5) 3.89 9.05 -61.19 1 2 0 27 287.79 1
Hi High (pH 8-9.5) 3.89 8.63 -45.42 0 2 -1 26 286.782 1

Parameters Provided:

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

Permalink

Embed Link to Results