metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax

25 rows where analysis = "diamond", bioproject = "PRJNA588137" 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
2413951	2413951	PRJNA588137_S_NODE_9822_length_244_cov_0.888889_g9789_i0	PRJNA588137	9822	244	0.888889	2.16888916	Herbiconiux sp.	1871186	Bacteria	Bacteria	134	7.6e-37	NR	WP_291038116.1	1871186	g9789	i0	86.4	0.995901639344262	81	11	99.6	0	2	244	18	98	WP_291038116.1 SDR family NAD(P)-dependent oxidoreductase [Herbiconiux sp.]	diamond	243	134	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Herbiconiux	Herbiconiux sp.
5668508	5668508	PRJNA588137_S_NODE_7205_length_249_cov_0.875000_g7172_i0	PRJNA588137	7205	249	0.875	2.17875	Microbacterium yannicii	671622	Bacteria	Bacteria	88.6	1.22e-18	NR	WP_026059843.1	671622	g7172	i0	89.6	2.31325301204819	48	5	57.8	0	249	106	297	344	WP_026059843.1 NAD(P)-dependent alcohol dehydrogenase [Microbacterium yannicii]	diamond	576	88.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium yannicii
8217986	8217986	PRJNA588137_S_NODE_8247_length_247_cov_0.885057_g8214_i0	PRJNA588137	8247	247	0.885057	2.18609079	Propionibacterium sp.	1977903	Bacteria	Bacteria	75.9	3.14e-14	NR	NMD46780.1	1977903	g8214	i0	97.3	0.449392712550607	37	1	44.9	0	113	3	1	37	NMD46780.1 hypothetical protein [Propionibacterium sp.]	diamond	111	75.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propionibacterium	Propionibacterium sp.
11341861	11341861	PRJNA588137_S_NODE_9129_length_245_cov_0.895349_g9096_i0	PRJNA588137	9129	245	0.895349	2.19360505	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	133	3.89e-34	NR	MEZ0370246.1	2762020	g9096	i0	91.5	1.73877551020408	71	6	86.9	0	1	213	61	131	MEZ0370246.1 ATP-dependent helicase [Candidatus Sericytochromatia bacterium]	diamond	426	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
24790959	24790959	PRJNA588137_S_NODE_8760_length_246_cov_0.890173_g8727_i0	PRJNA588137	8760	246	0.890173	2.18982558	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	122	1.26e-31	NR	WP_237025130.1	1528099	g8727	i0	85.3	0.914634146341463	75	11	91.5	0	225	1	1	75	WP_237025130.1 class II fructose-bisphosphatase [Lawsonella clevelandensis]	diamond	225	122	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
26667908	26667908	PRJNA588137_S_NODE_2761_length_330_cov_0.665370_g2728_i0	PRJNA588137	2761	330	0.66537	2.195721	Vulcanococcus sp.	2856995	Bacteria	Bacteria	43.5	0.049	NR	WP_296450979.1	2856995	g2728	i0	27.8	1.76363636363636	97	62	85.5	2	22	303	69	160	WP_296450979.1 tRNA epoxyqueuosine(34) reductase QueG [Vulcanococcus sp.]	diamond	582	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Vulcanococcus	Vulcanococcus sp.
27205844	27205844	PRJNA588137_S_NODE_8262_length_247_cov_0.885057_g8229_i0	PRJNA588137	8262	247	0.885057	2.18609079	Solirubrobacterales bacterium	1909295	Bacteria	Bacteria	64.7	5.03e-10	NR	MBN8869093.1	1909295	g8229	i0	56.9	0.619433198380567	51	22	61.9	0	153	1	1	51	MBN8869093.1 PD40 domain-containing protein [Solirubrobacterales bacterium]	diamond	153	64.7	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			Solirubrobacterales bacterium
27869209	27869209	PRJNA588137_S_NODE_9725_length_244_cov_0.900585_g9692_i0	PRJNA588137	9725	244	0.900585	2.1974274	Lawsonella	1847725	Bacteria	Bacteria	125	3.28e-33	NR	WP_290598695.1	1847725	g9692	i0	100	0.786885245901639	64	0	78.7	0	193	2	1	64	WP_290598695.1 MULTISPECIES: universal stress protein [Lawsonella]	diamond	192	125	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28153738	28153738	PRJNA588137_S_NODE_3305_length_311_cov_1.739496_g3272_i0	PRJNA588137	3305	311	1.739496	5.40983256	Streptomyces lunaelactis	1535768	Bacteria	Bacteria	167	5.24e-51	NR	WP_175314560.1	1535768	g3272	i0	95.1	0.993569131832797	103	5	99.4	0	3	311	8	110	WP_175314560.1 hypothetical protein, partial [Streptomyces lunaelactis]	diamond	309	167	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces lunaelactis
28437820	28437820	PRJNA588137_S_NODE_9706_length_244_cov_0.900585_g9673_i0	PRJNA588137	9706	244	0.900585	2.1974274	Chloroflexota bacterium	2026724	Bacteria	Bacteria	118	9.239999999999999e-30	NR	MDQ3655775.1	2026724	g9673	i0	72.5	1.94262295081967	80	22	98.4	0	244	5	122	201	MDQ3655775.1 gamma-glutamyltransferase family protein [Chloroflexota bacterium]	diamond	474	118	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28564061	28564061	PRJNA588137_S_NODE_5287_length_268_cov_1.446154_g5254_i0	PRJNA588137	5287	268	1.446154	3.87569272	Listeria monocytogenes	1639	Bacteria	Bacteria	127	2.31e-32	NR	HCA4015454.1	1639	g5254	i0	97	0.738805970149254	66	2	73.9	0	59	256	1	66	HCA4015454.1 hypothetical protein [Listeria monocytogenes]	diamond	198	127	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28829930	28829930	PRJNA588137_S_NODE_7348_length_249_cov_0.875000_g7315_i0	PRJNA588137	7348	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	86.7	5.2e-19	NR	WP_069142025.1	1313	g7315	i0	47.6	11.8313253012048	82	43	98.8	0	247	2	30	111	WP_069142025.1 LexA family protein, partial [Streptococcus pneumoniae]	diamond	2946	86.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
28847981	28847981	PRJNA588137_S_NODE_7948_length_248_cov_0.880000_g7915_i0	PRJNA588137	7948	248	0.88	2.1824	Bacilli bacterium	1903720	Bacteria	Bacteria	120	2.18e-32	NR	MEG0407245.1	1903720	g7915	i0	74.4	1.98387096774194	82	21	99.2	0	248	3	10	91	MEG0407245.1 phage protein [Bacilli bacterium]	diamond	492	120	1	Bacteria		Bacillati	Bacillota	Bacilli				Bacilli bacterium
29132477	29132477	PRJNA588137_S_NODE_6349_length_251_cov_1.157303_g6316_i0	PRJNA588137	6349	251	1.157303	2.90483053	Carnobacteriaceae bacterium 52-44	3142729	Bacteria	Bacteria	48.9	6.53e-5	NR	MEY8292856.1	3142729	g6316	i0	75.9	0.346613545816733	29	7	34.7	0	91	5	1	29	MEY8292856.1 Rid family detoxifying hydrolase [Carnobacteriaceae bacterium 52-44]	diamond	87	48.9	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae		Carnobacteriaceae bacterium 52-44
29321701	29321701	PRJNA588137_S_NODE_5549_length_263_cov_1.315789_g5516_i0	PRJNA588137	5549	263	1.315789	3.46052507	Actinacidiphila cocklensis	887465	Bacteria	Bacteria	57.8	7.88e-9	NR	CAG6391361.1	887465	g5516	i0	57.8	0.513307984790874	45	19	51.3	0	202	68	18	62	CAG6391361.1 hypothetical protein SCOCK_1180002 [Actinacidiphila cocklensis]	diamond	135	57.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Actinacidiphila	Actinacidiphila cocklensis
29542694	29542694	PRJNA588137_S_NODE_3930_length_296_cov_1.035874_g3897_i0	PRJNA588137	3930	296	1.035874	3.06618704	Listeria monocytogenes	1639	Bacteria	Bacteria	109	1.12e-25	NR	HCA4015454.1	1639	g3897	i0	98.1	0.537162162162162	53	1	53.7	0	2	160	432	484	HCA4015454.1 hypothetical protein [Listeria monocytogenes]	diamond	159	109	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29668704	29668704	PRJNA588137_S_NODE_6770_length_250_cov_1.259887_g6737_i0	PRJNA588137	6770	250	1.259887	3.1497175	Pseudonocardia sp. H11422	2835866	Bacteria	Bacteria	126	3.5e-32	NR	WP_214368640.1	2835866	g6737	i0	78.3	0.996	83	18	99.6	0	249	1	220	302	WP_214368640.1 HAMP domain-containing sensor histidine kinase [Pseudonocardia sp. H11422]	diamond	249	126	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp. H11422
30237672	30237672	PRJNA588137_S_NODE_9972_length_243_cov_0.905882_g9939_i0	PRJNA588137	9972	243	0.905882	2.20129326	Thermicanus aegyptius	94009	Bacteria	Bacteria	114	1.55e-29	NR	WP_028987004.1	94009	g9939	i0	98.4	1.53086419753086	62	1	76.5	0	243	58	143	204	WP_028987004.1 SpoIIIAH-like family protein [Thermicanus aegyptius]	diamond	372	114	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
30283125	30283125	PRJNA588137_S_NODE_5692_length_261_cov_1.228723_g5659_i0	PRJNA588137	5692	261	1.228723	3.20696703	Bacillaceae	186817	Bacteria	Bacteria	102	4.66e-26	NR	WP_229725710.1	373054	g5659	i0	57.6	3.91954022988506	85	36	97.7	0	259	5	30	114	WP_229725710.1 group I truncated hemoglobin [Calditerricola satsumensis]	diamond	1023	103	0.990291262135922	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Calditerricola	Calditerricola satsumensis
30427673	30427673	PRJNA588137_S_NODE_6873_length_250_cov_0.870056_g6840_i0	PRJNA588137	6873	250	0.870056	2.17514	Amycolatopsis azurea	36819	Bacteria	Bacteria	80.9	5.66e-18	NR	WP_005155815.1	36819	g6840	i0	94.7	1.824	38	2	45.6	0	27	140	39	76	WP_005155815.1 DUF2188 domain-containing protein [Amycolatopsis azurea]	diamond	456	80.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis azurea
31976199	31976199	PRJNA588137_S_NODE_10838_length_242_cov_0.857988_g10805_i0	PRJNA588137	10838	242	0.857988	2.07633096	Mycolicibacterium frederiksbergense	117567	Bacteria	Bacteria	147	8.399999999999998e-44	NR	MBX9921123.1	117567	g10805	i0	100	1.98347107438017	80	0	99.2	0	2	241	48	127	MBX9921123.1 diol dehydratase reactivase [Mycolicibacterium frederiksbergense]	diamond	480	147	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium frederiksbergense
32356241	32356241	PRJNA588137_S_NODE_7439_length_249_cov_0.875000_g7406_i0	PRJNA588137	7439	249	0.875	2.17875	Nakamurella silvestris	1645681	Bacteria	Bacteria	83.2	6.87e-17	NR	RIJ70718.1	1645681	g7406	i0	55.1	1.66265060240964	69	31	83.1	0	249	43	134	202	RIJ70718.1 permease [Nakamurella silvestris]	diamond	414	83.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella silvestris
32608910	32608910	PRJNA588137_S_NODE_7380_length_249_cov_0.875000_g7347_i0	PRJNA588137	7380	249	0.875	2.17875	Amnibacterium kyonggiense	595671	Bacteria	Bacteria	96.7	3.76e-21	NR	WP_133767622.1	595671	g7347	i0	53.1	1.96385542168675	81	38	97.6	0	246	4	388	468	WP_133767622.1 ArnT family glycosyltransferase [Amnibacterium kyonggiense]	diamond	489	96.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Amnibacterium	Amnibacterium kyonggiense
32640113	32640113	PRJNA588137_S_NODE_7440_length_249_cov_0.875000_g7407_i0	PRJNA588137	7440	249	0.875	2.17875	Lawsonella	1847725	Bacteria	Bacteria	177	3.13e-50	NR	WP_290595468.1	1847725	g7407	i0	100	0.987951807228916	82	0	98.8	0	3	248	507	588	WP_290595468.1 MULTISPECIES: maltotransferase domain-containing protein [Lawsonella]	diamond	246	177	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
32640114	32640114	PRJNA588137_S_NODE_9040_length_245_cov_0.895349_g9007_i0	PRJNA588137	9040	245	0.895349	2.19360505	Roseiflexus castenholzii	120962	Bacteria	Bacteria	91.7	2.33e-19	NR	WP_011997801.1	120962	g9007	i0	64.9	5.62040816326531	77	22	93.1	2	5	232	139	211	WP_011997801.1 RCC1 domain-containing protein [Roseiflexus castenholzii]	diamond	1377	91.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii

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