metadata: contig_metadata: 15 rows where bioproject = "PRJDB3785", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJDB3785", 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
20409595	20409595	PRJDB3785_S_NODE_7917_length_267_cov_1.100917_g7764_i0	PRJDB3785	7917	267	1.100917	2.93944839	Planctomycetia	203683	Bacteria	Bacteria	135	1.18e-35	NR	MDR1053142.1	2026779	g7764	i0	77.8	30.9887640449438	81	18	91	0	4	246	358	438	MDR1053142.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	8274	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
24234738	24234738	PRJDB3785_S_NODE_2840_length_462_cov_2.208232_g2689_i0	PRJDB3785	2840	462	2.208232	10.20203184	Gemmata massiliana	1210884	Bacteria	Bacteria	268	4.0899999999999994e-67	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g2689	i0	83.681	63.4285714285714	288	43	62	4	8	293	9030584	9030299	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	29304	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
27317102	27317102	PRJDB3785_S_NODE_14863_length_201_cov_1.894737_g14710_i0	PRJDB3785	14863	201	1.894737	3.80842137	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	89.4	6.95e-21	NR	MEI8196857.1	2026778	g14710	i0	62.1	1.97014925373134	66	25	98.5	0	200	3	7	72	MEI8196857.1 aldolase/citrate lyase family protein [Phycisphaerae bacterium]	diamond	396	89.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
27538100	27538100	PRJDB3785_S_NODE_9284_length_248_cov_1.266332_g9131_i0	PRJDB3785	9284	248	1.266332	3.14050336	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	116	1.29e-31	NR	MFN9913585.1	2699754	g9131	i0	69.5	1.98387096774194	82	25	99.2	0	1	246	14	95	MFN9913585.1 V-type ATP synthase subunit A [Pirellulaceae bacterium]	diamond	492	116	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
28068825	28068825	PRJDB3785_S_NODE_26525_length_162_cov_0.902655_g26372_i0	PRJDB3785	26525	162	0.902655	1.4623011	Bacteria	2	Bacteria	Bacteria	56.2	2.22e-7	NR	MDA1050033.1	2026780	g26372	i0	54.2	1.77777777777778	48	22	88.9	0	4	147	1256	1303	MDA1050033.1 hypothetical protein [Planctomycetota bacterium]	diamond	288	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28264045	28264045	PRJDB3785_S_NODE_27346_length_161_cov_0.910714_g27193_i0	PRJDB3785	27346	161	0.910714	1.46624954	Planctomycetota bacterium	2026780	Bacteria	Bacteria	77.8	3.74e-15	NR	MBM4018201.1	2026780	g27193	i0	68.8	1.7888198757764	48	15	89.4	0	159	16	310	357	MBM4018201.1 galactose mutarotase [Planctomycetota bacterium]	diamond	288	77.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28832455	28832455	PRJDB3785_S_NODE_27208_length_161_cov_0.910714_g27055_i0	PRJDB3785	27208	161	0.910714	1.46624954	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	79.7	1.12e-15	NR	MFT7643622.1	2699754	g27055	i0	67.3	0.968944099378882	52	17	96.9	0	161	6	772	823	MFT7643622.1 NAD(P)H-dependent nitrite reductase large subunit/NAD(P)H-dependent nitrite reductase small subunit [Pirellulaceae bacterium]	diamond	156	79.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29274394	29274394	PRJDB3785_S_NODE_15709_length_197_cov_0.918919_g15556_i0	PRJDB3785	15709	197	0.918919	1.81027043	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	90.5	3.41e-20	NR	MEO2031777.1	2026779	g15556	i0	54.7	0.974619289340102	64	29	97.5	0	3	194	95	158	MEO2031777.1 phytanoyl-CoA dioxygenase family protein [Planctomycetaceae bacterium]	diamond	192	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29363510	29363510	PRJDB3785_S_NODE_21629_length_172_cov_1.203252_g21476_i0	PRJDB3785	21629	172	1.203252	2.06959344	Urbifossiella	2807415	Bacteria	Bacteria	80.9	4.67e-17	NR	MBY0513773.1	2052164	g21476	i0	61.8	1.91860465116279	55	21	95.9	0	168	4	4	58	MBY0513773.1 NAD(P)H:quinone oxidoreductase [Gemmataceae bacterium]	diamond	330	80.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29552621	29552621	PRJDB3785_S_NODE_24570_length_165_cov_0.879310_g24417_i0	PRJDB3785	24570	165	0.87931	1.4508615	PVC group	1783257	Bacteria	Bacteria	74.3	8.16e-14	NR	MBP8299990.1	2026780	g24417	i0	64.8	9.78181818181818	54	19	98.2	0	2	163	284	337	MBP8299990.1 acetyl-CoA C-acetyltransferase [Planctomycetota bacterium]	diamond	1614	74.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29969219	29969219	PRJDB3785_S_NODE_11991_length_221_cov_1.011628_g11838_i0	PRJDB3785	11991	221	1.011628	2.23569788	Planctomycetota bacterium	2026780	Bacteria	Bacteria	139	1.12e-37	NR	MDZ4818359.1	2026780	g11838	i0	87.7	14.8642533936652	73	9	99.1	0	221	3	238	310	MDZ4818359.1 NAD-dependent formate dehydrogenase [Planctomycetota bacterium]	diamond	3285	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30152681	30152681	PRJDB3785_S_NODE_11712_length_223_cov_1.172414_g11559_i0	PRJDB3785	11712	223	1.172414	2.61448322	Bacteria	2	Bacteria	Bacteria	49.7	9.31e-5	NR	KPK58091.1	1704029	g11559	i0	48.9	2.42152466367713	45	23	60.5	0	209	75	260	304	KPK58091.1 MAG: hypothetical protein AMK73_09475 [Planctomycetes bacterium SM23_32]	diamond	540	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium SM23_32
31201063	31201063	PRJDB3785_S_NODE_20255_length_177_cov_0.992188_g20102_i0	PRJDB3785	20255	177	0.992188	1.75617276	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	9.2e-4	NR	MEM9800773.1	2026780	g20102	i0	48	0.847457627118644	50	26	84.7	0	23	172	405	454	MEM9800773.1 hypothetical protein [Planctomycetota bacterium]	diamond	150	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31486370	31486370	PRJDB3785_S_NODE_5316_length_328_cov_2.222222_g5163_i0	PRJDB3785	5316	328	2.222222	7.28888816	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	61.6	2.33e-8	NR	HBJ37838.1	2026779	g5163	i0	40	0.86890243902439	95	41	84.1	4	278	3	659	740	HBJ37838.1 deoxyribodipyrimidine photolyase [Planctomycetaceae bacterium]	diamond	285	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32055472	32055472	PRJDB3785_S_NODE_25358_length_164_cov_0.878261_g25205_i0	PRJDB3785	25358	164	0.878261	1.44034804	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	52.8	7.7e-7	NR	MBY0262496.1	2052180	g25205	i0	59	0.713414634146341	39	16	71.3	0	135	19	8	46	MBY0262496.1 globin [Phycisphaerales bacterium]	diamond	117	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;