metadata: contig_metadata: 10 rows where bioproject = "PRJNA884104", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA884104", 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
5964440	5964440	PRJNA884104_S_NODE_61225_length_267_cov_1.190722_g60482_i0	PRJNA884104	61225	267	1.190722	3.17922774	Bacteria	2	Bacteria	Bacteria	138	1.09e-36	NR	MCD4826324.1	1898209	g60482	i0	79.8	6.68539325842697	84	17	94.4	0	264	13	108	191	MCD4826324.1 xylose isomerase [Acholeplasmataceae bacterium]	diamond	1785	138	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
6345298	6345298	PRJNA884104_S_NODE_68425_length_251_cov_1.000000_g67682_i0	PRJNA884104	68425	251	1	2.51	Mesomycoplasma	2923352	Bacteria	Bacteria	283	7.409999999999999e-72	NTclustered	gi\|1958638472\|gb\|MW498281.1\|	2100	g67682	i0	99.359	62.2111553784861	156	1	62	0	96	251	2244	2399	Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence	blastn	15615	283	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
11064126	11064126	PRJNA884104_S_NODE_31909_length_362_cov_1.688581_g31166_i0	PRJNA884104	31909	362	1.688581	6.11266322	Mycoplasmopsis bovigenitalium	2112	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|1109662972\|dbj\|AP017902.1\|	2112	g31166	i0	100	0.154696132596685	28	0	8	0	100	127	670740	670767	Mycoplasma bovigenitalium DNA, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovigenitalium
21263527	21263527	PRJNA884104_S_NODE_82057_length_243_cov_1.341176_g81314_i0	PRJNA884104	82057	243	1.341176	3.25905768	Mariniplasma anaerobium	2735436	Bacteria	Bacteria	67.6	7.82e-7	NTclustered	gi\|1964073164\|dbj\|AP024412.1\|	2735436	g81314	i0	85.714	0.489711934156379	63	9	26	0	8	70	312507	312445	Mariniplasma anaerobium DNA, complete genome	blastn	119	67.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Mariniplasma	Mariniplasma anaerobium
26928904	26928904	PRJNA884104_S_NODE_75882_length_247_cov_0.885057_g75139_i0	PRJNA884104	75882	247	0.885057	2.18609079	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	62.4	4.38e-9	NR	MCR5112743.1	2053494	g75139	i0	41.9	0.753036437246964	62	36	75.3	0	245	60	329	390	MCR5112743.1 hypothetical protein [Acholeplasmatales bacterium]	diamond	186	62.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium
28697804	28697804	PRJNA884104_S_NODE_59987_length_270_cov_1.147208_g59244_i0	PRJNA884104	59987	270	1.147208	3.0974616	Mycoplasma buteonis	171280	Bacteria	Bacteria	43.1	0.0399	NR	WP_036453040.1	171280	g59244	i0	31.3	0.922222222222222	83	53	88.9	2	270	31	1086	1167	WP_036453040.1 FtsX-like permease family protein, partial [Mycoplasma buteonis]	diamond	249	43.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma buteonis
30055293	30055293	PRJNA884104_S_NODE_72411_length_249_cov_0.875000_g71668_i0	PRJNA884104	72411	249	0.875	2.17875	Spiroplasma chrysopicola	216933	Bacteria	Bacteria	78.6	9.7e-15	NR	WP_016339049.1	216933	g71668	i0	51.9	5.80722891566265	81	33	97.6	1	247	5	610	684	WP_016339049.1 isoleucine--tRNA ligase [Spiroplasma chrysopicola]	diamond	1446	78.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma chrysopicola
30497853	30497853	PRJNA884104_S_NODE_78953_length_245_cov_0.895349_g78210_i0	PRJNA884104	78953	245	0.895349	2.19360505	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	60.1	2.9e-8	NR	MBR4495755.1	2053494	g78210	i0	54.8	1.3469387755102	62	27	74.7	1	56	238	12	73	MBR4495755.1 hypothetical protein [Acholeplasmatales bacterium]	diamond	330	60.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium
31287600	31287600	PRJNA884104_S_NODE_51995_length_290_cov_1.419355_g51252_i0	PRJNA884104	51995	290	1.419355	4.1161295	Spiroplasma ixodetis	2141	Bacteria	Bacteria	76.6	1.2e-15	NR	WP_281748395.1	2141	g51252	i0	37.3	1.81034482758621	83	50	85.9	1	290	42	8	88	WP_281748395.1 thioredoxin [Spiroplasma ixodetis]	diamond	525	76.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma ixodetis
32300419	32300419	PRJNA884104_S_NODE_61679_length_266_cov_1.160622_g60936_i0	PRJNA884104	61679	266	1.160622	3.08725452	Mollicutes bacterium PWAP	2885760	Bacteria	Bacteria	53.1	4.27e-6	NR	MBX4209690.1	2885760	g60936	i0	72.7	2.23308270676692	33	9	37.2	0	142	44	2	34	MBX4209690.1 adenylate kinase [Mollicutes bacterium PWAP]	diamond	594	53.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium PWAP

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