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

Number of Warnings: 7

Number of Value Errors: 17

Number of Consistency Errors: 2

Number of Format Errors: 5

Issue Log:
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-CARBOXY-2_3-DIHYDRO-5_6-DIHYDROXYINDOLE"
	"2^-DEOXYURIDINE 5^-MONOPHOSPHATE"
	"3_4-DIHYDROXYBENZOATE"
	"3ALPHA_7ALPHA_12ALPHA_26-TETRAHYDROXY-5BETA-CHOLESTANE"
	"3ALPHA_7ALPHA-DIHYDROXY-5BETA-CHOLESTANATE"
	"4-(2-AMINO-3-HYDROXYPHENYL)-2_4-DIOXOBUTANOATE"
	"4-(2-AMINOPHENYL)-2_4-DIOXOBUTANOATE"
	"4-ANDROSTEN-3BETA_17BETA-DIOL DISULFATE"
	"5_6-DIHYDROURACIL"
	"ADENOSINE 3`_5`-CYCLIC MONOPHOSPHATE"
	"GULONO-1_4-LACTONE"
	"LL-2_6-DIAMINOHEPTANEDIOATE"
	"PYRIDINE-2_3-DICARBOXYLATE"
Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table:
	"2-CARBOXY-2,3-DIHYDRO-5,6-DIHYDROXYINDOLE"
	"2'-DEOXYURIDINE 5'-MONOPHOSPHATE"
	"3ALPHA,7ALPHA,12ALPHA,26-TETRAHYDROXY-5BETA-CHOLESTANE"
	"3ALPHA,7ALPHA-DIHYDROXY-5BETA-CHOLESTANATE"
	"4-(2-AMINO-3-HYDROXYPHENYL)-2,4-DIOXOBUTANOATE"
	"4-(2-AMINOPHENYL)-2,4-DIOXOBUTANOATE"
	"4-ANDROSTEN-3BETA,17BETA-DIOL DISULFATE"
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.
Warning: The "inchi_key" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.