metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA473641" 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
444891	444891	PRJNA473641_P_NODE_14861_length_269_cov_1.341837_g14778_i0	PRJNA473641	14861	269	1.341837	3.60954153	root	1	Root_unresolved	Root_unresolved	157	2e-47	NR	WP_260644777.1	1280	g14778	i0	75.3	32.3866171003717	89	22	99.3	0	3	269	9	97	WP_260644777.1 ribulose bisphosphate carboxylase small subunit [Staphylococcus aureus]	diamond	8712	157	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19570941	19570941	PRJNA473641_P_NODE_4216_length_435_cov_1.552486_g4133_i0	PRJNA473641	4216	435	1.552486	6.7533141	Clostridioides difficile	1496	Bacteria	Bacteria	125	1.09e-34	NR	MCU6128222.1	1496	g4133	i0	93.2	0.503448275862069	73	5	50.3	0	430	212	1	73	MCU6128222.1 hypothetical protein [Clostridioides difficile]	diamond	219	125	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
20846391	20846391	PRJNA473641_P_NODE_1177_length_730_cov_2.686454_g1104_i0	PRJNA473641	1177	730	2.686454	19.6111142	Bacillati	1783272	Bacteria	Bacteria	283	4.2899999999999997e-94	NR	WP_262469944.1	1496	g1104	i0	88.7	1.32739726027397	159	18	65.3	0	662	186	1	159	WP_262469944.1 pathogenesis-related BetVI family protein [Clostridioides difficile]	diamond	969	285	0.992982456140351	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29286576	29286576	PRJNA473641_P_NODE_1249_length_712_cov_2.104851_g1172_i0	PRJNA473641	1249	712	2.104851	14.98653912	Peptococcaceae bacterium CEB3	999898	Bacteria	Bacteria	110	6.870000000000001e-27	NR	KLU63339.1	999898	g1172	i0	52.2	0.484550561797753	115	55	48.5	0	499	155	10	124	KLU63339.1 hypothetical protein CEB3_c02620 [Peptococcaceae bacterium CEB3]	diamond	345	110	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae		Peptococcaceae bacterium CEB3
29366080	29366080	PRJNA473641_P_NODE_9449_length_322_cov_1.289157_g9366_i0	PRJNA473641	9449	322	1.289157	4.15108554	root	1	Root_unresolved	Root_unresolved	157	9.749999999999999e-47	NR	WP_236643868.1	1292	g9366	i0	72.5	7.06211180124224	109	26	99.7	3	1	321	27	133	WP_236643868.1 photosystem I protein PsaO, partial [Staphylococcus warneri]	diamond	2274	157	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
29570749	29570749	PRJNA473641_P_NODE_6370_length_370_cov_2.737374_g6287_i0	PRJNA473641	6370	370	2.737374	10.1282838	Clostridioides difficile	1496	Bacteria	Bacteria	201	7.49e-64	NR	WP_262469944.1	1496	g6287	i0	95.4	0.875675675675676	108	5	87.6	0	3	326	51	158	WP_262469944.1 pathogenesis-related BetVI family protein [Clostridioides difficile]	diamond	324	201	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
30724216	30724216	PRJNA473641_P_NODE_24914_length_242_cov_0.911243_g24831_i0	PRJNA473641	24914	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	52	5.31e-7	NR	MBO8631128.1	1280	g24831	i0	95.8	12.198347107438	24	1	29.8	0	3	74	12	35	MBO8631128.1 hypothetical protein [Staphylococcus aureus]	diamond	2952	52.4	0.99236641221374	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32574201	32574201	PRJNA473641_P_NODE_18539_length_250_cov_0.870056_g18456_i0	PRJNA473641	18539	250	0.870056	2.17514	Lysinibacillus sp. NPDC	1869345	Bacteria	Bacteria	43.1	0.0168	NR	WP_402865498.1	3364144	g18456	i0	45	0.48	40	19	44.4	1	13	123	115	154	WP_402865498.1 hypothetical protein [Lysinibacillus sp. NPDC097287]	diamond	120	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. NPDC097287

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