metadata: contig_metadata: 17 rows where bioproject = "PRJNA643700", tax_kingdom = "Bacillati" and tax

17 rows where bioproject = "PRJNA643700", 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	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
618269	618269	PRJNA643700_P_NODE_410801_length_165_cov_0.896552_g409245_i0	PRJNA643700	410801	165	0.896552	1.4793108	Mycoplasmataceae bacterium T2110	363696	Bacteria	Bacteria	200	4.659999999999998e-47	NTclustered	gi\|83962876\|gb\|DQ318957.1\|	363696	g409245	i0	88.485	46.2909090909091	165	19	100	1	165	288	124	Mycoplasmataceae bacterium T2110 16S ribosomal RNA gene, partial sequence	blastn	7638	200	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium T2110
1894277	1894277	PRJNA643700_P_NODE_182262_length_295_cov_2.878049_g180706_i0	PRJNA643700	182262	295	2.878049	8.49024455	Mesoplasma florum	2151	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1359437501\|gb\|CP022513.1\|	2151	g180706	i0	100	0.0949152542372881	28	0	9	114	141	714324	714297	Mesoplasma florum strain CnuA-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma florum
1894318	1894318	PRJNA643700_P_NODE_246342_length_242_cov_1.492228_g244786_i0	PRJNA643700	246342	242	1.492228	3.61119176	Candidatus Hepatoplasma vulgare	3132032	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2416256354\|dbj\|AP027131.1\|	3132032	g244786	i0	100	0.115702479338843	28	0	12	13	40	29788	29761	MAG: Candidatus Hepatoplasma vulgare Av-JP DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma vulgare
1894552	1894552	PRJNA643700_P_NODE_99702_length_418_cov_1.821138_g98149_i0	PRJNA643700	99702	418	1.821138	7.61235684	Spiroplasma helicoides	216938	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|1060138310\|gb\|CP017015.1\|	216938	g98149	i0	100	0.0669856459330144	28	0	7	113	140	740135	740162	Spiroplasma helicoides strain TABS-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma helicoides
3168865	3168865	PRJNA643700_P_NODE_123943_length_371_cov_2.406832_g122388_i0	PRJNA643700	123943	371	2.406832	8.92934672	Spiroplasma endosymbiont of Polydrusus pterygomalis	3139327	Bacteria	Bacteria	58.4	7.58e-4	NTclustered	gi\|2719437748\|emb\|OZ034909.1\|	3139327	g122388	i0	97.059	0.183288409703504	34	1	9	275	308	122033	122066	Spiroplasma endosymbiont of Polydrusus pterygomalis isolate 3de30a2b-c507-4d1c-999b-652e75e456be genome assembly, chromosome: 1	blastn	68	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Polydrusus pterygomalis
5721750	5721750	PRJNA643700_P_NODE_381565_length_171_cov_1.278689_g380009_i0	PRJNA643700	381565	171	1.278689	2.18655819	Metamycoplasma faucium	56142	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g380009	i0	100	0.350877192982456	30	0	18	3	32	94173	94202	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	60	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
6996774	6996774	PRJNA643700_P_NODE_352726_length_184_cov_1.511111_g351170_i0	PRJNA643700	352726	184	1.511111	2.78044424	Spiroplasma chrysopicola	216933	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|506965883\|gb\|CP005077.1\|	1276227	g351170	i0	100	0.16304347826087	30	0	16	74	103	34942	34913	Spiroplasma chrysopicola DF-1, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma chrysopicola
9546680	9546680	PRJNA643700_P_NODE_201288_length_277_cov_2.184211_g199732_i0	PRJNA643700	201288	277	2.184211	6.05026447	Malacoplasma muris	2119	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2890642799\|gb\|CP177248.1\|	2119	g199732	i0	100	0.101083032490975	28	0	10	61	88	506612	506639	Malacoplasma muris strain RIII-4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
13912654	13912654	PRJNA643700_P_NODE_347911_length_186_cov_1.693431_g346355_i0	PRJNA643700	347911	186	1.693431	3.14978166	Ureaplasma	2129	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2177595200\|gb\|CP086123.1\|	2130	g346355	i0	100	2.25806451612903	28	0	15	92	119	588043	588070	Ureaplasma urealyticum strain MIN-201 chromosome, complete genome	blastn	420	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma urealyticum
14646981	14646981	PRJNA643700_P_NODE_184652_length_293_cov_1.704918_g183096_i0	PRJNA643700	184652	293	1.704918	4.99540974	Spiroplasma citri	2133	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2476924698\|gb\|CP096808.1\|	2133	g183096	i0	100	0.102389078498294	30	0	10	254	283	530090	530061	Spiroplasma citri strain D12 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma citri
19010148	19010148	PRJNA643700_P_NODE_292035_length_214_cov_1.290909_g290479_i0	PRJNA643700	292035	214	1.290909	2.76254526	Spiroplasma	2132	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2719437843\|emb\|OZ034965.1\|	3066313	g290479	i0	100	0.654205607476635	28	0	13	104	131	510566	510539	Spiroplasma endosymbiont of Zeiraphera isertana isolate 54782 genome assembly, chromosome: 1	blastn	140	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Zeiraphera isertana
19744909	19744909	PRJNA643700_P_NODE_131036_length_360_cov_1.443730_g129481_i0	PRJNA643700	131036	360	1.44373	5.197428	Spiroplasma litorale	216942	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|915477727\|gb\|CP012357.1\|	216942	g129481	i0	100	0.0777777777777778	28	0	8	56	83	302531	302558	Spiroplasma litorale strain TN-1, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma litorale
21020433	21020433	PRJNA643700_P_NODE_124737_length_370_cov_1.457944_g123182_i0	PRJNA643700	124737	370	1.457944	5.3943928	Spiroplasma endosymbiont of Diplazon laetatorius	3066322	Bacteria	Bacteria	58.4	7.56e-4	NTclustered	gi\|2706542397\|emb\|OZ026458.1\|	3066322	g123182	i0	100	0.0837837837837838	31	0	8	51	81	333707	333737	Spiroplasma endosymbiont of Diplazon laetatorius isolate 54808 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Diplazon laetatorius
21020648	21020648	PRJNA643700_P_NODE_397857_length_167_cov_0.881356_g396301_i0	PRJNA643700	397857	167	0.881356	1.47186452	[Mycoplasma] anseris	92400	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1417668539\|gb\|CP030140.1\|	92400	g396301	i0	100	0.173652694610778	29	0	17	105	133	8856	8828	[Mycoplasma] anseris strain ATCC 49234 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	[Mycoplasma] anseris
22836115	22836115	PRJNA643700_P_NODE_309358_length_205_cov_1.250000_g307802_i0	PRJNA643700	309358	205	1.25	2.5625	Mycoplasma	2093	Bacteria	Bacteria	178	2.8299999999999993e-40	NTclustered	gi\|526641996\|ref\|NR_103993.1\|	29501	g307802	i0	92.683	47.9170731707317	123	9	60	56	178	509	387	Mycoplasma haemofelis strain Langford 1 23S ribosomal RNA gene, complete sequence	blastn	9823	178	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
23570813	23570813	PRJNA643700_P_NODE_211379_length_268_cov_2.566210_g209823_i0	PRJNA643700	211379	268	2.56621	6.8774428	Mycoplasmopsis bovis	28903	Bacteria	Bacteria	60.2	1.47e-4	NTclustered	gi\|1951465684\|gb\|CP058422.1\|	28903	g209823	i0	100	0.119402985074627	32	0	12	4	35	232123	232092	Mycoplasmopsis bovis strain Mb252 chromosome	blastn	32	60.2	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
24844693	24844693	PRJNA643700_P_NODE_90660_length_439_cov_2.302564_g89109_i0	PRJNA643700	90660	439	2.302564	10.10825596	Mycoplasmopsis gallinacea	29556	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|1563682195\|emb\|LR214950.1\|	29556	g89109	i0	96.875	0.200455580865604	32	1	7	83	114	798333	798302	Mycoplasma gallinaceum strain NCTC10183 genome assembly, chromosome: 1	blastn	88	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis gallinacea

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