MySQL database

The input data for HotMAPS can also be prepared by directly using the MuPIT MySQL database. A MySQL dump of the MuPIT database containing m[utation counts in our study and associated tables that map genome coordinates to PDB structures is available here. The MuPIT database has a fairly large file size, you may want to directly download and upload to MYSQL.

$ wget https://www.dropbox.com/scl/fi/2fvqta3mcpy0jjs8ta3fc/mupit_modbase.sql.gz?rlkey=z2ud0kaqyr1p23kryuxv9o168&st=21vhlb4f&dl=1 -o mupit_modbase.sql.gz
$ gunzip mupit_modbase.sql.gz
$ mysql [options] < mupit_modbase.sql

This will create a database named mupit_modbase, where [options] is the necessary MySQL parameters to login. You will need sufficient privileges on your MySQL database to CREATE a new database. For running HotMAPS, you should also have SELECT, DELETE, DROP, and UPDATE privileges (see here).