#

Convert Abundance Table to Experiment

This tool has been deprecated and will be retired in a future version of the software. It has been moved to the **Legacy Tools** () folder of the Toolbox, and its name has "(legacy)" appended to it. The functionality of this tool has become obsolete as you can now run statistical test on the abundance table as is using the tools **Differential Abundance Analysis** and **Create Heat Map for Abundance Table**.

To run the Convert Abundance Table to Experiment (legacy) tool, go to:

**Toolbox** | **Legacy Tools** () | **Convert Abundance Table to Experiment (legacy)** ()

Choose an abundance table as input, and define which metadata group is to be considered as factor.

The tool outputs a table labeled (experiment). The first column is the name of the group used as factor in the analysis (its taxonomy and an ID number). For each feature (e.g. an OTU, an organism, a Pfam family or a GO term) there will be the following data:

**Range**: The difference between the highest and the lowest expression value for the feature over all the samples.**IQR**: The inter-quantile range of the values for a feature across the samples, that is, the difference between the 75%-ile value and the 25%-ile value.**Difference**: The difference for a two-group experiment between the mean of the expression values across the samples assigned to group 2 and the mean of the expression values across the samples assigned to group 1. Thus, if the mean expression level in group 2 is higher than that of group 1 the 'Difference' is positive, and if it is lower the 'Difference' is negative. For experiments with more than two groups the 'Difference' contains the difference between the maximum and minimum of the mean expression values of the groups, multiplied by -1 if the group with the maximum mean expression value occurs before the group with the minimum mean expression value (with the ordering: group 1, group 2, ...).**Fold change**: For a two-group experiment the 'Fold Change' tells you how many times bigger the mean expression value in group 2 is relative to that of group 1. If the mean expression value in group 2 is bigger than that in group 1 this value is the mean expression value in group 2 divided by that in group 1. If the mean expression value in group 2 is smaller than that in group 1 the fold change is the mean expression value in group 1 divided by that in group 2 with a negative sign. Thus, if the mean expression levels in group 1 and group 2 are 10 and 50 respectively, the fold change is 5, and if the and if the mean expression levels in group 1 and group 2 are 50 and 10 respectively, the fold change is -5. For experiments with more than two groups, the 'Fold Change' column contains the ratio of the maximum of the mean expression values of the groups to the minimum of the mean expression values of the groups, multiplied by -1 if the group with the maximum mean expression value occurs before the group with the minimum mean expression value (with the ordering: group 1, group 2, ...).**Taxonomy**: The taxonomy of the feature, if specified. For OTUs, this is specified by the reference database when a database entry was used as Reference.**Expression values and Means for each site**: The expression values represents the number of reads belonging to the feature in a specific sample, and Means is the mean of these expression values.

You can create a sub-experiment by selecting only some of the features from your experiment table (the most abundant ones for example).