-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathtpsa.sql.in
75 lines (69 loc) · 3.06 KB
/
tpsa.sql.in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Drop Table If Exists _OCSCHEMA_.tpsa;
CREATE TABLE _OCSCHEMA_.tpsa (
atom_psa numeric,
smarts Text,
description Text
);
Grant Select On _OCSCHEMA_.tpsa To Public;
COPY _OCSCHEMA_.tpsa (atom_psa, smarts, description) FROM stdin;
23.79 [N0;H0;D1;v3] N#
23.85 [N+0;H1;D1;v3] [NH]=
26.02 [N+0;H2;D1;v3] [NH2]-
25.59 [N+1;H2;D1;v4] [NH2+]=
27.64 [N+1;H3;D1;v4] [NH3+]-
12.36 [N+0;H0;D2;v3] =N-
13.6 [N+0;H0;D2;v5] =N#
12.03 [N+0;H1;D2;v3;!r3] -[NH]- not in 3-ring
21.94 [N+0;H1;D2;v3;r3] -[NH]- in 3-ring
4.36 [N+1;H0;D2;v4] -[N+]#
13.97 [N+1;H1;D2;v4] -[NH+]=
16.61 [N+1;H2;D2;v4] -[NH2+]-
12.89 [n+0;H0;D2;v3] :[n]:
15.79 [n+0;H1;D2;v3] :[nH]:
3.24 [N+0;H0;D3;v3;!r3] -N(-)-
3.01 [N+0;H0;D3;v3;r3] -N(-)- in 3-ring
11.68 [N+0;H0;D3;v5] -N(=)=
3.01 [N+1;H0;D3;v4] =[N+](-)-
4.44 [N+1;H1;D3;v4] -[NH+](-)-
0 [N+1;H0;D4;v4] -[N+](-)(-)-
17.07 [O+0;H0;D1;v2] O=
23.06 [O-1;H0;D1;v1] [O-]-
9.23 [O+0;H0;D2;!r3;v2] -O- not in 3-ring
12.53 [O+0;H0;D2;r3;v2] -O- in 3-ring
13.14 [o+0;H0;D2;v2] :o:
14.14 [n+1;H1;D2;v4] :[nH+]:
20.23 [O+0;H1;D1] [OH]-
4.93 [n+0;H0;D3;$(n-*)] -[n](:):
4.41 [n+0;H0;D3;$(n(:*)(:*):*)] :[n](:):
4.10 [n+1;H0;D3;v4;$(n(:*)(:*):*)] :[n+](:):
3.88 [n+1;H0;D3;v4;$(n-*)] -[n+](:):
8.39 [n+0;H0;D3;v5;$(n=*)] =[n](:):
11.3 [#8+1;H0;D2] 28.5 - 2*8.6\r\nnon-standard valency
12.8 [#8+1;H1;D2] 28.5 - 2*8.6 + 1.5\r\nnon-standard valency
11.3 [#8;H0;D2;v4] 28.5 - 2*8.6\r\nnon-standard valency
2.7 [#8;H0;D3;v4] 28.5 - 3 *8.6\r\nnon-standard valency
2.7 [#8+1;H0;D3;v3] 28.5 - 3*8.6\r\nnon-standard valency
7.4 [NH+0;v5;D3] =N(-)-\r\n30.5 - 8.2*3 + 1.5\r\nnon-standard valency
14.10 [#7;v2;D2] 30.5 - 2*8.2\r\n-[N]-\r\nnon-standard valency
15.6 [NH+0;v5;D2] 30.5 - 2*8.2 + 1.5\r\n-N#, =N=\r\nnon-standard valency
35.00 [NH3] 30.5 + 3*1.5\nnon-standard valency?
2.68 O=[N+][O-] 17.07 - 23.06 - 3.01 + 11.68\r\n(O=) - ([O-])- - (-N(-)-) + (N(=)=) \r\nfix to make charge-separated spelling work
33.03 N=[N+]=[N-] 23.79 + 13.6 - 4.36\r\n(N#) + (=N#) - (-[N+]#)\r\nfix to make charged-separated spelling work
\.
COMMENT ON TABLE _OCSCHEMA_.tpsa IS 'topological polar surface area
Ertl, P., Rohde, B., Selzer, P. Fast calculation of molecular polar surface area as a sum of fragment based contributions and its application to the prediction of drug transport properties. J. Med. Chem. 2000, 43, 3714-3717.';
COMMENT ON COLUMN _OCSCHEMA_.tpsa.atom_psa IS 'parameterized partial surface area of atom fragment';
COMMENT ON COLUMN _OCSCHEMA_.tpsa.smarts IS 'fragment smarts';
COMMENT ON COLUMN _OCSCHEMA_.tpsa.description IS 'pseudo-smarts description and more';
Create OR Replace FUNCTION _OCSCHEMA_.tpsa(Text)
Returns numeric AS '
-- For description of the methodology see :
-- P. Ertl, B. Rohde, P. Selzer
-- Fast Calculation of Molecular Polar Surface Area as a Sum of Fragment-based
-- Contributions and Its Application to the Prediction of Drug Transport
-- Properties, J.Med.Chem. 43, 3714-3717, 2000
Select sum(atom_psa*_SCHEMA_.count_matches($1,smarts))
from _OCSCHEMA_.tpsa;
' LANGUAGE sql IMMUTABLE;
Comment on FUNCTION _OCSCHEMA_.tpsa(Text)
Is 'polar surface area of smiles, by Ertl''s method';