Validation Log 2025-12-14 21:13:55.554930 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN000344/mwtab/json Study ID: ST000230 Analysis ID: AN000344 File format: json Status: Contains Validation Issues Number of Issues: 23 Number of Warnings: 9 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 ["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: "160.133m/z_2" Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table: "1,2,3,4,6,7,8,9-Octachlorodibenzofuran/" "3,4-Dehydrothiomorpholine-3-carboxylate/" "5,6-Dihydrothymine/ gamma-Amino-gamma-cyanobutanoate/ alpha-Amino-gamma-cyanobutanoate/" "6alpha-Fluoro-11beta,17-dihydroxypregn-4-ene-3,20-dione/ 9-Fluoro-11beta,16alpha-dihydroxypregn-4-ene-3,20-dione/" "Dehydrocostus lactone/ Eremanthin/ Dehydromyodesmone/ 3-(1,2,3,4-Tetrahydro-6-hydroxy-2-naphthyl)cyclopentanone/ Curzerenone/ Furanodienone/ Linderenol/ Isodehydrocostus lactone/" "L-Norleucine/ 6-Aminohexanoate/ -beta-Leucine/ beta-Alaninebetaine/ N,N-Diethylglycine/" "N,N-Dimethylglycine" "Pantetheine 4'-phosphate/" "Pyridoxamine 5'-phosphate" "RU-0211/ 6alpha-Fluoro-17-hydroxypregn-4-ene-3,20-dione acetate/" 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 column pair, "other_id" and "other_id_type", in the METABOLITES table should have data in the same rows, but at least one row has data in one column and nothing in the other. 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 "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 "pubchem_id" column at position 5 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. Warning: The "other_id" column at position 8 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.