metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1093380" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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
199076	199076	PRJNA1093380_P_NODE_13881_length_247_cov_1.729885_g13775_i0	PRJNA1093380	13881	247	1.729885	4.27281595	Opitutus terrae	107709	Bacteria	Bacteria	237	5.74e-58	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g13775	i0	84.274	11.2550607287449	248	34	100	4	1	247	3507688	3507445	Opitutus terrae PB90-1, complete genome	blastn	2780	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
199131	199131	PRJNA1093380_P_NODE_17501_length_235_cov_2.191358_g17395_i0	PRJNA1093380	17501	235	2.191358	5.1496913	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	398	2.349999999999999e-106	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g17395	i0	99.095	299.442553191489	221	2	94	0	15	235	27211	27431	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	70369	398	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2749917	2749917	PRJNA1093380_P_NODE_6423_length_283_cov_1.100000_g6317_i0	PRJNA1093380	6423	283	1.1	3.113	Urbifossiella limnaea	2528023	Bacteria	Bacteria	276	1.4199999999999999e-69	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6317	i0	87.045	78.3003533568905	247	28	87	4	1	245	2018907	2019151	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	22159	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
5301918	5301918	PRJNA1093380_P_NODE_12005_length_251_cov_0.865169_g11899_i0	PRJNA1093380	12005	251	0.865169	2.17157419	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	422	1.4999999999999998e-113	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g11899	i0	97.189	240.02390438247	249	7	99	0	3	251	915172	915420	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	60246	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5302102	5302102	PRJNA1093380_P_NODE_925_length_575_cov_1.735060_g822_i0	PRJNA1093380	925	575	1.73506	9.976595	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	830	0	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g822	i0	92.696	207.737391304348	575	42	100	0	1	575	3454218	3453644	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	119449	830	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
6577101	6577101	PRJNA1093380_P_NODE_3046_length_345_cov_1.794118_g2940_i0	PRJNA1093380	3046	345	1.794118	6.1897071	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	571	2.0299999999999996e-158	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g2940	i0	96.522	90.4376811594203	345	12	100	0	1	345	27753	27409	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	31201	571	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
7851856	7851856	PRJNA1093380_P_NODE_1727_length_428_cov_1.636620_g1621_i0	PRJNA1093380	1727	428	1.63662	7.0047336	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	791	0	NTclustered	gi\|55975911\|gb\|AY802942.1\|	120965	g1621	i0	100	99.6144859813084	428	0	100	0	1	428	76	503	Uncultured planctomycete clone FPln-22 16S ribosomal RNA gene, partial sequence	blastn	42635	791	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
7851880	7851880	PRJNA1093380_P_NODE_307_length_1025_cov_2.407563_g234_i0	PRJNA1093380	307	1025	2.407563	24.67752075	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1485	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g234	i0	93.113	83.8546341463415	1031	44	100	13	1	1025	1315791	1316800	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	85951	1485	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9126822	9126822	PRJNA1093380_P_NODE_2388_length_375_cov_3.728477_g2282_i0	PRJNA1093380	2388	375	3.728477	13.98178875	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	649	0	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g2282	i0	97.878	158.173333333333	377	4	100	4	1	375	3454589	3454215	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	59315	649	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
11677723	11677723	PRJNA1093380_P_NODE_1430_length_462_cov_2.290488_g1325_i0	PRJNA1093380	1430	462	2.290488	10.58205456	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	776	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1325	i0	96.97	211.5670995671	462	14	100	0	1	462	5153307	5152846	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	97744	776	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14227838	14227838	PRJNA1093380_P_NODE_16752_length_241_cov_1.833333_g16646_i0	PRJNA1093380	16752	241	1.833333	4.41833253	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	307	4.1900000000000005e-79	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g16646	i0	90	6.51452282157676	250	7	100	13	1	241	1830896	1830656	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1570	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14227870	14227870	PRJNA1093380_P_NODE_2692_length_360_cov_3.027875_g2586_i0	PRJNA1093380	2692	360	3.027875	10.90035	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	593	4.519999999999998e-165	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g2586	i0	96.893	116.333333333333	354	11	98	0	1	354	7628522	7628875	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	41880	593	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
16776248	16776248	PRJNA1093380_P_NODE_2014_length_402_cov_2.577508_g1908_i0	PRJNA1093380	2014	402	2.577508	10.36158216	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	616	1.0899999999999995e-171	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g1908	i0	94.71	476.310945273632	397	19	99	2	1	396	3454578	3454973	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	191477	616	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
16776254	16776254	PRJNA1093380_P_NODE_2294_length_382_cov_1.983819_g2188_i0	PRJNA1093380	2294	382	1.983819	7.57818858	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	544	4.93e-150	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2188	i0	94.828	112.973821989529	348	18	91	0	1	348	1315425	1315078	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	43156	544	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16776326	16776326	PRJNA1093380_P_NODE_7254_length_277_cov_1.965686_g7148_i0	PRJNA1093380	7254	277	1.965686	5.44495022	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	255	1.81e-63	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g7148	i0	83.509	2.05054151624549	285	35	99	6	2	277	2924625	2924344	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	568	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18870808	18870808	PRJNA1093380_P_NODE_2575_length_366_cov_1.443686_g2469_i0	PRJNA1093380	2575	366	1.443686	5.28389076	Luteolibacter	518753	Bacteria	Bacteria	571	2.1599999999999996e-158	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g2469	i0	94.809	258.713114754098	366	19	100	0	1	366	1008768	1009133	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	94689	571	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
19324840	19324840	PRJNA1093380_P_NODE_17076_length_241_cov_0.916667_g16970_i0	PRJNA1093380	17076	241	0.916667	2.20916747	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	346	8.89e-91	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g16970	i0	92.857	85.9128630705394	238	17	99	0	4	241	627975	627738	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	20705	346	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
20600198	20600198	PRJNA1093380_P_NODE_2037_length_400_cov_1.853211_g1931_i0	PRJNA1093380	2037	400	1.853211	7.412844	Urbifossiella limnaea	2528023	Bacteria	Bacteria	575	1.8399999999999994e-159	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g1931	i0	92.556	128.4825	403	26	100	4	1	400	2019829	2019428	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	51393	575	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20600212	20600212	PRJNA1093380_P_NODE_3117_length_343_cov_1.140741_g3011_i0	PRJNA1093380	3117	343	1.140741	3.91274163	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	449	9.84e-122	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3011	i0	90.23	158.00583090379	348	29	100	3	1	343	7050955	7050608	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	54196	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20600218	20600218	PRJNA1093380_P_NODE_3597_length_325_cov_1.519841_g3491_i0	PRJNA1093380	3597	325	1.519841	4.93948325	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	383	9.53e-102	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3491	i0	88.11	166.230769230769	328	32	99	7	3	325	1315544	1315219	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	54025	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21875991	21875991	PRJNA1093380_P_NODE_1898_length_412_cov_2.477876_g1792_i0	PRJNA1093380	1898	412	2.477876	10.20884912	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	706	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1792	i0	97.573	215.06067961165	412	10	100	0	1	412	26240	25829	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	88605	706	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21876019	21876019	PRJNA1093380_P_NODE_4818_length_295_cov_1.265766_g4712_i0	PRJNA1093380	4818	295	1.265766	3.7340097	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	392	1.4199999999999998e-104	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g4712	i0	91.096	7.63050847457627	292	22	98	3	6	295	3334	3623	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	2251	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21876024	21876024	PRJNA1093380_P_NODE_5098_length_291_cov_1.059633_g4992_i0	PRJNA1093380	5098	291	1.059633	3.08353203	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	1.7600000000000003e-123	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g4992	i0	94.845	10.0549828178694	291	15	100	0	1	291	5153951	5153661	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	2926	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23151322	23151322	PRJNA1093380_P_NODE_10199_length_261_cov_1.079787_g10093_i0	PRJNA1093380	10199	261	1.079787	2.81824407	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	359	1.25e-94	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10093	i0	92.157	183.528735632184	255	18	97	2	8	261	2002781	2002528	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47901	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23151571	23151571	PRJNA1093380_P_NODE_919_length_577_cov_2.222222_g816_i0	PRJNA1093380	919	577	2.222222	12.82222094	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	983	0	NTclustered	gi\|220682213\|gb\|FJ542820.1\|	100234	g816	i0	97.405	98.6395147313691	578	13	100	2	1	577	580	4	Uncultured Verrucomicrobiales bacterium clone A02-04D 16S ribosomal RNA gene, partial sequence	blastn	56915	983	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
24425076	24425076	PRJNA1093380_P_NODE_360_length_941_cov_1.710829_g280_i0	PRJNA1093380	360	941	1.710829	16.09890089	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1408	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g280	i0	93.737	222.959617428268	942	54	99	5	1	940	28646	27708	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	209805	1408	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
24425089	24425089	PRJNA1093380_P_NODE_4440_length_304_cov_8.086580_g4334_i0	PRJNA1093380	4440	304	8.08658	24.5832032	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	318	2.53e-82	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g4334	i0	87.868	145.118421052632	272	31	89	2	2	271	7053161	7053432	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	44116	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24425131	24425131	PRJNA1093380_P_NODE_7280_length_277_cov_1.544118_g7174_i0	PRJNA1093380	7280	277	1.544118	4.27720686	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	222	1.84e-53	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7174	i0	82.182	12.8158844765343	275	33	99	7	1	275	1831181	1831439	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	3550	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales 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);;