metadata: contig_metadata: 25 rows where bioproject = "PRJNA352850" and tax

25 rows where bioproject = "PRJNA352850" 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
4222235	4222235	PRJNA352850_P_NODE_19964_length_650_cov_6.128120_g17203_i0	PRJNA352850	19964	650	6.12812	39.83278	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	337	3.659999999999999e-112	NR	MBC8002191.1	2026801	g17203	i0	75.2	7.86	214	51	98.8	1	2	643	220	431	MBC8002191.1 L-fuconate dehydratase [Verrucomicrobiales bacterium]	diamond	5109	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
5499347	5499347	PRJNA352850_P_NODE_44525_length_370_cov_1.990654_g41692_i0	PRJNA352850	44525	370	1.990654	7.3654198	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	667	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g41692	i0	99.189	116.721621621622	370	3	100	0	1	370	1251066	1250697	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	43187	667	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7449436	7449436	PRJNA352850_P_NODE_58986_length_304_cov_1.160784_g56153_i0	PRJNA352850	58986	304	1.160784	3.52878336	Frigoriglobus	2774146	Bacteria	Bacteria	484	2.36e-132	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g56153	i0	95.395	121.394736842105	304	14	100	0	1	304	2003450	2003753	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	36904	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11875184	11875184	PRJNA352850_P_NODE_71550_length_265_cov_1.995370_g68717_i0	PRJNA352850	71550	265	1.99537	5.2877305	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	165	2.98e-36	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g68717	i0	90.4	0.471698113207547	125	12	47	0	138	262	7136708	7136832	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	125	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14423631	14423631	PRJNA352850_P_NODE_16072_length_762_cov_3.093969_g13426_i0	PRJNA352850	16072	762	3.093969	23.57604378	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1362	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13426	i0	98.95	125.863517060367	762	7	100	1	1	762	1249854	1249094	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	95908	1362	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14424069	14424069	PRJNA352850_P_NODE_29752_length_491_cov_4.402715_g26924_i0	PRJNA352850	29752	491	4.402715	21.61733065	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	902	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g26924	i0	99.796	116.423625254582	491	1	100	0	1	491	1251125	1251615	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	57164	902	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
18922606	18922606	PRJNA352850_P_NODE_35015_length_438_cov_3.041131_g32184_i0	PRJNA352850	35015	438	3.041131	13.32015378	Planctomycetia	203683	Bacteria	Bacteria	549	1.2299999999999994e-151	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g32184	i0	90.046	102.735159817352	432	31	96	6	5	426	5936808	5936379	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	44998	549	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20796271	20796271	PRJNA352850_P_NODE_16017_length_764_cov_2.689510_g13373_i0	PRJNA352850	16017	764	2.68951	20.5478564	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1373	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g13373	i0	99.601	139.952879581152	752	3	98	0	13	764	1249889	1250640	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	106924	1373	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
22072815	22072815	PRJNA352850_P_NODE_62658_length_290_cov_4.290456_g59825_i0	PRJNA352850	62658	290	4.290456	12.4423224	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	433	8.21e-117	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g59825	i0	94.056	131.993103448276	286	16	98	1	3	287	2002489	2002774	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	38278	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24621797	24621797	PRJNA352850_P_NODE_41360_length_390_cov_2.826979_g38528_i0	PRJNA352850	41360	390	2.826979	11.0252181	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	470	8.679999999999999e-128	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g38528	i0	89.785	76.1512820512821	372	31	95	7	21	390	1831430	1831064	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	29699	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
24621994	24621994	PRJNA352850_P_NODE_47420_length_354_cov_2.573770_g44587_i0	PRJNA352850	47420	354	2.57377	9.1111458	Singulisphaera sp. Ch	1906241	Bacteria	Bacteria	129	8.159999999999999e-32	NR	WP_406700929.1	3120278	g44587	i0	78.5	1.57627118644068	93	20	78.8	0	350	72	897	989	WP_406700929.1 beta strand repeat-containing protein [Singulisphaera sp. Ch08]	diamond	558	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
27201048	27201048	PRJNA352850_P_NODE_78722_length_252_cov_1.004926_g75889_i0	PRJNA352850	78722	252	1.004926	2.53241352	Novipirellula caenicola	1536901	Bacteria	Bacteria	121	7.789999999999999e-31	NR	WP_345689132.1	1536901	g75889	i0	73.8	5	84	22	100	0	252	1	18	101	WP_345689132.1 2-amino-4-hydroxy-6-hydroxymethyldihydropteridine diphosphokinase [Novipirellula caenicola]	diamond	1260	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Novipirellula	Novipirellula caenicola
27990929	27990929	PRJNA352850_P_NODE_46825_length_357_cov_2.636364_g43992_i0	PRJNA352850	46825	357	2.636364	9.41181948	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	44.7	0.0142	NR	MCH1506043.1	2026801	g43992	i0	39	0.991596638655462	59	32	47.1	2	349	182	78	135	MCH1506043.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	354	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28053839	28053839	PRJNA352850_P_NODE_56465_length_313_cov_2.166667_g53632_i0	PRJNA352850	56465	313	2.166667	6.78166771	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	99	1.6e-21	NR	MEZ6130026.1	2026779	g53632	i0	65.2	0.853035143769968	89	31	85.3	0	296	30	2966	3054	MEZ6130026.1 YDG domain-containing protein [Planctomycetaceae bacterium]	diamond	267	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29018615	29018615	PRJNA352850_P_NODE_55908_length_315_cov_2.808271_g53075_i0	PRJNA352850	55908	315	2.808271	8.84605365	Tautonia	2680020	Bacteria	Bacteria	118	1.79e-28	NR	WP_152049823.1	2653855	g53075	i0	83.1	1.46666666666667	77	13	73.3	0	83	313	2	78	WP_152049823.1 AI-2E family transporter [Tautonia marina]	diamond	462	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia marina
29032970	29032970	PRJNA352850_P_NODE_60388_length_298_cov_2.911647_g57555_i0	PRJNA352850	60388	298	2.911647	8.67670806	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	84.3	2.26e-17	NR	HLJ10262.1	2026779	g57555	i0	46.4	0.845637583892617	84	45	84.6	0	252	1	141	224	HLJ10262.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	252	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29600790	29600790	PRJNA352850_P_NODE_67410_length_275_cov_3.951327_g64577_i0	PRJNA352850	67410	275	3.951327	10.86614925	Planctomycetes bacterium Pla133	2528011	Bacteria	Bacteria	145	1.11e-40	NR	QDU66550.1	2528011	g64577	i0	76.4	2.89090909090909	89	21	97.1	0	274	8	208	296	QDU66550.1 putative 3-hydroxybutyryl-CoA dehydrogenase [Planctomycetes bacterium Pla133]	diamond	795	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
29965673	29965673	PRJNA352850_P_NODE_12491_length_919_cov_4.281609_g10016_i0	PRJNA352850	12491	919	4.2816090000000004	39.34798671	Planctomycetaceae	126	Bacteria	Bacteria	212	8.910000000000001e-59	NR	WP_310821170.1	2527980	g10016	i0	46.5	1.67791077257889	254	128	81.9	4	2	754	280	528	WP_310821170.1 peroxidase family protein [Stratiformator vulcanicus]	diamond	1542	212	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
29980057	29980057	PRJNA352850_P_NODE_58971_length_304_cov_1.203922_g56138_i0	PRJNA352850	58971	304	1.203922	3.65992288	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	103	2.94e-23	NR	HNQ23619.1	2026778	g56138	i0	59	0.769736842105263	78	31	76	1	234	4	21	98	HNQ23619.1 aspartate aminotransferase family protein [Phycisphaerae bacterium]	diamond	234	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30738220	30738220	PRJNA352850_P_NODE_58514_length_305_cov_3.246094_g55681_i0	PRJNA352850	58514	305	3.246094	9.9005867	Chlamydiales bacterium	2047757	Bacteria	Bacteria	87.8	2.41e-18	NR	MBN9377724.1	2047757	g55681	i0	47	0.983606557377049	100	51	96.4	2	304	11	184	283	MBN9377724.1 hypothetical protein [Chlamydiales bacterium]	diamond	300	87.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31560403	31560403	PRJNA352850_P_NODE_81836_length_246_cov_2.111675_g79003_i0	PRJNA352850	81836	246	2.111675	5.1947205	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	51.6	2.81e-5	NR	HYE19843.1	2876886	g79003	i0	41.8	0.817073170731707	67	39	81.7	0	203	3	58	124	HYE19843.1 HlyD family efflux transporter periplasmic adaptor subunit [Tepidisphaeraceae bacterium]	diamond	201	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31592009	31592009	PRJNA352850_P_NODE_65536_length_281_cov_2.241379_g62703_i0	PRJNA352850	65536	281	2.241379	6.29827499	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.4	6.85e-10	NR	MDP9291775.1	2026799	g62703	i0	75	0.875444839857651	40	10	42.7	0	281	162	76	115	MDP9291775.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	246	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32256552	32256552	PRJNA352850_P_NODE_34678_length_441_cov_4.563776_g31847_i0	PRJNA352850	34678	441	4.563776	20.12625216	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	4.6e-5	NR	NRA95951.1	2026780	g31847	i0	39.5	0.551020408163265	81	47	55.1	2	11	253	203	281	NRA95951.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32494991	32494991	PRJNA352850_P_NODE_7099_length_1419_cov_6.465693_g5141_i0	PRJNA352850	7099	1419	6.465693	91.74818367	Pseudomonadati	3379134	Bacteria	Bacteria	401	1.86e-132	NR	TDJ68285.1	2026780	g5141	i0	45.2	19.6384778012685	442	236	93	3	1417	98	28	465	TDJ68285.1 MAG: M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium]	diamond	27867	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32635282	32635282	PRJNA352850_P_NODE_65140_length_283_cov_1.111111_g62307_i0	PRJNA352850	65140	283	1.111111	3.14444413	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	65.1	7.43e-10	NR	MFC1510138.1	2035772	g62307	i0	37.3	5.26855123674912	83	52	88	0	3	251	304	386	MFC1510138.1 8-amino-7-oxononanoate synthase [Candidatus Omnitrophota bacterium]	diamond	1491	65.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;