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

6 rows where analysis = "blastn", bioproject = "PRJNA1047321" 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
1449128	1449128	PRJNA1047321_P_NODE_6722_length_250_cov_0.870056_g6551_i0	PRJNA1047321	6722	250	0.870056	2.17514	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	375	1.18e-99	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g6551	i0	93.976	0.996	249	14	99	1	2	250	1151413	1151166	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	249	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8663003	8663003	PRJNA1047321_P_NODE_2527_length_418_cov_1.315942_g2358_i0	PRJNA1047321	2527	418	1.315942	5.50063756	Hassallia	482629	Bacteria	Bacteria	761	0	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g2358	i0	99.522	309.291866028708	418	2	100	0	1	418	2429	2012	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	129284	761	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
10377684	10377684	PRJNA1047321_P_NODE_4969_length_285_cov_2.462264_g4798_i0	PRJNA1047321	4969	285	2.462264	7.0174524	Anabaena cylindrica	1165	Bacteria	Bacteria	490	4.71e-134	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g4798	i0	97.887	305.582456140351	284	5	99	1	2	285	6054723	6055005	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	87091	490	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
15477159	15477159	PRJNA1047321_P_NODE_1613_length_545_cov_1.127119_g1446_i0	PRJNA1047321	1613	545	1.127119	6.14279855	Oculatella lusitanica	2928764	Bacteria	Bacteria	813	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g1446	i0	93.59	165.433027522936	546	34	100	1	1	545	3187	2642	Oculatella lusitanica LEGE 161147 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	90161	813	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
19300207	19300207	PRJNA1047321_P_NODE_6636_length_250_cov_0.870056_g6465_i0	PRJNA1047321	6636	250	0.870056	2.17514	Nostoc sphaeroides	446679	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|1770427826\|gb\|CP045227.1\|	2653204	g6465	i0	97.2	7.756	250	7	100	0	1	250	262615	262366	Nostoc sphaeroides CCNUC1 chromosome Gxm2, complete sequence	blastn	1939	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
24400460	24400460	PRJNA1047321_P_NODE_4360_length_307_cov_2.081197_g4190_i0	PRJNA1047321	4360	307	2.081197	6.38927479	Nostoc edaphicum	264686	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g4190	i0	100	158.980456026059	307	0	100	0	1	307	1355621	1355927	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	48807	568	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum

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