metadata: contig_metadata: 13 rows where bioproject = "PRJNA682774" and tax

13 rows where bioproject = "PRJNA682774" 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
3215471	3215471	PRJNA682774_P_NODE_4863_length_245_cov_0.906977_g4834_i0	PRJNA682774	4863	245	0.906977	2.22209365	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|2108005054\|gb\|CP070772.1\|	2052180	g4834	i0	79.821	0.910204081632653	223	41	90	4	18	238	685773	685993	MAG: Phycisphaerales bacterium isolate bin220 chromosome	blastn	223	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
15967387	15967387	PRJNA682774_P_NODE_4813_length_245_cov_0.906977_g4784_i0	PRJNA682774	4813	245	0.906977	2.22209365	Akkermansia muciniphila	239935	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2051367837\|gb\|CP072029.1\|	239935	g4784	i0	99.592	65.0897959183673	245	1	100	0	1	245	1577096	1577340	Akkermansia muciniphila strain Akk1713 chromosome, complete genome	blastn	15947	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
17242596	17242596	PRJNA682774_P_NODE_4154_length_249_cov_0.886364_g4125_i0	PRJNA682774	4154	249	0.886364	2.20704636	Akkermansia muciniphila	239935	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2623926283\|gb\|CP137887.1\|	239935	g4125	i0	100	95.6746987951807	249	0	100	0	1	249	318517	318765	Akkermansia muciniphila strain SDLYAKK5 chromosome, complete genome	blastn	23823	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
27335164	27335164	PRJNA682774_P_NODE_5263_length_243_cov_0.917647_g5234_i0	PRJNA682774	5263	243	0.917647	2.22988221	Opitutaceae bacterium	2006848	Bacteria	Bacteria	73.9	2.33e-13	NR	HWA10989.1	2006848	g5234	i0	51.3	0.987654320987654	80	28	97.5	2	237	1	168	237	HWA10989.1 hypothetical protein [Opitutaceae bacterium]	diamond	240	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27631013	27631013	PRJNA682774_P_NODE_1424_length_366_cov_1.993174_g1395_i0	PRJNA682774	1424	366	1.993174	7.29501684	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	3.29e-7	NR	MBO6102755.1	2026772	g1395	i0	50.9	1.59836065573771	57	28	46.7	0	147	317	1054	1110	MBO6102755.1 hypothetical protein [Opitutales bacterium]	diamond	585	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27650926	27650926	PRJNA682774_P_NODE_3864_length_251_cov_0.876404_g3835_i0	PRJNA682774	3864	251	0.876404	2.19977404	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	95.5	4.500000000000001e-22	NR	HCG27922.1	2053569	g3835	i0	98	0.597609561752988	50	1	59.8	0	251	102	177	226	HCG27922.1 hypothetical protein [Lentisphaeria bacterium]	diamond	150	95.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27820452	27820452	PRJNA682774_P_NODE_2944_length_270_cov_1.583756_g2915_i0	PRJNA682774	2944	270	1.583756	4.2761412	Bacteria	2	Bacteria	Bacteria	103	2.13e-23	NR	MBI3829501.1	2026780	g2915	i0	58.4	1.97777777777778	89	36	98.9	1	269	3	343	430	MBI3829501.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Planctomycetota bacterium]	diamond	534	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29260881	29260881	PRJNA682774_P_NODE_4849_length_245_cov_0.906977_g4820_i0	PRJNA682774	4849	245	0.906977	2.22209365	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	73.2	7.22e-13	NR	RYD77759.1	2026800	g4820	i0	45.6	0.96734693877551	79	42	96.7	1	244	8	511	588	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	237	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30019116	30019116	PRJNA682774_P_NODE_5011_length_244_cov_0.912281_g4982_i0	PRJNA682774	5011	244	0.912281	2.22596564	Roseimaritima multifibrata	1930274	Bacteria	Bacteria	87.8	1.51e-18	NR	WP_145352363.1	1930274	g4982	i0	66.7	3.13524590163934	57	19	70.1	0	66	236	49	105	WP_145352363.1 metallophosphoesterase [Roseimaritima multifibrata]	diamond	765	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima multifibrata
31800334	31800334	PRJNA682774_P_NODE_5377_length_242_cov_0.923077_g5348_i0	PRJNA682774	5377	242	0.923077	2.23384634	PVC group	1783257	Bacteria	Bacteria	65.9	2.46e-10	NR	KPK77428.1	1703411	g5348	i0	76.3	10.3636363636364	38	9	47.1	0	1	114	364	401	KPK77428.1 MAG: elongation factor Tu [Phycisphaerae bacterium SM23_30]	diamond	2508	65.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium SM23_30
32105260	32105260	PRJNA682774_P_NODE_4638_length_246_cov_0.901734_g4609_i0	PRJNA682774	4638	246	0.901734	2.21826564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	160	1.9e-44	NR	MCH7992811.1	2026780	g4609	i0	96.3	0.98780487804878	81	3	98.8	0	2	244	2	82	MCH7992811.1 carbamoyltransferase [Planctomycetota bacterium]	diamond	243	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32200271	32200271	PRJNA682774_P_NODE_3438_length_253_cov_0.866667_g3409_i0	PRJNA682774	3438	253	0.866667	2.19266751	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	45.1	0.00681	NR	MBL9138679.1	2026801	g3409	i0	32.5	0.91304347826087	77	47	91.3	2	2	232	541	612	MBL9138679.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	231	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32768667	32768667	PRJNA682774_P_NODE_5160_length_243_cov_0.917647_g5131_i0	PRJNA682774	5160	243	0.917647	2.22988221	Planctomycetales bacterium	2053591	Bacteria	Bacteria	142	2.5499999999999998e-40	NR	MCA9216007.1	2053591	g5131	i0	85.2	2	81	11	98.8	1	3	242	107	187	MCA9216007.1 hypothetical protein [Planctomycetales bacterium]	diamond	486	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales 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);;