metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1111448" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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
16325517	16325517	PRJNA1111448_S_NODE_8073_length_630_cov_8.771993_g7322_i0	PRJNA1111448	8073	630	8.771993	55.2635559	root	1	Root_unresolved	Root_unresolved	414	7.69e-131	NR	WP_306789577.1	1280	g7322	i0	100	45.7809523809524	209	0	99.5	0	629	3	825	1033	WP_306789577.1 type II CRISPR RNA-guided endonuclease Cas9 [Staphylococcus aureus]	diamond	28842	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
26972834	26972834	PRJNA1111448_S_NODE_110102_length_261_cov_1.218085_g109279_i0	PRJNA1111448	110102	261	1.218085	3.17920185	Aedoeadaptatus coxii	755172	Bacteria	Bacteria	186	2.31e-58	NR	WP_068369379.1	755172	g109279	i0	98.8	0.988505747126437	86	1	98.9	0	259	2	40	125	WP_068369379.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Aedoeadaptatus coxii]	diamond	258	186	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Aedoeadaptatus	Aedoeadaptatus coxii
27754239	27754239	PRJNA1111448_S_NODE_140324_length_238_cov_2.824242_g139501_i0	PRJNA1111448	140324	238	2.824242	6.72169596	Dorea	189330	Bacteria	Bacteria	43.1	0.0037200000000000002	NR	RGC52711.1	88431	g139501	i0	42.2	1.13445378151261	45	25	56.7	1	222	88	31	74	RGC52711.1 hypothetical protein DW690_27965 [Dorea longicatena]	diamond	270	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Dorea	Dorea longicatena
28299495	28299495	PRJNA1111448_S_NODE_94506_length_278_cov_1.126829_g93683_i0	PRJNA1111448	94506	278	1.126829	3.13258462	Sporolactobacillus shoreicorticis	1923877	Bacteria	Bacteria	43.1	0.0422	NR	WP_253058382.1	1923877	g93683	i0	44.2	0.561151079136691	52	28	55	1	39	191	77	128	WP_253058382.1 sigma 54-interacting transcriptional regulator [Sporolactobacillus shoreicorticis]	diamond	156	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Sporolactobacillaceae	Sporolactobacillus	Sporolactobacillus shoreicorticis
28804501	28804501	PRJNA1111448_S_NODE_87588_length_286_cov_1.431925_g86765_i0	PRJNA1111448	87588	286	1.431925	4.0953055	Desulfitobacterium	36853	Bacteria	Bacteria	43.5	0.0328	NR	WP_014792319.1	36853	g86765	i0	34.9	0.660839160839161	63	40	65	1	68	253	318	380	WP_014792319.1 MULTISPECIES: aldehyde dehydrogenase family protein [Desulfitobacterium]	diamond	189	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfitobacterium
29183810	29183810	PRJNA1111448_S_NODE_121049_length_251_cov_0.865169_g120226_i0	PRJNA1111448	121049	251	0.865169	2.17157419	Dialister sp.	1955814	Bacteria	Bacteria	42.7	0.0415	NR	MDU5281008.1	1955814	g120226	i0	34.3	0.800796812749004	67	37	80.1	1	202	2	456	515	MDU5281008.1 type I DNA topoisomerase [Dialister sp.]	diamond	201	42.7	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Dialister	Dialister sp.
29404686	29404686	PRJNA1111448_S_NODE_137349_length_242_cov_0.911243_g136526_i0	PRJNA1111448	137349	242	0.911243	2.20520806	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0143	NR	MBR3018279.1	2044939	g136526	i0	35.8	0.830578512396694	67	40	80.6	2	240	46	27	92	MBR3018279.1 SDR family oxidoreductase [Clostridia bacterium]	diamond	201	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29688496	29688496	PRJNA1111448_S_NODE_129650_length_246_cov_0.890173_g128827_i0	PRJNA1111448	129650	246	0.890173	2.18982558	Weissella cibaria	137591	Bacteria	Bacteria	42	0.0355	NR	WP_196777313.1	137591	g128827	i0	54.8	0.890243902439024	73	20	85.4	5	225	16	22	84	WP_196777313.1 hypothetical protein, partial [Weissella cibaria]	diamond	219	42	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
30004735	30004735	PRJNA1111448_S_NODE_119971_length_251_cov_1.730337_g119148_i0	PRJNA1111448	119971	251	1.730337	4.34314587	Clostridia bacterium	2044939	Bacteria	Bacteria	129	1.06e-32	NR	MBQ8407404.1	2044939	g119148	i0	89	0.872509960159363	73	8	87.3	0	220	2	1	73	MBQ8407404.1 ABC transporter ATP-binding protein [Clostridia bacterium]	diamond	219	129	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30130663	30130663	PRJNA1111448_S_NODE_81632_length_294_cov_0.760181_g80809_i0	PRJNA1111448	81632	294	0.760181	2.23493214	Streptococcus anginosus	1328	Bacteria	Bacteria	46.6	0.0028	NR	WP_330942626.1	1328	g80809	i0	45.7	0.469387755102041	46	25	46.9	0	293	156	328	373	WP_330942626.1 hypothetical protein [Streptococcus anginosus]	diamond	138	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
31449611	31449611	PRJNA1111448_S_NODE_56296_length_334_cov_6.750958_g55473_i0	PRJNA1111448	56296	334	6.750958	22.54819972	root	1	Root_unresolved	Root_unresolved	87	3.83e-20	NR	WP_369599335.1	1590	g55473	i0	100	77.5958083832335	40	0	35.9	0	332	213	20	59	WP_369599335.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	25917	87	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
31616422	31616422	PRJNA1111448_S_NODE_34396_length_393_cov_1.203125_g33573_i0	PRJNA1111448	34396	393	1.203125	4.72828125	Tissierellaceae bacterium	2562714	Bacteria	Bacteria	248	7.209999999999998e-82	NR	HZJ99966.1	2562714	g33573	i0	96.9	0.99236641221374	130	4	99.2	0	392	3	44	173	HZJ99966.1 hypothetical protein [Tissierellaceae bacterium]	diamond	390	248	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);;