metadata: contig_metadata: 5 rows where bioproject = "PRJNA564013" and tax

5 rows where bioproject = "PRJNA564013" 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
23501186	23501186	PRJNA564013_P_NODE_200039_length_306_cov_4.085714_g197188_i0	PRJNA564013	200039	306	4.085714	12.50228484	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	105	9.81e-27	NR	MBU1061198.1	2035772	g197188	i0	57.8	2.44117647058824	83	35	81.4	0	297	49	34	116	MBU1061198.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	747	105	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
27616452	27616452	PRJNA564013_P_NODE_271444_length_245_cov_1.336957_g268592_i0	PRJNA564013	271444	245	1.336957	3.27554465	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	104	1.28e-25	NR	MFA5499469.1	2035772	g268592	i0	67.6	0.869387755102041	71	23	86.9	0	23	235	68	138	MFA5499469.1 ERF family protein [Candidatus Omnitrophota bacterium]	diamond	213	104	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
28026901	28026901	PRJNA564013_P_NODE_183505_length_321_cov_16.684615_g180655_i0	PRJNA564013	183505	321	16.684615	53.55761415	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	55.1	6.81e-7	NR	MDD4938679.1	2035772	g180655	i0	81.8	0.925233644859813	33	6	30.8	0	1	99	21	53	MDD4938679.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	297	55.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
29731530	29731530	PRJNA564013_P_NODE_197910_length_308_cov_4.060729_g195059_i0	PRJNA564013	197910	308	4.060729	12.50704532	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	172	5.89e-51	NR	MDP3732272.1	2035772	g195059	i0	91.8	4.72402597402597	97	8	94.5	0	301	11	162	258	MDP3732272.1 methylenetetrahydrofolate reductase [Candidatus Omnitrophota bacterium]	diamond	1455	172	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
30205354	30205354	PRJNA564013_P_NODE_21412_length_799_cov_6.235772_g19101_i0	PRJNA564013	21412	799	6.235772	49.82381828	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	341	3.17e-115	NR	MCM8820210.1	2035772	g19101	i0	71.5	0.908635794743429	242	65	90.9	1	3	728	19	256	MCM8820210.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	726	341	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);;