Tabular (file format) - Revision history

WikiBot: {{Type link}} used

2013-05-17T09:40:25Z

{{Type link}} used

WikiBot: Target element type added

2013-05-16T06:48:04Z

Target element type added

WikiBot: Plugin link added

2013-05-07T07:13:10Z

Plugin link added

WikiBot: Protected "Tabular (file format)": Autogenerated page (‎[edit=sysop] (indefinite))

2013-04-04T09:28:34Z

Protected "Tabular (file format)": Autogenerated page (‎[edit=sysop] (indefinite))

WikiBot: Added 'Autogenerated pages' category

2013-04-04T09:28:34Z

Added 'Autogenerated pages' category

WikiBot: Automatic synchronization with BioUML

2013-04-04T08:24:52Z

Automatic synchronization with BioUML

New page

=== Tabular file formats ===

Tabular file format represents the table. Several formats are supported including tab-separated (*.txt, *.tab), comma-separated (*.csv), and Microsoft Excel Workbooks (*.xls, *.xlsx). During the import additional parameters can be specified. Some parameters may appear only after file upload as they depends on the file structure. Most of parameters will be auto-detected by the system, but you should review them carefully as auto-detection may not work for some specific files.

'''Parameters:'''
* '''Sheet name''' (for MS Excel only) – which workbook sheet you want to import. Only one sheet may be imported at once.
* '''Column delimiter''' (n/a for MS Excel) – specify which symbol separates the columns.
* '''Process quotes''' – if checked, then column delimiter inside "quoted" values will be ignored. The quote symbols themselves will be removed.
* '''Header row index''' – number of row (starting from 1) at which column headers are located. If there are no column headers in your file, please specify 0. In this case table columns will be named as "Column#1", "Column#2" and so on. You will be able to rename them later.
* '''First data row index''' – number of row (starting from 1) at which actual data starts. All rows from this till the end of the file will be loaded.
* '''Column for ID''' – select the column which will be used as row ID. In the system each table row must have unique identifier (key) which will be used in many analyses. If you have genes list, then column containing Entrez gene ID or Ensembl gene ID will be fine. If you have Affymetrix probes, then Probe ID column should be selected. You may also use "Generate unique ID" option to generate incrementing numbers and use them as row IDs.
* '''Add suffixes to repeated ID''' – if checked and repeated entries encountered in the ID column, then suffixes will be added to keep row IDs unique. If not checked, then rows with repeated IDs will be ignored.
* '''Type of the table''' – select the type of identifiers in the ID column. Usually it<nowiki>'</nowiki>s detected automatically. It<nowiki>'</nowiki>s very important option as many analyses require tables of the specific type.
* '''Species''' – select the species the data in the table is associated with or "Unspecified" if it<nowiki>'</nowiki>s not associated with any species.

[[Category:File formats]]

@@ Line 2: / Line 2: @@
 :Tabular (*.txt, *.xls, *.tab, etc.)
 ;Element type
-:[[File:Type-table-icon.png]] [[Table (element type)|table]]
+:{{Type link|table}}
 ;Plugin
 :[[Ru.biosoft.table (plugin)|ru.biosoft.table (TableData)]]

@@ Line 1: / Line 1: @@
 ;File format title
 :Tabular (*.txt, *.xls, *.tab, etc.)
 ;Plugin
 :[[Ru.biosoft.table (plugin)|ru.biosoft.table (TableData)]]

← Older revision		Revision as of 07:13, 7 May 2013
Line 1:		Line 1:
		+	;File format title
		+	:Tabular (.txt, .xls, *.tab, etc.)
		+	;Plugin
		+	:[[Ru.biosoft.table (plugin)\|ru.biosoft.table (TableData)]]
		+
	=== Tabular file formats ===		=== Tabular file formats ===

← Older revision		Revision as of 09:28, 4 April 2013
Line 15:		Line 15:

	[[Category:File formats]]		[[Category:File formats]]
		+	[[Category:Autogenerated pages]]