metadata: contig_metadata: 14 rows where bioproject = "PRJNA888821", tax_clade = "Bacteria candidate phyla" and tax

14 rows where bioproject = "PRJNA888821", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"

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_class	tax_order	tax_family	tax_genus	tax_species
11066098	11066098	PRJNA888821_P_NODE_14949_length_310_cov_6.582278_g14867_i0	PRJNA888821	14949	310	6.582278	20.4050618	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	141	6.21e-38	NR	HKA28764.1	2838779	g14867	i0	56.9	1.19032258064516	123	33	99.7	1	309	1	26	148	HKA28764.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	369	141	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
12342312	12342312	PRJNA888821_P_NODE_5110_length_328_cov_28.776471_g5028_i0	PRJNA888821	5110	328	28.776471	94.38682488	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	311	4.61e-80	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g5028	i0	84.084	307.484756097561	333	41	99	8	2	328	2239537	2239211	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	100855	311	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
17440814	17440814	PRJNA888821_P_NODE_20614_length_309_cov_12.046610_g20532_i0	PRJNA888821	20614	309	12.04661	37.2240249	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	55.1	3.07e-6	NR	MEO6026913.1	2838779	g20532	i0	69.2	1.11650485436893	39	12	37.9	0	148	32	163	201	MEO6026913.1 PrsW family intramembrane metalloprotease [Candidatus Binatia bacterium]	diamond	345	55.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
23814966	23814966	PRJNA888821_P_NODE_27579_length_280_cov_15.497585_g27497_i0	PRJNA888821	27579	280	15.497585	43.393238	Candidatus Binatus	2767079	Bacteria	Bacteria	159	7.869999999999999e-48	NR	HYR95236.1	2811406	g27497	i0	82.2	5.83928571428571	90	16	96.4	0	11	280	4	93	HYR95236.1 pantetheine-phosphate adenylyltransferase [Candidatus Binatus sp.]	diamond	1635	159	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
27403253	27403253	PRJNA888821_P_NODE_26363_length_286_cov_8.910798_g26281_i0	PRJNA888821	26363	286	8.910798	25.48488228	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	94.7	5.77e-21	NR	HLK12174.1	2838779	g26281	i0	50	3.06293706293706	98	46	99.7	1	286	2	179	276	HLK12174.1 sugar phosphate nucleotidyltransferase [Candidatus Binatia bacterium]	diamond	876	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27719321	27719321	PRJNA888821_P_NODE_14664_length_310_cov_6.801688_g14582_i0	PRJNA888821	14664	310	6.801688	21.0852328	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	92.4	1.52e-19	NR	HKA31465.1	2838779	g14582	i0	83.7	0.948387096774194	49	8	47.4	0	162	308	7	55	HKA31465.1 CoA transferase [Candidatus Binatia bacterium]	diamond	294	92.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27845003	27845003	PRJNA888821_P_NODE_26984_length_283_cov_6.904762_g26902_i0	PRJNA888821	26984	283	6.904762	19.54047646	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	132	2.74e-34	NR	HEV7731578.1	2838779	g26902	i0	59.6	0.996466431095406	94	38	99.6	0	282	1	315	408	HEV7731578.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	282	132	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
28855367	28855367	PRJNA888821_P_NODE_52368_length_199_cov_9.317460_g52285_i0	PRJNA888821	52368	199	9.31746	18.5417454	Candidatus Binatus sp.	2811406	Bacteria	Bacteria	84.7	2.55e-17	NR	HXN17238.1	2811406	g52285	i0	64.6	2.93969849246231	65	23	98	0	195	1	23	87	HXN17238.1 glycosyltransferase family 4 protein [Candidatus Binatus sp.]	diamond	585	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
29897626	29897626	PRJNA888821_P_NODE_41471_length_233_cov_11.500000_g41388_i0	PRJNA888821	41471	233	11.5	26.795	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	101	2.5399999999999994e-23	NR	MDG2306605.1	2838779	g41388	i0	62.3	1.98283261802575	77	29	99.1	0	1	231	52	128	MDG2306605.1 sulfotransferase [Candidatus Binatia bacterium]	diamond	462	101	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30284924	30284924	PRJNA888821_P_NODE_44012_length_225_cov_4.934211_g43929_i0	PRJNA888821	44012	225	4.934211	11.10197475	Bacillati	1783272	Bacteria	Bacteria	91.7	2.64e-20	NR	HJW70241.1	2838779	g43929	i0	68.3	1.66666666666667	63	20	84	0	1	189	193	255	HJW70241.1 ferritin-like domain-containing protein [Candidatus Binatia bacterium]	diamond	375	91.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31256142	31256142	PRJNA888821_P_NODE_19235_length_310_cov_3.345992_g19153_i0	PRJNA888821	19235	310	3.345992	10.3725752	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	133	7.0199999999999985e-34	NR	MFI5396171.1	2838779	g19153	i0	52.2	1.29677419354839	134	29	95.8	1	297	1	5	138	MFI5396171.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	402	133	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31762185	31762185	PRJNA888821_P_NODE_40737_length_236_cov_5.453988_g40654_i0	PRJNA888821	40737	236	5.453988	12.87141168	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	117	4.16e-30	NR	HLY37620.1	2838779	g40654	i0	74.4	1.98305084745763	78	20	99.2	0	236	3	38	115	HLY37620.1 ParB/RepB/Spo0J family partition protein [Candidatus Binatia bacterium]	diamond	468	117	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31857027	31857027	PRJNA888821_P_NODE_13417_length_310_cov_7.759494_g13335_i0	PRJNA888821	13417	310	7.759494	24.0544314	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	87.4	1.74e-17	NR	HEV7734731.1	2838779	g13335	i0	82	0.483870967741935	50	9	48.4	0	1	150	271	320	HEV7734731.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	150	87.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32710642	32710642	PRJNA888821_P_NODE_43400_length_227_cov_4.428571_g43317_i0	PRJNA888821	43400	227	4.428571	10.05285617	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	62.8	1.72e-10	NR	HLK10587.1	2838779	g43317	i0	50	0.92511013215859	70	35	92.5	0	213	4	2	71	HLK10587.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	210	62.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;