This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
for i in *.bam; do echo -n -e $i'\t'; samtools flagstat $i | head -n1 | cut -c 1-8; done |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"metadata": { | |
"name": "", | |
"signature": "sha256:1aae1f7a5ceff5b5a6cf0eb36c31f2be3a6f6ffb7d63b276d6d3a150abb85555" | |
}, | |
"nbformat": 3, | |
"nbformat_minor": 0, | |
"worksheets": [ | |
{ | |
"cells": [ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Add entry to pg_hba.conf (at the bottom of the file) of the form. | |
host all all USERS-IP md5 | |
(Also note that pg_hba.conf will be in the directory of the default database, usually postgres but can be something else.) | |
2. Go into postgresql.conf (also in the same database directory with pg_hba.conf) and edit listen_addresses='*' | |
3. Log into the database under admin account and issue the following commands for username='new_user' on database='host_db' with password='tmp_password' and schema='escherichia' | |
CREATE ROLE new_user WITH PASSWORD 'tmp_password'; |