1-DAV-202 Data Management 2023/24
Previously 2-INF-185 Data Source Integration

Materials · Introduction · Rules · Contact
· Grades from marked homeworks are on the server in file /grades/userid.txt
· Dates of project submission and oral exams:
Early: submit project May 24 9:00am, oral exams May 27 1:00pm (limit 5 students).
Otherwise submit project June 11, 9:00am, oral exams June 18 and 21 (estimated 9:00am-1:00pm, schedule will be published before exam).
Sign up for one the exam days in AIS before June 11.
Remedial exams will take place in the last week of the exam period. Beware, there will not be much time to prepare a better project. Projects should be submitted as homeworks to /submit/project.
· Cloud homework is due on May 20 9:00am.


Difference between revisions of "HWperl"

From MAD
Jump to navigation Jump to search
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<!-- NOTEX -->
 
<!-- NOTEX -->
Materials: [[Lperl|the lecture]], [[Connecting from Windows]], [[Editors]]
+
'''Materials:''' [[Lperl|the lecture]], [[Connecting to server]], [[Editors]]
 
<!-- /NOTEX -->
 
<!-- /NOTEX -->
  
Line 10: Line 10:
 
</syntaxhighlight>
 
</syntaxhighlight>
  
The folder <tt>/tasks/perl/</tt> contains input files, an example script working with FASTQ files and correct outputs for some of your scripts below on the tiny data, see further details below.
+
The folder <tt>/tasks/perl/</tt> contains input files, an example script working with FASTQ files and correct outputs for some of your scripts; see further details below. In this first homework we will provide almost all commands you need to run.
  
  
 
<!-- NOTEX -->
 
<!-- NOTEX -->
We recommend writing your protocol starting from an outline provided in  <tt>/tasks/perl/protocol.txt</tt>. Make your own copy of the protocol and open it in an editor, e.g. kate:
+
Write your protocol starting from an outline provided in  <tt>/tasks/perl/protocol.txt</tt>. Make your own copy of the protocol and open it in an editor, e.g. kate:
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
cp -ip /tasks/perl/protocol.txt . # copy protocol
+
cp -i /tasks/perl/protocol.txt .   # copy protocol
 
kate protocol.txt &                # open editor, run in the background
 
kate protocol.txt &                # open editor, run in the background
 
</syntaxhighlight>
 
</syntaxhighlight>
Line 24: Line 24:
 
* Copy the required files to this directory, including the protocol named <tt>protocol.txt</tt>
 
* Copy the required files to this directory, including the protocol named <tt>protocol.txt</tt>
 
* You can modify these files freely until deadline, but after the deadline of the homework, you will lose access rights to this directory
 
* You can modify these files freely until deadline, but after the deadline of the homework, you will lose access rights to this directory
 +
* Here is an example of the commands you can use for submitting and checking submitted files. Change it to include your username
 +
<syntaxhighlight lang="bash">
 +
# protocol
 +
cp -ipv protocol.txt /submit/perl/your_username
 +
# tasks A,B
 +
cp -ipv series-stats.pl series-stats.txt fastq2fasta.pl reads-small.fasta reads-tiny.fasta /submit/perl/your_username
 +
# tasks C, D
 +
cp -ipv fastq-quality.pl reads-qualities.tsv fastq-trim.pl reads-small-trim.fastq reads-trim-qualities.tsv /submit/perl/your_username
 +
# check what was submitted
 +
ls -l /submit/perl/your_username
 +
</syntaxhighlight>
 
<!-- /NOTEX -->
 
<!-- /NOTEX -->
  
 
===Task A (series)===
 
===Task A (series)===
  
