metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA278119" 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
2334173	2334173	PRJNA278119_P_NODE_7222_length_443_cov_1.319797_g6975_i0	PRJNA278119	7222	443	1.319797	5.84670071	Bacteria	2	Bacteria	Bacteria	544	5.8e-150	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g6975	i0	89.318	115.939051918736	440	37	98	10	6	440	2583492	2583926	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	51361	544	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2921960	2921960	PRJNA278119_P_NODE_30443_length_179_cov_2.761538_g30194_i0	PRJNA278119	30443	179	2.761538	4.94315302	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	243	8.379999999999999e-60	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g30194	i0	92.899	182.262569832402	169	9	93	3	1	167	2059353	2059520	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32625	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
2922258	2922258	PRJNA278119_P_NODE_8063_length_418_cov_1.268293_g7816_i0	PRJNA278119	8063	418	1.268293	5.30146474	Waddlia malaysiensis	219016	Bacteria	Bacteria	431	4.419999999999998e-116	NTclustered	gi\|27903501\|gb\|AY184804.1\|	219016	g7816	i0	85.681	202.167464114833	426	42	100	17	1	418	1772	2186	Waddlia sp. G817 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	84506	431	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia malaysiensis
3609450	3609450	PRJNA278119_P_NODE_4763_length_551_cov_1.364542_g4519_i0	PRJNA278119	4763	551	1.364542	7.51862642	Bacteria	2	Bacteria	Bacteria	462	2.1099999999999999e-125	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4519	i0	82.033	386.444646098004	551	91	99	8	5	551	2001738	2002284	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	212931	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4198120	4198120	PRJNA278119_P_NODE_11324_length_343_cov_2.693878_g11076_i0	PRJNA278119	11324	343	2.693878	9.24000154	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	617	2.55e-172	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g11076	i0	99.125	101.661807580175	343	3	100	0	1	343	1249089	1249431	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	34870	617	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
4198722	4198722	PRJNA278119_P_NODE_9564_length_379_cov_2.351515_g9317_i0	PRJNA278119	9564	379	2.351515	8.91224185	Stieleria magnilauensis	2527963	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g9317	i0	100	0.0765171503957784	29	0	8	0	227	255	3127751	3127779	Planctomycetes bacterium TBK1r chromosome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
5474931	5474931	PRJNA278119_P_NODE_5825_length_494_cov_1.948315_g5579_i0	PRJNA278119	5825	494	1.948315	9.6246761	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	503	1.11e-137	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g5579	i0	85.193	161.714574898785	493	69	99	4	2	493	2583948	2584437	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	79887	503	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
5474978	5474978	PRJNA278119_P_NODE_8705_length_400_cov_2.165242_g8458_i0	PRJNA278119	8705	400	2.165242	8.660968	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	422	2.54e-113	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g8458	i0	88.539	256.775	349	38	87	2	53	400	2192397	2192050	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	102710	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
10575242	10575242	PRJNA278119_P_NODE_28849_length_184_cov_1.540741_g28600_i0	PRJNA278119	28849	184	1.540741	2.83496344	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	233	5.22e-57	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g28600	i0	91.279	268.260869565217	172	13	99	2	14	184	653752	653582	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	49360	233	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11849832	11849832	PRJNA278119_P_NODE_2510_length_774_cov_1.750345_g2290_i0	PRJNA278119	2510	774	1.750345	13.5476703	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1208	0	NTclustered	gi\|389546986\|gb\|JQ401914.1\|	100233	g2290	i0	95.503	99.5813953488372	756	34	98	0	1	756	4	759	Uncultured Planctomycetaceae bacterium clone CNY_02145 16S ribosomal RNA gene, partial sequence	blastn	77076	1208	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11850171	11850171	PRJNA278119_P_NODE_5890_length_491_cov_3.665158_g5644_i0	PRJNA278119	5890	491	3.665158	17.99592578	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	902	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g5644	i0	99.796	115.399185336049	491	1	100	0	1	491	1251589	1251099	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	56661	902	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14400169	14400169	PRJNA278119_P_NODE_22832_length_207_cov_1.031646_g22583_i0	PRJNA278119	22832	207	1.031646	2.13550722	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	230	7.7999999999999985e-56	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g22583	i0	89.247	92.9420289855072	186	16	90	2	5	190	3832565	3832384	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	19239	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14400251	14400251	PRJNA278119_P_NODE_28872_length_184_cov_1.540741_g28623_i0	PRJNA278119	28872	184	1.540741	2.83496344	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	244	2.41e-60	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g28623	i0	91.16	105.66847826087	181	14	98	2	1	180	989080	989259	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	19443	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14400568	14400568	PRJNA278119_P_NODE_7852_length_424_cov_1.818667_g7605_i0	PRJNA278119	7852	424	1.818667	7.71114808	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	383	1.2799999999999998e-101	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g7605	i0	83.295	418.129716981132	431	57	100	12	1	424	2002912	2002490	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	177287	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15086474	15086474	PRJNA278119_P_NODE_39492_length_166_cov_1.333333_g39243_i0	PRJNA278119	39492	166	1.333333	2.21333278	Planctomycetia	203683	Bacteria	Bacteria	274	2.73e-69	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g39243	i0	96.386	113.807228915663	166	6	100	0	1	166	1038085	1038250	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	18892	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
16948788	16948788	PRJNA278119_P_NODE_3754_length_623_cov_1.768293_g3516_i0	PRJNA278119	3754	623	1.768293	11.01646539	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	1016	0	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g3516	i0	96.429	106.157303370787	616	22	99	0	6	621	2497075	2497690	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	66136	1016	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
18223109	18223109	PRJNA278119_P_NODE_39395_length_166_cov_1.333333_g39146_i0	PRJNA278119	39395	166	1.333333	2.21333278	Actomonas aquatica	2866162	Bacteria	Bacteria	75	2.97e-9	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g39146	i0	97.674	0.259036144578313	43	1	26	0	10	52	1672679	1672637	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	43	75	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
19497255	19497255	PRJNA278119_P_NODE_31296_length_177_cov_1.617188_g31047_i0	PRJNA278119	31296	177	1.617188	2.86242276	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	248	1.7799999999999998e-61	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g31047	i0	92.09	15	177	12	100	2	1	177	1830328	1830502	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	2655	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
20185002	20185002	PRJNA278119_P_NODE_7876_length_423_cov_2.639037_g7629_i0	PRJNA278119	7876	423	2.639037	11.16312651	Gemmataceae	1914233	Bacteria	Bacteria	460	5.71e-125	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g7629	i0	86.62	229.919621749409	426	46	99	10	1	421	1303	1722	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	97256	462	0.995670995670996	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
20772953	20772953	PRJNA278119_P_NODE_45637_length_163_cov_0.912281_g45388_i0	PRJNA278119	45637	163	0.912281	1.48701803	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	176	7.73e-40	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g45388	i0	86.709	4.82822085889571	158	21	97	0	1	158	3216485	3216328	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	787	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21460463	21460463	PRJNA278119_P_NODE_1517_length_993_cov_4.096398_g1334_i0	PRJNA278119	1517	993	4.096398	40.67723214	Nibricoccus	2576890	Bacteria	Bacteria	1171	0	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g1334	i0	91.924	200.229607250755	842	61	84	7	1	838	1902491	1901653	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	198828	1182	0.990693739424704	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
22047651	22047651	PRJNA278119_P_NODE_21338_length_215_cov_1.391566_g21089_i0	PRJNA278119	21338	215	1.391566	2.9918669	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	93.5	1.12e-14	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g21089	i0	93.651	0.423255813953488	63	3	29	1	81	143	4278816	4278755	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	91	93.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
24597288	24597288	PRJNA278119_P_NODE_22900_length_207_cov_0.924051_g22651_i0	PRJNA278119	22900	207	0.924051	1.91278557	Pirellulales bacterium	2715253	Bacteria	Bacteria	230	7.7999999999999985e-56	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g22651	i0	87.192	148.217391304348	203	24	97	2	7	207	313175	312973	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	30681	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;