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

5 rows where bioproject = "PRJNA379145", tax_clade = "Bacteria candidate phyla" 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
27612106	27612106	PRJNA379145_P_NODE_13444_length_793_cov_2.828947_g9833_i1	PRJNA379145	13444	793	2.828947	22.43354971	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	273	1.0699999999999996e-87	NR	MCK4764035.1	2052149	g9833	i1	56.7	1.04035308953342	275	83	91.9	4	2	730	54	324	MCK4764035.1 cysteine synthase family protein [Candidatus Aminicenantes bacterium]	diamond	825	273	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
27927826	27927826	PRJNA379145_P_NODE_51685_length_224_cov_2.418848_g49531_i0	PRJNA379145	51685	224	2.418848	5.41821952	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	55.8	6.8e-7	NR	MBN1224544.1	2052149	g49531	i0	56.1	0.977678571428571	41	18	54.9	0	91	213	11	51	MBN1224544.1 MFS transporter [Candidatus Aminicenantes bacterium]	diamond	219	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
30548826	30548826	PRJNA379145_P_NODE_35293_length_349_cov_2.094937_g33147_i0	PRJNA379145	35293	349	2.094937	7.31133013	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	65.1	1.6e-9	NR	UCH94282.1	2052149	g33147	i0	46.2	1.09169054441261	65	35	55.9	0	346	152	218	282	UCH94282.1 MAG: 6-bladed beta-propeller [Candidatus Aminicenantes bacterium]	diamond	381	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
31560511	31560511	PRJNA379145_P_NODE_32976_length_376_cov_2.399417_g30835_i0	PRJNA379145	32976	376	2.399417	9.02180792	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	99	5.92e-22	NR	MCK4764035.1	2052149	g30835	i0	43.4	5.13829787234043	136	42	83	3	2	313	192	324	MCK4764035.1 cysteine synthase family protein [Candidatus Aminicenantes bacterium]	diamond	1932	99	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
32066322	32066322	PRJNA379145_P_NODE_11098_length_897_cov_2.712963_g9833_i0	PRJNA379145	11098	897	2.712963	24.33527811	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	283	4.2900000000000003e-91	NR	MCK4764035.1	2052149	g9833	i0	64.6	0.792642140468227	237	80	79.3	3	896	186	54	286	MCK4764035.1 cysteine synthase family protein [Candidatus Aminicenantes bacterium]	diamond	711	283	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);;