metadata: contig_metadata: 34 rows where bioproject = "PRJNA459724" and tax

34 rows where bioproject = "PRJNA459724" and tax_clade = "PVC group"

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
2369355	2369355	PRJNA459724_P_NODE_5462_length_164_cov_3.044444_g5070_i0	PRJNA459724	5462	164	3.044444	4.99288816	Pirellulaceae	2691357	Bacteria	Bacteria	235	1.27e-57	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g5070	i0	93.21	90.7987804878049	162	7	98	4	4	163	6999548	6999707	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	14891	237	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
2993704	2993704	PRJNA459724_P_NODE_3223_length_260_cov_1.896104_g2831_i0	PRJNA459724	3223	260	1.896104	4.9298704	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	228	3.6699999999999994e-55	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g2831	i0	82.443	58.4884615384615	262	44	100	2	1	260	7629687	7629426	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	15207	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
5546721	5546721	PRJNA459724_P_NODE_1385_length_493_cov_2.254310_g1055_i0	PRJNA459724	1385	493	2.25431	11.1137483	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	256	2.09e-80	NR	MFI0436073.1	2052176	g1055	i0	84.1	0.955375253549696	157	25	95.5	0	491	21	328	484	MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium]	diamond	471	256	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
17020389	17020389	PRJNA459724_P_NODE_3054_length_272_cov_2.008230_g2663_i0	PRJNA459724	3054	272	2.00823	5.4623856	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	468	2.09e-127	NTclustered	gi\|576901465\|gb\|KF827058.1\|	120965	g2663	i0	97.794	101.319852941176	272	5	100	1	1	272	621	351	Uncultured planctomycete clone B-30-43 16S ribosomal RNA gene, partial sequence	blastn	27559	468	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
18945485	18945485	PRJNA459724_P_NODE_5895_length_151_cov_2.221311_g5503_i0	PRJNA459724	5895	151	2.221311	3.35417961	Chthoniobacter	295577	Bacteria	Bacteria	224	2.4699999999999993e-54	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g5503	i0	93.421	181.013245033113	152	8	100	2	1	151	15701	15551	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	27333	224	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26696192	26696192	PRJNA459724_P_NODE_301_length_1018_cov_4.123357_g179_i0	PRJNA459724	301	1018	4.123357	41.97577426	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	400	1.35e-137	NR	MFI0436135.1	2052176	g179	i0	97.5	0.595284872298625	202	2	59.5	1	1018	413	47	245	MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium]	diamond	606	400	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27012816	27012816	PRJNA459724_P_NODE_4402_length_198_cov_1.970414_g4010_i0	PRJNA459724	4402	198	1.970414	3.90141972	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	94.7	4.049999999999999e-23	NR	MCE5266732.1	2026779	g4010	i0	93.2	0.666666666666667	44	3	66.7	0	66	197	47	90	MCE5266732.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	132	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27234203	27234203	PRJNA459724_P_NODE_303_length_1016_cov_4.159068_g180_i0	PRJNA459724	303	1016	4.159068	42.25613088	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	399	5.299999999999998e-137	NR	MFI0436135.1	2052176	g180	i0	97.5	0.593503937007874	201	2	59.4	1	2	604	48	245	MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium]	diamond	603	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27455570	27455570	PRJNA459724_P_NODE_4763_length_186_cov_2.299363_g4371_i0	PRJNA459724	4763	186	2.299363	4.27681518	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.00432	NR	MBI3272279.1	2026780	g4371	i0	78.6	0.451612903225806	28	6	45.2	0	98	181	1	28	MBI3272279.1 hypothetical protein [Planctomycetota bacterium]	diamond	84	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27518561	27518561	PRJNA459724_P_NODE_223_length_1184_cov_3.614719_g121_i0	PRJNA459724	223	1184	3.614719	42.79827296	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	399	2.09e-136	NR	MFI0436135.1	2052176	g121	i0	97.5	0.511824324324324	202	2	51.2	1	1184	579	47	245	MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium]	diamond	606	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27598028	27598028	PRJNA459724_P_NODE_5084_length_176_cov_2.224490_g4692_i0	PRJNA459724	5084	176	2.22449	3.9151024	Pseudomonadati	3379134	Bacteria	Bacteria	67.8	2.21e-11	NR	NBX31864.1	2026780	g4692	i0	53.4	1.97727272727273	58	27	98.9	0	174	1	185	242	NBX31864.1 phage head-tail adapter protein [Planctomycetota bacterium]	diamond	348	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27613398	27613398	PRJNA459724_P_NODE_5944_length_150_cov_1.628099_g5552_i0	PRJNA459724	5944	150	1.628099	2.4421485	Verrucomicrobia bacterium ADurb.Bin122	1852929	Bacteria	Bacteria	91.7	4.85e-20	NR	OQB94327.1	1852929	g5552	i0	82	1	50	9	100	0	1	150	351	400	OQB94327.1 MAG: Replicative DNA helicase [Verrucomicrobia bacterium ADurb.Bin122]	diamond	150	91.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium ADurb.Bin122
27834169	27834169	PRJNA459724_P_NODE_3744_length_229_cov_1.760000_g3352_i0	PRJNA459724	3744	229	1.76	4.0304	Victivallis sp. Marseille-Q1	2049020	Bacteria	Bacteria	76.3	4.25e-14	NR	WP_217704981.1	2717288	g3352	i0	58.1	0.96943231441048	74	31	96.9	0	224	3	211	284	WP_217704981.1 hypothetical protein, partial [Victivallis sp. Marseille-Q1083]	diamond	222	76.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis sp. Marseille-Q1083
27960528	27960528	PRJNA459724_P_NODE_3105_length_268_cov_2.882845_g2714_i0	PRJNA459724	3105	268	2.882845	7.7260246	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	140	4.15e-37	NR	MFI0436073.1	2052176	g2714	i0	78.7	0.996268656716418	89	19	99.6	0	1	267	112	200	MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium]	diamond	267	140	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28529066	28529066	PRJNA459724_P_NODE_207_length_1211_cov_2.633672_g110_i0	PRJNA459724	207	1211	2.633672	31.89376792	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	527	1.1799999999999996e-180	NR	MFI0436039.1	2052176	g110	i0	64.4	0.995871180842279	402	140	99.3	2	2	1204	8	407	MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium]	diamond	1206	527	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28592137	28592137	PRJNA459724_S_NODE_2087_length_167_cov_1.189394_g2084_i0	PRJNA459724	2087	167	1.189394	1.98628798	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	104	1.73e-25	NR	MFV0339066.1	2052176	g2084	i0	92.7	0.988023952095808	55	4	98.8	0	1	165	26	80	MFV0339066.1 TIGR01777 family oxidoreductase [Parachlamydiaceae bacterium]	diamond	165	104	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29192062	29192062	PRJNA459724_P_NODE_2489_length_321_cov_2.404110_g2098_i0	PRJNA459724	2489	321	2.40411	7.7171931	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	43.9	0.0344	NR	HAM41114.1	2035772	g2098	i0	57.6	0.308411214953271	33	14	30.8	0	25	123	350	382	HAM41114.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	99	43.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29696726	29696726	PRJNA459724_P_NODE_2950_length_281_cov_1.853175_g2559_i0	PRJNA459724	2950	281	1.853175	5.20742175	Gemmataceae bacterium	2052164	Bacteria	Bacteria	44.3	0.0163	NR	HKB36233.1	2052164	g2559	i0	50.6	0.864768683274021	81	32	86.5	4	36	278	251	323	HKB36233.1 tail fiber domain-containing protein [Gemmataceae bacterium]	diamond	243	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29728443	29728443	PRJNA459724_P_NODE_4430_length_197_cov_1.940476_g4038_i0	PRJNA459724	4430	197	1.940476	3.82273772	Pirellulales bacterium	2715253	Bacteria	Bacteria	43.1	0.0142	NR	MEX2167767.1	2715253	g4038	i0	35.4	2.01015228426396	65	39	95.9	2	196	8	122	185	MEX2167767.1 PHB depolymerase family esterase [Pirellulales bacterium]	diamond	396	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29760110	29760110	PRJNA459724_P_NODE_3451_length_244_cov_2.353488_g3059_i0	PRJNA459724	3451	244	2.353488	5.74251072	Victivallis sp. Marseille-Q1	2049020	Bacteria	Bacteria	106	2.3e-27	NR	WP_176014508.1	2717288	g3059	i0	60.5	0.995901639344262	81	26	99.6	1	2	244	13	87	WP_176014508.1 hypothetical protein [Victivallis sp. Marseille-Q1083]	diamond	243	106	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis sp. Marseille-Q1083
30455653	30455653	PRJNA459724_P_NODE_3653_length_233_cov_2.338235_g3261_i0	PRJNA459724	3653	233	2.338235	5.44808755	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	68.9	3.48e-13	NR	MBL4698368.1	2052180	g3261	i0	91.9	0.476394849785408	37	3	47.6	0	112	2	21	57	MBL4698368.1 hypothetical protein [Phycisphaerales bacterium]	diamond	111	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30550004	30550004	PRJNA459724_S_NODE_773_length_213_cov_4.117978_g770_i0	PRJNA459724	773	213	4.117978	8.77129314	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	69.7	1.55e-12	NR	WP_077025744.1	1891926	g770	i0	78.6	4.63380281690141	42	9	59.2	0	15	140	161	202	WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici]	diamond	987	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
31181676	31181676	PRJNA459724_P_NODE_1555_length_458_cov_2.806527_g1208_i0	PRJNA459724	1555	458	2.806527	12.85389366	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	114	5.44e-28	NR	MFI0435901.1	2052176	g1208	i0	82.8	0.419213973799127	64	11	41.9	0	457	266	207	270	MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	192	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31324597	31324597	PRJNA459724_P_NODE_4815_length_184_cov_2.703226_g4423_i0	PRJNA459724	4815	184	2.703226	4.97393584	Pseudomonadati	3379134	Bacteria	Bacteria	42.7	0.0172	NR	OQB94327.1	1852929	g4423	i0	39.1	1.77717391304348	64	36	99.5	2	1	183	62	125	OQB94327.1 MAG: Replicative DNA helicase [Verrucomicrobia bacterium ADurb.Bin122]	diamond	327	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium ADurb.Bin122
31530059	31530059	PRJNA459724_P_NODE_3396_length_248_cov_2.538813_g3004_i0	PRJNA459724	3396	248	2.538813	6.29625624	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.4	6.94e-4	NR	MBL4698368.1	2052180	g3004	i0	100	0.254032258064516	21	0	25.4	0	64	2	21	41	MBL4698368.1 hypothetical protein [Phycisphaerales bacterium]	diamond	63	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31624726	31624726	PRJNA459724_P_NODE_5356_length_168_cov_1.748201_g4964_i0	PRJNA459724	5356	168	1.748201	2.93697768	Verrucomicrobia bacterium ADurb.Bin122	1852929	Bacteria	Bacteria	56.2	2.29e-7	NR	OQB94327.1	1852929	g4964	i0	86.7	0.535714285714286	30	4	53.6	0	167	78	424	453	OQB94327.1 MAG: Replicative DNA helicase [Verrucomicrobia bacterium ADurb.Bin122]	diamond	90	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium ADurb.Bin122
31798953	31798953	PRJNA459724_P_NODE_5517_length_163_cov_1.649254_g5125_i0	PRJNA459724	5517	163	1.649254	2.68828402	Pseudomonadati	3379134	Bacteria	Bacteria	83.2	2.16e-18	NR	MEI6128977.1	2026780	g5125	i0	71.2	1.93251533742331	52	15	95.7	0	158	3	93	144	MEI6128977.1 hypothetical protein [Planctomycetota bacterium]	diamond	315	84	0.990476190476191	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31877655	31877655	PRJNA459724_P_NODE_2877_length_287_cov_2.565891_g2486_i0	PRJNA459724	2877	287	2.565891	7.36410717	Limisphaerales bacterium	2052186	Bacteria	Bacteria	67.4	1.29e-10	NR	MCC6824111.1	2052186	g2486	i0	44.1	3.02090592334495	93	51	97.2	1	286	8	2	93	MCC6824111.1 hypothetical protein [Limisphaerales bacterium]	diamond	867	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
31972731	31972731	PRJNA459724_P_NODE_1798_length_413_cov_2.632812_g1426_i0	PRJNA459724	1798	413	2.632812	10.87351356	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	118	8.69e-28	NR	MFI0436039.1	2052176	g1426	i0	60	0.653753026634383	90	34	65.4	1	411	142	424	511	MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium]	diamond	270	118	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31972733	31972733	PRJNA459724_P_NODE_3418_length_246_cov_3.087558_g3026_i0	PRJNA459724	3418	246	3.087558	7.59539268	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	169	1.12e-50	NR	MFI0436136.1	2052176	g3026	i0	100	1.97560975609756	81	0	98.8	0	245	3	155	235	MFI0436136.1 phage portal protein [Parachlamydiaceae bacterium]	diamond	486	169	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32321123	32321123	PRJNA459724_P_NODE_3779_length_227_cov_1.707071_g3387_i0	PRJNA459724	3779	227	1.707071	3.87505117	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.8	1.29e-9	NR	MEY4402908.1	2026799	g3387	i0	57.9	2.12775330396476	57	23	74	1	189	22	1	57	MEY4402908.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	483	60.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32415851	32415851	PRJNA459724_P_NODE_1159_length_546_cov_2.682785_g859_i0	PRJNA459724	1159	546	2.682785	14.6480061	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	115	1.1e-27	NR	MFI0436074.1	2052176	g859	i0	53.5	0.697802197802198	127	52	67	4	421	56	149	273	MFI0436074.1 DUF6291 domain-containing protein [Parachlamydiaceae bacterium]	diamond	381	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32479204	32479204	PRJNA459724_P_NODE_2159_length_360_cov_1.676737_g1772_i0	PRJNA459724	2159	360	1.676737	6.0362532	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.1	2.48e-5	NR	MBM4071985.1	2026780	g1772	i0	40	0.458333333333333	55	33	45.8	0	193	357	18	72	MBM4071985.1 hypothetical protein [Planctomycetota bacterium]	diamond	165	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32794061	32794061	PRJNA459724_P_NODE_2900_length_285_cov_2.867188_g2509_i0	PRJNA459724	2900	285	2.867188	8.1714858	Planctomycetota bacterium	2026780	Bacteria	Bacteria	97.1	5.14e-21	NR	MFH1231028.1	2026780	g2509	i0	54.3	1.94736842105263	92	38	96.8	2	2	277	691	778	MFH1231028.1 hypothetical protein [Planctomycetota bacterium]	diamond	555	97.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;