metadata: contig_metadata: 26 rows where bioproject = "PRJNA399711", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJNA399711", tax_clade = "PVC group" 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
4908961	4908961	PRJNA399711_P_NODE_7484_length_213_cov_7.085227_g7418_i0	PRJNA399711	7484	213	7.085227	15.09153351	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	8.6e-11	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g7418	i0	95.918	22.2441314553991	49	2	23	0	144	192	1925587	1925635	Opitutus terrae PB90-1, complete genome	blastn	4738	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
25563042	25563042	PRJNA399711_S_NODE_31713_length_234_cov_3.543147_g31571_i0	PRJNA399711	31713	234	3.543147	8.29096398	Akkermansia muciniphila	239935	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1554474302\|gb\|CP025823.1\|	239935	g31571	i0	100	0.247863247863248	29	0	12	0	127	155	410818	410790	Akkermansia muciniphila strain EB-AMDK-7 chromosome, complete genome	blastn	58	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
26109082	26109082	PRJNA399711_S_NODE_71133_length_175_cov_3.181159_g70991_i0	PRJNA399711	71133	175	3.181159	5.56702825	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	195	2.31e-45	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g70991	i0	86.857	34.8342857142857	175	21	99	2	2	175	28443	28616	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	6096	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26244767	26244767	PRJNA399711_S_NODE_58150_length_188_cov_6.344371_g58008_i0	PRJNA399711	58150	188	6.344371	11.92741748	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	224	3.23e-54	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g58008	i0	99.2	153.531914893617	125	0	66	1	1	124	15369	15493	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	28864	224	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26379091	26379091	PRJNA399711_S_NODE_23479_length_260_cov_8.349776_g23337_i0	PRJNA399711	23479	260	8.349776	21.7094176	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	60.2	1.42e-4	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g23337	i0	91.111	0.173076923076923	45	3	17	1	103	146	2219902	2219858	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	45	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482
27391650	27391650	PRJNA399711_P_NODE_21663_length_155_cov_7.381356_g21597_i0	PRJNA399711	21663	155	7.381356	11.4411018	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	58.5	2.4e-9	NR	HMF46722.1	2665650	g21597	i0	50	1.47096774193548	76	5	83.2	1	129	1	1	76	HMF46722.1 thioredoxin [Candidatus Udaeobacter sp.]	diamond	228	58.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
28275441	28275441	PRJNA399711_P_NODE_6206_length_226_cov_3.449735_g6140_i0	PRJNA399711	6206	226	3.449735	7.7964011	Opitutaceae bacterium	2006848	Bacteria	Bacteria	57.4	2.07e-7	NR	HRJ48582.1	2006848	g6140	i0	56.8	0.584070796460177	44	19	58.4	0	132	1	123	166	HRJ48582.1 hypothetical protein [Opitutaceae bacterium]	diamond	132	57.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32825069	32825069	PRJNA399711_P_NODE_7360_length_214_cov_9.079096_g7294_i0	PRJNA399711	7360	214	9.079096	19.429265440000002	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	134	2.48e-37	NR	MDE0835402.1	2562705	g7294	i0	92.6	1.90654205607477	68	5	95.3	0	209	6	60	127	MDE0835402.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	408	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32924006	32924006	PRJNA399711_S_NODE_12897_length_319_cov_2.631206_g12755_i0	PRJNA399711	12897	319	2.631206	8.39354714	Bacteria	2	Bacteria	Bacteria	47	0.00262	NR	HWL16345.1	1913982	g12755	i0	33	3.87460815047022	103	59	93.1	3	3	299	214	310	HWL16345.1 collagen-binding domain-containing protein [Opitutus sp.]	diamond	1236	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
32934758	32934758	PRJNA399711_S_NODE_37689_length_220_cov_5.245902_g37547_i0	PRJNA399711	37689	220	5.245902	11.5409844	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	43.1	0.0202	NR	MDB4470400.1	2562705	g37547	i0	33.3	0.818181818181818	60	34	79.1	2	30	203	293	348	MDB4470400.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	180	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32951973	32951973	PRJNA399711_S_NODE_35418_length_225_cov_3.202128_g35276_i0	PRJNA399711	35418	225	3.202128	7.204788	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.4	3.5e-24	NR	MEY4484647.1	2026799	g35276	i0	71.9	0.853333333333333	64	18	85.3	0	3	194	114	177	MEY4484647.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	192	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32969015	32969015	PRJNA399711_S_NODE_15730_length_299_cov_4.034351_g15588_i0	PRJNA399711	15730	299	4.034351	12.06270949	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	105	4.78e-24	NR	HEY5914955.1	2499141	g15588	i0	47.4	0.973244147157191	97	50	97.3	1	3	293	55	150	HEY5914955.1 PA14 domain-containing protein [Verrucomicrobiia bacterium]	diamond	291	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32969302	32969302	PRJNA399711_S_NODE_56250_length_191_cov_1.474026_g56108_i0	PRJNA399711	56250	191	1.474026	2.81538966	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	43.5	0.00967	NR	HMJ06857.1	2201154	g56108	i0	39.6	0.832460732984293	53	32	83.2	0	26	184	1	53	HMJ06857.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	159	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32969435	32969435	PRJNA399711_S_NODE_80842_length_167_cov_4.430769_g80700_i0	PRJNA399711	80842	167	4.430769	7.39938423	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.4	8.15e-23	NR	MEI8037279.1	2026799	g80700	i0	83.6	2.96407185628743	55	9	98.8	0	2	166	59	113	MEI8037279.1 glucose-1-phosphate thymidylyltransferase RfbA [Verrucomicrobiota bacterium]	diamond	495	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32975630	32975630	PRJNA399711_S_NODE_80610_length_167_cov_6.792308_g80468_i0	PRJNA399711	80610	167	6.792308	11.34315436	Bacteria	2	Bacteria	Bacteria	97.8	5.33e-22	NR	PYJ12048.1	2026799	g80468	i0	92.7	6.91616766467066	55	4	98.8	0	165	1	109	163	PYJ12048.1 MAG: hypothetical protein DME93_08595 [Verrucomicrobiota bacterium]	diamond	1155	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32986296	32986296	PRJNA399711_S_NODE_55555_length_191_cov_11.058442_g55413_i0	PRJNA399711	55555	191	11.058442	21.12162422	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.3	0.00544	NR	MBP8258533.1	2026799	g55413	i0	41.2	0.801047120418848	51	27	80.1	1	5	157	946	993	MBP8258533.1 type 2 lantipeptide synthetase LanM family protein [Verrucomicrobiota bacterium]	diamond	153	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
33019951	33019951	PRJNA399711_S_NODE_109764_length_150_cov_1.743363_g109622_i0	PRJNA399711	109764	150	1.743363	2.6150445	Luteolibacter yonseiensis	1144680	Bacteria	Bacteria	88.6	6.59e-19	NR	WP_200350545.1	1144680	g109622	i0	78.7	1.88	47	10	94	0	10	150	35	81	WP_200350545.1 cryptochrome/photolyase family protein [Luteolibacter yonseiensis]	diamond	282	88.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter yonseiensis
33037543	33037543	PRJNA399711_S_NODE_86396_length_163_cov_4.095238_g86254_i0	PRJNA399711	86396	163	4.095238	6.67523794	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67.8	1.74e-11	NR	NOS72616.1	2026799	g86254	i0	60	0.920245398773006	50	20	92	0	158	9	320	369	NOS72616.1 outer membrane beta-barrel protein [Verrucomicrobiota bacterium]	diamond	150	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
33088254	33088254	PRJNA399711_S_NODE_17406_length_289_cov_4.353175_g17264_i0	PRJNA399711	17406	289	4.353175	12.58067575	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	69.7	2.15e-11	NR	HEY6226941.1	2499141	g17264	i0	65	2.95847750865052	60	20	62.3	1	288	109	446	504	HEY6226941.1 CARDB domain-containing protein [Verrucomicrobiia bacterium]	diamond	855	69.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
33088753	33088753	PRJNA399711_S_NODE_85790_length_164_cov_1.346457_g85648_i0	PRJNA399711	85790	164	1.346457	2.20818948	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	90.5	5.65e-20	NR	HEY5953652.1	2832348	g85648	i0	94.2	5.70731707317073	52	3	95.1	0	5	160	179	230	HEY5953652.1 efflux RND transporter permease subunit [Terrimicrobiaceae bacterium]	diamond	936	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
33122539	33122539	PRJNA399711_S_NODE_40159_length_215_cov_10.241573_g40017_i0	PRJNA399711	40159	215	10.241573	22.01938195	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	94.4	9.8e-21	NR	HEX3798091.1	2499141	g40017	i0	72.9	4.91162790697674	70	19	97.7	0	1	210	195	264	HEX3798091.1 multidrug effflux MFS transporter [Verrucomicrobiia bacterium]	diamond	1056	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
33139635	33139635	PRJNA399711_S_NODE_46047_length_205_cov_3.452381_g45905_i0	PRJNA399711	46047	205	3.452381	7.07738105	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.00477	NR	MEW6156768.1	2026799	g45905	i0	42.2	0.658536585365854	45	26	65.9	0	137	3	4	48	MEW6156768.1 dATP/dGTP pyrophosphohydrolase domain-containing protein [Verrucomicrobiota bacterium]	diamond	135	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
33139721	33139721	PRJNA399711_S_NODE_58199_length_188_cov_5.509934_g58057_i0	PRJNA399711	58199	188	5.509934	10.35867592	Luteolibacter sp.	1962973	Bacteria	Bacteria	59.3	2.5e-8	NR	MFT4175806.1	1962973	g58057	i0	89.3	2.26595744680851	28	3	44.7	0	188	105	394	421	MFT4175806.1 adenylosuccinate synthase [Luteolibacter sp.]	diamond	426	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
33139891	33139891	PRJNA399711_S_NODE_89695_length_161_cov_2.596774_g89553_i0	PRJNA399711	89695	161	2.596774	4.18080614	Chthoniobacter sp.	2510640	Bacteria	Bacteria	77.8	5.32e-15	NR	WP_348545423.1	2510640	g89553	i0	68	2.83229813664596	50	16	93.2	0	3	152	119	168	WP_348545423.1 hypothetical protein [Chthoniobacter sp.]	diamond	456	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
33162992	33162992	PRJNA399711_S_NODE_30816_length_236_cov_11.592965_g30674_i0	PRJNA399711	30816	236	11.592965	27.3593974	Bacteria	2	Bacteria	Bacteria	46.6	0.00153	NR	NNM30568.1	2562705	g30674	i0	54.7	4.39830508474576	53	20	66.1	2	157	2	1309	1358	NNM30568.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	1038	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
33174119	33174119	PRJNA399711_S_NODE_84072_length_165_cov_2.203125_g83930_i0	PRJNA399711	84072	165	2.203125	3.63515625	Verrucomicrobia bacterium TMED4	1986790	Bacteria	Bacteria	41.2	0.0445	NR	OUU12443.1	1986790	g83930	i0	47.5	0.727272727272727	40	19	72.7	1	163	44	132	169	OUU12443.1 MAG: fructosamine kinase family protein [Verrucomicrobia bacterium TMED40]	diamond	120	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium TMED40

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