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

23 rows where analysis = "blastn", bioproject = "PRJNA494251" 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
3658108	3658108	PRJNA494251_P_NODE_6803_length_498_cov_3.214118_g6501_i0	PRJNA494251	6803	498	3.214118	16.00630764	Botrimarina	2795782	Bacteria	Bacteria	65.8	6.25e-6	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g6501	i0	91.667	2.42771084337349	48	2	9	2	11	57	1763634	1763680	Planctomycetes bacterium K2D chromosome, complete genome	blastn	1209	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
4302050	4302050	PRJNA494251_P_NODE_16764_length_341_cov_1.720149_g16451_i0	PRJNA494251	16764	341	1.720149	5.86570809	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	472	2.09e-128	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g16451	i0	91.643	234.944281524927	347	19	100	9	1	341	1156227	1155885	Planctomyces sp. SH-PL62, complete genome	blastn	80116	472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
6853121	6853121	PRJNA494251_P_NODE_42426_length_247_cov_0.758621_g42112_i0	PRJNA494251	42426	247	0.758621	1.87379387	Lacipirellula parvula	2650471	Bacteria	Bacteria	263	9.47e-66	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g42112	i0	86.179	167.943319838057	246	30	99	4	1	244	5164003	5163760	Lacipirellula parvula PX69 DNA, complete genome	blastn	41482	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
8128223	8128223	PRJNA494251_P_NODE_18887_length_325_cov_1.535714_g18573_i0	PRJNA494251	18887	325	1.535714	4.9910705	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	385	2.65e-102	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g18573	i0	88.11	73.5476923076923	328	33	100	6	1	325	2190808	2191132	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	23903	385	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
8128584	8128584	PRJNA494251_P_NODE_50967_length_233_cov_6.625000_g50653_i0	PRJNA494251	50967	233	6.625	15.43625	Polystyrenella longa	2528007	Bacteria	Bacteria	287	5.25e-73	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g50653	i0	89.427	238.394849785408	227	24	97	0	1	227	1415497	1415723	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	55546	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
8128623	8128623	PRJNA494251_P_NODE_6267_length_518_cov_1.035955_g5967_i0	PRJNA494251	6267	518	1.035955	5.3662469	Phycisphaera sp.	2030824	Bacteria	Bacteria	141	1.05e-28	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g5967	i0	83.553	28.1119691119691	152	23	29	2	29	179	2389431	2389281	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	14562	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
9403302	9403302	PRJNA494251_P_NODE_29708_length_273_cov_1.305000_g29394_i0	PRJNA494251	29708	273	1.305	3.56265	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	460	3.5099999999999996e-125	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g29394	i0	97.07	232.673992673993	273	8	100	0	1	273	17221	16949	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	63520	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9403473	9403473	PRJNA494251_P_NODE_46308_length_243_cov_2.152941_g45994_i0	PRJNA494251	46308	243	2.152941	5.23164663	Urbifossiella limnaea	2528023	Bacteria	Bacteria	337	5.399999999999998e-88	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g45994	i0	94.118	140.127572016461	221	13	91	0	5	225	2018410	2018190	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	34051	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10678852	10678852	PRJNA494251_P_NODE_23149_length_300_cov_0.973568_g22835_i0	PRJNA494251	23149	300	0.973568	2.920704	Rohdeia mirabilis	2528008	Bacteria	Bacteria	331	3.2e-86	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g22835	i0	88.889	25.7133333333333	270	29	90	1	23	291	3892860	3893129	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	7714	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
10679054	10679054	PRJNA494251_P_NODE_39369_length_249_cov_0.875000_g39055_i0	PRJNA494251	39369	249	0.875	2.17875	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	115	2.83e-21	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g39055	i0	100	0.248995983935743	62	0	25	0	171	232	4622546	4622485	Lacipirellula limnantheis strain I41 chromosome	blastn	62	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
11310015	11310015	PRJNA494251_P_NODE_24389_length_294_cov_0.814480_g24075_i0	PRJNA494251	24389	294	0.81448	2.3945712	Phycisphaerae	666505	Bacteria	Bacteria	444	3.85e-120	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g24075	i0	93.878	332.636054421769	294	18	100	0	1	294	1832305	1832598	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	97795	444	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
11954014	11954014	PRJNA494251_P_NODE_25610_length_288_cov_1.772093_g25296_i0	PRJNA494251	25610	288	1.772093	5.10362784	Singulisphaera acidiphila	466153	Bacteria	Bacteria	322	1.84e-83	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g25296	i0	89.015	72.7048611111111	264	23	91	4	18	279	4645394	4645135	Singulisphaera acidiphila DSM 18658, complete genome	blastn	20939	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
14504157	14504157	PRJNA494251_P_NODE_38112_length_250_cov_0.870056_g37798_i0	PRJNA494251	38112	250	0.870056	2.17514	Sedimentisphaera cyanobacteriorum	1940790	Bacteria	Bacteria	121	6.12e-23	NTclustered	gi\|1146072971\|gb\|CP019633.1\|	1940790	g37798	i0	76.336	5.892	262	41	100	18	1	250	344764	345016	Sedimentisphaera cyanobacteriorum strain L21-RPul-D3 chromosome, complete genome	blastn	1473	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae	Sedimentisphaera	Sedimentisphaera cyanobacteriorum
16409498	16409498	PRJNA494251_P_NODE_11613_length_397_cov_1.814815_g11307_i0	PRJNA494251	11613	397	1.814815	7.20481555	Waddlia	71666	Bacteria	Bacteria	350	1.2e-91	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g11307	i0	86.103	188.874055415617	331	39	83	5	2	329	1188	1514	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	74983	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
17052490	17052490	PRJNA494251_P_NODE_17154_length_338_cov_1.562264_g16841_i0	PRJNA494251	17154	338	1.562264	5.28045232	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	76.8	1.89e-9	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g16841	i0	85.915	0.902366863905325	71	10	21	0	238	308	2050409	2050339	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	305	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
18326813	18326813	PRJNA494251_P_NODE_17995_length_331_cov_2.162791_g17681_i0	PRJNA494251	17995	331	2.162791	7.15883821	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	353	7.63e-93	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17681	i0	87.5	102.703927492447	312	32	93	6	3	311	1866211	1866518	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	33995	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18326878	18326878	PRJNA494251_P_NODE_22675_length_302_cov_1.524017_g22361_i0	PRJNA494251	22675	302	1.524017	4.60253134	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	424	5.17e-114	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g22361	i0	92.079	140.41059602649	303	21	100	2	1	302	4317609	4317309	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	42404	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19601121	19601121	PRJNA494251_P_NODE_21896_length_306_cov_1.939914_g21582_i0	PRJNA494251	21896	306	1.939914	5.93613684	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	213	1.24e-50	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g21582	i0	79.412	1.87581699346405	306	59	99	4	1	304	2178210	2178513	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	574	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19601209	19601209	PRJNA494251_P_NODE_28436_length_277_cov_2.975490_g28122_i0	PRJNA494251	28436	277	2.97549	8.2421073	Urbifossiella limnaea	2528023	Bacteria	Bacteria	300	8.24e-77	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g28122	i0	90.393	111.848375451264	229	20	82	2	13	240	2018059	2017832	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	30982	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20876916	20876916	PRJNA494251_P_NODE_17697_length_334_cov_1.084291_g17383_i0	PRJNA494251	17697	334	1.084291	3.62153194	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	294	4.74e-75	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17383	i0	86.182	100.18862275449101	275	35	82	2	60	333	1867559	1867287	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	33463	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20877032	20877032	PRJNA494251_P_NODE_25697_length_288_cov_1.325581_g25383_i0	PRJNA494251	25697	288	1.325581	3.81767328	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	76.8	1.58e-9	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g25383	i0	83.75	0.277777777777778	80	13	28	0	1	80	3513331	3513252	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	80	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20877283	20877283	PRJNA494251_P_NODE_44957_length_244_cov_3.567251_g44643_i0	PRJNA494251	44957	244	3.567251	8.70409244	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|443301411\|emb\|HE613588.1\|	120965	g44643	i0	99.59	99.5983606557377	244	1	100	0	1	244	748	505	Uncultured planctomycete partial 16S rRNA gene, clone H100B0W9	blastn	24302	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
23427598	23427598	PRJNA494251_P_NODE_18259_length_329_cov_3.031250_g17945_i0	PRJNA494251	18259	329	3.03125	9.9728125	Pedosphaera parvula	1032527	Bacteria	Bacteria	326	1.65e-84	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g17945	i0	86.23	104.212765957447	305	36	91	6	1	301	5	307	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	34286	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula

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