metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA415856" 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
419270	419270	PRJNA415856_P_NODE_28161_length_177_cov_1.992188_g27900_i0	PRJNA415856	28161	177	1.992188	3.52617276	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	233	4.9799999999999995e-57	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g27900	i0	98.485	83.4237288135593	132	2	75	0	1	132	3556144	3556275	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	14766	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1694186	1694186	PRJNA415856_P_NODE_37502_length_166_cov_1.376068_g37241_i0	PRJNA415856	37502	166	1.376068	2.28427288	Adhaeretor mobilis	1930276	Bacteria	Bacteria	224	2.7799999999999995e-54	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g37241	i0	90.964	56.0903614457831	166	15	100	0	1	166	3977207	3977372	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	9311	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
1694202	1694202	PRJNA415856_P_NODE_39942_length_165_cov_1.698276_g39681_i0	PRJNA415856	39942	165	1.698276	2.8021554	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	154	3.68e-33	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g39681	i0	86.429	0.848484848484849	140	19	85	0	26	165	5868166	5868027	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	140	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
1694319	1694319	PRJNA415856_P_NODE_8142_length_320_cov_2.003690_g7881_i0	PRJNA415856	8142	320	2.00369	6.411808	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	392	1.5599999999999995e-104	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g7881	i0	88.785	73.875	321	35	100	1	1	320	2621795	2622115	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	23640	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2359086	2359086	PRJNA415856_P_NODE_8382_length_314_cov_3.418868_g8121_i0	PRJNA415856	8382	314	3.418868	10.73524552	Chthoniobacter	295577	Bacteria	Bacteria	375	1.5299999999999998e-99	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g8121	i0	89.369	261.684713375796	301	28	95	4	1	299	17769	17471	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	82169	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2970089	2970089	PRJNA415856_P_NODE_38583_length_166_cov_0.871795_g38322_i0	PRJNA415856	38583	166	0.871795	1.4471797	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	176	7.91e-40	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g38322	i0	90.84	8.19277108433735	131	12	79	0	36	166	4369754	4369884	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1360	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
6797096	6797096	PRJNA415856_P_NODE_3586_length_525_cov_2.808824_g3337_i0	PRJNA415856	3586	525	2.808824	14.746326	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	673	0	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3337	i0	90.249	93.992380952381	523	39	99	2	1	523	3081664	3082174	Stratiformator vulcanicus strain Pan189 chromosome	blastn	49346	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
8736372	8736372	PRJNA415856_P_NODE_3907_length_500_cov_2.780488_g3654_i0	PRJNA415856	3907	500	2.780488	13.90244	Pirellulales	2691354	Bacteria	Bacteria	756	0	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g3654	i0	94.165	126.798	497	28	100	1	4	500	2674143	2673648	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	63399	756	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
9347482	9347482	PRJNA415856_P_NODE_40268_length_165_cov_1.224138_g40007_i0	PRJNA415856	40268	165	1.224138	2.0198277	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g40007	i0	98.788	18.9090909090909	165	2	100	0	1	165	2497234	2497070	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	3120	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
13173000	13173000	PRJNA415856_P_NODE_22691_length_188_cov_1.071942_g22430_i0	PRJNA415856	22691	188	1.071942	2.01525096	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	222	1.16e-53	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g22430	i0	88.235	86.6276595744681	187	20	99	2	3	188	4421361	4421546	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	16286	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13173018	13173018	PRJNA415856_P_NODE_24471_length_184_cov_1.807407_g24210_i0	PRJNA415856	24471	184	1.807407	3.32562888	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	285	1.42e-72	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g24210	i0	94.565	135.20652173913	184	10	100	0	1	184	4422213	4422396	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	24878	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15721840	15721840	PRJNA415856_P_NODE_14493_length_228_cov_1.648045_g14232_i0	PRJNA415856	14493	228	1.648045	3.7575426	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	399	6.299999999999999e-107	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g14232	i0	98.667	116.118421052632	225	3	99	0	1	225	5169504	5169728	Lacipirellula limnantheis strain I41 chromosome	blastn	26475	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
16385983	16385983	PRJNA415856_P_NODE_45613_length_163_cov_1.500000_g45352_i0	PRJNA415856	45613	163	1.5	2.445	Planctomycetia	203683	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g45352	i0	95.706	136.361963190184	163	7	100	0	1	163	2507	2669	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	22227	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
18271061	18271061	PRJNA415856_P_NODE_48715_length_162_cov_0.902655_g48454_i0	PRJNA415856	48715	162	0.902655	1.4623011	Humisphaera borealis	2807512	Bacteria	Bacteria	132	1.68e-26	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g48454	i0	84.733	2.65432098765432	131	20	81	0	1	131	3547554	3547684	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	430	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19545171	19545171	PRJNA415856_P_NODE_34876_length_167_cov_1.491525_g34615_i0	PRJNA415856	34876	167	1.491525	2.49084675	Humisphaera borealis	2807512	Bacteria	Bacteria	86.1	1.38e-12	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g34615	i0	88.571	0.419161676646707	70	8	42	0	96	165	4459470	4459539	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	70	86.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19545309	19545309	PRJNA415856_P_NODE_536_length_1235_cov_3.026138_g443_i0	PRJNA415856	536	1235	3.026138	37.3728043	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	1249	0	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g443	i0	85.138	109.338461538462	1265	138	100	30	1	1235	1844353	1845597	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	135033	1249	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
20209534	20209534	PRJNA415856_P_NODE_14836_length_225_cov_3.198864_g14575_i0	PRJNA415856	14836	225	3.198864	7.197444	Gimesia	1649453	Bacteria	Bacteria	333	6.379999999999999e-87	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g14575	i0	93.722	526.675555555556	223	12	99	2	3	224	2397312	2397091	Gimesia alba strain Pan241w chromosome	blastn	118502	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
22095611	22095611	PRJNA415856_P_NODE_16778_length_212_cov_4.042945_g16517_i0	PRJNA415856	16778	212	4.042945	8.5710434	Candidatus Methylacidiphilum infernorum	511746	Bacteria	Bacteria	193	1.05e-44	NTclustered	gi\|1999105499\|gb\|CP065956.1\|	511746	g16517	i0	83.81	105.943396226415	210	27	98	7	6	212	2044615	2044410	Candidatus Methylacidiphilum infernorum strain IT5 chromosome, complete genome	blastn	22460	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
24645778	24645778	PRJNA415856_P_NODE_41940_length_165_cov_0.879310_g41679_i0	PRJNA415856	41940	165	0.87931	1.4508615	Paludisphaera borealis	1387353	Bacteria	Bacteria	283	4.4899999999999995e-72	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g41679	i0	97.576	150.454545454545	165	4	100	0	1	165	121929	121765	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	24825	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
24645872	24645872	PRJNA415856_P_NODE_560_length_1211_cov_2.354561_g463_i0	PRJNA415856	560	1211	2.354561	28.51373371	Chthoniobacter flavus	191863	Bacteria	Bacteria	1576	0	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g463	i0	90.19	204.23534269199	1213	113	100	6	1	1211	1424	216	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	247329	1576	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
25309656	25309656	PRJNA415856_P_NODE_39740_length_165_cov_1.974138_g39479_i0	PRJNA415856	39740	165	1.974138	3.2573277	Planctomycetaceae	126	Bacteria	Bacteria	255	9.8e-64	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g39479	i0	94.545	137.024242424242	165	9	100	0	1	165	5087678	5087842	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	22609	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus

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