metadata: contig_metadata: 7 rows where bioproject = "PRJNA429937", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA429937", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"

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
27423609	27423609	PRJNA429937_P_NODE_20583_length_811_cov_3.531969_g4249_i3	PRJNA429937	20583	811	3.531969	28.64426859	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	60.8	1.51e-6	NR	PYM23558.1	2053607	g4249	i3	30.3	0.658446362515413	178	99	58.1	6	23	493	214	387	PYM23558.1 MAG: hypothetical protein DMD78_11570 [Candidatus Rokuibacteriota bacterium]	diamond	534	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
28086297	28086297	PRJNA429937_P_NODE_24725_length_738_cov_3.706629_g4249_i5	PRJNA429937	24725	738	3.706629	27.35492202	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	61.2	8.02e-7	NR	PYM23558.1	2053607	g4249	i5	30.3	0.723577235772358	178	99	63.8	6	702	232	214	387	PYM23558.1 MAG: hypothetical protein DMD78_11570 [Candidatus Rokuibacteriota bacterium]	diamond	534	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
28117882	28117882	PRJNA429937_P_NODE_17765_length_873_cov_3.481043_g4249_i1	PRJNA429937	17765	873	3.481043	30.38950539	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	60.8	1.92e-6	NR	PYM23558.1	2053607	g4249	i1	30.3	0.611683848797251	178	99	54	6	23	493	214	387	PYM23558.1 MAG: hypothetical protein DMD78_11570 [Candidatus Rokuibacteriota bacterium]	diamond	534	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
28560178	28560178	PRJNA429937_P_NODE_82547_length_358_cov_1.793313_g60074_i0	PRJNA429937	82547	358	1.793313	6.42006054	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	118	8.39e-31	NR	MET0487660.1	2053607	g60074	i0	75.9	0.695530726256983	83	7	58.7	1	147	356	14	96	MET0487660.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	249	118	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29475373	29475373	PRJNA429937_P_NODE_7190_length_1315_cov_2.612753_g4249_i0	PRJNA429937	7190	1315	2.612753	34.35770195	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	61.6	3.09e-6	NR	PYM23558.1	2053607	g4249	i0	30.3	0.406083650190114	178	99	35.8	6	614	1084	214	387	PYM23558.1 MAG: hypothetical protein DMD78_11570 [Candidatus Rokuibacteriota bacterium]	diamond	534	61.6	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29980962	29980962	PRJNA429937_P_NODE_19971_length_823_cov_3.445844_g4249_i2	PRJNA429937	19971	823	3.445844	28.35929612	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	61.2	1.19e-6	NR	PYM23558.1	2053607	g4249	i2	30.3	0.648845686512758	178	99	57.2	6	122	592	214	387	PYM23558.1 MAG: hypothetical protein DMD78_11570 [Candidatus Rokuibacteriota bacterium]	diamond	534	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
32225542	32225542	PRJNA429937_P_NODE_23358_length_760_cov_3.603283_g4249_i4	PRJNA429937	23358	760	3.603283	27.3849508	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	61.2	8.91e-7	NR	PYM23558.1	2053607	g4249	i4	30.3	0.702631578947368	178	99	62	6	702	232	214	387	PYM23558.1 MAG: hypothetical protein DMD78_11570 [Candidatus Rokuibacteriota bacterium]	diamond	534	61.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota 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);;