Changeset: bcc095a70a73 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bcc095a70a73
Modified Files:
sql/backends/monet5/bam/Tests/query2.4.sql
sql/backends/monet5/bam/Tests/query2.4.stable.out
Branch: Oct2014
Log Message:
Fixed test query 2.4
(grafted from 8228693a61305d8bdf68082a366ab5c7cd2ada10)
diffs (200 lines):
diff --git a/sql/backends/monet5/bam/Tests/query2.4.sql
b/sql/backends/monet5/bam/Tests/query2.4.sql
--- a/sql/backends/monet5/bam/Tests/query2.4.sql
+++ b/sql/backends/monet5/bam/Tests/query2.4.sql
@@ -3,29 +3,36 @@ FROM bam.alignments_1
WHERE qname IN (
SELECT qname
FROM (
- SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
- bam.bam_flag(flag, 'firs_segm') AS firs_segm
- FROM bam.alignments_1
- WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
+ SELECT qname, SUM(segm_unma), SUM(seco_alig), COUNT(*)
+ FROM (
+ SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
+ bam.bam_flag(flag, 'firs_segm') AS firs_segm
+ FROM bam.alignments_1
+ WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
+ ) AS sub
+ GROUP BY qname, firs_segm
+ HAVING SUM(segm_unma) < COUNT(*)
+ AND (COUNT(*) - SUM(seco_alig)) <> 1
) AS qnames
- GROUP BY qname, firs_segm
- HAVING SUM(segm_unma) < COUNT(*)
- AND (COUNT(*) - SUM(seco_alig)) <> 1
-)
-ORDER BY qname;
+);
+
SELECT qname, flag, rname, pos, mapq, cigar, rnext, pnext, tlen, seq, qual
FROM bam.unpaired_all_alignments_3
WHERE qname IN (
SELECT qname
FROM (
- SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
- bam.bam_flag(flag, 'firs_segm') AS firs_segm
- FROM bam.unpaired_all_alignments_3
- WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
+ SELECT qname, SUM(segm_unma), SUM(seco_alig), COUNT(*)
+ FROM (
+ SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
+ bam.bam_flag(flag, 'firs_segm') AS firs_segm
+ FROM bam.unpaired_all_alignments_3
+ WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
+ ) AS sub
+ GROUP BY qname, firs_segm
+ HAVING SUM(segm_unma) < COUNT(*)
+ AND (COUNT(*) - SUM(seco_alig)) <> 1
) AS qnames
- GROUP BY qname, firs_segm
- HAVING SUM(segm_unma) < COUNT(*)
- AND (COUNT(*) - SUM(seco_alig)) <> 1
-)
-ORDER BY qname;
+);
+
+
diff --git a/sql/backends/monet5/bam/Tests/query2.4.stable.out
b/sql/backends/monet5/bam/Tests/query2.4.stable.out
--- a/sql/backends/monet5/bam/Tests/query2.4.stable.out
+++ b/sql/backends/monet5/bam/Tests/query2.4.stable.out
@@ -1,9 +1,9 @@
stdout of test 'query2.4` in directory 'sql/backends/monet5/bam` itself:
-# 10:22:42 >
-# 10:22:42 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=32986" "--set"
"mapi_usock=/var/tmp/mtest-16074/.s.monetdb.32986" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_backends_monet5_bam"
"--set" "mal_listing=0"
-# 10:22:42 >
+# 17:36:06 >
+# 17:36:06 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=33676" "--set"
"mapi_usock=/var/tmp/mtest-11149/.s.monetdb.33676" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_backends_monet5_bam"
"--set" "mal_listing=0"
+# 17:36:06 >
# MonetDB 5 server v11.18.0
# This is an unreleased version
@@ -13,29 +13,27 @@ stdout of test 'query2.4` in directory '
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
# Visit http://www.monetdb.org/ for further information
-# Listening for connection requests on mapi:monetdb://robin-xps13:32986/
-# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-16074/.s.monetdb.32986
+# Listening for connection requests on mapi:monetdb://robin-xps13:33676/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-11149/.s.monetdb.33676
# MonetDB/SQL module loaded
Ready.
-# 10:22:42 >
-# 10:22:42 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-16074" "--port=32986"
-# 10:22:42 >
+# 17:36:06 >
+# 17:36:06 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-11149" "--port=33676"
+# 17:36:06 >
#SELECT qname, flag, rname, pos, mapq, cigar, rnext, pnext, tlen, seq, qual
#FROM bam.alignments_1
#WHERE qname IN (
# SELECT qname
# FROM (
-# SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
-# bam.bam_flag(flag, 'firs_segm') AS firs_segm
-# FROM bam.alignments_1
-# WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
-# ) AS qnames
-# GROUP BY qname, firs_segm
-# HAVING SUM(segm_unma) < COUNT(*)
-# AND (COUNT(*) - SUM(seco_alig)) <> 1
+# SELECT qname, SUM(segm_unma), SUM(seco_alig), COUNT(*)
+# FROM (
+# SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
+# bam.bam_flag(flag, 'firs_segm') AS firs_segm
+# FROM bam.alignments_1
+# WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
% bam.alignments_1, bam.alignments_1, bam.alignments_1,
bam.alignments_1, bam.alignments_1, bam.alignments_1,
bam.alignments_1, bam.alignments_1, bam.alignments_1,
bam.alignments_1, bam.alignments_1 # table_name
% qname, flag, rname, pos, mapq, cigar, rnext, pnext, tlen,
seq, qual # name
% clob, smallint, clob, int, smallint, clob, clob,
int, int, clob, clob # type
@@ -45,74 +43,17 @@ Ready.
#WHERE qname IN (
# SELECT qname
# FROM (
-# SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
-# bam.bam_flag(flag, 'firs_segm') AS firs_segm
-# FROM bam.unpaired_all_alignments_3
-# WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
-# ) AS qnames
-# GROUP BY qname, firs_segm
-# HAVING SUM(segm_unma) < COUNT(*)
+# SELECT qname, SUM(segm_unma), SUM(seco_alig), COUNT(*)
+# FROM (
+# SELECT qname, bam.bam_flag(flag, 'seco_alig') AS seco_alig,
bam.bam_flag(flag, 'segm_unma') AS segm_unma,
+# bam.bam_flag(flag, 'firs_segm') AS firs_segm
+# FROM bam.unpaired_all_alignments_3
+# WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag,
'last_segm')
% .unpaired_all_alignments_3, .unpaired_all_alignments_3,
.unpaired_all_alignments_3, .unpaired_all_alignments_3,
.unpaired_all_alignments_3, .unpaired_all_alignments_3,
.unpaired_all_alignments_3, .unpaired_all_alignments_3,
.unpaired_all_alignments_3, .unpaired_all_alignments_3,
.unpaired_all_alignments_3 # table_name
% qname, flag, rname, pos, mapq, cigar, rnext, pnext, tlen,
seq, qual # name
% clob, smallint, clob, int, smallint, clob, clob,
int, int, clob, clob # type
-% 11, 3, 5, 9, 3, 27, 1, 8, 1, 100,
100 # length
-[ "sim_22_1_1", 83, "chr22", 39996429, 255,
"62=1X37=", "=", 39996217, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "sim_22_1_1", 339, "chr22", 39995061, 0,
"11=1368D51=1X37=", "=", 39994332, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "sim_22_1_1", 385, "chr22", 39996047, 0,
"3=1I1=1X13=171D81=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "sim_22_1_1", 385, "chr22", 39994467, 0,
"3=1I1=1X14=1751D80=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "sim_22_1_1", 419, "chr22", 39995910, 0,
"5=1X12=307D82=", "=", 39996123, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "sim_22_1_1", 163, "chr22", 39996217, 255, "100=",
"=", 39996429, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "sim_22_1_1", 419, "chr22", 39994332, 0,
"5=1X11=1885D83=", "=", 39995061, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "sim_22_1_1", 339, "chr22", 39996123, 0,
"4=1X1I10=307D46=1X37=", "=", 39995910, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "sim_22_1_11", 337, "chr22", 41987433, 0,
"19=1X50=1X26=1I1=1I", "*", 0, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
-[ "sim_22_1_11", 83, "chr22", 41987433, 255,
"19=1X50=1X26=1X2=", "=", 41987203, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
-[ "sim_22_1_11", 163, "chr22", 41987203, 255,
"68=1X31=", "=", 41987433, 0,
"GCCTGGATGGAGCCCTGGGGCTGGAGGCTGGCACTTCCAATCGAGACTGCCCGTTTGGTCCTGCCCTGTGTGACAGTATACAGGCTTATCTTGGCCACCC",
"GGGF:GFGG?EGFEG?DAFBEF=FA+>EGG=E:EDBEB7DCCE=DG@?:?CAE4E=DCBGFG@FE8EB>FDAE#CE=ECA@#D-D?:CEA#BD#E#B#EA"
]
-[ "sim_22_1_13", 163, "chr22", 32901856, 255, "100=",
"=", 32902057, 0,
"TTATTACTCATAACAATCTTATGGGGTACATACTCTCATTATCCCGATTTGACAGATTAGTAAACTGAGGTGCAGACAGGCAAGTGATTCTTCCAGAGAG",
"F:CADE=EBGDDAEGE>DE@@D=CDDE#EG35CG?E;7CEEBDGGEB@-F=GEGD8CG>=5A=BBAFB#?D:G?E3A##?#F-?#DC#:###E#G8##B#"
]
-[ "sim_22_1_13", 83, "chr22", 32902057, 255, "100=",
"=", 32901856, 0,
"AGAGCAAAACATTCTGGCAGATGCACAGCAGGTGGTGGGGCAAAAAGGGACCCGGATGGGGATCAAGAGGCTCACAAGATAGTCTCAGCTCTGCCGCTTA",
";5#GFC#@@#AE@FE@E@4B=BE:6;ADA>E#:GF=?#=:?/EA?G>GF3CFCDEB:EFGDG?G@GGFEG=F5FDGE?#GDFGGFEE@AGADGFGEDEEG"
]
-[ "sim_22_1_13", 337, "chr22", 32902044, 0,
"1=1I1=1I10=15D86=", "*", 0, 0,
"AGAGCAAAACATTCTGGCAGATGCACAGCAGGTGGTGGGGCAAAAAGGGACCCGGATGGGGATCAAGAGGCTCACAAGATAGTCTCAGCTCTGCCGCTTA",
";5#GFC#@@#AE@FE@E@4B=BE:6;ADA>E#:GF=?#=:?/EA?G>GF3CFCDEB:EFGDG?G@GGFEG=F5FDGE?#GDFGGFEE@AGADGFGEDEEG"
]
-[ "sim_22_1_14", 355, "chr22", 37296079, 0,
"92=172D6=1X1=", "=", 37296228, 0,
"TCGGGCCTAGAACACGGAGCCTGGAGACCCGCGCGCCGTTGACCACAGGGTTTGGCGCCAAACGAGGAGGGCGGGGCGAGGACCAAGGGGCCGGGGCGGG",
"FDFGECDG?GDF=2BGEGEGEE@GGG=EEG:GFF@>EADDAFEE?::FGEGB>F>E@6EGGAE#DG#=B?(#@BCDDAEEGGFBAFFE-D#:>#:#CD7#"
]
-[ "sim_22_1_14", 403, "chr22", 37296228, 0,
"1=1X7=104D18=1X9=1X12=1X49=", "=", 37296079, 0,
"GGCGAGGGGGCGGGGCGAGGGCTGAGGGGCGGAAAACTAAGAGGAGCCCCCGCGGGTGGCGAGCTGGGATGACGGAGGGAGGGAGGGAGGGGCGCTGTGG",
"E##G#A=CD:.E-E.DEDE71#-5EEAGC;5-=#EE5'?DDED?:CFDFG&=?ACFB=DFGG=EBFDGCAGFGG>FG>GFGFFDFGE=AG6DAGEFFEGA"
]
-[ "sim_22_1_14", 99, "chr22", 37296079, 255, "100=",
"=", 37296332, 0,
"TCGGGCCTAGAACACGGAGCCTGGAGACCCGCGCGCCGTTGACCACAGGGTTTGGCGCCAAACGAGGAGGGCGGGGCGAGGACCAAGGGGCCGGGGCGGG",
"FDFGECDG?GDF=2BGEGEGEE@GGG=EEG:GFF@>EADDAFEE?::FGEGB>F>E@6EGGAE#DG#=B?(#@BCDDAEEGGFBAFFE-D#:>#:#CD7#"
]
-[ "sim_22_1_14", 147, "chr22", 37296332, 255,
"27=1X9=1X12=1X49=", "=", 37296079, 0,
"GGCGAGGGGGCGGGGCGAGGGCTGAGGGGCGGAAAACTAAGAGGAGCCCCCGCGGGTGGCGAGCTGGGATGACGGAGGGAGGGAGGGAGGGGCGCTGTGG",
"E##G#A=CD:.E-E.DEDE71#-5EEAGC;5-=#EE5'?DDED?:CFDFG&=?ACFB=DFGG=EBFDGCAGFGG>FG>GFGFFDFGE=AG6DAGEFFEGA"
]
-[ "sim_22_1_15", 83, "chr22", 25992258, 255, "100=",
"=", 25992044, 0,
"ATGTGCTCTATGGTCACCTAACCTGTCTGAGACTCAATATACTCATCTGATAAATAGGCAGAATAAAAATAAGAGGTGCCCTGCCTCTTTTCAGAGTCAC",
"##AEG#=GE>75CADDFEB=DF;<7=CF?<B?CBBC6:GDCDE=EBFFGFDE=BDDEEDEB?DD'AAE?CEEDFGFDDG>EGEGDA>FGD;EEEF:@GF<"
]
-[ "sim_22_1_15", 163, "chr22", 25992044, 255,
"2=1X95=1X1=", "=", 25992258, 0,
"GAGAGGCAGCCATAGGTTCGAGTCCTAGCTACTGGCTAGGGGACCTTGGACAAGGCACTGATAGTCCCAAGACTCAGTTTACCCATCTGTGCAGTGATGT",
"CG.GCEGGGFDGGGGEDCE<BEG5GDGEE=##EEFEFABFDE:#G??>:55;FE:5=A?E;E9BF#E@5=AE;BEGCA:#>EAC#DED#B##A;###B#B"
]
-[ "sim_22_1_15", 385, "chr22", 25992044, 0,
"2=1X95=2I", "*", 0, 0,
"GAGAGGCAGCCATAGGTTCGAGTCCTAGCTACTGGCTAGGGGACCTTGGACAAGGCACTGATAGTCCCAAGACTCAGTTTACCCATCTGTGCAGTGATGT",
"CG.GCEGGGFDGGGGEDCE<BEG5GDGEE=##EEFEFABFDE:#G??>:55;FE:5=A?E;E9BF#E@5=AE;BEGCA:#>EAC#DED#B##A;###B#B"
]
-[ "sim_22_1_17", 163, "chr22", 42395864, 255,
"8=1X71=1X12=1X6=", "=", 42396076, 0,
"TCAGTGTTATCATTTCTAAATTTAAAAGGTAAATTCAATAATTCCTAAGATCTCTGCTTGCTCTAAAATTCCCTGACTCTCATTACTGTCTTTATAGTGT",
"G>AEE=EF-GB?EGG@GGEEAB-GCE>E9;DEACG?:CCGDA(E7DFF.GFGEBEEED;D#FG4G:DDGGC=GG.;D@#A#B????#C#B#CB##AFE##"
]
-[ "sim_22_1_17", 83, "chr22", 42396076, 255,
"20=1X79=", "=", 42395864, 0,
"TAATTTTACCTCTCAGAAAGCTCTGGCTGCTGCTGTTCATCTTTTTGTAAATGTTCACTTAACAGCTGATCCTTTGGAACAAGAACTGGAGAGACAGTGG",
"C=#EDEC#5####E#D-E3E#ECGA?EE=GCDD:#@E:B?F?E@GDBDFFG5GC:FE=BEBF:GA?EDG@B<>A?G:FFEFCFECFDCDC<DGEDDF;EG"
]
-[ "sim_22_1_17", 337, "chr22", 42395458, 0,
"2=1D9=617D9=1X79=", "*", 0, 0,
"TAATTTTACCTCTCAGAAAGCTCTGGCTGCTGCTGTTCATCTTTTTGTAAATGTTCACTTAACAGCTGATCCTTTGGAACAAGAACTGGAGAGACAGTGG",
"C=#EDEC#5####E#D-E3E#ECGA?EE=GCDD:#@E:B?F?E@GDBDFFG5GC:FE=BEBF:GA?EDG@B<>A?G:FFEFCFECFDCDC<DGEDDF;EG"
]
-[ "sim_22_1_17", 385, "chr22", 42395633, 0,
"5=1I3=232D71=1X12=1X6=", "*", 0, 0,
"TCAGTGTTATCATTTCTAAATTTAAAAGGTAAATTCAATAATTCCTAAGATCTCTGCTTGCTCTAAAATTCCCTGACTCTCATTACTGTCTTTATAGTGT",
"G>AEE=EF-GB?EGG@GGEEAB-GCE>E9;DEACG?:CCGDA(E7DFF.GFGEBEEED;D#FG4G:DDGGC=GG.;D@#A#B????#C#B#CB##AFE##"
]
-[ "sim_22_1_4", 147, "chr22", 46558385, 255,
"1X49=1X9=1X39=", "=", 46558150, 0,
"TGACTCCAGGGAAGTTAAATAAATGCCAAGAGGATTCACGTGGCAGGGCCATGGAGGTGGGGAGGAAGGAGCACAGGAGACACCAGGTGCTCACTGTCCA",
"#E###BF#?;;#>@=1#@=E=B#E-EDF?DBC#EDEF?;6FE>+g...@gde.aede+DAF:4E>FF=EDA;DAEGEGAEFD?GD=DG=G=C5FEGDGGFAG"
]
-[ "sim_22_1_4", 401, "chr22", 46558386, 0,
"1I49=1X9=1X39=", "*", 0, 0,
"TGACTCCAGGGAAGTTAAATAAATGCCAAGAGGATTCACGTGGCAGGGCCATGGAGGTGGGGAGGAAGGAGCACAGGAGACACCAGGTGCTCACTGTCCA",
"#E###BF#?;;#>@=1#@=E=B#E-EDF?DBC#EDEF?;6FE>+g...@gde.aede+DAF:4E>FF=EDA;DAEGEGAEFD?GD=DG=G=C5FEGDGGFAG"
]
-[ "sim_22_1_4", 99, "chr22", 46558150, 255, "100=",
"=", 46558385, 0,
"CCCTGGCTGGAGTACAAGTTACTGGGGCTCAGTTCTTAGGATTCCTACAAAGCCCAATTTGGGTCACCTGACTTGTTAAGTCAGGTGAAGGTGACTTACC",
"G6EG5GGGGDGGADFGEB?GFDGGAEGGCFFBECGGB*BEA9BFG6E=?=)C5FGAFE6G2FB=CFECF#DAEAG<AGD7F*44D:#B>+?F##;E;#DD"
]
-[ "sim_22_1_7", 83, "chr22", 45060375, 255,
"41=1X56=1X1=", "=", 45060162, 0,
"ACCAGCCTGGCCAACATGGTGAAACGCTGTCTCTACTAAAAGTACAAAAAAATTAGCTAGGCGTGGTGGTGGGCACCTGTAATCCCAGCTACTCGGGGAG",
"5#>?CG=E,A=#AG#?#>GAEA@=DB<>ED@?CFC@A?=EG65GGD:C@EE(BFABFG5B?G;EFE?@5EG5GAGD5@;DFGG?F?7GAGGAFEFA>E-E"
]
-[ "sim_22_1_7", 337, "chr22", 45059241, 0,
"1=1X8=1134D31=1X56=1I1=", "*", 0, 0,
"ACCAGCCTGGCCAACATGGTGAAACGCTGTCTCTACTAAAAGTACAAAAAAATTAGCTAGGCGTGGTGGTGGGCACCTGTAATCCCAGCTACTCGGGGAG",
"5#>?CG=E,A=#AG#?#>GAEA@=DB<>ED@?CFC@A?=EG65GGD:C@EE(BFABFG5B?G;EFE?@5EG5GAGD5@;DFGG?F?7GAGGAFEFA>E-E"
]
-[ "sim_22_1_7", 339, "chr22", 45060375, 0,
"41=1X56=1I1=", "=", 45060235, 0,
"ACCAGCCTGGCCAACATGGTGAAACGCTGTCTCTACTAAAAGTACAAAAAAATTAGCTAGGCGTGGTGGTGGGCACCTGTAATCCCAGCTACTCGGGGAG",
"5#>?CG=E,A=#AG#?#>GAEA@=DB<>ED@?CFC@A?=EG65GGD:C@EE(BFABFG5B?G;EFE?@5EG5GAGD5@;DFGG?F?7GAGGAFEFA>E-E"
]
-[ "sim_22_1_7", 163, "chr22", 45060162, 255,
"89=1X5=1X4=", "=", 45060375, 0,
"TAGGAATTTTTTTTTTTTTTGAGACAGAGTTTCGCTCTTGTTGCCCAGGCTGGAGTGCAATGGTGCGATTGGCTGGAATTTTTTTTCTTGGCTGTCATAA",
"FGFCEEEGDE?CB::GE=FADFCEABEGBF>D;FGGGFFCDFGDGABCCADCDDDC;EF=:ACGGCEC#C=?=>EG@9#A@?=E;=:#B##A##@%C#D#"
]
-[ "sim_22_1_7", 419, "chr22", 45060235, 0,
"1=1I12=72I3=1X5=1X4=", "=", 45060375, 0,
"TAGGAATTTTTTTTTTTTTTGAGACAGAGTTTCGCTCTTGTTGCCCAGGCTGGAGTGCAATGGTGCGATTGGCTGGAATTTTTTTTCTTGGCTGTCATAA",
"FGFCEEEGDE?CB::GE=FADFCEABEGBF>D;FGGGFFCDFGDGABCCADCDDDC;EF=:ACGGCEC#C=?=>EG@9#A@?=E;=:#B##A##@%C#D#"
]
-[ "sim_22_1_9", 163, "chr22", 15600021, 255,
"3=1X96=", "=", 15600266, 0,
"CACATTTTCAAAAAACAAAAAAAAGTCTGAGCTCCTACTGTTGATTTAAATTCTTTTATAAATCTCTATCAAACTTTTCATGTTTACAGTTCTTATGCAA",
"FGDEGFA:GGG@?BE?F;FGCFF5@EF3;5G#FA.G=D?D?AGAE?AFF=>CBDE32?<E?ED#GG?G?E#E#EEE>5#B####EFF##=D####6#:#,"
]
-[ "sim_22_1_9", 385, "chr22", 15600023, 0,
"1=1I1=1I96=", "*", 0, 0,
"CACATTTTCAAAAAACAAAAAAAAGTCTGAGCTCCTACTGTTGATTTAAATTCTTTTATAAATCTCTATCAAACTTTTCATGTTTACAGTTCTTATGCAA",
"FGDEGFA:GGG@?BE?F;FGCFF5@EF3;5G#FA.G=D?D?AGAE?AFF=>CBDE32?<E?ED#GG?G?E#E#EEE>5#B####EFF##=D####6#:#,"
]
-[ "sim_22_1_9", 83, "chr22", 15600266, 255, "100=",
"=", 15600021, 0,
"TTTAAAATATTAAAAGATGAATTACTATCAATTGTTTTGAATTTTAAACTAAAAATCAGTAGTTACTATAAAATTATTATTAAATGTTCTAATAATTGTA",
"5<###E?##AB#E=DB#<==;#E#?=AFEE@C@AEA6GDGFFG?DE??::?=@BC#G>GB>GEEDA=G>ADEFDEGABEDDEBCGGEFFF7;=GEGGFGC"
]
-[ "sim_22_1_9", 321, "chr3", 76011277, 0,
"41=1X34=1X2=1X20=", "*", 0, 0,
"TACAATTATTAGAACATTTAATAATAATTTTATAGTAACTACTGATTTTTAGTTTAAAATTCAAAACAATTGATAGTAATTCATCTTTTAATATTTTAAA",
"CGFGGEG=;7FFFEGGCBEDDEBAGEDFEDA>G=ADEEG>BG>G#CB@=?::??ED?GFFGDG6AEA@C@EEFA=?#E#;==<#BD=E#BA##?E###<5"
]
-[ "sim_22_1_a", 401, "chr18", 15278551, 0,
"31=1X1=1X16=1X43=1X5=", "*", 0, 0,
"ATGGTTTTTGCCTGGTACTGTTGAAGTTAGGCTTAATTTTGAACCAGTAGCTTTGTTGTTTACCTTATGTGGTTTTGGGTTCATTTGTTCTATAAGTATA",
"##A#A####D5A>F#E@:G2#3ADBD:?##@CE-?D>BEG?D5DEABG3B5EC?CGDEDE=B@AE5@BDDGD>/DGBAE5@EGFEGEEEFEAD;BB?FGC"
]
-[ "sim_22_1_a", 401, "chr9", 66420362, 0, "50=1X43=1X5=",
"*", 0, 0,
"ATGGTTTTTGCCTGGTACTGTTGAAGTTAGGCTTAATTTTGAACCAGTAGCTTTGTTGTTTACCTTATGTGGTTTTGGGTTCATTTGTTCTATAAGTATA",
"##A#A####D5A>F#E@:G2#3ADBD:?##@CE-?D>BEG?D5DEABG3B5EC?CGDEDE=B@AE5@BDDGD>/DGBAE5@EGFEGEEEFEAD;BB?FGC"
]
-[ "sim_22_1_a", 401, "chr9", 69153222, 0, "50=1X43=1X5=",
"*", 0, 0,
"ATGGTTTTTGCCTGGTACTGTTGAAGTTAGGCTTAATTTTGAACCAGTAGCTTTGTTGTTTACCTTATGTGGTTTTGGGTTCATTTGTTCTATAAGTATA",
"##A#A####D5A>F#E@:G2#3ADBD:?##@CE-?D>BEG?D5DEABG3B5EC?CGDEDE=B@AE5@BDDGD>/DGBAE5@EGFEGEEEFEAD;BB?FGC"
]
-[ "sim_22_1_a", 339, "chr14", 18226024, 0, "100=",
"=", 18225784, 0,
"GTACAAAAGTGGGAAATTTTAAAGCTGGGCATCCAGGGGAGACATCACGTGTCAGTAGGTTCCGTGATGCCCCCCAAGCCGCAAAACCAGCAAGTTTTTA",
"####F#EFCGEC5BE?EF#F=@?DF658;DEDG=@FBG@?E=DE=F#FDB?CCGE1GFFEDEFFDGGFE>FFCGEGGG:;B@FFG@DDGGGFGB7FBC?F"
]
-[ "sim_22_1_a", 147, "chr22", 15047749, 255, "100=",
"=", 15047509, 0,
"ATGGTTTTTGCCTGGTACTGTTGAAGTTAGGCTTAATTTTGAACCAGTAGCTTTGTTGTTTACCTTATGTGGTTTTGGGTTCATTTGTTCTATAAGTATA",
"##A#A####D5A>F#E@:G2#3ADBD:?##@CE-?D>BEG?D5DEABG3B5EC?CGDEDE=B@AE5@BDDGD>/DGBAE5@EGFEGEEEFEAD;BB?FGC"
]
-[ "sim_22_1_a", 419, "chr14", 18225784, 0,
"5=1X31=1X62=", "=", 18226024, 0,
"TATACTTATAGAACAAATGAACCCAAAACCACATAAGGTAAACAACAAAGCTACTGGTTCAAAATTAAGCCTAACTTCAACAGTACCAGGCAAAAACCAT",
"CGF?BB;DAEFEEEGEFGE@5EABGD/>DGDDB@5EA@B=EDEDGC?CE5B3GBAED5D?GEB>D?-EC@##?:DBDA3#2G:@E#F>A5D####A#A##"
]
-[ "sim_22_1_a", 99, "chr22", 15047509, 255, "100=",
"=", 15047749, 0,
"TAAAAACTTGCTGGTTTTGCGGCTTGGGGGGCATCACGGAACCTACTGACACGTGATGTCTCCCCTGGATGCCCAGCTTTAAAATTTCCCACTTTTGTAC",
"F?CBF7BGFGGGDD@GFF@B;:GGGEGCFF>EFGGDFFEDEFFG1EGCC?BDF#F=ED=E?@GBF@=GDED;856FD?@=F#FE?EB5CEGCFE#F####"
]
-[ "sim_22_1_a", 385, "chr13", 17922987, 0,
"3=1X1=1X43=1X16=1X33=", "*", 0, 0,
"TATACTTATAGAACAAATGAACCCAAAACCACATAAGGTAAACAACAAAGCTACTGGTTCAAAATTAAGCCTAACTTCAACAGTACCAGGCAAAAACCAT",
"CGF?BB;DAEFEEEGEFGE@5EABGD/>DGDDB@5EA@B=EDEDGC?CE5B3GBAED5D?GEB>D?-EC@##?:DBDA3#2G:@E#F>A5D####A#A##"
]
-[ "sim_22_1_a", 401, "chr2", 132593958, 0,
"33=1X16=1X3=1X39=1X5=", "*", 0, 0,
"ATGGTTTTTGCCTGGTACTGTTGAAGTTAGGCTTAATTTTGAACCAGTAGCTTTGTTGTTTACCTTATGTGGTTTTGGGTTCATTTGTTCTATAAGTATA",
"##A#A####D5A>F#E@:G2#3ADBD:?##@CE-?D>BEG?D5DEABG3B5EC?CGDEDE=B@AE5@BDDGD>/DGBAE5@EGFEGEEEFEAD;BB?FGC"
]
-[ "sim_22_1_d", 147, "chr22", 24189415, 255, "100=",
"=", 24189222, 0,
"CGGGGGGCGGAGCGCAGGCAGGTGAAACTGGAGGAAATTGGAGATACAGCGGGAGGGAGGGGGAAAAGGTAAAACCTCTCACCACCTCCTCAACGCTTAT",
"##??BG#C##5AB#D;=G#BF#E#:;@?#<(4BGCG-#EA@<G?FC*GDD@FD:BEBEGFGFDDBDEAD9GGD37DDFDCDFDGEFGFCGEE:?AE>EDG"
]
-[ "sim_22_1_d", 99, "chr22", 24189222, 255,
"86=1X1=1X11=", "=", 24189415, 0,
"CCTGTCAAGCCTACCTTGTCACCTGTTGCCAGGAAGTCCTGCTCCCTCCTAGGGCAGCCCCTGGTTAGTGGAGCTGAGAGAACCCAGGGTGCTGAGCCGT",
"G5FGBEFEEGFED=EGDABFGGGFGGCE?EF=EEDGG9G?GEAECD9FGBFCEF;GGEC=GC5>F1?CDCCD#FEB=EE5B#CFEB###:ECBA-CE:@A"
]
-[ "sim_22_1_d", 321, "chr22", 23964184, 0,
"33=1X52=1X1=1X11=", "*", 0, 0,
"CCTGTCAAGCCTACCTTGTCACCTGTTGCCAGGAAGTCCTGCTCCCTCCTAGGGCAGCCCCTGGTTAGTGGAGCTGAGAGAACCCAGGGTGCTGAGCCGT",
"G5FGBEFEEGFED=EGDABFGGGFGGCE?EF=EEDGG9G?GEAECD9FGBFCEF;GGEC=GC5>F1?CDCCD#FEB=EE5B#CFEB###:ECBA-CE:@A"
]
-[ "sim_22_1_e", 163, "chr22", 39608988, 255,
"92=1X7=", "=", 39609212, 0,
"CGTAGTGAGACCCCATCTCCAAAAAATAAATAAATTAAGGACAGGATGGGCATGGACCACTCTTCAAGATTACTGACCAGCTTCTTGATATTGGACAACT",
"BC-GDFADDFFFCG@FAF6GCFBD==@=ACG>=G>EC5<>B#E0<CG4,=GBB>DDGAGEDE7BBD6:G#55DD=EEF#B5#;#GEC#BE####A=C?A5"
]
-[ "sim_22_1_e", 83, "chr22", 39609212, 255,
"4=1X95=", "=", 39608988, 0,
"AATATAAATTAAAATCTCAGGCCTCCATCCCCTATCTACTGAATCAGAATCTGCATTTTAACAGATCTTTTGTGGTTCATATACAGTTGAGTTCTTTTTT",
"4D@6##D=>G#<E#F#?G#;BC:EE#DB:C#>DE>B>:#ED?CFAFDF>DDC<CG:FEGGF5GEE1EFBFDGDG=GDBFDEDFBEGGGFDEDEDFGC?FF"
]
-[ "sim_22_1_e", 337, "chr22", 39609186, 0,
"1=1I1=2X9=27D86=", "*", 0, 0,
"AATATAAATTAAAATCTCAGGCCTCCATCCCCTATCTACTGAATCAGAATCTGCATTTTAACAGATCTTTTGTGGTTCATATACAGTTGAGTTCTTTTTT",
"4D@6##D=>G#<E#F#?G#;BC:EE#DB:C#>DE>B>:#ED?CFAFDF>DDC<CG:FEGGF5GEE1EFBFDGDG=GDBFDEDFBEGGGFDEDEDFGC?FF"
]
-[ "sim_22_1_f", 147, "chr22", 23113851, 255,
"14=1X85=", "=", 23113643, 0,
"TGCCTTTTCCAGCTGATAGAGACAGCCATGTTTCATGGCTTGTAGCCCCTTCCTCCATCTTCAAAGCCAACAACAACTGGTCAAGTTGTCACATTGCATC",
"####FF-0AD#E>@#?#9??E##A>C=C>D7A,<G?D>=>DDD=F:?G=>CE?:CAFGEDGEFDAGGFEF7CGDCEDEEGA@DECFGE-?DEACD?DC=G"
]
-[ "sim_22_1_f", 99, "chr22", 23113643, 255, "100=",
"=", 23113851, 0,
"CTTTTCTATATAAAACAAATAATTTATAATACTGTATTTGTTTTCTATTACTATTGAAATTACTACAAATGTAGTAGCTAAAACAACACATATTTTTCAT",
"DE>FDG5FDGDGFDAGEFABDGGEGADG?BEDDFGGEDGA?GG=9FEDDGBD58=@AFDFD=CBD9GGD=DCC?EE?F#A6GC#>?F#F@2E?CDF?#B?"
]
-[ "sim_22_1_f", 401, "chr22", 23113851, 0,
"14=1X77=1056D1=1X2=1D4=", "*", 0, 0,
"TGCCTTTTCCAGCTGATAGAGACAGCCATGTTTCATGGCTTGTAGCCCCTTCCTCCATCTTCAAAGCCAACAACAACTGGTCAAGTTGTCACATTGCATC",
"####FF-0AD#E>@#?#9??E##A>C=C>D7A,<G?D>=>DDD=F:?G=>CE?:CAFGEDGEFDAGGFEF7CGDCEDEEGA@DECFGE-?DEACD?DC=G"
]
+% 0, 1, 0, 1, 1, 0, 0, 1, 1, 0,
0 # length
-# 10:22:42 >
-# 10:22:42 > "Done."
-# 10:22:42 >
-
+# 17:36:06 >
+# 17:36:06 > "Done."
+# 17:36:06 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
