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

5 rows where bioproject = "PRJNA1174207", 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
9243360	9243360	PRJNA1174207_P_NODE_19428_length_322_cov_1.116466_g18899_i0	PRJNA1174207	19428	322	1.116466	3.59502052	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	420	7.19e-113	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g18899	i0	90.373	137.965838509317	322	27	99	4	1	320	3738050	3737731	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	44425	420	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
28335403	28335403	PRJNA1174207_P_NODE_35086_length_249_cov_0.875000_g34557_i0	PRJNA1174207	35086	249	0.875	2.17875	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	168	4.7e-51	NR	MBY0278448.1	2838779	g34557	i0	97.6	1	83	2	100	0	1	249	15	97	MBY0278448.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	249	168	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
29156578	29156578	PRJNA1174207_P_NODE_25829_length_282_cov_1.473684_g25300_i0	PRJNA1174207	25829	282	1.473684	4.15578888	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	134	7.420000000000001e-36	NR	HEY2773004.1	2838779	g25300	i0	65.6	5.93617021276596	93	32	98.9	0	280	2	14	106	HEY2773004.1 lysophospholipid acyltransferase family protein [Candidatus Binatia bacterium]	diamond	1674	134	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
29977311	29977311	PRJNA1174207_P_NODE_38311_length_245_cov_0.895349_g37782_i0	PRJNA1174207	38311	245	0.895349	2.19360505	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	139	3.04e-39	NR	MEO6027488.1	2838779	g37782	i0	75	0.979591836734694	80	19	96.7	1	245	9	145	224	MEO6027488.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Binatia bacterium]	diamond	240	139	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31241051	31241051	PRJNA1174207_P_NODE_38815_length_244_cov_1.590643_g38286_i0	PRJNA1174207	38815	244	1.590643	3.88116892	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	167	2.95e-51	NR	MBY0273815.1	2838779	g38286	i0	100	0.995901639344262	81	0	99.6	0	2	244	74	154	MBY0273815.1 3D domain-containing protein [Candidatus Binatia bacterium]	diamond	243	167	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);;