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

17 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
1241897	1241897	PRJNA888821_P_NODE_38501_length_243_cov_0.905882_g38418_i0	PRJNA888821	38501	243	0.905882	2.20129326	Nostocaceae	1162	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g38418	i0	100	293.452674897119	243	0	100	0	1	243	402	644	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	71309	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
3413722	3413722	PRJNA888821_P_NODE_3803_length_363_cov_11.082759_g3722_i0	PRJNA888821	3803	363	11.082759	40.23041517	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	448	3.759999999999999e-121	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3722	i0	89.041	105.407713498623	365	35	100	3	1	363	2151596	2151957	Leptolyngbya sp. 7M chromosome	blastn	38263	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
6345825	6345825	PRJNA888821_P_NODE_29125_length_274_cov_1.009950_g29043_i0	PRJNA888821	29125	274	1.00995	2.767263	Nostoc	1177	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1468550239\|emb\|LS992499.1\|	1178	g29043	i0	100	100	274	0	100	0	1	274	74	347	Nostoc commune partial 16S rRNA gene, strain S23	blastn	27400	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
8515483	8515483	PRJNA888821_P_NODE_16007_length_310_cov_5.822785_g15925_i0	PRJNA888821	16007	310	5.822785	18.0506335	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	209	1.62e-49	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15925	i0	91.946	0.480645161290323	149	12	48	0	1	149	2707879	2708027	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	149	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8894494	8894494	PRJNA888821_P_NODE_15347_length_310_cov_6.286920_g15265_i0	PRJNA888821	15347	310	6.28692	19.489452	Synechococcus	1129	Bacteria	Bacteria	150	9.98e-32	NTclustered	gi\|1940477070\|gb\|CP060398.1\|	1353134	g15265	i0	86.525	1.70322580645161	141	13	45	5	173	310	1781223	1781360	Synechococcus sp. CBW1002 chromosome, complete genome	blastn	528	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1002
12341872	12341872	PRJNA888821_P_NODE_26310_length_286_cov_15.352113_g26228_i0	PRJNA888821	26310	286	15.352113	43.90704318	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	457	4.79e-124	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g26228	i0	95.455	129.636363636364	286	13	100	0	1	286	3682378	3682663	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	37076	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12341922	12341922	PRJNA888821_P_NODE_28890_length_275_cov_1.009901_g28808_i0	PRJNA888821	28890	275	1.009901	2.77722775	Macrochaete psychrophila	1844959	Bacteria	Bacteria	448	2.7599999999999995e-121	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g28808	i0	96.992	272.68	266	8	97	0	2	267	2107	2372	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	74987	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
12342048	12342048	PRJNA888821_P_NODE_36290_length_247_cov_12.086207_g36207_i0	PRJNA888821	36290	247	12.086207	29.85293129	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	433	6.82e-117	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g36207	i0	98.374	134.153846153846	246	4	99	0	2	247	3680435	3680680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	33136	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13616901	13616901	PRJNA888821_P_NODE_611_length_650_cov_2.305026_g543_i0	PRJNA888821	611	650	2.305026	14.982669	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	896	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g543	i0	93.543	97.0538461538462	604	36	93	3	49	650	1614	2216	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	63085	896	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14890525	14890525	PRJNA888821_P_NODE_15012_length_310_cov_6.535865_g14930_i0	PRJNA888821	15012	310	6.535865	20.2611815	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	124	6.049999999999999e-24	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14930	i0	82.119	0.487096774193548	151	21	48	4	1	148	2256335	2256482	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	151	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
18714109	18714109	PRJNA888821_P_NODE_2635_length_407_cov_13.979042_g2556_i0	PRJNA888821	2635	407	13.979042	56.89470094	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	414	4.32e-111	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2556	i0	96.787	106.117936117936	249	6	98	2	1	247	3682108	3681860	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	43190	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
19989139	19989139	PRJNA888821_P_NODE_13096_length_310_cov_8.004219_g13014_i0	PRJNA888821	13096	310	8.004219	24.8130789	Rivularia sp. PCC 7116	373994	Bacteria	Bacteria	169	2.7599999999999997e-37	NTclustered	gi\|427368660\|gb\|CP003549.1\|	373994	g13014	i0	75.949	3.0258064516129	316	62	100	8	1	310	2029607	2029914	Rivularia sp. PCC 7116, complete genome	blastn	938	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. PCC 7116
19989216	19989216	PRJNA888821_P_NODE_17696_length_310_cov_4.641350_g17614_i0	PRJNA888821	17696	310	4.64135	14.388185	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	272	2.04e-68	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g17614	i0	99.333	149.187096774194	150	1	97	0	161	310	2472	2621	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46248	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19989595	19989595	PRJNA888821_P_NODE_39416_length_241_cov_0.916667_g39333_i0	PRJNA888821	39416	241	0.916667	2.20916747	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	394	3.13e-105	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g39333	i0	96.639	220.286307053942	238	7	99	1	4	241	1857892	1857656	Calothrix sp. PCC 7716 DNA, complete genome	blastn	53089	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
22539504	22539504	PRJNA888821_P_NODE_23838_length_298_cov_8.520000_g23756_i0	PRJNA888821	23838	298	8.52	25.3896	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	8.47e-117	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g23756	i0	93.471	152.503355704698	291	19	98	0	1	291	1646	1936	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	45446	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22539762	22539762	PRJNA888821_P_NODE_38998_length_241_cov_20.369048_g38915_i0	PRJNA888821	38998	241	20.369048	49.08940568	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g38915	i0	97.925	96.9045643153527	241	5	100	0	1	241	3680917	3681157	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23354	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23815400	23815400	PRJNA888821_P_NODE_579_length_663_cov_5.632203_g512_i0	PRJNA888821	579	663	5.632203	37.34150589	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1035	0	NTclustered	gi\|225696221\|gb\|FJ805888.1\|	259957	g512	i0	94.872	130.21568627451	663	32	100	2	1	663	2230	2890	Uncultured Chroococcidiopsis sp. clone NA2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	86333	1035	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);;