Validation Log
2025-12-14 20:59:28.950097
mwtab Python Library Version: 2.0.0
Source:        https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN000023/mwtab/json
Study ID:      ST000009
Analysis ID:   AN000023
File format:   json
Status: Contains Validation Issues
Number of Issues: 20

Number of Warnings: 1

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 ["PROJECT"]["PHONE"]. A legitimate value should be provided for this required key.
Error: An empty value or a null value was detected in ["STUDY"]["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: An empty value or a null value was detected in ["CHROMATOGRAPHY"]["CHROMATOGRAPHY_TYPE"]. A legitimate value should be provided for this required key.
Error: An empty value or a null value was detected in ["CHROMATOGRAPHY"]["INSTRUMENT_NAME"]. A legitimate value should be provided for this required key.
Error: An empty value or a null value was detected in ["CHROMATOGRAPHY"]["COLUMN_NAME"]. 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"
	"2_3-DIAMINOPROPIONIC ACID"
	"2^_4^-DIHYDROXYACETOPHENONE"
	"2_6-DIHYDROXYPYRIDINE"
	"2^-DEOXYADENOSINE"
	"2^-DEOXYADENOSINE 5^-MONOPHOSPHATE"
	"2^-DEOXYCYTIDINE"
	"2^-DEOXYCYTIDINE 5^-MONOPHOSPHATE"
	"2^-DEOXYGUANOSINE 5^-DIPHOSPHATE"
	"3_4-DIHYDROXYBENZOATE"
	"3^-CMP"
	"3^-DEPHOSPHO COA"
	"5^-DEOXYADENOSINE"
	"6_7-DIHYDROBIOPTERIN"
	"ADENOSINE 3^_5^-CYCLIC MONOPHOSPHATE"
	"ADENOSINE 5^-MONOPHOSPHATE"
	"CYCLOHEXANE-1_3-DIONE"
	"CYTIDINE 5^-DIPHOSPHOCHOLINE"
	"FRUCTOSE 1_6-BIPHOSPHATE"
	"GUANOSINE 5^ MONOPHOSPHATE"
	"INOSINE 5^-DIPHOSPHATE"
	"INOSINE 5^-MONOPHOSPHATE"
	"LL-2_6-DIAMINOHEPTANEDIOATE"
	"N_N_N-TRIMETHYLLYSINE"
	"OROTIDINE 5^-MONOPHOSPHATE"
	"URIDINE 5^-DIPHOSPHATE"
	"URIDINE 5^-DIPHOSPHO-N-ACETYLGALACTOSAMINE"
	"3-(CYSTEIN-S-YL)ACETAMINOPHEN (*)_2"
	"DOCOSAHEXAENOYLGLYCEROPHOSPHOCHOLINE (*)_2"
	"MYRISTOYLGLYCEROPHOSPHOCHOLINE (*)_2"
	"METHYL JASMONATE (??)_2"
	"SUCCINATE (*)_2"
Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table:
	"2',4'-DIHYDROXYACETOPHENONE"
	"2'-DEOXYADENOSINE"
	"2'-DEOXYADENOSINE 5'-MONOPHOSPHATE"
	"2'-DEOXYCYTIDINE"
	"2'-DEOXYCYTIDINE 5'-MONOPHOSPHATE"
	"2'-DEOXYGUANOSINE 5'-DIPHOSPHATE"
	"3'-CMP"
	"3'-DEPHOSPHO COA"
	"5'-DEOXYADENOSINE"
	"ADENOSINE 3',5'-CYCLIC MONOPHOSPHATE"
	"ADENOSINE 5'-MONOPHOSPHATE"
	"CYTIDINE 5'-DIPHOSPHOCHOLINE"
	"GUANOSINE 5' MONOPHOSPHATE"
	"INOSINE 5'-DIPHOSPHATE"
	"INOSINE 5'-MONOPHOSPHATE"
	"OROTIDINE 5'-MONOPHOSPHATE"
	"URIDINE 5'-DIPHOSPHATE"
	"URIDINE 5'-DIPHOSPHO-N-ACETYLGALACTOSAMINE"
	"3-(CYSTEIN-S-YL)ACETAMINOPHEN (*)_1"
	"DOCOSAHEXAENOYLGLYCEROPHOSPHOCHOLINE (*)_1"
	"MYRISTOYLGLYCEROPHOSPHOCHOLINE (*)_1"
	"METHYL JASMONATE (??)_1"
	"SUCCINATE (*)_1"
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.