metadata: contig_metadata: 25 rows where bioproject = "PRJEB39269", tax_clade = "PVC group" and tax

25 rows where bioproject = "PRJEB39269", 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
989216	989216	PRJEB39269_P_NODE_54521_length_186_cov_1.952381_g54116_i0	PRJEB39269	54521	186	1.952381	3.63142866	Gemmata	113	Bacteria	Bacteria	278	2.41e-70	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g54116	i0	93.548	407.870967741935	186	12	100	0	1	186	1728	1543	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	75864	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
3883173	3883173	PRJEB39269_P_NODE_32344_length_243_cov_1.877451_g31939_i0	PRJEB39269	32344	243	1.877451	4.56220593	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	340	4.169999999999999e-89	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g31939	i0	93.506	105.728395061728	231	12	94	3	15	243	7051659	7051430	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	25692	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3883227	3883227	PRJEB39269_P_NODE_81664_length_157_cov_3.966102_g81259_i0	PRJEB39269	81664	157	3.966102	6.22678014	Phycisphaera mikurensis	547188	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g81259	i0	94.118	0.21656050955414	34	2	22	0	107	140	2049852	2049885	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	34	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
4817097	4817097	PRJEB39269_P_NODE_15264_length_359_cov_2.159375_g14859_i0	PRJEB39269	15264	359	2.159375	7.75215625	Planctomycetia	203683	Bacteria	Bacteria	652	0	NTclustered	gi\|220682248\|gb\|FJ542855.1\|	100233	g14859	i0	99.443	96.5097493036212	359	2	100	0	1	359	6	364	Uncultured Planctomycetaceae bacterium clone A04-09A 16S ribosomal RNA gene, partial sequence	blastn	34647	652	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5159378	5159378	PRJEB39269_P_NODE_33985_length_237_cov_1.242424_g33580_i0	PRJEB39269	33985	237	1.242424	2.94454488	Polystyrenella longa	2528007	Bacteria	Bacteria	344	3.13e-90	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g33580	i0	92.827	163.164556962025	237	17	100	0	1	237	1417758	1417994	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	38670	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
5159379	5159379	PRJEB39269_P_NODE_34865_length_234_cov_1.097436_g34460_i0	PRJEB39269	34865	234	1.097436	2.56800024	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	300	6.78e-77	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g34460	i0	89.873	45.517094017094	237	19	100	5	1	234	2002932	2003166	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	10651	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6092337	6092337	PRJEB39269_P_NODE_43785_length_207_cov_2.416667_g43380_i0	PRJEB39269	43785	207	2.416667	5.00250069	root	1	Root_unresolved	Root_unresolved	333	5.779999999999999e-87	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g43380	i0	95.694	169.033816425121	209	6	100	2	1	207	7051114	7050907	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	34990	335	0.994029850746269	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9917427	9917427	PRJEB39269_P_NODE_64448_length_172_cov_2.082707_g64043_i0	PRJEB39269	64448	172	2.082707	3.58225604	Lacipirellula	2691417	Bacteria	Bacteria	272	1.02e-68	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g64043	i0	95.322	116.732558139535	171	8	99	0	1	171	5170678	5170508	Lacipirellula limnantheis strain I41 chromosome	blastn	20078	272	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
9917461	9917461	PRJEB39269_P_NODE_80148_length_159_cov_0.941667_g79743_i0	PRJEB39269	80148	159	0.941667	1.49725053	Gimesia	1649453	Bacteria	Bacteria	171	3.479999999999999e-38	NTclustered	gi\|1727531535\|gb\|CP042910.1\|	122	g79743	i0	86.164	177.465408805031	159	21	99	1	2	159	2184726	2184568	Gimesia maris strain DSM 8797 chromosome, complete genome	blastn	28217	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
10259871	10259871	PRJEB39269_P_NODE_72389_length_165_cov_2.515873_g71984_i0	PRJEB39269	72389	165	2.515873	4.15119045	Gemmataceae bacterium	2052164	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g71984	i0	97.576	146.454545454545	165	4	100	0	1	165	320107	319943	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	24165	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
12810570	12810570	PRJEB39269_P_NODE_27071_length_268_cov_1.248908_g26666_i0	PRJEB39269	27071	268	1.248908	3.34707344	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	390	4.579999999999999e-104	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g26666	i0	92.91	446.570895522388	268	19	100	0	1	268	2192424	2192157	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	119681	390	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
13742708	13742708	PRJEB39269_P_NODE_60911_length_177_cov_1.188406_g60506_i0	PRJEB39269	60911	177	1.188406	2.10347862	Schlesneria	656899	Bacteria	Bacteria	159	8.559999999999998e-35	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g60506	i0	85.714	11.3050847457627	154	19	86	3	24	175	297	449	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	2001	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
13742738	13742738	PRJEB39269_P_NODE_80271_length_158_cov_4.495798_g79866_i0	PRJEB39269	80271	158	4.495798	7.10336084	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.1	1.71e-8	NR	MFM2096802.1	2026780	g79866	i0	92.6	2.6962025316455702	27	2	51.3	0	82	2	6	32	MFM2096802.1 Dihydrofolate reductase type 3 [Planctomycetota bacterium]	diamond	426	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14085345	14085345	PRJEB39269_P_NODE_41452_length_213_cov_2.293103_g41047_i0	PRJEB39269	41452	213	2.293103	4.88430939	Aeoliella mucimassa	2527972	Bacteria	Bacteria	339	1.28e-88	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g41047	i0	95.327	100.596244131455	214	8	99	2	1	212	2043834	2043621	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	21427	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
15359187	15359187	PRJEB39269_P_NODE_10153_length_437_cov_2.361809_g9749_i0	PRJEB39269	10153	437	2.361809	10.32110533	Aeoliella mucimassa	2527972	Bacteria	Bacteria	645	1.5199999999999993e-180	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g9749	i0	93.349	231.118993135011	436	29	99	0	2	437	2043036	2042601	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	100999	645	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
16633883	16633883	PRJEB39269_P_NODE_13274_length_385_cov_1.901734_g12869_i0	PRJEB39269	13274	385	1.901734	7.3216759	Aeoliella mucimassa	2527972	Bacteria	Bacteria	499	1.09e-136	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g12869	i0	97.279	219.955844155844	294	8	76	0	9	302	2043413	2043120	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	84683	499	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
18840927	18840927	PRJEB39269_P_NODE_31675_length_246_cov_1.299517_g31270_i0	PRJEB39269	31675	246	1.299517	3.19681182	Schlesneria	656899	Bacteria	Bacteria	219	2.07e-52	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g31270	i0	90.116	71.719512195122	172	12	68	4	80	246	1511	1682	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	17643	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
19182544	19182544	PRJEB39269_P_NODE_45916_length_202_cov_2.306748_g45511_i0	PRJEB39269	45916	202	2.306748	4.65963096	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	248	2.09e-61	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g45511	i0	88.78	157.668316831683	205	20	100	2	1	202	7051893	7052097	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	31849	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20115749	20115749	PRJEB39269_P_NODE_35596_length_231_cov_2.046875_g35191_i0	PRJEB39269	35596	231	2.046875	4.72828125	Planctomycetia	203683	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|4775510\|emb\|AJ231182.1\|	79875	g35191	i0	100	100.021645021645	231	0	100	0	1	231	919	689	planctomycete str. 292 16S rRNA gene, partial	blastn	23105	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 292
20115786	20115786	PRJEB39269_P_NODE_73896_length_164_cov_1.312000_g73491_i0	PRJEB39269	73896	164	1.312	2.15168	Schlesneria	656899	Bacteria	Bacteria	169	1.3000000000000001e-37	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g73491	i0	85.455	32.0731707317073	165	21	100	3	1	164	1415	1577	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	5260	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
27697146	27697146	PRJEB39269_P_NODE_88684_length_152_cov_1.442478_g88279_i0	PRJEB39269	88684	152	1.442478	2.19256656	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	66.2	5.43e-11	NR	HSZ58344.1	2876886	g88279	i0	70.2	7.36184210526316	47	14	92.8	0	10	150	18	64	HSZ58344.1 long-chain fatty acid--CoA ligase [Tepidisphaeraceae bacterium]	diamond	1119	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27823261	27823261	PRJEB39269_P_NODE_66784_length_170_cov_3.083969_g66379_i0	PRJEB39269	66784	170	3.083969	5.2427473000000004	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	50.4	1.44e-5	NR	MBX3406412.1	2026777	g66379	i0	84.6	0.9	26	4	45.9	0	1	78	21	46	MBX3406412.1 sigma-70 family RNA polymerase sigma factor [Phycisphaeraceae bacterium]	diamond	153	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28959957	28959957	PRJEB39269_P_NODE_34248_length_236_cov_1.441624_g33843_i0	PRJEB39269	34248	236	1.441624	3.40223264	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	45.1	0.00522	NR	MBX3417541.1	2699754	g33843	i0	40.4	0.597457627118644	47	28	59.7	0	23	163	22	68	MBX3417541.1 AMP-binding protein [Pirellulaceae bacterium]	diamond	141	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29117794	29117794	PRJEB39269_P_NODE_52589_length_189_cov_3.213333_g52184_i0	PRJEB39269	52589	189	3.213333	6.07319937	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0478	NR	HET6202587.1	2026780	g52184	i0	37.9	0.920634920634921	58	32	85.7	1	10	171	48	105	HET6202587.1 glycosyltransferase [Planctomycetota bacterium]	diamond	174	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31771683	31771683	PRJEB39269_P_NODE_87137_length_153_cov_1.596491_g86732_i0	PRJEB39269	87137	153	1.596491	2.44263123	Gemmataceae bacterium	2052164	Bacteria	Bacteria	51.2	1.14e-5	NR	MEO2089549.1	2052164	g86732	i0	56.1	0.803921568627451	41	18	80.4	0	1	123	230	270	MEO2089549.1 hypothetical protein [Gemmataceae bacterium]	diamond	123	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;