Validation Log 2025-12-14 21:01:15.280184 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN000062/mwtab/json Study ID: ST000041 Analysis ID: AN000062 File format: json Status: Contains Validation Issues Number of Issues: 22 Number of Warnings: 8 Number of Value Errors: 14 Number of Consistency Errors: 2 Number of Format Errors: 5 Issue Log: Error: An empty value or a null value was detected in ["PROJECT"]["PROJECT_SUMMARY"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["PROJECT"]["ADDRESS"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["STUDY"]["PHONE"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["COLLECTION"]["COLLECTION_SUMMARY"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["TREATMENT"]["TREATMENT_SUMMARY"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["SAMPLEPREP"]["SAMPLEPREP_SUMMARY"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["MS"]["MS_COMMENTS"]. Either a legitimate value should be provided for this key, or it should be removed altogether. Error: The required property, "FLOW_GRADIENT", in ["CHROMATOGRAPHY"] is missing. Error: The required property, "FLOW_RATE", in ["CHROMATOGRAPHY"] is missing. Error: The required property, "COLUMN_TEMPERATURE", in ["CHROMATOGRAPHY"] is missing. Error: The required property, "SOLVENT_A", in ["CHROMATOGRAPHY"] is missing. Error: The required property, "SOLVENT_B", in ["CHROMATOGRAPHY"] is missing. Error: The following metabolites in the, ["MS_METABOLITE_DATA"]["Data"] table were not found in the ["MS_METABOLITE_DATA"]["Metabolites"] table: "11-BETA-HYDROXYANDROST-4-ENE-3_17-DIONE" "2_3-DIPHOSPHO-D-GLYCERIC ACID" "2`_4`-DIHYDROXYACETOPHENONE" "3_4-DIHYDROXYBENZOATE" "5_6-DIHYDROURACIL" "CIS-7_10_13_16-DOCOSATETRAENOIC ACID" "PYRIDINE-2_3-DICARBOXYLATE" "11-BETA-HYDROXYANDROST-4-ENE-3,17-DIONE_2" "11-BETA-HYDROXYANDROST-4-ENE-3,17-DIONE_3" "3,4-DIHYDROXYBENZOATE_2" Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table: "2,3-DIPHOSPHO-D-GLYCERIC ACID" "2`,4`-DIHYDROXYACETOPHENONE" "5,6-DIHYDROURACIL" Warning: The "inchi_key" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "inchi_key", and some of the values in the column do not match the expected type or format for that column. The non-matching values are: 193 CA1375 194 C02494 195 CA1373 196 C02774 197 C08317 198 C03401 199 C03401 200 C03212 201 CA1233 202 C03056 203 C03056 204 CA1504 205 CA1504 206 C01987 207 C00586 208 C02502 209 CA1107 210 C06325 211 C06325 212 C15519 213 C00206 214 C00360 215 C00360 216 C00881 217 C00705 218 C00705 219 C00239 220 C00330 221 C00330 222 C00330 223 C00361 224 C00362 225 C00362 226 C02465 227 C02465 228 CA1489 229 CA1489 230 C00355 231 CA1222 232 C01161 233 CE6369 234 C01060 235 C01179 236 CA1235 237 C02636 238 C02794 239 C01089 240 C05587 241 CA1325 242 C00913 243 C00597 244 CA1202 245 CA1234 246 C05822 247 C00882 248 C02946 249 C02946 250 CA1491 251 C01035 252 C05584 253 CA1410 254 C02835 255 C00233 256 C06730 257 C02235 258 C01017 259 C00643 260 C03088 261 C02804 262 C02240 263 C03681 264 C05198 265 C05198 266 C00170 267 C00268 268 CA1404 269 C07756 270 C00164 271 C00147 272 CA1486 273 C00575 274 C00020 275 C00002 276 CA1496 277 C00301 278 C00301 279 C00498 280 C00498 281 C01401 282 C01551 283 C02477 284 C02477 285 CA1498 286 CA1514 287 C00292 288 C00108 289 CA1890 290 C00072 291 C00072 292 C01262 293 C01408 294 C00719 295 C03690 296 C03690 297 C03690 298 C01159 299 C01159 300 C01159 301 C06555 302 CA1201 303 CA1424 304 CA1424 305 CA1424 306 C01481 307 C07481 308 C07481 309 C12650 310 C12650 311 C12650 312 C00386 313 C01164 314 C01164 315 C00187 316 C00695 317 C00815 318 C00815 319 C00735 320 C00735 321 C00735 322 C02821 323 C02821 324 C00762 325 C00762 326 C00762 327 C00791 328 C12101 329 C01066 330 C01066 331 C00571 332 CA1248 333 CA1487 334 C00542 335 C02354 336 C02354 337 C00307 338 C00307 339 C00055 340 C00055 341 C00063 342 C00380 343 C00380 344 CA1059 345 C04483 346 C04483 347 C14554 348 C14554 349 C14554 350 C00526 351 UP0002 352 UP0013 353 UP0027 354 UP0012 355 UP0037 356 C06772 357 CA1488 358 C00415 359 C00415 360 C00415 361 C00337 362 C00337 363 C00337 364 C00337 365 CA1310 366 CA1310 367 C03114 368 C03114 369 Z02138 370 C03758 371 CA1037 372 C00788 373 C00503 374 C02537 375 C00189 376 CA1213 377 CA1213 378 CA1342 379 CA1342 380 C00016 381 C00504 382 C00354 383 C00354 384 CA1420 385 C00818 386 C00257 387 C03752 388 C00352 389 C00127 390 C00051 391 CA1402 392 CA1402 393 CA1512 394 CA1512 395 C00037 396 C00037 397 CA1349 398 CA1349 399 CA1349 400 C00242 401 C00035 402 C05410 403 CA1510 404 C01381 405 C00860 406 C00860 407 CA1198 408 C01817 409 C00544 410 C00544 411 C00263 412 C00530 413 CA1517 414 CA1517 415 CA1513 416 C00262 417 C00262 418 C02693 419 C02693 420 C00955 421 C05658 422 C00104 423 C00130 424 C00311 425 C01717 426 C04771 427 C16439 428 C00666 429 C01727 430 C01727 431 C16440 432 C00208 433 C00275 434 C00275 435 C03510 436 CA1265 437 C11512 438 C11512 439 CA1357 440 CA1091 441 CA1015 442 C03793 443 C04203 444 C01132 445 CA1500 446 C03137 447 CE1554 448 CE1310 449 CE1310 450 C02714 451 CA1214 452 CA1214 453 C11519 454 C11519 455 CA1328 456 CA1328 457 C02441 458 C02299 459 CA1477 460 CA1477 461 CA1254 462 CA1254 463 C02567 464 C04083 465 C04083 466 C04083 467 C00153 468 C00003 469 C04423 470 C00455 471 C00455 472 C00455 473 C13051 474 CA1379 475 C02571 476 C02571 477 CA1209 478 CA1209 479 C01118 480 C04227 481 CA1223 482 CA1223 483 CA1223 484 CA1475 485 C01602 486 C01602 487 C00295 488 C00830 489 C01012 490 C01012 491 CA1476 492 C07418 493 CA1493 494 C05332 495 C02735 496 C02304 497 C02305 498 CA1497 499 C05682 500 C05682 501 C01606 502 C00408 503 U03237 504 CA1277 505 CA1277 506 C00715 507 C00715 508 C00134 509 CA1509 510 C00534 511 C00314 512 C00296 513 C00296 514 C00296 515 C06338 516 C06338 517 C00376 518 C00376 519 C00473 520 C01182 521 C00019 522 C00021 523 C03727 524 C02886 525 C02886 526 C09642 527 C09642 528 C00780 529 C00493 530 C00670 531 C00315 532 C00750 533 C00836 534 C00550 535 C00550 536 C00751 537 C01613 538 C08278 539 C07130 540 C01081 541 C01081 542 C00068 543 C03542 544 C03542 545 C00214 546 C00842 547 C00178 548 C03739 549 C01004 550 C01004 551 C00565 552 C00398 553 C01536 554 CA1401 555 C00086 556 C00086 557 C00299 558 C00299 559 C00299 560 C00015 561 C00105 562 C00785 563 C16436 564 C16436 565 C05441 566 C05441 567 C05443 568 C05443 569 C01762 570 C00655 Warning: The "kegg_id" column at position 7 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "kegg_id", and some of the values in the column do not match the expected type or format for that column. The non-matching values are: 55 BOCASN Warning: The "ri" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "retention_index". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name. Warning: The "ri_type" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "retention_index_type". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name. Warning: The standard column, "other_id", was found in the METABOLITES table as "other_id". If this column contains database IDs for standard databases such as KEGG, PubChem, HMDB, etc., it is recommended to make individual columns for these and not lump them together into a less descriptive "other_id" column. Warning: The "moverz_quant" column at position 2 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "ri" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "ri_type" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.