metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA682370" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA682370" 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
14693158	14693158	PRJNA682370_S_NODE_13852_length_193_cov_1.170886_g13240_i0	PRJNA682370	13852	193	1.170886	2.25980998	Bacillati	1783272	Bacteria	Bacteria	130	2.52e-37	NR	MRU65477.1	1280	g13240	i0	100	3.91709844559586	63	0	97.9	0	191	3	47	109	MRU65477.1 chromosomal replication initiation protein DnaA [Staphylococcus aureus]	diamond	756	130	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27208347	27208347	PRJNA682370_S_NODE_21802_length_156_cov_2.975207_g21190_i0	PRJNA682370	21802	156	2.975207	4.64132292	Streptococcus sp.	1306	Bacteria	Bacteria	64.7	8.76e-11	NR	MBK8157246.1	1306	g21190	i0	63.3	0.942307692307692	49	18	94.2	0	5	151	99	147	MBK8157246.1 hypothetical protein [Streptococcus sp.]	diamond	147	64.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
27757444	27757444	PRJNA682370_S_NODE_22884_length_154_cov_0.991597_g22272_i0	PRJNA682370	22884	154	0.991597	1.52705938	root	1	Root_unresolved	Root_unresolved	75.1	1.07e-15	NR	WP_207653160.1	1496	g22272	i0	84.2	1.48051948051948	38	6	74	0	1	114	87	124	WP_207653160.1 hypothetical protein, partial [Clostridioides difficile]	diamond	228	75.5	0.994701986754967	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
28471829	28471829	PRJNA682370_S_NODE_8446_length_258_cov_2.035874_g7834_i0	PRJNA682370	8446	258	2.035874	5.25255492	Listeria monocytogenes	1639	Bacteria	Bacteria	100	2.13e-24	NR	HAC3253152.1	1639	g7834	i0	63.4	0.953488372093023	82	30	95.3	0	256	11	104	185	HAC3253152.1 hypothetical protein [Listeria monocytogenes]	diamond	246	100	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28945586	28945586	PRJNA682370_S_NODE_8768_length_252_cov_1.760369_g8156_i0	PRJNA682370	8768	252	1.760369	4.43612988	Listeria monocytogenes	1639	Bacteria	Bacteria	119	1.16e-31	NR	HAC3253152.1	1639	g8156	i0	74.4	0.976190476190476	82	17	92.9	1	252	19	23	104	HAC3253152.1 hypothetical protein [Listeria monocytogenes]	diamond	246	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29904327	29904327	PRJNA682370_S_NODE_12271_length_206_cov_1.298246_g11659_i0	PRJNA682370	12271	206	1.298246	2.67438676	Bacillati	1783272	Bacteria	Bacteria	139	2.24e-41	NR	MDN8971977.1	1280	g11659	i0	98.5	1.98058252427184	68	1	99	0	1	204	18	85	MDN8971977.1 hypothetical protein [Staphylococcus aureus]	diamond	408	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30694070	30694070	PRJNA682370_S_NODE_20353_length_161_cov_1.087302_g19741_i0	PRJNA682370	20353	161	1.087302	1.75055622	root	1	Root_unresolved	Root_unresolved	63.9	2.82e-11	NR	WP_207653160.1	1496	g19741	i0	89.3	1.04347826086957	28	3	52.2	0	159	76	97	124	WP_207653160.1 hypothetical protein, partial [Clostridioides difficile]	diamond	168	64.3	0.993779160186625	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
31136111	31136111	PRJNA682370_S_NODE_24475_length_150_cov_1.513043_g23863_i0	PRJNA682370	24475	150	1.513043	2.2695645	Bacillati	1783272	Bacteria	Bacteria	95.5	3.81e-24	NR	KMS09603.1	1280	g23863	i0	98	2	50	1	100	0	150	1	36	85	KMS09603.1 hypothetical protein FE70_15090, partial [Staphylococcus aureus]	diamond	300	95.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31187651	31187651	PRJNA682370_S_NODE_19295_length_164_cov_1.697674_g18683_i0	PRJNA682370	19295	164	1.697674	2.78418536	Streptococcus sp.	1306	Bacteria	Bacteria	70.5	4.43e-13	NR	MBK8156571.1	1306	g18683	i0	72.7	1.60975609756098	44	12	80.5	0	150	19	117	160	MBK8156571.1 hypothetical protein [Streptococcus sp.]	diamond	264	70.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
31219209	31219209	PRJNA682370_S_NODE_14615_length_187_cov_1.763158_g14003_i0	PRJNA682370	14615	187	1.763158	3.29710546	Bacillus toyonensis	155322	Bacteria	Bacteria	132	4.47e-38	NR	MDF9451943.1	155322	g14003	i0	100	1.9572192513369	61	0	97.9	0	185	3	18	78	MDF9451943.1 hypothetical protein [Bacillus toyonensis]	diamond	366	132	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus toyonensis
31440912	31440912	PRJNA682370_S_NODE_17936_length_169_cov_2.895522_g17324_i0	PRJNA682370	17936	169	2.895522	4.89343218	Streptococcus sp.	1306	Bacteria	Bacteria	67.8	7.48e-12	NR	MBK8157246.1	1306	g17324	i0	50	1.13609467455621	64	24	99.4	2	2	169	10	73	MBK8157246.1 hypothetical protein [Streptococcus sp.]	diamond	192	67.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
32010389	32010389	PRJNA682370_S_NODE_2798_length_495_cov_392.530435_g2206_i0	PRJNA682370	2798	495	392.530435	1943.02565325	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	126	1.3499999999999999e-34	NR	WP_222114562.1	283734	g2206	i0	100	1.58181818181818	83	0	50.3	0	287	39	1	83	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	783	126	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
32737455	32737455	PRJNA682370_S_NODE_940_length_864_cov_302.525935_g566_i0	PRJNA682370	940	864	302.525935	2613.8240784	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	115	1.67e-28	NR	WP_222114562.1	283734	g566	i0	100	0.541666666666667	78	0	27.1	0	857	624	1	78	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	468	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius

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