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

14 rows where bioproject = "PRJNA459724", 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
2369355	2369355	PRJNA459724_P_NODE_5462_length_164_cov_3.044444_g5070_i0	PRJNA459724	5462	164	3.044444	4.99288816	Pirellulaceae	2691357	Bacteria	Bacteria	235	1.27e-57	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g5070	i0	93.21	90.7987804878049	162	7	98	4	4	163	6999548	6999707	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	14891	237	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
2993704	2993704	PRJNA459724_P_NODE_3223_length_260_cov_1.896104_g2831_i0	PRJNA459724	3223	260	1.896104	4.9298704	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	228	3.6699999999999994e-55	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g2831	i0	82.443	58.4884615384615	262	44	100	2	1	260	7629687	7629426	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	15207	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
17020389	17020389	PRJNA459724_P_NODE_3054_length_272_cov_2.008230_g2663_i0	PRJNA459724	3054	272	2.00823	5.4623856	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	468	2.09e-127	NTclustered	gi\|576901465\|gb\|KF827058.1\|	120965	g2663	i0	97.794	101.319852941176	272	5	100	1	1	272	621	351	Uncultured planctomycete clone B-30-43 16S ribosomal RNA gene, partial sequence	blastn	27559	468	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
27012816	27012816	PRJNA459724_P_NODE_4402_length_198_cov_1.970414_g4010_i0	PRJNA459724	4402	198	1.970414	3.90141972	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	94.7	4.049999999999999e-23	NR	MCE5266732.1	2026779	g4010	i0	93.2	0.666666666666667	44	3	66.7	0	66	197	47	90	MCE5266732.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	132	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27455570	27455570	PRJNA459724_P_NODE_4763_length_186_cov_2.299363_g4371_i0	PRJNA459724	4763	186	2.299363	4.27681518	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.00432	NR	MBI3272279.1	2026780	g4371	i0	78.6	0.451612903225806	28	6	45.2	0	98	181	1	28	MBI3272279.1 hypothetical protein [Planctomycetota bacterium]	diamond	84	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27598028	27598028	PRJNA459724_P_NODE_5084_length_176_cov_2.224490_g4692_i0	PRJNA459724	5084	176	2.22449	3.9151024	Pseudomonadati	3379134	Bacteria	Bacteria	67.8	2.21e-11	NR	NBX31864.1	2026780	g4692	i0	53.4	1.97727272727273	58	27	98.9	0	174	1	185	242	NBX31864.1 phage head-tail adapter protein [Planctomycetota bacterium]	diamond	348	67.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29696726	29696726	PRJNA459724_P_NODE_2950_length_281_cov_1.853175_g2559_i0	PRJNA459724	2950	281	1.853175	5.20742175	Gemmataceae bacterium	2052164	Bacteria	Bacteria	44.3	0.0163	NR	HKB36233.1	2052164	g2559	i0	50.6	0.864768683274021	81	32	86.5	4	36	278	251	323	HKB36233.1 tail fiber domain-containing protein [Gemmataceae bacterium]	diamond	243	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29728443	29728443	PRJNA459724_P_NODE_4430_length_197_cov_1.940476_g4038_i0	PRJNA459724	4430	197	1.940476	3.82273772	Pirellulales bacterium	2715253	Bacteria	Bacteria	43.1	0.0142	NR	MEX2167767.1	2715253	g4038	i0	35.4	2.01015228426396	65	39	95.9	2	196	8	122	185	MEX2167767.1 PHB depolymerase family esterase [Pirellulales bacterium]	diamond	396	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30455653	30455653	PRJNA459724_P_NODE_3653_length_233_cov_2.338235_g3261_i0	PRJNA459724	3653	233	2.338235	5.44808755	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	68.9	3.48e-13	NR	MBL4698368.1	2052180	g3261	i0	91.9	0.476394849785408	37	3	47.6	0	112	2	21	57	MBL4698368.1 hypothetical protein [Phycisphaerales bacterium]	diamond	111	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30550004	30550004	PRJNA459724_S_NODE_773_length_213_cov_4.117978_g770_i0	PRJNA459724	773	213	4.117978	8.77129314	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	69.7	1.55e-12	NR	WP_077025744.1	1891926	g770	i0	78.6	4.63380281690141	42	9	59.2	0	15	140	161	202	WP_077025744.1 peptidylprolyl isomerase [Fuerstiella marisgermanici]	diamond	987	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
31530059	31530059	PRJNA459724_P_NODE_3396_length_248_cov_2.538813_g3004_i0	PRJNA459724	3396	248	2.538813	6.29625624	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.4	6.94e-4	NR	MBL4698368.1	2052180	g3004	i0	100	0.254032258064516	21	0	25.4	0	64	2	21	41	MBL4698368.1 hypothetical protein [Phycisphaerales bacterium]	diamond	63	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31798953	31798953	PRJNA459724_P_NODE_5517_length_163_cov_1.649254_g5125_i0	PRJNA459724	5517	163	1.649254	2.68828402	Pseudomonadati	3379134	Bacteria	Bacteria	83.2	2.16e-18	NR	MEI6128977.1	2026780	g5125	i0	71.2	1.93251533742331	52	15	95.7	0	158	3	93	144	MEI6128977.1 hypothetical protein [Planctomycetota bacterium]	diamond	315	84	0.990476190476191	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32479204	32479204	PRJNA459724_P_NODE_2159_length_360_cov_1.676737_g1772_i0	PRJNA459724	2159	360	1.676737	6.0362532	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.1	2.48e-5	NR	MBM4071985.1	2026780	g1772	i0	40	0.458333333333333	55	33	45.8	0	193	357	18	72	MBM4071985.1 hypothetical protein [Planctomycetota bacterium]	diamond	165	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32794061	32794061	PRJNA459724_P_NODE_2900_length_285_cov_2.867188_g2509_i0	PRJNA459724	2900	285	2.867188	8.1714858	Planctomycetota bacterium	2026780	Bacteria	Bacteria	97.1	5.14e-21	NR	MFH1231028.1	2026780	g2509	i0	54.3	1.94736842105263	92	38	96.8	2	2	277	691	778	MFH1231028.1 hypothetical protein [Planctomycetota bacterium]	diamond	555	97.1	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);;