Convert table (analysis) - Revision history

WikiBot: Automatic synchronization with BioUML

2020-12-09T11:15:31Z

Automatic synchronization with BioUML

2019-03-12T09:32:50Z

Automatic synchronization with BioUML

2017-02-13T12:00:33Z

Automatic synchronization with BioUML

2014-12-11T09:17:44Z

Automatic synchronization with BioUML

2013-05-31T04:14:31Z

Class name added

2013-05-16T05:40:51Z

Mistaken file names update reverted

2013-05-16T05:32:51Z

Automatic synchronization with BioUML

2013-05-07T03:51:14Z

Link to plugin page

2013-05-06T04:47:13Z

Plugin name added

2013-04-23T10:02:42Z

Space after icon

@@ Line 1: / Line 1: @@
 ;Analysis title
-:[[File:Data-Convert-table-icon.png]] Convert table
+:[[File:Table-manipulation-Convert-table-icon.png]] Convert table
 ;Provider
 :[[Institute of Systems Biology]]
@@ Line 27: / Line 27: @@
 * '''Input type''' – Type of references in input table
 * '''Output type''' – Select type of identifiers for the resulting table
 * '''Numerical value treatment rule''' – Select one of the rules to treat values in the numerical columns of the table when several rows are merged into a single one.
 *:In cases of "average", "average w/o 20% outliers" and "sum", the selected rule is applied to all numerical columns of the table. In cases of "minimum", "maximum" and "extreme" a new option appears bellow which request user to select a "Leading column". The chosen rule is applied then to the values in the selected Leading column (e.g. in the Leading column the maximum value is computed among all the merged rows). All other numerical values of the table will be taken from that row which corresponds to the selected value in the leading column.
@@ Line 36: / Line 37: @@
 [[Category:Analyses]]
-[[Category:Data (analyses group)]]
+[[Category:Table manipulation (analyses group)]]
 [[Category:ISB analyses]]
 [[Category:Autogenerated pages]]

@@ Line 31: / Line 31: @@
 * '''Leading column''' – Select the column with numerical values to apply one of the rules described above
 * '''Restrict multiple matching to max''' (expert) – Input accession will be excluded from result if it matches to more accessions than specified in this parameter (set 0 to turn this feature off)
 * '''Unmatched rows''' (expert) – Path to store unmatched rows of the table
 * '''Output table''' – Path to store the resulting table in the tree

@@ Line 10: / Line 10: @@
 === Convert table identifiers using BioHub(s) ===
-This analysis allows you to change the type of identifiers in the table and convert rows accordingly using chain of BioHubs. BioHub is a converter capable to convert between two or more types (for example, convert ''"Genes: Ensembl"'' into ''"Proteins: Ensembl"''). If direct conversion between two given types is impossible, this analysis will create the optimal chain of several BioHubs and use them subsequently.
+This analysis changes the type of identifiers in the table and converts rows accordingly using a chain of BioHubs. A BioHub is a converter between two or more types (for example, convert ''"Genes: Ensembl"'' into ''"Proteins: Ensembl"''). If direct conversion between two given types is impossible, this analysis will create the optimal chain of several BioHubs and use them subsequently.
 Note that several non-trivial situations might occur during conversion:

@@ Line 24: / Line 24: @@
 * '''Input table''' – Data set to be converted
 * '''Column with IDs''' (expert) – Column to be used as source ID. Select (none) to use row IDs
 * '''Input type''' – Type of references in input table
 * '''Output type''' – Select type of identifiers for the resulting table
 * '''Numerical value treatment rule''' – Select one of the rules to treat values in the numerical columns of the table when several rows are merged into a single one.
 *:In cases of "average", "average w/o 20% outliers" and "sum", the selected rule is applied to all numerical columns of the table. In cases of "minimum", "maximum" and "extreme" a new option appears bellow which request user to select a "Leading column". The chosen rule is applied then to the values in the selected Leading column (e.g. in the Leading column the maximum value is computed among all the merged rows). All other numerical values of the table will be taken from that row which corresponds to the selected value in the leading column.
 * '''Leading column''' – Select the column with numerical values to apply one of the rules described above
 * '''Unmatched rows''' (expert) – Path to store unmatched rows of the table
 * '''Output table''' – Path to store the resulting table in the tree

@@ Line 3: / Line 3: @@
 ;Provider
 :[[Institute of Systems Biology]]
 ;Plugin
 :[[Ru.biosoft.analysis (plugin)|ru.biosoft.analysis (Common methods of data analysis plug-in)]]