metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_phylum = "Bacillota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26673872	26673872	PRJNA800053_P_NODE_10681_length_300_cov_1.343612_g10517_i0	PRJNA800053	10681	300	1.343612	4.030836	Massilistercora timonensis	2086584	Bacteria	Bacteria	43.9	0.0115	NR	WP_106790073.1	2086584	g10517	i0	41.2	0.51	51	30	51	0	143	295	31	81	WP_106790073.1 DMT family transporter [Massilistercora timonensis]	diamond	153	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Massilistercora	Massilistercora timonensis
26714492	26714492	PRJNA800053_P_NODE_13761_length_274_cov_1.766169_g13597_i0	PRJNA800053	13761	274	1.766169	4.83930306	Bacteria	2	Bacteria	Bacteria	67	5.33e-11	NR	WP_210888096.1	137838	g13597	i0	42.7	4.54379562043796	96	45	94.2	3	2	259	60	155	WP_210888096.1 hypothetical protein [Clostridium neonatale]	diamond	1245	67	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium neonatale
26999574	26999574	PRJNA800053_P_NODE_21902_length_244_cov_0.900585_g21738_i0	PRJNA800053	21902	244	0.900585	2.1974274	Bacillales	1385	Bacteria	Bacteria	115	3.18e-29	NR	WP_028988430.1	94009	g21738	i0	76.3	7.86885245901639	80	19	98.4	0	241	2	126	205	WP_028988430.1 nucleoid occlusion protein [Thermicanus aegyptius]	diamond	1920	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
27180242	27180242	PRJNA800053_P_NODE_17862_length_250_cov_1.598870_g17698_i0	PRJNA800053	17862	250	1.59887	3.997175	Thermosediminibacteraceae bacterium	2885163	Bacteria	Bacteria	45.4	0.00448	NR	MCG0276764.1	2885163	g17698	i0	48.8	0.492	41	19	49.2	1	95	217	9	47	MCG0276764.1 hypothetical protein [Thermosediminibacteraceae bacterium]	diamond	123	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermosediminibacterales	Thermosediminibacteraceae		Thermosediminibacteraceae bacterium
27243691	27243691	PRJNA800053_P_NODE_23823_length_241_cov_0.916667_g23659_i0	PRJNA800053	23823	241	0.916667	2.20916747	Heliorestis convoluta	356322	Bacteria	Bacteria	61.6	8.08e-9	NR	WP_153724125.1	356322	g23659	i0	39.2	0.983402489626556	79	48	98.3	0	5	241	529	607	WP_153724125.1 stalk domain-containing protein [Heliorestis convoluta]	diamond	237	61.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Heliobacteriaceae	Heliorestis	Heliorestis convoluta
27370461	27370461	PRJNA800053_P_NODE_18083_length_250_cov_0.870056_g17919_i0	PRJNA800053	18083	250	0.870056	2.17514	Listeria monocytogenes	1639	Bacteria	Bacteria	135	8.97e-40	NR	WP_333731491.1	1639	g17919	i0	78.9	0.912	76	16	91.2	0	239	12	1	76	WP_333731491.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	228	135	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
27410942	27410942	PRJNA800053_P_NODE_15483_length_262_cov_1.518519_g15319_i0	PRJNA800053	15483	262	1.518519	3.97851978	Bacteria	2	Bacteria	Bacteria	62.8	4.33e-9	NR	MFA5758336.1	2044939	g15319	i0	43.9	2.00381679389313	82	39	88.2	2	5	235	1191	1270	MFA5758336.1 hypothetical protein [Clostridia bacterium]	diamond	525	63.2	0.993670886075949	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27433542	27433542	PRJNA800053_P_NODE_13503_length_276_cov_1.467980_g13339_i0	PRJNA800053	13503	276	1.46798	4.0516248	Loigolactobacillus coryniformis	1610	Bacteria	Bacteria	67.8	1.61e-12	NR	WP_249567962.1	1610	g13339	i0	49.3	0.728260869565217	67	30	68.5	2	192	4	6	72	WP_249567962.1 hypothetical protein, partial [Loigolactobacillus coryniformis]	diamond	201	67.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Loigolactobacillus	Loigolactobacillus coryniformis
27465048	27465048	PRJNA800053_P_NODE_24343_length_236_cov_2.447853_g24179_i0	PRJNA800053	24343	236	2.447853	5.77693308	Bacillota bacterium	1879010	Bacteria	Bacteria	78.6	8.05e-15	NR	MDI6872135.1	1879010	g24179	i0	48.7	4.86864406779661	78	35	99.2	1	1	234	399	471	MDI6872135.1 phage terminase large subunit [Bacillota bacterium]	diamond	1149	78.6	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
27686254	27686254	PRJNA800053_P_NODE_24004_length_241_cov_0.916667_g23840_i0	PRJNA800053	24004	241	0.916667	2.20916747	Priestia	2800373	Bacteria	Bacteria	42.4	0.0476	NR	WP_061785142.1	2800373	g23840	i0	42.9	0.609958506224066	49	26	58.5	1	93	233	19	67	WP_061785142.1 MULTISPECIES: recombinase family protein [Priestia]	diamond	147	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia
27843595	27843595	PRJNA800053_P_NODE_12824_length_281_cov_1.168269_g12660_i0	PRJNA800053	12824	281	1.168269	3.28283589	Fusibacter sp.	2004507	Bacteria	Bacteria	101	1.58e-22	NR	HSN67330.1	2004507	g12660	i0	51.1	0.98220640569395	92	45	98.2	0	279	4	380	471	HSN67330.1 reverse transcriptase domain-containing protein [Fusibacter sp.]	diamond	276	101	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriales Family XII. Incertae Sedis	Fusibacter	Fusibacter sp.
27970023	27970023	PRJNA800053_P_NODE_15505_length_262_cov_1.317460_g15341_i0	PRJNA800053	15505	262	1.31746	3.4517452	Clostridium botulinum	1491	Bacteria	Bacteria	62.8	3.25e-10	NR	WP_225894519.1	1491	g15341	i0	58.3	1.80916030534351	60	22	68.7	1	182	3	9	65	WP_225894519.1 hypothetical protein [Clostridium botulinum]	diamond	474	62.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
29264410	29264410	PRJNA800053_P_NODE_23049_length_242_cov_0.911243_g22885_i0	PRJNA800053	23049	242	0.911243	2.20520806	Streptococcus	1301	Bacteria	Bacteria	152	9.81e-44	NR	WP_002929784.1	1301	g22885	i0	90	0.991735537190083	80	8	99.2	0	241	2	162	241	WP_002929784.1 MULTISPECIES: CPBP family intramembrane glutamic endopeptidase [Streptococcus]	diamond	240	152	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus
29431167	29431167	PRJNA800053_P_NODE_23349_length_242_cov_0.911243_g23185_i0	PRJNA800053	23349	242	0.911243	2.20520806	Bacilli	91061	Bacteria	Bacteria	45.1	0.00513	NR	WP_272225797.1	97478	g23185	i0	50	3.12396694214876	34	17	42.1	0	236	135	32	65	WP_272225797.1 hypothetical protein [Limosilactobacillus mucosae]	diamond	756	45.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus mucosae
29737952	29737952	PRJNA800053_P_NODE_22370_length_243_cov_0.905882_g22206_i0	PRJNA800053	22370	243	0.905882	2.20129326	Anoxybacteroides amylolyticum	294699	Bacteria	Bacteria	92.8	2.92e-22	NR	WP_066328038.1	294699	g22206	i0	90.7	0.666666666666667	54	5	66.7	0	5	166	62	115	WP_066328038.1 DUF2294 domain-containing protein [Anoxybacteroides amylolyticum]	diamond	162	92.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides amylolyticum
29841888	29841888	PRJNA800053_P_NODE_18051_length_250_cov_0.870056_g17887_i0	PRJNA800053	18051	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	111	3.98e-30	NR	WP_284730359.1	257758	g17887	i0	98.1	1.608	54	1	64.8	0	9	170	26	79	WP_284730359.1 hypothetical protein, partial [Streptococcus pseudopneumoniae]	diamond	402	112	0.991071428571429	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pseudopneumoniae
30053903	30053903	PRJNA800053_P_NODE_18371_length_250_cov_0.802260_g18207_i0	PRJNA800053	18371	250	0.80226	2.00565	Fusibacter sp.	2004507	Bacteria	Bacteria	157	1.2899999999999997e-42	NR	HSN67330.1	2004507	g18207	i0	96.3	0.984	82	3	98.4	0	247	2	282	363	HSN67330.1 reverse transcriptase domain-containing protein [Fusibacter sp.]	diamond	246	157	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriales Family XII. Incertae Sedis	Fusibacter	Fusibacter sp.
30180365	30180365	PRJNA800053_P_NODE_15832_length_260_cov_1.438503_g15668_i0	PRJNA800053	15832	260	1.438503	3.7401078	Holdemania massiliensis	1468449	Bacteria	Bacteria	61.2	1.36e-8	NR	WP_303016301.1	1468449	g15668	i0	49.1	3.10384615384615	53	27	61.2	0	18	176	373	425	WP_303016301.1 radical SAM/SPASM domain-containing protein [Holdemania massiliensis]	diamond	807	61.2	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Holdemania	Holdemania massiliensis
30370481	30370481	PRJNA800053_P_NODE_16412_length_256_cov_1.934426_g16248_i0	PRJNA800053	16412	256	1.934426	4.95213056	Fusibacter sp. 3D3	1048380	Bacteria	Bacteria	43.9	0.0176	NR	WP_069872425.1	1048380	g16248	i0	45.3	0.62109375	53	26	62.1	2	44	202	387	436	WP_069872425.1 DEAD/DEAH box helicase family protein [Fusibacter sp. 3D3]	diamond	159	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriales Family XII. Incertae Sedis	Fusibacter	Fusibacter sp. 3D3
30812303	30812303	PRJNA800053_P_NODE_22894_length_242_cov_1.384615_g22730_i0	PRJNA800053	22894	242	1.384615	3.3507683	Thermicanus sp.	2773240	Bacteria	Bacteria	122	7.039999999999999e-31	NR	MBE3553727.1	2773240	g22730	i0	70.9	1.95867768595041	79	23	97.9	0	241	5	53	131	MBE3553727.1 HAMP domain-containing protein [Thermicanus sp.]	diamond	474	122	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus sp.
30812305	30812305	PRJNA800053_P_NODE_6534_length_365_cov_1.044521_g6370_i0	PRJNA800053	6534	365	1.044521	3.81250165	Roseburia sp.	2049040	Bacteria	Bacteria	53.1	2.66e-5	NR	MDY5882880.1	2049040	g6370	i0	40.6	0.526027397260274	64	27	52.6	2	193	2	87	139	MDY5882880.1 hypothetical protein [Roseburia sp.]	diamond	192	53.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia sp.
30852870	30852870	PRJNA800053_P_NODE_23934_length_241_cov_0.916667_g23770_i0	PRJNA800053	23934	241	0.916667	2.20916747	Bacillota	1239	Bacteria	Bacteria	63.2	2.33e-9	NR	WP_028986206.1	94009	g23770	i0	56.5	2.31535269709544	62	27	77.2	0	5	190	488	549	WP_028986206.1 methyl-accepting chemotaxis protein [Thermicanus aegyptius]	diamond	558	63.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
30875549	30875549	PRJNA800053_P_NODE_22954_length_242_cov_0.911243_g22790_i0	PRJNA800053	22954	242	0.911243	2.20520806	Clostridia bacterium	2044939	Bacteria	Bacteria	43.9	0.0142	NR	NLG03894.1	2044939	g22790	i0	34.2	0.942148760330578	76	49	93	1	15	239	11	86	NLG03894.1 hypothetical protein [Clostridia bacterium]	diamond	228	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30970474	30970474	PRJNA800053_P_NODE_13234_length_278_cov_1.292683_g13070_i0	PRJNA800053	13234	278	1.292683	3.59365874	Firmicutes bacterium ADurb.Bin5	1879010	Bacteria	Bacteria	149	3.06e-43	NR	OPZ65775.1	1852895	g13070	i0	98.4	0.669064748201439	62	1	66.9	0	5	190	144	205	OPZ65775.1 MAG: Fimbrial protein precursor [Firmicutes bacterium ADurb.Bin506]	diamond	186	149	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium ADurb.Bin506
31159534	31159534	PRJNA800053_P_NODE_13935_length_273_cov_1.390000_g13771_i0	PRJNA800053	13935	273	1.39	3.7947	Streptococcus pneumoniae	1313	Bacteria	Bacteria	114	4.369999999999999e-31	NR	WP_155459506.1	1313	g13771	i0	83.6	0.67032967032967	61	10	67	0	4	186	15	75	WP_155459506.1 glycoside hydrolase family protein, partial [Streptococcus pneumoniae]	diamond	183	114	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
31231888	31231888	PRJNA800053_P_NODE_23815_length_241_cov_0.916667_g23651_i0	PRJNA800053	23815	241	0.916667	2.20916747	Bacillati	1783272	Bacteria	Bacteria	61.2	2.7e-10	NR	WP_038600505.1	1358	g23651	i0	56	5.39004149377593	50	22	62.2	0	5	154	19	68	WP_038600505.1 DUF7681 family protein [Lactococcus lactis]	diamond	1299	61.6	0.993506493506494	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
31381434	31381434	PRJNA800053_P_NODE_18576_length_249_cov_0.875000_g18412_i0	PRJNA800053	18576	249	0.875	2.17875	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	82	2.62e-18	NR	MFK5282989.1	1597	g18412	i0	82.6	1.13253012048193	46	8	55.4	0	28	165	40	85	MFK5282989.1 hypothetical protein [Lacticaseibacillus paracasei]	diamond	282	82	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
31634209	31634209	PRJNA800053_P_NODE_20756_length_246_cov_0.890173_g20592_i0	PRJNA800053	20756	246	0.890173	2.18982558	Brevibacillus invocatus	173959	Bacteria	Bacteria	89	9.75e-20	NR	WP_251244117.1	173959	g20592	i0	74.5	1.34146341463415	55	14	67.1	0	246	82	152	206	WP_251244117.1 PilZ domain-containing protein [Brevibacillus invocatus]	diamond	330	89	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus invocatus
31792256	31792256	PRJNA800053_P_NODE_18697_length_249_cov_0.875000_g18533_i0	PRJNA800053	18697	249	0.875	2.17875	Brockia lithotrophica	933949	Bacteria	Bacteria	105	1.9099999999999994e-24	NR	MBT9253880.1	933949	g18533	i0	64.5	0.91566265060241	76	27	91.6	0	19	246	17	92	MBT9253880.1 carbamoyltransferase HypF [Brockia lithotrophica]	diamond	228	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Brockia	Brockia lithotrophica
31991136	31991136	PRJNA800053_P_NODE_21318_length_245_cov_0.895349_g21154_i0	PRJNA800053	21318	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	125	1.92e-33	NR	HDA7126330.1	1280	g21154	i0	71.3	2.93877551020408	80	23	98	0	4	243	152	231	HDA7126330.1 hypothetical protein [Staphylococcus aureus]	diamond	720	126	0.992063492063492	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32203797	32203797	PRJNA800053_P_NODE_12238_length_285_cov_2.141509_g12074_i0	PRJNA800053	12238	285	2.141509	6.10330065	Firmicutes bacterium ADurb.Bin3	1879010	Bacteria	Bacteria	81.3	2.26e-16	NR	OQA46152.1	1852888	g12074	i0	45.1	0.957894736842105	91	47	92.6	2	269	6	123	213	OQA46152.1 MAG: hypothetical protein BWY46_02042 [Firmicutes bacterium ADurb.Bin300]	diamond	273	81.3	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium ADurb.Bin300
32267224	32267224	PRJNA800053_P_NODE_21838_length_244_cov_0.900585_g21674_i0	PRJNA800053	21838	244	0.900585	2.1974274	Thermicanus aegyptius	94009	Bacteria	Bacteria	129	1.81e-33	NR	WP_028987196.1	94009	g21674	i0	80	0.983606557377049	80	16	98.4	0	3	242	104	183	WP_028987196.1 replication-associated recombination protein A [Thermicanus aegyptius]	diamond	240	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
32520449	32520449	PRJNA800053_P_NODE_18739_length_249_cov_0.875000_g18575_i0	PRJNA800053	18739	249	0.875	2.17875	Eubacterium limosum	1736	Bacteria	Bacteria	60.5	2.19e-8	NR	WP_133965423.1	1736	g18575	i0	48.2	0.674698795180723	56	29	67.5	0	17	184	74	129	WP_133965423.1 G5 domain-containing protein [Eubacterium limosum]	diamond	168	60.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium limosum
32614879	32614879	PRJNA800053_P_NODE_19420_length_248_cov_0.880000_g19256_i0	PRJNA800053	19420	248	0.88	2.1824	Exiguobacterium antarcticum	132920	Bacteria	Bacteria	53.9	4.06e-6	NR	WP_051590445.1	132920	g19256	i0	36.8	1.77822580645161	76	48	91.9	0	236	9	142	217	WP_051590445.1 hypothetical protein [Exiguobacterium antarcticum]	diamond	441	53.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium antarcticum
32623683	32623683	PRJNA800053_P_NODE_23680_length_241_cov_0.916667_g23516_i0	PRJNA800053	23680	241	0.916667	2.20916747	Thermicanus	94008	Bacteria	Bacteria	118	7.579999999999999e-31	NR	WP_005586448.1	94009	g23516	i0	78.5	1.96680497925311	79	17	98.3	0	238	2	66	144	WP_005586448.1 ABC transporter permease [Thermicanus aegyptius]	diamond	474	118	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius

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