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

28 rows where analysis = "blastn", bioproject = "PRJNA352610" 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
393653	393653	PRJNA352610_P_NODE_12521_length_339_cov_0.770677_g12460_i0	PRJNA352610	12521	339	0.770677	2.61259503	Corynebacterium sp. YSMAA1_1_F7	3383590	Bacteria	Bacteria	564	3.33e-156	NTclustered	gi\|2869833946\|gb\|CP175789.1\|	3383590	g12460	i0	96.755	343.6401179941	339	9	100	2	1	339	796219	795883	Corynebacterium sp. YSMAA1_1_F7 chromosome, complete genome	blastn	116494	564	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_F7
393865	393865	PRJNA352610_P_NODE_23521_length_259_cov_1.467742_g23460_i0	PRJNA352610	23521	259	1.467742	3.80145178	Streptomyces poriferorum	2798799	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2562642067\|gb\|CP120990.1\|	2798799	g23460	i0	96.97	0.563706563706564	33	1	13	0	61	93	4933402	4933370	Streptomyces poriferorum strain Alt1 chromosome, complete genome	blastn	146	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces poriferorum
2345891	2345891	PRJNA352610_P_NODE_62_length_1962_cov_3.499735_g58_i0	PRJNA352610	62	1962	3.499735	68.6648007	Cutibacterium	1912216	Bacteria	Bacteria	3613	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g58	i0	99.898	281.995922528033	1962	2	100	0	1	1962	606992	608953	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	553276	3613	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3621174	3621174	PRJNA352610_P_NODE_25063_length_251_cov_0.865169_g25002_i0	PRJNA352610	25063	251	0.865169	2.17157419	Cutibacterium	1912216	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g25002	i0	100	53.00796812749	251	0	100	0	1	251	159969	160219	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13305	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4220917	4220917	PRJNA352610_P_NODE_15364_length_314_cov_0.834025_g15303_i0	PRJNA352610	15364	314	0.834025	2.6188385	Corynebacterium accolens	38284	Bacteria	Bacteria	484	2.4399999999999998e-132	NTclustered	gi\|2242616707\|gb\|CP046605.1\|	38284	g15303	i0	98.195	284.200636942675	277	5	88	0	1	277	2012554	2012830	Corynebacterium accolens strain DSM 44278 chromosome, complete genome	blastn	89239	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
6173413	6173413	PRJNA352610_P_NODE_26005_length_250_cov_0.870056_g25944_i0	PRJNA352610	26005	250	0.870056	2.17514	Cutibacterium	1912216	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g25944	i0	100	51	250	0	100	0	1	250	2262517	2262268	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12750	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
7448392	7448392	PRJNA352610_P_NODE_18566_length_290_cov_0.834101_g18505_i0	PRJNA352610	18566	290	0.834101	2.4188929	Bacillati	1783272	Bacteria	Bacteria	525	1.32e-144	NTclustered	gi\|1678593041\|gb\|CP035103.1\|	1275	g18505	i0	99.31	109.575862068966	290	2	100	0	1	290	2504874	2504585	Kocuria rosea strain ATCC 186 chromosome, complete genome	blastn	31777	525	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
7448421	7448421	PRJNA352610_P_NODE_29046_length_245_cov_0.895349_g28985_i0	PRJNA352610	29046	245	0.895349	2.19360505	Cutibacterium	1912216	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g28985	i0	99.592	52.1428571428571	245	1	100	0	1	245	2110036	2110280	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	12775	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8723080	8723080	PRJNA352610_P_NODE_29807_length_244_cov_0.900585_g29746_i0	PRJNA352610	29807	244	0.900585	2.1974274	Cutibacterium	1912216	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g29746	i0	100	51	244	0	100	0	1	244	1347673	1347430	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	12444	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9321977	9321977	PRJNA352610_P_NODE_30028_length_244_cov_0.900585_g29967_i0	PRJNA352610	30028	244	0.900585	2.1974274	Streptomyces sp. NBC_01546	2975872	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2656295666\|gb\|CP109379.1\|	2975872	g29967	i0	100	0.114754098360656	28	0	11	0	191	218	4028124	4028097	Streptomyces sp. NBC_01546 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01546
9998653	9998653	PRJNA352610_P_NODE_10808_length_358_cov_1.350877_g10747_i0	PRJNA352610	10808	358	1.350877	4.83613966	root	1	Root_unresolved	Root_unresolved	56.5	0.003	NTclustered	gi\|2657114941\|gb\|CP108188.1\|	68286	g10747	i0	100	19.108938547486	30	0	8	0	236	265	2576336	2576365	Streptomyces zaomyceticus strain NBC_00123 chromosome, complete genome	blastn	6841	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces zaomyceticus
11273715	11273715	PRJNA352610_P_NODE_20089_length_280_cov_1.487923_g20028_i0	PRJNA352610	20089	280	1.487923	4.1661844	Cutibacterium	1912216	Bacteria	Bacteria	518	2.12e-142	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g20028	i0	100	51	280	0	100	0	1	280	1057627	1057906	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	14280	518	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11273751	11273751	PRJNA352610_P_NODE_31469_length_241_cov_1.827381_g31408_i0	PRJNA352610	31469	241	1.827381	4.40398821	Cutibacterium	1912216	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g31408	i0	100	55.9336099585062	241	0	100	0	1	241	2231754	2231514	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	13480	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11872347	11872347	PRJNA352610_P_NODE_1830_length_698_cov_1.376000_g1773_i0	PRJNA352610	1830	698	1.376	9.60448	Streptomyces clavuligerus	1901	Bacteria	Bacteria	67.6	2.49e-6	NTclustered	gi\|1939990771\|gb\|CP065242.1\|	1901	g1773	i0	91.667	7.72349570200573	48	4	7	0	358	405	18608	18655	Streptomyces clavuligerus strain F1D35 plasmid pF1D35A, complete sequence	blastn	5391	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces clavuligerus
12549010	12549010	PRJNA352610_P_NODE_15870_length_310_cov_0.789030_g15809_i0	PRJNA352610	15870	310	0.78903	2.445993	Micrococcus	1269	Bacteria	Bacteria	553	6.509999999999998e-153	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g15809	i0	99.029	247.070967741935	309	2	99	1	3	310	346376	346068	Micrococcus luteus strain V017 chromosome, complete genome	blastn	76592	553	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15696506	15696506	PRJNA352610_P_NODE_25733_length_250_cov_0.870056_g25672_i0	PRJNA352610	25733	250	0.870056	2.17514	Cutibacterium acnes	1747	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2415255273\|gb\|CP114143.1\|	1734925	g25672	i0	100	51	250	0	100	0	1	250	2211686	2211437	Cutibacterium acnes subsp. acnes strain CCSM0331 chromosome, complete genome	blastn	12750	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17648126	17648126	PRJNA352610_P_NODE_14534_length_320_cov_1.085020_g14473_i0	PRJNA352610	14534	320	1.08502	3.472064	Corynebacterium	1716	Bacteria	Bacteria	580	3.099999999999999e-161	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g14473	i0	99.375	361.75625	320	2	100	0	1	320	1898	1579	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	115762	580	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
17648164	17648164	PRJNA352610_P_NODE_30174_length_243_cov_1.588235_g30113_i0	PRJNA352610	30174	243	1.588235	3.85941105	Cutibacterium	1912216	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g30113	i0	99.588	51.6255144032922	243	1	100	0	1	243	1631594	1631836	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12545	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18921993	18921993	PRJNA352610_P_NODE_29375_length_245_cov_0.895349_g29314_i0	PRJNA352610	29375	245	0.895349	2.19360505	Cutibacterium	1912216	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g29314	i0	100	52.9428571428571	245	0	100	0	1	245	782775	782531	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12971	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19519724	19519724	PRJNA352610_P_NODE_28056_length_247_cov_0.885057_g27995_i0	PRJNA352610	28056	247	0.885057	2.18609079	Cutibacterium acnes	1747	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2415255273\|gb\|CP114143.1\|	1734925	g27995	i0	100	51	247	0	100	0	1	247	56767	56521	Cutibacterium acnes subsp. acnes strain CCSM0331 chromosome, complete genome	blastn	12597	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20196593	20196593	PRJNA352610_P_NODE_26636_length_249_cov_0.875000_g26575_i0	PRJNA352610	26636	249	0.875	2.17875	Cutibacterium	1912216	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g26575	i0	100	18.9839357429719	249	0	100	0	1	249	2259291	2259539	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	4727	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20795278	20795278	PRJNA352610_P_NODE_25117_length_251_cov_0.865169_g25056_i0	PRJNA352610	25117	251	0.865169	2.17157419	Cutibacterium acnes	1747	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|2415255273\|gb\|CP114143.1\|	1734925	g25056	i0	98.805	62.6653386454183	251	3	100	0	1	251	962299	962549	Cutibacterium acnes subsp. acnes strain CCSM0331 chromosome, complete genome	blastn	15729	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22747436	22747436	PRJNA352610_P_NODE_18798_length_288_cov_1.334884_g18737_i0	PRJNA352610	18798	288	1.334884	3.84446592	Cutibacterium	1912216	Bacteria	Bacteria	508	1.32e-139	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g18737	i0	98.944	50.6979166666667	284	3	99	0	4	287	40983	40700	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	14601	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23345537	23345537	PRJNA352610_P_NODE_13339_length_330_cov_1.513619_g13278_i0	PRJNA352610	13339	330	1.513619	4.9949427	Corynebacterium gottingense	2041036	Bacteria	Bacteria	508	1.53e-139	NTclustered	gi\|2869851930\|gb\|CP175790.1\|	2041036	g13278	i0	95.062	347.7	324	14	100	2	1	323	2001930	2002252	Corynebacterium gottingense strain YSMAA1_1_F6 chromosome, complete genome	blastn	114741	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium gottingense
23345848	23345848	PRJNA352610_P_NODE_29839_length_244_cov_0.900585_g29778_i0	PRJNA352610	29839	244	0.900585	2.1974274	Corynebacterium jeddahense	1414719	Bacteria	Bacteria	401	1.8999999999999998e-107	NTclustered	gi\|2443262567\|gb\|CP063194.1\|	1414719	g29778	i0	96.311	475.450819672131	244	9	100	0	1	244	917339	917096	Corynebacterium jeddahense strain DSM 45997 chromosome, complete genome	blastn	116010	401	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium jeddahense
23345878	23345878	PRJNA352610_P_NODE_31339_length_242_cov_0.911243_g31278_i0	PRJNA352610	31339	242	0.911243	2.20520806	Cutibacterium avidum	33010	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2047661185\|dbj\|AP024309.1\|	33010	g31278	i0	100	45.7851239669422	242	0	100	0	1	242	270940	271181	Cutibacterium avidum TPCV-14 DNA, complete genome	blastn	11080	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium avidum
24022307	24022307	PRJNA352610_P_NODE_27339_length_248_cov_0.880000_g27278_i0	PRJNA352610	27339	248	0.88	2.1824	Cutibacterium	1912216	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g27278	i0	100	53	248	0	100	0	1	248	1826065	1825818	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	13144	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24022319	24022319	PRJNA352610_P_NODE_31199_length_242_cov_0.911243_g31138_i0	PRJNA352610	31199	242	0.911243	2.20520806	Cutibacterium	1912216	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g31138	i0	100	68.896694214876	242	0	100	0	1	242	1959313	1959072	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16673	448	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);;