metadata: contig_metadata: 22 rows where bioproject = "PRJNA1214993", tax_clade = "PVC group" and tax

22 rows where bioproject = "PRJNA1214993", tax_clade = "PVC group" 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
2881177	2881177	PRJNA1214993_P_NODE_13503_length_300_cov_1.775330_g13317_i0	PRJNA1214993	13503	300	1.77533	5.32599	root	1	Root_unresolved	Root_unresolved	110	5.46e-28	NR	MDG2093923.1	2052180	g13317	i0	64.1	3.85	78	28	78	0	1	234	128	205	MDG2093923.1 adenylyl-sulfate kinase [Phycisphaerales bacterium]	diamond	1155	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
2881212	2881212	PRJNA1214993_P_NODE_18223_length_262_cov_2.000000_g18037_i0	PRJNA1214993	18223	262	2	5.24	Bacteria	2	Bacteria	Bacteria	151	2.98e-41	NR	MBX3463307.1	2026780	g18037	i0	81.4	15.4236641221374	86	16	98.5	0	260	3	362	447	MBX3463307.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	4041	151	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
6708124	6708124	PRJNA1214993_P_NODE_19966_length_252_cov_1.720670_g19780_i0	PRJNA1214993	19966	252	1.72067	4.3360884	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	115	5.49e-28	NR	HVU63673.1	2052180	g19780	i0	69.1	2.86904761904762	81	25	96.4	0	244	2	155	235	HVU63673.1 NADP-dependent isocitrate dehydrogenase [Phycisphaerales bacterium]	diamond	723	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9973509	9973509	PRJNA1214993_P_NODE_25288_length_243_cov_0.917647_g25102_i0	PRJNA1214993	25288	243	0.917647	2.22988221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.2	1.77e-9	NR	MBJ77738.1	2026780	g25102	i0	44.9	6.55555555555556	78	40	96.3	1	243	10	41	115	MBJ77738.1 3-hydroxybutyryl-CoA dehydrogenase [Planctomycetota bacterium]	diamond	1593	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
9973527	9973527	PRJNA1214993_P_NODE_9328_length_357_cov_2.795775_g9142_i0	PRJNA1214993	9328	357	2.795775	9.98091675	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	129	1.03e-34	NR	MFK7736369.1	2699754	g9142	i0	58.9	2.77310924369748	107	40	87.4	2	314	3	21	126	MFK7736369.1 peptidylprolyl isomerase [Pirellulaceae bacterium]	diamond	990	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
10534092	10534092	PRJNA1214993_P_NODE_10389_length_340_cov_1.677903_g10203_i0	PRJNA1214993	10389	340	1.677903	5.7048702	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	534	2.62e-147	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g10203	i0	95.015	175.879411764706	341	15	100	2	1	340	3413086	3412747	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	59799	534	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
16907475	16907475	PRJNA1214993_P_NODE_21094_length_250_cov_0.881356_g20908_i0	PRJNA1214993	21094	250	0.881356	2.20339	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	331	2.6e-86	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g20908	i0	90.837	125.372	251	18	99	5	3	250	4421030	4421278	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	31343	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20731715	20731715	PRJNA1214993_P_NODE_13837_length_297_cov_0.995536_g13651_i0	PRJNA1214993	13837	297	0.995536	2.95674192	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	472	1.7899999999999998e-128	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g13651	i0	95.578	128.771043771044	294	13	99	0	4	297	2621115	2620822	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	38245	472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22007030	22007030	PRJNA1214993_P_NODE_12378_length_313_cov_1.950000_g12192_i0	PRJNA1214993	12378	313	1.95	6.1035	Planctomycetota bacterium	2026780	Bacteria	Bacteria	179	4.7199999999999984e-55	NR	HGY92355.1	2026780	g12192	i0	77.9	1.99361022364217	104	23	99.7	0	312	1	84	187	HGY92355.1 superoxide dismutase [Planctomycetota bacterium]	diamond	624	179	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23997527	23997527	PRJNA1214993_P_NODE_9259_length_359_cov_1.090909_g9073_i0	PRJNA1214993	9259	359	1.090909	3.91636331	Botrimarina	2795782	Bacteria	Bacteria	549	9.889999999999996e-152	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g9073	i0	94.398	115.924791086351	357	20	99	0	3	359	4245554	4245198	Planctomycetes bacterium K2D chromosome, complete genome	blastn	41617	549	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
26692766	26692766	PRJNA1214993_P_NODE_25301_length_243_cov_0.917647_g25115_i0	PRJNA1214993	25301	243	0.917647	2.22988221	Phycisphaerales bacterium JB063	3342861	Bacteria	Bacteria	68.9	3.71e-12	NR	MFI4859409.1	3342861	g25115	i0	53.6	3.46913580246914	69	29	84	2	219	16	37	103	MFI4859409.1 superoxide dismutase family protein [Phycisphaerales bacterium JB063]	diamond	843	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium JB063
26933317	26933317	PRJNA1214993_P_NODE_14522_length_290_cov_1.437788_g14336_i0	PRJNA1214993	14522	290	1.437788	4.1695852	Bacteria	2	Bacteria	Bacteria	81.6	1.42e-15	NR	MES2788344.1	2026780	g14336	i0	55.4	6.70344827586207	92	36	95.2	2	1	276	1110	1196	MES2788344.1 ELWxxDGT repeat protein [Planctomycetota bacterium]	diamond	1944	81.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27799387	27799387	PRJNA1214993_P_NODE_17104_length_271_cov_1.176768_g16918_i0	PRJNA1214993	17104	271	1.176768	3.18904128	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00306	NR	MBN8643811.1	2026780	g16918	i0	39.3	0.675276752767528	61	35	67.5	1	73	255	283	341	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	183	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27862242	27862242	PRJNA1214993_P_NODE_21185_length_250_cov_0.881356_g20999_i0	PRJNA1214993	21185	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0281	NR	HUT34610.1	2026780	g20999	i0	45.8	0.576	48	26	57.6	0	146	3	279	326	HUT34610.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Planctomycetota bacterium]	diamond	144	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28399111	28399111	PRJNA1214993_P_NODE_23346_length_246_cov_1.803468_g23160_i0	PRJNA1214993	23346	246	1.803468	4.43653128	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0393	NR	MCB9832205.1	2026780	g23160	i0	36.6	1	82	49	100	1	1	246	449	527	MCB9832205.1 zf-HC2 domain-containing protein [Planctomycetota bacterium]	diamond	246	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28683455	28683455	PRJNA1214993_P_NODE_25187_length_243_cov_1.735294_g25001_i0	PRJNA1214993	25187	243	1.735294	4.21676442	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.6	8.32e-9	NR	HYF51941.1	2026780	g25001	i0	57.4	8.71604938271605	68	24	84	2	3	206	1191	1253	HYF51941.1 cadherin domain-containing protein [Planctomycetota bacterium]	diamond	2118	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29283005	29283005	PRJNA1214993_P_NODE_19649_length_253_cov_0.866667_g19463_i0	PRJNA1214993	19649	253	0.866667	2.19266751	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	132	2.05e-36	NR	MBY0307717.1	2052180	g19463	i0	74.4	0.924901185770751	78	20	92.5	0	249	16	150	227	MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	234	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29567207	29567207	PRJNA1214993_P_NODE_16530_length_275_cov_1.376238_g16344_i0	PRJNA1214993	16530	275	1.376238	3.7846545	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	6.95e-6	NR	HEX3135187.1	2026780	g16344	i0	42.6	0.741818181818182	68	33	74.2	2	208	5	133	194	HEX3135187.1 hypothetical protein [Planctomycetota bacterium]	diamond	204	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29693295	29693295	PRJNA1214993_P_NODE_24870_length_244_cov_0.912281_g24684_i0	PRJNA1214993	24870	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0378	NR	HYG74935.1	2026780	g24684	i0	40.6	0.786885245901639	64	32	78.7	2	224	33	892	949	HYG74935.1 DUF5060 domain-containing protein [Planctomycetota bacterium]	diamond	192	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30009622	30009622	PRJNA1214993_P_NODE_15411_length_283_cov_2.338095_g15225_i0	PRJNA1214993	15411	283	2.338095	6.61680885	Rhodopirellula sp.	2024855	Bacteria	Bacteria	43.1	0.0126	NR	MDA7873697.1	2024855	g15225	i0	42.1	0.604240282685512	57	20	46.6	3	38	169	45	101	MDA7873697.1 hypothetical protein [Rhodopirellula sp.]	diamond	171	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp.
31178224	31178224	PRJNA1214993_P_NODE_17295_length_269_cov_1.617347_g17109_i0	PRJNA1214993	17295	269	1.617347	4.35066343	Planctomycetota bacterium	2026780	Bacteria	Bacteria	165	1.86e-47	NR	MDZ4818359.1	2026780	g17109	i0	83.1	10.9182156133829	89	15	99.3	0	2	268	225	313	MDZ4818359.1 NAD-dependent formate dehydrogenase [Planctomycetota bacterium]	diamond	2937	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31905925	31905925	PRJNA1214993_P_NODE_14417_length_291_cov_1.412844_g14231_i0	PRJNA1214993	14417	291	1.412844	4.11137604	Gemmataceae bacterium	2052164	Bacteria	Bacteria	52.4	2.52e-5	NR	MDB5312908.1	2052164	g14231	i0	42.1	1.5360824742268	76	35	78.4	2	286	59	271	337	MDB5312908.1 hypothetical protein [Gemmataceae bacterium]	diamond	447	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;