metadata: contig_metadata: 44 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax

44 rows where analysis = "blastn", bioproject = "PRJNA942359" 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
1258736	1258736	PRJNA942359_P_NODE_1201_length_702_cov_2.260731_g1096_i0	PRJNA942359	1201	702	2.260731	15.87033162	Gloeothece	28070	Bacteria	Bacteria	1020	0	NTclustered	gi\|218169741\|gb\|CP001291.1\|	65393	g1096	i0	93.03	140.457264957265	703	42	99	4	1	700	1331776	1332474	Cyanothece sp. PCC 7424, complete genome	blastn	98601	1024	0.99609375	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
3473625	3473625	PRJNA942359_P_NODE_10143_length_279_cov_1.514563_g10028_i0	PRJNA942359	10143	279	1.514563	4.22563077	Nostoc piscinale	224012	Bacteria	Bacteria	449	7.799999999999999e-122	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g10028	i0	95.699	314.10394265233	279	12	100	0	1	279	2145944	2146222	Nostoc piscinale CENA21 chromosome	blastn	87635	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
3473706	3473706	PRJNA942359_P_NODE_14063_length_251_cov_2.331461_g13948_i0	PRJNA942359	14063	251	2.331461	5.85196711	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g13948	i0	91.235	1	251	22	100	0	1	251	503237	503487	Calothrix sp. PCC 7716 DNA, complete genome	blastn	251	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
3473918	3473918	PRJNA942359_P_NODE_6823_length_325_cov_2.980159_g6708_i0	PRJNA942359	6823	325	2.980159	9.68551675	Gloeothece citriformis	2546356	Bacteria	Bacteria	555	1.9099999999999995e-153	NTclustered	gi\|218169741\|gb\|CP001291.1\|	65393	g6708	i0	97.546	164.230769230769	326	4	100	4	1	325	1331669	1331991	Cyanothece sp. PCC 7424, complete genome	blastn	53375	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
4751491	4751491	PRJNA942359_P_NODE_6184_length_338_cov_2.588679_g6069_i0	PRJNA942359	6184	338	2.588679	8.74973502	Gloeothece verrucosa	2546359	Bacteria	Bacteria	547	3.339999999999999e-151	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g6069	i0	96.131	180.896449704142	336	11	99	2	1	336	3856324	3856657	Cyanothece sp. PCC 7822, complete genome	blastn	61143	547	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
6025980	6025980	PRJNA942359_P_NODE_10045_length_280_cov_1.468599_g9930_i0	PRJNA942359	10045	280	1.468599	4.1120772	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	507	4.58e-139	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g9930	i0	99.286	152.464285714286	280	2	100	0	1	280	1761	1482	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	42690	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
6026269	6026269	PRJNA942359_P_NODE_6565_length_331_cov_1.003876_g6450_i0	PRJNA942359	6565	331	1.003876	3.32282956	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	595	1.1499999999999998e-165	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g6450	i0	99.094	119.749244712991	331	3	100	0	1	331	3307	2977	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	39637	595	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7300901	7300901	PRJNA942359_P_NODE_10126_length_279_cov_1.922330_g10011_i0	PRJNA942359	10126	279	1.92233	5.3633007	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	278	3.89e-70	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g10011	i0	84.588	12.3010752688172	279	43	100	0	1	279	1694994	1694716	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	3432	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
7301232	7301232	PRJNA942359_P_NODE_7646_length_311_cov_1.852941_g7531_i0	PRJNA942359	7646	311	1.852941	5.76264651	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	416	8.95e-112	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g7531	i0	90.939	155.861736334405	309	28	99	0	3	311	1903	1595	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48473	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7301244	7301244	PRJNA942359_P_NODE_8326_length_300_cov_1.929515_g8211_i0	PRJNA942359	8326	300	1.929515	5.788545	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	416	8.59e-112	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g8211	i0	91.694	116.676666666667	301	24	100	1	1	300	1905	2205	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35003	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7301248	7301248	PRJNA942359_P_NODE_8566_length_296_cov_3.910314_g8451_i0	PRJNA942359	8566	296	3.910314	11.57452944	Gloeothece verrucosa	2546359	Bacteria	Bacteria	396	1.0999999999999994e-105	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g8451	i0	91.379	131.179054054054	290	23	98	2	2	290	1627748	1627460	Cyanothece sp. PCC 7822, complete genome	blastn	38829	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
8575769	8575769	PRJNA942359_P_NODE_12067_length_260_cov_1.807487_g11952_i0	PRJNA942359	12067	260	1.807487	4.6994662	Microcoleus vaginatus	119532	Bacteria	Bacteria	239	1.69e-58	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g11952	i0	83.65	149.338461538462	263	33	99	8	2	260	101951	102207	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	38828	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
8575850	8575850	PRJNA942359_P_NODE_1627_length_608_cov_1.882243_g1517_i0	PRJNA942359	1627	608	1.882243	11.44403744	Phormidium sp. NIES-2120	2510783	Bacteria	Bacteria	654	0	NTclustered	gi\|1566846236\|dbj\|LC455614.1\|	2510783	g1517	i0	86.275	121.386513157895	612	73	100	10	1	608	1718	1114	Phormidium sp. NIES-2120 gene for 23S ribosomal RNA, partial sequence	blastn	73803	654	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2120
8575952	8575952	PRJNA942359_P_NODE_2667_length_481_cov_1.833333_g2553_i0	PRJNA942359	2667	481	1.833333	8.81833173	Gloeothece verrucosa	2546359	Bacteria	Bacteria	662	0	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g2553	i0	91.546	178.288981288981	485	33	100	7	1	481	1627744	1627264	Cyanothece sp. PCC 7822, complete genome	blastn	85757	662	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
8575955	8575955	PRJNA942359_P_NODE_2767_length_473_cov_5.095000_g2653_i0	PRJNA942359	2767	473	5.095	24.09935	Scytonema hofmannii	34078	Bacteria	Bacteria	691	0	NTclustered	gi\|146740650\|emb\|AM709637.1\|	128403	g2653	i0	93.096	282.99577167019	478	23	100	10	1	473	3286	2814	Scytonema hofmanni PCC 7110 partial ribosomal RNA operon, strain PCC 7110	blastn	133857	691	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
8911725	8911725	PRJNA942359_P_NODE_9827_length_282_cov_2.119617_g9712_i0	PRJNA942359	9827	282	2.119617	5.97731994	Nostocales	1161	Bacteria	Bacteria	394	3.75e-105	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g9712	i0	92.727	194.283687943262	275	16	96	4	11	282	2135937	2136210	Nostoc sp. PCC 7524, complete genome	blastn	54788	396	0.994949494949495	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
11126521	11126521	PRJNA942359_P_NODE_14809_length_250_cov_0.881356_g14694_i0	PRJNA942359	14809	250	0.881356	2.20339	Picosynechococcus sp. PCC 7002	32049	Bacteria	Bacteria	130	1.02e-25	NTclustered	gi\|169884305\|gb\|CP000951.1\|	32049	g14694	i0	92.553	44.396	94	2	37	5	1	93	1461404	1461315	Synechococcus sp. PCC 7002, complete genome	blastn	11099	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7002
11126562	11126562	PRJNA942359_P_NODE_16609_length_247_cov_1.505747_g16494_i0	PRJNA942359	16609	247	1.505747	3.71919509	Oculatella crustae-formantes	2739055	Bacteria	Bacteria	348	2.5400000000000004e-91	NTclustered	gi\|1713066357\|gb\|MN243147.1\|	2599945	g16494	i0	92.887	191.008097165992	239	17	97	0	1	239	2208	1970	Oculatella crustae-formantes PJ S28 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47179	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella crustae-formantes
11126690	11126690	PRJNA942359_P_NODE_3929_length_407_cov_2.488024_g3814_i0	PRJNA942359	3929	407	2.488024	10.12625768	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	433	1.19e-116	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g3814	i0	86.923	181.683046683047	390	45	96	6	15	403	3337	3721	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	73945	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
12402022	12402022	PRJNA942359_P_NODE_1290_length_679_cov_2.417492_g1182_i0	PRJNA942359	1290	679	2.417492	16.41477068	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	896	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g1182	i0	90.497	110.446244477172	684	58	100	6	1	679	2190	1509	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	74993	896	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12402240	12402240	PRJNA942359_P_NODE_5850_length_346_cov_3.402930_g5735_i0	PRJNA942359	5850	346	3.40293	11.7741378	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	584	2.609999999999999e-162	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g5735	i0	97.118	115.534682080925	347	8	100	2	1	346	2732	2387	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39975	584	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14950810	14950810	PRJNA942359_P_NODE_112_length_1792_cov_22.449680_g14_i3	PRJNA942359	112	1792	22.44968	402.2982656	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2377	0	NTclustered	gi\|225696222\|gb\|FJ805889.1\|	259957	g14	i3	90.658	106.669084821429	1809	139	100	24	1	1792	3469	1674	Uncultured Chroococcidiopsis sp. clone NA2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	191151	2377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17501036	17501036	PRJNA942359_P_NODE_11294_length_267_cov_2.917526_g11179_i0	PRJNA942359	11294	267	2.917526	7.78979442	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	405	1.63e-108	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g11179	i0	94.636	118.50936329588	261	14	98	0	7	267	1892	1632	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	31642	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17501240	17501240	PRJNA942359_P_NODE_3094_length_450_cov_3.198939_g2980_i0	PRJNA942359	3094	450	3.198939	14.3952255	Scytonema hofmannii	34078	Bacteria	Bacteria	604	2.6699999999999992e-168	NTclustered	gi\|146740650\|emb\|AM709637.1\|	128403	g2980	i0	91.071	168.922222222222	448	34	99	5	5	450	2092	2535	Scytonema hofmanni PCC 7110 partial ribosomal RNA operon, strain PCC 7110	blastn	76015	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
17501333	17501333	PRJNA942359_P_NODE_834_length_832_cov_3.897233_g735_i0	PRJNA942359	834	832	3.897233	32.42497856	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	1393	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g735	i0	96.879	237.110576923077	833	24	100	2	1	832	1858488	1859319	Calothrix sp. PCC 7716 DNA, complete genome	blastn	197276	1393	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
17836259	17836259	PRJNA942359_P_NODE_20494_length_235_cov_2.623457_g20379_i0	PRJNA942359	20494	235	2.623457	6.16512395	Leptolyngbya	47251	Bacteria	Bacteria	257	4.16e-64	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g20379	i0	86.383	7	235	32	100	0	1	235	31288	31522	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	1645	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
18774813	18774813	PRJNA942359_P_NODE_2955_length_459_cov_2.813472_g2841_i0	PRJNA942359	2955	459	2.813472	12.91383648	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	641	2.08e-179	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g2841	i0	91.828	177.740740740741	465	31	100	6	1	459	2319	1856	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	81583	641	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18774832	18774832	PRJNA942359_P_NODE_4315_length_391_cov_2.160377_g4200_i0	PRJNA942359	4315	391	2.160377	8.44707407	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	717	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g4200	i0	99.744	271.774936061381	391	1	100	0	1	391	1857056	1857446	Calothrix sp. PCC 7716 DNA, complete genome	blastn	106264	717	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
20049553	20049553	PRJNA942359_P_NODE_15636_length_249_cov_0.886364_g15521_i0	PRJNA942359	15636	249	0.886364	2.20704636	Richelia sinica	1357545	Bacteria	Bacteria	276	1.2299999999999999e-69	NTclustered	gi\|2059364121\|gb\|CP021056.1\|	1357546	g15521	i0	87.243	18.8232931726908	243	29	97	2	2	243	1629965	1630206	Richelia sinica FACHB-800 strain FACHB 800 chromosome, complete genome	blastn	4687	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sinica
20049727	20049727	PRJNA942359_P_NODE_5996_length_343_cov_2.137037_g5881_i0	PRJNA942359	5996	343	2.137037	7.33003691	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	601	2.57e-167	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g5881	i0	98.256	6.01749271137026	344	5	100	1	1	343	6206928	6206585	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	2064	601	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
20385056	20385056	PRJNA942359_P_NODE_12816_length_253_cov_2.111111_g12701_i0	PRJNA942359	12816	253	2.111111	5.34111083	Chroococcaceae	1890464	Bacteria	Bacteria	340	4.379999999999999e-89	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g12701	i0	90.909	279.328063241107	253	23	100	0	1	253	2873	2621	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	70670	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
20385132	20385132	PRJNA942359_P_NODE_5516_length_354_cov_1.387900_g5401_i0	PRJNA942359	5516	354	1.3879	4.913166	Cyanophyceae	3028117	Bacteria	Bacteria	298	3.9e-76	NTclustered	gi\|470476413\|ref\|NR_076335.1\|	251221	g5401	i0	83.801	116.463276836158	321	45	90	7	35	353	309	624	Gloeobacter violaceus PCC 7421 strain PCC 7421 23S ribosomal RNA gene, complete sequence	blastn	41228	300	0.993333333333333	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
21324997	21324997	PRJNA942359_P_NODE_14757_length_250_cov_0.881356_g14642_i0	PRJNA942359	14757	250	0.881356	2.20339	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	1.22e-79	NTclustered	gi\|225696189\|gb\|FJ805856.1\|	259957	g14642	i0	89.431	176.516	246	24	98	2	6	250	1890	1646	Uncultured Chroococcidiopsis sp. clone AR2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44129	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21325121	21325121	PRJNA942359_P_NODE_20637_length_229_cov_2.641026_g20522_i0	PRJNA942359	20637	229	2.641026	6.04794954	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	331	2.34e-86	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g20522	i0	93.333	165.126637554585	225	14	98	1	2	225	1916	1692	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37814	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21325283	21325283	PRJNA942359_P_NODE_9997_length_280_cov_8.014493_g9882_i0	PRJNA942359	9997	280	8.014493	22.4405804	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	497	2.76e-136	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g9882	i0	98.921	261.867857142857	278	3	99	0	3	280	1858183	1858460	Calothrix sp. PCC 7716 DNA, complete genome	blastn	73323	497	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
21661088	21661088	PRJNA942359_P_NODE_3697_length_417_cov_2.706395_g3582_i0	PRJNA942359	3697	417	2.706395	11.28566715	Leptolyngbya	47251	Bacteria	Bacteria	610	5.2799999999999996e-170	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g3582	i0	93.237	222.153477218225	414	28	100	0	1	414	450922	451335	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	92638	616	0.99025974025974	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
22599883	22599883	PRJNA942359_P_NODE_118_length_1769_cov_11.449292_g14_i4	PRJNA942359	118	1769	11.449292	202.53797548	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2394	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g14	i4	91.17	104.503674392312	1778	135	99	17	6	1769	1640	3409	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	184867	2394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23875527	23875527	PRJNA942359_P_NODE_20439_length_237_cov_2.920732_g20324_i0	PRJNA942359	20439	237	2.920732	6.92213484	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	235	1.97e-57	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g20324	i0	85.153	0.966244725738397	229	34	97	0	3	231	4136674	4136902	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	229	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
23875530	23875530	PRJNA942359_P_NODE_20599_length_231_cov_2.468354_g20484_i0	PRJNA942359	20599	231	2.468354	5.70189774	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	348	2.3500000000000006e-91	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g20484	i0	93.939	169.207792207792	231	12	99	2	2	231	2056021	2056250	Leptolyngbya sp. 7M chromosome	blastn	39087	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
23875674	23875674	PRJNA942359_P_NODE_9679_length_284_cov_1.303318_g9564_i0	PRJNA942359	9679	284	1.303318	3.70142312	Phormidium nigroviride	482564	Bacteria	Bacteria	143	1.51e-29	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g9564	i0	95.506	1.20422535211268	89	4	31	0	195	283	4327362	4327274	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	342	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
25149074	25149074	PRJNA942359_P_NODE_12280_length_258_cov_4.000000_g12165_i0	PRJNA942359	12280	258	4	10.32	Scytonema hofmannii	34078	Bacteria	Bacteria	377	3.41e-100	NTclustered	gi\|146740650\|emb\|AM709637.1\|	128403	g12165	i0	93.023	310.267441860465	258	18	100	0	1	258	1824	1567	Scytonema hofmanni PCC 7110 partial ribosomal RNA operon, strain PCC 7110	blastn	80049	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
25149402	25149402	PRJNA942359_P_NODE_9580_length_285_cov_1.254717_g9465_i0	PRJNA942359	9580	285	1.254717	3.57594345	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	254	6.72e-63	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g9465	i0	83.704	1.32631578947368	270	42	94	2	17	285	4094219	4093951	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	378	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
25149405	25149405	PRJNA942359_P_NODE_9720_length_283_cov_3.628571_g9605_i0	PRJNA942359	9720	283	3.628571	10.26885593	Trichormus azollae	1164	Bacteria	Bacteria	401	2.2499999999999992e-107	NTclustered	gi\|470486451\|ref\|NR_076758.1\|	551115	g9605	i0	92.58	302.159010600707	283	16	99	4	3	281	14	295	'Nostoc azollae' 0708 strain 708 23S ribosomal RNA gene, complete sequence	blastn	85511	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus azollae
25485453	25485453	PRJNA942359_P_NODE_7660_length_311_cov_1.310924_g7545_i0	PRJNA942359	7660	311	1.310924	4.07697364	Cyanophyceae	3028117	Bacteria	Bacteria	479	1.1299999999999996e-130	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g7545	i0	94.516	163.231511254019	310	17	100	0	2	311	281947	281638	Leptolyngbya sp. O-77 DNA, complete genome	blastn	50765	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77

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