metadata: contig_metadata: 33 rows where bioproject = "PRJEB43370", tax_kingdom = "Bacillati" and tax

33 rows where bioproject = "PRJEB43370", tax_kingdom = "Bacillati" 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
2610155	2610155	PRJEB43370_P_NODE_7003_length_173_cov_1.677419_g6960_i0	PRJEB43370	7003	173	1.677419	2.90193487	Bacteria	2	Bacteria	Bacteria	91.3	1.16e-19	NR	WP_345627168.1	556531	g6960	i0	69.1	13.3872832369942	55	17	95.4	0	165	1	495	549	WP_345627168.1 aminomethyl-transferring glycine dehydrogenase [Rugosimonospora acidiphila]	diamond	2316	91.7	0.995637949836423	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Rugosimonospora	Rugosimonospora acidiphila
2610161	2610161	PRJEB43370_P_NODE_7643_length_169_cov_0.866667_g7600_i0	PRJEB43370	7643	169	0.866667	1.46466723	Actinomyces qiguomingii	2057800	Bacteria	Bacteria	117	4.93e-22	NTclustered	gi\|1560770216\|gb\|CP025228.1\|	2057800	g7600	i0	90	23.0532544378698	90	9	53	0	71	160	2813612	2813701	Actinomyces qiguomingii strain 410 chromosome, complete genome	blastn	3896	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces qiguomingii
3540446	3540446	PRJEB43370_P_NODE_1883_length_316_cov_1.625468_g1840_i0	PRJEB43370	1883	316	1.625468	5.13647888	Mycobacteriaceae	1762	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1806304829\|dbj\|AP022581.1\|	169765	g1840	i0	96.97	3.15189873417722	33	1	10	0	254	286	27572	27540	Mycobacterium lacus JCM 15657 DNA, complete genome	blastn	996	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium lacus
3886274	3886274	PRJEB43370_P_NODE_10184_length_163_cov_0.912281_g10141_i0	PRJEB43370	10184	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	53.5	1.29e-6	NR	NCZ55714.1	2080302	g10141	i0	50.9	4.95092024539877	53	24	97.5	1	162	4	27	77	NCZ55714.1 M18 family aminopeptidase [Acidimicrobiia bacterium]	diamond	807	53.5	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
3886359	3886359	PRJEB43370_P_NODE_9264_length_165_cov_0.896552_g9221_i0	PRJEB43370	9264	165	0.896552	1.4793108	Streptomyces sp. NBC_00448	2903652	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2658430807\|gb\|CP107913.1\|	2903652	g9221	i0	100	0.16969696969697	28	0	17	0	30	57	8489766	8489793	Streptomyces sp. NBC_00448 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00448
6093064	6093064	PRJEB43370_P_NODE_6465_length_180_cov_1.786260_g6422_i0	PRJEB43370	6465	180	1.78626	3.215268	Mycobacteriaceae	1762	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|1806225195\|dbj\|AP022563.1\|	39688	g6422	i0	100	129.927777777778	171	0	95	0	10	180	1558638	1558468	Mycolicibacterium duvalii JCM 6396 DNA, complete genome	blastn	23387	316	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium duvalii
6093069	6093069	PRJEB43370_P_NODE_9305_length_165_cov_0.896552_g9262_i0	PRJEB43370	9305	165	0.896552	1.4793108	Nocardiopsis	2013	Bacteria	Bacteria	60.2	8.25e-5	NTclustered	gi\|1540223313\|emb\|LR134501.1\|	2014	g9262	i0	97.143	1.83636363636364	35	1	21	0	20	54	3001746	3001780	Nocardiopsis dassonvillei strain NCTC10488 genome assembly, chromosome: 1	blastn	303	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis dassonvillei
11193296	11193296	PRJEB43370_P_NODE_10809_length_162_cov_0.920354_g10766_i0	PRJEB43370	10809	162	0.920354	1.49097348	Streptomyces	1883	Bacteria	Bacteria	139	1.01e-28	NTclustered	gi\|1863100227\|gb\|CP056041.1\|	1969	g10766	i0	87.603	35.1296296296296	121	13	74	2	43	162	10896460	10896341	Streptomyces chartreusis strain NA02069 chromosome, complete genome	blastn	5691	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces chartreusis
11193310	11193310	PRJEB43370_P_NODE_9429_length_165_cov_0.896552_g9386_i0	PRJEB43370	9429	165	0.896552	1.4793108	Streptomyces	1883	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1688905926\|gb\|CP040467.1\|	1886	g9386	i0	100	0.509090909090909	28	0	17	0	94	121	25820	25847	Streptomyces albidoflavus strain UYFA156 plasmid unnamed, complete sequence	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albidoflavus
12469015	12469015	PRJEB43370_P_NODE_8870_length_166_cov_0.888889_g8827_i0	PRJEB43370	8870	166	0.888889	1.47555574	Winkia	2692118	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2435992455\|gb\|CP116394.1\|	29318	g8827	i0	100	4	166	0	100	0	1	166	200931	201096	Winkia neuii subsp. anitrata strain NY0527 chromosome, complete genome	blastn	664	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Winkia	Winkia neuii
13743405	13743405	PRJEB43370_P_NODE_11071_length_159_cov_2.836364_g11028_i0	PRJEB43370	11071	159	2.836364	4.50981876	Mycobacteriaceae	1762	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1806215240\|dbj\|AP022561.1\|	1799	g11028	i0	100	168.918238993711	159	0	100	0	1	159	3182899	3182741	Mycolicibacterium aichiense JCM 6376 DNA, complete genome	blastn	26858	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aichiense
17567755	17567755	PRJEB43370_P_NODE_9394_length_165_cov_0.896552_g9351_i0	PRJEB43370	9394	165	0.896552	1.4793108	Actinomycetes	1760	Bacteria	Bacteria	95.3	2.26e-15	NTclustered	gi\|1907669513\|gb\|CP031142.1\|	333966	g9351	i0	77.711	49.5818181818182	166	30	98	5	5	165	7301066	7301229	Saccharopolyspora pogona strain NRRL30141 chromosome, complete genome	blastn	8181	95.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora pogona
20461075	20461075	PRJEB43370_P_NODE_8657_length_167_cov_0.881356_g8614_i0	PRJEB43370	8657	167	0.881356	1.47186452	Janibacter terrae	103817	Bacteria	Bacteria	243	7.739999999999999e-60	NTclustered	gi\|2732501705\|gb\|CP144167.1\|	103817	g8614	i0	92.857	192.760479041916	168	11	100	1	1	167	2460941	2461108	Janibacter terrae strain Sec5.9 chromosome, complete genome	blastn	32191	243	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter terrae
21392020	21392020	PRJEB43370_P_NODE_3917_length_224_cov_1.011429_g3874_i0	PRJEB43370	3917	224	1.011429	2.26560096	Bacteria	2	Bacteria	Bacteria	82.4	2.54e-11	NTclustered	gi\|2285394500\|gb\|CP097984.1\|	2045	g3874	i0	77.273	26.1741071428571	154	26	69	9	10	163	3701549	3701405	Pimelobacter simplex strain N39 chromosome, complete genome	blastn	5863	82.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Pimelobacter	Pimelobacter simplex
23012126	23012126	PRJEB43370_P_NODE_10019_length_164_cov_0.904348_g9976_i0	PRJEB43370	10019	164	0.904348	1.48313072	Mycolicibacterium rufum	318424	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2294186521\|gb\|CP092427.2\|	318424	g9976	i0	98.78	166.536585365854	164	2	100	0	1	164	209585	209422	Mycolicibacterium rufum strain JCM 16372 chromosome, complete genome	blastn	27312	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rufum
27001615	27001615	PRJEB43370_P_NODE_7522_length_169_cov_0.866667_g7479_i0	PRJEB43370	7522	169	0.866667	1.46466723	Actinomycetota bacterium	2900548	Bacteria	Bacteria	44.7	0.0029	NR	NIA30818.1	2900548	g7479	i0	45.3	1.66863905325444	53	28	92.3	1	5	160	32	84	NIA30818.1 T9SS type A sorting domain-containing protein [Actinomycetota bacterium]	diamond	282	44.7	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27412979	27412979	PRJEB43370_P_NODE_8923_length_166_cov_0.888889_g8880_i0	PRJEB43370	8923	166	0.888889	1.47555574	unclassified Gordonia (in: high G+C Gram-positive bacteria)	2657482	Bacteria	Bacteria	74.3	9.62e-14	NR	WP_290720141.1	2657482	g8880	i0	58.2	4.96987951807229	55	23	99.4	0	2	166	475	529	WP_290720141.1 MULTISPECIES: ABC transporter ATP-binding protein [unclassified Gordonia (in: high G+C Gram-positive bacteria)]	diamond	825	74.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia
27665501	27665501	PRJEB43370_P_NODE_10784_length_162_cov_0.920354_g10741_i0	PRJEB43370	10784	162	0.920354	1.49097348	Arachnia rubra	1547448	Bacteria	Bacteria	47	4.09e-4	NR	WP_212326732.1	1547448	g10741	i0	52.8	6.16666666666667	36	17	66.7	0	162	55	402	437	WP_212326732.1 aminopeptidase N [Arachnia rubra]	diamond	999	47	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Arachnia	Arachnia rubra
28423264	28423264	PRJEB43370_P_NODE_10306_length_163_cov_0.912281_g10263_i0	PRJEB43370	10306	163	0.912281	1.48701803	Nonomuraea sp.	1883105	Bacteria	Bacteria	41.2	0.044	NR	HEX4812196.1	1883105	g10263	i0	59.4	0.588957055214724	32	13	58.9	0	142	47	9	40	HEX4812196.1 class F sortase [Nonomuraea sp.]	diamond	96	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea sp.
28423266	28423266	PRJEB43370_P_NODE_2146_length_296_cov_1.263158_g2103_i0	PRJEB43370	2146	296	1.263158	3.73894768	Catenulispora pinisilvae	2705253	Bacteria	Bacteria	60.5	4.18e-8	NR	WP_194924196.1	2705253	g2103	i0	35.7	2.32094594594595	115	50	99.3	5	2	295	622	729	WP_194924196.1 VWD domain-containing protein [Catenulispora pinisilvae]	diamond	687	60.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Catenulisporales	Catenulisporaceae	Catenulispora	Catenulispora pinisilvae
28833526	28833526	PRJEB43370_P_NODE_2528_length_272_cov_1.713004_g2485_i0	PRJEB43370	2528	272	1.713004	4.65937088	Streptomyces turgidiscabies	85558	Bacteria	Bacteria	42.7	0.04	NR	WP_344307674.1	85558	g2485	i0	35.5	0.838235294117647	76	40	73.9	2	267	67	55	130	WP_344307674.1 IS5 family transposase, partial [Streptomyces turgidiscabies]	diamond	228	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces turgidiscabies
29117927	29117927	PRJEB43370_P_NODE_6749_length_177_cov_1.210938_g6706_i0	PRJEB43370	6749	177	1.210938	2.14336026	Actinomycetes bacterium	1883427	Bacteria	Bacteria	55.1	6.95e-7	NR	MFM7125210.1	1883427	g6706	i0	54.2	2.86440677966102	59	25	100	2	177	1	150	206	MFM7125210.1 RCC1 domain-containing protein [Actinomycetes bacterium]	diamond	507	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
29268734	29268734	PRJEB43370_P_NODE_6569_length_179_cov_1.353846_g6526_i0	PRJEB43370	6569	179	1.353846	2.42338434	Bacteria	2	Bacteria	Bacteria	80.5	7.32e-16	NR	WP_307326838.1	3041785	g6526	i0	62.7	7.91061452513966	59	22	98.9	0	179	3	392	450	WP_307326838.1 NAD-dependent succinate-semialdehyde dehydrogenase [Microbacterium sp. SORGH_AS_1204]	diamond	1416	80.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. SORGH_AS_1204
29338851	29338851	PRJEB43370_P_NODE_8769_length_166_cov_0.888889_g8726_i0	PRJEB43370	8769	166	0.888889	1.47555574	Catenulispora sp.	1962977	Bacteria	Bacteria	41.6	0.0343	NR	NUP48143.1	1962977	g8726	i0	51.2	0.740963855421687	41	19	74.1	1	25	147	268	307	NUP48143.1 MFS transporter [Catenulispora sp.]	diamond	123	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Catenulisporales	Catenulisporaceae	Catenulispora	Catenulispora sp.
29528273	29528273	PRJEB43370_P_NODE_4650_length_208_cov_1.465409_g4607_i0	PRJEB43370	4650	208	1.465409	3.04805072	actinobacterium acAcidi	1504320	Bacteria	Bacteria	45.1	0.00371	NR	KGA05777.1	1504320	g4607	i0	82.6	0.663461538461538	23	4	33.2	0	2	70	500	522	KGA05777.1 MAG: hypothetical protein GM46_10800, partial [actinobacterium acAcidi]	diamond	138	45.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				actinobacterium acAcidi
29812218	29812218	PRJEB43370_P_NODE_9751_length_164_cov_0.904348_g9708_i0	PRJEB43370	9751	164	0.904348	1.48313072	Actinomycetota bacterium	2900548	Bacteria	Bacteria	64.7	2.26e-10	NR	MEM9711264.1	2900548	g9708	i0	46.9	4.60975609756098	49	26	89.6	0	157	11	350	398	MEM9711264.1 class I adenylate-forming enzyme family protein [Actinomycetota bacterium]	diamond	756	64.7	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
31138968	31138968	PRJEB43370_P_NODE_10995_length_162_cov_0.920354_g10952_i0	PRJEB43370	10995	162	0.920354	1.49097348	Paractinoplanes atraurantiacus	1036182	Bacteria	Bacteria	58.9	2.46e-8	NR	WP_245923682.1	1036182	g10952	i0	50	2	54	26	98.1	1	4	162	179	232	WP_245923682.1 serine/threonine-protein kinase [Paractinoplanes atraurantiacus]	diamond	324	58.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Paractinoplanes	Paractinoplanes atraurantiacus
31170660	31170660	PRJEB43370_P_NODE_10555_length_162_cov_1.840708_g10512_i0	PRJEB43370	10555	162	1.840708	2.98194696	Amycolatopsis speibonae	1450224	Bacteria	Bacteria	40.4	0.0199	NR	WP_378247620.1	1450224	g10512	i0	42.2	1.62962962962963	45	25	81.5	1	29	160	32	76	WP_378247620.1 acyl carrier protein [Amycolatopsis speibonae]	diamond	264	40.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis speibonae
31195442	31195442	PRJEB43370_P_NODE_1215_length_395_cov_2.924855_g1172_i0	PRJEB43370	1215	395	2.924855	11.55317725	PVC group	1783257	Bacteria	Bacteria	57	1.93e-6	NR	WP_106238110.1	1144618	g1172	i0	47.5	2.0886075949367102	59	28	44.8	1	215	391	5	60	WP_106238110.1 F0F1 ATP synthase subunit beta [Allonocardiopsis opalescens]	diamond	825	57	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales		Allonocardiopsis	Allonocardiopsis opalescens
31265788	31265788	PRJEB43370_P_NODE_6295_length_183_cov_1.164179_g6252_i0	PRJEB43370	6295	183	1.164179	2.13044757	Actinomadura sediminis	1038904	Bacteria	Bacteria	41.6	0.0346	NR	WP_378296409.1	1038904	g6252	i0	45.2	0.688524590163934	42	23	68.9	0	6	131	139	180	WP_378296409.1 hypothetical protein [Actinomadura sediminis]	diamond	126	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sediminis
31607029	31607029	PRJEB43370_P_NODE_9516_length_165_cov_0.896552_g9473_i0	PRJEB43370	9516	165	0.896552	1.4793108	Actinomycetes	1760	Bacteria	Bacteria	103	5.3699999999999995e-25	NR	MBW8711991.1	1785	g9473	i0	81.8	12	55	10	100	0	1	165	218	272	MBW8711991.1 alpha/beta fold hydrolase [Mycobacterium sp.]	diamond	1980	103	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
31740041	31740041	PRJEB43370_P_NODE_7797_length_168_cov_1.924370_g7754_i0	PRJEB43370	7797	168	1.92437	3.2329416	Prescottella equi	43767	Bacteria	Bacteria	41.6	0.0349	NR	MBM4602470.1	43767	g7754	i0	51.3	0.696428571428571	39	19	69.6	0	46	162	225	263	MBM4602470.1 hypothetical protein [Prescottella equi]	diamond	117	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Prescottella	Prescottella equi
31961581	31961581	PRJEB43370_P_NODE_9658_length_164_cov_1.808696_g9615_i0	PRJEB43370	9658	164	1.808696	2.96626144	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	80.9	9.01e-18	NR	HEY7070843.1	2201156	g9615	i0	84.4	5.90853658536585	45	7	82.3	0	145	11	87	131	HEY7070843.1 adenosylhomocysteinase [Acidimicrobiales bacterium]	diamond	969	80.9	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium

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