metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA929522" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA929522" 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
905375	905375	PRJNA929522_S_NODE_7901_length_258_cov_1.827027_g7831_i0	PRJNA929522	7901	258	1.827027	4.71372966	Amycolatopsis sp. NBC_00355	2975957	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2658899090\|gb\|CP107982.1\|	2975957	g7831	i0	100	0.108527131782946	28	0	11	0	227	254	3706846	3706873	Amycolatopsis sp. NBC_00355 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. NBC_00355
905384	905384	PRJNA929522_S_NODE_9981_length_242_cov_0.911243_g9911_i0	PRJNA929522	9981	242	0.911243	2.20520806	Arthrobacter sp. NicSoilB8	2830998	Bacteria	Bacteria	363	8.869999999999999e-96	NTclustered	gi\|2089584408\|dbj\|AP024655.1\|	2830998	g9911	i0	93.776	6.85537190082645	241	15	99	0	1	241	986350	986110	Arthrobacter sp. NicSoilB8 DNA, complete genome	blastn	1659	363	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. NicSoilB8
3805449	3805449	PRJNA929522_S_NODE_6583_length_279_cov_0.859223_g6513_i0	PRJNA929522	6583	279	0.859223	2.39723217	Actinomycetes	1760	Bacteria	Bacteria	411	3.679999999999999e-110	NTclustered	gi\|1552102408\|gb\|CP028129.1\|	33887	g6513	i0	98.291	185.974910394265	234	4	84	0	46	279	882296	882063	Rathayibacter rathayi strain DSM 7485 chromosome, complete genome	blastn	51887	411	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rathayibacter	Rathayibacter rathayi
4733771	4733771	PRJNA929522_S_NODE_2324_length_437_cov_1.302198_g2254_i0	PRJNA929522	2324	437	1.302198	5.69060526	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	758	0	NTclustered	gi\|2869854277\|gb\|CP175799.1\|	38304	g2254	i0	97.945	361.070938215103	438	8	100	1	1	437	1864	1427	Corynebacterium tuberculostearicum strain YSMAA1_1_B1 chromosome, complete genome	blastn	157788	758	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
4733790	4733790	PRJNA929522_S_NODE_6064_length_288_cov_1.074419_g5994_i0	PRJNA929522	6064	288	1.074419	3.09432672	Actinoplanes friuliensis	196914	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|556031042\|gb\|CP006272.1\|	1246995	g5994	i0	96.774	0.107638888888889	31	1	11	0	11	41	7776514	7776544	Actinoplanes friuliensis DSM 7358, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Actinoplanes	Actinoplanes friuliensis
6357464	6357464	PRJNA929522_S_NODE_565_length_829_cov_5.541005_g512_i0	PRJNA929522	565	829	5.541005	45.93493145	Cutibacterium	1912216	Bacteria	Bacteria	1531	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g512	i0	100	276.442702050663	829	0	100	0	1	829	56175	55347	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	229171	1531	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7283411	7283411	PRJNA929522_S_NODE_2746_length_403_cov_1.166667_g2676_i0	PRJNA929522	2746	403	1.166667	4.70166801	Mycolicibacterium nivoides	2487344	Bacteria	Bacteria	58.4	8.31e-4	NTclustered	gi\|1526088018\|gb\|CP034072.1\|	2487344	g2676	i0	100	0.0769230769230769	31	0	8	0	72	102	257099	257069	Mycolicibacterium nivoides strain DL90 chromosome	blastn	31	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium nivoides
7283427	7283427	PRJNA929522_S_NODE_4086_length_337_cov_1.458333_g4016_i0	PRJNA929522	4086	337	1.458333	4.91458221	Amycolatopsis sp. BJA-103	1911175	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1318683790\|gb\|CP017780.1\|	1911175	g4016	i0	100	0.166172106824926	28	0	8	0	294	321	9043	9070	Amycolatopsis sp. BJA-103 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. BJA-103
7283435	7283435	PRJNA929522_S_NODE_5226_length_305_cov_1.271552_g5156_i0	PRJNA929522	5226	305	1.271552	3.8782336	Streptomyces tabacisoli	3156398	Bacteria	Bacteria	60.2	1.7e-4	NTclustered	gi\|2754130499\|gb\|CP159534.1\|	3156398	g5156	i0	100	0.104918032786885	32	0	10	0	57	88	1898544	1898513	Streptomyces sp. HUAS MG91 chromosome unmamed1, complete sequence	blastn	32	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces tabacisoli
7283441	7283441	PRJNA929522_S_NODE_6266_length_284_cov_1.090047_g6196_i0	PRJNA929522	6266	284	1.090047	3.09573348	Corynebacterium variabile	1727	Bacteria	Bacteria	110	1.53e-19	NTclustered	gi\|340532866\|gb\|CP002917.1\|	858619	g6196	i0	81.633	1.02464788732394	147	14	50	10	90	231	2111742	2111604	Corynebacterium variabile DSM 44702, complete genome	blastn	291	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium variabile
7631559	7631559	PRJNA929522_S_NODE_4666_length_318_cov_2.224490_g4596_i0	PRJNA929522	4666	318	2.22449	7.0738782	root	1	Root_unresolved	Root_unresolved	52.8	0.03	NTclustered	gi\|2667034633\|dbj\|AP029214.1\|	69366	g4596	i0	100	0.176100628930818	28	0	9	0	274	301	2541901	2541928	Microbacterium flavescens JCM 11568 DNA, unplaced contig sequence4	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium flavescens
10182075	10182075	PRJNA929522_S_NODE_8788_length_249_cov_0.875000_g8718_i0	PRJNA929522	8788	249	0.875	2.17875	Microbacterium	33882	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2370304889\|gb\|CP092891.1\|	82380	g8718	i0	100	0.232931726907631	29	0	12	0	9	37	146519	146491	Microbacterium oxydans strain ML-6 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
11108960	11108960	PRJNA929522_S_NODE_8569_length_250_cov_1.559322_g8499_i0	PRJNA929522	8569	250	1.559322	3.898305	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	453	5.31e-123	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g8499	i0	99.597	459.224	248	1	99	0	3	250	81671	81424	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	114806	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
12384430	12384430	PRJNA929522_S_NODE_3170_length_376_cov_1.785479_g3100_i0	PRJNA929522	3170	376	1.785479	6.71340104	Tomitella gaofuii	2760083	Bacteria	Bacteria	87.9	9.81e-13	NTclustered	gi\|1886976244\|gb\|CP059900.1\|	2760083	g3100	i0	98	12.7526595744681	50	1	13	0	4	53	2542163	2542212	Tomitella gaofuii strain HY172 chromosome, complete genome	blastn	4795	87.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales		Tomitella	Tomitella gaofuii
12384467	12384467	PRJNA929522_S_NODE_8890_length_248_cov_1.497143_g8820_i0	PRJNA929522	8890	248	1.497143	3.71291464	Neomicrococcus aestuarii	556325	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1109133054\|gb\|CP018135.1\|	556325	g8820	i0	96.97	0.133064516129032	33	1	13	0	102	134	2092713	2092681	Neomicrococcus aestuarii strain B18 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Neomicrococcus	Neomicrococcus aestuarii
14007433	14007433	PRJNA929522_S_NODE_5271_length_304_cov_1.398268_g5201_i0	PRJNA929522	5271	304	1.398268	4.25073472	Corynebacterium	1716	Bacteria	Bacteria	518	2.32e-142	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g5201	i0	97.368	366.023026315789	304	8	100	0	1	304	2492693	2492390	Corynebacterium accolens strain CA3 chromosome	blastn	111271	518	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
15281402	15281402	PRJNA929522_S_NODE_7512_length_264_cov_0.979058_g7442_i0	PRJNA929522	7512	264	0.979058	2.58471312	Mycobacterium	1763	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1806479221\|dbj\|AP022619.1\|	590652	g7442	i0	100	0.212121212121212	28	0	11	0	218	245	2184303	2184276	Mycobacterium paraseoulense JCM 16952 DNA, nearly complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium paraseoulense
16555951	16555951	PRJNA929522_S_NODE_7193_length_268_cov_2.938462_g7123_i0	PRJNA929522	7193	268	2.938462	7.87507816	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|1109133054\|gb\|CP018135.1\|	556325	g7123	i0	96.875	1.7910447761194	32	1	12	0	3	34	1219361	1219330	Neomicrococcus aestuarii strain B18 chromosome, complete genome	blastn	480	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Neomicrococcus	Neomicrococcus aestuarii
17483570	17483570	PRJNA929522_S_NODE_6114_length_287_cov_1.074766_g6044_i0	PRJNA929522	6114	287	1.074766	3.08457842	uncultured Solirubrobacterales bacterium	768556	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2874253732\|emb\|OY969574.1\|	768556	g6044	i0	100	0.0975609756097561	28	0	10	0	24	51	1507579	1507552	MAG: uncultured Solirubrobacterales bacterium isolate MFD04463.bin.c.9 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			uncultured Solirubrobacterales bacterium
18756902	18756902	PRJNA929522_S_NODE_7535_length_263_cov_2.268421_g7465_i0	PRJNA929522	7535	263	2.268421	5.96594723	Streptomyces sp. So13.3	2136173	Bacteria	Bacteria	161	3.819999999999999e-35	NTclustered	gi\|1896846195\|gb\|CP048835.1\|	2136173	g7465	i0	78.516	65.4144486692015	256	48	95	7	13	263	5916722	5916469	Streptomyces sp. So13.3 chromosome, complete genome	blastn	17204	161	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. So13.3
20031979	20031979	PRJNA929522_S_NODE_2436_length_427_cov_1.073446_g2366_i0	PRJNA929522	2436	427	1.073446	4.58361442	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	627	5.38e-175	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g2366	i0	93.072	386.103044496487	433	23	100	6	1	427	80470	80039	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	164866	627	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
20031994	20031994	PRJNA929522_S_NODE_4276_length_331_cov_0.914729_g4206_i0	PRJNA929522	4276	331	0.914729	3.02775299	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	527	4.249999999999999e-145	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g4206	i0	95.468	477.135951661631	331	13	100	1	1	331	80656	80328	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	157932	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
21307409	21307409	PRJNA929522_S_NODE_2457_length_425_cov_6.704545_g2387_i0	PRJNA929522	2457	425	6.704545	28.49431625	Dactylosporangium fulvum	53359	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|2299511191\|gb\|CP073720.1\|	53359	g2387	i0	100	0.0658823529411765	28	0	7	0	144	171	1513942	1513969	Dactylosporangium fulvum strain NRRL B-16292 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium fulvum
21307437	21307437	PRJNA929522_S_NODE_6137_length_286_cov_2.004695_g6067_i0	PRJNA929522	6137	286	2.004695	5.7334277	Microcella flavibacter	1804990	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1832644234\|gb\|CP051299.1\|	1804990	g6067	i0	100	0.0979020979020979	28	0	10	0	233	260	1125960	1125987	Microcella flavibacter strain WY83 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microcella	Microcella flavibacter
21655729	21655729	PRJNA929522_S_NODE_9317_length_246_cov_0.890173_g9247_i0	PRJNA929522	9317	246	0.890173	2.18982558	Micrococcus	1269	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g9247	i0	100	27.9878048780488	246	0	100	0	1	246	144756	145001	Micrococcus luteus strain V017 chromosome, complete genome	blastn	6885	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
23857728	23857728	PRJNA929522_S_NODE_8759_length_249_cov_1.198864_g8689_i0	PRJNA929522	8759	249	1.198864	2.98517136	Rathayibacter sp. VKM Ac-2804	2609257	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1796395186\|gb\|CP047420.1\|	2609257	g8689	i0	94.286	0.140562248995984	35	2	14	0	140	174	1218985	1218951	Rathayibacter sp. VKM Ac-2804 chromosome	blastn	35	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rathayibacter	Rathayibacter sp. VKM Ac-2804
25131492	25131492	PRJNA929522_S_NODE_5240_length_305_cov_0.991379_g5170_i0	PRJNA929522	5240	305	0.991379	3.02370595	Helcobacillus massiliensis	521392	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2606501910\|gb\|CP136959.1\|	521392	g5170	i0	100	0.0918032786885246	28	0	9	0	111	138	15406	15433	Helcobacillus massiliensis strain UMB10441 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Helcobacillus	Helcobacillus massiliensis
25131498	25131498	PRJNA929522_S_NODE_5900_length_291_cov_1.261468_g5830_i0	PRJNA929522	5900	291	1.261468	3.67087188	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	505	1.7199999999999995e-138	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g5830	i0	97.938	395	291	6	100	0	1	291	2428388	2428098	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	114945	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107

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