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

33 rows where analysis = "blastn", bioproject = "PRJNA603943" 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_class	tax_order	tax_family	tax_genus	tax_species
577143	577143	PRJNA603943_P_NODE_37641_length_300_cov_1.017621_g37449_i0	PRJNA603943	37641	300	1.017621	3.052863	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	544	3.78e-150	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g37449	i0	99.333	1	300	2	100	0	1	300	175607	175906	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	300	544	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
577709	577709	PRJNA603943_P_NODE_58141_length_248_cov_0.880000_g57949_i0	PRJNA603943	58141	248	0.88	2.1824	uncultured Mollicutes bacterium	220137	Bacteria	Bacteria	307	4.34e-79	NTclustered	gi\|2187163481\|emb\|OV788639.1\|	220137	g57949	i0	98.837	2.99596774193548	172	2	100	0	77	248	1150435	1150264	uncultured Mollicutes bacterium isolate min17_bin64 genome assembly, chromosome: 1	blastn	743	307	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				uncultured Mollicutes bacterium
1852845	1852845	PRJNA603943_P_NODE_35462_length_308_cov_0.982979_g35270_i0	PRJNA603943	35462	308	0.982979	3.02757532	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	547	3.0099999999999987e-151	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g35270	i0	98.701	1	308	4	100	0	1	308	1098395	1098702	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	308	547	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
3128579	3128579	PRJNA603943_P_NODE_53583_length_251_cov_0.865169_g53391_i0	PRJNA603943	53583	251	0.865169	2.17157419	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g53391	i0	100	1	251	0	100	0	1	251	989424	989674	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	251	464	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
3128822	3128822	PRJNA603943_P_NODE_61963_length_246_cov_0.890173_g61771_i0	PRJNA603943	61963	246	0.890173	2.18982558	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g61771	i0	100	1	246	0	100	0	1	246	983323	983568	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	246	455	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
5680500	5680500	PRJNA603943_P_NODE_23965_length_358_cov_1.080702_g23773_i0	PRJNA603943	23965	358	1.080702	3.86891316	Ureaplasma diversum	42094	Bacteria	Bacteria	75	7.24e-9	NTclustered	gi\|764071633\|gb\|CP009770.1\|	42094	g23773	i0	87.692	1.07541899441341	65	6	18	2	29	92	92437	92500	Ureaplasma diversum strain ATCC 49782 genome	blastn	385	75	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma diversum
5681689	5681689	PRJNA603943_P_NODE_65325_length_244_cov_0.900585_g65133_i0	PRJNA603943	65325	244	0.900585	2.1974274	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g65133	i0	99.59	1	244	1	100	0	1	244	818299	818056	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	244	446	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
6955252	6955252	PRJNA603943_P_NODE_30246_length_328_cov_1.188235_g30054_i0	PRJNA603943	30246	328	1.188235	3.8974108	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	606	5.249999999999998e-169	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g30054	i0	100	1	328	0	100	0	1	328	960408	960735	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	328	606	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
6955475	6955475	PRJNA603943_P_NODE_37346_length_301_cov_1.201754_g37154_i0	PRJNA603943	37346	301	1.201754	3.61727954	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	492	1.39e-134	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g37154	i0	97.241	6.65116279069767	290	8	100	0	12	301	136438	136149	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	2002	492	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
8230276	8230276	PRJNA603943_P_NODE_34127_length_313_cov_0.962500_g33935_i0	PRJNA603943	34127	313	0.9625	3.012625	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	579	1.0899999999999999e-160	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g33935	i0	100	1	313	0	100	0	1	313	38629	38317	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	313	579	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
8230993	8230993	PRJNA603943_P_NODE_58347_length_248_cov_0.880000_g58155_i0	PRJNA603943	58347	248	0.88	2.1824	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g58155	i0	91.129	1	248	22	100	0	1	248	138523	138770	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	248	337	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
9505959	9505959	PRJNA603943_P_NODE_52208_length_252_cov_1.290503_g52016_i0	PRJNA603943	52208	252	1.290503	3.25206756	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g52016	i0	100	1	252	0	100	0	1	252	355371	355622	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	252	466	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
9506297	9506297	PRJNA603943_P_NODE_63848_length_245_cov_0.895349_g63656_i0	PRJNA603943	63848	245	0.895349	2.19360505	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g63656	i0	100	1	245	0	100	0	1	245	286874	286630	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	245	453	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
9506324	9506324	PRJNA603943_P_NODE_64688_length_244_cov_0.900585_g64496_i0	PRJNA603943	64688	244	0.900585	2.1974274	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g64496	i0	99.59	1	244	1	100	0	1	244	767828	767585	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	244	446	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
10071722	10071722	PRJNA603943_P_NODE_39628_length_293_cov_1.050000_g39436_i0	PRJNA603943	39628	293	1.05	3.0765	Metamycoplasmataceae	2895623	Bacteria	Bacteria	108	5.72e-19	NTclustered	gi\|1563788636\|emb\|LR214955.1\|	2115	g39436	i0	86.275	1.74061433447099	102	10	34	4	2	100	418006	418106	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1	blastn	510	108	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
10782396	10782396	PRJNA603943_P_NODE_70609_length_241_cov_0.863095_g70417_i0	PRJNA603943	70609	241	0.863095	2.08005895	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g70417	i0	99.585	1	241	1	100	0	1	241	686062	685822	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	241	440	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
12057171	12057171	PRJNA603943_P_NODE_64770_length_244_cov_0.900585_g64578_i0	PRJNA603943	64770	244	0.900585	2.1974274	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	401	1.8999999999999998e-107	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g64578	i0	96.311	1	244	9	100	0	1	244	474209	473966	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	244	401	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
13331173	13331173	PRJNA603943_P_NODE_37591_length_300_cov_1.110132_g37399_i0	PRJNA603943	37591	300	1.110132	3.330396	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	538	1.76e-148	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g37399	i0	99	1	300	3	100	0	1	300	417109	416810	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	300	538	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
13331633	13331633	PRJNA603943_P_NODE_52731_length_251_cov_0.865169_g52539_i0	PRJNA603943	52731	251	0.865169	2.17157419	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g52539	i0	98.406	4.49800796812749	251	4	100	0	1	251	929062	928812	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	1129	442	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
13332001	13332001	PRJNA603943_P_NODE_65231_length_244_cov_0.900585_g65039_i0	PRJNA603943	65231	244	0.900585	2.1974274	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g65039	i0	97.131	1	244	7	100	0	1	244	359702	359945	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	244	412	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
13332038	13332038	PRJNA603943_P_NODE_66311_length_243_cov_0.905882_g66119_i0	PRJNA603943	66311	243	0.905882	2.20129326	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g66119	i0	98.354	2.04938271604938	243	4	100	0	1	243	568316	568558	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	498	427	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
14607012	14607012	PRJNA603943_P_NODE_68712_length_242_cov_0.911243_g68520_i0	PRJNA603943	68712	242	0.911243	2.20520806	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	385	1.89e-102	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g68520	i0	96.186	9.34710743801653	236	8	100	1	7	242	867877	867643	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	2262	385	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
15879813	15879813	PRJNA603943_P_NODE_31053_length_325_cov_0.916667_g30861_i0	PRJNA603943	31053	325	0.916667	2.97916775	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	595	1.1299999999999995e-165	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g30861	i0	99.692	1	325	1	100	0	1	325	1091543	1091867	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	325	595	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
15880922	15880922	PRJNA603943_P_NODE_68393_length_242_cov_0.911243_g68201_i0	PRJNA603943	68393	242	0.911243	2.20520806	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g68201	i0	99.587	1	242	1	100	0	1	242	997289	997048	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	242	442	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
17154793	17154793	PRJNA603943_P_NODE_35474_length_308_cov_0.982979_g35282_i0	PRJNA603943	35474	308	0.982979	3.02757532	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	564	2.99e-156	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g35282	i0	99.675	1	308	1	100	0	1	308	962997	963304	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	308	564	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
17155155	17155155	PRJNA603943_P_NODE_47934_length_266_cov_1.196891_g47742_i0	PRJNA603943	47934	266	1.196891	3.18373006	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	481	2.62e-131	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g47742	i0	99.248	1.91729323308271	266	2	100	0	1	266	597692	597957	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	510	481	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
17155746	17155746	PRJNA603943_P_NODE_67334_length_243_cov_0.894118_g67142_i0	PRJNA603943	67334	243	0.894118	2.17270674	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g67142	i0	99.177	1	243	2	100	0	1	243	755561	755319	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	243	438	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
19704591	19704591	PRJNA603943_P_NODE_67696_length_242_cov_0.911243_g67504_i0	PRJNA603943	67696	242	0.911243	2.20520806	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	399	6.759999999999999e-107	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g67504	i0	97.835	2.78099173553719	231	5	95	0	1	231	500201	499971	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	673	399	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
20979929	20979929	PRJNA603943_P_NODE_55157_length_250_cov_0.870056_g54965_i0	PRJNA603943	55157	250	0.870056	2.17514	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g54965	i0	99.2	1	250	2	100	0	1	250	355128	354879	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	250	451	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
20980172	20980172	PRJNA603943_P_NODE_63457_length_245_cov_0.895349_g63265_i0	PRJNA603943	63457	245	0.895349	2.19360505	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g63265	i0	98.776	1	245	3	100	0	1	245	917628	917872	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	245	436	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
23530222	23530222	PRJNA603943_P_NODE_57539_length_248_cov_1.320000_g57347_i0	PRJNA603943	57539	248	1.32	3.2736	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g57347	i0	99.187	0.991935483870968	246	0	99	2	3	248	633657	633414	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	246	442	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
23530434	23530434	PRJNA603943_P_NODE_63999_length_245_cov_0.889535_g63807_i0	PRJNA603943	63999	245	0.889535	2.17936075	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g63807	i0	99.592	3.7469387755102	245	1	100	0	1	245	1133285	1133529	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	918	448	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
24803315	24803315	PRJNA603943_P_NODE_36040_length_306_cov_0.991416_g35848_i0	PRJNA603943	36040	306	0.991416	3.03373296	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	544	3.86e-150	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g35848	i0	98.693	1	306	4	100	0	1	306	1062265	1062570	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	306	544	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium

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