metadata: contig_metadata: 11 rows where bioproject = "PRJNA797655" and tax

11 rows where bioproject = "PRJNA797655" and tax_clade = "Bacteria candidate phyla"

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
2060928	2060928	PRJNA797655_S_NODE_214982_length_172_cov_1.488372_g214377_i0	PRJNA797655	214982	172	1.488372	2.55999984	uncultured Poribacteria bacterium	265321	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2518551991\|emb\|OX638351.1\|	265321	g214377	i0	100	0.162790697674419	28	0	16	0	144	171	2020899	2020926	MAG: uncultured Poribacteria bacterium isolate d4690918-7cf6-4b6d-bcb0-07eb3c50a363 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					uncultured Poribacteria bacterium
16084181	16084181	PRJNA797655_S_NODE_101953_length_244_cov_1.910448_g101348_i0	PRJNA797655	101953	244	1.910448	4.66149312	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2160621446\|gb\|CP054059.1\|	2735562	g101348	i0	96.875	0.131147540983607	32	0	13	1	195	225	277327	277296	Candidatus Absconditicoccus praedator strain M39-6 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
27433367	27433367	PRJNA797655_S_NODE_164883_length_197_cov_1.266234_g164278_i0	PRJNA797655	164883	197	1.266234	2.49448098	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42	0.039	NR	MEK7550205.1	2052139	g164278	i0	35.7	0.639593908629442	42	26	62.4	1	48	170	213	254	MEK7550205.1 alpha-(1->3)-arabinofuranosyltransferase family protein [Patescibacteria group bacterium]	diamond	126	42	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27686074	27686074	PRJNA797655_S_NODE_198144_length_179_cov_5.852941_g197539_i0	PRJNA797655	198144	179	5.852941	10.47676439	Candidatus Babeliaceae bacterium	2545253	Bacteria	Bacteria	42.4	0.02	NR	HVW99685.1	2545253	g197539	i0	60.7	0.46927374301676	28	10	45.3	1	8	88	77	104	HVW99685.1 lycopene cyclase domain-containing protein [Candidatus Babeliaceae bacterium]	diamond	84	42.4	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		Candidatus Babeliaceae bacterium
27875112	27875112	PRJNA797655_S_NODE_221105_length_169_cov_2.666667_g220500_i0	PRJNA797655	221105	169	2.666667	4.50666723	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	41.6	0.0356	NR	MFH1308574.1	2052139	g220500	i0	31.8	0.781065088757396	44	30	78.1	0	166	35	47	90	MFH1308574.1 UDP-N-acetylglucosamine 2-epimerase [Patescibacteria group bacterium]	diamond	132	41.6	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27969868	27969868	PRJNA797655_S_NODE_183045_length_187_cov_1.666667_g182440_i0	PRJNA797655	183045	187	1.666667	3.11666729	Candidatus Wallbacteria bacterium	2053640	Bacteria	Bacteria	42	0.0269	NR	MBI3892909.1	2053640	g182440	i0	42.2	0.72192513368984	45	25	70.6	1	8	139	94	138	MBI3892909.1 GNAT family N-acetyltransferase [Candidatus Wallbacteria bacterium]	diamond	135	42	1	Bacteria	Bacteria candidate phyla	Candidatus Walliibacteriota					Candidatus Wallbacteria bacterium
28096199	28096199	PRJNA797655_S_NODE_83225_length_264_cov_1.737557_g82620_i0	PRJNA797655	83225	264	1.737557	4.58715048	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	45.8	0.0037	NR	MDP2631042.1	2053634	g82620	i0	26.6	0.897727272727273	79	51	81.8	1	49	264	154	232	MDP2631042.1 hypothetical protein [Candidatus Uhrbacteria bacterium]	diamond	237	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota					Candidatus Uhrbacteria bacterium
28127881	28127881	PRJNA797655_S_NODE_192305_length_182_cov_2.417266_g191700_i0	PRJNA797655	192305	182	2.417266	4.39942412	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	42.4	0.0231	NR	MCC6520548.1	2052152	g191700	i0	36.5	0.857142857142857	52	31	82.4	1	16	165	464	515	MCC6520548.1 class I tRNA ligase family protein [Candidatus Nomurabacteria bacterium]	diamond	156	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
29327492	29327492	PRJNA797655_S_NODE_40469_length_336_cov_2.457338_g39864_i0	PRJNA797655	40469	336	2.457338	8.25665568	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.9	0.03	NR	NJK48716.1	2044595	g39864	i0	40.4	0.508928571428571	57	33	50	1	31	198	105	161	NJK48716.1 CPBP family intramembrane metalloprotease [Candidatus Altimarinota bacterium]	diamond	171	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
32235585	32235585	PRJNA797655_S_NODE_154078_length_203_cov_2.700000_g153473_i0	PRJNA797655	154078	203	2.7	5.481	Candidatus Peribacteraceae bacterium	2735830	Bacteria	Bacteria	42.4	0.0303	NR	MDD4318736.1	2735830	g153473	i0	40	0.665024630541872	45	27	66.5	0	23	157	499	543	MDD4318736.1 hypothetical protein [Candidatus Peribacteraceae bacterium]	diamond	135	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales			Candidatus Peribacteraceae bacterium
32835026	32835026	PRJNA797655_S_NODE_112600_length_234_cov_2.513089_g111995_i0	PRJNA797655	112600	234	2.513089	5.88062826	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	43.9	0.0132	NR	HWT82134.1	2032687	g111995	i0	37.3	0.653846153846154	51	32	65.4	0	4	156	293	343	HWT82134.1 transposase [Candidatus Methylomirabilis sp.]	diamond	153	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.

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);;