metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax_phylum = "Verrucomicrobiota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26642193	26642193	PRJNA792582_P_NODE_47501_length_257_cov_1.467391_g46687_i0	PRJNA792582	47501	257	1.467391	3.77119487	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0445	NR	MBI5692837.1	2026799	g46687	i0	46.5	0.501945525291829	43	20	46.7	1	132	13	229	271	MBI5692837.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	129	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28768221	28768221	PRJNA792582_P_NODE_52967_length_248_cov_0.880000_g52153_i0	PRJNA792582	52967	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	46.2	5.57e-4	NR	MBS0628080.1	2026799	g52153	i0	80.8	1.25806451612903	26	5	31.5	0	245	168	85	110	MBS0628080.1 30S ribosomal protein S6 [Verrucomicrobiota bacterium]	diamond	312	46.6	0.991416309012876	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29012051	29012051	PRJNA792582_P_NODE_55468_length_245_cov_0.895349_g54654_i0	PRJNA792582	55468	245	0.895349	2.19360505	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	45.1	0.00563	NR	MDD5198439.1	2832348	g54654	i0	35.6	0.893877551020408	73	42	89.4	2	224	6	264	331	MDD5198439.1 NADH-quinone oxidoreductase subunit H [Terrimicrobiaceae bacterium]	diamond	219	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
29327356	29327356	PRJNA792582_P_NODE_47349_length_257_cov_2.288043_g46535_i0	PRJNA792582	47349	257	2.288043	5.88027051	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	120	1.2699999999999998e-31	NR	HEY4758684.1	2201154	g46535	i0	70.6	1.98443579766537	85	22	95.7	1	254	9	51	135	HEY4758684.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	510	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30053616	30053616	PRJNA792582_P_NODE_44851_length_264_cov_3.068063_g44037_i0	PRJNA792582	44851	264	3.068063	8.09968632	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	150	2.5499999999999994e-42	NR	MBL9168847.1	2026801	g44037	i0	80.5	0.988636363636364	87	17	98.9	0	264	4	167	253	MBL9168847.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	261	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30780457	30780457	PRJNA792582_P_NODE_54414_length_246_cov_1.231214_g53600_i0	PRJNA792582	54414	246	1.231214	3.02878644	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0381	NR	MEI6341235.1	2026799	g53600	i0	36	0.914634146341463	75	39	80.5	2	5	202	84	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	225	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30884420	30884420	PRJNA792582_P_NODE_32134_length_305_cov_1.327586_g31320_i0	PRJNA792582	32134	305	1.327586	4.0491373	Pseudomonadati	3379134	Bacteria	Bacteria	77.4	5.17e-14	NR	MBP7949329.1	2026801	g31320	i0	40	2.97049180327869	100	54	98.4	2	301	2	199	292	MBP7949329.1 peptidase M66 [Verrucomicrobiales bacterium]	diamond	906	77.8	0.994858611825193	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31507674	31507674	PRJNA792582_P_NODE_49196_length_252_cov_1.458101_g48382_i0	PRJNA792582	49196	252	1.458101	3.67441452	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0395	NR	MEO0797149.1	2026799	g48382	i0	40	0.773809523809524	65	37	76.2	2	32	223	289	352	MEO0797149.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	195	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32076917	32076917	PRJNA792582_P_NODE_40858_length_275_cov_2.049505_g40044_i0	PRJNA792582	40858	275	2.049505	5.63613875	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	93.2	1.51e-20	NR	MBS0585478.1	2026799	g40044	i0	50.6	0.949090909090909	87	43	94.9	0	2	262	47	133	MBS0585478.1 deoxyribonuclease IV [Verrucomicrobiota bacterium]	diamond	261	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32393340	32393340	PRJNA792582_P_NODE_35419_length_290_cov_1.152074_g34605_i0	PRJNA792582	35419	290	1.152074	3.3410146	Methylacidimicrobium cyclopophantes	1041766	Bacteria	Bacteria	44.7	0.0133	NR	WP_142524394.1	1041766	g34605	i0	43.8	0.496551724137931	48	23	49.7	1	164	21	33	76	WP_142524394.1 ABC transporter permease, partial [Methylacidimicrobium cyclopophantes]	diamond	144	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium cyclopophantes

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