metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1240805" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1240805" and tax_phylum = "Planctomycetota"

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
1624138	1624138	PRJNA1240805_P_NODE_6502_length_179_cov_13.469231_g6453_i0	PRJNA1240805	6502	179	13.469231	24.10992349	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	215	1.83e-51	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g6453	i0	91.613	52.7039106145251	155	13	87	0	25	179	2001627	2001781	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	9434	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5452954	5452954	PRJNA1240805_P_NODE_6225_length_183_cov_6.626866_g6176_i0	PRJNA1240805	6225	183	6.626866	12.12716478	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	126	9.05e-25	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g6176	i0	88.571	5.85792349726776	105	10	57	2	67	170	8994887	8994784	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1072	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5452956	5452956	PRJNA1240805_P_NODE_6285_length_182_cov_11.436090_g6236_i0	PRJNA1240805	6285	182	11.43609	20.8136838	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	209	8.68e-50	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g6236	i0	91.447	128.021978021978	152	13	84	0	9	160	5362734	5362583	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	23300	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
6727280	6727280	PRJNA1240805_P_NODE_4906_length_206_cov_4.363057_g4857_i0	PRJNA1240805	4906	206	4.363057	8.98789742	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	217	6.029999999999999e-52	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g4857	i0	86.634	1.51941747572816	202	19	96	8	9	206	6010848	6010651	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	313	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
9277656	9277656	PRJNA1240805_P_NODE_1248_length_445_cov_11.858586_g1199_i0	PRJNA1240805	1248	445	11.858586	52.7707077	Phycisphaera sp.	2030824	Bacteria	Bacteria	215	5.19e-51	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g1199	i0	85.507	35.7168539325843	207	28	46	2	62	267	1190410	1190615	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	15894	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
9277693	9277693	PRJNA1240805_P_NODE_4388_length_218_cov_18.532544_g4339_i0	PRJNA1240805	4388	218	18.532544	40.40094592	Aureliella helgolandensis	2527968	Bacteria	Bacteria	202	1.81e-47	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g4339	i0	85.492	320.477064220183	193	28	89	0	4	196	6998995	6998803	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	69864	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
9277709	9277709	PRJNA1240805_P_NODE_5288_length_198_cov_7.046980_g5239_i0	PRJNA1240805	5288	198	7.04698	13.9530204	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	207	3.46e-49	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g5239	i0	91.946	253.792929292929	149	10	75	2	26	173	5362591	5362444	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	50251	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
12529138	12529138	PRJNA1240805_P_NODE_6350_length_181_cov_29.651515_g6301_i0	PRJNA1240805	6350	181	29.651515	53.66924215	Blastopirellula	265487	Bacteria	Bacteria	145	2.4699999999999997e-30	NTclustered	gi\|45635\|emb\|X07408.1\|	314230	g6301	i0	88.889	10.0939226519337	117	13	65	0	21	137	4	120	P.marina 23S ribosomal RNA	blastn	1827	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
13103305	13103305	PRJNA1240805_P_NODE_6531_length_179_cov_3.076923_g6482_i0	PRJNA1240805	6531	179	3.076923	5.50769217	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	230	6.529999999999999e-56	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g6482	i0	91.176	91.1396648044693	170	14	94	1	11	179	3097595	3097426	Pirellula sp. SH-Sr6A, complete genome	blastn	16314	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
13803926	13803926	PRJNA1240805_P_NODE_5571_length_193_cov_4.298611_g5522_i0	PRJNA1240805	5571	193	4.298611	8.29631923	Planctomycetia	203683	Bacteria	Bacteria	298	1.94e-76	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g5522	i0	98.802	122.818652849741	167	2	87	0	10	176	1885	2051	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	23704	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
14378513	14378513	PRJNA1240805_P_NODE_6032_length_186_cov_3.985401_g5983_i0	PRJNA1240805	6032	186	3.985401	7.41284586	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	195	2.5e-45	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5983	i0	89.103	72.8978494623656	156	17	84	0	28	183	2001627	2001782	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	13559	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14378522	14378522	PRJNA1240805_P_NODE_6612_length_178_cov_2.666667_g6563_i0	PRJNA1240805	6612	178	2.666667	4.74666726	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	231	1.7999999999999997e-56	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g6563	i0	94.079	5.75842696629214	152	9	85	0	1	152	1867812	1867661	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1025	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
15652418	15652418	PRJNA1240805_P_NODE_3093_length_266_cov_1.944700_g3044_i0	PRJNA1240805	3093	266	1.9447	5.172902	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	315	2.81e-81	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g3044	i0	89.796	116.808270676692	245	25	92	0	1	245	1843763	1844007	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	31071	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
15652451	15652451	PRJNA1240805_P_NODE_5673_length_191_cov_12.774648_g5624_i0	PRJNA1240805	5673	191	12.774648	24.39957768	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	187	4.32e-43	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g5624	i0	86.471	7.45026178010471	170	23	89	0	22	191	3097749	3097580	Pirellula sp. SH-Sr6A, complete genome	blastn	1423	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
16926690	16926690	PRJNA1240805_P_NODE_4854_length_207_cov_51.664557_g4805_i0	PRJNA1240805	4854	207	51.664557	106.94563298999999	planctomycete str. 449	79870	Bacteria	Bacteria	239	1.2999999999999999e-58	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g4805	i0	90.323	126.80193236715	186	13	89	4	24	207	6	188	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	26248	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
17628262	17628262	PRJNA1240805_P_NODE_6214_length_183_cov_9.925373_g6165_i0	PRJNA1240805	6214	183	9.925373	18.16343259	Planctomycetaceae	126	Bacteria	Bacteria	169	1.4799999999999998e-37	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g6165	i0	83.516	24.5081967213115	182	29	99	1	1	181	5363555	5363374	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	4485	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
19475499	19475499	PRJNA1240805_P_NODE_5776_length_190_cov_4.539007_g5727_i0	PRJNA1240805	5776	190	4.539007	8.6241133	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	147	7.28e-31	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g5727	i0	82.759	12.3684210526316	174	21	89	6	1	169	2623378	2623547	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	2350	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22026242	22026242	PRJNA1240805_P_NODE_9038_length_153_cov_4.336538_g8989_i0	PRJNA1240805	9038	153	4.336538	6.63490314	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	169	1.19e-37	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g8989	i0	86.538	12.0065359477124	156	18	100	3	1	153	5085675	5085520	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	1837	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
24002539	24002539	PRJNA1240805_P_NODE_6859_length_175_cov_3.674603_g6810_i0	PRJNA1240805	6859	175	3.674603	6.43055525	Planctopirus	1649480	Bacteria	Bacteria	132	1.84e-26	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g6810	i0	82.667	125.571428571429	150	25	85	1	1	149	1013	864	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	21975	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus 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);;