metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA316313" 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
387399	387399	PRJNA316313_P_NODE_351361_length_178_cov_1.914894_g349975_i0	PRJNA316313	351361	178	1.914894	3.40851132	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	65.8	1.93e-6	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g349975	i0	90	0.280898876404494	50	5	28	0	103	152	2097617	2097666	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	50	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
388152	388152	PRJNA316313_P_NODE_473541_length_151_cov_2.929825_g472155_i0	PRJNA316313	473541	151	2.929825	4.42403575	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	122	9.26e-24	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g472155	i0	81.699	6.70860927152318	153	22	99	4	3	151	1758369	1758519	Planctomycetes bacterium MalM25 chromosome	blastn	1013	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
1661222	1661222	PRJNA316313_P_NODE_205642_length_187_cov_3.373333_g204256_i0	PRJNA316313	205642	187	3.373333	6.30813271	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g204256	i0	87.273	0.294117647058824	55	7	29	0	133	187	3862222	3862168	Tautonia plasticadhaerens strain ElP chromosome	blastn	55	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
3619076	3619076	PRJNA316313_P_NODE_443743_length_151_cov_3.824561_g442357_i0	PRJNA316313	443743	151	3.824561	5.77508711	Botrimarina	2795782	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g442357	i0	100	2.02649006622517	76	0	100	0	76	151	1737546	1737621	Planctomycetes bacterium K2D chromosome, complete genome	blastn	306	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
4215320	4215320	PRJNA316313_P_NODE_454544_length_151_cov_3.421053_g453158_i0	PRJNA316313	454544	151	3.421053	5.16579003	Gemmataceae bacterium	2052164	Bacteria	Bacteria	145	1.98e-30	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g453158	i0	100	1.02649006622517	78	0	100	0	74	151	7045610	7045687	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	155	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
4895395	4895395	PRJNA316313_P_NODE_203584_length_187_cov_3.400000_g202198_i0	PRJNA316313	203584	187	3.4	6.358	Gimesia	1649453	Bacteria	Bacteria	69.4	1.59e-7	NTclustered	gi\|1712536321\|gb\|CP036341.1\|	122	g202198	i0	100	0.593582887700535	37	0	20	0	40	76	241395	241359	Gimesia maris strain Mal35 chromosome	blastn	111	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
8040081	8040081	PRJNA316313_P_NODE_254067_length_187_cov_2.806667_g252681_i0	PRJNA316313	254067	187	2.806667	5.24846729	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	130	7.19e-26	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g252681	i0	97.368	32.5187165775401	76	2	81	0	1	76	3522489	3522414	Luteolibacter sp. SL250 chromosome	blastn	6081	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
9314354	9314354	PRJNA316313_P_NODE_167928_length_187_cov_4.066667_g166542_i0	PRJNA316313	167928	187	4.066667	7.60466729	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	97.1	7.29e-16	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g166542	i0	92.537	1.62032085561497	67	5	36	0	10	76	2961205	2961139	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	303	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
10589930	10589930	PRJNA316313_P_NODE_134209_length_187_cov_5.900000_g132823_i0	PRJNA316313	134209	187	5.9	11.033	Humisphaera borealis	2807512	Bacteria	Bacteria	119	1.56e-22	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g132823	i0	94.737	28.7379679144385	76	4	41	0	1	76	4390203	4390278	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	5374	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
10591020	10591020	PRJNA316313_P_NODE_334729_length_186_cov_2.644295_g333343_i0	PRJNA316313	334729	186	2.644295	4.9183887	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	65.8	2.04e-6	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g333343	i0	91.667	0.440860215053763	48	3	26	1	112	159	1797254	1797300	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	82	65.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
10591997	10591997	PRJNA316313_P_NODE_504289_length_150_cov_3.212389_g502903_i0	PRJNA316313	504289	150	3.212389	4.8185835	Lacipirellula parvula	2650471	Bacteria	Bacteria	52.8	0.012	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g502903	i0	100	0.186666666666667	28	0	19	0	113	140	5729968	5729941	Lacipirellula parvula PX69 DNA, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
11864867	11864867	PRJNA316313_P_NODE_14210_length_445_cov_3.634804_g12890_i0	PRJNA316313	14210	445	3.634804	16.1748778	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	117	1.51e-21	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12890	i0	85.714	0.339325842696629	112	14	25	2	335	445	1237639	1237749	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	151	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
12546136	12546136	PRJNA316313_P_NODE_231870_length_187_cov_3.033333_g230484_i0	PRJNA316313	231870	187	3.033333	5.67233271	Akkermansia	239934	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2289586829\|dbj\|AP025943.1\|	2946555	g230484	i0	100	4.81283422459893	76	0	80	0	1	76	963281	963356	Akkermansia biwaensis WON2089 DNA, complete genome	blastn	900	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia biwaensis
13141800	13141800	PRJNA316313_P_NODE_485231_length_150_cov_5.097345_g483845_i0	PRJNA316313	485231	150	5.097345	7.6460175	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	154	3.26e-33	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g483845	i0	85.065	1.02666666666667	154	19	100	1	1	150	436369	436522	Pirellula sp. SH-Sr6A, complete genome	blastn	154	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15688934	15688934	PRJNA316313_P_NODE_148333_length_187_cov_4.766667_g146947_i0	PRJNA316313	148333	187	4.766667	8.91366729	Akkermansia muciniphila	239935	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2240218473\|gb\|CP097283.1\|	239935	g146947	i0	100	55.1122994652406	76	0	81	0	112	187	2563762	2563687	Akkermansia muciniphila strain NB2A-8-WC chromosome	blastn	10306	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
15689190	15689190	PRJNA316313_P_NODE_200453_length_187_cov_3.440000_g199067_i0	PRJNA316313	200453	187	3.44	6.4328	Limnoglobus roseus	2598579	Bacteria	Bacteria	75	3.42e-9	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g199067	i0	93.878	2.03208556149733	49	3	26	0	28	76	7245418	7245370	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	380	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16964245	16964245	PRJNA316313_P_NODE_262854_length_187_cov_2.686667_g261468_i0	PRJNA316313	262854	187	2.686667	5.02406729	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	91.6	3.39e-14	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g261468	i0	89.041	2.20855614973262	73	8	76	0	115	187	2426021	2425949	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	413	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16964565	16964565	PRJNA316313_P_NODE_320234_length_187_cov_2.240000_g318848_i0	PRJNA316313	320234	187	2.24	4.1888	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	135	1.55e-27	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g318848	i0	98.684	0.812834224598931	76	1	81	0	1	76	3969647	3969722	Luteolibacter sp. SL250 chromosome	blastn	152	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
19512375	19512375	PRJNA316313_P_NODE_178376_length_187_cov_3.833333_g176990_i0	PRJNA316313	178376	187	3.833333	7.16833271	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	117	5.600000000000001e-22	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g176990	i0	95.833	0.550802139037433	72	3	39	0	112	183	2965268	2965197	Planctomyces sp. SH-PL62, complete genome	blastn	103	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19512485	19512485	PRJNA316313_P_NODE_202536_length_187_cov_3.413333_g201150_i0	PRJNA316313	202536	187	3.413333	6.38293271	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	73.1	1.23e-8	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g201150	i0	89.474	0.304812834224599	57	6	30	0	113	169	2252727	2252783	Planctomyces sp. SH-PL62, complete genome	blastn	57	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
19513252	19513252	PRJNA316313_P_NODE_341536_length_183_cov_6.294521_g340150_i0	PRJNA316313	341536	183	6.294521	11.51897343	Roseimaritima ulvae	980254	Bacteria	Bacteria	63.9	7.2e-6	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g340150	i0	93.182	0.240437158469945	44	1	23	2	39	81	4941787	4941745	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	44	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
19513257	19513257	PRJNA316313_P_NODE_342316_length_183_cov_3.657534_g340930_i0	PRJNA316313	342316	183	3.657534	6.69328722	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	117	5.45e-22	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g340930	i0	78.836	7.24590163934426	189	28	100	11	1	183	4707125	4707307	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	1326	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20788535	20788535	PRJNA316313_P_NODE_295217_length_187_cov_2.460000_g293831_i0	PRJNA316313	295217	187	2.46	4.6002	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g293831	i0	100	0.149732620320856	28	0	15	0	128	155	1465697	1465670	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21469727	21469727	PRJNA316313_P_NODE_319797_length_187_cov_2.246667_g318411_i0	PRJNA316313	319797	187	2.246667	4.20126729	Planctomycetia	203683	Bacteria	Bacteria	124	3.34e-24	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g318411	i0	96.053	17.4705882352941	76	3	41	0	1	76	3909201	3909126	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	3267	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22062598	22062598	PRJNA316313_P_NODE_130958_length_187_cov_6.620000_g129572_i0	PRJNA316313	130958	187	6.62	12.3794	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g129572	i0	100	0.149732620320856	28	0	15	0	38	65	2320361	2320388	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
22063656	22063656	PRJNA316313_P_NODE_321698_length_187_cov_2.213333_g320312_i0	PRJNA316313	321698	187	2.213333	4.13893271	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	67.6	5.72e-7	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g320312	i0	90.196	0.272727272727273	51	5	27	0	1	51	6030870	6030920	Tautonia plasticadhaerens strain ElP chromosome	blastn	51	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
22064610	22064610	PRJNA316313_P_NODE_486098_length_150_cov_4.920354_g484712_i0	PRJNA316313	486098	150	4.920354	7.380531	Pirellulales bacterium	2715253	Bacteria	Bacteria	104	3.33e-18	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g484712	i0	90.909	19.4266666666667	77	7	51	0	74	150	2656546	2656470	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	2914	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
22744450	22744450	PRJNA316313_P_NODE_202378_length_187_cov_3.413333_g200992_i0	PRJNA316313	202378	187	3.413333	6.38293271	Planctomycetia	203683	Bacteria	Bacteria	91.6	3.39e-14	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g200992	i0	92.188	1.02673796791444	64	5	35	0	1	64	1866043	1865980	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	192	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23340576	23340576	PRJNA316313_P_NODE_87659_length_215_cov_4.522472_g86273_i0	PRJNA316313	87659	215	4.522472	9.7233148	Haloferula helveola	490095	Bacteria	Bacteria	100	6.67e-17	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g86273	i0	93.939	27.0744186046512	66	4	31	0	18	83	2865103	2865168	Haloferula helveola CN-1 DNA, complete genome	blastn	5821	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
24613268	24613268	PRJNA316313_P_NODE_304920_length_187_cov_2.393333_g303534_i0	PRJNA316313	304920	187	2.393333	4.47553271	Urbifossiella limnaea	2528023	Bacteria	Bacteria	65.8	2.06e-6	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g303534	i0	86.885	0.556149732620321	61	4	32	2	16	74	1400181	1400239	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	104	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24613349	24613349	PRJNA316313_P_NODE_318420_length_187_cov_2.266667_g317034_i0	PRJNA316313	318420	187	2.266667	4.23866729	Actomonas aquatica	2866162	Bacteria	Bacteria	60.2	9.57e-5	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g317034	i0	92.683	0.219251336898396	41	3	22	0	4	44	2831933	2831973	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	41	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica

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