metadata: contig_metadata: 5 rows where bioproject = "PRJNA951810" and tax

5 rows where bioproject = "PRJNA951810" and tax_phylum = "Candidatus Aminicenantota"

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_species
4765422	4765422	PRJNA951810_P_NODE_25724_length_396_cov_7.043344_g25382_i0	PRJNA951810	25724	396	7.043344	27.89164224	Bacteria	2	Bacteria	Bacteria	169	8.469999999999998e-48	NR	MBC7349124.1	2052149	g25382	i0	66.4	18.8560606060606	131	44	99.2	0	2	394	252	382	MBC7349124.1 MFS transporter [Candidatus Aminicenantes bacterium]	diamond	7467	169	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
28352195	28352195	PRJNA951810_P_NODE_74986_length_299_cov_6.995575_g74642_i0	PRJNA951810	74986	299	6.995575	20.91676925	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	65.5	7.55e-10	NR	HCS49338.1	2052149	g74642	i0	36.9	2.25752508361204	111	54	96.3	2	1	288	491	600	HCS49338.1 hypothetical protein [Candidatus Aminicenantes bacterium]	diamond	675	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
28604790	28604790	PRJNA951810_P_NODE_186067_length_224_cov_4.986755_g185722_i0	PRJNA951810	186067	224	4.986755	11.1703312	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	95.1	1.07e-20	NR	HPL13788.1	2052149	g185722	i0	56.9	0.964285714285714	72	31	96.4	0	4	219	737	808	HPL13788.1 TaqI-like C-terminal specificity domain-containing protein [Candidatus Aminicenantes bacterium]	diamond	216	95.1	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
30158309	30158309	PRJNA951810_P_NODE_27132_length_386_cov_3.990415_g26790_i0	PRJNA951810	27132	386	3.990415	15.4030019	Bacteria	2	Bacteria	Bacteria	114	1.61e-26	NR	NOR53482.1	2052149	g26790	i0	69	1.10362694300518	71	22	55.2	0	3	215	293	363	NOR53482.1 family 78 glycoside hydrolase catalytic domain [Candidatus Aminicenantes bacterium]	diamond	426	115	0.991304347826087	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
30411651	30411651	PRJNA951810_P_NODE_131413_length_272_cov_2.663317_g131068_i0	PRJNA951810	131413	272	2.663317	7.24422224	Bacteria	2	Bacteria	Bacteria	52.8	1.09e-5	NR	MCX6559066.1	2052149	g131068	i0	41.9	5.53676470588235	62	35	68.4	1	86	271	26	86	MCX6559066.1 lysophospholipid acyltransferase family protein [Candidatus Aminicenantes bacterium]	diamond	1506	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes 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);;