metadata: contig_metadata: 14 rows where bioproject = "PRJNA385396", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJNA385396", 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
2351910	2351910	PRJNA385396_P_NODE_14862_length_249_cov_1.312500_g14770_i0	PRJNA385396	14862	249	1.3125	3.268125	Isosphaera	127	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g14770	i0	94.239	186.690763052209	243	14	98	0	1	243	2429	2671	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	46486	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
2957588	2957588	PRJNA385396_P_NODE_17963_length_245_cov_0.895349_g17871_i0	PRJNA385396	17963	245	0.895349	2.19360505	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g17871	i0	100	0.114285714285714	28	0	11	0	22	49	949644	949617	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
6784546	6784546	PRJNA385396_P_NODE_16186_length_248_cov_0.880000_g16094_i0	PRJNA385396	16186	248	0.88	2.1824	Urbifossiella limnaea	2528023	Bacteria	Bacteria	316	7.2e-82	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g16094	i0	89.879	65.4879032258064	247	24	99	1	2	248	2018474	2018229	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	16241	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9334916	9334916	PRJNA385396_P_NODE_13628_length_251_cov_0.865169_g13536_i0	PRJNA385396	13628	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	115	4.89e-28	NR	MDX2119264.1	2026780	g13536	i0	62.7	2.97609561752988	83	30	99.2	1	2	250	255	336	MDX2119264.1 NADP-dependent isocitrate dehydrogenase [Planctomycetota bacterium]	diamond	747	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
15709898	15709898	PRJNA385396_P_NODE_7193_length_322_cov_1.236948_g7101_i0	PRJNA385396	7193	322	1.236948	3.98297256	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	379	1.22e-100	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g7101	i0	88.199	125.953416149068	322	33	99	5	2	322	4317515	4317198	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	40557	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24633616	24633616	PRJNA385396_P_NODE_8860_length_299_cov_1.057522_g8768_i0	PRJNA385396	8860	299	1.057522	3.16199078	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	392	1.44e-104	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g8768	i0	90.301	43.752508361204	299	29	100	0	1	299	2666501	2666799	Gemmata sp. SH-PL17, complete genome	blastn	13082	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
25302710	25302710	PRJNA385396_P_NODE_11980_length_263_cov_1.621053_g11888_i0	PRJNA385396	11980	263	1.621053	4.26336939	Gemmata	113	Bacteria	Bacteria	119	4.1e-31	NR	WP_010045460.1	114	g11888	i0	72.3	4.7680608365019	83	22	94.7	1	260	12	98	179	WP_010045460.1 peptidylprolyl isomerase [Gemmata obscuriglobus]	diamond	1254	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
27106655	27106655	PRJNA385396_P_NODE_14922_length_249_cov_0.875000_g14830_i0	PRJNA385396	14922	249	0.875	2.17875	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	79.7	3.68e-15	NR	MBX3403171.1	2026777	g14830	i0	63.6	0.662650602409639	55	20	66.3	0	83	247	288	342	MBX3403171.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	165	79.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28260460	28260460	PRJNA385396_P_NODE_15626_length_248_cov_1.314286_g15534_i0	PRJNA385396	15626	248	1.314286	3.25942928	PVC group	1783257	Bacteria	Bacteria	86.7	1.42e-17	NR	HMN42288.1	2052180	g15534	i0	54.2	7.40322580645161	72	33	87.1	0	242	27	1387	1458	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	1836	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28591198	28591198	PRJNA385396_P_NODE_18687_length_244_cov_0.900585_g18595_i0	PRJNA385396	18687	244	0.900585	2.1974274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.1	1.3e-6	NR	RPH43679.1	2026780	g18595	i0	65	0.491803278688525	40	13	48	1	5	121	224	263	RPH43679.1 MAG: hypothetical protein EHM91_08590, partial [Planctomycetota bacterium]	diamond	120	55.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28811798	28811798	PRJNA385396_P_NODE_13688_length_251_cov_0.865169_g13596_i0	PRJNA385396	13688	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	116	7.09e-29	NR	MBL8728556.1	2026780	g13596	i0	70.3	10.792828685259	74	22	88.4	0	250	29	281	354	MBL8728556.1 fatty acid desaturase [Planctomycetota bacterium]	diamond	2709	116	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29474877	29474877	PRJNA385396_P_NODE_10670_length_277_cov_1.509804_g10578_i0	PRJNA385396	10670	277	1.509804	4.18215708	Gemmataceae bacterium	2052164	Bacteria	Bacteria	49.3	2.89e-4	NR	HEV3079466.1	2052164	g10578	i0	39.4	3.53068592057762	66	37	70.4	2	77	271	983	1046	HEV3079466.1 autotransporter-associated beta strand repeat-containing protein [Gemmataceae bacterium]	diamond	978	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29727496	29727496	PRJNA385396_P_NODE_19050_length_244_cov_0.900585_g18958_i0	PRJNA385396	19050	244	0.900585	2.1974274	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	132	3e-35	NR	MBX3451904.1	2026779	g18958	i0	74.7	0.971311475409836	79	20	97.1	0	239	3	121	199	MBX3451904.1 Mrp/NBP35 family ATP-binding protein [Planctomycetaceae bacterium]	diamond	237	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31971750	31971750	PRJNA385396_P_NODE_21558_length_241_cov_0.916667_g21466_i0	PRJNA385396	21558	241	0.916667	2.20916747	Phycisphaera sp.	2030824	Bacteria	Bacteria	61.6	3.19e-9	NR	MBI1337463.1	2030824	g21466	i0	45.3	0.796680497925311	64	33	77.2	1	239	54	92	155	MBI1337463.1 PEP-CTERM sorting domain-containing protein [Phycisphaera sp.]	diamond	192	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.

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