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

7 rows where bioproject = "PRJDB14275" and tax_clade = "Bacteria candidate phyla"

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
27406024	27406024	PRJDB14275_P_NODE_5263_length_215_cov_1.238636_g5204_i0	PRJDB14275	5263	215	1.238636	2.6630674	Bacteria	2	Bacteria	Bacteria	75.1	1.95e-15	NR	OGH16387.1	1798600	g5204	i0	48.4	2.67906976744186	64	33	89.3	0	192	1	12	75	OGH16387.1 MAG: tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Candidatus Levybacteria bacterium RIFCSPHIGHO2_02_FULL_37_10]	diamond	576	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota		Candidatus Levybacteria bacterium RIFCSPHIGHO2_02_FULL_37_10
27538069	27538069	PRJDB14275_P_NODE_7144_length_168_cov_0.945736_g7085_i0	PRJDB14275	7144	168	0.945736	1.58883648	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	62.8	1.17e-9	NR	MBI5117590.1	2026781	g7085	i0	50	1	56	27	98.2	1	1	165	31	86	MBI5117590.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	168	62.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria		Candidatus Poribacteria bacterium
28106188	28106188	PRJDB14275_P_NODE_6045_length_190_cov_2.695364_g5986_i0	PRJDB14275	6045	190	2.695364	5.1211916	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	71.6	1.21e-12	NR	MFA6049709.1	2053589	g5986	i0	59.3	0.931578947368421	59	24	93.2	0	1	177	912	970	MFA6049709.1 LamG domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	177	71.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
28580029	28580029	PRJDB14275_P_NODE_5727_length_199_cov_1.075000_g5668_i0	PRJDB14275	5727	199	1.075	2.13925	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	52.4	3.58e-6	NR	MDE2020638.1	2052139	g5668	i0	51.1	0.678391959798995	45	21	66.3	1	34	165	13	57	MDE2020638.1 hypothetical protein [Patescibacteria group bacterium]	diamond	135	52.4	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
30126943	30126943	PRJDB14275_P_NODE_4652_length_241_cov_1.212871_g4593_i0	PRJDB14275	4652	241	1.212871	2.92301911	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	70.5	5.5e-12	NR	HVF35626.1	2890869	g4593	i0	68.8	1.95435684647303	48	15	59.8	0	146	3	9	56	HVF35626.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Saccharimonadia bacterium]	diamond	471	70.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadia bacterium
31264739	31264739	PRJDB14275_P_NODE_6115_length_189_cov_1.046667_g6056_i0	PRJDB14275	6115	189	1.046667	1.97820063	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	57	1.73e-7	NR	MCR4308382.1	2053521	g6056	i0	66.7	0.80952380952381	51	16	79.4	1	189	40	254	304	MCR4308382.1 phage major capsid protein [Candidatus Berkelbacteria bacterium]	diamond	153	57	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria		Candidatus Berkelbacteria bacterium
31638280	31638280	PRJDB14275_P_NODE_6076_length_190_cov_1.066225_g6017_i0	PRJDB14275	6076	190	1.066225	2.0258275	Paraburkholderia	1822464	Bacteria	Bacteria	54.7	1.13e-6	NR	MDE2144896.1	2052139	g6017	i0	40	2.74736842105263	60	35	93.2	1	10	186	186	245	MDE2144896.1 hypothetical protein [Patescibacteria group bacterium]	diamond	522	55.1	0.992740471869329	Bacteria	Bacteria candidate phyla			Patescibacteria group 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);;