metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA792582" 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
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.
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);;