metadata: contig_metadata: 7 rows where bioproject = "PRJNA385073" and tax

7 rows where bioproject = "PRJNA385073" 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
5509328	5509328	PRJNA385073_P_NODE_21225_length_312_cov_1.288703_g21063_i0	PRJNA385073	21225	312	1.288703	4.02075336	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	289	2.04e-73	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g21063	i0	83.648	262.211538461538	318	40	100	8	1	312	2239525	2239214	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	81810	289	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
11884763	11884763	PRJNA385073_P_NODE_39970_length_253_cov_9.472222_g39808_i0	PRJNA385073	39970	253	9.472222	23.96472166	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	292	1.24e-74	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g39808	i0	88.477	241.501976284585	243	27	96	1	3	245	597131	596890	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	61100	292	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
13829651	13829651	PRJNA385073_P_NODE_30311_length_278_cov_1.502439_g30149_i0	PRJNA385073	30311	278	1.502439	4.17678042	Bacteria	2	Bacteria	Bacteria	300	8.280000000000001e-77	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g30149	i0	88.142	123.503597122302	253	28	91	2	1	252	3395685	3395434	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	34334	300	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
16983654	16983654	PRJNA385073_P_NODE_49634_length_246_cov_0.890173_g49472_i0	PRJNA385073	49634	246	0.890173	2.18982558	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	73.2	2.56e-13	NR	HEV7734552.1	2838779	g49472	i0	79.5	0.536585365853659	44	9	53.7	0	132	1	1	44	HEV7734552.1 crotonase/enoyl-CoA hydratase family protein [Candidatus Binatia bacterium]	diamond	132	73.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
29538233	29538233	PRJNA385073_P_NODE_61930_length_230_cov_2.146497_g61768_i0	PRJNA385073	61930	230	2.146497	4.9369431	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	113	1.43e-27	NR	HJY83707.1	2838779	g61768	i0	81.7	0.782608695652174	60	11	78.3	0	1	180	239	298	HJY83707.1 group II intron reverse transcriptase/maturase [Candidatus Binatia bacterium]	diamond	180	113	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31371005	31371005	PRJNA385073_P_NODE_32936_length_271_cov_1.282828_g32774_i0	PRJNA385073	32936	271	1.282828	3.47646388	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	119	8.160000000000001e-29	NR	MFN8643327.1	2838779	g32774	i0	63.4	0.907749077490775	82	30	90.8	0	6	251	686	767	MFN8643327.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	246	119	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31497470	31497470	PRJNA385073_P_NODE_42356_length_251_cov_0.865169_g42194_i0	PRJNA385073	42356	251	0.865169	2.17157419	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	79	6.89e-15	NR	HEX2230455.1	2838779	g42194	i0	38.1	1.00398406374502	84	50	99.2	2	250	2	332	414	HEX2230455.1 carotenoid oxygenase family protein [Candidatus Binatia bacterium]	diamond	252	79	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);;