UCSF banner
Search Results
Initial search took 0 second(s).
Beginning : #1 Hits: 100 Display:   per page=

Download: Show Detail?
Done
ZINC ID
Supplier information; Representations
Properties:xLogP, ap & p desolvation, HBD,HBA,Charge,Mwt,NRB
Annotations; Similarity
Structure

Click for quick 3D display
86753570
 
#1

Apexmol Building Blocks: AM99999
Chembo Pharma: KB-132583
ref: mol2, SDF, SMILES, flexibase
-0.77,-0.6,-16.88,2,5,0, 189.24, 3
lo: mol2, SDF, SMILES, flexibase
-0.77,-0.13,-38.65,3,5,1, 190.248, 3
95088627
 
#2

Apexmol Building Blocks: AM99998
Chembo Pharma: KB-130182
ref: mol2, SDF, SMILES, flexibase
-0.10,1.25,-15.98,1,5,0, 217.294, 4
lo: mol2, SDF, SMILES, flexibase
-0.10,1.65,-36.94,2,5,1, 218.302, 4
95091585
 
#3

Apexmol Building Blocks: AM99997
Chembo Pharma: KB-132792
ref: mol2, SDF, SMILES, flexibase
0.33,2.59,-17.41,1,5,0, 243.332, 5
mid: mol2, SDF, SMILES, flexibase
0.33,3.18,-32.55,2,5,1, 244.34, 5
95091584
 
#4

Apexmol Building Blocks: AM99997
Chembo Pharma: KB-132792
ref: mol2, SDF, SMILES, flexibase
0.33,2.65,-17.34,1,5,0, 243.332, 5
mid: mol2, SDF, SMILES, flexibase
0.33,3.13,-32.64,2,5,1, 244.34, 5
95088529
 
#5

Apexmol Building Blocks: AM99996
Chembo Pharma: KB-130123
ref: mol2, SDF, SMILES, flexibase
1.00,3.15,-16.68,1,5,0, 259.375, 5
mid: mol2, SDF, SMILES, flexibase
1.00,3.69,-31.94,2,5,1, 260.383, 5
95088528
 
#6

Apexmol Building Blocks: AM99996
Chembo Pharma: KB-130123
ref: mol2, SDF, SMILES, flexibase
1.00,3.29,-17.03,1,5,0, 259.375, 5
mid: mol2, SDF, SMILES, flexibase
1.00,3.98,-32.68,2,5,1, 260.383, 5
95091587
 
#7

Apexmol Building Blocks: AM99995
Chembo Pharma: KB-132793
ref: mol2, SDF, SMILES, flexibase
0.34,2.02,-17.64,1,5,0, 231.321, 5
mid: mol2, SDF, SMILES, flexibase
0.34,2.54,-33.64,2,5,1, 232.329, 5
95091586
 
#8

Apexmol Building Blocks: AM99995
Chembo Pharma: KB-132793
ref: mol2, SDF, SMILES, flexibase
0.34,2.02,-17.59,1,5,0, 231.321, 5
mid: mol2, SDF, SMILES, flexibase
0.34,2.63,-33.76,2,5,1, 232.329, 5
95091261
 
#9

Apexmol Building Blocks: AM99992
Chembo Pharma: KB-132559
ref: mol2, SDF, SMILES, flexibase
1.13,5.06,-7.18,0,2,0, 156.254, 2
mid: mol2, SDF, SMILES, flexibase
1.13,5.53,-26.19,1,2,1, 157.262, 2
hi: mol2, SDF, SMILES, flexibase
1.13,5.6,-50.97,0,2,-1, 155.246, 2
95091260
 
#10

Apexmol Building Blocks: AM99992
Chembo Pharma: KB-132559
ref: mol2, SDF, SMILES, flexibase
1.13,5.14,-7.24,0,2,0, 156.254, 2
mid: mol2, SDF, SMILES, flexibase
1.13,5.65,-26.28,1,2,1, 157.262, 2
hi: mol2, SDF, SMILES, flexibase
1.13,5.68,-51.59,0,2,-1, 155.246, 2
95089634
 
#11

Apexmol Building Blocks: AM99991
Chembo Pharma: KB-131282
ref: mol2, SDF, SMILES, flexibase
3.63,8.88,-5.94,0,3,0, 359.207, 3
95082888
 
#12

