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

27 rows where analysis = "blastn", bioproject = "PRJNA725806" 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
711855	711855	PRJNA725806_P_NODE_32281_length_281_cov_9.635246_g31984_i0	PRJNA725806	32281	281	9.635246	27.07504126	Prochlorococcus sp. MIT 1223	3096217	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2625929803\|gb\|CP139303.1\|	3096217	g31984	i0	96.875	0.113879003558719	32	1	11	0	80	111	586397	586366	Prochlorococcus sp. MIT 1223 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1223
711994	711994	PRJNA725806_P_NODE_90921_length_204_cov_3.526946_g90619_i0	PRJNA725806	90921	204	3.526946	7.19496984	Annamia dubia	2815909	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2663421582\|dbj\|AP025630.1\|	2759045	g90619	i0	100	0.137254901960784	28	0	14	0	25	52	3378000	3378027	Annamia dubia NIES-4383 DNA, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
1194424	1194424	PRJNA725806_P_NODE_30241_length_286_cov_5.871486_g29944_i0	PRJNA725806	30241	286	5.871486	16.79244996	Cyanophyceae	3028117	Bacteria	Bacteria	350	8.369999999999999e-92	NTclustered	gi\|470482446\|ref\|NR_076532.1\|	43989	g29944	i0	95.045	135.657342657343	222	11	78	0	14	235	1412	1191	Cyanothece sp. ATCC 51142 strain ATCC 51142 23S ribosomal RNA, complete sequence	blastn	38798	351	0.997150997150997	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
3263025	3263025	PRJNA725806_P_NODE_117423_length_186_cov_1.033557_g117121_i0	PRJNA725806	117423	186	1.033557	1.92241602	Thermocoleostomius sinensis	3065396	Bacteria	Bacteria	148	1.97e-31	NTclustered	gi\|2407448737\|gb\|CP113797.1\|	2016057	g117121	i0	85.517	8.6989247311828	145	17	77	4	44	186	643092	643234	Thermocoleostomius sinensis A174 chromosome, complete genome	blastn	1618	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermocoleostomius	Thermocoleostomius sinensis
3263137	3263137	PRJNA725806_P_NODE_20703_length_315_cov_2.485612_g20407_i0	PRJNA725806	20703	315	2.485612	7.8296778	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	438	1.9399999999999994e-118	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g20407	i0	96.935	85.7968253968254	261	8	83	0	22	282	2150425	2150685	Leptolyngbya sp. 7M chromosome	blastn	27026	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
3746211	3746211	PRJNA725806_P_NODE_29663_length_288_cov_1.764940_g29366_i0	PRJNA725806	29663	288	1.76494	5.0830272	Leptolyngbya	47251	Bacteria	Bacteria	457	4.8299999999999984e-124	NTclustered	gi\|767811646\|gb\|KJ939025.1\|	1601951	g29366	i0	97.378	97.7013888888889	267	7	93	0	1	267	506	772	Leptolyngbya sp. WJT66-NPBG2 16S ribosomal RNA gene, partial sequence	blastn	28138	460	0.993478260869565	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. WJT66-NPBG2
4540113	4540113	PRJNA725806_P_NODE_124_length_1558_cov_26.164366_g61_i2	PRJNA725806	124	1558	26.164366	407.64082228	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1971	0	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g61	i2	90.072	199.852374839538	1531	137	98	15	19	1539	3086	1561	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	311370	1971	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5815415	5815415	PRJNA725806_P_NODE_182005_length_155_cov_2.288136_g181703_i0	PRJNA725806	182005	155	2.288136	3.5466108	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	265	1.5e-66	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g181703	i0	97.419	165.367741935484	155	4	100	0	1	155	3704	3550	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25632	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5815452	5815452	PRJNA725806_P_NODE_21945_length_310_cov_8.003663_g21649_i0	PRJNA725806	21945	310	8.003663	24.8113553	Planktothricoides raciborskii	132608	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g21649	i0	97.059	0.219354838709677	34	0	11	1	101	133	5381050	5381083	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	68	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
5815627	5815627	PRJNA725806_P_NODE_95045_length_201_cov_2.024390_g94743_i0	PRJNA725806	95045	201	2.02439	4.0690239	Moorena producens	1155739	Bacteria	Bacteria	62.1	2.9e-5	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g94743	i0	93.023	91.8805970149254	43	1	22	2	104	146	6582662	6582702	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	18468	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
8365052	8365052	PRJNA725806_P_NODE_133927_length_176_cov_7.143885_g133625_i0	PRJNA725806	133927	176	7.143885	12.5732376	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	58.4	3.19e-4	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g133625	i0	97.059	8.03409090909091	34	1	19	0	50	83	5946359	5946392	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	1414	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
12191141	12191141	PRJNA725806_P_NODE_159470_length_164_cov_4.062992_g159168_i0	PRJNA725806	159470	164	4.062992	6.66330688	uncultured Hormoscilla sp.	1007660	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2751213477\|emb\|OZ001294.2\|	1007660	g159168	i0	84.375	0.390243902439024	64	3	37	7	44	104	3388566	3388507	MAG: uncultured Hormoscilla sp. isolate 8e647e88-4706-4a17-b8b9-b52c092b67df genome assembly, chromosome: 2	blastn	64	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	uncultured Hormoscilla sp.
12673937	12673937	PRJNA725806_P_NODE_147690_length_170_cov_1.195489_g147388_i0	PRJNA725806	147690	170	1.195489	2.0323313	Chroococcidiopsis	54298	Bacteria	Bacteria	259	7.8e-65	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g147388	i0	97.368	100.752941176471	152	4	89	0	1	152	4372	4221	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	17128	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
13465737	13465737	PRJNA725806_P_NODE_7211_length_406_cov_2.940379_g6927_i0	PRJNA725806	7211	406	2.940379	11.93793874	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	433	1.19e-116	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g6927	i0	88.021	140.238916256158	384	22	93	6	15	393	1927	2291	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	56937	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
14741041	14741041	PRJNA725806_P_NODE_73652_length_219_cov_7.692308_g73351_i0	PRJNA725806	73652	219	7.692308	16.84615452	Nostoc sp. C117	3349875	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g73351	i0	96.875	0.146118721461187	32	0	15	1	150	181	1758873	1758903	Nostoc sp. C117 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
16014423	16014423	PRJNA725806_P_NODE_51613_length_246_cov_3.555024_g51316_i0	PRJNA725806	51613	246	3.555024	8.74535904	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g51316	i0	100	0.113821138211382	28	0	11	0	124	151	3595288	3595315	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
21114289	21114289	PRJNA725806_P_NODE_117_length_1587_cov_25.694194_g61_i1	PRJNA725806	117	1587	25.694194	407.76685878	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1903	0	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g61	i1	91.233	208.168241965974	1403	115	88	8	20	1416	1561	2961	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	330363	1903	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21114300	21114300	PRJNA725806_P_NODE_122517_length_183_cov_1.321918_g122215_i0	PRJNA725806	122517	183	1.321918	2.41910994	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	117	5.45e-22	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g122215	i0	80.519	0.841530054644809	154	28	83	2	18	169	3681174	3681021	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	154	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21114560	21114560	PRJNA725806_P_NODE_73997_length_219_cov_3.978022_g73696_i0	PRJNA725806	73997	219	3.978022	8.71186818	Prochlorococcus marinus	1219	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|157386913\|gb\|CP000825.1\|	93060	g73696	i0	100	0.127853881278539	28	0	13	0	81	108	1428013	1427986	Prochlorococcus marinus str. MIT 9215, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
21114614	21114614	PRJNA725806_P_NODE_97_length_1650_cov_25.152511_g61_i0	PRJNA725806	97	1650	25.152511	415.0164315	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1969	0	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g61	i0	91.713	191.999393939394	1424	110	86	8	213	1631	2981	1561	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	316799	1969	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22389271	22389271	PRJNA725806_P_NODE_179318_length_156_cov_2.445378_g179016_i0	PRJNA725806	179318	156	2.445378	3.81478968	uncultured cyanobacterium	1211	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|129563743\|gb\|EF438215.1\|	1211	g179016	i0	100	105.910256410256	156	0	100	0	1	156	39	194	Uncultured cyanobacterium clone G1-1_9 16S ribosomal RNA gene, partial sequence	blastn	16522	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22389274	22389274	PRJNA725806_P_NODE_179898_length_156_cov_1.537815_g179596_i0	PRJNA725806	179898	156	1.537815	2.3989914	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	244	1.9799999999999998e-60	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g179596	i0	94.872	144.467948717949	156	8	100	0	1	156	2380	2535	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	22537	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23664884	23664884	PRJNA725806_P_NODE_27039_length_294_cov_8.770428_g26742_i0	PRJNA725806	27039	294	8.770428	25.78505832	uncultured Hormoscilla sp.	1007660	Bacteria	Bacteria	63.9	1.26e-5	NTclustered	gi\|2751213477\|emb\|OZ001294.2\|	1007660	g26742	i0	100	0.115646258503401	34	0	12	0	219	252	3388533	3388566	MAG: uncultured Hormoscilla sp. isolate 8e647e88-4706-4a17-b8b9-b52c092b67df genome assembly, chromosome: 2	blastn	34	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	uncultured Hormoscilla sp.
24938383	24938383	PRJNA725806_P_NODE_43500_length_259_cov_3.216216_g43203_i0	PRJNA725806	43500	259	3.216216	8.32999944	Moorena producens	1155739	Bacteria	Bacteria	58.4	5.07e-4	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g43203	i0	100	0.335907335907336	31	0	12	0	123	153	8405168	8405138	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	87	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
24938390	24938390	PRJNA725806_P_NODE_4800_length_446_cov_3.163814_g4524_i0	PRJNA725806	4800	446	3.163814	14.11061044	cyanobacterium CBW1115	1353153	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|519682872\|gb\|KC513917.1\|	1353153	g4524	i0	100	0.0672645739910314	30	0	7	0	106	135	272	301	Cyanobacterium CBW1115 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium CBW1115
25420936	25420936	PRJNA725806_P_NODE_145480_length_171_cov_1.432836_g145178_i0	PRJNA725806	145480	171	1.432836	2.45014956	Microcystis	1125	Bacteria	Bacteria	217	4.8e-52	NTclustered	gi\|1861038497\|dbj\|LC557444.1\|	1126	g145178	i0	89.474	134.777777777778	171	18	100	0	1	171	259	89	Microcystis aeruginosa NIES-1356 gene for 23S rRNA, partial sequence	blastn	23047	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
25421049	25421049	PRJNA725806_P_NODE_43960_length_258_cov_4.882353_g43663_i0	PRJNA725806	43960	258	4.882353	12.596470740000001	Oscillatoriales	1150	Bacteria	Bacteria	436	5.549999999999999e-118	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g43663	i0	98.394	145.298449612403	249	2	96	2	11	258	1442	1195	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	37487	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride

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