metadata: contig_metadata: 8 rows where bioproject = "PRJNA760976" and tax

8 rows where bioproject = "PRJNA760976" 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_order	tax_family	tax_genus	tax_species
2018434	2018434	PRJNA760976_P_NODE_50502_length_247_cov_0.873563_g50181_i0	PRJNA760976	50502	247	0.873563	2.15770061	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	246	9.54e-61	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g50181	i0	85.294	0.963562753036437	238	35	96	0	1	238	624071	623834	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	238	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
16045009	16045009	PRJNA760976_P_NODE_36013_length_283_cov_1.023810_g35692_i0	PRJNA760976	36013	283	1.02381	2.8973823	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2575820324\|emb\|OY730443.1\|	2026781	g35692	i0	100	0.0989399293286219	28	0	10	0	13	40	1031835	1031862	MAG: Candidatus Poribacteria bacterium isolate dbacca32-2332-4c09-a5ad-da9f5ab17b7d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
27084785	27084785	PRJNA760976_P_NODE_37682_length_278_cov_1.390244_g37361_i0	PRJNA760976	37682	278	1.390244	3.86487832	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	42.7	0.0442	NR	MFB6226409.1	3120121	g37361	i0	51.4	0.377697841726619	35	17	37.8	0	219	115	95	129	MFB6226409.1 hypothetical protein [Minisyncoccia bacterium]	diamond	105	42.7	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia				Minisyncoccia bacterium
28758428	28758428	PRJNA760976_P_NODE_53407_length_244_cov_0.859649_g53086_i0	PRJNA760976	53407	244	0.859649	2.09754356	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	137	1.39e-35	NR	MCA0228375.1	2052139	g53086	i0	85	0.983606557377049	80	12	98.4	0	242	3	797	876	MCA0228375.1 SGNH/GDSL hydrolase family protein [Patescibacteria group bacterium]	diamond	240	137	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31411995	31411995	PRJNA760976_P_NODE_36416_length_282_cov_0.894737_g36095_i0	PRJNA760976	36416	282	0.894737	2.52315834	Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_	2030810	Bacteria	Bacteria	77.4	3.89e-14	NR	OGG51404.1	1798483	g36095	i0	39.8	0.936170212765957	88	53	93.6	0	1	264	39	126	OGG51404.1 MAG: hypothetical protein A2704_03485 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36b]	diamond	264	77.4	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36b
32139612	32139612	PRJNA760976_P_NODE_56418_length_241_cov_0.898810_g56097_i0	PRJNA760976	56418	241	0.89881	2.1661321	Candidatus Saccharicenans sp.	2819258	Bacteria	Bacteria	116	2.54e-28	NR	HNS04672.1	2819258	g56097	i0	69.6	4.91701244813278	79	24	98.3	0	237	1	248	326	HNS04672.1 NAD-glutamate dehydrogenase [Candidatus Saccharicenans sp.]	diamond	1185	116	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantia	Candidatus Aminicenantales	Candidatus Saccharicenantaceae	Candidatus Saccharicenans	Candidatus Saccharicenans sp.
32424336	32424336	PRJNA760976_P_NODE_42139_length_265_cov_3.130208_g41818_i0	PRJNA760976	42139	265	3.130208	8.2950512	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	44.7	0.00886	NR	MFH1608868.1	2052139	g41818	i0	42.9	0.713207547169811	63	30	66.8	2	231	55	149	209	MFH1608868.1 hypothetical protein [Patescibacteria group bacterium]	diamond	189	44.7	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32676702	32676702	PRJNA760976_P_NODE_42020_length_266_cov_1.202073_g41699_i0	PRJNA760976	42020	266	1.202073	3.19751418	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	42.7	0.0467	NR	HVN87054.1	2838779	g41699	i0	35.3	0.575187969924812	51	32	57.5	1	188	36	6	55	HVN87054.1 ionic transporter y4hA [Candidatus Binatia bacterium]	diamond	153	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;