This will be a 2 task process, both involving writing python scripts.

This task is step 1: Adding a SolyID to a salmon counts table using our BLAT results from many steps ago.

We run this script repeatedly, one for each plant variety.

1. We need the Blat result fna file where we have a blatted the rna=spades contigs to SL5.
That can be found in this location:
/projects/tomato_genome/fnb/dataprocessing/brandon_work/mal/malintka-spades/spades_blat/blat-SL5-CDS-malintka-bestLongHit.fna

We read this file into a dict with the NODE id as the key and the SolyID as the value pair.

2. We need the salmon gene count file for the same variety:
/projects/tomato_genome/fnb/dataprocessing/brandon_work/NEXTFLOW/start_fresh/Mal-run-2/results-3.14.0/star_salmon/salmon.merged.gene_counts.tsv

The first column in the table is the NodeID, we ignore the 2nd column and then we keep all of the remaining column of read counts.
We read a line, parse it, we check if the ID in 1st column is in our dict from above.
If so, we write out a line using the SolyID as the first column and then write out all of the remaining fields!

In the end we write out a table, each row has a solyID and all of the gene counts.

We then repeat this script but point at new plant variety (aka MAL, etc).
After that we move to next phase of merging the 4 tables into 1 (new ticket that is not yet created)!!!

Completed the Python script, and added solyIDs back to the de novo results. I am moving the ticket to first-level review. I want to make sure the files are in the format we are looking for, if so, we can close this and move on to the next step.

Results are located in: /projects/tomato_genome/fnb/dataprocessing/brandon_work/NEXTFLOW/result_processing/counts_with_solID
The script is located in: /projects/tomato_genome/fnb/dataprocessing/brandon_work/NEXTFLOW/result_processing/add_soly_back.py

In the script add_soly_back.py, it looks logically correct.

Our data going into the script is off however!

/projects/tomato_genome/fnb/dataprocessing/brandon_work/NEXTFLOW/result_processing/counts_with_solID$ for file in *.tsv; do wc -l $file; done
7842 all_counts_with_solID_denovo.tsv
7842 all_counts_with_solID.tsv
25080 Hei_counts_with_solID.tsv
25092 Mal_counts_with_solID.tsv
11112 Nag_counts_with_solID.tsv
25616 Tam_counts_with_solID.tsv

First check why Nag does not have the same number as the other 3 varieties. This might become a new ticket.
Do we need to rerun Nextflow or did something not copy correctly?

Start with Nag NETFLOW results and make sure that salmon count folder has the same size files as the other varieties.

The Nag NEXTFLOW results have the same size as the Nag_counts_with_solID.tsv file, so it copied correctly. The pipeline was also completed without error.

Reran Nag. Again, the pipeline was completed without error, but the resulting gene counts file still only has 11,112 lines.
Results are found in: /projects/tomato_genome/fnb/dataprocessing/brandon_work/NEXTFLOW/start_fresh/test_Nag/results-3.14.0/star_salmon

This is now held up by the RNa-Spades run task (Fall 2 epic board)

This remains as a To do for now. I can't find the ticket ID that blocks this.

This is blocked by 3901. I am not quite sure how to tag this as blocked within Jira. I only see that option when setting up a ticket / task for the first time.

Added soly IDs to all NEXTFLOW results. Moving this to done. Results are found in:
/projects/tomato_genome/fnb/dataprocessing/brandon_work/NEXTFLOW/result_processing/counts_with_solID