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

5 rows where bioproject = "PRJNA493244", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"

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_class	tax_species
5558278	5558278	PRJNA493244_P_NODE_1008825_length_403_cov_2.058480_g985730_i0	PRJNA493244	1008825	403	2.05848	8.2956744	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	147	5.48e-38	NR	HEV8720377.1	2838779	g985730	i0	65.5	0.863523573200993	116	40	86.4	0	1	348	2101	2216	HEV8720377.1 amino acid adenylation domain-containing protein [Candidatus Binatia bacterium]	diamond	348	147	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
27139293	27139293	PRJNA493244_P_NODE_1698082_length_204_cov_0.895105_g1674957_i0	PRJNA493244	1698082	204	0.895105	1.8260142	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	43.1	0.016	NR	MET0643132.1	2838779	g1674957	i0	33.3	0.926470588235294	63	31	76.5	1	36	191	60	122	MET0643132.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	189	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
27613692	27613692	PRJNA493244_P_NODE_1199984_length_329_cov_1.544776_g1176860_i0	PRJNA493244	1199984	329	1.544776	5.08231304	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	109	2.29e-28	NR	HVN84825.1	2838779	g1176860	i0	64.9	1.43161094224924	77	27	70.2	0	245	15	1	77	HVN84825.1 VOC family protein [Candidatus Binatia bacterium]	diamond	471	109	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
28592416	28592416	PRJNA493244_P_NODE_1415047_length_264_cov_1.891626_g1391922_i0	PRJNA493244	1415047	264	1.891626	4.99389264	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	130	3.6199999999999997e-34	NR	HKA53091.1	2838779	g1391922	i0	74.4	0.886363636363636	78	20	88.6	0	29	262	34	111	HKA53091.1 ISAzo13 family transposase [Candidatus Binatia bacterium]	diamond	234	130	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31973042	31973042	PRJNA493244_P_NODE_938418_length_435_cov_2.155080_g915403_i0	PRJNA493244	938418	435	2.15508	9.374598	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	115	4.82e-28	NR	HEV8726224.1	2838779	g915403	i0	84.4	1.76551724137931	64	10	44.1	0	415	224	267	330	HEV8726224.1 ABC transporter substrate-binding protein [Candidatus Binatia bacterium]	diamond	768	115	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia 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);;