metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA627467" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA627467" 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
599143	599143	PRJNA627467_P_NODE_1861_length_317_cov_1.716418_g1793_i0	PRJNA627467	1861	317	1.716418	5.44104506	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	69.4	2.95e-7	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g1793	i0	86.154	0.205047318611987	65	8	21	1	217	281	664947	664884	Planctomyces sp. SH-PL14, complete genome	blastn	65	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
1150898	1150898	PRJNA627467_P_NODE_4421_length_316_cov_1.749064_g4353_i0	PRJNA627467	4421	316	1.749064	5.52704224	Candidatus Moanibacter	2480624	Bacteria	Bacteria	145	4.75e-30	NTclustered	gi\|2225500096\|gb\|CP095464.1\|	2026799	g4353	i0	95.604	18.6708860759494	91	2	28	1	222	310	594141	594051	MAG: Verrucomicrobia bacterium isolate LL51 chromosome, complete genome	blastn	5900	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
1875208	1875208	PRJNA627467_P_NODE_12442_length_179_cov_3.053846_g12373_i0	PRJNA627467	12442	179	3.053846	5.46638434	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	243	8.379999999999999e-60	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g12373	i0	91.908	140.888268156425	173	14	97	0	5	177	7052404	7052576	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	25219	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5702714	5702714	PRJNA627467_P_NODE_12205_length_180_cov_2.259542_g12136_i0	PRJNA627467	12205	180	2.259542	4.0671756	Fontisphaera persica	2974023	Bacteria	Bacteria	281	1.79e-71	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g12136	i0	95.48	232.361111111111	177	7	98	1	5	180	3861932	3861756	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	41825	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
6977659	6977659	PRJNA627467_P_NODE_20926_length_154_cov_3.704762_g20857_i0	PRJNA627467	20926	154	3.704762	5.70533348	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	191	2.57e-44	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g20857	i0	88.961	99.7012987012987	154	17	100	0	1	154	3920482	3920635	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	15354	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8252247	8252247	PRJNA627467_P_NODE_10727_length_185_cov_2.000000_g10658_i0	PRJNA627467	10727	185	2	3.7	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	252	1.45e-62	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g10658	i0	91.713	54.1459459459459	181	15	98	0	1	181	4319485	4319305	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	10017	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10803404	10803404	PRJNA627467_P_NODE_2449_length_316_cov_2.614232_g2381_i0	PRJNA627467	2449	316	2.614232	8.26097312	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	71.3	8.17e-8	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g2381	i0	85.333	0.569620253164557	75	3	22	5	25	95	4019792	4019722	Lacunisphaera limnophila strain IG16b, complete genome	blastn	180	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
12078586	12078586	PRJNA627467_P_NODE_20470_length_156_cov_3.196262_g20401_i0	PRJNA627467	20470	156	3.196262	4.98616872	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	159	7.36e-35	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g20401	i0	88.148	36.9230769230769	135	15	90	1	15	148	4318562	4318696	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	5760	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
12078662	12078662	PRJNA627467_P_NODE_6690_length_270_cov_3.877828_g6621_i0	PRJNA627467	6690	270	3.877828	10.4701356	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	91.6	5.24e-14	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g6621	i0	87.5	0.296296296296296	80	9	30	1	1	80	7051874	7051796	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	80	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13353341	13353341	PRJNA627467_P_NODE_13671_length_175_cov_2.365079_g13602_i0	PRJNA627467	13671	175	2.365079	4.13888825	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	237	3.7900000000000005e-58	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g13602	i0	92.262	336.04	168	11	95	2	9	175	2001903	2002069	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	58807	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13353368	13353368	PRJNA627467_P_NODE_16211_length_167_cov_2.110169_g16142_i0	PRJNA627467	16211	167	2.110169	3.52398223	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	285	1.27e-72	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g16142	i0	97.59	109.718562874252	166	4	99	0	2	167	2672137	2672302	Planctomycetes bacterium MalM25 chromosome	blastn	18323	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
14628043	14628043	PRJNA627467_P_NODE_12892_length_178_cov_1.550388_g12823_i0	PRJNA627467	12892	178	1.550388	2.75969064	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	209	8.44e-50	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g12823	i0	88.439	21.6741573033708	173	20	97	0	6	178	2711	2539	Luteolibacter sp. SL250 chromosome	blastn	3858	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15902068	15902068	PRJNA627467_P_NODE_13333_length_176_cov_2.913386_g13264_i0	PRJNA627467	13333	176	2.913386	5.12755936	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	191	3.02e-44	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g13264	i0	87.006	61.875	177	13	98	7	4	175	3047994	3047823	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	10890	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
15902148	15902148	PRJNA627467_P_NODE_20713_length_155_cov_3.264151_g20644_i0	PRJNA627467	20713	155	3.264151	5.05943405	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	276	6.95e-70	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g20644	i0	99.342	551.348387096774	152	1	98	0	4	155	5085816	5085967	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	85459	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
16453478	16453478	PRJNA627467_P_NODE_12553_length_179_cov_1.746154_g12484_i0	PRJNA627467	12553	179	1.746154	3.12561566	Planctomycetia	203683	Bacteria	Bacteria	270	3.849999999999999e-68	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g12484	i0	95.808	203.279329608939	167	7	93	0	5	171	5936397	5936231	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	36387	272	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17177122	17177122	PRJNA627467_P_NODE_19194_length_161_cov_1.785714_g19125_i0	PRJNA627467	19194	161	1.785714	2.87499954	Pedosphaera parvula	1032527	Bacteria	Bacteria	182	1.64e-41	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g19125	i0	90	13.944099378882	140	14	87	0	18	157	2372	2233	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	2245	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
17728668	17728668	PRJNA627467_P_NODE_19814_length_159_cov_3.100000_g19745_i0	PRJNA627467	19814	159	3.1	4.929	Tuwongella	2051044	Bacteria	Bacteria	220	3.4099999999999998e-53	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g19745	i0	92.258	120.333333333333	155	12	97	0	4	158	3454755	3454909	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	19133	222	0.990990990990991	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
17728846	17728846	PRJNA627467_P_NODE_8894_length_195_cov_4.452055_g8825_i0	PRJNA627467	8894	195	4.452055	8.68150725	Gemmata	113	Bacteria	Bacteria	163	7.46e-36	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g8825	i0	83.708	4	178	23	89	6	11	184	7002874	7003049	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	780	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
18451188	18451188	PRJNA627467_P_NODE_14435_length_172_cov_5.731707_g14366_i0	PRJNA627467	14435	172	5.731707	9.85853604	Caulifigura coniformis	2527983	Bacteria	Bacteria	300	4.67e-77	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g14366	i0	98.81	65.3720930232558	168	2	98	0	5	172	2925564	2925731	Caulifigura coniformis strain Pan44 chromosome	blastn	11244	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
19002181	19002181	PRJNA627467_P_NODE_13115_length_177_cov_2.054688_g13046_i0	PRJNA627467	13115	177	2.054688	3.63679776	Planctomycetia	203683	Bacteria	Bacteria	261	2.28e-65	NTclustered	gi\|12583972\|gb\|AF245376.1\|AF245376	149591	g13046	i0	93.678	165.64406779661	174	11	98	0	4	177	2202	2375	Planctomycete str. 670 23S ribosomal RNA gene, partial sequence	blastn	29319	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 670
19725741	19725741	PRJNA627467_P_NODE_16536_length_166_cov_3.940171_g16467_i0	PRJNA627467	16536	166	3.940171	6.54068386	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	167	4.76e-37	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g16467	i0	85.625	6.7710843373494	160	21	95	2	4	161	2623363	2623204	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	1124	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19725877	19725877	PRJNA627467_P_NODE_8856_length_196_cov_2.979592_g8787_i0	PRJNA627467	8856	196	2.979592	5.84000032	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	252	1.56e-62	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g8787	i0	90.206	21.8775510204082	194	17	99	1	3	196	1600275	1600466	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	4288	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
19725885	19725885	PRJNA627467_P_NODE_9876_length_188_cov_2.122302_g9807_i0	PRJNA627467	9876	188	2.122302	3.98992776	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	246	6.889999999999999e-61	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g9807	i0	90.761	322.356382978723	184	17	98	0	1	184	1868774	1868591	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	60603	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
24825325	24825325	PRJNA627467_P_NODE_17120_length_165_cov_2.551724_g17051_i0	PRJNA627467	17120	165	2.551724	4.2103446	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	69.4	1.37e-7	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g17051	i0	97.5	1.20606060606061	40	1	24	0	57	96	671582	671621	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	199	69.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales 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);;