metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA977246" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA977246" 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
950862	950862	PRJNA977246_S_NODE_15021_length_377_cov_489.548851_g14031_i0	PRJNA977246	15021	377	489.548851	1845.59916827	Aquisphaera giovannonii	406548	Bacteria	Bacteria	322	2.48e-83	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g14031	i0	83.721	15.6604774535809	344	52	91	4	34	375	7331742	7332083	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	5904	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
951045	951045	PRJNA977246_S_NODE_21741_length_291_cov_5.461832_g20749_i0	PRJNA977246	21741	291	5.461832	15.89393112	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	270	6.8399999999999985e-68	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g20749	i0	85.283	259.202749140893	265	35	91	4	28	291	2623120	2623381	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	75428	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
1269046	1269046	PRJNA977246_S_NODE_49961_length_154_cov_2.128000_g48969_i0	PRJNA977246	49961	154	2.128	3.27712	Bacteria	2	Bacteria	Bacteria	213	5.48e-51	NTclustered	gi\|12583968\|gb\|AF245372.1\|AF245372	69477	g48969	i0	91.613	133.61038961039	155	11	100	2	1	154	1807	1654	Planctomycete str. 140 23S ribosomal RNA gene, partial sequence	blastn	20576	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 140
2226602	2226602	PRJNA977246_S_NODE_27582_length_242_cov_5.685446_g26590_i0	PRJNA977246	27582	242	5.685446	13.75877932	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	331	2.5e-86	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g26590	i0	91.322	274.590909090909	242	21	100	0	1	242	4467732	4467491	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	66451	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
2227055	2227055	PRJNA977246_S_NODE_48042_length_158_cov_3.573643_g47050_i0	PRJNA977246	48042	158	3.573643	5.64635594	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	124	2.73e-24	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g47050	i0	81.481	141.487341772152	162	21	100	8	1	158	3537849	3538005	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	22355	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
4779289	4779289	PRJNA977246_S_NODE_21824_length_290_cov_7183.436782_g20832_i0	PRJNA977246	21824	290	7183.436782	20831.9666678	Saltatorellus ferox	2528018	Bacteria	Bacteria	259	1.47e-64	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g20832	i0	86.192	106.048275862069	239	33	82	0	52	290	2930080	2930318	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	30754	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
7328686	7328686	PRJNA977246_S_NODE_15826_length_364_cov_3.591045_g14836_i0	PRJNA977246	15826	364	3.591045	13.0714038	Caulifigura coniformis	2527983	Bacteria	Bacteria	529	1.3099999999999996e-145	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g14836	i0	92.857	77.1785714285714	364	26	100	0	1	364	2925967	2926330	Caulifigura coniformis strain Pan44 chromosome	blastn	28093	529	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
7329447	7329447	PRJNA977246_S_NODE_48886_length_156_cov_3.897638_g47894_i0	PRJNA977246	48886	156	3.897638	6.08031528	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	171	3.399999999999999e-38	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g47894	i0	95.327	95.6153846153846	107	5	69	0	50	156	3831862	3831756	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	14916	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11154701	11154701	PRJNA977246_S_NODE_25789_length_255_cov_709.526549_g24797_i0	PRJNA977246	25789	255	709.526549	1809.29269995	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	84.2	8.22e-12	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g24797	i0	94.444	0.32156862745098	54	3	21	0	29	82	6311245	6311298	Lacipirellula limnantheis strain I41 chromosome	blastn	82	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
11154875	11154875	PRJNA977246_S_NODE_32869_length_211_cov_3.362637_g31877_i0	PRJNA977246	32869	211	3.362637	7.09516407	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	73.1	1.42e-8	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g31877	i0	100	2.48341232227488	39	0	39	0	45	83	5833554	5833516	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	524	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
11472786	11472786	PRJNA977246_S_NODE_39149_length_184_cov_7.032258_g38157_i0	PRJNA977246	39149	184	7.032258	12.93935472	Frigoriglobus	2774146	Bacteria	Bacteria	228	2.4299999999999996e-55	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g38157	i0	91.975	28.4891304347826	162	13	88	0	3	164	2001782	2001621	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5242	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12430281	12430281	PRJNA977246_S_NODE_20110_length_308_cov_4.587814_g19118_i0	PRJNA977246	20110	308	4.587814	14.13046712	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	231	3.4399999999999997e-56	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g19118	i0	81.046	36.7012987012987	306	44	98	8	6	308	3082931	3083225	Stratiformator vulcanicus strain Pan189 chromosome	blastn	11304	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
12748081	12748081	PRJNA977246_S_NODE_30210_length_225_cov_5.301020_g29218_i0	PRJNA977246	30210	225	5.30102	11.927295	Gemmataceae	1914233	Bacteria	Bacteria	315	2.31e-81	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g29218	i0	95	193.48	200	10	89	0	24	223	2348	2547	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	43533	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
14979570	14979570	PRJNA977246_S_NODE_48252_length_158_cov_2.093023_g47260_i0	PRJNA977246	48252	158	2.093023	3.30697634	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	171	3.46e-38	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g47260	i0	87.097	23.8860759493671	155	14	97	5	5	157	1831285	1831435	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	3774	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
16253647	16253647	PRJNA977246_S_NODE_11633_length_442_cov_393.975787_g10675_i0	PRJNA977246	11633	442	393.975787	1741.37297854	Limnoglobus roseus	2598579	Bacteria	Bacteria	582	1.23e-161	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g10675	i0	92.494	152.298642533937	413	21	92	9	1	408	2958394	2957987	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	67316	582	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16253914	16253914	PRJNA977246_S_NODE_20633_length_302_cov_8.076923_g19641_i0	PRJNA977246	20633	302	8.076923	24.39230746	Chthoniobacter flavus	191863	Bacteria	Bacteria	313	1.17e-80	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g19641	i0	85.479	138.158940397351	303	40	100	3	1	302	191	490	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	41724	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
16254439	16254439	PRJNA977246_S_NODE_41493_length_176_cov_4.714286_g40501_i0	PRJNA977246	41493	176	4.714286	8.29714336	Pedosphaera parvula	1032527	Bacteria	Bacteria	147	6.619999999999999e-31	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g40501	i0	82.456	0.971590909090909	171	27	96	3	2	170	266	435	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	171	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16254517	16254517	PRJNA977246_S_NODE_45653_length_164_cov_3.466667_g44661_i0	PRJNA977246	45653	164	3.466667	5.68533388	Pedosphaera parvula	1032527	Bacteria	Bacteria	196	5.98e-46	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g44661	i0	88.415	92.2012195121951	164	17	99	2	2	164	1509	1671	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	15121	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
20077886	20077886	PRJNA977246_S_NODE_30516_length_223_cov_45.412371_g29524_i0	PRJNA977246	30516	223	45.412371	101.26958733	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	255	1.41e-63	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g29524	i0	89.899	67.4125560538117	198	20	89	0	26	223	1845629	1845432	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	15033	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
20078156	20078156	PRJNA977246_S_NODE_42876_length_172_cov_2.853147_g41884_i0	PRJNA977246	42876	172	2.853147	4.90741284	Caulifigura coniformis	2527983	Bacteria	Bacteria	279	6.08e-71	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g41884	i0	98.125	77.2383720930233	160	3	93	0	13	172	2926551	2926392	Caulifigura coniformis strain Pan44 chromosome	blastn	13285	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
21352885	21352885	PRJNA977246_S_NODE_12537_length_423_cov_5.685279_g11566_i0	PRJNA977246	12537	423	5.685279	24.04873017	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	420	9.699999999999999e-113	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11566	i0	92.857	76.8605200945626	294	13	68	7	1	289	3558070	3557780	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	32512	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21353003	21353003	PRJNA977246_S_NODE_16877_length_347_cov_5901.251572_g15885_i0	PRJNA977246	16877	347	5901.251572	20477.34295484	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	375	1.7199999999999998e-99	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g15885	i0	89.369	67.1440922190202	301	29	86	3	50	347	1316149	1316449	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	23299	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21353121	21353121	PRJNA977246_S_NODE_21097_length_297_cov_6799.847015_g20105_i0	PRJNA977246	21097	297	6799.847015	20195.54563455	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	344	4.06e-90	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g20105	i0	91.566	145.515151515152	249	21	84	0	49	297	454549	454797	Luteolibacter sp. AS25 chromosome, complete genome	blastn	43218	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
21671297	21671297	PRJNA977246_S_NODE_32017_length_215_cov_54.032258_g31025_i0	PRJNA977246	32017	215	54.032258	116.1693547	Phycisphaerae	666505	Bacteria	Bacteria	246	8.1e-61	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g31025	i0	91.16	694.860465116279	181	16	84	0	18	198	1831855	1831675	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	149395	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
25177123	25177123	PRJNA977246_S_NODE_19580_length_314_cov_5.417544_g18588_i0	PRJNA977246	19580	314	5.417544	17.01108816	Rosistilla carotiformis	2528017	Bacteria	Bacteria	291	5.719999999999999e-74	NTclustered	gi\|1712756907\|gb\|CP036348.1\|	2528017	g18588	i0	87.747	242.761146496815	253	25	79	6	44	292	1459798	1460048	Rosistilla carotiformis strain Poly24 chromosome	blastn	76227	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla carotiformis
25177606	25177606	PRJNA977246_S_NODE_36680_length_194_cov_2.933333_g35688_i0	PRJNA977246	36680	194	2.933333	5.69066602	Thermogutta terrifontis	1331910	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1238331385\|gb\|CP018477.1\|	1331910	g35688	i0	99.485	1.89175257731959	194	1	100	0	1	194	4330588	4330395	Thermogutta terrifontis strain R1 chromosome, complete genome	blastn	367	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis

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