Apexmol Building Blocks: AM99990
Chembo Pharma: KB-125655
ref: mol2, SDF, SMILES, flexibase
2.99,2.82,-5.82,0,2,0, 173.643, 2
95088379
 
#13

Apexmol Building Blocks: AM99989
Chembo Pharma: KB-130023
ref: mol2, SDF, SMILES, flexibase
1.63,5.64,-6.48,1,3,0, 179.267, 3
mid: mol2, SDF, SMILES, flexibase
1.63,5.86,-23.01,2,3,1, 180.275, 3
95075670
 
#14

Apexmol Building Blocks: AM99988
Chembo Pharma: KB-140969
ref: mol2, SDF, SMILES, flexibase
0.96,4.23,-7.17,1,3,0, 151.213, 2
lo: mol2, SDF, SMILES, flexibase
0.96,4.39,-24.41,2,3,1, 152.221, 2
95088034
 
#15

Apexmol Building Blocks: AM99986
Chembo Pharma: KB-129679
ref: mol2, SDF, SMILES, flexibase
0.63,-0.48,-14.96,2,4,0, 220.319, 3
95088214
 
#16

Apexmol Building Blocks: AM99985
Chembo Pharma: KB-129924
ref: mol2, SDF, SMILES, flexibase
0.21,2.98,-14.78,0,5,0, 231.321, 4
lo: mol2, SDF, SMILES, flexibase
0.21,3.46,-35.05,1,5,1, 232.329, 4
95088655
 
#17

Apexmol Building Blocks: AM99984
Chembo Pharma: KB-130204
ref: mol2, SDF, SMILES, flexibase
-0.04,1.61,-17.23,1,5,0, 229.305, 4
lo: mol2, SDF, SMILES, flexibase
-0.04,2.33,-34.54,2,5,1, 230.313, 4
95088654
 
#18

Apexmol Building Blocks: AM99984
Chembo Pharma: KB-130204
ref: mol2, SDF, SMILES, flexibase
-0.04,2.01,-17.91,1,5,0, 229.305, 4
lo: mol2, SDF, SMILES, flexibase
-0.04,2.57,-34.82,2,5,1, 230.313, 4
95073937
 
#19

Apexmol Building Blocks: AM99982
Chembo Pharma: KB-139335
ref: mol2, SDF, SMILES, flexibase
1.27,1.13,-11.07,1,4,0, 232.692, 3
95075991
 
#20

Apexmol Building Blocks: AM99981
Chembo Pharma: KB-141206
ref: mol2, SDF, SMILES, flexibase
-0.41,0.43,-14.97,1,5,0, 203.267, 3
lo: mol2, SDF, SMILES, flexibase
-0.41,0.66,-34.51,2,5,1, 204.275, 3
95075990
 
#21

Apexmol Building Blocks: AM99981
Chembo Pharma: KB-141206
ref: mol2, SDF, SMILES, flexibase
-0.41,0.33,-18.58,1,5,0, 203.267, 3
lo: mol2, SDF, SMILES, flexibase
-0.41,0.88,-34.92,2,5,1, 204.275, 3
95076368
 
#22

Apexmol Building Blocks: AM99980
Chembo Pharma: KB-141506
ref: mol2, SDF, SMILES, flexibase
1.37,2.51,-12.14,0,4,0, 229.301, 4
95077142
 
#23

Apexmol Building Blocks: AM99976
Chembo Pharma: KB-142157
ref: mol2, SDF, SMILES, flexibase
0.67,4.33,-3.72,1,3,0, 153.16, 2
95077815
 
#24

Apexmol Building Blocks: AM99975
Chembo Pharma: KB-142933
ref: mol2, SDF, SMILES, flexibase
1.22,3.24,-14.32,1,5,0, 260.293, 3
95077814
 
#25

Apexmol Building Blocks: AM99975
Chembo Pharma: KB-142933
ref: mol2, SDF, SMILES, flexibase
1.22,3.23,-14.33,1,5,0, 260.293, 3
95083459
 
#26

Apexmol Building Blocks: AM99972
Chembo Pharma: KB-126263
ref: mol2, SDF, SMILES, flexibase
2.95,6.53,-4.91,0,3,0, 278.19, 2
95077056
 
#27

Apexmol Building Blocks: AM99968
Chembo Pharma: KB-142087
ref: mol2, SDF, SMILES, flexibase
3.26,6.19,-7.65,1,4,0, 316.323, 6
95077055
 
