metadata: contig_metadata: 21 rows where bioproject = "PRJNA680334", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA680334", 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
1926115	1926115	PRJNA680334_S_NODE_57162_length_184_cov_1.953642_g56676_i0	PRJNA680334	57162	184	1.953642	3.59470128	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	303	3.92e-78	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g56676	i0	96.739	215.298913043478	184	2	99	3	1	183	1155550	1155730	Planctomyces sp. SH-PL62, complete genome	blastn	39615	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
6273090	6273090	PRJNA680334_S_NODE_104125_length_151_cov_6.728814_g103639_i0	PRJNA680334	104125	151	6.728814	10.16050914	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	65.9	7.09e-11	NR	MCC7423088.1	2026779	g103639	i0	76.6	0.933774834437086	47	10	93.4	1	9	149	15	60	MCC7423088.1 DUF1254 domain-containing protein [Planctomycetaceae bacterium]	diamond	141	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
7028596	7028596	PRJNA680334_S_NODE_51966_length_189_cov_9.455128_g51480_i0	PRJNA680334	51966	189	9.455128	17.87019192	Caulifigura coniformis	2527983	Bacteria	Bacteria	335	1.4399999999999993e-87	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g51480	i0	98.93	12.6825396825397	187	2	99	0	1	187	2924863	2924677	Caulifigura coniformis strain Pan44 chromosome	blastn	2397	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
8303351	8303351	PRJNA680334_S_NODE_59327_length_182_cov_1.369128_g58841_i0	PRJNA680334	59327	182	1.369128	2.49181296	Bacteria	2	Bacteria	Bacteria	124	2.08e-33	NR	MBM4070672.1	2026780	g58841	i0	100	2.93406593406593	59	0	97.3	0	2	178	39	97	MBM4070672.1 DUF4405 domain-containing protein [Planctomycetota bacterium]	diamond	534	125	0.992	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
10097975	10097975	PRJNA680334_S_NODE_45528_length_197_cov_7.829268_g45042_i0	PRJNA680334	45528	197	7.829268	15.42365796	Planctomycetia	203683	Bacteria	Bacteria	182	2.09e-41	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g45042	i0	83.77	27.5736040609137	191	31	97	0	1	191	5093571	5093761	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	5432	183	0.994535519125683	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
10853959	10853959	PRJNA680334_S_NODE_49429_length_192_cov_8.088050_g48943_i0	PRJNA680334	49429	192	8.08805	15.529056	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g48943	i0	100	0.3125	29	0	15	0	150	178	6896188	6896160	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	60	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
13404544	13404544	PRJNA680334_S_NODE_87511_length_160_cov_3.897638_g87025_i0	PRJNA680334	87511	160	3.897638	6.2362208	Humisphaera borealis	2807512	Bacteria	Bacteria	241	2.6400000000000007e-59	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g87025	i0	94.304	85.83125	158	8	99	1	1	158	5062835	5062679	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	13733	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19776536	19776536	PRJNA680334_S_NODE_38156_length_208_cov_12.805714_g37670_i0	PRJNA680334	38156	208	12.805714	26.63588512	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2621786302\|emb\|OY782760.1\|	2026780	g37670	i0	100	0.134615384615385	28	0	13	0	10	37	2644891	2644864	MAG: Planctomycetota bacterium isolate 4c5731f0-34ce-4739-be05-23ee86c4296e genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23602422	23602422	PRJNA680334_S_NODE_29859_length_225_cov_3.447917_g29373_i0	PRJNA680334	29859	225	3.447917	7.75781325	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	244	3.08e-60	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g29373	i0	86.222	278.053333333333	225	31	100	0	1	225	266618	266394	Tautonia plasticadhaerens strain ElP chromosome	blastn	62562	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
26797144	26797144	PRJNA680334_S_NODE_9341_length_320_cov_32.076655_g8855_i0	PRJNA680334	9341	320	32.076655	102.645296	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0198	NR	MEY4673374.1	2026780	g8855	i0	37	0.684375	73	43	66.6	2	61	273	1013	1084	MEY4673374.1 hypothetical protein [Planctomycetota bacterium]	diamond	219	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27124981	27124981	PRJNA680334_S_NODE_45082_length_198_cov_3.315152_g44596_i0	PRJNA680334	45082	198	3.315152	6.56400096	Pseudomonadati	3379134	Bacteria	Bacteria	92	7.56e-21	NR	HEY3966710.1	2026779	g44596	i0	80.7	12.0909090909091	57	11	86.4	0	172	2	1	57	HEY3966710.1 glucose 1-dehydrogenase [Planctomycetaceae bacterium]	diamond	2394	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28092612	28092612	PRJNA680334_S_NODE_47585_length_195_cov_1.586420_g47099_i0	PRJNA680334	47585	195	1.58642	3.093519	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	79	6.76e-16	NR	HVT27669.1	2691534	g47099	i0	55.7	0.938461538461538	61	27	93.8	0	3	185	89	149	HVT27669.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	183	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
28534895	28534895	PRJNA680334_S_NODE_45647_length_197_cov_4.865854_g45161_i0	PRJNA680334	45647	197	4.865854	9.58573238	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	109	8.67e-27	NR	HEY7090212.1	2876886	g45161	i0	83.1	0.989847715736041	65	11	99	0	1	195	81	145	HEY7090212.1 lipopolysaccharide heptosyltransferase I [Tepidisphaeraceae bacterium]	diamond	195	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29197897	29197897	PRJNA680334_S_NODE_27029_length_232_cov_2.869347_g26543_i0	PRJNA680334	27029	232	2.869347	6.65688504	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	113	1.98e-29	NR	HEY7087992.1	2876886	g26543	i0	63.1	1.08620689655172	84	23	98.3	1	3	230	9	92	HEY7087992.1 nicotinate (nicotinamide) nucleotide adenylyltransferase [Tepidisphaeraceae bacterium]	diamond	252	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29260701	29260701	PRJNA680334_S_NODE_69429_length_173_cov_1.735714_g68943_i0	PRJNA680334	69429	173	1.735714	3.00278522	Planctomycetota bacterium	2026780	Bacteria	Bacteria	57	1.33e-7	NR	MAG57786.1	2026780	g68943	i0	50	0.901734104046243	52	25	88.4	1	172	20	15	66	MAG57786.1 hypothetical protein [Planctomycetota bacterium]	diamond	156	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29670997	29670997	PRJNA680334_S_NODE_15630_length_274_cov_4.701245_g15144_i0	PRJNA680334	15630	274	4.701245	12.8814113	Candidatus Laterigemmans baculatus	2770505	Bacteria	Bacteria	94	4.549999999999999e-23	NR	WP_164102970.1	2770505	g15144	i0	76.8	1.21532846715328	56	13	61.3	0	273	106	11	66	WP_164102970.1 RNA-binding S4 domain-containing protein [Candidatus Laterigemmans baculatus]	diamond	333	94	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Candidatus Laterigemmans	Candidatus Laterigemmans baculatus
29904298	29904298	PRJNA680334_S_NODE_58191_length_183_cov_1.846667_g57705_i0	PRJNA680334	58191	183	1.846667	3.37940061	PVC group	1783257	Bacteria	Bacteria	57.8	7.41e-9	NR	MDP6541725.1	2052180	g57705	i0	83.3	4.91803278688525	30	5	49.2	0	177	88	81	110	MDP6541725.1 adenosylhomocysteinase [Phycisphaerales bacterium]	diamond	900	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31219014	31219014	PRJNA680334_S_NODE_47215_length_195_cov_4.006173_g46729_i0	PRJNA680334	47215	195	4.006173	7.81203735	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	95.9	1.48e-21	NR	WP_082840152.1	1630693	g46729	i0	68.3	1.93846153846154	63	20	96.9	0	189	1	169	231	WP_082840152.1 ISAs1 family transposase [Gemmata sp. SH-PL17]	diamond	378	95.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
31535907	31535907	PRJNA680334_S_NODE_18136_length_262_cov_3.703057_g17650_i0	PRJNA680334	18136	262	3.703057	9.70200934	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0377	NR	MCC6672320.1	2026780	g17650	i0	42.6	0.698473282442748	61	28	61.8	1	20	181	14	74	MCC6672320.1 hypothetical protein [Planctomycetota bacterium]	diamond	183	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31757091	31757091	PRJNA680334_S_NODE_24937_length_238_cov_1.546341_g24451_i0	PRJNA680334	24937	238	1.546341	3.68029158	Pirellulales bacterium	2715253	Bacteria	Bacteria	65.5	3.2e-10	NR	HUY88976.1	2715253	g24451	i0	46.6	0.920168067226891	73	33	92	1	12	230	367	433	HUY88976.1 hypothetical protein [Pirellulales bacterium]	diamond	219	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32611166	32611166	PRJNA680334_S_NODE_39560_length_206_cov_3.965318_g39074_i0	PRJNA680334	39560	206	3.965318	8.16855508	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	68.9	7e-13	NR	HVT27674.1	2691534	g39074	i0	78.4	0.538834951456311	37	8	53.9	0	203	93	96	132	HVT27674.1 co-chaperone GroES family protein [Lacipirellulaceae bacterium]	diamond	111	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae 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);;