metadata: contig_metadata: 10 rows where bioproject = "PRJNA1112809", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA1112809", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"

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_phylum	tax_species
6598977	6598977	PRJNA1112809_P_NODE_48066_length_558_cov_1.760825_g44809_i0	PRJNA1112809	48066	558	1.760825	9.8254035	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	234	1.03e-72	NR	PYN21637.1	2053607	g44809	i0	62.7	2.98387096774194	185	69	99.5	0	556	2	168	352	PYN21637.1 MAG: hypothetical protein DMD76_21475 [Candidatus Rokuibacteriota bacterium]	diamond	1665	234	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
26615750	26615750	PRJNA1112809_P_NODE_115041_length_304_cov_2.069264_g111766_i0	PRJNA1112809	115041	304	2.069264	6.29056256	Bacteria	2	Bacteria	Bacteria	118	4.07e-31	NR	TMQ26733.1	2053607	g111766	i0	57.3	5.97039473684211	103	41	98.7	1	3	302	82	184	TMQ26733.1 MAG: DUF1349 domain-containing protein [Candidatus Rokuibacteriota bacterium]	diamond	1815	118	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
26878315	26878315	PRJNA1112809_P_NODE_169921_length_249_cov_0.875000_g166646_i0	PRJNA1112809	169921	249	0.875	2.17875	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	117	2.24e-31	NR	MBI3455658.1	2053607	g166646	i0	61	1.97590361445783	82	31	98.8	1	247	2	55	135	MBI3455658.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	492	117	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29309915	29309915	PRJNA1112809_P_NODE_149089_length_264_cov_2.015707_g145814_i0	PRJNA1112809	149089	264	2.015707	5.32146648	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	117	9.05e-29	NR	PYO47245.1	2053607	g145814	i0	67.8	2.96590909090909	87	28	98.9	0	2	262	336	422	PYO47245.1 MAG: methyltransferase [Candidatus Rokuibacteriota bacterium]	diamond	783	117	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29373197	29373197	PRJNA1112809_P_NODE_37629_length_681_cov_2.052632_g34444_i0	PRJNA1112809	37629	681	2.052632	13.97842392	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	253	1.58e-81	NR	PYO06327.1	2053607	g34444	i0	87.1	2.16740088105727	163	21	71.8	0	191	679	3	165	PYO06327.1 MAG: oxidoreductase [Candidatus Rokuibacteriota bacterium]	diamond	1476	253	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29806183	29806183	PRJNA1112809_P_NODE_129491_length_285_cov_1.452830_g126216_i0	PRJNA1112809	129491	285	1.45283	4.1405655	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	5.3e-6	NR	PYM47497.1	2053607	g126216	i0	42.7	6.06315789473684	82	46	85.3	1	2	244	68	149	PYM47497.1 MAG: hypothetical protein DME16_12725 [Candidatus Rokuibacteriota bacterium]	diamond	1728	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
30541753	30541753	PRJNA1112809_P_NODE_118133_length_300_cov_1.013216_g114858_i0	PRJNA1112809	118133	300	1.013216	3.039648	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	48.9	5.33e-4	NR	PYM21373.1	2053607	g114858	i0	42.4	0.59	59	33	58	1	291	118	820	878	PYM21373.1 MAG: hypothetical protein DMD78_18235 [Candidatus Rokuibacteriota bacterium]	diamond	177	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
30627574	30627574	PRJNA1112809_P_NODE_54873_length_504_cov_1.851508_g51603_i0	PRJNA1112809	54873	504	1.851508	9.33160032	Pseudomonadati	3379134	Bacteria	Bacteria	153	4.78e-40	NR	MBI3827438.1	2053607	g51603	i0	68.5	1.32738095238095	111	31	65.5	3	503	174	501	608	MBI3827438.1 FAD-binding oxidoreductase [Candidatus Rokuibacteriota bacterium]	diamond	669	154	0.993506493506494	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31449637	31449637	PRJNA1112809_P_NODE_84456_length_369_cov_1.766892_g81181_i0	PRJNA1112809	84456	369	1.766892	6.51983148	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	1.99e-4	NR	OLD78321.1	1805348	g81181	i0	39.5	2.49593495934959	86	47	69.9	1	111	368	4	84	OLD78321.1 MAG: hypothetical protein AUG87_01770 [Candidatus Rokubacteria bacterium 13_1_20CM_4_70_14]	diamond	921	51.2	0.9921875	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokubacteria bacterium 13_1_20CM_4_70_14
31742854	31742854	PRJNA1112809_P_NODE_107117_length_317_cov_2.438525_g103842_i0	PRJNA1112809	107117	317	2.438525	7.73012425	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	60.8	5.3e-9	NR	MBI3825581.1	2053607	g103842	i0	50	0.586750788643533	62	31	58.7	0	123	308	1	62	MBI3825581.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	186	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota 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);;