metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA345071" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA345071" 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
393350	393350	PRJNA345071_P_NODE_2641_length_361_cov_1.083333_g2601_i0	PRJNA345071	2641	361	1.083333	3.91083213	Pseudonocardia broussonetiae	2736640	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1844840499\|gb\|CP053564.1\|	2736640	g2601	i0	100	0.0831024930747922	30	0	8	0	225	254	454407	454378	Pseudonocardia broussonetiae strain Gen 01 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia broussonetiae
393400	393400	PRJNA345071_P_NODE_4341_length_304_cov_1.303030_g4301_i0	PRJNA345071	4341	304	1.30303	3.9612112	Nocardioides sp. InS609-2	2760705	Bacteria	Bacteria	438	1.8599999999999998e-118	NTclustered	gi\|2232818235\|gb\|CP060034.1\|	2760705	g4301	i0	92.787	348.582236842105	305	18	99	2	1	303	123328	123630	Nocardioides sp. InS609-2 chromosome, complete genome	blastn	105969	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. InS609-2
393460	393460	PRJNA345071_P_NODE_6621_length_265_cov_1.395833_g6581_i0	PRJNA345071	6621	265	1.395833	3.69895745	Propioniciclava sp. MC1595	2760308	Bacteria	Bacteria	361	3.539999999999999e-95	NTclustered	gi\|2016305036\|gb\|CP071870.1\|	2760308	g6581	i0	93.145	206.169811320755	248	13	93	4	1	247	2051471	2051715	Propioniciclava sp. MC1595 chromosome, complete genome	blastn	54635	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propioniciclava	Propioniciclava sp. MC1595
3621073	3621073	PRJNA345071_P_NODE_8263_length_251_cov_0.876404_g8223_i0	PRJNA345071	8263	251	0.876404	2.19977404	Cutibacterium	1912216	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g8223	i0	100	51	251	0	100	0	1	251	822730	822980	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12801	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4220598	4220598	PRJNA345071_P_NODE_3744_length_320_cov_2.668016_g3704_i0	PRJNA345071	3744	320	2.668016	8.5376512000000009	uncultured Acidimicrobiaceae bacterium	410722	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2874254026\|emb\|OY970351.1\|	410722	g3704	i0	100	0.0875	28	0	9	0	89	116	536244	536217	MAG: uncultured Acidimicrobiaceae bacterium isolate MFD06092.bin.1.32 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae		uncultured Acidimicrobiaceae bacterium
4220708	4220708	PRJNA345071_P_NODE_8784_length_249_cov_0.886364_g8744_i0	PRJNA345071	8784	249	0.886364	2.20704636	Conexibacter sp. SYSU D00693	2812560	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1995533341\|gb\|CP070950.1\|	2812560	g8744	i0	96.97	0.132530120481928	33	0	13	1	131	162	2159838	2159870	Conexibacter sp. SYSU D00693 chromosome	blastn	33	54.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Conexibacteraceae	Conexibacter	Conexibacter sp. SYSU D00693
4898220	4898220	PRJNA345071_P_NODE_10864_length_242_cov_0.923077_g10824_i0	PRJNA345071	10864	242	0.923077	2.23384634	Cutibacterium	1912216	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10824	i0	100	72.0413223140496	242	0	100	0	1	242	1738576	1738817	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	17434	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4898239	4898239	PRJNA345071_P_NODE_6024_length_274_cov_1.124378_g5984_i0	PRJNA345071	6024	274	1.124378	3.08079572	Cutibacterium	1912216	Bacteria	Bacteria	496	9.67e-136	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5984	i0	99.27	51	274	2	100	0	1	274	1754459	1754186	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13974	496	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4898257	4898257	PRJNA345071_P_NODE_9004_length_248_cov_0.891429_g8964_i0	PRJNA345071	9004	248	0.891429	2.21074392	Cutibacterium	1912216	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8964	i0	100	51.5645161290323	248	0	100	0	1	248	1477166	1476919	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12788	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4898263	4898263	PRJNA345071_P_NODE_9644_length_246_cov_0.901734_g9604_i0	PRJNA345071	9644	246	0.901734	2.21826564	Cutibacterium	1912216	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g9604	i0	100	50.8861788617886	246	0	100	0	1	246	681754	681509	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12518	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4898265	4898265	PRJNA345071_P_NODE_9924_length_245_cov_0.906977_g9884_i0	PRJNA345071	9924	245	0.906977	2.22209365	Microbacterium	33882	Bacteria	Bacteria	361	3.2399999999999996e-95	NTclustered	gi\|2447060921\|gb\|CP078075.1\|	69367	g9884	i0	93.416	60.2326530612245	243	16	99	0	3	245	2808820	2809062	Microbacterium luteolum strain KACC 14465 chromosome	blastn	14757	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium luteolum
6770882	6770882	PRJNA345071_P_NODE_11046_length_236_cov_2.294479_g11006_i0	PRJNA345071	11046	236	2.294479	5.41497044	Blastococcus brunescens	1564165	Bacteria	Bacteria	394	3.05e-105	NTclustered	gi\|2645903955\|gb\|CP141261.1\|	1564165	g11006	i0	97.009	357.262711864407	234	7	99	0	1	234	1983990	1983757	Blastococcus brunescens strain BMG 8361 chromosome, complete genome	blastn	84314	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus brunescens
8722948	8722948	PRJNA345071_P_NODE_7907_length_252_cov_0.871508_g7867_i0	PRJNA345071	7907	252	0.871508	2.19620016	Cutibacterium	1912216	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7867	i0	100	59.8968253968254	252	0	100	0	1	252	1583082	1582831	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15094	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10597125	10597125	PRJNA345071_P_NODE_6229_length_271_cov_1.146465_g6189_i0	PRJNA345071	6229	271	1.146465	3.10692015	Corynebacterium propinquum	43769	Bacteria	Bacteria	412	9.899999999999997e-111	NTclustered	gi\|2550436109\|gb\|CP100368.1\|	43769	g6189	i0	94.096	342.472324723247	271	16	100	0	1	271	2509858	2509588	Corynebacterium propinquum strain CP4 chromosome	blastn	92810	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium propinquum
11273608	11273608	PRJNA345071_P_NODE_8649_length_249_cov_0.886364_g8609_i0	PRJNA345071	8649	249	0.886364	2.20704636	Streptomyces	1883	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2328521855\|gb\|CP098740.1\|	202862	g8609	i0	88.889	2.38955823293173	45	1	16	3	194	234	4153009	4152965	Streptomyces drozdowiczii strain MDA8-470 chromosome, complete genome	blastn	595	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces drozdowiczii
11872073	11872073	PRJNA345071_P_NODE_9250_length_247_cov_0.896552_g9210_i0	PRJNA345071	9250	247	0.896552	2.21448344	Kocuria rosea	1275	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1540076968\|emb\|LR134391.1\|	1275	g9210	i0	99.19	57.8178137651822	247	2	100	0	1	247	3183561	3183807	Kocuria rosea strain NCTC7514 genome assembly, chromosome: 1	blastn	14281	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
12548928	12548928	PRJNA345071_P_NODE_9950_length_245_cov_0.906977_g9910_i0	PRJNA345071	9950	245	0.906977	2.22209365	Cutibacterium	1912216	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g9910	i0	100	53.6326530612245	245	0	100	0	1	245	994296	994052	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	13140	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13147083	13147083	PRJNA345071_P_NODE_9251_length_247_cov_0.896552_g9211_i0	PRJNA345071	9251	247	0.896552	2.21448344	uncultured Solirubrobacterales bacterium	768556	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253915\|emb\|OY970240.1\|	768556	g9211	i0	96.774	0.125506072874494	31	1	13	0	18	48	1024610	1024640	MAG: uncultured Solirubrobacterales bacterium isolate MFD09212.bin.c.4 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			uncultured Solirubrobacterales bacterium
15696108	15696108	PRJNA345071_P_NODE_9533_length_246_cov_0.901734_g9493_i0	PRJNA345071	9533	246	0.901734	2.21826564	Leifsonia xyli	1575	Bacteria	Bacteria	211	3.46e-50	NTclustered	gi\|1029984024\|gb\|CP014761.1\|	1575	g9493	i0	82.329	25.8414634146341	249	38	100	5	1	246	721302	721547	Leifsonia xyli strain SE134 chromosome, complete genome	blastn	6357	211	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia xyli
16372943	16372943	PRJNA345071_P_NODE_3253_length_336_cov_2.342205_g3213_i0	PRJNA345071	3253	336	2.342205	7.8698088	Cutibacterium	1912216	Bacteria	Bacteria	616	8.96e-172	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3213	i0	100	290.845238095238	333	0	100	0	1	333	57032	57364	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	97724	616	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18245044	18245044	PRJNA345071_P_NODE_9375_length_247_cov_0.896552_g9335_i0	PRJNA345071	9375	247	0.896552	2.21448344	Actinomarinicola tropica	2789776	Bacteria	Bacteria	99	2.83e-16	NTclustered	gi\|1774476215\|gb\|CP045851.1\|	2789776	g9335	i0	85.567	0.736842105263158	97	11	39	3	152	247	251951	252045	Actinomarinicola tropica strain SCSIO 58843 chromosome, complete genome	blastn	182	99	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Iamiaceae	Actinomarinicola	Actinomarinicola tropica
18921863	18921863	PRJNA345071_P_NODE_655_length_627_cov_3.638989_g615_i0	PRJNA345071	655	627	3.638989	22.81646103	Cutibacterium	1912216	Bacteria	Bacteria	1147	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g615	i0	99.681	269.40350877193	627	2	100	0	1	627	55358	55984	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	168916	1147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19519039	19519039	PRJNA345071_P_NODE_10136_length_244_cov_0.912281_g10096_i0	PRJNA345071	10136	244	0.912281	2.22596564	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g10096	i0	100	17.4467213114754	244	0	100	0	1	244	1576042	1576285	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	4257	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
19519240	19519240	PRJNA345071_P_NODE_8516_length_250_cov_0.881356_g8476_i0	PRJNA345071	8516	250	0.881356	2.20339	Mycobacterium heckeshornense	110505	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1958892552\|dbj\|AP024310.1\|	110505	g8476	i0	100	0.224	28	0	11	0	47	74	374373	374346	Mycobacterium heckeshornense JMUB5695 DNA, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium heckeshornense
21472108	21472108	PRJNA345071_P_NODE_3597_length_324_cov_2.920319_g3557_i0	PRJNA345071	3597	324	2.920319	9.46183356	Cutibacterium	1912216	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3557	i0	100	281.904320987654	324	0	100	0	1	324	56418	56741	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	91337	599	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22069723	22069723	PRJNA345071_P_NODE_10778_length_242_cov_0.923077_g10738_i0	PRJNA345071	10778	242	0.923077	2.23384634	Corynebacterium accolens	38284	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2242616707\|gb\|CP046605.1\|	38284	g10738	i0	98.347	29.9628099173554	242	4	100	0	1	242	2389602	2389843	Corynebacterium accolens strain DSM 44278 chromosome, complete genome	blastn	7251	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
22747333	22747333	PRJNA345071_P_NODE_9678_length_246_cov_0.901734_g9638_i0	PRJNA345071	9678	246	0.901734	2.21826564	Cutibacterium	1912216	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9638	i0	100	49.0365853658537	246	0	100	0	1	246	800853	801098	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12063	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23345308	23345308	PRJNA345071_P_NODE_5939_length_275_cov_1.188119_g5899_i0	PRJNA345071	5939	275	1.188119	3.26732725	Auraticoccus monumenti	675864	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1085627832\|emb\|LT629688.1\|	675864	g5899	i0	100	0.105454545454545	29	0	11	0	196	224	1596451	1596423	Auraticoccus monumenti strain MON 2.2 genome assembly, chromosome: I	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Auraticoccus	Auraticoccus monumenti
24619473	24619473	PRJNA345071_P_NODE_2460_length_371_cov_1.469799_g2420_i0	PRJNA345071	2460	371	1.469799	5.45295429	Nocardioides sp. B-3	2895565	Bacteria	Bacteria	610	4.64e-170	NTclustered	gi\|2286662645\|gb\|CP087968.1\|	2895565	g2420	i0	96.257	214.204851752022	374	11	100	2	1	371	3322573	3322200	Nocardioides sp. B-3 chromosome, complete genome	blastn	79470	610	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. B-3
24619549	24619549	PRJNA345071_P_NODE_5420_length_283_cov_1.852381_g5380_i0	PRJNA345071	5420	283	1.852381	5.24223823	Nocardioides seonyuensis	2518371	Bacteria	Bacteria	484	2.1699999999999994e-132	NTclustered	gi\|1608352957\|gb\|CP038436.1\|	2518371	g5380	i0	97.527	234.452296819788	283	7	100	0	1	283	3103615	3103897	Nocardioides seonyuensis strain MMS17-SY207-3 chromosome, complete genome	blastn	66350	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides seonyuensis
25296611	25296611	PRJNA345071_P_NODE_5500_length_282_cov_1.492823_g5460_i0	PRJNA345071	5500	282	1.492823	4.20976086	Cutibacterium	1912216	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|1755605466\|dbj\|AP019664.1\|	1747	g5460	i0	100	51	282	0	100	0	1	282	1551790	1551509	Cutibacterium acnes TP-CU389 DNA, complete genome	blastn	14382	521	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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