metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA788929" 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
769383	769383	PRJNA788929_P_NODE_32441_length_275_cov_5.490099_g31780_i0	PRJNA788929	32441	275	5.490099	15.09777225	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	370	6.14e-98	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g31780	i0	95.299	36.4836363636364	234	9	84	2	21	252	897128	897361	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	10033	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3320599	3320599	PRJNA788929_P_NODE_29643_length_290_cov_7.211982_g28982_i0	PRJNA788929	29643	290	7.211982	20.9147478	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	344	3.959999999999999e-90	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g28982	i0	93.86	25.7137931034483	228	14	79	0	40	267	8526298	8526525	Tautonia plasticadhaerens strain ElP chromosome	blastn	7457	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
3320709	3320709	PRJNA788929_P_NODE_36743_length_255_cov_4.351648_g36082_i0	PRJNA788929	36743	255	4.351648	11.0967024	Lacipirellula parvula	2650471	Bacteria	Bacteria	394	3.34e-105	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g36082	i0	98.649	129.145098039216	222	3	87	0	18	239	5163510	5163731	Lacipirellula parvula PX69 DNA, complete genome	blastn	32932	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
3320818	3320818	PRJNA788929_P_NODE_43263_length_238_cov_4.666667_g42602_i0	PRJNA788929	43263	238	4.666667	11.10666746	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	126	1.24e-24	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g42602	i0	86.957	122.084033613445	115	11	48	3	23	137	5625796	5625686	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	29056	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
4597814	4597814	PRJNA788929_P_NODE_42824_length_240_cov_6.455090_g42163_i0	PRJNA788929	42824	240	6.45509	15.492216	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	318	1.93e-82	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g42163	i0	95.5	120.020833333333	200	8	83	1	18	217	265838	265640	Tautonia plasticadhaerens strain ElP chromosome	blastn	28805	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
4597824	4597824	PRJNA788929_P_NODE_43724_length_235_cov_20.777778_g43063_i0	PRJNA788929	43724	235	20.777778	48.8277783	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	268	1.92e-67	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g43063	i0	89.72	115.493617021277	214	17	90	5	24	235	2364439	2364229	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	27141	268	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
7148101	7148101	PRJNA788929_P_NODE_47406_length_214_cov_14.773050_g46745_i0	PRJNA788929	47406	214	14.77305	31.614327	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	355	1.28e-93	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g46745	i0	100	131.224299065421	192	0	90	0	23	214	3096521	3096330	Pirellula sp. SH-Sr6A, complete genome	blastn	28082	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
8422370	8422370	PRJNA788929_P_NODE_20827_length_357_cov_37.661972_g20167_i0	PRJNA788929	20827	357	37.661972	134.45324004	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	490	6.039999999999998e-134	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g20167	i0	93.884	105.274509803922	327	16	91	4	11	335	5087839	5087515	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	37583	490	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
9697488	9697488	PRJNA788929_P_NODE_18768_length_380_cov_5.947883_g18108_i0	PRJNA788929	18768	380	5.947883	22.6019554	Aquisphaera giovannonii	406548	Bacteria	Bacteria	259	1.99e-64	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g18108	i0	81.173	13.0973684210526	324	59	85	2	26	348	7611485	7611163	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	4977	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
9698055	9698055	PRJNA788929_P_NODE_9068_length_604_cov_58.209040_g8417_i0	PRJNA788929	9068	604	58.20904	351.5826016	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	918	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g8417	i0	96.092	242.081125827815	563	22	93	0	25	587	179	741	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	146217	918	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
10973611	10973611	PRJNA788929_P_NODE_44749_length_230_cov_8.528662_g44088_i0	PRJNA788929	44749	230	8.528662	19.6159226	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	381	2.309999999999999e-101	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g44088	i0	99.061	107	213	1	92	1	1	212	1250962	1250750	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	24610	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
10973710	10973710	PRJNA788929_P_NODE_6309_length_765_cov_186.517341_g5692_i0	PRJNA788929	6309	765	186.517341	1426.85765865	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	675	0	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g5692	i0	83.769	196.566013071895	727	103	94	14	27	748	2919809	2919093	Blastopirellula sp. J2-11 chromosome	blastn	150373	675	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
13523007	13523007	PRJNA788929_P_NODE_23431_length_333_cov_8.530769_g22770_i0	PRJNA788929	23431	333	8.530769	28.40746077	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	361	4.59e-95	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g22770	i0	89.825	121.468468468468	285	24	85	5	13	295	3722104	3722385	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	40449	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
13523403	13523403	PRJNA788929_P_NODE_49991_length_198_cov_7.696000_g49330_i0	PRJNA788929	49991	198	7.696	15.23808	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	259	9.42e-65	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g49330	i0	93.258	43.1767676767677	178	8	89	4	23	198	1830695	1830870	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	8549	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
13968275	13968275	PRJNA788929_P_NODE_40431_length_245_cov_8.081395_g39770_i0	PRJNA788929	40431	245	8.081395	19.79941775	Planctomycetaceae	126	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g39770	i0	90.968	67.6938775510204	155	11	63	2	1	154	3081743	3081895	Stratiformator vulcanicus strain Pan189 chromosome	blastn	16585	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
14798013	14798013	PRJNA788929_P_NODE_33592_length_269_cov_35.882653_g32931_i0	PRJNA788929	33592	269	35.882653	96.52433657	Gimesia maris	122	Bacteria	Bacteria	457	4.4699999999999985e-124	NTclustered	gi\|1712575600\|gb\|CP036353.1\|	122	g32931	i0	100	17.275092936803	247	0	92	0	23	269	2163427	2163673	Gimesia maris strain CA11 chromosome, complete genome	blastn	4647	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
16072067	16072067	PRJNA788929_P_NODE_43573_length_236_cov_10.411043_g42912_i0	PRJNA788929	43573	236	10.411043	24.57006148	Humisphaera borealis	2807512	Bacteria	Bacteria	278	3.2100000000000005e-70	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g42912	i0	90.654	74.7627118644068	214	13	90	6	1	213	5064400	5064193	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	17644	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
16072121	16072121	PRJNA788929_P_NODE_47713_length_212_cov_19.208633_g47052_i0	PRJNA788929	47713	212	19.208633	40.72230196	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	311	2.79e-80	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g47052	i0	96.316	59.5283018867925	190	6	89	1	1	189	1249297	1249108	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	12620	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17347476	17347476	PRJNA788929_P_NODE_20154_length_364_cov_11.463918_g19494_i0	PRJNA788929	20154	364	11.463918	41.72866152	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	167	1.1800000000000001e-36	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g19494	i0	88.652	1.89010989010989	141	11	38	5	105	244	1167667	1167531	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	688	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17348005	17348005	PRJNA788929_P_NODE_8214_length_645_cov_4.590909_g7567_i0	PRJNA788929	8214	645	4.590909	29.61136305	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	407	1.19e-108	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g7567	i0	81.744	2.05736434108527	493	84	76	6	135	624	4973204	4972715	Tautonia plasticadhaerens strain ElP chromosome	blastn	1327	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
17792104	17792104	PRJNA788929_P_NODE_5374_length_852_cov_4.296534_g4785_i0	PRJNA788929	5374	852	4.296534	36.60646968	Gemmata	113	Bacteria	Bacteria	1423	0	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g4785	i0	98.044	175.261737089202	818	16	96	0	5	822	3634776	3633959	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	149323	1428	0.996498599439776	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
18621069	18621069	PRJNA788929_P_NODE_43795_length_235_cov_7.753086_g43134_i0	PRJNA788929	43795	235	7.753086	18.2197521	Ereboglobus luteus	1796921	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g43134	i0	96.97	0.140425531914894	33	1	14	0	23	55	3303783	3303815	Ereboglobus luteus strain Ho45, complete genome	blastn	33	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
19066085	19066085	PRJNA788929_P_NODE_48315_length_209_cov_5.632353_g47654_i0	PRJNA788929	48315	209	5.632353	11.77161777	Gimesia	1649453	Bacteria	Bacteria	115	2.3e-21	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g47654	i0	79.032	3.57416267942584	186	26	86	11	31	209	2394445	2394624	Gimesia alba strain Pan241w chromosome	blastn	747	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
19896464	19896464	PRJNA788929_P_NODE_48596_length_207_cov_7.895522_g47935_i0	PRJNA788929	48596	207	7.895522	16.34373054	Roseimaritima ulvae	980254	Bacteria	Bacteria	198	2.2e-46	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g47935	i0	86.486	10.9178743961353	185	20	88	5	1	182	6157614	6157432	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	2260	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
21171895	21171895	PRJNA788929_P_NODE_30077_length_288_cov_1.330233_g29416_i0	PRJNA788929	30077	288	1.330233	3.83107104	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	307	5.15e-79	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g29416	i0	86.477	3.80902777777778	281	36	97	2	1	280	2027130	2026851	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1097	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
21172145	21172145	PRJNA788929_P_NODE_46797_length_218_cov_51.124138_g46136_i0	PRJNA788929	46797	218	51.124138	111.45062084	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	267	6.319999999999999e-67	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g46136	i0	91.667	135.688073394495	192	16	88	0	24	215	5171981	5171790	Lacipirellula limnantheis strain I41 chromosome	blastn	29580	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
21172146	21172146	PRJNA788929_P_NODE_46817_length_218_cov_12.351724_g46156_i0	PRJNA788929	46817	218	12.351724	26.92675832	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	202	1.81e-47	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g46156	i0	85.714	54.9311926605505	196	23	89	4	3	196	7050401	7050209	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	11975	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21172151	21172151	PRJNA788929_P_NODE_47137_length_216_cov_9.958042_g46476_i0	PRJNA788929	47137	216	9.958042	21.50937072	Luteolibacter luteus	2728835	Bacteria	Bacteria	340	3.629999999999999e-89	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g46476	i0	98.446	193.523148148148	193	3	89	0	23	215	3803649	3803841	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	41801	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
21172185	21172185	PRJNA788929_P_NODE_50277_length_196_cov_8.560976_g49616_i0	PRJNA788929	50277	196	8.560976	16.77951296	Blastopirellula marina	124	Bacteria	Bacteria	187	4.4499999999999985e-43	NTclustered	gi\|12583963\|gb\|AF245367.1\|AF245367	314230	g49616	i0	86.207	8.91326530612245	174	23	89	1	23	196	15	187	Pirellula marina 23S ribosomal RNA gene, partial sequence	blastn	1747	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
23722079	23722079	PRJNA788929_P_NODE_23739_length_330_cov_21.182879_g23078_i0	PRJNA788929	23739	330	21.182879	69.9035007	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	568	2.4899999999999995e-157	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g23078	i0	100	252.345454545455	307	0	93	0	1	307	1966	2272	Luteolibacter sp. SL250 chromosome	blastn	83274	568	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24996058	24996058	PRJNA788929_P_NODE_41940_length_242_cov_4.278107_g41279_i0	PRJNA788929	41940	242	4.278107	10.35301894	Gimesia chilikensis	2605989	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|1712562588\|gb\|CP036347.1\|	2605989	g41279	i0	94.924	3.25619834710744	197	10	81	0	24	220	5765027	5765223	Gimesia chilikensis strain V6 chromosome	blastn	788	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis

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