metadata: contig_metadata: 30 rows where bioproject = "PRJNA613025" and tax

30 rows where bioproject = "PRJNA613025" 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
1867823	1867823	PRJNA613025_S_NODE_26502_length_181_cov_1.439394_g26348_i0	PRJNA613025	26502	181	1.439394	2.60530314	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1.09e-63	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26348	i0	92.265	91.9447513812155	181	12	99	2	1	180	2003089	2002910	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	16642	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3142821	3142821	PRJNA613025_S_NODE_3103_length_986_cov_24.961580_g854_i4	PRJNA613025	3103	986	24.96158	246.1211788	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1279	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i4	90.432	149.685598377282	972	92	99	1	15	986	2192880	2191910	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	147590	1279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
4977011	4977011	PRJNA613025_S_NODE_32444_length_163_cov_1.245614_g32290_i0	PRJNA613025	32444	163	1.245614	2.03035082	Aquisphaera	1511635	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g32290	i0	93.21	134.668711656442	162	8	99	2	2	163	5178662	5178820	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	21951	237	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
5695780	5695780	PRJNA613025_S_NODE_885_length_2470_cov_29.969021_g854_i0	PRJNA613025	885	2470	29.969021	740.2348187	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	2536	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i0	85.335	129.289068825911	2489	324	100	39	1	2470	2192614	2190148	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	319344	2536	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
6969868	6969868	PRJNA613025_S_NODE_11966_length_340_cov_1.817869_g11812_i0	PRJNA613025	11966	340	1.817869	6.1807546	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	307	6.210000000000001e-79	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g11812	i0	83.237	141.891176470588	346	46	100	11	1	340	4989683	4990022	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	48243	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
6970382	6970382	PRJNA613025_S_NODE_32686_length_163_cov_0.894737_g32532_i0	PRJNA613025	32686	163	0.894737	1.45842131	Planctomycetia bacterium	2052181	Bacteria	Bacteria	65.8	1.75e-6	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g32532	i0	100	26.8159509202454	35	0	21	0	129	163	1078488	1078454	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	4371	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
9520049	9520049	PRJNA613025_S_NODE_2008_length_1368_cov_6.043973_g854_i3	PRJNA613025	2008	1368	6.043973	82.68155064	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1476	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i3	86.387	110.456140350877	1381	153	100	28	1	1368	2191160	2192518	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	151104	1476	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9520307	9520307	PRJNA613025_S_NODE_3248_length_949_cov_15.576667_g854_i7	PRJNA613025	3248	949	15.576667	147.82256983	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1286	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g854	i7	91.489	185.036880927292	940	73	99	6	14	949	1868926	1867990	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	175600	1286	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10795881	10795881	PRJNA613025_S_NODE_17369_length_246_cov_1.182741_g17215_i0	PRJNA613025	17369	246	1.182741	2.90954286	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g17215	i0	91.463	108.711382113821	246	21	100	0	1	246	7052348	7052593	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	26743	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10796152	10796152	PRJNA613025_S_NODE_28589_length_172_cov_2.016260_g28435_i0	PRJNA613025	28589	172	2.01626	3.4679672	Limnoglobus roseus	2598579	Bacteria	Bacteria	248	1.71e-61	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g28435	i0	92.982	184.098837209302	171	11	99	1	1	170	2956998	2957168	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31665	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14620640	14620640	PRJNA613025_S_NODE_1832_length_1463_cov_17.804102_g854_i2	PRJNA613025	1832	1463	17.804102	260.47401226	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	1598	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i2	86.576	177.127136021873	1475	166	100	25	1	1463	2191160	2192614	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	259137	1598	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14620927	14620927	PRJNA613025_S_NODE_3232_length_952_cov_9.457364_g854_i6	PRJNA613025	3232	952	9.457364	90.03410528	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1402	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g854	i6	93.291	141.616596638655	954	59	100	4	1	952	1868940	1867990	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	134819	1402	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15895152	15895152	PRJNA613025_S_NODE_933_length_2375_cov_23.797077_g854_i1	PRJNA613025	933	2375	23.797077	565.18057875	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	2416	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g854	i1	85.177	100.199157894737	2395	311	100	42	1	2375	2190148	2192518	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	237973	2416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16451614	16451614	PRJNA613025_S_NODE_26073_length_183_cov_1.500000_g25919_i0	PRJNA613025	26073	183	1.5	2.745	Singulisphaera	466152	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g25919	i0	89.617	258.568306010929	183	16	100	2	1	183	1543	1722	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	47318	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
19000300	19000300	PRJNA613025_S_NODE_3115_length_983_cov_30.907923_g854_i5	PRJNA613025	3115	983	30.907923	303.82488309	Bacteria	2	Bacteria	Bacteria	1203	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g854	i5	89.095	176.59003051882	972	101	99	5	1	970	2582676	2581708	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	173588	1212	0.992574257425743	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21550705	21550705	PRJNA613025_S_NODE_25917_length_184_cov_1.133333_g25763_i0	PRJNA613025	25917	184	1.133333	2.08533272	Planctomycetota	203682	Bacteria	Bacteria	78.7	2.59e-10	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g25763	i0	78.102	1.69021739130435	137	20	70	7	56	184	1882494	1882628	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	311	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
21550721	21550721	PRJNA613025_S_NODE_28417_length_173_cov_1.620968_g28263_i0	PRJNA613025	28417	173	1.620968	2.80427464	Aureliella	2795605	Bacteria	Bacteria	298	1.69e-76	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g28263	i0	97.701	102.346820809249	174	2	99	2	1	172	7000543	7000716	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	17706	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
22269017	22269017	PRJNA613025_S_NODE_26698_length_180_cov_1.755725_g26544_i0	PRJNA613025	26698	180	1.755725	3.160305	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26544	i0	98.333	139.4	180	3	100	0	1	180	2003630	2003451	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	25092	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23544337	23544337	PRJNA613025_S_NODE_26939_length_179_cov_1.561538_g26785_i0	PRJNA613025	26939	179	1.561538	2.79515302	Kolteria novifilia	2527975	Bacteria	Bacteria	165	1.87e-36	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g26785	i0	83.425	42.5586592178771	181	26	100	4	1	179	1830393	1830571	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	7618	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
23544711	23544711	PRJNA613025_S_NODE_9639_length_407_cov_1.424581_g9486_i0	PRJNA613025	9639	407	1.424581	5.79804467	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	315	4.51e-81	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g9486	i0	81.159	11.985257985258	414	58	99	18	1	404	1866284	1866687	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	4878	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
29272018	29272018	PRJNA613025_S_NODE_15189_length_276_cov_1.678414_g15035_i0	PRJNA613025	15189	276	1.678414	4.63242264	Bacteria	2	Bacteria	Bacteria	44.3	0.0158	NR	PHX78409.1	2026779	g15035	i0	64	1.08695652173913	25	9	27.2	0	92	18	547	571	PHX78409.1 MAG: hypothetical protein CK544_02960 [Planctomycetaceae bacterium]	diamond	300	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29953927	29953927	PRJNA613025_S_NODE_17811_length_241_cov_1.328125_g17657_i0	PRJNA613025	17811	241	1.328125	3.20078125	Rhodopirellula sp. TMED11	1986614	Bacteria	Bacteria	122	5.399999999999999e-31	NR	OUT58717.1	1986614	g17657	i0	74.7	0.983402489626556	79	20	98.3	0	3	239	366	444	OUT58717.1 MAG: adenosylhomocysteinase [Rhodopirellula sp. TMED11]	diamond	237	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. TMED11
30491065	30491065	PRJNA613025_S_NODE_29513_length_169_cov_1.133333_g29359_i0	PRJNA613025	29513	169	1.133333	1.91533277	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	72	6.58e-13	NR	HMN42288.1	2052180	g29359	i0	60.7	0.994082840236686	56	21	99.4	1	169	2	1362	1416	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	168	72	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30522555	30522555	PRJNA613025_S_NODE_20053_length_219_cov_2.147059_g19899_i0	PRJNA613025	20053	219	2.147059	4.70205921	Limnoglobus roseus	2598579	Bacteria	Bacteria	63.5	1.3e-9	NR	WP_149113609.1	2598579	g19899	i0	49.2	0.89041095890411	65	27	89	3	195	1	799	857	WP_149113609.1 FAD-binding protein [Limnoglobus roseus]	diamond	195	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
30996606	30996606	PRJNA613025_S_NODE_26294_length_182_cov_1.360902_g26140_i0	PRJNA613025	26294	182	1.360902	2.47684164	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	63.2	1.02e-9	NR	NUQ35036.1	2026779	g26140	i0	63	1.63186813186813	46	17	75.8	0	180	43	118	163	NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	297	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31375979	31375979	PRJNA613025_S_NODE_16356_length_258_cov_2.234450_g16202_i0	PRJNA613025	16356	258	2.23445	5.764881	Planctomycetia bacterium	2052181	Bacteria	Bacteria	161	2.3099999999999994e-48	NR	NCX99838.1	2052181	g16202	i0	98.8	0.988372093023256	85	1	98.8	0	257	3	92	176	NCX99838.1 TetR family transcriptional regulator [Planctomycetia bacterium]	diamond	255	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31534213	31534213	PRJNA613025_S_NODE_33776_length_161_cov_0.910714_g33622_i0	PRJNA613025	33776	161	0.910714	1.46624954	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	55.5	3.94e-7	NR	MFQ5463581.1	2026778	g33622	i0	71.9	0.596273291925466	32	9	59.6	0	14	109	325	356	MFQ5463581.1 hypothetical protein [Phycisphaerae bacterium]	diamond	96	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31945061	31945061	PRJNA613025_S_NODE_23817_length_195_cov_0.972603_g23663_i0	PRJNA613025	23817	195	0.972603	1.89657585	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0438	NR	NBU73603.1	2026780	g23663	i0	46.5	0.661538461538462	43	23	66.2	0	44	172	49	91	NBU73603.1 DUF1080 domain-containing protein [Planctomycetota bacterium]	diamond	129	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31945066	31945066	PRJNA613025_S_NODE_27077_length_178_cov_9.372093_g26923_i0	PRJNA613025	27077	178	9.372093	16.68232554	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0159	NR	MCZ7647757.1	2026780	g26923	i0	56.3	0.539325842696629	32	14	53.9	0	52	147	70	101	MCZ7647757.1 ThuA domain-containing protein [Planctomycetota bacterium]	diamond	96	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32356832	32356832	PRJNA613025_S_NODE_17979_length_239_cov_1.505263_g17825_i0	PRJNA613025	17979	239	1.505263	3.59757857	Rubripirellula tenax	2528015	Bacteria	Bacteria	81.3	9.7e-16	NR	WP_146456240.1	2528015	g17825	i0	55.6	0.903765690376569	72	32	90.4	0	218	3	415	486	WP_146456240.1 FAD-binding protein [Rubripirellula tenax]	diamond	216	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula tenax

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