!head /Volumes/web/cnidarian/BiGo_larvae_merge/CgM1_[0316_0954]/filt_methratio_CgM1.igv
C12768 102 104 CpG 0.167 C12806 141 143 CpG 0.333 C12924 29 31 CpG 0.000 C12924 37 39 CpG 0.000 C12924 51 53 CpG 0.000 C12924 59 61 CpG 0.000 C12924 126 128 CpG 0.000 C12924 135 137 CpG 0.000 C13128 86 88 CpG 0.000 C13208 82 84 CpG 0.400
!awk '{print ($1"_"$2),$1,$2,$3,$4,$5}' </Volumes/web/cnidarian/BiGo_larvae_merge/CgM1_[0316_0954]/filt_methratio_CgM1.igv> \
/Volumes/web/cnidarian/BiGo_larvae_merge/CgM1_[0316_0954]/filt_methratio_CgM1_id.tab
!head /Volumes/web/cnidarian/BiGo_larvae_merge/CgM1_[0316_0954]/filt_methratio_CgM1_id.tab
C12768_102 C12768 102 104 CpG 0.167 C12806_141 C12806 141 143 CpG 0.333 C12924_29 C12924 29 31 CpG 0.000 C12924_37 C12924 37 39 CpG 0.000 C12924_51 C12924 51 53 CpG 0.000 C12924_59 C12924 59 61 CpG 0.000 C12924_126 C12924 126 128 CpG 0.000 C12924_135 C12924 135 137 CpG 0.000 C13128_86 C13128 86 88 CpG 0.000 C13208_82 C13208 82 84 CpG 0.400
#Location of SQLShare python tools: you can empty ("") if tools are in PATH
spd="/Users/sr320/sqlshare-pythonclient/tools/"
!python {spd}singleupload.py -d filt_methratio_CgM1_id /Volumes/web/cnidarian/BiGo_larvae_merge/CgM1_[0316_0954]/filt_methratio_CgM1_id.tab
processing chunk line 0 to 380223 (3.3083050251 s elapsed) pushing /Volumes/web/cnidarian/BiGo_larvae_merge/CgM1_[0316_0954]/filt_methratio_CgM1_id.tab... parsing 2A8E1985... finished filt_methratio_CgM1_id
!head /Volumes/web/cnidarian/BiGo_larvae_merge/CgM3_[0316_1207]/filt_methratio_CgM3.igv
C13128 86 88 CpG 0.000 C13208 82 84 CpG 0.429 C13442 64 66 CpG 0.000 C13442 78 80 CpG 0.000 C13612 88 90 CpG 0.000 C13992 53 55 CpG 0.000 C14180 157 159 CpG 0.000 C14180 192 194 CpG 0.000 C14220 95 97 CpG 0.000 C14220 142 144 CpG 0.000