We’ve been using Methyl Extract for our SNP and Methylation status calling, and it seems to be working well, except the methylation calling output is not that great. We plan to use a modeling software called MACAU, which expects two count files, one a matrix of methylation counts by location and sample, the second a matrix of total reads by location and sample. Methyl Extract provides this in a single matrix, but both counts are split by which strand they came from.

The goal of this notebook is to figure out how to combine the different samples in two ways. First, We need all of the samples to be in a single file, and second, we need the +/- strands summed so we have total counts by sample. This would seem easy at first glance, but there’s the additional problem that each sample may not have had a read happen at each position in each scaffold, so it’s likely there will be dissimilar numbers of rows per sample file.

library(readr)
## Reads in some of the sample files, it also changes any "." characters to NAs.
EPI_111_CG <- read_delim("~/Documents/Roberts Lab/Hollie-Geoduck/Merge-test/VCF-Test/EPI-111-CG.output", "\t", escape_double = FALSE, trim_ws = TRUE, na = ".")
Parsed with column specification:
cols(
  `#CHROM` = col_character(),
  POS = col_integer(),
  CONTEXT = col_character(),
  `Watson METH` = col_integer(),
  `Watson COVERAGE` = col_integer(),
  `Watson QUAL` = col_integer(),
  `Crick METH` = col_integer(),
  `Crick COVERAGE` = col_integer(),
  `Crick QUAL` = col_integer()
)
EPI_113_CG <- read_delim("~/Documents/Roberts Lab/Hollie-Geoduck/Merge-test/VCF-Test/EPI-113-CG.output", "\t", escape_double = FALSE, trim_ws = TRUE, na = ".")
Parsed with column specification:
cols(
  `#CHROM` = col_character(),
  POS = col_integer(),
  CONTEXT = col_character(),
  `Watson METH` = col_integer(),
  `Watson COVERAGE` = col_integer(),
  `Watson QUAL` = col_integer(),
  `Crick METH` = col_integer(),
  `Crick COVERAGE` = col_integer(),
  `Crick QUAL` = col_integer()
)

