metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax_phylum = "Mycoplasmatota"

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_order	tax_family	tax_genus	tax_species
1059023	1059023	PRJNA283169_P_NODE_2121_length_281_cov_1.474138_g2059_i0	PRJNA283169	2121	281	1.474138	4.14232778	Mesomycoplasma	2923352	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g2059	i0	100	16	281	0	100	0	1	281	1072	792	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4496	520	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
2334225	2334225	PRJNA283169_P_NODE_562_length_508_cov_2.453159_g500_i0	PRJNA283169	562	508	2.453159	12.46204772	Mesomycoplasma	2923352	Bacteria	Bacteria	800	0	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g500	i0	100	36.7106299212598	433	0	100	0	76	508	651907	652339	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	18649	800	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
4886957	4886957	PRJNA283169_P_NODE_2264_length_273_cov_1.379464_g2202_i0	PRJNA283169	2264	273	1.379464	3.76593672	Mesomycoplasma	2923352	Bacteria	Bacteria	505	1.6e-138	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g2202	i0	100	15	273	0	100	0	1	273	752553	752281	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4095	505	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
4886964	4886964	PRJNA283169_P_NODE_8104_length_162_cov_0.911504_g8041_i0	PRJNA283169	8104	162	0.911504	1.47663648	Mesomycoplasma	2923352	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g8041	i0	98.765	15	162	2	100	0	1	162	146583	146422	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2430	289	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
6161817	6161817	PRJNA283169_P_NODE_8085_length_162_cov_0.920354_g8022_i0	PRJNA283169	8085	162	0.920354	1.49097348	Mesomycoplasma	2923352	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g8022	i0	100	17.0185185185185	162	0	100	0	1	162	333368	333529	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2757	300	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
7436914	7436914	PRJNA283169_P_NODE_7206_length_165_cov_1.025862_g7143_i0	PRJNA283169	7206	165	1.025862	1.6926723	Mesomycoplasma	2923352	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|44359\|emb\|X58555.1\|	2100	g7143	i0	100	30.0969696969697	165	0	100	0	1	165	342	178	M.hyorhinis DNA for 16S-23S ribosomal operon spacer region	blastn	4966	305	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
7436915	7436915	PRJNA283169_P_NODE_7926_length_163_cov_0.877193_g7863_i0	PRJNA283169	7926	163	0.877193	1.42982459	Mesomycoplasma	2923352	Bacteria	Bacteria	261	2.07e-65	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g7863	i0	100	12.9754601226994	141	0	87	0	1	141	764483	764343	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2115	261	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
8711657	8711657	PRJNA283169_P_NODE_4567_length_198_cov_1.228188_g4504_i0	PRJNA283169	4567	198	1.228188	2.43181224	Mesomycoplasma	2923352	Bacteria	Bacteria	237	4.42e-58	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g4504	i0	99.237	38.2525252525253	131	1	92	0	68	198	772288	772158	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	7574	237	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
8711667	8711667	PRJNA283169_P_NODE_7427_length_164_cov_1.513043_g7364_i0	PRJNA283169	7427	164	1.513043	2.48139052	Mesomycoplasma	2923352	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g7364	i0	100	57.0243902439024	164	0	100	0	1	164	666941	666778	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	9352	303	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
9987109	9987109	PRJNA283169_P_NODE_2728_length_251_cov_1.143564_g2665_i0	PRJNA283169	2728	251	1.143564	2.87034564	Mesomycoplasma	2923352	Bacteria	Bacteria	357	4.3e-94	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g2665	i0	98.995	29.9123505976096	199	2	100	0	1	199	680629	680431	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	7508	357	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
11262170	11262170	PRJNA283169_P_NODE_2009_length_288_cov_1.288703_g1947_i0	PRJNA283169	2009	288	1.288703	3.71146464	Mesomycoplasma	2923352	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g1947	i0	100	18.3333333333333	288	0	100	0	1	288	356264	356551	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	5280	532	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
11262177	11262177	PRJNA283169_P_NODE_4329_length_202_cov_1.490196_g4266_i0	PRJNA283169	4329	202	1.490196	3.01019592	Mesomycoplasma	2923352	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g4266	i0	100	15	202	0	100	0	1	202	272883	273084	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3030	374	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
12537503	12537503	PRJNA283169_P_NODE_6430_length_169_cov_1.233333_g6367_i0	PRJNA283169	6430	169	1.233333	2.08433277	Mesomycoplasma	2923352	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g6367	i0	99.408	15.1656804733728	169	1	100	0	1	169	109356	109524	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2563	307	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13812374	13812374	PRJNA283169_P_NODE_5351_length_185_cov_1.117647_g5288_i0	PRJNA283169	5351	185	1.117647	2.06764695	Mesomycoplasma	2923352	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g5288	i0	100	15	185	0	100	0	1	185	820014	820198	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2775	342	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13812376	13812376	PRJNA283169_P_NODE_6631_length_168_cov_0.873950_g6568_i0	PRJNA283169	6631	168	0.87395	1.468236	Mesomycoplasma	2923352	Bacteria	Bacteria	243	7.8e-60	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g6568	i0	100	32.4226190476191	131	0	78	0	38	168	360338	360208	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	5447	243	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15086605	15086605	PRJNA283169_P_NODE_5272_length_186_cov_1.124088_g5209_i0	PRJNA283169	5272	186	1.124088	2.09080368	Mesomycoplasma	2923352	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g5209	i0	100	15	186	0	100	0	1	186	273161	273346	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2790	344	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
15086606	15086606	PRJNA283169_P_NODE_5712_length_179_cov_1.200000_g5649_i0	PRJNA283169	5712	179	1.2	2.148	Mesomycoplasma	2923352	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g5649	i0	100	15	179	0	100	0	1	179	232417	232239	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2685	331	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16361476	16361476	PRJNA283169_P_NODE_233_length_870_cov_2.472594_g186_i0	PRJNA283169	233	870	2.472594	21.5115678	Mesomycoplasma	2923352	Bacteria	Bacteria	1607	0	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g186	i0	100	16.535632183908	870	0	100	0	1	870	299359	298490	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	14386	1607	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16361478	16361478	PRJNA283169_P_NODE_3613_length_218_cov_1.923077_g3550_i0	PRJNA283169	3613	218	1.923077	4.19230786	Mesomycoplasma	2923352	Bacteria	Bacteria	379	7.779999999999999e-101	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g3550	i0	100	15.8853211009174	205	0	94	0	1	205	527459	527663	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3463	379	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16361482	16361482	PRJNA283169_P_NODE_5473_length_183_cov_1.097015_g5410_i0	PRJNA283169	5473	183	1.097015	2.00753745	Mesomycoplasma	2923352	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g5410	i0	100	48.1857923497268	183	0	100	0	1	183	666584	666766	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	8818	339	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16361490	16361490	PRJNA283169_P_NODE_6573_length_168_cov_1.252101_g6510_i0	PRJNA283169	6573	168	1.252101	2.10352968	Mesomycoplasma	2923352	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g6510	i0	100	15	168	0	100	0	1	168	654739	654572	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2520	311	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
17636625	17636625	PRJNA283169_P_NODE_534_length_524_cov_2.334737_g472_i0	PRJNA283169	534	524	2.334737	12.23402188	Mesomycoplasma	2923352	Bacteria	Bacteria	957	0	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g472	i0	99.618	47.6278625954198	524	2	100	0	1	524	679257	678734	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	24957	957	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
17636626	17636626	PRJNA283169_P_NODE_5614_length_180_cov_1.648855_g5551_i0	PRJNA283169	5614	180	1.648855	2.967939	Mesomycoplasma	2923352	Bacteria	Bacteria	311	2.28e-80	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g5551	i0	98.851	15.3722222222222	174	2	97	0	1	174	490629	490802	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2767	311	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
17636629	17636629	PRJNA283169_P_NODE_7274_length_165_cov_0.896552_g7211_i0	PRJNA283169	7274	165	0.896552	1.4793108	Mesomycoplasma	2923352	Bacteria	Bacteria	261	2.11e-65	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g7211	i0	100	16.2121212121212	141	0	100	0	1	141	768793	768933	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	2675	261	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
20185047	20185047	PRJNA283169_P_NODE_3356_length_227_cov_1.016854_g3293_i0	PRJNA283169	3356	227	1.016854	2.30825858	Mesomycoplasma	2923352	Bacteria	Bacteria	324	3.88e-84	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g3293	i0	96	15.6343612334802	200	7	100	1	29	227	479419	479618	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3549	324	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
21460728	21460728	PRJNA283169_P_NODE_377_length_640_cov_1.976311_g321_i0	PRJNA283169	377	640	1.976311	12.6483904	Mesomycoplasma	2923352	Bacteria	Bacteria	1146	0	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g321	i0	99.368	16.6078125	633	2	99	2	10	640	300730	300098	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	10629	1146	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
22735809	22735809	PRJNA283169_P_NODE_1098_length_374_cov_2.000000_g1036_i0	PRJNA283169	1098	374	2	7.48	Mesomycoplasma	2923352	Bacteria	Bacteria	686	0	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g1036	i0	99.733	27.3449197860963	374	1	100	0	1	374	780948	780575	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	10227	686	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
22735817	22735817	PRJNA283169_P_NODE_3578_length_219_cov_1.776471_g3515_i0	PRJNA283169	3578	219	1.776471	3.89047149	Mesomycoplasma	2923352	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g3515	i0	100	26.9954337899543	219	0	100	0	1	219	780338	780556	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	5912	405	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
22735819	22735819	PRJNA283169_P_NODE_5158_length_188_cov_1.122302_g5095_i0	PRJNA283169	5158	188	1.122302	2.10992776	Mesomycoplasma	2923352	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g5095	i0	100	15	188	0	100	0	1	188	272519	272706	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2820	348	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
24010897	24010897	PRJNA283169_P_NODE_1619_length_317_cov_2.257463_g1557_i0	PRJNA283169	1619	317	2.257463	7.15615771	Mesomycoplasma	2923352	Bacteria	Bacteria	586	6.579999999999998e-163	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g1557	i0	100	15	317	0	100	0	1	317	599190	599506	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	4755	586	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
25285063	25285063	PRJNA283169_P_NODE_4340_length_202_cov_1.333333_g4277_i0	PRJNA283169	4340	202	1.333333	2.69333266	Mesomycoplasma	2923352	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g4277	i0	99.505	21.5742574257426	202	1	100	0	1	202	102073	101872	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4358	368	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
25285066	25285066	PRJNA283169_P_NODE_6460_length_169_cov_0.866667_g6397_i0	PRJNA283169	6460	169	0.866667	1.46466723	Mesomycoplasma	2923352	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g6397	i0	100	15	169	0	100	0	1	169	508134	507966	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2535	313	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
25285068	25285068	PRJNA283169_P_NODE_6920_length_166_cov_1.333333_g6857_i0	PRJNA283169	6920	166	1.333333	2.21333278	Mesomycoplasma	2923352	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g6857	i0	99.398	27	166	1	100	0	1	166	780963	781128	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	4482	302	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis

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