metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA826497" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA826497" and tax_phylum = "Actinomycetota"

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
2096201	2096201	PRJNA826497_S_NODE_8302_length_197_cov_9.573171_g8262_i0	PRJNA826497	8302	197	9.573171	18.85914687	Lawsonella	1847725	Bacteria	Bacteria	129	2.33e-34	NR	WP_290598777.1	1847725	g8262	i0	100	0.989847715736041	65	0	99	0	1	195	90	154	WP_290598777.1 MULTISPECIES: class 1b ribonucleoside-diphosphate reductase subunit beta [Lawsonella]	diamond	195	129	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
8473551	8473551	PRJNA826497_S_NODE_3727_length_245_cov_2.372642_g3687_i0	PRJNA826497	3727	245	2.372642	5.8129729	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	139	2.79e-37	NR	MFT7507153.1	2201156	g3687	i0	81.5	1.98367346938776	81	15	99.2	0	244	2	150	230	MFT7507153.1 tyrosyl-tRNA synthetase [Acidimicrobiales bacterium]	diamond	486	139	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
16123185	16123185	PRJNA826497_S_NODE_11353_length_180_cov_3.884354_g11313_i0	PRJNA826497	11353	180	3.884354	6.9918372	Corynebacterium	1716	Bacteria	Bacteria	103	1.87e-25	NR	WP_269026859.1	1288393	g11313	i0	81.7	1.98333333333333	60	11	100	0	1	180	17	76	WP_269026859.1 dihydrofolate reductase family protein [Corynebacterium pilbarense]	diamond	357	103	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pilbarense
17398983	17398983	PRJNA826497_S_NODE_19574_length_151_cov_20.016949_g19534_i0	PRJNA826497	19574	151	20.016949	30.22559299	Saccharothrix longispora	33920	Bacteria	Bacteria	67.8	7.67e-13	NR	WP_316037957.1	33920	g19534	i0	71.4	1.58940397350993	42	12	83.4	0	26	151	1	42	WP_316037957.1 YchJ family protein [Saccharothrix longispora]	diamond	240	67.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharothrix	Saccharothrix longispora
22497367	22497367	PRJNA826497_S_NODE_16758_length_159_cov_6.388889_g16718_i0	PRJNA826497	16758	159	6.388889	10.15833351	Cutibacterium	1912216	Bacteria	Bacteria	102	4.37e-26	NR	MES6838385.1	1747	g16718	i0	98.1	3.92452830188679	52	1	98.1	0	3	158	89	140	MES6838385.1 hypothetical protein [Cutibacterium acnes]	diamond	624	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
27157617	27157617	PRJNA826497_S_NODE_14502_length_167_cov_2.268657_g14462_i0	PRJNA826497	14502	167	2.268657	3.78865719	Actinomycetes	1760	Bacteria	Bacteria	107	2.6e-26	NR	MDU6928196.1	37640	g14462	i0	94.5	1.97604790419162	55	3	98.8	0	166	2	204	258	MDU6928196.1 hypothetical protein [Dermabacter sp.]	diamond	330	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Dermabacter	Dermabacter sp.
27252678	27252678	PRJNA826497_S_NODE_5843_length_218_cov_2.675676_g5803_i0	PRJNA826497	5843	218	2.675676	5.83297368	Corynebacterium	1716	Bacteria	Bacteria	98.2	5.21e-22	NR	QYH19777.1	1190508	g5803	i0	75.7	3.86697247706422	70	17	96.3	0	6	215	334	403	QYH19777.1 site-specific integrase [Corynebacterium aquatimens]	diamond	843	99	0.991919191919192	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium aquatimens
27528367	27528367	PRJNA826497_S_NODE_13423_length_171_cov_3.768116_g13383_i0	PRJNA826497	13423	171	3.768116	6.44347836	Lawsonella	1847725	Bacteria	Bacteria	115	2.29e-31	NR	WP_290598303.1	1847725	g13383	i0	98.2	0.982456140350877	56	1	98.2	0	170	3	51	106	WP_290598303.1 MULTISPECIES: nucleoside-diphosphate kinase [Lawsonella]	diamond	168	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
27812826	27812826	PRJNA826497_S_NODE_14804_length_166_cov_1.669173_g14764_i0	PRJNA826497	14804	166	1.669173	2.77082718	Lawsonella	1847725	Bacteria	Bacteria	102	4.13e-24	NR	WP_290598757.1	1847725	g14764	i0	100	0.993975903614458	55	0	99.4	0	2	166	9	63	WP_290598757.1 MULTISPECIES: L,D-transpeptidase [Lawsonella]	diamond	165	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28128475	28128475	PRJNA826497_S_NODE_10265_length_185_cov_7.750000_g10225_i0	PRJNA826497	10265	185	7.75	14.3375	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	55.1	7.53e-7	NR	WP_394268086.1	1528099	g10225	i0	100	0.502702702702703	31	0	50.3	0	1	93	422	452	WP_394268086.1 ABC transporter permease [Lawsonella clevelandensis]	diamond	93	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
28199933	28199933	PRJNA826497_S_NODE_8706_length_195_cov_3.290123_g8666_i0	PRJNA826497	8706	195	3.290123	6.41573985	Varibaculum	184869	Bacteria	Bacteria	120	4.11e-34	NR	MDU2151276.1	184870	g8666	i0	100	2.90769230769231	61	0	93.8	0	187	5	19	79	MDU2151276.1 cell division protein DivIVA [Varibaculum cambriense]	diamond	567	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Varibaculum	Varibaculum cambriense
28222878	28222878	PRJNA826497_S_NODE_14846_length_165_cov_16.984848_g14806_i0	PRJNA826497	14846	165	16.984848	28.0249992	Lawsonella	1847725	Bacteria	Bacteria	105	2.47e-28	NR	WP_290598482.1	1847725	g14806	i0	98.1	0.981818181818182	54	1	98.2	0	164	3	25	78	WP_290598482.1 MULTISPECIES: DUF3263 domain-containing protein [Lawsonella]	diamond	162	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28633741	28633741	PRJNA826497_S_NODE_13347_length_171_cov_8.347826_g13307_i0	PRJNA826497	13347	171	8.347826	14.27478246	Lawsonella	1847725	Bacteria	Bacteria	117	8.14e-29	NR	WP_290598622.1	1847725	g13307	i0	98.2	0.982456140350877	56	1	98.2	0	170	3	373	428	WP_290598622.1 MULTISPECIES: pyruvate kinase [Lawsonella]	diamond	168	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28728271	28728271	PRJNA826497_S_NODE_19847_length_151_cov_2.567797_g19807_i0	PRJNA826497	19847	151	2.567797	3.87737347	Kineosporiaceae bacterium	2487580	Bacteria	Bacteria	48.5	1.29e-5	NR	HET9657473.1	2487580	g19807	i0	63.9	1.52980132450331	36	12	69.5	1	129	25	27	62	HET9657473.1 hypothetical protein [Kineosporiaceae bacterium]	diamond	231	48.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kineosporiales	Kineosporiaceae		Kineosporiaceae bacterium
29328082	29328082	PRJNA826497_S_NODE_6249_length_214_cov_3.541436_g6209_i0	PRJNA826497	6249	214	3.541436	7.57867304	Curtobacterium flaccumfaciens	2035	Bacteria	Bacteria	95.5	2.25e-21	NR	WP_214561634.1	2035	g6209	i0	68.6	0.981308411214953	70	22	98.1	0	214	5	250	319	WP_214561634.1 replication initiation protein [Curtobacterium flaccumfaciens]	diamond	210	95.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium flaccumfaciens
29368406	29368406	PRJNA826497_S_NODE_4389_length_235_cov_3.153465_g4349_i0	PRJNA826497	4389	235	3.153465	7.41064275	Streptomyces	1883	Bacteria	Bacteria	43.1	0.025	NR	WP_306081240.1	2798799	g4349	i0	39.7	2.42553191489362	63	38	80.4	0	18	206	3716	3778	WP_306081240.1 SDR family NAD(P)-dependent oxidoreductase [Streptomyces poriferorum]	diamond	570	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces poriferorum
29611981	29611981	PRJNA826497_S_NODE_3450_length_249_cov_10.740741_g3410_i0	PRJNA826497	3450	249	10.740741	26.74444509	Lawsonella	1847725	Bacteria	Bacteria	165	5.45e-50	NR	WP_290598576.1	1847725	g3410	i0	98.8	0.975903614457831	81	1	97.6	0	247	5	93	173	WP_290598576.1 MULTISPECIES: hypothetical protein [Lawsonella]	diamond	243	165	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
29675120	29675120	PRJNA826497_S_NODE_12650_length_174_cov_5.971631_g12610_i0	PRJNA826497	12650	174	5.971631	10.39063794	Subtercola boreus	120213	Bacteria	Bacteria	115	1.46e-28	NR	WP_116284843.1	120213	g12610	i0	96.5	1.96551724137931	57	2	98.3	0	2	172	296	352	WP_116284843.1 site-specific DNA-methyltransferase [Subtercola boreus]	diamond	342	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Subtercola	Subtercola boreus
29675129	29675129	PRJNA826497_S_NODE_8750_length_195_cov_1.987654_g8710_i0	PRJNA826497	8750	195	1.987654	3.8759253	Cutibacterium acnes	1747	Bacteria	Bacteria	119	5.18e-32	NR	MES6222020.1	1747	g8710	i0	93.5	0.953846153846154	62	4	95.4	0	188	3	8	69	MES6222020.1 hypothetical protein [Cutibacterium acnes]	diamond	186	119	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
29738339	29738339	PRJNA826497_S_NODE_10470_length_184_cov_6.006623_g10430_i0	PRJNA826497	10470	184	6.006623	11.05218632	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	80.5	7.66e-16	NR	PZP88501.1	1528099	g10430	i0	100	0.570652173913043	35	0	57.1	0	79	183	1	35	PZP88501.1 MAG: hypothetical protein DI579_06450 [Lawsonella clevelandensis]	diamond	105	80.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
29896624	29896624	PRJNA826497_S_NODE_8971_length_193_cov_6.918750_g8931_i0	PRJNA826497	8971	193	6.91875	13.3531875	Yaniella sp.	2773929	Bacteria	Bacteria	109	2.35e-28	NR	MDN5705338.1	2773929	g8931	i0	95.2	3.91709844559586	63	3	97.9	0	3	191	54	116	MDN5705338.1 arsenical-resistance protein [Yaniella sp.]	diamond	756	109	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Yaniella	Yaniella sp.
30347983	30347983	PRJNA826497_S_NODE_19752_length_151_cov_3.728814_g19712_i0	PRJNA826497	19752	151	3.728814	5.63050914	FCB group	1783270	Bacteria	Bacteria	94.4	1.0799999999999999e-23	NR	WP_409096678.1	85558	g19712	i0	89.8	2.9205298013245	49	5	97.4	0	3	149	21	69	WP_409096678.1 hypothetical protein, partial [Streptomyces turgidiscabies]	diamond	441	94.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces turgidiscabies
30496932	30496932	PRJNA826497_S_NODE_5053_length_226_cov_12.590674_g5013_i0	PRJNA826497	5053	226	12.590674	28.45492324	Leifsonia aquatica	144185	Bacteria	Bacteria	43.1	0.0211	NR	WP_025157841.1	144185	g5013	i0	38.5	0.86283185840708	65	36	81	1	224	42	423	487	WP_025157841.1 MFS transporter [Leifsonia aquatica]	diamond	195	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia aquatica
30528338	30528338	PRJNA826497_S_NODE_2913_length_260_cov_5.290749_g2873_i0	PRJNA826497	2913	260	5.290749	13.7559474	Coriobacteriia bacterium	2052159	Bacteria	Bacteria	100	2.43e-22	NR	HZL04120.1	2052159	g2873	i0	55.8	0.992307692307692	86	37	99.2	1	259	2	386	470	HZL04120.1 hypothetical protein [Coriobacteriia bacterium]	diamond	258	100	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia				Coriobacteriia bacterium
30717873	30717873	PRJNA826497_S_NODE_7674_length_202_cov_2.479290_g7634_i0	PRJNA826497	7674	202	2.47929	5.0081658	Microlunatus sp.	39595	Bacteria	Bacteria	104	2.1e-27	NR	HEU5485502.1	39595	g7634	i0	83.9	2.76237623762376	62	10	92.1	0	2	187	38	99	HEU5485502.1 transposase [Microlunatus sp.]	diamond	558	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
31010918	31010918	PRJNA826497_S_NODE_3814_length_243_cov_4.609524_g3774_i0	PRJNA826497	3814	243	4.609524	11.20114332	Lawsonella	1847725	Bacteria	Bacteria	89	3.23e-21	NR	WP_303678726.1	1528099	g3774	i0	98	1.25925925925926	51	1	63	0	158	6	1	51	WP_303678726.1 hypothetical protein [Lawsonella clevelandensis]	diamond	306	89	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31223324	31223324	PRJNA826497_S_NODE_16975_length_159_cov_2.015873_g16935_i0	PRJNA826497	16975	159	2.015873	3.20523807	Propionicimonas sp.	1955623	Bacteria	Bacteria	69.7	3.58e-12	NR	WP_294127449.1	1955623	g16935	i0	77.3	0.830188679245283	44	10	83	0	2	133	601	644	WP_294127449.1 hypothetical protein [Propionicimonas sp.]	diamond	132	69.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Propionicimonas	Propionicimonas sp.
31286635	31286635	PRJNA826497_S_NODE_10355_length_185_cov_3.065789_g10315_i0	PRJNA826497	10355	185	3.065789	5.67170965	Leucobacter chromiireducens	283877	Bacteria	Bacteria	68.9	9.85e-12	NR	WP_202381404.1	283877	g10315	i0	55.7	0.989189189189189	61	27	98.9	0	3	185	378	438	WP_202381404.1 site-specific DNA-methyltransferase [Leucobacter chromiireducens]	diamond	183	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter chromiireducens
31381804	31381804	PRJNA826497_S_NODE_9556_length_190_cov_2.076433_g9516_i0	PRJNA826497	9556	190	2.076433	3.9452227	uncultured Lawsonella sp.	1847727	Bacteria	Bacteria	121	2.45e-30	NR	WP_296237632.1	1847727	g9516	i0	95.2	0.978947368421053	62	3	97.9	0	187	2	312	373	WP_296237632.1 ABC-F family ATP-binding cassette domain-containing protein [uncultured Lawsonella sp.]	diamond	186	121	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	uncultured Lawsonella sp.
32394081	32394081	PRJNA826497_S_NODE_12919_length_173_cov_4.642857_g12879_i0	PRJNA826497	12919	173	4.642857	8.03214261	Lawsonella	1847725	Bacteria	Bacteria	105	1.02e-24	NR	WP_290598911.1	1847725	g12879	i0	100	1.95953757225434	56	0	97.1	0	171	4	286	341	WP_290598911.1 MULTISPECIES: ABC transporter ATP-binding protein/permease [Lawsonella]	diamond	339	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
32781145	32781145	PRJNA826497_S_NODE_11520_length_179_cov_5.958904_g11480_i0	PRJNA826497	11520	179	5.958904	10.66643816	Microbacteriaceae	85023	Bacteria	Bacteria	90.9	7.580000000000001e-21	NR	WP_184214684.1	421115	g11480	i0	75.9	1.94413407821229	58	14	97.2	0	177	4	83	140	WP_184214684.1 hypothetical protein [Microbacterium marinum]	diamond	348	91.3	0.995618838992333	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium marinum
32804073	32804073	PRJNA826497_S_NODE_2680_length_265_cov_7.836207_g2640_i0	PRJNA826497	2680	265	7.836207	20.76594855	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	167	2.1399999999999994e-48	NR	WP_306558953.1	1528099	g2640	i0	100	0.99622641509434	88	0	99.6	0	265	2	41	128	WP_306558953.1 bifunctional glutamate N-acetyltransferase/amino-acid acetyltransferase ArgJ [Lawsonella clevelandensis]	diamond	264	167	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32867066	32867066	PRJNA826497_S_NODE_14580_length_166_cov_11.511278_g14540_i0	PRJNA826497	14580	166	11.511278	19.10872148	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	111	1.66e-30	NR	PZP89417.1	1528099	g14540	i0	100	0.993975903614458	55	0	99.4	0	166	2	6	60	PZP89417.1 MAG: hypothetical protein DI579_02570 [Lawsonella clevelandensis]	diamond	165	111	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis

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