metadata: contig_metadata: 11 rows where bioproject = "PRJNA495391" and tax

11 rows where bioproject = "PRJNA495391" 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
477249	477249	PRJNA495391_S_NODE_69181_length_152_cov_1.230769_g68129_i0	PRJNA495391	69181	152	1.230769	1.87076888	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	104	3.38e-18	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g68129	i0	81.203	0.875	133	22	86	3	22	152	1116298	1116167	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	133	104	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota					Candidatus Delongbacteria bacterium
20878568	20878568	PRJNA495391_S_NODE_49457_length_176_cov_1.127660_g48405_i0	PRJNA495391	49457	176	1.12766	1.9846816	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	193	8.39e-45	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g48405	i0	86.364	1	176	24	100	0	1	176	678061	677886	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	176	193	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
27266657	27266657	PRJNA495391_S_NODE_60643_length_160_cov_2.536000_g59591_i0	PRJNA495391	60643	160	2.536	4.0576	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42.4	0.0169	NR	MEX2043371.1	2052139	g59591	i0	50	2.15625	42	21	78.8	0	8	133	478	519	MEX2043371.1 phospholipid carrier-dependent glycosyltransferase [Patescibacteria group bacterium]	diamond	345	42.4	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27440463	27440463	PRJNA495391_S_NODE_3223_length_731_cov_2.229885_g2283_i0	PRJNA495391	3223	731	2.229885	16.30045935	Aestuariimicrobium	396388	Bacteria	Bacteria	100	4.66e-20	NR	RLC35813.1	2202143	g2283	i0	33.8	1.78932968536252	207	108	77.2	10	724	161	300	496	RLC35813.1 MAG: hypothetical protein DRH29_05725, partial [candidate division Kazan bacterium]	diamond	1308	100	1	Bacteria	Bacteria candidate phyla						candidate division Kazan bacterium
28245322	28245322	PRJNA495391_S_NODE_38306_length_198_cov_0.969325_g37254_i0	PRJNA495391	38306	198	0.969325	1.9192635	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	129	1.96e-33	NR	MBF1032827.1	2725945	g37254	i0	100	0.984848484848485	65	0	98.5	0	197	3	244	308	MBF1032827.1 glycosyltransferase [Candidatus Nanosynbacter sp.]	diamond	195	129	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
28245342	28245342	PRJNA495391_S_NODE_71026_length_150_cov_1.530435_g69974_i0	PRJNA495391	71026	150	1.530435	2.2956525	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	97.8	4.27e-22	NR	MBB1558591.1	2026720	g69974	i0	96	2	50	2	100	0	150	1	440	489	MBB1558591.1 PAS domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	300	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28703210	28703210	PRJNA495391_S_NODE_51647_length_172_cov_1.992701_g50595_i0	PRJNA495391	51647	172	1.992701	3.42744572	root	1	Root_unresolved	Root_unresolved	42.4	0.019	NR	MBP9763628.1	2053589	g50595	i0	72	0.906976744186046	25	7	43.6	0	1	75	216	240	MBP9763628.1 site-specific DNA-methyltransferase [Candidatus Paceibacterota bacterium]	diamond	156	42.7	0.992974238875878	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
29792497	29792497	PRJNA495391_S_NODE_29811_length_222_cov_1.245989_g28759_i0	PRJNA495391	29811	222	1.245989	2.76609558	Candidatus Binataceae bacterium	2785449	Bacteria	Bacteria	45.4	0.00301	NR	HKV54792.1	2785449	g28759	i0	51.9	0.72972972972973	54	21	67.6	2	190	41	277	329	HKV54792.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Binataceae bacterium]	diamond	162	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatales	Candidatus Binataceae		Candidatus Binataceae bacterium
30613984	30613984	PRJNA495391_S_NODE_47673_length_179_cov_1.111111_g46621_i0	PRJNA495391	47673	179	1.111111	1.98888869	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	41.6	0.0369	NR	MFH1978791.1	2052139	g46621	i0	38	0.837988826815642	50	31	83.8	0	162	13	144	193	MFH1978791.1 Type 1 glutamine amidotransferase-like domain-containing protein [Patescibacteria group bacterium]	diamond	150	41.6	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31088035	31088035	PRJNA495391_S_NODE_57655_length_164_cov_1.527132_g56603_i0	PRJNA495391	57655	164	1.527132	2.50449648	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	70.1	7.36e-13	NR	HUW47685.1	2052139	g56603	i0	59.3	0.98780487804878	54	22	98.8	0	2	163	128	181	HUW47685.1 hypothetical protein [Patescibacteria group bacterium]	diamond	162	70.1	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31451503	31451503	PRJNA495391_S_NODE_30756_length_219_cov_1.152174_g29704_i0	PRJNA495391	30756	219	1.152174	2.52326106	Bacteria	2	Bacteria	Bacteria	116	2.99e-28	NR	PIQ67671.1	1975040	g29704	i0	74.6	2.94520547945205	71	18	97.3	0	214	2	452	522	PIQ67671.1 MAG: glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Uhrbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_41_9]	diamond	645	116	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota					Candidatus Uhrbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_41_9

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);;