metadata: contig_metadata: 15 rows where bioproject = "PRJEB56027" and tax

15 rows where bioproject = "PRJEB56027" and tax_clade = "PVC group"

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
28296788	28296788	PRJEB56027_P_NODE_88926_length_284_cov_1.459716_g86117_i0	PRJEB56027	88926	284	1.459716	4.14559344	Opitutaceae bacterium	2006848	Bacteria	Bacteria	71.6	1.03e-13	NR	HVS53637.1	2006848	g86117	i0	66.7	0.570422535211268	54	18	57	0	265	104	59	112	HVS53637.1 hypothetical protein [Opitutaceae bacterium]	diamond	162	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29401999	29401999	PRJEB56027_P_NODE_129109_length_243_cov_0.905882_g126300_i0	PRJEB56027	129109	243	0.905882	2.20129326	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	108	2.58e-25	NR	HEX8296047.1	2811408	g126300	i0	65	0.987654320987654	80	28	98.8	0	241	2	1658	1737	HEX8296047.1 Ig-like domain-containing protein [Chthoniobacteraceae bacterium]	diamond	240	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
30413027	30413027	PRJEB56027_P_NODE_129453_length_243_cov_0.905882_g126644_i0	PRJEB56027	129453	243	0.905882	2.20129326	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	151	4.22e-42	NR	PYL57120.1	2026799	g126644	i0	90	1.97530864197531	80	8	98.8	0	241	2	113	192	PYL57120.1 MAG: hypothetical protein DMF31_11285 [Verrucomicrobiota bacterium]	diamond	480	151	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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
31898490	31898490	PRJEB56027_P_NODE_133757_length_241_cov_0.916667_g130948_i0	PRJEB56027	133757	241	0.916667	2.20916747	Opitutaceae bacterium	2006848	Bacteria	Bacteria	82.4	3.08e-16	NR	MFT3830094.1	2006848	g130948	i0	65.7	0.871369294605809	70	24	87.1	0	28	237	295	364	MFT3830094.1 helix-turn-helix domain-containing protein [Opitutaceae bacterium]	diamond	210	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;