|======                                                                         |   7%    4 MB
|======                                                                         |   7%    4 MB
|======                                                                         |   7%    4 MB
|======                                                                         |   7%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|======                                                                         |   8%    4 MB
|=======                                                                        |   8%    4 MB
|=======                                                                        |   8%    4 MB
|=======                                                                        |   8%    4 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|=======                                                                        |   9%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    5 MB
|========                                                                       |  10%    6 MB
|========                                                                       |  10%    6 MB
|========                                                                       |  10%    6 MB
|========                                                                       |  11%    6 MB
|========                                                                       |  11%    6 MB
|========                                                                       |  11%    6 MB
|========                                                                       |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  11%    6 MB
|=========                                                                      |  12%    6 MB
|=========                                                                      |  12%    6 MB
|=========                                                                      |  12%    6 MB
|=========                                                                      |  12%    6 MB
|=========                                                                      |  12%    6 MB
|=========                                                                      |  12%    6 MB
|=========                                                                      |  12%    6 MB
|==========                                                                     |  12%    6 MB
|==========                                                                     |  12%    7 MB
|==========                                                                     |  12%    7 MB
|==========                                                                     |  12%    7 MB
|==========                                                                     |  12%    7 MB
|==========                                                                     |  12%    7 MB
|==========                                                                     |  12%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|==========                                                                     |  13%    7 MB
|===========                                                                    |  13%    7 MB
|===========                                                                    |  13%    7 MB
|===========                                                                    |  13%    7 MB
|===========                                                                    |  13%    7 MB
|===========                                                                    |  14%    7 MB
|===========                                                                    |  14%    7 MB
|===========                                                                    |  14%    7 MB
|===========                                                                    |  14%    7 MB
|===========                                                                    |  14%    7 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|===========                                                                    |  14%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  15%    8 MB
|============                                                                   |  16%    8 MB
|============                                                                   |  16%    8 MB
|============                                                                   |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  16%    9 MB
|=============                                                                  |  17%    9 MB
|=============                                                                  |  17%    9 MB
|=============                                                                  |  17%    9 MB
|=============                                                                  |  17%    9 MB
|=============                                                                  |  17%    9 MB
|=============                                                                  |  17%    9 MB
|=============                                                                  |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  17%    9 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|==============                                                                 |  18%   10 MB
|===============                                                                |  18%   10 MB
|===============                                                                |  18%   10 MB
|===============                                                                |  18%   10 MB
|===============                                                                |  18%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   10 MB
|===============                                                                |  19%   11 MB
|===============                                                                |  19%   11 MB
|===============                                                                |  19%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  20%   11 MB
|================                                                               |  21%   11 MB
|================                                                               |  21%   11 MB
|================                                                               |  21%   11 MB
|================                                                               |  21%   11 MB
|=================                                                              |  21%   11 MB
|=================                                                              |  21%   11 MB
|=================                                                              |  21%   11 MB
|=================                                                              |  21%   11 MB
|=================                                                              |  21%   12 MB
|=================                                                              |  21%   12 MB
|=================                                                              |  21%   12 MB
|=================                                                              |  21%   12 MB
|=================                                                              |  21%   12 MB
|=================                                                              |  21%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|=================                                                              |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  22%   12 MB
|==================                                                             |  23%   12 MB
|==================                                                             |  23%   12 MB
|==================                                                             |  23%   12 MB
|==================                                                             |  23%   12 MB
|==================                                                             |  23%   13 MB
|==================                                                             |  23%   13 MB
|==================                                                             |  23%   13 MB
|==================                                                             |  23%   13 MB
|==================                                                             |  23%   13 MB
|==================                                                             |  23%   13 MB
|==================                                                             |  23%   13 MB
|===================                                                            |  23%   13 MB
|===================                                                            |  23%   13 MB
|===================                                                            |  23%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|===================                                                            |  24%   13 MB
|====================                                                           |  25%   13 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  25%   14 MB
|====================                                                           |  26%   14 MB
|====================                                                           |  26%   14 MB
|====================                                                           |  26%   14 MB
|====================                                                           |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   14 MB
|=====================                                                          |  26%   15 MB
|=====================                                                          |  26%   15 MB
|=====================                                                          |  27%   15 MB
|=====================                                                          |  27%   15 MB
|=====================                                                          |  27%   15 MB
|=====================                                                          |  27%   15 MB
|=====================                                                          |  27%   15 MB
|=====================                                                          |  27%   15 MB
|=====================                                                          |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  27%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   15 MB
|======================                                                         |  28%   16 MB
|=======================                                                        |  28%   16 MB
|=======================                                                        |  28%   16 MB
|=======================                                                        |  28%   16 MB
|=======================                                                        |  28%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|=======================                                                        |  29%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   16 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  30%   17 MB
|========================                                                       |  31%   17 MB
|========================                                                       |  31%   17 MB
|========================                                                       |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  31%   17 MB
|=========================                                                      |  32%   17 MB
|=========================                                                      |  32%   17 MB
|=========================                                                      |  32%   17 MB
|=========================                                                      |  32%   17 MB
|=========================                                                      |  32%   18 MB
|=========================                                                      |  32%   18 MB
|=========================                                                      |  32%   18 MB
|=========================                                                      |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  32%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|==========================                                                     |  33%   18 MB
|===========================                                                    |  33%   18 MB
|===========================                                                    |  33%   18 MB
|===========================                                                    |  33%   18 MB
|===========================                                                    |  34%   18 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|===========================                                                    |  34%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   19 MB
|============================                                                   |  35%   20 MB
|============================                                                   |  35%   20 MB
|============================                                                   |  36%   20 MB
|============================                                                   |  36%   20 MB
|============================                                                   |  36%   20 MB
|============================                                                   |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  36%   20 MB
|=============================                                                  |  37%   20 MB
|=============================                                                  |  37%   20 MB
|=============================                                                  |  37%   20 MB
|=============================                                                  |  37%   20 MB
|=============================                                                  |  37%   20 MB
|=============================                                                  |  37%   20 MB
|=============================                                                  |  37%   20 MB
|==============================                                                 |  37%   20 MB
|==============================                                                 |  37%   20 MB
|==============================                                                 |  37%   21 MB
|==============================                                                 |  37%   21 MB
|==============================                                                 |  37%   21 MB
|==============================                                                 |  37%   21 MB
|==============================                                                 |  37%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|==============================                                                 |  38%   21 MB
|===============================                                                |  38%   21 MB
|===============================                                                |  38%   21 MB
|===============================                                                |  38%   21 MB
|===============================                                                |  38%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   21 MB
|===============================                                                |  39%   22 MB
|===============================                                                |  39%   22 MB
|===============================                                                |  39%   22 MB
|===============================                                                |  39%   22 MB
|===============================                                                |  39%   22 MB
|===============================                                                |  39%   22 MB
|===============================                                                |  39%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  40%   22 MB
|================================                                               |  41%   22 MB
|================================                                               |  41%   22 MB
|================================                                               |  41%   22 MB
|=================================                                              |  41%   22 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  41%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|=================================                                              |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  42%   23 MB
|==================================                                             |  43%   23 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|==================================                                             |  43%   24 MB
|===================================                                            |  43%   24 MB
|===================================                                            |  43%   24 MB
|===================================                                            |  43%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   24 MB
|===================================                                            |  44%   25 MB
|===================================                                            |  44%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  45%   25 MB
|====================================                                           |  46%   25 MB
|====================================                                           |  46%   25 MB
|====================================                                           |  46%   25 MB
|====================================                                           |  46%   25 MB
|=====================================                                          |  46%   25 MB
|=====================================                                          |  46%   25 MB
|=====================================                                          |  46%   25 MB
|=====================================                                          |  46%   25 MB
|=====================================                                          |  46%   25 MB
|=====================================                                          |  46%   25 MB
|=====================================                                          |  46%   26 MB
|=====================================                                          |  46%   26 MB
|=====================================                                          |  46%   26 MB
|=====================================                                          |  46%   26 MB
|=====================================                                          |  46%   26 MB
|=====================================                                          |  47%   26 MB
|=====================================                                          |  47%   26 MB
|=====================================                                          |  47%   26 MB
|=====================================                                          |  47%   26 MB
|=====================================                                          |  47%   26 MB
|=====================================                                          |  47%   26 MB
|=====================================                                          |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  47%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   26 MB
|======================================                                         |  48%   27 MB
|======================================                                         |  48%   27 MB
|======================================                                         |  48%   27 MB
|======================================                                         |  48%   27 MB
|=======================================                                        |  48%   27 MB
|=======================================                                        |  48%   27 MB
|=======================================                                        |  48%   27 MB
|=======================================                                        |  48%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|=======================================                                        |  49%   27 MB
|========================================                                       |  50%   27 MB
|========================================                                       |  50%   27 MB
|========================================                                       |  50%   27 MB
|========================================                                       |  50%   27 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  50%   28 MB
|========================================                                       |  51%   28 MB
|========================================                                       |  51%   28 MB
|========================================                                       |  51%   28 MB
|========================================                                       |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  51%   28 MB
|=========================================                                      |  52%   29 MB
|=========================================                                      |  52%   29 MB
|=========================================                                      |  52%   29 MB
|=========================================                                      |  52%   29 MB
|=========================================                                      |  52%   29 MB
|=========================================                                      |  52%   29 MB
|=========================================                                      |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  52%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|==========================================                                     |  53%   29 MB
|===========================================                                    |  53%   29 MB
|===========================================                                    |  53%   30 MB
|===========================================                                    |  53%   30 MB
|===========================================                                    |  53%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|===========================================                                    |  54%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   30 MB
|============================================                                   |  55%   31 MB
|============================================                                   |  55%   31 MB
|============================================                                   |  55%   31 MB
|============================================                                   |  55%   31 MB
|============================================                                   |  55%   31 MB
|============================================                                   |  55%   31 MB
|============================================                                   |  56%   31 MB
|============================================                                   |  56%   31 MB
|============================================                                   |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  56%   31 MB
|=============================================                                  |  57%   31 MB
|=============================================                                  |  57%   31 MB
|=============================================                                  |  57%   31 MB
|=============================================                                  |  57%   31 MB
|=============================================                                  |  57%   31 MB
|=============================================                                  |  57%   31 MB
|=============================================                                  |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  57%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|==============================================                                 |  58%   32 MB
|===============================================                                |  58%   32 MB
|===============================================                                |  58%   32 MB
|===============================================                                |  58%   32 MB
|===============================================                                |  59%   32 MB
|===============================================                                |  59%   32 MB
|===============================================                                |  59%   32 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|===============================================                                |  59%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  60%   33 MB
|================================================                               |  61%   34 MB
|================================================                               |  61%   34 MB
|================================================                               |  61%   34 MB
|================================================                               |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  61%   34 MB
|=================================================                              |  62%   34 MB
|=================================================                              |  62%   34 MB
|=================================================                              |  62%   34 MB
|=================================================                              |  62%   34 MB
|=================================================                              |  62%   34 MB
|=================================================                              |  62%   34 MB
|=================================================                              |  62%   34 MB
|==================================================                             |  62%   34 MB
|==================================================                             |  62%   34 MB
|==================================================                             |  62%   34 MB
|==================================================                             |  62%   34 MB
|==================================================                             |  62%   35 MB
|==================================================                             |  62%   35 MB
|==================================================                             |  62%   35 MB
|==================================================                             |  62%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|==================================================                             |  63%   35 MB
|===================================================                            |  63%   35 MB
|===================================================                            |  63%   35 MB
|===================================================                            |  63%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   35 MB
|===================================================                            |  64%   36 MB
|===================================================                            |  64%   36 MB
|===================================================                            |  64%   36 MB
|===================================================                            |  64%   36 MB
|===================================================                            |  64%   36 MB
|===================================================                            |  64%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  65%   36 MB
|====================================================                           |  66%   36 MB
|====================================================                           |  66%   36 MB
|====================================================                           |  66%   36 MB
|====================================================                           |  66%   36 MB
|=====================================================                          |  66%   36 MB
|=====================================================                          |  66%   36 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  66%   37 MB
|=====================================================                          |  67%   37 MB
|=====================================================                          |  67%   37 MB
|=====================================================                          |  67%   37 MB
|=====================================================                          |  67%   37 MB
|=====================================================                          |  67%   37 MB
|=====================================================                          |  67%   37 MB
|=====================================================                          |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  67%   37 MB
|======================================================                         |  68%   37 MB
|======================================================                         |  68%   37 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|======================================================                         |  68%   38 MB
|=======================================================                        |  68%   38 MB
|=======================================================                        |  68%   38 MB
|=======================================================                        |  68%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   38 MB
|=======================================================                        |  69%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  70%   39 MB
|========================================================                       |  71%   39 MB
|========================================================                       |  71%   39 MB
|========================================================                       |  71%   39 MB
|========================================================                       |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   39 MB
|=========================================================                      |  71%   40 MB
|=========================================================                      |  71%   40 MB
|=========================================================                      |  71%   40 MB
|=========================================================                      |  71%   40 MB
|=========================================================                      |  72%   40 MB
|=========================================================                      |  72%   40 MB
|=========================================================                      |  72%   40 MB
|=========================================================                      |  72%   40 MB
|=========================================================                      |  72%   40 MB
|=========================================================                      |  72%   40 MB
|=========================================================                      |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  72%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   40 MB
|==========================================================                     |  73%   41 MB
|==========================================================                     |  73%   41 MB
|==========================================================                     |  73%   41 MB
|===========================================================                    |  73%   41 MB
|===========================================================                    |  73%   41 MB
|===========================================================                    |  73%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|===========================================================                    |  74%   41 MB
|============================================================                   |  75%   41 MB
|============================================================                   |  75%   41 MB
|============================================================                   |  75%   41 MB
|============================================================                   |  75%   41 MB
|============================================================                   |  75%   41 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  75%   42 MB
|============================================================                   |  76%   42 MB
|============================================================                   |  76%   42 MB
|============================================================                   |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  76%   42 MB
|=============================================================                  |  77%   42 MB
|=============================================================                  |  77%   42 MB
|=============================================================                  |  77%   43 MB
|=============================================================                  |  77%   43 MB
|=============================================================                  |  77%   43 MB
|=============================================================                  |  77%   43 MB
|=============================================================                  |  77%   43 MB
|=============================================================                  |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  77%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|==============================================================                 |  78%   43 MB
|===============================================================                |  78%   43 MB
|===============================================================                |  78%   43 MB
|===============================================================                |  78%   43 MB
|===============================================================                |  78%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|===============================================================                |  79%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   44 MB
|================================================================               |  80%   45 MB
|================================================================               |  80%   45 MB
|================================================================               |  80%   45 MB
|================================================================               |  80%   45 MB
|================================================================               |  81%   45 MB
|================================================================               |  81%   45 MB
|================================================================               |  81%   45 MB
|================================================================               |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  81%   45 MB
|=================================================================              |  82%   45 MB
|=================================================================              |  82%   45 MB
|=================================================================              |  82%   45 MB
|=================================================================              |  82%   45 MB
|=================================================================              |  82%   45 MB
|=================================================================              |  82%   45 MB
|=================================================================              |  82%   45 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  82%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|==================================================================             |  83%   46 MB
|===================================================================            |  83%   46 MB
|===================================================================            |  83%   46 MB
|===================================================================            |  83%   46 MB
|===================================================================            |  83%   46 MB
|===================================================================            |  84%   46 MB
|===================================================================            |  84%   46 MB
|===================================================================            |  84%   46 MB
|===================================================================            |  84%   46 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|===================================================================            |  84%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  85%   47 MB
|====================================================================           |  86%   47 MB
|====================================================================           |  86%   47 MB
|====================================================================           |  86%   48 MB
|====================================================================           |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  86%   48 MB
|=====================================================================          |  87%   48 MB
|=====================================================================          |  87%   48 MB
|=====================================================================          |  87%   48 MB
|=====================================================================          |  87%   48 MB
|=====================================================================          |  87%   48 MB
|=====================================================================          |  87%   48 MB
|=====================================================================          |  87%   48 MB
|======================================================================         |  87%   48 MB
|======================================================================         |  87%   48 MB
|======================================================================         |  87%   48 MB
|======================================================================         |  87%   48 MB
|======================================================================         |  87%   48 MB
|======================================================================         |  87%   48 MB
|======================================================================         |  87%   49 MB
|======================================================================         |  87%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|======================================================================         |  88%   49 MB
|=======================================================================        |  88%   49 MB
|=======================================================================        |  88%   49 MB
|=======================================================================        |  88%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   49 MB
|=======================================================================        |  89%   50 MB
|=======================================================================        |  89%   50 MB
|=======================================================================        |  89%   50 MB
|=======================================================================        |  89%   50 MB
|=======================================================================        |  89%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  90%   50 MB
|========================================================================       |  91%   50 MB
|========================================================================       |  91%   50 MB
|========================================================================       |  91%   50 MB
|=========================================================================      |  91%   50 MB
|=========================================================================      |  91%   50 MB
|=========================================================================      |  91%   50 MB
|=========================================================================      |  91%   50 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  91%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|=========================================================================      |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  92%   51 MB
|==========================================================================     |  93%   51 MB
|==========================================================================     |  93%   51 MB
|==========================================================================     |  93%   51 MB
|==========================================================================     |  93%   51 MB
|==========================================================================     |  93%   52 MB
|==========================================================================     |  93%   52 MB
|==========================================================================     |  93%   52 MB
|==========================================================================     |  93%   52 MB
|==========================================================================     |  93%   52 MB
|==========================================================================     |  93%   52 MB
|==========================================================================     |  93%   52 MB
|===========================================================================    |  93%   52 MB
|===========================================================================    |  93%   52 MB
|===========================================================================    |  93%   52 MB
|===========================================================================    |  93%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|===========================================================================    |  94%   52 MB
|============================================================================   |  95%   52 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  95%   53 MB
|============================================================================   |  96%   53 MB
|============================================================================   |  96%   53 MB
|============================================================================   |  96%   53 MB
|============================================================================   |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   53 MB
|=============================================================================  |  96%   54 MB
|=============================================================================  |  96%   54 MB
|=============================================================================  |  97%   54 MB
|=============================================================================  |  97%   54 MB
|=============================================================================  |  97%   54 MB
|=============================================================================  |  97%   54 MB
|=============================================================================  |  97%   54 MB
|=============================================================================  |  97%   54 MB
|=============================================================================  |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  97%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   54 MB
|============================================================================== |  98%   55 MB
|============================================================================== |  98%   55 MB
|===============================================================================|  98%   55 MB
|===============================================================================|  98%   55 MB
|===============================================================================|  98%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|===============================================================================|  99%   55 MB
|================================================================================| 100%   55 MB
EPI_104_CG <- read_delim("~/Documents/Roberts Lab/Hollie-Geoduck/Merge-test/VCF-Test/EPI-104-CG.output", "\t", escape_double = FALSE, trim_ws = TRUE, na = ".")
Parsed with column specification:
cols(
  `#CHROM` = col_character(),
  POS = col_integer(),
  CONTEXT = col_character(),
  `Watson METH` = col_integer(),
  `Watson COVERAGE` = col_integer(),
  `Watson QUAL` = col_integer(),
  `Crick METH` = col_integer(),
  `Crick COVERAGE` = col_integer(),
  `Crick QUAL` = col_integer()
)
EPI_119_CG <- read_delim("~/Documents/Roberts Lab/Hollie-Geoduck/Merge-test/VCF-Test/EPI-119-CG.output", "\t", escape_double = FALSE, trim_ws = TRUE, na = ".")
Parsed with column specification:
cols(
  `#CHROM` = col_character(),
  POS = col_integer(),
  CONTEXT = col_character(),
  `Watson METH` = col_integer(),
  `Watson COVERAGE` = col_integer(),
  `Watson QUAL` = col_integer(),
  `Crick METH` = col_integer(),
  `Crick COVERAGE` = col_integer(),
  `Crick QUAL` = col_integer()
)
EPI_104_CG[,10] <- rowSums(cbind(EPI_104_CG$`Watson METH`, EPI_104_CG$`Crick METH`), na.rm = TRUE)
EPI_104_CG[,11] <- rowSums(cbind(EPI_104_CG$`Watson COVERAGE`, EPI_104_CG$`Crick COVERAGE`), na.rm = TRUE)
EPI_104_CG[,12] <- "EPI_104"
EPI_111_CG[,10] <- rowSums(cbind(EPI_111_CG$`Watson METH`, EPI_111_CG$`Crick METH`), na.rm = TRUE)
EPI_111_CG[,11] <- rowSums(cbind(EPI_111_CG$`Watson COVERAGE`, EPI_111_CG$`Crick COVERAGE`), na.rm = TRUE)
EPI_111_CG[,12] <- "EPI_111"
EPI_113_CG[,10] <- rowSums(cbind(EPI_113_CG$`Watson METH`, EPI_113_CG$`Crick METH`), na.rm = TRUE)
EPI_113_CG[,11] <- rowSums(cbind(EPI_113_CG$`Watson COVERAGE`, EPI_113_CG$`Crick COVERAGE`), na.rm = TRUE)
EPI_113_CG[,12] <- "EPI_113"
EPI_119_CG[,10] <- rowSums(cbind(EPI_119_CG$`Watson METH`, EPI_119_CG$`Crick METH`), na.rm = TRUE)
EPI_119_CG[,11] <- rowSums(cbind(EPI_119_CG$`Watson COVERAGE`, EPI_119_CG$`Crick COVERAGE`), na.rm = TRUE)
EPI_119_CG[,12] <- "EPI_119"
colnames(EPI_104_CG)[10:12] <- c("TotalMeth104", "TotalCov104", "SampleName")
colnames(EPI_111_CG)[10:12] <- c("TotalMeth111", "TotalCov111", "SampleName")
colnames(EPI_113_CG)[10:12] <- c("TotalMeth113", "TotalCov113", "SampleName")
colnames(EPI_119_CG)[10:12] <- c("TotalMeth119", "TotalCov119", "SampleName")
test.meth <- merge(EPI_104_CG[,c(1, 2, 3, 10)], EPI_111_CG[,c(1, 2, 3, 10)], by = names(EPI_111_CG[,c(1,2,3)]), all = T)
test.meth2 <- merge(test.meth, EPI_113_CG[,c(1, 2, 3, 10)], all = T)
test.meth3 <- merge(test.meth2, EPI_119_CG[,c(1, 2, 3, 10)], all = T)
head(test.meth3)
LS0tCnRpdGxlOiAiTWVyZ2luZyBNZXRoeWxhdGlvbiBDb3VudCBmaWxlcyBieSBzYW1wbGUuIgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpXZSd2ZSBiZWVuIHVzaW5nIE1ldGh5bCBFeHRyYWN0IGZvciBvdXIgU05QIGFuZCBNZXRoeWxhdGlvbiBzdGF0dXMgY2FsbGluZywgYW5kIGl0IHNlZW1zIHRvIGJlIHdvcmtpbmcgd2VsbCwgZXhjZXB0IHRoZSBtZXRoeWxhdGlvbiBjYWxsaW5nIG91dHB1dCBpcyBub3QgdGhhdCBncmVhdC4gV2UgcGxhbiB0byB1c2UgYSBtb2RlbGluZyBzb2Z0d2FyZSBjYWxsZWQgTUFDQVUsIHdoaWNoIGV4cGVjdHMgdHdvIGNvdW50IGZpbGVzLCBvbmUgYSBtYXRyaXggb2YgbWV0aHlsYXRpb24gY291bnRzIGJ5IGxvY2F0aW9uIGFuZCBzYW1wbGUsIHRoZSBzZWNvbmQgYSBtYXRyaXggb2YgdG90YWwgcmVhZHMgYnkgbG9jYXRpb24gYW5kIHNhbXBsZS4gTWV0aHlsIEV4dHJhY3QgcHJvdmlkZXMgdGhpcyBpbiBhIHNpbmdsZSBtYXRyaXgsIGJ1dCBib3RoIGNvdW50cyBhcmUgc3BsaXQgYnkgd2hpY2ggc3RyYW5kIHRoZXkgY2FtZSBmcm9tLgoKVGhlIGdvYWwgb2YgdGhpcyBub3RlYm9vayBpcyB0byBmaWd1cmUgb3V0IGhvdyB0byBjb21iaW5lIHRoZSBkaWZmZXJlbnQgc2FtcGxlcyBpbiB0d28gd2F5cy4gRmlyc3QsIFdlIG5lZWQgYWxsIG9mIHRoZSBzYW1wbGVzIHRvIGJlIGluIGEgc2luZ2xlIGZpbGUsIGFuZCBzZWNvbmQsIHdlIG5lZWQgdGhlICsvLSBzdHJhbmRzIHN1bW1lZCBzbyB3ZSBoYXZlIHRvdGFsIGNvdW50cyBieSBzYW1wbGUuIFRoaXMgd291bGQgc2VlbSBlYXN5IGF0IGZpcnN0IGdsYW5jZSwgYnV0IHRoZXJlJ3MgdGhlIGFkZGl0aW9uYWwgcHJvYmxlbSB0aGF0IGVhY2ggc2FtcGxlIG1heSBub3QgaGF2ZSBoYWQgYSByZWFkIGhhcHBlbiBhdCBlYWNoIHBvc2l0aW9uIGluIGVhY2ggc2NhZmZvbGQsIHNvIGl0J3MgbGlrZWx5IHRoZXJlIHdpbGwgYmUgZGlzc2ltaWxhciBudW1iZXJzIG9mIHJvd3MgcGVyIHNhbXBsZSBmaWxlLgoKCmBgYHtyfQpsaWJyYXJ5KHJlYWRyKQoKIyMgUmVhZHMgaW4gc29tZSBvZiB0aGUgc2FtcGxlIGZpbGVzLCBpdCBhbHNvIGNoYW5nZXMgYW55ICIuIiBjaGFyYWN0ZXJzIHRvIE5Bcy4KRVBJXzExMV9DRyA8LSByZWFkX2RlbGltKCJ+L0RvY3VtZW50cy9Sb2JlcnRzIExhYi9Ib2xsaWUtR2VvZHVjay9NZXJnZS10ZXN0L1ZDRi1UZXN0L0VQSS0xMTEtQ0cub3V0cHV0IiwgIlx0IiwgZXNjYXBlX2RvdWJsZSA9IEZBTFNFLCB0cmltX3dzID0gVFJVRSwgbmEgPSAiLiIpCgpFUElfMTEzX0NHIDwtIHJlYWRfZGVsaW0oIn4vRG9jdW1lbnRzL1JvYmVydHMgTGFiL0hvbGxpZS1HZW9kdWNrL01lcmdlLXRlc3QvVkNGLVRlc3QvRVBJLTExMy1DRy5vdXRwdXQiLCAiXHQiLCBlc2NhcGVfZG91YmxlID0gRkFMU0UsIHRyaW1fd3MgPSBUUlVFLCBuYSA9ICIuIikKCkVQSV8xMDRfQ0cgPC0gcmVhZF9kZWxpbSgifi9Eb2N1bWVudHMvUm9iZXJ0cyBMYWIvSG9sbGllLUdlb2R1Y2svTWVyZ2UtdGVzdC9WQ0YtVGVzdC9FUEktMTA0LUNHLm91dHB1dCIsICJcdCIsIGVzY2FwZV9kb3VibGUgPSBGQUxTRSwgdHJpbV93cyA9IFRSVUUsIG5hID0gIi4iKQoKRVBJXzExOV9DRyA8LSByZWFkX2RlbGltKCJ+L0RvY3VtZW50cy9Sb2JlcnRzIExhYi9Ib2xsaWUtR2VvZHVjay9NZXJnZS10ZXN0L1ZDRi1UZXN0L0VQSS0xMTktQ0cub3V0cHV0IiwgIlx0IiwgZXNjYXBlX2RvdWJsZSA9IEZBTFNFLCB0cmltX3dzID0gVFJVRSwgbmEgPSAiLiIpCgoKRVBJXzEwNF9DR1ssMTBdIDwtIHJvd1N1bXMoY2JpbmQoRVBJXzEwNF9DRyRgV2F0c29uIE1FVEhgLCBFUElfMTA0X0NHJGBDcmljayBNRVRIYCksIG5hLnJtID0gVFJVRSkKRVBJXzEwNF9DR1ssMTFdIDwtIHJvd1N1bXMoY2JpbmQoRVBJXzEwNF9DRyRgV2F0c29uIENPVkVSQUdFYCwgRVBJXzEwNF9DRyRgQ3JpY2sgQ09WRVJBR0VgKSwgbmEucm0gPSBUUlVFKQpFUElfMTA0X0NHWywxMl0gPC0gIkVQSV8xMDQiCgpFUElfMTExX0NHWywxMF0gPC0gcm93U3VtcyhjYmluZChFUElfMTExX0NHJGBXYXRzb24gTUVUSGAsIEVQSV8xMTFfQ0ckYENyaWNrIE1FVEhgKSwgbmEucm0gPSBUUlVFKQpFUElfMTExX0NHWywxMV0gPC0gcm93U3VtcyhjYmluZChFUElfMTExX0NHJGBXYXRzb24gQ09WRVJBR0VgLCBFUElfMTExX0NHJGBDcmljayBDT1ZFUkFHRWApLCBuYS5ybSA9IFRSVUUpCkVQSV8xMTFfQ0dbLDEyXSA8LSAiRVBJXzExMSIKCkVQSV8xMTNfQ0dbLDEwXSA8LSByb3dTdW1zKGNiaW5kKEVQSV8xMTNfQ0ckYFdhdHNvbiBNRVRIYCwgRVBJXzExM19DRyRgQ3JpY2sgTUVUSGApLCBuYS5ybSA9IFRSVUUpCkVQSV8xMTNfQ0dbLDExXSA8LSByb3dTdW1zKGNiaW5kKEVQSV8xMTNfQ0ckYFdhdHNvbiBDT1ZFUkFHRWAsIEVQSV8xMTNfQ0ckYENyaWNrIENPVkVSQUdFYCksIG5hLnJtID0gVFJVRSkKRVBJXzExM19DR1ssMTJdIDwtICJFUElfMTEzIgoKRVBJXzExOV9DR1ssMTBdIDwtIHJvd1N1bXMoY2JpbmQoRVBJXzExOV9DRyRgV2F0c29uIE1FVEhgLCBFUElfMTE5X0NHJGBDcmljayBNRVRIYCksIG5hLnJtID0gVFJVRSkKRVBJXzExOV9DR1ssMTFdIDwtIHJvd1N1bXMoY2JpbmQoRVBJXzExOV9DRyRgV2F0c29uIENPVkVSQUdFYCwgRVBJXzExOV9DRyRgQ3JpY2sgQ09WRVJBR0VgKSwgbmEucm0gPSBUUlVFKQpFUElfMTE5X0NHWywxMl0gPC0gIkVQSV8xMTkiCgpjb2xuYW1lcyhFUElfMTA0X0NHKVsxMDoxMl0gPC0gYygiVG90YWxNZXRoMTA0IiwgIlRvdGFsQ292MTA0IiwgIlNhbXBsZU5hbWUiKQpjb2xuYW1lcyhFUElfMTExX0NHKVsxMDoxMl0gPC0gYygiVG90YWxNZXRoMTExIiwgIlRvdGFsQ292MTExIiwgIlNhbXBsZU5hbWUiKQpjb2xuYW1lcyhFUElfMTEzX0NHKVsxMDoxMl0gPC0gYygiVG90YWxNZXRoMTEzIiwgIlRvdGFsQ292MTEzIiwgIlNhbXBsZU5hbWUiKQpjb2xuYW1lcyhFUElfMTE5X0NHKVsxMDoxMl0gPC0gYygiVG90YWxNZXRoMTE5IiwgIlRvdGFsQ292MTE5IiwgIlNhbXBsZU5hbWUiKQoKCgoKCgp0ZXN0Lm1ldGggPC0gbWVyZ2UoRVBJXzEwNF9DR1ssYygxLCAyLCAzLCAxMCldLCBFUElfMTExX0NHWyxjKDEsIDIsIDMsIDEwKV0sIGJ5ID0gbmFtZXMoRVBJXzExMV9DR1ssYygxLDIsMyldKSwgYWxsID0gVCkKCnRlc3QubWV0aDIgPC0gbWVyZ2UodGVzdC5tZXRoLCBFUElfMTEzX0NHWyxjKDEsIDIsIDMsIDEwKV0sIGFsbCA9IFQpCgp0ZXN0Lm1ldGgzIDwtIG1lcmdlKHRlc3QubWV0aDIsIEVQSV8xMTlfQ0dbLGMoMSwgMiwgMywgMTApXSwgYWxsID0gVCkKCmhlYWQodGVzdC5tZXRoMykKYGBgCgo=