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

8 rows where analysis = "diamond", bioproject = "PRJNA493234" 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
11933308	11933308	PRJNA493234_S_NODE_9470_length_316_cov_0.946502_g9377_i0	PRJNA493234	9470	316	0.946502	2.99094632	Lachnospiraceae bacterium oral taxon	1898203	Bacteria	Bacteria	208	6e-61	NR	EHO52930.1	861454	g9377	i0	98.1	0.987341772151899	104	2	98.7	0	314	3	10	113	EHO52930.1 hypothetical protein HMPREF9099_01115 [Lachnospiraceae bacterium oral taxon 082 str. F0431]	diamond	312	208	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium oral taxon 082
27834447	27834447	PRJNA493234_S_NODE_10564_length_306_cov_0.884120_g10471_i0	PRJNA493234	10564	306	0.88412	2.7054072	Listeria monocytogenes	1639	Bacteria	Bacteria	58.5	8.17e-9	NR	WP_207148867.1	1639	g10471	i0	73	0.362745098039216	37	10	36.3	0	7	117	44	80	WP_207148867.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	111	58.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28797522	28797522	PRJNA493234_S_NODE_1867_length_463_cov_2.230769_g1774_i0	PRJNA493234	1867	463	2.230769	10.32846047	FCB group	1783270	Bacteria	Bacteria	46.6	0.00466	NR	WP_262458101.1	1496	g1774	i0	32.5	1.84017278617711	117	72	73.9	3	399	58	33	145	WP_262458101.1 endonuclease/exonuclease/phosphatase family protein [Clostridioides difficile]	diamond	852	46.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29602333	29602333	PRJNA493234_S_NODE_22130_length_215_cov_4.387324_g22037_i0	PRJNA493234	22130	215	4.387324	9.4327466	Staphylococcus aureus	1280	Bacteria	Bacteria	63.5	3.96e-11	NR	MCS4580470.1	1280	g22037	i0	100	0.586046511627907	42	0	58.6	0	4	129	1	42	MCS4580470.1 hypothetical protein [Staphylococcus aureus]	diamond	126	63.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30392845	30392845	PRJNA493234_S_NODE_16973_length_259_cov_1.000000_g16880_i0	PRJNA493234	16973	259	1	2.59	Staphylococcus aureus	1280	Bacteria	Bacteria	54.7	1.27e-7	NR	QHG79981.1	1280	g16880	i0	62.9	0.405405405405405	35	13	40.5	0	259	155	38	72	QHG79981.1 hypothetical protein D7B62_12290 [Staphylococcus aureus]	diamond	105	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30771700	30771700	PRJNA493234_S_NODE_12894_length_287_cov_1.504673_g12801_i0	PRJNA493234	12894	287	1.504673	4.31841151	[Eubacterium] yurii	39498	Bacteria	Bacteria	183	7.4e-57	NR	SKC65989.1	39498	g12801	i0	96.8	0.993031358885017	95	3	99.3	0	285	1	11	105	SKC65989.1 Carboxysome shell and ethanolamine utilization microcompartment protein CcmL/EutN [[Eubacterium] yurii]	diamond	285	183	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Peptoanaerobacter	[Eubacterium] yurii
31435192	31435192	PRJNA493234_S_NODE_1596_length_482_cov_0.909535_g1504_i0	PRJNA493234	1596	482	0.909535	4.3839587	Staphylococcus aureus	1280	Bacteria	Bacteria	69.3	2.33e-12	NR	QHG79981.1	1280	g1504	i0	50	0.448132780082988	72	36	44.8	0	156	371	1	72	QHG79981.1 hypothetical protein D7B62_12290 [Staphylococcus aureus]	diamond	216	69.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32447879	32447879	PRJNA493234_S_NODE_14299_length_277_cov_1.063725_g14206_i0	PRJNA493234	14299	277	1.063725	2.94651825	Listeria monocytogenes	1639	Bacteria	Bacteria	65.5	1.09e-11	NR	WP_207148867.1	1639	g14206	i0	64.6	0.51985559566787	48	17	52	0	134	277	1	48	WP_207148867.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	144	65.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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