metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA285816" 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
1059201	1059201	PRJNA285816_S_NODE_28581_length_163_cov_0.912281_g28479_i0	PRJNA285816	28581	163	0.912281	1.48701803	Pseudomonadati	3379134	Bacteria	Bacteria	180	5.97e-41	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g28479	i0	86.667	43.1165644171779	165	18	100	4	1	163	1826549	1826387	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	7028	180	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
2922569	2922569	PRJNA285816_S_NODE_14883_length_200_cov_3.238411_g14781_i0	PRJNA285816	14883	200	3.238411	6.476822	uncultured Prosthecobacter sp.	522608	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|595333799\|gb\|KF945042.1\|	522608	g14781	i0	100	99.635	200	0	100	0	1	200	982	1181	Uncultured Prosthecobacter sp. clone FCW2D4 16S ribosomal RNA gene, partial sequence	blastn	19927	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	uncultured Prosthecobacter sp.
2922710	2922710	PRJNA285816_S_NODE_24843_length_168_cov_0.873950_g24741_i0	PRJNA285816	24843	168	0.87395	1.468236	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	215	1.7e-51	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g24741	i0	89.881	9.05357142857143	168	16	100	1	1	168	2191348	2191182	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1521	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
2922721	2922721	PRJNA285816_S_NODE_26043_length_166_cov_1.324786_g25941_i0	PRJNA285816	26043	166	1.324786	2.19914476	Caulifigura coniformis	2527983	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g25941	i0	100	0.180722891566265	30	0	18	0	101	130	250837	250866	Caulifigura coniformis strain Pan44 chromosome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
4199304	4199304	PRJNA285816_S_NODE_9924_length_231_cov_2.302198_g9822_i0	PRJNA285816	9924	231	2.302198	5.31807738	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	414	2.29e-111	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g9822	i0	99.13	128.108225108225	230	2	99	0	2	231	326	555	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	29593	414	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5475271	5475271	PRJNA285816_S_NODE_11225_length_221_cov_2.058140_g11123_i0	PRJNA285816	11225	221	2.05814	4.5484894	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	392	1.0199999999999999e-104	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g11123	i0	98.643	152.764705882353	221	3	100	0	1	221	573	793	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	33761	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
6749638	6749638	PRJNA285816_S_NODE_17406_length_189_cov_2.185714_g17304_i0	PRJNA285816	17406	189	2.185714	4.13099946	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	344	2.39e-90	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g17304	i0	99.471	277.989417989418	189	1	100	0	1	189	944	1132	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	52540	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
8025416	8025416	PRJNA285816_S_NODE_5227_length_301_cov_3.523810_g5125_i0	PRJNA285816	5227	301	3.52381	10.6066681	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	556	4.87e-154	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g5125	i0	100	280.794019933555	301	0	100	0	1	301	4805	4505	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	84519	556	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11262359	11262359	PRJNA285816_S_NODE_8689_length_244_cov_1.189744_g8587_i0	PRJNA285816	8689	244	1.189744	2.90297536	Candidatus Rhabdochlamydia	292833	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|2082223669\|gb\|CP075585.1\|	225148	g8587	i0	92.683	159.811475409836	246	14	100	4	1	244	1019600	1019843	Candidatus Rhabdochlamydia porcellionis strain 15C chromosome, complete genome	blastn	38994	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis
11850600	11850600	PRJNA285816_S_NODE_18810_length_184_cov_1.962963_g18708_i0	PRJNA285816	18810	184	1.962963	3.61185192	Coraliomargarita algicola	3092156	Bacteria	Bacteria	91.6	3.33e-14	NTclustered	gi\|2623481368\|gb\|CP138858.1\|	3092156	g18708	i0	83.178	25.0815217391304	107	10	54	6	79	178	1496467	1496362	Coraliomargarita algicola strain J2-16 chromosome, complete genome	blastn	4615	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita algicola
11850748	11850748	PRJNA285816_S_NODE_29950_length_159_cov_2.381818_g29848_i0	PRJNA285816	29950	159	2.381818	3.78709062	Aquisphaera giovannonii	406548	Bacteria	Bacteria	176	7.49e-40	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g29848	i0	87.179	341.779874213836	156	18	97	2	5	159	9143375	9143221	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	54343	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
12537636	12537636	PRJNA285816_S_NODE_20570_length_178_cov_5.503876_g20468_i0	PRJNA285816	20570	178	5.503876	9.79689928	Bacteria	2	Bacteria	Bacteria	183	5.12e-42	NTclustered	gi\|2076416356\|gb\|CP076040.1\|	2684114	g20468	i0	86.391	81.7022471910112	169	22	94	1	1	168	4360171	4360339	Opitutia bacterium ISCC 52 isolate E3 chromosome, complete genome	blastn	14543	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium ISCC 52
13125788	13125788	PRJNA285816_S_NODE_19071_length_183_cov_2.380597_g18969_i0	PRJNA285816	19071	183	2.380597	4.35649251	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	224	3.1199999999999996e-54	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g18969	i0	90.23	42.6885245901639	174	14	95	3	11	183	2190391	2190220	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	7812	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14400951	14400951	PRJNA285816_S_NODE_19372_length_182_cov_1.954887_g19270_i0	PRJNA285816	19372	182	1.954887	3.55789434	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g19270	i0	100	126.230769230769	182	0	100	0	1	182	1488	1669	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	22974	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
16361650	16361650	PRJNA285816_S_NODE_8933_length_241_cov_1.333333_g8831_i0	PRJNA285816	8933	241	1.333333	3.21333253	Gemmata	113	Bacteria	Bacteria	296	9.08e-76	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g8831	i0	90.991	106.107883817427	222	16	91	4	20	239	558741	558522	Gemmata sp. SH-PL17, complete genome	blastn	25572	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
24598045	24598045	PRJNA285816_S_NODE_16320_length_194_cov_1.096552_g16218_i0	PRJNA285816	16320	194	1.096552	2.12731088	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	231	2e-56	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g16218	i0	88.205	96.4072164948454	195	21	100	2	1	194	1729153	1728960	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	18703	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24598266	24598266	PRJNA285816_S_NODE_7120_length_264_cov_2.283721_g7018_i0	PRJNA285816	7120	264	2.283721	6.02902344	Urbifossiella limnaea	2528023	Bacteria	Bacteria	287	6.07e-73	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g7018	i0	86.232	44.9015151515151	276	24	100	8	1	264	2020310	2020037	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	11854	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea

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