metadata: contig_metadata: 21 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax

21 rows where analysis = "diamond", bioproject = "PRJNA942359" 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
4751371	4751371	PRJNA942359_P_NODE_18444_length_245_cov_0.906977_g18329_i0	PRJNA942359	18444	245	0.906977	2.22209365	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	79	6.88e-15	NR	HYJ06632.1	2201154	g18329	i0	94.7	0.46530612244898	38	2	46.5	0	245	132	908	945	HYJ06632.1 zinc-dependent metalloprotease family protein [Chthoniobacterales bacterium]	diamond	114	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
19110237	19110237	PRJNA942359_P_NODE_9035_length_290_cov_1.852535_g8920_i0	PRJNA942359	9035	290	1.852535	5.3723515	Pirellulales bacterium	2715253	Bacteria	Bacteria	160	9.35e-48	NR	MFO0900204.1	2715253	g8920	i0	84.4	0.993103448275862	96	15	99.3	0	1	288	65	160	MFO0900204.1 RNA polymerase sigma factor [Pirellulales bacterium]	diamond	288	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27373249	27373249	PRJNA942359_P_NODE_18863_length_244_cov_0.912281_g18748_i0	PRJNA942359	18863	244	0.912281	2.22596564	Gemmata sp.	1914242	Bacteria	Bacteria	134	3.12e-34	NR	HEV3436501.1	1914242	g18748	i0	74.1	1.99180327868852	81	21	99.6	0	2	244	563	643	HEV3436501.1 DUF255 domain-containing protein [Gemmata sp.]	diamond	486	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
27436316	27436316	PRJNA942359_P_NODE_13663_length_252_cov_0.871508_g13548_i0	PRJNA942359	13663	252	0.871508	2.19620016	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	166	1.85e-47	NR	WP_336519313.1	3064265	g13548	i0	94	1	84	5	100	0	252	1	58	141	WP_336519313.1 glucuronate isomerase [Planctellipticum variicoloris]	diamond	252	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
27436325	27436325	PRJNA942359_P_NODE_9863_length_282_cov_1.349282_g9748_i0	PRJNA942359	9863	282	1.349282	3.80497524	Planctomycetota bacterium	2026780	Bacteria	Bacteria	175	1.3499999999999999e-48	NR	MBC8469060.1	2026780	g9748	i0	88.2	2.96808510638298	93	11	98.9	0	281	3	50	142	MBC8469060.1 hypothetical protein [Planctomycetota bacterium]	diamond	837	175	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27467790	27467790	PRJNA942359_P_NODE_13903_length_252_cov_0.871508_g13788_i0	PRJNA942359	13903	252	0.871508	2.19620016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	84.7	4.49e-17	NR	MDQ1272615.1	2026780	g13788	i0	63.5	0.880952380952381	74	27	88.1	0	222	1	20	93	MDQ1272615.1 arabinose-5-phosphate isomerase [Planctomycetota bacterium]	diamond	222	84.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27909436	27909436	PRJNA942359_P_NODE_14545_length_251_cov_0.876404_g14430_i0	PRJNA942359	14545	251	0.876404	2.19977404	Gemmataceae bacterium	2052164	Bacteria	Bacteria	54.3	2.15e-7	NR	MFO0804316.1	2052164	g14430	i0	70	0.47808764940239	40	12	47.8	0	120	1	6	45	MFO0804316.1 hypothetical protein [Gemmataceae bacterium]	diamond	120	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28130886	28130886	PRJNA942359_P_NODE_19845_length_242_cov_0.923077_g19730_i0	PRJNA942359	19845	242	0.923077	2.23384634	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.1	0.0237	NR	NUQ33636.1	2026779	g19730	i0	40.3	0.768595041322314	62	28	65.7	1	242	84	5	66	NUQ33636.1 sigma-70 family RNA polymerase sigma factor [Planctomycetaceae bacterium]	diamond	186	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28926855	28926855	PRJNA942359_P_NODE_18228_length_245_cov_0.906977_g18113_i0	PRJNA942359	18228	245	0.906977	2.22209365	Verrucomicrobiota	74201	Bacteria	Bacteria	131	1.68e-33	NR	MEA3186286.1	2510640	g18113	i0	83.8	6.86938775510204	80	10	98	2	240	1	487	563	MEA3186286.1 formate dehydrogenase beta subunit [Chthoniobacter sp.]	diamond	1683	131	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
29488219	29488219	PRJNA942359_P_NODE_9210_length_289_cov_0.861111_g9095_i0	PRJNA942359	9210	289	0.861111	2.48861079	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0469	NR	MCA8964472.1	2026780	g9095	i0	50	0.394463667820069	38	19	39.4	0	175	288	56	93	MCA8964472.1 class I SAM-dependent methyltransferase [Planctomycetota bacterium]	diamond	114	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29519909	29519909	PRJNA942359_P_NODE_18170_length_245_cov_0.906977_g18055_i0	PRJNA942359	18170	245	0.906977	2.22209365	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	115	7.15e-28	NR	MEW6304817.1	2026799	g18055	i0	72.8	1.97142857142857	81	18	99.2	2	245	3	117	193	MEW6304817.1 DUF2514 family protein [Verrucomicrobiota bacterium]	diamond	483	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29867339	29867339	PRJNA942359_P_NODE_13991_length_252_cov_0.871508_g13876_i0	PRJNA942359	13991	252	0.871508	2.19620016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	153	4.1e-43	NR	MCC6406646.1	2026780	g13876	i0	88	1.97619047619048	83	10	98.8	0	250	2	250	332	MCC6406646.1 bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Planctomycetota bacterium]	diamond	498	153	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29993773	29993773	PRJNA942359_P_NODE_18691_length_244_cov_0.912281_g18576_i0	PRJNA942359	18691	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	72.8	9.37e-13	NR	MDJ0974891.1	2026780	g18576	i0	54.1	0.909836065573771	74	32	91	1	244	23	167	238	MDJ0974891.1 hypothetical protein [Planctomycetota bacterium]	diamond	222	72.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30632207	30632207	PRJNA942359_P_NODE_13653_length_252_cov_0.871508_g13538_i0	PRJNA942359	13653	252	0.871508	2.19620016	Blastopirellula	265487	Bacteria	Bacteria	144	1.37e-39	NR	PQO34445.1	124	g13538	i0	83.1	4.94047619047619	83	14	98.8	0	251	3	268	350	PQO34445.1 serine protease [Blastopirellula marina]	diamond	1245	144	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula marina
31486000	31486000	PRJNA942359_P_NODE_19236_length_243_cov_0.917647_g19121_i0	PRJNA942359	19236	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	81.3	8.81e-16	NR	MSU68344.1	2006848	g19121	i0	88.4	4.39506172839506	43	5	53.1	0	131	3	1	43	MSU68344.1 sugar porter family MFS transporter [Opitutaceae bacterium]	diamond	1068	81.6	0.996323529411765	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31763597	31763597	PRJNA942359_P_NODE_18677_length_244_cov_0.912281_g18562_i0	PRJNA942359	18677	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.2	1.1e-22	NR	MBS0204489.1	2026780	g18562	i0	59.2	1.89344262295082	76	31	93.4	0	229	2	4	79	MBS0204489.1 class I SAM-dependent methyltransferase [Planctomycetota bacterium]	diamond	462	98.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31890070	31890070	PRJNA942359_P_NODE_10037_length_280_cov_1.507246_g9922_i0	PRJNA942359	10037	280	1.507246	4.2202888	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	122	4.74e-34	NR	MDB5354815.1	2052180	g9922	i0	81.3	0.803571428571429	75	14	80.4	0	55	279	1	75	MDB5354815.1 hypothetical protein [Phycisphaerales bacterium]	diamond	225	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32301838	32301838	PRJNA942359_P_NODE_15999_length_248_cov_0.891429_g15884_i0	PRJNA942359	15999	248	0.891429	2.21074392	Humisphaera borealis	2807512	Bacteria	Bacteria	49.7	1.36e-4	NR	WP_206295573.1	2807512	g15884	i0	64.7	0.411290322580645	34	12	41.1	0	1	102	334	367	WP_206295573.1 hypothetical protein [Humisphaera borealis]	diamond	102	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
32364921	32364921	PRJNA942359_P_NODE_14919_length_250_cov_0.881356_g14804_i0	PRJNA942359	14919	250	0.881356	2.20339	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	92	1.04e-19	NR	MCD4824176.1	2026778	g14804	i0	62.9	2.256	62	23	74.4	0	1	186	338	399	MCD4824176.1 ATP-binding protein [Phycisphaerae bacterium]	diamond	564	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32396503	32396503	PRJNA942359_P_NODE_5079_length_367_cov_1.319728_g4964_i0	PRJNA942359	5079	367	1.319728	4.84340176	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	239	5.87e-76	NR	HJW85717.1	2094028	g4964	i0	99.2	0.997275204359673	122	1	99.7	0	2	367	170	291	HJW85717.1 group II intron reverse transcriptase/maturase [Candidatus Brocadiaceae bacterium]	diamond	366	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
32680334	32680334	PRJNA942359_P_NODE_15120_length_250_cov_0.881356_g15005_i0	PRJNA942359	15120	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	58.5	1.11e-7	NR	MBV9124879.1	2026780	g15005	i0	47.6	1.98	84	41	97.2	3	1	243	59	142	MBV9124879.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Planctomycetota bacterium]	diamond	495	58.5	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);;