Mercurial > repos > eschen42 > mqppep_anova
comparison search_ppep.py @ 6:922d309640db draft
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/mqppep commit 9dfb7e07a3673d7de4b0a1b7e6ce1b75a8a4f42b"
| author | eschen42 |
|---|---|
| date | Fri, 11 Mar 2022 20:04:05 +0000 |
| parents | d4d531006735 |
| children |
comparison
equal
deleted
inserted
replaced
| 5:d4d531006735 | 6:922d309640db |
|---|---|
| 514 """ | 514 """ |
| 515 ) | 515 ) |
| 516 for row in ker.fetchall(): | 516 for row in ker.fetchall(): |
| 517 print(row[0]) | 517 print(row[0]) |
| 518 | 518 |
| 519 # link peptides not found in sequence database to a dummy sequence-record | |
| 520 ker.execute( | |
| 521 """ | |
| 522 INSERT INTO deppep_UniProtKB(deppep_id,UniProtKB_id,pos_start,pos_end) | |
| 523 SELECT id, 'No Uniprot_ID', 0, 0 | |
| 524 FROM deppep | |
| 525 WHERE id NOT IN (SELECT deppep_id FROM deppep_UniProtKB) | |
| 526 """ | |
| 527 ) | |
| 528 | |
| 519 con.commit() | 529 con.commit() |
| 520 ker.execute("vacuum") | 530 ker.execute("vacuum") |
| 521 con.close() | 531 con.close() |
| 522 | 532 |
| 523 | 533 |