metadata: contig_metadata: 5 rows where bioproject = "PRJNA924320", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA924320", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"

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_phylum	tax_species
8552341	8552341	PRJNA924320_S_NODE_53987_length_163_cov_0.894737_g53845_i0	PRJNA924320	53987	163	0.894737	1.45842131	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621704339\|emb\|OY760935.1\|	2044595	g53845	i0	100	0.171779141104294	28	0	17	0	121	148	729133	729106	MAG: Candidatus Gracilibacteria bacterium isolate 3c0776cb-dd52-49a3-965b-30fb91b92491 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
26771516	26771516	PRJNA924320_S_NODE_4761_length_433_cov_1.726562_g4620_i0	PRJNA924320	4761	433	1.726562	7.47601346	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	70.5	4.3e-11	NR	MCP4523361.1	2044595	g4620	i0	30.1	0.921478060046189	133	88	92.1	2	29	427	113	240	MCP4523361.1 ion transporter [Candidatus Altimarinota bacterium]	diamond	399	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
27182533	27182533	PRJNA924320_S_NODE_30382_length_198_cov_1.026846_g30240_i0	PRJNA924320	30382	198	1.026846	2.03315508	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	61.6	4.27e-9	NR	MBX9809319.1	2044595	g30240	i0	61.7	0.712121212121212	47	18	71.2	0	196	56	344	390	MBX9809319.1 fatty acid desaturase [Candidatus Altimarinota bacterium]	diamond	141	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
27277688	27277688	PRJNA924320_S_NODE_39843_length_177_cov_3.414062_g39701_i0	PRJNA924320	39843	177	3.414062	6.04288974	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	54.7	7.88e-7	NR	MBX9809727.1	2044595	g39701	i0	67.3	0.932203389830508	55	18	93.2	0	11	175	9	63	MBX9809727.1 CAP domain-containing protein [Candidatus Altimarinota bacterium]	diamond	165	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31510192	31510192	PRJNA924320_S_NODE_37356_length_182_cov_1.917293_g37214_i0	PRJNA924320	37356	182	1.917293	3.48947326	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	48.9	1.08e-4	NR	MBX9809131.1	2044595	g37214	i0	73.3	1.48351648351648	30	8	49.5	0	3	92	281	310	MBX9809131.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	270	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota 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);;