metadata: contig_metadata: 57 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

57 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax_phylum = "Cyanobacteriota"

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
1486974	1486974	PRJNA1104180_P_NODE_16302_length_270_cov_1.563452_g16160_i0	PRJNA1104180	16302	270	1.563452	4.2213204	Phormidium nigroviride	482564	Bacteria	Bacteria	453	5.810000000000001e-123	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g16160	i0	99.203	6.87777777777778	251	2	93	0	4	254	1645695	1645445	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1857	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
1487071	1487071	PRJNA1104180_P_NODE_23262_length_246_cov_0.890173_g23119_i0	PRJNA1104180	23262	246	0.890173	2.18982558	Microcoleus vaginatus	119532	Bacteria	Bacteria	97.1	1.01e-15	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g23119	i0	98.182	0.443089430894309	55	1	22	0	192	246	5902770	5902824	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	109	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
1487082	1487082	PRJNA1104180_P_NODE_23942_length_245_cov_0.895349_g23799_i0	PRJNA1104180	23942	245	0.895349	2.19360505	Microcoleus vaginatus	119532	Bacteria	Bacteria	357	4.18e-94	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g23799	i0	93.697	1.59591836734694	238	15	97	0	1	238	5607355	5607592	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	391	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
2762925	2762925	PRJNA1104180_P_NODE_1123_length_820_cov_16.010710_g989_i0	PRJNA1104180	1123	820	16.01071	131.287822	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1107	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g989	i0	91.03	112.285365853659	825	66	99	7	1	819	1485	2307	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	92074	1107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2763033	2763033	PRJNA1104180_P_NODE_17603_length_263_cov_1.621053_g17461_i0	PRJNA1104180	17603	263	1.621053	4.26336939	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	331	2.75e-86	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g17461	i0	90.196	1.93916349809886	255	24	97	1	9	263	3853384	3853131	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	510	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
2763071	2763071	PRJNA1104180_P_NODE_20323_length_251_cov_0.865169_g20180_i0	PRJNA1104180	20323	251	0.865169	2.17157419	Phormidium nigroviride	482564	Bacteria	Bacteria	335	2.0199999999999998e-87	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g20180	i0	90.873	1.85657370517928	252	20	99	3	2	251	4760390	4760640	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	466	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3570919	3570919	PRJNA1104180_P_NODE_8863_length_332_cov_1.301158_g8721_i0	PRJNA1104180	8863	332	1.301158	4.31984456	Chroococcidiopsis	54298	Bacteria	Bacteria	551	2.529999999999999e-152	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g8721	i0	96.677	160.762048192771	331	11	99	0	2	332	2321	1991	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	53373	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
4039044	4039044	PRJNA1104180_P_NODE_15864_length_272_cov_2.758794_g15722_i0	PRJNA1104180	15864	272	2.758794	7.50391968	Microcoleus vaginatus	119532	Bacteria	Bacteria	161	3.97e-35	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g15722	i0	94.286	0.386029411764706	105	6	39	0	1	105	3946657	3946761	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	105	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
4039147	4039147	PRJNA1104180_P_NODE_23024_length_246_cov_1.381503_g22881_i0	PRJNA1104180	23024	246	1.381503	3.39849738	Phormidium nigroviride	482564	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g22881	i0	96.735	0.995934959349594	245	8	99	0	1	245	3243231	3242987	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	245	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
4039295	4039295	PRJNA1104180_P_NODE_8164_length_342_cov_1.643123_g8022_i0	PRJNA1104180	8164	342	1.643123	5.61948066	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	416	9.949999999999996e-112	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g8022	i0	88.696	153.040935672515	345	33	100	6	1	342	2056379	2056038	Leptolyngbya sp. 7M chromosome	blastn	52340	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
5315082	5315082	PRJNA1104180_P_NODE_10685_length_310_cov_2.801688_g10543_i0	PRJNA1104180	10685	310	2.801688	8.6852328	Microcoleus vaginatus	119532	Bacteria	Bacteria	231	3.47e-56	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g10543	i0	94.631	3.45806451612903	149	8	76	0	1	149	6741768	6741916	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1072	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
5315139	5315139	PRJNA1104180_P_NODE_14605_length_280_cov_0.835749_g14463_i0	PRJNA1104180	14605	280	0.835749	2.3400972	Geitlerinema sp. PCC 7407	1173025	Bacteria	Bacteria	63.9	1.19e-5	NTclustered	gi\|427983362\|gb\|CP003591.1\|	1173025	g14463	i0	77.6	0.446428571428571	125	15	44	7	88	211	4276592	4276704	Geitlerinema sp. PCC 7407 chromosome, complete genome	blastn	125	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
5315266	5315266	PRJNA1104180_P_NODE_23065_length_246_cov_1.208092_g22922_i0	PRJNA1104180	23065	246	1.208092	2.97190632	Microcoleus vaginatus	119532	Bacteria	Bacteria	394	3.2e-105	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g22922	i0	95.885	5.3780487804878	243	10	99	0	1	243	2224219	2223977	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1323	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
5315274	5315274	PRJNA1104180_P_NODE_23645_length_245_cov_1.412791_g23502_i0	PRJNA1104180	23645	245	1.412791	3.46133795	Microcoleus sp. PCC 8701	272133	Bacteria	Bacteria	311	3.3000000000000003e-80	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g23502	i0	90.377	124.138775510204	239	20	98	2	1	239	982	1217	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	30414	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
5315335	5315335	PRJNA1104180_P_NODE_27205_length_233_cov_2.793750_g27062_i0	PRJNA1104180	27205	233	2.79375	6.5094375	Phormidium nigroviride	482564	Bacteria	Bacteria	381	2.3399999999999995e-101	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g27062	i0	96.137	5.90557939914163	233	9	100	0	1	233	707896	707664	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1376	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
5315338	5315338	PRJNA1104180_P_NODE_27585_length_228_cov_2.522581_g27442_i0	PRJNA1104180	27585	228	2.522581	5.75148468	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.3100000000000002e-91	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g27442	i0	94.298	116.513157894737	228	12	99	1	1	227	1999	1772	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	26565	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6590361	6590361	PRJNA1104180_P_NODE_16146_length_271_cov_1.525253_g16004_i0	PRJNA1104180	16146	271	1.525253	4.13343563	Phormidium nigroviride	482564	Bacteria	Bacteria	429	9.83e-116	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g16004	i0	95.203	27.3653136531365	271	13	100	0	1	271	4059218	4059488	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	7416	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
7398046	7398046	PRJNA1104180_P_NODE_17946_length_261_cov_2.457447_g17804_i0	PRJNA1104180	17946	261	2.457447	6.41393667	Bacillati	1783272	Bacteria	Bacteria	385	2.07e-102	NTclustered	gi\|47118304\|dbj\|BA000022.2\|	1148	g17804	i0	99.526	30.6743295019157	211	1	81	0	51	261	935293	935083	Synechocystis sp. PCC 6803 DNA, complete genome	blastn	8006	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
7864930	7864930	PRJNA1104180_P_NODE_11107_length_306_cov_11.133047_g10965_i0	PRJNA1104180	11107	306	11.133047	34.06712382	Microcoleus vaginatus	119532	Bacteria	Bacteria	544	3.86e-150	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g10965	i0	98.693	20.5130718954248	306	4	100	0	1	306	4034443	4034748	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	6277	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7865012	7865012	PRJNA1104180_P_NODE_17147_length_266_cov_1.170984_g17005_i0	PRJNA1104180	17147	266	1.170984	3.11481744	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	479	9.42e-131	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g17005	i0	99.245	25.8684210526316	265	2	99	0	2	266	2408	2144	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	6881	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
7865052	7865052	PRJNA1104180_P_NODE_1927_length_624_cov_1.001815_g1786_i0	PRJNA1104180	1927	624	1.001815	6.2513256	Microcoleus vaginatus	119532	Bacteria	Bacteria	1031	0	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g1786	i0	96.48	6.53365384615385	625	21	100	1	1	624	6679389	6678765	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	4077	1031	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7865107	7865107	PRJNA1104180_P_NODE_22787_length_247_cov_0.885057_g22644_i0	PRJNA1104180	22787	247	0.885057	2.18609079	Microcoleus vaginatus	119532	Bacteria	Bacteria	303	5.58e-78	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g22644	i0	88.845	1.01619433198381	251	23	100	2	1	247	1253332	1253083	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	251	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7865179	7865179	PRJNA1104180_P_NODE_28647_length_201_cov_9.281250_g28504_i0	PRJNA1104180	28647	201	9.28125	18.6553125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	366	5.5e-97	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g28504	i0	99.502	186.641791044776	201	1	100	0	1	201	2112	2312	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37515	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9139970	9139970	PRJNA1104180_P_NODE_22228_length_248_cov_0.880000_g22085_i0	PRJNA1104180	22228	248	0.88	2.1824	Microcoleus vaginatus	119532	Bacteria	Bacteria	409	1.16e-109	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g22085	i0	96.371	10.6451612903226	248	9	100	0	1	248	1428081	1428328	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	2640	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10415621	10415621	PRJNA1104180_P_NODE_10289_length_314_cov_2.887967_g10147_i0	PRJNA1104180	10289	314	2.887967	9.06821638	Nostoc sp. 'Peltigera malacea cyanobiont' DB3992	1206980	Bacteria	Bacteria	407	5.439999999999999e-109	NTclustered	gi\|394332606\|gb\|JX219483.1\|	1206980	g10147	i0	92.069	245.624203821656	290	21	92	2	26	314	5103	4815	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	77126	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera malacea cyanobiont' DB3992
10415854	10415854	PRJNA1104180_P_NODE_25129_length_243_cov_0.905882_g24986_i0	PRJNA1104180	25129	243	0.905882	2.20129326	Phormidium nigroviride	482564	Bacteria	Bacteria	348	2.4900000000000003e-91	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g24986	i0	92.593	3.53086419753086	243	17	99	1	1	242	5732811	5732569	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	858	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
10415864	10415864	PRJNA1104180_P_NODE_25869_length_242_cov_0.911243_g25726_i0	PRJNA1104180	25869	242	0.911243	2.20520806	Microcoleus vaginatus	119532	Bacteria	Bacteria	139	1.63e-28	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g25726	i0	85.926	70.1198347107438	135	13	54	3	51	181	6459724	6459592	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	16969	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
11691143	11691143	PRJNA1104180_P_NODE_27490_length_229_cov_3.269231_g27347_i0	PRJNA1104180	27490	229	3.269231	7.48653899	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	294	3.07e-75	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g27347	i0	89.912	75.8951965065502	228	23	99	0	1	228	1300693	1300466	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	17380	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
11691208	11691208	PRJNA1104180_P_NODE_7190_length_358_cov_6.950877_g7048_i0	PRJNA1104180	7190	358	6.950877	24.88413966	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	634	2.6499999999999993e-177	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g7048	i0	98.873	151.667597765363	355	4	99	0	4	358	2032	1678	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54297	634	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12966083	12966083	PRJNA1104180_P_NODE_12051_length_296_cov_3.143498_g11909_i0	PRJNA1104180	12051	296	3.143498	9.30475408	uncultured cyanobacterium	1211	Bacteria	Bacteria	102	2.69e-17	NTclustered	gi\|2874254044\|emb\|OY970368.1\|	1211	g11909	i0	85.859	1.44594594594595	99	11	33	3	152	249	415569	415665	MAG: uncultured cyanobacterium isolate MFD04716.bin.1.71 genome assembly, chromosome: 1	blastn	428	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12966133	12966133	PRJNA1104180_P_NODE_16151_length_271_cov_1.474747_g16009_i0	PRJNA1104180	16151	271	1.474747	3.99656437	Microcoleus vaginatus	119532	Bacteria	Bacteria	335	2.2e-87	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g16009	i0	88.971	3.8450184501845	272	28	100	2	1	271	3216249	3215979	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1042	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
12966277	12966277	PRJNA1104180_P_NODE_26811_length_239_cov_2.192771_g26668_i0	PRJNA1104180	26811	239	2.192771	5.24072269	Microcoleus vaginatus	119532	Bacteria	Bacteria	364	2.4299999999999993e-96	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g26668	i0	94.142	4.11297071129707	239	14	100	0	1	239	4961957	4962195	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	983	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
14241257	14241257	PRJNA1104180_P_NODE_26972_length_236_cov_3.190184_g26829_i0	PRJNA1104180	26972	236	3.190184	7.52883424	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	320	5.26e-83	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g26829	i0	92.241	6.5635593220339	232	8	98	6	1	231	6206717	6206939	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	1549	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
14241355	14241355	PRJNA1104180_P_NODE_9192_length_327_cov_6.429134_g9050_i0	PRJNA1104180	9192	327	6.429134	21.02326818	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	593	4.0699999999999987e-165	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g9050	i0	99.388	161.278287461774	327	2	100	0	1	327	3044	3370	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52738	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15514864	15514864	PRJNA1104180_P_NODE_13053_length_289_cov_1.115741_g12911_i0	PRJNA1104180	13053	289	1.115741	3.22449149	Microcoleus vaginatus	119532	Bacteria	Bacteria	424	4.9199999999999996e-114	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g12911	i0	93.103	4.01384083044983	290	18	100	2	1	289	6756091	6755803	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1160	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
15514948	15514948	PRJNA1104180_P_NODE_19033_length_256_cov_1.573770_g18891_i0	PRJNA1104180	19033	256	1.57377	4.0288512	Microcoleus vaginatus	119532	Bacteria	Bacteria	438	1.5299999999999996e-118	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g18891	i0	97.647	7.05078125	255	6	99	0	1	255	6161543	6161289	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1805	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
16322792	16322792	PRJNA1104180_P_NODE_19753_length_252_cov_3.296089_g19610_i0	PRJNA1104180	19753	252	3.296089	8.30614428	Chroococcidiopsis	54298	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g19610	i0	98.81	131.142857142857	252	3	100	0	1	252	964	713	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	33048	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16789500	16789500	PRJNA1104180_P_NODE_20974_length_250_cov_0.870056_g20831_i0	PRJNA1104180	20974	250	0.870056	2.17514	Nostoc sp. C057	2576903	Bacteria	Bacteria	403	5.43e-108	NTclustered	gi\|1866646741\|gb\|CP040281.1\|	2576903	g20831	i0	96.327	14.564	245	9	98	0	5	249	7112039	7111795	Nostoc sp. C057 chromosome, complete genome	blastn	3641	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
19338042	19338042	PRJNA1104180_P_NODE_1176_length_799_cov_8.176309_g1040_i0	PRJNA1104180	1176	799	8.176309	65.32870891	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1116	0	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g1040	i0	91.895	113.724655819775	802	59	99	6	2	799	2463	1664	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	90866	1116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19338058	19338058	PRJNA1104180_P_NODE_12556_length_292_cov_1.273973_g12414_i0	PRJNA1104180	12556	292	1.273973	3.72000116	Phormidium nigroviride	482564	Bacteria	Bacteria	512	1.03e-140	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g12414	i0	98.288	14.3493150684932	292	5	100	0	1	292	6292633	6292924	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	4190	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
19338222	19338222	PRJNA1104180_P_NODE_23616_length_245_cov_1.610465_g23473_i0	PRJNA1104180	23616	245	1.610465	3.94563925	Phormidium nigroviride	482564	Bacteria	Bacteria	451	1.87e-122	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g23473	i0	100	5.95918367346939	244	0	99	0	2	245	5451176	5450933	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1460	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
20146650	20146650	PRJNA1104180_P_NODE_18956_length_256_cov_2.469945_g18814_i0	PRJNA1104180	18956	256	2.469945	6.3230592	Bacillati	1783272	Bacteria	Bacteria	270	5.899999999999999e-68	NTclustered	gi\|47118304\|dbj\|BA000022.2\|	1148	g18814	i0	99.329	44.17578125	149	1	58	0	108	256	934294	934442	Synechocystis sp. PCC 6803 DNA, complete genome	blastn	11309	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
20613442	20613442	PRJNA1104180_P_NODE_14557_length_280_cov_1.275362_g14415_i0	PRJNA1104180	14557	280	1.275362	3.5710136	Phormidium nigroviride	482564	Bacteria	Bacteria	518	2.12e-142	NTclustered	gi\|428244644\|gb\|CP003615.1\|	179408	g14415	i0	100	3.80357142857143	280	0	100	0	1	280	266112	265833	Oscillatoria nigro-viridis PCC 7112 plasmid pOSC7112.01, complete sequence	blastn	1065	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
20613465	20613465	PRJNA1104180_P_NODE_1637_length_674_cov_4.866889_g1497_i0	PRJNA1104180	1637	674	4.866889	32.80283186	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	848	0	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g1497	i0	89.497	170.818991097923	676	64	99	6	1	672	1114	1786	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	115132	848	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
20613556	20613556	PRJNA1104180_P_NODE_23017_length_246_cov_1.427746_g22874_i0	PRJNA1104180	23017	246	1.427746	3.51225516	Microcoleus vaginatus	119532	Bacteria	Bacteria	353	5.44e-93	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g22874	i0	92.683	5.27235772357724	246	17	100	1	1	246	2402746	2402502	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1297	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21889002	21889002	PRJNA1104180_P_NODE_10758_length_310_cov_2.101266_g10616_i0	PRJNA1104180	10758	310	2.101266	6.5139246	Microcoleus vaginatus	119532	Bacteria	Bacteria	250	9.57e-62	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g10616	i0	96.667	5.15806451612903	150	5	97	0	161	310	1404103	1403954	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1599	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21889127	21889127	PRJNA1104180_P_NODE_19638_length_253_cov_1.611111_g19495_i0	PRJNA1104180	19638	253	1.611111	4.07611083	Microcoleus vaginatus	119532	Bacteria	Bacteria	424	4.22e-114	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g19495	i0	96.838	3.20553359683794	253	8	100	0	1	253	6341550	6341298	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	811	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21889162	21889162	PRJNA1104180_P_NODE_21998_length_248_cov_0.880000_g21855_i0	PRJNA1104180	21998	248	0.88	2.1824	Microcoleus vaginatus	119532	Bacteria	Bacteria	396	9e-106	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g21855	i0	95.547	5.49596774193548	247	11	99	0	2	248	4558467	4558221	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1363	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
22697215	22697215	PRJNA1104180_P_NODE_15358_length_275_cov_2.475248_g15216_i0	PRJNA1104180	15358	275	2.475248	6.806932	Cyanophyceae	3028117	Bacteria	Bacteria	479	9.78e-131	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g15216	i0	98.175	188.916363636364	274	5	99	0	2	275	1873399	1873672	Leptolyngbya sp. O-77 DNA, complete genome	blastn	51952	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
23164562	23164562	PRJNA1104180_P_NODE_15419_length_275_cov_1.524752_g15277_i0	PRJNA1104180	15419	275	1.524752	4.193068	Phormidium nigroviride	482564	Bacteria	Bacteria	492	1.26e-134	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g15277	i0	98.909	5.63636363636364	275	3	100	0	1	275	6423056	6423330	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1550	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
23164571	23164571	PRJNA1104180_P_NODE_15939_length_272_cov_1.547739_g15797_i0	PRJNA1104180	15939	272	1.547739	4.20985008	Microcoleus vaginatus	119532	Bacteria	Bacteria	387	6.02e-103	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g15797	i0	92.279	4.00367647058824	272	21	100	0	1	272	4691812	4691541	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1089	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23164573	23164573	PRJNA1104180_P_NODE_16059_length_271_cov_2.333333_g15917_i0	PRJNA1104180	16059	271	2.333333	6.32333243	Phormidium nigroviride	482564	Bacteria	Bacteria	141	5.16e-29	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g15917	i0	84.615	1.16236162361624	143	21	53	1	1	143	6392371	6392512	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	315	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
23164619	23164619	PRJNA1104180_P_NODE_19259_length_255_cov_1.439560_g19116_i0	PRJNA1104180	19259	255	1.43956	3.670878	Phormidium nigroviride	482564	Bacteria	Bacteria	405	1.54e-108	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g19116	i0	95.294	4	255	12	100	0	1	255	3811352	3811098	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1020	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
23164641	23164641	PRJNA1104180_P_NODE_20999_length_250_cov_0.870056_g20856_i0	PRJNA1104180	20999	250	0.870056	2.17514	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g20856	i0	82.197	2.112	264	32	100	10	1	250	3320987	3320725	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	528	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
23164675	23164675	PRJNA1104180_P_NODE_23159_length_246_cov_0.890173_g23016_i0	PRJNA1104180	23159	246	0.890173	2.18982558	Microcoleus vaginatus	119532	Bacteria	Bacteria	414	2.46e-111	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g23016	i0	97.143	5.5650406504065	245	7	99	0	1	245	6683762	6684006	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	1369	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23164706	23164706	PRJNA1104180_P_NODE_25239_length_243_cov_0.905882_g25096_i0	PRJNA1104180	25239	243	0.905882	2.20129326	Microcoleus vaginatus	119532	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g25096	i0	98.354	3.97119341563786	243	4	100	0	1	243	6186410	6186168	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	965	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23972650	23972650	PRJNA1104180_P_NODE_3339_length_489_cov_5.495192_g3198_i0	PRJNA1104180	3339	489	5.495192	26.87148888	Macrochaete	1844958	Bacteria	Bacteria	806	0	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g3198	i0	96.708	296.278118609407	486	13	99	3	5	489	2016	1533	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	144880	806	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides

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