metadata: contig_metadata: 11 rows where bioproject = "PRJEB56027", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJEB56027", 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
11600587	11600587	PRJEB56027_P_NODE_108410_length_257_cov_3.076087_g105601_i0	PRJEB56027	108410	257	3.076087	7.90554359	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	134	3.879999999999999e-34	NR	MBL9091246.1	2026779	g105601	i0	80	0.992217898832685	85	17	99.2	0	255	1	213	297	MBL9091246.1 DUF1080 domain-containing protein [Planctomycetaceae bacterium]	diamond	255	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
24348352	24348352	PRJEB56027_P_NODE_122040_length_247_cov_0.885057_g119231_i0	PRJEB56027	122040	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	147	1.14e-41	NR	HIB64223.1	2052180	g119231	i0	82.9	1.9919028340081	82	14	99.6	0	246	1	71	152	HIB64223.1 serine/threonine protein kinase [Phycisphaerales bacterium]	diamond	492	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27286421	27286421	PRJEB56027_P_NODE_131003_length_242_cov_0.911243_g128194_i0	PRJEB56027	131003	242	0.911243	2.20520806	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	133	1.47e-34	NR	MFN0133218.1	2052180	g128194	i0	85	7.93388429752066	80	12	99.2	0	3	242	345	424	MFN0133218.1 ABC transporter permease [Phycisphaerales bacterium]	diamond	1920	133	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27318195	27318195	PRJEB56027_P_NODE_137783_length_226_cov_3.019608_g134974_i0	PRJEB56027	137783	226	3.019608	6.82431408	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	86.7	6.97e-19	NR	HEX5103376.1	2699754	g134974	i0	55.3	1.00884955752212	76	33	99.6	1	1	225	53	128	HEX5103376.1 hypothetical protein [Pirellulaceae bacterium]	diamond	228	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
27444711	27444711	PRJEB56027_P_NODE_85903_length_289_cov_1.125000_g83094_i0	PRJEB56027	85903	289	1.125	3.25125	Pirellula sp.	117	Bacteria	Bacteria	43.5	0.0333	NR	MFM8571759.1	117	g83094	i0	36.4	1.13148788927336	55	33	56.1	2	257	96	21	74	MFM8571759.1 hypothetical protein [Pirellula sp.]	diamond	327	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27570668	27570668	PRJEB56027_P_NODE_119824_length_248_cov_0.880000_g117015_i0	PRJEB56027	119824	248	0.88	2.1824	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.8	0.00308	NR	MFM1823046.1	2026780	g117015	i0	37.3	0.810483870967742	67	41	79.8	1	43	240	251	317	MFM1823046.1 hypothetical protein [Planctomycetota bacterium]	diamond	201	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27886409	27886409	PRJEB56027_P_NODE_88865_length_284_cov_1.658768_g86056_i0	PRJEB56027	88865	284	1.658768	4.71090112	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	84	1.75e-16	NR	HEV3164036.1	2691532	g86056	i0	50	0.992957746478873	94	45	97.2	2	279	4	206	299	HEV3164036.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	282	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
30696983	30696983	PRJEB56027_P_NODE_134674_length_237_cov_2.731707_g131865_i0	PRJEB56027	134674	237	2.731707	6.47414559	Planctomycetota bacterium	2026780	Bacteria	Bacteria	116	1.6e-30	NR	MCE9532588.1	2026780	g131865	i0	68.9	0.936708860759494	74	23	93.7	0	5	226	81	154	MCE9532588.1 hypothetical protein [Planctomycetota bacterium]	diamond	222	116	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32246873	32246873	PRJEB56027_P_NODE_93918_length_277_cov_1.504902_g91109_i0	PRJEB56027	93918	277	1.504902	4.16857854	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	48.9	3.96e-4	NR	HEX3451115.1	2691532	g91109	i0	36.6	1.0072202166065	93	45	86.6	3	2	241	1149	1240	HEX3451115.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	279	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
32468293	32468293	PRJEB56027_P_NODE_94999_length_275_cov_2.386139_g92190_i0	PRJEB56027	94999	275	2.386139	6.56188225	Gemmataceae bacterium	2052164	Bacteria	Bacteria	131	4.33e-33	NR	MCI0379427.1	2052164	g92190	i0	60.4	1.96363636363636	91	36	99.3	0	275	3	512	602	MCI0379427.1 Ig-like domain-containing protein [Gemmataceae bacterium]	diamond	540	131	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32808059	32808059	PRJEB56027_P_NODE_123080_length_246_cov_1.497110_g120271_i0	PRJEB56027	123080	246	1.49711	3.6828906	Planctomycetia	203683	Bacteria	Bacteria	127	9.95e-33	NR	MCA9234635.1	2053591	g120271	i0	66.7	1.97560975609756	81	27	98.8	0	2	244	116	196	MCA9234635.1 family 43 glycosylhydrolase [Planctomycetales bacterium]	diamond	486	127	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales 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);;