Validation Log 2025-12-14 21:01:18.874477 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN000063/mwtab/json Study ID: ST000041 Analysis ID: AN000063 File format: json Status: Contains Validation Issues Number of Issues: 20 Number of Warnings: 7 Number of Value Errors: 12 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: 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" "11-BETA-HYDROXYANDROST-4-ENE-3_17-DIONE_1" "11-BETA-HYDROXYANDROST-4-ENE-3_17-DIONE_2" "1_2-DIDECANOYL-SN-GLYCERO-3-PHOSPHOCHOLINE" "17ALPHA-HYDROXYPROGESTERONE_1" "2_3-DIAMINOPROPIONIC ACID" "2_3-DIAMINOPROPIONIC ACID_1" "2_4-DIHYDROXYPTERIDINE" "2_5-DIMETHYLPYRAZINE" "2_6-DIHYDROXYPYRIDINE" "2_6-DIHYDROXYPYRIDINE_1" "2-AMINO-2-DEOXYHEXOPYRANOSE_1" "2`-DEOXYADENOSINE 5`-MONOPHOSPHATE_1" "2`-DEOXYCYTIDINE 5`-DIPHOSPHATE_1" "2`-DEOXYGUANOSINE_1" "2`-DEOXYGUANOSINE 5`-MONOPHOSPHATE_1" "2-HYDROXYBUTYRIC ACID_1" "2-QUINOLINECARBOXYLIC ACID_1" "3_3`_5-TRIIODO-L-THYRONINE" "3_3`_5-TRIIODO-L-THYRONINE_1" "3_3`-DITHIODIVALINE" "3_3`-DITHIODIVALINE_1" "3_4-DIHYDROXYBENZOATE" "3_4-DIHYDROXYBENZOATE_1" "3_4-DIHYDROXY-L-PHENYLALANINE" "3_4-DIHYDROXYPHENYLACETATE" "3_4-DIHYDROXYPHENYL GLYCOL" "3_5-DIIODO-L-THYRONINE" "3_5-DIIODO-L-TYROSINE" "3-ALPHA_11-BETA_17-ALPHA_21-TETRAHYDROXY- 5-ALPHA-PREGNAN-20-ONE" "3-HYDROXY-3-METHYLGLUTARATE_1" "3-METHOXY-L-TYROSINE_1" "4-ACETAMIDOBUTANOATE_1" "5ALPHA-PREGNANE-3_20-DIONE" "5`-DEOXYADENOSINE_1" "5-HYDROXYINDOLE-3-ACETIC ACID_1" "5-HYDROXY-L-TRYPTOPHAN_1" "6_7-DIHYDROBIOPTERIN" "6-PHOSPHOGLUCONIC ACID_1" "ADENOSINE_1" "ADENOSINE 2`_3`-CYCLIC MONOPHOSPHATE" "ADENOSINE 3`_5`-CYCLIC MONOPHOSPHATE" "ADPGLUCOSE_1" "ADP-RIBOSE_1" "ALPHA-TOCOPHEROL_1" "ASCORBATE_1" "ASPARAGINE_1" "BILIVERDIN_1" "BIOTIN_1" "BIS(2-ETHYLHEXYL)PHTHALATE_1" "BISPHOSPHOGLYCERATE_1" "BOC-HIS-OH_1" "BOC-LYS-OH_1" "CAFFEINE_1" "CAPECITABINE_1" "CHOLESTA-5_7-DIEN-3BETA-OL" "CHOLESTA-5_7-DIEN-3BETA-OL_1" "CIS-7_10_13_16-DOCOSATETRAENOIC ACID" "CITRAMALATE_1" "CITRATE_1" "CORTICOSTERONE_1" "CORTISOL_1" "CORTISOL 21-ACETATE_1" "CORTISONE_1" "CYCLOHEXANE-1_3-DIONE" "CYCLOHEXANE-1_3-DIONE_1" "CYS-GLY_ OXIDIZED" "CYSTINE_1" "CYTIDINE 2`_3`-CYCLIC MONOPHOSPHATE (CCMP)" "CYTIDINE 2`_3`-CYCLIC MONOPHOSPHATE (CCMP)_1" "CYTIDINE 5`-DIPHOSPHATE_1" "CYTIDINE 5`-DIPHOSPHOCHOLINE_1" "CYTIDINE 5`-MONOPHOSPHATE_1" "CYTOSINE_1" "DEOXYCHOLATE_1" "DEOXYCORTICOSTERONE_1" "DETHIOBIOTIN_1" "DIHYDROFOLATE_1" "DIHYDROOROTATE_1" "DIMETHYLBENZIMIDAZOLE_1" "DIMETHYL MALEATE_1" "DOCOSAHEXAENOIC ACID_1" "ENKEPHALINE_ (D-ALA)2-LEU" "ETHYL 3-INDOLE ACETATE_1" "ETHYL 4-OXOCYCLOHEXANECARBOXYLATE_1" "FERULATE_1" "FRUCTOSE 1_6-BIPHOSPHATE" "FRUCTOSE 1_6-BIPHOSPHATE_1" "GLUTAMINE_1" "GLUTARATE_1" "GLUTATHIONE_1" "GLYCERALDEHYDE 3-PHOSPHATE DIETHYL ACETAL_1" "GLYCEROL PHOSPHATE_1" "GLYCINE_1" "GLYCOCHOLATE_1" "GLYCOLITHOCHOLIC ACID ETHYL ESTER_1" "GUANOSINE_1" "GULONO-1_4-LACTONE" "HIPPURATE_1" "HISTIDINOL_1" "HOMOGENTISATE_1" "HYDROXYBENZOIC ACID_1" "HYPOXANTHINE_1" "INDOLE-3-ACETAMIDE_1" "INDOLE-3-ACETIC ACID_1" "INOSINE_1" "LL-2_6-DIAMINOHEPTANEDIOATE" "LUMICHROME_1" "MANNOSE-6-PHOSPHATE_1" "MELATONIN_1" "METHYL JASMONATE_1" "N6-(DELTA2-ISOPENTENYL)-ADENINE_1" "N-ACETYL-DL-GLUTAMIC ACID_1" "N-ACETYL-DL-METHIONINE_1" "N-ACETYL-L-CYSTEINE_1" "N-ACETYL-L-LEUCINE_1" "N-ACETYL-L-PHENYLALANINE_1" "N-ACETYLSEROTONIN_1" "N-ALPHA-ACETYL-L-ASPARAGINE_1" "N-CYCLOHEXYLFORMAMIDE_1" "N-CYCLOHEXYLSULFAMIC ACID_1" "NICOTINAMIDE MONONUCLEOTIDE_1" "N_N-DIMETHYL-1_4-PHENYLENEDIAMINE" "N-NITROSODIETHANOLAMINE_1" "N_N_N-TRIMETHYLLYSINE" "N-OLEOYLGLYCINE_1" "O-ACETYL-L-CARNITINE_1" "OLEAMIDE_1" "O-PHOSPHO-DL-SERINE_1" "ORNITHINE_1" "PANTOLACTONE_1" "PANTOTHENIC ACID_1" "P-BROMO-DL-PHENYLALANINE_1" "PHENYLACETIC ACID_1" "PHENYLALANINE_1" "PHOSPHONOACETATE_1" "PROMETRYN_1" "PTERIN_1" "PYRIDINE-2_3-DICARBOXYLATE" "QUINATE_1" "QUINOLIN-2-OL_1" "RETINAL_1" "RETINOATE_1" "RIBOFLAVIN_1" "RIBULOSE 1_5-BISPHOSPHATE" "ROSMARINIC ACID_1" "SALSOLINOL_1" "S-HEXYL-GLUTATHIONE_1" "THIAMINE MONOPHOSPHATE_1" "THIOPURINE S-METHYLETHER_1" "THYROXINE_1" "TRANS-CYCLOHEXANE-1_2-DIOL" "TRIGONELLINE_1" "TRYPTOPHAN_1" "UREA_1" "URIDINE_1" "VALINE_1" "VITAMIN D2_1" "VITAMIN D3_1" Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table: "11-BETA-HYDROXYANDROST-4-ENE-3,17-DIONE_2" "11-BETA-HYDROXYANDROST-4-ENE-3,17-DIONE_3" "1,2-DIDECANOYL-SN-GLYCERO-3-PHOSPHOCHOLINE" "17ALPHA-HYDROXYPROGESTERONE_3" "2,3-DIAMINOPROPIONIC ACID" "2,3-DIAMINOPROPIONIC ACID_2" "2,4-DIHYDROXYPTERIDINE" "2,5-DIMETHYLPYRAZINE" "2,6-DIHYDROXYPYRIDINE" "2,6-DIHYDROXYPYRIDINE_2" "2-AMINO-2-DEOXYHEXOPYRANOSE_2" "2`-DEOXYADENOSINE 5`-MONOPHOSPHATE_2" "2`-DEOXYCYTIDINE 5`-DIPHOSPHATE_2" "2`-DEOXYGUANOSINE_3" "2`-DEOXYGUANOSINE 5`-MONOPHOSPHATE_2" "2-HYDROXYBUTYRIC ACID_2" "2-QUINOLINECARBOXYLIC ACID_2" "3,3`,5-TRIIODO-L-THYRONINE" "3,3`,5-TRIIODO-L-THYRONINE_2" "3,3`-DITHIODIVALINE" "3,3`-DITHIODIVALINE_2" "3,4-DIHYDROXYBENZOATE_2" "3,4-DIHYDROXY-L-PHENYLALANINE" "3,4-DIHYDROXYPHENYLACETATE" "3,4-DIHYDROXYPHENYL GLYCOL" "3,5-DIIODO-L-THYRONINE" "3,5-DIIODO-L-TYROSINE" "3-ALPHA,11-BETA,17-ALPHA,21-TETRAHYDROXY- 5-ALPHA-PREGNAN-20-ONE" "3-HYDROXY-3-METHYLGLUTARATE_2" "3-METHOXY-L-TYROSINE_2" "4-ACETAMIDOBUTANOATE_2" "5ALPHA-PREGNANE-3,20-DIONE" "5`-DEOXYADENOSINE_2" "5-HYDROXYINDOLE-3-ACETIC ACID_2" "5-HYDROXY-L-TRYPTOPHAN_2" "6,7-DIHYDROBIOPTERIN" "6-PHOSPHOGLUCONIC ACID_3" "ADENOSINE_2" "ADENOSINE 2`,3`-CYCLIC MONOPHOSPHATE" "ADENOSINE 3`,5`-CYCLIC MONOPHOSPHATE" "ADPGLUCOSE_2" "ADP-RIBOSE_2" "ALPHA-TOCOPHEROL_2" "ASCORBATE_2" "ASPARAGINE_2" "BILIVERDIN_4" "BIOTIN_3" "BIS(2-ETHYLHEXYL)PHTHALATE_3" "BISPHOSPHOGLYCERATE_3" "BOC-HIS-OH_3" "BOC-LYS-OH_3" "CAFFEINE_2" "CAPECITABINE_3" "CHOLESTA-5,7-DIEN-3BETA-OL" "CHOLESTA-5,7-DIEN-3BETA-OL_2" "CITRAMALATE_2" "CITRATE_2" "CORTICOSTERONE_3" "CORTISOL_3" "CORTISOL 21-ACETATE_2" "CORTISONE_3" "CYCLOHEXANE-1,3-DIONE" "CYCLOHEXANE-1,3-DIONE_2" "CYS-GLY, OXIDIZED" "CYSTINE_2" "CYTIDINE 2`,3`-CYCLIC MONOPHOSPHATE (CCMP)" "CYTIDINE 2`,3`-CYCLIC MONOPHOSPHATE (CCMP)_2" "CYTIDINE 5`-DIPHOSPHATE_2" "CYTIDINE 5`-DIPHOSPHOCHOLINE_2" "CYTIDINE 5`-MONOPHOSPHATE_2" "CYTOSINE_2" "DEOXYCHOLATE_2" "DEOXYCORTICOSTERONE_3" "DETHIOBIOTIN_2" "DIHYDROFOLATE_3" "DIHYDROOROTATE_4" "DIMETHYLBENZIMIDAZOLE_2" "DIMETHYL MALEATE_2" "DOCOSAHEXAENOIC ACID_2" "ENKEPHALINE, (D-ALA)2-LEU" "ETHYL 3-INDOLE ACETATE_2" "ETHYL 4-OXOCYCLOHEXANECARBOXYLATE_2" "FERULATE_2" "FRUCTOSE 1,6-BIPHOSPHATE" "FRUCTOSE 1,6-BIPHOSPHATE_2" "GLUTAMINE_2" "GLUTARATE_2" "GLUTATHIONE_2" "GLYCERALDEHYDE 3-PHOSPHATE DIETHYL ACETAL_2" "GLYCEROL PHOSPHATE_2" "GLYCINE_2" "GLYCOCHOLATE_2" "GLYCOLITHOCHOLIC ACID ETHYL ESTER_3" "GUANOSINE_2" "GULONO-1,4-LACTONE" "HIPPURATE_2" "HISTIDINOL_2" "HOMOGENTISATE_2" "HYDROXYBENZOIC ACID_2" "HYPOXANTHINE_2" "INDOLE-3-ACETAMIDE_2" "INDOLE-3-ACETIC ACID_2" "INOSINE_3" "LL-2,6-DIAMINOHEPTANEDIOATE" "LUMICHROME_2" "MANNOSE-6-PHOSPHATE_2" "MELATONIN_2" "METHYL JASMONATE_2" "N6-(DELTA2-ISOPENTENYL)-ADENINE_3" "N-ACETYL-DL-GLUTAMIC ACID_2" "N-ACETYL-DL-METHIONINE_2" "N-ACETYL-L-CYSTEINE_2" "N-ACETYL-L-LEUCINE_2" "N-ACETYL-L-PHENYLALANINE_3" "N-ACETYLSEROTONIN_2" "N-ALPHA-ACETYL-L-ASPARAGINE_2" "N-CYCLOHEXYLFORMAMIDE_2" "N-CYCLOHEXYLSULFAMIC ACID_2" "NICOTINAMIDE MONONUCLEOTIDE_3" "N,N-DIMETHYL-1,4-PHENYLENEDIAMINE" "N-NITROSODIETHANOLAMINE_2" "N,N,N-TRIMETHYLLYSINE" "N-OLEOYLGLYCINE_2" "O-ACETYL-L-CARNITINE_2" "OLEAMIDE_3" "O-PHOSPHO-DL-SERINE_2" "ORNITHINE_2" "PANTOLACTONE_2" "PANTOTHENIC ACID_2" "P-BROMO-DL-PHENYLALANINE_2" "PHENYLACETIC ACID_2" "PHENYLALANINE_2" "PHOSPHONOACETATE_2" "PROMETRYN_2" "PTERIN_2" "QUINATE_3" "QUINOLIN-2-OL_2" "RETINAL_2" "RETINOATE_2" "RIBOFLAVIN_2" "RIBULOSE 1,5-BISPHOSPHATE" "ROSMARINIC ACID_2" "SALSOLINOL_2" "S-HEXYL-GLUTATHIONE_2" "THIAMINE MONOPHOSPHATE_2" "THIOPURINE S-METHYLETHER_2" "THYROXINE_2" "TRANS-CYCLOHEXANE-1,2-DIOL" "TRIGONELLINE_2" "TRYPTOPHAN_2" "UREA_2" "URIDINE_3" "VALINE_2" "VITAMIN D2_2" "VITAMIN D3_2" 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: 534 C00337 535 C00186 536 C03203 537 C03917 538 C01159 539 C06338 540 C02226 541 C03663 542 C00460 543 C03351 544 CA1195 545 C04555 546 C01717 547 CA1445 548 C00633 549 C00642 550 C00233 551 C00429 552 CA1042 553 C01780 554 C00026 555 CA1502 556 CA1501 557 C06425 558 C00219 559 C08281 560 C00180 561 C00180 562 BOCASN 563 C01410 564 CA1334 565 C00246 566 C06423 567 C00090 568 C02528 569 C00695 570 CA1523 571 C00588 572 CA1166 573 C12104 574 C01419 575 C01571 576 C14554 577 C07620 578 C00468 579 C00122 580 C00818 581 C02670 582 CA1393 583 CA1352 584 C01585 585 CA1503 586 C05330 587 C08481 588 C02679 589 C08320 590 C01595 591 C00828 592 C03619 593 C06672 594 C00137 595 C06424 596 C03710 597 CA1268 598 C08323 599 C01601 600 C00547 601 C00712 602 C00209 603 C00249 604 C08362 605 C00803 606 C00601 607 C00166 608 C00009 609 C00408 610 C00465 611 C00022 612 C03727 613 CA1193 614 C05335 615 C01530 616 C00042 617 C03958 618 CA1269 619 C00106 620 C01733 621 C02057 622 C01536 623 C00719 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.