metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA561138" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA561138" 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
1130638	1130638	PRJNA561138_P_NODE_1081_length_1190_cov_5.345568_g930_i0	PRJNA561138	1081	1190	5.345568	63.6122592	Rhodococcus	1827	Bacteria	Bacteria	2182	0	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g930	i0	99.748	417.305882352941	1190	3	100	0	1	1190	4196677	4197866	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	496594	2198	0.992720655141037	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
1130667	1130667	PRJNA561138_P_NODE_17881_length_309_cov_0.978814_g17686_i0	PRJNA561138	17881	309	0.978814	3.02453526	Streptomyces	1883	Bacteria	Bacteria	60.2	1.72e-4	NTclustered	gi\|2094040734\|gb\|CP082945.1\|	285578	g17686	i0	92.857	0.381877022653722	42	1	13	2	165	205	525282	525242	Streptomyces angustmyceticus strain JCM 4053 chromosome, complete genome	blastn	118	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces angustmyceticus
1130711	1130711	PRJNA561138_P_NODE_29181_length_242_cov_1.822485_g28986_i0	PRJNA561138	29181	242	1.822485	4.4104137	Streptomyces	1883	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2659047069\|gb\|CP108013.1\|	2903646	g28986	i0	100	0.487603305785124	28	0	12	0	210	237	3732349	3732322	Streptomyces sp. NBC_00328 chromosome, complete genome	blastn	118	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00328
1820706	1820706	PRJNA561138_P_NODE_20622_length_284_cov_1.459716_g20427_i0	PRJNA561138	20622	284	1.459716	4.14559344	Leifsonia sp. ZF2019	2781978	Bacteria	Bacteria	235	2.43e-57	NTclustered	gi\|2093112753\|gb\|CP065037.1\|	2781978	g20427	i0	84.082	6.57042253521127	245	37	86	2	2	245	3840639	3840882	Leifsonia sp. ZF2019 chromosome, complete genome	blastn	1866	235	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. ZF2019
1820827	1820827	PRJNA561138_P_NODE_29442_length_242_cov_0.911243_g29247_i0	PRJNA561138	29442	242	0.911243	2.20520806	Cutibacterium acnes	1747	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2493035247\|gb\|CP114009.1\|	1747	g29247	i0	100	50.9628099173554	242	0	100	0	1	242	19971	19730	Cutibacterium acnes strain CBS-BPNBT19223 chromosome, complete genome	blastn	12333	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3096032	3096032	PRJNA561138_P_NODE_23023_length_263_cov_1.300000_g22828_i0	PRJNA561138	23023	263	1.3	3.419	Microbacterium atlanticum	2782168	Bacteria	Bacteria	257	4.7400000000000005e-64	NTclustered	gi\|1929479552\|gb\|CP063813.1\|	2782168	g22828	i0	84.528	49.4144486692015	265	35	99	6	2	263	1848485	1848746	Microbacterium sp. WY121 chromosome, complete genome	blastn	12996	257	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium atlanticum
4958722	4958722	PRJNA561138_P_NODE_19544_length_293_cov_1.400000_g19349_i0	PRJNA561138	19544	293	1.4	4.102	Amycolatopsis	1813	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1086009940\|emb\|LT629789.1\|	129921	g19349	i0	100	0.191126279863481	28	0	10	0	17	44	5686058	5686031	Amycolatopsis keratiniphila strain FH 1893 genome assembly, chromosome: I	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis keratiniphila
5648753	5648753	PRJNA561138_P_NODE_10005_length_404_cov_1.395770_g9810_i0	PRJNA561138	10005	404	1.39577	5.6389108	Streptomyces nitrosporeus	28894	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1751398356\|gb\|CP023702.1\|	28894	g9810	i0	100	0.0717821782178218	29	0	7	0	226	254	5746940	5746912	Streptomyces nitrosporeus strain ATCC 12769 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces nitrosporeus
5648915	5648915	PRJNA561138_P_NODE_25125_length_250_cov_0.870056_g24930_i0	PRJNA561138	25125	250	0.870056	2.17514	Mycobacterium tuberculosis	1773	Bacteria	Bacteria	335	2.0099999999999996e-87	NTclustered	gi\|2556671644\|gb\|CP130756.1\|	1773	g24930	i0	100	2.12	181	0	72	0	13	193	4359363	4359183	Mycobacterium tuberculosis strain MTb-Oman-3216462 chromosome, complete genome	blastn	530	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
6234202	6234202	PRJNA561138_P_NODE_19125_length_297_cov_1.031250_g18930_i0	PRJNA561138	19125	297	1.03125	3.0628125	Actinomycetes	1760	Bacteria	Bacteria	195	4.33e-45	NTclustered	gi\|1108516157\|gb\|CP018063.1\|	1570939	g18930	i0	83.333	7.07407407407407	210	35	71	0	55	264	1751591	1751382	Rhodococcus sp. 2G, complete genome	blastn	2101	196	0.994897959183674	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. 2G
6923052	6923052	PRJNA561138_P_NODE_20746_length_283_cov_1.285714_g20551_i0	PRJNA561138	20746	283	1.285714	3.63857062	Mycobacterium sp. Z3061	3073562	Bacteria	Bacteria	259	1.43e-64	NTclustered	gi\|2578572951\|gb\|CP134062.1\|	3073562	g20551	i0	84.859	2.00706713780919	284	14	100	15	1	283	4189197	4188942	Mycobacterium sp. Z3061 chromosome, complete genome	blastn	568	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. Z3061
7508603	7508603	PRJNA561138_P_NODE_23826_length_256_cov_1.437158_g23631_i0	PRJNA561138	23826	256	1.437158	3.67912448	Actinomyces	1654	Bacteria	Bacteria	405	1.55e-108	NTclustered	gi\|1948687139\|gb\|CP066060.1\|	544580	g23631	i0	95.984	9.8515625	249	10	97	0	8	256	2892849	2892601	Actinomyces oris strain FDAARGOS_1051 chromosome, complete genome	blastn	2522	405	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
8783540	8783540	PRJNA561138_P_NODE_18747_length_300_cov_5.471366_g18552_i0	PRJNA561138	18747	300	5.471366	16.414098	root	1	Root_unresolved	Root_unresolved	272	1.9699999999999997e-68	NTclustered	gi\|1008904259\|emb\|LT223647.1\|	1711	g18552	i0	99.333	93.4366666666667	150	1	100	0	151	300	480	331	Cellulomonas flavigena partial 16S rRNA gene, strain Marseille-P2084	blastn	28031	274	0.992700729927007	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas flavigena
10059205	10059205	PRJNA561138_P_NODE_26548_length_248_cov_0.880000_g26353_i0	PRJNA561138	26548	248	0.88	2.1824	Mycobacteriaceae	1762	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1176886821\|gb\|CP019885.1\|	1768	g26353	i0	100	19	248	0	100	0	1	248	6352661	6352414	Mycobacterium kansasii strain 6MK chromosome	blastn	4712	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium kansasii
10749420	10749420	PRJNA561138_P_NODE_25429_length_250_cov_0.870056_g25234_i0	PRJNA561138	25429	250	0.870056	2.17514	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|1806463312\|dbj\|AP022616.1\|	319706	g25234	i0	99.2	14.884	250	2	100	0	1	250	5501612	5501363	Mycolicibacterium phocaicum JCM 15301 DNA, nearly complete genome	blastn	3721	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
11333738	11333738	PRJNA561138_P_NODE_10629_length_395_cov_0.956522_g10434_i0	PRJNA561138	10629	395	0.956522	3.7782619	Saccharopolyspora	1835	Bacteria	Bacteria	394	5.45e-105	NTclustered	gi\|21927981\|gb\|AY117133.1\|	1836	g10434	i0	85.455	99.1164556962025	385	48	96	7	15	395	3609	3229	Saccharopolyspora erythraea methylmalonyl-CoA mutase operon, partial sequence	blastn	39151	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora erythraea
11333759	11333759	PRJNA561138_P_NODE_15889_length_329_cov_1.253906_g15694_i0	PRJNA561138	15889	329	1.253906	4.12535074	Microbacterium	33882	Bacteria	Bacteria	606	5.269999999999998e-169	NTclustered	gi\|1341395247\|gb\|MG926589.1\|	2033	g15694	i0	100	101.604863221885	328	0	99	0	2	329	332	5	Microbacterium testaceum strain OB24-R 16S ribosomal RNA gene, partial sequence	blastn	33428	606	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
12024277	12024277	PRJNA561138_P_NODE_7210_length_463_cov_0.987179_g7016_i0	PRJNA561138	7210	463	0.987179	4.57063877	Streptomyces sp. A2-16	2781734	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2028936199\|gb\|CP063808.1\|	2781734	g7016	i0	100	0.0647948164146868	30	0	6	0	34	63	6422183	6422212	Streptomyces sp. A2-16 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. A2-16
12609595	12609595	PRJNA561138_P_NODE_20130_length_288_cov_1.320930_g19935_i0	PRJNA561138	20130	288	1.32093	3.8042784	Leifsonia	110932	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|1890945858\|gb\|CP043643.1\|	150026	g19935	i0	99.653	2	288	1	100	0	1	288	13337	13624	Leifsonia shinshuensis strain INR9 plasmid unnamed2, complete sequence	blastn	576	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia shinshuensis
12609627	12609627	PRJNA561138_P_NODE_28390_length_244_cov_0.900585_g28195_i0	PRJNA561138	28390	244	0.900585	2.1974274	Rhodococcus	1827	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g28195	i0	100	66.1516393442623	244	0	100	0	1	244	4762288	4762531	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	16141	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
13884531	13884531	PRJNA561138_P_NODE_7891_length_444_cov_1.037736_g7696_i0	PRJNA561138	7891	444	1.037736	4.60754784	Aeromicrobium	2040	Bacteria	Bacteria	302	3.8600000000000004e-77	NTclustered	gi\|1380481754\|gb\|CP026952.1\|	2079793	g7696	i0	84.013	64.9324324324324	319	45	71	5	129	444	2937303	2936988	Aeromicrobium chenweiae strain 592 chromosome, complete genome	blastn	28830	303	0.996699669966997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium chenweiae
15158699	15158699	PRJNA561138_P_NODE_26492_length_248_cov_0.880000_g26297_i0	PRJNA561138	26492	248	0.88	2.1824	Cutibacterium	1912216	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g26297	i0	100	54.0120967741936	248	0	100	0	1	248	1251627	1251874	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13395	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16433330	16433330	PRJNA561138_P_NODE_23113_length_262_cov_1.613757_g22918_i0	PRJNA561138	23113	262	1.613757	4.22804334	Cutibacterium	1912216	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g22918	i0	100	267.854961832061	262	0	100	0	1	262	56198	56459	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	70178	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16433369	16433369	PRJNA561138_P_NODE_9153_length_418_cov_1.101449_g8958_i0	PRJNA561138	9153	418	1.101449	4.60405682	Cutibacterium	1912216	Bacteria	Bacteria	767	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8958	i0	99.761	271.421052631579	418	1	100	0	1	418	57121	56704	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	113454	767	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17122810	17122810	PRJNA561138_P_NODE_25654_length_249_cov_0.875000_g25459_i0	PRJNA561138	25654	249	0.875	2.17875	Micrococcus lylae	1273	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|2514694063\|gb\|CP126965.1\|	1273	g25459	i0	98.795	100.076305220884	249	3	100	0	1	249	1030758	1030510	Micrococcus lylae strain UMB0955 chromosome, complete genome	blastn	24919	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus lylae
17708545	17708545	PRJNA561138_P_NODE_14094_length_348_cov_2.720000_g13899_i0	PRJNA561138	14094	348	2.72	9.4656	root	1	Root_unresolved	Root_unresolved	643	4.279999999999998e-180	NTclustered	gi\|50082565\|gb\|AY642042.1\|	1747	g13899	i0	100	129	348	0	100	0	1	348	350	3	Propionibacterium acnes isolate L1958 16S ribosomal RNA gene, partial sequence	blastn	44892	643	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17708596	17708596	PRJNA561138_P_NODE_26794_length_247_cov_0.885057_g26599_i0	PRJNA561138	26794	247	0.885057	2.18609079	Microbacterium	33882	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g26599	i0	100	181.534412955466	247	0	100	0	1	247	2452115	2452361	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	44839	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
18982022	18982022	PRJNA561138_P_NODE_20095_length_288_cov_1.432558_g19900_i0	PRJNA561138	20095	288	1.432558	4.12576704	Cutibacterium	1912216	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|966544767\|gb\|CP012355.1\|	1747	g19900	i0	100	50.9930555555556	288	0	100	0	1	288	286609	286322	Cutibacterium acnes strain PA_15_1_R1 chromosome, complete genome	blastn	14686	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22222225	22222225	PRJNA561138_P_NODE_28438_length_244_cov_0.900585_g28243_i0	PRJNA561138	28438	244	0.900585	2.1974274	Cutibacterium acnes	1747	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|2493032747\|gb\|CP114008.1\|	1747	g28243	i0	98.361	52.9590163934426	244	4	100	0	1	244	277474	277231	Cutibacterium acnes strain CBS-BPNBT19227 chromosome, complete genome	blastn	12922	429	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25356947	25356947	PRJNA561138_P_NODE_17260_length_315_cov_1.053719_g17065_i0	PRJNA561138	17260	315	1.053719	3.31921485	Microbacterium	33882	Bacteria	Bacteria	577	3.9299999999999986e-160	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g17065	i0	99.683	180.04126984127	315	1	100	0	1	315	561	875	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	56713	577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum

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