metadata: contig_metadata: 14 rows where bioproject = "PRJNA638138" and tax

14 rows where bioproject = "PRJNA638138" 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
17187382	17187382	PRJNA638138_P_NODE_28194_length_246_cov_0.878613_g27979_i0	PRJNA638138	28194	246	0.878613	2.16138798	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	145	5.43e-40	NR	MES2876310.1	2052139	g27979	i0	90.1	1.97560975609756	81	8	98.8	0	2	244	166	246	MES2876310.1 phosphoglycerate kinase [Patescibacteria group bacterium]	diamond	486	145	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
18461458	18461458	PRJNA638138_P_NODE_23875_length_248_cov_0.880000_g23660_i0	PRJNA638138	23875	248	0.88	2.1824	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	103	3.61e-26	NR	MFI5212834.1	2973664	g23660	i0	62.5	0.967741935483871	80	30	96.8	0	9	248	1	80	MFI5212834.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	240	103	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
19736074	19736074	PRJNA638138_P_NODE_20396_length_251_cov_0.865169_g20181_i0	PRJNA638138	20396	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	94.7	1.17e-21	NR	HSX17183.1	2052139	g20181	i0	74.6	4.50597609561753	63	16	75.3	0	189	1	1	63	HSX17183.1 ABC transporter ATP-binding protein [Patescibacteria group bacterium]	diamond	1131	95.5	0.991623036649215	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
26827981	26827981	PRJNA638138_P_NODE_32921_length_243_cov_0.876471_g32706_i0	PRJNA638138	32921	243	0.876471	2.12982453	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	71.6	1.58e-12	NR	MDL2341490.1	2052139	g32706	i0	47.6	1.01234567901235	82	37	93.8	3	232	5	115	196	MDL2341490.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Patescibacteria group bacterium]	diamond	246	71.6	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27902058	27902058	PRJNA638138_P_NODE_32145_length_243_cov_0.905882_g31930_i0	PRJNA638138	32145	243	0.905882	2.20129326	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	101	8.569999999999999e-23	NR	MBC7512123.1	2026720	g31930	i0	67.9	1	81	26	100	0	243	1	24	104	MBC7512123.1 LCP family protein [Candidatus Saccharibacteria bacterium]	diamond	243	101	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28439166	28439166	PRJNA638138_P_NODE_19906_length_251_cov_0.865169_g19691_i0	PRJNA638138	19906	251	0.865169	2.17157419	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	41.6	0.041	NR	MBF1035544.1	2725945	g19691	i0	44.7	1.08764940239044	38	21	45.4	0	198	85	22	59	MBF1035544.1 histidine phosphatase family protein [Candidatus Nanosynbacter sp.]	diamond	273	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
28817572	28817572	PRJNA638138_P_NODE_17028_length_266_cov_1.580311_g16813_i0	PRJNA638138	17028	266	1.580311	4.20362726	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	42.7	0.0472	NR	MFQ5668180.1	2838779	g16813	i0	41	0.879699248120301	78	41	83.5	3	248	27	300	376	MFQ5668180.1 acyl-CoA dehydrogenase family protein [Candidatus Binatia bacterium]	diamond	234	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30156403	30156403	PRJNA638138_P_NODE_28892_length_245_cov_0.895349_g28677_i0	PRJNA638138	28892	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	136	3.07e-36	NR	TXH06985.1	2045217	g28677	i0	72.8	4.93469387755102	81	22	99.2	0	243	1	215	295	TXH06985.1 MAG: PQQ-dependent sugar dehydrogenase [Candidatus Moraniibacteriota bacterium]	diamond	1209	136	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
30175692	30175692	PRJNA638138_P_NODE_19892_length_251_cov_0.865169_g19677_i0	PRJNA638138	19892	251	0.865169	2.17157419	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	96.7	1.21e-21	NR	MCA9339119.1	2026720	g19677	i0	69.2	0.776892430278884	65	20	77.7	0	57	251	1	65	MCA9339119.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Candidatus Saccharibacteria bacterium]	diamond	195	96.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31408321	31408321	PRJNA638138_P_NODE_26616_length_247_cov_0.885057_g26401_i0	PRJNA638138	26616	247	0.885057	2.18609079	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	146	8.689999999999997e-42	NR	MES2876336.1	2052139	g26401	i0	87.7	0.983805668016194	81	10	98.4	0	245	3	159	239	MES2876336.1 VTT domain-containing protein [Patescibacteria group bacterium]	diamond	243	146	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31661097	31661097	PRJNA638138_P_NODE_20357_length_251_cov_0.865169_g20142_i0	PRJNA638138	20357	251	0.865169	2.17157419	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	152	1.1199999999999999e-40	NR	HEX8390433.1	2973664	g20142	i0	90.4	12.8964143426295	83	8	99.2	0	249	1	315	397	HEX8390433.1 DNA translocase FtsK 4TM domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	3237	152	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31724436	31724436	PRJNA638138_P_NODE_23857_length_248_cov_0.880000_g23642_i0	PRJNA638138	23857	248	0.88	2.1824	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	42.7	0.0375	NR	HUY25280.1	2973664	g23642	i0	44	0.604838709677419	50	25	56.9	1	46	186	254	303	HUY25280.1 IS3 family transposase [Candidatus Saccharimonadales bacterium]	diamond	150	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32072529	32072529	PRJNA638138_P_NODE_35978_length_241_cov_0.916667_g35763_i0	PRJNA638138	35978	241	0.916667	2.20916747	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	150	3.25e-40	NR	HEY4963408.1	2973664	g35763	i0	87.5	0.995850622406639	80	10	99.6	0	2	241	599	678	HEY4963408.1 toprim domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	240	150	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32798937	32798937	PRJNA638138_P_NODE_17440_length_263_cov_1.568421_g17225_i0	PRJNA638138	17440	263	1.568421	4.12494723	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	76.6	2.67e-15	NR	HJY82301.1	2838779	g17225	i0	48.8	0.935361216730038	82	42	93.5	0	257	12	4	85	HJY82301.1 DUF3368 domain-containing protein [Candidatus Binatia bacterium]	diamond	246	76.6	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);;