metadata: contig_metadata: 15 rows where bioproject = "PRJNA951810" and tax

15 rows where bioproject = "PRJNA951810" 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
936078	936078	PRJNA951810_P_NODE_145941_length_261_cov_3.611702_g145596_i0	PRJNA951810	145941	261	3.611702	9.42654222	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	86.1	2.35e-12	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g145596	i0	85.542	0.318007662835249	83	10	31	2	24	105	343034	342953	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	83	86.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
1262949	1262949	PRJNA951810_P_NODE_122381_length_278_cov_4.824390_g122036_i0	PRJNA951810	122381	278	4.82439	13.4118042	Ureaplasma	2129	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g122036	i0	100	16.2230215827338	278	0	100	0	1	278	508973	509250	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	4510	514	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
2538784	2538784	PRJNA951810_P_NODE_135102_length_269_cov_4.566327_g134757_i0	PRJNA951810	135102	269	4.566327	12.28341963	Ureaplasma	2129	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|620596742\|dbj\|AP014584.1\|	38504	g134757	i0	99.628	45.4163568773234	269	1	100	0	1	269	262703	262435	Ureaplasma parvum serovar 3 DNA, complete genome, strain: SV3F4	blastn	12217	492	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
3815508	3815508	PRJNA951810_P_NODE_187303_length_221_cov_10.094595_g186958_i0	PRJNA951810	187303	221	10.094595	22.30905495	Ureaplasma	2129	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g186958	i0	100	11	221	0	100	0	1	221	345225	345445	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	2431	409	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
6038981	6038981	PRJNA951810_P_NODE_130185_length_273_cov_2.110000_g129840_i0	PRJNA951810	130185	273	2.11	5.7603	Metamycoplasma faucium	56142	Bacteria	Bacteria	451	2.11e-122	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g129840	i0	96.364	2	275	8	100	2	1	273	382921	382647	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	546	451	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
8915669	8915669	PRJNA951810_P_NODE_104407_length_290_cov_4.322581_g104063_i0	PRJNA951810	104407	290	4.322581	12.5354849	Ureaplasma	2129	Bacteria	Bacteria	278	4.07e-70	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g104063	i0	100	11.051724137931	150	0	100	0	141	290	583697	583846	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	3205	279	0.996415770609319	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
21338484	21338484	PRJNA951810_P_NODE_163277_length_247_cov_5.821839_g162932_i0	PRJNA951810	163277	247	5.821839	14.37994233	Candidatus Xianfuyuplasma coldseepsis	2782163	Bacteria	Bacteria	71.3	6.16e-8	NTclustered	gi\|1883609011\|gb\|CP048914.1\|	2782163	g162932	i0	88.333	0.242914979757085	60	6	24	1	1	59	1410067	1410008	Candidatus Xianfuyuplasma coldseepsis strain zrk13 chromosome, complete genome	blastn	60	71.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Xianfuyuplasma	Candidatus Xianfuyuplasma coldseepsis
25489894	25489894	PRJNA951810_P_NODE_166740_length_245_cov_1.598837_g166395_i0	PRJNA951810	166740	245	1.598837	3.91715065	Ureaplasma	2129	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g166395	i0	100	16	245	0	100	0	1	245	62223	62467	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	3920	453	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
27436861	27436861	PRJNA951810_P_NODE_96443_length_294_cov_8.651584_g96099_i0	PRJNA951810	96443	294	8.651584	25.43565696	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	116	2.4699999999999997e-30	NR	NLB84923.1	1898209	g96099	i0	73.3	0.76530612244898	75	20	76.5	0	68	292	3	77	NLB84923.1 polyribonucleotide nucleotidyltransferase [Acholeplasmataceae bacterium]	diamond	225	116	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
28573189	28573189	PRJNA951810_P_NODE_66907_length_310_cov_2.510549_g66564_i0	PRJNA951810	66907	310	2.510549	7.7827019	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	54.3	6.88e-6	NR	NLH46424.1	1898209	g66564	i0	40.9	1.71290322580645	88	42	75.5	3	308	75	207	294	NLH46424.1 TonB-dependent receptor [Acholeplasmataceae bacterium]	diamond	531	54.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
29173303	29173303	PRJNA951810_P_NODE_32609_length_349_cov_4.369565_g32267_i0	PRJNA951810	32609	349	4.369565	15.24978185	Mycoplasma sp. CAG:472	1262904	Bacteria	Bacteria	63.5	1.85e-9	NR	CDE37919.1	1262904	g32267	i0	42.3	0.833810888252149	97	44	73.9	4	11	268	108	203	CDE37919.1 ribulose-phosphate 3-epimerase [Mycoplasma sp. CAG:472]	diamond	291	63.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. CAG:472
29994230	29994230	PRJNA951810_P_NODE_16131_length_485_cov_2.883495_g15798_i0	PRJNA951810	16131	485	2.883495	13.98495075	Spiroplasma floricola	216937	Bacteria	Bacteria	45.4	0.0321	NR	WP_100916407.1	216937	g15798	i0	28	0.995876288659794	161	93	85.4	4	29	442	26	186	WP_100916407.1 hypothetical protein [Spiroplasma floricola]	diamond	483	45.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma floricola
30720762	30720762	PRJNA951810_P_NODE_64034_length_310_cov_2.970464_g63691_i0	PRJNA951810	64034	310	2.970464	9.2084384	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	65.5	6.94e-11	NR	WNE40183.1	2685873	g63691	i0	62.5	0.464516129032258	48	18	46.5	0	3	146	27	74	WNE40183.1 MAG: hypothetical protein GBAus27B_000250 [Mycoplasmataceae bacterium]	diamond	144	65.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
32530153	32530153	PRJNA951810_P_NODE_62479_length_310_cov_3.198312_g62136_i0	PRJNA951810	62479	310	3.198312	9.9147672	FCB group	1783270	Bacteria	Bacteria	97.8	8.01e-22	NR	WP_129725445.1	171281	g62136	i0	50.9	6.48387096774194	112	44	98.7	3	308	3	103	213	WP_129725445.1 DNA adenine methylase [Mycoplasmopsis citelli]	diamond	2010	98.2	0.995926680244399	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis citelli
32624393	32624393	PRJNA951810_P_NODE_166100_length_245_cov_4.854651_g165755_i0	PRJNA951810	166100	245	4.854651	11.89389495	FCB group	1783270	Bacteria	Bacteria	62.4	4.43e-9	NR	WP_262095948.1	69473	g165755	i0	45.3	5.36326530612245	64	30	75.9	2	243	58	270	330	WP_262095948.1 glycoside hydrolase family 30 protein [Paracholeplasma vituli]	diamond	1314	62.8	0.993630573248408	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Paracholeplasma	Paracholeplasma vituli

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