metadata: contig_metadata: 30 rows where bioproject = "PRJNA1126198", tax_clade = "PVC group" and tax

30 rows where bioproject = "PRJNA1126198", 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
7408172	7408172	PRJNA1126198_P_NODE_265886_length_274_cov_1.348259_g265165_i0	PRJNA1126198	265886	274	1.348259	3.69422966	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	97.1	1.97e-22	NR	MDD5199665.1	2832348	g265165	i0	68.6	0.941605839416058	86	21	92	2	23	274	3	84	MDD5199665.1 type II secretion system protein [Terrimicrobiaceae bacterium]	diamond	258	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
15057895	15057895	PRJNA1126198_P_NODE_199752_length_293_cov_0.909091_g199032_i0	PRJNA1126198	199752	293	0.909091	2.66363663	PVC group	1783257	Bacteria	Bacteria	128	4.3899999999999995e-25	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g199032	i0	81.699	20.4505119453925	153	28	52	0	3	155	3317499	3317651	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	5992	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15583947	15583947	PRJNA1126198_P_NODE_116613_length_331_cov_1.790698_g115894_i0	PRJNA1126198	116613	331	1.790698	5.92721038	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	298	3.63e-76	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g115894	i0	83.234	143.546827794562	334	46	100	8	1	331	276759	276433	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	47514	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
15584684	15584684	PRJNA1126198_P_NODE_470993_length_242_cov_0.917160_g470272_i0	PRJNA1126198	470993	242	0.91716	2.2195272	Pseudomonadati	3379134	Bacteria	Bacteria	152	3.05e-44	NR	HTA48576.1	2499141	g470272	i0	86.3	11.8884297520661	80	11	99.2	0	2	241	2	81	HTA48576.1 radical SAM protein [Verrucomicrobiia bacterium]	diamond	2877	153	0.993464052287582	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
18132761	18132761	PRJNA1126198_P_NODE_100675_length_342_cov_1.457249_g99956_i0	PRJNA1126198	100675	342	1.457249	4.98379158	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	246	1.38e-60	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g99956	i0	93.373	78.7251461988304	166	11	49	0	177	342	3261422	3261587	Luteolibacter sp. Populi chromosome, complete genome	blastn	26924	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
18133254	18133254	PRJNA1126198_P_NODE_373735_length_251_cov_1.629213_g373014_i0	PRJNA1126198	373735	251	1.629213	4.08932463	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	65.8	2.92e-6	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g373014	i0	97.368	3.70517928286853	38	1	15	0	171	208	3512617	3512580	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	930	65.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
19407403	19407403	PRJNA1126198_P_NODE_368336_length_252_cov_0.871508_g367615_i0	PRJNA1126198	368336	252	0.871508	2.19620016	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	226	1.2699999999999999e-54	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g367615	i0	86.473	11.6428571428571	207	26	82	2	7	212	318241	318446	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2934	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
21958340	21958340	PRJNA1126198_P_NODE_376838_length_251_cov_0.876404_g376117_i0	PRJNA1126198	376838	251	0.876404	2.19977404	Bacteria	2	Bacteria	Bacteria	168	1.1799999999999999e-48	NR	MBI3849520.1	2026799	g376117	i0	88	46.5179282868526	83	10	99.2	0	1	249	95	177	MBI3849520.1 KamA family radical SAM protein [Verrucomicrobiota bacterium]	diamond	11676	169	0.994082840236686	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21958415	21958415	PRJNA1126198_P_NODE_406358_length_248_cov_0.891429_g405637_i0	PRJNA1126198	406358	248	0.891429	2.21074392	Congregicoccus parvus	3081749	Bacteria	Bacteria	73.1	1.72e-8	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g405637	i0	95.556	0.181451612903226	45	2	18	0	1	45	489189	489233	Opitutales bacterium ASA1 DNA, complete genome	blastn	45	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
26627064	26627064	PRJNA1126198_P_NODE_157861_length_309_cov_1.970339_g157142_i0	PRJNA1126198	157861	309	1.970339	6.08834751	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	61.6	1.93e-8	NR	MEI6077090.1	2026799	g157142	i0	42.1	0.737864077669903	76	27	72.8	2	1	225	633	692	MEI6077090.1 NADAR family protein [Verrucomicrobiota bacterium]	diamond	228	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27164932	27164932	PRJNA1126198_P_NODE_257022_length_276_cov_1.527094_g256301_i0	PRJNA1126198	257022	276	1.527094	4.21477944	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	127	9.85e-32	NR	MES2468680.1	2026799	g256301	i0	67.4	2.98913043478261	92	29	100	1	276	1	522	612	MES2468680.1 outer membrane protein assembly factor BamA [Verrucomicrobiota bacterium]	diamond	825	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27164948	27164948	PRJNA1126198_P_NODE_473202_length_241_cov_2.684524_g472481_i0	PRJNA1126198	473202	241	2.684524	6.46970284	Opitutaceae bacterium	2006848	Bacteria	Bacteria	71.2	3.37e-12	NR	HEU5077952.1	2006848	g472481	i0	51.4	0.921161825726141	74	36	92.1	0	226	5	865	938	HEU5077952.1 HEAT repeat domain-containing protein [Opitutaceae bacterium]	diamond	222	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27249019	27249019	PRJNA1126198_P_NODE_142203_length_317_cov_1.270492_g141484_i0	PRJNA1126198	142203	317	1.270492	4.02745964	PVC group	1783257	Bacteria	Bacteria	134	2.01e-34	NR	MAE30140.1	2026801	g141484	i0	63.4	12.4542586750789	101	37	95.6	0	310	8	288	388	MAE30140.1 aspartate aminotransferase family protein [Verrucomicrobiales bacterium]	diamond	3948	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27291608	27291608	PRJNA1126198_P_NODE_481403_length_235_cov_2.185185_g480682_i0	PRJNA1126198	481403	235	2.185185	5.13518475	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	52.8	1.03e-5	NR	MBK9138994.1	2026799	g480682	i0	50	0.638297872340426	50	23	63.8	1	216	67	1265	1312	MBK9138994.1 S8 family serine peptidase [Verrucomicrobiota bacterium]	diamond	150	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27407292	27407292	PRJNA1126198_P_NODE_14743_length_532_cov_2.416122_g14059_i0	PRJNA1126198	14743	532	2.416122	12.85376904	Verrucomicrobiota	74201	Bacteria	Bacteria	74.3	8.4e-12	NR	HZE56784.1	2201154	g14059	i0	34.9	3.82330827067669	172	103	95.9	4	6	515	3357	3521	HZE56784.1 Calx-beta domain-containing protein [Chthoniobacterales bacterium]	diamond	2034	74.7	0.994645247657296	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
27891392	27891392	PRJNA1126198_P_NODE_282345_length_270_cov_1.223350_g281624_i0	PRJNA1126198	282345	270	1.22335	3.303045	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	154	3.63e-44	NR	MEK7685321.1	2026799	g281624	i0	78.7	3.95555555555556	89	19	98.9	0	268	2	179	267	MEK7685321.1 sugar phosphate isomerase/epimerase family protein [Verrucomicrobiota bacterium]	diamond	1068	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28049400	28049400	PRJNA1126198_P_NODE_393065_length_249_cov_1.551136_g392344_i0	PRJNA1126198	393065	249	1.551136	3.86232864	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	136	1.23e-35	NR	HEY5954410.1	2832348	g392344	i0	92.9	1.83132530120482	70	5	84.3	0	247	38	39	108	HEY5954410.1 hypothetical protein [Terrimicrobiaceae bacterium]	diamond	456	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
28112462	28112462	PRJNA1126198_P_NODE_463865_length_242_cov_1.834320_g463144_i0	PRJNA1126198	463865	242	1.83432	4.4390544	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	110	3.9300000000000005e-27	NR	PYJ04199.1	2026799	g463144	i0	75.4	3.78099173553719	61	15	75.6	0	2	184	240	300	PYJ04199.1 MAG: hypothetical protein DME25_10360 [Verrucomicrobiota bacterium]	diamond	915	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28586370	28586370	PRJNA1126198_P_NODE_300287_length_265_cov_2.864583_g299566_i0	PRJNA1126198	300287	265	2.864583	7.59114495	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0465	NR	MEI6605964.1	2026799	g299566	i0	46.2	0.588679245283019	52	21	50.9	2	82	216	28	79	MEI6605964.1 RHS repeat-associated core domain-containing protein [Verrucomicrobiota bacterium]	diamond	156	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28606820	28606820	PRJNA1126198_P_NODE_279947_length_270_cov_2.192893_g279226_i0	PRJNA1126198	279947	270	2.192893	5.9208111	Bacteria	2	Bacteria	Bacteria	58.5	2.75e-8	NR	MFA6288556.1	2006848	g279226	i0	50	1.9	54	27	60	0	108	269	6	59	MFA6288556.1 hypothetical protein [Opitutaceae bacterium]	diamond	513	58.9	0.99320882852292	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28681068	28681068	PRJNA1126198_P_NODE_428827_length_246_cov_0.895954_g428106_i0	PRJNA1126198	428827	246	0.895954	2.20404684	Terrimicrobium sp.	1965319	Bacteria	Bacteria	93.6	4.89e-20	NR	HEY5769230.1	1965319	g428106	i0	95.7	1.1219512195122	46	2	56.1	0	139	2	1	46	HEY5769230.1 phosphate acetyltransferase [Terrimicrobium sp.]	diamond	276	93.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sp.
30038674	30038674	PRJNA1126198_P_NODE_367911_length_252_cov_0.871508_g367190_i0	PRJNA1126198	367911	252	0.871508	2.19620016	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	76.3	9.47e-15	NR	HWY78480.1	2499141	g367190	i0	75.6	0.535714285714286	45	11	53.6	0	137	3	1	45	HWY78480.1 ankyrin repeat domain-containing protein [Verrucomicrobiia bacterium]	diamond	135	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30323598	30323598	PRJNA1126198_P_NODE_405572_length_248_cov_0.891429_g404851_i0	PRJNA1126198	405572	248	0.891429	2.21074392	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	110	5.810000000000001e-26	NR	HWD93566.1	2499141	g404851	i0	71.4	2.92741935483871	77	21	91.9	1	21	248	591	667	HWD93566.1 DUF3656 domain-containing protein [Verrucomicrobiia bacterium]	diamond	726	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30418196	30418196	PRJNA1126198_P_NODE_376753_length_251_cov_0.876404_g376032_i0	PRJNA1126198	376753	251	0.876404	2.19977404	Prosthecobacter sp.	1965333	Bacteria	Bacteria	104	1.88e-25	NR	WP_294226070.1	1965333	g376032	i0	69	6.96812749003984	84	19	99.2	2	1	249	97	174	WP_294226070.1 two-component system response regulator CreB [Prosthecobacter sp.]	diamond	1749	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30533282	30533282	PRJNA1126198_P_NODE_231693_length_283_cov_1.457143_g230972_i0	PRJNA1126198	231693	283	1.457143	4.12371469	Pseudomonadati	3379134	Bacteria	Bacteria	140	5.05e-38	NR	MBS0651906.1	2026799	g230972	i0	73.4	6.97526501766784	94	24	99.6	1	282	1	146	238	MBS0651906.1 Fic family protein [Verrucomicrobiota bacterium]	diamond	1974	141	0.99290780141844	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30796894	30796894	PRJNA1126198_P_NODE_329454_length_259_cov_1.618280_g328733_i0	PRJNA1126198	329454	259	1.61828	4.1913452	Nibricoccus sp.	2576892	Bacteria	Bacteria	65.9	2.78e-11	NR	MFT3780451.1	2576892	g328733	i0	46.4	0.972972972972973	84	41	97.3	1	8	259	29	108	MFT3780451.1 PEGA domain-containing protein [Nibricoccus sp.]	diamond	252	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp.
31050056	31050056	PRJNA1126198_P_NODE_398635_length_249_cov_0.880682_g397914_i0	PRJNA1126198	398635	249	0.880682	2.19289818	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	174	3.62e-51	NR	MES2598984.1	2026799	g397914	i0	92.8	2	83	6	100	0	249	1	200	282	MES2598984.1 SGNH/GDSL hydrolase family protein [Verrucomicrobiota bacterium]	diamond	498	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31164943	31164943	PRJNA1126198_P_NODE_467995_length_242_cov_0.923077_g467274_i0	PRJNA1126198	467995	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	125	1.23e-31	NR	MCX6980731.1	2026799	g467274	i0	73.8	2.08264462809917	84	18	99.2	1	241	2	344	427	MCX6980731.1 DUF1080 domain-containing protein [Verrucomicrobiota bacterium]	diamond	504	126	0.992063492063492	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31302595	31302595	PRJNA1126198_P_NODE_459095_length_243_cov_0.911765_g458374_i0	PRJNA1126198	459095	243	0.911765	2.21558895	Opitutaceae bacterium	2006848	Bacteria	Bacteria	66.2	1.95e-10	NR	HXB01787.1	2006848	g458374	i0	58.1	1.81481481481481	74	26	91.4	3	233	12	520	588	HXB01787.1 autotransporter-associated beta strand repeat-containing protein [Opitutaceae bacterium]	diamond	441	66.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31840145	31840145	PRJNA1126198_P_NODE_368637_length_252_cov_0.871508_g367916_i0	PRJNA1126198	368637	252	0.871508	2.19620016	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	51.2	3.98e-5	NR	MEC7609478.1	2026799	g367916	i0	47.7	1.66666666666667	65	34	77.4	0	9	203	140	204	MEC7609478.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	420	51.2	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);;