gistfile1.txt

{
  "rules": [
    {
      "type": "add_filter_count",
      "count": 1,
      "which": "first",
      "invert": false
    },
    {
      "type": "remove_columns",
      "target_columns": [
        0,
        1,
        2,
        4,
        5,
        7,
        8
      ]
    },
    {
      "type": "add_filter_regex",
      "target_column": 1,
      "expression": ";",
      "invert": false
    },
    {
      "type": "add_column_regex",
      "target_column": 1,
      "expression": "(.*);(.*)",
      "group_count": "2"
    },
    {
      "type": "split_columns",
      "target_columns_0": [
        2
      ],
      "target_columns_1": [
        3
      ]
    },
    {
      "type": "remove_columns",
      "target_columns": [
        1
      ]
    },
    {
      "type": "add_column_regex",
      "target_column": 1,
      "expression": "_([12]).fastq",
      "group_count": 1
    },
    {
      "type": "add_column_regex",
      "target_column": 1,
      "expression": "(.*)",
      "replacement": "ftp://\\1"
    }
  ],
  "mapping": [
    {
      "type": "list_identifiers",
      "columns": [
        0
      ],
      "editing": false
    },
    {
      "type": "paired_identifier",
      "columns": [
        2
      ]
    },
    {
      "type": "url",
      "columns": [
        3
      ]
    }
  ]
}