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

14 rows where bioproject = "PRJNA312615", 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
11267260	11267260	PRJNA312615_P_NODE_48129_length_173_cov_1.645161_g47978_i0	PRJNA312615	48129	173	1.645161	2.84612853	Singulisphaera	466152	Bacteria	Bacteria	235	1.34e-57	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g47978	i0	91.329	143.450867052023	173	14	100	1	1	173	101	272	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	24817	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
20779814	20779814	PRJNA312615_P_NODE_36757_length_202_cov_2.973856_g36606_i0	PRJNA312615	36757	202	2.973856	6.00718912	Planctomycetia	203683	Bacteria	Bacteria	102	2.03e-25	NR	WP_077025744.1	1891926	g36606	i0	75.8	4.63366336633663	62	15	92.1	0	201	16	139	200	WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici]	diamond	936	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
28084890	28084890	PRJNA312615_P_NODE_43245_length_186_cov_1.153285_g43094_i0	PRJNA312615	43245	186	1.153285	2.1451101	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.1	3.7e-6	NR	MBM3999155.1	2026780	g43094	i0	40	2.80645161290323	60	36	96.8	0	5	184	426	485	MBM3999155.1 hypothetical protein [Planctomycetota bacterium]	diamond	522	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28748020	28748020	PRJNA312615_P_NODE_44847_length_182_cov_1.210526_g44696_i0	PRJNA312615	44847	182	1.210526	2.20315732	Planctomycetota bacterium	2026780	Bacteria	Bacteria	49.3	8.01e-5	NR	MEM8681583.1	2026780	g44696	i0	39	2.83516483516484	59	36	97.3	0	182	6	340	398	MEM8681583.1 hypothetical protein [Planctomycetota bacterium]	diamond	516	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28810800	28810800	PRJNA312615_P_NODE_34768_length_208_cov_1.283019_g34617_i0	PRJNA312615	34768	208	1.283019	2.66867952	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.6	1.54e-12	NR	MCZ6572710.1	2026780	g34617	i0	53.6	1.99038461538462	69	31	99.5	1	2	208	187	254	MCZ6572710.1 acetate--CoA ligase [Planctomycetota bacterium]	diamond	414	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28955267	28955267	PRJNA312615_P_NODE_51748_length_167_cov_0.864407_g51597_i0	PRJNA312615	51748	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	47.8	2.3e-4	NR	MCA9033902.1	2026779	g51597	i0	61.7	3.39520958083832	47	17	84.4	1	155	15	1684	1729	MCA9033902.1 tandem-95 repeat protein [Planctomycetaceae bacterium]	diamond	567	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28986869	28986869	PRJNA312615_P_NODE_20528_length_269_cov_1.222727_g20377_i0	PRJNA312615	20528	269	1.222727	3.28913563	PVC group	1783257	Bacteria	Bacteria	93.2	1.13e-21	NR	MCS6866835.1	1914242	g20377	i0	55.4	1.70631970260223	83	33	88.1	1	268	32	80	162	MCS6866835.1 glutathione peroxidase [Gemmata sp.]	diamond	459	93.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
29680894	29680894	PRJNA312615_P_NODE_27110_length_235_cov_1.096774_g26959_i0	PRJNA312615	27110	235	1.096774	2.5774189	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	1.02e-5	NR	MEI6236014.1	2026780	g26959	i0	44.3	4.90212765957447	61	31	77.9	1	207	25	1170	1227	MEI6236014.1 hypothetical protein [Planctomycetota bacterium]	diamond	1152	53.1	0.994350282485876	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29807409	29807409	PRJNA312615_P_NODE_36631_length_203_cov_1.292208_g36480_i0	PRJNA312615	36631	203	1.292208	2.62318224	Bacteria	2	Bacteria	Bacteria	58.5	5.96e-8	NR	MEI8382219.1	2026780	g36480	i0	51.5	1.95073891625616	66	31	97.5	1	199	2	626	690	MEI8382219.1 hypothetical protein [Planctomycetota bacterium]	diamond	396	58.9	0.99320882852292	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29997198	29997198	PRJNA312615_P_NODE_36491_length_203_cov_1.896104_g36340_i0	PRJNA312615	36491	203	1.896104	3.84909112	Schlesneria	656899	Bacteria	Bacteria	44.7	0.00473	NR	WP_010585981.1	360056	g36340	i0	61.3	5.58620689655172	31	12	45.8	0	96	4	1871	1901	WP_010585981.1 hypothetical protein [Schlesneria paludicola]	diamond	1134	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria paludicola
30755386	30755386	PRJNA312615_P_NODE_25894_length_240_cov_2.005236_g25743_i0	PRJNA312615	25894	240	2.005236	4.8125664	Bacteria	2	Bacteria	Bacteria	43.1	0.0251	NR	PKL48441.1	2013827	g25743	i0	58.1	1.1875	31	13	38.8	0	233	141	365	395	PKL48441.1 MAG: 8-amino-7-oxononanoate synthase [Planctomycetes bacterium HGW-Planctomycetes-1]	diamond	285	43.5	0.990804597701149	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium HGW-Planctomycetes-1
31780886	31780886	PRJNA312615_P_NODE_46917_length_176_cov_2.700787_g46766_i0	PRJNA312615	46917	176	2.700787	4.75338512	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.2	0.0389	NR	MCC6427943.1	2052180	g46766	i0	47.5	0.681818181818182	40	20	68.2	1	23	142	125	163	MCC6427943.1 PepSY domain-containing protein [Phycisphaerales bacterium]	diamond	120	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32350734	32350734	PRJNA312615_P_NODE_22719_length_256_cov_0.961353_g22568_i0	PRJNA312615	22719	256	0.961353	2.46106368	Pirellulales bacterium	2715253	Bacteria	Bacteria	126	2.43e-32	NR	HJT32260.1	2715253	g22568	i0	66.7	2.953125	84	28	98.4	0	2	253	124	207	HJT32260.1 fumarylacetoacetase [Pirellulales bacterium]	diamond	756	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32683837	32683837	PRJNA312615_P_NODE_38200_length_198_cov_5.395973_g38049_i0	PRJNA312615	38200	198	5.395973	10.68402654	Bacteria	2	Bacteria	Bacteria	74.3	3.28e-14	NR	MEO1372129.1	2026780	g38049	i0	71.2	6.34848484848485	52	15	78.8	0	42	197	6	57	MEO1372129.1 MmgE/PrpD family protein [Planctomycetota bacterium]	diamond	1257	74.3	1	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);;