metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA674308" 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
1921027	1921027	PRJNA674308_P_NODE_52362_length_162_cov_0.920354_g52127_i0	PRJNA674308	52362	162	0.920354	1.49097348	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	108	2.84e-19	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g52127	i0	98.361	110.104938271605	61	1	38	0	102	162	1064950	1065010	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	17837	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
3195474	3195474	PRJNA674308_P_NODE_17643_length_232_cov_1.136612_g17408_i0	PRJNA674308	17643	232	1.136612	2.63693984	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	407	3.84e-109	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g17408	i0	98.276	61.375	232	4	100	0	1	232	791030	791261	Neochlamydia sp. S13 DNA, complete genome	blastn	14239	407	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
5748146	5748146	PRJNA674308_P_NODE_22545_length_209_cov_1.531250_g22310_i0	PRJNA674308	22545	209	1.53125	3.2003125	Ereboglobus luteus	1796921	Bacteria	Bacteria	84.2	6.5e-12	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g22310	i0	74.766	6.53588516746411	214	40	100	14	1	209	660920	661124	Ereboglobus luteus strain Ho45, complete genome	blastn	1366	84.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
5748166	5748166	PRJNA674308_P_NODE_25445_length_198_cov_2.436242_g25210_i0	PRJNA674308	25445	198	2.436242	4.82375916	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g25210	i0	95.96	53.9848484848485	198	8	100	0	1	198	1250165	1249968	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	10689	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7023371	7023371	PRJNA674308_P_NODE_25766_length_197_cov_1.790541_g25531_i0	PRJNA674308	25766	197	1.790541	3.52736577	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	261	2.6e-65	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g25531	i0	93.678	120.522842639594	174	11	88	0	1	174	2002840	2003013	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	23743	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7023583	7023583	PRJNA674308_P_NODE_5346_length_411_cov_1.334254_g5111_i0	PRJNA674308	5346	411	1.334254	5.48378394	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	604	2.4199999999999993e-168	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g5111	i0	93.046	63.7396593673966	417	23	100	4	1	411	1156607	1156191	Planctomyces sp. SH-PL62, complete genome	blastn	26197	604	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
9573384	9573384	PRJNA674308_P_NODE_45168_length_165_cov_0.896552_g44933_i0	PRJNA674308	45168	165	0.896552	1.4793108	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	86.1	1.36e-12	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g44933	i0	82.979	0.56969696969697	94	16	57	0	50	143	3388094	3388187	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	94	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9573401	9573401	PRJNA674308_P_NODE_46388_length_165_cov_0.896552_g46153_i0	PRJNA674308	46388	165	0.896552	1.4793108	Isosphaera sp. SD2-3	886838	Bacteria	Bacteria	217	4.619999999999999e-52	NTclustered	gi\|307591277\|gb\|GQ889474.1\|	886838	g46153	i0	90.303	30.1818181818182	165	16	100	0	1	165	63	227	Isosphaera sp. SD2-3 16S ribosomal RNA gene, partial sequence	blastn	4980	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp. SD2-3
10848685	10848685	PRJNA674308_P_NODE_18809_length_226_cov_0.853107_g18574_i0	PRJNA674308	18809	226	0.853107	1.92802182	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	351	1.77e-92	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g18574	i0	94.714	99.3451327433628	227	11	100	1	1	226	3991911	3992137	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	22452	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
12124034	12124034	PRJNA674308_P_NODE_31210_length_181_cov_1.568182_g30975_i0	PRJNA674308	31210	181	1.568182	2.83840942	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	132	1.92e-26	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g30975	i0	86.667	18.2044198895028	120	14	66	2	48	166	1294163	1294045	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	3295	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
12124056	12124056	PRJNA674308_P_NODE_34450_length_172_cov_1.691057_g34215_i0	PRJNA674308	34450	172	1.691057	2.90861804	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	296	6.04e-76	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g34215	i0	97.674	130.732558139535	172	4	100	0	1	172	1157094	1157265	Planctomyces sp. SH-PL62, complete genome	blastn	22486	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
12124271	12124271	PRJNA674308_P_NODE_8610_length_324_cov_1.854545_g8375_i0	PRJNA674308	8610	324	1.854545	6.0087258	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	472	1.97e-128	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g8375	i0	92.923	116.287037037037	325	21	100	2	1	324	1251037	1250714	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	37677	472	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
12646031	12646031	PRJNA674308_P_NODE_52170_length_162_cov_0.920354_g51935_i0	PRJNA674308	52170	162	0.920354	1.49097348	Neochlamydia	112987	Bacteria	Bacteria	272	9.51e-69	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g51935	i0	96.914	192.925925925926	162	5	100	0	1	162	652676	652515	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	31254	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13920418	13920418	PRJNA674308_P_NODE_18371_length_228_cov_1.413408_g18136_i0	PRJNA674308	18371	228	1.413408	3.22257024	Gemmata	113	Bacteria	Bacteria	411	2.909999999999999e-110	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g18136	i0	99.123	120.574561403509	228	2	100	0	1	228	860	633	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	27491	411	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
16469387	16469387	PRJNA674308_P_NODE_25533_length_198_cov_1.395973_g25298_i0	PRJNA674308	25533	198	1.395973	2.76402654	Candidatus Protochlamydia	282132	Bacteria	Bacteria	320	4.26e-83	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g25298	i0	96.392	163.227272727273	194	7	98	0	4	197	1249337	1249144	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	32319	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
17222682	17222682	PRJNA674308_P_NODE_15954_length_243_cov_0.798969_g15719_i0	PRJNA674308	15954	243	0.798969	1.94149467	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g15719	i0	87.558	54.8230452674897	217	17	87	10	4	214	1867798	1867586	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	13322	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19771503	19771503	PRJNA674308_P_NODE_18676_length_226_cov_2.016949_g18441_i0	PRJNA674308	18676	226	2.016949	4.55830474	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	351	1.77e-92	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g18441	i0	94.69	251.035398230089	226	12	100	0	1	226	654541	654766	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	56734	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20293074	20293074	PRJNA674308_P_NODE_40396_length_167_cov_0.881356_g40161_i0	PRJNA674308	40396	167	0.881356	1.47186452	Verrucomicrobiota	74201	Bacteria	Bacteria	261	2.14e-65	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g40161	i0	95.152	34.4251497005988	165	8	99	0	3	167	312	476	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	5749	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
21568877	21568877	PRJNA674308_P_NODE_8077_length_335_cov_1.451049_g7842_i0	PRJNA674308	8077	335	1.451049	4.86101415	Candidatus Protochlamydia	282132	Bacteria	Bacteria	470	7.36e-128	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g7842	i0	91.964	73.3522388059701	336	26	100	1	1	335	1250288	1249953	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	24573	470	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
22322036	22322036	PRJNA674308_P_NODE_29958_length_184_cov_2.274074_g29723_i0	PRJNA674308	29958	184	2.274074	4.18429616	Aeoliella mucimassa	2527972	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g29723	i0	100	0.157608695652174	29	0	16	0	82	110	4056023	4055995	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
24870966	24870966	PRJNA674308_P_NODE_38200_length_168_cov_0.873950_g37965_i0	PRJNA674308	38200	168	0.87395	1.468236	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	278	2.14e-70	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g37965	i0	96.429	127.428571428571	168	6	100	0	1	168	1155613	1155446	Planctomyces sp. SH-PL62, complete genome	blastn	21408	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
24871009	24871009	PRJNA674308_P_NODE_43200_length_166_cov_0.888889_g42965_i0	PRJNA674308	43200	166	0.888889	1.47555574	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	119	1.35e-22	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g42965	i0	80.46	49.144578313253	174	19	99	11	1	165	7051380	7051547	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	8158	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;