#!/bin/bash

dir=`pwd`

rm $dir/ALL_Protomers_worked

for i in `cat FINISHED_WORKED`;
do

cd ${i}_worked_build

grep "REAL3" ${i}_worked.xls >> $dir/ALL_Protomers_worked

cd $dir

done

awk '{print $2}' $dir/ALL_Protomers_worked | sort -u > PROTOMERS_WORKED-uniq

awk '$5==0' $dir/ALL_Protomers_worked > PROTOMERS_WORKED-neutral

awk '$5==-1' $dir/ALL_Protomers_worked > PROTOMERS_WORKED-mon-anion

awk '$5<=-2' $dir/ALL_Protomers_worked > PROTOMERS_WORKED-mult-anion