metadata: contig_metadata: 4 rows where bioproject = "PRJNA1067370", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA1067370", tax_clade = "FCB group" and tax_phylum = "Candidatus Kapaibacteriota"

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_class	tax_order	tax_family	tax_genus	tax_species
5283758	5283758	PRJNA1067370_P_NODE_55885_length_286_cov_1.413146_g55336_i0	PRJNA1067370	55885	286	1.413146	4.04159756	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2907625638\|emb\|OZ223198.1\|	2447898	g55336	i0	100	0.101398601398601	29	0	10	0	256	284	1078636	1078608	MAG: Candidatus Kapaibacterium sp. isolate 09316a08-0405-4927-8c64-54324f316411 genome assembly, chromosome: 2	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
21857777	21857777	PRJNA1067370_P_NODE_57598_length_283_cov_2.452381_g57049_i0	PRJNA1067370	57598	283	2.452381	6.94023823	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	276	1.4199999999999999e-69	NTclustered	gi\|1869359902\|gb\|CP058732.1\|	2447898	g57049	i0	89.189	428.802120141343	222	23	78	1	63	283	421844	422065	MAG: Candidatus Kapaibacterium sp. isolate Ch6 chromosome, complete genome	blastn	121351	276	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
30952047	30952047	PRJNA1067370_P_NODE_28254_length_364_cov_1.058419_g27706_i0	PRJNA1067370	28254	364	1.058419	3.85264516	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	64.7	2.84e-9	NR	HYE59772.1	2447898	g27706	i0	47.7	1.06318681318681	65	29	52.7	2	72	263	403	463	HYE59772.1 PQQ-dependent sugar dehydrogenase [Candidatus Kapaibacterium sp.]	diamond	387	64.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
32659109	32659109	PRJNA1067370_P_NODE_109180_length_242_cov_1.822485_g108631_i0	PRJNA1067370	109180	242	1.822485	4.4104137	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	42.7	0.0344	NR	MBP7214623.1	2447898	g108631	i0	34.5	0.71900826446281	58	38	71.9	0	16	189	166	223	MBP7214623.1 Hsp33 family molecular chaperone HslO [Candidatus Kapaibacterium sp.]	diamond	174	42.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.

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