metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA950981" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA950981" 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
933893	933893	PRJNA950981_P_NODE_8381_length_346_cov_1.142857_g8205_i0	PRJNA950981	8381	346	1.142857	3.95428522	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	606	5.57e-169	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g8205	i0	98.266	275	346	6	100	0	1	346	553665	553320	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	95150	606	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
1262426	1262426	PRJNA950981_P_NODE_2561_length_595_cov_4.120690_g2388_i0	PRJNA950981	2561	595	4.12069	24.5181055	Cutibacterium	1912216	Bacteria	Bacteria	1098	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g2388	i0	100	291.206722689076	594	0	99	0	2	595	608928	608335	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	173268	1098	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2209185	2209185	PRJNA950981_P_NODE_7402_length_364_cov_2.402062_g7226_i0	PRJNA950981	7402	364	2.402062	8.74350568	Antiquaquibacter oligotrophicus	2880260	Bacteria	Bacteria	628	1.2499999999999999e-175	NTclustered	gi\|2119302123\|gb\|CP085036.1\|	2880260	g7226	i0	97.802	209.057692307692	364	8	100	0	1	364	293893	293530	Antiquaquibacter oligotrophicus strain SG_E_30_P1 chromosome, complete genome	blastn	76097	628	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Antiquaquibacter	Antiquaquibacter oligotrophicus
2538171	2538171	PRJNA950981_P_NODE_22082_length_229_cov_2.198718_g21906_i0	PRJNA950981	22082	229	2.198718	5.03506422	Antiquaquibacter	3108736	Bacteria	Bacteria	416	6.289999999999999e-112	NTclustered	gi\|2119302123\|gb\|CP085036.1\|	2880260	g21906	i0	99.561	176.240174672489	228	1	99	0	2	229	292398	292625	Antiquaquibacter oligotrophicus strain SG_E_30_P1 chromosome, complete genome	blastn	40359	416	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Antiquaquibacter	Antiquaquibacter oligotrophicus
3484516	3484516	PRJNA950981_P_NODE_20463_length_244_cov_1.736842_g20287_i0	PRJNA950981	20463	244	1.736842	4.23789448	Micromonospora sp. WMMA1998	3015167	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2418478635\|gb\|CP114911.1\|	3015167	g20287	i0	100	0.114754098360656	28	0	11	0	79	106	4138548	4138575	Micromonospora sp. WMMA1998 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. WMMA1998
3814554	3814554	PRJNA950981_P_NODE_7083_length_371_cov_1.046980_g6907_i0	PRJNA950981	7083	371	1.04698	3.8842958	root	1	Root_unresolved	Root_unresolved	58.4	7.58e-4	NTclustered	gi\|1748211690\|gb\|CP029195.1\|	54571	g6907	i0	100	9.02425876010782	31	0	8	0	337	367	5384827	5384857	Streptomyces venezuelae strain ATCC 10595 chromosome, complete genome	blastn	3348	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces venezuelae
4762247	4762247	PRJNA950981_P_NODE_19304_length_247_cov_0.896552_g19128_i0	PRJNA950981	19304	247	0.896552	2.21448344	Corynebacterium glucuronolyticum	39791	Bacteria	Bacteria	444	3.15e-120	NTclustered	gi\|1986091972\|gb\|CP069534.1\|	39791	g19128	i0	99.19	6.00404858299595	247	1	100	1	1	247	113914	114159	Corynebacterium glucuronolyticum strain FDAARGOS_1191 chromosome, complete genome	blastn	1483	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glucuronolyticum
4762261	4762261	PRJNA950981_P_NODE_2484_length_604_cov_2.986817_g2311_i0	PRJNA950981	2484	604	2.986817	18.04037468	Microbacterium azadirachtae	582680	Bacteria	Bacteria	1116	0	NTclustered	gi\|2313714276\|gb\|CP099706.1\|	582680	g2311	i0	100	191.079470198675	604	0	100	0	1	604	1335302	1335905	Microbacterium azadirachtae strain CNUC13 chromosome, complete genome	blastn	115412	1116	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium azadirachtae
5090842	5090842	PRJNA950981_P_NODE_12664_length_289_cov_1.171296_g12488_i0	PRJNA950981	12664	289	1.171296	3.38504544	Corynebacterium	1716	Bacteria	Bacteria	418	2.29e-112	NTclustered	gi\|2550476051\|gb\|CP100377.1\|	38284	g12488	i0	92.857	381.276816608997	294	11	100	9	1	289	2471007	2470719	Corynebacterium accolens strain CA6 chromosome, complete genome	blastn	110189	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
5090844	5090844	PRJNA950981_P_NODE_18644_length_248_cov_1.760000_g18468_i0	PRJNA950981	18644	248	1.76	4.3648	Micrococcus	1269	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1796953946\|gb\|CP041689.1\|	1270	g18468	i0	100	325.346774193548	248	0	100	0	1	248	115111	114864	Micrococcus luteus strain 10240 chromosome, complete genome	blastn	80686	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
7640459	7640459	PRJNA950981_P_NODE_446_length_1309_cov_8.265372_g152_i1	PRJNA950981	446	1309	8.265372	108.19371948	Kocuria	57493	Bacteria	Bacteria	2106	0	NTclustered	gi\|1586061146\|gb\|CP035504.1\|	1049583	g152	i1	96.199	302.472880061115	1289	46	98	3	1	1287	1847774	1846487	Kocuria marina subsp. indica strain CE7 chromosome, complete genome	blastn	395937	2106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria marina
8586836	8586836	PRJNA950981_P_NODE_3407_length_520_cov_1.232662_g3232_i0	PRJNA950981	3407	520	1.232662	6.4098424	Nakamurella sp. PAMC28650	2762325	Bacteria	Bacteria	817	0	NTclustered	gi\|1896707401\|gb\|CP060298.1\|	2762325	g3232	i0	95.01	262.438461538462	521	24	100	2	1	520	2684547	2685066	Nakamurella sp. PAMC28650 chromosome, complete genome	blastn	136468	817	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella sp. PAMC28650
9861881	9861881	PRJNA950981_P_NODE_21708_length_242_cov_0.923077_g21532_i0	PRJNA950981	21708	242	0.923077	2.23384634	Microbacterium sp. LWO14-1.2	3135263	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|2719809309\|gb\|CP151633.1\|	3135263	g21532	i0	99.174	176.96694214876	242	2	100	0	1	242	2984170	2983929	Microbacterium sp. LWO14-1.2 chromosome	blastn	42826	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. LWO14-1.2
11137484	11137484	PRJNA950981_P_NODE_19289_length_247_cov_0.896552_g19113_i0	PRJNA950981	19289	247	0.896552	2.21448344	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	346	9.14e-91	NTclustered	gi\|1954924873\|gb\|CP067012.1\|	1979527	g19113	i0	91.903	1.83400809716599	247	20	100	0	1	247	1160267	1160021	Corynebacterium kefirresidentii strain FDAARGOS_1055 chromosome, complete genome	blastn	453	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
11466278	11466278	PRJNA950981_P_NODE_1369_length_800_cov_3.762036_g1215_i0	PRJNA950981	1369	800	3.762036	30.096288	Cutibacterium	1912216	Bacteria	Bacteria	1472	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1215	i0	99.875	273.9825	800	1	100	0	1	800	56159	55360	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	219186	1472	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11466282	11466282	PRJNA950981_P_NODE_17409_length_251_cov_0.876404_g17233_i0	PRJNA950981	17409	251	0.876404	2.19977404	Micrococcus	1269	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g17233	i0	100	110.569721115538	251	0	100	0	1	251	1950746	1950996	Micrococcus luteus strain ML chromosome, complete genome	blastn	27753	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11466283	11466283	PRJNA950981_P_NODE_18829_length_248_cov_0.891429_g18653_i0	PRJNA950981	18829	248	0.891429	2.21074392	Kocuria	57493	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1586061146\|gb\|CP035504.1\|	1049583	g18653	i0	99.597	6.96774193548387	248	1	100	0	1	248	972599	972352	Kocuria marina subsp. indica strain CE7 chromosome, complete genome	blastn	1728	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria marina
12412941	12412941	PRJNA950981_P_NODE_15190_length_264_cov_1.628272_g15014_i0	PRJNA950981	15190	264	1.628272	4.29863808	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	460	3.3799999999999995e-125	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g15014	i0	98.106	333.314393939394	264	5	100	0	1	264	552829	553092	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	87995	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
12412957	12412957	PRJNA950981_P_NODE_19750_length_246_cov_0.901734_g19574_i0	PRJNA950981	19750	246	0.901734	2.21826564	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	187	5.839999999999998e-43	NTclustered	gi\|927981428\|gb\|CP009312.1\|	1528099	g19574	i0	80.579	2.95121951219512	242	47	98	0	4	245	752311	752070	Lawsonella clevelandensis strain X1036, complete genome.	blastn	726	187	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
12741782	12741782	PRJNA950981_P_NODE_190_length_1855_cov_8.118967_g152_i0	PRJNA950981	190	1855	8.118967	150.60683785	Kocuria	57493	Bacteria	Bacteria	2577	0	NTclustered	gi\|1586061146\|gb\|CP035504.1\|	1049583	g152	i0	91.738	217.188140161725	1876	124	100	28	1	1855	1847774	1845909	Kocuria marina subsp. indica strain CE7 chromosome, complete genome	blastn	402884	2577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria marina
13687504	13687504	PRJNA950981_P_NODE_19231_length_247_cov_0.896552_g19055_i0	PRJNA950981	19231	247	0.896552	2.21448344	Kocuria marina	223184	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1586061146\|gb\|CP035504.1\|	1049583	g19055	i0	99.595	27.2550607287449	247	1	100	0	1	247	1921363	1921117	Kocuria marina subsp. indica strain CE7 chromosome, complete genome	blastn	6732	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria marina
14961664	14961664	PRJNA950981_P_NODE_16752_length_253_cov_0.866667_g16576_i0	PRJNA950981	16752	253	0.866667	2.19266751	Pseudonocardia alni	33907	Bacteria	Bacteria	451	1.94e-122	NTclustered	gi\|2476288951\|gb\|CP052771.1\|	33907	g16576	i0	98.819	256.97628458498	254	2	100	1	1	253	793504	793757	Pseudonocardia alni strain Shahu chromosome, complete genome	blastn	65015	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia alni
16236683	16236683	PRJNA950981_P_NODE_16413_length_253_cov_1.666667_g16237_i0	PRJNA950981	16413	253	1.666667	4.21666751	Tsukamurella paurometabola	2061	Bacteria	Bacteria	128	3.71e-25	NTclustered	gi\|296025884\|gb\|CP001966.1\|	521096	g16237	i0	84.733	43.4782608695652	131	16	51	4	76	204	3547214	3547086	Tsukamurella paurometabola DSM 20162, complete genome	blastn	11000	128	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella paurometabola
16236699	16236699	PRJNA950981_P_NODE_3353_length_523_cov_3.008889_g3179_i0	PRJNA950981	3353	523	3.008889	15.73648947	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	894	0	NTclustered	gi\|2874253773\|emb\|OY969722.1\|	3039803	g3179	i0	97.533	232.523900573614	527	6	99	7	1	522	1178335	1178859	MAG: uncultured Actinomycetota bacterium isolate MFD10113.bin.2.32 genome assembly, chromosome: 1	blastn	121610	894	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
16565026	16565026	PRJNA950981_P_NODE_19953_length_246_cov_0.901734_g19777_i0	PRJNA950981	19953	246	0.901734	2.21826564	Bifidobacterium	1678	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1539960149\|emb\|LR134349.1\|	1689	g19777	i0	100	339.882113821138	246	0	100	0	1	246	1974243	1973998	Bifidobacterium dentium strain NCTC11816 genome assembly, chromosome: 1	blastn	83611	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium dentium
16565028	16565028	PRJNA950981_P_NODE_2873_length_563_cov_3.222449_g2700_i0	PRJNA950981	2873	563	3.222449	18.14238787	root	1	Root_unresolved	Root_unresolved	1040	0	NTclustered	gi\|1313740129\|dbj\|LC341276.1\|	1747	g2700	i0	100	101	563	0	100	0	1	563	343	905	Cutibacterium acnes JK12.2 gene for 16S ribosomal RNA, partial sequence	blastn	56863	1040	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18785600	18785600	PRJNA950981_P_NODE_13055_length_285_cov_1.301887_g12879_i0	PRJNA950981	13055	285	1.301887	3.71037795	Streptomyces noursei	1971	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2453844347\|gb\|CP119144.1\|	1971	g12879	i0	89.13	0.557894736842105	46	3	15	2	69	112	2682310	2682265	Streptomyces noursei strain C27 chromosome, complete genome	blastn	159	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces noursei
19113849	19113849	PRJNA950981_P_NODE_10535_length_314_cov_1.294606_g10359_i0	PRJNA950981	10535	314	1.294606	4.06506284	Rhodococcoides	3259750	Bacteria	Bacteria	580	3.0299999999999992e-161	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g10359	i0	100	403.410828025478	314	0	100	0	1	314	2530880	2530567	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	126671	580	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
22610826	22610826	PRJNA950981_P_NODE_15218_length_264_cov_1.225131_g15042_i0	PRJNA950981	15218	264	1.225131	3.23434584	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	327	3.58e-85	NTclustered	gi\|2694275225\|gb\|CP140010.1\|	1528099	g15042	i0	89.272	99.5984848484848	261	28	99	0	1	261	625675	625415	MAG: Lawsonella clevelandensis isolate TECA_312545_bc_10 chromosome	blastn	26294	327	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
22610857	22610857	PRJNA950981_P_NODE_8318_length_347_cov_1.145985_g8142_i0	PRJNA950981	8318	347	1.145985	3.97656795	Janibacter terrae	103817	Bacteria	Bacteria	577	4.3799999999999985e-160	NTclustered	gi\|2732501705\|gb\|CP144167.1\|	103817	g8142	i0	96.571	189.123919308357	350	9	100	3	1	347	2461270	2460921	Janibacter terrae strain Sec5.9 chromosome, complete genome	blastn	65626	577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter terrae
23886222	23886222	PRJNA950981_P_NODE_21599_length_242_cov_0.923077_g21423_i0	PRJNA950981	21599	242	0.923077	2.23384634	Corynebacterium marquesiae	2913503	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2869822234\|gb\|CP175776.1\|	2913503	g21423	i0	98.347	64.004132231405	242	4	100	0	1	242	26112	26353	Corynebacterium marquesiae strain YSMAA3_1_G3 chromosome, complete genome	blastn	15489	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium marquesiae
25159996	25159996	PRJNA950981_P_NODE_18540_length_249_cov_0.886364_g18364_i0	PRJNA950981	18540	249	0.886364	2.20704636	Herbiconiux sp. A18JL235	3152363	Bacteria	Bacteria	403	5.3999999999999986e-108	NTclustered	gi\|2779598800\|gb\|CP162511.1\|	3152363	g18364	i0	97.071	95.9678714859438	239	7	96	0	11	249	3551220	3551458	Herbiconiux sp. A18JL235 chromosome, complete genome	blastn	23896	403	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Herbiconiux	Herbiconiux sp. A18JL235
25489046	25489046	PRJNA950981_P_NODE_9200_length_333_cov_0.926923_g9024_i0	PRJNA950981	9200	333	0.926923	3.08665359	Actinomycetes	1760	Bacteria	Bacteria	610	4.13e-170	NTclustered	gi\|827663658\|gb\|KF933781.1\|	2047	g9024	i0	99.7	107.96996996997	333	1	100	0	1	333	335	3	Rothia dentocariosa strain ChDC B334 16S ribosomal RNA gene, partial sequence	blastn	35954	616	0.99025974025974	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa

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