metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA1146029" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA1146029" 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
7943092	7943092	PRJNA1146029_P_NODE_12907_length_272_cov_1.547739_g12626_i0	PRJNA1146029	12907	272	1.547739	4.20985008	Bacteria	2	Bacteria	Bacteria	167	6.469999999999999e-46	NR	MBI2515963.1	2026771	g12626	i0	88.9	2.97794117647059	90	10	99.3	0	271	2	164	253	MBI2515963.1 glutamate synthase large subunit [Opitutia bacterium]	diamond	810	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
26647754	26647754	PRJNA1146029_P_NODE_20721_length_243_cov_0.905882_g20440_i0	PRJNA1146029	20721	243	0.905882	2.20129326	Pseudomonadati	3379134	Bacteria	Bacteria	128	1.03e-33	NR	HEY5227254.1	2006848	g20440	i0	80.6	8.75308641975309	72	14	88.9	0	241	26	292	363	HEY5227254.1 CocE/NonD family hydrolase [Opitutaceae bacterium]	diamond	2127	129	0.992248062015504	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27007151	27007151	PRJNA1146029_P_NODE_16742_length_250_cov_0.870056_g16461_i0	PRJNA1146029	16742	250	0.870056	2.17514	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	77	5.12e-15	NR	HEY1788369.1	2499141	g16461	i0	58.9	0.876	73	28	85.2	2	245	33	147	219	HEY1788369.1 PEP-CTERM sorting domain-containing protein [Verrucomicrobiia bacterium]	diamond	219	77	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27091134	27091134	PRJNA1146029_P_NODE_14882_length_258_cov_1.664865_g14601_i0	PRJNA1146029	14882	258	1.664865	4.2953517	Bacteria	2	Bacteria	Bacteria	78.2	1.54e-14	NR	TMP90165.1	2026799	g14601	i0	57.3	3.63953488372093	75	32	87.2	0	31	255	593	667	TMP90165.1 MAG: tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	939	78.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27449986	27449986	PRJNA1146029_P_NODE_15023_length_257_cov_1.673913_g14742_i0	PRJNA1146029	15023	257	1.673913	4.30195641	Opitutia bacterium	2026771	Bacteria	Bacteria	77.4	3.84e-16	NR	MAL85640.1	2026771	g14742	i0	82.2	0.525291828793774	45	8	52.5	0	121	255	1	45	MAL85640.1 nucleotide pyrophosphohydrolase [Opitutia bacterium]	diamond	135	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
27943965	27943965	PRJNA1146029_P_NODE_14945_length_258_cov_1.248649_g14664_i0	PRJNA1146029	14945	258	1.248649	3.22151442	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	1.82e-5	NR	HVW22076.1	2006848	g14664	i0	44.4	4.36046511627907	81	35	88.4	3	16	243	113	188	HVW22076.1 tetratricopeptide repeat protein [Opitutaceae bacterium]	diamond	1125	52.8	0.992424242424242	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28133486	28133486	PRJNA1146029_P_NODE_14305_length_262_cov_2.063492_g14024_i0	PRJNA1146029	14305	262	2.063492	5.40634904	Opitutus	178440	Bacteria	Bacteria	112	1.06e-26	NR	MSU24673.1	1913982	g14024	i0	58.1	1.96946564885496	86	36	98.5	0	260	3	461	546	MSU24673.1 amidase [Opitutus sp.]	diamond	516	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
28144655	28144655	PRJNA1146029_P_NODE_21125_length_243_cov_0.905882_g20844_i0	PRJNA1146029	21125	243	0.905882	2.20129326	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	55.8	9e-7	NR	RYD66550.1	2026800	g20844	i0	41.6	0.950617283950617	77	45	95.1	0	3	233	839	915	RYD66550.1 MAG: ATP-binding protein [Verrucomicrobiaceae bacterium]	diamond	231	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28385904	28385904	PRJNA1146029_P_NODE_19106_length_246_cov_0.890173_g18825_i0	PRJNA1146029	19106	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	112	5.03e-27	NR	MEM9016119.1	2026799	g18825	i0	63	3.95121951219512	81	30	98.8	0	245	3	97	177	MEM9016119.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Verrucomicrobiota bacterium]	diamond	972	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28480680	28480680	PRJNA1146029_P_NODE_18046_length_248_cov_0.880000_g17765_i0	PRJNA1146029	18046	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	155	4.74e-44	NR	HXU59272.1	2499141	g17765	i0	85.4	15.8709677419355	82	12	99.2	0	248	3	82	163	HXU59272.1 aldo/keto reductase [Verrucomicrobiia bacterium]	diamond	3936	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28586639	28586639	PRJNA1146029_P_NODE_8487_length_311_cov_1.294118_g8206_i0	PRJNA1146029	8487	311	1.294118	4.02470698	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.6	6.86e-11	NR	MEO6181703.1	2026799	g8206	i0	42	0.964630225080386	100	57	95.5	1	10	306	339	438	MEO6181703.1 TIGR04222 domain-containing membrane protein [Verrucomicrobiota bacterium]	diamond	300	68.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29616955	29616955	PRJNA1146029_P_NODE_7750_length_323_cov_1.232000_g7471_i0	PRJNA1146029	7750	323	1.232	3.97936	root	1	Root_unresolved	Root_unresolved	101	2.78e-22	NR	MEY2479147.1	2026799	g7471	i0	46.6	3.79876160990712	103	55	95.7	0	316	8	178	280	MEY2479147.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1227	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29912783	29912783	PRJNA1146029_P_NODE_15571_length_253_cov_1.555556_g15290_i0	PRJNA1146029	15571	253	1.555556	3.93555668	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	116	2.31e-29	NR	MBE0540231.1	2026799	g15290	i0	60.7	0.99604743083004	84	33	99.6	0	252	1	166	249	MBE0540231.1 phosphodiester glycosidase family protein [Verrucomicrobiota bacterium]	diamond	252	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30702469	30702469	PRJNA1146029_P_NODE_21454_length_242_cov_0.911243_g21173_i0	PRJNA1146029	21454	242	0.911243	2.20520806	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	95.1	1.17e-20	NR	HUJ11825.1	2499141	g21173	i0	63	1.84710743801653	73	27	90.5	0	23	241	40	112	HUJ11825.1 lipase maturation factor family protein [Verrucomicrobiia bacterium]	diamond	447	95.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31039231	31039231	PRJNA1146029_P_NODE_19055_length_246_cov_0.890173_g18774_i0	PRJNA1146029	19055	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	123	1.2499999999999999e-31	NR	MEO0452574.1	2026799	g18774	i0	76.9	9.53658536585366	78	18	95.1	0	236	3	136	213	MEO0452574.1 alkene reductase [Verrucomicrobiota bacterium]	diamond	2346	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31524437	31524437	PRJNA1146029_P_NODE_20016_length_244_cov_2.052632_g19735_i0	PRJNA1146029	20016	244	2.052632	5.00842208	Pedosphaera sp.	2024890	Bacteria	Bacteria	43.1	0.0271	NR	MSU41697.1	2024890	g19735	i0	43.2	0.540983606557377	44	24	52.9	1	208	80	344	387	MSU41697.1 Gfo/Idh/MocA family oxidoreductase [Pedosphaera sp.]	diamond	132	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
31872174	31872174	PRJNA1146029_P_NODE_12797_length_273_cov_1.340000_g12516_i0	PRJNA1146029	12797	273	1.34	3.6582	Rariglobus sp.	2706526	Bacteria	Bacteria	50.4	1.61e-5	NR	MET0263957.1	2706526	g12516	i0	68.6	0.769230769230769	35	11	38.5	0	110	6	1	35	MET0263957.1 BON domain-containing protein [Rariglobus sp.]	diamond	210	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Rariglobus	Rariglobus sp.
32030569	32030569	PRJNA1146029_P_NODE_8598_length_310_cov_2.118143_g8317_i0	PRJNA1146029	8598	310	2.118143	6.5662433	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	107	1.62e-25	NR	MDP4937962.1	2026801	g8317	i0	98	0.948387096774194	49	1	47.4	0	3	149	30	78	MDP4937962.1 DUF1552 domain-containing protein [Verrucomicrobiales bacterium]	diamond	294	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32188735	32188735	PRJNA1146029_P_NODE_12478_length_275_cov_1.361386_g12197_i0	PRJNA1146029	12478	275	1.361386	3.7438115	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	107	1.07e-25	NR	MCZ6672608.1	2026799	g12197	i0	57.6	0.927272727272727	85	36	92.7	0	262	8	2	86	MCZ6672608.1 SGNH/GDSL hydrolase family protein [Verrucomicrobiota bacterium]	diamond	255	107	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);;