metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA376117" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA376117" 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
399987	399987	PRJNA376117_P_NODE_34741_length_250_cov_1.305085_g34439_i0	PRJNA376117	34741	250	1.305085	3.2627125	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	1.19e-94	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g34439	i0	93.75	95.064	240	13	95	2	1	238	1315557	1315318	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	23766	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
400062	400062	PRJNA376117_P_NODE_39341_length_246_cov_0.890173_g39039_i0	PRJNA376117	39341	246	0.890173	2.18982558	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	110	1.3e-19	NTclustered	gi\|2814788363\|emb\|OY780964.2\|	2691551	g39039	i0	83.065	2.58130081300813	124	18	49	3	2	122	1419012	1418889	MAG: Thermoguttaceae bacterium isolate 5d2646e0-01ad-46f9-a460-09296c79865c genome assembly, chromosome: 1	blastn	635	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
1073583	1073583	PRJNA376117_P_NODE_11821_length_393_cov_2.990625_g11519_i0	PRJNA376117	11821	393	2.990625	11.75315625	Pirellulaceae	2691357	Bacteria	Bacteria	446	1.4799999999999999e-120	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g11519	i0	87.186	114.068702290076	398	43	100	7	1	393	1131	1525	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	44829	448	0.995535714285714	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
1674846	1674846	PRJNA376117_P_NODE_8542_length_459_cov_4.556995_g8240_i0	PRJNA376117	8542	459	4.556995	20.91660705	Lignipirellula cremea	2528010	Bacteria	Bacteria	597	4.559999999999998e-166	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g8240	i0	90.175	129.56862745098	458	45	99	0	2	459	1144450	1144907	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	59472	597	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
2950632	2950632	PRJNA376117_P_NODE_37343_length_248_cov_0.880000_g37041_i0	PRJNA376117	37343	248	0.88	2.1824	uncultured verrucomicrobium HF0070_15G23	723594	Bacteria	Bacteria	93.5	1.32e-14	NTclustered	gi\|297170473\|gb\|GU567957.1\|	723594	g37041	i0	77.64	5.33870967741935	161	31	64	4	33	190	16163	16005	Uncultured verrucomicrobium HF0070_15G23 genomic sequence	blastn	1324	93.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured verrucomicrobium HF0070_15G23
2950668	2950668	PRJNA376117_P_NODE_39643_length_246_cov_0.890173_g39341_i0	PRJNA376117	39643	246	0.890173	2.18982558	Aureliella helgolandensis	2527968	Bacteria	Bacteria	195	3.49e-45	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g39341	i0	84.314	102.837398373984	204	27	82	5	1	202	6998852	6999052	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	25298	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
8052863	8052863	PRJNA376117_P_NODE_10187_length_421_cov_2.436782_g9885_i0	PRJNA376117	10187	421	2.436782	10.25885222	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	617	3.19e-172	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g9885	i0	93.128	79.5914489311164	422	27	100	2	1	421	5152796	5152376	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33508	617	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8053253	8053253	PRJNA376117_P_NODE_38087_length_247_cov_0.885057_g37785_i0	PRJNA376117	38087	247	0.885057	2.18609079	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	73.1	1.71e-8	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g37785	i0	93.75	0.194331983805668	48	3	19	0	165	212	3730605	3730558	Planctomyces sp. SH-PL14, complete genome	blastn	48	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
8726338	8726338	PRJNA376117_P_NODE_24127_length_285_cov_2.858491_g23825_i0	PRJNA376117	24127	285	2.858491	8.14669935	Neochlamydia	112987	Bacteria	Bacteria	342	1.4e-89	NTclustered	gi\|29569597\|gb\|AY225593.1\|	226902	g23825	i0	88.542	106.150877192982	288	26	100	7	1	285	3	286	Uncultured clinical Neochlamydia sp. clone WB13 16S ribosomal RNA gene, partial sequence	blastn	30253	342	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	uncultured clinical Neochlamydia sp.
14428530	14428530	PRJNA376117_P_NODE_22352_length_292_cov_1.789954_g22050_i0	PRJNA376117	22352	292	1.789954	5.22666568	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	339	1.86e-88	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g22050	i0	87.838	356.609589041096	296	27	99	7	2	292	1829829	1830120	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	104130	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
16977286	16977286	PRJNA376117_P_NODE_3274_length_781_cov_3.598870_g2997_i0	PRJNA376117	3274	781	3.59887	28.1071747	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	1018	0	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g2997	i0	90.306	123.340588988476	784	66	100	10	1	781	7628963	7628187	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	96329	1018	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
19525676	19525676	PRJNA376117_P_NODE_24376_length_285_cov_1.089623_g24074_i0	PRJNA376117	24376	285	1.089623	3.10542555	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	359	1.39e-94	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g24074	i0	89.384	49.5368421052632	292	21	99	9	2	285	1830165	1830454	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	14118	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19525706	19525706	PRJNA376117_P_NODE_26336_length_278_cov_1.502439_g26034_i0	PRJNA376117	26336	278	1.502439	4.17678042	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	176	1.46e-39	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g26034	i0	78.967	4.01079136690648	271	47	96	10	1	266	246585	246850	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1115	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
19526016	19526016	PRJNA376117_P_NODE_6376_length_532_cov_1.941176_g6076_i0	PRJNA376117	6376	532	1.941176	10.32705632	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	833	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g6076	i0	94.925	178.146616541353	532	27	100	0	1	532	5153565	5154096	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	94774	833	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20199735	20199735	PRJNA376117_P_NODE_22716_length_290_cov_1.774194_g22414_i0	PRJNA376117	22716	290	1.774194	5.1451626	Parachlamydia	83551	Bacteria	Bacteria	392	1.39e-104	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g22414	i0	91.349	118.151724137931	289	22	99	3	1	288	692	978	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	34264	392	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
20199752	20199752	PRJNA376117_P_NODE_24736_length_283_cov_2.052381_g24434_i0	PRJNA376117	24736	283	2.052381	5.80823823	Verrucomicrobiota	74201	Bacteria	Bacteria	451	2.1999999999999995e-122	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g24434	i0	95.406	120.049469964664	283	13	100	0	1	283	5154271	5154553	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33974	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20801337	20801337	PRJNA376117_P_NODE_27977_length_272_cov_1.547739_g27675_i0	PRJNA376117	27977	272	1.547739	4.20985008	Akkermansia muciniphila	239935	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g27675	i0	100	2.23897058823529	29	0	11	0	221	249	1454019	1453991	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	609	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
21475364	21475364	PRJNA376117_P_NODE_25257_length_282_cov_1.000000_g24955_i0	PRJNA376117	25257	282	1	2.82	Candidatus Protochlamydia	282132	Bacteria	Bacteria	457	4.72e-124	NTclustered	gi\|449714028\|emb\|HF565157.1\|	464463	g24955	i0	96.085	111.783687943262	281	10	99	1	2	282	469	190	Uncultured Candidatus Protochlamydia sp. partial 16S rRNA gene, DGGE gel band 8/20a	blastn	31523	457	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	uncultured Candidatus Protochlamydia sp.
22076363	22076363	PRJNA376117_P_NODE_27378_length_274_cov_1.960199_g27076_i0	PRJNA376117	27378	274	1.960199	5.37094526	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	176	1.43e-39	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g27076	i0	80.165	54.1204379562044	242	42	87	6	11	249	2593105	2592867	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	14829	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22076398	22076398	PRJNA376117_P_NODE_2978_length_828_cov_2.487417_g2711_i0	PRJNA376117	2978	828	2.487417	20.59581276	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	1055	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2711	i0	89.94	346.566425120773	835	60	99	22	3	828	1831477	1830658	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	286957	1055	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
22076429	22076429	PRJNA376117_P_NODE_31778_length_258_cov_1.664865_g31476_i0	PRJNA376117	31778	258	1.664865	4.2953517	Horticoccus luteus	2862869	Bacteria	Bacteria	111	3.82e-20	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g31476	i0	86.869	3.46124031007752	99	13	38	0	159	257	1507126	1507028	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	893	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
22750696	22750696	PRJNA376117_P_NODE_9398_length_438_cov_2.745205_g9096_i0	PRJNA376117	9398	438	2.745205	12.0239979	Parachlamydia	83551	Bacteria	Bacteria	409	2.18e-109	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g9096	i0	83.864	93.2351598173516	440	60	99	10	1	435	7	440	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	40837	409	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
23351661	23351661	PRJNA376117_P_NODE_15499_length_348_cov_2.716364_g15197_i0	PRJNA376117	15499	348	2.716364	9.45294672	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	462	1.2799999999999998e-125	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g15197	i0	90.988	82.0632183908046	344	30	99	1	6	348	1316202	1315859	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	28558	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23352123	23352123	PRJNA376117_P_NODE_5659_length_570_cov_1.849095_g5361_i0	PRJNA376117	5659	570	1.849095	10.5398415	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	863	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g5361	i0	93.913	211.438596491228	575	29	100	6	1	570	1315284	1315857	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	120520	863	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24025292	24025292	PRJNA376117_P_NODE_11319_length_401_cov_1.408537_g11017_i0	PRJNA376117	11319	401	1.408537	5.64823337	Phycisphaerae	666505	Bacteria	Bacteria	547	4.0199999999999996e-151	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g11017	i0	91.294	123.082294264339	402	34	100	1	1	401	1831896	1832297	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	49356	547	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);;