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