metadata: contig_metadata: 23 rows where bioproject = "PRJNA274362" and tax

23 rows where bioproject = "PRJNA274362" 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
5474199	5474199	PRJNA274362_S_NODE_3585_length_437_cov_1.729381_g3465_i0	PRJNA274362	3585	437	1.729381	7.55739497	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	403	1.0099999999999999e-107	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g3465	i0	83.916	314.851258581236	429	61	97	8	14	437	27396	26971	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	137590	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6748156	6748156	PRJNA274362_S_NODE_1886_length_586_cov_1.897579_g1777_i0	PRJNA274362	1886	586	1.897579	11.11981294	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	564	6.019999999999998e-156	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1777	i0	86.398	172.081911262799	522	64	89	7	68	586	16603	16086	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	100840	564	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6748474	6748474	PRJNA274362_S_NODE_33986_length_166_cov_1.333333_g33866_i0	PRJNA274362	33986	166	1.333333	2.21333278	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	241	2.76e-59	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g33866	i0	92.771	17	166	12	100	0	1	166	3412725	3412890	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	2822	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
7436529	7436529	PRJNA274362_S_NODE_28826_length_177_cov_0.984375_g28706_i0	PRJNA274362	28826	177	0.984375	1.74234375	Humisphaera	2807511	Bacteria	Bacteria	213	6.48e-51	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g28706	i0	89.881	19.6214689265537	168	13	95	3	10	177	5064359	5064522	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	3473	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
8023937	8023937	PRJNA274362_S_NODE_24447_length_190_cov_1.276596_g24327_i0	PRJNA274362	24447	190	1.276596	2.4255324	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	191	3.32e-44	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g24327	i0	85.185	170.347368421053	189	25	99	1	1	189	3457518	3457333	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	32366	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
10574654	10574654	PRJNA274362_S_NODE_27989_length_179_cov_1.200000_g27869_i0	PRJNA274362	27989	179	1.2	2.148	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	243	8.379999999999999e-60	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g27869	i0	91.16	13.0502793296089	181	13	100	3	1	179	1316260	1316439	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	2336	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10574766	10574766	PRJNA274362_S_NODE_34169_length_166_cov_1.094017_g34049_i0	PRJNA274362	34169	166	1.094017	1.81606822	Aureliella helgolandensis	2527968	Bacteria	Bacteria	268	1.27e-67	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g34049	i0	95.808	135.789156626506	167	5	100	2	1	166	6999501	6999666	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	22541	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
12537093	12537093	PRJNA274362_S_NODE_20230_length_205_cov_1.423077_g20110_i0	PRJNA274362	20230	205	1.423077	2.91730785	Lacipirellula	2691417	Bacteria	Bacteria	303	4.48e-78	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g20110	i0	95.745	199.887804878049	188	8	92	0	1	188	5171426	5171613	Lacipirellula limnantheis strain I41 chromosome	blastn	40977	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
14399435	14399435	PRJNA274362_S_NODE_17492_length_217_cov_2.613095_g17372_i0	PRJNA274362	17492	217	2.613095	5.67041615	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	333	6.109999999999999e-87	NTclustered	gi\|430803024\|gb\|KC011133.1\|	120965	g17372	i0	100	83.6635944700461	180	0	97	0	1	180	698	877	Uncultured planctomycete clone bsc34 16S ribosomal RNA gene, partial sequence	blastn	18155	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14399727	14399727	PRJNA274362_S_NODE_32192_length_169_cov_0.866667_g32072_i0	PRJNA274362	32192	169	0.866667	1.46466723	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g32072	i0	93.491	240.692307692308	169	9	100	2	1	169	3831306	3831472	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	40677	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15673245	15673245	PRJNA274362_S_NODE_22813_length_195_cov_1.684932_g22693_i0	PRJNA274362	22813	195	1.684932	3.2856174	Pirellulales bacterium	2715253	Bacteria	Bacteria	230	7.249999999999999e-56	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g22693	i0	90.698	122.34358974359	172	16	88	0	24	195	314042	313871	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	23857	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
18221999	18221999	PRJNA274362_S_NODE_11215_length_262_cov_2.835681_g11095_i0	PRJNA274362	11215	262	2.835681	7.42948422	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	370	5.81e-98	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g11095	i0	94.915	284.248091603053	236	12	90	0	1	236	17789	17554	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	74473	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18222052	18222052	PRJNA274362_S_NODE_14275_length_237_cov_1.250000_g14155_i0	PRJNA274362	14275	237	1.25	2.9625	Adhaeretor mobilis	1930276	Bacteria	Bacteria	327	3.16e-85	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g14155	i0	92.544	105.151898734177	228	17	96	0	3	230	3977295	3977522	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	24921	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
19496473	19496473	PRJNA274362_S_NODE_21716_length_199_cov_1.733333_g21596_i0	PRJNA274362	21716	199	1.733333	3.44933267	Planctomycetales bacterium	2053591	Bacteria	Bacteria	124	8.859999999999999e-32	NR	MBI5761395.1	2053591	g21596	i0	90.8	13.7185929648241	65	6	98	0	197	3	41	105	MBI5761395.1 adenosylhomocysteinase [Planctomycetales bacterium]	diamond	2730	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
24010548	24010548	PRJNA274362_S_NODE_3579_length_437_cov_2.131443_g3459_i0	PRJNA274362	3579	437	2.131443	9.31440591	Chthoniobacter	295577	Bacteria	Bacteria	584	3.3699999999999986e-162	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g3459	i0	91.055	150.398169336384	436	34	99	5	1	434	15614	16046	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	65724	584	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
27186412	27186412	PRJNA274362_S_NODE_34462_length_166_cov_0.888889_g34342_i0	PRJNA274362	34462	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	55.1	5.62e-7	NR	MBC04340.1	2026778	g34342	i0	53.7	2.92771084337349	54	24	95.8	1	161	3	54	107	MBC04340.1 hypothetical protein [Phycisphaerae bacterium]	diamond	486	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
28084674	28084674	PRJNA274362_S_NODE_23285_length_194_cov_0.882759_g23165_i0	PRJNA274362	23285	194	0.882759	1.71255246	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.8	0.00152	NR	PYJ00909.1	2026799	g23165	i0	54.1	2.33505154639175	37	16	55.7	1	176	69	258	294	PYJ00909.1 MAG: alpha/beta hydrolase [Verrucomicrobiota bacterium]	diamond	453	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30705847	30705847	PRJNA274362_S_NODE_32774_length_168_cov_0.873950_g32654_i0	PRJNA274362	32774	168	0.87395	1.468236	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	60.1	1e-8	NR	HOW97165.1	2212473	g32654	i0	54	1.83928571428571	50	23	89.3	0	164	15	417	466	HOW97165.1 AmmeMemoRadiSam system protein B [Kiritimatiellia bacterium]	diamond	309	60.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30944974	30944974	PRJNA274362_S_NODE_37474_length_162_cov_0.920354_g37354_i0	PRJNA274362	37474	162	0.920354	1.49097348	Bacteria	2	Bacteria	Bacteria	44.3	0.00355	NR	MCK4342298.1	2026778	g37354	i0	65.5	1.12962962962963	29	9	51.9	1	9	92	1251	1279	MCK4342298.1 HYR domain-containing protein [Phycisphaerae bacterium]	diamond	183	44.7	0.991051454138702	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31591244	31591244	PRJNA274362_S_NODE_32856_length_168_cov_0.873950_g32736_i0	PRJNA274362	32856	168	0.87395	1.468236	Rosistilla carotiformis	2528017	Bacteria	Bacteria	43.9	0.00528	NR	WP_145100387.1	2528017	g32736	i0	47.3	0.982142857142857	55	26	96.4	2	167	6	191	243	WP_145100387.1 DUF11 domain-containing protein [Rosistilla carotiformis]	diamond	165	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla carotiformis
32477071	32477071	PRJNA274362_S_NODE_18939_length_211_cov_0.907407_g18819_i0	PRJNA274362	18939	211	0.907407	1.91462877	Aquisphaera insulae	2712864	Bacteria	Bacteria	58.5	6.69e-8	NR	WP_165234168.1	2712864	g18819	i0	47.3	0.781990521327014	55	29	78.2	0	192	28	379	433	WP_165234168.1 sigma-70 family RNA polymerase sigma factor [Aquisphaera insulae]	diamond	165	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
32540424	32540424	PRJNA274362_S_NODE_23079_length_194_cov_1.765517_g22959_i0	PRJNA274362	23079	194	1.765517	3.42510298	Limisphaera ngatamarikiensis	1324935	Bacteria	Bacteria	97.4	2.32e-22	NR	WP_165108057.1	1324935	g22959	i0	74.6	3.92783505154639	63	16	97.4	0	192	4	12	74	WP_165108057.1 malate dehydrogenase [Limisphaera ngatamarikiensis]	diamond	762	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera ngatamarikiensis
32760679	32760679	PRJNA274362_S_NODE_11480_length_260_cov_1.355450_g11360_i0	PRJNA274362	11480	260	1.35545	3.52417	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	46.2	0.00278	NR	NQU40615.1	1932692	g11360	i0	54.1	0.807692307692308	37	17	42.7	0	23	133	385	421	NQU40615.1 glycosyltransferase [Lentisphaerota bacterium]	diamond	210	46.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;