metadata: contig_metadata: 52 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax_clade = "Cyanobacteriota/Melainabacteria group"

52 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax_clade = "Cyanobacteriota/Melainabacteria group"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
551443	551443	PRJNA564013_P_NODE_338301_length_205_cov_0.902778_g335449_i0	PRJNA564013	338301	205	0.902778	1.8506949	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	187	4.6999999999999985e-43	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g335449	i0	84.293	0.931707317073171	191	30	93	0	1	191	4410293	4410483	Calothrix sp. PCC 7716 DNA, complete genome	blastn	191	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
552062	552062	PRJNA564013_P_NODE_373941_length_173_cov_7.375000_g371089_i0	PRJNA564013	373941	173	7.375	12.75875	Halotia branconii	1620816	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g371089	i0	100	0.173410404624277	30	0	17	0	117	146	4123367	4123338	Halotia branconii CENA392 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
552137	552137	PRJNA564013_P_NODE_40441_length_611_cov_2.816364_g37733_i0	PRJNA564013	40441	611	2.816364	17.20798404	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	462	2.36e-125	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g37733	i0	83.532	4.32569558101473	504	74	82	7	90	588	1362868	1363367	Synechococcus sp. CB0101 chromosome, complete genome	blastn	2643	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
552815	552815	PRJNA564013_P_NODE_78361_length_457_cov_18.919192_g75538_i0	PRJNA564013	78361	457	18.919192	86.46070744	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	730	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g75538	i0	98.091	4.45733041575492	419	8	92	0	25	443	1949153	1949571	Calothrix sp. PCC 7716 DNA, complete genome	blastn	2037	730	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
1131455	1131455	PRJNA564013_P_NODE_107061_length_399_cov_6.979290_g104222_i0	PRJNA564013	107061	399	6.97929	27.8473671	root	1	Root_unresolved	Root_unresolved	656	0	NTclustered	gi\|338183097\|gb\|JF983605.1\|	1211	g104222	i0	99.446	89.6190476190476	361	2	90	0	17	377	441	81	Uncultured cyanobacterium clone Upland_120_2896 16S ribosomal RNA gene, partial sequence	blastn	35758	656	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1824521	1824521	PRJNA564013_P_NODE_209822_length_297_cov_2.127119_g206971_i0	PRJNA564013	209822	297	2.127119	6.31754343	Pseudanabaena sp. Chao 1811	2963092	Bacteria	Bacteria	268	2.52e-67	NTclustered	gi\|2429870828\|gb\|CP101416.1\|	2963092	g206971	i0	86.585	0.828282828282828	246	30	83	2	33	278	183521	183279	Pseudanabaena sp. Chao 1811 chromosome, complete genome	blastn	246	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. Chao 1811
1825438	1825438	PRJNA564013_P_NODE_2602_length_1887_cov_51.797919_g1907_i0	PRJNA564013	2602	1887	51.797919	977.42673153	Parathermosynechococcus lividus	33070	Bacteria	Bacteria	425	9.95e-114	NTclustered	gi\|1275017176\|gb\|CP018092.1\|	1917166	g1907	i0	84.848	0.227344992050874	429	57	23	6	1440	1864	395657	395233	Parathermosynechococcus lividus PCC 6715, complete genome	blastn	429	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Parathermosynechococcus	Parathermosynechococcus lividus
3099865	3099865	PRJNA564013_P_NODE_209923_length_297_cov_1.474576_g207072_i0	PRJNA564013	209923	297	1.474576	4.37949072	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	331	3.16e-86	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g207072	i0	87.456	0.966329966329966	287	36	97	0	1	287	7149620	7149906	Allocoleopsis franciscana PCC 7113, complete genome	blastn	287	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
3100501	3100501	PRJNA564013_P_NODE_243163_length_267_cov_2.990291_g240311_i0	PRJNA564013	243163	267	2.990291	7.98407697	Phormidium nigroviride	482564	Bacteria	Bacteria	420	5.81e-113	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g240311	i0	97.551	3.62546816479401	245	6	92	0	1	245	2419021	2418777	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	968	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3102473	3102473	PRJNA564013_P_NODE_345183_length_202_cov_0.921986_g342331_i0	PRJNA564013	345183	202	0.921986	1.86241172	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	158	3.6199999999999997e-34	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g342331	i0	94.175	3.41584158415842	103	6	81	0	1	103	1324024	1323922	Calothrix sp. PCC 7716 DNA, complete genome	blastn	690	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
3104013	3104013	PRJNA564013_P_NODE_9343_length_1128_cov_5.483599_g7741_i0	PRJNA564013	9343	1128	5.483599	61.85499672	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	773	0	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g7741	i0	82.932	48.0886524822695	873	134	77	13	223	1085	3109421	3108554	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	54244	773	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
3682847	3682847	PRJNA564013_P_NODE_127123_length_374_cov_9.488818_g124276_i0	PRJNA564013	127123	374	9.488818	35.48817932	Nostocaceae	1162	Bacteria	Bacteria	496	1.37e-135	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g124276	i0	100	271.494652406417	268	0	89	0	84	351	666	399	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	101539	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
4374060	4374060	PRJNA564013_P_NODE_110324_length_395_cov_2.008982_g107483_i0	PRJNA564013	110324	395	2.008982	7.9354789	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	355	2.57e-93	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g107483	i0	85.319	0.913924050632911	361	34	91	10	20	379	50213	49871	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	361	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
4374167	4374167	PRJNA564013_P_NODE_114344_length_389_cov_15.085366_g111501_i0	PRJNA564013	114344	389	15.085366	58.68207374	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	224	7.44e-54	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g111501	i0	77.568	1.16452442159383	370	83	95	0	19	388	1325362	1325731	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	453	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
4375103	4375103	PRJNA564013_P_NODE_152064_length_349_cov_17.607639_g149215_i0	PRJNA564013	152064	349	17.607639	61.45066011	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	492	1.6399999999999996e-134	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g149215	i0	95.738	1.34670487106017	305	13	87	0	23	327	4247311	4247615	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	470	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
4960339	4960339	PRJNA564013_P_NODE_254584_length_257_cov_10.229592_g251732_i0	PRJNA564013	254584	257	10.229592	26.29005144	Synechocystis	1142	Bacteria	Bacteria	196	1.02e-45	NTclustered	gi\|2032561288\|gb\|CP054306.1\|	2732530	g251732	i0	87.209	79.0739299610895	172	22	67	0	3	174	2722407	2722236	Synechocystis sp. PCC 7338 chromosome, complete genome	blastn	20322	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7338
6236880	6236880	PRJNA564013_P_NODE_86405_length_437_cov_5.539894_g83575_i0	PRJNA564013	86405	437	5.539894	24.20933678	Oscillatoriales	1150	Bacteria	Bacteria	555	2.639999999999999e-153	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g83575	i0	92.327	3.5720823798627	391	28	89	2	25	414	6834159	6833770	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1561	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
6927095	6927095	PRJNA564013_P_NODE_212706_length_294_cov_4.420601_g209855_i0	PRJNA564013	212706	294	4.420601	12.99656694	Prochlorococcus marinus	1219	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|123959780\|gb\|CP000553.1\|	167555	g209855	i0	96.774	0.105442176870748	31	1	11	0	261	291	1035469	1035439	Prochlorococcus marinus str. NATL1A, complete genome	blastn	31	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
6928382	6928382	PRJNA564013_P_NODE_282466_length_237_cov_1.863636_g279614_i0	PRJNA564013	282466	237	1.863636	4.41681732	Nostoc sp. C052	2576902	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1866639087\|gb\|CP040272.1\|	2576902	g279614	i0	100	0.118143459915612	28	0	12	0	77	104	3318274	3318247	Nostoc sp. C052 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
7509337	7509337	PRJNA564013_P_NODE_103646_length_404_cov_6.501458_g100810_i0	PRJNA564013	103646	404	6.501458	26.26589032	Bacteria	2	Bacteria	Bacteria	62.1	6.44e-5	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g100810	i0	95	35.990099009901	40	0	12	2	219	258	39272	39235	Cylindrospermum stagnale PCC 7417, complete genome	blastn	14540	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
9475533	9475533	PRJNA564013_P_NODE_125848_length_376_cov_2.473016_g123002_i0	PRJNA564013	125848	376	2.473016	9.29854016	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	551	2.899999999999999e-152	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g123002	i0	95.906	153.94414893617	342	10	90	4	24	361	3670366	3670025	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	57883	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
9481596	9481596	PRJNA564013_P_NODE_96508_length_416_cov_5.540845_g93675_i0	PRJNA564013	96508	416	5.540845	23.0499152	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	412	1.5899999999999998e-110	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g93675	i0	86.898	13.3725961538462	374	42	89	6	23	394	2315437	2315069	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	5563	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
10751444	10751444	PRJNA564013_P_NODE_130349_length_371_cov_3.493548_g127501_i0	PRJNA564013	130349	371	3.493548	12.96106308	cyanobacterium enrichment culture clone E_4_E.1.3_C08-T7	1148046	Bacteria	Bacteria	353	8.63e-93	NTclustered	gi\|376000812\|gb\|JQ310205.1\|	1148046	g127501	i0	100	51.9973045822102	191	0	51	0	56	246	1	191	Cyanobacterium enrichment culture clone E_4_E.1.3_C08-T7 16S ribosomal RNA gene, partial sequence	blastn	19291	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium enrichment culture clone E_4_E.1.3_C08-T7
10752949	10752949	PRJNA564013_P_NODE_190989_length_314_cov_17.442688_g188138_i0	PRJNA564013	190989	314	17.442688	54.77004032	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	460	4.119999999999999e-125	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g188138	i0	97.07	1.73885350318471	273	8	87	0	24	296	1996178	1996450	Leptolyngbya sp. 7M chromosome	blastn	546	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
10755660	10755660	PRJNA564013_P_NODE_333129_length_207_cov_2.082192_g330277_i0	PRJNA564013	333129	207	2.082192	4.31013744	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	265	2.1399999999999997e-66	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g330277	i0	92.432	177.840579710145	185	14	89	0	1	185	1418	1234	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	36813	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
10756451	10756451	PRJNA564013_P_NODE_38329_length_624_cov_44.637655_g35641_i0	PRJNA564013	38329	624	44.637655	278.5389672	Parathermosynechococcus lividus	33070	Bacteria	Bacteria	900	0	NTclustered	gi\|1275017176\|gb\|CP018092.1\|	1917166	g35641	i0	94.228	0.943910256410256	589	34	94	0	19	607	394684	395272	Parathermosynechococcus lividus PCC 6715, complete genome	blastn	589	900	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Parathermosynechococcus	Parathermosynechococcus lividus
12025982	12025982	PRJNA564013_P_NODE_121270_length_381_cov_6.906250_g118425_i0	PRJNA564013	121270	381	6.90625	26.3128125	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	462	1.42e-125	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g118425	i0	91.395	3.54330708661417	337	29	88	0	22	358	4370434	4370770	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	1350	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
12028568	12028568	PRJNA564013_P_NODE_235470_length_274_cov_1.572770_g232618_i0	PRJNA564013	235470	274	1.57277	4.3093898	Thermosynechococcus sp.	2814275	Bacteria	Bacteria	215	3.03e-51	NTclustered	gi\|2314731918\|dbj\|AP024678.1\|	2814275	g232618	i0	81.923	10.963503649635	260	41	94	6	10	266	2355670	2355926	MAG: Thermosynechococcus sp. KatS3mg067 DNA, complete genome	blastn	3004	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus sp.
12028592	12028592	PRJNA564013_P_NODE_237150_length_272_cov_5.208531_g234298_i0	PRJNA564013	237150	272	5.208531	14.16720432	Macrochaete lichenoides	1844961	Bacteria	Bacteria	379	1.01e-100	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g234298	i0	95.763	272.051470588235	236	9	87	1	14	249	1942	1708	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	73998	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
12031705	12031705	PRJNA564013_P_NODE_63810_length_503_cov_5.529412_g61009_i0	PRJNA564013	63810	503	5.529412	27.81294236	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	207	9.92e-49	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g61009	i0	79.688	0.636182902584493	320	40	60	18	157	460	5154412	5154722	Leptolyngbya sp. 7M chromosome	blastn	320	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
12612172	12612172	PRJNA564013_P_NODE_78410_length_457_cov_12.994949_g75587_i0	PRJNA564013	78410	457	12.994949	59.38691693	Oscillatoriales	1150	Bacteria	Bacteria	736	0	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g75587	i0	98.337	154.711159737418	421	4	91	2	24	441	103598	103178	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	70703	736	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
13300551	13300551	PRJNA564013_P_NODE_104611_length_403_cov_1.847953_g101775_i0	PRJNA564013	104611	403	1.847953	7.44725059	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	394	5.569999999999999e-105	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g101775	i0	85.156	0.952853598014888	384	57	95	0	17	400	5559384	5559001	Anabaena sp. YBS01 chromosome, complete genome	blastn	384	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
13302948	13302948	PRJNA564013_P_NODE_201631_length_304_cov_13.740741_g198780_i0	PRJNA564013	201631	304	13.740741	41.77185264	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	313	1.18e-80	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g198780	i0	88.76	130.898026315789	258	26	84	3	22	277	454	198	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	39793	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
15849285	15849285	PRJNA564013_P_NODE_103373_length_404_cov_18.381924_g100537_i0	PRJNA564013	103373	404	18.381924	74.26297296	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	584	3.0899999999999987e-162	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g100537	i0	95.616	0.903465346534653	365	14	90	2	17	380	4219560	4219197	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	365	584	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
15849837	15849837	PRJNA564013_P_NODE_126453_length_375_cov_5.535032_g123607_i0	PRJNA564013	126453	375	5.535032	20.75637	Synechococcus sp. RS9909	221352	Bacteria	Bacteria	505	2.28e-138	NTclustered	gi\|1895776483\|gb\|CP047943.1\|	221352	g123607	i0	93.75	52.1013333333333	336	21	90	0	17	352	2436791	2436456	Synechococcus sp. RS9909 chromosome, complete genome	blastn	19538	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9909
16435078	16435078	PRJNA564013_P_NODE_272173_length_244_cov_3.551913_g269321_i0	PRJNA564013	272173	244	3.551913	8.66666772	Cyanophyceae	3028117	Bacteria	Bacteria	139	1.64e-28	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g269321	i0	82.609	13.4590163934426	161	24	65	4	63	221	3191	3033	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	3284	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18399631	18399631	PRJNA564013_P_NODE_155555_length_346_cov_12.066667_g152706_i0	PRJNA564013	155555	346	12.066667	41.75066782	Microcoleus vaginatus	119532	Bacteria	Bacteria	442	1.6599999999999994e-119	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g152706	i0	92.405	32.3092485549133	316	14	90	5	21	332	4034719	4034410	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	11179	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
18399802	18399802	PRJNA564013_P_NODE_162155_length_340_cov_17.136201_g159305_i0	PRJNA564013	162155	340	17.136201	58.2630834	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	451	2.7100000000000003e-122	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g159305	i0	92.163	6.69117647058824	319	25	94	0	22	340	1581937	1582255	Synechococcus sp. CB0101 chromosome, complete genome	blastn	2275	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
18400152	18400152	PRJNA564013_P_NODE_17555_length_867_cov_27.129032_g15411_i0	PRJNA564013	17555	867	27.129032	235.20870744	Microcystis aeruginosa	1126	Bacteria	Bacteria	1179	0	NTclustered	gi\|18307477\|emb\|AJ307004.1\|	317604	g15411	i0	92.822	35.163783160323	822	45	95	14	1	821	700	1508	Microcystis aeruginosa rf1 gene (partial), rf2 gene (partial) and tRNA-Leu (UAA) gene, strain NIVA-CYA 57	blastn	30487	1179	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
19676648	19676648	PRJNA564013_P_NODE_272396_length_244_cov_2.699454_g269544_i0	PRJNA564013	272396	244	2.699454	6.58666776	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	329	9.08e-86	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g269544	i0	94.393	118.504098360656	214	12	88	0	9	222	2897	3110	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28915	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20257921	20257921	PRJNA564013_P_NODE_110756_length_394_cov_6.876877_g107915_i0	PRJNA564013	110756	394	6.876877	27.09489538	Nostoc	1177	Bacteria	Bacteria	628	1.3699999999999998e-175	NTclustered	gi\|394332606\|gb\|JX219483.1\|	1206980	g107915	i0	98.596	280.266497461929	356	4	90	1	24	378	2273	2628	Nostoc sp. 'Peltigera malacea DB3992 cyanobiont' 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile, tRNA-Ala, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	110425	634	0.990536277602524	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera malacea cyanobiont' DB3992
20948996	20948996	PRJNA564013_P_NODE_122477_length_380_cov_2.376176_g119632_i0	PRJNA564013	122477	380	2.376176	9.0294688	Nostoc flagelliforme	1306274	Bacteria	Bacteria	381	4.069999999999999e-101	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g119632	i0	91.912	5.67105263157895	272	22	72	0	109	380	5384496	5384225	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	2155	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
20954773	20954773	PRJNA564013_P_NODE_6717_length_1293_cov_9.694805_g538_i5	PRJNA564013	6717	1293	9.694805	125.35382865	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1823	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g538	i5	92.733	109.873936581593	1266	87	98	4	33	1293	1622	2887	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	142067	1823	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22227113	22227113	PRJNA564013_P_NODE_268638_length_247_cov_1.381720_g265786_i0	PRJNA564013	268638	247	1.38172	3.4128484	Leptolyngbya sp. O-77	1080068	Bacteria	Bacteria	235	2.07e-57	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g265786	i0	85.909	22.3117408906883	220	31	89	0	10	229	3399786	3400005	Leptolyngbya sp. O-77 DNA, complete genome	blastn	5511	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
22230119	22230119	PRJNA564013_P_NODE_87618_length_434_cov_11.069705_g84788_i0	PRJNA564013	87618	434	11.069705	48.0425197	Synechococcus sp. MIT S1220	3082549	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2895575621\|gb\|CP138939.1\|	3082549	g84788	i0	96.97	0.147465437788018	33	1	8	0	381	413	825782	825750	Synechococcus sp. MIT S1220 chromosome, complete genome	blastn	64	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MIT S1220
23499303	23499303	PRJNA564013_P_NODE_123519_length_378_cov_16.694006_g120673_i0	PRJNA564013	123519	378	16.694006	63.10334268	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	580	3.71e-161	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g120673	i0	97.633	0.894179894179894	338	8	89	0	22	359	3518801	3518464	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	338	580	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
23499407	23499407	PRJNA564013_P_NODE_127159_length_374_cov_8.396166_g124312_i0	PRJNA564013	127159	374	8.396166	31.40166084	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	479	1.3799999999999996e-130	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g124312	i0	90.244	171.304812834225	369	33	99	3	1	368	685947	685581	Synechococcus sp. CB0101 chromosome, complete genome	blastn	64068	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
23503494	23503494	PRJNA564013_P_NODE_322899_length_212_cov_1.516556_g320047_i0	PRJNA564013	322899	212	1.516556	3.21509872	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	252	1.71e-62	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g320047	i0	93.491	4.09433962264151	169	11	80	0	21	189	1821292	1821460	Synechococcus sp. CB0101 chromosome, complete genome	blastn	868	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
23504842	23504842	PRJNA564013_P_NODE_59539_length_518_cov_22.113786_g56749_i0	PRJNA564013	59539	518	22.113786	114.54941148	Microcoleus vaginatus	119532	Bacteria	Bacteria	534	4.13e-147	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g56749	i0	87.738	4.97104247104247	473	39	91	9	26	495	1372929	1373385	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	2575	534	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
24776985	24776985	PRJNA564013_P_NODE_30660_length_687_cov_3.931310_g28084_i0	PRJNA564013	30660	687	3.93131	27.0080997	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	540	1.1999999999999999e-148	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g28084	i0	94.334	113.927219796215	353	18	72	2	158	509	1243503	1243152	Calothrix sp. NIES-4101 DNA, complete genome	blastn	78268	540	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
24779155	24779155	PRJNA564013_P_NODE_82240_length_447_cov_7.365285_g79413_i0	PRJNA564013	82240	447	7.365285	32.92282395	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	370	1.05e-97	NTclustered	gi\|453199516\|gb\|JQ997496.1\|	259957	g79413	i0	96.035	115.230425055928	227	9	51	0	1	227	148	374	Uncultured Chroococcidiopsis sp. clone GKJWQY101ANW47 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	51508	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25358424	25358424	PRJNA564013_P_NODE_227960_length_280_cov_6.479452_g225109_i0	PRJNA564013	227960	280	6.479452	18.1424656	Oscillatoriales	1150	Bacteria	Bacteria	135	2.49e-27	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g225109	i0	80.108	8.39642857142857	186	34	66	3	68	251	6385640	6385456	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	2351	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;