metadata: contig_metadata: 5 rows where bioproject = "PRJNA594101", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA594101", 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
27616961	27616961	PRJNA594101_S_NODE_28084_length_321_cov_1.774194_g27782_i0	PRJNA594101	28084	321	1.774194	5.69516274	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	58.5	3.04e-8	NR	MFH1857097.1	2035772	g27782	i0	35.2	0.663551401869159	71	46	66.4	0	12	224	49	119	MFH1857097.1 ribonuclease HI family protein [Candidatus Omnitrophota bacterium]	diamond	213	58.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
28248128	28248128	PRJNA594101_S_NODE_22446_length_355_cov_2.219858_g22144_i0	PRJNA594101	22446	355	2.219858	7.8804959	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	90.9	2.31e-19	NR	MFH2067961.1	2035772	g22144	i0	39.5	1.0056338028169	119	65	99.7	3	355	2	117	229	MFH2067961.1 class I SAM-dependent methyltransferase [Candidatus Omnitrophota bacterium]	diamond	357	90.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
31122040	31122040	PRJNA594101_S_NODE_30555_length_310_cov_1.299578_g30253_i0	PRJNA594101	30555	310	1.299578	4.0286918	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	46.2	0.0051	NR	MEA3306061.1	2035772	g30253	i0	47.2	0.512903225806452	53	27	50.3	1	201	46	788	840	MEA3306061.1 UvrD-helicase domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	159	46.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
31944551	31944551	PRJNA594101_S_NODE_51377_length_248_cov_0.880000_g51075_i0	PRJNA594101	51377	248	0.88	2.1824	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.4	0.00111	NR	MDD5618411.1	2035772	g51075	i0	37.8	2.6491935483871	74	46	89.5	0	238	17	5	78	MDD5618411.1 50S ribosomal protein L22 [Candidatus Omnitrophota bacterium]	diamond	657	45.4	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Omnitrophota bacterium
32229693	32229693	PRJNA594101_S_NODE_53818_length_245_cov_0.959302_g53516_i0	PRJNA594101	53818	245	0.959302	2.3502899	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	68.2	4.16e-11	NR	MSR77164.1	2035772	g53516	i0	79.5	1.43265306122449	39	8	47.8	0	49	165	108	146	MSR77164.1 translational GTPase TypA [Candidatus Omnitrophota bacterium]	diamond	351	68.2	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);;