metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA760976" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA760976" 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
18594058	18594058	PRJNA760976_P_NODE_43715_length_261_cov_2.377660_g43394_i0	PRJNA760976	43715	261	2.37766	6.2056926	Natranaerovirga hydrolytica	680378	Bacteria	Bacteria	63.2	3.13e-9	NR	WP_132282290.1	680378	g43394	i0	42.9	3.08045977011494	70	40	80.5	0	52	261	634	703	WP_132282290.1 glycosyltransferase [Natranaerovirga hydrolytica]	diamond	804	63.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Natranaerovirgaceae	Natranaerovirga	Natranaerovirga hydrolytica
27969101	27969101	PRJNA760976_P_NODE_29145_length_305_cov_3.310345_g28824_i0	PRJNA760976	29145	305	3.310345	10.09655225	Brevibacillus daliensis	2892995	Bacteria	Bacteria	45.8	0.00599	NR	WP_232696529.1	2892995	g28824	i0	29.5	1.0327868852459	105	62	91.5	4	302	24	286	390	WP_232696529.1 NO-inducible flavohemoprotein [Brevibacillus daliensis]	diamond	315	45.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus daliensis
28253213	28253213	PRJNA760976_P_NODE_51166_length_246_cov_0.890173_g50845_i0	PRJNA760976	51166	246	0.890173	2.18982558	Eremococcus coleocola	88132	Bacteria	Bacteria	139	1.0799999999999998e-37	NR	WP_006419019.1	88132	g50845	i0	87.8	1	82	10	100	0	1	246	93	174	WP_006419019.1 thiolase family protein [Eremococcus coleocola]	diamond	246	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Eremococcus	Eremococcus coleocola
28663817	28663817	PRJNA760976_P_NODE_11547_length_426_cov_1.152975_g11227_i0	PRJNA760976	11547	426	1.152975	4.9116735	Paenibacillus tengchongensis	2608684	Bacteria	Bacteria	73.6	1.78e-12	NR	WP_151737566.1	2608684	g11227	i0	32.7	1.03521126760563	147	92	98.6	4	420	1	5	151	WP_151737566.1 carbonic anhydrase [Paenibacillus tengchongensis]	diamond	441	73.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus tengchongensis
28894322	28894322	PRJNA760976_P_NODE_48708_length_249_cov_2.545455_g48387_i0	PRJNA760976	48708	249	2.545455	6.33818295	Clostridium	1485	Bacteria	Bacteria	71.2	4.37e-13	NR	WP_332563247.1	1506	g48387	i0	48.1	2.65060240963855	77	40	92.8	0	246	16	27	103	WP_332563247.1 ferritin-like domain-containing protein [Clostridium sp.]	diamond	660	71.6	0.994413407821229	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
29904992	29904992	PRJNA760976_P_NODE_1651_length_979_cov_1.615894_g1412_i0	PRJNA760976	1651	979	1.615894	15.81960226	root	1	Root_unresolved	Root_unresolved	105	7.480000000000001e-21	NR	WP_073009723.1	1121298	g1412	i0	84.2	2.08988764044944	57	9	17.5	0	1	171	686	742	WP_073009723.1 formate C-acetyltransferase [Clostridium amylolyticum]	diamond	2046	105	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium amylolyticum
31073937	31073937	PRJNA760976_P_NODE_41415_length_267_cov_2.350515_g41094_i0	PRJNA760976	41415	267	2.350515	6.27587505	Bacillaceae	186817	Bacteria	Bacteria	127	2.19e-33	NR	WP_328164171.1	135735	g41094	i0	66.7	3.79775280898876	84	28	94.4	0	16	267	160	243	WP_328164171.1 DMT family transporter [Priestia endophytica]	diamond	1014	127	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia endophytica
31317059	31317059	PRJNA760976_P_NODE_40995_length_269_cov_1.142857_g40674_i0	PRJNA760976	40995	269	1.142857	3.07428533	Desnuesiella massiliensis	1650662	Bacteria	Bacteria	105	4.51e-24	NR	WP_055669362.1	1650662	g40674	i0	53.9	0.992565055762082	89	41	99.3	0	267	1	257	345	WP_055669362.1 DUF3794 and LysM peptidoglycan-binding domain-containing protein [Desnuesiella massiliensis]	diamond	267	105	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Desnuesiella	Desnuesiella massiliensis
31358488	31358488	PRJNA760976_P_NODE_38856_length_275_cov_0.787129_g38535_i0	PRJNA760976	38856	275	0.787129	2.16460475	FCB group	1783270	Bacteria	Bacteria	46.6	0.00246	NR	MCI5863028.1	1898203	g38535	i0	36.1	2.50909090909091	72	43	75.3	2	212	6	375	446	MCI5863028.1 RICIN domain-containing protein [Lachnospiraceae bacterium]	diamond	690	46.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32361279	32361279	PRJNA760976_P_NODE_53339_length_244_cov_0.859649_g53018_i0	PRJNA760976	53339	244	0.859649	2.09754356	Clostridium tunisiense	219748	Bacteria	Bacteria	57.8	3.04e-9	NR	WP_017414399.1	219748	g53018	i0	96.3	0.331967213114754	27	1	33.2	0	3	83	14	40	WP_017414399.1 hypothetical protein [Clostridium tunisiense]	diamond	81	57.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium tunisiense
32465821	32465821	PRJNA760976_P_NODE_8199_length_485_cov_2.563107_g7880_i0	PRJNA760976	8199	485	2.563107	12.43106895	root	1	Root_unresolved	Root_unresolved	120	2.98e-28	NR	WP_300302390.1	1872527	g7880	i0	62.2	8.98762886597938	90	34	55.7	0	359	90	3	92	WP_300302390.1 hydroxylamine reductase [Anaerosolibacter sp.]	diamond	4359	121	0.991735537190083	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Thermotaleaceae	Anaerosolibacter	Anaerosolibacter sp.

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