metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_phylum = "Candidatus Absconditibacteriota"

16 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_phylum = "Candidatus Absconditibacteriota"

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_order	tax_family	tax_genus	tax_species
26961134	26961134	PRJNA917598_P_NODE_54562_length_309_cov_1.245763_g53618_i0	PRJNA917598	54562	309	1.245763	3.84940767	candidate division SR1 bacterium	2044938	Bacteria	Bacteria	73.6	1.05e-12	NR	GHW02549.1	2044938	g53618	i0	44.6	0.893203883495146	92	44	82.5	2	282	28	48	139	GHW02549.1 hypothetical protein AGMMS50249_3350 [candidate division SR1 bacterium]	diamond	276	73.6	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				candidate division SR1 bacterium
27277623	27277623	PRJNA917598_P_NODE_57383_length_299_cov_2.004425_g56439_i0	PRJNA917598	57383	299	2.004425	5.99323075	Candidatus Absconditabacteria bacterium	3018262	Bacteria	Bacteria	73.2	7.43e-13	NR	MEF2175542.1	3018262	g56439	i0	47.2	2.83946488294314	89	47	89.3	0	288	22	120	208	MEF2175542.1 succinylglutamate desuccinylase/aspartoacylase family protein [Candidatus Absconditabacteria bacterium]	diamond	849	73.2	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				Candidatus Absconditabacteria bacterium
27435706	27435706	PRJNA917598_P_NODE_60923_length_289_cov_1.425926_g59979_i0	PRJNA917598	60923	289	1.425926	4.12092614	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	52	3.74e-5	NR	HMY80756.1	2927939	g59979	i0	34.4	0.996539792387543	96	60	98.6	2	4	288	233	326	HMY80756.1 S-layer homology domain-containing protein [Candidatus Absconditabacterales bacterium]	diamond	288	52	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales			Candidatus Absconditabacterales bacterium
27561546	27561546	PRJNA917598_P_NODE_82324_length_249_cov_2.187500_g81380_i0	PRJNA917598	82324	249	2.1875	5.446875	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	97.8	1.2e-21	NR	MCK9467307.1	2927939	g81380	i0	58	0.975903614457831	81	34	97.6	0	248	6	185	265	MCK9467307.1 pyruvate kinase [Candidatus Absconditabacterales bacterium]	diamond	243	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales			Candidatus Absconditabacterales bacterium
27877447	27877447	PRJNA917598_P_NODE_10645_length_730_cov_12.275495_g9747_i0	PRJNA917598	10645	730	12.275495	89.6111135	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	56.6	8.82e-6	NR	WP_231176162.1	2735562	g9747	i0	20.9	0.965753424657534	235	131	94.5	6	40	729	6	190	WP_231176162.1 hypothetical protein [Candidatus Absconditicoccus praedator]	diamond	705	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
28193044	28193044	PRJNA917598_P_NODE_6826_length_926_cov_2.284877_g6052_i0	PRJNA917598	6826	926	2.284877	21.15796102	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	60.5	4.26e-7	NR	WP_231176576.1	2735562	g6052	i0	34.4	0.311015118790497	96	59	30.5	2	430	149	35	128	WP_231176576.1 hypothetical protein [Candidatus Absconditicoccus praedator]	diamond	288	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
28509011	28509011	PRJNA917598_P_NODE_26087_length_452_cov_2.081794_g25143_i0	PRJNA917598	26087	452	2.081794	9.40970888	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	115	1.34e-26	NR	WP_231176568.1	2735562	g25143	i0	44.5	0.90929203539823	137	76	90.9	0	22	432	253	389	WP_231176568.1 ATPase, T2SS/T4P/T4SS family [Candidatus Absconditicoccus praedator]	diamond	411	115	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
28509069	28509069	PRJNA917598_P_NODE_8787_length_810_cov_1.814111_g7934_i0	PRJNA917598	8787	810	1.814111	14.6942991	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	115	1.75e-25	NR	WP_231176179.1	2735562	g7934	i0	42	0.511111111111111	138	79	51.1	1	795	382	22	158	WP_231176179.1 phosphodiester glycosidase family protein [Candidatus Absconditicoccus praedator]	diamond	414	115	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
29993103	29993103	PRJNA917598_P_NODE_28711_length_430_cov_0.862745_g27767_i0	PRJNA917598	28711	430	0.862745	3.7098035	Candidatus Absconditabacteria bacterium	3018262	Bacteria	Bacteria	60.8	5.36e-8	NR	MEF2174997.1	3018262	g27767	i0	68.2	0.306976744186047	44	14	30.7	0	277	408	153	196	MEF2174997.1 PHP domain-containing protein [Candidatus Absconditabacteria bacterium]	diamond	132	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				Candidatus Absconditabacteria bacterium
30277705	30277705	PRJNA917598_P_NODE_10652_length_730_cov_3.838661_g9754_i0	PRJNA917598	10652	730	3.838661	28.0222253	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	51.2	0.0021	NR	AKH32774.1	1643353	g9754	i0	38	0.378082191780822	92	47	36.6	4	284	18	589	673	AKH32774.1 hypothetical protein XF24_00435 [candidate division SR1 bacterium Aalborg_AAW-1]	diamond	276	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				candidate division SR1 bacterium Aalborg_AAW-1
30593234	30593234	PRJNA917598_P_NODE_31393_length_410_cov_60.495549_g30449_i0	PRJNA917598	31393	410	60.495549	248.0317509	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	53.9	4.85e-6	NR	WP_231176587.1	2735562	g30449	i0	42	0.592682926829268	81	46	58.5	1	319	80	23	103	WP_231176587.1 hypothetical protein [Candidatus Absconditicoccus praedator]	diamond	243	53.9	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
30656473	30656473	PRJNA917598_P_NODE_27053_length_444_cov_1.350404_g26109_i0	PRJNA917598	27053	444	1.350404	5.99579376	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	45.8	0.0237	NR	WP_231176221.1	2735562	g26109	i0	37.5	0.486486486486487	72	42	48.6	1	228	443	236	304	WP_231176221.1 hypothetical protein [Candidatus Absconditicoccus praedator]	diamond	216	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
31098753	31098753	PRJNA917598_P_NODE_90135_length_244_cov_3.274854_g89191_i0	PRJNA917598	90135	244	3.274854	7.99064376	candidate division SR1 bacterium	2044938	Bacteria	Bacteria	59.7	2.32e-8	NR	PZM87411.1	2044938	g89191	i0	46.4	0.848360655737705	69	36	84.8	1	242	36	31	98	PZM87411.1 MAG: hypothetical protein DLD55_01440 [candidate division SR1 bacterium]	diamond	207	59.7	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				candidate division SR1 bacterium
31161773	31161773	PRJNA917598_P_NODE_4475_length_1170_cov_2.423883_g3823_i0	PRJNA917598	4475	1170	2.423883	28.3594311	Candidatus Vampirococcus lugosii	2789015	Bacteria	Bacteria	181	7.92e-51	NR	WP_213348035.1	2789015	g3823	i0	43.6	0.541025641025641	211	118	53.8	1	6	635	17	227	WP_213348035.1 HD domain-containing protein [Candidatus Vampirococcus lugosii]	diamond	633	181	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota			Vampirococcus	Candidatus Vampirococcus lugosii
31826090	31826090	PRJNA917598_P_NODE_6617_length_941_cov_1.451613_g5851_i0	PRJNA917598	6617	941	1.451613	13.65967833	Candidatus Absconditabacteria bacterium	3018262	Bacteria	Bacteria	91.7	1.76e-16	NR	MEF2175373.1	3018262	g5851	i0	43.6	0.656748140276302	101	56	31.9	1	316	615	73	173	MEF2175373.1 InlB B-repeat-containing protein [Candidatus Absconditabacteria bacterium]	diamond	618	91.7	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota				Candidatus Absconditabacteria bacterium
32395820	32395820	PRJNA917598_P_NODE_13259_length_649_cov_1.604167_g12332_i0	PRJNA917598	13259	649	1.604167	10.41104383	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	189	3.2499999999999993e-52	NR	WP_231176568.1	2735562	g12332	i0	55.3	0.827426810477658	179	79	82.7	1	17	553	391	568	WP_231176568.1 ATPase, T2SS/T4P/T4SS family [Candidatus Absconditicoccus praedator]	diamond	537	189	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator

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