Dear all
I aattach the file I want to parse and I wanto to create a sqlite database.
The problem is I'm not able to create in the right way because there is some
logic problems on my script. I have this code:
import sqlite
import sqlite3
import os
# Creates or opens a file called mydb with a SQLite3 DB
db = sqlite3.connect('Fastqcd_completo.db')
cursor = db.cursor()
create_table_sql = """
create table fastqc_summary (
fileid varchar,
module varchar,
status varchar,
total int,
duplicate varchar
);"""
cursor.execute(create_table_sql)
create_table_sql2="""
create table fastqc_details (
id serial primary key,
fileid varchar,
module varchar,
col1 varchar,
ocols varchar
);
"""
cursor.execute(create_table_sql2)
db.commit()
for root, dirs, files in
os.walk("/home/mauro/Desktop/LAVORO_CRO/2014/Statitica_RNAseqalign/FASTQC_completo/fastqcdecembre/"):
# walk a r
for name in files:
if (name == "fastqc_data.txt"):
fileid = name # use string slicing here if you only want part of the
with open(os.path.join(root,name),"r") as p: # automatically close
the file when done
for i in p:
line =i.strip()
if "Filename" in line:
fileid = line.split()[1]
if "Total Sequence" in line:
total = line.split()[2]
if "Total Duplicate" in line:
dup = line.split()[3]
if (line[:2] == ">>" and line[:12] != ">>END_MODULE"):
module = line[2:-5] # grab module name
status = line[-4:] # and overall status pass/warn/fail
sql = "insert into
fastqc_summary(fileid,module,status,total,duplicate) values(?,?,?,?,?);"
data = (fileid,module,status,total,dup)
cursor.execute(sql,data)
elif (line[:2] != ">>" and line[:2] != "##"): # grab
details under each module
cols = line.split("\t")
col1 = cols[0]
ocols = "|".join(cols[1:])
sql = "insert into
fastqc_details(fileid,module,col1,ocols) values(?,?,?,?);"
data = (fileid,module,col1,ocols)
cursor.execute(sql,data)
db.commit()
So the problem is how to excatct only some parts of the files. In red are the
point of the problems. The say the Filename are not defined On the file atached
I want to take this part and use for create the database:
##FastQC 0.10.1
>>Basic Statistics pass
#Measure Value
Filename R05_CTTGTA_L004_R1_001.fastq.gz
File type Conventional base calls
Encoding Sanger / Illumina 1.9
Total Sequences 27868496
Filtered Sequences 0
Sequence length 50
%GC 50
>>END_MODULE
How can I resolve this problem? I need to use the number of rows?
bw,
##FastQC 0.10.1
>>Basic Statistics pass
#Measure Value
Filename R05_CTTGTA_L004_R1_001.fastq.gz
File type Conventional base calls
Encoding Sanger / Illumina 1.9
Total Sequences 27868496
Filtered Sequences 0
Sequence length 50
%GC 50
>>END_MODULE
>>Per base sequence quality pass
#Base Mean Median Lower Quartile Upper Quartile 10th Percentile 90th
Percentile
1 32.90529076273079 34.0 31.0 34.0 31.0 34.0
2 33.100253167591106 34.0 33.0 34.0 31.0 34.0
3 33.219579520904176 34.0 34.0 34.0 31.0 34.0
4 36.53049856009452 37.0 37.0 37.0 35.0 37.0
5 36.441143289540996 37.0 37.0 37.0 35.0 37.0
6 36.400846174117184 37.0 37.0 37.0 35.0 37.0
7 36.38746253116781 37.0 37.0 37.0 35.0 37.0
8 36.36443940139432 37.0 37.0 37.0 35.0 37.0
9 38.22529985112939 39.0 39.0 39.0 37.0 39.0
10 38.215059327205886 39.0 39.0 39.0 37.0 39.0
11 38.252484848841505 39.0 39.0 39.0 37.0 39.0
12 38.22672156401982 39.0 39.0 39.0 37.0 39.0
13 38.164828234720666 39.0 39.0 39.0 37.0 39.0
14 39.76166327741547 41.0 40.0 41.0 38.0 41.0
15 39.765876098947 41.0 40.0 41.0 38.0 41.0
16 39.74199730764086 41.0 40.0 41.0 37.0 41.0
17 39.07676352538006 41.0 40.0 41.0 36.0 41.0
18 39.42998348385934 41.0 39.0 41.0 36.0 41.0
19 39.57992178695255 41.0 40.0 41.0 37.0 41.0
20 39.438335638923604 41.0 40.0 41.0 37.0 41.0
21 39.54068827395637 41.0 40.0 41.0 37.0 41.0
22 39.464387565084245 41.0 40.0 41.0 37.0 41.0
23 39.227799196626904 41.0 39.0 41.0 36.0 41.0
24 39.349455062088744 41.0 39.0 41.0 36.0 41.0
25 39.38084283414505 41.0 39.0 41.0 36.0 41.0
26 39.29243497747421 41.0 39.0 41.0 36.0 41.0
27 39.26697906481929 41.0 39.0 41.0 36.0 41.0
28 39.184627688555565 41.0 39.0 41.0 36.0 41.0
29 39.14554377100221 40.0 39.0 41.0 36.0 41.0
30 39.12001440623132 40.0 39.0 41.0 36.0 41.0
31 39.04045833689769 40.0 39.0 41.0 35.0 41.0
32 38.9482415197433 40.0 39.0 41.0 35.0 41.0
33 38.84069972774993 40.0 38.0 41.0 35.0 41.0
34 38.72765430183244 40.0 38.0 41.0 35.0 41.0
35 38.58004920681762 40.0 38.0 41.0 35.0 41.0
36 38.4478375869297 40.0 38.0 41.0 34.0 41.0
37 38.322173180784496 40.0 38.0 41.0 34.0 41.0
38 38.227387907836864 40.0 38.0 41.0 34.0 41.0
39 38.11976530775109 40.0 37.0 41.0 34.0 41.0
40 38.14086938886117 40.0 37.0 41.0 34.0 41.0
41 38.15597702150844 40.0 37.0 41.0 34.0 41.0
42 37.973637508102335 40.0 37.0 41.0 34.0 41.0
43 38.097268614711034 40.0 37.0 41.0 34.0 41.0
44 38.04950636733321 40.0 37.0 41.0 34.0 41.0
45 37.62462089809224 40.0 36.0 41.0 33.0 41.0
46 37.73354195360955 40.0 36.0 41.0 33.0 41.0
47 37.608081254187525 40.0 36.0 41.0 33.0 41.0
48 37.5684216686828 40.0 35.0 41.0 33.0 41.0
49 37.39912763860669 39.0 35.0 41.0 33.0 41.0
50 36.83706458360724 39.0 35.0 41.0 33.0 41.0
>>END_MODULE
>>Per sequence quality scores pass
#Quality Count
2 874.0
3 18.0
4 80.0
5 167.0
6 205.0
7 236.0
8 567.0
9 446.0
10 629.0
11 903.0
12 1225.0
13 1896.0
14 2918.0
15 4034.0
16 5269.0
17 6736.0
18 8190.0
19 10241.0
20 12193.0
21 14762.0
22 18197.0
23 22609.0
24 28515.0
25 36090.0
26 50150.0
27 70030.0
28 98941.0
29 138161.0
30 191913.0
31 254400.0
32 336510.0
33 464881.0
34 693760.0
35 1010813.0
36 1720754.0
37 3014844.0
38 5431130.0
39 1.4215209E7
>>END_MODULE
>>Per base sequence content fail
#Base G A T C
1 47.74738725623603 8.472574441550554 5.714737503136125
38.06530079907729
2 29.46250490159211 10.56883729929308 34.67189976811091
25.296758031003897
3 29.225825462558152 12.862100631480079 22.867789492479247
35.04428441348252
4 32.74084112755852 20.958859782027705 19.71756208157053
26.58273700884325
5 33.69965497958699 24.8594829085861 21.981469685339317
19.4593924264876
6 27.787333769285578 28.55180631204497 24.513974489330174
19.14688542933928
7 20.210046498382976 24.5745805586351 39.16698267463016
16.04839026835176
8 24.20494685699112 21.261125583998965 32.313486339268415
22.220441219741495
9 23.82639113056885 20.774427485901278 34.57401557974951
20.825165803780358
10 23.025494450794906 33.58635858928304 25.42061114456984
17.967535815352218
11 28.777064252050057 25.730656580821588 20.542138334268202
24.95014083286016
12 26.436984615172634 21.600720756513017 25.84038621962233
26.121908408692025
13 24.59188325053494 23.60112651935002 28.32585224548896
23.48113798462608
14 24.954600053644942 25.212092179590346 26.86321885790101
22.970088908863705
15 26.777721684793704 23.70371053474922 26.681045911160556
22.83752186929652
16 26.57934967139956 23.602615656044016 27.134216356706155
22.68381831585027
17 26.579432904714327 24.800204619864704 26.22104313501861
22.399319340402354
18 25.045451885231923 24.59052935106151 25.60434492285389
24.759673840852685
19 26.69571186298298 24.466991294514997 25.091928430299514
23.745368412202513
20 25.426271402382827 25.756163072766174 25.556081494255363
23.26148403059564
21 25.815024491668126 25.895990581753413 25.38901238773284
22.89997253884562
22 26.049704160017956 25.963713324215952 24.234799801901342
23.75178271386475
23 25.293863106682995 26.42627691201157 24.615547305469757
23.66431267583568
24 24.998690277365522 27.230357174639064 25.12644026430418
22.644512283691235
25 25.8648774209698 25.963053030366368 24.44045554200418
23.73161400665965
26 26.11759529470123 25.67549393408241 25.288408100673966
22.91850267054239
27 27.14507808386933 25.119177583174924 24.828519630194613
22.907224702761138
28 25.40991089006023 25.681303361329583 24.767163610120903
24.141622138489282
29 25.084163135319535 26.19492275435316 25.38421879673736
23.33669531358994
30 25.121269551108895 26.90342887538674 24.824012749019538
23.151288824484823
31 24.74644015804009 27.167496544111007 24.694800973662904
23.391262324186
32 25.97013487918401 26.55884264439674 24.431207195393682
23.03981528102557
33 25.58406452935243 24.40673511767553 23.99487937921013
26.01432097376191
34 27.082950209464173 25.783963386030724 24.268570857932055
22.86451554657305
35 26.623955594876737 25.881773454871766 24.09915841888274
23.395112531368753
36 25.48568103567555 25.140990744531027 24.901745684445977
24.47158253534744
37 26.348379187739447 25.7436963946673 23.808138049502205
24.099786368091053
38 26.177724122607838 25.884392900140718 24.52811231722013
23.409770660031313
39 25.27979981409833 25.36202168929389 24.990778117340813
24.367400379266968
40 26.148427404308645 25.12479062815018 24.148146011126045
24.57863595641513
41 27.252622703391964 25.207351470925012 23.60566896205169
23.934356863631336
42 25.17832167367942 25.08192808844053 25.169210877680403
24.570539360199646
43 28.368420580483455 24.565721083028475 24.77703399759223
22.288824338895836
44 28.268481828454895 25.60956486554723 23.13917903769173
22.982774268306144
45 26.577346344974757 26.36663052587631 25.22720344741156
21.82881968173737
46 27.257742905870824 24.797429523760588 25.30717854191169
22.637649028456895
47 26.41425921684439 24.658683137090573 25.138670207778624
23.788387438286414
48 25.376276609369008 25.48944280370547 25.309253170937435
23.82502741598809
49 26.93336243261894 24.48996977121524 25.365130068172924
23.211537727992898
50 25.171216974354593 25.611867522063747 25.826257455956835
23.390658047624825
>>END_MODULE
>>Per base GC content fail
#Base %GC
1 85.81268805531333
2 54.75926293259601
3 64.27010987604066
4 59.323578136401764
5 53.15904740607459
6 46.93421919862485
7 36.25843676673474
8 46.425388076732624
9 44.65155693434921
10 40.99303026614712
11 53.72720508491021
12 52.55889302386465
13 48.07302123516102
14 47.92468896250865
15 49.61524355409023
16 49.26316798724984
17 48.97875224511669
18 49.805125726084604
19 50.44108027518549
20 48.68775543297847
21 48.71499703051374
22 49.80148687388271
23 48.95817578251867
24 47.64320256105676
25 49.59649142762945
26 49.03609796524362
27 50.05230278663046
28 49.551533028549514
29 48.42085844890948
30 48.27255837559372
31 48.13770248222609
32 49.009950160209584
33 51.59838550311434
34 49.947465756037225
35 50.01906812624549
36 49.95726357102299
37 50.44816555583049
38 49.58749478263915
39 49.6472001933653
40 50.727063360723776
41 51.18697956702331
42 49.748861033879066
43 50.657244919379295
44 51.25125609676105
45 48.40616602671213
46 49.89539193432772
47 50.2026466551308
48 49.201304025357096
49 50.14490016061184
50 48.56187502197942
>>END_MODULE
>>Per sequence GC content fail
#GC Content Count
0 417.0
1 373.0
2 329.0
3 347.5
4 366.0
5 524.0
6 682.0
7 893.0
8 1104.0
9 1508.5
10 1913.0
11 2757.0
12 3601.0
13 5264.5
14 6928.0
15 10160.5
16 13393.0
17 19728.5
18 26064.0
19 36414.0
20 46764.0
21 63316.5
22 79869.0
23 103826.0
24 127783.0
25 160211.5
26 192640.0
27 234315.0
28 275990.0
29 326691.5
30 377393.0
31 436528.0
32 495663.0
33 581591.5
34 667520.0
35 733258.0
36 798996.0
37 900814.0
38 1002632.0
39 1042647.5
40 1082663.0
41 1200881.0
42 1319099.0
43 1553938.5
44 1788778.0
45 2003227.0
46 2217676.0
47 2095793.5
48 1973911.0
49 2076889.5
50 2179868.0
51 1953283.0
52 1726698.0
53 1690380.0
54 1654062.0
55 1682835.5
56 1711609.0
57 1754331.5
58 1797054.0
59 1852801.0
60 1908548.0
61 1603200.0
62 1297852.0
63 1087091.0
64 876330.0
65 761676.0
66 647022.0
67 546918.0
68 446814.0
69 435612.0
70 424410.0
71 334935.5
72 245461.0
73 211052.5
74 176644.0
75 148601.0
76 120558.0
77 92270.0
78 63982.0
79 44952.0
80 25922.0
81 35024.0
82 44126.0
83 28509.5
84 12893.0
85 8773.0
86 4653.0
87 2941.0
88 1229.0
89 790.0
90 351.0
91 231.0
92 111.0
93 84.0
94 57.0
95 50.0
96 43.0
97 30.0
98 17.0
99 12.5
100 8.0
>>END_MODULE
>>Per base N content pass
#Base N-Count
1 0.08479108452784823
2 0.0
3 0.0
4 0.0
5 0.0
6 0.0
7 0.0
8 0.0010621312323420683
9 4.30593742841379E-5
10 0.0
11 0.0
12 0.0
13 0.0
14 2.547679645144826E-4
15 3.121804635599998E-4
16 0.0
17 8.396577985406891E-4
18 5.382421785517238E-5
19 0.003204335102977929
20 0.003096686667267584
21 1.3994296642344818E-4
22 0.00564436631241241
23 0.001804905438743447
24 0.0
25 2.404148397531033E-4
26 0.0
27 0.0
28 0.0
29 0.0
30 0.0
31 4.4494686760275835E-4
32 0.0
33 0.0
34 2.5117968332413775E-5
35 0.0
36 0.0
37 0.0
38 0.0
39 0.0
40 6.100078023586203E-5
41 4.0906405569931007E-4
42 0.0016470210663682746
43 0.0012415452918593094
44 0.0015070780999448265
45 0.0022642054311075846
46 0.0023826187103889638
47 1.3276640404275854E-4
48 0.0022713819934882746
49 0.0024651491777668948
50 0.005439834284562755
>>END_MODULE
>>Sequence Length Distribution pass
#Length Count
50 2.7868496E7
>>END_MODULE
>>Sequence Duplication Levels fail
#Total Duplicate Percentage 74.1779737104926
#Duplication Level Relative count
1 100.0
2 19.425236164178056
3 5.374932608237032
4 2.612847018744677
5 1.803364509348898
6 1.426751990498738
7 1.1188986037208066
8 0.9298109905221787
9 0.8126079244899713
10++ 22.766304899869514
>>END_MODULE
>>Overrepresented sequences warn
#Sequence Count Percentage Possible Source
GGGAGTTTGACTGGGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCCT 193893
0.6957426048395292 No Hit
CTTCGATGTCGGCTCTTCCTATCATTGTGAAGCAGAATTCACCAAGCGTT 161113
0.5781187474200258 No Hit
GGGGAGTTTGACTGGGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCC 121272
0.43515803651549767 No Hit
GATCGGAAGAGCACACGTCTGAACTCCAGTCACCTTGTAATCTCGTATGC 104920
0.37648246249097905 TruSeq Adapter, Index 12 (100% over 50bp)
GTTGGTTTTCGGAACTGAGGCCATGATTAAGAGGGACGGCCGGGGGCATT 99637
0.35752557296238735 No Hit
GGCGGGAGTAACTATGACTCTCTTAAGGTAGCCAAATGCCTCGTCATCTA 85580
0.30708510426971014 No Hit
CGACTGTTTAATTAAAACAAAGCATCGCGAAGGCCCGCGGCGGGTGTTGA 78501
0.2816836617232591 No Hit
GCCCAGTGCTCTGAATGTCAAAGTGAAGAAATTCAATGAAGCGCGGGTAA 78050
0.2800653469064136 No Hit
CTGGGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCCTAAGGCGAGCT 77370
0.2776253156969791 No Hit
GTGGGGAGTTTGACTGGGGCGGTACACCTGTCAAACGGTAACGCAGGTGT 75219
0.2699069228565474 No Hit
GTCGGCTCTTCCTATCATTGTGAAGCAGAATTCACCAAGCGTTGGATTGT 74520
0.2673987143044964 No Hit
GTCGCTTTTTGATCCTTCGATGTCGGCTCTTCCTATCATTGTGAAGCAGA 68122
0.2444408912486702 No Hit
GGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCCTAAGGCGAGCTCAG 66674
0.23924506008505086 No Hit
CCGAAAGATGGTGAACTATGCCTGGGCAGGGCGAAGCCAGAGGAAACTCT 66311
0.23794251401295569 No Hit
GTGAACTATGCCTGGGCAGGGCGAAGCCAGAGGAAACTCTGGTGGAGGTC 59593
0.21383644097621918 No Hit
GTCTGTGATGCCCTTAGATGTCCGGGGCTGCACGCGCGCTACACTGACTG 58364
0.2094264433932854 No Hit
GTTGGATTGTTCACCCACTAATAGGGAACGTGAGCTGGGTTTAGACCGTC 58248
0.20901020277520535 No Hit
CAGAAAAGTTACCACAGGGATAACTGGCTTGTGGCGGCCAAGCGTTCATA 55553
0.19933978496722604 No Hit
GTTTAATTAAAACAAAGCATCGCGAAGGCCCGCGGCGGGTGTTGACGCGA 55434
0.198912779505575 No Hit
GGGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCCTAAGGCGAGCTCA 54368
0.19508767175666744 No Hit
GTTTTAAGCAGGAGGTGTCAGAAAAGTTACCACAGGGATAACTGGCTTGT 54010
0.193803067090524 No Hit
GTGGCGGCCAAGCGTTCATAGCGACGTCGCTTTTTGATCCTTCGATGTCG 49897
0.17904446655463574 No Hit
GGGTTTTAAGCAGGAGGTGTCAGAAAAGTTACCACAGGGATAACTGGCTT 48985
0.17577195410904126 No Hit
GGTGAACTATGCCTGGGCAGGGCGAAGCCAGAGGAAACTCTGGTGGAGGT 48531
0.17414287444862472 No Hit
GTTGTTGCCATGGTAATCCTGCTCAGTACGAGAGGAACCGCAGGTTCAGA 47687
0.17111436512397368 No Hit
GCTCGCTTGATCTTGATTTTCAGTACGAATACAGACCGTGAAAGCGGGGC 47549
0.1706191823197061 No Hit
GTCCGTAGCGGTCCTGACGTGCAAATCGGTCGTCCGACCTGGGTATAGGG 47289
0.16968622921021645 No Hit
GTGCGGACCAGGGGAATCCGACTGTTTAATTAAAACAAAGCATCGCGAAG 46646
0.16737896440482472 No Hit
CCCGAAAGATGGTGAACTATGCCTGGGCAGGGCGAAGCCAGAGGAAACTC 44811
0.16079446842054196 No Hit
GCTGGGTTTAGACCGTCGTGAGACAGGTTAGTTTTACCCTACTGATGATG 43378
0.15565246147477782 No Hit
GTCCTAAGGCGAGCTCAGGGAGGACAGAAACCTCCCGTGGAGCAGAAGGG 43110
0.1546908021157654 No Hit
GTCGGCATGTATTAGCTCTAGAATTACCACAGTTATCCAAGTAGGAGAGG 40407
0.14499167805826335 No Hit
GCCCTATCAACTTTCGATGGTAGTCGCCGTGCCTACCATGGTGACCACGG 39887
0.14312577183928404 No Hit
GGGTAAACGGCGGGAGTAACTATGACTCTCTTAAGGTAGCCAAATGCCTC 39258
0.14086874297055715 No Hit
GTCCGGGGCTGCACGCGCGCTACACTGACTGGCTCAGCGTGTGCCTACCC 39119
0.14036997188509923 No Hit
GTCGCGGTTCCGGCGGCGTCCGGTGAGCTCTCGCTGGCCCTTGAAAATCC 37905
0.1360137985200206 No Hit
GCTTGATCTTGATTTTCAGTACGAATACAGACCGTGAAAGCGGGGCCTCA 37165
0.13335847043916543 No Hit
CCTAAGGCGAGCTCAGGGAGGACAGAAACCTCCCGTGGAGCAGAAGGGCA 36705
0.13170786109160681 No Hit
TGGGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCCTAAGGCGAGCTC 36489
0.13093279235449234 No Hit
GGCAGGGCGAAGCCAGAGGAAACTCTGGTGGAGGTCCGTAGCGGTCCTGA 34635
0.12428011902759302 No Hit
CCTGCCAGTAGCATATGCTTGTCTCAAAGATTAAGCCATGCATGTCTAAG 34301
0.12308163311001785 No Hit
CTGTGATGCCCTTAGATGTCCGGGGCTGCACGCGCGCTACACTGACTGGC 34174
0.12262592139884407 No Hit
GCCCTCTTGAACTCTCTCTTCAAAGTTCTTTTCAACTTTCCCTTACGGTA 33567
0.12044783471630474 No Hit
GTGCCTAGTGGGCCACTTTTGGTAAGCAGAACTGGCGCTGCGGGATGAAC 31672
0.11364804186060129 No Hit
CAGGTGGGGAGTTTGACTGGGGCGGTACACCTGTCAAACGGTAACGCAGG 30133
0.10812567710866061 No Hit
GCCGACTTAGAACTGGTGCGGACCAGGGGAATCCGACTGTTTAATTAAAA 29341
0.10528375840590752 No Hit
CTGCCCAGTGCTCTGAATGTCAAAGTGAAGAAATTCAATGAAGCGCGGGT 28998
0.10405297795761924 No Hit
GTTTTCGGAACTGAGGCCATGATTAAGAGGGACGGCCGGGGGCATTCGTA 28967
0.10394174124071856 No Hit
GTTTGACTGGGGCGGTACACCTGTCAAACGGTAACGCAGGTGTCCTAAGG 28804
0.10335685140669235 No Hit
GTGCAGATCTTGGTGGTAGTAGCAAATATTCAAACGAGAACTTTGAAGGC 28784
0.10328508578288545 No Hit
GGGCGAAAGACTAATCGAACCATCTAGTAGCTGGTTCCCTCCGAAGTTTC 28535
0.10239160376648959 No Hit
GCCGAAACGATCTCAACCTATTCTCAAACTTTAAATGGGTAAGAAGCCCG 28374
0.10181389049484406 No Hit
CCGACTGTTTAATTAAAACAAAGCATCGCGAAGGCCCGCGGCGGGTGTTG 28135
0.10095629129035165 No Hit
GCCAAATGCCTCGTCATCTAATTAGTGACGCGCATGAATGGATGAACGAG 27894
0.10009151552347856 No Hit
>>END_MODULE
>>Kmer Content fail
#Sequence Count Obs/Exp Overall Obs/Exp Max Max Obs/Exp Position
TCAAA 3186460 2.8718429 10.758567 28
TTTTT 3304055 2.5312302 5.1893187 6
GCAGG 3516205 2.4860408 10.352499 40
CTCTT 2801985 2.437556 9.405544 13
GGTAA 3256580 2.368683 8.363166 34
CAGAA 2776305 2.3589997 8.200787 33
CAAAG 2754525 2.3404937 6.8363333 19
AGAAA 2770290 2.2829983 5.9724474 27
CTCTC 2429915 2.25259 6.661347 18
TTTAA 2646805 2.1659582 8.427601 7
TGTCA 2695015 2.14377 9.644947 26
CTGGG 3076955 2.1049092 8.311629 11
GGCGG 3247285 2.094311 7.290433 15
CGGTA 2782315 2.086565 8.679945 33
ACTGG 2771500 2.078454 8.971444 10
GAAAC 2436070 2.0699055 5.0943966 34
AAGCA 2418130 2.054662 8.672969 30
TTAAA 2421115 2.0476954 5.8518977 7
AGCAG 2622090 2.0323339 7.937268 31
GTGAA 2782185 2.0236304 7.885611 27
TTTGA 2698200 2.0141363 10.168408 6
GCTCT 2453600 2.012339 8.234197 12
CAGGT 2644730 1.9833844 9.929331 41
GAACT 2412095 1.9830484 6.146467 12
TGAAC 2407015 1.9788717 5.5485926 20
TTTTC 2415455 1.9719031 7.1122622 6
ATTAA 2313550 1.9567207 6.0273533 6
TGCCT 2382870 1.9543293 5.104261 9
GTTTT 2699235 1.9495466 6.921604 5
TGACT 2441625 1.942209 10.123622 8
TTAAT 2367665 1.9375297 6.7455816 8
AGCCA 2200485 1.9277892 5.1869283 30
AGAGG 2808335 1.9257623 6.738071 30
GGGGC 2981375 1.9228145 7.2242136 13
AAAGT 2406525 1.9188846 5.0895076 20
CTTTT 2327370 1.8999931 5.662585 5
GGGAG 3031670 1.8963667 9.016056 1
AGTTT 2537060 1.8938497 9.535754 4
AGGGA 2724125 1.8680167 5.063619 32
CACCT 1949320 1.8676527 10.225004 22
AAAGC 2193810 1.8640594 5.762354 19
CAAAC 1937695 1.860972 10.942371 29
CCAAG 2114930 1.8528367 8.67382 42
TGAAG 2539840 1.8473598 6.818169 28
TAATT 2251545 1.8425052 6.464911 9
ACCTG 2165990 1.8360128 9.129572 23
CTTCC 1973895 1.8298485 8.76335 15
AGGTG 2757705 1.8296993 7.6151342 42
TACAC 1963350 1.8244432 9.840401 20
TCCTT 2078875 1.8084944 5.4221582 13
GTCAA 2151670 1.7689458 8.860351 27
AACTG 2150885 1.7683005 5.287144 13
CAAAT 1948925 1.7564967 5.5982494 33
GGTGT 2735400 1.7560258 10.069287 43
AAACG 2061195 1.7513778 9.402864 30
TTGAC 2198905 1.7491357 10.400425 7
TCTCT 1997865 1.7380208 5.090452 19
CCGGG 2382990 1.7371476 5.2617836 40
CCACA 1732455 1.7155241 5.049743 30
CCAAA 1785080 1.7143999 5.429743 32
TTAAG 2212290 1.7067845 5.861571 23
CGGGG 2636390 1.7003192 5.803532 41
ATTCA 1941685 1.6932033 8.404382 37
CCATG 1992635 1.6890676 6.6743174 21
ACTCT 1868025 1.6795517 5.4741874 17
AATTA 1983705 1.6777492 6.335233 10
TCTTC 1921900 1.6719358 8.374936 14
TGTCC 2037870 1.6713748 9.136687 45
TCACC 1740050 1.6671499 9.254485 39
GAAGC 2148000 1.6648755 7.0898113 29
TAAAA 1898745 1.659734 5.2176323 13
AAGAA 2006920 1.6539046 5.226598 26
ACACC 1655835 1.6396526 10.464204 21
ATCCT 1817345 1.633985 5.0368857 12
GCGGG 2523340 1.6274084 5.951216 40
GGGGA 2600855 1.6268839 8.252071 1
GTAAC 1974100 1.6229607 9.218988 35
CACCA 1637265 1.6212642 9.575987 40
TTCAA 1857235 1.6195607 5.317369 32
CGCAG 2024115 1.6175696 10.693015 39
TTCAC 1798070 1.6166549 8.578648 38
GGAGT 2426210 1.6097567 7.806657 5
TTGAT 2145235 1.6013625 5.002787 9
CCTGT 1946615 1.5965314 8.961711 24
TTCCT 1824790 1.5874561 8.2345295 16
TTTTG 2196845 1.5866909 6.165789 7
AATTC 1806670 1.5754666 9.004014 36
AAATT 1856310 1.5700029 5.9956274 29
AAACA 1677205 1.5622848 5.421774 15
AAGCG 1991755 1.5437727 6.836148 44
GACTG 2047545 1.5355325 8.489702 9
ATGCC 1807880 1.5324589 6.6052103 8
AATCC 1647045 1.5305167 5.359844 15
GGTTT 2247260 1.5302233 7.637432 4
ATGAA 1917130 1.5286571 5.41319 36
GTTCA 1920985 1.528062 5.575622 44
TGGGG 2522480 1.5266738 6.861274 12
GTCCT 1852505 1.5193464 9.01613 46
ATGTC 1909905 1.5192485 8.626558 6
GCGGT 2212630 1.5136346 7.382894 16
TAACT 1734270 1.5123317 6.225693 9
TCCTA 1680850 1.5112617 7.745259 17
GGGCG 2335830 1.5064753 6.802953 14
GCCCT 1703080 1.4884515 7.1986885 1
GTGTC 2040110 1.4803256 8.251822 44
AACTA 1640960 1.4789388 5.5659213 10
ACAAA 1586550 1.4778414 5.3574347 17
AAAAC 1577075 1.4690156 5.389269 14
CTGAA 1772795 1.4574625 5.6208205 11
GCAGA 1851425 1.4350054 7.1646442 32
AACAA 1535915 1.430676 5.3306456 16
TCATT 1695450 1.4305185 7.520268 22
CCCAG 1582540 1.4294738 5.8914433 1
CTGTC 1740645 1.4276035 8.905688 25
CTCCA 1469155 1.4076042 6.0745063 24
GCCTC 1609705 1.4068439 5.580426 38
TCCGG 1808740 1.398563 5.598373 2
GGCTC 1781915 1.3778216 6.8048334 11
TCTGA 1712335 1.3620898 5.1697826 18
CATCT 1509960 1.3576134 5.075815 45
TGGTT 1993750 1.3576009 6.6007934 3
GAATG 1862305 1.354553 5.743091 13
ACGCA 1544575 1.353163 9.098378 38
TTGGT 1982610 1.3500155 5.7757926 2
GTACA 1639220 1.3476468 8.558203 19
CCGAA 1532615 1.3426851 5.562068 2
CGGCC 1623745 1.3379072 6.329614 37
AACTC 1435925 1.3343334 5.5494003 22
GTTTA 1775285 1.3252043 6.9000897 6
GATGT 1873440 1.3184483 8.661675 5
TGTTT 1786595 1.2903842 5.037216 5
TGTGA 1820440 1.2811491 6.535451 26
CCAGT 1490350 1.263303 5.789477 26
GCCAT 1475870 1.251029 6.0572133 20
CTGTT 1624325 1.2501671 5.781611 4
AGAAT 1561185 1.2448382 7.2756553 34
TGCTC 1505535 1.2347761 5.381775 7
AACGG 1588315 1.2310737 8.090395 31
GGTAC 1635480 1.2265093 7.918203 18
TAATC 1388400 1.2107235 5.359603 38
CTATC 1345040 1.2093331 8.575096 19
ATGAT 1560410 1.2038583 5.1681333 23
ACCAA 1252150 1.2025712 8.461103 41
TAACG 1440060 1.1839122 8.66726 36
CCTAT 1315190 1.1824948 8.496358 18
GAATT 1531075 1.1812264 7.499196 35
ACGGT 1572185 1.1790417 8.484699 32
GTCGG 1706135 1.1671472 7.6757226 1
CGATG 1550515 1.1627907 7.7158527 4
AACGC 1315115 1.152139 9.109909 37
ATTGT 1535200 1.1459872 6.628105 24
TATCA 1313580 1.1454782 8.109393 20
GAGTT 1615230 1.136731 8.063056 3
CTTGT 1469905 1.1313173 5.140606 34
GTTTG 1649830 1.1234161 8.144531 5
GTGGG 1822915 1.1032779 6.924057 1
ATCAT 1256990 1.0961303 7.5902925 21
CCTTG 1336025 1.0957513 5.240072 33
CAAGC 1233200 1.0803752 7.8356557 43
TCGGC 1385330 1.0711719 7.246894 9
GCGTT 1473980 1.0695359 6.4226317 46
TCGAT 1330170 1.0580939 8.6855755 3
TTGTG 1546565 1.0531 6.0313888 25
AGCGT 1398975 1.049145 6.6602592 45
GCCCA 1135165 1.0253696 6.1453147 1
CACAC 1025045 1.0150274 6.0657015 12
GTTGG 1562420 1.0030159 7.640461 1
TTCGA 1259900 1.0021969 8.547816 2
GTCTG 1369050 0.9933974 5.258105 1
CGGCT 1267835 0.9803218 6.54606 10
ATCTC 1083595 0.9742664 6.5817914 40
TCTCG 1177445 0.96569055 5.360861 41
GAGCA 1239915 0.96103543 5.9294796 9
TCCAG 1115705 0.94573325 5.681487 25
ACCTT 1014195 0.9118684 5.4808273 32
CGGAA 1175210 0.91088367 5.097932 4
AATCT 1028390 0.8967847 5.4551206 39
AGCAC 1021445 0.89486206 5.7885504 10
GCATT 1086310 0.8641135 5.1501546 46
GTCCG 1104975 0.8543944 6.2138057 1
CATTG 1068715 0.8501175 6.908206 23
ACTCC 887230 0.85005915 5.59203 23
TTTCG 1103215 0.8490931 5.1564026 7
AGAGC 1051270 0.8148202 5.3253975 8
GTCGC 1032500 0.7983549 5.2080135 1
CTTCG 941060 0.77181756 7.2605977 1
GCACA 725160 0.6352943 5.259059 11
CACGT 659155 0.5587362 5.027879 14
TGTCG 687370 0.49876305 6.1271486 7
>>END_MODULE
_______________________________________________
Tutor maillist - [email protected]
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
