Deleting specific rows.

[thesmallfry123]

Hello there,

We are working on a research project pertaining to the Covid-19 virus. We need to curate a long list of anti-viral agents down to a manageable list. We have removed a few antiviral agents and would like to remove some more. The list (Worksheet 1) labelled below as “List I want to retain” are the rows I would like to not delete from the bigger list (Worksheet 2) containing all the anti-viral agents but I need to delete the remaining rows from the bigger list. There are around 30,000 rows so deleting the rows manually is not feasible. Is there any add-in or built-in Microsoft Excel feature that will let me delete the rows automatically.

Thank you for your time and consideration.

 

[Peter_SSs]

Welcome to the MrExcel board!

Assuming both worksheets have those 'row ID' columns in column A and there is a header row in row 1, then try this macro with a copy of your workbook.
Post back if you need help with how to implement.

If it is not what you need, please provide further explanation and if possible small sets of sample dummy data for each worksheet with XL2BB to make it easier for helpers by not having to manually type out sample data to test with.

Sub Delete_Unwanted()
  Dim d As Object
  Dim a As Variant, b As Variant
  Dim nc As Long, i As Long, k As Long
 
  With Sheets("Worksheet 1")
    a = .Range("A2", .Range("A" & .Rows.Count).End(xlUp)).Value
  End With
  Set d = CreateObject("Scripting.Dictionary")
  For i = 1 To UBound(a)
    d(a(i, 1)) = 1
  Next i
  With Sheets("Worksheet 2")
    nc = .Cells.Find(What:="*", LookIn:=xlFormulas, SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column + 1
    a = .Range("A2", .Range("A" & .Rows.Count).End(xlUp)).Value
    ReDim b(1 To UBound(a), 1 To 1)
    For i = 1 To UBound(a)
      If Not d.exists(a(i, 1)) Then
        b(i, 1) = 1
        k = k + 1
      End If
    Next i
    If k > 0 Then
      Application.ScreenUpdating = False
      With .Range("A2").Resize(UBound(a), nc)
        .Columns(nc).Value = b
        .Sort Key1:=.Columns(nc), Order1:=xlAscending, Header:=xlNo
        .Resize(k).EntireRow.Delete
      End With
      Application.ScreenUpdating = True
    End If
  End With
End Sub

 

[thesmallfry123]

Thank you for getting back to me. Upon running the VBA code, some of the rows that were meant to be deleted were deleted but I ended up retaining some of the rows that I did not need. I should have mentioned earlier that, The list I would like to retain (worksheet 1) contains about 23,000 different anti-viral agents. The rest of the anti-viral agents have to be deleted from the bigger list containing roughly 30,000 anti-viral agents(Worksheet 2). List 2 contains the anti-viral agents from list 1 but it contains 7,000 additional anti-viral agents that I wont be needing. Hope the question is clear. Below is the sample data from each other. I have additionally added a google drive link for both worksheets so you can look into the worksheets and get a better understanding.
Google Drive Download Link

Thank you once again.

Sample data from worksheet 1

Result_Interactive_table_duplicate_Analysis.csv
	A
1	row ID
2	Row60
3	Row61
4	Row62
5	Row63
6	Row66
7	Row107
8	Row116
9	Row120
10	Row122
11	Row123
12	Row124
13	Row125
14	Row126
15	Row127
16	Row128
17	Row129
18	Row130
19	Row131
20	Row132
21	Row133
22	Row134
23	Row135
24	Row136
25	Row137
26	Row138
27	Row139
28	Row140
29	Row141
30	Row142
31	Row143
32	Row144
33	Row145
34	Row146
35	Row147
36	Row148
37	Row149
38	Row150
39	Row151
40	Row152
41	Row153
42	Row154
43	Row155
44	Row159
45	Row160
46	Row162
47	Row163
48	Row164
49	Row165
50	Row166
51	Row167
52	Row168
53	Row169
54	Row170
55	Row177
56	Row178
57	Row179
58	Row180
59	Row182
60	Row183
61	Row184
62	Row185
63	Row186
64	Row188
65	Row189
66	Row190
67	Row191
68	Row192
69	Row193
70	Row194
71	Row196
72	Row197
73	Row198
74	Row199
75	Row205
76	Row207
77	Row208
78	Row209
79	Row210
80	Row211
81	Row212
82	Row216
83	Row217
84	Row262
85	Row336
86	Row340
87	Row350
88	Row373
89	Row376
90	Row383
91	Row384
92	Row391
93	Row392
94	Row394
95	Row395
96	Row396
97	Row397
98	Row399
99	Row404
100	Row405
Worksheet 1

Sample data from worksheet 2

Result_Interactive_table_duplicate_Analysis.csv
	A	B	C
1	row ID	Molecule	Distance Similarity
2	Row0	O=c1c2c(n(c(n2)[H])[C@]3(C([C@@](C(O[H])([H])[H])([C@@](O[H])(C3([H])[H])[H])[H])([H])[H])[H])n(c(N([H])[H])n1)[H]	1
3	Row1	O=c1n([C@]2(O[C@](C(OP(OP(OP(OP(=O)(O[H])O[H])(=O)O[H])(=O)O[H])(=O)O[H])([H])[H])([C@@](O[H])(C2([H])[H])[H])[H])[H])c(c(C([H])([H])[H])c(=O)n1[H])[H]
4	Row2	O=[14c]1n(c(c(c(=O)n1[H])[2H])[H])[C@]2(O[C@](C(OP(=O)(O[H])O[H])([H])[H])([C@](O[H])(C2([H])[H])[H])[H])[H]
5	Row3	C(c1c2c(N(c3c(C(=O)N2[H])c(c(c(n3)[H])[H])[H])C4(C(C4([H])[H])([H])[H])[H])nc(c1[H])[H])([H])([H])[H]
6	Row4	C(c1c2c(N(c3c(C(=O)N2[H])c(c(c(n3)[H])[H])[H])C4(C(C4([H])[H])([H])[H])[H])nc(c1[H])[H])([H])([H])[H]
7	Row5	[C@@](C(=O)N1C(C(C(=N1)[H])([H])[H])([H])[H])(N([H])[H])(C23C(C4(O[H])C(C(C2([H])[H])(C(C(C3([H])[H])(C4([H])[H])[H])([H])[H])[H])([H])[H])([H])[H])[H]
8	Row6	[C@@](C(=O)N1C(C([H])([H])[H])(C(C(C1([H])[H])([H])[H])([H])[H])[H])(N([H])[H])(C23C(C4(O[H])C(C(C2([H])[H])(C(C(C3([H])[H])(C4([H])[H])[H])([H])[H])[H])([H])[H])([H])[H])[H]
9	Row7	[C@@](C(=O)n1c(c2c(c1[H])c(c(c(c2[H])[H])[H])[H])[H])(N([H])[H])(C34C(C5(O[H])C(C(C3([H])[H])(C(C(C4([H])[H])(C5([H])[H])[H])([H])[H])[H])([H])[H])([H])[H])[H]
10	Row8	[C@@](C(=O)N1c2c(C(C1([H])[H])([H])[H])c(c(c(c2[H])[H])[H])[H])(N([H])[H])(C34C(C5(O[H])C(C(C3([H])[H])(C(C(C4([H])[H])(C5([H])[H])[H])([H])[H])[H])([H])[H])([H])[H])[H]
11	Row9	[C@@](C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])(C(N([C@@](C(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])(/C(=C(/S(=O)(=O)c3c(c(c(c(c3[H])[H])[H])[H])[H])\[H])/[H])[H])[H])=O)(N(C(=O)N4C(C(OC(C4([H])[H])([H])[H])([H])[H])([H])[H])[H])[H]
12	Row10	O=c1c2c(n(c(n2)[H])[C@]3(O[C@@](C(OP(OP([C@@](P(=O)(O[H])O[H])(F)[H])(=O)O[H])(=O)O[H])([H])[H])([C@@](O[H])(C3([H])[H])[H])[H])[H])n(c(N([H])[H])n1)[H]	0.349661
13	Row11	O=c1c2c(n(c(n2)[H])[C@]3(O[C@@](C(OP(OP([C@@](P(=O)(O[H])O[H])(F)[H])(=O)O[H])(=O)O[H])([H])[H])([C@@](O[H])(C3([H])[H])[H])[H])[H])n(c(N([H])[H])n1)[H]	0.349661
14	Row12	C(C(OC(P(=O)(O[H])O[H])([H])[H])([H])[H])(n1c2c(n(c1=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n2)([H])[H]	0.6661
15	Row13	C(C(OC(P(OC(C([H])([H])[H])(C([H])([H])[H])[H])(=O)O[H])([H])[H])([H])[H])(n1c2c(n(c1=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n2)([H])[H]	0.390559
16	Row14	C([C@@](C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])(OC(P(=O)(O[H])O[H])([H])[H])[H])(n2c3c(n(c2=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n3)([H])[H]	0.608113
17	Row15	C([C@@](OC(P(=O)(O[H])O[H])([H])[H])(C([H])([H])[H])[H])(n1c2c(n(c1=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n2)([H])[H]	0.56531
18	Row16	C([C@@](C(Oc1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])(OC(P(=O)(O[H])O[H])([H])[H])[H])(n2c3c(n(c2=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n3)([H])[H]	0.547975
19	Row17	C([C@@](C(Oc1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])(OC(P(=O)(O[H])O[H])([H])[H])[H])(n2c3c(n(c2=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n3)([H])[H]	0.547975
20	Row18	C([C@@](C(Oc1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])(OC(P(=O)(O[H])O[H])([H])[H])[H])(n2c3c(n(c2=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n3)([H])[H]	0.547975
21	Row19	O=c1n(c2c(n1[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n2)[C@]3([C@@](OC(P(=O)(O[H])O[H])([H])[H])(C(C(C3([H])[H])([H])[H])([H])[H])[H])[H]	0.570041
22	Row20	[C@@](C(OC(P(=O)(O[H])O[H])([H])[H])([H])[H])(n1c2c(n(c1=O)[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n2)(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H]	0.571308
23	Row21	O=c1n(c2c(n1[H])c(N([H])[H])nc(OC(C(OC([H])([H])[H])([H])[H])([H])[H])n2)[C@]3([C@@](OC(P(=O)(O[H])O[H])([H])[H])(C(C(C3([H])[H])([H])[H])([H])[H])[H])[H]	0.452624
24	Row22	C(/C(=C(\c1c(c(C([H])([H])[H])c(O[H])c(C([H])([H])[H])c1[H])[H])/[H])/[H])(=O)c2c(OC([H])([H])[H])c(c(OC([H])([H])[H])c(c2[H])[H])[H]	0.400634
25	Row23	N(C(C(OC(C(N1C(=O)C2(N(C1=O)[H])C(C(C(C2([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([H])[H])=O)(C34C(C5(C(C(C3([H])[H])(C(C(C4([H])[H])(C5([H])[H])[H])([H])[H])[H])([H])[H])[H])([H])[H])[H]
26	Row24	C(C(C1(C(OP(=O)(O[H])OC1([H])[H])([H])[H])[H])([H])[H])(n2c3c(nc2[H])c(=O)nc(N([H])[H])n3[H])([H])[H]	0.791924
27	Row25	C([C@@](OC(P(=O)(O[H])O[H])([H])[H])(C([H])([H])[H])[H])(n1c2c(nc1[H])c(N([H])[H])nc(n2)[H])([H])[H]	0.481073
28	Row26	O([C@@]1([C@](n2c3c(nc2[H])c(=O)nc(n3[H])[H])(O[C@](C(O[H])([H])[H])([C@]1(OP(OC([C@@]4(O[C@]([C@](O[H])([C@]4(O[H])[H])[H])(n5c(=O)n(c(=O)c(c5[H])[H])[H])[H])[H])([H])[H])(=O)O[H])[H])[H])[H])[H])[H]
29	Row27	N(c1nc(nc(n1)N2C(C(OC(C2([H])[H])([H])[H])([H])[H])([H])[H])N3C(C(OC(C3([H])[H])([H])[H])([H])[H])([H])[H])(c4c(c(c(C(OC([H])([H])[H])=O)c(c4[H])[H])[H])[H])[H]
30	Row28	O([C@]1([C@@](O[C@@](C(OC(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.577978
31	Row29	O([C@]1([C@@](O[C@@](C(OC(OC(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.476795
32	Row30	1(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]1(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[C@]2([C@@](O[C@@](C(O[H])([H])[H])([C@@]2(OC(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H]]O(C(C(C(O[C@]1(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]1(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[C@]2([C@@](O[C@@](C(O[H])([H])[H])([C@@]2(OC(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H]	0.207244
33	Row31	O([C@]1([C@@](O[C@@](C(OC(C(C(O[C@]2([C@@](N(C(C([H])([H])[H])=O)[H])([C@@](O[H])([C@@](O[H])([C@@](C(O[H])([H])[H])(O2)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.390967
34	Row32	O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.566573
35	Row33	1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])(C(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])(C(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.127808
36	Row34	1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C(N(C(C(OC([C@]3(O[C@@]([C@@](O[H])([C@@]3(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])([H])[H])([H])[H])=O)[H])([H])[H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n5nc(C(N([H])[H])=O)nc5[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C(N(C(C(OC([C@]3(O[C@@]([C@@](O[H])([C@@]3(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])([H])[H])([H])[H])=O)[H])([H])[H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n5nc(C(N([H])[H])=O)nc5[H])[H])[H])[H]	0.085207
37	Row35	1([C@@](O[C@@](C(OC(C(N(C(C(N(C([C@@](N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C(C(C(C(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C([C@@](N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C(C(C(C(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.065275
38	Row36	1([C@@](O[C@@](C(OC(C(N(C(C(N(C([C@@](N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)[H])([H])[H])(C(N(C([C@@](N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)[H])([H])[H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C([C@@](N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)[H])([H])[H])(C(N(C([C@@](N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)[H])([H])[H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.131358
39	Row37	1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])C(C(C(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])C(C(C(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.079634
40	Row38	O([C@]1([C@@](O[C@@](C(OC(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.600921
41	Row39	1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.587057
42	Row40	O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(C(N([C@@]([C@@]([C@@]([C@@](C(O[H])([H])[H])(O[H])[H])(O[H])[H])(O[H])[H])(C(=O)[H])[H])[H])=O)([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n2nc(C(N([H])[H])=O)nc2[H])[H])[H])[H]	0.69181
43	Row41	O([C@]1([C@@](O[C@@](C(OC([C@@](N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.472377
44	Row42	O([C@]1([C@@](O[C@@](C(OC(C(C(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.439349
45	Row43	O([C@]1([C@@](O[C@@](C(OC(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.445671
46	Row44	O(C(c1c(c(c(N(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])c(c1[H])[H])[H])[H])([H])[H])[C@]3([C@@](O[C@@](C(O[H])([H])[H])([C@@]3(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H]	0.451742
47	Row45	O([C@]1([C@@](O[C@@](C(O[H])([H])[H])([C@@]1(OC(c2c(c(c(N(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])c(c2[H])[H])[H])[H])([H])[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.533206
48	Row46	O([C@]1([C@@](O[C@@](C(OC(C(C(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.355638
49	Row47	O([C@]1([C@@](O[C@@](C(OC(C(C(C(C(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.240689
50	Row48	1([C@@](O[C@@](C(OC(C(C(N(C([C@@](N(C(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])(C(C(C(C(N(C(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])=O)[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]]O([C@]1([C@@](O[C@@](C(OC(C(C(N(C([C@@](N(C(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])(C(C(C(C(N(C(C(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])=O)[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.076575
51	Row49	O([C@]1([C@@](O[C@@](C(OC([C@@](C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])(C([H])([H])[H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.636736
52	Row50	O([C@]1([C@@](O[C@@](C(OC(C(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])(C([H])([H])[H])C([H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.433706
53	Row51	O([C@]1([C@@](O[C@@](C(OC(=O)c2c(c(c(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])c(c2[H])[H])[H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.447298
54	Row52	O([C@]1([C@@](O[C@@](C(OC(=O)c2c(c(c(C(O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])([H])[H])c(c2[H])[H])[H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.652454
55	Row53	O([C@]1([C@@](O[C@@](C(OC(C(N(C(C(C(C(N([C@@]([C@@]([C@@]([C@@](C(O[H])([H])[H])(O[H])[H])(O[H])[H])(O[H])[H])(C(=O)[H])[H])[H])=O)([H])[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n2nc(C(N([H])[H])=O)nc2[H])[H])[H])[H]	0.491339
56	Row54	O([C@]1([C@@](O[C@@](C(OC(C(C(C(N([C@@]([C@@]([C@@]([C@@](C(O[H])([H])[H])(O[H])[H])(O[H])[H])(O[H])[H])(C(=O)[H])[H])[H])=O)([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n2nc(C(N([H])[H])=O)nc2[H])[H])[H])[H]	0.431369
57	Row55	O([C@]1([C@@](O[C@@](C(OC(C(OC(C(O[C@]2(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]2(O[H])[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.375816
58	Row56	)([H])[H])=O)[C@]1([C@@](OC(C([H])([H])[H])=O)([C@@](C(OC(C([H])([H])[H])=O)([H])[H])(O[C@@](OC(C(C(OC([C@]2(O[C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([C@@]1(OC(C([H])([H])[H])=O)[H])[H])[H])[H])[H]]O(C(C([H])([H])[H])=O)[C@]1([C@@](OC(C([H])([H])[H])=O)([C@@](C(OC(C([H])([H])[H])=O)([H])[H])(O[C@@](OC(C(C(OC([C@]2(O[C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([C@@]1(OC(C([H])([H])[H])=O)[H])[H])[H])[H])[H]	0.465161
59	Row57	O([C@]1([C@@](O[C@@](C(OC(C(C(OC2(C(C(C(C(C2([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])([H])[H])([H])[H])=O)([H])[H])([C@@]1(O[H])[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H])[H]	0.435715
60	Row58	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(C(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.126364
61	Row59	)[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](OC(C(C(OC([C@]5(O[C@@]([C@@](O[H])([C@@]5(O[H])[H])[H])(n6nc(C(N([H])[H])=O)nc6[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])(O[C@@]2(C(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])([H])[H])[H])[H])[H])[H])[H]]O(C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](OC(C(C(OC([C@]5(O[C@@]([C@@](O[H])([C@@]5(O[H])[H])[H])(n6nc(C(N([H])[H])=O)nc6[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])(O[C@@]2(C(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])([H])[H])[H])[H])[H])[H])[H]	0.367966
62	Row60	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(OC(C(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.293592
63	Row61	)[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O[C@@](OC(C(C(OC(OC([C@]5(O[C@@]([C@@](O[H])([C@@]5(O[H])[H])[H])(n6nc(C(N([H])[H])=O)nc6[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]]O(C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O[C@@](OC(C(C(OC(OC([C@]5(O[C@@]([C@@](O[H])([C@@]5(O[H])[H])[H])(n6nc(C(N([H])[H])=O)nc6[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]	0.248332
64	Row62	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[C@]6([C@@](O[C@@](C(O[H])([H])[H])([C@@]6(OC(C(C(O[C@]7([C@@](OC(c8c(c(c(c(c8[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c9c(c(c(c(c9[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c%10c(c(c(c(c%10[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c%11c(c(c(c(c%11[H])[H])[H])[H])[H])([H])[H])([H])[H])(O7)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])[H])(n%12nc(C(N([H])[H])=O)nc%12[H])[H])[H]]O(C(C(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[C@]6([C@@](O[C@@](C(O[H])([H])[H])([C@@]6(OC(C(C(O[C@]7([C@@](OC(c8c(c(c(c(c8[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c9c(c(c(c(c9[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c%10c(c(c(c(c%10[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c%11c(c(c(c(c%11[H])[H])[H])[H])[H])([H])[H])([H])[H])(O7)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)[H])[H])(n%12nc(C(N([H])[H])=O)nc%12[H])[H])[H]	0.118621
65	Row63	1([C@@](N(C(C([H])([H])[H])=O)[H])([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]]C(OC(C(C(O[C@]1([C@@](N(C(C([H])([H])[H])=O)[H])([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]	0.122118
66	Row64	C(OC(N(C(C(N(C(OC(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([C@]2([C@]3([C@@]([C@@](O2)(n4nc(C(N([H])[H])=O)nc4[H])[H])(O[C@@](OC([H])([H])[H])(O3)[H])[H])[H])[H])([H])[H]	0.362791
67	Row65	C(OC(N(C(C(N([H])[H])([H])[H])([H])[H])[H])=O)([C@]1([C@]2([C@@]([C@@](O1)(n3nc(C(N([H])[H])=O)nc3[H])[H])(O[C@@](OC([H])([H])[H])(O2)[H])[H])[H])[H])([H])[H]	0.706125
68	Row66	1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]]C(OC(N(C(C(N(C(C(O[C@]1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]	0.290624
69	Row67	C(OC([C@@](N(C(OC(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)([C@]2([C@]3([C@@]([C@@](O2)(n4nc(C(N([H])[H])=O)nc4[H])[H])(O[C@@](OC([H])([H])[H])(O3)[H])[H])[H])[H])([H])[H]	0.332384
70	Row68	C(OC([C@@](C([H])([H])[H])(N([H])[H])[H])=O)([C@]1([C@]2([C@@]([C@@](O1)(n3nc(C(N([H])[H])=O)nc3[H])[H])(O[C@@](OC([H])([H])[H])(O2)[H])[H])[H])[H])([H])[H]	0.33473
71	Row69	(N(C(C(O[C@]1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]]C(OC([C@@](N(C(C(O[C@]1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])(C([H])([H])[H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]	0.462826
72	Row70	C(OC(C(C(N(C(OC(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])=O)([C@]2([C@]3([C@@]([C@@](O2)(n4nc(C(N([H])[H])=O)nc4[H])[H])(O[C@@](OC([H])([H])[H])(O3)[H])[H])[H])[H])([H])[H]	0.292677
73	Row71	C(OC(C(C(N([H])[H])([H])[H])([H])[H])=O)([C@]1([C@]2([C@@]([C@@](O1)(n3nc(C(N([H])[H])=O)nc3[H])[H])(O[C@@](OC([H])([H])[H])(O2)[H])[H])[H])[H])([H])[H]	0.479218
74	Row72	1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]]C(OC(C(C(N(C(C(O[C@]1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])=O)[H])([H])[H])([H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]	0.549091
75	Row73	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(C(C(C(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.103692
76	Row74	)[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O[C@@](OC(C(C(C(C(OC([C@]5(O[C@@]([C@@](O[H])([C@@]5(O[H])[H])[H])(n6nc(C(N([H])[H])=O)nc6[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]]O(C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O[C@@](OC(C(C(C(C(OC([C@]5(O[C@@]([C@@](O[H])([C@@]5(O[H])[H])[H])(n6nc(C(N([H])[H])=O)nc6[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]	0.247114
77	Row75	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(C(C(C(C(C(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.167769
78	Row76	C(OC(C(C(N(C(OC(C([H])([H])[H])(C([H])([H])[H])C([H])([H])[H])=O)[H])([H])[H])([H])[H])=O)([C@]1([C@]2([C@@]([C@@](O1)(n3nc(C(N([H])[H])=O)nc3[H])[H])(O[C@@](OC([H])([H])[H])(O2)[H])[H])[H])[H])([H])[H]	0.497421
79	Row77	(C(O[C@]1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])(C([H])([H])[H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]]C(OC([C@@](C(O[C@]1(O[C@]2([C@@]([C@@](O[H])([C@@]1(O[H])[H])[H])(O[C@@](OC2([H])[H])(c3c(c(c(c(c3[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])(C([H])([H])[H])[H])=O)([C@]4([C@]5([C@@]([C@@](O4)(n6nc(C(N([H])[H])=O)nc6[H])[H])(O[C@@](OC([H])([H])[H])(O5)[H])[H])[H])[H])([H])[H]	0.261736
80	Row78	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])(C([H])([H])[H])C([H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(C(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])(C([H])([H])[H])C([H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.159265
81	Row79	)[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(C(C(OC([C@]4(O[C@@]([C@@](O[H])([C@@]4(O[H])[H])[H])(n5nc(C(N([H])[H])=O)nc5[H])[H])[H])([H])[H])=O)(C([H])([H])[H])C([H])([H])[H])([H])[H])(O[C@@](C(OC(c6c(c(c(c(c6[H])[H])[H])[H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]]O(C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])[C@]2([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(C(C(OC([C@]4(O[C@@]([C@@](O[H])([C@@]4(O[H])[H])[H])(n5nc(C(N([H])[H])=O)nc5[H])[H])[H])([H])[H])=O)(C([H])([H])[H])C([H])([H])[H])([H])[H])(O[C@@](C(OC(c6c(c(c(c(c6[H])[H])[H])[H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]	0.184427
82	Row80	2(O[C@]3([C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(O[C@@](OC3([H])[H])(c4c(c(c(c(c4[H])[H])[H])[H])[H])[H])[H])[H])[H])c(c1[H])[H])[H])[H])([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]]C(OC(=O)c1c(c(c(O[C@]2(O[C@]3([C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(O[C@@](OC3([H])[H])(c4c(c(c(c(c4[H])[H])[H])[H])[H])[H])[H])[H])[H])c(c1[H])[H])[H])[H])([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]	0.268139
83	Row81	2(O[C@]3([C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(O[C@@](OC3([H])[H])(c4c(c(c(c(c4[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])c(c1[H])[H])[H])[H])([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]]C(OC(=O)c1c(c(c(C(O[C@]2(O[C@]3([C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(O[C@@](OC3([H])[H])(c4c(c(c(c(c4[H])[H])[H])[H])[H])[H])[H])[H])[H])([H])[H])c(c1[H])[H])[H])[H])([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]	0.653192
84	Row82	O(C(C([H])([H])[H])=O)[C@]1([C@@](O[C@@](C(OC(C(O[H])=O)([H])[H])([H])[H])([C@@]1(OC(C([H])([H])[H])=O)[H])[H])(n2nc(C(N([H])[H])=O)nc2[H])[H])[H]	0.490196
85	Row83	)([H])[H])=O)[C@]1([C@@](O[C@@](C(OC(C(N(C(C(C(C(N([C@]2([C@@](OC(C([H])([H])[H])=O)([C@@](OC(C([H])([H])[H])=O)([C@@](C(OC(C([H])([H])[H])=O)([H])[H])(O[C@@]2(OC(C([H])([H])[H])=O)[H])[H])[H])[H])[H])[H])=O)([H])[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(OC(C([H])([H])[H])=O)[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H]]O(C(C([H])([H])[H])=O)[C@]1([C@@](O[C@@](C(OC(C(N(C(C(C(C(N([C@]2([C@@](OC(C([H])([H])[H])=O)([C@@](OC(C([H])([H])[H])=O)([C@@](C(OC(C([H])([H])[H])=O)([H])[H])(O[C@@]2(OC(C([H])([H])[H])=O)[H])[H])[H])[H])[H])[H])=O)([H])[H])([H])[H])([H])[H])[H])=O)([H])[H])([H])[H])([C@@]1(OC(C([H])([H])[H])=O)[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H]	0.300966
86	Row84	O(C(C([H])([H])[H])=O)[C@]1([C@@](O[C@@](C(OC(C(OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])([C@@]1(OC(C([H])([H])[H])=O)[H])[H])(n3nc(C(N([H])[H])=O)nc3[H])[H])[H]	0.700161
87	Row85	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O[C@@]1(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H])[H])=O)([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(C(C(C(N([C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([H])[H])(O[C@@]1(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H])[H])=O)([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.108943
88	Row86	)[H])[H])[H])[H])([H])[H])[C@]2([C@@](N(C(C(C(C(OC([C@]3(O[C@@]([C@@](O[H])([C@@]3(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])=O)[H])([C@@](OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])(O[C@@](C(OC(c6c(c(c(c(c6[H])[H])[H])[H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]]O(C(c1c(c(c(c(c1[H])[H])[H])[H])[H])([H])[H])[C@]2([C@@](N(C(C(C(C(OC([C@]3(O[C@@]([C@@](O[H])([C@@]3(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])([H])[H])=O)([H])[H])([H])[H])=O)[H])([C@@](OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])(O[C@@](C(OC(c6c(c(c(c(c6[H])[H])[H])[H])[H])([H])[H])([H])[H])([C@@]2(OC(c7c(c(c(c(c7[H])[H])[H])[H])[H])([H])[H])[H])[H])[H])[H])[H]	0.459623
89	Row87	1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]]C(OC(C(OC(C(O[C@]1([C@@](OC(c2c(c(c(c(c2[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c3c(c(c(c(c3[H])[H])[H])[H])[H])([H])[H])([C@@](OC(c4c(c(c(c(c4[H])[H])[H])[H])[H])([H])[H])([C@@](C(OC(c5c(c(c(c(c5[H])[H])[H])[H])[H])([H])[H])([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])([H])[H])=O)([C@]6([C@]7([C@@]([C@@](O6)(n8nc(C(N([H])[H])=O)nc8[H])[H])(O[C@@](OC([H])([H])[H])(O7)[H])[H])[H])[H])([H])[H]	0.168894
90	Row88	1([C@@](OC(C([H])([H])[H])=O)([C@@](OC(C([H])([H])[H])=O)([C@@](OC(C([H])([H])[H])=O)([C@@](C(OC(C([H])([H])[H])=O)([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([C@]2([C@]3([C@@]([C@@](O2)(n4nc(C(N([H])[H])=O)nc4[H])[H])(O[C@@](OC([H])([H])[H])(O3)[H])[H])[H])[H])([H])[H]]C(OC(C(C(O[C@]1([C@@](OC(C([H])([H])[H])=O)([C@@](OC(C([H])([H])[H])=O)([C@@](OC(C([H])([H])[H])=O)([C@@](C(OC(C([H])([H])[H])=O)([H])[H])(O1)[H])[H])[H])[H])[H])([H])[H])([H])[H])=O)([C@]2([C@]3([C@@]([C@@](O2)(n4nc(C(N([H])[H])=O)nc4[H])[H])(O[C@@](OC([H])([H])[H])(O3)[H])[H])[H])[H])([H])[H]	0.325056
91	Row89	C(OC(C(C(OC1(C(C(C(C(C1([H])[H])([H])[H])([H])[H])([H])[H])([H])[H])[H])([H])[H])([H])[H])=O)([C@]2([C@]3([C@@]([C@@](O2)(n4nc(C(N([H])[H])=O)nc4[H])[H])(O[C@@](OC([H])([H])[H])(O3)[H])[H])[H])[H])([H])[H]	0.331053
92	Row90	C(C(OC(P(=O)(O[H])O[H])([H])[H])([H])[H])(n1c2c(c(N(C(C(P(=O)(O[H])O[H])([H])[H])([H])[H])[H])nc(N([H])[H])n2)nc1[H])([H])[H]	0.586246
93	Row91	O([C@]1([C@@](O[C@@](C(OC(=O)[C@]2(C(C([C@@](O[C@]3(O[C@@](C(O[H])([H])[H])([C@@](O[H])([C@@](O[H])([C@@]3(O[H])[H])[H])[H])[H])[H])(C(C2([H])[H])([H])[H])[H])([H])[H])([H])[H])[H])([H])[H])([C@@]1(O[H])[H])[H])(n4nc(C(N([H])[H])=O)nc4[H])[H])[H])[H]	0.471876
94	Row92	1(C(C([C@@](O[C@]2(O[C@]3([C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(O[C@@](OC3([H])[H])(c4c(c(c(c(c4[H])[H])[H])[H])[H])[H])[H])[H])[H])(C(C1([H])[H])([H])[H])[H])([H])[H])([H])[H])[H])([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]]C(OC(=O)[C@]1(C(C([C@@](O[C@]2(O[C@]3([C@@]([C@@](O[H])([C@@]2(O[H])[H])[H])(O[C@@](OC3([H])[H])(c4c(c(c(c(c4[H])[H])[H])[H])[H])[H])[H])[H])[H])(C(C1([H])[H])([H])[H])[H])([H])[H])([H])[H])[H])([C@]5([C@]6([C@@]([C@@](O5)(n7nc(C(N([H])[H])=O)nc7[H])[H])(O[C@@](OC([H])([H])[H])(O6)[H])[H])[H])[H])([H])[H]	0.680323
95	Row93	N(C(C(OC(C(n1c2c(oc1=O)c(c(c(c2[H])[H])[H])[H])([H])[H])=O)([H])[H])=O)(C34C(C5(C(C(C3([H])[H])(C(C(C4([H])[H])(C5([H])[H])[H])([H])[H])[H])([H])[H])[H])([H])[H])[H]
96	Row94	N(C(c1nc2c(s1)c(c(c(c2[H])[H])[H])[H])([H])[H])(C34C(C5(C(C(C3([H])[H])(C(C(C4([H])[H])(C5([H])[H])[H])([H])[H])[H])([H])[H])[H])([H])[H])[H]
97	Row95	O=C1C2(C(c3c(C(C2(C(O1)([H])[H])[H])([H])[H])c(c4c(c3[H])OC(O4)([H])[H])[H])(c5c(c(OC([H])([H])[H])c(OC([H])([H])[H])c(OC([H])([H])[H])c5[H])[H])[H])[H]
98	Row96	O([C@]1([C@@](n2c3c(nc2[H])c([13N]([H])[H])nc(n3)[H])(O[C@@](C(O[H])([H])[H])([C@@]1(O[H])[H])[H])[H])[H])[H]	0.344194
99	Row97	O=c1n(c(c(/C(=C(\Br)/[H])/[H])c(=O)n1[H])[H])[C@]2(C([C@](OC([H])([H])[H])([C@@](C(O[H])([H])[H])(O2)[H])[H])([H])[H])[H]
100	Row98	O=c1c2c(n(c(n2)[H])[C@]3(C(=C([H])[H])[C@@](C(O[H])([H])[H])([C@@](OC([C@@](C(C([H])([H])[H])(C([H])([H])[H])[H])(N([H])[H])[H])=O)(C3([H])[H])[H])[H])[H])n(c(N([H])[H])n1)[H]	0.782411
Worksheet 2

 

[sandy666]

try Power Query

let
    Source1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Join = Table.NestedJoin(Source1,{"row ID"},Source2,{"row ID"},"Source2",JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Join, "Source2", {"Molecule", "Distance Similarity"}, {"Molecule", "Distance Similarity"})
in
    Expand

s666-PQ-Worksheets.xlsx

Microsoft Excel Workbook

1drv.ms

 

[Peter_SSs]

Upon running the VBA code, some of the rows that were meant to be deleted were deleted but I ended up retaining some of the rows that I did not need.

I'm not following. I Downloaded the file from your link.
Worksheet 2 contained 30,462 rows
I ran the code I posted and then worksheet 2 contained 13,589 rows (heading row and 13,588 IDs). Every one of the 13,588 IDs remaining appear in worksheet 1.
As best I could understand it, that is what you wanted. If you ran the code and thought the code failed to delete some ID from worksheet 2 that do not appear in worksheet 1, can you provide details of 1 or 2 of them?

If I am misunderstanding the requirement, please make up a small dummy workbook with just say 10 items in worksheet 1, 15 items in worksheet 2 and add a worksheet 3 that contains the desired result & provide that workbook.

 

[sandy666]

Correction, so ignore post#4

let
    Source1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Join = Table.NestedJoin(Source1,{"row ID"},Source2,{"row ID"},"Source2",JoinKind.Inner),
    Expand = Table.ExpandTableColumn(Join, "Source2", {"Molecule", "Distance Similarity"}, {"Molecule", "Distance Similarity"})
in
    Expand

s666-PQ-Worksheets.xlsx

Microsoft Excel Workbook

1drv.ms

 

[thesmallfry123]

i cannot find the power query addin under the options menu in microsoft excel 2019. am i supposed to install it?

 

[sandy666]

XL2019 has Power Query build-in
On Data tab you've some tools for PQ
eg. Show Queries/Connections, New Query and so on...

maybe it is called: Get&Transform

 

[sandy666]

• download my file from post #6
• open this file
• click Show Queries / Connections on Data tab
• on the right side you should see pane where you can click Queries
• then double click on the Table there and it will open new window Power Query Editor

 

[Peter_SSs]

@thesmallfry123
Any response to my question in post #5?

If you ran the code and thought the code failed to delete some ID from worksheet 2 that do not appear in worksheet 1, can you provide details of 1 or 2 of them?