[Standard] Combining SNP data tables (MW)

Description

This question concerns SNPs in the dog genome. On this webpage you will find to coordinates of 2.8M SNPs in the dog genome. There is one file each for the canfam2 and canfam3 genome assemblies.

Objective

  1. Your task is to generate a new file that contains the SNP positions on each assembly as separate columns. The file should contain the following columns: 1) SNP ID, 2) bases (e.g. AT) 3) chromosome (canfam2) 4) position (canfam2) 5) chromosome (canfam3) 6) position (canfam3).

Bonus points

  1. Print the distance between each SNP on the two assemblies, count the number of each type of SNP and perform an additional analysis of your choice.