Please cite this repository in AMP® SCZ papers as:

Billah T, Cho KIK, Nicholas S, Mohandass D, Ennis M, Eichi HR, Bouix S, Baker JT, Accelerating Medicines Partnership® Schizophrenia (AMP® SCZ) Data Processing and Submission Software, https://github.com/AMP-SCZ/utility, 2022, DOI: 10.5281/zenodo.7849718

utility

This repository is the storehouse of all DPdash utility scripts. Currently, it consists of scripts that make DPdash importable files.

Install

Prerequisites are only Python libraries. Install them against Python 3 as:

pip install -r requirements.txt

https://github.com/AMP-SCZ/dpimport and https://github.com/NDAR/nda-tools are two packages used by several programs in this repository. They are put in the requirements.txt too.

Usage

Most scripts' usage can be obtained by ./script.* --help.

Some scripts' usage can be obtained by cat ./script.*.

Only outstanding ones are noted below:

• remove_collections.js

/data/predict/utility/genhash.py /path/to/YAmetadata.csv mriqc > /tmp/mriqc_hashes.txt

mongo --tls --tlsCAFile $state/ssl/ca/cacert.pem --tlsCertificateKeyFile $state/ssl/mongoclient.pem mongodb://dpdash:$MONGOPASS@`hostname`:27017/dpdata?authSource=admin --eval "hashscript=\"/tmp/mriqchashes.txt\"" /data/predict/utility/remove_collections.js

(The back slashes are important: \"/tmp/mriqc_hashes.txt\"

• remove_studies.js

mongo --tls --tlsCAFile $state/ssl/ca/cacert.pem --tlsCertificateKeyFile $state/ssl/mongoclient.pem mongodb://dpdash:$MONGOPASS@`hostname`:27017/dpdata?authSource=admin /data/predict/utility/remove_studies.js

The mechanism for downloading configuration item at server backend is described in this wiki.

Selective PRESCIENT upload, download, shift

1. Populate Prescient/PHOENIX/PROTECTED/rpms_records.txt as:

PrescientCG/raw/CG12345/surveys PrescientME/raw/ME12345/surveys PrescientHK/raw/HK12345/surveys ... ...

1. Set FORCE=1 in utility/_rpms_to_redcap.sh. Execute it as:

rpmstoredcap.sh /data/predict1/datafrom_nda/Prescient/PHOENIX/PROTECTED /data/predict1/utility/yale-real 123456

It will use rpms_records.txt.

1. Clean duplicate arms if needed:

cleanoldarm.py /data/predict1/datafromnda/Prescient/PHOENIX/PROTECTED 123456

1. Download the JSONs. rpms_recods.txt will be used to download selectively.

downmgbredcaprecords.py /data/predict1/datafrom_nda/Prescient/PHOENIX/PROTECTED/ 123456 1 1

1. Shift the dates:

for d in $(cat rpmsrecords.txt); do shiftredcapdates.py /data/predict1/datafromnda/Prescient/PHOENIX/PROTECTED/ "$d/*.Prescient.json" /data/predict1/utility/yale-real/CloneOfYaleRealRecordsDataDictionary_2024-04-16.csv 1 1; done

Steps 3-5 basically imitates utility/clean_down_shift.sh but with the trailing 1 meant for force re-download and re-shift.