metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA864829" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA864829" 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
20363237	20363237	PRJNA864829_S_NODE_4356_length_278_cov_2.502183_g4270_i0	PRJNA864829	4356	278	2.502183	6.95606874	Faecalicatena contorta	39482	Bacteria	Bacteria	62	8.48e-11	NR	PWJ48915.1	39482	g4270	i0	93.3	0.323741007194245	30	2	32.4	0	184	273	1	30	PWJ48915.1 hypothetical protein A8805_10956 [Faecalicatena contorta]	diamond	90	62	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Faecalicatena	Faecalicatena contorta
26991629	26991629	PRJNA864829_S_NODE_6042_length_246_cov_1.624365_g5956_i0	PRJNA864829	6042	246	1.624365	3.9959379	Bacilli bacterium	1903720	Bacteria	Bacteria	127	6.249999999999998e-32	NR	MDD3341693.1	1903720	g5956	i0	77.8	0.878048780487805	72	16	87.8	0	242	27	679	750	MDD3341693.1 phosphoketolase family protein [Bacilli bacterium]	diamond	216	127	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27371482	27371482	PRJNA864829_S_NODE_9803_length_201_cov_1.098684_g9717_i0	PRJNA864829	9803	201	1.098684	2.20835484	Bacilli bacterium	1903720	Bacteria	Bacteria	95.1	7.530000000000001e-21	NR	MEI3499095.1	1903720	g9717	i0	83.7	1.49253731343284	49	8	73.1	0	199	53	199	247	MEI3499095.1 LTA synthase family protein [Bacilli bacterium]	diamond	300	95.1	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
27971069	27971069	PRJNA864829_S_NODE_4405_length_277_cov_2.070175_g4319_i0	PRJNA864829	4405	277	2.070175	5.73438475	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	45.1	0.0078	NR	MBP3411900.1	2485925	g4319	i0	40	0.595667870036101	55	31	57.4	1	257	99	183	237	MBP3411900.1 tRNA dihydrouridine synthase DusB [Oscillospiraceae bacterium]	diamond	165	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28791845	28791845	PRJNA864829_S_NODE_10387_length_196_cov_2.210884_g10301_i0	PRJNA864829	10387	196	2.210884	4.33333264	Clostridia bacterium	2044939	Bacteria	Bacteria	55.1	8.4e-7	NR	MBO5910446.1	2044939	g10301	i0	45.5	0.841836734693878	55	30	84.2	0	12	176	283	337	MBO5910446.1 sel1 repeat family protein [Clostridia bacterium]	diamond	165	55.1	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28791846	28791846	PRJNA864829_S_NODE_13487_length_175_cov_1.269841_g13401_i0	PRJNA864829	13487	175	1.269841	2.22222175	Tissierellia bacterium KA	2049431	Bacteria	Bacteria	104	1.7e-26	NR	KXB45279.1	1588751	g13401	i0	100	0.994285714285714	58	0	99.4	0	174	1	76	133	KXB45279.1 ATP synthase, subunit E [Tissierellia bacterium KA00581]	diamond	174	104	1	Bacteria	Bacillati	Bacillota	Tissierellia				Tissierellia bacterium KA00581
28886649	28886649	PRJNA864829_S_NODE_9408_length_204_cov_2.800000_g9322_i0	PRJNA864829	9408	204	2.8	5.712	Clostridium amylolyticum	1121298	Bacteria	Bacteria	132	1.8e-37	NR	WP_073009000.1	1121298	g9322	i0	97	0.985294117647059	67	2	98.5	0	203	3	22	88	WP_073009000.1 NYN domain-containing protein [Clostridium amylolyticum]	diamond	201	132	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium amylolyticum
29076365	29076365	PRJNA864829_S_NODE_13648_length_174_cov_1.184000_g13562_i0	PRJNA864829	13648	174	1.184	2.06016	Selenomonas sp. oral taxon 149 str. 67H29BP	864563	Bacteria	Bacteria	39.7	0.0237	NR	EFM24372.1	864563	g13562	i0	52.6	0.655172413793103	38	18	65.5	0	24	137	10	47	EFM24372.1 hypothetical protein HMPREF9166_0012 [Selenomonas sp. oral taxon 149 str. 67H29BP]	diamond	114	39.7	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp. oral taxon 149
29234150	29234150	PRJNA864829_S_NODE_4449_length_276_cov_1.898678_g4363_i0	PRJNA864829	4449	276	1.898678	5.24035128	Clostridium amylolyticum	1121298	Bacteria	Bacteria	176	4.46e-51	NR	WP_242949014.1	1121298	g4363	i0	98.9	0.989130434782609	91	1	98.9	0	3	275	83	173	WP_242949014.1 flavocytochrome c [Clostridium amylolyticum]	diamond	273	176	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium amylolyticum
30308374	30308374	PRJNA864829_S_NODE_10052_length_199_cov_1.440000_g9966_i0	PRJNA864829	10052	199	1.44	2.8656	Bacilli bacterium	1903720	Bacteria	Bacteria	48.9	1.41e-4	NR	HOI47073.1	1903720	g9966	i0	26.3	1.82412060301508	57	42	85.9	0	29	199	311	367	HOI47073.1 ABC transporter permease subunit [Bacilli bacterium]	diamond	363	48.9	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
30592160	30592160	PRJNA864829_S_NODE_4493_length_275_cov_2.353982_g4407_i0	PRJNA864829	4493	275	2.353982	6.4734505	Clostridium perfringens	1502	Bacteria	Bacteria	129	3.27e-33	NR	WP_272453523.1	1502	g4407	i0	69.7	0.970909090909091	89	27	97.1	0	2	268	78	166	WP_272453523.1 DUF4433 domain-containing protein [Clostridium perfringens]	diamond	267	129	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
31003057	31003057	PRJNA864829_S_NODE_10154_length_198_cov_2.107383_g10068_i0	PRJNA864829	10154	198	2.107383	4.17261834	Erysipelothrix sp.	38403	Bacteria	Bacteria	47.8	3.44e-4	NR	NLA78563.1	38403	g10068	i0	50	0.575757575757576	38	19	57.6	0	115	2	17	54	NLA78563.1 F0F1 ATP synthase subunit alpha [Erysipelothrix sp.]	diamond	114	47.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix sp.
32236825	32236825	PRJNA864829_S_NODE_10198_length_198_cov_1.073826_g10112_i0	PRJNA864829	10198	198	1.073826	2.12617548	[Clostridium] innocuum	1522	Bacteria	Bacteria	43.5	0.011	NR	WP_233106945.1	1522	g10112	i0	38.2	0.833333333333333	55	30	83.3	1	28	192	59	109	WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum]	diamond	165	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
32655142	32655142	PRJNA864829_S_NODE_2280_length_349_cov_1.770000_g2194_i0	PRJNA864829	2280	349	1.77	6.1773	Bacillota	1239	Bacteria	Bacteria	138	1.84e-35	NR	WP_291579049.1	1946370	g2194	i0	55.2	2.96561604584527	116	52	99.7	0	349	2	172	287	WP_291579049.1 peptidase domain-containing ABC transporter, partial [Clostridium sp. UBA6640]	diamond	1035	138	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. UBA6640
32718525	32718525	PRJNA864829_S_NODE_5780_length_250_cov_1.597015_g5694_i0	PRJNA864829	5780	250	1.597015	3.9925375	Anaerocolumna	1843210	Bacteria	Bacteria	142	5.6399999999999996e-40	NR	WP_073587253.1	100134	g5694	i0	79.5	1.992	83	17	99.6	0	2	250	137	219	WP_073587253.1 endonuclease/exonuclease/phosphatase family protein [Anaerocolumna xylanovorans]	diamond	498	142	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerocolumna	Anaerocolumna xylanovorans

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