metadata: contig_metadata: 21 rows where bioproject = "PRJNA495917" and tax

21 rows where bioproject = "PRJNA495917" 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
1752475	1752475	PRJNA495917_S_NODE_1762_length_362_cov_6.507645_g1568_i0	PRJNA495917	1762	362	6.507645	23.5576749	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	377	4.99e-100	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1568	i0	91.912	143.185082872928	272	19	77	3	2	272	1155850	1156119	Planctomyces sp. SH-PL62, complete genome	blastn	51833	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
3028428	3028428	PRJNA495917_S_NODE_15443_length_153_cov_4.161017_g15249_i0	PRJNA495917	15443	153	4.161017	6.36635601	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	156	9.29e-34	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g15249	i0	87.143	135.993464052288	140	15	91	3	15	153	3454131	3453994	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	20807	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
4304388	4304388	PRJNA495917_S_NODE_2064_length_339_cov_6.365132_g1870_i0	PRJNA495917	2064	339	6.365132	21.57779748	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	483	9.579999999999998e-132	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g1870	i0	92.375	170.185840707965	341	22	100	4	1	339	1156438	1156776	Planctomyces sp. SH-PL62, complete genome	blastn	57693	483	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
5581037	5581037	PRJNA495917_S_NODE_1425_length_397_cov_9.453039_g1231_i0	PRJNA495917	1425	397	9.453039	37.52856483	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	401	3.279999999999999e-107	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g1231	i0	85.567	152.2040302267	388	51	96	5	1	383	2002940	2002553	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	60425	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5581186	5581186	PRJNA495917_S_NODE_9965_length_175_cov_1.307143_g9771_i0	PRJNA495917	9965	175	1.307143	2.28750025	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	204	3.85e-48	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9771	i0	89.024	6.2	164	18	94	0	1	164	2191716	2191553	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1085	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
7485977	7485977	PRJNA495917_S_NODE_2406_length_314_cov_7.483871_g2212_i0	PRJNA495917	2406	314	7.483871	23.49935494	Frigoriglobus	2774146	Bacteria	Bacteria	342	1.5599999999999997e-89	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2212	i0	86.581	163.93949044586	313	39	99	2	2	314	3457525	3457216	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	51477	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
9405478	9405478	PRJNA495917_S_NODE_4208_length_242_cov_2.024155_g4014_i0	PRJNA495917	4208	242	2.024155	4.8984551	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	250	7.2e-62	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g4014	i0	88.372	210.743801652893	215	16	89	3	26	240	2190748	2190543	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	51000	250	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9405490	9405490	PRJNA495917_S_NODE_5088_length_223_cov_21.409574_g4894_i0	PRJNA495917	5088	223	21.409574	47.74335002	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	396	7.939999999999995e-106	NTclustered	gi\|633869078\|gb\|KJ127967.1\|	100233	g4894	i0	98.655	118.502242152466	223	3	100	0	1	223	714	936	Uncultured Planctomycetaceae bacterium clone NJFU_SLX-S92 16S ribosomal RNA gene, partial sequence	blastn	26426	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10681161	10681161	PRJNA495917_S_NODE_2529_length_307_cov_183.069853_g2335_i0	PRJNA495917	2529	307	183.069853	562.02444871	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	455	1.87e-123	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g2335	i0	93.485	170.882736156352	307	18	100	1	1	307	4319585	4319889	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	52461	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14506265	14506265	PRJNA495917_S_NODE_5572_length_215_cov_2.638889_g5378_i0	PRJNA495917	5572	215	2.638889	5.67361135	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	130	8.51e-26	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g5378	i0	78.341	275.139534883721	217	35	97	11	1	209	7050415	7050627	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	59155	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17054816	17054816	PRJNA495917_S_NODE_14734_length_155_cov_6.700000_g14540_i0	PRJNA495917	14734	155	6.7	10.385	Paludisphaera borealis	1387353	Bacteria	Bacteria	193	7.2e-45	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g14540	i0	89.103	13.5806451612903	156	16	100	1	1	155	123424	123579	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	2105	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
17054932	17054932	PRJNA495917_S_NODE_8474_length_184_cov_3.993289_g8280_i0	PRJNA495917	8474	184	3.993289	7.34765176	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	169	1.4899999999999998e-37	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g8280	i0	94.495	81.9619565217391	109	6	59	0	76	184	593141	593249	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	15081	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
18329183	18329183	PRJNA495917_S_NODE_695_length_553_cov_3.617761_g521_i0	PRJNA495917	695	553	3.617761	20.00621833	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	754	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g521	i0	91.351	168.26582278481	555	43	100	5	1	553	4317532	4318083	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	93051	754	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19603481	19603481	PRJNA495917_S_NODE_556_length_612_cov_7.798960_g395_i0	PRJNA495917	556	612	7.79896	47.7296352	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	765	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g395	i0	89.577	463.205882352941	614	49	99	11	3	606	5936167	5936775	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	283482	765	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20234348	20234348	PRJNA495917_S_NODE_5896_length_210_cov_11.028571_g5702_i0	PRJNA495917	5896	210	11.028571	23.1599991	Isosphaeraceae	1763524	Bacteria	Bacteria	355	1.25e-93	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g5702	i0	97.143	180.771428571429	210	6	100	0	1	210	5180611	5180402	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	37962	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
20879257	20879257	PRJNA495917_S_NODE_11557_length_167_cov_1.310606_g11363_i0	PRJNA495917	11557	167	1.310606	2.18871202	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	174	2.87e-39	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g11363	i0	85.799	7.05988023952096	169	19	99	5	1	165	2190974	2191141	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1179	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22784958	22784958	PRJNA495917_S_NODE_118_length_1150_cov_11.729148_g65_i0	PRJNA495917	118	1150	11.729148	134.885202	Bacteria	2	Bacteria	Bacteria	1234	0	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g65	i0	86.239	316.315652173913	1170	123	99	29	7	1150	3453709	3454866	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	363763	1234	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
24059750	24059750	PRJNA495917_S_NODE_1339_length_408_cov_6.367292_g1145_i0	PRJNA495917	1339	408	6.367292	25.97855136	Singulisphaera	466152	Bacteria	Bacteria	455	2.56e-123	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g1145	i0	87.317	93.1470588235294	410	37	99	11	1	406	162	560	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	38004	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
24703566	24703566	PRJNA495917_S_NODE_860_length_504_cov_22.899787_g674_i0	PRJNA495917	860	504	22.899787	115.41492648	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	540	8.63e-149	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g674	i0	86.106	175.242063492063	511	60	100	11	1	504	2003174	2002668	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	88322	540	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
30866808	30866808	PRJNA495917_S_NODE_14094_length_157_cov_2.934426_g13900_i0	PRJNA495917	14094	157	2.934426	4.60704882	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.00452	NR	MBM4009064.1	2026780	g13900	i0	37.5	1.52866242038217	40	22	70.7	1	2	112	137	176	MBM4009064.1 DMT family transporter [Planctomycetota bacterium]	diamond	240	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32527339	32527339	PRJNA495917_S_NODE_4539_length_234_cov_2.432161_g4345_i0	PRJNA495917	4539	234	2.432161	5.69125674	Bacteria	2	Bacteria	Bacteria	109	9.31e-26	NR	MFK7818047.1	2026779	g4345	i0	69.7	3.92307692307692	76	21	96.2	2	234	10	1377	1451	MFK7818047.1 Calx-beta domain-containing protein [Planctomycetaceae bacterium]	diamond	918	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;