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

13 rows where analysis = "blastn", bioproject = "PRJNA797475" 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
2057267	2057267	PRJNA797475_P_NODE_22562_length_250_cov_0.870056_g22463_i0	PRJNA797475	22562	250	0.870056	2.17514	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22463	i0	95.547	138.828	247	11	99	0	4	250	3679982	3679736	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	34707	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
2492372	2492372	PRJNA797475_P_NODE_2302_length_641_cov_2.125000_g2204_i0	PRJNA797475	2302	641	2.125	13.62125	root	1	Root_unresolved	Root_unresolved	1177	0	NTclustered	gi\|47594\|emb\|X53842.1\|	1148	g2204	i0	99.844	104.630265210608	641	0	100	1	1	641	263	902	Synechocystis sp. ndhE gene (partial), psaC gene for photosystem I iron-sulfur protein and ndhD-like ORF	blastn	67068	1184	0.994087837837838	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
3768650	3768650	PRJNA797475_P_NODE_21823_length_251_cov_0.865169_g21724_i0	PRJNA797475	21823	251	0.865169	2.17157419	Oscillatoriales	1150	Bacteria	Bacteria	324	4.37e-84	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g21724	i0	90	5.97609561752988	250	25	99	0	1	250	938738	938987	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1500	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
7159896	7159896	PRJNA797475_P_NODE_3206_length_546_cov_0.902748_g3108_i0	PRJNA797475	3206	546	0.902748	4.92900408	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	924	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g3108	i0	97.248	313.677655677656	545	15	99	0	2	546	1858739	1859283	Calothrix sp. PCC 7716 DNA, complete genome	blastn	171268	924	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9709683	9709683	PRJNA797475_P_NODE_24388_length_248_cov_0.880000_g24289_i0	PRJNA797475	24388	248	0.88	2.1824	Leptolyngbya sp. LEGE 18517	3132512	Bacteria	Bacteria	440	4.0999999999999997e-119	NTclustered	gi\|2697880845\|gb\|PP476846.1\|	3132512	g24289	i0	98.785	107.661290322581	247	3	99	0	1	247	469	715	Leptolyngbya sp. LEGE 18517 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	26700	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. LEGE 18517
10985360	10985360	PRJNA797475_P_NODE_19929_length_258_cov_1.308108_g19830_i0	PRJNA797475	19929	258	1.308108	3.37491864	Spirirestis rafaelensis	293980	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g19830	i0	99.225	167.693798449612	258	2	100	0	1	258	520	777	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	43265	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
10985375	10985375	PRJNA797475_P_NODE_21029_length_252_cov_1.720670_g20930_i0	PRJNA797475	21029	252	1.72067	4.3360884	Nostoc sp. C117	3349875	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g20930	i0	90.909	24.0952380952381	187	16	74	1	2	188	6456313	6456498	Nostoc sp. C117 chromosome, complete genome	blastn	6072	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
12261044	12261044	PRJNA797475_P_NODE_750_length_1061_cov_4.505061_g684_i0	PRJNA797475	750	1061	4.505061	47.79869721	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1125	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g684	i0	85.968	94.3053722902922	1069	130	99	19	4	1059	3682661	3681600	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	100058	1125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13534948	13534948	PRJNA797475_P_NODE_10231_length_328_cov_2.949020_g10132_i0	PRJNA797475	10231	328	2.94902	9.6727856	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	207	6.22e-49	NTclustered	gi\|2557660174\|gb\|OR395668.1\|	2053573	g10132	i0	79.605	71.8384146341463	304	50	91	11	4	302	1496	1200	Candidatus Margulisiibacteriota bacterium clone Gx481_unbinned&&k119_1959521 16S ribosomal RNA gene, partial sequence	blastn	23563	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
16084059	16084059	PRJNA797475_P_NODE_30853_length_233_cov_2.656250_g30754_i0	PRJNA797475	30853	233	2.65625	6.1890625	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	313	8.66e-81	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g30754	i0	91.342	114.188841201717	231	16	98	3	5	233	3669365	3669593	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	26606	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20343433	20343433	PRJNA797475_P_NODE_9516_length_338_cov_1.845283_g9417_i0	PRJNA797475	9516	338	1.845283	6.23705654	Chroococcidiopsis	54298	Bacteria	Bacteria	553	7.179999999999998e-153	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g9417	i0	96.165	129.023668639053	339	12	100	1	1	338	794982	794644	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	43610	558	0.991039426523297	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
23734102	23734102	PRJNA797475_P_NODE_14099_length_288_cov_2.055814_g14000_i0	PRJNA797475	14099	288	2.055814	5.92074432	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	228	4.119999999999999e-55	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g14000	i0	92.453	279.71875	159	12	55	0	129	287	597324	597482	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	80559	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23734296	23734296	PRJNA797475_P_NODE_29719_length_241_cov_2.654762_g29620_i0	PRJNA797475	29719	241	2.654762	6.39797642	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g29620	i0	97.934	105.680497925311	242	3	99	2	1	240	3153	3394	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25469	418	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);;