metadata: contig_metadata: 25 rows where bioproject = "PRJNA929522" and tax

25 rows where bioproject = "PRJNA929522" 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
12384447	12384447	PRJNA929522_S_NODE_5430_length_300_cov_2.436123_g5360_i0	PRJNA929522	5430	300	2.436123	7.308369	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g5360	i0	100	0.1	30	0	10	0	200	229	7205167	7205196	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
14933286	14933286	PRJNA929522_S_NODE_7472_length_264_cov_1.612565_g7402_i0	PRJNA929522	7472	264	1.612565	4.2571716	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	145	3.8699999999999995e-30	NTclustered	gi\|2108005054\|gb\|CP070772.1\|	2052180	g7402	i0	83.125	1.70075757575758	160	25	60	2	106	264	3895765	3895923	MAG: Phycisphaerales bacterium isolate bin220 chromosome	blastn	449	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23857693	23857693	PRJNA929522_S_NODE_279_length_1092_cov_2.563297_g243_i0	PRJNA929522	279	1092	2.563297	27.99120324	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	209	1.09e-60	NR	MBL0922610.1	2052180	g243	i0	47.3	3.40659340659341	224	116	61.5	2	419	1090	112	333	MBL0922610.1 hypothetical protein [Phycisphaerales bacterium]	diamond	3720	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
24205016	24205016	PRJNA929522_S_NODE_8479_length_251_cov_0.865169_g8409_i0	PRJNA929522	8479	251	0.865169	2.17157419	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	79	6.71e-16	NR	MAJ46129.1	2026779	g8409	i0	55.4	4.26693227091633	65	29	77.7	0	196	2	13	77	MAJ46129.1 pyridoxamine 5'-phosphate oxidase [Planctomycetaceae bacterium]	diamond	1071	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
25131512	25131512	PRJNA929522_S_NODE_8300_length_253_cov_1.144444_g8230_i0	PRJNA929522	8300	253	1.144444	2.89544332	Planctomycetota bacterium	2026780	Bacteria	Bacteria	122	2.7e-30	NR	MFH0944211.1	2026780	g8230	i0	64.1	0.924901185770751	78	28	92.5	0	253	20	476	553	MFH0944211.1 S9 family peptidase [Planctomycetota bacterium]	diamond	234	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
25131514	25131514	PRJNA929522_S_NODE_9000_length_248_cov_0.862857_g8930_i0	PRJNA929522	9000	248	0.862857	2.13988536	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	161	6.37e-44	NR	MCW5757365.1	2026777	g8930	i0	84.1	8.93951612903226	82	13	99.2	0	1	246	167	248	MCW5757365.1 alanine--tRNA ligase [Phycisphaeraceae bacterium]	diamond	2217	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27119434	27119434	PRJNA929522_S_NODE_7062_length_270_cov_1.903553_g6992_i0	PRJNA929522	7062	270	1.903553	5.1395931	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.9	0.0205	NR	MDB5337226.1	2026779	g6992	i0	42.2	1.48888888888889	64	36	70	1	265	77	572	635	MDB5337226.1 repeat-containing protein [Planctomycetaceae bacterium]	diamond	402	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27348245	27348245	PRJNA929522_S_NODE_2483_length_423_cov_1.914286_g2413_i0	PRJNA929522	2483	423	1.914286	8.09742978	Bacteria	2	Bacteria	Bacteria	105	2.0299999999999998e-24	NR	MCP4452294.1	2026780	g2413	i0	39	6.01418439716312	141	84	98.6	2	3	419	48	188	MCP4452294.1 class I SAM-dependent methyltransferase [Planctomycetota bacterium]	diamond	2544	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27561781	27561781	PRJNA929522_S_NODE_6324_length_283_cov_1.095238_g6254_i0	PRJNA929522	6324	283	1.095238	3.09952354	Pirellulales bacterium	2715253	Bacteria	Bacteria	93.2	1.12e-19	NR	HVU86055.1	2715253	g6254	i0	54.8	0.985865724381625	93	41	98.6	1	4	282	268	359	HVU86055.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Pirellulales bacterium]	diamond	279	93.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27593731	27593731	PRJNA929522_S_NODE_3184_length_375_cov_1.953642_g3114_i0	PRJNA929522	3184	375	1.953642	7.3261575	Planctomycetota bacterium	2026780	Bacteria	Bacteria	90.9	2.41e-18	NR	MDX2116503.1	2026780	g3114	i0	44.5	1.992	128	67	99.2	1	1	372	723	850	MDX2116503.1 alanine--tRNA ligase [Planctomycetota bacterium]	diamond	747	90.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27783207	27783207	PRJNA929522_S_NODE_4364_length_328_cov_1.427451_g4294_i0	PRJNA929522	4364	328	1.427451	4.68203928	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	70.1	1.56e-11	NR	MBY0307982.1	2052180	g4294	i0	46.2	0.713414634146341	78	42	71.3	0	70	303	54	131	MBY0307982.1 hypothetical protein [Phycisphaerales bacterium]	diamond	234	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28042748	28042748	PRJNA929522_S_NODE_10185_length_240_cov_2.305389_g10115_i0	PRJNA929522	10185	240	2.305389	5.5329336	Bacteria	2	Bacteria	Bacteria	112	4.87e-29	NR	MCS6970716.1	2026780	g10115	i0	68.5	9.5375	73	23	91.3	0	222	4	4	76	MCS6970716.1 peroxiredoxin [Planctomycetota bacterium]	diamond	2289	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28137614	28137614	PRJNA929522_S_NODE_5085_length_308_cov_2.191489_g5015_i0	PRJNA929522	5085	308	2.191489	6.7497861199999996	PVC group	1783257	Bacteria	Bacteria	76.3	1.35e-13	NR	MDE0864191.1	1973111	g5015	i0	39.3	2.52272727272727	89	53	86.7	1	307	41	576	663	MDE0864191.1 2-aminoethylphosphonate--pyruvate transaminase [Rubripirellula sp.]	diamond	777	76.6	0.996083550913838	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula sp.
28326731	28326731	PRJNA929522_S_NODE_6646_length_278_cov_0.853659_g6576_i0	PRJNA929522	6646	278	0.853659	2.37317202	Pseudomonadati	3379134	Bacteria	Bacteria	98.2	1.02e-21	NR	MEK6262949.1	2026780	g6576	i0	50	12.8093525179856	92	44	99.3	1	278	3	53	142	MEK6262949.1 epoxide hydrolase family protein [Planctomycetota bacterium]	diamond	3561	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28446227	28446227	PRJNA929522_S_NODE_5606_length_297_cov_1.022321_g5536_i0	PRJNA929522	5606	297	1.022321	3.03629337	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	117	2.45e-28	NR	MCR4411333.1	2691551	g5536	i0	58.2	7.8989898989899	98	40	98	1	296	6	73	170	MCR4411333.1 aldehyde dehydrogenase family protein [Thermoguttaceae bacterium]	diamond	2346	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
29140949	29140949	PRJNA929522_S_NODE_2089_length_460_cov_1.217054_g2019_i0	PRJNA929522	2089	460	1.217054	5.5984484	Planctomycetota bacterium	2026780	Bacteria	Bacteria	50.4	5.96e-4	NR	MFT4511489.1	2026780	g2019	i0	42.9	1.01086956521739	56	32	36.5	0	8	175	278	333	MFT4511489.1 ankyrin repeat protein [Planctomycetota bacterium]	diamond	465	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29235540	29235540	PRJNA929522_S_NODE_2169_length_451_cov_1.433862_g2099_i0	PRJNA929522	2169	451	1.433862	6.46671762	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	58.9	6.62e-8	NR	MDX2035010.1	2691532	g2099	i0	61.7	0.399113082039911	60	22	39.2	1	215	39	2	61	MDX2035010.1 BPSL0067 family protein [Isosphaeraceae bacterium]	diamond	180	58.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29582415	29582415	PRJNA929522_S_NODE_3410_length_363_cov_3.120690_g3340_i0	PRJNA929522	3410	363	3.12069	11.3281047	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.7	5.24e-4	NR	MDF1837216.1	2026780	g3340	i0	34.1	2.75206611570248	85	55	69.4	1	305	54	61	145	MDF1837216.1 bifunctional serine/threonine-protein kinase/formylglycine-generating enzyme family protein [Planctomycetota bacterium]	diamond	999	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29740366	29740366	PRJNA929522_S_NODE_1290_length_575_cov_1.384462_g1223_i0	PRJNA929522	1290	575	1.384462	7.9606565	Singulisphaera sp.	1906241	Bacteria	Bacteria	87.8	2.32e-16	NR	MBV8611957.1	1906241	g1223	i0	31.6	2.04	193	122	97	5	569	12	398	587	MBV8611957.1 hypothetical protein [Singulisphaera sp.]	diamond	1173	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp.
29993407	29993407	PRJNA929522_S_NODE_4511_length_323_cov_1.232000_g4441_i0	PRJNA929522	4511	323	1.232	3.97936	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.4	0.0104	NR	TVS09422.1	2052180	g4441	i0	32.2	0.835913312693498	90	46	74.3	3	56	295	401	485	TVS09422.1 MAG: hypothetical protein EA423_00135 [Phycisphaerales bacterium]	diamond	270	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30087998	30087998	PRJNA929522_S_NODE_9152_length_247_cov_0.885057_g9082_i0	PRJNA929522	9152	247	0.885057	2.18609079	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	69.7	1.23e-11	NR	NLE30217.1	2026778	g9082	i0	49.3	0.862348178137652	71	36	86.2	0	242	30	1283	1353	NLE30217.1 PAS domain S-box protein [Phycisphaerae bacterium]	diamond	213	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30530315	30530315	PRJNA929522_S_NODE_9293_length_246_cov_0.890173_g9223_i0	PRJNA929522	9293	246	0.890173	2.18982558	Planctomycetota bacterium	2026780	Bacteria	Bacteria	79.3	5.15e-15	NR	MBL8692655.1	2026780	g9223	i0	52.1	9.02439024390244	71	33	86.6	1	10	222	282	351	MBL8692655.1 S9 family peptidase [Planctomycetota bacterium]	diamond	2220	79.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31193556	31193556	PRJNA929522_S_NODE_8435_length_251_cov_1.297753_g8365_i0	PRJNA929522	8435	251	1.297753	3.25736003	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	43.5	0.0221	NR	MDT8301803.1	2813034	g8365	i0	32.1	0.968127490039841	81	48	88.4	2	27	248	76	156	MDT8301803.1 LamG-like jellyroll fold domain-containing protein [Sedimentisphaerales bacterium]	diamond	243	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
31390930	31390930	PRJNA929522_S_NODE_3436_length_362_cov_1.598616_g3366_i0	PRJNA929522	3436	362	1.598616	5.78698992	Bacteria	2	Bacteria	Bacteria	123	9.95e-31	NR	MBL9149081.1	2026778	g3366	i0	72.8	2.03038674033149	81	22	67.1	0	9	251	317	397	MBL9149081.1 PLP-dependent transferase [Phycisphaerae bacterium]	diamond	735	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32079573	32079573	PRJNA929522_S_NODE_3558_length_357_cov_0.894366_g3488_i0	PRJNA929522	3558	357	0.894366	3.19288662	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	112	1.6499999999999999e-28	NR	MCU0877786.1	2699754	g3488	i0	72.6	1.32773109243697	73	20	61.3	0	138	356	4	76	MCU0877786.1 peroxiredoxin [Pirellulaceae bacterium]	diamond	474	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae 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);;