metadata: contig_metadata: 27 rows where bioproject = "PRJNA473824" and tax

27 rows where bioproject = "PRJNA473824" 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
2372246	2372246	PRJNA473824_P_NODE_99722_length_173_cov_2.779412_g99084_i0	PRJNA473824	99722	173	2.779412	4.80838276	Bacteria	2	Bacteria	Bacteria	75	3.1e-9	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g99084	i0	92.308	0.901734104046243	52	4	30	0	25	76	831219	831168	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	156	75	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6199212	6199212	PRJNA473824_P_NODE_106805_length_173_cov_2.639706_g106167_i0	PRJNA473824	106805	173	2.639706	4.56669138	Candidatus Gracilibacteria bacterium GN	2044595	Bacteria	Bacteria	94	1.31e-20	NR	RAL55467.1	1914866	g106167	i0	86	0.988439306358382	57	3	98.8	1	1	171	110	161	RAL55467.1 translation elongation factor G [Candidatus Gracilibacteria bacterium GN02-873]	diamond	171	94	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium GN02-873
14475631	14475631	PRJNA473824_P_NODE_51292_length_174_cov_1.138686_g50654_i0	PRJNA473824	51292	174	1.138686	1.98131364	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	97.1	6.67e-16	NTclustered	gi\|1958002866\|gb\|CP064959.1\|	2026720	g50654	i0	89.744	2.11494252873563	78	4	44	4	99	174	765872	765797	Candidatus Saccharibacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.508_uni chromosome, complete genome	blastn	368	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18298464	18298464	PRJNA473824_P_NODE_38675_length_195_cov_1.481013_g38037_i0	PRJNA473824	38675	195	1.481013	2.88797535	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	128	2.72e-25	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g38037	i0	89.216	2.37948717948718	102	11	52	0	1	102	327053	327154	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	464	128	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
19571834	19571834	PRJNA473824_P_NODE_103716_length_173_cov_2.698529_g103078_i0	PRJNA473824	103716	173	2.698529	4.66845517	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g103078	i0	89.13	0.601156069364162	46	3	25	2	1	44	139439	139484	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	104	56.5	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
22122664	22122664	PRJNA473824_P_NODE_118618_length_172_cov_2.555556_g117980_i0	PRJNA473824	118618	172	2.555556	4.39555632	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	187	3.79e-43	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g117980	i0	84.884	3.43604651162791	172	17	100	1	1	172	469086	468924	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	591	187	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
22123567	22123567	PRJNA473824_P_NODE_51318_length_174_cov_1.131387_g50680_i0	PRJNA473824	51318	174	1.131387	1.96861338	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	294	2.1999999999999998e-75	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g50680	i0	97.126	59.7241379310345	174	5	100	0	1	174	882660	882833	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	10392	294	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26965770	26965770	PRJNA473824_P_NODE_152402_length_151_cov_3.447368_g151764_i0	PRJNA473824	152402	151	3.447368	5.20552568	Bacteria	2	Bacteria	Bacteria	54.3	8.75e-7	NR	MBN2197635.1	2030812	g151764	i0	60.9	20.2847682119205	46	15	91.4	1	138	1	1	43	MBN2197635.1 DnaJ domain-containing protein [Candidatus Wolfebacteria bacterium]	diamond	3063	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota					Candidatus Wolfebacteria bacterium
27170875	27170875	PRJNA473824_P_NODE_62642_length_173_cov_4.544118_g62004_i0	PRJNA473824	62642	173	4.544118	7.86132414	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	43.5	0.0078	NR	HEY0965346.1	2973664	g62004	i0	78.3	1.17919075144509	23	5	39.9	0	103	171	349	371	HEY0965346.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	204	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27360863	27360863	PRJNA473824_P_NODE_113863_length_173_cov_2.360294_g113225_i0	PRJNA473824	113863	173	2.360294	4.08330862	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	47.4	3.36e-4	NR	MCK9369318.1	2099670	g113225	i0	34.3	1.21387283236994	70	31	95.4	1	3	167	144	213	MCK9369318.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	210	47.4	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
28623890	28623890	PRJNA473824_P_NODE_169047_length_150_cov_3.407080_g168409_i0	PRJNA473824	169047	150	3.40708	5.11062	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	53.5	1.57e-6	NR	HYD17954.1	2052139	g168409	i0	56	1	50	21	98	1	148	2	82	131	HYD17954.1 fused MFS/spermidine synthase [Patescibacteria group bacterium]	diamond	150	53.5	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
28923841	28923841	PRJNA473824_P_NODE_72148_length_173_cov_3.779412_g71510_i0	PRJNA473824	72148	173	3.779412	6.53838276	Candidatus Nanoperiomorbus	2171988	Bacteria	Bacteria	51.6	1.07e-5	NR	MCG5079764.1	2026720	g71510	i0	100	0.867052023121387	25	0	43.4	0	75	1	22	46	MCG5079764.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	150	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29034416	29034416	PRJNA473824_P_NODE_80068_length_173_cov_3.382353_g79430_i0	PRJNA473824	80068	173	3.382353	5.85147069	Candidatus Saccharibacteria bacterium 32-49-12	1970479	Bacteria	Bacteria	98.2	5.659999999999999e-24	NR	OYX41352.1	1970479	g79430	i0	86	0.988439306358382	57	2	98.8	1	3	173	98	148	OYX41352.1 MAG: hypothetical protein B7Y94_05285 [Candidatus Saccharibacteria bacterium 32-49-12]	diamond	171	98.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-49-12
29318211	29318211	PRJNA473824_P_NODE_106929_length_173_cov_2.632353_g106291_i0	PRJNA473824	106929	173	2.632353	4.55397069	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	43.9	0.00574	NR	HEV8713089.1	2838779	g106291	i0	66.7	1.68208092485549	24	8	41.6	0	5	76	617	640	HEV8713089.1 translocation/assembly module TamB domain-containing protein [Candidatus Binatia bacterium]	diamond	291	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29381493	29381493	PRJNA473824_P_NODE_86769_length_173_cov_3.169118_g86131_i0	PRJNA473824	86769	173	3.169118	5.48257414	Candidatus Nanoperiomorbus periodonticus	2171989	Bacteria	Bacteria	53.1	3.03e-6	NR	WP_129619217.1	2171989	g86131	i0	96	0.433526011560694	25	1	43.4	0	75	1	145	169	WP_129619217.1 Fic family protein [Candidatus Nanoperiomorbus periodonticus]	diamond	75	53.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanoperiomorbia	Candidatus Nanoperiomorbales	Candidatus Nanoperiomorbaceae	Candidatus Nanoperiomorbus	Candidatus Nanoperiomorbus periodonticus
29412912	29412912	PRJNA473824_P_NODE_15589_length_302_cov_4.079245_g14951_i0	PRJNA473824	15589	302	4.079245	12.3193199	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	76.6	4.42e-15	NR	MDE2106739.1	2052139	g14951	i0	78.6	0.417218543046358	42	9	41.7	0	128	3	6	47	MDE2106739.1 3'-5' exoribonuclease [Patescibacteria group bacterium]	diamond	126	76.6	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29444389	29444389	PRJNA473824_P_NODE_34030_length_206_cov_2.455621_g33392_i0	PRJNA473824	34030	206	2.455621	5.05857926	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	70.1	5.17e-12	NR	MCS7259043.1	2052148	g33392	i0	70	1.1504854368932	40	12	58.3	0	120	1	202	241	MCS7259043.1 acetate--CoA ligase [candidate division WOR-3 bacterium]	diamond	237	70.1	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3					candidate division WOR-3 bacterium
29507702	29507702	PRJNA473824_P_NODE_75690_length_173_cov_3.610294_g75052_i0	PRJNA473824	75690	173	3.610294	6.24580862	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	51.6	1.08e-5	NR	MBB1558430.1	2026720	g75052	i0	100	0.433526011560694	25	0	43.4	0	75	1	49	73	MBB1558430.1 DNA translocase FtsK [Candidatus Saccharibacteria bacterium]	diamond	75	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29886813	29886813	PRJNA473824_P_NODE_128051_length_160_cov_4.569106_g127413_i0	PRJNA473824	128051	160	4.569106	7.3105696	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	108	3.4e-28	NR	MBI2775627.1	2030827	g127413	i0	100	0.975	52	0	97.5	0	3	158	57	108	MBI2775627.1 hypothetical protein [Candidatus Dependentiae bacterium]	diamond	156	108	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
29918423	29918423	PRJNA473824_P_NODE_47931_length_178_cov_2.758865_g47293_i0	PRJNA473824	47931	178	2.758865	4.9107797	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	47.8	5.82e-5	NR	MDQ5900912.1	2052139	g47293	i0	42.4	0.99438202247191	59	34	99.4	0	2	178	20	78	MDQ5900912.1 Transglycosylas protein [Patescibacteria group bacterium]	diamond	177	47.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30408628	30408628	PRJNA473824_P_NODE_26753_length_229_cov_4.291667_g26115_i0	PRJNA473824	26753	229	4.291667	9.82791743	Bacteria	2	Bacteria	Bacteria	93.6	7.290000000000001e-22	NR	OGL23189.1	1802133	g26115	i0	85.1	1.23144104803493	47	7	61.6	0	87	227	19	65	OGL23189.1 MAG: hypothetical protein A2791_05135 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30]	diamond	282	94.4	0.991525423728813	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30
30897872	30897872	PRJNA473824_P_NODE_70954_length_173_cov_3.852941_g70316_i0	PRJNA473824	70954	173	3.852941	6.66558793	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	51.2	2.65e-6	NR	MDO4712836.1	2026720	g70316	i0	50	1.94219653179191	56	21	97.1	1	3	170	45	93	MDO4712836.1 AraC family ligand binding domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	336	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31134688	31134688	PRJNA473824_P_NODE_165655_length_150_cov_4.371681_g165017_i0	PRJNA473824	165655	150	4.371681	6.5575215	Bacteria	2	Bacteria	Bacteria	45.1	0.0014	NR	MBI4086982.1	2030810	g165017	i0	84	4.18	25	4	50	0	146	72	197	221	MBI4086982.1 PrsW family intramembrane metalloprotease [Candidatus Kaiserbacteria bacterium]	diamond	627	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
31245271	31245271	PRJNA473824_P_NODE_63355_length_173_cov_4.463235_g62717_i0	PRJNA473824	63355	173	4.463235	7.72139655	TM7 phylum sp. oral taxon 35	713052	Bacteria	Bacteria	54.3	1.12e-6	NR	TWP07762.1	713052	g62717	i0	100	0.433526011560694	25	0	43.4	0	1	75	91	115	TWP07762.1 hypothetical protein EUA76_02565 [TM7 phylum sp. oral taxon 350]	diamond	75	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 350
32447667	32447667	PRJNA473824_P_NODE_166019_length_150_cov_4.230088_g165381_i0	PRJNA473824	166019	150	4.230088	6.345132	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	49.3	4.99e-5	NR	MBP6925505.1	2053589	g165381	i0	75	0.56	28	7	56	0	2	85	515	542	MBP6925505.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	84	49.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
32699811	32699811	PRJNA473824_P_NODE_87480_length_173_cov_3.147059_g86842_i0	PRJNA473824	87480	173	3.147059	5.44441207	Candidatus Gracilibacteria bacterium GN	2044595	Bacteria	Bacteria	43.9	0.00572	NR	RAL56315.1	1914866	g86842	i0	72	0.433526011560694	25	7	43.4	0	76	2	140	164	RAL56315.1 hypothetical protein BLM37_02225 [Candidatus Gracilibacteria bacterium GN02-873]	diamond	75	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium GN02-873
32857326	32857326	PRJNA473824_P_NODE_40460_length_191_cov_3.305195_g39822_i0	PRJNA473824	40460	191	3.305195	6.31292245	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	47.4	4.46e-4	NR	MBP6875238.1	2212470	g39822	i0	51.9	2.67015706806283	54	25	83.2	1	190	32	782	835	MBP6875238.1 Ig-like domain repeat protein [Candidatus Eiseniibacteriota bacterium]	diamond	510	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota 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);;