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

10 rows where bioproject = "PRJNA169559", 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_order	tax_family	tax_genus	tax_species
29884540	29884540	PRJNA169559_P_NODE_45851_length_203_cov_3.143678_g43774_i0	PRJNA169559	45851	203	3.143678	6.38166634	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	130	7.5e-37	NR	WP_282460195.1	2094	g43774	i0	100	0.990147783251232	67	0	99	0	2	202	51	117	WP_282460195.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	201	130	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
30231894	30231894	PRJNA169559_P_NODE_22272_length_339_cov_1.674194_g20207_i0	PRJNA169559	22272	339	1.674194	5.67551766	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	137	3.72e-40	NR	WP_282460194.1	2094	g20207	i0	100	0.566371681415929	64	0	56.6	0	268	77	1	64	WP_282460194.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	192	137	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
31274580	31274580	PRJNA169559_P_NODE_18415_length_396_cov_2.811989_g16409_i0	PRJNA169559	18415	396	2.811989	11.13547644	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	211	9.16e-68	NR	WP_282460074.1	2094	g16409	i0	100	0.772727272727273	102	0	77.3	0	387	82	49	150	WP_282460074.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	306	211	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
31464640	31464640	PRJNA169559_P_NODE_48336_length_160_cov_2.763359_g46259_i0	PRJNA169559	48336	160	2.763359	4.4213744	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	105	3.6e-26	NR	WP_282460166.1	2094	g46259	i0	92.3	0.975	52	4	97.5	0	3	158	89	140	WP_282460166.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	156	105	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
31717417	31717417	PRJNA169559_P_NODE_17557_length_406_cov_2.066313_g15564_i0	PRJNA169559	17557	406	2.066313	8.38923078	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	200	2.96e-63	NR	WP_282460065.1	2094	g15564	i0	100	0.731527093596059	99	0	73.2	0	299	3	1	99	WP_282460065.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	297	200	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
31938731	31938731	PRJNA169559_P_NODE_5577_length_719_cov_2.350725_g4188_i0	PRJNA169559	5577	719	2.350725	16.90171275	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	328	4.1199999999999987e-112	NR	WP_282460229.1	2094	g4188	i0	99.4	0.663421418636996	159	1	66.3	0	681	205	1	159	WP_282460229.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	477	328	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
32476929	32476929	PRJNA169559_P_NODE_18939_length_389_cov_2.469444_g16926_i0	PRJNA169559	18939	389	2.469444	9.60613716	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	179	7.659999999999999e-56	NR	MDI3349154.1	2094	g16926	i0	92.8	1.49614395886889	97	1	70.2	1	387	115	17	113	MDI3349154.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	582	179	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
32476932	32476932	PRJNA169559_P_NODE_22939_length_329_cov_2.453333_g20868_i0	PRJNA169559	22939	329	2.453333	8.07146557	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	204	1.76e-65	NR	WP_282460059.1	2094	g20868	i0	99	0.884498480243161	97	1	88.4	0	37	327	1	97	WP_282460059.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	291	204	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
32540279	32540279	PRJNA169559_P_NODE_37899_length_240_cov_1.587678_g35822_i0	PRJNA169559	37899	240	1.587678	3.8104272	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	67.8	6.88e-12	NR	WP_282460216.1	2094	g35822	i0	97.3	0.4625	37	1	46.3	0	239	129	136	172	WP_282460216.1 hypothetical protein, partial [Mycoplasmopsis arginini]	diamond	111	67.8	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
32603158	32603158	PRJNA169559_P_NODE_23360_length_323_cov_2.292517_g21287_i0	PRJNA169559	23360	323	2.292517	7.40482991	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	201	7.05e-64	NR	WP_282460215.1	2094	g21287	i0	96.3	0.993808049535604	107	4	99.4	0	3	323	46	152	WP_282460215.1 hypothetical protein [Mycoplasmopsis arginini]	diamond	321	201	1	Bacteria	Bacillati	Mycoplasmatota	Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini

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