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

51 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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
163533	163533	PRJNA1028258_P_NODE_137201_length_234_cov_0.860606_g136638_i0	PRJNA1028258	137201	234	0.860606	2.01381804	Phormidium nigroviride	482564	Bacteria	Bacteria	313	8.71e-81	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g136638	i0	90.948	5.94871794871795	232	21	99	0	1	232	113500	113269	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1392	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
164911	164911	PRJNA1028258_P_NODE_48021_length_366_cov_1.101010_g47458_i0	PRJNA1028258	48021	366	1.10101	4.0296966	Rippkaea orientalis	2546366	Bacteria	Bacteria	488	2.2299999999999993e-133	NTclustered	gi\|470483849\|ref\|NR_076616.1\|	41431	g47458	i0	91.257	131.983606557377	366	21	99	5	1	365	1873	1518	Cyanothece sp. PCC 8801 strain PCC 8801 23S ribosomal RNA, complete sequence	blastn	48306	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rippkaea	Rippkaea orientalis
165660	165660	PRJNA1028258_P_NODE_86361_length_277_cov_2.850962_g85798_i0	PRJNA1028258	86361	277	2.850962	7.89716474	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g85798	i0	99.639	24.1227436823105	277	1	100	0	1	277	10	286	Synechococcus sp. rnpB gene, strain PCC7003	blastn	6682	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
1004600	1004600	PRJNA1028258_P_NODE_133261_length_235_cov_0.855422_g132698_i0	PRJNA1028258	133261	235	0.855422	2.0102417	Leptolyngbya	47251	Bacteria	Bacteria	353	5.16e-93	NTclustered	gi\|757114188\|dbj\|AP014640.1\|	411966	g132698	i0	93.991	2.97446808510638	233	14	99	0	3	235	263893	264125	Leptolyngbya boryana IAM M-101 plasmid pLBX DNA, complete genome, strain: IAM M-101	blastn	699	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
2713852	2713852	PRJNA1028258_P_NODE_127803_length_238_cov_1.260355_g127240_i0	PRJNA1028258	127803	238	1.260355	2.9996449	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	372	1.44e-98	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g127240	i0	94.937	1.99159663865546	237	12	99	0	1	237	283878	283642	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	474	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
2714040	2714040	PRJNA1028258_P_NODE_139343_length_233_cov_2.329268_g138780_i0	PRJNA1028258	139343	233	2.329268	5.42719444	Microcoleus vaginatus	119532	Bacteria	Bacteria	409	1.07e-109	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g138780	i0	98.283	4.01287553648069	233	4	100	0	1	233	2472415	2472183	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	935	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
2714080	2714080	PRJNA1028258_P_NODE_141223_length_233_cov_0.865854_g140660_i0	PRJNA1028258	141223	233	0.865854	2.01743982	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	261	3.1800000000000002e-65	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g140660	i0	87.013	7.96137339055794	231	30	99	0	3	233	10058608	10058378	Calothrix sp. PCC 7716 DNA, complete genome	blastn	1855	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
2714191	2714191	PRJNA1028258_P_NODE_147123_length_232_cov_0.871166_g146560_i0	PRJNA1028258	147123	232	0.871166	2.02110512	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	187	5.449999999999998e-43	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g146560	i0	83.333	6.56465517241379	204	33	88	1	2	205	6935115	6934913	Allocoleopsis franciscana PCC 7113, complete genome	blastn	1523	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
2714459	2714459	PRJNA1028258_P_NODE_163603_length_228_cov_0.893082_g163040_i0	PRJNA1028258	163603	228	0.893082	2.03622696	Microcoleus vaginatus	119532	Bacteria	Bacteria	261	3.1e-65	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g163040	i0	88.393	3.71929824561404	224	17	95	5	12	228	5392930	5393151	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	848	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
3990616	3990616	PRJNA1028258_P_NODE_167364_length_227_cov_0.898734_g166801_i0	PRJNA1028258	167364	227	0.898734	2.04012618	Microcoleus vaginatus	119532	Bacteria	Bacteria	252	1.86e-62	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g166801	i0	87.111	2.93832599118943	225	25	98	3	1	223	490459	490237	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	667	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
3991293	3991293	PRJNA1028258_P_NODE_39004_length_405_cov_1.690476_g38441_i0	PRJNA1028258	39004	405	1.690476	6.8464278	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	749	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g38441	i0	100	180.340740740741	405	0	100	0	1	405	2524	2928	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	73038	749	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
3991614	3991614	PRJNA1028258_P_NODE_55724_length_340_cov_3.261993_g55161_i0	PRJNA1028258	55724	340	3.261993	11.0907762	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	472	2.08e-128	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g55161	i0	91.813	274.511764705882	342	23	100	4	1	340	1859131	1858793	Calothrix sp. PCC 7716 DNA, complete genome	blastn	93334	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
3991950	3991950	PRJNA1028258_P_NODE_72984_length_301_cov_1.224138_g72421_i0	PRJNA1028258	72984	301	1.224138	3.68465538	Brasilonema sennae	1397703	Bacteria	Bacteria	65.8	3.6e-6	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g72421	i0	97.368	1.89700996677741	38	1	13	0	228	265	7682878	7682915	Brasilonema sennae CENA114 chromosome	blastn	571	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
4832461	4832461	PRJNA1028258_P_NODE_120304_length_244_cov_1.354286_g119741_i0	PRJNA1028258	120304	244	1.354286	3.30445784	root	1	Root_unresolved	Root_unresolved	390	4.11e-104	NTclustered	gi\|338180994\|gb\|JF981502.1\|	1211	g119741	i0	95.528	100.229508196721	246	8	100	3	1	244	285	41	Uncultured cyanobacterium clone Upland_8_779 16S ribosomal RNA gene, partial sequence	blastn	24456	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5265835	5265835	PRJNA1028258_P_NODE_106725_length_255_cov_1.446237_g106162_i0	PRJNA1028258	106725	255	1.446237	3.68790435	Microcoleus vaginatus	119532	Bacteria	Bacteria	95.3	3.8e-15	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g106162	i0	92.424	0.745098039215686	66	5	26	0	1	66	2316895	2316960	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	190	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
5266989	5266989	PRJNA1028258_P_NODE_174705_length_225_cov_1.365385_g174142_i0	PRJNA1028258	174705	225	1.365385	3.07211625	Capilliphycus salinus	2768948	Bacteria	Bacteria	58.4	4.3e-4	NTclustered	gi\|2894934693\|gb\|CP178543.1\|	1972598	g174142	i0	100	0.288888888888889	31	0	14	0	86	116	1348654	1348624	Capilliphycus salinus ALCB114379 voucher ALCB 114379 chromosome, complete genome	blastn	65	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Capilliphycus	Capilliphycus salinus
5267387	5267387	PRJNA1028258_P_NODE_30565_length_459_cov_2.287179_g30003_i0	PRJNA1028258	30565	459	2.287179	10.49815161	Aliterella chasmolithica	2739056	Bacteria	Bacteria	616	1.2599999999999999e-171	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g30003	i0	90.87	116.806100217865	460	40	100	2	1	459	2447	1989	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	53614	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
6541864	6541864	PRJNA1028258_P_NODE_147006_length_232_cov_0.871166_g146443_i0	PRJNA1028258	147006	232	0.871166	2.02110512	Microcoleus vaginatus	119532	Bacteria	Bacteria	219	1.93e-52	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g146443	i0	89.205	4.50431034482759	176	17	75	2	58	232	5047123	5046949	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1045	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10368255	10368255	PRJNA1028258_P_NODE_52749_length_350_cov_1.106762_g52186_i0	PRJNA1028258	52749	350	1.106762	3.873667	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	614	3.359999999999999e-171	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g52186	i0	98.286	245.994285714286	350	6	100	0	1	350	1858957	1859306	Calothrix sp. PCC 7716 DNA, complete genome	blastn	86098	614	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
11207908	11207908	PRJNA1028258_P_NODE_133889_length_235_cov_0.855422_g133326_i0	PRJNA1028258	133889	235	0.855422	2.0102417	Oscillatoriales	1150	Bacteria	Bacteria	355	1.43e-93	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g133326	i0	94.017	3.99148936170213	234	14	99	0	2	235	607630	607863	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	938	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11208216	11208216	PRJNA1028258_P_NODE_167709_length_227_cov_0.898734_g167146_i0	PRJNA1028258	167709	227	0.898734	2.04012618	Bacillati	1783272	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g167146	i0	100	8.79735682819383	29	0	13	0	1	29	5719980	5720008	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1997	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
11209848	11209848	PRJNA1028258_P_NODE_99169_length_262_cov_1.010363_g98606_i0	PRJNA1028258	99169	262	1.010363	2.64715106	root	1	Root_unresolved	Root_unresolved	346	9.789999999999999e-91	NTclustered	gi\|1812693548\|gb\|MT114673.1\|	1211	g98606	i0	90.458	137.629770992366	262	25	100	0	1	262	47	308	Uncultured cyanobacterium clone Otu35 16S ribosomal RNA gene, partial sequence	blastn	36059	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11642209	11642209	PRJNA1028258_P_NODE_138710_length_234_cov_0.860606_g138147_i0	PRJNA1028258	138710	234	0.860606	2.01381804	Phormidium nigroviride	482564	Bacteria	Bacteria	350	6.64e-92	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g138147	i0	93.59	4	234	15	100	0	1	234	732820	733053	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	936	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11642459	11642459	PRJNA1028258_P_NODE_155430_length_230_cov_0.881988_g154867_i0	PRJNA1028258	155430	230	0.881988	2.0285724	Microcoleus vaginatus	119532	Bacteria	Bacteria	381	2.309999999999999e-101	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g154867	i0	96.522	5.90434782608696	230	8	100	0	1	230	3923616	3923387	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1358	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
11643820	11643820	PRJNA1028258_P_NODE_6390_length_963_cov_4.431767_g6042_i0	PRJNA1028258	6390	963	4.431767	42.67791621	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	1544	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g6042	i0	95.643	260.665628245068	964	39	100	3	1	963	3392646	3393607	Calothrix sp. PCC 7716 DNA, complete genome	blastn	251021	1544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
12917226	12917226	PRJNA1028258_P_NODE_133191_length_235_cov_0.855422_g132628_i0	PRJNA1028258	133191	235	0.855422	2.0102417	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	281	2.47e-71	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g132628	i0	88.186	430.004255319149	237	26	100	2	1	235	1477436	1477672	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	101051	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
12917358	12917358	PRJNA1028258_P_NODE_141891_length_233_cov_0.865854_g141328_i0	PRJNA1028258	141891	233	0.865854	2.01743982	Phormidium nigroviride	482564	Bacteria	Bacteria	364	2.359999999999999e-96	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g141328	i0	94.85	2.93991416309013	233	12	100	0	1	233	7083040	7083272	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	685	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
12917627	12917627	PRJNA1028258_P_NODE_159811_length_229_cov_0.887500_g159248_i0	PRJNA1028258	159811	229	0.8875	2.032375	Microcoleus vaginatus	119532	Bacteria	Bacteria	351	1.8e-92	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g159248	i0	94.323	3.56768558951965	229	13	100	0	1	229	4890517	4890745	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	817	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
12918690	12918690	PRJNA1028258_P_NODE_49771_length_359_cov_4.200000_g49208_i0	PRJNA1028258	49771	359	4.2	15.078	Nodosilinea sp. SA1303_Zammit	2517750	Bacteria	Bacteria	652	0	NTclustered	gi\|1569139967\|gb\|MK502140.1\|	2517750	g49208	i0	99.443	127.055710306407	359	2	100	0	1	359	2465	2107	Nodosilinea sp. SA1303_Zammit 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45613	652	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. SA1303_Zammit
12919328	12919328	PRJNA1028258_P_NODE_82111_length_284_cov_2.176744_g81548_i0	PRJNA1028258	82111	284	2.176744	6.18195296	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	422	1.73e-113	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g81548	i0	93.617	109.007042253521	282	18	99	0	1	282	2558	2839	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30958	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13759636	13759636	PRJNA1028258_P_NODE_80311_length_288_cov_1.136986_g79748_i0	PRJNA1028258	80311	288	1.136986	3.27451968	Oscillatoriales	1150	Bacteria	Bacteria	510	3.66e-140	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g79748	i0	98.611	130.809027777778	288	4	100	0	1	288	2187	2474	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	37673	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14192357	14192357	PRJNA1028258_P_NODE_147332_length_232_cov_0.871166_g146769_i0	PRJNA1028258	147332	232	0.871166	2.02110512	Cylindrospermum stagnale	142864	Bacteria	Bacteria	276	1.13e-69	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g146769	i0	88.546	0.978448275862069	227	26	98	0	5	231	3569964	3569738	Cylindrospermum stagnale PCC 7417, complete genome	blastn	227	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
14193272	14193272	PRJNA1028258_P_NODE_33272_length_439_cov_2.640541_g32709_i0	PRJNA1028258	33272	439	2.640541	11.59197499	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	795	0	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g32709	i0	99.317	147.526195899772	439	3	100	0	1	439	3346	2908	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	64764	795	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15466251	15466251	PRJNA1028258_P_NODE_128753_length_237_cov_1.482143_g128190_i0	PRJNA1028258	128753	237	1.482143	3.51267891	Phormidium nigroviride	482564	Bacteria	Bacteria	318	1.8999999999999998e-82	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g128190	i0	92.727	0.928270042194093	220	16	93	0	2	221	804018	804237	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	220	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
15468478	15468478	PRJNA1028258_P_NODE_84933_length_280_cov_1.090047_g84370_i0	PRJNA1028258	84933	280	1.090047	3.0521316	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	254	6.59e-63	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g84370	i0	90.206	189.989285714286	194	19	69	0	87	280	509914	510107	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	53197	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
16307060	16307060	PRJNA1028258_P_NODE_137513_length_234_cov_0.860606_g136950_i0	PRJNA1028258	137513	234	0.860606	2.01381804	Pleurocapsa	44474	Bacteria	Bacteria	327	3.11e-85	NTclustered	gi\|2717502813\|gb\|PP667996.1\|	2601948	g136950	i0	91.915	199.863247863248	235	18	100	1	1	234	2639	2405	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	46768	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			Pleurocapsales cyanobacterium PJS 27
16308298	16308298	PRJNA1028258_P_NODE_58653_length_332_cov_5.528517_g58090_i0	PRJNA1028258	58653	332	5.528517	18.35467644	Nostoc	1177	Bacteria	Bacteria	335	2.7699999999999993e-87	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g58090	i0	84.911	38.4397590361446	338	43	99	5	2	332	3601123	3601459	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	12762	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
16740103	16740103	PRJNA1028258_P_NODE_114754_length_248_cov_2.033520_g114191_i0	PRJNA1028258	114754	248	2.03352	5.0431296	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g114191	i0	99.597	2	248	1	100	0	1	248	2433959	2433712	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	496	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
16741698	16741698	PRJNA1028258_P_NODE_38954_length_405_cov_2.315476_g38391_i0	PRJNA1028258	38954	405	2.315476	9.3776778	Ancylothrix terrestris	2023235	Bacteria	Bacteria	494	5.37e-135	NTclustered	gi\|2257652262\|gb\|ON803474.1\|	2953716	g38391	i0	88.78	171.306172839506	410	37	100	8	1	405	1997	2402	Ancylothrix terrestris strain BEA0843B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69379	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Ancylothrix	Ancylothrix terrestris
18015489	18015489	PRJNA1028258_P_NODE_141035_length_233_cov_0.865854_g140472_i0	PRJNA1028258	141035	233	0.865854	2.01743982	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	348	2.37e-91	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g140472	i0	93.562	1	233	15	100	0	1	233	5403881	5403649	Allocoleopsis franciscana PCC 7113, complete genome	blastn	233	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
18015890	18015890	PRJNA1028258_P_NODE_167515_length_227_cov_0.898734_g166952_i0	PRJNA1028258	167515	227	0.898734	2.04012618	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	381	2.2699999999999995e-101	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g166952	i0	96.916	102.022026431718	227	7	100	0	1	227	1244519	1244745	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	23159	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
20131042	20131042	PRJNA1028258_P_NODE_138976_length_234_cov_0.860606_g138413_i0	PRJNA1028258	138976	234	0.860606	2.01381804	Microcoleus	44471	Bacteria	Bacteria	327	3.11e-85	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g138413	i0	91.88	6	234	19	100	0	1	234	1294021	1294254	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1404	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21408569	21408569	PRJNA1028258_P_NODE_98197_length_263_cov_1.000000_g97634_i0	PRJNA1028258	98197	263	1	2.63	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|218169741\|gb\|CP001291.1\|	65393	g97634	i0	100	0.212927756653992	28	0	11	0	18	45	5410702	5410729	Cyanothece sp. PCC 7424, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
21840728	21840728	PRJNA1028258_P_NODE_154278_length_230_cov_0.881988_g153715_i0	PRJNA1028258	154278	230	0.881988	2.0285724	Microcoleus vaginatus	119532	Bacteria	Bacteria	276	1.12e-69	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g153715	i0	88.261	2.56521739130435	230	27	100	0	1	230	1253016	1253245	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	590	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21841143	21841143	PRJNA1028258_P_NODE_179838_length_220_cov_3.059603_g179275_i0	PRJNA1028258	179838	220	3.059603	6.7311266	Capilliphycus salinus	2768948	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2894934693\|gb\|CP178543.1\|	1972598	g179275	i0	96.875	0.145454545454545	32	1	15	0	76	107	5945959	5945928	Capilliphycus salinus ALCB114379 voucher ALCB 114379 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Capilliphycus	Capilliphycus salinus
23115561	23115561	PRJNA1028258_P_NODE_123519_length_241_cov_1.651163_g122956_i0	PRJNA1028258	123519	241	1.651163	3.97930283	Oculatella lusitanica	2928764	Bacteria	Bacteria	374	4.079999999999998e-99	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g122956	i0	94.628	155.107883817427	242	11	100	2	1	241	2519	2279	Oculatella lusitanica LEGE 161147 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	37381	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
23116264	23116264	PRJNA1028258_P_NODE_163499_length_228_cov_0.893082_g162936_i0	PRJNA1028258	163499	228	0.893082	2.03622696	Microcoleus vaginatus	119532	Bacteria	Bacteria	294	3.0600000000000003e-75	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g162936	i0	89.912	3.9780701754386	228	23	100	0	1	228	3417962	3418189	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	907	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23118135	23118135	PRJNA1028258_P_NODE_97459_length_263_cov_1.835052_g96896_i0	PRJNA1028258	97459	263	1.835052	4.82618676	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	394	3.46e-105	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g96896	i0	93.87	0.992395437262357	261	16	99	0	1	261	3422148	3422408	Allocoleopsis franciscana PCC 7113, complete genome	blastn	261	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
24389892	24389892	PRJNA1028258_P_NODE_153520_length_230_cov_0.900621_g152957_i0	PRJNA1028258	153520	230	0.900621	2.0714283	Thermoleptolyngbya oregonensis	2303529	Bacteria	Bacteria	58.4	4.41e-4	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g152957	i0	94.595	0.160869565217391	37	2	16	0	145	181	1345282	1345246	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	37	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
24390657	24390657	PRJNA1028258_P_NODE_32220_length_447_cov_1.560847_g31658_i0	PRJNA1028258	32220	447	1.560847	6.97698609	Nodosilinea nodulosa	416001	Bacteria	Bacteria	680	0	NTclustered	gi\|46409896\|gb\|AY584521.1\|	118166	g31658	i0	94.183	149.624161073825	447	25	100	1	1	447	1544	1989	Leptolyngbya sp. PCC 7104 23S ribosomal RNA gene, partial sequence	blastn	66882	680	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
25231542	25231542	PRJNA1028258_P_NODE_30080_length_463_cov_1.680203_g29519_i0	PRJNA1028258	30080	463	1.680203	7.77933989	Nodosilinea	1120752	Bacteria	Bacteria	819	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g29519	i0	98.698	149.451403887689	461	6	99	0	3	463	3672	3212	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69196	824	0.993932038834951	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B

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