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

9 rows where bioproject = "PRJNA797475", 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_family	tax_genus	tax_species
2057267	2057267	PRJNA797475_P_NODE_22562_length_250_cov_0.870056_g22463_i0	PRJNA797475	22562	250	0.870056	2.17514	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22463	i0	95.547	138.828	247	11	99	0	4	250	3679982	3679736	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	34707	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
12261044	12261044	PRJNA797475_P_NODE_750_length_1061_cov_4.505061_g684_i0	PRJNA797475	750	1061	4.505061	47.79869721	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1125	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g684	i0	85.968	94.3053722902922	1069	130	99	19	4	1059	3682661	3681600	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	100058	1125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
23734102	23734102	PRJNA797475_P_NODE_14099_length_288_cov_2.055814_g14000_i0	PRJNA797475	14099	288	2.055814	5.92074432	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	228	4.119999999999999e-55	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g14000	i0	92.453	279.71875	159	12	55	0	129	287	597324	597482	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	80559	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
26895912	26895912	PRJNA797475_P_NODE_14301_length_287_cov_1.607477_g14202_i0	PRJNA797475	14301	287	1.607477	4.61345899	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	189	4.3e-58	NR	MBK8224185.1	2711154	g14202	i0	98.9	0.993031358885017	95	1	99.3	0	286	2	60	154	MBK8224185.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	285	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
26990361	26990361	PRJNA797475_P_NODE_2242_length_650_cov_1.906412_g2145_i0	PRJNA797475	2242	650	1.906412	12.391678	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	49.7	0.00288	NR	MBI3591571.1	2052166	g2145	i0	43.9	0.304615384615385	66	26	27.7	3	410	231	195	255	MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	198	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
27085580	27085580	PRJNA797475_P_NODE_5262_length_438_cov_1.265753_g5164_i0	PRJNA797475	5262	438	1.265753	5.54399814	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	170	2.49e-49	NR	MBX9722485.1	2364082	g5164	i0	55.5	1	146	64	99.3	1	436	2	81	226	MBX9722485.1 pirin family protein [Candidatus Obscuribacterales bacterium]	diamond	438	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27116895	27116895	PRJNA797475_P_NODE_26542_length_245_cov_0.895349_g26443_i0	PRJNA797475	26542	245	0.895349	2.19360505	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	155	4.64e-45	NR	HIN65143.1	2364082	g26443	i0	98.8	0.991836734693878	81	1	99.2	0	2	244	129	209	HIN65143.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	243	155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31476121	31476121	PRJNA797475_P_NODE_21596_length_251_cov_0.865169_g21497_i0	PRJNA797475	21596	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	58.2	9.17e-8	NR	MBX9950823.1	2364082	g21497	i0	87.5	0.764940239043825	32	4	38.2	0	9	104	212	243	MBX9950823.1 HAD family phosphatase [Candidatus Obscuribacterales bacterium]	diamond	192	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31887132	31887132	PRJNA797475_P_NODE_29377_length_242_cov_0.911243_g29278_i0	PRJNA797475	29377	242	0.911243	2.20520806	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.8	8.76e-20	NR	MBX9685384.1	2364082	g29278	i0	62	0.979338842975207	79	30	97.9	0	1	237	397	475	MBX9685384.1 AAA family ATPase [Candidatus Obscuribacterales bacterium]	diamond	237	92.8	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);;