metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA896973" 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
22550324	22550324	PRJNA896973_S_NODE_38_length_1693_cov_5.185185_g36_i0	PRJNA896973	38	1693	5.185185	87.78518205	Gemmataceae bacterium	2052164	Bacteria	Bacteria	342	1.46e-111	NR	HEY7331155.1	2052164	g36	i0	74	1.97578263437685	223	58	39.5	0	576	1244	1	223	HEY7331155.1 heavy metal response regulator transcription factor [Gemmataceae bacterium]	diamond	3345	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
26834316	26834316	PRJNA896973_P_NODE_20401_length_257_cov_2.114130_g20307_i0	PRJNA896973	20401	257	2.11413	5.4333141	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.042	NR	MBI5768465.1	2026799	g20307	i0	34.3	0.817120622568093	70	46	81.7	0	46	255	146	215	MBI5768465.1 glycoside hydrolase family protein [Verrucomicrobiota bacterium]	diamond	210	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26960626	26960626	PRJNA896973_P_NODE_24542_length_246_cov_1.780347_g24448_i0	PRJNA896973	24542	246	1.780347	4.37965362	Planctomycetota bacterium	2026780	Bacteria	Bacteria	160	9.83e-45	NR	MBS0264672.1	2026780	g24448	i0	95.1	2.96341463414634	81	4	98.8	0	2	244	165	245	MBS0264672.1 DUF1501 domain-containing protein [Planctomycetota bacterium]	diamond	729	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27094995	27094995	PRJNA896973_S_NODE_822_length_405_cov_4.382530_g808_i0	PRJNA896973	822	405	4.38253	17.7492465	Chthoniobacter	295577	Bacteria	Bacteria	101	7.1400000000000005e-22	NR	MDB6149795.1	2510640	g808	i0	74.1	1.19259259259259	54	14	40	0	27	188	95	148	MDB6149795.1 hypothetical protein [Chthoniobacter sp.]	diamond	483	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
28263390	28263390	PRJNA896973_P_NODE_23086_length_249_cov_0.875000_g22992_i0	PRJNA896973	23086	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	48.9	9.16e-5	NR	MEI9997826.1	2026799	g22992	i0	52	1.91566265060241	50	21	57.8	2	230	87	101	149	MEI9997826.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	477	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29297861	29297861	PRJNA896973_P_NODE_28209_length_241_cov_0.916667_g28115_i0	PRJNA896973	28209	241	0.916667	2.20916747	Candidatus Brocadiaceae bacterium	2094028	Bacteria	Bacteria	42.4	0.0456	NR	NLW51132.1	2094028	g28115	i0	33.3	0.746887966804979	60	36	74.7	2	4	183	187	242	NLW51132.1 cytochrome c biogenesis protein CcsA [Candidatus Brocadiaceae bacterium]	diamond	180	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae		Candidatus Brocadiaceae bacterium
29739581	29739581	PRJNA896973_P_NODE_24930_length_246_cov_0.890173_g24836_i0	PRJNA896973	24930	246	0.890173	2.18982558	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	135	1.15e-35	NR	MDB5334976.1	2026779	g24836	i0	84.1	1	82	13	100	0	1	246	35	116	MDB5334976.1 transposase family protein [Planctomycetaceae bacterium]	diamond	246	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30150274	30150274	PRJNA896973_P_NODE_27332_length_242_cov_0.911243_g27238_i0	PRJNA896973	27332	242	0.911243	2.20520806	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	124	9.1e-31	NR	MDE1920525.1	2035772	g27238	i0	73.8	3.96694214876033	80	21	99.2	0	240	1	601	680	MDE1920525.1 ATP-dependent DNA helicase RecG [Candidatus Omnitrophota bacterium]	diamond	960	124	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
30972113	30972113	PRJNA896973_P_NODE_25594_length_245_cov_0.895349_g25500_i0	PRJNA896973	25594	245	0.895349	2.19360505	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	117	6.27e-30	NR	WP_171475323.1	2774151	g25500	i0	84.7	0.881632653061225	72	11	88.2	0	2	217	192	263	WP_171475323.1 FG-GAP repeat domain-containing protein [Frigoriglobus tundricola]	diamond	216	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
31414567	31414567	PRJNA896973_P_NODE_24276_length_247_cov_0.885057_g24182_i0	PRJNA896973	24276	247	0.885057	2.18609079	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	124	3.63e-31	NR	MCE0523300.1	2720631	g24182	i0	72	1.9919028340081	82	23	99.6	0	246	1	140	221	MCE0523300.1 tetratricopeptide repeat protein [Candidatus Methylacidiphilales bacterium]	diamond	492	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
31793879	31793879	PRJNA896973_P_NODE_22877_length_249_cov_0.875000_g22783_i0	PRJNA896973	22877	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	164	2e-45	NR	MBN9121418.1	2026780	g22783	i0	93.9	3.95180722891566	82	5	98.8	0	2	247	529	610	MBN9121418.1 DUF1549 domain-containing protein [Planctomycetota bacterium]	diamond	984	164	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31825568	31825568	PRJNA896973_P_NODE_27717_length_241_cov_1.821429_g27623_i0	PRJNA896973	27717	241	1.821429	4.38964389	Gemmataceae bacterium	2052164	Bacteria	Bacteria	94.4	1.84e-20	NR	MCC6417287.1	2052164	g27623	i0	70	0.995850622406639	80	24	99.6	0	1	240	120	199	MCC6417287.1 efflux RND transporter periplasmic adaptor subunit [Gemmataceae bacterium]	diamond	240	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32047258	32047258	PRJNA896973_P_NODE_24178_length_247_cov_0.885057_g24084_i0	PRJNA896973	24178	247	0.885057	2.18609079	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	103	2.13e-23	NR	WP_171469499.1	2774151	g24084	i0	63.4	0.995951417004049	82	29	99.6	1	246	1	328	408	WP_171469499.1 tetratricopeptide repeat protein [Frigoriglobus tundricola]	diamond	246	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola

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