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

5 rows where bioproject = "PRJNA615351" and tax_phylum = "Candidatus Zixiibacteriota"

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
27017052	27017052	PRJNA615351_P_NODE_152622_length_186_cov_1.854305_g138522_i0	PRJNA615351	152622	186	1.854305	3.4490073	Candidatus Zixiibacteriota bacterium	2053527	Bacteria	Bacteria	41.6	0.0421	NR	HEX9917405.1	2053527	g138522	i0	41.7	0.774193548387097	48	26	74.2	1	5	142	134	181	HEX9917405.1 PEP-CTERM sorting domain-containing protein [Candidatus Zixiibacteriota bacterium]	diamond	144	41.6	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota	Candidatus Zixiibacteriota bacterium
27933327	27933327	PRJNA615351_P_NODE_65585_length_541_cov_2.031621_g51925_i0	PRJNA615351	65585	541	2.031621	10.99106961	Candidatus Zixiibacteriota bacterium	2053527	Bacteria	Bacteria	47.4	0.0125	NR	MCK4386252.1	2053527	g51925	i0	36.6	0.393715341959335	71	44	39.4	1	434	222	287	356	MCK4386252.1 hypothetical protein [Candidatus Zixiibacteriota bacterium]	diamond	213	47.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota	Candidatus Zixiibacteriota bacterium
28848804	28848804	PRJNA615351_P_NODE_82008_length_412_cov_5.230769_g67959_i0	PRJNA615351	82008	412	5.230769	21.55076828	Candidatus Zixiibacteriota bacterium	2053527	Bacteria	Bacteria	159	2.7199999999999994e-42	NR	MDD4050449.1	2053527	g67959	i0	56.3	0.983009708737864	135	50	93.9	3	410	24	316	447	MDD4050449.1 trypsin-like peptidase domain-containing protein [Candidatus Zixiibacteriota bacterium]	diamond	405	159	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota	Candidatus Zixiibacteriota bacterium
29177697	29177697	PRJNA615351_P_NODE_184389_length_152_cov_1.709402_g170289_i0	PRJNA615351	184389	152	1.709402	2.59829104	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	3.54e-13	NR	MDP3024715.1	2053527	g170289	i0	89.2	6.51315789473684	37	4	73	0	151	41	394	430	MDP3024715.1 citrate (Si)-synthase, eukaryotic [Candidatus Zixiibacteriota bacterium]	diamond	990	72.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota	Candidatus Zixiibacteriota bacterium
32905779	32905779	PRJNA615351_P_NODE_38760_length_924_cov_6.000000_g28737_i0	PRJNA615351	38760	924	6	55.44	FCB group	1783270	Bacteria	Bacteria	125	1.84e-30	NR	MCI0531590.1	2053527	g28737	i0	31.3	2.22077922077922	230	147	74	4	81	764	4	224	MCI0531590.1 MIP family channel protein [Candidatus Zixiibacteriota bacterium]	diamond	2052	125	1	Bacteria	FCB group	Pseudomonadati	Candidatus Zixiibacteriota	Candidatus Zixiibacteriota 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);;