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

35 rows where analysis = "diamond", bioproject = "PRJNA283169" 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
27200332	27200332	PRJNA283169_S_NODE_1102_length_254_cov_0.087805_g1088_i0	PRJNA283169	1102	254	0.087805	0.2230247	Listeria monocytogenes	1639	Bacteria	Bacteria	63.9	3.75e-11	NR	WP_333728030.1	1639	g1088	i0	88.6	0.413385826771654	35	4	41.3	0	107	3	1	35	WP_333728030.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	105	63.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
27421981	27421981	PRJNA283169_P_NODE_2283_length_272_cov_1.798206_g2221_i0	PRJNA283169	2283	272	1.798206	4.89112032	Bacilli bacterium	1903720	Bacteria	Bacteria	55.1	2.54e-6	NR	MBR1376281.1	1903720	g2221	i0	51.7	0.981617647058823	89	42	98.2	1	2	268	3359	3446	MBR1376281.1 cadherin-like beta sandwich domain-containing protein [Bacilli bacterium]	diamond	267	55.1	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27453557	27453557	PRJNA283169_P_NODE_7443_length_164_cov_1.339130_g7380_i0	PRJNA283169	7443	164	1.33913	2.1961732	Bacilli bacterium	1903720	Bacteria	Bacteria	43.5	0.00671	NR	NCB78520.1	1903720	g7380	i0	50	0.548780487804878	30	15	54.9	0	53	142	2	31	NCB78520.1 hypothetical protein [Bacilli bacterium]	diamond	90	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27912834	27912834	PRJNA283169_P_NODE_7125_length_165_cov_2.577586_g7062_i0	PRJNA283169	7125	165	2.577586	4.2530169	Planomicrobium	162291	Bacteria	Bacteria	88.2	1.38e-19	NR	WP_308787516.1	253160	g7062	i0	91.3	1.67272727272727	46	4	83.6	0	3	140	203	248	WP_308787516.1 SDR family NAD(P)-dependent oxidoreductase [Planomicrobium stackebrandtii]	diamond	276	89	0.991011235955056	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planomicrobium	Planomicrobium stackebrandtii
28368889	28368889	PRJNA283169_P_NODE_1226_length_357_cov_1.175325_g1164_i0	PRJNA283169	1226	357	1.175325	4.19591025	Candidatus Petromonas sp.	3030600	Bacteria	Bacteria	176	1.12e-53	NR	MDK2917274.1	3030600	g1164	i0	68.1	1	119	37	99.2	1	4	357	23	141	MDK2917274.1 hypothetical protein [Candidatus Petromonas sp.]	diamond	357	176	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Caminicellaceae	Candidatus Petromonas	Candidatus Petromonas sp.
28449971	28449971	PRJNA283169_P_NODE_1046_length_385_cov_2.211310_g984_i0	PRJNA283169	1046	385	2.21131	8.5135435	root	1	Root_unresolved	Root_unresolved	48.5	4.53e-4	NR	HSH24195.1	1923872	g984	i0	76.9	0.397402597402597	26	6	20.3	0	308	385	71	96	HSH24195.1 DUF3310 domain-containing protein [Massilibacterium sp.]	diamond	153	48.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Massilibacterium	Massilibacterium sp.
28527079	28527079	PRJNA283169_P_NODE_7107_length_166_cov_0.871795_g7044_i0	PRJNA283169	7107	166	0.871795	1.4471797	Bacilli bacterium	1903720	Bacteria	Bacteria	40.8	0.0489	NR	MFA5695853.1	1903720	g7044	i0	40.4	1.03012048192771	57	27	99.4	4	1	165	114	165	MFA5695853.1 hypothetical protein [Bacilli bacterium]	diamond	171	40.8	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
28747883	28747883	PRJNA283169_P_NODE_5847_length_177_cov_1.375000_g5784_i0	PRJNA283169	5847	177	1.375	2.43375	Planomicrobium sp. MB-3u-38	2058318	Bacteria	Bacteria	120	4.68e-33	NR	WP_101802035.1	2058318	g5784	i0	100	0.983050847457627	58	0	98.3	0	175	2	34	91	WP_101802035.1 PCC domain-containing protein [Planomicrobium sp. MB-3u-38]	diamond	174	120	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planomicrobium	Planomicrobium sp. MB-3u-38
29127025	29127025	PRJNA283169_P_NODE_5529_length_182_cov_1.150376_g5466_i0	PRJNA283169	5529	182	1.150376	2.09368432	Bacillota bacterium	1879010	Bacteria	Bacteria	60.5	9.08e-9	NR	MBT9176623.1	1879010	g5466	i0	50	0.857142857142857	52	26	85.7	0	25	180	288	339	MBT9176623.1 ATP-dependent RNA helicase RhlB [Bacillota bacterium]	diamond	156	60.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29379348	29379348	PRJNA283169_P_NODE_3609_length_219_cov_0.805882_g3546_i0	PRJNA283169	3609	219	0.805882	1.76488158	Clostridium botulinum NCTC 2916	445335	Bacteria	Bacteria	40	0.0424	NR	EDT79926.1	445335	g3546	i0	45.5	0.753424657534247	55	25	71.2	2	163	8	14	66	EDT79926.1 unknown protein [Clostridium botulinum NCTC 2916]	diamond	165	40	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
29789666	29789666	PRJNA283169_P_NODE_1611_length_318_cov_1.680297_g1549_i0	PRJNA283169	1611	318	1.680297	5.34334446	Firmicutes bacterium ADurb.Bin419	1852892	Bacteria	Bacteria	132	8.43e-35	NR	OPZ92294.1	1852892	g1549	i0	57.3	0.971698113207547	103	44	97.2	0	316	8	91	193	OPZ92294.1 MAG: pyrroloquinoline quinone biosynthesis protein PqqE [Firmicutes bacterium ADurb.Bin419]	diamond	309	132	1	Bacteria	Bacillati	Bacillota					Firmicutes bacterium ADurb.Bin419
29789672	29789672	PRJNA283169_P_NODE_4871_length_193_cov_1.055556_g4808_i0	PRJNA283169	4871	193	1.055556	2.03722308	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	85.1	9.17e-18	NR	HVI40215.1	3030912	g4808	i0	68.8	0.994818652849741	64	20	99.5	0	2	193	233	296	HVI40215.1 hypothetical protein [Anaerovoracaceae bacterium]	diamond	192	85.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
29807358	29807358	PRJNA283169_P_NODE_8011_length_162_cov_0.955752_g7948_i0	PRJNA283169	8011	162	0.955752	1.54831824	Bacillota	1239	Bacteria	Bacteria	95.5	5.8e-23	NR	MDF2985769.1	142586	g7948	i0	77.4	5.88888888888889	53	12	98.1	0	3	161	133	185	MDF2985769.1 phage related protein [Eubacterium sp.]	diamond	954	95.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
30011084	30011084	PRJNA283169_S_NODE_2931_length_170_cov_0.099174_g2917_i0	PRJNA283169	2931	170	0.099174	0.1685958	Sporomusaceae bacterium ACPt	3076075	Bacteria	Bacteria	94	1.25e-20	NR	XEQ93372.1	3076075	g2917	i0	75	0.988235294117647	56	14	98.8	0	1	168	168	223	XEQ93372.1 putative dimethyl sulfoxide reductase chain YnfF [Sporomusaceae bacterium ACPt]	diamond	168	94	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa carbonis
30264004	30264004	PRJNA283169_P_NODE_5772_length_178_cov_1.356589_g5709_i0	PRJNA283169	5772	178	1.356589	2.41472842	uncultured Clostridium sp.	59620	Bacteria	Bacteria	92	6.1e-21	NR	WP_298842126.1	59620	g5709	i0	88.5	0.876404494382023	52	6	87.6	0	157	2	148	199	WP_298842126.1 hypothetical protein [uncultured Clostridium sp.]	diamond	156	92	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
30422061	30422061	PRJNA283169_S_NODE_1673_length_214_cov_0.121212_g1659_i0	PRJNA283169	1673	214	0.121212	0.25939368	Candidatus Allofournierella merdipullorum	2838595	Bacteria	Bacteria	43.5	0.00256	NR	WP_394969838.1	2838595	g1659	i0	53.8	1.1214953271028	39	18	54.7	0	14	130	36	74	WP_394969838.1 hypothetical protein [Candidatus Allofournierella merdipullorum]	diamond	240	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Allofournierella	Candidatus Allofournierella merdipullorum
30579397	30579397	PRJNA283169_P_NODE_6013_length_175_cov_1.111111_g5950_i0	PRJNA283169	6013	175	1.111111	1.94444425	Clostridia bacterium	2044939	Bacteria	Bacteria	44.3	0.00247	NR	MBO5142050.1	2044939	g5950	i0	47.6	0.72	42	20	68.6	1	138	19	1	42	MBO5142050.1 hypothetical protein [Clostridia bacterium]	diamond	126	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30895763	30895763	PRJNA283169_P_NODE_7934_length_163_cov_0.868421_g7871_i0	PRJNA283169	7934	163	0.868421	1.41552623	Clostridia bacterium	2044939	Bacteria	Bacteria	101	8.42e-26	NR	MBS1340966.1	2044939	g7871	i0	100	0.975460122699387	53	0	97.5	0	161	3	32	84	MBS1340966.1 Mini-ribonuclease 3 [Clostridia bacterium]	diamond	159	101	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30976589	30976589	PRJNA283169_P_NODE_5194_length_188_cov_0.884892_g5131_i0	PRJNA283169	5194	188	0.884892	1.66359696	Lacticaseibacillus	2759736	Bacteria	Bacteria	44.3	0.00267	NR	KTE97037.1	1597	g5131	i0	38.2	1.75531914893617	55	34	87.8	0	24	188	28	82	KTE97037.1 hypothetical protein AC564_3197 [Lacticaseibacillus paracasei]	diamond	330	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
31039950	31039950	PRJNA283169_P_NODE_1955_length_292_cov_0.851852_g1893_i0	PRJNA283169	1955	292	0.851852	2.48740784	Bacteria	2	Bacteria	Bacteria	131	2.21e-33	NR	MFA7222995.1	1903720	g1893	i0	57.7	6.0513698630137	97	39	97.6	1	290	6	23	119	MFA7222995.1 hypothetical protein [Bacilli bacterium]	diamond	1767	132	0.992424242424242	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31053853	31053853	PRJNA283169_P_NODE_1495_length_329_cov_1.064286_g1433_i0	PRJNA283169	1495	329	1.064286	3.50150094	Eubacteriales bacterium	2831996	Bacteria	Bacteria	63.5	5.76e-10	NR	MFA5386021.1	2831996	g1433	i0	50.8	0.574468085106383	63	31	57.4	0	139	327	44	106	MFA5386021.1 hypothetical protein [Eubacteriales bacterium]	diamond	189	63.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
31085201	31085201	PRJNA283169_S_NODE_1695_length_213_cov_0.109756_g1681_i0	PRJNA283169	1695	213	0.109756	0.23378028	Neobacillus drentensis	220684	Bacteria	Bacteria	62.8	2.44e-10	NR	WP_310359678.1	220684	g1681	i0	53.1	1.38028169014085	49	23	69	0	2	148	96	144	WP_310359678.1 hypothetical protein [Neobacillus drentensis]	diamond	294	62.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus drentensis
31274775	31274775	PRJNA283169_P_NODE_2455_length_263_cov_1.841121_g2393_i0	PRJNA283169	2455	263	1.841121	4.84214823	Bacillota bacterium	1879010	Bacteria	Bacteria	59.3	6.75e-8	NR	MFO7152718.1	1879010	g2393	i0	54.5	0.627376425855513	55	25	62.7	0	167	3	1	55	MFO7152718.1 tRNA lysidine(34) synthetase TilS [Bacillota bacterium]	diamond	165	59.3	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31369946	31369946	PRJNA283169_P_NODE_7176_length_165_cov_1.310345_g7113_i0	PRJNA283169	7176	165	1.310345	2.16206925	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.7	0.0128	NR	MCL2513950.1	2485925	g7113	i0	43.5	1.12727272727273	62	26	96.4	2	5	163	184	245	MCL2513950.1 aspartate kinase [Oscillospiraceae bacterium]	diamond	186	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
31464817	31464817	PRJNA283169_P_NODE_2936_length_242_cov_1.590674_g2873_i0	PRJNA283169	2936	242	1.590674	3.84943108	Paenisporosarcina sp.	1932001	Bacteria	Bacteria	62.8	6.07e-10	NR	HLG26887.1	1932001	g2873	i0	43.2	0.91735537190082606	74	42	91.7	0	4	225	99	172	HLG26887.1 hypothetical protein [Paenisporosarcina sp.]	diamond	222	62.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Paenisporosarcina	Paenisporosarcina sp.
31577277	31577277	PRJNA283169_P_NODE_6676_length_168_cov_0.865546_g6613_i0	PRJNA283169	6676	168	0.865546	1.45411728	root	1	Root_unresolved	Root_unresolved	91.3	7.98e-20	NR	WP_196592427.1	865	g6613	i0	69.1	4.875	55	17	98.2	0	3	167	68	122	WP_196592427.1 phage terminase large subunit [Pectinatus frisingensis]	diamond	819	92	0.992391304347826	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Pectinatus	Pectinatus frisingensis
31654185	31654185	PRJNA283169_S_NODE_1077_length_256_cov_0.222222_g1063_i0	PRJNA283169	1077	256	0.222222	0.56888832	Bacillota bacterium	1879010	Bacteria	Bacteria	55.8	1.05e-6	NR	MDP4145624.1	1879010	g1063	i0	75	0.421875	36	9	42.2	0	50	157	1	36	MDP4145624.1 hypothetical protein [Bacillota bacterium]	diamond	108	55.8	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31703665	31703665	PRJNA283169_P_NODE_1957_length_291_cov_2.338843_g1895_i0	PRJNA283169	1957	291	2.338843	6.80603313	Clostridia	186801	Bacteria	Bacteria	80.9	1.36e-15	NR	MDF2841580.1	1940278	g1895	i0	44.7	1.87628865979381	94	47	92.8	2	286	17	196	288	MDF2841580.1 metallophosphoesterase [Herbinix sp.]	diamond	546	80.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Herbinix	Herbinix sp.
31749128	31749128	PRJNA283169_P_NODE_2997_length_240_cov_1.073298_g2934_i0	PRJNA283169	2997	240	1.073298	2.5759152	Clostridium beijerinckii	1520	Bacteria	Bacteria	60.1	2.76e-8	NR	WP_012060541.1	1520	g2934	i0	48.5	1.65	66	34	82.5	0	1	198	371	436	WP_012060541.1 cell wall binding repeat-containing protein [Clostridium beijerinckii]	diamond	396	60.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
31844022	31844022	PRJNA283169_P_NODE_4657_length_196_cov_1.408163_g4594_i0	PRJNA283169	4657	196	1.408163	2.75999948	Bacillota bacterium	1879010	Bacteria	Bacteria	42	0.0354	NR	MBP7893212.1	1879010	g4594	i0	50	0.459183673469388	30	15	45.9	0	75	164	122	151	MBP7893212.1 hypothetical protein [Bacillota bacterium]	diamond	90	42	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
31956627	31956627	PRJNA283169_P_NODE_6537_length_168_cov_1.462185_g6474_i0	PRJNA283169	6537	168	1.462185	2.4564708	Bacteria	2	Bacteria	Bacteria	48.5	1.25e-4	NR	WP_169725485.1	392016	g6474	i0	42.9	3.01785714285714	56	31	100	1	168	1	288	342	WP_169725485.1 terminase large subunit domain-containing protein [Alicyclobacillus contaminans]	diamond	507	48.9	0.991820040899796	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus contaminans
32002368	32002368	PRJNA283169_P_NODE_6598_length_168_cov_0.873950_g6535_i0	PRJNA283169	6598	168	0.87395	1.468236	Planomicrobium okeanokoites	244	Bacteria	Bacteria	88.2	2.12e-19	NR	WP_084242972.1	244	g6535	i0	100	1.46428571428571	41	0	73.2	0	124	2	1	41	WP_084242972.1 hypothetical protein [Planomicrobium okeanokoites]	diamond	246	88.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planomicrobium	Planomicrobium okeanokoites
32255879	32255879	PRJNA283169_P_NODE_6558_length_168_cov_1.294118_g6495_i0	PRJNA283169	6558	168	1.294118	2.17411824	Clostridiales bacterium	1898207	Bacteria	Bacteria	91.7	8e-20	NR	MBD5089767.1	1898207	g6495	i0	80.4	1	56	11	100	0	1	168	273	328	MBD5089767.1 VWA domain-containing protein [Clostridiales bacterium]	diamond	168	91.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
32603378	32603378	PRJNA283169_P_NODE_8100_length_162_cov_0.911504_g8037_i0	PRJNA283169	8100	162	0.911504	1.47663648	Bacilli bacterium	1903720	Bacteria	Bacteria	80.5	2.77e-16	NR	MFA5408823.1	1903720	g8037	i0	64.2	0.981481481481482	53	19	98.1	0	160	2	12	64	MFA5408823.1 DNA methyltransferase [Bacilli bacterium]	diamond	159	80.5	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
32683789	32683789	PRJNA283169_P_NODE_880_length_413_cov_1.365385_g818_i0	PRJNA283169	880	413	1.365385	5.63904005	Paucisalibacillus	351094	Bacteria	Bacteria	54.7	1.45e-5	NR	WP_255247423.1	351095	g818	i0	34.5	3.41404358353511	113	67	79.9	4	394	65	146	254	WP_255247423.1 S1C family serine protease [Paucisalibacillus globulus]	diamond	1410	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Paucisalibacillus	Paucisalibacillus globulus

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