TesTable

Checks if your passport and input tables are properly set 

This tool is able to detect any errors in the input tables, whether they are passport tables or tables of external sources presence, phenotypic, genotypic or phenotypic data or nature of variables. Testable offers the option of automatic correction of detected errors, which does not imply an improvement in the quality of the information analyzed but simply adjust the format to fit the needs of CAPFITOGEN tools.

Testable detects the following types of error:

• not matching fields
• Fields in wrong locations
• Empty cells
• ”Ghost” columns and rows
• Incorrect date formats
• Incorrect format of decimal and sexagesimal coordinates
• Specific code format of passport data FAO-Bioversity 2012 (multi-crop passport descriptor)

Under the auto-correction option, all existing errors will be shown as NA values ​​(equivalent to R “empty cell”).

In any case, with or without the auto-correction option, TesTable will generate a text file called “TestTableAnalysis.txt” which will address all the errors found both in English and Spanish. So, if you want to correct errors detected manually, you can go line by line in this file,  correcting the mistakes with your favorite spreadsheet program.

The tables to be analyzed by TesTable must be in the same format as any other tool, e.g. tables are in tab-delimited text format (txt) and must be stored in the “Passport” folder, as required by the other tools. If you have selected the auto-correction option, auto-corrected table will be saved in the “Passport” folder and, depending on the type of table that has been analyzed, the names of the tables will be:

Passport:

Pasaporte_Passport_corr.txt

External Source:

FuentesExt_ExtSources_corr.txt

Phenotype:

Fenotipo_Phenotype_corr.txt

Nature of Phenotypic variables:

NaturalezaVariables_VariableType_corr.txt

Genotype:

Genotipo_Genotype_corr.txt

Finally the Passport tables analyzed by TesTable may have the additional column “AVAILAB” required by ColNucleo and FIGS_R tools, and five additional fields generated by GEOQUAL (LOCALQUAL, COORQUAL, SUITQUAL, TOTALQUAL and TOTALQUAL100). To allow TesTable correctly detect errors in passport tables with AVAILAB and/or GEOQUAL columns, please indicate it in the correct fields within the TesTable interface.