metadata: contig_metadata: 26 rows where bioproject = "PRJNA1020854", tax_clade = "PVC group" and tax

26 rows where bioproject = "PRJNA1020854", 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
160800	160800	PRJNA1020854_S_NODE_21661_length_233_cov_2514.656863_g18897_i0	PRJNA1020854	21661	233	2514.656863	5859.15049079	Gemmataceae bacterium	2052164	Bacteria	Bacteria	120	1.58e-31	NR	MBY0523881.1	2052164	g18897	i0	93.3	0.772532188841202	60	4	77.3	0	233	54	160	219	MBY0523881.1 TIGR03032 family protein [Gemmataceae bacterium]	diamond	180	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
161307	161307	PRJNA1020854_S_NODE_7521_length_547_cov_1040.063707_g4899_i0	PRJNA1020854	7521	547	1040.063707	5689.14847729	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	599	1.53e-166	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g4899	i0	88.431	54.617915904936	510	41	91	16	1	500	7728938	7728437	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	29876	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
1435406	1435406	PRJNA1020854_S_NODE_10322_length_404_cov_3.645333_g7583_i0	PRJNA1020854	10322	404	3.645333	14.72714532	Gemmataceae bacterium	2052164	Bacteria	Bacteria	218	4.28e-70	NR	HMC65290.1	2052164	g7583	i0	76.7	1.9752475247524801	133	31	98.8	0	402	4	53	185	HMC65290.1 cupin domain-containing protein [Gemmataceae bacterium]	diamond	798	218	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3553739	3553739	PRJNA1020854_S_NODE_20783_length_240_cov_1451.208531_g18019_i0	PRJNA1020854	20783	240	1451.208531	3482.9004744	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	72.4	1e-12	NR	MEO6808610.1	2691532	g18019	i0	59	0.7625	61	25	76.3	0	57	239	1	61	MEO6808610.1 Xaa-Pro peptidase family protein [Isosphaeraceae bacterium]	diamond	183	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
3987965	3987965	PRJNA1020854_S_NODE_8444_length_483_cov_1167.570485_g5770_i0	PRJNA1020854	8444	483	1167.570485	5639.36544255	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	90.5	1.04e-17	NR	HEX7009068.1	2026777	g5770	i0	37.2	1.4472049689441	113	64	70.2	3	451	113	305	410	HEX7009068.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	699	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
8656502	8656502	PRJNA1020854_S_NODE_32827_length_178_cov_3.281879_g30063_i0	PRJNA1020854	32827	178	3.281879	5.84174462	Planctomycetia bacterium	2052181	Bacteria	Bacteria	92.4	4.99e-20	NR	MCI0705108.1	2052181	g30063	i0	71.2	1.90449438202247	59	17	99.4	0	177	1	158	216	MCI0705108.1 protein kinase [Planctomycetia bacterium]	diamond	339	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
9088629	9088629	PRJNA1020854_S_NODE_32908_length_178_cov_2.442953_g30144_i0	PRJNA1020854	32908	178	2.442953	4.34845634	Urbifossiella limnaea	2528023	Bacteria	Bacteria	200	5.08e-47	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g30144	i0	87.006	0.99438202247191	177	23	99	0	1	177	5920133	5919957	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	177	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9088768	9088768	PRJNA1020854_S_NODE_41628_length_154_cov_2.240000_g38864_i0	PRJNA1020854	41628	154	2.24	3.4496000000000002	Aureliella helgolandensis	2527968	Bacteria	Bacteria	130	5.68e-26	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g38864	i0	98.63	1.26623376623377	73	1	47	0	7	79	5554640	5554568	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	195	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
10364595	10364595	PRJNA1020854_S_NODE_9889_length_418_cov_3.796915_g7159_i0	PRJNA1020854	9889	418	3.796915	15.8711047	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	673	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7159	i0	95.694	207.538277511962	418	18	100	0	1	418	1830937	1830520	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	86751	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
12914489	12914489	PRJNA1020854_S_NODE_20151_length_245_cov_912.379630_g17387_i0	PRJNA1020854	20151	245	912.37963	2235.3300935	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	257	4.37e-64	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g17387	i0	89.372	65.7795918367347	207	19	84	3	40	245	1831413	1831209	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	16116	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
14189932	14189932	PRJNA1020854_S_NODE_6212_length_695_cov_803.510511_g3744_i0	PRJNA1020854	6212	695	803.510511	5584.39805145	Planctomycetota bacterium	2026780	Bacteria	Bacteria	122	4.98e-28	NR	MBK7878710.1	2026780	g3744	i0	42.2	1.38992805755396	161	90	69.1	2	182	661	422	580	MBK7878710.1 right-handed parallel beta-helix repeat-containing protein [Planctomycetota bacterium]	diamond	966	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14189988	14189988	PRJNA1020854_S_NODE_7912_length_518_cov_2192.764826_g5266_i0	PRJNA1020854	7912	518	2192.764826	11358.52179868	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	198	2.3899999999999996e-55	NR	MBN1507229.1	2813034	g5266	i0	64.2	0.793436293436293	137	49	79.3	0	464	54	506	642	MBN1507229.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Sedimentisphaerales bacterium]	diamond	411	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
15030851	15030851	PRJNA1020854_S_NODE_15572_length_294_cov_1159.800000_g12808_i0	PRJNA1020854	15572	294	1159.8	3409.812	Pirellulaceae	2691357	Bacteria	Bacteria	241	5.42e-59	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g12808	i0	85.47	368.15306122449	234	31	79	3	56	288	3097757	3097526	Pirellula sp. SH-Sr6A, complete genome	blastn	108237	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15463318	15463318	PRJNA1020854_S_NODE_10113_length_410_cov_526.167979_g7377_i0	PRJNA1020854	10113	410	526.167979	2157.2887139	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	520	8.979999999999998e-143	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7377	i0	93.466	467.936585365854	352	20	85	3	62	410	1831263	1830912	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	191854	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
20129806	20129806	PRJNA1020854_S_NODE_39216_length_159_cov_4.338462_g36452_i0	PRJNA1020854	39216	159	4.338462	6.89815458	root	1	Root_unresolved	Root_unresolved	231	1.58e-56	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g36452	i0	93.082	12.5157232704403	159	9	100	2	1	159	1830336	1830492	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1990	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
24386768	24386768	PRJNA1020854_S_NODE_13640_length_324_cov_666.728814_g10876_i0	PRJNA1020854	13640	324	666.72881400000006	2160.20135736	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	1.65e-74	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10876	i0	86.296	107.595679012346	270	36	83	1	7	275	2562350	2562619	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	34861	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26591433	26591433	PRJNA1020854_S_NODE_9041_length_452_cov_14.929078_g6341_i0	PRJNA1020854	9041	452	14.929078	67.47943256	Planctomycetota bacterium	2026780	Bacteria	Bacteria	111	8.84e-26	NR	RIK84561.1	2026780	g6341	i0	52	0.676991150442478	102	47	67.7	1	450	145	324	423	RIK84561.1 MAG: hypothetical protein DCC68_00965 [Planctomycetota bacterium]	diamond	306	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27446008	27446008	PRJNA1020854_S_NODE_22783_length_226_cov_2.203046_g20019_i0	PRJNA1020854	22783	226	2.203046	4.97888396	Planctomycetota bacterium	2026780	Bacteria	Bacteria	149	7.44e-40	NR	MBN8601304.1	2026780	g20019	i0	98.6	0.982300884955752	74	1	98.2	0	2	223	734	807	MBN8601304.1 discoidin domain-containing protein [Planctomycetota bacterium]	diamond	222	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27856121	27856121	PRJNA1020854_S_NODE_31425_length_183_cov_3.324675_g28661_i0	PRJNA1020854	31425	183	3.324675	6.08415525	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	50.8	1.41e-5	NR	HIB63803.1	2052180	g28661	i0	51.1	0.770491803278688	47	23	77	0	143	3	67	113	HIB63803.1 hypothetical protein [Phycisphaerales bacterium]	diamond	141	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28897988	28897988	PRJNA1020854_S_NODE_24708_length_214_cov_3.508108_g21944_i0	PRJNA1020854	24708	214	3.508108	7.50735112	Pirellulales bacterium	2715253	Bacteria	Bacteria	43.1	0.0186	NR	HVX60454.1	2715253	g21944	i0	57.5	1.07943925233645	40	17	56.1	0	93	212	1052	1091	HVX60454.1 SdrD B-like domain-containing protein [Pirellulales bacterium]	diamond	231	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28897991	28897991	PRJNA1020854_S_NODE_36628_length_166_cov_3.598540_g33864_i0	PRJNA1020854	36628	166	3.59854	5.9735764	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	59.7	5.41e-9	NR	HIB63803.1	2052180	g33864	i0	50	1.01204819277108	56	25	99.4	2	2	166	122	175	HIB63803.1 hypothetical protein [Phycisphaerales bacterium]	diamond	168	59.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30919750	30919750	PRJNA1020854_S_NODE_43394_length_150_cov_3.008264_g40630_i0	PRJNA1020854	43394	150	3.008264	4.512396	Gemmataceae bacterium	2052164	Bacteria	Bacteria	45.4	0.0012	NR	MFO0844493.1	2052164	g40630	i0	42.6	0.94	47	27	94	0	7	147	310	356	MFO0844493.1 tetratricopeptide repeat-containing protein kinase family protein [Gemmataceae bacterium]	diamond	141	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30982945	30982945	PRJNA1020854_S_NODE_30474_length_187_cov_1.854430_g27710_i0	PRJNA1020854	30474	187	1.85443	3.4677841	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	118	1.03e-30	NR	MBL8871739.1	2026779	g27710	i0	100	0.978609625668449	61	0	97.9	0	3	185	50	110	MBL8871739.1 acetylglutamate kinase [Planctomycetaceae bacterium]	diamond	183	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32437943	32437943	PRJNA1020854_S_NODE_35259_length_170_cov_3.397163_g32495_i0	PRJNA1020854	35259	170	3.397163	5.7751771	Planctomycetales bacterium	2053591	Bacteria	Bacteria	108	2.78e-27	NR	MCA9199412.1	2053591	g32495	i0	98.2	0.988235294117647	56	1	98.8	0	169	2	161	216	MCA9199412.1 ParA family protein [Planctomycetales bacterium]	diamond	168	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
32564523	32564523	PRJNA1020854_S_NODE_21359_length_236_cov_1.961353_g18595_i0	PRJNA1020854	21359	236	1.961353	4.62879308	Pirellula sp.	117	Bacteria	Bacteria	127	3.81e-33	NR	MCF7963791.1	117	g18595	i0	75.6	0.991525423728814	78	19	99.2	0	234	1	102	179	MCF7963791.1 transglutaminase-like domain-containing protein [Pirellula sp.]	diamond	234	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
32713870	32713870	PRJNA1020854_S_NODE_11420_length_372_cov_6.664723_g8665_i0	PRJNA1020854	11420	372	6.664723	24.79276956	Bacteria	2	Bacteria	Bacteria	48.5	0.00137	NR	MCZ6688040.1	2026780	g8665	i0	45	2.50806451612903	60	29	48.4	1	26	205	132	187	MCZ6688040.1 VWA domain-containing protein [Planctomycetota bacterium]	diamond	933	48.9	0.991820040899796	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);;