metadata: contig_metadata: 19 rows where bioproject = "PRJNA492406", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJNA492406", 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
3003258	3003258	PRJNA492406_P_NODE_25543_length_256_cov_1.213115_g25244_i0	PRJNA492406	25543	256	1.213115	3.1055744	Phycisphaera sp.	2030824	Bacteria	Bacteria	296	9.74e-76	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g25244	i0	90.043	497.13671875	231	19	90	4	2	231	3046480	3046707	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	127267	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
4279443	4279443	PRJNA492406_P_NODE_18364_length_291_cov_1.059633_g18065_i0	PRJNA492406	18364	291	1.059633	3.08353203	Planctomycetota bacterium	2026780	Bacteria	Bacteria	117	9.43e-22	NTclustered	gi\|1949774590\|gb\|CP066225.1\|	2026780	g18065	i0	90	28.6426116838488	90	9	31	0	193	282	4975449	4975538	Planctomycetota bacterium strain ZRK32 chromosome, complete genome	blastn	8335	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
4927369	4927369	PRJNA492406_P_NODE_21724_length_275_cov_1.465347_g21425_i0	PRJNA492406	21724	275	1.465347	4.02970425	Planctomycetota	203682	Bacteria	Bacteria	233	8.41e-57	NTclustered	gi\|1927964719\|gb\|CP054188.1\|	2052181	g21425	i0	82.576	337.516363636364	264	46	96	0	1	264	585708	585971	MAG: Planctomycetia bacterium isolate H1_AMX1 chromosome, complete genome	blastn	92817	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
9380636	9380636	PRJNA492406_P_NODE_508_length_1602_cov_2.741007_g384_i0	PRJNA492406	508	1602	2.741007	43.91093214	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1467	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g384	i0	83.488	442.92759051186	1617	223	99	35	4	1602	1867802	1866212	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	709570	1467	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18303977	18303977	PRJNA492406_P_NODE_17175_length_301_cov_2.504386_g16876_i0	PRJNA492406	17175	301	2.504386	7.53820186	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	392	1.4499999999999994e-104	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g16876	i0	91.034	325.102990033223	290	26	96	0	1	290	2192489	2192200	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	97856	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22128916	22128916	PRJNA492406_P_NODE_23678_length_265_cov_1.567708_g23379_i0	PRJNA492406	23678	265	1.567708	4.1544262	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	479	9.38e-131	NTclustered	gi\|673538887\|gb\|KJ611639.1\|	100371	g23379	i0	99.245	99.3320754716981	265	2	100	0	1	265	156	420	Uncultured Planctomycetales bacterium clone Uvmin2_16 16S ribosomal RNA gene, partial sequence	blastn	26323	479	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
26727811	26727811	PRJNA492406_P_NODE_26761_length_251_cov_0.865169_g26462_i0	PRJNA492406	26761	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	8.93e-7	NR	NRA40340.1	2026780	g26462	i0	49	1.1593625498008	49	25	58.6	0	169	23	5	53	NRA40340.1 hypothetical protein [Planctomycetota bacterium]	diamond	291	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27897518	27897518	PRJNA492406_P_NODE_12885_length_349_cov_1.021739_g12586_i0	PRJNA492406	12885	349	1.021739	3.56586911	Pirellula sp.	117	Bacteria	Bacteria	67	3.97e-10	NR	MFN7894481.1	117	g12586	i0	34.8	1.7621776504298	92	59	78.2	1	335	63	643	734	MFN7894481.1 hypothetical protein [Pirellula sp.]	diamond	615	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
28308239	28308239	PRJNA492406_P_NODE_30266_length_244_cov_0.900585_g29967_i0	PRJNA492406	30266	244	0.900585	2.1974274	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	69.3	1.55e-11	NR	NUM34221.1	2517210	g29967	i0	49.2	0.799180327868853	65	33	79.9	0	197	3	392	456	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	195	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
28308243	28308243	PRJNA492406_P_NODE_32086_length_241_cov_0.916667_g31787_i0	PRJNA492406	32086	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.2	2.18e-9	NR	MBN2712670.1	2026780	g31787	i0	60	0.622406639004149	50	20	62.2	0	153	4	30	79	MBN2712670.1 ABC transporter substrate-binding protein [Planctomycetota bacterium]	diamond	150	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28339702	28339702	PRJNA492406_P_NODE_24326_length_262_cov_1.222222_g24027_i0	PRJNA492406	24326	262	1.222222	3.20222164	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	64.3	1.23e-9	NR	MCA9280974.1	2052180	g24027	i0	37.6	0.973282442748092	85	53	97.3	0	262	8	564	648	MCA9280974.1 AAA family ATPase [Phycisphaerales bacterium]	diamond	255	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29129308	29129308	PRJNA492406_P_NODE_5349_length_518_cov_1.159551_g5054_i0	PRJNA492406	5349	518	1.159551	6.00647418	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	48.5	0.00583	NR	MCL4200996.1	2699754	g5054	i0	35.1	0.544401544401544	94	52	54.4	3	283	2	5850	5934	MCL4200996.1 choice-of-anchor L domain-containing protein [Pirellulaceae bacterium]	diamond	282	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29507852	29507852	PRJNA492406_P_NODE_16570_length_308_cov_0.961702_g16271_i0	PRJNA492406	16570	308	0.961702	2.96204216	Planctomycetota bacterium	2026780	Bacteria	Bacteria	105	5.85e-24	NR	MDA1267173.1	2026780	g16271	i0	51	9.75974025974026	102	49	98.4	1	303	1	176	277	MDA1267173.1 M20 family metallopeptidase [Planctomycetota bacterium]	diamond	3006	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30771670	30771670	PRJNA492406_P_NODE_19534_length_286_cov_0.957746_g19235_i0	PRJNA492406	19534	286	0.957746	2.73915356	Tepidisphaera sp.	2017440	Bacteria	Bacteria	70.1	3.05e-12	NR	MBI1191332.1	2017440	g19235	i0	82.6	0.482517482517482	46	8	48.3	0	146	283	1	46	MBI1191332.1 PEP-CTERM sorting domain-containing protein [Tepidisphaera sp.]	diamond	138	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
31024346	31024346	PRJNA492406_P_NODE_32135_length_241_cov_0.916667_g31836_i0	PRJNA492406	32135	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.5	1.17e-6	NR	HEY3322248.1	2026780	g31836	i0	46.4	0.858921161825726	69	36	84.6	1	230	27	539	607	HEY3322248.1 PKD domain-containing protein [Planctomycetota bacterium]	diamond	207	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31719900	31719900	PRJNA492406_P_NODE_11257_length_370_cov_0.976431_g10958_i0	PRJNA492406	11257	370	0.976431	3.6127947	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	56.2	2.99e-6	NR	MFA6185759.1	2026778	g10958	i0	34.8	0.559459459459459	69	43	55.9	1	217	11	39	105	MFA6185759.1 cellulase family glycosylhydrolase [Phycisphaerae bacterium]	diamond	207	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32605618	32605618	PRJNA492406_P_NODE_26700_length_251_cov_0.865169_g26401_i0	PRJNA492406	26700	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	152	2.97e-42	NR	MFN7587052.1	2026780	g26401	i0	92.8	0.99203187250996006	83	6	99.2	0	249	1	38	120	MFN7587052.1 porin [Planctomycetota bacterium]	diamond	249	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32668541	32668541	PRJNA492406_P_NODE_32040_length_241_cov_0.916667_g31741_i0	PRJNA492406	32040	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	6.46e-4	NR	MCI0586680.1	2026780	g31741	i0	44.3	2.35269709543568	61	33	74.7	1	195	16	124	184	MCI0586680.1 sigma 54-interacting transcriptional regulator [Planctomycetota bacterium]	diamond	567	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32810448	32810448	PRJNA492406_P_NODE_19180_length_287_cov_1.457944_g18881_i0	PRJNA492406	19180	287	1.457944	4.18429928	Pseudomonadati	3379134	Bacteria	Bacteria	117	1.12e-29	NR	WP_094414939.1	2023130	g18881	i0	56.8	5.50871080139373	95	39	97.2	1	9	287	35	129	WP_094414939.1 alpha/beta hydrolase [Rhodopirellula sp. MGV]	diamond	1581	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. MGV

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);;