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

14 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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
193929	193929	PRJNA1086823_P_NODE_7941_length_293_cov_2.590909_g7824_i0	PRJNA1086823	7941	293	2.590909	7.59136337	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	440	4.959999999999998e-119	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g7824	i0	94.138	120.894197952218	290	15	99	2	4	292	1921	1633	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	35422	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1468563	1468563	PRJNA1086823_P_NODE_8062_length_292_cov_1.292237_g7945_i0	PRJNA1086823	8062	292	1.292237	3.77333204	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	418	2.3199999999999996e-112	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g7945	i0	92.466	113.900684931507	292	22	100	0	1	292	3117	2826	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	33259	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2744626	2744626	PRJNA1086823_P_NODE_7163_length_307_cov_2.205128_g7046_i0	PRJNA1086823	7163	307	2.205128	6.76974296	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	510	3.93e-140	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g7046	i0	96.743	272.882736156352	307	9	100	1	1	307	1858982	1858677	Calothrix sp. PCC 7716 DNA, complete genome	blastn	83775	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
4020422	4020422	PRJNA1086823_P_NODE_2524_length_479_cov_2.352217_g2407_i0	PRJNA1086823	2524	479	2.352217	11.26711943	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	494	6.45e-135	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2407	i0	85.391	125.826722338205	486	59	100	12	1	479	3682000	3682480	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	60271	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
5296632	5296632	PRJNA1086823_P_NODE_4105_length_385_cov_3.160256_g3988_i0	PRJNA1086823	4105	385	3.160256	12.1669856	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	544	4.969999999999998e-150	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g3988	i0	92.408	106.6	382	27	99	2	6	385	1640	2021	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	41041	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6571821	6571821	PRJNA1086823_P_NODE_8106_length_291_cov_2.064220_g7989_i0	PRJNA1086823	8106	291	2.06422	6.0068802	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	508	1.33e-139	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g7989	i0	98.282	283.347079037801	291	4	100	1	1	291	1857505	1857794	Calothrix sp. PCC 7716 DNA, complete genome	blastn	82454	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9121283	9121283	PRJNA1086823_P_NODE_1168_length_698_cov_14.227200_g10_i7	PRJNA1086823	1168	698	14.2272	99.305856	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	1155	0	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g10	i7	96.571	119.163323782235	700	18	100	4	1	698	1157	462	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	83176	1155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
11220803	11220803	PRJNA1086823_P_NODE_16929_length_245_cov_1.261628_g16812_i0	PRJNA1086823	16929	245	1.261628	3.0909886	Oscillatoriales	1150	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g16812	i0	98.367	140.240816326531	245	4	100	0	1	245	921	1165	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	34359	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
11220827	11220827	PRJNA1086823_P_NODE_5349_length_346_cov_1.142857_g5232_i0	PRJNA1086823	5349	346	1.142857	3.95428522	Synechococcales	1890424	Bacteria	Bacteria	86.1	3.23e-12	NTclustered	gi\|78196017\|gb\|CP000110.1\|	110662	g5232	i0	89.706	17.6416184971098	68	5	19	2	116	181	2191224	2191291	Synechococcus sp. CC9605, complete genome	blastn	6104	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CC9605
13770753	13770753	PRJNA1086823_P_NODE_2631_length_470_cov_1.659950_g2514_i0	PRJNA1086823	2631	470	1.65995	7.801765	Chroococcidiopsis	54298	Bacteria	Bacteria	680	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g2514	i0	92.781	205.814893617021	471	33	100	1	1	470	14	484	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	96733	680	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
20143772	20143772	PRJNA1086823_P_NODE_2556_length_476_cov_2.181141_g2439_i0	PRJNA1086823	2556	476	2.181141	10.38223116	Oscillatoriales	1150	Bacteria	Bacteria	830	0	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g2439	i0	98.113	152.163865546218	477	8	100	1	1	476	103585	103109	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	72430	830	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
20594905	20594905	PRJNA1086823_P_NODE_2997_length_441_cov_1.820652_g2880_i0	PRJNA1086823	2997	441	1.820652	8.02907532	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	320	1.06e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2880	i0	80.556	116.142857142857	432	70	96	13	1	422	3681543	3681116	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	51219	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
24419700	24419700	PRJNA1086823_P_NODE_400_length_1145_cov_13.415112_g10_i6	PRJNA1086823	400	1145	13.415112	153.6030324	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1916	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g10	i6	96.859	100.342358078603	1146	34	100	2	1	1145	1576	2720	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	114892	1916	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25243756	25243756	PRJNA1086823_P_NODE_5500_length_342_cov_1.185874_g5383_i0	PRJNA1086823	5500	342	1.185874	4.05568908	Chroococcidiopsis	54298	Bacteria	Bacteria	568	2.6e-157	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g5383	i0	96.512	114.286549707602	344	10	100	2	1	342	4312	3969	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	39086	571	0.994746059544658	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025

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