metadata: contig_metadata: 23 rows where bioproject = "PRJNA1034994" and tax

23 rows where bioproject = "PRJNA1034994" 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
168239	168239	PRJNA1034994_P_NODE_661_length_642_cov_5.370826_g578_i0	PRJNA1034994	661	642	5.370826	34.48070292	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	680	0	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g578	i0	85.802	144.806853582555	648	85	100	6	1	642	2623571	2622925	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	92966	680	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2282765	2282765	PRJNA1034994_P_NODE_3122_length_293_cov_1.050000_g3038_i0	PRJNA1034994	3122	293	1.05	3.0765	Planctomycetaceae	126	Bacteria	Bacteria	296	1.14e-75	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3038	i0	90.991	178.59385665529	222	17	75	2	73	293	3083037	3082818	Stratiformator vulcanicus strain Pan189 chromosome	blastn	52328	298	0.993288590604027	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
6110755	6110755	PRJNA1034994_P_NODE_4685_length_272_cov_1.547739_g4601_i0	PRJNA1034994	4685	272	1.547739	4.20985008	Planctomycetaceae	126	Bacteria	Bacteria	291	4.86e-74	NTclustered	gi\|1712549334\|gb\|CP036343.1\|	2527971	g4601	i0	86.081	157.033088235294	273	35	99	3	2	272	2344413	2344684	Gimesia algae strain Pan161 chromosome	blastn	42713	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia algae
6546261	6546261	PRJNA1034994_P_NODE_1726_length_387_cov_1.958599_g1642_i0	PRJNA1034994	1726	387	1.958599	7.57977813	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	462	1.44e-125	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g1642	i0	88.402	116.875968992248	388	39	99	6	3	387	1844561	1844945	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	45231	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
9095795	9095795	PRJNA1034994_P_NODE_5428_length_264_cov_1.382199_g5344_i0	PRJNA1034994	5428	264	1.382199	3.64900536	Urbifossiella limnaea	2528023	Bacteria	Bacteria	198	2.93e-46	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g5344	i0	80.451	88.75	266	47	100	5	1	264	4212458	4212196	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	23430	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11646840	11646840	PRJNA1034994_P_NODE_7890_length_247_cov_1.971264_g7806_i0	PRJNA1034994	7890	247	1.971264	4.86902208	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g7806	i0	99.19	156.246963562753	247	2	100	0	1	247	3095125	3095371	Pirellula sp. SH-Sr6A, complete genome	blastn	38593	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
12921933	12921933	PRJNA1034994_P_NODE_1551_length_406_cov_1.879880_g1467_i0	PRJNA1034994	1551	406	1.87988	7.6323128	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	381	4.369999999999999e-101	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g1467	i0	83.942	155.869458128079	411	53	99	12	1	405	2663972	2664375	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	63283	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18020115	18020115	PRJNA1034994_P_NODE_6375_length_253_cov_2.444444_g6291_i0	PRJNA1034994	6375	253	2.444444	6.18444332	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	158	6.17e-44	NR	MDZ4687866.1	2026779	g6291	i0	87.8	0.972332015810277	82	10	97.2	0	4	249	86	167	MDZ4687866.1 arylsulfatase [Planctomycetaceae bacterium]	diamond	246	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
21845148	21845148	PRJNA1034994_P_NODE_638_length_652_cov_2.373057_g555_i0	PRJNA1034994	638	652	2.373057	15.47233164	Planctomycetales bacterium	2053591	Bacteria	Bacteria	793	0	NTclustered	gi\|2210174292\|gb\|CP060262.1\|	2053591	g555	i0	88.72	222.216257668712	656	65	100	7	1	652	3542259	3542909	MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome	blastn	144885	793	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
24394369	24394369	PRJNA1034994_P_NODE_940_length_536_cov_1.166307_g856_i0	PRJNA1034994	940	536	1.166307	6.25140552	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	531	5.55e-146	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g856	i0	85.165	117.369402985075	546	49	100	22	1	536	1843757	1844280	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	62910	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
25233838	25233838	PRJNA1034994_P_NODE_9660_length_242_cov_2.526627_g9576_i0	PRJNA1034994	9660	242	2.526627	6.11443734	Singulisphaera	466152	Bacteria	Bacteria	296	9.12e-76	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g9576	i0	88.797	40.4876033057851	241	27	99	0	1	241	7354298	7354538	Singulisphaera acidiphila DSM 18658, complete genome	blastn	9798	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
26774051	26774051	PRJNA1034994_P_NODE_9481_length_243_cov_0.905882_g9397_i0	PRJNA1034994	9481	243	0.905882	2.20129326	Planctomycetia	203683	Bacteria	Bacteria	139	2.11e-37	NR	MBL9092141.1	2026779	g9397	i0	86.1	3.92592592592593	79	11	97.5	0	239	3	188	266	MBL9092141.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Planctomycetaceae bacterium]	diamond	954	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26908579	26908579	PRJNA1034994_P_NODE_4242_length_278_cov_1.219512_g4158_i0	PRJNA1034994	4242	278	1.219512	3.39024336	Pirellulales bacterium	2715253	Bacteria	Bacteria	157	1.5899999999999996e-43	NR	HEX4130324.1	2715253	g4158	i0	78	2.9568345323741	91	20	98.2	0	278	6	346	436	HEX4130324.1 family 16 glycoside hydrolase [Pirellulales bacterium]	diamond	822	157	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27035132	27035132	PRJNA1034994_P_NODE_4382_length_276_cov_1.492611_g4298_i0	PRJNA1034994	4382	276	1.492611	4.11960636	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	140	1.13e-36	NR	MBL9093521.1	2026779	g4298	i0	79.3	1	92	18	98.9	1	273	1	234	325	MBL9093521.1 pilus assembly protein N-terminal domain-containing protein [Planctomycetaceae bacterium]	diamond	276	140	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27446249	27446249	PRJNA1034994_P_NODE_3343_length_289_cov_1.111111_g3259_i0	PRJNA1034994	3343	289	1.111111	3.21111079	Pirellulales bacterium	2715253	Bacteria	Bacteria	52	3.68e-5	NR	MBN2217511.1	2715253	g3259	i0	42.9	0.653979238754325	63	36	65.4	0	26	214	135	197	MBN2217511.1 hypothetical protein [Pirellulales bacterium]	diamond	189	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27817076	27817076	PRJNA1034994_P_NODE_7504_length_249_cov_0.875000_g7420_i0	PRJNA1034994	7504	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	84.3	3.67e-17	NR	TDJ55487.1	2026780	g7420	i0	62.9	2.24096385542169	62	23	74.7	0	1	186	38	99	TDJ55487.1 MAG: phytoene/squalene synthase family protein [Planctomycetota bacterium]	diamond	558	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28898230	28898230	PRJNA1034994_P_NODE_3888_length_282_cov_1.473684_g3804_i0	PRJNA1034994	3888	282	1.473684	4.15578888	Planctomycetales bacterium	2053591	Bacteria	Bacteria	124	1.07e-30	NR	MCA9232188.1	2053591	g3804	i0	60.2	0.98936170212766	93	36	98.9	1	282	4	71	162	MCA9232188.1 hypothetical protein [Planctomycetales bacterium]	diamond	279	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29340545	29340545	PRJNA1034994_P_NODE_8009_length_247_cov_0.885057_g7925_i0	PRJNA1034994	8009	247	0.885057	2.18609079	Planctomycetales bacterium	2053591	Bacteria	Bacteria	53.1	8.3e-6	NR	MFN0054048.1	2053591	g7925	i0	50	0.607287449392713	50	21	60.7	1	151	2	164	209	MFN0054048.1 zf-HC2 domain-containing protein [Planctomycetales bacterium]	diamond	150	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29403609	29403609	PRJNA1034994_P_NODE_3669_length_285_cov_1.202830_g3585_i0	PRJNA1034994	3669	285	1.20283	3.4280655	Pirellulales bacterium	2715253	Bacteria	Bacteria	66.6	1.52e-10	NR	HEX3869457.1	2715253	g3585	i0	73.7	0.4	38	10	40	0	121	8	1	38	HEX3869457.1 hypothetical protein [Pirellulales bacterium]	diamond	114	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31046498	31046498	PRJNA1034994_P_NODE_8535_length_246_cov_0.890173_g8451_i0	PRJNA1034994	8535	246	0.890173	2.18982558	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	119	7.91e-33	NR	QDT71552.1	2528024	g8451	i0	76.5	2.96341463414634	81	19	98.8	0	245	3	5	85	QDT71552.1 Transposase [Lacipirellula limnantheis]	diamond	729	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
31203733	31203733	PRJNA1034994_P_NODE_9055_length_244_cov_0.900585_g8971_i0	PRJNA1034994	9055	244	0.900585	2.1974274	Anatilimnocola floriformis	2948575	Bacteria	Bacteria	71.6	1.32e-12	NR	WP_254509295.1	2948575	g8971	i0	61.7	0.577868852459016	47	18	57.8	0	5	145	241	287	WP_254509295.1 RNA polymerase sigma factor SigJ [Anatilimnocola floriformis]	diamond	141	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola floriformis
31227660	31227660	PRJNA1034994_P_NODE_7035_length_250_cov_0.870056_g6951_i0	PRJNA1034994	7035	250	0.870056	2.17514	Anatilimnocola	2807414	Bacteria	Bacteria	105	3.27e-24	NR	MBS0208814.1	2026780	g6951	i0	59.8	3.912	82	33	98.4	0	248	3	378	459	MBS0208814.1 S9 family peptidase [Planctomycetota bacterium]	diamond	978	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31765467	31765467	PRJNA1034994_P_NODE_9997_length_241_cov_2.505952_g9913_i0	PRJNA1034994	9997	241	2.505952	6.03934432	Bacteria	2	Bacteria	Bacteria	106	1.05e-25	NR	MCE9605887.1	2052181	g9913	i0	68.4	1.96680497925311	79	25	98.3	0	239	3	24	102	MCE9605887.1 ABC transporter permease subunit [Planctomycetia bacterium]	diamond	474	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;