metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA737474" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA737474" 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
25993828	25993828	PRJNA737474g_S_NODE_265084_length_260_cov_3.245989_g263790_i0	PRJNA737474	265084	260	3.245989	8.4395714	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	170	4.91e-53	NR	WP_367896666.1	2109	g263790	i0	100	0.992307692307692	86	0	99.2	0	259	2	2	87	WP_367896666.1 aldehyde dehydrogenase family protein, partial [Mycoplasmopsis synoviae]	diamond	258	170	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
32937049	32937049	PRJNA737474f_S_NODE_66257_length_318_cov_3.253061_g65579_i0	PRJNA737474	66257	318	3.253061	10.34473398	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	119	1.45e-32	NR	WP_367896663.1	2109	g65579	i0	100	0.594339622641509	63	0	59.4	0	77	265	1	63	WP_367896663.1 hypothetical protein, partial [Mycoplasmopsis synoviae]	diamond	189	119	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
32954253	32954253	PRJNA737474f_S_NODE_45410_length_349_cov_4.619565_g44732_i0	PRJNA737474	45410	349	4.619565	16.12228185	Spiroplasma endosymbiont of Danaus chrysippus	2691041	Bacteria	Bacteria	80.9	2.88e-17	NR	WP_174480293.1	2691041	g44732	i0	58.7	0.541547277936963	63	26	54.2	0	343	155	20	82	WP_174480293.1 HMG-box domain-containing protein [Spiroplasma endosymbiont of Danaus chrysippus]	diamond	189	80.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Danaus chrysippus
32988795	32988795	PRJNA737474g_S_NODE_188947_length_281_cov_1.822115_g187653_i0	PRJNA737474	188947	281	1.822115	5.12014315	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	166	3.23e-51	NR	WP_367896663.1	2109	g187653	i0	95.5	0.939501779359431	88	4	94	0	280	17	9	96	WP_367896663.1 hypothetical protein, partial [Mycoplasmopsis synoviae]	diamond	264	166	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
33055539	33055539	PRJNA737474d_S_NODE_22701_length_320_cov_1.923077_g22107_i0	PRJNA737474	22701	320	1.923077	6.1538464	Mesoplasma photuris	217731	Bacteria	Bacteria	68.2	1.09e-10	NR	WP_031542743.1	217731	g22107	i0	43.9	0.76875	82	31	76.9	1	54	299	673	739	WP_031542743.1 ATP-dependent DNA helicase [Mesoplasma photuris]	diamond	246	68.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma photuris
33057473	33057473	PRJNA737474g_S_NODE_46333_length_424_cov_1.752137_g45041_i0	PRJNA737474	46333	424	1.752137	7.42906088	Mycoplasmopsis synoviae	2109	Bacteria	Bacteria	161	2.82e-48	NR	WP_367896650.1	2109	g45041	i0	100	1.71933962264151	81	0	57.3	0	2	244	12	92	WP_367896650.1 alcohol dehydrogenase catalytic domain-containing protein, partial [Mycoplasmopsis synoviae]	diamond	729	161	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis synoviae
33142180	33142180	PRJNA737474g_S_NODE_177775_length_285_cov_2.561321_g176481_i0	PRJNA737474	177775	285	2.561321	7.29976485	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	69.3	2.08e-12	NR	RKX67325.1	2231116	g176481	i0	38.1	0.884210526315789	84	52	88.4	0	280	29	43	126	RKX67325.1 MAG: hypothetical protein DRP42_00575 [Mycoplasmatota bacterium]	diamond	252	69.3	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
33175655	33175655	PRJNA737474f_S_NODE_163952_length_262_cov_0.804233_g163274_i0	PRJNA737474	163952	262	0.804233	2.10709046	Spiroplasma	2132	Bacteria	Bacteria	54.3	3.94e-6	NR	WP_040093872.1	2132	g163274	i0	45.9	4.21374045801527	61	28	68.7	2	261	82	413	469	WP_040093872.1 MULTISPECIES: glycerol kinase GlpK [Spiroplasma]	diamond	1104	54.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma

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