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

11 rows where bioproject = "PRJNA1016321", 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
159578	159578	PRJNA1016321_P_NODE_35801_length_299_cov_1.039823_g35570_i0	PRJNA1016321	35801	299	1.039823	3.10907077	Planctomycetia bacterium	2052181	Bacteria	Bacteria	211	4.33e-50	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g35570	i0	80.427	1.17056856187291	281	51	93	4	21	299	550209	549931	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	350	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
12913694	12913694	PRJNA1016321_P_NODE_57971_length_203_cov_8.069231_g57740_i0	PRJNA1016321	57971	203	8.069231	16.38053893	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	185	1.67e-42	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g57740	i0	84.946	3.89162561576355	186	24	91	3	20	203	2919803	2919620	Blastopirellula sp. J2-11 chromosome	blastn	790	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
27603801	27603801	PRJNA1016321_P_NODE_57184_length_232_cov_2.735849_g56953_i0	PRJNA1016321	57184	232	2.735849	6.34716968	Gemmataceae bacterium	2052164	Bacteria	Bacteria	96.3	5.63e-22	NR	MBY0460844.1	2052164	g56953	i0	61	0.995689655172414	77	30	99.6	0	232	2	88	164	MBY0460844.1 TIGR02996 domain-containing protein [Gemmataceae bacterium]	diamond	231	96.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27635279	27635279	PRJNA1016321_P_NODE_46384_length_255_cov_1.994505_g46153_i0	PRJNA1016321	46384	255	1.994505	5.08598775	Gemmataceae bacterium	2052164	Bacteria	Bacteria	73.6	3.33e-13	NR	MFL5330220.1	2052164	g46153	i0	42.4	1	85	48	98.8	1	254	3	103	187	MFL5330220.1 DUF1559 domain-containing protein [Gemmataceae bacterium]	diamond	255	73.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28708828	28708828	PRJNA1016321_P_NODE_17727_length_460_cov_0.994832_g17497_i0	PRJNA1016321	17727	460	0.994832	4.5762272	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	301	1.16e-94	NR	MCP4083351.1	2026779	g17497	i0	100	0.997826086956522	153	0	99.8	0	1	459	265	417	MCP4083351.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	459	301	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29623809	29623809	PRJNA1016321_P_NODE_38870_length_285_cov_1.000000_g38639_i0	PRJNA1016321	38870	285	1	2.85	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	185	3.419999999999999e-54	NR	HEV3304486.1	2026779	g38639	i0	90.4	1.97894736842105	94	9	98.9	0	2	283	324	417	HEV3304486.1 IS21 family transposase [Planctomycetaceae bacterium]	diamond	564	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29687143	29687143	PRJNA1016321_P_NODE_37070_length_292_cov_2.602740_g36839_i0	PRJNA1016321	37070	292	2.60274	7.6000008	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	178	2.39e-51	NR	MFN0197902.1	2026779	g36839	i0	93.3	1.84931506849315	90	6	92.5	0	271	2	425	514	MFN0197902.1 IS1380 family transposase [Planctomycetaceae bacterium]	diamond	540	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30003417	30003417	PRJNA1016321_P_NODE_12791_length_554_cov_2.561331_g12568_i0	PRJNA1016321	12791	554	2.561331	14.18977374	Gemmatales bacterium	2838789	Bacteria	Bacteria	181	7.46e-51	NR	MCS6975467.1	2838789	g12568	i0	62.2	3.18953068592058	148	55	79.6	1	2	442	353	500	MCS6975467.1 thiamine phosphate synthase [Gemmatales bacterium]	diamond	1767	181	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales			Gemmatales bacterium
31172049	31172049	PRJNA1016321_P_NODE_43415_length_266_cov_1.932642_g43184_i0	PRJNA1016321	43415	266	1.932642	5.14082772	Phycisphaera sp.	2030824	Bacteria	Bacteria	43.5	0.0264	NR	MBI1337797.1	2030824	g43184	i0	37.3	0.575187969924812	51	32	57.5	0	176	24	126	176	MBI1337797.1 hypothetical protein [Phycisphaera sp.]	diamond	153	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
32216266	32216266	PRJNA1016321_P_NODE_30058_length_332_cov_1.189189_g29827_i0	PRJNA1016321	30058	332	1.189189	3.94810748	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	220	5.19e-65	NR	MCP4083351.1	2026779	g29827	i0	100	0.993975903614458	110	0	99.4	0	331	2	691	800	MCP4083351.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	330	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32248166	32248166	PRJNA1016321_P_NODE_6698_length_790_cov_2.993026_g6500_i0	PRJNA1016321	6698	790	2.993026	23.6449054	Gemmataceae bacterium	2052164	Bacteria	Bacteria	51.2	0.00194	NR	HEX4590038.1	2052164	g6500	i0	54.8	0.315189873417722	42	19	15.9	0	639	764	37	78	HEX4590038.1 hypothetical protein [Gemmataceae bacterium]	diamond	249	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;