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

5 rows where bioproject = "PRJNA404067", 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
27707691	27707691	PRJNA404067_P_NODE_25384_length_222_cov_1.211180_g24997_i0	PRJNA404067	25384	222	1.21118	2.6888196	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	96.3	5.27e-22	NR	MDO4874040.1	2044595	g24997	i0	97.9	0.635135135135135	47	1	63.5	0	143	3	225	271	MDO4874040.1 amidase domain-containing protein [Candidatus Altimarinota bacterium]	diamond	141	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
27896571	27896571	PRJNA404067_P_NODE_31505_length_209_cov_0.864865_g31118_i0	PRJNA404067	31505	209	0.864865	1.80756785	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	75.5	6.81e-14	NR	MDF2379179.1	2044595	g31118	i0	48.4	0.91866028708134	64	33	91.9	0	208	17	306	369	MDF2379179.1 DCC1-like thiol-disulfide oxidoreductase family protein [Candidatus Altimarinota bacterium]	diamond	192	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
28906837	28906837	PRJNA404067_P_NODE_31868_length_208_cov_1.367347_g31481_i0	PRJNA404067	31868	208	1.367347	2.84408176	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	89.4	8.29e-19	NR	MCF7843868.1	2044595	g31481	i0	52.9	1.96153846153846	68	32	98.1	0	5	208	359	426	MCF7843868.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	408	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
30106927	30106927	PRJNA404067_P_NODE_42572_length_185_cov_7.161290_g42185_i0	PRJNA404067	42572	185	7.16129	13.2483865	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	97.1	4.14e-23	NR	NRH21400.1	2044595	g42185	i0	88.1	0.956756756756757	59	7	95.7	0	184	8	163	221	NRH21400.1 30S ribosomal protein S5 [Candidatus Altimarinota bacterium]	diamond	177	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
31371239	31371239	PRJNA404067_P_NODE_36636_length_203_cov_0.901408_g36249_i0	PRJNA404067	36636	203	0.901408	1.82985824	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	79.3	2.68e-15	NR	MCF7843864.1	2044595	g36249	i0	66.2	0.960591133004926	65	17	88.7	1	182	3	256	320	MCF7843864.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	195	79.3	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);;