metadata: contig_metadata: 18 rows where bioproject = "PRJNA898105" and tax

18 rows where bioproject = "PRJNA898105" 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
3424673	3424673	PRJNA898105_P_NODE_7563_length_245_cov_0.895349_g7363_i0	PRJNA898105	7563	245	0.895349	2.19360505	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g7363	i0	97.959	227.955102040816	245	5	100	0	1	245	532	776	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	55849	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
3424682	3424682	PRJNA898105_P_NODE_8103_length_242_cov_0.911243_g7903_i0	PRJNA898105	8103	242	0.911243	2.20520806	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g7903	i0	93.023	0.177685950413223	43	3	18	0	200	242	594295	594337	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	43	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
5977138	5977138	PRJNA898105_P_NODE_3745_length_298_cov_1.555556_g3545_i0	PRJNA898105	3745	298	1.555556	4.63555688	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	5.059999999999997e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3545	i0	93.289	116.684563758389	298	20	100	0	1	298	2060038	2059741	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	34772	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
5977160	5977160	PRJNA898105_P_NODE_6405_length_250_cov_0.870056_g6205_i0	PRJNA898105	6405	250	0.870056	2.17514	Lacipirellula parvula	2650471	Bacteria	Bacteria	340	4.31e-89	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g6205	i0	91.2	1	250	22	100	0	1	250	3775882	3776131	Lacipirellula parvula PX69 DNA, complete genome	blastn	250	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
7252013	7252013	PRJNA898105_P_NODE_8446_length_236_cov_2.404908_g8246_i0	PRJNA898105	8446	236	2.404908	5.67558288	uncultured Chlamydia sp.	199738	Bacteria	Bacteria	381	2.379999999999999e-101	NTclustered	gi\|170792156\|gb\|EU403820.1\|	199738	g8246	i0	95.763	106.728813559322	236	10	100	0	1	236	378	143	Uncultured Chlamydia sp. clone MP9B13 16S ribosomal RNA gene, partial sequence	blastn	25188	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	uncultured Chlamydia sp.
7622250	7622250	PRJNA898105_P_NODE_3146_length_330_cov_1.198444_g2946_i0	PRJNA898105	3146	330	1.198444	3.9548652	Chlamydiia	204429	Bacteria	Bacteria	431	3.419999999999999e-116	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g2946	i0	90.741	100.318181818182	324	29	98	1	1	324	2363406	2363728	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	33105	433	0.995381062355658	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
12723751	12723751	PRJNA898105_P_NODE_1970_length_426_cov_1.699717_g1770_i0	PRJNA898105	1970	426	1.699717	7.24079442	Chlamydiia	204429	Bacteria	Bacteria	604	2.509999999999999e-168	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g1770	i0	92.272	137.478873239437	427	32	100	1	1	426	2361608	2361182	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	58566	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16546739	16546739	PRJNA898105_P_NODE_4353_length_283_cov_1.642857_g4153_i0	PRJNA898105	4353	283	1.642857	4.64928531	Humisphaera	2807511	Bacteria	Bacteria	361	3.82e-95	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4153	i0	92.829	91.0459363957597	251	14	88	3	32	281	5064105	5063858	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	25766	363	0.994490358126722	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
17452022	17452022	PRJNA898105_P_NODE_2534_length_369_cov_1.040541_g2334_i0	PRJNA898105	2534	369	1.040541	3.83959629	Candidatus Syngnamydia medusae	3141954	Bacteria	Bacteria	492	1.7399999999999996e-134	NTclustered	gi\|1127901232\|emb\|LT599033.1\|	3141954	g2334	i0	90.786	383.777777777778	369	32	99	2	1	368	3328	2961	Uncultured Simkania sp. partial 23S rRNA gene, isolate M1	blastn	141614	492	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia medusae
23826011	23826011	PRJNA898105_P_NODE_6759_length_248_cov_1.320000_g6559_i0	PRJNA898105	6759	248	1.32	3.2736	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g6559	i0	95.968	126.016129032258	248	10	100	0	1	248	1826610	1826363	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	31252	403	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
26644053	26644053	PRJNA898105_P_NODE_6441_length_250_cov_0.870056_g6241_i0	PRJNA898105	6441	250	0.870056	2.17514	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	142	5.189999999999999e-37	NR	HEY1173498.1	2499141	g6241	i0	91.6	2.976	83	7	99.6	0	249	1	809	891	HEY1173498.1 CusA/CzcA family heavy metal efflux RND transporter [Verrucomicrobiia bacterium]	diamond	744	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27277112	27277112	PRJNA898105_P_NODE_7483_length_245_cov_0.895349_g7283_i0	PRJNA898105	7483	245	0.895349	2.19360505	Gemmataceae bacterium	2052164	Bacteria	Bacteria	122	1.48e-30	NR	HZV08024.1	2052164	g7283	i0	80.2	3.95510204081633	81	16	99.2	0	243	1	345	425	HZV08024.1 hypothetical protein [Gemmataceae bacterium]	diamond	969	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29802948	29802948	PRJNA898105_P_NODE_4651_length_278_cov_1.765854_g4451_i0	PRJNA898105	4651	278	1.765854	4.90907412	Prosthecobacter sp.	1965333	Bacteria	Bacteria	111	3.5300000000000003e-26	NR	MEQ1747971.1	1965333	g4451	i0	68.1	1.97482014388489	91	29	98.2	0	6	278	1591	1681	MEQ1747971.1 putative Ig domain-containing protein [Prosthecobacter sp.]	diamond	549	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30308986	30308986	PRJNA898105_P_NODE_6472_length_250_cov_0.870056_g6272_i0	PRJNA898105	6472	250	0.870056	2.17514	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	148	1.5799999999999994e-42	NR	MEO6784820.1	2811408	g6272	i0	91.6	0.996	83	7	99.6	0	1	249	33	115	MEO6784820.1 acetate/propionate family kinase [Chthoniobacteraceae bacterium]	diamond	249	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31224662	31224662	PRJNA898105_P_NODE_7735_length_244_cov_0.900585_g7535_i0	PRJNA898105	7735	244	0.900585	2.1974274	Paludisphaera rhizosphaerae	2711216	Bacteria	Bacteria	116	7.789999999999999e-31	NR	WP_165074790.1	2711216	g7535	i0	79.4	0.836065573770492	68	14	83.6	0	1	204	103	170	WP_165074790.1 hypothetical protein [Paludisphaera rhizosphaerae]	diamond	204	116	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera rhizosphaerae
31762421	31762421	PRJNA898105_P_NODE_4557_length_280_cov_1.410628_g4357_i0	PRJNA898105	4557	280	1.410628	3.9497584	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.6	7.46e-7	NR	MES2735671.1	2026799	g4357	i0	35.7	1.52142857142857	70	44	75	1	55	264	381	449	MES2735671.1 Fic family protein [Verrucomicrobiota bacterium]	diamond	426	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31888919	31888919	PRJNA898105_P_NODE_1917_length_433_cov_1.494444_g1717_i0	PRJNA898105	1917	433	1.494444	6.47094252	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	95.9	8.18e-20	NR	MBS0645922.1	2026799	g1717	i0	38.2	5.96535796766744	144	83	98.4	3	6	431	842	981	MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	2583	95.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32276613	32276613	PRJNA898105_P_NODE_5698_length_259_cov_1.424731_g5498_i0	PRJNA898105	5698	259	1.424731	3.69005329	Bacteria	2	Bacteria	Bacteria	139	3.26e-37	NR	HMP82642.1	2026799	g5498	i0	74.4	5.90733590733591	86	22	99.6	0	258	1	209	294	HMP82642.1 acyl-CoA reductase [Verrucomicrobiota bacterium]	diamond	1530	140	0.992857142857143	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium

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