metadata: contig_metadata: 10 rows where bioproject = "PRJNA851399" and tax

10 rows where bioproject = "PRJNA851399" 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
27497450	27497450	PRJNA851399_P_NODE_24043_length_169_cov_1.216667_g23590_i0	PRJNA851399	24043	169	1.216667	2.05616723	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	42.7	0.0028	NR	MDI3352152.1	2094	g23590	i0	46.7	0.798816568047337	45	16	79.9	1	162	28	1	37	MDI3352152.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	135	42.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
28160608	28160608	PRJNA851399_P_NODE_36585_length_162_cov_8.929204_g36132_i0	PRJNA851399	36585	162	8.929204	14.46531048	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	42.7	0.00774	NR	MDI3350438.1	2094	g36132	i0	55	0.740740740740741	40	18	74.1	0	121	2	43	82	MDI3350438.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	120	42.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
29486285	29486285	PRJNA851399_P_NODE_17710_length_184_cov_0.977778_g17257_i0	PRJNA851399	17710	184	0.977778	1.79911152	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	44.7	0.00296	NR	MDI3350303.1	2094	g17257	i0	90	0.326086956521739	20	2	32.6	0	109	50	4	23	MDI3350303.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	60	44.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
29991853	29991853	PRJNA851399_P_NODE_24091_length_168_cov_4.025210_g23638_i0	PRJNA851399	24091	168	4.02521	6.7623528	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	42.4	0.00625	NR	WP_282459194.1	2094	g23638	i0	60	0.446428571428571	25	10	44.6	0	27	101	16	40	WP_282459194.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	75	42.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
30149578	30149578	PRJNA851399_P_NODE_10312_length_244_cov_6.010256_g9859_i0	PRJNA851399	10312	244	6.010256	14.66502464	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	48.9	1.17e-4	NR	MDI3349153.1	2094	g9859	i0	87.5	0.295081967213115	24	3	29.5	0	194	123	11	34	MDI3349153.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	72	48.9	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
30718392	30718392	PRJNA851399_P_NODE_29894_length_165_cov_1.250000_g29441_i0	PRJNA851399	29894	165	1.25	2.0625	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	43.9	0.00114	NR	MDI3350086.1	2094	g29441	i0	71.4	0.509090909090909	28	8	50.9	0	147	64	68	95	MDI3350086.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	84	43.9	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
30718394	30718394	PRJNA851399_P_NODE_42314_length_153_cov_2.384615_g41861_i0	PRJNA851399	42314	153	2.384615	3.64846095	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	44.3	0.00188	NR	MDI3351509.1	2094	g41861	i0	60	0.686274509803922	35	14	68.6	0	133	29	3	37	MDI3351509.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	105	44.3	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
32054656	32054656	PRJNA851399_P_NODE_22038_length_173_cov_1.233871_g21585_i0	PRJNA851399	22038	173	1.233871	2.13459683	root	1	Root_unresolved	Root_unresolved	55.5	3.25e-7	NR	AAO61963.1	35779	g21585	i0	42.1	6.72832369942197	57	33	98.8	0	173	3	97	153	AAO61963.1 DNA polymerase, partial [Aster yellows phytoplasma]	diamond	1164	55.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Aster yellows phytoplasma
32204737	32204737	PRJNA851399_P_NODE_27138_length_166_cov_2.042735_g26685_i0	PRJNA851399	27138	166	2.042735	3.3909401	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	44.3	0.00317	NR	MDI3350304.1	2094	g26685	i0	90	0.36144578313253	20	2	36.1	0	42	101	115	134	MDI3350304.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	60	44.3	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
32804613	32804613	PRJNA851399_P_NODE_38700_length_162_cov_0.902655_g38247_i0	PRJNA851399	38700	162	0.902655	1.4623011	Mycoplasmoidaceae bacterium	2854035	Bacteria	Bacteria	50.1	2.69e-5	NR	GMO20760.1	2854035	g38247	i0	42.3	2.88888888888889	52	30	96.3	0	158	3	66	117	GMO20760.1 MAG: hypothetical protein Ta2E_11940 [Mycoplasmoidaceae bacterium]	diamond	468	50.1	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae		Mycoplasmoidaceae 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);;