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

6 rows where bioproject = "PRJNA753704", 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
7109645	7109645	PRJNA753704_P_NODE_11386_length_351_cov_1.122302_g11025_i0	PRJNA753704	11386	351	1.122302	3.93928002	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	353	8.12e-93	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11025	i0	85.714	0.977207977207977	343	39	97	8	1	339	2647202	2647538	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	343	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
8384446	8384446	PRJNA753704_P_NODE_30967_length_208_cov_4.881481_g30606_i0	PRJNA753704	30967	208	4.881481	10.15348048	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	340	3.4699999999999996e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g30606	i0	96.154	2.03365384615385	208	8	100	0	1	208	3682437	3682230	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	423	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
8384452	8384452	PRJNA753704_P_NODE_327_length_1751_cov_25.941001_g212_i0	PRJNA753704	327	1751	25.941001	454.22692751	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1873	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g212	i0	86.11	146.216447744146	1771	209	100	35	1	1751	3682673	3680920	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	256025	1873	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
8384455	8384455	PRJNA753704_P_NODE_347_length_1691_cov_22.076638_g212_i1	PRJNA753704	347	1691	22.076638	373.31594858	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1831	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g212	i1	86.276	145.948551153164	1705	210	100	21	1	1691	3680979	3682673	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	246799	1831	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
9659663	9659663	PRJNA753704_P_NODE_4488_length_533_cov_2.636957_g4129_i0	PRJNA753704	4488	533	2.636957	14.05498081	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	316	3.89e-108	NR	MBX9724270.1	2364082	g4129	i0	91.1	0.945590994371482	168	15	94.6	0	8	511	3	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	504	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
27369308	27369308	PRJNA753704_P_NODE_17423_length_289_cov_1.300926_g17062_i0	PRJNA753704	17423	289	1.300926	3.75967614	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	135	6.31e-38	NR	MBX9674352.1	2364082	g17062	i0	100	0.695501730103806	67	0	69.6	0	201	1	1	67	MBX9674352.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	201	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales 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);;