metadata: contig_metadata: 7 rows where analysis = "diamond", tax_clade = "Bacteria candidate phyla" and tax

7 rows where analysis = "diamond", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Brenneribacteriota"

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
2838056	2838056	PRJNA1144090_P_NODE_38323_length_418_cov_1.533333_g37788_i0	PRJNA1144090	38323	418	1.533333	6.40933194	Candidatus Brennerbacteria bacterium	2750072	Bacteria	Bacteria	102	3.47e-22	NR	MBI2591641.1	2750072	g37788	i0	54.3	0.660287081339713	92	39	63.9	1	413	147	157	248	MBI2591641.1 M1 family metallopeptidase [Candidatus Brennerbacteria bacterium]	diamond	276	102	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria bacterium
3571132	3571132	PRJNA1108487_P_NODE_6923_length_274_cov_1.398010_g6857_i0	PRJNA1108487	6923	274	1.39801	3.8305474	Candidatus Brennerbacteria bacterium	2750072	Bacteria	Bacteria	117	2.21e-28	NR	MBI2591856.1	2750072	g6857	i0	63.3	2.93430656934307	90	30	96.4	2	274	11	64	152	MBI2591856.1 leucine--tRNA ligase [Candidatus Brennerbacteria bacterium]	diamond	804	117	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria bacterium
26317685	26317685	PRJEB14175_P_NODE_112015_length_333_cov_28.533088_g109749_i0	PRJEB14175	112015	333	28.533088	95.01518304	Candidatus Brennerbacteria bacterium	2750072	Bacteria	Bacteria	60.1	8.78e-8	NR	MFH0806279.1	2750072	g109749	i0	36.8	0.783783783783784	87	54	77.5	1	15	272	436	522	MFH0806279.1 hypothetical protein [Candidatus Brennerbacteria bacterium]	diamond	261	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria bacterium
29503096	29503096	PRJNA1148190_P_NODE_718470_length_244_cov_0.900585_g707297_i0	PRJNA1148190	718470	244	0.900585	2.1974274	Candidatus Brennerbacteria bacterium RIFOXYD1_FULL_41_16	1797529	Bacteria	Bacteria	106	7.78e-25	NR	OGY40366.1	1797529	g707297	i0	63	5.93852459016393	81	30	99.6	0	1	243	111	191	OGY40366.1 MAG: hypothetical protein A2570_03770 [Candidatus Brennerbacteria bacterium RIFOXYD1_FULL_41_16]	diamond	1449	106	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria bacterium RIFOXYD1_FULL_41_16
30218342	30218342	PRJNA379145_P_NODE_8872_length_1019_cov_3.125761_g7837_i0	PRJNA379145	8872	1019	3.125761	31.85150459	root	1	Root_unresolved	Root_unresolved	174	2.3e-48	NR	PIP50406.1	1974524	g7837	i0	37.6	10.360157016683	274	161	78.6	6	64	864	1	271	PIP50406.1 MAG: GNAT family N-acetyltransferase [Candidatus Brennerbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_44_41]	diamond	10557	175	0.994285714285714	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_44_41
30902944	30902944	PRJNA661142_P_NODE_12514_length_162_cov_0.902655_g12449_i0	PRJNA661142	12514	162	0.902655	1.4623011	Candidatus Brennerbacteria bacterium CG_4_9_14_3_um_filter_43_9	1974522	Bacteria	Bacteria	69.3	5.08e-12	NR	PJB50695.1	1974522	g12449	i0	62.3	0.981481481481482	53	20	98.1	0	2	160	272	324	PJB50695.1 MAG: hypothetical protein CO102_00295, partial [Candidatus Brennerbacteria bacterium CG_4_9_14_3_um_filter_43_9]	diamond	159	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria bacterium CG_4_9_14_3_um_filter_43_9
32283674	32283674	PRJNA1139127_P_NODE_28599_length_331_cov_1.209302_g28107_i0	PRJNA1139127	28599	331	1.209302	4.00278962	Candidatus Brennerbacteria bacterium	2750072	Bacteria	Bacteria	82	3.36e-16	NR	MBI2278936.1	2750072	g28107	i0	81.8	1.26888217522659	44	8	39.9	0	198	67	216	259	MBI2278936.1 IS3 family transposase [Candidatus Brennerbacteria bacterium]	diamond	420	82	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota	Candidatus Brennerbacteria 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);;