metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA473641" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA473641" 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
1719802	1719802	PRJNA473641_P_NODE_18002_length_250_cov_0.870056_g17919_i0	PRJNA473641	18002	250	0.870056	2.17514	Propioniciclava sp. MC1595	2760308	Bacteria	Bacteria	281	2.65e-71	NTclustered	gi\|2016305036\|gb\|CP071870.1\|	2760308	g17919	i0	87.603	60.46	242	30	97	0	7	248	3426399	3426158	Propioniciclava sp. MC1595 chromosome, complete genome	blastn	15115	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propioniciclava	Propioniciclava sp. MC1595
2370898	2370898	PRJNA473641_P_NODE_20362_length_247_cov_0.965517_g20279_i0	PRJNA473641	20362	247	0.965517	2.38482699	Microbacterium	33882	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2805280850\|gb\|CP169427.1\|	69370	g20279	i0	99.595	174.991902834008	247	1	100	0	1	247	624819	625065	Microbacterium trichothecenolyticum strain T2 chromosome, complete genome	blastn	43223	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium trichothecenolyticum
2370901	2370901	PRJNA473641_P_NODE_20922_length_247_cov_0.885057_g20839_i0	PRJNA473641	20922	247	0.885057	2.18609079	Rhodococcus	1827	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2258906618\|dbj\|AP018733.1\|	1833	g20839	i0	100	48.9757085020243	247	0	100	0	1	247	5754578	5754824	Rhodococcus erythropolis JCM 2895 DNA, complete genome	blastn	12097	457	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
4271914	4271914	PRJNA473641_P_NODE_17004_length_251_cov_0.966292_g16921_i0	PRJNA473641	17004	251	0.966292	2.42539292	Streptomyces sp. CMB-StM0423	2059884	Bacteria	Bacteria	63.9	1.05e-5	NTclustered	gi\|1317055927\|gb\|CP025407.1\|	2059884	g16921	i0	100	0.135458167330677	34	0	14	0	38	71	432651	432684	Streptomyces sp. CMB-StM0423 chromosome, complete genome	blastn	34	63.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CMB-StM0423
5548857	5548857	PRJNA473641_P_NODE_4585_length_421_cov_1.106322_g4502_i0	PRJNA473641	4585	421	1.106322	4.65761562	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	662	0	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g4502	i0	95.433	455.985748218527	416	17	98	2	1	414	886126	886541	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	191970	662	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
8098231	8098231	PRJNA473641_P_NODE_25587_length_241_cov_0.916667_g25504_i0	PRJNA473641	25587	241	0.916667	2.20916747	Leifsonia xyli	1575	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|1029984024\|gb\|CP014761.1\|	1575	g25504	i0	94.191	99.3029045643154	241	14	100	0	1	241	3216128	3216368	Leifsonia xyli strain SE134 chromosome, complete genome	blastn	23932	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia xyli
8748445	8748445	PRJNA473641_P_NODE_26187_length_241_cov_0.863095_g26104_i0	PRJNA473641	26187	241	0.863095	2.08005895	Streptomyces	1883	Bacteria	Bacteria	281	2.54e-71	NTclustered	gi\|2297620468\|gb\|CP104005.1\|	285558	g26104	i0	92.821	516.195020746888	195	13	81	1	47	241	1170973	1171166	Streptomyces carpaticus strain SCPM-O-B-9993 chromosome, complete genome	blastn	124403	283	0.992932862190813	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces carpaticus
9372604	9372604	PRJNA473641_P_NODE_13728_length_279_cov_1.218447_g13645_i0	PRJNA473641	13728	279	1.218447	3.39946713	Microbacterium sediminis	904291	Bacteria	Bacteria	187	6.749999999999998e-43	NTclustered	gi\|1605155173\|gb\|CP038256.1\|	904291	g13645	i0	80.913	1.55197132616487	241	42	86	4	5	243	2098055	2097817	Microbacterium sediminis strain YLB-01 chromosome, complete genome	blastn	433	187	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sediminis
12574443	12574443	PRJNA473641_P_NODE_6010_length_378_cov_2.777049_g5927_i0	PRJNA473641	6010	378	2.777049	10.49724522	Streptomyces	1883	Bacteria	Bacteria	58.4	7.74e-4	NTclustered	gi\|1860144928\|gb\|CP054936.1\|	73044	g5927	i0	94.595	1.04761904761905	37	2	10	0	111	147	3847671	3847635	Streptomyces seoulensis strain A01 chromosome	blastn	396	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces seoulensis
15747636	15747636	PRJNA473641_P_NODE_19233_length_249_cov_0.875000_g19150_i0	PRJNA473641	19233	249	0.875	2.17875	Pseudonocardia alni	33907	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2476288951\|gb\|CP052771.1\|	33907	g19150	i0	92.105	0.265060240963855	38	3	15	0	168	205	224576	224539	Pseudonocardia alni strain Shahu chromosome, complete genome	blastn	66	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia alni
16398074	16398074	PRJNA473641_P_NODE_20213_length_248_cov_0.880000_g20130_i0	PRJNA473641	20213	248	0.88	2.1824	Cutibacterium	1912216	Bacteria	Bacteria	309	1.21e-79	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g20130	i0	100	54.6088709677419	167	0	100	0	82	248	1832837	1832671	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	13543	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17673098	17673098	PRJNA473641_P_NODE_4414_length_427_cov_1.372881_g4331_i0	PRJNA473641	4414	427	1.372881	5.86220187	Cutibacterium	1912216	Bacteria	Bacteria	789	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4331	i0	100	291.421545667447	427	0	100	0	1	427	57352	56926	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	124437	789	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21497297	21497297	PRJNA473641_P_NODE_10997_length_305_cov_1.327586_g10914_i0	PRJNA473641	10997	305	1.327586	4.0491373	Microbacterium	33882	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g10914	i0	99.672	199.583606557377	305	1	100	0	1	305	5	309	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	60873	558	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
22772485	22772485	PRJNA473641_P_NODE_23998_length_243_cov_0.905882_g23915_i0	PRJNA473641	23998	243	0.905882	2.20129326	Cutibacterium	1912216	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g23915	i0	100	50.9423868312757	243	0	100	0	1	243	1399219	1398977	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12379	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23396982	23396982	PRJNA473641_P_NODE_11279_length_303_cov_0.973913_g11196_i0	PRJNA473641	11279	303	0.973913	2.95095639	Streptomyces albus	1888	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1812219466\|gb\|CP048875.1\|	1888	g11196	i0	100	0.191419141914191	29	0	10	0	206	234	496960	496932	Streptomyces albus strain CAS922 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces albus
23397208	23397208	PRJNA473641_P_NODE_19959_length_248_cov_0.880000_g19876_i0	PRJNA473641	19959	248	0.88	2.1824	Microcella flavibacter	1804990	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1832644234\|gb\|CP051299.1\|	1804990	g19876	i0	99.194	2	248	2	100	0	1	248	1865481	1865234	Microcella flavibacter strain WY83 chromosome, complete genome	blastn	496	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microcella	Microcella flavibacter
24671183	24671183	PRJNA473641_P_NODE_22080_length_245_cov_0.895349_g21997_i0	PRJNA473641	22080	245	0.895349	2.19360505	Dactylosporangium sp. AC04546	2862460	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2666884590\|gb\|CP139171.1\|	2862460	g21997	i0	96.875	0.130612244897959	32	1	13	0	206	237	4309682	4309651	Dactylosporangium sp. AC04546 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium sp. AC04546

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