metadata: contig_metadata: 2 rows where bioproject = "PRJNA404067" and tax_phylum = "Candidatus Campbelliibacteriota"

2 rows where bioproject = "PRJNA404067" and tax_phylum = "Candidatus Campbelliibacteriota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	lowcoverage_flag	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_class	tax_order	tax_family	tax_genus	tax_species
19540229	19540229	PRJNA404067_P_NODE_16976_length_252_cov_5.225131_g16589_i0	PRJNA404067	16976	252	5.225131	13.16733012	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	427	3.2499999999999993e-115		NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g16589	i0	97.222	1	252	7	100	0	1	252	63682	63431	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	252	427	1	Bacteria	Bacteria candidate phyla		Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium
32368676	32368676	PRJNA404067_P_NODE_15979_length_259_cov_6.813131_g15592_i0	PRJNA404067	15979	259	6.813131	17.64600929	Bacteria	2	Bacteria	Bacteria	105	2.65e-24		NR	PIP86889.1	1974529	g15592	i0	60.5	7.37837837837838	81	32	93.8	0	11	253	18	98	PIP86889.1 MAG: hypothetical protein COW81_03195 [Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13]	diamond	1911	105	1	Bacteria	Bacteria candidate phyla		Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium CG22_combo_CG10-13_8_21_14_all_36_13

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);;