metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA964500" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA964500" 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	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
14969783	14969783	PRJNA964500_S_NODE_3752_length_277_cov_3.161290_g3660_i0	PRJNA964500	3752	277	3.16129	8.7567733	Staphylococcus aureus	1280	Bacteria	Bacteria	161	1.8999999999999997e-48	NR	WP_347134780.1	1280	g3660	i0	100	0.89891696750902494	83	0	89.9	273	25	61	143	WP_347134780.1 relaxase domain-containing protein, partial [Staphylococcus aureus]	diamond	249	161	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27531388	27531388	PRJNA964500_S_NODE_8343_length_201_cov_4.656977_g8251_i0	PRJNA964500	8343	201	4.656977	9.36052377	Staphylococcus aureus	1280	Bacteria	Bacteria	47	3.7e-5	NR	HDA7671954.1	1280	g8251	i0	100	0.298507462686567	20	0	29.9	177	118	1	20	HDA7671954.1 hypothetical protein [Staphylococcus aureus]	diamond	60	47	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
27878745	27878745	PRJNA964500_S_NODE_7025_length_216_cov_2.401070_g6933_i0	PRJNA964500	7025	216	2.40107	5.1863112	Staphylococcus aureus	1280	Bacteria	Bacteria	134	8.17e-39	NR	WP_347134789.1	1280	g6933	i0	98.5	0.930555555555556	67	1	93.1	203	3	1	67	WP_347134789.1 hypothetical protein [Staphylococcus aureus]	diamond	201	134	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28289001	28289001	PRJNA964500_S_NODE_12746_length_170_cov_2.695035_g12654_i0	PRJNA964500	12746	170	2.695035	4.5815595	Staphylococcus aureus	1280	Bacteria	Bacteria	100	9.16e-26	NR	WP_347134760.1	1280	g12654	i0	83	0.935294117647059	53	9	93.5	160	2	40	92	WP_347134760.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	159	100	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28573296	28573296	PRJNA964500_S_NODE_707_length_494_cov_54.419355_g629_i0	PRJNA964500	707	494	54.419355	268.8316137	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	124	7.759999999999999e-34	NR	WP_222114562.1	283734	g629	i0	98.8	1.02024291497976	84	1	51	277	26	1	84	WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius]	diamond	504	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
29236529	29236529	PRJNA964500_S_NODE_5069_length_246_cov_3.129032_g4977_i0	PRJNA964500	5069	246	3.129032	7.69741872	Bacillus velezensis	492670	Bacteria	Bacteria	161	1.59e-49	NR	WP_346611493.1	492670	g4977	i0	100	0.939024390243902	77	0	93.9	245	15	25	101	WP_346611493.1 hypothetical protein, partial [Bacillus velezensis]	diamond	231	161	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus velezensis
29741321	29741321	PRJNA964500_S_NODE_9050_length_195_cov_2.915663_g8958_i0	PRJNA964500	9050	195	2.915663	5.68554285	Thermoanaerobacterium thermosaccharolyticum	1517	Bacteria	Bacteria	73.9	1.21e-15	NR	WP_333508461.1	1517	g8958	i0	90.5	1.29230769230769	42	4	64.6	194	69	26	67	WP_333508461.1 hypothetical protein [Thermoanaerobacterium thermosaccharolyticum]	diamond	252	73.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
30815713	30815713	PRJNA964500_S_NODE_12394_length_172_cov_2.125874_g12302_i0	PRJNA964500	12394	172	2.125874	3.65650328	Staphylococcus aureus	1280	Bacteria	Bacteria	105	6.89e-25	NR	WP_347134746.1	1280	g12302	i0	98.1	0.924418604651163	53	1	92.4	13	171	39	91	WP_347134746.1 hypothetical protein [Staphylococcus aureus]	diamond	159	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31200806	31200806	PRJNA964500_S_NODE_17335_length_151_cov_1.663934_g17243_i0	PRJNA964500	17335	151	1.663934	2.51254034	Bacillati	1783272	Bacteria	Bacteria	47.4	2.5e-4	NR	WP_347134747.1	1280	g17243	i0	60	2.68211920529801	45	18	89.4	14	148	51	95	WP_347134747.1 RICIN domain-containing protein, partial [Staphylococcus aureus]	diamond	405	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31606098	31606098	PRJNA964500_S_NODE_13196_length_168_cov_1.359712_g13104_i0	PRJNA964500	13196	168	1.359712	2.28431616	Tissierellaceae bacterium	2562714	Bacteria	Bacteria	85.9	2.42e-20	NR	HZJ98490.1	2562714	g13104	i0	76	0.892857142857143	50	12	89.3	150	1	1	50	HZJ98490.1 hypothetical protein [Tissierellaceae bacterium]	diamond	150	85.9	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae		Tissierellaceae bacterium

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