metadata: contig_metadata: 9 rows where bioproject = "PRJNA529241" and tax

9 rows where bioproject = "PRJNA529241" 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_genus	tax_species
500380	500380	PRJNA529241_P_NODE_358781_length_173_cov_2.779412_g356459_i0	PRJNA529241	358781	173	2.779412	4.80838276	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	97.1	6.62e-16	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g356459	i0	89.474	5.5606936416185	76	8	44	0	98	173	3078562	3078487	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	962	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
18353361	18353361	PRJNA529241_P_NODE_549595_length_151_cov_2.833333_g547273_i0	PRJNA529241	549595	151	2.833333	4.27833283	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	119	1.2e-22	NTclustered	gi\|2893356064\|emb\|OZ220487.1\|	3036252	g547273	i0	94.737	1.49668874172185	76	4	100	0	1	76	3155780	3155855	MAG: uncultured Candidatus Binatia bacterium isolate d2d8104a-f810-4fb4-bb0c-dc82b69497ba genome assembly, chromosome: 1	blastn	226	119	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
19628381	19628381	PRJNA529241_P_NODE_68196_length_255_cov_3.486239_g65874_i0	PRJNA529241	68196	255	3.486239	8.88990945	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	104	3.36e-24	NR	HSR58777.1	2785449	g65874	i0	45.1	3.6	153	16	100	1	255	1	117	269	HSR58777.1 IS3 family transposase [Candidatus Binataceae bacterium]	diamond	918	104	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
22176938	22176938	PRJNA529241_P_NODE_350938_length_173_cov_2.852941_g348616_i0	PRJNA529241	350938	173	2.852941	4.93558793	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	84.2	5.15e-12	NTclustered	gi\|2518556404\|emb\|OX638375.1\|	2838779	g348616	i0	96.078	1.38150289017341	51	2	29	0	107	157	1380916	1380966	MAG: Candidatus Binatia bacterium isolate 97b5e0c7-6798-4f16-949c-9b63468df6e4 genome assembly, chromosome: 1	blastn	239	84.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27108959	27108959	PRJNA529241_P_NODE_542842_length_151_cov_3.131579_g540520_i0	PRJNA529241	542842	151	3.131579	4.72868429	Candidatus Binatus sp.	2811406	Bacteria	Bacteria	56.6	1.25e-7	NR	HYL41425.1	2811406	g540520	i0	82.4	0.675496688741722	34	3	61.6	1	150	58	261	294	HYL41425.1 molybdopterin cofactor-binding domain-containing protein [Candidatus Binatus sp.]	diamond	102	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae	Candidatus Binatus	Candidatus Binatus sp.
27582879	27582879	PRJNA529241_P_NODE_195404_length_173_cov_6.566176_g193082_i0	PRJNA529241	195404	173	6.566176	11.35948448	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	52	7.68e-6	NR	MFN2427512.1	2838779	g193082	i0	92	1.69942196531792	25	2	43.4	0	2	76	319	343	MFN2427512.1 NAD(P)H-dependent flavin oxidoreductase [Candidatus Binatia bacterium]	diamond	294	52	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30582767	30582767	PRJNA529241_P_NODE_290673_length_173_cov_3.683824_g288351_i0	PRJNA529241	290673	173	3.683824	6.37301552	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	42.4	0.0199	NR	HZD11726.1	2838779	g288351	i0	76	0.433526011560694	25	6	43.4	0	172	98	273	297	HZD11726.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	75	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31088593	31088593	PRJNA529241_P_NODE_550615_length_151_cov_2.710526_g548293_i0	PRJNA529241	550615	151	2.710526	4.09289426	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	44.7	0.00223	NR	HEX5019871.1	2838779	g548293	i0	72	0.496688741721854	25	7	49.7	0	76	2	45	69	HEX5019871.1 D-2-hydroxyacid dehydrogenase [Candidatus Binatia bacterium]	diamond	75	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31721052	31721052	PRJNA529241_P_NODE_585377_length_150_cov_3.070796_g583055_i0	PRJNA529241	585377	150	3.070796	4.606194	Candidatus Binatota bacterium	2528255	Bacteria	Bacteria	49.7	3.63e-5	NR	MDP9131110.1	2528255	g583055	i0	84	2	25	4	50	0	2	76	365	389	MDP9131110.1 IS110 family transposase [Candidatus Binatota bacterium]	diamond	300	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota					Candidatus Binatota 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);;