metadata: contig_metadata: 22 rows where bioproject = "PRJNA825466" and tax

22 rows where bioproject = "PRJNA825466" 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
3371289	3371289	PRJNA825466_P_NODE_28423_length_241_cov_0.916667_g28322_i0	PRJNA825466	28423	241	0.916667	2.20916747	Akkermansia muciniphila	239935	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g28322	i0	100	100	241	0	100	0	1	241	497342	497102	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24100	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
5923646	5923646	PRJNA825466_P_NODE_14625_length_260_cov_1.240642_g14524_i0	PRJNA825466	14625	260	1.240642	3.2256692	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	161	4.39e-45	NR	HVZ93305.1	2052180	g14524	i0	85.9	0.980769230769231	85	12	98.1	0	6	260	218	302	HVZ93305.1 adenosylhomocysteinase [Phycisphaerales bacterium]	diamond	255	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16123083	16123083	PRJNA825466_S_NODE_1793_length_245_cov_0.895349_g1787_i0	PRJNA825466	1793	245	0.895349	2.19360505	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	92	4.06e-20	NR	HET6572422.1	1914235	g1787	i0	75	1.37142857142857	56	14	68.6	0	75	242	58	113	HET6572422.1 fused MFS/spermidine synthase [Fimbriiglobus sp.]	diamond	336	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
26896453	26896453	PRJNA825466_P_NODE_28041_length_241_cov_2.375000_g27940_i0	PRJNA825466	28041	241	2.375	5.72375	Gemmataceae bacterium	2052164	Bacteria	Bacteria	87.8	2.49e-18	NR	HEY7428810.1	2052164	g27940	i0	71.9	0.70954356846473	57	16	71	0	173	3	1	57	HEY7428810.1 prenyltransferase/squalene oxidase repeat-containing protein [Gemmataceae bacterium]	diamond	171	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26896454	26896454	PRJNA825466_S_NODE_1861_length_244_cov_0.900585_g1855_i0	PRJNA825466	1861	244	0.900585	2.1974274	Pirellulales bacterium	2715253	Bacteria	Bacteria	89.7	1.11e-18	NR	MFO0788448.1	2715253	g1855	i0	56	0.922131147540984	75	33	92.2	0	16	240	26	100	MFO0788448.1 RICIN domain-containing protein [Pirellulales bacterium]	diamond	225	89.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27086155	27086155	PRJNA825466_P_NODE_10242_length_287_cov_0.827103_g10141_i0	PRJNA825466	10242	287	0.827103	2.37378561	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.1	0.00618	NR	MEI6341235.1	2026799	g10141	i0	37.9	0.606271777003484	58	34	58.5	1	58	225	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27718253	27718253	PRJNA825466_P_NODE_4024_length_380_cov_1.788274_g3923_i0	PRJNA825466	4024	380	1.788274	6.7954412	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	59.7	1.81e-7	NR	MEW6160311.1	2026799	g3923	i0	50.7	0.592105263157895	75	32	55.3	2	374	165	274	348	MEW6160311.1 HYR domain-containing protein [Verrucomicrobiota bacterium]	diamond	225	59.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28254508	28254508	PRJNA825466_P_NODE_14746_length_259_cov_1.655914_g14645_i0	PRJNA825466	14746	259	1.655914	4.28881726	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	86.7	6.09e-19	NR	UCG59062.1	2052180	g14645	i0	52.4	0.972972972972973	84	40	97.3	0	5	256	43	126	UCG59062.1 MAG: hypothetical protein JSU70_06045 [Phycisphaerales bacterium]	diamond	252	86.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28981021	28981021	PRJNA825466_P_NODE_9888_length_289_cov_1.370370_g9787_i0	PRJNA825466	9888	289	1.37037	3.9603693	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	88.6	2.37e-18	NR	RYD71398.1	2026800	g9787	i0	46.4	0.8719723183391	84	45	87.2	0	286	35	119	202	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	252	88.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29675109	29675109	PRJNA825466_P_NODE_19690_length_248_cov_1.342857_g19589_i0	PRJNA825466	19690	248	1.342857	3.33028536	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	141	6.8399999999999995e-37	NR	MBM3869833.1	2026799	g19589	i0	82.5	0.967741935483871	80	14	96.8	0	240	1	546	625	MBM3869833.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	240	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30023042	30023042	PRJNA825466_P_NODE_16151_length_251_cov_1.730337_g16050_i0	PRJNA825466	16151	251	1.730337	4.34314587	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.2	7.95e-13	NR	MSR63205.1	2026780	g16050	i0	45.3	2.85657370517928	75	36	89.6	1	250	26	357	426	MSR63205.1 HYR domain-containing protein [Planctomycetota bacterium]	diamond	717	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30505514	30505514	PRJNA825466_P_NODE_1813_length_520_cov_2.612975_g1714_i0	PRJNA825466	1813	520	2.612975	13.58747	Pseudomonadati	3379134	Bacteria	Bacteria	176	3.87e-50	NR	WP_018970930.1	361055	g1714	i0	51.1	5.91923076923077	174	79	98.1	3	514	5	207	378	WP_018970930.1 glycoside hydrolase family 75 protein [Rubritalea marina]	diamond	3078	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea marina
30528326	30528326	PRJNA825466_P_NODE_13673_length_265_cov_2.218750_g13572_i0	PRJNA825466	13673	265	2.21875	5.8796875	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.1	1.73e-13	NR	MCA8997906.1	2026779	g13572	i0	75	0.49811320754717	44	11	49.8	0	264	133	361	404	MCA8997906.1 SpoVR family protein [Planctomycetaceae bacterium]	diamond	132	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30528327	30528327	PRJNA825466_P_NODE_29813_length_222_cov_7.167785_g29712_i0	PRJNA825466	29813	222	7.167785	15.9124827	Opitutaceae bacterium	2006848	Bacteria	Bacteria	42.4	0.0388	NR	MBP6506442.1	2006848	g29712	i0	42.9	0.567567567567568	42	24	56.8	0	130	5	185	226	MBP6506442.1 alpha-galactosidase [Opitutaceae bacterium]	diamond	126	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31010914	31010914	PRJNA825466_P_NODE_17334_length_250_cov_1.497175_g17233_i0	PRJNA825466	17334	250	1.497175	3.7429375	PVC group	1783257	Bacteria	Bacteria	47.8	7.05e-4	NR	HSW87035.1	2047756	g17233	i0	33.8	2.844	77	47	88.8	2	223	2	602	677	HSW87035.1 CDC27 family protein [Rhabdochlamydiaceae bacterium]	diamond	711	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31159909	31159909	PRJNA825466_S_NODE_2055_length_241_cov_0.916667_g2049_i0	PRJNA825466	2055	241	0.916667	2.20916747	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	124	8.55e-32	NR	MCK6483905.1	2026778	g2049	i0	73.4	0.983402489626556	79	21	98.3	0	3	239	56	134	MCK6483905.1 PilT/PilU family type 4a pilus ATPase [Phycisphaerae bacterium]	diamond	237	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31413313	31413313	PRJNA825466_P_NODE_24636_length_244_cov_0.900585_g24535_i0	PRJNA825466	24636	244	0.900585	2.1974274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.8	9.11e-7	NR	MFH0983654.1	2026780	g24535	i0	55.3	1.04508196721311	38	17	46.7	0	117	4	280	317	MFH0983654.1 thrombospondin type 3 repeat-containing protein [Planctomycetota bacterium]	diamond	255	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31611796	31611796	PRJNA825466_P_NODE_26136_length_243_cov_0.905882_g26035_i0	PRJNA825466	26136	243	0.905882	2.20129326	Pseudomonadati	3379134	Bacteria	Bacteria	87	3.81e-18	NR	MBS0626875.1	2026799	g26035	i0	63.8	1.97530864197531	80	23	98.8	3	3	242	51	124	MBS0626875.1 MFS transporter [Verrucomicrobiota bacterium]	diamond	480	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32109245	32109245	PRJNA825466_P_NODE_10718_length_283_cov_1.361905_g10617_i0	PRJNA825466	10718	283	1.361905	3.85419115	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	87.4	1.16e-17	NR	HEX8324621.1	2876886	g10617	i0	47.9	0.996466431095406	94	49	99.6	0	283	2	381	474	HEX8324621.1 GTPase domain-containing protein [Tepidisphaeraceae bacterium]	diamond	282	87.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
32236150	32236150	PRJNA825466_S_NODE_1698_length_246_cov_0.890173_g1692_i0	PRJNA825466	1698	246	0.890173	2.18982558	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0278	NR	MBI5367152.1	2026780	g1692	i0	47.5	0.719512195121951	59	25	69.5	2	232	62	548	602	MBI5367152.1 hypothetical protein [Planctomycetota bacterium]	diamond	177	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32520818	32520818	PRJNA825466_P_NODE_21019_length_247_cov_0.885057_g20918_i0	PRJNA825466	21019	247	0.885057	2.18609079	Pirellulales bacterium	2715253	Bacteria	Bacteria	120	6.62e-30	NR	MDA7886108.1	2715253	g20918	i0	66.3	0.97165991902834	80	27	97.2	0	5	244	260	339	MDA7886108.1 glycosyltransferase family 4 protein [Pirellulales bacterium]	diamond	240	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32615262	32615262	PRJNA825466_P_NODE_28900_length_241_cov_0.916667_g28799_i0	PRJNA825466	28900	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	144	1.3899999999999999e-40	NR	MBM3965989.1	2026780	g28799	i0	97.5	12.7842323651452	79	2	98.3	0	239	3	145	223	MBM3965989.1 acetyl-CoA carboxylase carboxyltransferase subunit beta [Planctomycetota bacterium]	diamond	3081	144	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);;