metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1197996" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1197996" 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
324341	324341	PRJNA1197996_S_NODE_7721_length_362_cov_3.404844_g7667_i0	PRJNA1197996	7721	362	3.404844	12.32553528	Kocuria palustris	71999	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g7667	i0	96.875	0.0883977900552486	32	1	9	0	299	330	121392	121423	Kocuria palustris strain MU14/1, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
1598941	1598941	PRJNA1197996_S_NODE_5842_length_395_cov_3.015528_g5788_i0	PRJNA1197996	5842	395	3.015528	11.9113356	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	691	0	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g5788	i0	98.228	393.944303797468	395	7	100	0	1	395	553120	553514	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	155608	691	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
2318910	2318910	PRJNA1197996_S_NODE_10162_length_333_cov_1.011538_g10108_i0	PRJNA1197996	10162	333	1.011538	3.36842154	Mycobacteriaceae	1762	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|1935556990\|gb\|CP062008.1\|	1226753	g10108	i0	100	166.219219219219	333	0	100	0	1	333	1385805	1385473	Mycolicibacterium mucogenicum DSM 44124 chromosome, complete genome	blastn	55351	616	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mucogenicum
2319030	2319030	PRJNA1197996_S_NODE_5982_length_392_cov_2.755486_g5928_i0	PRJNA1197996	5982	392	2.755486	10.80150512	Cutibacterium	1912216	Bacteria	Bacteria	719	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5928	i0	99.745	275.043367346939	392	1	100	0	1	392	56035	56426	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	107817	719	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3594051	3594051	PRJNA1197996_S_NODE_18103_length_276_cov_1.699507_g18049_i0	PRJNA1197996	18103	276	1.699507	4.69063932	Bacteria	2	Bacteria	Bacteria	488	1.6299999999999995e-133	NTclustered	gi\|2800755081\|gb\|CP081300.1\|	2859784	g18049	i0	98.551	99.6884057971015	276	4	100	0	1	276	807346	807071	Streptomyces sp. II-2-2-2 strain Soil LB -1 chromosome, complete genome	blastn	27514	488	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. II-2-2-2
3594100	3594100	PRJNA1197996_S_NODE_2523_length_518_cov_2.480899_g2472_i0	PRJNA1197996	2523	518	2.480899	12.85105682	root	1	Root_unresolved	Root_unresolved	948	0	NTclustered	gi\|443497846\|dbj\|AB777853.1\|	1747	g2472	i0	99.615	100.181467181467	520	0	100	2	1	518	756	237	Cutibacterium acnes gene for 16S ribosomal RNA, partial sequence, strain: K56	blastn	51894	952	0.995798319327731	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3594127	3594127	PRJNA1197996_S_NODE_28903_length_238_cov_2.472727_g28849_i0	PRJNA1197996	28903	238	2.472727	5.88509026	Cellulomonas	1707	Bacteria	Bacteria	435	1.8200000000000003e-117	NTclustered	gi\|1368095924\|gb\|KY951360.1\|	1711	g28849	i0	99.58	109	238	1	100	0	1	238	526	763	Cellulomonas flavigena strain PDS_PXH_60 16S ribosomal RNA gene, partial sequence	blastn	25942	435	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas flavigena
4150784	4150784	PRJNA1197996_S_NODE_15184_length_293_cov_1.059091_g15130_i0	PRJNA1197996	15184	293	1.059091	3.10313663	Mycobacterium haemophilum	29311	Bacteria	Bacteria	525	1.3299999999999994e-144	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g15130	i0	98.976	109	293	3	100	0	1	293	3005453	3005745	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	31937	525	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum
4150960	4150960	PRJNA1197996_S_NODE_21844_length_258_cov_1.318919_g21790_i0	PRJNA1197996	21844	258	1.318919	3.40281102	Actinomarinicola tropica	2789776	Bacteria	Bacteria	100	8.27e-17	NTclustered	gi\|1774476215\|gb\|CP045851.1\|	2789776	g21790	i0	88.235	16.7519379844961	85	8	33	2	2	85	335712	335795	Actinomarinicola tropica strain SCSIO 58843 chromosome, complete genome	blastn	4322	100	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Iamiaceae	Actinomarinicola	Actinomarinicola tropica
5427554	5427554	PRJNA1197996_S_NODE_9365_length_341_cov_1.723881_g9311_i0	PRJNA1197996	9365	341	1.723881	5.87843421	Pseudarthrobacter oxydans	1671	Bacteria	Bacteria	586	7.14e-163	NTclustered	gi\|2666964057\|dbj\|AP029193.1\|	1671	g9311	i0	98.209	368.865102639296	335	6	98	0	7	341	809447	809113	Pseudarthrobacter oxydans JCM 2521 DNA, complete genome	blastn	125783	586	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
6146412	6146412	PRJNA1197996_S_NODE_12165_length_314_cov_1.547718_g12111_i0	PRJNA1197996	12165	314	1.547718	4.85983452	Mycolicibacterium	1866885	Bacteria	Bacteria	484	2.4399999999999998e-132	NTclustered	gi\|1806441670\|dbj\|AP022612.1\|	28047	g12111	i0	94.586	151.474522292994	314	16	100	1	1	314	1087395	1087083	Mycolicibacterium confluentis JCM 13671 DNA, nearly complete genome	blastn	47563	486	0.995884773662551	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium confluentis
6146550	6146550	PRJNA1197996_S_NODE_965_length_723_cov_4.878462_g923_i0	PRJNA1197996	965	723	4.878462	35.27128026	Cutibacterium	1912216	Bacteria	Bacteria	1279	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g923	i0	98.617	281.526970954357	723	9	100	1	1	723	57425	56704	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	203544	1279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6701938	6701938	PRJNA1197996_S_NODE_22746_length_254_cov_1.276243_g22692_i0	PRJNA1197996	22746	254	1.276243	3.24165722	Nocardioides sp. W7	2931390	Bacteria	Bacteria	335	2.0399999999999993e-87	NTclustered	gi\|2221858821\|gb\|CP095078.1\|	2931390	g22692	i0	90.588	231.917322834646	255	21	100	3	1	254	3231099	3230847	Nocardioides sp. W7 chromosome	blastn	58907	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. W7
8696661	8696661	PRJNA1197996_S_NODE_28507_length_241_cov_0.916667_g28453_i0	PRJNA1197996	28507	241	0.916667	2.20916747	Microbispora	2005	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1005009962\|gb\|KT345250.1\|	58118	g28453	i0	98.34	255.539419087137	241	4	100	0	1	241	373	133	Microbispora rosea subsp. rosea strain JCM8972 23S ribosomal RNA gene, partial sequence	blastn	61585	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Microbispora	Microbispora rosea
9252045	9252045	PRJNA1197996_S_NODE_24768_length_248_cov_1.760000_g24714_i0	PRJNA1197996	24768	248	1.76	4.3648	Geodermatophilaceae bacterium NBWT11	2596920	Bacteria	Bacteria	364	2.539999999999999e-96	NTclustered	gi\|1891431189\|gb\|CP043652.1\|	2596920	g24714	i0	94.167	297.729838709677	240	13	100	1	1	239	649400	649639	Geodermatophilaceae bacterium NBWT11 chromosome, complete genome	blastn	73837	364	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae		Geodermatophilaceae bacterium NBWT11
9252247	9252247	PRJNA1197996_S_NODE_6888_length_375_cov_5.268212_g6834_i0	PRJNA1197996	6888	375	5.268212	19.755795	Leifsonia sp. McL0608	3143537	Bacteria	Bacteria	510	4.9e-140	NTclustered	gi\|2731609019\|gb\|CP154826.1\|	3143537	g6834	i0	91.223	184.624	376	31	100	2	1	375	2458501	2458875	Diaminobutyricibacter sp. McL0608 chromosome, complete genome	blastn	69234	510	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. McL0608
9971718	9971718	PRJNA1197996_S_NODE_24208_length_249_cov_3.340909_g24154_i0	PRJNA1197996	24208	249	3.340909	8.31886341	root	1	Root_unresolved	Root_unresolved	460	3.16e-125	NTclustered	gi\|1851830967\|gb\|CP050522.1\|	1902	g24154	i0	100	100	249	0	100	0	1	249	4169601	4169849	Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome	blastn	24900	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces coelicolor
11246910	11246910	PRJNA1197996_S_NODE_1829_length_576_cov_17.546720_g1780_i0	PRJNA1197996	1829	576	17.54672	101.0691072	Plantibacter	190323	Bacteria	Bacteria	1053	0	NTclustered	gi\|1154341650\|gb\|CP019402.1\|	150123	g1780	i0	99.653	187.296875	576	2	100	0	1	576	2449328	2449903	Plantibacter flavus strain 251 genome	blastn	107883	1053	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Plantibacter	Plantibacter flavus
11246932	11246932	PRJNA1197996_S_NODE_22689_length_254_cov_1.701657_g22635_i0	PRJNA1197996	22689	254	1.701657	4.32220878	Kocuria	57493	Bacteria	Bacteria	418	1.9699999999999995e-112	NTclustered	gi\|2654448039\|gb\|CP108528.1\|	72000	g22635	i0	96.457	286.374015748031	254	7	100	2	1	254	421115	420864	Kocuria rhizophila strain NBC_01227 chromosome, complete genome	blastn	72739	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
11246990	11246990	PRJNA1197996_S_NODE_4649_length_423_cov_4.471429_g4595_i0	PRJNA1197996	4649	423	4.471429	18.91414467	Mycolicibacterium	1866885	Bacteria	Bacteria	688	0	NTclustered	gi\|2741228740\|gb\|CP157737.1\|	39692	g4595	i0	95.981	224.304964539007	423	17	100	0	1	423	3851274	3850852	Mycolicibacterium parafortuitum strain Panama NTM 1 chromosome, complete genome	blastn	94881	691	0.995658465991317	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium parafortuitum
12522231	12522231	PRJNA1197996_S_NODE_1090_length_693_cov_4.198387_g1047_i0	PRJNA1197996	1090	693	4.198387	29.09482191	Cutibacterium	1912216	Bacteria	Bacteria	1280	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1047	i0	100	270.500721500722	693	0	100	0	1	693	55355	56047	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	187457	1280	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14353120	14353120	PRJNA1197996_S_NODE_24572_length_249_cov_0.875000_g24518_i0	PRJNA1197996	24572	249	0.875	2.17875	Frigoribacterium sp. SL97	2994664	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2381123252\|gb\|CP113062.1\|	2994664	g24518	i0	98.394	89.2610441767068	249	4	100	0	1	249	1318757	1318509	Frigoribacterium sp. SL97 chromosome	blastn	22226	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Frigoribacterium	Frigoribacterium sp. SL97
15071296	15071296	PRJNA1197996_S_NODE_13932_length_301_cov_1.513158_g13878_i0	PRJNA1197996	13932	301	1.513158	4.55460558	Microbacterium	33882	Bacteria	Bacteria	545	1.0499999999999999e-150	NTclustered	gi\|1004607086\|gb\|KT865794.1\|	1811290	g13878	i0	99.336	174.514950166113	301	2	100	0	1	301	425	125	Microbacterium sp. ALBL_047 23S ribosomal RNA gene, partial sequence	blastn	52529	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. ALBL_047
18175501	18175501	PRJNA1197996_S_NODE_15615_length_290_cov_1.419355_g15561_i0	PRJNA1197996	15615	290	1.419355	4.1161295	Tsukamurella pulmonis	47312	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2174344570\|dbj\|AP025457.1\|	47312	g15561	i0	100	0.096551724137931	28	0	10	0	50	77	940197	940224	Tsukamurella pulmonis TP-B0596 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella pulmonis
18175820	18175820	PRJNA1197996_S_NODE_28915_length_238_cov_2.230303_g28861_i0	PRJNA1197996	28915	238	2.230303	5.30812114	Aeromicrobium wangtongii	2969247	Bacteria	Bacteria	111	3.48e-20	NTclustered	gi\|2283193646\|gb\|CP102173.1\|	2969247	g28861	i0	88.889	27.7058823529412	90	10	38	0	1	90	559016	559105	Aeromicrobium wangtongii strain zg-Y1379 chromosome, complete genome	blastn	6594	111	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium wangtongii
18895188	18895188	PRJNA1197996_S_NODE_7495_length_366_cov_1.440273_g7441_i0	PRJNA1197996	7495	366	1.440273	5.27139918	Microbacteriaceae	85023	Bacteria	Bacteria	612	1.2699999999999999e-170	NTclustered	gi\|2667034633\|dbj\|AP029214.1\|	69366	g7441	i0	96.739	265.77868852459	368	10	100	2	1	366	1621464	1621097	Microbacterium flavescens JCM 11568 DNA, unplaced contig sequence4	blastn	97275	617	0.991896272285251	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium flavescens
19449895	19449895	PRJNA1197996_S_NODE_14996_length_294_cov_1.393665_g14942_i0	PRJNA1197996	14996	294	1.393665	4.0973751	Citricoccus sp. SGAir0253	2567881	Bacteria	Bacteria	444	3.85e-120	NTclustered	gi\|1669663700\|gb\|CP039424.1\|	2567881	g14942	i0	93.898	330.986394557823	295	16	100	2	1	294	1314654	1314361	Citricoccus sp. SGAir0253 chromosome, complete genome	blastn	97310	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Citricoccus	Citricoccus sp. SGAir0253
20725283	20725283	PRJNA1197996_S_NODE_17557_length_279_cov_1.669903_g17503_i0	PRJNA1197996	17557	279	1.669903	4.65902937	Sanguibacter keddieii	60920	Bacteria	Bacteria	499	7.63e-137	NTclustered	gi\|269095543\|gb\|CP001819.1\|	446469	g17503	i0	98.925	274.136200716846	279	3	100	0	1	279	4145584	4145306	Sanguibacter keddieii DSM 10542, complete genome	blastn	76484	499	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Sanguibacteraceae	Sanguibacter	Sanguibacter keddieii
21445627	21445627	PRJNA1197996_S_NODE_28397_length_241_cov_1.375000_g28343_i0	PRJNA1197996	28397	241	1.375	3.31375	Micrococcus	1269	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g28343	i0	100	345.813278008299	241	0	100	0	1	241	346345	346105	Micrococcus luteus strain V017 chromosome, complete genome	blastn	83341	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus

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