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

40 rows where analysis = "blastn", bioproject = "PRJNA565584" 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
554833	554833	PRJNA565584_P_NODE_133781_length_273_cov_1.320000_g132629_i0	PRJNA565584	133781	273	1.32	3.6036	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	268	2.2899999999999994e-67	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g132629	i0	86.081	1	273	11	100	4	1	273	1562884	1562639	Allocoleopsis franciscana PCC 7113, complete genome	blastn	273	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
555488	555488	PRJNA565584_P_NODE_166161_length_251_cov_2.202247_g165009_i0	PRJNA565584	166161	251	2.202247	5.52763997	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	206	1.65e-48	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g165009	i0	81.707	0.9800796812749	246	45	98	0	6	251	2659892	2659647	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	246	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
1134544	1134544	PRJNA565584_P_NODE_202141_length_244_cov_0.900585_g200989_i0	PRJNA565584	202141	244	0.900585	2.1974274	Oscillatoriales	1150	Bacteria	Bacteria	375	1.15e-99	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g200989	i0	94.628	3.9672131147541	242	13	99	0	3	244	4821440	4821681	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	968	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
1831122	1831122	PRJNA565584_P_NODE_173382_length_250_cov_0.870056_g172230_i0	PRJNA565584	173382	250	0.870056	2.17514	Microcoleus vaginatus	119532	Bacteria	Bacteria	394	3.27e-105	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g172230	i0	95.181	6.008	249	12	99	0	1	249	3672770	3673018	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1502	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
3106064	3106064	PRJNA565584_P_NODE_148923_length_263_cov_1.384211_g147771_i0	PRJNA565584	148923	263	1.384211	3.64047493	Crinalium epipsammum	241425	Bacteria	Bacteria	239	1.72e-58	NTclustered	gi\|428245228\|gb\|CP003620.1\|	1173022	g147771	i0	87.745	66.319391634981	204	25	82	0	2	205	816976	817179	Crinalium epipsammum PCC 9333, complete genome	blastn	17442	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
3107052	3107052	PRJNA565584_P_NODE_206343_length_243_cov_0.905882_g205191_i0	PRJNA565584	206343	243	0.905882	2.20129326	Chamaesiphon minutus	1173032	Bacteria	Bacteria	250	7.2399999999999995e-62	NTclustered	gi\|428015215\|gb\|CP003600.1\|	1173020	g205191	i0	85.185	1	243	36	100	0	1	243	1049994	1050236	Chamaesiphon minutus PCC 6605, complete genome	blastn	243	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
3686237	3686237	PRJNA565584_P_NODE_31263_length_545_cov_6.277542_g30115_i0	PRJNA565584	31263	545	6.277542	34.2126039	Nostocaceae	1162	Bacteria	Bacteria	983	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g30115	i0	100	5.14862385321101	532	0	98	0	14	545	4274695	4275226	Nostoc sp. PCC 7120 DNA, complete genome	blastn	2806	983	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
4381762	4381762	PRJNA565584_P_NODE_102624_length_295_cov_1.036036_g101472_i0	PRJNA565584	102624	295	1.036036	3.0563062	Anabaena sp. 90	46234	Bacteria	Bacteria	174	5.6e-39	NTclustered	gi\|413968727\|gb\|CP003284.1\|	46234	g101472	i0	77.622	8.34237288135593	286	64	97	0	2	287	923870	924155	Anabaena sp. 90 chromosome chANA01, complete sequence	blastn	2461	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. 90
4385517	4385517	PRJNA565584_P_NODE_99344_length_299_cov_8.663717_g98192_i0	PRJNA565584	99344	299	8.663717	25.90451383	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	372	1.88e-98	NTclustered	gi\|146740643\|emb\|AM709630.1\|	118168	g98192	i0	89.298	133.545150501672	299	28	99	4	1	297	3106	3402	Microcoleus chthonoplastes PCC 7420 partial ribosomal RNA operon, strain PCC 7420	blastn	39930	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
4963458	4963458	PRJNA565584_P_NODE_71244_length_352_cov_1.430108_g70093_i0	PRJNA565584	71244	352	1.430108	5.03398016	Synechococcus	1129	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|147846875\|emb\|CT971583.1\|	32051	g70093	i0	97.059	0.193181818181818	34	0	9	1	200	232	1058750	1058717	Synechococcus WH7803 complete genome sequence	blastn	68	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. WH 7803
5658890	5658890	PRJNA565584_P_NODE_144365_length_266_cov_1.352332_g143213_i0	PRJNA565584	144365	266	1.352332	3.59720312	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	215	2.93e-51	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g143213	i0	81.538	4.88721804511278	260	48	98	0	7	266	432095	432354	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	1300	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
5661513	5661513	PRJNA565584_P_NODE_8425_length_1176_cov_2.120580_g7564_i0	PRJNA565584	8425	1176	2.12058	24.9380208	Prochlorococcus sp. MIT 1223	3096217	Bacteria	Bacteria	65.8	1.54e-5	NTclustered	gi\|2625929803\|gb\|CP139303.1\|	3096217	g7564	i0	95.122	0.034863945578231303	41	2	3	0	422	462	1693199	1693239	Prochlorococcus sp. MIT 1223 chromosome, complete genome	blastn	41	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1223
6237547	6237547	PRJNA565584_P_NODE_138305_length_270_cov_1.345178_g137153_i0	PRJNA565584	138305	270	1.345178	3.6319806	Chroococcidiopsis	54298	Bacteria	Bacteria	263	1.05e-65	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g137153	i0	87.892	2.64074074074074	223	27	83	0	48	270	732718	732496	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	713	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
6238083	6238083	PRJNA565584_P_NODE_203245_length_243_cov_1.800000_g202093_i0	PRJNA565584	203245	243	1.8	4.374	Chroococcidiopsis	54298	Bacteria	Bacteria	340	4.169999999999999e-89	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g202093	i0	92.116	3.95061728395062	241	19	99	0	3	243	2921618	2921858	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	960	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
7511825	7511825	PRJNA565584_P_NODE_131426_length_274_cov_2.044776_g130274_i0	PRJNA565584	131426	274	2.044776	5.60268624	Bacteria	2	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|440337519\|gb\|KC110372.1\|	1211	g130274	i0	100	100.244525547445	274	0	100	0	1	274	147	420	Uncultured cyanobacterium clone CW1_P2_3B 16S ribosomal RNA gene, partial sequence	blastn	27467	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9482949	9482949	PRJNA565584_P_NODE_116868_length_284_cov_1.094787_g115716_i0	PRJNA565584	116868	284	1.094787	3.10919508	Synechococcus sp. A15-24	1050635	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1895823488\|gb\|CP047960.1\|	1050635	g115716	i0	100	0.102112676056338	29	0	10	0	227	255	156059	156031	Synechococcus sp. A15-24 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-24
11337508	11337508	PRJNA565584_P_NODE_172069_length_250_cov_0.870056_g170917_i0	PRJNA565584	172069	250	0.870056	2.17514	Chroococcidiopsis	54298	Bacteria	Bacteria	433	6.92e-117	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g170917	i0	98	127.068	250	4	100	1	1	250	1428	1676	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	31767	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
12036131	12036131	PRJNA565584_P_NODE_46370_length_438_cov_1.750685_g45219_i0	PRJNA565584	46370	438	1.750685	7.6680003	Coleofasciculus chthonoplastes	64178	Bacteria	Bacteria	697	0	NTclustered	gi\|146740643\|emb\|AM709630.1\|	118168	g45219	i0	95.444	147.212328767123	439	16	100	4	1	438	2823	2388	Microcoleus chthonoplastes PCC 7420 partial ribosomal RNA operon, strain PCC 7420	blastn	64479	697	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
12036483	12036483	PRJNA565584_P_NODE_64910_length_368_cov_4.515254_g63759_i0	PRJNA565584	64910	368	4.515254	16.61613472	Microcoleus sp. PCC 8701	272133	Bacteria	Bacteria	584	2.789999999999999e-162	NTclustered	gi\|46409899\|gb\|AY584524.1\|	272133	g63759	i0	95.368	160.119565217391	367	17	99	0	2	368	1166	1532	Microcoleus sp. PCC 8701 23S ribosomal RNA gene, partial sequence	blastn	58924	584	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PCC 8701
13309513	13309513	PRJNA565584_P_NODE_164491_length_252_cov_2.882682_g163339_i0	PRJNA565584	164491	252	2.882682	7.26435864	Fischerella sp. JS2	2597771	Bacteria	Bacteria	283	7.44e-72	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g163339	i0	86.905	30.1587301587302	252	33	100	0	1	252	6690551	6690300	Fischerella sp. JS2 chromosome, complete genome	blastn	7600	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2
14584775	14584775	PRJNA565584_P_NODE_191412_length_246_cov_0.890173_g190260_i0	PRJNA565584	191412	246	0.890173	2.18982558	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	315	2.57e-81	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g190260	i0	90.083	0.983739837398374	242	24	98	0	1	242	5388016	5387775	Calothrix sp. PCC 7716 DNA, complete genome	blastn	242	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
18407224	18407224	PRJNA565584_P_NODE_148855_length_263_cov_1.431579_g147703_i0	PRJNA565584	148855	263	1.431579	3.76505277	Nostoc sp. CENA543	1869241	Bacteria	Bacteria	333	7.659999999999999e-87	NTclustered	gi\|1334423280\|gb\|CP023279.1\|	1869241	g147703	i0	89.734	1.42205323193916	263	23	99	4	3	263	10937	11197	Nostoc sp. CENA543 plasmid pCENA543c, complete sequence	blastn	374	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
18407804	18407804	PRJNA565584_P_NODE_182515_length_248_cov_0.880000_g181363_i0	PRJNA565584	182515	248	0.88	2.1824	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	174	4.59e-39	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g181363	i0	79.668	0.971774193548387	241	49	97	0	1	241	7136659	7136899	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	241	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
18986103	18986103	PRJNA565584_P_NODE_2595_length_2109_cov_5.785855_g2255_i0	PRJNA565584	2595	2109	5.785855	122.02368195	Nostocaceae	1162	Bacteria	Bacteria	2385	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g2255	i0	100	40.493124703651	1291	0	61	0	1	1291	4273406	4274696	Nostoc sp. PCC 7120 DNA, complete genome	blastn	85400	2385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
19681308	19681308	PRJNA565584_P_NODE_130836_length_275_cov_1.222772_g129684_i0	PRJNA565584	130836	275	1.222772	3.362623	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	374	4.7499999999999996e-99	NTclustered	gi\|225696253\|gb\|FJ805920.1\|	259957	g129684	i0	91.273	148.64	275	23	100	1	1	275	3218	2945	Uncultured Chroococcidiopsis sp. clone A1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40876	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21536941	21536941	PRJNA565584_P_NODE_40437_length_471_cov_6.281407_g39286_i0	PRJNA565584	40437	471	6.281407	29.58542697	Cyanophyceae	3028117	Bacteria	Bacteria	725	0	NTclustered	gi\|485099154\|ref\|NR_102549.1\|	1173022	g39286	i0	94.34	125.386411889597	477	19	100	6	1	471	1018	544	Crinalium epipsammum PCC 9333 strain PCC 9333 23S ribosomal RNA, complete sequence	blastn	59057	732	0.990437158469945	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
21537176	21537176	PRJNA565584_P_NODE_59017_length_387_cov_1.152866_g57866_i0	PRJNA565584	59017	387	1.152866	4.46159142	Oscillatoriales	1150	Bacteria	Bacteria	704	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g57866	i0	99.483	153.21188630491	387	2	100	0	1	387	1775	2161	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	59293	710	0.991549295774648	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22231736	22231736	PRJNA565584_P_NODE_120218_length_281_cov_3.201923_g119066_i0	PRJNA565584	120218	281	3.201923	8.99740363	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g119066	i0	100	1.02846975088968	29	0	10	0	58	86	1873227	1873255	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	289	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
22231850	22231850	PRJNA565584_P_NODE_125838_length_278_cov_1.502439_g124686_i0	PRJNA565584	125838	278	1.502439	4.17678042	Sphaerospermopsis torques-reginae	984207	Bacteria	Bacteria	137	6.87e-28	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g124686	i0	81.176	0.611510791366906	170	32	61	0	1	170	773358	773527	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	170	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
22231905	22231905	PRJNA565584_P_NODE_128738_length_276_cov_1.517241_g127586_i0	PRJNA565584	128738	276	1.517241	4.18758516	Acaryochloris marina	155978	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2034612996\|gb\|CP064923.1\|	2762553	g127586	i0	100	0.101449275362319	28	0	10	0	22	49	401385	401412	Acaryochloris marina S15 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
22811744	22811744	PRJNA565584_P_NODE_203938_length_243_cov_1.117647_g202786_i0	PRJNA565584	203938	243	1.117647	2.71588221	root	1	Root_unresolved	Root_unresolved	444	3.09e-120	NTclustered	gi\|1214568504\|dbj\|LC176673.1\|	1211	g202786	i0	99.588	99.9300411522634	243	1	100	0	1	243	175	417	Uncultured cyanobacterium gene for 16S ribosomal RNA, partial sequence, clone: MIU_SFDB_3_20	blastn	24283	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22812199	22812199	PRJNA565584_P_NODE_43218_length_455_cov_1.382199_g42067_i0	PRJNA565584	43218	455	1.382199	6.28900545	Nostocaceae	1162	Bacteria	Bacteria	833	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g42067	i0	99.78	51.9604395604396	455	0	100	1	1	455	1590618	1590165	Nostoc sp. PCC 7120 DNA, complete genome	blastn	23642	833	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
22812345	22812345	PRJNA565584_P_NODE_54258_length_403_cov_4.839394_g53107_i0	PRJNA565584	54258	403	4.839394	19.50275782	Nostocaceae	1162	Bacteria	Bacteria	723	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g53107	i0	99.252	9.56079404466501	401	2	99	1	1	400	4275782	4275382	Nostoc sp. PCC 7120 DNA, complete genome	blastn	3853	723	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
22812870	22812870	PRJNA565584_P_NODE_97138_length_303_cov_2.465217_g95986_i0	PRJNA565584	97138	303	2.465217	7.46960751	Chroococcidiopsis	54298	Bacteria	Bacteria	558	1.36e-154	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g95986	i0	100	159.085808580858	302	0	99	0	1	302	16	317	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	48203	558	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
23508380	23508380	PRJNA565584_P_NODE_196799_length_245_cov_0.895349_g195647_i0	PRJNA565584	196799	245	0.895349	2.19360505	Okeanomitos corallinicola	3231550	Bacteria	Bacteria	198	2.68e-46	NTclustered	gi\|2715117499\|gb\|CP150886.1\|	3133117	g195647	i0	81.481	13.6571428571429	243	43	99	2	1	242	3554025	3553784	Okeanomitos corallinicola TIOX110 chromosome, complete genome	blastn	3346	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Okeanomitos	Okeanomitos corallinicola
23508659	23508659	PRJNA565584_P_NODE_213979_length_241_cov_0.916667_g212827_i0	PRJNA565584	213979	241	0.916667	2.20916747	Anabaenopsis circularis	109266	Bacteria	Bacteria	364	2.4499999999999993e-96	NTclustered	gi\|1210095109\|dbj\|AP018174.1\|	1085406	g212827	i0	96.789	6.78008298755187	218	7	90	0	1	218	5905220	5905437	Anabaenopsis circularis NIES-21 DNA, nearly complete genome	blastn	1634	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
24085846	24085846	PRJNA565584_P_NODE_135259_length_272_cov_1.371859_g134107_i0	PRJNA565584	135259	272	1.371859	3.73145648	Bacillati	1783272	Bacteria	Bacteria	492	1.24e-134	NTclustered	gi\|47118304\|dbj\|BA000022.2\|	1148	g134107	i0	99.265	18	272	2	100	0	1	272	703704	703975	Synechocystis sp. PCC 6803 DNA, complete genome	blastn	4896	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
24781696	24781696	PRJNA565584_P_NODE_163520_length_253_cov_1.711111_g162368_i0	PRJNA565584	163520	253	1.711111	4.32911083	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	313	9.539999999999999e-81	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g162368	i0	88.933	46.4150197628459	253	28	100	0	1	253	6109621	6109873	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	11743	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
24781701	24781701	PRJNA565584_P_NODE_163660_length_253_cov_1.711111_g162508_i0	PRJNA565584	163660	253	1.711111	4.32911083	Halomicronema hongdechloris	1209493	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1562104929\|gb\|CP021983.2\|	1641165	g162508	i0	100	0.110671936758893	28	0	11	0	179	206	1795703	1795730	Halomicronema hongdechloris C2206 genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Halomicronema	Halomicronema hongdechloris
24782288	24782288	PRJNA565584_P_NODE_202040_length_244_cov_0.900585_g200888_i0	PRJNA565584	202040	244	0.900585	2.1974274	Fischerella sp. JS2	2597771	Bacteria	Bacteria	207	4.44e-49	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g200888	i0	82.158	4.7827868852459	241	43	99	0	4	244	2940447	2940207	Fischerella sp. JS2 chromosome, complete genome	blastn	1167	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2

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