metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA577226" 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
22239456	22239456	PRJNA577226_S_NODE_57118_length_166_cov_1.162791_g56179_i0	PRJNA577226	57118	166	1.162791	1.93023306	Planctomycetia bacterium	2052181	Bacteria	Bacteria	65.5	8.33e-11	NR	MFN6053982.1	2052181	g56179	i0	61.8	0.993975903614458	55	19	99.4	1	1	165	178	230	MFN6053982.1 FG-GAP repeat domain-containing protein [Planctomycetia bacterium]	diamond	165	65.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
26858487	26858487	PRJNA577226_S_NODE_43161_length_189_cov_2.250000_g42222_i0	PRJNA577226	43161	189	2.25	4.2525	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	79	2.45e-15	NR	MBC8552221.1	2760054	g42222	i0	61.9	1	63	22	100	2	1	189	272	332	MBC8552221.1 phage portal protein [Candidatus Brocadiales bacterium]	diamond	189	79	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
27300948	27300948	PRJNA577226_S_NODE_23463_length_260_cov_1.573991_g22524_i0	PRJNA577226	23463	260	1.573991	4.0923766	Chlamydia trachomatis	813	Bacteria	Bacteria	166	1.26e-50	NR	WP_194941313.1	813	g22524	i0	100	0.923076923076923	80	0	92.3	0	1	240	75	154	WP_194941313.1 hypothetical protein [Chlamydia trachomatis]	diamond	240	166	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27395890	27395890	PRJNA577226_S_NODE_48943_length_178_cov_1.957447_g48004_i0	PRJNA577226	48943	178	1.957447	3.48425566	Chlamydia trachomatis	813	Bacteria	Bacteria	114	1.1000000000000002e-28	NR	CPR46792.1	813	g48004	i0	100	0.97752808988764	58	0	97.8	0	176	3	281	338	CPR46792.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	174	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27427483	27427483	PRJNA577226_S_NODE_25143_length_250_cov_2.272300_g24204_i0	PRJNA577226	25143	250	2.2723	5.68075	Planctomycetia bacterium	2052181	Bacteria	Bacteria	45.1	0.00637	NR	MEI8369323.1	2052181	g24204	i0	38.5	0.936	78	47	92.4	1	1	231	57	134	MEI8369323.1 serine/threonine-protein kinase [Planctomycetia bacterium]	diamond	234	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27900694	27900694	PRJNA577226_S_NODE_50905_length_175_cov_1.413043_g49966_i0	PRJNA577226	50905	175	1.413043	2.47282525	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	70.9	7.58e-13	NR	HXY34838.1	2026779	g49966	i0	55.2	5.69142857142857	58	25	97.7	1	173	3	128	185	HXY34838.1 class I SAM-dependent methyltransferase [Planctomycetaceae bacterium]	diamond	996	70.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27932471	27932471	PRJNA577226_S_NODE_55725_length_168_cov_1.045802_g54786_i0	PRJNA577226	55725	168	1.045802	1.75694736	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0342	NR	MBC8870611.1	2026780	g54786	i0	45.5	0.785714285714286	44	24	78.6	0	167	36	77	120	MBC8870611.1 Nramp family divalent metal transporter [Planctomycetota bacterium]	diamond	132	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27945990	27945990	PRJNA577226_S_NODE_33965_length_214_cov_1.322034_g33026_i0	PRJNA577226	33965	214	1.322034	2.82915276	Pseudomonadati	3379134	Bacteria	Bacteria	57.8	9.43e-9	NR	KAA3614469.1	2026780	g33026	i0	74.3	1.97663551401869	35	9	49.1	0	122	18	6	40	KAA3614469.1 MAG: DUF4325 domain-containing protein [Planctomycetota bacterium]	diamond	423	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28040777	28040777	PRJNA577226_S_NODE_11425_length_386_cov_1.899713_g10488_i0	PRJNA577226	11425	386	1.899713	7.33289218	Pseudomonadati	3379134	Bacteria	Bacteria	64.3	2.53e-10	NR	MCG3176831.1	2035772	g10488	i0	32.4	2.43264248704663	105	70	81.6	1	331	17	12	115	MCG3176831.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	939	64.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29700203	29700203	PRJNA577226_S_NODE_23950_length_257_cov_1.904545_g23011_i0	PRJNA577226	23950	257	1.904545	4.89468065	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	47	0.00137	NR	MEX1118820.1	2832348	g23011	i0	66.7	0.385214007782101	33	11	38.5	0	78	176	389	421	MEX1118820.1 CCA tRNA nucleotidyltransferase [Terrimicrobiaceae bacterium]	diamond	99	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
29826794	29826794	PRJNA577226_S_NODE_66291_length_155_cov_1.652542_g65352_i0	PRJNA577226	66291	155	1.652542	2.5614401	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.1	0.00826	NR	MFO0833199.1	2052180	g65352	i0	53.8	0.754838709677419	39	17	75.5	1	133	17	335	372	MFO0833199.1 FAD-dependent oxidoreductase [Phycisphaerales bacterium]	diamond	117	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30187833	30187833	PRJNA577226_S_NODE_27812_length_237_cov_2.090000_g26873_i0	PRJNA577226	27812	237	2.09	4.9533	PVC group	1783257	Bacteria	Bacteria	87.8	2.83e-18	NR	MEM9915694.1	2026780	g26873	i0	60.3	5.45569620253165	73	29	92.4	0	235	17	261	333	MEM9915694.1 DUF262 domain-containing protein [Planctomycetota bacterium]	diamond	1293	88.6	0.99097065462754	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30679736	30679736	PRJNA577226_S_NODE_64153_length_157_cov_1.950000_g63214_i0	PRJNA577226	64153	157	1.95	3.0615	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	67	2.98e-11	NR	MBC8552221.1	2760054	g63214	i0	59.6	1.94904458598726	52	21	99.4	0	156	1	325	376	MBC8552221.1 phage portal protein [Candidatus Brocadiales bacterium]	diamond	306	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
30869433	30869433	PRJNA577226_S_NODE_2794_length_969_cov_3.217811_g2003_i0	PRJNA577226	2794	969	3.217811	31.18058859	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	103	2.43e-20	NR	MBR5457434.1	2212473	g2003	i0	33.3	0.603715170278638	195	114	55.4	4	2	538	9	203	MBR5457434.1 GIY-YIG nuclease family protein [Kiritimatiellia bacterium]	diamond	585	103	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31121902	31121902	PRJNA577226_S_NODE_53415_length_171_cov_1.455224_g52476_i0	PRJNA577226	53415	171	1.455224	2.48843304	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42	0.0264	NR	NBW86160.1	2052181	g52476	i0	47.1	0.894736842105263	51	25	87.7	2	158	9	533	582	NBW86160.1 hypothetical protein [Planctomycetia bacterium]	diamond	153	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31533584	31533584	PRJNA577226_S_NODE_41296_length_193_cov_2.500000_g40357_i0	PRJNA577226	41296	193	2.5	4.825	Chlamydia trachomatis	813	Bacteria	Bacteria	108	2.25e-26	NR	CPR46792.1	813	g40357	i0	100	0.994818652849741	64	0	99.5	0	193	2	76	139	CPR46792.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	192	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31628207	31628207	PRJNA577226_S_NODE_31196_length_224_cov_1.197861_g30257_i0	PRJNA577226	31196	224	1.197861	2.68320864	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	118	6.17e-29	NR	MCB9858810.1	2052180	g30257	i0	70.3	2.97321428571429	74	22	99.1	0	224	3	260	333	MCB9858810.1 site-specific DNA-methyltransferase [Phycisphaerales bacterium]	diamond	666	118	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31659717	31659717	PRJNA577226_S_NODE_65797_length_156_cov_0.983193_g64858_i0	PRJNA577226	65797	156	0.983193	1.53378108	Planctomycetota bacterium	2026780	Bacteria	Bacteria	101	1.6e-26	NR	MBM4059100.1	2026780	g64858	i0	96.1	0.980769230769231	51	2	98.1	0	2	154	1	51	MBM4059100.1 hypothetical protein [Planctomycetota bacterium]	diamond	153	101	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);;