metadata: contig_metadata: 18 rows where bioproject = "PRJNA792582", tax_kingdom = "Bacillati" and tax

18 rows where bioproject = "PRJNA792582", tax_kingdom = "Bacillati" 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
2052857	2052857	PRJNA792582_P_NODE_34222_length_294_cov_1.742081_g33408_i0	PRJNA792582	34222	294	1.742081	5.12171814	Malacoplasma muris	2119	Bacteria	Bacteria	327	4.05e-85	NTclustered	gi\|2890642799\|gb\|CP177248.1\|	2119	g33408	i0	86.942	94.8639455782313	291	38	99	0	1	291	88002	88292	Malacoplasma muris strain RIII-4 chromosome, complete genome	blastn	27890	327	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
3328230	3328230	PRJNA792582_P_NODE_47223_length_258_cov_1.248649_g46409_i0	PRJNA792582	47223	258	1.248649	3.22151442	Malacoplasma muris	2119	Bacteria	Bacteria	259	1.29e-64	NTclustered	gi\|2890642799\|gb\|CP177248.1\|	2119	g46409	i0	84.884	49.062015503876	258	37	99	2	1	257	1041889	1041633	Malacoplasma muris strain RIII-4 chromosome, complete genome	blastn	12658	259	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
4605583	4605583	PRJNA792582_P_NODE_58544_length_242_cov_0.911243_g57730_i0	PRJNA792582	58544	242	0.911243	2.20520806	Mollicutes	31969	Bacteria	Bacteria	133	3.4299999999999995e-37	NR	MBD5445969.1	2108	g57730	i0	77.5	3.96694214876033	80	18	99.2	0	242	3	83	162	MBD5445969.1 30S ribosomal protein S5 [Mycoplasma sp.]	diamond	960	133	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
10143882	10143882	PRJNA792582_P_NODE_31848_length_306_cov_3.862661_g31034_i0	PRJNA792582	31848	306	3.862661	11.81974266	Mycoplasma	2093	Bacteria	Bacteria	84.2	1.01e-11	NTclustered	gi\|2040452726\|gb\|CP074573.1\|	2231116	g31034	i0	80.909	6.24509803921569	110	17	35	4	63	169	1703833	1703941	Tenericutes bacterium strain zrk4 chromosome, complete genome	blastn	1911	84.2	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
11419426	11419426	PRJNA792582_P_NODE_45929_length_261_cov_2.457447_g45115_i0	PRJNA792582	45929	261	2.457447	6.41393667	Mycoplasmoidales	2790996	Bacteria	Bacteria	383	7.43e-102	NTclustered	gi\|1563789200\|emb\|LR214962.1\|	2115	g45115	i0	93.103	329.659003831418	261	18	100	0	1	261	355853	355593	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8	blastn	86041	383	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
14805573	14805573	PRJNA792582_P_NODE_40232_length_277_cov_1.509804_g39418_i0	PRJNA792582	40232	277	1.509804	4.18215708	Malacoplasma iowae	2116	Bacteria	Bacteria	209	1.43e-49	NTclustered	gi\|2624200933\|gb\|CP129196.1\|	2116	g39418	i0	81.395	38.2815884476534	258	46	93	2	3	259	1052570	1052314	Malacoplasma iowae strain M820 chromosome, complete genome	blastn	10604	209	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
16079377	16079377	PRJNA792582_P_NODE_28793_length_322_cov_1.232932_g27979_i0	PRJNA792582	28793	322	1.232932	3.97004104	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	202	2.84e-47	NTclustered	gi\|2907625690\|emb\|OZ223250.1\|	1898209	g27979	i0	79.655	62.0124223602485	290	51	89	7	30	315	1439943	1439658	MAG: Acholeplasmataceae bacterium isolate c289da16-4743-485f-819d-17f5771af8e7 genome assembly, chromosome: 1	blastn	19968	202	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
16079453	16079453	PRJNA792582_P_NODE_37373_length_285_cov_1.070755_g36559_i0	PRJNA792582	37373	285	1.070755	3.05165175	Malacoplasma penetrans	28227	Bacteria	Bacteria	139	1.96e-28	NTclustered	gi\|47118307\|dbj\|BA000026.2\|	272633	g36559	i0	89.815	13.0280701754386	108	11	38	0	1	108	94980	95087	Mycoplasma penetrans HF-2 DNA, complete genome	blastn	3713	139	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
17355251	17355251	PRJNA792582_P_NODE_37354_length_285_cov_1.089623_g36540_i0	PRJNA792582	37354	285	1.089623	3.10542555	Malacoplasma penetrans	28227	Bacteria	Bacteria	311	3.9300000000000005e-80	NTclustered	gi\|47118307\|dbj\|BA000026.2\|	272633	g36540	i0	87.004	81.2561403508772	277	34	97	2	1	276	1271351	1271076	Mycoplasma penetrans HF-2 DNA, complete genome	blastn	23158	311	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
19903718	19903718	PRJNA792582_P_NODE_33416_length_298_cov_1.702222_g32602_i0	PRJNA792582	33416	298	1.702222	5.07262156	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	109	1.48e-25	NR	MDK2819925.1	2685873	g32602	i0	59.2	3.06040268456376	98	34	98.7	1	4	297	190	281	MDK2819925.1 APC family permease [Mycoplasmataceae bacterium]	diamond	912	109	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
19903930	19903930	PRJNA792582_P_NODE_51776_length_249_cov_0.875000_g50962_i0	PRJNA792582	51776	249	0.875	2.17875	Malacoplasma sp.	2791014	Bacteria	Bacteria	81.3	1.13e-15	NR	MCF0217436.1	2791014	g50962	i0	60.3	2.20481927710843	63	25	75.9	0	237	49	21	83	MCF0217436.1 TROVE domain-containing protein [Malacoplasma sp.]	diamond	549	81.3	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma sp.
22454497	22454497	PRJNA792582_P_NODE_59218_length_241_cov_0.916667_g58404_i0	PRJNA792582	59218	241	0.916667	2.20916747	Malacoplasma iowae	2116	Bacteria	Bacteria	103	5.879999999999999e-24	NR	WP_406646931.1	2116	g58404	i0	58.2	1.96680497925311	79	33	98.3	0	239	3	271	349	WP_406646931.1 amidase family protein [Malacoplasma iowae]	diamond	474	103	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
22892911	22892911	PRJNA792582_P_NODE_18418_length_401_cov_1.173780_g17604_i0	PRJNA792582	18418	401	1.17378	4.7068578	Bacteria	2	Bacteria	Bacteria	104	5.94e-24	NR	MDR2823098.1	2685873	g17604	i0	77.3	8.3715710723192	66	14	48.6	1	130	324	107	172	MDR2823098.1 type I glyceraldehyde-3-phosphate dehydrogenase [Mycoplasmataceae bacterium]	diamond	3357	105	0.990476190476191	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
27022189	27022189	PRJNA792582_P_NODE_55662_length_245_cov_0.895349_g54848_i0	PRJNA792582	55662	245	0.895349	2.19360505	Mycoplasma sp.	2108	Bacteria	Bacteria	49.3	1.9e-4	NR	MBD5446104.1	2108	g54848	i0	34.8	1.68979591836735	69	36	84.5	2	36	242	959	1018	MBD5446104.1 hypothetical protein [Mycoplasma sp.]	diamond	414	49.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
27536930	27536930	PRJNA792582_P_NODE_42843_length_270_cov_1.502538_g42029_i0	PRJNA792582	42843	270	1.502538	4.0568526	Malacoplasma	2791001	Bacteria	Bacteria	132	5.51e-36	NR	WP_004024704.1	2116	g42029	i0	75.3	2.96666666666667	89	22	98.9	0	269	3	76	164	WP_004024704.1 50S ribosomal protein L3 [Malacoplasma iowae]	diamond	801	132	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma iowae
29327363	29327363	PRJNA792582_P_NODE_56509_length_244_cov_0.900585_g55695_i0	PRJNA792582	56509	244	0.900585	2.1974274	Ureaplasma sp.	1965234	Bacteria	Bacteria	68.9	2.06e-11	NR	MDE5651448.1	1965234	g55695	i0	48.4	3.11065573770492	64	33	78.7	0	208	17	10	73	MDE5651448.1 aminotransferase class V-fold PLP-dependent enzyme [Ureaplasma sp.]	diamond	759	68.9	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma sp.
29611291	29611291	PRJNA792582_P_NODE_13550_length_465_cov_1.448980_g12738_i0	PRJNA792582	13550	465	1.44898	6.737757	Malacoplasma muris	2119	Bacteria	Bacteria	172	1.4599999999999999e-46	NR	WP_412032115.1	2119	g12738	i0	69	0.832258064516129	129	37	82.6	3	58	441	20	146	WP_412032115.1 PTS transporter subunit IIABC [Malacoplasma muris]	diamond	387	172	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
32045345	32045345	PRJNA792582_P_NODE_58418_length_242_cov_0.911243_g57604_i0	PRJNA792582	58418	242	0.911243	2.20520806	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	80.5	1.79e-15	NR	MDK2819538.1	2685873	g57604	i0	82.2	0.557851239669422	45	8	55.8	0	181	47	19	63	MDK2819538.1 PTS sugar transporter subunit IIC [Mycoplasmataceae bacterium]	diamond	135	80.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae 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);;