metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Candidatus Anderseniibacteriota"

5 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Candidatus Anderseniibacteriota"

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
32983578	32983578	PRJNA1233465b_S_NODE_195003_length_211_cov_3.018519_g193318_i0	PRJNA1233465	195003	211	3.018519	6.36907509	Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_12_FULL_45_11b	1797282	Bacteria	Bacteria	108	2.26e-25	NR	OGY36934.1	1797282	g193318	i0	66.7	0.938388625592417	66	21	93.8	1	198	1	436	500	OGY36934.1 MAG: hypothetical protein A3E36_04575 [Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_12_FULL_45_11b]	diamond	198	108	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota	Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_12_FULL_45_11b
32999697	32999697	PRJNA1233465a_S_NODE_111019_length_220_cov_1.198830_g109745_i0	PRJNA1233465	111019	220	1.19883	2.637426	Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_	1797278	Bacteria	Bacteria	113	8.47e-31	NR	OGY30717.1	1797278	g109745	i0	71.2	0.995454545454545	73	21	99.5	0	219	1	5	77	OGY30717.1 MAG: hypothetical protein A2805_03345 [Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_01_FULL_46_36]	diamond	219	113	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota	Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_01_FULL_46_36
33017103	33017103	PRJNA1233465a_S_NODE_211652_length_169_cov_1.475000_g210378_i0	PRJNA1233465	211652	169	1.475	2.49275	Candidatus Anderseniibacteriota bacterium	2053502	Bacteria	Bacteria	61.6	3e-9	NR	MCE9643342.1	2053502	g210378	i0	79.5	0.692307692307692	39	8	69.2	0	53	169	1	39	MCE9643342.1 hypothetical protein [Candidatus Andersenbacteria bacterium]	diamond	117	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota	Candidatus Anderseniibacteriota bacterium
33052953	33052953	PRJNA1233465e_S_NODE_37805_length_290_cov_1.041494_g36495_i0	PRJNA1233465	37805	290	1.041494	3.0203326	Candidatus Anderseniibacteriota bacterium	2053502	Bacteria	Bacteria	80.5	2.09e-15	NR	MCE9642998.1	2053502	g36495	i0	75.5	0.548275862068966	53	13	54.8	0	3	161	300	352	MCE9642998.1 HAMP domain-containing histidine kinase [Candidatus Andersenbacteria bacterium]	diamond	159	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota	Candidatus Anderseniibacteriota bacterium
33120158	33120158	PRJNA1233465b_S_NODE_35799_length_395_cov_5.722543_g34122_i0	PRJNA1233465	35799	395	5.722543	22.60404485	Candidatus Anderseniibacteriota bacterium	2053502	Bacteria	Bacteria	239	6.24e-71	NR	MCE9643212.1	2053502	g34122	i0	88.5	0.994936708860759	131	15	99.5	0	2	394	377	507	MCE9643212.1 penicillin-binding protein [Candidatus Andersenbacteria bacterium]	diamond	393	239	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota	Candidatus Anderseniibacteriota 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);;