galaxy_sql_percent_rank
Galaxy · SQL · Tabular dataCalculate each value’s relative rank from zero to one.
Use this operator
operator: galaxy_sql_percent_rank@1.0Configure remote_operator_library_urls with this repository’s origin. XStream verifies and caches artifacts by digest, sharing them across operators.
Named ports
- sourceInputbytes
One TSV bytes stream. Runs a fixed SQLite query over bounded headerless TSV inputs. The key column is text; selected value columns contain finite numbers or NA. A header row labels the result. The header parameter can skip an input header. Named columns are projected in the documented order.
Formats: Any compatible format - resultOutputbytes
TSV bytes. Runs a fixed SQLite query over bounded headerless TSV inputs. The key column is text; selected value columns contain finite numbers or NA. A header row labels the result. The header parameter can skip an input header. Named columns are projected in the documented order.
Output structure and samples are provided by operator inference.
Parameters
- key_columnintegerOptional
One-based key column of each TSV input.
- How to fill
- One-based key column of each TSV input. · Minimum: 1 · Maximum: 256
- Example value
- 1
- Default value
- 1
- value_columnintegerOptional
One-based primary numeric column.
- How to fill
- One-based primary numeric column. · Minimum: 1 · Maximum: 256
- Example value
- 2
- Default value
- 2
- second_columnintegerOptional
One-based optional secondary numeric column; zero supplies NULL.
- How to fill
- One-based optional secondary numeric column; zero supplies NULL. · Minimum: 0 · Maximum: 256
- Example value
- 0
- Default value
- 0
- headerbooleanOptional
Skip the first row of each TSV input.
- How to fill
- Skip the first row of each TSV input.
- Example value
- false
- Default value
- false
Operator usage example
Connect the input ports to upstream steps and adjust the parameters for your data.
id: process
operator: galaxy_sql_percent_rank@1.0
inputs:
source: read_source
params:
key_column: 1
value_column: 2
second_column: 0
header: false
Manual download
curl -fLo 'operator.zip' 'https://repo.conox.cn/v1/blobs/sha256/eeb7a35bd460dfd475700fb037e756a9f6f68e1229da68738ba1b8ce8c0356be/operator.zip'
sha256sum -- 'operator.zip'
curl -fLo 'GALAXY-LICENSE.txt' 'https://repo.conox.cn/v1/blobs/sha256/06276304c423a835d843f55c62288aee7e5d6e474f301fe51a6e78481c39ca5b/GALAXY-LICENSE.txt'
sha256sum -- 'GALAXY-LICENSE.txt'Compare checksums with the manifest. Download execution and build environments from the runtime catalog ↗.
Source and licensing
See Source archive under Artifact details
- Source repository
- https://github.com/galaxyproject/tools-iuc
- Source revision
- a9914e6c25a7aee16191a11c654ea25d72d0017c
- License (publisher declared)
- AFL-3.0 AND MIT
- License text
- Available below
- Dependency SBOM
- Dependency SBOM not provided
Build instructions
Compile src/*.py with the python-arrow@2.0 builder. Execute with the registered python-arrow@2.0 runtime. See upstream-manifest.json and fixtures.json for evidence.
Publisher-provided source, licenses and dependency information support your review. Availability and checksums do not certify safety, legal clearance, or that the executable matches the source.