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

59 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
130859	130859	PRJEB66218_P_NODE_122921_length_271_cov_1.233333_g120492_i0	PRJEB66218	122921	271	1.233333	3.34233243	Synechococcus sp. SynAce01	1916956	Bacteria	Bacteria	111	4.04e-20	NTclustered	gi\|1104554094\|gb\|CP018091.1\|	1916956	g120492	i0	89.655	8.32472324723247	87	9	32	0	10	96	982591	982505	Synechococcus sp. SynAce01 chromosome, complete genome	blastn	2256	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. SynAce01
132191	132191	PRJEB66218_P_NODE_196661_length_211_cov_1.706667_g194231_i0	PRJEB66218	196661	211	1.706667	3.60106737	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	193	1.05e-44	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g194231	i0	85.946	0.876777251184834	185	20	86	4	1	181	126042	125860	Leptolyngbya sp. 7M chromosome	blastn	185	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
134658	134658	PRJEB66218_P_NODE_91301_length_324_cov_2.821293_g88874_i0	PRJEB66218	91301	324	2.821293	9.14098932	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	538	1.9199999999999998e-148	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g88874	i0	96.605	5.53703703703704	324	11	100	0	1	324	5549554	5549231	Anabaena sp. YBS01 chromosome, complete genome	blastn	1794	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
994338	994338	PRJEB66218_P_NODE_156221_length_237_cov_1.318182_g153792_i0	PRJEB66218	156221	237	1.318182	3.12409134	Cyanophyceae	3028117	Bacteria	Bacteria	377	3.09e-100	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g153792	i0	95.378	145.075949367089	238	10	100	1	1	237	2492139	2492376	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	34383	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
995233	995233	PRJEB66218_P_NODE_90421_length_326_cov_3.305660_g87994_i0	PRJEB66218	90421	326	3.30566	10.7764516	Cyanophyceae	3028117	Bacteria	Bacteria	508	1.51e-139	NTclustered	gi\|485099144\|ref\|NR_102539.1\|	1173025	g87994	i0	95.046	186.825153374233	323	16	99	0	1	323	539	217	Geitlerinema sp. PCC 7407 strain PCC 7407 23S ribosomal RNA, complete sequence	blastn	60905	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
1408208	1408208	PRJEB66218_P_NODE_50942_length_473_cov_3.342233_g48525_i0	PRJEB66218	50942	473	3.342233	15.80876209	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	455	2.9999999999999995e-123	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g48525	i0	84.134	62.8266384778013	479	67	100	9	1	473	3681380	3680905	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	29717	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
1408274	1408274	PRJEB66218_P_NODE_53422_length_458_cov_3.395466_g51003_i0	PRJEB66218	53422	458	3.395466	15.55123428	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	669	0	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g51003	i0	93.013	171.006550218341	458	32	100	0	1	458	480	23	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	78321	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2684888	2684888	PRJEB66218_P_NODE_97163_length_312_cov_1.553785_g94735_i0	PRJEB66218	97163	312	1.553785	4.8478092	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	479	1.1299999999999996e-130	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g94735	i0	94.788	32.0096153846154	307	16	98	0	6	312	3682540	3682234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9987	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
3544675	3544675	PRJEB66218_P_NODE_130443_length_261_cov_2.215000_g128014_i0	PRJEB66218	130443	261	2.215	5.78115	Oscillatoriales	1150	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|389547780\|gb\|JQ402708.1\|	1211	g128014	i0	100	106	261	0	100	0	1	261	4	264	Uncultured cyanobacterium clone CNY_03146 16S ribosomal RNA gene, partial sequence	blastn	27666	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3545024	3545024	PRJEB66218_P_NODE_190723_length_214_cov_3.006536_g188293_i0	PRJEB66218	190723	214	3.006536	6.43398704	Nostoc	1177	Bacteria	Bacteria	374	3.539999999999999e-99	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g188293	i0	98.14	232.81308411215	215	3	100	1	1	214	5962695	5962481	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	49822	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
3956917	3956917	PRJEB66218_P_NODE_122744_length_271_cov_1.528571_g120315_i0	PRJEB66218	122744	271	1.528571	4.14242741	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	383	7.76e-102	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g120315	i0	92.251	111.132841328413	271	19	99	2	3	271	1845	2115	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	30117	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3957414	3957414	PRJEB66218_P_NODE_145584_length_245_cov_2.119565_g143155_i0	PRJEB66218	145584	245	2.119565	5.19293425	uncultured Euhalothece sp.	259947	Bacteria	Bacteria	141	4.59e-29	NTclustered	gi\|453201740\|gb\|JQ999648.1\|	259947	g143155	i0	82.84	289.722448979592	169	17	68	11	7	172	122	281	Uncultured Euhalothece sp. clone GKJWQY101BEFSI 23S ribosomal RNA gene, partial sequence	blastn	70982	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Euhalothece	uncultured Euhalothece sp.
3957939	3957939	PRJEB66218_P_NODE_175084_length_224_cov_1.546012_g172654_i0	PRJEB66218	175084	224	1.546012	3.46306688	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	189	1.4499999999999999e-43	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g172654	i0	82.648	11.6205357142857	219	33	96	4	1	216	4812484	4812700	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	2603	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
3958013	3958013	PRJEB66218_P_NODE_180044_length_221_cov_1.275000_g177614_i0	PRJEB66218	180044	221	1.275	2.81775	Microcystis aeruginosa	1126	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2719083847\|gb\|CP142375.1\|	3113711	g177614	i0	100	0.126696832579186	28	0	13	0	47	74	3609740	3609713	Microcystis aeruginosa 1339 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6097213	6097213	PRJEB66218_P_NODE_113105_length_284_cov_3.282511_g110676_i0	PRJEB66218	113105	284	3.282511	9.32233124	Bacteria	2	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|892164921\|gb\|KT182535.1\|	1211	g110676	i0	99.648	99.9788732394366	284	1	100	0	1	284	304	21	Uncultured cyanobacterium clone MBR Ca 100ppm 6 16S ribosomal RNA gene, partial sequence	blastn	28394	525	0.990476190476191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6509391	6509391	PRJEB66218_P_NODE_140166_length_251_cov_1.026316_g137737_i0	PRJEB66218	140166	251	1.026316	2.57605316	Microcystis sp. BLCC-F210	3342751	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2807378526\|gb\|CP169647.1\|	3342751	g137737	i0	100	0.450199203187251	29	0	12	0	1	29	2147031	2147059	Microcystis sp. BLCC-F210 chromosome	blastn	113	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. BLCC-F210
6511556	6511556	PRJEB66218_P_NODE_41526_length_540_cov_3.878914_g39122_i0	PRJEB66218	41526	540	3.878914	20.9461356	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	713	0	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g39122	i0	90.59	119.087037037037	542	45	100	5	1	540	2738	3275	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	64307	713	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7784078	7784078	PRJEB66218_P_NODE_169707_length_227_cov_3.096386_g167277_i0	PRJEB66218	169707	227	3.096386	7.02879622	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	340	3.8499999999999996e-89	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g167277	i0	94.545	98.1938325991189	220	12	97	0	1	220	2152262	2152043	Leptolyngbya sp. 7M chromosome	blastn	22290	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
9061188	9061188	PRJEB66218_P_NODE_61968_length_416_cov_2.200000_g59547_i0	PRJEB66218	61968	416	2.2	9.152	Phormidesmis sp. TAA2-2HA3-12	904375	Bacteria	Bacteria	658	0	NTclustered	gi\|484980767\|gb\|KC848647.1\|	904375	g59547	i0	98.913	142.769230769231	368	4	88	0	5	372	368	1	Leptolyngbya sp. TAA22HA312 23S ribosomal RNA gene, partial sequence	blastn	59392	658	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis sp. TAA2-2HA3-12
9922395	9922395	PRJEB66218_P_NODE_156548_length_237_cov_0.965909_g154119_i0	PRJEB66218	156548	237	0.965909	2.28920433	Cyanophyceae	3028117	Bacteria	Bacteria	383	6.64e-102	NTclustered	gi\|1345606788\|gb\|MG968522.1\|	102128	g154119	i0	95.781	147.818565400844	237	10	100	0	1	237	797	561	Leptolyngbya sp. PCC 73110 23S ribosomal RNA gene, partial sequence	blastn	35033	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 73110
9922960	9922960	PRJEB66218_P_NODE_44068_length_520_cov_4.302832_g41658_i0	PRJEB66218	44068	520	4.302832	22.3747264	Oculatella	1240886	Bacteria	Bacteria	719	0	NTclustered	gi\|1300933886\|gb\|MG652616.1\|	2058828	g41658	i0	91.699	201.75	518	43	99	0	1	518	2472	1955	Oculatella kazantipica KZ-19-s-2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	104910	719	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella kazantipica
10336957	10336957	PRJEB66218_P_NODE_61489_length_418_cov_2.719888_g59068_i0	PRJEB66218	61489	418	2.719888	11.36913184	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	678	0	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g59068	i0	95.933	82.8803827751196	418	17	100	0	1	418	5551187	5550770	Anabaena sp. YBS01 chromosome, complete genome	blastn	34644	678	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
10337493	10337493	PRJEB66218_P_NODE_83229_length_344_cov_3.091873_g80802_i0	PRJEB66218	83229	344	3.091873	10.63604312	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	560	4.3700000000000005e-155	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g80802	i0	96.46	51.4912790697674	339	12	99	0	6	344	5549098	5548760	Anabaena sp. YBS01 chromosome, complete genome	blastn	17713	560	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
11198129	11198129	PRJEB66218_P_NODE_27929_length_703_cov_10.856698_g25650_i0	PRJEB66218	27929	703	10.856698	76.32258694	Nostocales	1161	Bacteria	Bacteria	1105	0	NTclustered	gi\|394332606\|gb\|JX219483.1\|	1206980	g25650	i0	96.16	289.486486486487	677	24	96	2	28	703	3366	2691	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	203509	1105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera malacea cyanobiont' DB3992
11610984	11610984	PRJEB66218_P_NODE_217270_length_207_cov_0.890411_g214840_i0	PRJEB66218	217270	207	0.890411	1.84315077	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	259	9.94e-65	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g214840	i0	89.423	11.0531400966184	208	18	99	3	1	206	131264	131469	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	2288	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
11611107	11611107	PRJEB66218_P_NODE_225550_length_205_cov_0.902778_g223120_i0	PRJEB66218	225550	205	0.902778	1.8506949	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	215	2.16e-51	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g223120	i0	85.714	7.68292682926829	203	29	99	0	3	205	3764128	3763926	Calothrix sp. PCC 7716 DNA, complete genome	blastn	1575	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
12886298	12886298	PRJEB66218_P_NODE_228851_length_204_cov_1.811189_g226421_i0	PRJEB66218	228851	204	1.811189	3.69482556	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	7.609999999999999e-61	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g226421	i0	88.67	67.1813725490196	203	22	99	1	2	204	3679933	3679732	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13705	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14158911	14158911	PRJEB66218_P_NODE_109812_length_289_cov_2489.342105_g107383_i0	PRJEB66218	109812	289	2489.342105	7194.19868345	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	351	2.35e-92	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g107383	i0	97.573	126.743944636678	206	4	71	1	84	289	5575108	5575312	Anabaena sp. YBS01 chromosome, complete genome	blastn	36629	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
14162550	14162550	PRJEB66218_P_NODE_6912_length_1728_cov_5.381524_g5841_i0	PRJEB66218	6912	1728	5.381524	92.99273472	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1400	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5841	i0	84.621	129.710069444444	1437	189	89	26	310	1728	3681231	3682653	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	224139	1400	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
15022514	15022514	PRJEB66218_P_NODE_218752_length_206_cov_2.082759_g216322_i0	PRJEB66218	218752	206	2.082759	4.29048354	root	1	Root_unresolved	Root_unresolved	375	9.41e-100	NTclustered	gi\|192337817\|gb\|EU751426.1\|	1211	g216322	i0	100	98.6699029126214	203	0	99	0	1	203	458	660	Uncultured cyanobacterium clone HK04-B12 16S ribosomal RNA gene, partial sequence	blastn	20326	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15433079	15433079	PRJEB66218_P_NODE_114973_length_282_cov_1.176471_g112544_i0	PRJEB66218	114973	282	1.176471	3.31764822	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g112544	i0	100	0.099290780141844	28	0	10	0	72	99	2957763	2957790	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
16710271	16710271	PRJEB66218_P_NODE_49114_length_484_cov_5.569740_g46697_i0	PRJEB66218	49114	484	5.56974	26.9575416	Macrochaete psychrophila	1844959	Bacteria	Bacteria	760	0	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g46697	i0	95.041	306.743801652893	484	22	100	2	1	484	2578	2097	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	148464	760	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
16710668	16710668	PRJEB66218_P_NODE_64694_length_405_cov_1.462209_g62271_i0	PRJEB66218	64694	405	1.462209	5.92194645	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g62271	i0	94.444	0.0888888888888889	36	2	9	0	351	386	2446273	2446238	Nodosilinea sp. E11 chromosome	blastn	36	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
16711051	16711051	PRJEB66218_P_NODE_81154_length_350_cov_1.965398_g78727_i0	PRJEB66218	81154	350	1.965398	6.878893	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	545	1.24e-150	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g78727	i0	96.375	14.4885714285714	331	12	95	0	1	331	5552878	5553208	Anabaena sp. YBS01 chromosome, complete genome	blastn	5071	545	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
17571833	17571833	PRJEB66218_P_NODE_100214_length_306_cov_2.253061_g97786_i0	PRJEB66218	100214	306	2.253061	6.89436666	Oscillatoriales	1150	Bacteria	Bacteria	555	1.7799999999999996e-153	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g97786	i0	99.346	163.633986928105	306	2	100	0	1	306	103134	103439	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	50072	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
17572680	17572680	PRJEB66218_P_NODE_248674_length_187_cov_2.341270_g246242_i0	PRJEB66218	248674	187	2.34127	4.3781749	root	1	Root_unresolved	Root_unresolved	237	4.12e-58	NTclustered	gi\|389547189\|gb\|JQ402117.1\|	1211	g246242	i0	99.237	102.673796791444	131	1	100	0	57	187	479	609	Uncultured cyanobacterium clone CNY_02390 16S ribosomal RNA gene, partial sequence	blastn	19200	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17982384	17982384	PRJEB66218_P_NODE_122155_length_272_cov_1.232227_g119726_i0	PRJEB66218	122155	272	1.232227	3.35165744	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	398	2.7799999999999997e-106	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g119726	i0	93.309	1.98897058823529	269	18	99	0	2	270	5548284	5548016	Anabaena sp. YBS01 chromosome, complete genome	blastn	541	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
17985569	17985569	PRJEB66218_P_NODE_63975_length_408_cov_1.360231_g61552_i0	PRJEB66218	63975	408	1.360231	5.54974248	Spirirestis rafaelensis	293980	Bacteria	Bacteria	686	0	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g61552	i0	97.739	167.18137254902	398	8	98	1	11	408	821	425	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	68210	686	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
18846043	18846043	PRJEB66218_P_NODE_171295_length_226_cov_2.503030_g168865_i0	PRJEB66218	171295	226	2.50303	5.6568478	Wilmottia	1048851	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|213053950\|gb\|EU909982.1\|	1211	g168865	i0	100	99.9911504424779	226	0	100	0	1	226	409	634	Uncultured cyanobacterium clone T5P2B_77 16S ribosomal RNA gene, partial sequence	blastn	22598	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19258386	19258386	PRJEB66218_P_NODE_238116_length_202_cov_1.843972_g235685_i0	PRJEB66218	238116	202	1.843972	3.72482344	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	348	2e-91	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g235685	i0	98	70.2475247524752	200	4	99	0	3	202	5552453	5552652	Anabaena sp. YBS01 chromosome, complete genome	blastn	14190	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
19259516	19259516	PRJEB66218_P_NODE_61676_length_417_cov_4.573034_g59255_i0	PRJEB66218	61676	417	4.573034	19.06955178	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	425	2.05e-114	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g59255	i0	85.167	128.383693045564	418	59	100	3	1	417	3255	2840	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53536	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20120777	20120777	PRJEB66218_P_NODE_144696_length_246_cov_1.772973_g142267_i0	PRJEB66218	144696	246	1.772973	4.36151358	Gloeocapsopsis	693222	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g142267	i0	89.474	155.963414634146	247	24	100	2	1	246	2442	2687	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	38367	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
20121111	20121111	PRJEB66218_P_NODE_218036_length_207_cov_0.890411_g215606_i0	PRJEB66218	218036	207	0.890411	1.84315077	Pseudanabaena	1152	Bacteria	Bacteria	315	2.09e-81	NTclustered	gi\|2874253827\|emb\|OY969811.1\|	1211	g215606	i0	94.203	160.173913043478	207	10	100	2	1	207	3651537	3651741	MAG: uncultured cyanobacterium isolate MFD02832.bin.c.1 genome assembly, chromosome: 1	blastn	33156	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20121167	20121167	PRJEB66218_P_NODE_23036_length_799_cov_10.712737_g20876_i0	PRJEB66218	23036	799	10.712737	85.59476863	Oscillatoriales	1150	Bacteria	Bacteria	1125	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g20876	i0	92.069	135.434292866083	807	52	100	9	1	799	2761	1959	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	108212	1129	0.996457041629761	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20121375	20121375	PRJEB66218_P_NODE_40916_length_546_cov_2.356701_g38515_i0	PRJEB66218	40916	546	2.356701	12.86758746	Oscillatoriales	1150	Bacteria	Bacteria	963	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g38515	i0	98.711	138.010989010989	543	6	99	1	4	546	1738	1197	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	75354	963	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
20121439	20121439	PRJEB66218_P_NODE_49396_length_482_cov_16.275534_g46979_i0	PRJEB66218	49396	482	16.275534	78.44807388	Limnospira	2596745	Bacteria	Bacteria	769	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g46979	i0	95.473	161.226141078838	486	15	100	5	1	482	812460	811978	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	77711	769	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
20533663	20533663	PRJEB66218_P_NODE_23377_length_792_cov_4.269494_g21205_i0	PRJEB66218	23377	792	4.269494	33.81439248	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	896	0	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g21205	i0	87.421	85.6994949494949	795	81	99	17	1	789	2151233	2152014	Leptolyngbya sp. 7M chromosome	blastn	67874	896	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
20535138	20535138	PRJEB66218_P_NODE_72657_length_375_cov_2.627389_g70232_i0	PRJEB66218	72657	375	2.627389	9.85270875	Microcystis aeruginosa	1126	Bacteria	Bacteria	309	1.92e-79	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g70232	i0	81.794	101.698666666667	379	59	100	9	1	375	5089720	5089348	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	38137	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
21807716	21807716	PRJEB66218_P_NODE_130318_length_261_cov_3.545000_g127889_i0	PRJEB66218	130318	261	3.545	9.25245	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	427	3.38e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g127889	i0	96.169	191.091954022989	261	10	100	0	1	261	3679768	3680028	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49875	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22671230	22671230	PRJEB66218_P_NODE_151238_length_240_cov_4.212291_g148809_i0	PRJEB66218	151238	240	4.212291	10.1094984	Godleyaceae	1892260	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|385867180\|gb\|JQ776463.1\|	1211	g148809	i0	100	104.9625	240	0	100	0	1	240	622	383	Uncultured cyanobacterium clone S284 16S ribosomal RNA gene, partial sequence	blastn	25191	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22671942	22671942	PRJEB66218_P_NODE_63778_length_408_cov_11.023055_g61355_i0	PRJEB66218	63778	408	11.023055	44.9740644	Leptolyngbyales	3079749	Bacteria	Bacteria	579	1.45e-160	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g61355	i0	92.402	227.262254901961	408	27	99	4	2	408	5197164	5197568	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	92723	579	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
23084798	23084798	PRJEB66218_P_NODE_247679_length_190_cov_2.953488_g245247_i0	PRJEB66218	247679	190	2.953488	5.6116272	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	263	6.93e-66	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g245247	i0	91.623	230.915789473684	191	14	100	2	1	190	571168	570979	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	43874	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
23086104	23086104	PRJEB66218_P_NODE_74819_length_368_cov_4.094463_g72393_i0	PRJEB66218	74819	368	4.094463	15.06762384	Leptolyngbyaceae cyanobacterium China 12	3053674	Bacteria	Bacteria	669	0	NTclustered	gi\|2518630044\|gb\|OR129814.1\|	3053674	g72393	i0	99.457	100.127717391304	368	2	100	0	1	368	190	557	Leptolyngbyaceae cyanobacterium China 12 clone 2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36847	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium China 12
23947497	23947497	PRJEB66218_P_NODE_57939_length_435_cov_1.390374_g55519_i0	PRJEB66218	57939	435	1.390374	6.0481269	Thermoleptolyngbya	2303528	Bacteria	Bacteria	601	3.3299999999999996e-167	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g55519	i0	91.705	159.806896551724	434	34	99	2	3	435	312119	311687	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	69516	601	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
24357721	24357721	PRJEB66218_P_NODE_179360_length_221_cov_1.750000_g176930_i0	PRJEB66218	179360	221	1.75	3.8675	Cyanobium gracile	59930	Bacteria	Bacteria	128	3.16e-25	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g176930	i0	80	1.09954751131222	175	33	79	2	1	174	788973	788800	Cyanobium gracile PCC 6307, complete genome	blastn	243	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
24359711	24359711	PRJEB66218_P_NODE_60020_length_425_cov_1.793956_g57599_i0	PRJEB66218	60020	425	1.793956	7.624313	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	429	1.62e-115	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g57599	i0	85.012	56.9388235294118	427	59	100	4	1	425	3681380	3680957	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	24199	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
24360485	24360485	PRJEB66218_P_NODE_92380_length_322_cov_1.475096_g89953_i0	PRJEB66218	92380	322	1.475096	4.74980912	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	464	3.28e-126	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g89953	i0	92.615	112.450310559006	325	21	100	3	1	322	1586	1910	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36209	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25220752	25220752	PRJEB66218_P_NODE_223380_length_205_cov_2.826389_g220950_i0	PRJEB66218	223380	205	2.826389	5.79409745	Nostocaceae	1162	Bacteria	Bacteria	285	1.6199999999999998e-72	NTclustered	gi\|75699950\|gb\|CP000117.1\|	240292	g220950	i0	91.707	303.839024390244	205	17	100	0	1	205	1005336	1005132	Anabaena variabilis ATCC 29413, complete genome	blastn	62287	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus variabilis
25220997	25220997	PRJEB66218_P_NODE_40320_length_551_cov_11.432653_g37920_i0	PRJEB66218	40320	551	11.432653	62.99391803	Aphanizomenonaceae	1892259	Bacteria	Bacteria	826	0	NTclustered	gi\|1566846272\|dbj\|LC455652.1\|	77022	g37920	i0	93.852	246.816696914701	553	27	100	6	1	551	1030	483	Cylindrospermopsis raciborskii NIES-1262 gene for 23S ribosomal RNA, partial sequence	blastn	135996	826	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii

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