OPERATOR / VERSION 1.0

galaxy_sql_filter_key_prefix

Galaxy · SQL · Tabular data

Filter rows by a literal prefix of the key.

View manifest JSON ↗

Use this operator

operator: galaxy_sql_filter_key_prefix@1.0

Configure 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
  • prefixstringOptional

    Literal prefix.

    How to fill
    Literal prefix. · Maximum length: 64
    Example value
    b
    Default value
    b

Operator usage example

Connect the input ports to upstream steps and adjust the parameters for your data.

id: process
operator: galaxy_sql_filter_key_prefix@1.0
inputs:
  source: read_source
params:
  key_column: 1
  value_column: 2
  second_column: 0
  header: false
  prefix: b

Manual download

curl -fLo 'operator.zip' 'https://repo.conox.cn/v1/blobs/sha256/f43cdec5aa4fc9bd7b54fa77242a10287ba6be0aa484cf215b525370cbd32611/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.