hit 'Shift-ENTER' to execute each cell.
ls /mnt
lost+found/ titus/
cd /mnt/titus
/mnt/titus
import csv
r = csv.reader(open('salm.x.ecoli.csv', 'r'))
outfp = open('filtered.csv', 'w')
w = csv.writer(outfp)
scores = []
for row in r:
name1, descr1, name2, descr2, bitscore, evalue = row
bitscore = float(bitscore)
if bitscore > 100:
w.writerow([name1, descr1, name2, descr2, bitscore, evalue])
outfp.close()
print open('filtered.csv').read(500)
ref|YP_008253424.1|,membrane protein [Salmonella enterica subsp. enterica serovar Typhimurium var. 5- str. CFSAN001921],ref|NP_417733.1|,putative outer membrane protein [Escherichia coli str. K-12 substr. MG1655],119.0,4e-29 ref|YP_008253425.1|,multidrug transporter [Salmonella enterica subsp. enterica serovar Typhimurium var. 5- str. CFSAN001921],ref|NP_417732.1|,multidrug efflux system protein [Escherichia coli str. K-12 substr. MG1655],1744.0,1e-300 ref|YP_008253425.1|,multidrug transporter