metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA833575" 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
19950826	19950826	PRJNA833575_P_NODE_33376_length_256_cov_1.540107_g33239_i0	PRJNA833575	33376	256	1.540107	3.94267392	Actinokineospora guangxiensis	1490288	Bacteria	Bacteria	124	9.549999999999999e-32	NR	WP_378251071.1	1490288	g33239	i0	66.7	2.9765625	84	27	98.4	1	255	4	157	239	WP_378251071.1 S8 family peptidase [Actinokineospora guangxiensis]	diamond	762	124	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinokineospora	Actinokineospora guangxiensis
19950924	19950924	PRJNA833575_P_NODE_40196_length_233_cov_0.878049_g40059_i0	PRJNA833575	40196	233	0.878049	2.04585417	root	1	Root_unresolved	Root_unresolved	105	6.020000000000001e-27	NR	WP_006636326.1	1386	g40059	i0	66.7	8.98712446351931	69	23	88.8	0	214	8	3	71	WP_006636326.1 MULTISPECIES: glutathione peroxidase [Bacillus]	diamond	2094	105	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
26769769	26769769	PRJNA833575_P_NODE_39201_length_234_cov_0.872727_g39064_i0	PRJNA833575	39201	234	0.872727	2.04218118	Gordonia sesuvii	3116777	Bacteria	Bacteria	47	0.00107	NR	WP_330434099.1	3116777	g39064	i0	46.9	0.628205128205128	49	23	62.8	2	230	84	674	719	WP_330434099.1 hypothetical protein [Gordonia sesuvii]	diamond	147	47	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia sesuvii
27600444	27600444	PRJNA833575_P_NODE_33624_length_255_cov_1.317204_g33487_i0	PRJNA833575	33624	255	1.317204	3.3588702	Bacillati	1783272	Bacteria	Bacteria	57.4	1.29e-8	NR	MBO5985740.1	1898203	g33487	i0	54	1.70588235294118	50	20	56.5	2	255	112	24	72	MBO5985740.1 DUF4215 domain-containing protein [Lachnospiraceae bacterium]	diamond	435	57.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28105301	28105301	PRJNA833575_P_NODE_25785_length_293_cov_1.285714_g25648_i0	PRJNA833575	25785	293	1.285714	3.76714202	Bacillati	1783272	Bacteria	Bacteria	140	4.29e-36	NR	NMA50996.1	37628	g25648	i0	70.1	7.94539249146758	97	29	99.3	0	2	292	281	377	NMA50996.1 pyruvate, phosphate dikinase [Mollicutes bacterium]	diamond	2328	140	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium
28160258	28160258	PRJNA833575_P_NODE_45825_length_227_cov_0.911392_g45688_i0	PRJNA833575	45825	227	0.911392	2.06885984	Anaerolineae bacterium	2052143	Bacteria	Bacteria	47	9.72e-4	NR	HSJ59173.1	2052143	g45688	i0	47.6	1.45374449339207	42	22	55.5	0	80	205	1	42	HSJ59173.1 protein kinase [Anaerolineae bacterium]	diamond	330	47	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
28231449	28231449	PRJNA833575_P_NODE_2846_length_809_cov_3.514865_g2739_i0	PRJNA833575	2846	809	3.514865	28.43525785	Leptolyngbya	47251	Bacteria	Bacteria	57.4	2.68e-5	NR	WP_316428033.1	1184	g2739	i0	54.7	0.589616810877627	53	22	19.7	2	24	182	476	526	WP_316428033.1 hypothetical protein [Leptolyngbya boryana]	diamond	477	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
28231451	28231451	PRJNA833575_P_NODE_31826_length_263_cov_1.484536_g31689_i0	PRJNA833575	31826	263	1.484536	3.90432968	Bacteria candidate phyla	1783234	Bacteria	Bacteria	103	1.2e-25	NR	MBC7258397.1	2026724	g31689	i0	58.3	13.6425855513308	84	35	95.8	0	252	1	15	98	MBC7258397.1 hypoxanthine phosphoribosyltransferase [Chloroflexota bacterium]	diamond	3588	104	0.990384615384615	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28263120	28263120	PRJNA833575_P_NODE_45946_length_227_cov_0.911392_g45809_i0	PRJNA833575	45946	227	0.911392	2.06885984	Bacteria	2	Bacteria	Bacteria	70.5	5.09e-12	NR	MBP3232660.1	1872532	g45809	i0	50.7	11.920704845815	69	33	89.9	1	207	4	649	717	MBP3232660.1 FIST C-terminal domain-containing protein [Anaerovibrio sp.]	diamond	2706	71.2	0.990168539325843	Bacteria		Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Anaerovibrio	Anaerovibrio sp.
28412723	28412723	PRJNA833575_P_NODE_37626_length_237_cov_1.714286_g37489_i0	PRJNA833575	37626	237	1.714286	4.06285782	Clostridiaceae bacterium	1898204	Bacteria	Bacteria	141	4.569999999999999e-37	NR	NBH77902.1	1898204	g37489	i0	86.1	1	79	11	100	0	237	1	574	652	NBH77902.1 alpha-galactosidase [Clostridiaceae bacterium]	diamond	237	141	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium
28610635	28610635	PRJNA833575_P_NODE_11587_length_424_cov_3.118310_g11450_i0	PRJNA833575	11587	424	3.11831	13.2216344	Bacteria	2	Bacteria	Bacteria	109	1.97e-27	NR	MEZ4515128.1	2026724	g11450	i0	43.4	2.97877358490566	136	65	93.4	3	8	403	1	128	MEZ4515128.1 coactosin family protein [Chloroflexota bacterium]	diamond	1263	109	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29422781	29422781	PRJNA833575_P_NODE_15009_length_378_cov_0.957929_g14872_i0	PRJNA833575	15009	378	0.957929	3.62097162	Syntrophomonadaceae bacterium	2093811	Bacteria	Bacteria	167	8.77e-49	NR	NLB89001.1	2093811	g14872	i0	68	2.97619047619048	125	40	99.2	0	3	377	5	129	NLB89001.1 bifunctional phosphoribosylaminoimidazolecarboxamide formyltransferase/IMP cyclohydrolase [Syntrophomonadaceae bacterium]	diamond	1125	167	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae		Syntrophomonadaceae bacterium
29485922	29485922	PRJNA833575_P_NODE_45070_length_228_cov_0.905660_g44933_i0	PRJNA833575	45070	228	0.90566	2.0649048	Pseudonocardia cypriaca	882449	Bacteria	Bacteria	42.4	0.0396	NR	WP_142095399.1	882449	g44933	i0	41.8	0.881578947368421	67	37	88.2	2	202	2	76	140	WP_142095399.1 carbohydrate ABC transporter permease [Pseudonocardia cypriaca]	diamond	201	42.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia cypriaca
29928426	29928426	PRJNA833575_P_NODE_13211_length_401_cov_0.846386_g13074_i0	PRJNA833575	13211	401	0.846386	3.39400786	Bacilli bacterium	1903720	Bacteria	Bacteria	49.3	0.00112	NR	MEE3344554.1	1903720	g13074	i0	48	0.374064837905237	50	26	37.4	0	62	211	248	297	MEE3344554.1 filamin/ABP280 repeat domain-containing protein [Bacilli bacterium]	diamond	150	49.3	1	Bacteria		Bacillati	Bacillota	Bacilli				Bacilli bacterium
30758298	30758298	PRJNA833575_P_NODE_40334_length_233_cov_0.878049_g40197_i0	PRJNA833575	40334	233	0.878049	2.04585417	Blautia	572511	Bacteria	Bacteria	128	2.3e-34	NR	WP_033140526.1	765821	g40197	i0	80	1.931330472103	75	15	96.6	0	9	233	50	124	WP_033140526.1 fructose bisphosphate aldolase [uncultured Blautia sp.]	diamond	450	128	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	uncultured Blautia sp.
31824468	31824468	PRJNA833575_P_NODE_29437_length_274_cov_1.404878_g29300_i0	PRJNA833575	29437	274	1.404878	3.84936572	Virgibacillus proomii	84407	Bacteria	Bacteria	56.2	9.29e-7	NR	WP_245799798.1	84407	g29300	i0	50.8	2.01459854014599	61	29	66.8	1	263	81	486	545	WP_245799798.1 M4 family metallopeptidase [Virgibacillus proomii]	diamond	552	56.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus proomii
32109399	32109399	PRJNA833575_P_NODE_20318_length_328_cov_0.930502_g20181_i0	PRJNA833575	20318	328	0.930502	3.05204656	Candidatus Flexifilum breve	3140694	Bacteria	Bacteria	137	5.839999999999999e-37	NR	WP_343421931.1	3140694	g20181	i0	64.2	2.95426829268293	109	39	99.7	0	1	327	128	236	WP_343421931.1 methionyl-tRNA formyltransferase [Candidatus Flexifilum breve]	diamond	969	137	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales	Candidatus Flexifilaceae	Candidatus Flexifilum	Candidatus Flexifilum breve
32308055	32308055	PRJNA833575_P_NODE_19859_length_331_cov_1.419847_g19722_i0	PRJNA833575	19859	331	1.419847	4.69969357	Cellulomonas	1707	Bacteria	Bacteria	87	3.05e-17	NR	WP_307494345.1	144055	g19722	i0	47.7	1.95770392749245	109	41	89.7	5	11	307	290	392	WP_307494345.1 hemopexin repeat-containing protein [Cellulomonas humilata]	diamond	648	87	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas humilata
32898627	32898627	PRJNA833575_P_NODE_23960_length_304_cov_1.221277_g23823_i0	PRJNA833575	23960	304	1.221277	3.71268208	Phormidium sp. FACHB-1136	2692848	Bacteria	Bacteria	65.9	5.33e-10	NR	WP_199325174.1	2692848	g23823	i0	60.3	0.572368421052632	58	21	57.2	2	299	126	296	351	WP_199325174.1 hypothetical protein [Phormidium sp. FACHB-1136]	diamond	174	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. FACHB-1136

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