subsystems_to_spreadsheets

The subsystem_to_spreadsheets command allows the user to output the entire spreadsheet for a set of input subsystems. The input is a table with a column containing subsystem names. The output is a table with 4 appended columns

[Genome,variant-code,role,fid]

Example:

subsystems_to_spreadsheets [arguments] < input > output

The standard input should be a tab-separated table (i.e., each line is a tab-separated set of fields). Normally, the last field in each line would contain the subsystem name. If another column contains the subsystem use

-c N

where N is the column (from 1) that contains the subsystem.

This is a pipe command. The input is taken from the standard input, and the output is to the standard output.

Documentation for underlying call

This script is a wrapper for the CDMI-API call subsystems_to_spreadsheets. It is documented as follows:

$return = $obj->subsystems_to_spreadsheets($subsystems, $genomes)

Parameter and return types

$subsystems is a subsystems
$genomes is a genomes
$return is a reference to a hash where the key is a subsystem and the value is a reference to a hash where the key is a genome and the value is a row
subsystems is a reference to a list where each element is a subsystem
subsystem is a string
genomes is a reference to a list where each element is a genome
genome is a string
row is a reference to a list containing 2 items:
	0: a variant
	1: a reference to a hash where the key is a role and the value is a fids
variant is a string
role is a string
fids is a reference to a list where each element is a fid
fid is a string

Command-Line Options

-c Column

This is used only if the column containing the subsystem is not the last column.

-i InputFile [ use InputFile, rather than stdin ]

Output Format

The standard output is a tab-delimited file. It consists of the input file with 4 extra columns added (Genome,Variant,Role,Fid).

Input lines that cannot be extended are written to stderr.