Operator catalog

More tags45

All operators

Showing 441–480 of 500
OperatorVersionsExecutorTrustDownloadsActions
galaxy_sql_group_centerAuthor dacp-examplesGalaxy · SQL · Tabular data

Subtract each group mean from its rows.

python13.0 KiB3
galaxy_sql_group_fractionAuthor dacp-examplesGalaxy · SQL · Tabular data

Measure each value’s share of its group total.

python13.0 KiB3
galaxy_sql_group_spreadAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the range between each key’s maximum and minimum.

python13.0 KiB3
galaxy_sql_inner_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Return rows with matching keys in both TSV streams.

python13.0 KiB3
galaxy_sql_key_differenceAuthor dacp-examplesGalaxy · SQL · Tabular data

Return distinct source keys missing from the reference stream.

python13.0 KiB3
galaxy_sql_key_intersectionAuthor dacp-examplesGalaxy · SQL · Tabular data

Return distinct keys shared by two TSV streams.

python13.0 KiB3
galaxy_sql_key_row_numberAuthor dacp-examplesGalaxy · SQL · Tabular data

Number rows starting at one inside each key partition.

python13.0 KiB3
galaxy_sql_key_unionAuthor dacp-examplesGalaxy · SQL · Tabular data

Return the distinct keys from either TSV stream.

python13.0 KiB3
galaxy_sql_largest_nAuthor dacp-examplesGalaxy · SQL · Tabular data

Return the rows with the largest values.

python13.1 KiB3
galaxy_sql_last_per_keyAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep the last observed value of each key.

python13.0 KiB3
galaxy_sql_left_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep all source rows and matching reference values.

python13.0 KiB3
galaxy_sql_matched_relative_changeAuthor dacp-examplesGalaxy · SQL · Tabular data

Report relative numeric change against the reference value for matched keys.

python13.1 KiB3
galaxy_sql_matched_value_differenceAuthor dacp-examplesGalaxy · SQL · Tabular data

Subtract the reference value from the source value for each matched key.

python13.1 KiB3
galaxy_sql_missing_valuesAuthor dacp-examplesGalaxy · SQL · Tabular data

List rows that have missing numeric data.

python13.0 KiB3
galaxy_sql_order_key_then_valueAuthor dacp-examplesGalaxy · SQL · Tabular data

Order rows by key and descending numeric value.

python13.0 KiB3
galaxy_sql_pair_dot_productAuthor dacp-examplesGalaxy · SQL · Tabular data

Sum the row-wise products of two numeric columns.

python13.0 KiB3
galaxy_sql_percent_rankAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate each value’s relative rank from zero to one.

python13.0 KiB3
galaxy_sql_quantile_bucketsAuthor dacp-examplesGalaxy · SQL · Tabular data

Assign rows to approximately equal-sized ordered buckets.

python13.1 KiB3
galaxy_sql_rankAuthor dacp-examplesGalaxy · SQL · Tabular data

Rank values with gaps after ties.

python13.0 KiB5
galaxy_sql_row_ratioAuthor dacp-examplesGalaxy · SQL · Tabular data

Divide two numeric columns row by row.

python13.0 KiB3
galaxy_sql_running_averageAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the cumulative average in input order.

python13.0 KiB3
galaxy_sql_running_totalAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the cumulative sum in input order.

python13.0 KiB3
galaxy_sql_semi_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep source rows with a matching reference key without duplicating matches.

python13.0 KiB3
galaxy_sql_singleton_keysAuthor dacp-examplesGalaxy · SQL · Tabular data

Return rows whose key appears exactly once.

python13.0 KiB3
galaxy_sql_smallest_nAuthor dacp-examplesGalaxy · SQL · Tabular data

Return the rows with the smallest values.

python13.1 KiB3
galaxy_sql_unique_pairsAuthor dacp-examplesGalaxy · SQL · Tabular data

Retain one row per distinct key and value pair.

python13.0 KiB3
galaxy_sql_weighted_averageAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate a weighted mean using the second numeric column.

python13.0 KiB3
galaxy_statistical_hypothesis_testingAuthor dacp-examplesGalaxy · Statistics · Data analysis

Perform a two-sided one-sample Student t test.

jvm803.1 KiB2
galaxy_summary_statisticsAuthor dacp-examplesGalaxy · Tabular data · Statistics

Report summary statistics and quartiles for a tabular column.

jvm835.9 KiB4
galaxy_table_computeAuthor dacp-examplesGalaxy · Tabular data

Apply a numeric function to one tabular column.

jvm835.9 KiB4
galaxy_table_to_geojsonAuthor dacp-examplesGalaxy · Tabular data · Geospatial

Convert WGS 84 table rows into GeoJSON Point features.

jvm836.0 KiB3
galaxy_tabular_to_fastaAuthor dacp-examplesGalaxy · FASTA · Bioinformatics

Convert tab-separated title and sequence columns to FASTA entries; skip rows missing selected fields.

jvm67.7 KiB4
galaxy_tabular_to_fastqAuthor dacp-examplesGalaxy · FASTQ · Bioinformatics

Build validated FASTQ records from selected TSV columns.

jvm383.7 KiB2
galaxy_tailAuthor dacp-examplesGalaxy · Text processing · Tabular data

Return the last N text lines with a bounded rolling buffer, preserving original line endings.

jvm51.0 KiB3
galaxy_translateAuthor dacp-examplesGalaxy · Bioinformatics

Translate nucleotide FASTA to protein FASTA with the standard genetic code.

jvm208.5 KiB3
galaxy_transpose_tableAuthor dacp-examplesGalaxy · Tabular data · Analysis

Transpose a rectangular TSV matrix.

jvm383.5 KiB3
galaxy_trimAuthor dacp-examplesGalaxy · Text processing · Tabular data

Trim whole text lines or one tab-separated column using one-based inclusive character positions.

jvm87.6 KiB3
galaxy_unfold_columnAuthor dacp-examplesGalaxy · Text processing · Tabular data

Expand a delimited list in one tab-separated field into multiple rows.

jvm208.5 KiB2
galaxy_unique_consecutiveAuthor dacp-examplesGalaxy · Text processing · Tabular data

Collapse adjacent equal text records, optionally counting or selecting duplicate groups.

jvm208.6 KiB2
galaxy_unique_linesAuthor dacp-examplesGalaxy · Text processing · Tabular data

Sort text lines and retain one occurrence of each comparison key.

jvm208.6 KiB2