metadata: contig_metadata: 5 rows where bioproject = "PRJNA662254" and tax

5 rows where bioproject = "PRJNA662254" 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
28534395	28534395	PRJNA662254_P_NODE_65567_length_241_cov_0.916667_g64916_i0	PRJNA662254	65567	241	0.916667	2.20916747	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	69.7	9.27e-12	NR	MBI1727606.1	2053607	g64916	i0	37.2	0.970954356846473	78	47	97.1	2	8	241	210	285	MBI1727606.1 beta-galactosidase [Candidatus Rokuibacteriota bacterium]	diamond	234	69.7	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29449590	29449590	PRJNA662254_P_NODE_9970_length_527_cov_1.253304_g9322_i0	PRJNA662254	9970	527	1.253304	6.60491208	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	42.7	0.0498	NR	PYM83194.1	2053607	g9322	i0	29.7	0.364326375711575	64	45	36.4	0	298	489	5	68	PYM83194.1 MAG: hypothetical protein DME09_11690 [Candidatus Rokuibacteriota bacterium]	diamond	192	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31167523	31167523	PRJNA662254_P_NODE_51255_length_248_cov_0.880000_g50604_i0	PRJNA662254	51255	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	103	1.39e-26	NR	MBI2553418.1	2053607	g50604	i0	72.1	5.83064516129032	68	19	82.3	0	206	3	37	104	MBI2553418.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	1446	104	0.990384615384615	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31914708	31914708	PRJNA662254_P_NODE_41037_length_262_cov_1.285714_g40386_i0	PRJNA662254	41037	262	1.285714	3.36857068	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	72.4	1.65e-12	NR	TMQ19279.1	2053607	g40386	i0	67.9	1.31679389312977	56	18	64.1	0	176	9	18	73	TMQ19279.1 MAG: homoserine O-succinyltransferase [Candidatus Rokuibacteriota bacterium]	diamond	345	72.4	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
31914732	31914732	PRJNA662254_P_NODE_60737_length_243_cov_0.905882_g60086_i0	PRJNA662254	60737	243	0.905882	2.20129326	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	72.4	1.33e-12	NR	PYO38174.1	2053607	g60086	i0	53.2	0.765432098765432	62	29	76.5	0	243	58	421	482	PYO38174.1 MAG: hypothetical protein DMD86_00820 [Candidatus Rokuibacteriota bacterium]	diamond	186	72.4	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);;