metadata: contig_metadata: 42 rows where analysis = "blastn", bioproject = "PRJNA1196384" and tax

42 rows where analysis = "blastn", bioproject = "PRJNA1196384" 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
322656	322656	PRJNA1196384_S_NODE_1321_length_336_cov_2.705686_g1257_i0	PRJNA1196384	1321	336	2.705686	9.09110496	Humisphaera borealis	2807512	Bacteria	Bacteria	316	1.02e-81	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g1257	i0	84.783	132.223214285714	322	41	95	7	16	334	5064202	5063886	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	44427	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
322714	322714	PRJNA1196384_S_NODE_501_length_526_cov_3.932515_g439_i0	PRJNA1196384	501	526	3.932515	20.6850289	Humisphaera borealis	2807512	Bacteria	Bacteria	601	4.0899999999999996e-167	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g439	i0	87.619	106.376425855513	525	55	99	7	3	526	5063886	5064401	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	55954	601	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
1043151	1043151	PRJNA1196384_S_NODE_2541_length_243_cov_2.966019_g2477_i0	PRJNA1196384	2541	243	2.966019	7.20742617	Singulisphaera	466152	Bacteria	Bacteria	355	1.49e-93	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g2477	i0	93.388	196.855967078189	242	13	99	2	2	243	2798	2560	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	47836	357	0.994397759103641	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
1043182	1043182	PRJNA1196384_S_NODE_7341_length_157_cov_4.341667_g7277_i0	PRJNA1196384	7341	157	4.341667	6.81641719	Phycisphaerae	666505	Bacteria	Bacteria	213	5.62e-51	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7277	i0	91.139	38.2547770700637	158	12	100	2	1	157	1830578	1830734	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	6006	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
1597264	1597264	PRJNA1196384_S_NODE_2002_length_276_cov_4.912134_g1938_i0	PRJNA1196384	2002	276	4.912134	13.55748984	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	438	1.6699999999999996e-118	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g1938	i0	95.29	164.804347826087	276	13	100	0	1	276	1601326	1601601	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	45486	438	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
1597280	1597280	PRJNA1196384_S_NODE_3222_length_217_cov_1.344444_g3158_i0	PRJNA1196384	3222	217	1.344444	2.91744348	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	342	1.02e-89	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g3158	i0	94.977	115.345622119816	219	9	100	2	1	217	15907	16125	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	25030	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2873448	2873448	PRJNA1196384_S_NODE_2763_length_233_cov_4.571429_g2699_i0	PRJNA1196384	2763	233	4.571429	10.65142957	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	300	6.74e-77	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g2699	i0	91.071	285.995708154506	224	16	95	4	12	233	16295	16074	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	66637	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2873468	2873468	PRJNA1196384_S_NODE_4163_length_195_cov_1.550633_g4099_i0	PRJNA1196384	4163	195	1.550633	3.02373435	Singulisphaera acidiphila	466153	Bacteria	Bacteria	239	1.1999999999999999e-58	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g4099	i0	88.718	84.8923076923077	195	22	100	0	1	195	7449660	7449466	Singulisphaera acidiphila DSM 18658, complete genome	blastn	16554	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
2873541	2873541	PRJNA1196384_S_NODE_843_length_418_cov_21.188976_g779_i0	PRJNA1196384	843	418	21.188976	88.56991968	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	492	1.9999999999999996e-134	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g779	i0	91.808	235	354	27	84	2	67	418	1320589	1320236	Luteolibacter sp. Populi chromosome, complete genome	blastn	98230	492	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
4149598	4149598	PRJNA1196384_S_NODE_2624_length_239_cov_3.336634_g2560_i0	PRJNA1196384	2624	239	3.336634	7.97455526	Humisphaera borealis	2807512	Bacteria	Bacteria	287	5.409999999999999e-73	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2560	i0	88.608	50.673640167364	237	26	99	1	3	239	5063004	5063239	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	12111	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
4149623	4149623	PRJNA1196384_S_NODE_4144_length_195_cov_2.537975_g4080_i0	PRJNA1196384	4144	195	2.537975	4.94905125	Chthoniobacter flavus	191863	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g4080	i0	94.872	95.2615384615385	195	10	100	0	1	195	955	1149	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	18576	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
4871242	4871242	PRJNA1196384_S_NODE_704_length_452_cov_2.730120_g640_i0	PRJNA1196384	704	452	2.73012	12.3401424	root	1	Root_unresolved	Root_unresolved	459	2.2099999999999993e-124	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g640	i0	85.193	98.7212389380531	466	48	99	12	1	451	5063200	5063659	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	44622	462	0.993506493506494	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
9250569	9250569	PRJNA1196384_S_NODE_2408_length_250_cov_2.140845_g2344_i0	PRJNA1196384	2408	250	2.140845	5.3521125	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	196	9.88e-46	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g2344	i0	81.967	34.504	244	33	95	10	8	245	5085933	5085695	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	8626	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
10526389	10526389	PRJNA1196384_S_NODE_1069_length_370_cov_7.093093_g1005_i0	PRJNA1196384	1069	370	7.093093	26.2444441	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	542	1.7099999999999999e-149	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g1005	i0	93.261	148.937837837838	371	19	100	5	4	370	4317738	4317370	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	55107	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10526391	10526391	PRJNA1196384_S_NODE_1209_length_352_cov_2.622222_g1145_i0	PRJNA1196384	1209	352	2.622222	9.23022144	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	2.17e-123	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g1145	i0	92.744	246.039772727273	317	20	90	3	1	316	2748639	2748325	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	86606	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10526402	10526402	PRJNA1196384_S_NODE_2169_length_263_cov_14.314159_g2105_i0	PRJNA1196384	2169	263	14.314159	37.64623817	Pirellulimonas nuda	2528009	Bacteria	Bacteria	287	6.05e-73	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g2105	i0	86.364	174.003802281369	264	35	100	1	1	263	1067818	1068081	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	45763	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
10526445	10526445	PRJNA1196384_S_NODE_4849_length_184_cov_1.326531_g4785_i0	PRJNA1196384	4849	184	1.326531	2.44081704	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	329	6.47e-86	NTclustered	gi\|781803457\|emb\|LN798716.1\|	120965	g4785	i0	98.913	90.7717391304348	184	2	100	0	1	184	14	197	Uncultured planctomycete partial 16S rRNA gene, clone denovo3970	blastn	16702	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
11801179	11801179	PRJNA1196384_S_NODE_1190_length_355_cov_2.773585_g1126_i0	PRJNA1196384	1190	355	2.773585	9.84622675	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	621	2.04e-173	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1126	i0	98.305	271.684507042254	354	6	99	0	1	354	17809	18162	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	96448	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11801180	11801180	PRJNA1196384_S_NODE_1250_length_345_cov_5.259740_g1186_i0	PRJNA1196384	1250	345	5.25974	18.146103	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	322	2.25e-83	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g1186	i0	87.912	179.098550724638	273	33	79	0	1	273	631813	631541	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	61789	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
11801215	11801215	PRJNA1196384_S_NODE_3790_length_203_cov_2.915663_g3726_i0	PRJNA1196384	3790	203	2.915663	5.91879589	Luteolibacter luteus	2728835	Bacteria	Bacteria	196	7.72e-46	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g3726	i0	85.204	122.674876847291	196	23	96	5	1	195	3803530	3803720	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	24903	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
13076278	13076278	PRJNA1196384_S_NODE_3031_length_223_cov_2.887097_g2967_i0	PRJNA1196384	3031	223	2.887097	6.43822631	Humisphaera borealis	2807512	Bacteria	Bacteria	281	2.32e-71	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2967	i0	90.61	28.8161434977578	213	18	95	2	1	211	5063083	5063295	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	6426	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13076285	13076285	PRJNA1196384_S_NODE_351_length_612_cov_3.688696_g294_i0	PRJNA1196384	351	612	3.688696	22.57481952	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	608	2.869999999999998e-169	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g294	i0	85.619	350.387254901961	598	65	96	17	12	597	1830773	1831361	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	214437	608	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
13076340	13076340	PRJNA1196384_S_NODE_6871_length_161_cov_1.951613_g6807_i0	PRJNA1196384	6871	161	1.951613	3.14209693	Humisphaera borealis	2807512	Bacteria	Bacteria	165	1.65e-36	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g6807	i0	85.714	98.3229813664596	161	18	100	4	4	161	5063022	5062864	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	15830	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
13796527	13796527	PRJNA1196384_S_NODE_4631_length_187_cov_1.553333_g4567_i0	PRJNA1196384	4631	187	1.553333	2.90473271	Pirellulaceae	2691357	Bacteria	Bacteria	226	8.909999999999998e-55	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g4567	i0	88.421	82.5989304812834	190	18	100	4	1	187	601	789	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	15446	228	0.991228070175439	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
14351646	14351646	PRJNA1196384_S_NODE_1212_length_351_cov_3.500000_g1148_i0	PRJNA1196384	1212	351	3.5	12.285	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	599	9.45e-167	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g1148	i0	97.436	198.481481481481	351	9	100	0	1	351	1601565	1601915	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	69667	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
14351662	14351662	PRJNA1196384_S_NODE_2132_length_266_cov_1.873362_g2068_i0	PRJNA1196384	2132	266	1.873362	4.98314292	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	387	5.87e-103	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2068	i0	92.884	138.063909774436	267	18	100	1	1	266	1832243	1831977	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	36725	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14351696	14351696	PRJNA1196384_S_NODE_372_length_601_cov_4.338652_g315_i0	PRJNA1196384	372	601	4.338652	26.07529852	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	981	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g315	i0	96.173	619.875207986689	601	21	99	1	3	601	1600027	1600627	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	372545	981	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
14351780	14351780	PRJNA1196384_S_NODE_92_length_1009_cov_3.601852_g64_i0	PRJNA1196384	92	1009	3.601852	36.34268668	Humisphaera borealis	2807512	Bacteria	Bacteria	1079	0	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g64	i0	86.391	402.663032705649	1014	107	99	21	16	1009	5064202	5063200	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	406287	1079	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
15070877	15070877	PRJNA1196384_S_NODE_5732_length_172_cov_6.148148_g5668_i0	PRJNA1196384	5732	172	6.148148	10.57481456	Planctomycetia	203683	Bacteria	Bacteria	243	7.979999999999999e-60	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g5668	i0	93.373	91.9883720930233	166	7	95	4	7	170	865	702	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	15822	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
15625527	15625527	PRJNA1196384_S_NODE_7033_length_160_cov_1.268293_g6969_i0	PRJNA1196384	7033	160	1.268293	2.0292688	Limnoglobus roseus	2598579	Bacteria	Bacteria	268	1.21e-67	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g6969	i0	96.875	76.9875	160	5	100	0	1	160	2957268	2957427	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	12318	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18174304	18174304	PRJNA1196384_S_NODE_4195_length_194_cov_3.159236_g4131_i0	PRJNA1196384	4195	194	3.159236	6.12891784	Lignipirellula cremea	2528010	Bacteria	Bacteria	291	3.2599999999999993e-74	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g4131	i0	97.093	100.134020618557	172	5	89	0	23	194	1144173	1144344	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	19426	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
18174330	18174330	PRJNA1196384_S_NODE_5655_length_173_cov_3.132353_g5591_i0	PRJNA1196384	5655	173	3.132353	5.41897069	Humisphaera borealis	2807512	Bacteria	Bacteria	213	6.3e-51	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g5591	i0	89.143	21.0520231213873	175	14	99	4	1	172	5064305	5064477	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	3642	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
18174340	18174340	PRJNA1196384_S_NODE_6215_length_167_cov_1.484615_g6151_i0	PRJNA1196384	6215	167	1.484615	2.47930705	Urbifossiella limnaea	2528023	Bacteria	Bacteria	119	1.36e-22	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6151	i0	85.47	1.40119760479042	117	13	68	4	15	128	2020184	2020069	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	234	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
18174373	18174373	PRJNA1196384_S_NODE_7995_length_153_cov_1.336207_g7931_i0	PRJNA1196384	7995	153	1.336207	2.04439671	Gemmata massiliana	1210884	Bacteria	Bacteria	222	9.029999999999999e-54	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g7931	i0	92.857	68.6274509803922	154	10	100	1	1	153	3634627	3634474	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	10500	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
20169448	20169448	PRJNA1196384_S_NODE_8416_length_150_cov_3.522124_g8352_i0	PRJNA1196384	8416	150	3.522124	5.283186	Planctopirus	1649480	Bacteria	Bacteria	244	1.88e-60	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g8352	i0	96	103.233333333333	150	6	100	0	1	150	1614	1763	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	15485	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
20724032	20724032	PRJNA1196384_S_NODE_3117_length_220_cov_2.535519_g3053_i0	PRJNA1196384	3117	220	2.535519	5.5781418	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	283	6.35e-72	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g3053	i0	90	226.018181818182	220	20	100	1	1	220	5362717	5362500	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	49724	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
20724129	20724129	PRJNA1196384_S_NODE_997_length_383_cov_5.537572_g933_i0	PRJNA1196384	997	383	5.537572	21.20890076	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	525	1.7899999999999994e-144	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g933	i0	91.495	223.023498694517	388	23	100	9	1	383	6982912	6983294	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	85418	525	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
21999448	21999448	PRJNA1196384_S_NODE_358_length_609_cov_4.921329_g301_i0	PRJNA1196384	358	609	4.921329	29.97089361	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	497	6.45e-136	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g301	i0	83.835	240.896551724138	532	77	87	7	1	529	924	1449	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	146706	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
24548781	24548781	PRJNA1196384_S_NODE_360_length_608_cov_5.042032_g303_i0	PRJNA1196384	360	608	5.042032	30.65555456	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	848	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g303	i0	92.092	200.452302631579	607	41	99	5	3	608	1600027	1600627	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	121875	848	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
24548859	24548859	PRJNA1196384_S_NODE_7700_length_155_cov_1.483051_g7636_i0	PRJNA1196384	7700	155	1.483051	2.29872905	Caulifigura coniformis	2527983	Bacteria	Bacteria	176	7.25e-40	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g7636	i0	89.286	229.135483870968	140	15	90	0	16	155	2924939	2924800	Caulifigura coniformis strain Pan44 chromosome	blastn	35516	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
24548875	24548875	PRJNA1196384_S_NODE_860_length_414_cov_3.169761_g796_i0	PRJNA1196384	860	414	3.169761	13.12281054	Humisphaera borealis	2807512	Bacteria	Bacteria	520	9.079999999999997e-143	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g796	i0	89.614	206.799516908213	414	35	100	7	1	411	5064736	5065144	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	85615	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
25269345	25269345	PRJNA1196384_S_NODE_1940_length_281_cov_4.381148_g1876_i0	PRJNA1196384	1940	281	4.381148	12.31102588	Akkermansia	239934	Bacteria	Bacteria	326	1.38e-84	NTclustered	gi\|183579827\|emb\|AM905424.1\|	239935	g1876	i0	87.676	299.163701067616	284	30	100	4	1	281	923	1204	Akkermansia muciniphila 23S rRNA gene, strain CIP107961	blastn	84065	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila

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