metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA330616" 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
15692470	15692470	PRJNA330616_P_NODE_30993_length_162_cov_0.902655_g30584_i0	PRJNA330616	30993	162	0.902655	1.4623011	Bacillati	1783272	Bacteria	Bacteria	93.6	4.72e-22	NR	NLW29482.1	38403	g30584	i0	77.4	18.4814814814815	53	12	98.1	0	3	161	133	185	NLW29482.1 superoxide dismutase [Erysipelothrix sp.]	diamond	2994	94.4	0.991525423728813	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix sp.
16967257	16967257	PRJNA330616_P_NODE_8774_length_280_cov_1.450216_g8365_i0	PRJNA330616	8774	280	1.450216	4.0606048	FCB group	1783270	Bacteria	Bacteria	154	3.9399999999999996e-42	NR	WP_390302589.1	202260	g8365	i0	79.3	13.8535714285714	92	19	98.6	0	5	280	328	419	WP_390302589.1 aldehyde dehydrogenase family protein [Virgibacillus sediminis]	diamond	3879	154	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus sediminis
17647000	17647000	PRJNA330616_P_NODE_30334_length_163_cov_0.894737_g29925_i0	PRJNA330616	30334	163	0.894737	1.45842131	Bacillota	1239	Bacteria	Bacteria	60.1	6.92e-9	NR	MCQ8264833.1	1307	g29925	i0	55.6	7.26993865030675	54	24	99.4	0	163	2	3	56	MCQ8264833.1 Cof-type HAD-IIB family hydrolase [Streptococcus suis]	diamond	1185	60.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
26789893	26789893	PRJNA330616_P_NODE_21461_length_182_cov_2.300752_g21052_i0	PRJNA330616	21461	182	2.300752	4.18736864	Carnobacterium maltaromaticum LMA28	1234679	Bacteria	Bacteria	43.9	0.00196	NR	CCO09713.2	1234679	g21052	i0	53.5	1.36813186813187	43	18	67.6	1	3	125	72	114	CCO09713.2 putative uncharacterized protein [Carnobacterium maltaromaticum LMA28]	diamond	249	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
26884946	26884946	PRJNA330616_P_NODE_29661_length_163_cov_1.333333_g29252_i0	PRJNA330616	29661	163	1.333333	2.17333279	Solibacillus	648800	Bacteria	Bacteria	61.2	3.78e-9	NR	WP_051032377.1	648800	g29252	i0	48.1	1.98773006134969	54	28	99.4	0	1	162	264	317	WP_051032377.1 MULTISPECIES: Ig-like domain-containing protein [Solibacillus]	diamond	324	61.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Solibacillus
27295874	27295874	PRJNA330616_P_NODE_25683_length_167_cov_0.864407_g25274_i0	PRJNA330616	25683	167	0.864407	1.44355969	Bacillaceae	186817	Bacteria	Bacteria	112	2.8700000000000003e-27	NR	WP_098429757.1	186817	g25274	i0	94.5	0.988023952095808	55	3	98.8	0	1	165	241	295	WP_098429757.1 MULTISPECIES: stage IV sporulation protein A [Bacillaceae]	diamond	165	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae
27439858	27439858	PRJNA330616_P_NODE_1463_length_766_cov_4.354254_g1112_i0	PRJNA330616	1463	766	4.354254	33.35358564	Paenibacillus	44249	Bacteria	Bacteria	126	8.869999999999999e-31	NR	MEV2911048.1	1464	g1112	i0	44.5	5.51436031331593	155	75	60.3	4	766	305	151	295	MEV2911048.1 ATP-binding protein [Paenibacillus larvae]	diamond	4224	127	0.992125984251969	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus larvae
27516981	27516981	PRJNA330616_P_NODE_27223_length_166_cov_0.871795_g26814_i0	PRJNA330616	27223	166	0.871795	1.4471797	[Clostridium] innocuum	1522	Bacteria	Bacteria	52	2.31e-6	NR	WP_156113313.1	1522	g26814	i0	48.1	0.939759036144578	52	25	94	2	1	156	79	128	WP_156113313.1 hypothetical protein, partial [[Clostridium] innocuum]	diamond	156	52	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
28291893	28291893	PRJNA330616_P_NODE_24126_length_172_cov_1.406504_g23717_i0	PRJNA330616	24126	172	1.406504	2.41918688	Bacteria	2	Bacteria	Bacteria	119	1.38e-29	NR	WP_088001897.1	1516104	g23717	i0	100	1.98837209302326	57	0	99.4	0	1	171	568	624	WP_088001897.1 TOMM precursor leader peptide-binding protein [Gottfriedia solisilvae]	diamond	342	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia solisilvae
28607777	28607777	PRJNA330616_P_NODE_31547_length_162_cov_0.902655_g31138_i0	PRJNA330616	31547	162	0.902655	1.4623011	Gottfriedia	2837503	Bacteria	Bacteria	102	1.07e-25	NR	WP_025671591.1	186817	g31138	i0	88.9	2	54	6	100	0	1	162	119	172	WP_025671591.1 MULTISPECIES: GNAT family N-acetyltransferase [Bacillaceae]	diamond	324	103	0.990291262135922	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae
29207881	29207881	PRJNA330616_P_NODE_25729_length_167_cov_0.864407_g25320_i0	PRJNA330616	25729	167	0.864407	1.44355969	Anaerococcus	165779	Bacteria	Bacteria	103	3.16e-24	NR	WP_015777408.1	33034	g25320	i0	94.5	1.97604790419162	55	3	98.8	0	167	3	140	194	WP_015777408.1 ClC family H(+)/Cl(-) exchange transporter [Anaerococcus prevotii]	diamond	330	103	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
29712497	29712497	PRJNA330616_P_NODE_30910_length_162_cov_0.902655_g30501_i0	PRJNA330616	30910	162	0.902655	1.4623011	Bacillaceae	186817	Bacteria	Bacteria	83.2	1.27e-18	NR	WP_088041702.1	1978338	g30501	i0	86.7	1.64814814814815	45	6	83.3	0	2	136	24	68	WP_088041702.1 divergent PAP2 family protein [Bacillus sp. EAC]	diamond	267	84	0.990476190476191	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. EAC
30060159	30060159	PRJNA330616_P_NODE_32031_length_161_cov_0.910714_g31622_i0	PRJNA330616	32031	161	0.910714	1.46624954	FCB group	1783270	Bacteria	Bacteria	87.4	5.42e-19	NR	WP_093134536.1	237682	g31622	i0	71.2	16.472049689441	52	15	96.9	0	160	5	64	115	WP_093134536.1 TIGR01777 family oxidoreductase [Salinibacillus kushneri]	diamond	2652	88.2	0.99092970521542	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salinibacillus	Salinibacillus kushneri
30200749	30200749	PRJNA330616_P_NODE_32292_length_161_cov_0.910714_g31883_i0	PRJNA330616	32292	161	0.910714	1.46624954	Bacillus sp. AFS	2033505	Bacteria	Bacteria	72.4	4.17e-13	NR	WP_176547352.1	2033505	g31883	i0	56.6	1.97515527950311	53	23	98.8	0	161	3	239	291	WP_176547352.1 recombinase family protein [Bacillus sp. AFS053548]	diamond	318	72.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. AFS053548
30737991	30737991	PRJNA330616_P_NODE_28754_length_164_cov_0.886957_g28345_i0	PRJNA330616	28754	164	0.886957	1.45460948	Gottfriedia solisilvae	1516104	Bacteria	Bacteria	70.9	1.53e-12	NR	WP_088001897.1	1516104	g28345	i0	82.9	0.75	41	7	75	0	42	164	1	41	WP_088001897.1 TOMM precursor leader peptide-binding protein [Gottfriedia solisilvae]	diamond	123	70.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia solisilvae
31623191	31623191	PRJNA330616_P_NODE_96_length_2336_cov_42.039353_g66_i0	PRJNA330616	96	2336	42.039353	982.03928608	Clostridia bacterium	2044939	Bacteria	Bacteria	59.3	7.59e-6	NR	MBQ4120586.1	2044939	g66	i0	31.6	0.585616438356164	114	70	14.6	2	586	245	48	153	MBQ4120586.1 lytic transglycosylase domain-containing protein [Clostridia bacterium]	diamond	1368	59.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31907902	31907902	PRJNA330616_P_NODE_25397_length_167_cov_1.669492_g24988_i0	PRJNA330616	25397	167	1.669492	2.78805164	Koleobacter methoxysyntrophicus	2751313	Bacteria	Bacteria	41.2	0.046	NR	WP_206709363.1	2751313	g24988	i0	46.3	0.736526946107784	41	20	70.1	1	157	41	164	204	WP_206709363.1 regulatory iron-sulfur-containing complex subunit RicT [Koleobacter methoxysyntrophicus]	diamond	123	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Koleobacterales	Koleobacteraceae	Koleobacter	Koleobacter methoxysyntrophicus
32319572	32319572	PRJNA330616_P_NODE_7119_length_312_cov_2.288973_g6710_i0	PRJNA330616	7119	312	2.288973	7.14159576	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	119	1.1e-32	NR	WP_222114562.1	283734	g6710	i0	97.5	1.55769230769231	81	2	77.9	0	244	2	1	81	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	486	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
32558327	32558327	PRJNA330616_P_NODE_28859_length_164_cov_0.886957_g28450_i0	PRJNA330616	28859	164	0.886957	1.45460948	Bacillaceae	186817	Bacteria	Bacteria	125	2.3699999999999998e-32	NR	WP_087997854.1	1516104	g28450	i0	100	1.97560975609756	54	0	98.8	0	164	3	395	448	WP_087997854.1 glucose-6-phosphate dehydrogenase [Gottfriedia solisilvae]	diamond	324	125	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia solisilvae
32603839	32603839	PRJNA330616_P_NODE_16340_length_207_cov_1.329114_g15931_i0	PRJNA330616	16340	207	1.329114	2.75126598	Marinococcus halophilus	1371	Bacteria	Bacteria	42.4	0.0256	NR	WP_079475810.1	1371	g15931	i0	40.7	0.782608695652174	54	29	78.3	1	171	10	39	89	WP_079475810.1 3-isopropylmalate dehydratase small subunit [Marinococcus halophilus]	diamond	162	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Marinococcus	Marinococcus halophilus

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