Validation Log
2025-12-14 21:01:25.198699
mwtab Python Library Version: 2.0.0
Source:        https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN000065/mwtab/json
Study ID:      ST000042
Analysis ID:   AN000065
File format:   json
Status: Contains Validation Issues
Number of Issues: 20

Number of Warnings: 8

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 ["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`_4`-DIHYDROXYACETOPHENONE"
	"3_4-DIHYDROXYBENZOATE"
	"3_4-DIHYDROXYPHENYL GLYCOL"
	"3_5-DIBROMO-4-HYDROXYBENZONITRILE"
	"3-CARBOXY-4-METHYL-5-PROPYL-2-FURANPROPANOATE_1"
	"4-ANDROSTEN-3BETA_17BETA-DIOL DISULFATE (*)"
	"5_6-DIHYDROURACIL"
	"BOC-ASN_1"
	"CIS-7_10_13_16-DOCOSATETRAENOIC ACID"
	"DEHYDROISOANDROSTERONE 3-SULFATE_1"
	"GULONO-1_4-LACTONE"
	"PYRIDINE-2_3-DICARBOXYLATE"
	"STEAROYLGLYCEROPHOSPHOETHANOLAMINE (*)_1"
Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table:
	"3-CARBOXY-4-METHYL-5-PROPYL-2-FURANPROPANOATE_2"
	"BOC-ASN_2"
	"DEHYDROISOANDROSTERONE 3-SULFATE_2"
	"STEAROYLGLYCEROPHOSPHOETHANOLAMINE (*)_2"
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:
68    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.
Warning: The "inchi_key" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.