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

26 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
776885	776885	PRJNA792582_P_NODE_35081_length_291_cov_0.880734_g34267_i0	PRJNA792582	35081	291	0.880734	2.56293594	uncultured Calothrix sp.	332972	Bacteria	Bacteria	313	1.12e-80	NTclustered	gi\|745734102\|gb\|KM458389.1\|	332972	g34267	i0	99.419	117.137457044674	172	1	59	0	120	291	163	334	Uncultured Calothrix sp. isolate OTU 00139 23S ribosomal RNA gene, partial sequence	blastn	34087	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	uncultured Calothrix sp.
2052782	2052782	PRJNA792582_P_NODE_25362_length_343_cov_1.666667_g24548_i0	PRJNA792582	25362	343	1.666667	5.71666781	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	9.909999999999998e-117	NTclustered	gi\|225696253\|gb\|FJ805920.1\|	259957	g24548	i0	89.535	161.501457725948	344	33	100	3	1	343	2884	3225	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	55395	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4605260	4605260	PRJNA792582_P_NODE_32824_length_301_cov_1.649123_g32010_i0	PRJNA792582	32824	301	1.649123	4.96386023	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.15e-114	NTclustered	gi\|225696212\|gb\|FJ805879.1\|	259957	g32010	i0	92.053	149.820598006645	302	23	100	1	1	301	1628	1929	Uncultured Chroococcidiopsis sp. clone A3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45096	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5043682	5043682	PRJNA792582_P_NODE_4684_length_758_cov_6.392701_g3979_i0	PRJNA792582	4684	758	6.392701	48.45667358	Chroococcidiopsis	54298	Bacteria	Bacteria	881	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g3979	i0	87.875	157.48944591029	767	72	100	17	1	758	794891	795645	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	119377	887	0.993235625704622	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5880229	5880229	PRJNA792582_P_NODE_13485_length_466_cov_1.534351_g12673_i0	PRJNA792582	13485	466	1.534351	7.15007566	Chroococcidiopsis sp. SAG 2025	171389	Bacteria	Bacteria	730	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g12673	i0	94.872	153.568669527897	468	22	100	2	1	466	1956	2423	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	71563	730	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
7155240	7155240	PRJNA792582_P_NODE_25286_length_343_cov_4.644444_g24472_i0	PRJNA792582	25286	343	4.644444	15.93044292	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	473	5.839999999999999e-129	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g24472	i0	91.57	114.521865889213	344	28	100	1	1	343	2865	3208	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	39281	473	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7593429	7593429	PRJNA792582_P_NODE_29146_length_320_cov_0.914980_g28332_i0	PRJNA792582	29146	320	0.91498	2.927936	Chroococcidiopsis	54298	Bacteria	Bacteria	558	1.45e-154	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g28332	i0	98.125	72.259375	320	6	100	0	1	320	4858100	4857781	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	23123	558	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
7593741	7593741	PRJNA792582_P_NODE_59426_length_241_cov_0.916667_g58612_i0	PRJNA792582	59426	241	0.916667	2.20916747	Fischerella	1190	Bacteria	Bacteria	291	4.22e-74	NTclustered	gi\|2314726996\|dbj\|AP024677.1\|	1191	g58612	i0	88.477	230.871369294606	243	24	100	4	1	241	290050	289810	MAG: Fischerella sp. KatS3mg066 DNA, complete genome	blastn	55640	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
8430307	8430307	PRJNA792582_P_NODE_54727_length_246_cov_0.890173_g53913_i0	PRJNA792582	54727	246	0.890173	2.18982558	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	315	2.57e-81	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g53913	i0	90.377	2.91463414634146	239	23	97	0	8	246	1679215	1679453	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	717	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
8430389	8430389	PRJNA792582_P_NODE_7227_length_622_cov_6.112933_g6441_i0	PRJNA792582	7227	622	6.112933	38.02244326	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	715	0	NTclustered	gi\|225696217\|gb\|FJ805884.1\|	259957	g6441	i0	89.912	160.382636655949	565	43	90	12	1	558	2112	1555	Uncultured Chroococcidiopsis sp. clone NA4_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	99758	715	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8868349	8868349	PRJNA792582_P_NODE_11907_length_494_cov_4.230404_g11096_i0	PRJNA792582	11907	494	4.230404	20.89819576	Cyanophyceae	3028117	Bacteria	Bacteria	695	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g11096	i0	92.105	153.097165991903	494	37	99	2	2	494	2377751	2378243	Nostoc sp. PCC 7120 DNA, complete genome	blastn	75630	697	0.997130559540889	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
9705067	9705067	PRJNA792582_P_NODE_12348_length_485_cov_2.813107_g11536_i0	PRJNA792582	12348	485	2.813107	13.64356895	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	654	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g11536	i0	91.152	118.352577319588	486	37	99	6	3	484	2128	1645	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	57401	654	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10980941	10980941	PRJNA792582_P_NODE_38849_length_281_cov_1.120192_g38035_i0	PRJNA792582	38849	281	1.120192	3.14773952	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	340	4.939999999999999e-89	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g38035	i0	89.091	185.017793594306	275	29	98	1	7	280	1910	1636	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	51990	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12256369	12256369	PRJNA792582_P_NODE_18570_length_399_cov_2.254601_g17756_i0	PRJNA792582	18570	399	2.254601	8.99585799	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	390	7.13e-104	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g17756	i0	84.653	861.458646616541	404	49	100	12	1	399	3561	3166	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	343722	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
12695031	12695031	PRJNA792582_P_NODE_37190_length_285_cov_1.452830_g36376_i0	PRJNA792582	37190	285	1.45283	4.1405655	Oculatella	1240886	Bacteria	Bacteria	396	1.06e-105	NTclustered	gi\|1300933890\|gb\|MG652620.1\|	1963209	g36376	i0	91.93	221.712280701754	285	19	99	4	1	283	2161	2443	Oculatella ucrainica KZ-5-4-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	63188	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella ucrainica
14805347	14805347	PRJNA792582_P_NODE_14212_length_455_cov_2.693717_g13399_i0	PRJNA792582	14212	455	2.693717	12.25641235	Calothrix parietina	32054	Bacteria	Bacteria	710	0	NTclustered	gi\|1345606777\|gb\|MG968511.1\|	2081933	g13399	i0	94.934	258.03956043956	454	20	99	3	1	452	212	664	Calothrix parietina UTEX LB 1952 23S ribosomal RNA gene, partial sequence	blastn	117408	710	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina
16518254	16518254	PRJNA792582_P_NODE_30373_length_313_cov_1.133333_g29559_i0	PRJNA792582	30373	313	1.133333	3.54733229	Synechococcus	1129	Bacteria	Bacteria	394	4.22e-105	NTclustered	gi\|2675671200\|gb\|CP143862.1\|	3115658	g29559	i0	89.524	151.431309904153	315	28	100	5	1	313	1796589	1796278	Synechococcus elongatus IITB8 chromosome, complete genome	blastn	47398	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
16518431	16518431	PRJNA792582_P_NODE_48373_length_254_cov_2.232044_g47559_i0	PRJNA792582	48373	254	2.232044	5.66939176	Nodularia	159191	Bacteria	Bacteria	291	4.489999999999999e-74	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g47559	i0	88.259	87.4330708661417	247	24	97	4	1	246	5025906	5025664	Nodularia spumigena CCY9414 genome	blastn	22208	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
18628764	18628764	PRJNA792582_P_NODE_56515_length_244_cov_0.900585_g55701_i0	PRJNA792582	56515	244	0.900585	2.1974274	Spirirestis rafaelensis	293980	Bacteria	Bacteria	307	4.25e-79	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g55701	i0	90	187.446721311475	240	21	98	3	6	244	671	434	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	45737	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
20341965	20341965	PRJNA792582_P_NODE_50476_length_250_cov_1.694915_g49662_i0	PRJNA792582	50476	250	1.694915	4.2372875	Nostocales	1161	Bacteria	Bacteria	324	4.35e-84	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g49662	i0	90.079	280.532	252	22	100	3	1	250	1245410	1245160	Halotia branconii CENA392 chromosome, complete genome	blastn	70133	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
21179399	21179399	PRJNA792582_P_NODE_3357_length_885_cov_7.495074_g2732_i0	PRJNA792582	3357	885	7.495074	66.3314049	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1389	0	NTclustered	gi\|225696264\|gb\|FJ805931.1\|	259957	g2732	i0	95.034	133.918644067797	886	40	100	3	1	885	2044	2926	Uncultured Chroococcidiopsis sp. clone NA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	118518	1389	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21617523	21617523	PRJNA792582_P_NODE_34757_length_292_cov_1.406393_g33943_i0	PRJNA792582	34757	292	1.406393	4.10666756	Cyanophyceae	3028117	Bacteria	Bacteria	344	3.9899999999999985e-90	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g33943	i0	88.693	128.558219178082	283	31	97	1	5	287	1656	1937	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37539	346	0.994219653179191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22454020	22454020	PRJNA792582_P_NODE_10918_length_515_cov_4.237557_g10109_i0	PRJNA792582	10918	515	4.237557	21.82341855	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	754	0	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g10109	i0	93.517	165.506796116505	509	30	98	3	9	515	2161	1654	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	85236	754	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22454137	22454137	PRJNA792582_P_NODE_26358_length_336_cov_2.326996_g25544_i0	PRJNA792582	26358	336	2.326996	7.81870656	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	514	3.36e-141	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g25544	i0	94.345	312.85119047619	336	18	100	1	1	336	1858849	1859183	Calothrix sp. PCC 7716 DNA, complete genome	blastn	105118	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
23729662	23729662	PRJNA792582_P_NODE_12299_length_486_cov_4.145278_g11487_i0	PRJNA792582	12299	486	4.145278	20.14605108	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	673	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g11487	i0	91.77	152.923868312757	486	36	99	4	1	484	1631	2114	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	74321	673	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23729672	23729672	PRJNA792582_P_NODE_1399_length_1307_cov_8.487034_g1013_i0	PRJNA792582	1399	1307	8.487034	110.92553438	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1877	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g1013	i0	92.624	105.377964804897	1315	81	99	13	1	1305	2942	1634	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	137729	1877	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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