• Notice: Undefined index: synonym
    file: /domains/zinc12/htdocs/lib/zinc/reporter/ZincAuxiliaryInfoReports.php
    line: 245
  • Search Results | ZINC Is Not Commercial - A database of commercially-available compounds
    UCSF
    ZINC Item Suppliers, Protomers, & Similar Substances

    Analogs

    13319948
    13319948
    44699472
    44699472
    1530090
    1530090

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 1 0.43 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.43 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 510 0.30 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 510 0.30 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 3 0.41 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.59 12.96 -37.85 2 3 1 34 388.531 8
    Hi High (pH 8-9.5) 5.59 10.42 -6.22 1 3 0 33 387.523 8

    Analogs

    6548583
    6548583

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 19 0.34 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 346 0.28 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 32 0.33 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 32 0.33 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 32 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) 5.70 -1.28 -36.92 2 4 1 37 429.584 6

    Analogs

    5934385
    5934385

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 19 0.34 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 346 0.28 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 32 0.33 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 32 0.33 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 32 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) 5.70 12.2 -36.53 2 4 1 37 429.584 6

    Analogs

    602228
    602228
    34537110
    34537110

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 38 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    5HT2B-4-E Serotonin 2b (5-HT2b) Receptor (cluster #4 Of 4), Eukaryotic Eukaryotes 69 0.29 Binding ≤ 10μM
    EBP-1-E 3-beta-hydroxysteroid-delta(8),delta(7)-isomerase (cluster #1 Of 1), Eukaryotic Eukaryotes 1 0.37 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 7 0.34 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.33 Binding ≤ 10μM
    PLD1-1-E Phospholipase D1 (cluster #1 Of 2), Eukaryotic Eukaryotes 8500 0.21 Binding ≤ 10μM
    PLD2-1-E Phospholipase D2 (cluster #1 Of 1), Eukaryotic Eukaryotes 3400 0.23 Binding ≤ 10μM
    SGMR1-1-E Sigma Opioid Receptor (cluster #1 Of 6), Eukaryotic Eukaryotes 38 0.31 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.35 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 7 0.34 Functional ≤ 10μM
    ADO-1-E Aldehyde Oxidase (cluster #1 Of 3), Eukaryotic Eukaryotes 1100 0.25 ADME/T ≤ 10μM
    CP3A4-2-E Cytochrome P450 3A4 (cluster #2 Of 4), Eukaryotic Eukaryotes 9900 0.21 ADME/T ≤ 10μM
    ERG2-2-F C-8 Sterol Isomerase (cluster #2 Of 2), Fungal Fungi 66 0.30 Binding ≤ 10μM
    Z50425-3-O Plasmodium Falciparum (cluster #3 Of 22), Other Other 3162 0.23 Functional ≤ 10μM
    Z50466-1-O Trypanosoma Cruzi (cluster #1 Of 8), Other Other 10000 0.21 Functional ≤ 10μM
    Z50592-3-O Oryctolagus Cuniculus (cluster #3 Of 8), Other Other 2000 0.23 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 5 0.34 Functional ≤ 10μM
    Z80561-1-O U2OS (Osteosarcoma Cells) (cluster #1 Of 1), Other Other 3 0.35 Functional ≤ 10μM
    Z80936-1-O HEK293 (Embryonic Kidney Fibroblasts) (cluster #1 Of 4), Other Other 4 0.35 Functional ≤ 10μM
    Z81068-1-O Ishikawa (Uterine Carcinoma Cells) (cluster #1 Of 1), Other Other 23 0.31 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) 6.22 10.88 -44.71 3 5 1 71 474.602 7
    Hi High (pH 8-9.5) 6.22 8.67 -11.05 2 5 0 70 473.594 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 20 0.31 Binding ≤ 10μM
    ESR2-3-E Estrogen Receptor Beta (cluster #3 Of 4), Eukaryotic Eukaryotes 20 0.31 Binding ≤ 10μM
    RASH-1-E Transforming Protein P21/H-Ras-1 (cluster #1 Of 1), Eukaryotic Eukaryotes 200 0.27 Binding ≤ 10μM
    TOP1-1-E DNA Topoisomerase 1 (cluster #1 Of 2), Eukaryotic Eukaryotes 2700 0.22 Binding ≤ 10μM
    Z80186-1-O K562 (Erythroleukemia Cells) (cluster #1 Of 11), Other Other 5000 0.21 Functional ≤ 10μM
    Z80193-2-O L1210 (Lymphocytic Leukemia Cells) (cluster #2 Of 12), Other Other 9640 0.20 Functional ≤ 10μM
    Z81115-1-O KB (Squamous Cell Carcinoma) (cluster #1 Of 6), Other Other 8400 0.20 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.04 2.11 -51.46 8 13 1 183 482.525 9

    Analogs

    3814382
    3814382

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ANDR-2-E Androgen Receptor (cluster #2 Of 4), Eukaryotic Eukaryotes 89 0.31 Binding ≤ 10μM
    ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 5), Eukaryotic Eukaryotes 5000 0.23 Binding ≤ 10μM
    ESR2-2-E Estrogen Receptor Beta (cluster #2 Of 4), Eukaryotic Eukaryotes 2876 0.24 Binding ≤ 10μM
    GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 410 0.28 Binding ≤ 10μM
    MCR-1-E Mineralocorticoid Receptor (cluster #1 Of 2), Eukaryotic Eukaryotes 640 0.27 Binding ≤ 10μM
    PRGR-1-E Progesterone Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 4 0.37 Binding ≤ 10μM
    ANDR-2-E Androgen Receptor (cluster #2 Of 3), Eukaryotic Eukaryotes 8 0.35 Functional ≤ 10μM
    ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 2244 0.25 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 812 0.27 Functional ≤ 10μM
    GCR-2-E Glucocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 2 0.38 Functional ≤ 10μM
    MCR-2-E Mineralocorticoid Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 1155 0.26 Functional ≤ 10μM
    PRGR-2-E Progesterone Receptor (cluster #2 Of 2), Eukaryotic Eukaryotes 3 0.37 Functional ≤ 10μM
    CP3A4-2-E Cytochrome P450 3A4 (cluster #2 Of 4), Eukaryotic Eukaryotes 4700 0.23 ADME/T ≤ 10μM
    Z50425-4-O Plasmodium Falciparum (cluster #4 Of 22), Other Other 6310 0.23 Functional ≤ 10μM
    Z80110-2-O CV-1 (Kidney Cells) (cluster #2 Of 2), Other Other 10 0.35 Functional ≤ 10μM
    Z80491-2-O SK-N-MC (Neuroepithelioma Cells) (cluster #2 Of 4), Other Other 0 0.00 Functional ≤ 10μM
    Z80951-1-O NIH3T3 (Fibroblasts) (cluster #1 Of 4), Other Other 2 0.38 Functional ≤ 10μM
    VP16-1-V Alpha Trans-inducing Protein (VP16) (cluster #1 Of 1), Viral Viruses 1 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) 5.60 1.26 -10.46 1 3 0 40 429.604 2

    Analogs

    14948382
    14948382
    14948385
    14948385
    28263800
    28263800
    36288955
    36288955

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 12), Eukaryotic Eukaryotes 37 0.43 Binding ≤ 10μM
    CAH2-1-E Carbonic Anhydrase II (cluster #1 Of 15), Eukaryotic Eukaryotes 9 0.47 Binding ≤ 10μM
    CAH9-3-E Carbonic Anhydrase IX (cluster #3 Of 11), Eukaryotic Eukaryotes 30 0.44 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 2600 0.33 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 3700 0.32 Binding ≤ 10μM
    STS-1-E Steryl-sulfatase Precursor (cluster #1 Of 2), Eukaryotic Eukaryotes 93 0.41 Binding ≤ 10μM
    CAH1-1-E Carbonic Anhydrase I (cluster #1 Of 3), Eukaryotic Eukaryotes 37 0.43 Functional ≤ 10μM
    CAH2-2-E Carbonic Anhydrase II (cluster #2 Of 2), Eukaryotic Eukaryotes 10 0.47 Functional ≤ 10μM
    STS-1-E Steryl-sulfatase Precursor (cluster #1 Of 1), Eukaryotic Eukaryotes 20 0.45 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.54 -4.79 -15.28 2 5 0 86 349.452 2

    Analogs

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 64 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ANDR-1-E Androgen Receptor (cluster #1 Of 4), Eukaryotic Eukaryotes 26 0.53 Binding ≤ 10μM
    ERR1-1-E Estrogen-related Receptor Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 4 0.59 Binding ≤ 10μM
    ERR2-1-E Estrogen-related Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 3 0.60 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 4 0.59 Binding ≤ 10μM
    GPER-1-E G-protein Coupled Estrogen Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.58 Binding ≤ 10μM
    SHBG-1-E Testis-specific Androgen-binding Protein (cluster #1 Of 1), Eukaryotic Eukaryotes 50 0.51 Binding ≤ 10μM
    ERR1-1-E Estrogen-related Receptor Alpha (cluster #1 Of 1), Eukaryotic Eukaryotes 6 0.58 Functional ≤ 10μM
    ERR2-1-E Estrogen-related Receptor Beta (cluster #1 Of 1), Eukaryotic Eukaryotes 5 0.58 Functional ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 50 0.51 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 10 0.56 Functional ≤ 10μM
    GPER-1-E G-protein Coupled Estrogen Receptor 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 0 0.00 Functional ≤ 10μM
    ADO-2-E Aldehyde Oxidase (cluster #2 Of 3), Eukaryotic Eukaryotes 3000 0.39 ADME/T ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 1 0.63 Functional ≤ 10μM
    Z80226-1-O MCF7-2A (cluster #1 Of 1), Other Other 0 0.00 Functional ≤ 10μM
    Z80475-2-O SK-BR-3 (Breast Adenocarcinoma) (cluster #2 Of 3), Other Other 0 0.00 Functional ≤ 10μM
    Z81068-1-O Ishikawa (Uterine Carcinoma Cells) (cluster #1 Of 1), Other Other 0 0.00 Functional ≤ 10μM
    Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 1 0.63 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.43 4.8 -5.19 2 2 0 40 272.388 0

    Analogs

    31705487
    31705487
    1871287
    1871287
    2039577
    2039577
    2039578
    2039578
    2039579
    2039579

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 8 0.57 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 24 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) 3.45 -2.79 -5.98 2 2 0 40 268.356 0

    Analogs

    5925939
    5925939
    5923210
    5923210
    5923219
    5923219
    4826265
    4826265
    4826273
    4826273

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 0 0.00 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.15 0.11 -11.24 2 3 0 64 267.328 4

    Analogs

    3995807
    3995807
    3995809
    3995809
    3995811
    3995811
    26265317
    26265317
    26265324
    26265324

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 8 0.28 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.28 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 5 0.28 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.28 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 18 0.26 Functional ≤ 10μM
    Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 18 0.26 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) 7.96 -0.35 -17.51 2 3 0 57 606.782 15

    Analogs

    3995811
    3995811
    26265317
    26265317
    26265324
    26265324
    3926298
    3926298

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 8 0.28 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.28 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 5 0.28 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 5 0.28 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 18 0.26 Functional ≤ 10μM
    Z81170-1-O LNCaP (Prostate Carcinoma) (cluster #1 Of 5), Other Other 18 0.26 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) 7.96 -0.35 -17.82 2 3 0 57 606.782 15

    Analogs

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 39 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    DHB1-1-E Estradiol 17-beta-dehydrogenase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 810 0.43 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 96 0.49 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 8 0.57 Binding ≤ 10μM
    DHB1-1-E Estradiol 17-beta-dehydrogenase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 330 0.45 Functional ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 120 0.48 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 26 0.53 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 0 0.00 Functional ≤ 10μM
    Z81247-2-O HeLa (Cervical Adenocarcinoma Cells) (cluster #2 Of 9), Other Other 26 0.53 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.24 7.14 -7.63 1 2 0 37 270.372 0

    Analogs

    31561765
    31561765
    518397
    518397

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 506 0.42 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 506 0.42 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 65 0.48 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 65 0.48 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 65 0.48 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.17 2.9 -7.49 3 3 0 61 288.387 0

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 3 0.50 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 3 0.50 Binding ≤ 10μM
    Z81068-1-O Ishikawa (Uterine Carcinoma Cells) (cluster #1 Of 1), 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.36 -0.89 -6.4 2 3 0 49 326.436 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
    ESR2-3-E Estrogen Receptor Beta (cluster #3 Of 4), Eukaryotic Eukaryotes 34 0.31 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.89 10.71 -46.9 3 5 1 65 473.618 5
    Mid Mid (pH 6-8) 5.89 8.34 -11.24 2 5 0 64 472.61 5

    Analogs

    34553898
    34553898

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 199 0.49 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 3 0.63 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.75 0.25 -8.83 2 4 0 66 324.105 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 132 0.54 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 2 0.68 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.40 -5.28 -8.54 2 4 0 66 306.115 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 2222 0.26 Binding ≤ 10μM
    ESR2-3-E Estrogen Receptor Beta (cluster #3 Of 4), Eukaryotic Eukaryotes 139 0.32 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.98 9.7 -8.45 1 4 0 50 423.316 4

    Analogs

    2581732
    2581732

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 120 0.37 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 250 0.36 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.80 1.38 -12.62 1 3 0 50 362.812 3

    Analogs

    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
    ESR1-5-E Estrogen Receptor Alpha (cluster #5 Of 5), Eukaryotic Eukaryotes 638 0.51 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 245 0.54 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.44 -0.1 -6.28 1 1 0 20 220.271 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
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 680 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.52 3.41 -7.29 2 3 0 50 240.258 1

    Analogs

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 15 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-3-E Estrogen Receptor Alpha (cluster #3 Of 5), Eukaryotic Eukaryotes 6950 0.34 Binding ≤ 10μM
    ESR2-3-E Estrogen Receptor Beta (cluster #3 Of 4), Eukaryotic Eukaryotes 171 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) 5.56 0.99 -5.93 1 1 0 15 269.347 2

    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
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 8609 0.37 Binding ≤ 10μM
    ESR2-2-E Estrogen Receptor Beta (cluster #2 Of 2), Eukaryotic Eukaryotes 961 0.44 Functional ≤ 10μM
    Z81247-7-O HeLa (Cervical Adenocarcinoma Cells) (cluster #7 Of 9), Other Other 961 0.44 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.34 -2.49 -12.03 2 5 0 75 254.245 1

    Analogs

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 7 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 1450 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) 3.47 5.98 -15.83 1 3 0 50 226.231 0

    Analogs

    Draw Identity 99% 90% 80% 70%


    Notice: Undefined index: field_name in /domains/zinc12/htdocs/lib/zinc/reporter/ZincAuxiliaryInfoReports.php on line 244

    Notice: Undefined index: synonym in /domains/zinc12/htdocs/lib/zinc/reporter/ZincAuxiliaryInfoReports.php on line 245

    Vendors

    And 6 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 308 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) 3.50 0.86 -13.34 1 4 0 59 256.257 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
    ESR1-3-E Estrogen Receptor Alpha (cluster #3 Of 5), Eukaryotic Eukaryotes 240 0.49 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 12 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) 4.29 -1.47 -7.41 2 2 0 40 252.313 1

    Analogs

    38208787
    38208787

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 93 0.41 Binding ≤ 10μM
    ESR2-3-E Estrogen Receptor Beta (cluster #3 Of 4), Eukaryotic Eukaryotes 106 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) 4.09 4.34 -10.43 2 4 0 58 334.297 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 22 0.32 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 66 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) 7.05 -0.41 -39.75 2 5 1 52 476.618 8

    Analogs

    639297
    639297

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 53 0.33 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 780 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) 4.08 -0.68 -11.19 3 6 0 91 421.424 6

    Analogs

    639294
    639294

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 53 0.33 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 780 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) 4.08 -0.32 -10.34 3 6 0 91 421.424 6

    Analogs

    639309
    639309

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 56 0.33 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 915 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) 4.42 -1.22 -11.06 3 6 0 91 417.461 6

    Analogs

    639306
    639306

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 56 0.33 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 915 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) 4.42 -1.2 -11.31 3 6 0 91 417.461 6

    Analogs

    41660888
    41660888
    41660894
    41660894

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 2100 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) 4.75 6.32 -4.97 1 1 0 20 218.683 1

    Analogs

    34521009
    34521009
    34573404
    34573404
    40174791
    40174791

    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
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 2400 0.52 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.31 -0.21 -6.18 1 2 0 29 200.237 2

    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
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 1800 0.54 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.96 5.37 -8.85 1 2 0 44 195.221 1

    Analogs

    39119182
    39119182

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 4000 0.54 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.63 5.71 -4.54 1 1 0 20 184.238 1

    Analogs

    32153068
    32153068
    41661165
    41661165
    41662447
    41662447

    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
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), 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) 3.39 5.13 -5.62 1 1 0 20 188.201 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 3 0.57 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 0 0.00 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 19 0.51 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.60 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.66 -2.67 -6.72 2 3 0 50 282.339 1

    Analogs

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 48 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 3000 0.39 Binding ≤ 10μM
    AA2AR-3-E Adenosine A2a Receptor (cluster #3 Of 4), Eukaryotic Eukaryotes 7580 0.36 Binding ≤ 10μM
    ABCG2-1-E ATP-binding Cassette Sub-family G Member 2 (cluster #1 Of 2), Eukaryotic Eukaryotes 5900 0.37 Binding ≤ 10μM
    ALDR-1-E Aldose Reductase (cluster #1 Of 5), Eukaryotic Eukaryotes 6670 0.36 Binding ≤ 10μM
    AOFA-4-E Monoamine Oxidase A (cluster #4 Of 8), Eukaryotic Eukaryotes 1700 0.40 Binding ≤ 10μM
    BGLR-1-E Beta-glucuronidase (cluster #1 Of 2), Eukaryotic Eukaryotes 2800 0.39 Binding ≤ 10μM
    CCNB1-1-E G2/mitotic-specific Cyclin B1 (cluster #1 Of 2), Eukaryotic Eukaryotes 4000 0.38 Binding ≤ 10μM
    CCNB2-1-E G2/mitotic-specific Cyclin B2 (cluster #1 Of 2), Eukaryotic Eukaryotes 4000 0.38 Binding ≤ 10μM
    CCNB3-1-E G2/mitotic-specific Cyclin B3 (cluster #1 Of 2), Eukaryotic Eukaryotes 4000 0.38 Binding ≤ 10μM
    CDK1-1-E Cyclin-dependent Kinase 1 (cluster #1 Of 4), Eukaryotic Eukaryotes 4000 0.38 Binding ≤ 10μM
    CDK6-1-E Cyclin-dependent Kinase 6 (cluster #1 Of 1), Eukaryotic Eukaryotes 1700 0.40 Binding ≤ 10μM
    CP19A-3-E Cytochrome P450 19A1 (cluster #3 Of 3), Eukaryotic Eukaryotes 900 0.42 Binding ≤ 10μM
    CP1B1-1-E Cytochrome P450 1B1 (cluster #1 Of 1), Eukaryotic Eukaryotes 25 0.53 Binding ≤ 10μM
    CSK21-2-E Casein Kinase II Alpha (cluster #2 Of 3), Eukaryotic Eukaryotes 800 0.43 Binding ≤ 10μM
    CSK2B-3-E Casein Kinase II Beta (cluster #3 Of 3), Eukaryotic Eukaryotes 4290 0.38 Binding ≤ 10μM
    DHB1-1-E Estradiol 17-beta-dehydrogenase 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 710 0.43 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 660 0.43 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 660 0.43 Binding ≤ 10μM
    GBRA1-1-E GABA Receptor Alpha-1 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.39 Binding ≤ 10μM
    GBRA2-1-E GABA Receptor Alpha-2 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.39 Binding ≤ 10μM
    GBRA3-1-E GABA Receptor Alpha-3 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.39 Binding ≤ 10μM
    GBRA4-1-E GABA Receptor Alpha-4 Subunit (cluster #1 Of 7), Eukaryotic Eukaryotes 3020 0.39 Binding ≤ 10μM
    GBRA5-1-E GABA Receptor Alpha-5 Subunit (cluster #1 Of 8), Eukaryotic Eukaryotes 3020 0.39 Binding ≤ 10μM
    GBRA6-6-E GABA Receptor Alpha-6 Subunit (cluster #6 Of 8), Eukaryotic Eukaryotes 3020 0.39 Binding ≤ 10μM
    GSK3A-1-E Glycogen Synthase Kinase-3 Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 1400 0.41 Binding ≤ 10μM
    GSK3B-7-E Glycogen Synthase Kinase-3 Beta (cluster #7 Of 7), Eukaryotic Eukaryotes 1400 0.41 Binding ≤ 10μM
    MRP1-1-E Multidrug Resistance-associated Protein 1 (cluster #1 Of 1), Eukaryotic Eukaryotes 2400 0.39 Binding ≤ 10μM
    NOX4-1-E NADPH Oxidase 4 (cluster #1 Of 1), Eukaryotic Eukaryotes 1130 0.42 Binding ≤ 10μM
    P90584-1-E Protein Kinase Pfmrk (cluster #1 Of 2), Eukaryotic Eukaryotes 7000 0.36 Binding ≤ 10μM
    PGH2-4-E Cyclooxygenase-2 (cluster #4 Of 8), Eukaryotic Eukaryotes 8000 0.36 Binding ≤ 10μM
    XDH-2-E Xanthine Dehydrogenase (cluster #2 Of 2), Eukaryotic Eukaryotes 700 0.43 Binding ≤ 10μM
    ANDR-1-E Androgen Receptor (cluster #1 Of 3), Eukaryotic Eukaryotes 5200 0.37 Functional ≤ 10μM
    CP1A1-1-E Cytochrome P450 1A1 (cluster #1 Of 3), Eukaryotic Eukaryotes 427 0.45 ADME/T ≤ 10μM
    CP1A2-1-E Cytochrome P450 1A2 (cluster #1 Of 3), Eukaryotic Eukaryotes 795 0.43 ADME/T ≤ 10μM
    CP1B1-1-E Cytochrome P450 1B1 (cluster #1 Of 3), Eukaryotic Eukaryotes 64 0.50 ADME/T ≤ 10μM
    Z104294-2-O Cyclin-dependent Kinase 5/CDK5 Activator 1 (cluster #2 Of 2), Other Other 1600 0.41 Binding ≤ 10μM
    Z104301-4-O GABA-A Receptor; Anion Channel (cluster #4 Of 8), Other Other 770 0.43 Binding ≤ 10μM
    Z50597-1-O Rattus Norvegicus (cluster #1 Of 12), Other Other 3400 0.38 Functional ≤ 10μM
    Z50607-3-O Human Immunodeficiency Virus 1 (cluster #3 Of 10), Other Other 9000 0.35 Functional ≤ 10μM
    Z50652-3-O Influenza A Virus (cluster #3 Of 4), Other Other 4740 0.37 Functional ≤ 10μM
    Z80418-2-O RAW264.7 (Monocytic-macrophage Leukemia Cells) (cluster #2 Of 9), Other Other 7700 0.36 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.46 1.12 -12.82 3 5 0 91 270.24 1
    Mid Mid (pH 6-8) 2.72 1.4 -45.92 2 5 -1 94 269.232 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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 1000 0.44 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 7470 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.90 1.13 -9.05 3 3 0 61 276.288 1

    Analogs

    4098705
    4098705

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 39 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    CSK21-1-E Casein Kinase II Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 890 0.42 Binding ≤ 10μM
    CSK2B-1-E Casein Kinase II Beta (cluster #1 Of 3), Eukaryotic Eukaryotes 890 0.42 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 770 0.43 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 5200 0.37 Binding ≤ 10μM
    Z80928-6-O HCT-116 (Colon Carcinoma Cells) (cluster #6 Of 9), Other Other 5700 0.37 Functional ≤ 10μM
    Z81020-3-O HepG2 (Hepatoblastoma Cells) (cluster #3 Of 8), Other Other 5200 0.37 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.01 1.74 -10.81 3 5 0 95 270.24 0
    Hi High (pH 8-9.5) 3.01 2.52 -45.75 2 5 -1 98 269.232 0

    Analogs

    519099
    519099
    519452
    519452
    4027098
    4027098
    4027099
    4027099
    4027100
    4027100

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 5), Eukaryotic Eukaryotes 3200 0.40 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 850 0.45 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 20 0.57 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 20 0.57 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 20 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.54 -3.38 -5.95 2 3 0 49 260.333 2

    Analogs

    519452
    519452
    4027098
    4027098
    4027099
    4027099
    4027100
    4027100
    187200
    187200

    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
    ESR1-2-E Estrogen Receptor Alpha (cluster #2 Of 5), Eukaryotic Eukaryotes 3200 0.40 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 850 0.45 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 20 0.57 Functional ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 835 0.45 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 20 0.57 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 61 0.53 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 20 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.54 -3.33 -6.32 2 3 0 49 260.333 2

    Analogs

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 310 0.51 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 690 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.66 1.65 -9.01 2 4 0 75 240.214 0
    Hi High (pH 8-9.5) 2.66 2.43 -43.99 1 4 -1 77 239.206 0
    Hi High (pH 8-9.5) 2.66 3.2 -85.88 0 4 -2 80 238.198 0

    Analogs

    Draw Identity 99% 90% 80% 70%

    Vendors

    And 7 More

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-5-E Estrogen Receptor Alpha (cluster #5 Of 5), Eukaryotic Eukaryotes 76 0.50 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 2 0.61 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.54 3.05 -12.71 2 5 0 84 268.224 0

    Analogs

    11680893
    11680893
    11680896
    11680896
    537882
    537882

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 4 0.38 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 11 0.36 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 1 0.41 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 24 0.34 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 24 0.34 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 2 0.39 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 2 0.39 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 0 0.00 Functional ≤ 10μM
    Z80224-1-O MCF7 (Breast Carcinoma Cells) (cluster #1 Of 14), Other Other 2 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) 6.07 0.19 -37.23 2 3 1 33 414.569 6

    Analogs

    3995935
    3995935

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 20 0.60 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 6 0.64 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 66 0.56 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.70 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.01 4.01 -12.02 2 3 0 64 239.274 3

    Analogs

    2383130
    2383130

    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
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 5), Eukaryotic Eukaryotes 20 0.60 Binding ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 4), Eukaryotic Eukaryotes 6 0.64 Binding ≤ 10μM
    ESR1-1-E Estrogen Receptor Alpha (cluster #1 Of 3), Eukaryotic Eukaryotes 66 0.56 Functional ≤ 10μM
    ESR2-1-E Estrogen Receptor Beta (cluster #1 Of 2), Eukaryotic Eukaryotes 1 0.70 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.01 -0.62 -12.03 2 3 0 64 239.274 3

    Analogs

    39242799
    39242799

    Draw Identity 99% 90% 80% 70%

    Vendors

    Activity (Go SEA)

    Clustered Target Annotations
    Code Description Organism Class Affinity (nM) LE (kcal/mol/atom) Type
    ESR1-5-E Estrogen Receptor Alpha (cluster #5 Of 5), Eukaryotic Eukaryotes 176 0.56 Binding ≤ 10μM
    ESR2-4-E Estrogen Receptor Beta (cluster #4 Of 4), Eukaryotic Eukaryotes 6 0.68 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.20 2.87 -8.27 2 3 0 54 226.231 1

    Parameters Provided:

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

    Permalink

    Embed Link to Results

  • Notice: Undefined index: synonym
    file: /domains/zinc12/htdocs/lib/zinc/reporter/ZincAuxiliaryInfoReports.php
    line: 245