Feature Request: Build File-Sample-Participant Mapping

[chris-s-friedman]

Description

Use the file manifest received from ARCUS of all the submitted files and convert that into a manifest mapping file, sample, and participant. This mapping file should have the following columns:

• genomic_file_id for the file's genomic file ID
• sample_id for the kf_id of the sample associated with the file
• participant_id for the kf_id of the participant associated with the sample

This file should be the same format as the one for CDS.

The generated mapping file should be placed in the data/ directory and the script(s) used to build the manifest should be in the scripts/ directory.

[youngnm]

Created a new PR for the file and SQL here.