An Informatics system for Transcriptome Analysis Data

View the Project on GitHub

TransAtlasDB Downloads

TransAtlasDB can be deployed on Ubuntu Linux and Mac OSX operating systems using the latest available MySQL and FastBit software and Perl programming language.

However, for an easier and quicker install process, the VM appliance is configured with the Ubuntu 16.04 OS and contains all the required programs and perl dependencies listed below.

The following are required for successful utilization of TransAtlasDB toolkit on your local machine or server.

  1. Relational Database - MySQL

  2. For Mac OSX

    1. The MySQL community server is required and can be downloaded here.

    2. Download the DMG Archive file.

    3. Unpack the download .dmg file.

    4. Click on the mysql server package from unpacked files and complete the installation process.
      Once the installer has finished successfully, all MySQL related files should be installed under /usr/local/mysql-VERSION directory. A link /usr/local/mysql (pointing to the MySQL installation directory) should also have been created.
      IMPORTANT: Save the mysql temporary password provided.

    5. Setup auto start package for MySQL on OS X, by
      • Restarting the operating system, or
      • STARTing the mysql server in your System Preferences.
    1. Add the mysql location (/usr/local/mysql/bin/) to your PATH. Save this path in your profile - $HOME/.bash_profile.
      echo 'export PATH=${PATH}:/usr/local/mysql/bin' >> $HOME/.bash_profile 
    2. Create aliases of mysql in your profile - $HOME/.bash_profile.
      echo 'alias mysqladmin=/usr/local/mysql/bin/mysqladmin' >> $HOME/.bash_profile
      echo 'alias mysql=/usr/local/mysql/bin/mysql' >> $HOME/.bash_profile
    3. Reload your updated profile
      source $HOME/.bash_profile
    4. Log into mysql using the syntax below and paste the temporary password when requested
      mysql -uroot -p
    5. In the mysql interface, change temporary password to a new password
      NOTE: Avoid using special characters such as $ & ! \ [ ] < > `
      SET PASSWORD=PASSWORD('your_new_password');
    6. Exit from MySQL

    For Ubuntu

    1. Update apt-get
      sudo apt-get update
    2. Install mysql-server & set your mysql password when prompted
      NOTE: Avoid using special characters such as $ & ! \ [ ] < > `
      sudo apt-get install mysql-server
    3. Install the mysqlclient
      sudo apt-get install libmysqlclient-dev
    You have successfully installed MySQL !

  3. Non-Relational Database - FastBit

  4. The FastBit software can be downloaded here.
    Once downloaded.

    1. Unzip the file.
    2. Unpack the download .tar.gz file.
      tar -xzvf fastbit-version.tar.gz
    3. In the unpacked directory, configure the fastbit software.
      ( if Mac OSX: ensure Xcode install has been previously configured; the option to install with automatically appear when you run the command below ).
      NOTE: This step takes about 15 - 30 minutes to complete.
      ./configure && make
    4. Install the fastbit software.
      sudo make install
    5. Add the library path to your profile
      • For Mac OSX: Your profile is $HOME/.bash_profile
      • For Ubuntu: Your profile is $HOME/.bashrc
      # Mac OSX
      echo 'export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/lib' >> $HOME/.bash_profile
      # Ubuntu
      echo 'export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/lib' >> $HOME/.bashrc
    6. Reload your updated profile
      # Mac OSX
      source $HOME/.bash_profile
      # Ubuntu
      source $HOME/.bashrc
    You have successfully installed FastBit !

  5. Perl modules

  6. The easiest way to install Perl modules is using cpanminus.

    1. Install cpanm using curl
      NOTE: Users must have admin access to use sudo
      # Mac OSX
      curl -L | perl - App::cpanminus --sudo
      # Ubuntu
      sudo apt install cpanminus
    2. Install required Perl modules
      1. DBD::mysql
        sudo cpanm DBD::mysql
      2. Spreadsheet::Read
        sudo cpanm Spreadsheet::Read
      3. Spreadsheet::XLSX
        sudo cpanm Spreadsheet::XLSX
      4. Text::TabularDisplay
        sudo cpanm Text::TabularDisplay
      5. Sort::Key
        sudo cpanm Sort::Key
    You have successfully installed the required Perl modules !


  8. Have required PHP and Apache dependencies with MySQL installed on desired local machine or server.

    • Recommended configuration for Ubuntu here.
    • Recommended configuration for Mac OSX here.
    You have successfully installed configured Apache and PHP with MySQL !

  9. SAM Tools Package

  10. SAMtools can be installed from the download page using the provided link.

    You have successfully installed SAM Tools !
    ==> Proceed to the Tutorial <==

VM Applicance

The virtual machince appliance (VMA) is configured on Ubuntu 16.04 OS with all the above software and dependencies already installed.
This method provide users an easy way to get started on installing and using TransAtlasDB independent of the host operating system. The VMA can be imported on all virtual machines, such as VirtualBox, VMware.
IMPORTANT: Ensure the vma download has the extension .ova to avoid import complications.

VMA User Login details are provided below:
  • Ubuntu Account:
    user account : TransAtlasDB
    user pasword : rainbow

  • MySQL Root Login
    username : root
    password : rainbow
==> Proceed to the Tutorial <==

Please click the menu items to navigate through this repository. If you have questions, comments and bug reports, please email me directly.

Thank you very much for your help and support!