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

4 rows where analysis = "blastn", bioproject = "PRJNA352850" 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
395781	395781	PRJNA352850_P_NODE_44321_length_371_cov_2.161491_g41488_i0	PRJNA352850	44321	371	2.161491	8.01913161	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	652	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g41488	i0	98.383	139.609164420485	371	6	100	0	1	371	1879	2249	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	51795	652	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11874979	11874979	PRJNA352850_P_NODE_65070_length_283_cov_1.555556_g62237_i0	PRJNA352850	65070	283	1.555556	4.40222348	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	235	2.4199999999999997e-57	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g62237	i0	81.69	37.4310954063604	284	50	100	2	1	283	3682661	3682379	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	10593	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13149842	13149842	PRJNA352850_P_NODE_59571_length_301_cov_4.638889_g56738_i0	PRJNA352850	59571	301	4.638889	13.96305589	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	512	1.07e-140	NTclustered	gi\|225696217\|gb\|FJ805884.1\|	259957	g56738	i0	97.351	105.720930232558	302	6	100	2	1	301	1874	1574	Uncultured Chroococcidiopsis sp. clone NA4_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31822	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22072797	22072797	PRJNA352850_P_NODE_62118_length_292_cov_2.255144_g59285_i0	PRJNA352850	62118	292	2.255144	6.58502048	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	427	3.8499999999999997e-115	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g59285	i0	93.127	381.736301369863	291	20	99	0	1	291	2150439	2150729	Leptolyngbya sp. 7M chromosome	blastn	111467	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M

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