metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA561138" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA561138" 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
27995133	27995133	PRJNA561138_P_NODE_13045_length_362_cov_1.093426_g12850_i0	PRJNA561138	13045	362	1.093426	3.95820212	Bacillus sp. FSL W8-	2954627	Bacteria	Bacteria	147	7.2e-40	NR	WP_341026961.1	2954627	g12850	i0	61	3.90331491712707	118	45	97	1	1	351	311	428	WP_341026961.1 restriction endonuclease [Bacillus sp. FSL W8-0645]	diamond	1413	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FSL W8-0645
29257785	29257785	PRJNA561138_P_NODE_27369_length_246_cov_0.890173_g27174_i0	PRJNA561138	27369	246	0.890173	2.18982558	Bacilli bacterium	1903720	Bacteria	Bacteria	64.3	9.76e-10	NR	MEG1494751.1	1903720	g27174	i0	43.6	0.951219512195122	78	41	93.9	2	11	241	731	806	MEG1494751.1 hypothetical protein [Bacilli bacterium]	diamond	234	64.3	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
29826225	29826225	PRJNA561138_P_NODE_12471_length_369_cov_1.135135_g12276_i0	PRJNA561138	12471	369	1.135135	4.18864815	Enterococcus faecium	1352	Bacteria	Bacteria	139	6.92e-39	NR	WP_230206348.1	1352	g12276	i0	94.6	0.601626016260163	74	4	60.2	0	367	146	135	208	WP_230206348.1 hypothetical protein, partial [Enterococcus faecium]	diamond	222	139	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
29857887	29857887	PRJNA561138_P_NODE_28951_length_243_cov_0.905882_g28756_i0	PRJNA561138	28951	243	0.905882	2.20129326	Candidatus Fimenecus sp.	3022888	Bacteria	Bacteria	56.2	6.29e-7	NR	MDY4909386.1	3022888	g28756	i0	32.6	1.09876543209877	89	50	97.5	2	4	240	116	204	MDY4909386.1 LPD28 domain-containing protein [Candidatus Fimenecus sp.]	diamond	267	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia			Candidatus Fimenecus	Candidatus Fimenecus sp.
32559416	32559416	PRJNA561138_P_NODE_24519_length_251_cov_0.865169_g24324_i0	PRJNA561138	24519	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	99	3.1e-23	NR	WP_209465717.1	557451	g24324	i0	58.1	4.49402390438247	74	31	88.4	0	3	224	173	246	WP_209465717.1 VOC family protein [Symbiobacterium terraclitae]	diamond	1128	100	0.99	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae	Symbiobacterium	Symbiobacterium terraclitae

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