#28

Apexmol Building Blocks: AM99968
Chembo Pharma: KB-142087
ref: mol2, SDF, SMILES, flexibase
3.26,6.27,-7.95,1,4,0, 316.323, 6
95076975
 
#29

Apexmol Building Blocks: AM99960
Chembo Pharma: KB-142025
ref: mol2, SDF, SMILES, flexibase
3.26,4.94,-7.72,1,4,0, 316.323, 6
95082817
 
#30

Apexmol Building Blocks: AM99953
Chembo Pharma: KB-125568
ref: mol2, SDF, SMILES, flexibase
1.69,6.42,-9.23,0,2,0, 260.175, 1
95082816
 
#31

Apexmol Building Blocks: AM99953
Chembo Pharma: KB-125568
ref: mol2, SDF, SMILES, flexibase
1.69,6.42,-9.26,0,2,0, 260.175, 1
95082815
 
#32

Apexmol Building Blocks: AM99953
Chembo Pharma: KB-125568
ref: mol2, SDF, SMILES, flexibase
1.69,6.46,-9.78,0,2,0, 260.175, 1
95082814
 
#33

Apexmol Building Blocks: AM99953
Chembo Pharma: KB-125568
ref: mol2, SDF, SMILES, flexibase
1.69,6.47,-8.84,0,2,0, 260.175, 1
95078232
 
#34

Apexmol Building Blocks: AM99952
Chembo Pharma: KB-143369
ref: mol2, SDF, SMILES, flexibase
2.54,2.66,-5.16,1,2,0, 231.217, 4
95078237
 
#35

Apexmol Building Blocks: AM99950
Chembo Pharma: KB-143375
ref: mol2, SDF, SMILES, flexibase
1.91,0.35,-4.45,2,2,0, 191.152, 3
95076126
 
#36

Apexmol Building Blocks: AM99948
Chembo Pharma: KB-141303
ref: mol2, SDF, SMILES, flexibase
3.19,6.16,-6.65,0,3,0, 273.254, 6
95088100
 
#37

Apexmol Building Blocks: AM99944
Chembo Pharma: KB-129796
ref: mol2, SDF, SMILES, flexibase
4.14,5.79,-3.25,0,1,0, 296.13, 4
95091126
 
#38

Apexmol Building Blocks: AM99942
Chembo Pharma: KB-132441
ref: mol2, SDF, SMILES, flexibase
3.66,5.33,-2.89,0,1,0, 237.652, 4
95077039
 
#39

Apexmol Building Blocks: AM99940
Chembo Pharma: KB-142075
ref: mol2, SDF, SMILES, flexibase
3.04,3.65,-2.52,1,1,0, 209.598, 3
95077092
 
#40

Apexmol Building Blocks: AM99938
Chembo Pharma: KB-142109
ref: mol2, SDF, SMILES, flexibase
2.52,3.24,-3.07,1,1,0, 193.143, 3
95091015
 
#41

Apexmol Building Blocks: AM99936
Chembo Pharma: KB-132321
ref: mol2, SDF, SMILES, flexibase
1.45,2.97,-9.82,0,4,0, 247.36, 2
95091014
 
#42

Apexmol Building Blocks: AM99936
Chembo Pharma: KB-132321
ref: mol2, SDF, SMILES, flexibase
1.45,2.93,-9.84,0,4,0, 247.36, 2
95091013
 
#43

Apexmol Building Blocks: AM99936
Chembo Pharma: KB-132321
ref: mol2, SDF, SMILES, flexibase
1.45,2.58,-10.3,0,4,0, 247.36, 2
95091073
 
#44

Apexmol Building Blocks: AM99935
Chembo Pharma: KB-132378
ref: mol2, SDF, SMILES, flexibase
3.91,6.73,-3.64,0,1,0, 243.272, 5
95076016
 
#45

Apexmol Building Blocks: AM99934
Chembo Pharma: KB-141229
ref: mol2, SDF, SMILES, flexibase
0.80,0.2,-10.56,1,4,0, 207.295, 2
95076015
 
#46

Apexmol Building Blocks: AM99934
Chembo Pharma: KB-141229
ref: mol2, SDF, SMILES, flexibase
0.80,0.07,-10.08,1,4,0, 207.295, 2
95076014
 
#47

