metadata: contig_metadata: 5 rows where bioproject = "PRJNA432257", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA432257", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Nomuraibacteriota"

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	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_species
13183873	13183873	PRJNA432257_S_NODE_81631_length_191_cov_31.909091_g81250_i0	PRJNA432257	81631	191	31.909091	60.94636381	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	97.1	7.48e-16	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g81250	i0	89.474	1.6282722513089	76	8	40	38	113	344966	344891	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	311	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27518166	27518166	PRJNA432257_S_NODE_12983_length_373_cov_64.523810_g12602_i0	PRJNA432257	12983	373	64.52381	240.6738113	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	104	9.41e-24	NR	MCX6757307.1	2052152	g12602	i0	66.2	0.571045576407507	71	24	57.1	340	128	210	280	MCX6757307.1 cohesin domain-containing protein [Candidatus Nomurabacteria bacterium]	diamond	213	104	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29507249	29507249	PRJNA432257_S_NODE_113770_length_162_cov_2.968000_g113389_i0	PRJNA432257	113770	162	2.968	4.80816	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	95.5	1.94e-21	NR	MEI6810939.1	2052152	g113389	i0	90.6	1.96296296296296	53	5	98.1	2	160	249	301	MEI6810939.1 cysteine desulfurase family protein [Candidatus Nomurabacteria bacterium]	diamond	318	95.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31750839	31750839	PRJNA432257_S_NODE_95417_length_180_cov_1.636364_g95036_i0	PRJNA432257	95417	180	1.636364	2.9454552	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	75.5	4.49e-14	NR	MDB5260513.1	2052152	g95036	i0	79.2	0.883333333333333	53	11	88.3	164	6	202	254	MDB5260513.1 Smc, chromosome segregation ATPase, chromosome segregation protein [Candidatus Nomurabacteria bacterium]	diamond	159	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31877324	31877324	PRJNA432257_S_NODE_56137_length_221_cov_9.831522_g55756_i0	PRJNA432257	56137	221	9.831522	21.72766362	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	57.8	4.49e-9	NR	NVN96890.1	2052152	g55756	i0	77.4	0.420814479638009	31	7	42.1	166	74	6	36	NVN96890.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	93	57.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;