metadata: contig_metadata: 25 rows where bioproject = "PRJNA721440" and tax

25 rows where bioproject = "PRJNA721440" 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
14739172	14739172	PRJNA721440_S_NODE_17552_length_167_cov_3.525424_g17426_i0	PRJNA721440	17552	167	3.525424	5.88745808	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	226	7.799999999999999e-55	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g17426	i0	92.405	177.005988023952	158	12	95	0	10	167	175619	175462	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	29560	226	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
22871151	22871151	PRJNA721440_S_NODE_458_length_721_cov_3.813988_g370_i0	PRJNA721440	458	721	3.813988	27.49885348	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	286	4.52e-93	NR	RYD65414.1	2026800	g370	i0	73.4	0.844660194174757	203	52	84.5	1	609	1	56	256	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	609	286	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
24936674	24936674	PRJNA721440_S_NODE_1160_length_486_cov_2.395881_g1036_i0	PRJNA721440	1160	486	2.395881	11.64398166	root	1	Root_unresolved	Root_unresolved	196	9.09e-59	NR	WP_184343325.1	48466	g1036	i0	55.8	22.2098765432099	163	65	98.1	2	478	2	161	320	WP_184343325.1 SAM-dependent methyltransferase [Prosthecobacter vanneervenii]	diamond	10794	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
27536537	27536537	PRJNA721440_S_NODE_19903_length_162_cov_0.920354_g19777_i0	PRJNA721440	19903	162	0.920354	1.49097348	Bacteria	2	Bacteria	Bacteria	61.6	6.39e-11	NR	GBL24036.1	2026771	g19777	i0	59.6	7.55555555555556	47	19	87	0	2	142	18	64	GBL24036.1 secretory immunoglobulin A-binding protein EsiB [Opitutia bacterium]	diamond	1224	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
27652483	27652483	PRJNA721440_S_NODE_14424_length_179_cov_1.353846_g14298_i0	PRJNA721440	14424	179	1.353846	2.42338434	Planctomycetota bacterium	2026780	Bacteria	Bacteria	94.7	6.040000000000001e-21	NR	NOZ40414.1	2026780	g14298	i0	74.6	2.91620111731844	59	15	98.9	0	2	178	343	401	NOZ40414.1 3-isopropylmalate dehydratase large subunit [Planctomycetota bacterium]	diamond	522	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27715860	27715860	PRJNA721440_S_NODE_19104_length_164_cov_0.860870_g18978_i0	PRJNA721440	19104	164	0.86087	1.4118268	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.00941	NR	NRA36897.1	2026780	g18978	i0	44.7	0.859756097560976	47	25	86	1	14	154	29	74	NRA36897.1 GHKL domain-containing protein [Planctomycetota bacterium]	diamond	141	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27852110	27852110	PRJNA721440_S_NODE_12584_length_188_cov_1.395683_g12458_i0	PRJNA721440	12584	188	1.395683	2.62388404	root	1	Root_unresolved	Root_unresolved	104	1.43e-24	NR	WP_185690965.1	388746	g12458	i0	78.7	9.63829787234043	61	13	97.3	0	184	2	133	193	WP_185690965.1 diaminopimelate decarboxylase [Puniceicoccus vermicola]	diamond	1812	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Puniceicoccaceae	Puniceicoccus	Puniceicoccus vermicola
28978562	28978562	PRJNA721440_S_NODE_1008_length_518_cov_29.699360_g885_i0	PRJNA721440	1008	518	29.69936	153.8426848	Candidatus Subterrananammoxibius californiae	3063417	Bacteria	Bacteria	216	1.41e-61	NR	MDO8094970.1	3063417	g885	i0	62	0.99034749034749	171	63	99	2	5	517	603	771	MDO8094970.1 RNase H-like domain-containing protein [Candidatus Subterrananammoxibius californiae]	diamond	513	216	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Subterrananammoxibiaceae	Candidatus Subterrananammoxibius	Candidatus Subterrananammoxibius californiae
28978566	28978566	PRJNA721440_S_NODE_12908_length_186_cov_2.875912_g12782_i0	PRJNA721440	12908	186	2.875912	5.34919632	Prosthecobacter sp.	1965333	Bacteria	Bacteria	45.1	0.00268	NR	MDP1591546.1	1965333	g12782	i0	62.9	0.564516129032258	35	13	56.5	0	105	1	10	44	MDP1591546.1 UTP--glucose-1-phosphate uridylyltransferase [Prosthecobacter sp.]	diamond	105	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
29483387	29483387	PRJNA721440_S_NODE_17430_length_168_cov_0.873950_g17304_i0	PRJNA721440	17430	168	0.87395	1.468236	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	79.7	1.21e-15	NR	RYD77031.1	2026800	g17304	i0	69.8	0.946428571428571	53	16	94.6	0	9	167	14	66	RYD77031.1 MAG: hypothetical protein EOP84_16100, partial [Verrucomicrobiaceae bacterium]	diamond	159	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29546600	29546600	PRJNA721440_S_NODE_17250_length_168_cov_1.697479_g17124_i0	PRJNA721440	17250	168	1.697479	2.85176472	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	76.3	2.01e-14	NR	HEX8200246.1	2691532	g17124	i0	61.1	1.94642857142857	54	21	96.4	0	3	164	9	62	HEX8200246.1 glucose-6-phosphate isomerase [Isosphaeraceae bacterium]	diamond	327	76.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29672730	29672730	PRJNA721440_S_NODE_19930_length_162_cov_0.920354_g19804_i0	PRJNA721440	19930	162	0.920354	1.49097348	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	41.6	0.0305	NR	MCU0752501.1	2562705	g19804	i0	38.8	0.907407407407407	49	28	90.7	1	10	156	123	169	MCU0752501.1 tetratricopeptide repeat protein [Akkermansiaceae bacterium]	diamond	147	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
30241709	30241709	PRJNA721440_S_NODE_21952_length_152_cov_4.067961_g21826_i0	PRJNA721440	21952	152	4.067961	6.18330072	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	63.9	2.47e-10	NR	RYD69104.1	2026800	g21826	i0	65.3	0.967105263157895	49	16	96.7	1	4	150	26	73	RYD69104.1 MAG: MFS transporter, partial [Verrucomicrobiaceae bacterium]	diamond	147	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30305283	30305283	PRJNA721440_S_NODE_12312_length_189_cov_5.571429_g12186_i0	PRJNA721440	12312	189	5.571429	10.53000081	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	67.4	1.22e-12	NR	RYD73501.1	2026800	g12186	i0	78.6	0.666666666666667	42	9	66.7	0	128	3	3	44	RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium]	diamond	126	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30842037	30842037	PRJNA721440_S_NODE_134_length_1122_cov_13.505126_g98_i0	PRJNA721440	134	1122	13.505126	151.52751372	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	249	6.33e-76	NR	RYD71398.1	2026800	g98	i0	45.7	0.802139037433155	300	150	78.6	6	9	890	69	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	900	249	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30873538	30873538	PRJNA721440_S_NODE_13694_length_182_cov_3.015038_g13568_i0	PRJNA721440	13694	182	3.015038	5.48736916	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	41.6	0.0426	NR	MFN7020982.1	2052180	g13568	i0	39.6	0.791208791208791	48	29	79.1	0	14	157	236	283	MFN7020982.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	144	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31000007	31000007	PRJNA721440_S_NODE_19874_length_162_cov_0.920354_g19748_i0	PRJNA721440	19874	162	0.920354	1.49097348	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	47	3.9e-4	NR	RYD20361.1	2026800	g19748	i0	45.3	0.981481481481482	53	26	92.6	1	157	8	213	265	RYD20361.1 MAG: phosphatidylinositol-specific phospholipase C domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	159	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31315989	31315989	PRJNA721440_S_NODE_16295_length_171_cov_2.081967_g16169_i0	PRJNA721440	16295	171	2.081967	3.56016357	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	99	5.089999999999999e-23	NR	RYD81270.1	2026800	g16169	i0	83.9	0.982456140350877	56	9	98.2	0	169	2	56	111	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	168	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31347733	31347733	PRJNA721440_S_NODE_11256_length_196_cov_3.476190_g11130_i0	PRJNA721440	11256	196	3.47619	6.8133324	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.4	4.52e-4	NR	MCA8973576.1	2026780	g11130	i0	44.8	0.887755102040816	58	32	88.8	0	194	21	30	87	MCA8973576.1 carbamoyl-phosphate synthase large subunit [Planctomycetota bacterium]	diamond	174	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31474264	31474264	PRJNA721440_S_NODE_14356_length_179_cov_2.238462_g14230_i0	PRJNA721440	14356	179	2.238462	4.00684698	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	74.7	8.15e-14	NR	RYD76251.1	2026800	g14230	i0	57.6	0.988826815642458	59	25	98.9	0	178	2	162	220	RYD76251.1 MAG: hypothetical protein EOP84_17160, partial [Verrucomicrobiaceae bacterium]	diamond	177	74.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31548091	31548091	PRJNA721440_S_NODE_9816_length_206_cov_3.133758_g9690_i0	PRJNA721440	9816	206	3.133758	6.45554148	Bacteria	2	Bacteria	Bacteria	90.5	3.66e-20	NR	MCE2925133.1	2026777	g9690	i0	56.9	3.78640776699029	65	28	94.7	0	10	204	20	84	MCE2925133.1 queuosine precursor transporter [Phycisphaeraceae bacterium]	diamond	780	90.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
31663784	31663784	PRJNA721440_S_NODE_12417_length_189_cov_1.442857_g12291_i0	PRJNA721440	12417	189	1.442857	2.72699973	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	43.1	0.0129	NR	HYW79930.1	2691551	g12291	i0	75	0.380952380952381	24	6	38.1	0	74	3	42	65	HYW79930.1 ammonium transporter [Thermoguttaceae bacterium]	diamond	72	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
32075196	32075196	PRJNA721440_S_NODE_17798_length_167_cov_0.881356_g17672_i0	PRJNA721440	17798	167	0.881356	1.47186452	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	100	3.9599999999999997e-23	NR	HEX2748675.1	2026801	g17672	i0	83.3	1.94011976047904	54	9	97	0	166	5	250	303	HEX2748675.1 UTP--glucose-1-phosphate uridylyltransferase [Verrucomicrobiales bacterium]	diamond	324	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32738962	32738962	PRJNA721440_S_NODE_17040_length_169_cov_0.866667_g16914_i0	PRJNA721440	17040	169	0.866667	1.46466723	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42.7	0.0141	NR	UCG46482.1	2052180	g16914	i0	45.1	0.905325443786982	51	23	90.5	2	157	5	99	144	UCG46482.1 MAG: hypothetical protein JSU94_13365, partial [Phycisphaerales bacterium]	diamond	153	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32906543	32906543	PRJNA721440_S_NODE_18180_length_166_cov_0.888889_g18054_i0	PRJNA721440	18180	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	53.5	1.98e-6	NR	MFM2092802.1	2026780	g18054	i0	54.5	4.96987951807229	55	17	99.4	1	1	165	96	142	MFM2092802.1 NAD-dependent malic enzyme [Planctomycetota bacterium]	diamond	825	53.9	0.992578849721707	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);;