metadata: contig_metadata: 28 rows where bioproject = "PRJNA689790" and tax

28 rows where bioproject = "PRJNA689790" 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_species
668711	668711	PRJNA689790_S_NODE_14201_length_160_cov_2.170732_g14086_i0	PRJNA689790	14201	160	2.170732	3.4731712	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	183	4.5099999999999996e-42	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g14086	i0	90.58	6.41875	138	13	86	0	1	138	2191690	2191553	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1027	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
3219618	3219618	PRJNA689790_S_NODE_5703_length_251_cov_1.144860_g5588_i0	PRJNA689790	5703	251	1.14486	2.8735986	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	127	8.24e-33	NR	MCE5266673.1	2026779	g5588	i0	76.8	10.792828685259	82	19	98	0	247	2	209	290	MCE5266673.1 elongation factor Tu [Planctomycetaceae bacterium]	diamond	2709	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomycetaceae bacterium
3729994	3729994	PRJNA689790_S_NODE_4503_length_286_cov_1.871486_g4388_i0	PRJNA689790	4503	286	1.871486	5.35244996	Planctomycetales bacterium 1	2053591	Bacteria	Bacteria	109	1.75e-25	NR	QGJ68794.1	2603660	g4388	i0	58.5	1.96153846153846	94	36	96.5	2	3	278	321	413	QGJ68794.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Planctomycetales bacterium 10988]	diamond	561	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales		Planctomycetales bacterium 10988
21071204	21071204	PRJNA689790_S_NODE_9897_length_188_cov_2.013245_g9782_i0	PRJNA689790	9897	188	2.013245	3.7849006	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	222	1.16e-53	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g9782	i0	89.266	10.6010638297872	177	19	94	0	12	188	1867436	1867260	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1993	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaeraceae bacterium
24894903	24894903	PRJNA689790_S_NODE_12020_length_172_cov_1.444444_g11905_i0	PRJNA689790	12020	172	1.444444	2.48444368	Bacteria	2	Bacteria	Bacteria	87.8	1.68e-18	NR	MEP0848726.1	2026778	g11905	i0	77.2	6.94186046511628	57	12	97.7	1	3	170	210	266	MEP0848726.1 aldehyde dehydrogenase family protein [Phycisphaerae bacterium]	diamond	1194	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
24894919	24894919	PRJNA689790_S_NODE_16460_length_151_cov_2.394737_g16345_i0	PRJNA689790	16460	151	2.394737	3.61605287	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	207	2.49e-49	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g16345	i0	91.447	42.7086092715232	152	12	100	1	1	151	1867034	1866883	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	6449	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaeraceae bacterium
27271961	27271961	PRJNA689790_S_NODE_10663_length_182_cov_1.337931_g10548_i0	PRJNA689790	10663	182	1.337931	2.43503442	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	58.5	4.42e-8	NR	MCB9855559.1	2052180	g10548	i0	45.3	1.23626373626374	75	22	94	2	181	11	2032	2105	MCB9855559.1 thrombospondin type 3 repeat-containing protein [Phycisphaerales bacterium]	diamond	225	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
27303735	27303735	PRJNA689790_S_NODE_16003_length_153_cov_1.344828_g15888_i0	PRJNA689790	16003	153	1.344828	2.05758684	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	81.3	2.95e-16	NR	MCC6952351.1	2052180	g15888	i0	76.5	5	51	12	100	0	153	1	621	671	MCC6952351.1 aminomethyl-transferring glycine dehydrogenase [Phycisphaerales bacterium]	diamond	765	81.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
27651116	27651116	PRJNA689790_S_NODE_15704_length_154_cov_1.666667_g15589_i0	PRJNA689790	15704	154	1.666667	2.56666718	Planctomycetota bacterium	2026780	Bacteria	Bacteria	65.1	1.43e-10	NR	MBL8723148.1	2026780	g15589	i0	63	2.64935064935065	46	17	89.6	0	2	139	378	423	MBL8723148.1 acetyl-CoA hydrolase/transferase family protein [Planctomycetota bacterium]	diamond	408	65.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
27662662	27662662	PRJNA689790_S_NODE_2744_length_382_cov_3.214493_g2629_i0	PRJNA689790	2744	382	3.214493	12.27936326	Bacteria	2	Bacteria	Bacteria	112	7.62e-26	NR	MBX3467716.1	2026780	g2629	i0	47.3	5.27748691099476	112	56	87.2	2	378	46	1988	2097	MBX3467716.1 hypothetical protein [Planctomycetota bacterium]	diamond	2016	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
27809077	27809077	PRJNA689790_S_NODE_12744_length_168_cov_1.190840_g12629_i0	PRJNA689790	12744	168	1.19084	2.0006112	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.3	1.16e-6	NR	MFM7561483.1	2026780	g12629	i0	58.7	1.64285714285714	46	19	82.1	0	10	147	649	694	MFM7561483.1 beta strand repeat-containing protein [Planctomycetota bacterium]	diamond	276	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
27935247	27935247	PRJNA689790_S_NODE_14325_length_160_cov_1.065041_g14210_i0	PRJNA689790	14325	160	1.065041	1.7040656	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	52.4	4.83e-6	NR	MCC7192158.1	2026777	g14210	i0	49	0.95625	51	20	95.6	1	7	159	363	407	MCC7192158.1 biosynthetic-type acetolactate synthase large subunit [Phycisphaeraceae bacterium]	diamond	153	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaeraceae bacterium
28093006	28093006	PRJNA689790_S_NODE_14485_length_159_cov_1.508197_g14370_i0	PRJNA689790	14485	159	1.508197	2.39803323	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.00248	NR	MAE78070.1	2026780	g14370	i0	38.5	1.9622641509434	52	29	98.1	2	157	2	1846	1894	MAE78070.1 hypothetical protein [Planctomycetota bacterium]	diamond	312	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
28598353	28598353	PRJNA689790_S_NODE_13367_length_164_cov_2.039370_g13252_i0	PRJNA689790	13367	164	2.03937	3.3445668	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	87	2.83e-19	NR	MBY0307717.1	2052180	g13252	i0	71.2	0.951219512195122	52	15	95.1	0	7	162	145	196	MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	156	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
28767521	28767521	PRJNA689790_S_NODE_7507_length_215_cov_5.011236_g7392_i0	PRJNA689790	7507	215	5.011236	10.7741574	Planctomycetota	203682	Bacteria	Bacteria	79.7	2.38e-15	NR	MBE0536547.1	2026778	g7392	i0	72.5	9.99069767441861	51	14	71.2	0	213	61	499	549	MBE0536547.1 hydroxylamine reductase [Phycisphaerae bacterium]	diamond	2148	80.1	0.995006242197254	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
28787470	28787470	PRJNA689790_S_NODE_16027_length_153_cov_1.344828_g15912_i0	PRJNA689790	16027	153	1.344828	2.05758684	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	56.2	1.81e-7	NR	GDX99154.1	2026778	g15912	i0	58.5	6.35294117647059	41	17	80.4	0	1	123	14	54	GDX99154.1 hypothetical protein LBMAG48_15580 [Phycisphaerae bacterium]	diamond	972	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
28913731	28913731	PRJNA689790_S_NODE_8968_length_197_cov_3.156250_g8853_i0	PRJNA689790	8968	197	3.15625	6.2178125	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.4	2.4e-9	NR	HAK97666.1	2026780	g8853	i0	40	1.97969543147208	65	39	99	0	197	3	1563	1627	HAK97666.1 hypothetical protein [Planctomycetota bacterium]	diamond	390	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29071999	29071999	PRJNA689790_S_NODE_10408_length_184_cov_1.333333_g10293_i0	PRJNA689790	10408	184	1.333333	2.45333272	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.3	1.37e-6	NR	MFC1479087.1	2026780	g10293	i0	47.4	4.58152173913043	57	29	92.9	1	9	179	231	286	MFC1479087.1 LamG-like jellyroll fold domain-containing protein [Planctomycetota bacterium]	diamond	843	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29608204	29608204	PRJNA689790_S_NODE_10890_length_180_cov_1.629371_g10775_i0	PRJNA689790	10890	180	1.629371	2.9328678	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.1	1.18e-8	NR	MDP6929221.1	2026780	g10775	i0	50.8	2.95	59	28	96.7	1	6	179	258	316	MDP6929221.1 histidinol dehydrogenase [Planctomycetota bacterium]	diamond	531	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29987616	29987616	PRJNA689790_S_NODE_8291_length_205_cov_1.738095_g8176_i0	PRJNA689790	8291	205	1.738095	3.56309475	Planctomycetota bacterium	2026780	Bacteria	Bacteria	66.2	1.19e-10	NR	MFC1758885.1	2026780	g8176	i0	50.8	2.59024390243902	61	30	89.3	0	204	22	1458	1518	MFC1758885.1 glutamate synthase large subunit [Planctomycetota bacterium]	diamond	531	66.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
30745856	30745856	PRJNA689790_S_NODE_14534_length_159_cov_1.270492_g14419_i0	PRJNA689790	14534	159	1.270492	2.02008228	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	68.2	1.2e-11	NR	MBY0307194.1	2052180	g14419	i0	60.4	1	53	20	98.1	1	159	4	165	217	MBY0307194.1 cation transporter [Phycisphaerales bacterium]	diamond	159	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
30935522	30935522	PRJNA689790_S_NODE_14694_length_158_cov_1.611570_g14579_i0	PRJNA689790	14694	158	1.61157	2.5462806	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	48.5	1.46e-5	NR	MBY0307178.1	2052180	g14579	i0	48.9	0.854430379746835	45	23	85.4	0	153	19	44	88	MBY0307178.1 hypothetical protein [Phycisphaerales bacterium]	diamond	135	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
30967153	30967153	PRJNA689790_S_NODE_15434_length_155_cov_1.652542_g15319_i0	PRJNA689790	15434	155	1.652542	2.5614401	Planctomycetota bacterium	2026780	Bacteria	Bacteria	102	1.4399999999999994e-23	NR	NRA37879.1	2026780	g15319	i0	82.4	0.987096774193548	51	9	98.7	0	155	3	482	532	NRA37879.1 acetate--CoA ligase [Planctomycetota bacterium]	diamond	153	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
31504607	31504607	PRJNA689790_S_NODE_14536_length_159_cov_1.262295_g14421_i0	PRJNA689790	14536	159	1.262295	2.00704905	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.00854	NR	MEM9083324.1	2026780	g14421	i0	36.7	0.924528301886792	49	27	84.9	1	20	154	279	327	MEM9083324.1 glycosidase [Planctomycetota bacterium]	diamond	147	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32169028	32169028	PRJNA689790_S_NODE_9638_length_191_cov_1.012987_g9523_i0	PRJNA689790	9638	191	1.012987	1.93480517	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.7	1.13e-6	NR	MEL6894797.1	2026780	g9523	i0	46.6	1.82198952879581	58	30	91.1	1	188	15	426	482	MEL6894797.1 arylsulfatase [Planctomycetota bacterium]	diamond	348	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32200477	32200477	PRJNA689790_S_NODE_11898_length_173_cov_1.147059_g11783_i0	PRJNA689790	11898	173	1.147059	1.98441207	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	133	1.58e-34	NR	MBY0309260.1	2052180	g11783	i0	96.5	0.988439306358382	57	2	98.8	0	3	173	10	66	MBY0309260.1 FYVE zinc finger domain-containing protein [Phycisphaerales bacterium]	diamond	171	133	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
32465211	32465211	PRJNA689790_S_NODE_13919_length_162_cov_0.936000_g13804_i0	PRJNA689790	13919	162	0.936	1.51632	Bacteria	2	Bacteria	Bacteria	60.8	4.88e-9	NR	MEM7453634.1	2026780	g13804	i0	54.2	1.74074074074074	48	21	88.9	1	6	149	290	336	MEM7453634.1 GTP-binding protein [Planctomycetota bacterium]	diamond	282	61.2	0.993464052287582	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32800298	32800298	PRJNA689790_S_NODE_13420_length_164_cov_1.527559_g13305_i0	PRJNA689790	13420	164	1.5275589999999999	2.50519676	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	112	2.76e-29	NR	MBY0307717.1	2052180	g13305	i0	90.2	0.932926829268293	51	5	93.3	0	1	153	178	228	MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	153	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales 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);;