metadata: contig_metadata: 24 rows where bioproject = "PRJDB3785" and tax

24 rows where bioproject = "PRJDB3785" and tax_clade = "PVC group"

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
27095602	27095602	PRJDB3785_S_NODE_25402_length_164_cov_0.860870_g25249_i0	PRJDB3785	25402	164	0.86087	1.4118268	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	90.5	7.24e-20	NR	GDY17185.1	2026799	g25249	i0	65.4	5.70731707317073	52	18	95.1	0	160	5	283	334	GDY17185.1 cyclopropane-fatty-acyl-phospholipid synthase [Verrucomicrobiota bacterium]	diamond	936	90.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27126847	27126847	PRJDB3785_S_NODE_9622_length_244_cov_1.179487_g9469_i0	PRJDB3785	9622	244	1.179487	2.87794828	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	45.8	0.00176	NR	MBQ3807801.1	2212473	g9469	i0	42.9	0.688524590163934	56	32	68.9	0	238	71	72	127	MBQ3807801.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	168	45.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27158560	27158560	PRJDB3785_S_NODE_22302_length_169_cov_1.975000_g22149_i0	PRJDB3785	22302	169	1.975	3.33775	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	41.2	0.04	NR	MEI6341235.1	2026799	g22149	i0	42	0.887573964497041	50	27	85.2	1	7	150	109	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	150	41.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
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
27790707	27790707	PRJDB3785_S_NODE_1684_length_615_cov_3.374558_g1549_i0	PRJDB3785	1684	615	3.374558	20.7535317	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	54.3	8.62e-5	NR	MEM7396574.1	2026799	g1549	i0	29	1.29268292682927	138	92	64.9	3	87	485	205	341	MEM7396574.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	795	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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
29747908	29747908	PRJDB3785_S_NODE_7031_length_283_cov_1.876068_g6878_i0	PRJDB3785	7031	283	1.876068	5.30927244	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	99	1e-21	NR	HYG84357.1	2499141	g6878	i0	58.2	0.964664310954064	91	35	93.3	2	267	4	116	206	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	273	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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
30443325	30443325	PRJDB3785_S_NODE_19613_length_179_cov_1.484615_g19460_i0	PRJDB3785	19613	179	1.484615	2.65746085	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	76.6	1.48e-14	NR	MDD5771334.1	2035772	g19460	i0	64.4	4.91061452513966	59	21	98.9	0	3	179	35	93	MDD5771334.1 phosphoglycerate kinase [Candidatus Omnitrophota bacterium]	diamond	879	76.6	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
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
31422878	31422878	PRJDB3785_S_NODE_26396_length_162_cov_0.911504_g26243_i0	PRJDB3785	26396	162	0.911504	1.47663648	Opitutales bacterium	2026772	Bacteria	Bacteria	49.7	4.58e-5	NR	MDC0647085.1	2026772	g26243	i0	52.1	0.888888888888889	48	23	88.9	0	159	16	1248	1295	MDC0647085.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Opitutales bacterium]	diamond	144	49.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales 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
31612694	31612694	PRJDB3785_S_NODE_7916_length_267_cov_1.165138_g7763_i0	PRJDB3785	7916	267	1.165138	3.11091846	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.9	0.0184	NR	HXQ80725.1	2006848	g7763	i0	41.7	3.35955056179775	48	28	53.9	0	266	123	193	240	HXQ80725.1 serine/threonine-protein kinase [Opitutaceae bacterium]	diamond	897	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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
32435551	32435551	PRJDB3785_S_NODE_14799_length_202_cov_0.895425_g14646_i0	PRJDB3785	14799	202	0.895425	1.8087585	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.4	0.0305	NR	MDR1789864.1	2006848	g14646	i0	52.5	0.594059405940594	40	11	47.5	2	61	156	528	567	MDR1789864.1 hypothetical protein [Opitutaceae bacterium]	diamond	120	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;