Apexmol Building Blocks: AM99934
Chembo Pharma: KB-141229
ref: mol2, SDF, SMILES, flexibase
0.80,0.32,-10.49,1,4,0, 207.295, 2
95091044
 
#48

Apexmol Building Blocks: AM99933
Chembo Pharma: KB-132332
ref: mol2, SDF, SMILES, flexibase
0.69,0.53,-9.76,1,4,0, 219.306, 3
95091043
 
#49

Apexmol Building Blocks: AM99933
Chembo Pharma: KB-132332
ref: mol2, SDF, SMILES, flexibase
0.69,0.5,-10.09,1,4,0, 219.306, 3
95091042
 
#50

Apexmol Building Blocks: AM99933
Chembo Pharma: KB-132332
ref: mol2, SDF, SMILES, flexibase
0.69,1,-10.09,1,4,0, 219.306, 3
95091041
 
#51

Apexmol Building Blocks: AM99933
Chembo Pharma: KB-132332
ref: mol2, SDF, SMILES, flexibase
0.69,0.97,-9.97,1,4,0, 219.306, 3
95091052
 
#52

Apexmol Building Blocks: AM99932
Chembo Pharma: KB-132355
ref: mol2, SDF, SMILES, flexibase
4.19,8.04,-3.15,0,1,0, 245.288, 5
95090002
 
#53

Apexmol Building Blocks: AM99931
Chembo Pharma: KB-131617
ref: mol2, SDF, SMILES, flexibase
3.47,6.19,-3.26,0,1,0, 229.245, 4
95088066
 
#54

Apexmol Building Blocks: AM99929
Chembo Pharma: KB-129770
ref: mol2, SDF, SMILES, flexibase
3.73,5.95,-3.29,0,1,0, 231.261, 4
95091099
 
#55

Apexmol Building Blocks: AM99927
Chembo Pharma: KB-132413
ref: mol2, SDF, SMILES, flexibase
3.98,6.83,-2.75,0,1,0, 223.625, 3
95083020
 
#56

Apexmol Building Blocks: AM99925
Chembo Pharma: KB-125824
ref: mol2, SDF, SMILES, flexibase
2.20,5.4,-7.9,0,3,0, 217.334, 4
95091271
 
#57

Apexmol Building Blocks: AM99924
Chembo Pharma: KB-132564
ref: mol2, SDF, SMILES, flexibase
0.33,2.85,-17.26,1,5,0, 243.332, 5
mid: mol2, SDF, SMILES, flexibase
0.33,3.19,-33.53,2,5,1, 244.34, 5
95091270
 
#58

Apexmol Building Blocks: AM99924
Chembo Pharma: KB-132564
ref: mol2, SDF, SMILES, flexibase
0.33,2.52,-16.77,1,5,0, 243.332, 5
mid: mol2, SDF, SMILES, flexibase
0.33,3.21,-33.66,2,5,1, 244.34, 5
95091602
 
#59

Apexmol Building Blocks: AM99923
Chembo Pharma: KB-132809
ref: mol2, SDF, SMILES, flexibase
1.46,-1.52,-12.58,1,5,0, 226.257, 3
95088538
 
#60

Apexmol Building Blocks: AM99921
Chembo Pharma: KB-130131
ref: mol2, SDF, SMILES, flexibase
0.46,0.26,-13.7,1,5,0, 215.278, 3
95091591
 
#61

Apexmol Building Blocks: AM99918
Chembo Pharma: KB-132797
SureChEMBL: SCHEMBL14011213
ref: mol2, SDF, SMILES, flexibase
1.10,0.25,-11.38,1,4,0, 200.263, 3
91352764
 
#62

Apexmol Building Blocks: AM99916
Ark Pharm Building Blocks: AK159458
Bide Pharmatech BB: BD288074
Chembo Pharma: KB-142120, KB-58065
Otava (Virtual): 10013717...8 total

ref: mol2, SDF, SMILES, flexibase
1.57,3.12,-11.98,1,3,0, 229.276, 4
95089630
 
#63

Apexmol Building Blocks: AM99913
Chembo Pharma: KB-131278
ref: mol2, SDF, SMILES, flexibase
3.23,8.64,-8.79,0,3,0, 267.756, 3
95089629
 
#64

Apexmol Building Blocks: AM99913
Chembo Pharma: KB-131278
ref: mol2, SDF, SMILES, flexibase
3.23,8.64,-8.79,0,3,0, 267.756, 3
95083462
 
