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

59 rows where analysis = "blastn", bioproject = "PRJNA438687" 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
435275	435275	PRJNA438687_S_NODE_2181_length_297_cov_15.759542_g2091_i0	PRJNA438687	2181	297	15.759542	46.80583974	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	418	2.36e-112	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g2091	i0	92.617	187.548821548822	298	10	100	6	1	297	735	1021	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	55702	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
435278	435278	PRJNA438687_S_NODE_2361_length_288_cov_12.916996_g2271_i0	PRJNA438687	2361	288	12.916996	37.20094848	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	472	1.73e-128	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g2271	i0	96.181	129.954861111111	288	11	100	0	1	288	509	222	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37427	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
435307	435307	PRJNA438687_S_NODE_3601_length_234_cov_6.688442_g3511_i0	PRJNA438687	3601	234	6.688442	15.65095428	Aliterella chasmolithica	2739056	Bacteria	Bacteria	355	1.43e-93	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g3511	i0	94.017	134.615384615385	234	14	100	0	1	234	1991	2224	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31500	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
435372	435372	PRJNA438687_S_NODE_6661_length_169_cov_3.029851_g6571_i0	PRJNA438687	6661	169	3.029851	5.12044819	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	209	7.9100000000000005e-50	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g6571	i0	89.697	33.414201183432	165	15	97	2	6	169	4827943	4828106	Leptolyngbya sp. 7M chromosome	blastn	5647	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
1091128	1091128	PRJNA438687_S_NODE_1001_length_378_cov_109.355685_g912_i0	PRJNA438687	1001	378	109.355685	413.3644893	root	1	Root_unresolved	Root_unresolved	671	0	NTclustered	gi\|148723931\|gb\|EF520516.1\|	1211	g912	i0	98.677	100.843915343915	378	5	100	0	1	378	160	537	Uncultured cyanobacterium clone ADK-MOe02-64 16S ribosomal RNA gene, partial sequence	blastn	38119	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1091175	1091175	PRJNA438687_S_NODE_4081_length_219_cov_150.445652_g3991_i0	PRJNA438687	4081	219	150.445652	329.47597788	root	1	Root_unresolved	Root_unresolved	405	1.29e-108	NTclustered	gi\|338192823\|gb\|JF788836.1\|	1211	g3991	i0	100	103	219	0	100	0	1	219	114	332	Uncultured cyanobacterium clone RNSCYA_D10 16S ribosomal RNA gene, partial sequence	blastn	22557	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2366636	2366636	PRJNA438687_S_NODE_4822_length_202_cov_14.101796_g4732_i0	PRJNA438687	4822	202	14.101796	28.48562792	Cyanophyceae	3028117	Bacteria	Bacteria	357	3.3299999999999996e-94	NTclustered	gi\|225696189\|gb\|FJ805856.1\|	259957	g4732	i0	98.515	238.356435643564	202	3	100	0	1	202	3254	3455	Uncultured Chroococcidiopsis sp. clone AR2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48148	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4262310	4262310	PRJNA438687_S_NODE_3944_length_224_cov_2.402116_g3854_i0	PRJNA438687	3944	224	2.402116	5.38073984	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	296	8.33e-76	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g3854	i0	91.981	125.513392857143	212	15	94	2	2	211	1862	2073	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28115	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4262389	4262389	PRJNA438687_S_NODE_884_length_390_cov_12.983099_g795_i0	PRJNA438687	884	390	12.983099	50.6340861	uncultured cyanobacterium	1211	Bacteria	Bacteria	627	4.869999999999999e-175	NTclustered	gi\|146428936\|gb\|EF219752.1\|	1211	g795	i0	98.86	114.002564102564	351	4	90	0	40	390	1	351	Uncultured cyanobacterium clone AI-2M_B09 16S ribosomal RNA gene, partial sequence	blastn	44461	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4919290	4919290	PRJNA438687_S_NODE_1324_length_346_cov_139.199357_g1234_i0	PRJNA438687	1324	346	139.199357	481.62977522	Odorella	2510792	Bacteria	Bacteria	551	2.649999999999999e-152	NTclustered	gi\|1438699698\|gb\|MH702368.1\|	2291633	g1234	i0	98.403	96.7052023121387	313	5	90	0	1	313	334	22	Odorella benthonica CalAq792 clone cl1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33460	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales		Odorella	Odorella benthonica
4919325	4919325	PRJNA438687_S_NODE_3344_length_243_cov_17.649038_g3254_i0	PRJNA438687	3344	243	17.649038	42.88716234	Pleurocapsales	52604	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|315176210\|gb\|HQ531448.1\|	1211	g3254	i0	97.951	101.333333333333	244	3	100	2	1	243	357	599	Uncultured cyanobacterium clone 30LAKE63B12 16S ribosomal RNA gene, partial sequence	blastn	24624	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5539075	5539075	PRJNA438687_S_NODE_745_length_410_cov_11.181333_g656_i0	PRJNA438687	745	410	11.181333	45.8434653	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	651	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g656	i0	95.599	165.914634146341	409	12	99	5	2	408	3669490	3669894	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	68025	651	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
6194182	6194182	PRJNA438687_S_NODE_1545_length_331_cov_4.763514_g1455_i0	PRJNA438687	1545	331	4.763514	15.76723134	Nostocales	1161	Bacteria	Bacteria	409	1.61e-109	NTclustered	gi\|1150755742\|gb\|KY098849.1\|	1963215	g1455	i0	89.329	287.287009063444	328	31	99	3	5	331	2110	1786	Roholtiella edaphica KZ-5-4-5 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	95092	412	0.992718446601942	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Fortieaceae	Roholtiella	Roholtiella edaphica
6813026	6813026	PRJNA438687_S_NODE_1986_length_306_cov_6.040590_g1896_i0	PRJNA438687	1986	306	6.04059	18.4842054	Chamaesiphon minutus	1173032	Bacteria	Bacteria	405	1.9e-108	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1896	i0	90.523	138.90522875817	306	29	100	0	1	306	986	1291	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	42505	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
6813146	6813146	PRJNA438687_S_NODE_7246_length_161_cov_3.626984_g7156_i0	PRJNA438687	7246	161	3.626984	5.83944424	Synechocystis pevalekii	1392622	Bacteria	Bacteria	219	1.2499999999999996e-52	NTclustered	gi\|1035493918\|gb\|KT354206.1\|	1858734	g7156	i0	91.358	256.403726708075	162	11	100	3	1	161	761	920	Synechocystis pevalekii SAG 91.79 clone e 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41281	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
6813158	6813158	PRJNA438687_S_NODE_806_length_399_cov_22.153846_g717_i0	PRJNA438687	806	399	22.153846	88.39384554	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	577	5.099999999999999e-160	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g717	i0	94.226	177.721804511278	381	17	95	5	1	379	1936104	1935727	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	70911	577	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
7469121	7469121	PRJNA438687_S_NODE_1386_length_341_cov_258.996732_g1296_i0	PRJNA438687	1386	341	258.996732	883.17885612	Ahomia	3127778	Bacteria	Bacteria	470	7.51e-128	NTclustered	gi\|105990447\|gb\|DQ514178.1\|	1211	g1296	i0	91.57	107.947214076246	344	23	99	3	3	341	891	549	Uncultured cyanobacterium clone 500M1_E4 16S ribosomal RNA gene, partial sequence	blastn	36810	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8088483	8088483	PRJNA438687_S_NODE_2547_length_278_cov_10.382716_g2457_i0	PRJNA438687	2547	278	10.382716	28.86395048	uncultured Oscillatoriales cyanobacterium	156210	Bacteria	Bacteria	464	2.77e-126	NTclustered	gi\|332656091\|gb\|JF733400.1\|	156210	g2457	i0	96.763	99.7661870503597	278	9	100	0	1	278	410	133	Uncultured Oscillatoriales cyanobacterium clone LI06st2 16S ribosomal RNA gene, partial sequence	blastn	27735	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			uncultured Oscillatoriales cyanobacterium
8088497	8088497	PRJNA438687_S_NODE_3067_length_255_cov_14.895455_g2977_i0	PRJNA438687	3067	255	14.895455	37.98341025	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	407	4.29e-109	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g2977	i0	96	203.18431372549	250	10	98	0	6	255	3955	3706	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	51812	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8088564	8088564	PRJNA438687_S_NODE_6387_length_173_cov_9.311594_g6297_i0	PRJNA438687	6387	173	9.311594	16.10905762	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	172	1.07e-38	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g6297	i0	91.339	265.768786127168	127	10	73	1	48	173	3682049	3682175	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	45978	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8744111	8744111	PRJNA438687_S_NODE_1567_length_330_cov_6.447458_g1477_i0	PRJNA438687	1567	330	6.447458	21.2766114	Cyanophyceae	3028117	Bacteria	Bacteria	459	1.57e-124	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g1477	i0	92.547	205.590909090909	322	20	97	4	1	320	120057	120376	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	67845	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
9363343	9363343	PRJNA438687_S_NODE_4828_length_202_cov_6.856287_g4738_i0	PRJNA438687	4828	202	6.856287	13.84969974	Chamaesiphon minutus	1173032	Bacteria	Bacteria	287	4.429999999999999e-73	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g4738	i0	92.5	191.777227722772	200	15	99	0	1	200	1218	1417	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	38739	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
9363348	9363348	PRJNA438687_S_NODE_5028_length_198_cov_2.895706_g4938_i0	PRJNA438687	5028	198	2.895706	5.73349788	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	233	5.71e-57	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g4938	i0	87.94	136.323232323232	199	23	100	1	1	198	1934175	1933977	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	26992	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
11294264	11294264	PRJNA438687_S_NODE_1129_length_364_cov_15.006079_g1039_i0	PRJNA438687	1129	364	15.006079	54.62212756	Oscillatoriales	1150	Bacteria	Bacteria	651	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g1039	i0	98.901	149.489010989011	364	4	100	0	1	364	536	173	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	54414	651	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11913980	11913980	PRJNA438687_S_NODE_1050_length_373_cov_6.615385_g961_i0	PRJNA438687	1050	373	6.615385	24.67538605	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	357	6.71e-94	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g961	i0	88.776	176.941018766756	294	30	78	3	1	291	4829326	4829619	Leptolyngbya sp. 7M chromosome	blastn	65999	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
11914009	11914009	PRJNA438687_S_NODE_2070_length_302_cov_15.662921_g1980_i0	PRJNA438687	2070	302	15.662921	47.30202142	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	525	1.3799999999999995e-144	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g1980	i0	98.013	262.923841059603	302	6	100	0	1	302	482	783	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	79403	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
11914031	11914031	PRJNA438687_S_NODE_2970_length_259_cov_7.736607_g2880_i0	PRJNA438687	2970	259	7.736607	20.03781213	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	387	5.69e-103	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g2880	i0	96.186	120.694980694981	236	9	91	0	24	259	3090	2855	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31260	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11914060	11914060	PRJNA438687_S_NODE_4570_length_207_cov_17.168605_g4480_i0	PRJNA438687	4570	207	17.168605	35.53901235	Chamaesiphon minutus	1173032	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g4480	i0	100	233.661835748792	207	0	100	0	1	207	1291	1085	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	48368	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
11914076	11914076	PRJNA438687_S_NODE_550_length_443_cov_7.730392_g466_i0	PRJNA438687	550	443	7.730392	34.24563656	Microcoleus vaginatus	119532	Bacteria	Bacteria	584	3.42e-162	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g466	i0	90.93	165.496613995485	441	31	98	7	1	435	1374792	1374355	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	73315	584	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
12570036	12570036	PRJNA438687_S_NODE_4450_length_210_cov_60.211429_g4360_i0	PRJNA438687	4450	210	60.211429	126.4440009	Phormidium	1198	Bacteria	Bacteria	381	2.069999999999999e-101	NTclustered	gi\|389547375\|gb\|JQ402303.1\|	1211	g4360	i0	99.522	99.5333333333333	209	1	99	0	1	209	660	452	Uncultured cyanobacterium clone CNY_02600 16S ribosomal RNA gene, partial sequence	blastn	20902	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12570060	12570060	PRJNA438687_S_NODE_5270_length_192_cov_79.401274_g5180_i0	PRJNA438687	5270	192	79.401274	152.45044608	Bacteria	2	Bacteria	Bacteria	350	5.24e-92	NTclustered	gi\|220936841\|gb\|FJ484336.1\|	1211	g5180	i0	99.479	103	192	1	100	0	1	192	808	617	Uncultured cyanobacterium clone Z82M70B 16S ribosomal RNA gene, partial sequence	blastn	19776	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13844708	13844708	PRJNA438687_S_NODE_2531_length_279_cov_3.094262_g2441_i0	PRJNA438687	2531	279	3.094262	8.63299098	Nostocales	1161	Bacteria	Bacteria	446	1.01e-120	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g2441	i0	95.39	267.139784946237	282	10	100	2	1	279	111	392	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	74532	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
13844809	13844809	PRJNA438687_S_NODE_7811_length_154_cov_423.831933_g7721_i0	PRJNA438687	7811	154	423.831933	652.70117682	root	1	Root_unresolved	Root_unresolved	285	1.14e-72	NTclustered	gi\|391225915\|gb\|JQ861411.1\|	1211	g7721	i0	100	106	154	0	100	0	1	154	1006	1159	Uncultured cyanobacterium clone YZ26 16S ribosomal RNA gene, partial sequence	blastn	16324	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14464031	14464031	PRJNA438687_S_NODE_6052_length_178_cov_3.748252_g5962_i0	PRJNA438687	6052	178	3.748252	6.67188856	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	283	4.909999999999999e-72	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g5962	i0	95.506	108.567415730337	178	7	100	1	1	178	131022	131198	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	19325	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
15119026	15119026	PRJNA438687_S_NODE_672_length_422_cov_36.651163_g583_i0	PRJNA438687	672	422	36.651163	154.66790786	Microcoleus	44471	Bacteria	Bacteria	660	0	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g583	i0	96.5	160.687203791469	400	13	95	1	3	402	3996	3598	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67810	660	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15737900	15737900	PRJNA438687_S_NODE_1153_length_361_cov_24.211656_g1063_i0	PRJNA438687	1153	361	24.211656	87.40407816	Synechocystis pevalekii	1392622	Bacteria	Bacteria	606	5.819999999999997e-169	NTclustered	gi\|1035493916\|gb\|KT354204.1\|	1858734	g1063	i0	96.953	146.598337950139	361	11	100	0	1	361	1242	882	Synechocystis pevalekii SAG 91.79 clone c 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52922	606	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
15737936	15737936	PRJNA438687_S_NODE_2793_length_267_cov_6.370690_g2703_i0	PRJNA438687	2793	267	6.37069	17.0097423	Aliterella chasmolithica	2739056	Bacteria	Bacteria	453	5.73e-123	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2703	i0	97.368	119.187265917603	266	7	99	0	2	267	2256	1991	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31823	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15737973	15737973	PRJNA438687_S_NODE_4413_length_211_cov_24.386364_g4323_i0	PRJNA438687	4413	211	24.386364	51.45522804	Chamaesiphon minutus	1173032	Bacteria	Bacteria	385	1.61e-102	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g4323	i0	99.526	119.255924170616	211	1	100	0	1	211	2223	2433	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	25163	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
15737979	15737979	PRJNA438687_S_NODE_4733_length_204_cov_1.544379_g4643_i0	PRJNA438687	4733	204	1.544379	3.15053316	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	145	2.85e-30	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g4643	i0	82.022	61.343137254902	178	25	86	7	29	203	595858	596031	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	12514	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
15738015	15738015	PRJNA438687_S_NODE_6313_length_174_cov_7.834532_g6223_i0	PRJNA438687	6313	174	7.834532	13.63208568	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	261	2.23e-65	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g6223	i0	93.678	175.683908045977	174	11	100	0	1	174	3669866	3670039	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	30569	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
15738017	15738017	PRJNA438687_S_NODE_6413_length_173_cov_1.557971_g6323_i0	PRJNA438687	6413	173	1.557971	2.69528983	Spirirestis rafaelensis	293980	Bacteria	Bacteria	279	6.12e-71	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g6323	i0	97.546	167.086705202312	163	4	94	0	6	168	635	473	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	28906	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
16393717	16393717	PRJNA438687_S_NODE_1813_length_316_cov_6.786477_g1723_i0	PRJNA438687	1813	316	6.786477	21.44526732	Oscillatoriales	1150	Bacteria	Bacteria	503	6.8e-138	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g1723	i0	95.556	166.303797468354	315	13	99	1	3	316	2957	3271	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52552	508	0.990157480314961	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16393773	16393773	PRJNA438687_S_NODE_5273_length_192_cov_50.388535_g5183_i0	PRJNA438687	5273	192	50.388535	96.7459872	Cyanophyceae	3028117	Bacteria	Bacteria	331	1.9e-86	NTclustered	gi\|146142179\|gb\|EF522683.1\|	1211	g5183	i0	97.906	103.505208333333	191	4	99	0	2	192	186	376	Uncultured cyanobacterium clone SCLS048 16S ribosomal RNA gene, partial sequence	blastn	19873	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16393799	16393799	PRJNA438687_S_NODE_6393_length_173_cov_4.449275_g6303_i0	PRJNA438687	6393	173	4.449275	7.69724575	Oscillatoriales	1150	Bacteria	Bacteria	309	7.81e-80	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g6303	i0	98.844	143.034682080925	173	2	100	0	1	173	103386	103558	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	24745	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
17012705	17012705	PRJNA438687_S_NODE_754_length_408_cov_20.219839_g665_i0	PRJNA438687	754	408	20.219839	82.49694312	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	549	1.1399999999999994e-151	NTclustered	gi\|453199516\|gb\|JQ997496.1\|	259957	g665	i0	92.268	127.512254901961	388	29	95	1	21	408	49	435	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	52025	549	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19561221	19561221	PRJNA438687_S_NODE_4096_length_219_cov_9.576087_g4006_i0	PRJNA438687	4096	219	9.576087	20.97163053	Nostoc edaphicum	264686	Bacteria	Bacteria	303	4.84e-78	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g4006	i0	98.276	220.16894977169	174	2	100	1	47	219	1355896	1355723	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	48217	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
20836853	20836853	PRJNA438687_S_NODE_2837_length_265_cov_11.878261_g2747_i0	PRJNA438687	2837	265	11.878261	31.47739165	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	396	9.71e-106	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g2747	i0	93.633	164.977358490566	267	14	99	3	1	264	3670366	3670100	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	43719	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20836894	20836894	PRJNA438687_S_NODE_4457_length_210_cov_11.988571_g4367_i0	PRJNA438687	4457	210	11.988571	25.1759991	Synechocystis pevalekii	1392622	Bacteria	Bacteria	366	5.7900000000000005e-97	NTclustered	gi\|1035493918\|gb\|KT354206.1\|	1858734	g4367	i0	98.095	165.842857142857	210	4	100	0	1	210	711	920	Synechocystis pevalekii SAG 91.79 clone e 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34827	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
20836935	20836935	PRJNA438687_S_NODE_6457_length_172_cov_2.635036_g6367_i0	PRJNA438687	6457	172	2.635036	4.53226192	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	204	3.76e-48	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g6367	i0	92.857	119.593023255814	140	10	81	0	5	144	597463	597324	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	20570	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20836941	20836941	PRJNA438687_S_NODE_6637_length_169_cov_31.231343_g6547_i0	PRJNA438687	6637	169	31.231343	52.78096967	Chamaesiphon minutus	1173032	Bacteria	Bacteria	287	3.55e-73	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g6547	i0	100	226.390532544379	155	0	92	0	15	169	2880	2726	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	38260	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
20836950	20836950	PRJNA438687_S_NODE_7177_length_162_cov_2.740157_g7087_i0	PRJNA438687	7177	162	2.740157	4.43905434	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	231	1.6099999999999998e-56	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g7087	i0	94.079	107.135802469136	152	9	94	0	11	162	596618	596769	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	17356	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21493012	21493012	PRJNA438687_S_NODE_2757_length_268_cov_15.278970_g2667_i0	PRJNA438687	2757	268	15.27897	40.9476396	Cyanophyceae	3028117	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|321271924\|gb\|HQ419021.1\|	1211	g2667	i0	100	101.003731343284	268	0	100	0	1	268	789	522	Uncultured cyanobacterium clone AL66_2CY_12 16S ribosomal RNA gene, partial sequence	blastn	27069	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22111883	22111883	PRJNA438687_S_NODE_1438_length_338_cov_9.194719_g1348_i0	PRJNA438687	1438	338	9.194719	31.07815022	Chamaesiphon minutus	1173032	Bacteria	Bacteria	614	3.2499999999999993e-171	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g1348	i0	99.408	141.082840236686	338	2	100	0	1	338	1692	1355	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	47686	614	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
22111891	22111891	PRJNA438687_S_NODE_1698_length_322_cov_15.679443_g1608_i0	PRJNA438687	1698	322	15.679443	50.48780646	Synechocystis pevalekii	1392622	Bacteria	Bacteria	453	7.090000000000001e-123	NTclustered	gi\|1035493916\|gb\|KT354204.1\|	1858734	g1608	i0	92.212	149.94099378882	321	23	99	2	1	320	1242	923	Synechocystis pevalekii SAG 91.79 clone c 16S ribosomal RNA gene, partial sequence; tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48281	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis pevalekii
22768053	22768053	PRJNA438687_S_NODE_1298_length_347_cov_152.916667_g1208_i0	PRJNA438687	1298	347	152.916667	530.62083449	root	1	Root_unresolved	Root_unresolved	568	2.6399999999999995e-157	NTclustered	gi\|379334395\|gb\|JQ579791.1\|	1211	g1208	i0	98.746	101.461095100865	319	4	92	0	29	347	1	319	Uncultured cyanobacterium clone FII-OX142 16S ribosomal RNA gene, partial sequence	blastn	35207	569	0.998242530755712	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22768124	22768124	PRJNA438687_S_NODE_5238_length_193_cov_11.088608_g5148_i0	PRJNA438687	5238	193	11.088608	21.40101344	Pleurocapsa	44474	Bacteria	Bacteria	267	5.4599999999999996e-67	NTclustered	gi\|2717502813\|gb\|PP667996.1\|	2601948	g5148	i0	91.71	213.134715025907	193	15	99	1	2	193	2410	2602	Pleurocapsales cyanobacterium PJS 27 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41135	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			Pleurocapsales cyanobacterium PJS 27
23387545	23387545	PRJNA438687_S_NODE_5939_length_180_cov_36.448276_g5849_i0	PRJNA438687	5939	180	36.448276	65.6068968	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	303	3.82e-78	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g5849	i0	97.727	162.066666666667	176	4	98	0	5	180	1935530	1935705	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	29172	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
24043018	24043018	PRJNA438687_S_NODE_2699_length_271_cov_33.550847_g2609_i0	PRJNA438687	2699	271	33.550847	90.92279537	Chamaesiphon	217161	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|312985502\|gb\|HQ189013.1\|	1211	g2609	i0	100	102.0036900369	271	0	100	0	1	271	609	879	Uncultured cyanobacterium clone B10805H 16S ribosomal RNA gene, partial sequence	blastn	27643	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
25317351	25317351	PRJNA438687_S_NODE_2260_length_293_cov_6.562016_g2170_i0	PRJNA438687	2260	293	6.562016	19.22670688	Gloeocapsopsis	693222	Bacteria	Bacteria	346	1.11e-90	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g2170	i0	89.209	158.532423208191	278	28	95	2	1	277	2655	2379	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	46450	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis

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);;