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

14 rows where analysis = "diamond", bioproject = "PRJNA627467" 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
26744893	26744893	PRJNA627467_P_NODE_11621_length_182_cov_2.165414_g11552_i0	PRJNA627467	11621	182	2.165414	3.94105348	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	1.2e-16	NR	ADI16723.1	710995	g11552	i0	72	1.45054945054945	50	14	82.4	0	154	5	1	50	ADI16723.1 hypothetical protein [uncultured Verrucomicrobiales bacterium HF0010_05E02]	diamond	264	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium HF0010_05E02
26891015	26891015	PRJNA627467_P_NODE_12341_length_180_cov_1.251908_g12272_i0	PRJNA627467	12341	180	1.251908	2.2534344	Opitutus sp. ER46	2161864	Bacteria	Bacteria	108	1.04e-25	NR	WP_107834408.1	2161864	g12272	i0	93.1	0.966666666666667	58	4	96.7	0	5	178	825	882	WP_107834408.1 valine--tRNA ligase [Opitutus sp. ER46]	diamond	174	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46
26953840	26953840	PRJNA627467_P_NODE_2902_length_316_cov_2.299625_g2834_i0	PRJNA627467	2902	316	2.299625	7.266815	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.5	1.37e-13	NR	GBL26153.1	2026799	g2834	i0	93.8	1.23417721518987	32	2	30.4	0	314	219	150	181	GBL26153.1 hypothetical protein EMGBS8_01010 [Verrucomicrobiota bacterium]	diamond	390	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27156250	27156250	PRJNA627467_P_NODE_19342_length_161_cov_0.910714_g19273_i0	PRJNA627467	19342	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	88.2	8.99e-19	NR	PYL05533.1	2026799	g19273	i0	73.6	4.91925465838509	53	14	98.8	0	159	1	60	112	PYL05533.1 MAG: hypothetical protein DME34_11235, partial [Verrucomicrobiota bacterium]	diamond	792	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27333642	27333642	PRJNA627467_P_NODE_2303_length_316_cov_2.771536_g2235_i0	PRJNA627467	2303	316	2.7715360000000002	8.75805376	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	6.33e-10	NR	MEP7014928.1	2026799	g2235	i0	93.8	3.34177215189873	32	2	30.4	0	219	314	214	245	MEP7014928.1 NCS1 family nucleobase:cation symporter-1 [Verrucomicrobiota bacterium]	diamond	1056	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27586172	27586172	PRJNA627467_P_NODE_20804_length_155_cov_2.339623_g20735_i0	PRJNA627467	20804	155	2.339623	3.62641565	Spartobacteria bacterium	2052183	Bacteria	Bacteria	73.9	2.37e-15	NR	NBS53893.1	2052183	g20735	i0	92.1	0.735483870967742	38	3	73.5	0	40	153	1	38	NBS53893.1 DUF2442 domain-containing protein [Spartobacteria bacterium]	diamond	114	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
27996700	27996700	PRJNA627467_P_NODE_20645_length_155_cov_4.509434_g20576_i0	PRJNA627467	20645	155	4.509434	6.9896227	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.6	4.54e-17	NR	MFM2198789.1	2026799	g20576	i0	76	0.967741935483871	50	12	96.8	0	153	4	908	957	MFM2198789.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28009543	28009543	PRJNA627467_P_NODE_14805_length_171_cov_3.598361_g14736_i0	PRJNA627467	14805	171	3.598361	6.15319731	root	1	Root_unresolved	Root_unresolved	73.6	1.89e-13	NR	WP_205576064.1	239935	g14736	i0	69.2	6.35087719298246	52	14	91.2	1	5	160	578	627	WP_205576064.1 hypothetical protein [Akkermansia muciniphila]	diamond	1086	74.3	0.990578734858681	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
28754340	28754340	PRJNA627467_P_NODE_9307_length_190_cov_2.198582_g9238_i0	PRJNA627467	9307	190	2.198582	4.1773058	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	97.8	1.93e-24	NR	HEU4772675.1	2665650	g9238	i0	91.9	1.95789473684211	62	5	97.9	0	187	2	16	77	HEU4772675.1 hypothetical protein [Candidatus Udaeobacter sp.]	diamond	372	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28944111	28944111	PRJNA627467_P_NODE_21228_length_153_cov_2.711538_g21159_i0	PRJNA627467	21228	153	2.711538	4.14865314	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	100	2.4599999999999994e-23	NR	HEV8419696.1	2665650	g21159	i0	89.8	1.92156862745098	49	5	96.1	0	148	2	31	79	HEV8419696.1 NnrS family protein [Candidatus Udaeobacter sp.]	diamond	294	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
30491403	30491403	PRJNA627467_P_NODE_9613_length_189_cov_1.821429_g9544_i0	PRJNA627467	9613	189	1.821429	3.44250081	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	75.5	5.13e-14	NR	HXI73658.1	2499141	g9544	i0	63.3	0.952380952380952	60	22	95.2	0	6	185	168	227	HXI73658.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	180	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31818925	31818925	PRJNA627467_P_NODE_4697_length_316_cov_1.692884_g4629_i0	PRJNA627467	4697	316	1.692884	5.34951344	Opitutales bacterium	2026772	Bacteria	Bacteria	45.8	0.0072	NR	MFP4157167.1	2026772	g4629	i0	70	0.588607594936709	30	9	28.5	0	314	225	953	982	MFP4157167.1 chemotaxis protein CheW [Opitutales bacterium]	diamond	186	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
32135524	32135524	PRJNA627467_P_NODE_10258_length_187_cov_1.376812_g10189_i0	PRJNA627467	10258	187	1.376812	2.57463844	Roseimicrobium sp.	3069589	Bacteria	Bacteria	75.9	2.05e-14	NR	HSH95181.1	3069589	g10189	i0	55.7	1.9572192513369	61	27	97.9	0	186	4	101	161	HSH95181.1 DUF6268 family outer membrane beta-barrel protein [Roseimicrobium sp.]	diamond	366	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp.
32874410	32874410	PRJNA627467_P_NODE_9480_length_189_cov_3.564286_g9411_i0	PRJNA627467	9480	189	3.564286	6.73650054	Prosthecobacter	48463	Bacteria	Bacteria	71.2	6.4e-13	NR	MFN7563283.1	1965333	g9411	i0	68.1	2.23809523809524	47	15	74.6	0	27	167	87	133	MFN7563283.1 hypothetical protein [Prosthecobacter sp.]	diamond	423	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.

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