metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1126198" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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
2831991	2831991	PRJNA1126198_P_NODE_259923_length_275_cov_2.138614_g259202_i0	PRJNA1126198	259923	275	2.138614	5.8811885	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	459	1.27e-124	NTclustered	gi\|284519944\|gb\|FJ946606.1\|	100233	g259202	i0	96.727	100.2	275	9	100	0	1	275	257	531	Uncultured Planctomycetaceae bacterium clone MWR-H11v 16S ribosomal RNA gene, partial sequence	blastn	27555	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2832455	2832455	PRJNA1126198_P_NODE_474803_length_240_cov_2.335329_g474082_i0	PRJNA1126198	474803	240	2.335329	5.6047896	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	294	3.25e-75	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g474082	i0	88.797	167.895833333333	241	26	100	1	1	240	7050456	7050216	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	40295	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5385050	5385050	PRJNA1126198_P_NODE_5245_length_772_cov_3.277539_g4648_i0	PRJNA1126198	5245	772	3.277539	25.30260108	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1110	0	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g4648	i0	93.054	117.516839378238	763	47	98	6	13	772	4421414	4422173	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	90723	1110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
6659375	6659375	PRJNA1126198_P_NODE_371926_length_251_cov_2.196629_g371205_i0	PRJNA1126198	371926	251	2.196629	5.51353879	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	237	5.85e-58	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g371205	i0	83.984	122.836653386454	256	31	100	9	1	251	2711726	2711476	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	30832	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7408288	7408288	PRJNA1126198_P_NODE_407886_length_248_cov_0.885714_g407165_i0	PRJNA1126198	407886	248	0.885714	2.19657072	Gemmataceae	1914233	Bacteria	Bacteria	412	8.93e-111	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g407165	i0	97.131	231.45564516129	244	7	99	0	5	248	2022261	2022018	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	57401	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
7934865	7934865	PRJNA1126198_P_NODE_66187_length_374_cov_2.571429_g65470_i0	PRJNA1126198	66187	374	2.571429	9.61714446	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	608	1.6799999999999995e-169	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g65470	i0	95.989	133.24064171123	374	15	100	0	1	374	5169565	5169938	Lacipirellula limnantheis strain I41 chromosome	blastn	49832	608	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
9209259	9209259	PRJNA1126198_P_NODE_249108_length_278_cov_1.580488_g248387_i0	PRJNA1126198	249108	278	1.580488	4.39375664	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	259	1.4e-64	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g248387	i0	87.556	97.7877697841727	225	27	81	1	8	231	1844201	1844425	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	27185	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
10484630	10484630	PRJNA1126198_P_NODE_168169_length_305_cov_1.271552_g167449_i0	PRJNA1126198	168169	305	1.271552	3.8782336	Candidatus Brocadia pituitae	2608983	Bacteria	Bacteria	219	2.6499999999999998e-52	NTclustered	gi\|1996211272\|dbj\|AP021856.1\|	2608983	g167449	i0	81.004	7.39344262295082	279	49	91	4	3	279	2794515	2794239	Candidatus Brocadia pituitae DNA, complete genome	blastn	2255	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia	Candidatus Brocadia pituitae
10485341	10485341	PRJNA1126198_P_NODE_487849_length_230_cov_2.382166_g487128_i0	PRJNA1126198	487849	230	2.382166	5.4789818	Humisphaera borealis	2807512	Bacteria	Bacteria	398	2.2899999999999997e-106	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g487128	i0	97.826	145.982608695652	230	5	100	0	1	230	5064422	5064651	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	33576	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
11760355	11760355	PRJNA1126198_P_NODE_45890_length_405_cov_2.701807_g45173_i0	PRJNA1126198	45890	405	2.701807	10.94231835	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	422	2.57e-113	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g45173	i0	85.714	158.175308641975	406	51	99	7	1	401	194096	193693	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	64061	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11760512	11760512	PRJNA1126198_P_NODE_92270_length_349_cov_0.927536_g91552_i0	PRJNA1126198	92270	349	0.927536	3.23710064	Gemmataceae bacterium	2052164	Bacteria	Bacteria	545	1.24e-150	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g91552	i0	94.842	89.2951289398281	349	18	100	0	1	349	319014	319362	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	31164	545	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
13034758	13034758	PRJNA1126198_P_NODE_111551_length_334_cov_2.383142_g110832_i0	PRJNA1126198	111551	334	2.383142	7.95969428	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	496	1.21e-135	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g110832	i0	93.433	115.09880239521	335	21	100	1	1	334	4420754	4420420	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	38443	496	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13034898	13034898	PRJNA1126198_P_NODE_199931_length_292_cov_2.662100_g199211_i0	PRJNA1126198	199931	292	2.6621	7.773332	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	331	3.1000000000000002e-86	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g199211	i0	87.543	183.797945205479	289	33	98	2	2	287	2664373	2664661	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	53669	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13035233	13035233	PRJNA1126198_P_NODE_3711_length_933_cov_3.990698_g3195_i0	PRJNA1126198	3711	933	3.990698	37.23321234	Lacipirellula parvula	2650471	Bacteria	Bacteria	1574	0	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g3195	i0	97.809	119.84780278671	913	18	98	1	1	913	5163717	5162807	Lacipirellula parvula PX69 DNA, complete genome	blastn	111818	1574	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
13783613	13783613	PRJNA1126198_P_NODE_260031_length_275_cov_2.034653_g259310_i0	PRJNA1126198	260031	275	2.034653	5.59529575	Lacipirellula	2691417	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g259310	i0	95.588	74.8254545454545	272	12	99	0	4	275	5171976	5171705	Lacipirellula limnantheis strain I41 chromosome	blastn	20577	436	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
14310615	14310615	PRJNA1126198_P_NODE_452672_length_243_cov_1.835294_g451951_i0	PRJNA1126198	452672	243	1.835294	4.45976442	Gemmata massiliana	1210884	Bacteria	Bacteria	128	3.54e-25	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g451951	i0	81.481	0.666666666666667	162	24	64	1	88	243	4033619	4033458	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	162	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
15057895	15057895	PRJNA1126198_P_NODE_199752_length_293_cov_0.909091_g199032_i0	PRJNA1126198	199752	293	0.909091	2.66363663	PVC group	1783257	Bacteria	Bacteria	128	4.3899999999999995e-25	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g199032	i0	81.699	20.4505119453925	153	28	52	0	3	155	3317499	3317651	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	5992	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15583947	15583947	PRJNA1126198_P_NODE_116613_length_331_cov_1.790698_g115894_i0	PRJNA1126198	116613	331	1.790698	5.92721038	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	298	3.63e-76	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g115894	i0	83.234	143.546827794562	334	46	100	8	1	331	276759	276433	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	47514	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
16332661	16332661	PRJNA1126198_P_NODE_217393_length_287_cov_1.453271_g216672_i0	PRJNA1126198	217393	287	1.453271	4.17088777	Candidatus Protochlamydia	282132	Bacteria	Bacteria	490	4.749999999999998e-134	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g216672	i0	97.552	109.066202090592	286	7	99	0	1	286	1251976	1252261	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	31302	490	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
18132761	18132761	PRJNA1126198_P_NODE_100675_length_342_cov_1.457249_g99956_i0	PRJNA1126198	100675	342	1.457249	4.98379158	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	246	1.38e-60	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g99956	i0	93.373	78.7251461988304	166	11	49	0	177	342	3261422	3261587	Luteolibacter sp. Populi chromosome, complete genome	blastn	26924	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
18133029	18133029	PRJNA1126198_P_NODE_271175_length_272_cov_4.984925_g270454_i0	PRJNA1126198	271175	272	4.984925	13.558996	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	484	2.0799999999999996e-132	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g270454	i0	98.893	149.952205882353	271	3	99	0	2	272	5169895	5170165	Lacipirellula limnantheis strain I41 chromosome	blastn	40787	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
18133254	18133254	PRJNA1126198_P_NODE_373735_length_251_cov_1.629213_g373014_i0	PRJNA1126198	373735	251	1.629213	4.08932463	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	65.8	2.92e-6	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g373014	i0	97.368	3.70517928286853	38	1	15	0	171	208	3512617	3512580	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	930	65.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
19407403	19407403	PRJNA1126198_P_NODE_368336_length_252_cov_0.871508_g367615_i0	PRJNA1126198	368336	252	0.871508	2.19620016	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	226	1.2699999999999999e-54	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g367615	i0	86.473	11.6428571428571	207	26	82	2	7	212	318241	318446	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2934	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
19407489	19407489	PRJNA1126198_P_NODE_405576_length_248_cov_0.891429_g404855_i0	PRJNA1126198	405576	248	0.891429	2.21074392	Stieleria marina	1930275	Bacteria	Bacteria	139	1.67e-28	NTclustered	gi\|1712461730\|gb\|CP036526.1\|	1930275	g404855	i0	84.397	227.524193548387	141	22	57	0	108	248	2122624	2122764	Planctomycetes bacterium K23_9 chromosome, complete genome	blastn	56426	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria marina
20156575	20156575	PRJNA1126198_P_NODE_146976_length_314_cov_3.323651_g146257_i0	PRJNA1126198	146976	314	3.323651	10.43626414	Lacipirellula	2691417	Bacteria	Bacteria	575	1.4099999999999994e-159	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g146257	i0	99.682	127.015923566879	314	1	100	0	1	314	5169272	5169585	Lacipirellula limnantheis strain I41 chromosome	blastn	39883	575	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
21432386	21432386	PRJNA1126198_P_NODE_441537_length_244_cov_2.286550_g440816_i0	PRJNA1126198	441537	244	2.28655	5.579182	Gemmata	113	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g440816	i0	100	0.344262295081967	28	0	11	0	207	234	1237371	1237344	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	84	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
21958415	21958415	PRJNA1126198_P_NODE_406358_length_248_cov_0.891429_g405637_i0	PRJNA1126198	406358	248	0.891429	2.21074392	Congregicoccus parvus	3081749	Bacteria	Bacteria	73.1	1.72e-8	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g405637	i0	95.556	0.181451612903226	45	2	18	0	1	45	489189	489233	Opitutales bacterium ASA1 DNA, complete genome	blastn	45	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
23233813	23233813	PRJNA1126198_P_NODE_352479_length_254_cov_1.723757_g351758_i0	PRJNA1126198	352479	254	1.723757	4.37834278	Humisphaera borealis	2807512	Bacteria	Bacteria	309	1.24e-79	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g351758	i0	88.716	95.9055118110236	257	23	100	3	1	254	47487	47740	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	24360	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24507049	24507049	PRJNA1126198_P_NODE_15140_length_528_cov_3.846154_g14455_i0	PRJNA1126198	15140	528	3.846154	20.30769312	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	732	0	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g14455	i0	91.667	163.111742424242	528	44	100	0	1	528	4422860	4422333	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	86123	732	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;