metadata: contig_metadata: 6 rows where bioproject = "PRJNA683669", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

6 rows where bioproject = "PRJNA683669", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_order	tax_species
21067359	21067359	PRJNA683669_P_NODE_16137_length_323_cov_0.924000_g15906_i0	PRJNA683669	16137	323	0.924	2.98452	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	78.7	5e-10	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15906	i0	83.908	0.634674922600619	87	8	27	3	121	207	3851390	3851310	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	205	78.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
27366917	27366917	PRJNA683669_P_NODE_34203_length_241_cov_0.916667_g33971_i0	PRJNA683669	34203	241	0.916667	2.20916747	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	75.5	1.09e-13	NR	HIA55216.1	2052166	g33971	i0	90	0.622406639004149	50	5	62.2	0	150	1	220	269	HIA55216.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	150	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
27694303	27694303	PRJNA683669_P_NODE_29124_length_247_cov_0.885057_g28892_i0	PRJNA683669	29124	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	91.3	3.26e-19	NR	MBX9567960.1	2364082	g28892	i0	54.1	4.73684210526316	74	34	89.9	0	238	17	192	265	MBX9567960.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium]	diamond	1170	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
27935060	27935060	PRJNA683669_P_NODE_26145_length_251_cov_0.865169_g25913_i0	PRJNA683669	26145	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	178	1.74e-51	NR	MBX9950078.1	2364082	g25913	i0	100	1.9840637450199201	83	0	99.2	0	249	1	418	500	MBX9950078.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Obscuribacterales bacterium]	diamond	498	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
30714023	30714023	PRJNA683669_P_NODE_29434_length_247_cov_0.885057_g29202_i0	PRJNA683669	29434	247	0.885057	2.18609079	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	160	7.46e-46	NR	PZM82533.1	2052166	g29202	i0	100	0.995951417004049	82	0	99.6	0	1	246	125	206	PZM82533.1 MAG: hypothetical protein DKT66_11080 [Candidatus Melainabacteria bacterium]	diamond	246	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32390112	32390112	PRJNA683669_P_NODE_31099_length_245_cov_0.895349_g30867_i0	PRJNA683669	31099	245	0.895349	2.19360505	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	68.2	3.13e-11	NR	PZM82581.1	2052166	g30867	i0	86.5	0.453061224489796	37	5	45.3	0	2	112	291	327	PZM82581.1 MAG: hypothetical protein DKT66_11330 [Candidatus Melainabacteria bacterium]	diamond	111	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium

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