metadata: contig_metadata: 29 rows where bioproject = "PRJNA421571" and tax

29 rows where bioproject = "PRJNA421571" 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
423318	423318	PRJNA421571_P_NODE_51941_length_378_cov_2.019672_g49392_i0	PRJNA421571	51941	378	2.019672	7.63436016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	111	3.98e-26	NR	MEO0631472.1	2026780	g49392	i0	52.8	1.79365079365079	106	44	79.4	2	364	65	296	401	MEO0631472.1 hypothetical protein [Planctomycetota bacterium]	diamond	678	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
2361500	2361500	PRJNA421571_P_NODE_65902_length_317_cov_2.286885_g63353_i0	PRJNA421571	65902	317	2.286885	7.24942545	Caulifigura	2795778	Bacteria	Bacteria	542	1.45e-149	NTclustered	gi\|12583971\|gb\|AF245375.1\|AF245375	149590	g63353	i0	97.476	129.205047318612	317	8	100	0	1	317	895	1211	Planctomycete str. 658 23S ribosomal RNA gene, partial sequence	blastn	40958	547	0.990859232175503	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 658
2972650	2972650	PRJNA421571_P_NODE_11103_length_1138_cov_1.540845_g9557_i0	PRJNA421571	11103	1138	1.540845	17.5348161	Pseudomonadati	3379134	Bacteria	Bacteria	546	5.95e-188	NR	WP_146586571.1	2528002	g9557	i0	69.7	60.8409490333919	373	109	98.1	2	22	1137	10	379	WP_146586571.1 catalase [Posidoniimonas polymericola]	diamond	69237	550	0.992727272727273	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Posidoniimonas	Posidoniimonas polymericola
2973628	2973628	PRJNA421571_P_NODE_3_length_7201_cov_7.290825_g2_i0	PRJNA421571	3	7201	7.290825	525.01230825	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	92.4	2.52e-14	NR	MCC6971826.1	2052180	g2	i0	27.7	0.189557005971393	455	284	18.3	12	3484	4803	107	531	MCC6971826.1 hypothetical protein [Phycisphaerales bacterium]	diamond	1365	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
4914232	4914232	PRJNA421571_P_NODE_75784_length_287_cov_1.761682_g73235_i0	PRJNA421571	75784	287	1.761682	5.05602734	Planctomycetia	203683	Bacteria	Bacteria	448	2.9e-121	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g73235	i0	94.81	317.369337979094	289	11	99	3	2	287	122779	123066	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	91085	451	0.993348115299335	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
9352515	9352515	PRJNA421571_P_NODE_96208_length_248_cov_0.880000_g93659_i0	PRJNA421571	96208	248	0.88	2.1824	Saltatorellus ferox	2528018	Bacteria	Bacteria	189	1.6399999999999996e-43	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g93659	i0	81.858	57.9072580645161	226	39	91	2	4	228	2331954	2332178	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	14361	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
11289512	11289512	PRJNA421571_P_NODE_87169_length_260_cov_2.871658_g84620_i0	PRJNA421571	87169	260	2.871658	7.4663108	Planctomyces	118	Bacteria	Bacteria	359	1.25e-94	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g84620	i0	91.635	144.55	263	16	100	5	1	260	5935802	5936061	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	37583	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11903322	11903322	PRJNA421571_P_NODE_99950_length_245_cov_2.674419_g97401_i0	PRJNA421571	99950	245	2.674419	6.55232655	Planctomycetota bacterium	2026780	Bacteria	Bacteria	96.3	5.59e-21	NR	MEM0982985.1	2026780	g97401	i0	63.2	2.75510204081633	76	25	93.1	1	229	2	8	80	MEM0982985.1 alanine--tRNA ligase [Planctomycetota bacterium]	diamond	675	96.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14452891	14452891	PRJNA421571_P_NODE_77052_length_284_cov_1.459716_g74503_i0	PRJNA421571	77052	284	1.459716	4.14559344	Bacteria	2	Bacteria	Bacteria	82.8	4.73e-16	NR	MFN5944013.1	2026778	g74503	i0	43.5	1.94366197183099	92	52	97.2	0	5	280	308	399	MFN5944013.1 aldehyde dehydrogenase [Phycisphaerae bacterium]	diamond	552	82.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
15725668	15725668	PRJNA421571_P_NODE_42333_length_445_cov_1.913978_g39785_i0	PRJNA421571	42333	445	1.913978	8.5172021	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g39785	i0	100	0.0696629213483146	31	0	7	0	59	89	7374518	7374488	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18937775	18937775	PRJNA421571_P_NODE_95415_length_249_cov_0.875000_g92866_i0	PRJNA421571	95415	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2916408352\|gb\|CP170455.1\|	2052180	g92866	i0	92.5	0.321285140562249	40	0	16	2	149	188	235684	235648	MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome	blastn	80	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
20825392	20825392	PRJNA421571_P_NODE_64877_length_321_cov_1.552419_g62328_i0	PRJNA421571	64877	321	1.552419	4.98326499	Botrimarina mediterranea	2528022	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1712762859\|gb\|CP036349.1\|	2528022	g62328	i0	100	0.177570093457944	29	0	9	0	92	120	4568598	4568626	Botrimarina mediterranea strain Spa11 chromosome	blastn	57	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
23376062	23376062	PRJNA421571_P_NODE_74599_length_290_cov_1.419355_g72050_i0	PRJNA421571	74599	290	1.419355	4.1161295	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	270	6.81e-68	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g72050	i0	84.286	88.9379310344828	280	41	96	3	3	281	7379430	7379153	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	25792	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
26712131	26712131	PRJNA421571_P_NODE_95601_length_249_cov_0.869318_g93052_i0	PRJNA421571	95601	249	0.869318	2.16460182	root	1	Root_unresolved	Root_unresolved	70.5	2.34e-12	NR	MBI1825087.1	2026780	g93052	i0	45.9	3.24096385542169	74	39	89.2	1	246	25	20	92	MBI1825087.1 FkbM family methyltransferase [Planctomycetota bacterium]	diamond	807	70.9	0.994358251057828	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27138465	27138465	PRJNA421571_P_NODE_84862_length_266_cov_0.968912_g82313_i0	PRJNA421571	84862	266	0.968912	2.57730592	Planctomycetota bacterium	2026780	Bacteria	Bacteria	105	2.12e-24	NR	MDP6963322.1	2026780	g82313	i0	58.1	4.84962406015038	86	33	95.9	2	10	264	230	313	MDP6963322.1 M60 family metallopeptidase [Planctomycetota bacterium]	diamond	1290	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27296901	27296901	PRJNA421571_P_NODE_27683_length_629_cov_1.194245_g25179_i0	PRJNA421571	27683	629	1.194245	7.51180105	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	3.42e-4	NR	MDH3592285.1	2026780	g25179	i0	29.4	0.777424483306836	163	91	70.6	3	3	446	71	224	MDH3592285.1 M60 family metallopeptidase [Planctomycetota bacterium]	diamond	489	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27707909	27707909	PRJNA421571_P_NODE_107484_length_236_cov_2.631902_g104935_i0	PRJNA421571	107484	236	2.631902	6.21128872	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	108	1.71e-25	NR	WP_075096580.1	1632864	g104935	i0	62.8	0.991525423728814	78	29	99.2	0	2	235	270	347	WP_075096580.1 M66 family metalloprotease [Planctomyces sp. SH-PL14]	diamond	234	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
28686530	28686530	PRJNA421571_P_NODE_89247_length_256_cov_1.262295_g86698_i0	PRJNA421571	89247	256	1.262295	3.2314752	Aquisphaera insulae	2712864	Bacteria	Bacteria	62.8	2.92e-9	NR	WP_165220558.1	2712864	g86698	i0	62	1.171875	50	19	58.6	0	252	103	115	164	WP_165220558.1 lipase family protein [Aquisphaera insulae]	diamond	300	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
28875662	28875662	PRJNA421571_P_NODE_38528_length_481_cov_1.575980_g35981_i0	PRJNA421571	38528	481	1.57598	7.5804638	Planctomycetota bacterium	2026780	Bacteria	Bacteria	121	4.55e-29	NR	MBL7007865.1	2026780	g35981	i0	39	2.97505197505198	159	93	96.7	3	1	465	111	269	MBL7007865.1 hypothetical protein [Planctomycetota bacterium]	diamond	1431	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29286055	29286055	PRJNA421571_P_NODE_82989_length_270_cov_1.177665_g80440_i0	PRJNA421571	82989	270	1.177665	3.1796955	Gemmataceae bacterium	2052164	Bacteria	Bacteria	104	6.62e-24	NR	MCI0460161.1	2052164	g80440	i0	53.6	1.86666666666667	84	39	93.3	0	16	267	1	84	MCI0460161.1 VWA-like domain-containing protein [Gemmataceae bacterium]	diamond	504	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29428786	29428786	PRJNA421571_P_NODE_106649_length_241_cov_0.916667_g104100_i0	PRJNA421571	106649	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	64.3	9.13e-10	NR	MFN0057506.1	2026780	g104100	i0	52.9	4.0954356846473	51	24	63.5	0	235	83	555	605	MFN0057506.1 M3 family metallopeptidase [Planctomycetota bacterium]	diamond	987	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29460288	29460288	PRJNA421571_P_NODE_103390_length_243_cov_0.905882_g100841_i0	PRJNA421571	103390	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	87.4	7.01e-18	NR	HMN42288.1	2052180	g100841	i0	57.1	1.61728395061728	63	27	77.8	0	51	239	1346	1408	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	393	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30107136	30107136	PRJNA421571_P_NODE_77132_length_284_cov_1.180095_g74583_i0	PRJNA421571	77132	284	1.180095	3.3514698	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.2	1.69e-8	NR	MEC7233350.1	2026780	g74583	i0	44.3	0.73943661971831	70	39	73.9	0	226	17	195	264	MEC7233350.1 hypothetical protein [Planctomycetota bacterium]	diamond	210	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30376986	30376986	PRJNA421571_P_NODE_42812_length_441_cov_1.782609_g40264_i0	PRJNA421571	42812	441	1.782609	7.86130569	Bacteria	2	Bacteria	Bacteria	113	7.93e-26	NR	MCC6682421.1	2026777	g40264	i0	47.8	4.87755102040816	115	60	78.2	0	437	93	653	767	MCC6682421.1 alanine--tRNA ligase [Phycisphaeraceae bacterium]	diamond	2151	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31149440	31149440	PRJNA421571_P_NODE_103955_length_243_cov_0.905882_g101406_i0	PRJNA421571	103955	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99.4	3.6000000000000003e-22	NR	MBL8722991.1	2026780	g101406	i0	52.6	1.91358024691358	78	37	96.3	0	239	6	225	302	MBL8722991.1 hypothetical protein [Planctomycetota bacterium]	diamond	465	99.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31434418	31434418	PRJNA421571_P_NODE_44816_length_425_cov_2.312500_g42268_i0	PRJNA421571	44816	425	2.3125	9.828125	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	44.7	0.0313	NR	HWE37279.1	2691532	g42268	i0	42.4	0.416470588235294	59	23	36.7	3	189	34	139	193	HWE37279.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	177	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
31592815	31592815	PRJNA421571_P_NODE_101916_length_244_cov_0.900585_g99367_i0	PRJNA421571	101916	244	0.900585	2.1974274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	97.8	4.5e-24	NR	MEO0480714.1	2026780	g99367	i0	61.3	3.4672131147541	75	29	92.2	0	2	226	53	127	MEO0480714.1 Rid family detoxifying hydrolase [Planctomycetota bacterium]	diamond	846	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31972217	31972217	PRJNA421571_P_NODE_88178_length_258_cov_1.664865_g85629_i0	PRJNA421571	88178	258	1.664865	4.2953517	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	172	2.2799999999999998e-48	NR	MBY0309260.1	2052180	g85629	i0	96.5	0.988372093023256	85	3	98.8	0	3	257	81	165	MBY0309260.1 FYVE zinc finger domain-containing protein [Phycisphaerales bacterium]	diamond	255	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32590078	32590078	PRJNA421571_P_NODE_97019_length_248_cov_0.880000_g94470_i0	PRJNA421571	97019	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	95.9	7.88e-21	NR	MCC6785004.1	2026780	g94470	i0	60.3	4.68145161290323	78	29	91.9	1	232	5	406	483	MCC6785004.1 glutamine synthetase III [Planctomycetota bacterium]	diamond	1161	96.7	0.991726990692865	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);;