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

19 rows where analysis = "blastn", bioproject = "PRJNA695273" 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
678639	678639	PRJNA695273_P_NODE_64321_length_342_cov_1.159851_g63563_i0	PRJNA695273	64321	342	1.159851	3.96669042	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	610	4.25e-170	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g63563	i0	98.834	182.745614035088	343	3	100	1	1	342	21	363	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	62499	610	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
679228	679228	PRJNA695273_P_NODE_91101_length_289_cov_2.726852_g90343_i0	PRJNA695273	91101	289	2.726852	7.88060228	Halotia branconii	1620816	Bacteria	Bacteria	405	1.78e-108	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g90343	i0	92.042	286.467128027682	289	22	100	1	1	289	1246534	1246247	Halotia branconii CENA392 chromosome, complete genome	blastn	82789	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
1953460	1953460	PRJNA695273_P_NODE_156882_length_242_cov_0.911243_g156124_i0	PRJNA695273	156882	242	0.911243	2.20520806	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	257	4.3e-64	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g156124	i0	86.134	1.26446280991736	238	33	98	0	1	238	1828440	1828203	Nodosilinea sp. E11 chromosome	blastn	306	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
4505162	4505162	PRJNA695273_P_NODE_139644_length_247_cov_0.885057_g138886_i0	PRJNA695273	139644	247	0.885057	2.18609079	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g138886	i0	88.406	5.02429149797571	138	16	56	0	96	233	4144668	4144805	Nodosilinea sp. E11 chromosome	blastn	1241	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
4505919	4505919	PRJNA695273_P_NODE_26684_length_532_cov_4.708061_g25930_i0	PRJNA695273	26684	532	4.708061	25.04688452	uncultured cyanobacterium	1211	Bacteria	Bacteria	795	0	NTclustered	gi\|225696245\|gb\|FJ805912.1\|	1211	g25930	i0	93.645	131.618421052632	535	29	100	4	1	532	2738	2206	Uncultured cyanobacterium clone AN2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	70021	795	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5010657	5010657	PRJNA695273_P_NODE_17444_length_679_cov_1.397690_g16701_i0	PRJNA695273	17444	679	1.39769	9.4903151	Nostocaceae	1162	Bacteria	Bacteria	1194	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g16701	i0	100	6.2179675994109	646	0	95	0	1	646	4275340	4274695	Nostoc sp. PCC 7120 DNA, complete genome	blastn	4222	1194	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
5010692	5010692	PRJNA695273_P_NODE_19884_length_630_cov_1.791741_g19135_i0	PRJNA695273	19884	630	1.791741	11.2879683	Cyanophyceae	3028117	Bacteria	Bacteria	787	0	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g19135	i0	89.308	110.549206349206	636	57	100	9	1	630	2411	3041	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69646	787	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7055256	7055256	PRJNA695273_P_NODE_121926_length_254_cov_2.038674_g121168_i0	PRJNA695273	121926	254	2.038674	5.17823196	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	1.24e-79	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g121168	i0	88.933	224.283464566929	253	24	99	4	4	254	1949	1699	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	56968	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7055355	7055355	PRJNA695273_P_NODE_126006_length_251_cov_0.865169_g125248_i0	PRJNA695273	126006	251	0.865169	2.17157419	Calothrix sp. PCC 7507	99598	Bacteria	Bacteria	165	2.8e-36	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g125248	i0	91.597	9.12350597609562	119	10	47	0	133	251	5972597	5972479	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	2290	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
7561449	7561449	PRJNA695273_P_NODE_95006_length_285_cov_1.452830_g94248_i0	PRJNA695273	95006	285	1.45283	4.1405655	Nostocaceae	1162	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|222354886\|gb\|FJ608815.1\|	103690	g94248	i0	100	88.9087719298246	285	0	100	0	1	285	1287	1003	Nostoc sp. PCC 7120 GroES and GroEL genes, complete cds	blastn	25339	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
8331796	8331796	PRJNA695273_P_NODE_65927_length_338_cov_1.596226_g65169_i0	PRJNA695273	65927	338	1.596226	5.39524388	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	625	1.4999999999999999e-174	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g65169	i0	100	148.905325443787	338	0	100	0	1	338	2283	1946	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	50330	625	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
9606327	9606327	PRJNA695273_P_NODE_28948_length_509_cov_6.252294_g28191_i0	PRJNA695273	28948	509	6.252294	31.82417646	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	719	0	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g28191	i0	92.172	169.033398821218	511	36	100	4	1	509	1245653	1246161	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	86038	719	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
12661301	12661301	PRJNA695273_P_NODE_122850_length_253_cov_1.711111_g122092_i0	PRJNA695273	122850	253	1.711111	4.32911083	Nostoc	1177	Bacteria	Bacteria	374	4.31e-99	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g122092	i0	93.281	2	253	17	100	0	1	253	3071341	3071593	Nostoc sp. NIES-3756 DNA, complete genome	blastn	506	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
18530941	18530941	PRJNA695273_P_NODE_84735_length_300_cov_1.396476_g83977_i0	PRJNA695273	84735	300	1.396476	4.189428	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	396	1.12e-105	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g83977	i0	90.909	136.686666666667	297	24	99	3	1	296	1768	1474	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	41006	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
19803778	19803778	PRJNA695273_P_NODE_131456_length_249_cov_1.625000_g130698_i0	PRJNA695273	131456	249	1.625	4.04625	Nostoc sp. NIES-3756	1751286	Bacteria	Bacteria	302	2.03e-77	NTclustered	gi\|953513865\|dbj\|AP017296.1\|	1751286	g130698	i0	89.787	12.7550200803213	235	24	94	0	1	235	418473	418707	Nostoc sp. NIES-3756 plasmid pNOS3756_1 DNA, complete genome	blastn	3176	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
22353991	22353991	PRJNA695273_P_NODE_120898_length_256_cov_1.234973_g120140_i0	PRJNA695273	120898	256	1.234973	3.16153088	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	379	9.4e-101	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g120140	i0	93.359	2	256	17	100	0	1	256	5027636	5027381	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	512	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
23631691	23631691	PRJNA695273_P_NODE_75779_length_317_cov_1.348361_g75021_i0	PRJNA695273	75779	317	1.348361	4.27430437	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	580	3.0599999999999993e-161	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g75021	i0	99.685	138.867507886435	317	1	100	0	1	317	1449	1133	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	44021	580	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
24133810	24133810	PRJNA695273_P_NODE_13199_length_799_cov_3.853994_g12490_i0	PRJNA695273	13199	799	3.853994	30.79341206	Nostocaceae	1162	Bacteria	Bacteria	1471	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g12490	i0	99.875	41.1852315394243	799	1	100	0	1	799	4274305	4273507	Nostoc sp. PCC 7120 DNA, complete genome	blastn	32907	1471	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
24904844	24904844	PRJNA695273_P_NODE_61320_length_349_cov_5.112319_g60562_i0	PRJNA695273	61320	349	5.112319	17.84199331	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	484	2.7399999999999996e-132	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g60562	i0	91.691	149.722063037249	349	29	100	0	1	349	3275	2927	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	52253	484	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);;