#65

Apexmol Building Blocks: AM99912
Chembo Pharma: KB-126266
ref: mol2, SDF, SMILES, flexibase
3.22,6.91,-4.75,0,3,0, 325.19, 2
95078907
 
#66

Apexmol Building Blocks: AM100143, AM99905
Chembo Pharma: KB-144104, KB-144102
ref: mol2, SDF, SMILES, flexibase
0.63,-1.63,-5.5,1,3,0, 199.172, 4
95078905
 
#67

Apexmol Building Blocks: AM100189, AM99905
Chembo Pharma: KB-144104, KB-144100
ref: mol2, SDF, SMILES, flexibase
0.63,-1.71,-5.64,1,3,0, 199.172, 4
95077010
 
#68

Apexmol Building Blocks: AM99901
Chembo Pharma: KB-142048
ref: mol2, SDF, SMILES, flexibase
2.89,4.04,-2.54,0,1,0, 246.07, 2
95077009
 
#69

Apexmol Building Blocks: AM99901
Chembo Pharma: KB-142048
ref: mol2, SDF, SMILES, flexibase
2.89,4.03,-2.54,0,1,0, 246.07, 2
95082866
 
#70

Apexmol Building Blocks: AM99894
Chembo Pharma: KB-125642
ref: mol2, SDF, SMILES, flexibase
1.18,1.53,-8.81,1,3,0, 224.226, 3
95076367
 
#71

Apexmol Building Blocks: AM99892
Chembo Pharma: KB-141505
ref: mol2, SDF, SMILES, flexibase
2.47,2.51,-4.01,1,2,0, 205.179, 4
95076135
 
#72

Apexmol Building Blocks: AM99891
Chembo Pharma: KB-141312
ref: mol2, SDF, SMILES, flexibase
2.56,3.84,-7.64,1,3,0, 233.189, 5
95088135
 
#73

Apexmol Building Blocks: AM99890
Chembo Pharma: KB-129820
ref: mol2, SDF, SMILES, flexibase
4.41,6.27,-3.01,0,1,0, 343.13, 4
95076921
 
#74

Apexmol Building Blocks: AM99889
Chembo Pharma: KB-141975
ref: mol2, SDF, SMILES, flexibase
4.08,6.6,-2.76,0,1,0, 341.114, 4
95088093
 
#75

Apexmol Building Blocks: AM99888
Chembo Pharma: KB-129791
ref: mol2, SDF, SMILES, flexibase
4.39,6.26,-3.72,0,1,0, 343.13, 4
95088081
 
#76

Apexmol Building Blocks: AM99887
Chembo Pharma: KB-129781
ref: mol2, SDF, SMILES, flexibase
4.36,6.61,-2.63,0,1,0, 343.13, 4
95077040
 
#77

Apexmol Building Blocks: AM99886
Chembo Pharma: KB-142076
ref: mol2, SDF, SMILES, flexibase
3.44,4.19,-2.39,1,1,0, 301.049, 3
95091144
 
#78

Apexmol Building Blocks: AM99885
Chembo Pharma: KB-132455
ref: mol2, SDF, SMILES, flexibase
3.82,5.45,-4.02,0,1,0, 282.103, 4
95091189
 
#79

Apexmol Building Blocks: AM99884
Chembo Pharma: KB-132488
ref: mol2, SDF, SMILES, flexibase
3.71,5.38,-3.35,0,1,0, 237.652, 4
95077122
 
#80

Apexmol Building Blocks: AM99883
Chembo Pharma: KB-142134
ref: mol2, SDF, SMILES, flexibase
2.57,3.27,-3.41,1,1,0, 193.143, 3
95088075
 
#81

Apexmol Building Blocks: AM99882
Chembo Pharma: KB-129777
ref: mol2, SDF, SMILES, flexibase
3.44,4.75,-2.6,0,1,0, 235.224, 4
95076634
 
#82

Apexmol Building Blocks: AM99881
Chembo Pharma: KB-141736
ref: mol2, SDF, SMILES, flexibase
3.36,6.07,-5.62,0,1,0, 221.247, 3
95076404
 
#83

Apexmol Building Blocks: AM99880
Chembo Pharma: KB-141534
SureChEMBL: SCHEMBL6325751
ref: mol2, SDF, SMILES, flexibase
2.76,2.78,-4.14,1,2,0, 191.152, 3
95091714
 
