metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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
9121303	9121303	PRJNA1086823_P_NODE_12748_length_252_cov_0.871508_g12631_i0	PRJNA1086823	12748	252	0.871508	2.19620016	Pseudomonadati	3379134	Bacteria	Bacteria	132	1.69e-33	NR	HEY5753989.1	2201154	g12631	i0	75.6	45.25	82	20	97.6	0	251	6	668	749	HEY5753989.1 DEAD/DEAH box helicase [Chthoniobacterales bacterium]	diamond	11403	133	0.992481203007519	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
10397044	10397044	PRJNA1086823_P_NODE_13989_length_250_cov_0.881356_g13872_i0	PRJNA1086823	13989	250	0.881356	2.20339	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	108	6.79e-27	NR	HWB58488.1	2811408	g13872	i0	65.9	0.984	82	26	98.4	1	248	3	16	95	HWB58488.1 glycosyltransferase [Chthoniobacteraceae bacterium]	diamond	246	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
26877925	26877925	PRJNA1086823_P_NODE_16961_length_245_cov_0.906977_g16844_i0	PRJNA1086823	16961	245	0.906977	2.22209365	Opitutaceae bacterium	2006848	Bacteria	Bacteria	152	2.07e-41	NR	MBW7894878.1	2006848	g16844	i0	84	2.97551020408163	81	13	99.2	0	1	243	11	91	MBW7894878.1 SAM-dependent DNA methyltransferase [Opitutaceae bacterium]	diamond	729	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27035883	27035883	PRJNA1086823_P_NODE_11302_length_259_cov_3.010753_g11185_i0	PRJNA1086823	11302	259	3.010753	7.79785027	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.8	5.33e-5	NR	MEO8427722.1	2026799	g11185	i0	51.7	1.37837837837838	58	20	60.2	2	6	161	42	97	MEO8427722.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium]	diamond	357	50.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27510004	27510004	PRJNA1086823_P_NODE_18103_length_244_cov_0.871345_g17986_i0	PRJNA1086823	18103	244	0.871345	2.1260818	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	114	2.03e-27	NR	HOX56336.1	2026799	g17986	i0	65.8	0.971311475409836	79	27	97.1	0	3	239	111	189	HOX56336.1 cell wall anchor protein [Verrucomicrobiota bacterium]	diamond	237	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29152097	29152097	PRJNA1086823_P_NODE_12309_length_253_cov_0.866667_g12192_i0	PRJNA1086823	12309	253	0.866667	2.19266751	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	107	6.84e-25	NR	MBX7210235.1	2026800	g12192	i0	59.1	1.10276679841897	93	27	98.4	3	3	251	200	291	MBX7210235.1 aryl-sulfate sulfotransferase [Verrucomicrobiaceae bacterium]	diamond	279	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29562064	29562064	PRJNA1086823_P_NODE_16130_length_247_cov_0.896552_g16013_i0	PRJNA1086823	16130	247	0.896552	2.21448344	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	149	1.36e-40	NR	MDH4410114.1	2026801	g16013	i0	86.3	1.95546558704453	80	11	97.2	0	3	242	379	458	MDH4410114.1 polysaccharide pyruvyl transferase family protein [Verrucomicrobiales bacterium]	diamond	483	149	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30130349	30130349	PRJNA1086823_P_NODE_18332_length_243_cov_0.917647_g18215_i0	PRJNA1086823	18332	243	0.917647	2.22988221	Haloferula rosea	490093	Bacteria	Bacteria	135	4.6599999999999995e-37	NR	WP_200275685.1	490093	g18215	i0	85	4.9382716049382704	80	12	98.8	0	241	2	81	160	WP_200275685.1 acetyl-CoA carboxylase, carboxyltransferase subunit beta [Haloferula rosea]	diamond	1200	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula rosea
30248757	30248757	PRJNA1086823_P_NODE_14532_length_249_cov_0.886364_g14415_i0	PRJNA1086823	14532	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	154	3.1099999999999998e-46	NR	PYJ67514.1	2026799	g14415	i0	88	5	83	10	100	0	1	249	50	132	PYJ67514.1 MAG: hypothetical protein DME76_15025, partial [Verrucomicrobiota bacterium]	diamond	1245	155	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30415416	30415416	PRJNA1086823_P_NODE_18713_length_243_cov_0.917647_g18596_i0	PRJNA1086823	18713	243	0.917647	2.22988221	Verrucomicrobia bacterium 21-51-4	1970609	Bacteria	Bacteria	110	2.33e-26	NR	OYV47722.1	1970609	g18596	i0	75	0.987654320987654	80	20	98.8	0	3	242	53	132	OYV47722.1 MAG: EscC/YscC/HrcC family type III secretion system outer membrane ring protein, partial [Verrucomicrobia bacterium 21-51-4]	diamond	240	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium 21-51-4
31141370	31141370	PRJNA1086823_P_NODE_12995_length_252_cov_0.871508_g12878_i0	PRJNA1086823	12995	252	0.871508	2.19620016	Chthoniobacter sp.	2510640	Bacteria	Bacteria	68.6	3.13e-11	NR	MCE9608906.1	2510640	g12878	i0	55.6	0.75	63	28	75	0	1	189	274	336	MCE9608906.1 glycosyltransferase family 4 protein [Chthoniobacter sp.]	diamond	189	68.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
31227820	31227820	PRJNA1086823_P_NODE_8915_length_283_cov_1.619048_g8798_i0	PRJNA1086823	8915	283	1.619048	4.58190584	Pseudomonadati	3379134	Bacteria	Bacteria	120	4.39e-30	NR	MBL9139086.1	2026801	g8798	i0	65.6	1.97173144876325	93	32	98.6	0	3	281	185	277	MBL9139086.1 DUF4062 domain-containing protein [Verrucomicrobiales bacterium]	diamond	558	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31331390	31331390	PRJNA1086823_P_NODE_19236_length_242_cov_0.923077_g19119_i0	PRJNA1086823	19236	242	0.923077	2.23384634	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	55.8	9.07e-7	NR	MCC7374768.1	2026801	g19119	i0	41.3	2.82644628099174	80	43	99.2	2	3	242	1635	1710	MCC7374768.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	684	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32090680	32090680	PRJNA1086823_P_NODE_15418_length_248_cov_0.891429_g15301_i0	PRJNA1086823	15418	248	0.891429	2.21074392	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	144	1.76e-39	NR	MBP8260243.1	2026799	g15301	i0	83.8	1.97177419354839	80	12	95.6	1	12	248	133	212	MBP8260243.1 acetylxylan esterase [Verrucomicrobiota bacterium]	diamond	489	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;