metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
777111	777111	PRJNA792582_P_NODE_54661_length_246_cov_0.890173_g53847_i0	PRJNA792582	54661	246	0.890173	2.18982558	Lignipirellula cremea	2528010	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g53847	i0	85.59	1.73577235772358	229	31	93	2	4	231	6914594	6914367	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	427	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
1215500	1215500	PRJNA792582_P_NODE_55081_length_245_cov_3.970930_g54267_i0	PRJNA792582	55081	245	3.97093	9.7287785	Chlamydiaceae	809	Bacteria	Bacteria	213	9.59e-51	NTclustered	gi\|2074314328\|gb\|CP063177.1\|	83559	g54267	i0	82.845	153.085714285714	239	39	97	2	3	240	418547	418310	Chlamydia suis strain 253.1 chromosome	blastn	37506	213	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia suis
2052722	2052722	PRJNA792582_P_NODE_16362_length_426_cov_2.611898_g15548_i0	PRJNA792582	16362	426	2.611898	11.12668548	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	76.8	2.44e-9	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g15548	i0	89.062	3.1056338028169	64	3	15	4	364	425	1297318	1297379	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	1323	76.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
3328183	3328183	PRJNA792582_P_NODE_43263_length_269_cov_1.346939_g42449_i0	PRJNA792582	43263	269	1.346939	3.62326591	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	387	5.95e-103	NTclustered	gi\|18029206\|gb\|AF364577.1\|	174324	g42449	i0	92.565	102.371747211896	269	20	100	0	1	269	272	4	Uncultured Chlamydiales bacterium clone P-11 16S ribosomal RNA gene, partial sequence	blastn	27538	387	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
7155160	7155160	PRJNA792582_P_NODE_13406_length_467_cov_2.672589_g12594_i0	PRJNA792582	13406	467	2.672589	12.48099063	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	361	6.639999999999999e-95	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g12594	i0	80.932	79.6745182012848	472	76	100	13	1	467	2162787	2162325	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	37208	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
7155533	7155533	PRJNA792582_P_NODE_51826_length_249_cov_0.875000_g51012_i0	PRJNA792582	51826	249	0.875	2.17875	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g51012	i0	95.984	163.064257028112	249	10	100	0	1	249	1251331	1251579	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	40603	405	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7155625	7155625	PRJNA792582_P_NODE_60066_length_236_cov_2.993865_g59252_i0	PRJNA792582	60066	236	2.993865	7.0655214	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	67.6	7.56e-7	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g59252	i0	79.787	0.775423728813559	94	17	40	2	131	224	2253534	2253625	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	183	67.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8430287	8430287	PRJNA792582_P_NODE_53327_length_247_cov_1.632184_g52513_i0	PRJNA792582	53327	247	1.632184	4.03149448	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	320	5.54e-83	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g52513	i0	91.453	103.174089068826	234	18	94	2	1	233	2059782	2060014	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	25484	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13969158	13969158	PRJNA792582_P_NODE_15031_length_443_cov_23.186486_g14218_i0	PRJNA792582	15031	443	23.186486	102.71613298	Chlamydiia	204429	Bacteria	Bacteria	75	9.15e-9	NTclustered	gi\|559133869\|tpe\|HG788876.1\|	765953	g14218	i0	87.692	3.25507900677201	65	6	14	2	1	64	438	375	TPA: Waddlia chondrophila 2032/99 transfer-messenger mRNA Waddl_chond_WSU861, single chain mature transcript	blastn	1442	75	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
14805364	14805364	PRJNA792582_P_NODE_16712_length_422_cov_1.501433_g15898_i0	PRJNA792582	16712	422	1.501433	6.33604726	Caulifigura coniformis	2527983	Bacteria	Bacteria	510	5.58e-140	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g15898	i0	89.383	151.791469194313	405	43	96	0	18	422	2926116	2925712	Caulifigura coniformis strain Pan44 chromosome	blastn	64056	510	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
15243725	15243725	PRJNA792582_P_NODE_26812_length_333_cov_3.900000_g25998_i0	PRJNA792582	26812	333	3.9	12.987	Luteolibacter	518753	Bacteria	Bacteria	219	2.9199999999999993e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g25998	i0	81.784	155.354354354354	269	41	80	7	1	265	2216378	2216642	Luteolibacter sp. LG18 DNA, complete genome	blastn	51733	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
16079633	16079633	PRJNA792582_P_NODE_5333_length_714_cov_3.858034_g4598_i0	PRJNA792582	5333	714	3.858034	27.54636276	Parachlamydiaceae bacterium CRIB39	665613	Bacteria	Bacteria	1256	0	NTclustered	gi\|256014209\|gb\|FJ532292.1\|	665613	g4598	i0	98.457	112.259103641457	713	11	99	0	2	714	1	713	Parachlamydiaceae bacterium CRIB39 16S ribosomal RNA gene, partial sequence	blastn	80153	1256	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium CRIB39
16518176	16518176	PRJNA792582_P_NODE_22093_length_366_cov_3.064846_g21279_i0	PRJNA792582	22093	366	3.064846	11.21733636	Bacteria	2	Bacteria	Bacteria	466	1.05e-126	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g21279	i0	90.055	282.448087431694	362	32	98	4	3	362	3893881	3894240	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	103376	466	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
16518183	16518183	PRJNA792582_P_NODE_22693_length_362_cov_1.065744_g21879_i0	PRJNA792582	22693	362	1.065744	3.85799328	Parachlamydia	83551	Bacteria	Bacteria	307	6.630000000000001e-79	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g21879	i0	82.337	116.986187845304	368	51	100	14	1	362	1669	1310	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	42349	307	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
16518188	16518188	PRJNA792582_P_NODE_22853_length_361_cov_0.739583_g22039_i0	PRJNA792582	22853	361	0.739583	2.66989463	Parachlamydiaceae	92713	Bacteria	Bacteria	409	1.76e-109	NTclustered	gi\|1491674\|emb\|Y07555.1\|	83552	g22039	i0	88.034	134.495844875346	351	34	97	5	3	351	1290	946	Parachlamydia acanthamoebae genomic LSU rRNA	blastn	48553	409	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
17355060	17355060	PRJNA792582_P_NODE_16254_length_427_cov_7.573446_g15440_i0	PRJNA792582	16254	427	7.573446	32.33861442	Chlamydiales bacterium CF280911-8	1345607	Bacteria	Bacteria	322	2.84e-83	NTclustered	gi\|512502429\|gb\|KC469550.1\|	1345607	g15440	i0	82.262	132.27868852459	389	54	89	11	39	420	2063	1683	Chlamydiales bacterium CF280911-8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56483	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium CF280911-8
18628706	18628706	PRJNA792582_P_NODE_52335_length_248_cov_1.760000_g51521_i0	PRJNA792582	52335	248	1.76	4.3648	Opitutales bacterium	2026772	Bacteria	Bacteria	202	2.0999999999999998e-47	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g51521	i0	83.122	266.568548387097	237	24	91	14	4	228	1410556	1410324	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	66109	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
19903630	19903630	PRJNA792582_P_NODE_22416_length_364_cov_1.384880_g21602_i0	PRJNA792582	22416	364	1.3848800000000001	5.0409632	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	416	1.0599999999999999e-111	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g21602	i0	87.5	189.409340659341	368	37	100	9	1	364	654047	653685	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	68945	416	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19903810	19903810	PRJNA792582_P_NODE_42276_length_272_cov_1.160804_g41462_i0	PRJNA792582	42276	272	1.160804	3.15738688	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	431	2.74e-116	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g41462	i0	95.221	118.011029411765	272	13	100	0	1	272	1250694	1250965	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	32099	431	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
21179289	21179289	PRJNA792582_P_NODE_20057_length_384_cov_2.424437_g19243_i0	PRJNA792582	20057	384	2.424437	9.30983808	Rohdeia mirabilis	2528008	Bacteria	Bacteria	449	1.11e-121	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g19243	i0	88.021	176.213541666667	384	40	99	5	4	384	3894999	3894619	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	67666	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
21179423	21179423	PRJNA792582_P_NODE_3557_length_862_cov_2.861850_g2913_i0	PRJNA792582	3557	862	2.86185	24.669147	planctomycete str. 139	149588	Bacteria	Bacteria	994	0	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g2913	i0	89.122	113.185614849188	809	75	93	10	18	815	630	1436	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	97566	994	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
22454114	22454114	PRJNA792582_P_NODE_23978_length_352_cov_2.200717_g23164_i0	PRJNA792582	23978	352	2.200717	7.74652384	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	516	9.82e-142	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g23164	i0	93.182	116.213068181818	352	23	99	1	1	351	627520	627169	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	40907	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
22893072	22893072	PRJNA792582_P_NODE_39458_length_279_cov_1.461165_g38644_i0	PRJNA792582	39458	279	1.461165	4.07665035	Parachlamydiaceae	92713	Bacteria	Bacteria	398	2.8599999999999996e-106	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g38644	i0	95.219	152.197132616487	251	12	90	0	9	259	1249720	1249970	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	42463	398	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23729817	23729817	PRJNA792582_P_NODE_34419_length_293_cov_2.063636_g33605_i0	PRJNA792582	34419	293	2.063636	6.04645348	Haloferula helveola	490095	Bacteria	Bacteria	82.4	3.47e-11	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g33605	i0	87.5	0.989761092150171	72	7	25	2	140	211	505902	505833	Haloferula helveola CN-1 DNA, complete genome	blastn	290	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
23729867	23729867	PRJNA792582_P_NODE_39079_length_280_cov_1.487923_g38265_i0	PRJNA792582	39079	280	1.487923	4.1661844	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	451	2.18e-122	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g38265	i0	95.714	223.510714285714	280	12	100	0	1	280	1298	1019	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	62583	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
24167173	24167173	PRJNA792582_P_NODE_54619_length_246_cov_0.890173_g53805_i0	PRJNA792582	54619	246	0.890173	2.18982558	Verrucomicrobiales	48461	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g53805	i0	81.569	251.731707317073	255	31	100	14	1	246	3411479	3411726	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	61926	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
25003421	25003421	PRJNA792582_P_NODE_36600_length_287_cov_0.976636_g35786_i0	PRJNA792582	36600	287	0.976636	2.80294532	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	357	5.02e-94	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g35786	i0	89.236	206.219512195122	288	28	100	2	1	287	2502481	2502766	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	59185	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
25003461	25003461	PRJNA792582_P_NODE_39860_length_278_cov_1.468293_g39046_i0	PRJNA792582	39860	278	1.468293	4.08185454	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	322	1.77e-83	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g39046	i0	88.087	65.4676258992806	277	26	99	6	5	278	277731	277459	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	18200	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
25003465	25003465	PRJNA792582_P_NODE_39980_length_278_cov_1.126829_g39166_i0	PRJNA792582	39980	278	1.126829	3.13258462	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	292	1.39e-74	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g39166	i0	88.571	87.5251798561151	245	20	86	6	6	245	1336496	1336737	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	24332	292	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
25442090	25442090	PRJNA792582_P_NODE_33040_length_300_cov_1.339207_g32226_i0	PRJNA792582	33040	300	1.339207	4.017621	Opitutaceae	134623	Bacteria	Bacteria	422	1.85e-113	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g32226	i0	92.027	95.2166666666667	301	23	100	1	1	300	2557194	2557494	Lacunisphaera limnophila strain IG16b, complete genome	blastn	28565	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila

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