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

5 rows where analysis = "blastn", bioproject = "PRJNA613025" 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
8244894	8244894	PRJNA613025_S_NODE_24587_length_190_cov_3.425532_g24433_i0	PRJNA613025	24587	190	3.425532	6.5085108	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	272	1.15e-68	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g24433	i0	92.593	85.1052631578947	189	14	99	0	2	190	3680916	3681104	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	16170	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14620567	14620567	PRJNA613025_S_NODE_15252_length_275_cov_1.814159_g15098_i0	PRJNA613025	15252	275	1.814159	4.98893725	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	318	2.2599999999999992e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15098	i0	87.636	150.727272727273	275	33	100	1	1	275	3679731	3680004	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	41450	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14620677	14620677	PRJNA613025_S_NODE_19612_length_223_cov_1.908046_g19458_i0	PRJNA613025	19612	223	1.908046	4.25494258	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	8.17e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g19458	i0	93.274	101.52466367713	223	15	100	0	1	223	3680416	3680194	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	22640	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20275227	20275227	PRJNA613025_S_NODE_20436_length_216_cov_2.377246_g20282_i0	PRJNA613025	20436	216	2.377246	5.13485136	Chroococcidiopsis	54298	Bacteria	Bacteria	204	4.9699999999999994e-48	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g20282	i0	83.945	446.74537037037	218	29	100	6	1	216	3133	2920	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	96497	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
22269022	22269022	PRJNA613025_S_NODE_26838_length_179_cov_9.723077_g26684_i0	PRJNA613025	26838	179	9.723077	17.40430783	Dolichospermum macrosporum	135103	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|13516977\|dbj\|AB047103.1\|	135103	g26684	i0	97.765	101.027932960894	179	4	100	0	1	179	839	661	Anabaena macrospora gene for 16S rRNA, partial sequence	blastn	18084	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum macrosporum

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