metadata: contig_metadata: 24 rows where bioproject = "PRJNA615175" and tax

24 rows where bioproject = "PRJNA615175" 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
8248398	8248398	PRJNA615175_P_NODE_9047_length_493_cov_2.766667_g8879_i0	PRJNA615175	9047	493	2.766667	13.63966831	Humisphaera sp.	2807514	Bacteria	Bacteria	180	4.94e-50	NR	HEX8912276.1	2807514	g8879	i0	57.7	0.991886409736308	163	44	99.2	3	491	3	160	297	HEX8912276.1 VIT domain-containing protein [Humisphaera sp.]	diamond	489	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
9523367	9523367	PRJNA615175_P_NODE_23788_length_280_cov_2.318841_g23620_i0	PRJNA615175	23788	280	2.318841	6.4927548	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	364	2.919999999999999e-96	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g23620	i0	89.831	139.864285714286	295	15	100	7	1	280	2621967	2621673	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	39162	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10799034	10799034	PRJNA615175_P_NODE_14049_length_379_cov_3.179739_g13881_i0	PRJNA615175	14049	379	3.179739	12.05121081	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	549	1.0499999999999996e-151	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g13881	i0	92.857	86.4300791556728	378	27	99	0	1	378	7629890	7629513	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	32757	549	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
12074558	12074558	PRJNA615175_P_NODE_90_length_2784_cov_3.961638_g84_i0	PRJNA615175	90	2784	3.961638	110.29200192	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	503	4.089999999999999e-152	NR	MBN1347182.1	2026778	g84	i0	34.4	6.78125	898	487	94.9	19	122	2764	45	857	MBN1347182.1 AAA family ATPase [Phycisphaerae bacterium]	diamond	18879	503	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
13349040	13349040	PRJNA615175_P_NODE_20251_length_308_cov_2.400000_g20083_i0	PRJNA615175	20251	308	2.4	7.392	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	257	5.68e-64	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g20083	i0	82.623	50.7857142857143	305	40	97	12	9	307	1831543	1831246	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	15642	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
13349186	13349186	PRJNA615175_P_NODE_29071_length_249_cov_5.494318_g28903_i0	PRJNA615175	29071	249	5.494318	13.680851820000001	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	77.8	5.28e-15	NR	HEU5117438.1	2691532	g28903	i0	69.8	1.24096385542169	53	13	60.2	1	241	92	185	237	HEU5117438.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	309	77.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
14623607	14623607	PRJNA615175_P_NODE_10012_length_464_cov_2.265985_g9844_i0	PRJNA615175	10012	464	2.265985	10.5141704	Phycisphaerae	666505	Bacteria	Bacteria	181	6.25e-50	NR	MDB5294752.1	2052180	g9844	i0	68.2	1.77155172413793	148	45	95	2	23	463	65	211	MDB5294752.1 marine proteobacterial sortase target protein [Phycisphaerales bacterium]	diamond	822	181	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16452560	16452560	PRJNA615175_P_NODE_17813_length_331_cov_4.410853_g17645_i0	PRJNA615175	17813	331	4.410853	14.59992343	Gemmata	113	Bacteria	Bacteria	584	2.4899999999999985e-162	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g17645	i0	98.489	111.111782477341	331	5	100	0	1	331	2941848	2942178	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	36778	584	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
18447176	18447176	PRJNA615175_P_NODE_4375_length_742_cov_1.944694_g4216_i0	PRJNA615175	4375	742	1.944694	14.42962948	Anatilimnocola	2807414	Bacteria	Bacteria	303	3.669999999999999e-101	NR	MFM1997553.1	2026780	g4216	i0	80.3	25.2008086253369	183	36	74	0	671	123	1	183	MFM1997553.1 Deoxycytidine triphosphate deaminase [Planctomycetota bacterium]	diamond	18699	306	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
24821051	24821051	PRJNA615175_P_NODE_17420_length_335_cov_4.354962_g17252_i0	PRJNA615175	17420	335	4.3549620000000004	14.5891227	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	442	1.5999999999999994e-119	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g17252	i0	90.504	202.382089552239	337	29	100	2	1	335	7629543	7629208	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	67798	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
26637082	26637082	PRJNA615175_P_NODE_28201_length_251_cov_0.865169_g28033_i0	PRJNA615175	28201	251	0.865169	2.17157419	Rhodopirellula sp.	2024855	Bacteria	Bacteria	48.9	2.71e-4	NR	NQV22724.1	2024855	g28033	i0	44.1	0.705179282868526	59	33	70.5	0	70	246	159	217	NQV22724.1 BON domain-containing protein [Rhodopirellula sp.]	diamond	177	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp.
27567119	27567119	PRJNA615175_P_NODE_14924_length_366_cov_1.576792_g14756_i0	PRJNA615175	14924	366	1.576792	5.77105872	Pseudomonadati	3379134	Bacteria	Bacteria	87.4	1.32e-17	NR	HID22770.1	2026779	g14756	i0	43.4	1.95901639344262	122	64	100	1	366	1	142	258	HID22770.1 DUF4815 domain-containing protein [Planctomycetaceae bacterium]	diamond	717	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27775443	27775443	PRJNA615175_P_NODE_13764_length_383_cov_1.987097_g13596_i0	PRJNA615175	13764	383	1.987097	7.61058151	Planctomycetes bacterium Pan216	2527975	Bacteria	Bacteria	42.7	0.0139	NR	QDU64224.1	2527975	g13596	i0	37.7	0.415143603133159	53	33	41.5	0	103	261	6	58	QDU64224.1 hypothetical protein Pan216_51130 [Planctomycetes bacterium Pan216]	diamond	159	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
28754049	28754049	PRJNA615175_P_NODE_3547_length_825_cov_2.316489_g3400_i0	PRJNA615175	3547	825	2.316489	19.11103425	Planctomycetota bacterium	2026780	Bacteria	Bacteria	268	1.6999999999999999e-84	NR	MCD6378656.1	2026780	g3400	i0	50.9	1.96	269	129	96.7	2	8	805	109	377	MCD6378656.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium]	diamond	1617	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28975179	28975179	PRJNA615175_P_NODE_25408_length_268_cov_1.579487_g25240_i0	PRJNA615175	25408	268	1.579487	4.23302516	Pirellulales bacterium	2715253	Bacteria	Bacteria	42.4	0.0477	NR	HJN67807.1	2715253	g25240	i0	32.4	0.828358208955224	74	48	82.8	1	268	47	82	153	HJN67807.1 hypothetical protein [Pirellulales bacterium]	diamond	222	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29732638	29732638	PRJNA615175_P_NODE_14710_length_369_cov_1.466216_g14542_i0	PRJNA615175	14710	369	1.466216	5.41033704	Planctomycetota bacterium	2026780	Bacteria	Bacteria	95.9	3.44e-22	NR	MEZ6184495.1	2026780	g14542	i0	44.6	0.821138211382114	101	56	82.1	0	3	305	56	156	MEZ6184495.1 pyridoxamine 5'-phosphate oxidase family protein [Planctomycetota bacterium]	diamond	303	95.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30333546	30333546	PRJNA615175_P_NODE_812_length_1524_cov_3.484493_g747_i0	PRJNA615175	812	1524	3.484493	53.10367332	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87.8	1.81e-15	NR	MBK7641543.1	2026780	g747	i0	52	0.147637795275591	75	36	14.8	0	235	11	7	81	MBK7641543.1 glycerophosphodiester phosphodiesterase [Planctomycetota bacterium]	diamond	225	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30459884	30459884	PRJNA615175_P_NODE_22613_length_289_cov_1.425926_g22445_i0	PRJNA615175	22613	289	1.425926	4.12092614	Aquisphaera insulae	2712864	Bacteria	Bacteria	48.9	3.36e-4	NR	WP_165235776.1	2712864	g22445	i0	67.6	0.695501730103806	34	11	35.3	0	1	102	206	239	WP_165235776.1 sulfite exporter TauE/SafE family protein [Aquisphaera insulae]	diamond	201	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
30662006	30662006	PRJNA615175_P_NODE_3413_length_842_cov_2.855657_g3266_i0	PRJNA615175	3413	842	2.855657	24.04463194	PVC group	1783257	Bacteria	Bacteria	200	2.37e-57	NR	MEN8126979.1	2026780	g3266	i0	39.4	8.02375296912114	282	144	99	7	841	8	176	434	MEN8126979.1 alpha-L-fucosidase [Planctomycetota bacterium]	diamond	6756	201	0.995024875621891	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31534238	31534238	PRJNA615175_P_NODE_3176_length_873_cov_8.558750_g3035_i0	PRJNA615175	3176	873	8.55875	74.7178875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	268	3.71e-85	NR	MFQ5748337.1	2026780	g3035	i0	50.5	11.639175257732	283	129	96.2	5	31	870	35	309	MFQ5748337.1 ornithine cyclodeaminase family protein [Planctomycetota bacterium]	diamond	10161	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31913632	31913632	PRJNA615175_P_NODE_8397_length_515_cov_1.798643_g8229_i0	PRJNA615175	8397	515	1.798643	9.26301145	Pirellula staleyi DSM 6	125	Bacteria	Bacteria	143	4.59e-36	NR	ADB18271.1	530564	g8229	i0	49	0.856310679611651	147	59	85.6	1	1	441	407	537	ADB18271.1 type IV pilus assembly protein PilM [Pirellula staleyi DSM 6068]	diamond	441	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
32008587	32008587	PRJNA615175_P_NODE_35918_length_234_cov_2.677019_g35750_i0	PRJNA615175	35918	234	2.677019	6.26422446	Planctomycetota bacterium	2026780	Bacteria	Bacteria	107	3.79e-25	NR	MCA8965049.1	2026780	g35750	i0	66.2	0.987179487179487	77	26	98.7	0	2	232	285	361	MCA8965049.1 hypothetical protein [Planctomycetota bacterium]	diamond	231	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32135259	32135259	PRJNA615175_P_NODE_18178_length_328_cov_1.207843_g18010_i0	PRJNA615175	18178	328	1.207843	3.96172504	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	108	1.37e-27	NR	WP_077023913.1	1891926	g18010	i0	42.9	1.91158536585366	105	59	96	1	317	3	45	148	WP_077023913.1 pyridoxamine 5'-phosphate oxidase family protein [Fuerstiella marisgermanici]	diamond	627	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
32230242	32230242	PRJNA615175_P_NODE_7038_length_570_cov_4.195171_g6873_i0	PRJNA615175	7038	570	4.195171	23.9124747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	152	1.31e-41	NR	MEY2981677.1	2026780	g6873	i0	43.2	1.92105263157895	185	93	93.7	6	569	36	136	315	MEY2981677.1 hypothetical protein [Planctomycetota bacterium]	diamond	1095	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;