Guest User

Untitled

a guest
Feb 27th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. import fdb
  2.  
  3. con = fdb.connect(dsn='molgenvz.cde.ua.ac.be:/home/firebird/gentli.fdb',
  4. user='wdc',
  5. password="mypassword",
  6. role='NBD_SC')
  7. cur = con.cursor()
  8. cur.execute('select "id", "sample_individual", "sample_sample", "experiment_id", \
  9. "experiment_description", "wes_project" from "NBD_SC:full_wes" \
  10. where \
  11. "wes_exome_capture_kit" = ? and \
  12. "ngs_seq_pct_target20x" > ?', (kit, min_cov_frac))
  13. res = [cur.fetchall()]
Add Comment
Please, Sign In to add comment