metadata: contig_metadata: 8 rows where bioproject = "PRJNA849822", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA849822", 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
10162025	10162025	PRJNA849822_P_NODE_28908_length_272_cov_0.919598_g28734_i0	PRJNA849822	28908	272	0.919598	2.50130656	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|2652376277\|gb\|CP142136.1\|	29562	g28734	i0	96.97	39.5882352941176	33	0	12	1	171	203	615634	615603	Mesomycoplasma ovipneumoniae strain GH 3-3 chromosome, complete genome	blastn	10768	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
12713068	12713068	PRJNA849822_P_NODE_19650_length_327_cov_0.803150_g19476_i0	PRJNA849822	19650	327	0.80315	2.6263005	Mesomycoplasma	2923352	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2717001259\|gb\|CP145983.1\|	29562	g19476	i0	94.286	0.321100917431193	35	1	10	1	261	294	818505	818539	Mesomycoplasma ovipneumoniae strain OARF2_122 chromosome, complete genome	blastn	105	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
16141281	16141281	PRJNA849822_P_NODE_18133_length_340_cov_1.168539_g17959_i0	PRJNA849822	18133	340	1.168539	3.9730326	Mycoplasma feriruminatoris	1179777	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1795739732\|emb\|LR739237.1\|	1179777	g17959	i0	96.97	0.194117647058824	33	0	10	1	239	271	591134	591103	Mycoplasma feriruminatoris 14/OD_0492 chromosome : 1	blastn	66	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma feriruminatoris
19965053	19965053	PRJNA849822_P_NODE_26396_length_283_cov_1.676190_g26222_i0	PRJNA849822	26396	283	1.67619	4.7436177	FCB group	1783270	Bacteria	Bacteria	132	5.28e-36	NR	KFZ26698.1	1541960	g26222	i0	62	10.5901060070671	92	35	97.5	0	282	7	39	130	KFZ26698.1 MAG: Uracil-DNA glycosylase [Candidatus Izimaplasma bacterium HR2]	diamond	2997	132	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Izemoplasma	Candidatus Izimoplasma sp. HR2
22515265	22515265	PRJNA849822_P_NODE_13558_length_398_cov_1.181538_g13384_i0	PRJNA849822	13558	398	1.181538	4.70252124	Mycoplasma yeatsii	51365	Bacteria	Bacteria	62.1	6.33e-5	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g13384	i0	80.723	1.23618090452261	83	13	20	3	312	392	762304	762385	Mycoplasma yeatsii GM274B	blastn	492	62.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
29107690	29107690	PRJNA849822_P_NODE_21988_length_309_cov_1.322034_g21814_i0	PRJNA849822	21988	309	1.322034	4.08508506	Spiroplasma ixodetis	2141	Bacteria	Bacteria	57.8	4.38e-7	NR	MBP1526520.1	2141	g21814	i0	60.9	0.893203883495146	46	18	44.7	0	309	172	303	348	MBP1526520.1 AAA family ATPase [Spiroplasma ixodetis]	diamond	276	57.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
29526399	29526399	PRJNA849822_P_NODE_23390_length_299_cov_2.070796_g23216_i0	PRJNA849822	23390	299	2.070796	6.19168004	Bacteria	2	Bacteria	Bacteria	43.1	0.00953	NR	WP_096862579.1	138853	g23216	i0	45.8	1.05351170568562	59	30	57.2	1	171	1	2	60	WP_096862579.1 HU family DNA-binding protein [Mesoplasma lactucae]	diamond	315	43.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma lactucae
30726659	30726659	PRJNA849822_P_NODE_41134_length_244_cov_0.912281_g40960_i0	PRJNA849822	41134	244	0.912281	2.22596564	Bacillati	1783272	Bacteria	Bacteria	63.5	1.04e-9	NR	MFA6800753.1	1898209	g40960	i0	47.8	3.45491803278689	69	33	84.8	1	243	37	194	259	MFA6800753.1 lysophospholipase [Acholeplasmataceae bacterium]	diamond	843	63.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae 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);;