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

26 rows where bioproject = "PRJNA896973", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
5976368	5976368	PRJNA896973_P_NODE_16385_length_282_cov_1.153110_g16291_i0	PRJNA896973	16385	282	1.15311	3.2517702	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	250	8.589999999999999e-62	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g16291	i0	86.207	5.42198581560284	232	31	82	1	47	277	7209785	7210016	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1529	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5976434	5976434	PRJNA896973_P_NODE_19065_length_265_cov_1.364583_g18971_i0	PRJNA896973	19065	265	1.364583	3.61614495	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	392	1.2599999999999997e-104	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g18971	i0	94.163	0.969811320754717	257	15	97	0	1	257	8850245	8850501	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	257	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
8526093	8526093	PRJNA896973_P_NODE_27447_length_242_cov_0.911243_g27353_i0	PRJNA896973	27447	242	0.911243	2.20520806	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	348	2.48e-91	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g27353	i0	92.562	4.3595041322314	242	18	100	0	1	242	7491478	7491237	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1055	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12352403	12352403	PRJNA896973_S_NODE_1010_length_368_cov_1.532203_g996_i0	PRJNA896973	1010	368	1.532203	5.63850704	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	496	1.34e-135	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g996	i0	91.484	88.9673913043478	364	25	98	6	10	368	2003086	2002724	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	32740	496	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12352425	12352425	PRJNA896973_S_NODE_470_length_545_cov_4.811441_g456_i0	PRJNA896973	470	545	4.811441	26.22235345	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	104	1.46e-17	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g456	i0	88.506	13.7064220183486	87	8	16	2	24	110	3249720	3249636	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	7470	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13626921	13626921	PRJNA896973_P_NODE_20471_length_257_cov_1.423913_g20377_i0	PRJNA896973	20471	257	1.423913	3.65945641	Gemmata massiliana	1210884	Bacteria	Bacteria	224	4.6799999999999996e-54	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g20377	i0	82.677	1.97665369649805	254	42	98	2	5	257	8062656	8062404	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	508	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
14901163	14901163	PRJNA896973_P_NODE_22612_length_250_cov_0.870056_g22518_i0	PRJNA896973	22612	250	0.870056	2.17514	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	333	7.219999999999999e-87	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g22518	i0	91.667	0.96	240	20	96	0	10	249	598780	598541	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	240	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
14901200	14901200	PRJNA896973_P_NODE_23972_length_247_cov_1.609195_g23878_i0	PRJNA896973	23972	247	1.609195	3.97471165	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	75	4.76e-9	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g23878	i0	97.674	9.22267206477733	43	1	46	0	205	247	7903046	7903088	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	2278	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
16175941	16175941	PRJNA896973_P_NODE_23113_length_249_cov_0.875000_g23019_i0	PRJNA896973	23113	249	0.875	2.17875	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	154	6.01e-33	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g23019	i0	91.228	1.02008032128514	114	8	45	2	1	113	4547645	4547757	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	254	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
18724654	18724654	PRJNA896973_P_NODE_22955_length_249_cov_0.875000_g22861_i0	PRJNA896973	22955	249	0.875	2.17875	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	150	7.77e-32	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g22861	i0	89.744	4.40963855421687	117	12	63	0	133	249	2412248	2412132	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1098	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18724664	18724664	PRJNA896973_P_NODE_23355_length_248_cov_1.760000_g23261_i0	PRJNA896973	23355	248	1.76	4.3648	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g23261	i0	87.097	1.85483870967742	248	32	100	0	1	248	3481997	3481750	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	460	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
19999781	19999781	PRJNA896973_P_NODE_22376_length_250_cov_0.870056_g22282_i0	PRJNA896973	22376	250	0.870056	2.17514	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	374	4.2499999999999986e-99	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g22282	i0	93.6	1	250	16	100	0	1	250	115965	115716	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	250	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
19999909	19999909	PRJNA896973_P_NODE_27956_length_241_cov_0.916667_g27862_i0	PRJNA896973	27956	241	0.916667	2.20916747	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	154	5.78e-33	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g27862	i0	91.818	0.45643153526971	110	9	46	0	132	241	8014088	8013979	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	110	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
22550136	22550136	PRJNA896973_P_NODE_26218_length_244_cov_0.900585_g26124_i0	PRJNA896973	26218	244	0.900585	2.1974274	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g26124	i0	93.617	4.66803278688525	235	15	96	0	10	244	3104113	3103879	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1139	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
22550270	22550270	PRJNA896973_P_NODE_7998_length_379_cov_1.006536_g7904_i0	PRJNA896973	7998	379	1.006536	3.81477144	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	575	1.7299999999999994e-159	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g7904	i0	94.164	8.9155672823219	377	22	99	0	1	377	7780677	7781053	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	3379	575	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
22550324	22550324	PRJNA896973_S_NODE_38_length_1693_cov_5.185185_g36_i0	PRJNA896973	38	1693	5.185185	87.78518205	Gemmataceae bacterium	2052164	Bacteria	Bacteria	342	1.46e-111	NR	HEY7331155.1	2052164	g36	i0	74	1.97578263437685	223	58	39.5	0	576	1244	1	223	HEY7331155.1 heavy metal response regulator transcription factor [Gemmataceae bacterium]	diamond	3345	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23825359	23825359	PRJNA896973_P_NODE_22999_length_249_cov_0.875000_g22905_i0	PRJNA896973	22999	249	0.875	2.17875	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	327	3.34e-85	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g22905	i0	90.361	151.722891566265	249	24	100	0	1	249	8209734	8209486	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	37779	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23825393	23825393	PRJNA896973_P_NODE_24439_length_247_cov_0.885057_g24345_i0	PRJNA896973	24439	247	0.885057	2.18609079	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	344	3.29e-90	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g24345	i0	91.87	3.31983805668016	246	20	99	0	1	246	4402176	4401931	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	820	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23825428	23825428	PRJNA896973_P_NODE_25719_length_245_cov_0.872093_g25625_i0	PRJNA896973	25719	245	0.872093	2.13662785	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	348	2.5200000000000005e-91	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g25625	i0	92.245	4	245	19	100	0	1	245	9422115	9421871	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	980	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
26960626	26960626	PRJNA896973_P_NODE_24542_length_246_cov_1.780347_g24448_i0	PRJNA896973	24542	246	1.780347	4.37965362	Planctomycetota bacterium	2026780	Bacteria	Bacteria	160	9.83e-45	NR	MBS0264672.1	2026780	g24448	i0	95.1	2.96341463414634	81	4	98.8	0	2	244	165	245	MBS0264672.1 DUF1501 domain-containing protein [Planctomycetota bacterium]	diamond	729	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29297861	29297861	PRJNA896973_P_NODE_28209_length_241_cov_0.916667_g28115_i0	PRJNA896973	28209	241	0.916667	2.20916747	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	42.4	0.0456	NR	NLW51132.1	2094028	g28115	i0	33.3	0.746887966804979	60	36	74.7	2	4	183	187	242	NLW51132.1 cytochrome c biogenesis protein CcsA [Candidatus Brocadiaceae bacterium]	diamond	180	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
29739581	29739581	PRJNA896973_P_NODE_24930_length_246_cov_0.890173_g24836_i0	PRJNA896973	24930	246	0.890173	2.18982558	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	135	1.15e-35	NR	MDB5334976.1	2026779	g24836	i0	84.1	1	82	13	100	0	1	246	35	116	MDB5334976.1 transposase family protein [Planctomycetaceae bacterium]	diamond	246	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30972113	30972113	PRJNA896973_P_NODE_25594_length_245_cov_0.895349_g25500_i0	PRJNA896973	25594	245	0.895349	2.19360505	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	117	6.27e-30	NR	WP_171475323.1	2774151	g25500	i0	84.7	0.881632653061225	72	11	88.2	0	2	217	192	263	WP_171475323.1 FG-GAP repeat domain-containing protein [Frigoriglobus tundricola]	diamond	216	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
31793879	31793879	PRJNA896973_P_NODE_22877_length_249_cov_0.875000_g22783_i0	PRJNA896973	22877	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	164	2e-45	NR	MBN9121418.1	2026780	g22783	i0	93.9	3.95180722891566	82	5	98.8	0	2	247	529	610	MBN9121418.1 DUF1549 domain-containing protein [Planctomycetota bacterium]	diamond	984	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31825568	31825568	PRJNA896973_P_NODE_27717_length_241_cov_1.821429_g27623_i0	PRJNA896973	27717	241	1.821429	4.38964389	Gemmataceae bacterium	2052164	Bacteria	Bacteria	94.4	1.84e-20	NR	MCC6417287.1	2052164	g27623	i0	70	0.995850622406639	80	24	99.6	0	1	240	120	199	MCC6417287.1 efflux RND transporter periplasmic adaptor subunit [Gemmataceae bacterium]	diamond	240	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32047258	32047258	PRJNA896973_P_NODE_24178_length_247_cov_0.885057_g24084_i0	PRJNA896973	24178	247	0.885057	2.18609079	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	103	2.13e-23	NR	WP_171469499.1	2774151	g24084	i0	63.4	0.995951417004049	82	29	99.6	1	246	1	328	408	WP_171469499.1 tetratricopeptide repeat protein [Frigoriglobus tundricola]	diamond	246	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola

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