{"api_version":2,"name":"galaxy_sql_cumulative_distribution","version":"1.0","role":"transform","type":"sdk","description":"Calculate the cumulative fraction at or below each value.","icon":{"path":"M4 3h12l4 4v14H4zM8 11h8M8 15h8m-8 4h5"},"inputs":{"source":{"representations":["bytes"],"formats":[]}},"outputs":{"result":{"view":"bytes"}},"parameters":{"type":"object","properties":{"key_column":{"type":"integer","default":1,"minimum":1,"maximum":256,"description":"One-based key column of each TSV input."},"value_column":{"type":"integer","default":2,"minimum":1,"maximum":256,"description":"One-based primary numeric column."},"second_column":{"type":"integer","default":0,"minimum":0,"maximum":256,"description":"One-based optional secondary numeric column; zero supplies NULL."},"header":{"type":"boolean","default":false,"description":"Skip the first row of each TSV input."}},"additionalProperties":false,"required":[]},"documentation":{"inputs":{"source":"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."},"outputs":{"result":"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."},"parameters":{"key_column":{"description":"One-based key column of each TSV input.","help":"One-based key column of each TSV input.","example":1},"value_column":{"description":"One-based primary numeric column.","help":"One-based primary numeric column.","example":2},"second_column":{"description":"One-based optional secondary numeric column; zero supplies NULL.","help":"One-based optional secondary numeric column; zero supplies NULL.","example":0},"header":{"description":"Skip the first row of each TSV input.","help":"Skip the first row of each TSV input.","example":false}},"example_job":"name: Calculate the cumulative fraction at or below each value.\nsteps:\n- id: read_source\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/galaxy/sql_cumulative_distribution-source.tsv\n    view: bytes\n- id: process\n  operator: galaxy_sql_cumulative_distribution@1.0\n  inputs:\n    source: read_source\n  params:\n    key_column: 1\n    value_column: 2\n    second_column: 0\n    header: false\n- id: client_sink\n  operator: client_sink@1.0\n  inputs:\n    result: process\n"},"execution":{"executor":"python","entrypoint":"galaxy_sql_cumulative_distribution","config":{}},"source_public":true,"runtime":{"image":"sha256:40db7fee594f1452790d1cc99c2e5429e187eb64633c716b8c6f903c47576975","archive":{"sha256":"e1844833e35390f2eaf9fc9ec7b67057ad0305ad713c0da6c8b055980a66946c","size":73825792,"filename":"python-arrow-2.0-runtime.tar"}},"provenance":{"source_archive":{"sha256":"df0c80d7b70a78784da8c5709ac4964399546faffae4b2e7169af4a16926899c","size":35693,"filename":"galaxy_sql_cumulative_distribution-sources.zip"},"source_repository":"https://github.com/galaxyproject/tools-iuc","source_revision":"a9914e6c25a7aee16191a11c654ea25d72d0017c","license":"AFL-3.0 AND MIT","license_file":{"sha256":"06276304c423a835d843f55c62288aee7e5d6e474f301fe51a6e78481c39ca5b","size":1077,"filename":"GALAXY-LICENSE.txt"},"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."},"artifact":{"sha256":"06f9f84ac465eaf2efe6cd169306e994104d5270d8d62b5a545b5f3a9294f68c","size":13350,"filename":"operator.zip"},"categories":["Galaxy","SQL","Tabular data"],"trust":{"score":4,"assessed_by":"administrator","reviewed_at_ms":1795075853922},"publication":{"author":"dacp-examples","submitted_at_ms":1795075848094,"approved_at_ms":1795075853922,"last_submitted_at_ms":1795075848094,"last_approved_at_ms":1795075853922},"download_count":3}