metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA774958" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA774958" 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
26863881	26863881	PRJNA774958_P_NODE_32041_length_259_cov_1.193548_g31794_i0	PRJNA774958	32041	259	1.193548	3.09128932	Clostridia bacterium	2044939	Bacteria	Bacteria	43.9	0.0188	NR	MBR2020077.1	2044939	g31794	i0	41	0.451737451737452	39	23	45.2	0	131	247	416	454	MBR2020077.1 hypothetical protein [Clostridia bacterium]	diamond	117	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27369787	27369787	PRJNA774958_P_NODE_33323_length_251_cov_0.865169_g33076_i0	PRJNA774958	33323	251	0.865169	2.17157419	Peptococcaceae bacterium	2052179	Bacteria	Bacteria	53.1	8.83e-6	NR	MBQ2369403.1	2052179	g33076	i0	36.4	1.75697211155378	77	49	92	0	233	3	632	708	MBQ2369403.1 RNA-binding transcriptional accessory protein [Peptococcaceae bacterium]	diamond	441	53.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae		Peptococcaceae bacterium
28064041	28064041	PRJNA774958_P_NODE_18785_length_371_cov_1.285235_g18538_i0	PRJNA774958	18785	371	1.285235	4.76822185	Clostridiaceae bacterium	1898204	Bacteria	Bacteria	43.9	0.0406	NR	MEQ8196678.1	1898204	g18538	i0	33.7	0.719676549865229	89	48	63.9	3	327	91	98	185	MEQ8196678.1 tRNA (guanosine(46)-N7)-methyltransferase TrmB [Clostridiaceae bacterium]	diamond	267	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium
28506168	28506168	PRJNA774958_P_NODE_39427_length_227_cov_2.922078_g39180_i0	PRJNA774958	39427	227	2.922078	6.63311706	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	44.3	0.00857	NR	MBE6951160.1	2485925	g39180	i0	40	0.52863436123348	40	24	52.9	0	219	100	49	88	MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	120	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28569198	28569198	PRJNA774958_P_NODE_18047_length_379_cov_6.003268_g17800_i0	PRJNA774958	18047	379	6.003268	22.75238572	Clostridium lundense	319475	Bacteria	Bacteria	135	2.38e-38	NR	WP_027623586.1	319475	g17800	i0	56.8	5.46965699208443	118	49	91.8	1	32	379	2	119	WP_027623586.1 RidA family protein [Clostridium lundense]	diamond	2073	135	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium lundense
29399643	29399643	PRJNA774958_P_NODE_21829_length_338_cov_1.550943_g21582_i0	PRJNA774958	21829	338	1.550943	5.24218734	root	1	Root_unresolved	Root_unresolved	44.3	0.0288	NR	MDD3206133.1	1898203	g21582	i0	29.2	1.52662721893491	96	55	85.2	3	24	311	101	183	MDD3206133.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	516	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29968135	29968135	PRJNA774958_P_NODE_16191_length_403_cov_1.942424_g15944_i0	PRJNA774958	16191	403	1.942424	7.82796872	Carboxydothermus	129957	Bacteria	Bacteria	118	2.3899999999999993e-31	NR	WP_011343424.1	129957	g15944	i0	60	1.35483870967742	90	36	67	0	270	1	6	95	WP_011343424.1 MULTISPECIES: glycine cleavage system protein GcvH [Carboxydothermus]	diamond	546	118	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Carboxydothermus
32276106	32276106	PRJNA774958_P_NODE_9718_length_525_cov_1.418142_g9475_i0	PRJNA774958	9718	525	1.418142	7.4452455	Cohnella	329857	Bacteria	Bacteria	112	4.66e-28	NR	WP_204602556.1	768479	g9475	i0	42.3	1.50857142857143	130	75	74.3	0	419	30	23	152	WP_204602556.1 acyl-CoA thioesterase [Cohnella boryungensis]	diamond	792	113	0.991150442477876	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella boryungensis
32361537	32361537	PRJNA774958_P_NODE_35399_length_247_cov_1.327586_g35152_i0	PRJNA774958	35399	247	1.327586	3.27913742	Oscillibacter sp.	1945593	Bacteria	Bacteria	40.4	0.0384	NR	WP_293279915.1	1945593	g35152	i0	54.1	0.449392712550607	37	12	44.9	1	97	207	13	44	WP_293279915.1 hypothetical protein, partial [Oscillibacter sp.]	diamond	111	40.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Oscillibacter	Oscillibacter 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);;