metadata: contig_metadata: 6 rows where bioproject = "PRJNA611476", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA611476", 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_order	tax_family	tax_species
13343492	13343492	PRJNA611476_P_NODE_35171_length_354_cov_0.818505_g34380_i0	PRJNA611476	35171	354	0.818505	2.8975077	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	143	7.23e-38	NR	HUA35362.1	2785449	g34380	i0	53.8	4.96610169491525	117	54	99.2	0	354	4	87	203	HUA35362.1 aldehyde dehydrogenase family protein [Candidatus Binataceae bacterium]	diamond	1758	143	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
27491087	27491087	PRJNA611476_P_NODE_60743_length_284_cov_0.857820_g59952_i0	PRJNA611476	60743	284	0.85782	2.4362088	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	79	5.95e-15	NR	HEV8711969.1	2838779	g59952	i0	66.7	0.602112676056338	57	19	60.2	0	1	171	273	329	HEV8711969.1 tyrosine-type recombinase/integrase [Candidatus Binatia bacterium]	diamond	171	79	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
28975051	28975051	PRJNA611476_P_NODE_18968_length_456_cov_1.148825_g18178_i0	PRJNA611476	18968	456	1.148825	5.238642	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	48.1	0.00397	NR	HMJ66572.1	2838779	g18178	i0	38.2	0.5	76	46	49.3	1	60	284	270	345	HMJ66572.1 trypsin-like peptidase domain-containing protein [Candidatus Binatia bacterium]	diamond	228	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
29416872	29416872	PRJNA611476_P_NODE_76869_length_253_cov_1.427778_g76078_i0	PRJNA611476	76869	253	1.427778	3.61227834	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	42.4	0.0359	NR	MCX8073175.1	2838779	g76078	i0	38.5	0.770750988142292	65	34	70	1	190	14	50	114	MCX8073175.1 CvpA family protein [Candidatus Binatia bacterium]	diamond	195	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia			Candidatus Binatia bacterium
31344270	31344270	PRJNA611476_P_NODE_91116_length_248_cov_0.880000_g90325_i0	PRJNA611476	91116	248	0.88	2.1824	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	43.1	0.0292	NR	HLK87794.1	2785449	g90325	i0	35.1	0.689516129032258	57	33	69	1	52	222	454	506	HLK87794.1 glycoside hydrolase family 15 protein [Candidatus Binataceae bacterium]	diamond	171	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binataceae bacterium
31723651	31723651	PRJNA611476_P_NODE_48097_length_313_cov_1.254167_g47306_i0	PRJNA611476	48097	313	1.254167	3.92554271	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	103	6.37e-24	NR	MCK6555919.1	2838779	g47306	i0	59.6	0.94888178913738	99	39	94.9	1	304	8	117	214	MCK6555919.1 NADPH:quinone reductase [Candidatus Binatia bacterium]	diamond	297	103	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);;