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

6 rows where bioproject = "PRJNA721440", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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_order	tax_species
22387588	22387588	PRJNA721440_S_NODE_418_length_755_cov_4.206799_g339_i0	PRJNA721440	418	755	4.206799	31.76133245	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	414	4.999999999999999e-142	NR	MCL4419852.1	2052139	g339	i0	81.5	0.985430463576159	248	46	98.5	0	2	745	93	340	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	744	414	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
26830636	26830636	PRJNA721440_S_NODE_19081_length_164_cov_0.904348_g18955_i0	PRJNA721440	19081	164	0.904348	1.48313072	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	48.1	1.53e-4	NR	HEX4069003.1	2803731	g18955	i0	48.9	0.823170731707317	45	23	82.3	0	138	4	167	211	HEX4069003.1 hypothetical protein [Candidatus Babeliales bacterium]	diamond	135	48.1	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliales bacterium
27209906	27209906	PRJNA721440_S_NODE_8882_length_213_cov_4.036585_g8756_i0	PRJNA721440	8882	213	4.036585	8.59792605	Candidatus Saccharibacteria bacterium 32-49-12	1970479	Bacteria	Bacteria	93.6	2.55e-22	NR	OYX41100.1	1970479	g8756	i0	69.2	0.915492957746479	65	20	91.5	0	211	17	18	82	OYX41100.1 MAG: hypothetical protein B7Y94_05545, partial [Candidatus Saccharibacteria bacterium 32-49-12]	diamond	195	93.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 32-49-12
27494504	27494504	PRJNA721440_S_NODE_3003_length_328_cov_0.863799_g2877_i0	PRJNA721440	3003	328	0.863799	2.83326072	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	62.8	9.43e-9	NR	MEK7398920.1	2026781	g2877	i0	40.9	0.804878048780488	88	41	80.5	2	64	327	418	494	MEK7398920.1 hypothetical protein [Candidatus Poribacteria bacterium]	diamond	264	62.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria			Candidatus Poribacteria bacterium
29894244	29894244	PRJNA721440_S_NODE_17011_length_169_cov_0.866667_g16885_i0	PRJNA721440	17011	169	0.866667	1.46466723	Candidatus Rifleibacteriota bacterium	2053586	Bacteria	Bacteria	77.8	6.07e-15	NR	MBF0407784.1	2053586	g16885	i0	60.7	1.98816568047337	56	22	99.4	0	169	2	278	333	MBF0407784.1 NADP-dependent isocitrate dehydrogenase [Candidatus Rifleibacteriota bacterium]	diamond	336	77.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota			Candidatus Rifleibacteriota bacterium
32801654	32801654	PRJNA721440_S_NODE_3380_length_310_cov_4.773946_g3254_i0	PRJNA721440	3380	310	4.773946	14.7992326	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	125	6.399999999999999e-31	NR	MCL4419431.1	2052139	g3254	i0	89.7	0.658064516129032	68	6	64.8	1	306	106	520	587	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	204	125	1	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);;