metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA492363" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA492363" 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
26110653	26110653	PRJNA492363_S_NODE_2701_length_544_cov_2.099379_g1894_i0	PRJNA492363	2701	544	2.099379	11.42062176	Alicyclobacillus	29330	Bacteria	Bacteria	179	6.14e-52	NR	WP_076347838.1	252246	g1894	i0	57.9	7.19117647058824	145	61	80	0	3	437	184	328	WP_076347838.1 UDP-glucose 4-epimerase GalE [Alicyclobacillus vulcanalis]	diamond	3912	179	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus vulcanalis
32918242	32918242	PRJNA492363_S_NODE_91753_length_206_cov_0.882759_g90932_i0	PRJNA492363	91753	206	0.882759	1.81848354	Clostridium sp.	1506	Bacteria	Bacteria	108	6.74e-26	NR	WP_291700353.1	1506	g90932	i0	82.4	0.990291262135922	68	12	99	0	206	3	383	450	WP_291700353.1 phage tail tape measure protein [Clostridium sp.]	diamond	204	108	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
32941438	32941438	PRJNA492363_S_NODE_97081_length_203_cov_0.901408_g96260_i0	PRJNA492363	97081	203	0.901408	1.82985824	Negativicutes	909932	Bacteria	Bacteria	70.5	2.38e-12	NR	WP_038675168.1	484770	g96260	i0	70.5	3.94581280788177	44	13	65	0	67	198	1	44	WP_038675168.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Pelosinus sp. UFO1]	diamond	801	71.2	0.990168539325843	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Pelosinus	Pelosinus sp. UFO1
32941440	32941440	PRJNA492363_S_NODE_98825_length_202_cov_1.361702_g98004_i0	PRJNA492363	98825	202	1.361702	2.75063804	Paenibacillus	44249	Bacteria	Bacteria	111	1.27e-27	NR	WP_145408319.1	528191	g98004	i0	78.8	2.92574257425743	66	14	98	0	200	3	43	108	WP_145408319.1 ABC transporter substrate-binding protein [Paenibacillus xylanexedens]	diamond	591	111	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus xylanexedens
32952516	32952516	PRJNA492363_S_NODE_39346_length_237_cov_1.693182_g38525_i0	PRJNA492363	39346	237	1.693182	4.01284134	Massilibacillus massiliensis	1806837	Bacteria	Bacteria	89	3.44e-19	NR	WP_110954057.1	1806837	g38525	i0	52.6	0.987341772151899	78	36	98.7	1	237	4	41	117	WP_110954057.1 glycosyltransferase family 2 protein [Massilibacillus massiliensis]	diamond	234	89	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Massilibacillus	Massilibacillus massiliensis
32952643	32952643	PRJNA492363_S_NODE_92954_length_205_cov_2.979167_g92133_i0	PRJNA492363	92954	205	2.979167	6.10729235	Clostridiales bacterium CHKCI	1898207	Bacteria	Bacteria	113	5.9899999999999995e-30	NR	CVI72592.1	1780378	g92133	i0	91.5	0.863414634146341	59	5	86.3	0	205	29	113	171	CVI72592.1 ECF RNA polymerase sigma factor SigW [Clostridiales bacterium CHKCI001]	diamond	177	113	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium CHKCI001
32975709	32975709	PRJNA492363_S_NODE_89882_length_207_cov_0.876712_g89061_i0	PRJNA492363	89882	207	0.876712	1.81479384	Eubacterium	1730	Bacteria	Bacteria	95.5	1.1699999999999997e-23	NR	WP_412191165.1	142586	g89061	i0	100	1.39130434782609	48	0	69.6	0	146	3	1	48	WP_412191165.1 Mur ligase domain-containing protein, partial [Eubacterium sp.]	diamond	288	95.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
32992673	32992673	PRJNA492363_S_NODE_61419_length_228_cov_1.401198_g60598_i0	PRJNA492363	61419	228	1.401198	3.19473144	Staphylococcus	1279	Bacteria	Bacteria	75.9	6.07e-14	NR	WP_369078522.1	29382	g60598	i0	54.4	3	57	26	75	0	206	36	1	57	WP_369078522.1 DNA repair protein RadA [Staphylococcus cohnii]	diamond	684	76.3	0.99475753604194	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
33003747	33003747	PRJNA492363_S_NODE_98963_length_202_cov_0.907801_g98142_i0	PRJNA492363	98963	202	0.907801	1.83375802	Jeotgalicoccus aerolatus	709510	Bacteria	Bacteria	143	5.469999999999999e-38	NR	HJG32880.1	709510	g98142	i0	100	0.995049504950495	67	0	99.5	0	201	1	536	602	HJG32880.1 glycosyltransferase family 4 protein [Jeotgalicoccus aerolatus]	diamond	201	143	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus aerolatus
33026836	33026836	PRJNA492363_S_NODE_86244_length_209_cov_0.864865_g85423_i0	PRJNA492363	86244	209	0.864865	1.80756785	Streptococcus	1301	Bacteria	Bacteria	142	2.1e-37	NR	RKV91865.1	1306	g85423	i0	98.6	6.93301435406699	69	1	99	0	209	3	415	483	RKV91865.1 MAG: YSIRK-type signal peptide-containing protein, partial [Streptococcus sp.]	diamond	1449	142	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
33054656	33054656	PRJNA492363_S_NODE_101085_length_201_cov_0.914286_g100264_i0	PRJNA492363	101085	201	0.914286	1.83771486	Bacillota bacterium	1879010	Bacteria	Bacteria	70.5	3.33e-12	NR	MCL5040764.1	1879010	g100264	i0	50.8	0.970149253731343	65	32	97	0	197	3	326	390	MCL5040764.1 hypothetical protein [Bacillota bacterium]	diamond	195	70.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
33054868	33054868	PRJNA492363_S_NODE_86269_length_209_cov_0.864865_g85448_i0	PRJNA492363	86269	209	0.864865	1.80756785	Halobacillus naozhouensis	554880	Bacteria	Bacteria	67.8	8.77e-12	NR	WP_283078271.1	554880	g85448	i0	48.5	3.78947368421053	66	34	94.7	0	208	11	129	194	WP_283078271.1 LysE family translocator [Halobacillus naozhouensis]	diamond	792	67.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halobacillus	Halobacillus naozhouensis
33060771	33060771	PRJNA492363_S_NODE_4693_length_411_cov_2.577143_g3872_i0	PRJNA492363	4693	411	2.577143	10.59205773	root	1	Root_unresolved	Root_unresolved	58.9	1.82e-8	NR	MDI9447315.1	1879010	g3872	i0	60.5	1	43	17	31.4	0	131	3	4	46	MDI9447315.1 hypothetical protein [Bacillota bacterium]	diamond	411	58.9	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
33071893	33071893	PRJNA492363_S_NODE_95229_length_204_cov_0.895105_g94408_i0	PRJNA492363	95229	204	0.895105	1.8260142	[Clostridium] innocuum	1522	Bacteria	Bacteria	130	1.26e-37	NR	WP_044909036.1	1522	g94408	i0	90.9	0.970588235294118	66	6	97.1	0	7	204	29	94	WP_044909036.1 integrase catalytic domain-containing protein, partial [[Clostridium] innocuum]	diamond	198	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
33088837	33088837	PRJNA492363_S_NODE_101006_length_201_cov_0.914286_g100185_i0	PRJNA492363	101006	201	0.914286	1.83771486	Macrococcus bovicus	69968	Bacteria	Bacteria	83.2	7.65e-17	NR	WP_289649966.1	69968	g100185	i0	63.1	0.970149253731343	65	24	97	0	197	3	92	156	WP_289649966.1 cysteine desulfurase family protein [Macrococcus bovicus]	diamond	195	83.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus bovicus
33146189	33146189	PRJNA492363_S_NODE_86135_length_209_cov_0.864865_g85314_i0	PRJNA492363	86135	209	0.864865	1.80756785	Thermoanaerobacterium	28895	Bacteria	Bacteria	121	3.88e-30	NR	WP_192401669.1	1517	g85314	i0	98.1	1.52153110047847	53	1	76.1	0	2	160	533	585	WP_192401669.1 transglycosylase domain-containing protein [Thermoanaerobacterium thermosaccharolyticum]	diamond	318	121	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
33146202	33146202	PRJNA492363_S_NODE_95215_length_204_cov_0.895105_g94394_i0	PRJNA492363	95215	204	0.895105	1.8260142	Bacillati	1783272	Bacteria	Bacteria	55.5	4.15e-7	NR	WP_255309913.1	86661	g94394	i0	44.6	3.91176470588235	65	28	94.1	2	11	202	22	79	WP_255309913.1 MULTISPECIES: tyrosinase family protein [Bacillus cereus group]	diamond	798	55.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
33156920	33156920	PRJNA492363_S_NODE_100952_length_201_cov_0.914286_g100131_i0	PRJNA492363	100952	201	0.914286	1.83771486	Macrococcoides caseolyticum JCSC54	69966	Bacteria	Bacteria	43.9	0.00375	NR	BAH18107.1	458233	g100131	i0	43.1	1.35820895522388	51	25	76.1	1	171	19	12	58	BAH18107.1 hypothetical protein MCCL_1400 [Macrococcoides caseolyticum JCSC5402]	diamond	273	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcoides	Macrococcoides caseolyticum

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