metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA760976" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA760976" 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
742352	742352	PRJNA760976_P_NODE_321_length_1933_cov_2.473656_g249_i0	PRJNA760976	321	1933	2.473656	47.81577048	Rothia amarae	169480	Bacteria	Bacteria	3321	0	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g249	i0	97.677	295.519917227108	1937	38	100	6	1	1933	1624667	1622734	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	571240	3321	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
1204905	1204905	PRJNA760976_P_NODE_32221_length_295_cov_0.851351_g31900_i0	PRJNA760976	32221	295	0.851351	2.51148545	Mycolicibacterium	1866885	Bacteria	Bacteria	479	1.0599999999999996e-130	NTclustered	gi\|1806225195\|dbj\|AP022563.1\|	39688	g31900	i0	95.932	198.871186440678	295	12	100	0	1	295	344189	344483	Mycolicibacterium duvalii JCM 6396 DNA, complete genome	blastn	58667	479	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium duvalii
1204911	1204911	PRJNA760976_P_NODE_50521_length_247_cov_0.867816_g50200_i0	PRJNA760976	50521	247	0.867816	2.14350552	Nocardioides	1839	Bacteria	Bacteria	346	9.14e-91	NTclustered	gi\|1696049846\|gb\|CP040695.2\|	2582905	g50200	i0	91.935	290.906882591093	248	18	100	2	1	247	1714101	1714347	Nocardioides sp. S-1144 chromosome, complete genome	blastn	71854	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S-1144
2480445	2480445	PRJNA760976_P_NODE_1482_length_1024_cov_2.209253_g1259_i0	PRJNA760976	1482	1024	2.209253	22.62275072	Cutibacterium	1912216	Bacteria	Bacteria	1886	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1259	i0	99.902	278.763671875	1024	1	100	0	1	1024	56383	55360	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	285454	1886	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5845955	5845955	PRJNA760976_P_NODE_44845_length_259_cov_1.048387_g44524_i0	PRJNA760976	44845	259	1.048387	2.71532233	Corynebacterium glucuronolyticum	39791	Bacteria	Bacteria	438	1.5499999999999996e-118	NTclustered	gi\|1986091972\|gb\|CP069534.1\|	39791	g44524	i0	97.287	370.822393822394	258	7	99	0	2	259	833728	833985	Corynebacterium glucuronolyticum strain FDAARGOS_1191 chromosome, complete genome	blastn	96043	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glucuronolyticum
6309068	6309068	PRJNA760976_P_NODE_38885_length_274_cov_2.233831_g38564_i0	PRJNA760976	38885	274	2.233831	6.12069694	Kytococcus	57499	Bacteria	Bacteria	71.3	6.95e-8	NTclustered	gi\|1948607475\|gb\|CP066015.1\|	1276	g38564	i0	100	1.8029197080292	38	0	14	0	100	137	1333910	1333873	Kytococcus sedentarius strain FDAARGOS_1061 chromosome, complete genome	blastn	494	71.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Kytococcaceae	Kytococcus	Kytococcus sedentarius
7121142	7121142	PRJNA760976_P_NODE_44826_length_259_cov_1.172043_g44505_i0	PRJNA760976	44826	259	1.172043	3.03559137	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	460	3.3099999999999997e-125	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g44505	i0	98.842	348.849420849421	259	2	100	1	1	259	622058	622315	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	90352	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
7582987	7582987	PRJNA760976_P_NODE_11886_length_421_cov_1.761494_g11566_i0	PRJNA760976	11886	421	1.761494	7.41588974	Kocuria	57493	Bacteria	Bacteria	767	0	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g11566	i0	99.525	389.895486935867	421	2	100	0	1	421	1193829	1194249	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	164146	767	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
8395700	8395700	PRJNA760976_P_NODE_5167_length_585_cov_2.208984_g4856_i0	PRJNA760976	5167	585	2.208984	12.9225564	Mycobacterium sp. SMC-16	3385967	Bacteria	Bacteria	1070	0	NTclustered	gi\|2872563150\|gb\|CP176427.1\|	3385967	g4856	i0	99.658	164.495726495727	585	2	100	0	1	585	1407533	1408117	Mycobacterium sp. SMC-16 chromosome, complete genome	blastn	96230	1070	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. SMC-16
8858134	8858134	PRJNA760976_P_NODE_36067_length_282_cov_2.181818_g35746_i0	PRJNA760976	36067	282	2.181818	6.15272676	Mycobacterium	1763	Bacteria	Bacteria	510	3.57e-140	NTclustered	gi\|1486329120\|gb\|CP025546.1\|	1389713	g35746	i0	99.293	104.812056737589	283	1	100	1	1	282	4995804	4996086	Mycobacterium paragordonae strain 49061 chromosome, complete genome	blastn	29557	510	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium paragordonae
8858146	8858146	PRJNA760976_P_NODE_49107_length_249_cov_0.875000_g48786_i0	PRJNA760976	49107	249	0.875	2.17875	Cutibacterium	1912216	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g48786	i0	100	64.1004016064257	249	0	100	0	1	249	2139234	2139482	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15961	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9670773	9670773	PRJNA760976_P_NODE_27468_length_312_cov_1.292887_g27147_i0	PRJNA760976	27468	312	1.292887	4.03380744	Microbacterium lacus	415217	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|2851096443\|gb\|CP084996.1\|	415217	g27147	i0	100	164.464743589744	312	0	100	0	1	312	25029	24718	Microbacterium lacus strain SLM-617 chromosome, complete genome	blastn	51313	577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium lacus
9670777	9670777	PRJNA760976_P_NODE_27988_length_310_cov_1.274262_g27667_i0	PRJNA760976	27988	310	1.274262	3.9502122	Streptomyces sp. VNUA116	3062449	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2551558038\|gb\|CP130487.1\|	3062449	g27667	i0	100	0.0935483870967742	29	0	9	0	35	63	4019343	4019315	Streptomyces sp. VNUA116 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. VNUA116
10133628	10133628	PRJNA760976_P_NODE_13708_length_398_cov_1.584615_g13388_i0	PRJNA760976	13708	398	1.584615	6.3067677	Mycobacteriaceae	1762	Bacteria	Bacteria	730	0	NTclustered	gi\|2021401477\|dbj\|AP023333.1\|	2755560	g13388	i0	99.749	140.701005025126	398	1	100	0	1	398	2888843	2889240	Mycolicibacterium sp. TY66 DNA, complete genome	blastn	55999	730	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sp. TY66
10133649	10133649	PRJNA760976_P_NODE_4068_length_648_cov_3.257391_g3762_i0	PRJNA760976	4068	648	3.257391	21.10789368	Cutibacterium	1912216	Bacteria	Bacteria	1192	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3762	i0	100	272.939814814815	645	0	100	0	4	648	57287	56643	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	176865	1192	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12221932	12221932	PRJNA760976_P_NODE_10070_length_448_cov_1.786667_g9751_i0	PRJNA760976	10070	448	1.786667	8.00426816	Crystallibacter crystallopoietes	37928	Bacteria	Bacteria	822	0	NTclustered	gi\|1318680687\|gb\|CP018864.1\|	37928	g9751	i0	99.777	475.453125	448	1	100	0	1	448	13748	14195	Arthrobacter crystallopoietes strain DSM 20117 plasmid pLDW-9, complete sequence	blastn	213003	822	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Crystallibacter	Crystallibacter crystallopoietes
12221995	12221995	PRJNA760976_P_NODE_27470_length_312_cov_1.288703_g27149_i0	PRJNA760976	27470	312	1.288703	4.02075336	Phycicoccus jejuensis	367299	Bacteria	Bacteria	568	2.3399999999999998e-157	NTclustered	gi\|2851167701\|gb\|CP085209.1\|	367299	g27149	i0	100	194.211538461538	307	0	98	0	1	307	2272415	2272721	Phycicoccus jejuensis strain QJJ-866 chromosome, complete genome	blastn	60594	568	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Phycicoccus	Phycicoccus jejuensis
12222019	12222019	PRJNA760976_P_NODE_3750_length_674_cov_4.014975_g3445_i0	PRJNA760976	3750	674	4.014975	27.0609315	Crystallibacter crystallopoietes	37928	Bacteria	Bacteria	1195	0	NTclustered	gi\|2019119068\|gb\|CP072014.1\|	37928	g3445	i0	98.665	332.026706231454	674	9	100	0	1	674	1517026	1516353	Arthrobacter crystallopoietes strain NT16 chromosome, complete genome	blastn	223786	1195	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Crystallibacter	Crystallibacter crystallopoietes
12684714	12684714	PRJNA760976_P_NODE_54850_length_242_cov_1.366864_g54529_i0	PRJNA760976	54850	242	1.366864	3.30781088	Mycolicibacterium	1866885	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|806984286\|ref\|NG_041981.1\|	36814	g54529	i0	99.587	181.896694214876	242	1	100	0	1	242	2333	2574	Mycobacterium rhodesiae strain NBB3 23S ribosomal RNA gene, complete sequence	blastn	44019	442	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rhodesiae
13959008	13959008	PRJNA760976_P_NODE_37811_length_277_cov_2.612745_g37490_i0	PRJNA760976	37811	277	2.612745	7.23730365	Corynebacterium	1716	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g37490	i0	99.639	376	277	1	100	0	1	277	2492433	2492709	Corynebacterium accolens strain CA3 chromosome	blastn	104152	507	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
13959016	13959016	PRJNA760976_P_NODE_52091_length_245_cov_0.877907_g51770_i0	PRJNA760976	52091	245	0.877907	2.15087215	Micrococcus	1269	Bacteria	Bacteria	287	5.57e-73	NTclustered	gi\|2842879972\|gb\|CP172000.1\|	1270	g51770	i0	87.755	73.4897959183673	245	30	100	0	1	245	2210486	2210242	Micrococcus luteus strain UC81_27 chromosome, complete genome	blastn	18005	287	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15233544	15233544	PRJNA760976_P_NODE_56872_length_241_cov_0.869048_g56551_i0	PRJNA760976	56872	241	0.869048	2.09440568	Rhodococcus	1827	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g56551	i0	99.17	49	241	2	100	0	1	241	1393459	1393219	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	11809	435	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
16507904	16507904	PRJNA760976_P_NODE_49853_length_248_cov_0.862857_g49532_i0	PRJNA760976	49853	248	0.862857	2.13988536	Cutibacterium	1912216	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g49532	i0	100	50.9435483870968	248	0	100	0	1	248	686912	687159	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	12634	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17320718	17320718	PRJNA760976_P_NODE_414_length_1745_cov_2.498206_g249_i1	PRJNA760976	414	1745	2.498206	43.5936947	Rothia amarae	169480	Bacteria	Bacteria	2534	0	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g249	i1	93.007	300.365616045845	1759	87	99	31	4	1745	1624473	1622734	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	524138	2534	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
19869314	19869314	PRJNA760976_P_NODE_53656_length_243_cov_1.729412_g53335_i0	PRJNA760976	53656	243	1.729412	4.20247116	Kocuria palustris	71999	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g53335	i0	100	1	243	0	100	0	1	243	1877704	1877946	Kocuria palustris strain MU14/1, complete genome	blastn	243	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
20331436	20331436	PRJNA760976_P_NODE_45696_length_256_cov_2.448087_g45375_i0	PRJNA760976	45696	256	2.448087	6.26710272	Cutibacterium	1912216	Bacteria	Bacteria	473	4.189999999999999e-129	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g45375	i0	100	60.22265625	256	0	100	0	1	256	492866	493121	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15417	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21144948	21144948	PRJNA760976_P_NODE_39797_length_272_cov_1.386935_g39476_i0	PRJNA760976	39797	272	1.386935	3.7724632	Rothia amarae	169480	Bacteria	Bacteria	486	5.7699999999999996e-133	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g39476	i0	98.897	5.50735294117647	272	3	100	0	1	272	302180	302451	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	1498	486	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
21607165	21607165	PRJNA760976_P_NODE_10257_length_445_cov_1.212366_g9938_i0	PRJNA760976	10257	445	1.212366	5.3950287	Corynebacterium	1716	Bacteria	Bacteria	800	0	NTclustered	gi\|2879425277\|gb\|CP176024.1\|	3050203	g9938	i0	99.544	360.258426966292	439	2	99	0	7	445	715445	715007	Corynebacterium sp. MSK090 chromosome, complete genome	blastn	160315	800	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. MSK090
22419716	22419716	PRJNA760976_P_NODE_53258_length_244_cov_0.865497_g52937_i0	PRJNA760976	53258	244	0.865497	2.11181268	Microbacterium sp. SY138	3149040	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|2735043096\|gb\|CP155793.1\|	3149040	g52937	i0	99.588	11.7540983606557	243	1	99	0	2	244	2985003	2985245	Microbacterium sp. SY138 chromosome, complete genome	blastn	2868	444	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. SY138
22882719	22882719	PRJNA760976_P_NODE_3138_length_732_cov_1.684370_g2844_i0	PRJNA760976	3138	732	1.68437	12.3295884	Mycobacteriaceae	1762	Bacteria	Bacteria	1068	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g2844	i0	98.355	136.924863387978	608	10	83	0	125	732	1313372	1312765	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	100229	1068	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
22882726	22882726	PRJNA760976_P_NODE_3778_length_672_cov_3.395659_g3473_i0	PRJNA760976	3778	672	3.395659	22.81882848	Microbacterium	33882	Bacteria	Bacteria	1225	0	NTclustered	gi\|2794121670\|gb\|CP168030.1\|	33918	g3473	i0	99.554	166.997023809524	672	3	100	0	1	672	1754571	1753900	Microbacterium maritypicum strain Sneb159 chromosome, complete genome	blastn	112222	1225	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
22882728	22882728	PRJNA760976_P_NODE_41058_length_268_cov_2.594872_g40737_i0	PRJNA760976	41058	268	2.594872	6.95425696	root	1	Root_unresolved	Root_unresolved	494	3.39e-135	NTclustered	gi\|50082565\|gb\|AY642042.1\|	1747	g40737	i0	100	122.541044776119	267	0	99	0	1	267	9	275	Propionibacterium acnes isolate L1958 16S ribosomal RNA gene, partial sequence	blastn	32841	494	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);;