ParseDb.py¶
Parses tab delimited database files
usage: ParseDb.py [--version] [-h] ...
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
- output files:
- sequences
FASTA formatted sequences output from the subcommands fasta and clip.
- <field>-<value>
database files partitioned by annotation <field> and <value>.
- parse-<command>
output of the database modification functions where <command> is one of the subcommands add, index, drop, delete, rename, select, sort or update.
- required fields:
sequence_id
ParseDb.py add¶
Adds field and value pairs.
usage: ParseDb.py add [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELDS [FIELDS ...] -u VALUES
[VALUES ...]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<fields>
¶ The name of the fields to add.
-
-u
<values>
¶ The value to assign to all rows for each field.
ParseDb.py delete¶
Deletes specific records.
usage: ParseDb.py delete [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELDS [FIELDS ...]
[-u VALUES [VALUES ...]] [--logic {any,all}]
[--regex]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<fields>
¶ The name of the fields to check for deletion criteria.
-
-u
<values>
¶ The values defining which records to delete. A value may appear in any of the fields specified with -f.
-
--logic
{any,all}
¶ Defines whether a value may appear in any field (any) or whether it must appear in all fields (all).
-
--regex
¶
If specified, treat values as regular expressions and allow partial string matches.
ParseDb.py drop¶
Deletes entire fields.
usage: ParseDb.py drop [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELDS [FIELDS ...]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<fields>
¶ The name of the fields to delete from the database.
ParseDb.py index¶
Adds a numeric index field.
usage: ParseDb.py index [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] [-f FIELD]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<field>
¶ The name of the index field to add to the database.
ParseDb.py merge¶
Merges files.
usage: ParseDb.py merge [--version] [-h] -d DB_FILES [DB_FILES ...]
[--outdir OUT_DIR] [--outname OUT_NAME] [-o OUT_FILE]
[--drop]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-o
<out_file>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir or –outname arguments.
-
--drop
¶
If specified, drop fields that do not exist in all input files. Otherwise, include all columns in all files and fill missing data with empty strings.
ParseDb.py rename¶
Renames fields.
usage: ParseDb.py rename [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELDS [FIELDS ...] -k NAMES
[NAMES ...]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<fields>
¶ List of fields to rename.
-
-k
<names>
¶ List of new names for each field.
ParseDb.py select¶
Selects specific records.
usage: ParseDb.py select [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELDS [FIELDS ...] -u VALUES
[VALUES ...] [--logic {any,all}] [--regex]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<fields>
¶ The name of the fields to check for selection criteria.
-
-u
<values>
¶ The values defining with records to select. A value may appear in any of the fields specified with -f.
-
--logic
{any,all}
¶ Defines whether a value may appear in any field (any) or whether it must appear in all fields (all).
-
--regex
¶
If specified, treat values as regular expressions and allow partial string matches.
ParseDb.py sort¶
Sorts records by field values.
usage: ParseDb.py sort [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELD [--num] [--descend]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<field>
¶ The annotation field by which to sort records.
-
--num
¶
Specify to define the sort column as numeric rather than textual.
-
--descend
¶
If specified, sort records in descending, rather than ascending, order by values in the target field.
ParseDb.py split¶
Splits database files by field values
usage: ParseDb.py split [--version] [-h] -d DB_FILES [DB_FILES ...]
[--outdir OUT_DIR] [--outname OUT_NAME] -f FIELD
[--num NUM_SPLIT]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<field>
¶ Annotation field by which to split database files.
-
--num
<num_split>
¶ Specify to define the field as numeric and group records by whether they are less than or at least (greater than or equal to) the specified value.
ParseDb.py update¶
Updates field and value pairs.
usage: ParseDb.py update [--version] [-h] -d DB_FILES [DB_FILES ...]
[-o OUT_FILES [OUT_FILES ...]] [--outdir OUT_DIR]
[--outname OUT_NAME] -f FIELD -u VALUES [VALUES ...]
-t UPDATES [UPDATES ...]
-
--version
¶
show program’s version number and exit
-
-h
,
--help
¶
show this help message and exit
-
-d
<db_files>
¶ A list of tab delimited database files.
-
-o
<out_files>
¶ Explicit output file name. Note, this argument cannot be used with the –failed, –outdir, or –outname arguments. If unspecified, then the output filename will be based on the input filename(s).
-
--outdir
<out_dir>
¶ Specify to changes the output directory to the location specified. The input file directory is used if this is not specified.
-
--outname
<out_name>
¶ Changes the prefix of the successfully processed output file to the string specified. May not be specified with multiple input files.
-
-f
<field>
¶ The name of the field to update.
-
-u
<values>
¶ The values that will be replaced.
-
-t
<updates>
¶ The new value to assign to each selected row.