metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA594101" and tax_phylum = "Candidatus Roizmaniibacteriota"

5 rows where analysis = "diamond", bioproject = "PRJNA594101" and tax_phylum = "Candidatus Roizmaniibacteriota"

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
29321776	29321776	PRJNA594101_S_NODE_3789_length_821_cov_2.906417_g3534_i0	PRJNA594101	3789	821	2.906417	23.86168357	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	96.7	4.5e-19	NR	MFS8160610.1	2282149	g3534	i0	29.8	1.83434835566382	252	170	90.6	3	816	73	78	326	MFS8160610.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	1506	96.7	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
29700368	29700368	PRJNA594101_S_NODE_45650_length_259_cov_1.150538_g45348_i0	PRJNA594101	45650	259	1.150538	2.97989342	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	67	3.06e-12	NR	MFS8159882.1	2282149	g45348	i0	44	0.868725868725869	75	33	76.4	2	57	254	12	86	MFS8159882.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	225	67	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
30016702	30016702	PRJNA594101_S_NODE_58791_length_229_cov_2.250000_g58489_i0	PRJNA594101	58791	229	2.25	5.1525	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	86.7	1.03e-17	NR	MFS8160018.1	2282149	g58489	i0	50.7	0.982532751091703	75	37	98.3	0	4	228	41	115	MFS8160018.1 ATP-binding protein [Candidatus Roizmanbacteria bacterium]	diamond	225	86.7	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
30142622	30142622	PRJNA594101_S_NODE_50152_length_249_cov_1.750000_g49850_i0	PRJNA594101	50152	249	1.75	4.3575	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	44.3	0.00455	NR	MFS8159408.1	2282149	g49850	i0	73.9	1.3855421686747	23	6	27.7	0	156	224	78	100	MFS8159408.1 lipase ROG1 family protein [Candidatus Roizmanbacteria bacterium]	diamond	345	44.3	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
30427726	30427726	PRJNA594101_S_NODE_15413_length_422_cov_2.779370_g15111_i0	PRJNA594101	15413	422	2.77937	11.7289414	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	44.7	0.0446	NR	MFS8160610.1	2282149	g15111	i0	40.7	0.383886255924171	54	32	38.4	0	419	258	273	326	MFS8160610.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	162	44.7	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria 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);;