| Table of Contents |
|---|
...
To access this count table:
Go to the W:\training\rnaseq\runs\run3_RNAseq\results folder that contains the results from running the nfcore/rnaseq pipeline. The output folders from task 3 look like this:
...
The count table can be found in the star_salmon folder. A list of files and folders in the star_salmon folder will look like this:
...
a. First create a new folder in H:\workshop\RNAseq . Call it something suitable, such as ‘DE_analysis_workshop’
...
The count table looks like this:
| Code Block |
|---|
gene_id gene_name SRR20622172 SRR20622173 SRR20622174 SRR20622175 SRR20622176 SRR20622177 SRR20622178 SRR20622179 SRR20622180 ENSMUSG00000000001 Gnai3 7086 4470 2457.002 2389 6398 2744 2681 3961 4399 ENSMUSG00000000003 Pbsn 0 0 0 0 0 0 0 0 0 CD49fmNGFRm_rep1 CD49fmNGFRm_rep2 CD49fmNGFRm_rep3 CD49fpNGFRp_rep1 CD49fpNGFRp_rep2 CD49fpNGFRp_rep3 MTEC_rep1 MTEC_rep2 MTEC_rep3 ENSMUSG00000000001 Gnai3 2460 2395 2749 2686 3972 4419 7095 4484 6414 ENSMUSG00000000003 Pbsn 0 0 0 0 0 0 0 0 0 ENSMUSG00000000028 Cdc45 43 57 55 79 87.999 89 1241 830 1041.999 ENSMUSG00000000031 H19 2 0 1 17.082 24 16.077 200 139 145.604 ENSMUSG00000000037 Scml2 8 8 16 23 29.001 29 69 57 67 ENSMUSG00000000049 Apoh 1 0 2 1 2 0 0 0 2ENSMUSG00000000028 Cdc45 1232.999 827 42 57 1036 55 78 88 89 ENSMUSG00000000031 H19 200 139 2 0 143.622 1 17.082 24 16.077 ENSMUSG00000000037 Scml2 70 57.001 8 8 66.999 16 23 27.999 29 ENSMUSG00000000049 Apoh 0 0 1 0 2 2 1 3 0 ENSMUSG00000000056 Narf 1933 1480 519 497 1730 539 365 458 536 ENSMUSG00000000058 Cav2 6008 3417 1347.001 1344 5482 1367 2669.001 4358 4365.832 ENSMUSG00000000078 Klf6 3809 2732 4413.001 3483.978 3559 4491 3209 3980 4626 |
d. In Excel, create a samples table. Open a blank Excel document and copy and paste the sample metadata below. This samples table needs 3 columns called ‘sample_name’, containing the sample names seen in the count table (column names), ‘sample_ID’, which is the (less messy) names you want to call the samples in this analysis workflow, and ‘group’, which contains the treatment groups each sample belongs to.
...
| Code Block |
|---|
sample_name sample_ID group CD49fmNGFRm_rep1SRR20622174 DC1 Differentiated_cells CD49fmNGFRm_rep2SRR20622175 DC2 Differentiated_cells CD49fmNGFRm_rep3SRR20622177 DC3 Differentiated_cells CD49fpNGFRp_rep1SRR20622178 BC1 Basal_cells CD49fpNGFRp_rep2SRR20622179 BC2 Basal_cells CD49fpNGFRp_rep3SRR20622180 BC3 Basal_cells MTEC_rep1SRR20622172 mTEC1 Murine_tracheal_epithelial_cell MTEC_rep2SRR20622173 mTEC2 Murine_tracheal_epithelial_cell MTEC_rep3SRR20622176 mTEC3 Murine_tracheal_epithelial_cell |
...