metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA930380" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA930380" 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
909447	909447	PRJNA930380_P_NODE_2421_length_404_cov_2.492447_g2368_i0	PRJNA930380	2421	404	2.492447	10.06948588	Corynebacterium sp. YSMAA1_1_F7	3383590	Bacteria	Bacteria	741	0	NTclustered	gi\|2869833946\|gb\|CP175789.1\|	3383590	g2368	i0	99.752	367.955445544554	404	1	100	0	1	404	794746	795149	Corynebacterium sp. YSMAA1_1_F7 chromosome, complete genome	blastn	148654	741	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_F7
1254903	1254903	PRJNA930380_P_NODE_5321_length_295_cov_1.387387_g5268_i0	PRJNA930380	5321	295	1.387387	4.09279165	root	1	Root_unresolved	Root_unresolved	52.8	0.027	NTclustered	gi\|1959051935\|gb\|CP058277.1\|	1781	g5268	i0	100	0.684745762711864	28	0	9	0	96	123	2224834	2224807	Mycobacterium marinum strain MMA1 chromosome, complete genome	blastn	202	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium marinum
5083224	5083224	PRJNA930380_P_NODE_4964_length_299_cov_1.075221_g4911_i0	PRJNA930380	4964	299	1.075221	3.21491079	Corynebacterium	1716	Bacteria	Bacteria	547	2.9099999999999987e-151	NTclustered	gi\|1986087704\|gb\|CP069533.1\|	38301	g4911	i0	99.666	398.979933110368	299	1	100	0	1	299	101971	101673	Corynebacterium minutissimum strain FDAARGOS_1196 chromosome, complete genome	blastn	119295	547	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium minutissimum
6358946	6358946	PRJNA930380_P_NODE_3145_length_360_cov_1.421603_g3092_i0	PRJNA930380	3145	360	1.421603	5.1177708	Microbacterium	33882	Bacteria	Bacteria	662	0	NTclustered	gi\|1154509326\|gb\|CP019892.1\|	104336	g3092	i0	100	154.602777777778	358	0	99	0	3	360	2458189	2458546	Microbacterium foliorum strain 122 chromosome	blastn	55657	662	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium foliorum
7287405	7287405	PRJNA930380_P_NODE_12526_length_247_cov_1.327586_g12473_i0	PRJNA930380	12526	247	1.327586	3.27913742	Corynebacterium lizhenjunii	2709394	Bacteria	Bacteria	134	7.750000000000001e-27	NTclustered	gi\|1939561086\|gb\|CP064954.1\|	2709394	g12473	i0	77.308	181.635627530364	260	38	100	19	1	247	708653	708402	Corynebacterium lizhenjunii strain ZJ-599 chromosome, complete genome	blastn	44864	134	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lizhenjunii
8562263	8562263	PRJNA930380_P_NODE_13567_length_244_cov_0.900585_g13514_i0	PRJNA930380	13567	244	0.900585	2.1974274	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g13514	i0	100	61.3401639344262	244	0	100	0	1	244	1891934	1891691	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	14967	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
8562300	8562300	PRJNA930380_P_NODE_1907_length_448_cov_1.642667_g1854_i0	PRJNA930380	1907	448	1.642667	7.35914816	Corynebacterium sp. YSMAA1_1_F7	3383590	Bacteria	Bacteria	798	0	NTclustered	gi\|2869833946\|gb\|CP175789.1\|	3383590	g1854	i0	98.884	414.133928571429	448	4	100	1	1	448	795875	796321	Corynebacterium sp. YSMAA1_1_F7 chromosome, complete genome	blastn	185532	798	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_F7
8562414	8562414	PRJNA930380_P_NODE_9727_length_273_cov_1.075000_g9674_i0	PRJNA930380	9727	273	1.075	2.93475	Rhodococcus erythropolis	1833	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|2179868499\|gb\|CP032403.1\|	1833	g9674	i0	98.535	48.8791208791209	273	4	100	0	1	273	2409314	2409586	Rhodococcus erythropolis strain D310-1 chromosome, complete genome	blastn	13344	483	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
8907711	8907711	PRJNA930380_P_NODE_5347_length_295_cov_1.040541_g5294_i0	PRJNA930380	5347	295	1.040541	3.06959595	Micropruina	116071	Bacteria	Bacteria	477	3.809999999999998e-130	NTclustered	gi\|1345633730\|emb\|LT985188.1\|	75385	g5294	i0	95.918	221.766101694915	294	12	99	0	2	295	1730393	1730100	Micropruina glycogenica isolate 1 genome assembly, chromosome: 1	blastn	65421	477	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Micropruina	Micropruina glycogenica
9837461	9837461	PRJNA930380_P_NODE_9288_length_275_cov_2.133663_g9235_i0	PRJNA930380	9288	275	2.133663	5.86757325	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g9235	i0	100	370.898181818182	275	0	100	0	1	275	621936	622210	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	101997	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
10183568	10183568	PRJNA930380_P_NODE_13428_length_244_cov_0.900585_g13375_i0	PRJNA930380	13428	244	0.900585	2.1974274	Cutibacterium	1912216	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g13375	i0	100	59.8196721311475	244	0	100	0	1	244	1812577	1812820	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	14596	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11458604	11458604	PRJNA930380_P_NODE_10829_length_261_cov_0.984043_g10776_i0	PRJNA930380	10829	261	0.984043	2.56835223	Corynebacterium	1716	Bacteria	Bacteria	466	7.17e-127	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g10776	i0	98.851	346.988505747126	261	3	100	0	1	261	1271922	1272182	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	90564	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
11458648	11458648	PRJNA930380_P_NODE_409_length_915_cov_2.047506_g366_i0	PRJNA930380	409	915	2.047506	18.7346799	Corynebacterium	1716	Bacteria	Bacteria	987	0	NTclustered	gi\|2242616707\|gb\|CP046605.1\|	38284	g366	i0	99.269	317.303825136612	547	3	94	1	370	915	748073	748619	Corynebacterium accolens strain DSM 44278 chromosome, complete genome	blastn	290333	992	0.994959677419355	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
12388653	12388653	PRJNA930380_P_NODE_9690_length_273_cov_1.330000_g9637_i0	PRJNA930380	9690	273	1.33	3.6309	Cutibacterium acnes	1747	Bacteria	Bacteria	505	1.6e-138	NTclustered	gi\|2493038017\|gb\|CP114010.1\|	1747	g9637	i0	100	59.3479853479854	273	0	100	0	1	273	1862342	1862070	Cutibacterium acnes strain CBS-BPNBT19329 chromosome, complete genome	blastn	16202	505	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12734279	12734279	PRJNA930380_P_NODE_10510_length_266_cov_0.911917_g10457_i0	PRJNA930380	10510	266	0.911917	2.42569922	Cutibacterium	1912216	Bacteria	Bacteria	481	2.62e-131	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10457	i0	99.248	267.101503759398	266	2	100	0	1	266	56196	56461	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	71049	481	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12734349	12734349	PRJNA930380_P_NODE_810_length_660_cov_3.250426_g758_i0	PRJNA930380	810	660	3.250426	21.4528116	Corynebacterium	1716	Bacteria	Bacteria	1050	0	NTclustered	gi\|2869799666\|gb\|CP175764.1\|	38304	g758	i0	95.732	362.327272727273	656	20	99	5	1	655	378794	378146	Corynebacterium tuberculostearicum strain YSMAA5_1_G11 chromosome, complete genome	blastn	239136	1050	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
20381206	20381206	PRJNA930380_P_NODE_13076_length_245_cov_2.761628_g13023_i0	PRJNA930380	13076	245	2.761628	6.7659886	Microbacterium	33882	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1154509326\|gb\|CP019892.1\|	104336	g13023	i0	100	166.877551020408	245	0	100	0	1	245	2456502	2456746	Microbacterium foliorum strain 122 chromosome	blastn	40885	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium foliorum
21657134	21657134	PRJNA930380_P_NODE_10977_length_258_cov_1.054054_g10924_i0	PRJNA930380	10977	258	1.054054	2.71945932	Brachybacterium	43668	Bacteria	Bacteria	202	2.1999999999999997e-47	NTclustered	gi\|2708453573\|gb\|CP149573.1\|	3023517	g10924	i0	96.721	4.5	122	3	47	1	1	121	3641696	3641575	Brachybacterium sp. GPGPB12 chromosome, complete genome	blastn	1161	202	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. GPGPB12
21657184	21657184	PRJNA930380_P_NODE_3537_length_343_cov_2.133333_g3484_i0	PRJNA930380	3537	343	2.133333	7.31733219	Microbacterium	33882	Bacteria	Bacteria	628	1.1799999999999997e-175	NTclustered	gi\|2274432258\|gb\|CP101471.1\|	33918	g3484	i0	99.708	186.099125364432	343	1	100	0	1	343	229781	230123	Microbacterium maritypicum strain DND4 chromosome, complete genome	blastn	63832	634	0.990536277602524	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
21657195	21657195	PRJNA930380_P_NODE_4757_length_302_cov_1.419214_g4704_i0	PRJNA930380	4757	302	1.419214	4.28602628	Cutibacterium	1912216	Bacteria	Bacteria	547	2.9399999999999987e-151	NTclustered	gi\|1976468523\|gb\|CP069240.1\|	33010	g4704	i0	99.338	293.698675496689	302	2	100	0	1	302	558511	558812	Cutibacterium avidum strain KCTC 5339 chromosome, complete genome	blastn	88697	547	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium avidum
22932729	22932729	PRJNA930380_P_NODE_13998_length_242_cov_0.911243_g13945_i0	PRJNA930380	13998	242	0.911243	2.20520806	Cutibacterium	1912216	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g13945	i0	100	66.9214876033058	242	0	100	0	1	242	108656	108897	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16195	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);;