#84

Apexmol Building Blocks: AM99879
Chembo Pharma: KB-132892
ref: mol2, SDF, SMILES, flexibase
3.87,8.06,-5.5,0,3,0, 273.254, 6
95076909
 
#85

Apexmol Building Blocks: AM99876
Chembo Pharma: KB-141963
ref: mol2, SDF, SMILES, flexibase
4.40,7.59,-2.62,0,1,0, 327.087, 3
95076171
 
#86

Apexmol Building Blocks: AM99875
Chembo Pharma: KB-141354
ref: mol2, SDF, SMILES, flexibase
0.63,3.39,-11.2,1,5,0, 238.239, 4
95076170
 
#87

Apexmol Building Blocks: AM99875
Chembo Pharma: KB-141354
ref: mol2, SDF, SMILES, flexibase
0.63,3.39,-11.2,1,5,0, 238.239, 4
95077025
 
#88

Apexmol Building Blocks: AM99874
Chembo Pharma: KB-142061
ref: mol2, SDF, SMILES, flexibase
3.79,4.59,-2.46,1,1,0, 287.022, 2
95091082
 
#89

Apexmol Building Blocks: AM99872
Chembo Pharma: KB-132396
ref: mol2, SDF, SMILES, flexibase
4.09,7.05,-3.39,0,1,0, 268.076, 3
95077128
 
#90

Apexmol Building Blocks: AM99870
Chembo Pharma: KB-142144
ref: mol2, SDF, SMILES, flexibase
2.85,3.56,-4.46,1,1,0, 179.116, 2
95088040
 
#91

Apexmol Building Blocks: AM99868
Chembo Pharma: KB-129723
ref: mol2, SDF, SMILES, flexibase
4.03,7.71,-2.35,0,1,0, 217.234, 3
95091083
 
#92

Apexmol Building Blocks: AM99866
Chembo Pharma: KB-132397
ref: mol2, SDF, SMILES, flexibase
3.73,7.15,-2.52,0,1,0, 203.207, 3
95088693
 
#93

Apexmol Building Blocks: AM99861
Chembo Pharma: KB-130221
ref: mol2, SDF, SMILES, flexibase
3.12,7.18,-7.17,0,3,0, 247.766, 3
95088692
 
#94

Apexmol Building Blocks: AM99861
Chembo Pharma: KB-130221
ref: mol2, SDF, SMILES, flexibase
3.12,7.17,-7.14,0,3,0, 247.766, 3
95079035
 
#95

Apexmol Building Blocks: AM99859
Chembo Pharma: KB-144215
ref: mol2, SDF, SMILES, flexibase
3.42,9.72,-8.19,0,3,0, 293.432, 6
95079034
 
#96

Apexmol Building Blocks: AM99859
Chembo Pharma: KB-144215
ref: mol2, SDF, SMILES, flexibase
3.42,9.69,-8.23,0,3,0, 293.432, 6
95077864
 
#97

Apexmol Building Blocks: AM99856
Chembo Pharma: KB-142988
ref: mol2, SDF, SMILES, flexibase
2.09,1.5,-14.84,1,4,0, 254.336, 3
95079556
 
#98

Apexmol Building Blocks: AM100205, AM99855
Chembo Pharma: KB-52656, KB-62350
ref: mol2, SDF, SMILES, flexibase
3.30,8.69,-8.57,0,3,0, 312.207, 5
95079563
 
#99

Apexmol Building Blocks: AM100132, AM99855
Chembo Pharma: KB-53328, KB-62350
ref: mol2, SDF, SMILES, flexibase
3.30,8.68,-8.16,0,3,0, 312.207, 5
85345261
 
#100

Apexmol Building Blocks: AM99854
Chembo Pharma: KB-141346
EDASA Scientific (Depleted): BB0263063
ref: mol2, SDF, SMILES, flexibase
0.60,6.1,-17.21,0,6,0, 257.286, 6

Old detail retrieval took 2 seconds.

start 0 size 100

select distinct(s.sub_id),s.smiles from substance s, catalog_item ci, catalog c where s.sub_id = ci.sub_id_fk and ci.cat_id_fk = c.cat_id and c.free=1 and ( c.cat_id = 656 ) limit 0,100

Smiles were