|
0
|
1
|
|
|
2 tryCatch({
|
|
|
3 DBModelR::ModelDefinition(table="yui", fields=list(yui="INTEGER"))
|
|
|
4 }, error=function(e) {
|
|
|
5 stop("Please, install DBModelR before you source this file.")
|
|
|
6 })
|
|
|
7
|
|
|
8 list(
|
|
|
9 adduct=DBModelR::ModelDefinition(
|
|
|
10 table="adduct",
|
|
|
11 fields=list(
|
|
|
12 name="TEXT",
|
|
|
13 mass="FLOAT",
|
|
|
14 charge="INTEGER",
|
|
|
15 multi="INTEGER",
|
|
|
16 formula_add="TEXT",
|
|
|
17 formula_ded="TEXT",
|
|
|
18 sign="TEXT",
|
|
|
19 oidscore="INTEGER",
|
|
|
20 quasi="INTEGER",
|
|
|
21 ips="FLOAT"
|
|
|
22 )
|
|
|
23 ),
|
|
|
24 cluster=DBModelR::ModelDefinition(
|
|
|
25 table="cluster",
|
|
|
26 fields=list(
|
|
|
27 clusterID="INTEGER",
|
|
|
28 formula="TEXT",
|
|
|
29 annotation="TEXT",
|
|
|
30 coeff="FLOAT",
|
|
|
31 r_squared="FLOAT",
|
|
|
32 charge="INTEGER",
|
|
|
33 mean_rt="FLOAT",
|
|
|
34 score="FLOAT",
|
|
|
35 deviation="FLOAT",
|
|
|
36 status="TEXT",
|
|
|
37 adduct="TEXT",
|
|
|
38 curent_group="INTEGER",
|
|
|
39 pc_group="INTEGER",
|
|
|
40 align_group="INTEGER",
|
|
|
41 xcms_group="INTEGER"
|
|
|
42 ),
|
|
|
43 one=list("sample", "compound")
|
|
|
44 ),
|
|
|
45 compound=DBModelR::ModelDefinition(
|
|
|
46 table="compound",
|
|
|
47 fields=list(
|
|
|
48 name="TEXT",
|
|
|
49 common_name="TEXT",
|
|
|
50 formula="TEXT",
|
|
|
51 charge="INTEGER",
|
|
|
52 date="TEXT",
|
|
|
53 mz="FLOAT"
|
|
|
54 )
|
|
|
55 ),
|
|
|
56 feature=DBModelR::ModelDefinition(
|
|
|
57 table="feature",
|
|
|
58 fields=list(
|
|
|
59 featureID="INTEGER",
|
|
|
60 mz="FLOAT",
|
|
|
61 mz_min="FLOAT",
|
|
|
62 mz_max="FLOAT",
|
|
|
63 rt="FLOAT",
|
|
|
64 rt_min="FLOAT",
|
|
|
65 rt_max="FLOAT",
|
|
|
66 int_o="FLOAT",
|
|
|
67 int_b="FLOAT",
|
|
|
68 max_o="FLOAT",
|
|
|
69 iso="TEXT",
|
|
|
70 abundance="FLOAT"
|
|
|
71 ),
|
|
|
72 one=list("cluster")
|
|
|
73 ),
|
|
|
74 instrument=DBModelR::ModelDefinition(
|
|
|
75 table="instrument",
|
|
|
76 fields=list(
|
|
|
77 model="TEXT",
|
|
|
78 manufacturer="TEXT",
|
|
|
79 analyzer="TEXT",
|
|
|
80 detector_type="TEXT",
|
|
|
81 ion_source="TEXT"
|
|
|
82 )
|
|
|
83 ),
|
|
|
84 instrument_config=DBModelR::ModelDefinition(
|
|
|
85 table="instrument_config",
|
|
|
86 fields=list(
|
|
|
87 resolution="TEXT",
|
|
|
88 agc_target="TEXT",
|
|
|
89 maximum_IT="TEXT",
|
|
|
90 number_of_scan_range="TEXT",
|
|
|
91 scan_range="TEXT",
|
|
|
92 version="TEXT"
|
|
|
93 )
|
|
|
94 ),
|
|
|
95 project=DBModelR::ModelDefinition(
|
|
|
96 table="project",
|
|
|
97 fields=list(
|
|
|
98 name="TEXT",
|
|
|
99 comment="TEXT"
|
|
|
100 ),
|
|
|
101 one=list("sample")
|
|
|
102 ),
|
|
|
103 sample=DBModelR::ModelDefinition(
|
|
|
104 table="sample",
|
|
|
105 fields=list(
|
|
|
106 name="TEXT",
|
|
|
107 path="TEXT",
|
|
|
108 polarity="TEXT",
|
|
|
109 kind="TEXT", ## rdata or mxml or enriched_rdata
|
|
|
110 raw="BLOB"
|
|
|
111 ),
|
|
|
112 one=list(
|
|
|
113 "peak_picking_parameters",
|
|
|
114 "pairing_parameters",
|
|
|
115 "alignmenmt_parameters",
|
|
|
116 "camera_parameters",
|
|
|
117 "instrument",
|
|
|
118 "instrument_config",
|
|
|
119 "software",
|
|
|
120 "smol_xcms_set"
|
|
|
121 )
|
|
|
122 ),
|
|
|
123 smol_xcms_set=DBModelR::ModelDefinition(
|
|
|
124 table="smol_xcms_set",
|
|
|
125 fields=list(
|
|
|
126 raw="BLOB"
|
|
|
127 )
|
|
|
128 ),
|
|
|
129 software=DBModelR::ModelDefinition(
|
|
|
130 table="software",
|
|
|
131 fields=list(
|
|
|
132 name="TEXT",
|
|
|
133 version="TEXT"
|
|
|
134 )
|
|
|
135 ),
|
|
|
136 # camera_parameters=DBModelR::ModelDefinition(
|
|
|
137 # table="camera_parameters",
|
|
|
138 # fields=list()
|
|
|
139 # ),
|
|
|
140 # pairing_parameters=DBModelR::ModelDefinition(
|
|
|
141 # table="pairing_parameters",
|
|
|
142 # fields=list()
|
|
|
143 # ),
|
|
|
144 peak_picking_parameters=DBModelR::ModelDefinition(
|
|
|
145 table="peak_picking_parameters",
|
|
|
146 fields=list(
|
|
|
147 ppm="FLOAT",
|
|
|
148 peakwidth="TEXT",
|
|
|
149 snthresh="TEXT",
|
|
|
150 prefilterStep="TEXT",
|
|
|
151 prefilterLevel="TEXT",
|
|
|
152 mzdiff="TEXT",
|
|
|
153 fitgauss="TEXT",
|
|
|
154 noise="TEXT",
|
|
|
155 mzCenterFun="TEXT",
|
|
|
156 integrate="INTEGER",
|
|
|
157 firstBaselineCheck="TEXT",
|
|
|
158 snthreshIsoROIs="TEXT",
|
|
|
159 maxCharge="INTEGER",
|
|
|
160 maxIso="INTEGER",
|
|
|
161 mzIntervalExtension="TEXT"
|
|
|
162 )
|
|
|
163 ),
|
|
|
164 alignmenmt_parameters=DBModelR::ModelDefinition(
|
|
|
165 table="alignmenmt_parameters",
|
|
|
166 fields=list(
|
|
|
167 binSize="TEXT",
|
|
|
168 centerSample="TEXT",
|
|
|
169 response="TEXT",
|
|
|
170 distFun="TEXT",
|
|
|
171 gapInit="TEXT",
|
|
|
172 gapExtend="TEXT",
|
|
|
173 factorDiag="TEXT",
|
|
|
174 factorGap="TEXT",
|
|
|
175 localAlignment="INTEGER",
|
|
|
176 initPenalty="TEXT",
|
|
|
177 bw="TEXT",
|
|
|
178 minFraction="TEXT",
|
|
|
179 minSamples="TEXT",
|
|
|
180 maxFeatures="TEXT"
|
|
|
181 )
|
|
|
182 )
|
|
|
183 )
|
