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

15 rows where analysis = "diamond", bioproject = "PRJNA672101" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26923597	26923597	PRJNA672101_S_NODE_31022_length_246_cov_0.890173_g30991_i0	PRJNA672101	31022	246	0.890173	2.18982558	Paractinoplanes lichenicola	2802976	Bacteria	Bacteria	43.5	0.0166	NR	WP_202994310.1	2802976	g30991	i0	42.4	0.719512195121951	59	33	70.7	1	177	4	142	200	WP_202994310.1 DUF4386 domain-containing protein [Paractinoplanes lichenicola]	diamond	177	43.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Paractinoplanes	Paractinoplanes lichenicola
27366493	27366493	PRJNA672101_S_NODE_21063_length_280_cov_5.135266_g21032_i0	PRJNA672101	21063	280	5.135266	14.3787448	Anaerolineales bacterium	2073117	Bacteria	Bacteria	43.5	0.0322	NR	HEY4668005.1	2073117	g21032	i0	31.1	0.792857142857143	74	51	79.3	0	25	246	432	505	HEY4668005.1 adenylate/guanylate cyclase domain-containing protein [Anaerolineales bacterium]	diamond	222	43.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28692561	28692561	PRJNA672101_S_NODE_15827_length_307_cov_1.470085_g15796_i0	PRJNA672101	15827	307	1.470085	4.51316095	Hydrogenispora ethanolica	1082276	Bacteria	Bacteria	163	8.77e-46	NR	WP_132015865.1	1082276	g15796	i0	71.6	8.96091205211726	102	29	99.7	0	306	1	378	479	WP_132015865.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Hydrogenispora ethanolica]	diamond	2751	163	1	Bacteria		Bacillati	Bacillota				Hydrogenispora	Hydrogenispora ethanolica
28755487	28755487	PRJNA672101_S_NODE_9427_length_353_cov_3.575000_g9396_i0	PRJNA672101	9427	353	3.575	12.61975	Clostridia bacterium	2044939	Bacteria	Bacteria	59.7	1.55e-7	NR	MFA5151318.1	2044939	g9396	i0	34.5	0.713881019830028	84	53	71.4	2	353	102	928	1009	MFA5151318.1 hypothetical protein [Clostridia bacterium]	diamond	252	59.7	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
29355509	29355509	PRJNA672101_S_NODE_1049_length_588_cov_21.885437_g1021_i0	PRJNA672101	1049	588	21.885437	128.68636956	Nostoc sp. LEGE 12447	1828640	Bacteria	Bacteria	105	2.9399999999999998e-24	NR	MBE9002840.1	1828640	g1021	i0	34.1	0.836734693877551	164	100	83.7	3	562	71	42	197	MBE9002840.1 hypothetical protein [Nostoc sp. LEGE 12447]	diamond	492	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LEGE 12447
29639251	29639251	PRJNA672101_S_NODE_13710_length_320_cov_3.380567_g13679_i0	PRJNA672101	13710	320	3.380567	10.8178144	Clostridium botulinum	1491	Bacteria	Bacteria	43.5	0.0329	NR	WP_222652759.1	1491	g13679	i0	51.6	0.871875	93	36	79.7	4	30	284	3	94	WP_222652759.1 hypothetical protein, partial [Clostridium botulinum]	diamond	279	43.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
30599067	30599067	PRJNA672101_S_NODE_28853_length_250_cov_1.728814_g28822_i0	PRJNA672101	28853	250	1.728814	4.322035	Bacteria	2	Bacteria	Bacteria	49.3	1.49e-4	NR	PKN83635.1	2013730	g28822	i0	48.1	2.46	52	25	62.4	1	93	248	172	221	PKN83635.1 MAG: 23S rRNA (cytosine(1962)-C(5))-methyltransferase RlmI, partial [Chloroflexi bacterium HGW-Chloroflexi-7]	diamond	615	49.3	1	Bacteria		Bacillati	Chloroflexota					Chloroflexi bacterium HGW-Chloroflexi-7
31756859	31756859	PRJNA672101_S_NODE_18757_length_291_cov_2.325688_g18726_i0	PRJNA672101	18757	291	2.325688	6.76775208	Eubacteriales bacterium ADMFC1	3385205	Bacteria	Bacteria	49.3	2.93e-4	NR	BFT87137.1	3385205	g18726	i0	33.7	0.917525773195876	89	54	86.6	2	286	35	130	218	BFT87137.1 hypothetical protein ADMFC1_12150 [Eubacteriales bacterium ADMFC1]	diamond	267	49.3	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium ADMFC1
31946507	31946507	PRJNA672101_S_NODE_12277_length_330_cov_3.120623_g12246_i0	PRJNA672101	12277	330	3.120623	10.2980559	Cyanobacteria bacterium P01_E01_bin.42	3023285	Bacteria	Bacteria	44.7	0.0203	NR	MEM9540379.1	3023285	g12246	i0	31	0.763636363636364	84	48	76.4	3	318	67	100	173	MEM9540379.1 NAD(P)/FAD-dependent oxidoreductase [Cyanobacteria bacterium P01_E01_bin.42]	diamond	252	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_E01_bin.42
32073293	32073293	PRJNA672101_S_NODE_9658_length_351_cov_2.780576_g9627_i0	PRJNA672101	9658	351	2.780576	9.75982176	Anaerolineales bacterium	2073117	Bacteria	Bacteria	61.2	4.02e-8	NR	HMD81774.1	2073117	g9627	i0	44.8	0.572649572649573	67	36	57.3	1	149	349	347	412	HMD81774.1 hypothetical protein [Anaerolineales bacterium]	diamond	201	61.2	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32231723	32231723	PRJNA672101_S_NODE_20998_length_281_cov_1.110577_g20967_i0	PRJNA672101	20998	281	1.110577	3.12072137	Streptomyces narbonensis	67333	Bacteria	Bacteria	59.3	3.32e-8	NR	WP_229833193.1	67333	g20967	i0	39.4	2.13523131672598	99	49	96.1	4	270	1	69	165	WP_229833193.1 hypothetical protein, partial [Streptomyces narbonensis]	diamond	600	59.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces narbonensis
32453248	32453248	PRJNA672101_S_NODE_12259_length_330_cov_4.494163_g12228_i0	PRJNA672101	12259	330	4.494163	14.8307379	Streptomyces physcomitrii	2724184	Bacteria	Bacteria	156	1.84e-46	NR	WP_246342120.1	2724184	g12228	i0	68.8	8.90909090909091	109	31	99.1	1	1	327	44	149	WP_246342120.1 hypothetical protein [Streptomyces physcomitrii]	diamond	2940	156	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces physcomitrii
32484746	32484746	PRJNA672101_S_NODE_8679_length_360_cov_3.881533_g8648_i0	PRJNA672101	8679	360	3.881533	13.9735188	Bifidobacterium animalis	28025	Bacteria	Bacteria	45.1	0.0164	NR	MED7637831.1	28025	g8648	i0	51.7	0.741666666666667	89	32	70	3	87	338	69	151	MED7637831.1 hypothetical protein [Bifidobacterium animalis]	diamond	267	45.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium animalis
32610949	32610949	PRJNA672101_S_NODE_29220_length_249_cov_6.238636_g29189_i0	PRJNA672101	29220	249	6.238636	15.53420364	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	160	3.03e-46	NR	HBS92032.1	2049044	g29189	i0	100	0.987951807228916	82	0	98.8	0	3	248	45	126	HBS92032.1 hypothetical protein [Erysipelotrichaceae bacterium]	diamond	246	160	1	Bacteria		Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
32874701	32874701	PRJNA672101_S_NODE_7460_length_373_cov_2.823333_g7429_i0	PRJNA672101	7460	373	2.823333	10.53103209	PVC group	1783257	Bacteria	Bacteria	70.5	3.12e-11	NR	WP_112881966.1	2081970	g7429	i0	38.4	2.67828418230563	112	59	86.1	4	368	48	795	901	WP_112881966.1 UxaA family hydrolase [Paenibacillus montanisoli]	diamond	999	71.2	0.990168539325843	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus montanisoli

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