metadata: contig_metadata: 10 rows where bioproject = "PRJNA429937", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA429937", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"

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_species
9354931	9354931	PRJNA429937_P_NODE_45248_length_531_cov_6.270916_g29119_i0	PRJNA429937	45248	531	6.270916	33.29856396	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	205	1.11e-59	NR	MBI3008271.1	2035772	g29119	i0	93.1	0.576271186440678	102	7	57.6	0	19	324	180	281	MBI3008271.1 threonine--tRNA ligase [Candidatus Omnitrophota bacterium]	diamond	306	205	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
26695741	26695741	PRJNA429937_P_NODE_103921_length_291_cov_2.232824_g81304_i0	PRJNA429937	103921	291	2.232824	6.49751784	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	157	3.68e-42	NR	MCG3177555.1	2035772	g81304	i0	78.9	0.927835051546392	90	19	92.8	0	16	285	508	597	MCG3177555.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	270	157	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
27486513	27486513	PRJNA429937_P_NODE_16023_length_918_cov_3.052868_g9458_i0	PRJNA429937	16023	918	3.052868	28.02532824	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	44.7	0.0175	NR	MCK9428762.1	2035772	g9458	i0	40	0.196078431372549	60	35	19.6	1	409	230	1	59	MCK9428762.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	180	44.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
28307480	28307480	PRJNA429937_P_NODE_48026_length_513_cov_3.303719_g20286_i1	PRJNA429937	48026	513	3.303719	16.94807847	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	68.6	6.42e-10	NR	MCB9800384.1	2035772	g20286	i1	54.7	0.730994152046784	64	27	37.4	1	267	458	468	529	MCB9800384.1 response regulator [Candidatus Omnitrophota bacterium]	diamond	375	68.6	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
29096890	29096890	PRJNA429937_P_NODE_54568_length_475_cov_3.578475_g20286_i2	PRJNA429937	54568	475	3.578475	16.99775625	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	53.5	7.05e-5	NR	MCB9800384.1	2035772	g20286	i2	54.8	0.265263157894737	42	19	26.5	0	209	84	468	509	MCB9800384.1 response regulator [Candidatus Omnitrophota bacterium]	diamond	126	53.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
30297363	30297363	PRJNA429937_P_NODE_115532_length_260_cov_1.523810_g92906_i0	PRJNA429937	115532	260	1.52381	3.961906	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	112	1.32e-26	NR	HAM40605.1	2035772	g92906	i0	67.4	0.992307692307692	86	25	99.2	1	260	3	208	290	HAM40605.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	258	112	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
30360518	30360518	PRJNA429937_P_NODE_116332_length_258_cov_1.257642_g93706_i0	PRJNA429937	116332	258	1.257642	3.24471636	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	65.5	4.5e-10	NR	HAM40605.1	2035772	g93706	i0	75	0.465116279069767	40	10	46.5	0	258	139	208	247	HAM40605.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	120	65.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
30392144	30392144	PRJNA429937_P_NODE_32993_length_632_cov_3.174129_g20286_i0	PRJNA429937	32993	632	3.174129	20.06049528	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	53.9	1.69e-4	NR	MCB9800384.1	2035772	g20286	i0	54.8	0.199367088607595	42	19	19.9	0	132	7	468	509	MCB9800384.1 response regulator [Candidatus Omnitrophota bacterium]	diamond	126	53.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
31592914	31592914	PRJNA429937_P_NODE_50796_length_496_cov_3.704497_g33280_i0	PRJNA429937	50796	496	3.704497	18.37430512	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	53.9	2.82e-6	NR	MBN3040005.1	2035772	g33280	i0	31.6	0.913306451612903	79	51	47.8	2	310	74	3	78	MBN3040005.1 acyl carrier protein [Candidatus Omnitrophota bacterium]	diamond	453	53.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
32730972	32730972	PRJNA429937_P_NODE_55140_length_472_cov_3.494357_g20286_i3	PRJNA429937	55140	472	3.494357	16.49336504	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	53.9	5.19e-5	NR	MCB9800384.1	2035772	g20286	i3	54.8	0.266949152542373	42	19	26.7	0	132	7	468	509	MCB9800384.1 response regulator [Candidatus Omnitrophota bacterium]	diamond	126	53.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota 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);;