metadata: contig_metadata: 6 rows where bioproject = "PRJNA982106", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA982106", 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
6375182	6375182	PRJNA982106_P_NODE_31565_length_242_cov_0.911243_g31325_i0	PRJNA982106	31565	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	146	4.62e-41	NR	MBF8288445.1	2053607	g31325	i0	91.3	1.98347107438017	80	7	99.2	0	240	1	133	212	MBF8288445.1 tRNA pseudouridine synthase B [Candidatus Rokuibacteriota bacterium]	diamond	480	147	0.993197278911565	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
7341787	7341787	PRJNA982106_P_NODE_31686_length_242_cov_0.911243_g31446_i0	PRJNA982106	31686	242	0.911243	2.20520806	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	167	3.7400000000000004e-49	NR	PYN12084.1	2053607	g31446	i0	96.3	0.991735537190083	80	3	99.2	0	1	240	217	296	PYN12084.1 MAG: hypothetical protein DME05_22580 [Candidatus Rokuibacteriota bacterium]	diamond	240	167	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
12750363	12750363	PRJNA982106_P_NODE_29770_length_243_cov_0.905882_g29530_i0	PRJNA982106	29770	243	0.905882	2.20129326	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	154	6.0799999999999986e-43	NR	PYN72127.1	2053607	g29530	i0	95	1.97530864197531	80	4	98.8	0	241	2	264	343	PYN72127.1 MAG: nitrilotriacetate monooxygenase [Candidatus Rokuibacteriota bacterium]	diamond	480	154	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
30405896	30405896	PRJNA982106_P_NODE_15453_length_282_cov_1.019139_g15213_i0	PRJNA982106	15453	282	1.019139	2.87397198	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	182	5.609999999999999e-54	NR	PYM25423.1	2053607	g15213	i0	93.6	1	94	6	100	0	282	1	164	257	PYM25423.1 MAG: ABC transporter substrate-binding protein [Candidatus Rokuibacteriota bacterium]	diamond	282	182	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
30911147	30911147	PRJNA982106_P_NODE_29434_length_243_cov_1.811765_g29194_i0	PRJNA982106	29434	243	1.811765	4.40258895	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	43.9	0.0137	NR	PYO01087.1	2053607	g29194	i0	40.8	0.876543209876543	71	31	76.5	3	21	206	110	178	PYO01087.1 MAG: phosphotransferase family protein, partial [Candidatus Rokuibacteriota bacterium]	diamond	213	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
32112787	32112787	PRJNA982106_P_NODE_28778_length_244_cov_0.900585_g28538_i0	PRJNA982106	28778	244	0.900585	2.1974274	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	115	5.58e-29	NR	PYN30401.1	2053607	g28538	i0	74.4	2.01639344262295	82	20	99.6	1	243	1	14	95	PYN30401.1 MAG: DUF2950 domain-containing protein [Candidatus Rokuibacteriota bacterium]	diamond	492	115	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);;