FCSLOG

This wiki page contains the following contents:

1. Description
2. Features
3. Input File Rules
4. Automatic FCS and Index Primer Organisation
5. Merge Mechanism
6. Frontend Design

Description

FCSLOG is the official name of the 2023 SM2 intake's implementation of the web application outlined in the Problem Space wiki page. The codebase can be found within the fcs-log directory.

This web application is capable of merging FCS files with their corresponding Index Primer spreadsheets to produce an Flow Cytometry Experiment spreadsheet. The Experiment spreadsheet is used during the Sequencing and demultiplexing steps. See the CEL-Seq2 workflow diagram for more information.

To view this intake's presentation, click here.

Features

• Outputs a Flow Cytometry Experiment Spreadsheet within a minute
• Automatically records the FCS and Index Primer files used to make the Experiment spreadsheet
• Preview functionality for exporting files

Architecture Overview

Input File Rules

• Requires at least 1 FCS file along with 1 corresponding Index Primer file
• FCS files:
  • Naming Convention: FCS_LC(Plate Number).fcs
  • Example: FCS_LC370.fcs
• Index Primer files:
  • Naming Convention: LC(Plate Number)_Primer.xlsx
  • Example: LC370_Primer.xlsx
• NOTE: The corresponding file of FCS_LC370.fcs is LC370_Primer.xlsx as they share the same plate number
• The merging mechanism relies on string comparison to know which files to pair and merge together

Automatic FCS and Index Primer Organisation

After the merge process, the web application will sort the constituent files into an Index Primer or FCS directory, as seen below:

Merge Mechanism

The merge mechanism is what is responsible for collating the FCS and Index Primer files together to produce the experiment spreadsheet.

The merge process has 2 steps:

1. Merge by Column: merges the corresponding FCS & Index Primer files together
2. Merge by Row: merges the resultant files from step 1 to produce the Experiment spreadsheet

The merge mechanism had 2 backend designs. The 2nd design is currently used.

Design 1

Initially, the approach involved using fcsparser to extract data from raw FCS files for merging into an Excel sheet. However, this method's limitations became apparent when comparing its output with FlowJo's analytical results.

Drawback: This design fell short as FlowJo not only parses but also analyses data, affecting the integrity of information derived from raw FCS files. Consequently, it was determined that input files should be pre-processed through FlowJo and exported as CSV files for merging.

Design 2

Adopting a refined approach, users now input Excel (.xlsx) files already analyzed by FlowJo into our generator. This method ensures the merged CSV file retains the analytical accuracy and detail necessary for subsequent research phases.

Differences between FlowJo & fcsparser

• Data Transformations: fluorescent values may be manipulated differently
• Compensation Function: used to correct for spectral overlap between fluorochromes in flow cytometry data; functions might be different between both software
• FlowJo Plugins: plugins such as FlowClean can omit or manipulate data

Frontend Designs

The frontend was designed via wireframes. The website has a total of 5 pages being the Home, Tutorial, Generator and Contact pages. The wireframe designs can be downloaded here.