Consider the program for counting series in the [[Lperl#A_sample_Perl_program|lecture 1]], save it to file <tt>series-stat.pl</tt>
+
'''Running the script from the lecture'''
* Open editor running in the background: <tt>kate series-stat.pl &</tt>
+
* Consider the program for counting series in the [[Lperl#A_sample_Perl_program|lecture 1]], save it to file <tt>series-stats.pl</tt>
 +
* Open editor running in the background: <tt>kate series-stats.pl &</tt>
 
* Copy and paste text to the editor, save it  
 
* Copy and paste text to the editor, save it  
* Make the script executable: <tt>chmod a+x series-stat.pl</tt>
+
* Make the script executable: <tt>chmod a+x series-stats.pl</tt>
* Try running it on the small input: <tt>./series-stat.pl < /tasks/perl/series-small.tsv</tt>
+
* Try running it on the small input: <tt>./series-stats.pl < /tasks/perl/series-small.tsv</tt>
 
* You should get the following output:
 
* You should get the following output:
 
<pre>
 
<pre>
Line 39: Line 51:
 
</pre>
 
</pre>
  
We have 5 input files for this task set:
+
'''Extending the script'''
* <tt>/tasks/perl/series-small.tsv</tt> a small version of the series file
+
* Extend the script to compute the average rating of each series (averaging over all episodes in the series)
* <tt>/tasks/perl/series.tsv</tt> the full version of the series file
 
* <tt>/tasks/perl/reads-tiny.fastq</tt> a tiny version of the read file, including some corner cases
 
* <tt>/tasks/perl/reads-small.fastq</tt> a small version of the read file
 
* <tt>/tasks/perl/reads.fastq</tt> a bigger version of the read file
 
 
 
 
 
'''Extend''' the script to compute the average rating of each series (averaging over all episodes in the series)
 
 
* Each row of the input table contains rating in column 5.  
 
* Each row of the input table contains rating in column 5.  
 
* Output a table with three columns: name of series, the number of episodes, the average rating.
 
* Output a table with three columns: name of series, the number of episodes, the average rating.
 
* Use <tt>[http://perldoc.perl.org/functions/printf.html printf]</tt> to print these three items right-justified in columns of a sufficient width; print the average rating to 1 decimal place.
 
* Use <tt>[http://perldoc.perl.org/functions/printf.html printf]</tt> to print these three items right-justified in columns of a sufficient width; print the average rating to 1 decimal place.
 +
 +
'''Running the script'''
 
* If you run your script on the small file, the output should look something like this (the exact column widths may differ):
 
* If you run your script on the small file, the output should look something like this (the exact column widths may differ):
 
<pre>
 
<pre>
./series-stat.pl < /tasks/perl/series-small.tsv
+
./series-stats.pl < /tasks/perl/series-small.tsv
 
         Black Mirror        3        8.2
 
         Black Mirror        3        8.2
 
     Game of Thrones        3        8.8
 
     Game of Thrones        3        8.8
 
</pre>
 
</pre>
* Run your script also on the large file: <tt>./series-stat.pl < /tasks/perl/series.tsv > taskA-out.txt</tt>
+
* Run your script also on the large file: <tt>./series-stats.pl < /tasks/perl/series.tsv > series-stats.txt</tt>
* Check the output, e.g. by running <tt>cat taskA-out.txt</tt>
+
* Check the output, e.g. by running <tt>cat series-stats.txt</tt>
 +
 
 
<!-- NOTEX -->
 
<!-- NOTEX -->
* '''Submit''' your script, <tt>series-stat.pl</tt> and the output <tt>taskA-out.txt</tt>
+
'''Submitting'''
 +
* Submit your script <tt>series-stats.pl</tt> and the output <tt>series-stats.txt</tt>
 
<!-- /NOTEX -->
 
<!-- /NOTEX -->
  
Line 68: Line 77:
 
* In the rest of the assignment, we will write several scripts for working with [[Lperl#The_second_input_file_for_today:_DNA_sequencing_reads_.28fastq.29|FASTQ files]] introduced in the lecture. Similar scripts are often used by bioinformaticians working with DNA sequencing data.
 
* In the rest of the assignment, we will write several scripts for working with [[Lperl#The_second_input_file_for_today:_DNA_sequencing_reads_.28fastq.29|FASTQ files]] introduced in the lecture. Similar scripts are often used by bioinformaticians working with DNA sequencing data.
 
* We will work with three input files:
 
* We will work with three input files:
** /tasks/perl/reads-tiny.fastq a tiny version of the read file, including some corner cases
+
** <tt>/tasks/perl/reads-tiny.fastq</tt> a tiny version of the read file, including some corner cases
** /tasks/perl/reads-small.fastq a small version of the read file
+
** <tt>/tasks/perl/reads-small.fastq</tt> a small version of the read file
** /tasks/perl/reads.fastq a bigger version of the read file
+
** <tt>/tasks/perl/reads.fastq</tt> a bigger version of the read file
  
 
'''Goal'''
 
'''Goal'''
Line 76: Line 85:
 
** FASTQ file should be on standard input, FASTA file written to standard output
 
** FASTQ file should be on standard input, FASTA file written to standard output
 
* [https://en.wikipedia.org/wiki/FASTA_format FASTA format] is a typical format for storing DNA and protein sequences.  
 
* [https://en.wikipedia.org/wiki/FASTA_format FASTA format] is a typical format for storing DNA and protein sequences.  
** Each sequence consists of several lines of the file. The first line starts with ">" followed by identifier of the sequence and optionally some further description separated by whitespace
+
** Each sequence consists of several lines of the file. The first line starts with ">" followed by identifier of the sequence and optionally some further description separated by whitespace.
** The sequence itself is on the second line, long sequences can be split into multiple lines
+
** The sequence itself is on the second line, long sequences can be split into multiple lines.
* In our case, the name of the sequence will be the ID of the read with the initial <tt>@</tt> replaced by <tt>></tt> and each <tt>/</tt> replaced by (<tt>_</tt>)  
+
* In our case, the name of the sequence will be the ID of the read with the initial <tt>@</tt> replaced by <tt>></tt> and each <tt>/</tt> replaced by (<tt>_</tt>).
** you can try to use [http://perldoc.perl.org/perlop.html#Quote-Like-Operators <tt>tr</tt> or <tt>s</tt> operators] (see also the [[Lperl#Regular_expressions|lecture]])
+
** You can try to use [http://perldoc.perl.org/perlop.html#Quote-Like-Operators <tt>tr</tt> or <tt>s</tt> regular expression operators] (see also the [[Lperl#Regular_expressions|lecture]])
 
* For example, the first two reads of the file <tt>/tasks/perl/reads.fastq</tt> are as follows (only the first 50 columns shown)
 
* For example, the first two reads of the file <tt>/tasks/perl/reads.fastq</tt> are as follows (only the first 50 columns shown)
 
<pre>
 
<pre>
Line 98: Line 107:
 
TAGCGTTGTAAAATAAATTTCTAGAATGGAAGTGATGATATTGAAATACAC...
 
TAGCGTTGTAAAATAAATTTCTAGAATGGAAGTGATGATATTGAAATACAC...
 
</pre>
 
</pre>
* You can start by modifying our script <tt>/tasks/perl/fastq-lengths.pl</tt>, which prints the length of each read in the FASTQ input file.
+
 
 +
'''Start programming'''
 +
* You can start by modifying our script <tt>/tasks/perl/fastq-lengths.pl</tt>, which prints the length of each read in the FASTQ input file. You can use the following commands to start:
 
<pre>
 
<pre>
 
# copy our script to your folder under the new name
 
# copy our script to your folder under the new name
 
cp -i /tasks/perl/fastq-lengths.pl fastq2fasta.pl
 
cp -i /tasks/perl/fastq-lengths.pl fastq2fasta.pl
# open in editor in bacground
+
# open in editor in background
 
kate fastq2fasta.pl &  
 
kate fastq2fasta.pl &  
 
</pre>
 
</pre>
  
 
'''Running the script'''
 
'''Running the script'''
* Run your script on the tiny file, compare with precomputed answer:
+
* Run your script on the tiny file, compare with our precomputed correct answer:
 
<pre>
 
<pre>
./fastq2fasta.pl < /tasks/perl/reads-tiny.fastq > taskB-out1.txt
+
./fastq2fasta.pl < /tasks/perl/reads-tiny.fastq > reads-tiny.fasta
diff taskB-out1.txt /tasks/perl/taskB-out1.txt
+
diff reads-tiny.fasta /tasks/perl/reads-tiny.fasta
 
</pre>
 
</pre>
* Command <tt>diff</tt> prints differences between files, here the output should be empty. Otherwise try to look at the input and putput files and fix your program to obtain the same output as we have.
+
* Command <tt>diff</tt> prints differences between files. Here the output of <tt>diff</tt> should be empty. Otherwise try to look at the input and output files and fix your program to obtain the same output as we have.
  
* Run your script on the small read file  
+
* Also run your script on the small read file  
 
<pre>
 
<pre>
./fastq2fasta.pl < /tasks/perl/reads-small.fastq > reads-small.fasta</tt>
+
./fastq2fasta.pl < /tasks/perl/reads-small.fastq > reads-small.fasta
 
</pre>
 
</pre>
 +
 
<!-- NOTEX -->
 
<!-- NOTEX -->
* '''Submit''' files <tt>fastq2fasta.pl</tt> and <tt>reads-small.fasta</tt>  
+
'''Submitting'''
 +
* Submit files <tt>fastq2fasta.pl</tt>, <tt>reads-small.fasta</tt>, <tt>reads-tiny.fasta</tt>  
 
<!-- /NOTEX -->
 
<!-- /NOTEX -->
  
Line 125: Line 138:
  
 
'''Goal'''
 
'''Goal'''
* Write a script <tt>fastq-quality.pl</tt> which for each position in a read computes the average quality
+
* Write a script <tt>fastq-quality.pl</tt> which for each position in a read computes the average quality.
* FASTQ file should be on standard input. It contains multiple reads, possibly of different lengths
+
* FASTQ file should be on standard input. It contains multiple reads, possibly of different lengths.
* As quality we will use ASCII values of characters in the quality string with value 33 subtracted
+
* As quality we will use ASCII values of characters in the quality string with value 33 subtracted.
 
** For example character 'A' (ASCII 65) means quality 32.
 
** For example character 'A' (ASCII 65) means quality 32.
** ASCII value can be computed by function [http://perldoc.perl.org/functions/ord.html <tt>ord</tt>]
+
** ASCII value can be computed by function [http://perldoc.perl.org/functions/ord.html <tt>ord</tt>].
* Positions in reads will be numbered from 0
+
* Positions in reads will be numbered from 0.
* Since reads can differ in length, some positions are used in more reads, some in fewer
+
* Since reads can differ in length, some positions are used in more reads, some in fewer.
* For each position from 0 up to the highest position used in some read, print three numbers separated by tabs "\t": the position index, the number of times this position was used in reads, the average quality at that position with 1 decimal place (you can again use <tt>printf</tt>)
+
* For each position from 0 up to the highest position used in some read, print three numbers separated by tabs "\t": the position index, the number of times this position was used in reads, the average quality at that position with 1 decimal place (you can again use <tt>printf</tt>).
  
 
'''Example'''
 
'''Example'''
The first 4 lines when you run <tt>./fastq-quality.pl < /tasks/perl/reads-tiny.fastq</tt> should be
+
* The first and last lines when you run <tt>./fastq-quality.pl < /tasks/perl/reads-tiny.fastq</tt> should be
 
<pre>
 
<pre>
 
0 5 28.2
 
0 5 28.2
 
1 5 33.0
 
1 5 33.0
2 5 33.0
+
...
3 5 33.2
+
20 2 32.0
4 4 33.5
+
21 2 32.0
 
</pre>
 
</pre>
 +
For example position 1 occurs in all reads and the qualities are B,A,B,A,D, which have ASCII values 66, 65, 66, 65, 68. After subtracting 33 from each and averaging we get 33. On the last position (21), we have only two reads with qualities A, which translates to value 32.
 +
  
* The last two lines when you run <tt>./fastq-quality.pl < reads-small.fastq</tt> should be
+
'''Running'''
<pre>
+
* Run the following commands, which runs your script on the large FASTQ file and selects every 10th position. The output is stored in <tt>reads-qualities.tsv</tt> and printed using <tt>cat</tt>
99      86      5.5
 
100    86      8.6
 
</pre>
 
Run the following command, which runs your script on the larger file and selects every 10th position.  
 
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
./fastq-quality.pl < reads.fastq | perl -lane 'print if $F[0]%10==0'
+
./fastq-quality.pl < /tasks/perl/reads.fastq | perl -lane 'print if $F[0] % 10 == 0' > reads-qualities.tsv
 +
cat reads-qualities.tsv
 
</syntaxhighlight>
 
</syntaxhighlight>
* What trends (if any) do you see in quality values with increasing position?
+
* This input is a sample of real sequencing data from Illumina technology. What trends (if any) do you see in quality values with increasing position?  
 +
 
 +
 
 
<!-- NOTEX -->
 
<!-- NOTEX -->
* '''Submit''' only <tt>fastq-quality.pl</tt>
+
'''Submitting'''
* In your '''protocol''', include the output of the command and the answer to the question above.
+
* Submit <tt>fastq-quality.pl</tt>, <tt>reads-qualities.tsv</tt>
 +
* In the protocol, discuss the question stated above regarding <tt>reads-qualities.tsv</tt>
 
<!-- /NOTEX -->
 
<!-- /NOTEX -->
  
 
===Task D (FASTQ trim)===
 
===Task D (FASTQ trim)===
  
Write script <tt>fastq-trim.pl</tt> that trims low quality bases from the end of each read and filters out short reads
+
'''Goal'''
* This script should read a fastq file from standard input and write trimmed fastq file to standard output
+
* Write script <tt>fastq-trim.pl</tt> that trims low quality bases from the end of each read and filters out short reads.
* It should also accept two command-line arguments: character ''Q'' and integer ''L''
+
* This script should read a FASTQ file from the standard input and write trimmed FASTQ file to the standard output.
** We have not covered processing command line arguments, but you can use the code snippet below
+
* It should also accept two command-line arguments: character ''Q'' and integer ''L''.
* ''Q'' is the minimum acceptable quality (characters from quality string with ASCII value >= ASCII value of ''Q'' are ok)
+
** We have not covered processing command line arguments, but you can use the code snippet below.
* ''L'' is the minimum acceptable length of a read
+
* ''Q'' is the minimum acceptable quality (characters from quality string with ASCII value >= ASCII value of ''Q'' are ok).
* First find the last base in a read which has quality at least Q (if any). All bases after this base will be removed from both the sequence and quality string
+
* ''L'' is the minimum acceptable length of a read.
* If the resulting read has fewer than L bases, it is omitted from the output
+
* First find the '''last base''' in a read which has quality at least ''Q'' (if any). All bases after this base will be removed from both the sequence and the quality string.
 +
* If the resulting read has fewer than ''L'' bases, it is omitted from the output.
 +
 
 +
'''Testing'''
 +
* You can check your program by the following tests.
 +
 
 +
* If you run the following two commands, nothing should be filtered out and thus you should get file <tt>tmp</tt> identical with input and thus output of the <tt>diff</tt> command should be empty.
 +
<syntaxhighlight lang="bash">
 +
# trim at quality ASCII >=33 and length >=1
 +
./fastq-trim.pl '!' 1 < /tasks/perl/reads-tiny.fastq > tmp
 +
diff /tasks/perl/reads-tiny.fastq tmp
 +
</syntaxhighlight>
  
You can check your program by the following tests:
+
* If you run the following two commands, nothing is trimmed but the shortest read should be filtered out. Comparing with our solution should produce no differences.
* If you run the following two commands, you should get file <tt>tmp</tt> identical with input and thus output of the <tt>diff</tt> command should be empty
 
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
./fastq-trim.pl '!' 101 < reads-small.fastq > tmp  # trim at quality ASCII >=33 and length >=101
+
# trim at quality ASCII >=33 and length >=1
diff reads-small.fastq tmp                        # output should be empty (no differences)
+
./fastq-trim.pl '!' 5 < /tasks/perl/reads-tiny.fastq > reads-tiny-trim1.fastq
 +
diff reads-tiny-trim1.fastq /tasks/perl/reads-tiny-trim1.fastq
 
</syntaxhighlight>
 
</syntaxhighlight>
  
* If you run the following two commands, you should see differences in 4 reads, 2 bases trimmed from each
+
* If you run the following two commands, you should see actual trimming of bases with quality A in many reads and one read is omitted. Again, you should see no differences from our output.
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
./fastq-trim.pl '"' 1 < reads-small.fastq > tmp  # trim at quality ASCII >=34 and length >=1
+
./fastq-trim.pl B 1 < /tasks/perl/reads-tiny.fastq > reads-tiny-trim2.fastq
diff reads-small.fastq tmp                        # output should be differences in 4 reads
+
diff reads-tiny-trim2.fastq /tasks/perl/reads-tiny-trim2.fastq
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
* If you run the following commands, you should get empty output (no reads meet the criteria):
 
* If you run the following commands, you should get empty output (no reads meet the criteria):
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
./fastq-trim.pl d 1 < reads-small.fastq          # quality ASCII >=100, length >= 1
+
./fastq-trim.pl d 1 < /tasks/perl/reads-small.fastq          # quality ASCII >=100, length >= 1
./fastq-trim.pl '!' 102 < reads-small.fastq      # quality ASCII >=33 and length >=102
+
./fastq-trim.pl '!' 102 < /tasks/perl/reads-small.fastq      # quality ASCII >=33 and length >=102
 
</syntaxhighlight>
 
</syntaxhighlight>
  
<!-- NOTEX -->
+
'''Further runs'''
Further runs and submitting
+
* <tt>./fastq-trim.pl '(' 95 < /tasks/perl/reads-small.fastq > reads-small-trim.fastq  # quality ASCII >= 40</tt>   
* <tt>./fastq-trim.pl '(' 95 < reads-small.fastq > reads-small-filtered.fastq  # quality ASCII >= 40</tt>   
+
* If you have done task C, run quality statistics on the trimmed version of the bigger file using the commands below. Comment on the differences between statistics on the whole file in part C and filtered file in D. Are they as you expected?
* '''Submit''' files <tt>fastq-trim.pl</tt> and <tt>reads-small-filtered.fastq</tt>
 
<!-- /NOTEX -->
 
* If you have done task C, run quality statistics on the trimmed version of the bigger file using command below. Comment on the differences between statistics on the whole file in part C and D. Are they as you expected?
 
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
 
# "2" means quality ASCII >= 50
 
# "2" means quality ASCII >= 50
./fastq-trim.pl 2 50 < reads.fastq | ./fastq-quality.pl | perl -lane 'print if $F[0]%10==0'
+
./fastq-trim.pl 2 50 < /tasks/perl/reads.fastq | ./fastq-quality.pl | perl -lane 'print if $F[0] % 10 == 0' > reads-trim-qualities.tsv
 +
cat reads-trim-qualities.tsv
 
</syntaxhighlight>
 
</syntaxhighlight>
 +
 
<!-- NOTEX -->
 
<!-- NOTEX -->
* In your '''protocol''', include the result of the command and your discussion of its results.
+
'''Submitting'''
 +
* Submit files <tt>fastq-trim.pl</tt>, <tt>reads-small-trim.fastq</tt>, <tt>reads-trim-qualities.tsv</tt>
 +
* In your protocol, include your discussion of the results for <tt>reads-trim-qualities.tsv</tt>
 
<!-- /NOTEX -->
 
<!-- /NOTEX -->
  
'''Note''': in this task set, you have created tools which can be combined, e.g. you can first trim FASTQ and then convert it to FASTA  
+
'''Note'''  
<!-- NOTEX -->
+
* In this task set, you have created tools which can be combined, e.g. you can first trim FASTQ and then convert it to FASTA.
(no need to submit these files).
 
<!-- /NOTEX -->
 
  
'''Parsing command-line arguments''' in this task (they will be stored in variables <tt>$Q</tt> and <tt>$L</tt>):
+
'''Parsing command-line arguments'''  
 +
* Use the following snippet, which stores command-line arguments in variables <tt>$Q</tt> and <tt>$L</tt>:
 
<syntaxhighlight lang="Perl">
 
<syntaxhighlight lang="Perl">
 
#!/usr/bin/perl -w
 
#!/usr/bin/perl -w

Latest revision as of 11:19, 22 February 2024

Materials: the lecture, Connecting to server, Editors

Files and setup

We recommend creating a directory (folder) for this set of tasks:

mkdir perl  # make directory
cd perl     # change to the new directory

The folder /tasks/perl/ contains input files, an example script working with FASTQ files and correct outputs for some of your scripts; see further details below. In this first homework we will provide almost all commands you need to run.


Write your protocol starting from an outline provided in /tasks/perl/protocol.txt. Make your own copy of the protocol and open it in an editor, e.g. kate:

cp -i /tasks/perl/protocol.txt .   # copy protocol
kate protocol.txt &                # open editor, run in the background

Submitting

  • Directory /submit/perl/your_username will be created for you
  • Copy the required files to this directory, including the protocol named protocol.txt
  • You can modify these files freely until deadline, but after the deadline of the homework, you will lose access rights to this directory
  • Here is an example of the commands you can use for submitting and checking submitted files. Change it to include your username
# protocol
cp -ipv protocol.txt /submit/perl/your_username
# tasks A,B
cp -ipv series-stats.pl series-stats.txt fastq2fasta.pl reads-small.fasta reads-tiny.fasta /submit/perl/your_username
# tasks C, D
cp -ipv fastq-quality.pl reads-qualities.tsv fastq-trim.pl reads-small-trim.fastq reads-trim-qualities.tsv /submit/perl/your_username
# check what was submitted
ls -l /submit/perl/your_username

Task A (series)

Running the script from the lecture

  • Consider the program for counting series in the lecture 1, save it to file series-stats.pl
  • Open editor running in the background: kate series-stats.pl &
  • Copy and paste text to the editor, save it
  • Make the script executable: chmod a+x series-stats.pl
  • Try running it on the small input: ./series-stats.pl < /tasks/perl/series-small.tsv
  • You should get the following output:
Black Mirror 3
Game of Thrones 3

Extending the script

  • Extend the script to compute the average rating of each series (averaging over all episodes in the series)
  • Each row of the input table contains rating in column 5.
  • Output a table with three columns: name of series, the number of episodes, the average rating.
  • Use printf to print these three items right-justified in columns of a sufficient width; print the average rating to 1 decimal place.

Running the script

  • If you run your script on the small file, the output should look something like this (the exact column widths may differ):
./series-stats.pl < /tasks/perl/series-small.tsv
        Black Mirror        3        8.2
     Game of Thrones        3        8.8
  • Run your script also on the large file: ./series-stats.pl < /tasks/perl/series.tsv > series-stats.txt
  • Check the output, e.g. by running cat series-stats.txt

Submitting

  • Submit your script series-stats.pl and the output series-stats.txt

Task B (FASTQ to FASTA)

Introduction

  • In the rest of the assignment, we will write several scripts for working with FASTQ files introduced in the lecture. Similar scripts are often used by bioinformaticians working with DNA sequencing data.
  • We will work with three input files:
    • /tasks/perl/reads-tiny.fastq a tiny version of the read file, including some corner cases
    • /tasks/perl/reads-small.fastq a small version of the read file
    • /tasks/perl/reads.fastq a bigger version of the read file

Goal

  • Write a script which reformats FASTQ file to FASTA format, call it fastq2fasta.pl
    • FASTQ file should be on standard input, FASTA file written to standard output
  • FASTA format is a typical format for storing DNA and protein sequences.
    • Each sequence consists of several lines of the file. The first line starts with ">" followed by identifier of the sequence and optionally some further description separated by whitespace.
    • The sequence itself is on the second line, long sequences can be split into multiple lines.
  • In our case, the name of the sequence will be the ID of the read with the initial @ replaced by > and each / replaced by (_).
  • For example, the first two reads of the file /tasks/perl/reads.fastq are as follows (only the first 50 columns shown)
@SRR022868.1845/1
AAATTTAGGAAAAGATGATTTAGCAACATTTAGCCTTAATGAAAGACCAG...
+
IICIIIIIIIIIID%IIII8>I8III1II,II)I+III*II<II,E;-HI...
@SRR022868.1846/1
TAGCGTTGTAAAATAAATTTCTAGAATGGAAGTGATGATATTGAAATACA...
+
4CIIIIIIII52I)IIIII0I16IIIII2IIII;IIAII&I6AI+*+&G5...
  • These should be reformatted as follows (again only first 50 columns shown, but you include entire reads):
>SRR022868.1845_1
AAATTTAGGAAAAGATGATTTAGCAACATTTAGCCTTAATGAAAGACCAGA...
>SRR022868.1846_1
TAGCGTTGTAAAATAAATTTCTAGAATGGAAGTGATGATATTGAAATACAC...

Start programming

  • You can start by modifying our script /tasks/perl/fastq-lengths.pl, which prints the length of each read in the FASTQ input file. You can use the following commands to start:
# copy our script to your folder under the new name
cp -i /tasks/perl/fastq-lengths.pl fastq2fasta.pl
# open in editor in background
kate fastq2fasta.pl & 

Running the script

  • Run your script on the tiny file, compare with our precomputed correct answer:
./fastq2fasta.pl < /tasks/perl/reads-tiny.fastq > reads-tiny.fasta
diff reads-tiny.fasta /tasks/perl/reads-tiny.fasta
  • Command diff prints differences between files. Here the output of diff should be empty. Otherwise try to look at the input and output files and fix your program to obtain the same output as we have.
  • Also run your script on the small read file
./fastq2fasta.pl < /tasks/perl/reads-small.fastq > reads-small.fasta

Submitting

  • Submit files fastq2fasta.pl, reads-small.fasta, reads-tiny.fasta

Task C (FASTQ quality)

Goal

  • Write a script fastq-quality.pl which for each position in a read computes the average quality.
  • FASTQ file should be on standard input. It contains multiple reads, possibly of different lengths.
  • As quality we will use ASCII values of characters in the quality string with value 33 subtracted.
    • For example character 'A' (ASCII 65) means quality 32.
    • ASCII value can be computed by function ord.
  • Positions in reads will be numbered from 0.
  • Since reads can differ in length, some positions are used in more reads, some in fewer.
  • For each position from 0 up to the highest position used in some read, print three numbers separated by tabs "\t": the position index, the number of times this position was used in reads, the average quality at that position with 1 decimal place (you can again use printf).

Example

  • The first and last lines when you run ./fastq-quality.pl < /tasks/perl/reads-tiny.fastq should be
0	5	28.2
1	5	33.0
...
20	2	32.0
21	2	32.0

For example position 1 occurs in all reads and the qualities are B,A,B,A,D, which have ASCII values 66, 65, 66, 65, 68. After subtracting 33 from each and averaging we get 33. On the last position (21), we have only two reads with qualities A, which translates to value 32.


Running

  • Run the following commands, which runs your script on the large FASTQ file and selects every 10th position. The output is stored in reads-qualities.tsv and printed using cat
./fastq-quality.pl < /tasks/perl/reads.fastq | perl -lane 'print if $F[0] % 10 == 0' > reads-qualities.tsv
cat reads-qualities.tsv
  • This input is a sample of real sequencing data from Illumina technology. What trends (if any) do you see in quality values with increasing position?


Submitting

  • Submit fastq-quality.pl, reads-qualities.tsv
  • In the protocol, discuss the question stated above regarding reads-qualities.tsv

Task D (FASTQ trim)

Goal

  • Write script fastq-trim.pl that trims low quality bases from the end of each read and filters out short reads.
  • This script should read a FASTQ file from the standard input and write trimmed FASTQ file to the standard output.
  • It should also accept two command-line arguments: character Q and integer L.
    • We have not covered processing command line arguments, but you can use the code snippet below.
  • Q is the minimum acceptable quality (characters from quality string with ASCII value >= ASCII value of Q are ok).
  • L is the minimum acceptable length of a read.
  • First find the last base in a read which has quality at least Q (if any). All bases after this base will be removed from both the sequence and the quality string.
  • If the resulting read has fewer than L bases, it is omitted from the output.

Testing

  • You can check your program by the following tests.
  • If you run the following two commands, nothing should be filtered out and thus you should get file tmp identical with input and thus output of the diff command should be empty.
# trim at quality ASCII >=33 and length >=1
./fastq-trim.pl '!' 1 < /tasks/perl/reads-tiny.fastq > tmp
diff /tasks/perl/reads-tiny.fastq tmp
  • If you run the following two commands, nothing is trimmed but the shortest read should be filtered out. Comparing with our solution should produce no differences.
# trim at quality ASCII >=33 and length >=1
./fastq-trim.pl '!' 5 < /tasks/perl/reads-tiny.fastq > reads-tiny-trim1.fastq
diff reads-tiny-trim1.fastq /tasks/perl/reads-tiny-trim1.fastq
  • If you run the following two commands, you should see actual trimming of bases with quality A in many reads and one read is omitted. Again, you should see no differences from our output.
./fastq-trim.pl B 1 < /tasks/perl/reads-tiny.fastq > reads-tiny-trim2.fastq
diff reads-tiny-trim2.fastq /tasks/perl/reads-tiny-trim2.fastq
  • If you run the following commands, you should get empty output (no reads meet the criteria):
./fastq-trim.pl d 1 < /tasks/perl/reads-small.fastq           # quality ASCII >=100, length >= 1
./fastq-trim.pl '!' 102 < /tasks/perl/reads-small.fastq       # quality ASCII >=33 and length >=102

Further runs

  • ./fastq-trim.pl '(' 95 < /tasks/perl/reads-small.fastq > reads-small-trim.fastq # quality ASCII >= 40
  • If you have done task C, run quality statistics on the trimmed version of the bigger file using the commands below. Comment on the differences between statistics on the whole file in part C and filtered file in D. Are they as you expected?
# "2" means quality ASCII >= 50
./fastq-trim.pl 2 50 < /tasks/perl/reads.fastq | ./fastq-quality.pl | perl -lane 'print if $F[0] % 10 == 0' > reads-trim-qualities.tsv
cat reads-trim-qualities.tsv

Submitting

  • Submit files fastq-trim.pl, reads-small-trim.fastq, reads-trim-qualities.tsv
  • In your protocol, include your discussion of the results for reads-trim-qualities.tsv

Note

  • In this task set, you have created tools which can be combined, e.g. you can first trim FASTQ and then convert it to FASTA.

Parsing command-line arguments

  • Use the following snippet, which stores command-line arguments in variables $Q and $L:
#!/usr/bin/perl -w
use strict;

my $USAGE = "
Usage:
$0 Q L < input.fastq > output.fastq

Trim from the end of each read bases with ASCII quality value less
than the given threshold Q. If the length of the read after trimming
is less than L, the read will be omitted from output.

L is a non-negative integer, Q is a character
";

# check that we have exactly 2 command-line arguments
die $USAGE unless @ARGV==2;
# copy command-line arguments to variables Q and L
my ($Q, $L) = @ARGV;
# check that $Q is one character and $L looks like a non-negative integer
die $USAGE unless length($Q)==1 && $L=~/^[0-9]+$/;