metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA495391" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA495391" 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
27076970	27076970	PRJNA495391_S_NODE_23042_length_250_cov_2.674419_g21990_i0	PRJNA495391	23042	250	2.674419	6.6860475	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.8	1.23e-5	NR	MEE2939368.1	2026780	g21990	i0	55.8	2.748	43	17	49.2	1	101	223	686	728	MEE2939368.1 DUF6797 domain-containing protein [Planctomycetota bacterium]	diamond	687	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28056009	28056009	PRJNA495391_S_NODE_51525_length_172_cov_2.445255_g50473_i0	PRJNA495391	51525	172	2.445255	4.2058386	Planctomycetota bacterium	2026780	Bacteria	Bacteria	66.6	2.44e-11	NR	MEY3173574.1	2026780	g50473	i0	70	0.697674418604651	40	12	69.8	0	2	121	91	130	MEY3173574.1 hypothetical protein [Planctomycetota bacterium]	diamond	120	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28624649	28624649	PRJNA495391_S_NODE_42107_length_189_cov_1.928571_g41055_i0	PRJNA495391	42107	189	1.928571	3.64499919	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0342	NR	MAG55102.1	2026780	g41055	i0	44.4	0.857142857142857	54	27	81	2	31	183	212	265	MAG55102.1 ABC transporter [Planctomycetota bacterium]	diamond	162	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29192922	29192922	PRJNA495391_S_NODE_33969_length_209_cov_1.712644_g32917_i0	PRJNA495391	33969	209	1.712644	3.57942596	Planctomycetales bacterium	2053591	Bacteria	Bacteria	88.6	1.58e-20	NR	MCA9178134.1	2053591	g32917	i0	64.2	3.84688995215311	67	24	96.2	0	204	4	71	137	MCA9178134.1 aminoacyl-tRNA hydrolase [Planctomycetales bacterium]	diamond	804	88.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29413679	29413679	PRJNA495391_S_NODE_25389_length_239_cov_2.068627_g24337_i0	PRJNA495391	25389	239	2.068627	4.94401853	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0465	NR	HKD99663.1	2026780	g24337	i0	50.9	0.665271966527197	53	24	66.5	1	42	200	38	88	HKD99663.1 thiamine-phosphate kinase [Planctomycetota bacterium]	diamond	159	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29539974	29539974	PRJNA495391_S_NODE_6830_length_469_cov_3.214286_g5783_i0	PRJNA495391	6830	469	3.214286	15.07500134	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	79.3	1.58e-14	NR	MFA6358854.1	2035772	g5783	i0	45.5	0.70362473347548	110	55	69.7	2	469	143	134	239	MFA6358854.1 HNH endonuclease signature motif containing protein [Candidatus Omnitrophota bacterium]	diamond	330	79.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29855876	29855876	PRJNA495391_S_NODE_68671_length_152_cov_1.957265_g67619_i0	PRJNA495391	68671	152	1.957265	2.9750428	Planctomycetota bacterium	2026780	Bacteria	Bacteria	68.6	8.36e-12	NR	MCO5165503.1	2026780	g67619	i0	68.6	7.69736842105263	51	14	96.7	1	2	148	130	180	MCO5165503.1 von Willebrand factor type A domain-containing protein [Planctomycetota bacterium]	diamond	1170	68.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30803646	30803646	PRJNA495391_S_NODE_55934_length_166_cov_1.824427_g54882_i0	PRJNA495391	55934	166	1.824427	3.02854882	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	80.9	3.45e-18	NR	HIB64395.1	2052180	g54882	i0	67.3	3.92168674698795	55	16	95.8	1	6	164	11	65	HIB64395.1 hypothetical protein [Phycisphaerales bacterium]	diamond	651	80.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31657029	31657029	PRJNA495391_S_NODE_25037_length_241_cov_1.237864_g23985_i0	PRJNA495391	25037	241	1.237864	2.98325224	Pirellulales bacterium	2715253	Bacteria	Bacteria	42.4	0.0475	NR	HZZ72305.1	2715253	g23985	i0	41.3	0.572614107883817	46	27	57.3	0	241	104	99	144	HZZ72305.1 tetratricopeptide repeat protein [Pirellulales bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32100107	32100107	PRJNA495391_S_NODE_39878_length_194_cov_1.754717_g38826_i0	PRJNA495391	39878	194	1.754717	3.40415098	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	43.1	0.0145	NR	MFO0918096.1	2026779	g38826	i0	51.1	0.695876288659794	45	18	64.9	2	43	168	532	575	MFO0918096.1 DUF1549 domain-containing protein [Planctomycetaceae bacterium]	diamond	135	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32290351	32290351	PRJNA495391_S_NODE_26759_length_233_cov_2.090909_g25707_i0	PRJNA495391	26759	233	2.090909	4.87181797	Planctomycetota bacterium	2026780	Bacteria	Bacteria	60.1	2.61e-9	NR	MEM0925828.1	2026780	g25707	i0	81.6	0.489270386266094	38	7	48.9	0	2	115	86	123	MEM0925828.1 hypothetical protein [Planctomycetota bacterium]	diamond	114	60.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32511786	32511786	PRJNA495391_S_NODE_8319_length_420_cov_2.324675_g7268_i0	PRJNA495391	8319	420	2.324675	9.763635	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	128	8.37e-33	NR	MDB5357711.1	2052180	g7268	i0	49	2.02142857142857	143	68	99.3	3	419	3	154	295	MDB5357711.1 hypothetical protein [Phycisphaerales bacterium]	diamond	849	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32527335	32527335	PRJNA495391_S_NODE_7159_length_456_cov_2.258907_g6109_i0	PRJNA495391	7159	456	2.258907	10.30061592	Bacteria	2	Bacteria	Bacteria	70.9	7.26e-12	NR	MBL7185283.1	2026778	g6109	i0	37.5	1.95394736842105	96	56	60.5	3	24	299	86	181	MBL7185283.1 hypothetical protein [Phycisphaerae bacterium]	diamond	891	71.2	0.995786516853933	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32858052	32858052	PRJNA495391_S_NODE_26120_length_236_cov_1.706468_g25068_i0	PRJNA495391	26120	236	1.706468	4.02726448	Chthoniobacter sp.	2510640	Bacteria	Bacteria	142	2.629999999999999e-38	NR	MDR3405335.1	2510640	g25068	i0	84.6	0.991525423728814	78	12	99.2	0	2	235	309	386	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	234	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.

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);;