Validation Log 2025-12-14 23:56:37.981097 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN003123/mwtab/json Study ID: ST001922 Analysis ID: AN003123 File format: json Status: Contains Validation Issues Number of Issues: 30 Number of Warnings: 22 Number of Value Errors: 22 Number of Consistency Errors: 2 Number of Format Errors: 5 Issue Log: 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. Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][0] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][1] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][2] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][3] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][4] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][5] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][6] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][7] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][8] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][9] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][10] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Warning: The SSF at ["SUBJECT_SAMPLE_FACTORS"][11] has the following duplicate keys in its Additional sample data: "RAW_FILE_NAME" "RAW_FILE_NAME" Error: The following metabolites in the, ["MS_METABOLITE_DATA"]["Data"] table were not found in the ["MS_METABOLITE_DATA"]["Metabolites"] table: "11_12-EpETrE" "3_4-Dihydroxyhydrocinnamic acid" "3_5_5-Trimethyl-2-cyclohexen-1-one" "4_5-Dihydroorotic acid" "5^-Methylthioadenosine" "cis_cis-Muconic acid" "Fructose 1_6-bisphosphate" "Pyridoxal 5^-phosphate" "Uridine 5^-diphosphate" "Uridine 5^-monophosphate" Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table: "11,12-EpETrE" "3,4-Dihydroxyhydrocinnamic acid" "3,5,5-Trimethyl-2-cyclohexen-1-one" "4,5-Dihydroorotic acid" "5'-Methylthioadenosine" "cis,cis-Muconic acid" "Fructose 1,6-bisphosphate" "Pyridoxal 5'-phosphate" "Uridine 5'-diphosphate" "Uridine 5'-monophosphate" Warning: The "ri" column at position 7 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 8 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. Error: Column(s) with no name were found in the ["MS_METABOLITE_DATA"]["Metabolites"] table. Warning: The "inchi_key" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "other_id" column at position 5 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "other_id_type" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "ri" column at position 7 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "ri_type" column at position 8 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "moverz_quant" column at position 9 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "" column at position 10 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.