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

33 rows where analysis = "blastn", bioproject = "PRJNA690234" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1946406	1946406	PRJNA690234_P_NODE_30862_length_243_cov_1.517647_g30495_i0	PRJNA690234	30862	243	1.517647	3.68788221	Arachnia propionica	1750	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1540109112\|emb\|LR134406.1\|	1750	g30495	i0	98.354	17.7530864197531	243	4	100	0	1	243	689157	689399	Pseudopropionibacterium propionicum strain NCTC12967 genome assembly, chromosome: 1	blastn	4314	427	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Arachnia	Arachnia propionica
2454104	2454104	PRJNA690234_P_NODE_18922_length_291_cov_1.431193_g18555_i0	PRJNA690234	18922	291	1.431193	4.16477163	Cutibacterium	1912216	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|1755605466\|dbj\|AP019664.1\|	1747	g18555	i0	100	61.9381443298969	291	0	100	0	1	291	1205764	1206054	Cutibacterium acnes TP-CU389 DNA, complete genome	blastn	18024	538	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2454124	2454124	PRJNA690234_P_NODE_25822_length_252_cov_0.871508_g25455_i0	PRJNA690234	25822	252	0.871508	2.19620016	Cutibacterium	1912216	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g25455	i0	100	50.9642857142857	252	0	100	0	1	252	2024077	2024328	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12843	466	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3221094	3221094	PRJNA690234_P_NODE_25863_length_252_cov_0.871508_g25496_i0	PRJNA690234	25863	252	0.871508	2.19620016	Microbacterium albipurpureum	3050384	Bacteria	Bacteria	305	1.59e-78	NTclustered	gi\|2526543409\|gb\|CP128170.1\|	3050384	g25496	i0	88.492	9.5515873015873	252	29	100	0	1	252	2304755	2305006	Microbacterium sp. ET2 chromosome, complete genome	blastn	2407	305	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium albipurpureum
3730658	3730658	PRJNA690234_P_NODE_14043_length_338_cov_2.498113_g13676_i0	PRJNA690234	14043	338	2.498113	8.44362194	Rhodococcus	1827	Bacteria	Bacteria	625	1.4999999999999999e-174	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g13676	i0	100	414.579881656805	338	0	100	0	1	338	559238	558901	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	140128	625	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
3730703	3730703	PRJNA690234_P_NODE_31343_length_243_cov_0.917647_g30976_i0	PRJNA690234	31343	243	0.917647	2.22988221	Cutibacterium	1912216	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g30976	i0	100	94.7448559670782	243	0	100	0	1	243	489741	489983	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	23023	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4498269	4498269	PRJNA690234_P_NODE_25884_length_252_cov_0.871508_g25517_i0	PRJNA690234	25884	252	0.871508	2.19620016	Nocardioides sp. B-3	2895565	Bacteria	Bacteria	372	1.54e-98	NTclustered	gi\|2286662645\|gb\|CP087968.1\|	2895565	g25517	i0	93.254	263.551587301587	252	17	100	0	1	252	3323367	3323116	Nocardioides sp. B-3 chromosome, complete genome	blastn	66415	372	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. B-3
5007161	5007161	PRJNA690234_P_NODE_21364_length_274_cov_2.457711_g20997_i0	PRJNA690234	21364	274	2.457711	6.73412814	Arachnia	2801844	Bacteria	Bacteria	287	6.34e-73	NTclustered	gi\|1540109112\|emb\|LR134406.1\|	1750	g20997	i0	85.766	111.288321167883	274	35	99	4	2	274	32587	32317	Pseudopropionibacterium propionicum strain NCTC12967 genome assembly, chromosome: 1	blastn	30493	287	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Arachnia	Arachnia propionica
5007187	5007187	PRJNA690234_P_NODE_32144_length_240_cov_2.227545_g31777_i0	PRJNA690234	32144	240	2.227545	5.346108	Corynebacterium	1716	Bacteria	Bacteria	438	1.4199999999999995e-118	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g31777	i0	99.583	365.9125	240	1	100	0	1	240	990664	990425	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	87819	438	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
5773794	5773794	PRJNA690234_P_NODE_25825_length_252_cov_0.871508_g25458_i0	PRJNA690234	25825	252	0.871508	2.19620016	Cutibacterium granulosum	33011	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g25458	i0	99.603	217.218253968254	252	1	100	0	1	252	487155	487406	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	54739	460	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
5773922	5773922	PRJNA690234_P_NODE_30985_length_243_cov_0.917647_g30618_i0	PRJNA690234	30985	243	0.917647	2.22988221	Capillimicrobium parvum	2884022	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2164499877\|gb\|CP087164.1\|	2884022	g30618	i0	96.721	95.2633744855967	244	7	100	1	1	243	2765699	2765942	Capillimicrobium parvum strain 0166_1 chromosome, complete genome	blastn	23149	405	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Capillimicrobiaceae	Capillimicrobium	Capillimicrobium parvum
6282839	6282839	PRJNA690234_P_NODE_13745_length_342_cov_1.494424_g13378_i0	PRJNA690234	13745	342	1.494424	5.11093008	Corynebacterium	1716	Bacteria	Bacteria	616	9.139999999999999e-172	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g13378	i0	99.123	362.023391812865	342	3	100	0	1	342	622962	622621	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	123812	616	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
6282867	6282867	PRJNA690234_P_NODE_25245_length_253_cov_0.866667_g24878_i0	PRJNA690234	25245	253	0.866667	2.19266751	Cutibacterium	1912216	Bacteria	Bacteria	383	7.17e-102	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g24878	i0	99.065	79.0671936758893	214	0	85	2	40	253	1957517	1957306	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	20004	383	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6282884	6282884	PRJNA690234_P_NODE_31145_length_243_cov_0.917647_g30778_i0	PRJNA690234	31145	243	0.917647	2.22988221	Rhodococcoides	3259750	Bacteria	Bacteria	355	1.49e-93	NTclustered	gi\|1017211286\|gb\|CP015220.1\|	1828	g30778	i0	93.004	98.8024691358025	243	17	100	0	1	243	775421	775663	Rhodococcus sp. PBTS2, complete genome	blastn	24009	355	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
7556755	7556755	PRJNA690234_P_NODE_26926_length_250_cov_0.881356_g26559_i0	PRJNA690234	26926	250	0.881356	2.20339	Cutibacterium	1912216	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g26559	i0	100	62.152	250	0	100	0	1	250	2061976	2062225	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	15538	462	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9598736	9598736	PRJNA690234_P_NODE_25068_length_253_cov_0.866667_g24701_i0	PRJNA690234	25068	253	0.866667	2.19266751	Mycolicibacterium fortuitum	1766	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2105673168\|gb\|CP060410.1\|	1766	g24701	i0	100	99.0276679841897	253	0	100	0	1	253	3382360	3382108	Mycolicibacterium fortuitum strain W6 chromosome	blastn	25054	468	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium fortuitum
10107534	10107534	PRJNA690234_P_NODE_26768_length_250_cov_1.276836_g26401_i0	PRJNA690234	26768	250	1.276836	3.19209	Cutibacterium	1912216	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g26401	i0	100	53	250	0	100	0	1	250	1939770	1940019	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13250	462	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10107535	10107535	PRJNA690234_P_NODE_26908_length_250_cov_0.881356_g26541_i0	PRJNA690234	26908	250	0.881356	2.20339	Micrococcus	1269	Bacteria	Bacteria	327	3.36e-85	NTclustered	gi\|1666025147\|gb\|CP025616.2\|	1270	g26541	i0	91.6	33.548	250	2	100	8	1	250	1300599	1300829	Micrococcus luteus strain SGAir0127 chromosome, complete genome	blastn	8387	327	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
10874063	10874063	PRJNA690234_P_NODE_17169_length_306_cov_2.210300_g16802_i0	PRJNA690234	17169	306	2.2103	6.763518	Rhodoluna limnophila	232537	Bacteria	Bacteria	462	1.11e-125	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g16802	i0	94.352	160.457516339869	301	17	98	0	1	301	476549	476849	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	49100	462	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
10874351	10874351	PRJNA690234_P_NODE_29749_length_245_cov_0.906977_g29382_i0	PRJNA690234	29749	245	0.906977	2.22209365	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	370	5.38e-98	NTclustered	gi\|1886103711\|gb\|CP043732.1\|	57043	g29382	i0	93.878	66.8612244897959	245	15	100	0	1	245	1007079	1006835	Microbacterium esteraromaticum strain B24 chromosome	blastn	16381	370	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
11382349	11382349	PRJNA690234_P_NODE_29209_length_246_cov_0.901734_g28842_i0	PRJNA690234	29209	246	0.901734	2.21826564	Cutibacterium	1912216	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g28842	i0	99.593	53	246	1	100	0	1	246	733723	733968	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13038	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11382357	11382357	PRJNA690234_P_NODE_31109_length_243_cov_0.917647_g30742_i0	PRJNA690234	31109	243	0.917647	2.22988221	Cutibacterium	1912216	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g30742	i0	100	85.6954732510288	243	0	100	0	1	243	1215312	1215070	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	20824	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12149574	12149574	PRJNA690234_P_NODE_27530_length_249_cov_0.886364_g27163_i0	PRJNA690234	27530	249	0.886364	2.20704636	Herbiconiux sp. L3-i23	2905871	Bacteria	Bacteria	309	1.21e-79	NTclustered	gi\|2238890657\|dbj\|AP025737.1\|	2905871	g27163	i0	91.892	91.140562248996	222	16	89	2	21	241	735432	735212	Herbiconiux sp. L3-i23 L3-i23 DNA, complete genome	blastn	22694	309	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Herbiconiux	Herbiconiux sp. L3-i23
15207455	15207455	PRJNA690234_P_NODE_23732_length_260_cov_1.647059_g23365_i0	PRJNA690234	23732	260	1.647059	4.2823534	Cutibacterium	1912216	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g23365	i0	100	51.5192307692308	260	0	100	0	1	260	1317731	1317990	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	13395	481	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16481675	16481675	PRJNA690234_P_NODE_26093_length_251_cov_1.640449_g25726_i0	PRJNA690234	26093	251	1.640449	4.11752699	Cutibacterium	1912216	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g25726	i0	99.203	59.5617529880478	251	2	100	0	1	251	2478569	2478819	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	14950	453	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16481689	16481689	PRJNA690234_P_NODE_30073_length_245_cov_0.906977_g29706_i0	PRJNA690234	30073	245	0.906977	2.22209365	Cutibacterium	1912216	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g29706	i0	100	51.134693877551	245	0	100	0	1	245	2193300	2193056	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12528	453	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17247958	17247958	PRJNA690234_P_NODE_18014_length_299_cov_1.256637_g17647_i0	PRJNA690234	18014	299	1.256637	3.75734463	Streptomyces sp. NBC_01216	2903778	Bacteria	Bacteria	518	2.28e-142	NTclustered	gi\|2654510592\|gb\|CP108677.1\|	2903778	g17647	i0	97.993	607.1872909699	299	4	100	2	1	299	4013655	4013359	Streptomyces sp. NBC_01216 chromosome, complete genome	blastn	181549	518	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01216
19030551	19030551	PRJNA690234_P_NODE_27575_length_249_cov_0.886364_g27208_i0	PRJNA690234	27575	249	0.886364	2.20704636	Corynebacterium	1716	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2550471320\|gb\|CP100376.1\|	38284	g27208	i0	100	30.0401606425703	249	0	100	0	1	249	1377184	1377432	Corynebacterium accolens strain CA7 chromosome	blastn	7480	460	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
19797076	19797076	PRJNA690234_P_NODE_22256_length_269_cov_1.418367_g21889_i0	PRJNA690234	22256	269	1.418367	3.81540723	Brooklawnia propionicigenes	3041175	Bacteria	Bacteria	231	2.95e-56	NTclustered	gi\|2504553319\|dbj\|AP028056.1\|	3041175	g21889	i0	82.288	166.758364312268	271	44	100	4	1	269	333828	333560	Brooklawnia propionicigenes SH051 DNA, complete genome	blastn	44858	231	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Brooklawnia	Brooklawnia propionicigenes
22347438	22347438	PRJNA690234_P_NODE_19378_length_288_cov_1.293023_g19011_i0	PRJNA690234	19378	288	1.293023	3.72390624	Actinomadura sp. WMMA1423	2591108	Bacteria	Bacteria	119	2.59e-22	NTclustered	gi\|1697170146\|gb\|CP041244.1\|	2591108	g19011	i0	92.683	24.1493055555556	82	6	28	0	1	82	142366	142285	Actinomadura sp. WMMA1423 chromosome	blastn	6955	119	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp. WMMA1423
22347654	22347654	PRJNA690234_P_NODE_28978_length_246_cov_1.514451_g28611_i0	PRJNA690234	28978	246	1.514451	3.72554946	Pseudarthrobacter oxydans	1671	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|2630413760\|gb\|CP139438.1\|	1671	g28611	i0	89.431	7.96747967479675	246	26	100	0	1	246	932364	932119	Pseudarthrobacter oxydans strain RH60 chromosome, complete genome	blastn	1960	311	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
22856251	22856251	PRJNA690234_P_NODE_8798_length_432_cov_1.520891_g8432_i0	PRJNA690234	8798	432	1.520891	6.57024912	Micrococcales	85006	Bacteria	Bacteria	787	0	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g8432	i0	99.767	183.115740740741	429	1	99	0	4	432	1114	686	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	79106	793	0.992433795712484	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
25405302	25405302	PRJNA690234_P_NODE_16920_length_309_cov_1.309322_g16553_i0	PRJNA690234	16920	309	1.309322	4.04580498	Streptomycetaceae	2062	Bacteria	Bacteria	566	8.33e-157	NTclustered	gi\|343457561\|gb\|JF424163.1\|	1887	g16553	i0	99.676	610.135922330097	309	1	100	0	1	309	844	1152	Streptomyces viridodiastaticus strain KCTC 19977 23S ribosomal RNA gene, partial sequence	blastn	188532	571	0.991243432574431	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albogriseolus

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