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

30 rows where bioproject = "PRJEB14664" and tax_clade = "PVC group"

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
11499176	11499176	PRJEB14664_P_NODE_11870_length_214_cov_1.787709_g11740_i0	PRJEB14664	11870	214	1.787709	3.82569726	Pseudomonadati	3379134	Bacteria	Bacteria	88.2	1.19e-18	NR	MBR3505802.1	2053569	g11740	i0	57.1	12.392523364486	70	30	98.1	0	213	4	26	95	MBR3505802.1 2-hydroxyacid dehydrogenase [Lentisphaeria bacterium]	diamond	2652	88.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
15323343	15323343	PRJEB14664_P_NODE_14853_length_184_cov_1.463087_g14723_i0	PRJEB14664	14853	184	1.463087	2.69208008	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	134	5.45e-27	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g14723	i0	82.692	73.5	156	22	83	4	33	184	7052393	7052239	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	13524	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15323462	15323462	PRJEB14664_P_NODE_7693_length_289_cov_1.795276_g7563_i0	PRJEB14664	7693	289	1.795276	5.18834764	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	145	2.6e-41	NR	MCX6845248.1	2026799	g7563	i0	69.8	3.95501730103806	96	29	99.7	0	288	1	133	228	MCX6845248.1 group II intron reverse transcriptase/maturase [Verrucomicrobiota bacterium]	diamond	1143	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
16288458	16288458	PRJEB14664_P_NODE_4473_length_411_cov_1.779255_g4345_i0	PRJEB14664	4473	411	1.779255	7.31273805	Telmatocola	1382832	Bacteria	Bacteria	298	4.59e-76	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g4345	i0	80.494	228.579075425791	405	65	96	12	16	411	3454131	3453732	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	93946	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
19146642	19146642	PRJEB14664_P_NODE_10576_length_232_cov_1.802030_g10446_i0	PRJEB14664	10576	232	1.80203	4.1807096	Kolteria novifilia	2527975	Bacteria	Bacteria	176	1.18e-39	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g10446	i0	81.034	294.560344827586	232	35	98	7	1	227	1830090	1830317	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	68338	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
19146803	19146803	PRJEB14664_P_NODE_7436_length_295_cov_2.861538_g7306_i0	PRJEB14664	7436	295	2.861538	8.4415371	Simkania sp.	34094	Bacteria	Bacteria	168	2.68e-51	NR	MCB1084350.1	34094	g7306	i0	81.1	1.93220338983051	95	18	96.6	0	9	293	1	95	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	570	168	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
21697878	21697878	PRJEB14664_P_NODE_14118_length_191_cov_1.076923_g13988_i0	PRJEB14664	14118	191	1.076923	2.05692293	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	263	6.97e-66	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g13988	i0	91.579	30.2198952879581	190	16	99	0	1	190	3990517	3990328	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	5772	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
22662664	22662664	PRJEB14664_P_NODE_10458_length_234_cov_1.402010_g10328_i0	PRJEB14664	10458	234	1.40201	3.2807034	Gemmata	113	Bacteria	Bacteria	399	6.499999999999999e-107	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g10328	i0	97.436	111.636752136752	234	6	100	0	1	234	3634164	3634397	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	26123	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
26709806	26709806	PRJEB14664_P_NODE_17401_length_165_cov_1.400000_g17271_i0	PRJEB14664	17401	165	1.4	2.31	Pseudomonadati	3379134	Bacteria	Bacteria	53.5	1.99e-6	NR	WP_309386201.1	490090	g17271	i0	58.8	1.29090909090909	34	14	61.8	0	103	2	2744	2777	WP_309386201.1 DUF6531 domain-containing protein [Cerasicoccus frondis]	diamond	213	53.9	0.992578849721707	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus frondis
26843387	26843387	PRJEB14664_P_NODE_19161_length_155_cov_1.950000_g19031_i0	PRJEB14664	19161	155	1.95	3.0225	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.6	0.026	NR	MDB5304208.1	2052180	g19031	i0	42.1	0.735483870967742	38	22	73.5	0	26	139	24	61	MDB5304208.1 hypothetical protein [Phycisphaerales bacterium]	diamond	114	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
26875151	26875151	PRJEB14664_P_NODE_12901_length_202_cov_2.395210_g12771_i0	PRJEB14664	12901	202	2.39521	4.8383242	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0118	NR	MEP7015139.1	2026799	g12771	i0	36	1.76732673267327	50	32	74.3	0	150	1	220	269	MEP7015139.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	357	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27064630	27064630	PRJEB14664_P_NODE_18062_length_161_cov_1.269841_g17932_i0	PRJEB14664	18062	161	1.269841	2.04444401	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.2	7.34e-10	NR	MEZ6184495.1	2026780	g17932	i0	51	0.91304347826087	49	24	91.3	0	8	154	102	150	MEZ6184495.1 pyridoxamine 5'-phosphate oxidase family protein [Planctomycetota bacterium]	diamond	147	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27279666	27279666	PRJEB14664_P_NODE_8223_length_277_cov_1.487603_g8093_i0	PRJEB14664	8223	277	1.487603	4.12066031	Pseudomonadati	3379134	Bacteria	Bacteria	161	2.39e-44	NR	MBN4067489.1	83561	g8093	i0	78.3	21.9314079422383	92	20	99.6	0	1	276	151	242	MBN4067489.1 phosphoenolpyruvate carboxykinase (GTP) [Simkania negevensis]	diamond	6075	161	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
27317705	27317705	PRJEB14664_P_NODE_16063_length_174_cov_2.294964_g15933_i0	PRJEB14664	16063	174	2.294964	3.99323736	Planctomycetota bacterium	2026780	Bacteria	Bacteria	66.2	1.17e-11	NR	MCC7137672.1	2026780	g15933	i0	53.6	3.87931034482759	56	26	96.6	0	173	6	22	77	MCC7137672.1 fasciclin domain-containing protein [Planctomycetota bacterium]	diamond	675	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27538722	27538722	PRJEB14664_P_NODE_784_length_1023_cov_3.206478_g718_i0	PRJEB14664	784	1023	3.206478	32.80226994	Simkania sp.	34094	Bacteria	Bacteria	258	1.98e-81	NR	MCB1084310.1	34094	g718	i0	75.3	0.498533724340176	170	42	49.9	0	757	248	1	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	510	258	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27759957	27759957	PRJEB14664_P_NODE_16664_length_170_cov_1.777778_g16534_i0	PRJEB14664	16664	170	1.777778	3.0222226	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.5	6.91e-9	NR	MCK6473335.1	2026780	g16534	i0	48.2	0.988235294117647	56	28	97.1	1	3	167	236	291	MCK6473335.1 endonuclease/exonuclease/phosphatase family protein [Planctomycetota bacterium]	diamond	168	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28580668	28580668	PRJEB14664_P_NODE_3367_length_488_cov_3.150110_g3243_i0	PRJEB14664	3367	488	3.15011	15.3725368	Chlamydiales bacterium	2047757	Bacteria	Bacteria	273	1.66e-91	NR	MCP5470421.1	2047757	g3243	i0	82.9	0.971311475409836	158	27	97.1	0	483	10	1	158	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	474	273	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29590579	29590579	PRJEB14664_P_NODE_10890_length_228_cov_1.186528_g10760_i0	PRJEB14664	10890	228	1.186528	2.70528384	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	43.5	0.0167	NR	HPA20325.1	2499141	g10760	i0	40.7	0.710526315789474	54	22	57.9	1	189	58	425	478	HPA20325.1 sulfatase-like hydrolase/transferase [Verrucomicrobiia bacterium]	diamond	162	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29622059	29622059	PRJEB14664_P_NODE_5490_length_358_cov_2.495356_g5360_i0	PRJEB14664	5490	358	2.495356	8.93337448	Chlamydiales bacterium	2047757	Bacteria	Bacteria	188	6.59e-59	NR	MCP5470420.1	2047757	g5360	i0	83.2	0.99720670391061506	119	18	99.7	1	357	1	4	120	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	357	188	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29653710	29653710	PRJEB14664_P_NODE_770_length_1034_cov_4.443443_g704_i0	PRJEB14664	770	1034	4.443443	45.94520062	PVC group bacterium	2056642	Bacteria	Bacteria	63.2	1.65e-8	NR	MCP4648866.1	2056642	g704	i0	45	0.290135396518375	100	55	29	0	475	176	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	63.2	1	Bacteria	PVC group	Pseudomonadati						PVC group bacterium
29716945	29716945	PRJEB14664_P_NODE_16210_length_173_cov_2.000000_g16080_i0	PRJEB14664	16210	173	2	3.46	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	69.3	6.12e-12	NR	HMN42288.1	2052180	g16080	i0	56.9	1.69942196531792	51	22	88.4	0	1	153	1408	1458	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	294	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29963591	29963591	PRJEB14664_P_NODE_4971_length_383_cov_1.589080_g4841_i0	PRJEB14664	4971	383	1.58908	6.0861764	Bacteria	2	Bacteria	Bacteria	186	4.21e-54	NR	HVK15574.1	1914235	g4841	i0	70.1	57.532637075718	127	38	99.5	0	1	381	236	362	HVK15574.1 aldehyde dehydrogenase family protein [Fimbriiglobus sp.]	diamond	22035	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
30569926	30569926	PRJEB14664_P_NODE_19473_length_154_cov_1.319328_g19343_i0	PRJEB14664	19473	154	1.319328	2.03176512	Planctomycetota bacterium	2026780	Bacteria	Bacteria	99.8	6.709999999999999e-23	NR	NBB94572.1	2026780	g19343	i0	83.7	8.53246753246753	49	8	95.5	0	5	151	107	155	NBB94572.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1314	99.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31201666	31201666	PRJEB14664_P_NODE_20395_length_150_cov_1.043478_g20265_i0	PRJEB14664	20395	150	1.043478	1.565217	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	46.6	4.48e-4	NR	UCD74336.1	2052180	g20265	i0	50	0.68	34	17	68	0	2	103	271	304	UCD74336.1 MAG: S46 family peptidase [Phycisphaerales bacterium]	diamond	102	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31581791	31581791	PRJEB14664_P_NODE_2036_length_645_cov_2.483607_g1927_i0	PRJEB14664	2036	645	2.483607	16.01926515	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	54.3	1.21e-4	NR	MFQ5462041.1	2026778	g1927	i0	44.8	1.05581395348837	105	43	46.5	5	2	301	219	313	MFQ5462041.1 hypothetical protein [Phycisphaerae bacterium]	diamond	681	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31992870	31992870	PRJEB14664_P_NODE_6118_length_334_cov_2.505017_g5988_i0	PRJEB14664	6118	334	2.505017	8.36675678	Gemmata palustris	2822762	Bacteria	Bacteria	70.5	1.1e-11	NR	WP_210652270.1	2822762	g5988	i0	76.7	5.78443113772455	43	10	38.6	0	332	204	252	294	WP_210652270.1 AraC family transcriptional regulator [Gemmata palustris]	diamond	1932	70.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata palustris
32087785	32087785	PRJEB14664_P_NODE_12958_length_202_cov_1.197605_g12828_i0	PRJEB14664	12958	202	1.197605	2.4191621	Spartobacteria bacterium LR76	2161866	Bacteria	Bacteria	61.6	4.48e-9	NR	PTX96103.1	2161866	g12828	i0	51.5	0.98019801980198	66	32	98	0	3	200	255	320	PTX96103.1 hypothetical protein DB345_09910 [Spartobacteria bacterium LR76]	diamond	198	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium LR76
32246349	32246349	PRJEB14664_P_NODE_20318_length_150_cov_1.391304_g20188_i0	PRJEB14664	20318	150	1.391304	2.086956	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	55.8	2.42e-7	NR	MDG2291586.1	2052180	g20188	i0	56.3	1.7	48	19	92	1	143	6	480	527	MDG2291586.1 PQQ-dependent sugar dehydrogenase [Phycisphaerales bacterium]	diamond	255	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32436138	32436138	PRJEB14664_P_NODE_13459_length_196_cov_1.987578_g13329_i0	PRJEB14664	13459	196	1.987578	3.89565288	Chlamydiales bacterium	2047757	Bacteria	Bacteria	109	1.04e-28	NR	MCP5470421.1	2047757	g13329	i0	81.3	0.979591836734694	64	12	98	0	194	3	58	121	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	192	109	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32814289	32814289	PRJEB14664_P_NODE_11540_length_219_cov_1.521739_g11410_i0	PRJEB14664	11540	219	1.521739	3.33260841	Chlamydiales bacterium	2047757	Bacteria	Bacteria	86.3	2.45e-19	NR	MCP5470421.1	2047757	g11410	i0	52.8	3.89041095890411	72	34	98.6	0	217	2	48	119	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	852	86.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;