metadata: contig_metadata: 18 rows where bioproject = "PRJNA358049" and tax

18 rows where bioproject = "PRJNA358049" 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
3623831	3623831	PRJNA358049_S_NODE_6443_length_243_cov_13.056701_g6395_i0	PRJNA358049	6443	243	13.056701	31.72778343	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	300	7.08e-77	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g6395	i0	92.754	195.267489711934	207	15	85	0	14	220	115461	115255	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	47450	300	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
6776063	6776063	PRJNA358049_S_NODE_11906_length_191_cov_1.323944_g11858_i0	PRJNA358049	11906	191	1.323944	2.52873304	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	73.1	1.26e-8	NTclustered	gi\|2108275290\|gb\|CP070680.1\|	2052148	g11858	i0	85.714	11.2251308900524	70	9	36	1	102	170	1347588	1347519	MAG: candidate division WOR-3 bacterium isolate bin69 chromosome	blastn	2144	73.1	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3					candidate division WOR-3 bacterium
10602274	10602274	PRJNA358049_S_NODE_14809_length_174_cov_1.984000_g14761_i0	PRJNA358049	14809	174	1.984	3.45216	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	224	2.93e-54	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g14761	i0	91.411	90.4540229885057	163	14	94	0	12	174	122984	123146	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	15739	224	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
15701475	15701475	PRJNA358049_S_NODE_7633_length_226_cov_1.898305_g7585_i0	PRJNA358049	7633	226	1.898305	4.2901693	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	115	2.5300000000000003e-21	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g7585	i0	85.217	1.01769911504425	115	14	50	3	78	190	429477	429590	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	230	115	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
19524550	19524550	PRJNA358049_S_NODE_5256_length_266_cov_1.658986_g5208_i0	PRJNA358049	5256	266	1.658986	4.41290276	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	267	7.979999999999999e-67	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g5208	i0	84.962	220.195488721805	266	36	99	4	4	266	125422	125686	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	58572	267	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
19524591	19524591	PRJNA358049_S_NODE_6696_length_239_cov_2.673684_g6648_i0	PRJNA358049	6696	239	2.673684	6.39010476	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	239	1.54e-58	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g6648	i0	84.874	94.0334728033473	238	34	99	2	3	239	125669	125905	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	22474	239	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
20800279	20800279	PRJNA358049_S_NODE_6737_length_239_cov_1.105263_g6689_i0	PRJNA358049	6737	239	1.105263	2.64157857	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6689	i0	99.582	211.008368200837	239	1	100	0	1	239	111002	111240	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	50431	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
23350763	23350763	PRJNA358049_S_NODE_6279_length_246_cov_3.096447_g6231_i0	PRJNA358049	6279	246	3.096447	7.61725962	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6231	i0	100	72.9674796747967	246	0	100	0	1	246	111645	111400	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	17950	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
26599740	26599740	PRJNA358049_S_NODE_8981_length_212_cov_1.564417_g8933_i0	PRJNA358049	8981	212	1.564417	3.31656404	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	127	4.46e-35	NR	MBF1037529.1	2725945	g8933	i0	97.1	0.976415094339623	69	2	97.6	0	4	210	43	111	MBF1037529.1 hypothetical protein [Candidatus Nanosynbacter sp.]	diamond	207	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
26694894	26694894	PRJNA358049_S_NODE_11301_length_194_cov_1.379310_g11253_i0	PRJNA358049	11301	194	1.37931	2.6758614	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	72.8	3.71e-14	NR	MEJ0072657.1	2026720	g11253	i0	59.3	3.64948453608247	59	24	91.2	0	16	192	4	62	MEJ0072657.1 HNH endonuclease [Candidatus Saccharibacteria bacterium]	diamond	708	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27612049	27612049	PRJNA358049_S_NODE_18424_length_162_cov_1.380531_g18376_i0	PRJNA358049	18424	162	1.380531	2.23646022	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	62.4	1.42e-9	NR	MDD4989195.1	2053589	g18376	i0	55.1	0.907407407407407	49	22	90.7	0	161	15	142	190	MDD4989195.1 tetratricopeptide repeat protein [Candidatus Paceibacterota bacterium]	diamond	147	62.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28085464	28085464	PRJNA358049_S_NODE_11545_length_193_cov_1.055556_g11497_i0	PRJNA358049	11545	193	1.055556	2.03722308	Candidatus Nanogingivalis gingivitcus	2171992	Bacteria	Bacteria	123	8.669999999999998e-31	NR	WP_129718745.1	2171992	g11497	i0	100	0.994818652849741	64	0	99.5	0	192	1	36	99	WP_129718745.1 hypothetical protein [Candidatus Nanogingivalis gingivitcus]	diamond	192	123	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalis	Candidatus Nanogingivalis gingivitcus
28481583	28481583	PRJNA358049_S_NODE_12806_length_185_cov_1.889706_g12758_i0	PRJNA358049	12806	185	1.889706	3.4959561	Bacteria	2	Bacteria	Bacteria	100	7.619999999999999e-23	NR	OQB19547.1	1852938	g12758	i0	78.7	11.8702702702703	61	13	98.9	0	184	2	450	510	OQB19547.1 MAG: Alanine--tRNA ligase [Parcubacteria group bacterium ADurb.Bin192]	diamond	2196	101	0.99009900990099	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium ADurb.Bin192
30643410	30643410	PRJNA358049_S_NODE_14413_length_176_cov_2.456693_g14365_i0	PRJNA358049	14413	176	2.456693	4.32377968	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	58.5	4.03e-8	NR	HLC69832.1	2052139	g14365	i0	43.1	2.96590909090909	58	33	98.9	0	1	174	348	405	HLC69832.1 excinuclease ABC subunit UvrB [Patescibacteria group bacterium]	diamond	522	58.5	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30675045	30675045	PRJNA358049_S_NODE_9293_length_209_cov_1.512500_g9245_i0	PRJNA358049	9293	209	1.5125	3.161125	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	125	1.45e-32	NR	MBF1015493.1	2725942	g9245	i0	95.7	1.98086124401914	69	3	99	0	3	209	250	318	MBF1015493.1 DNA recombination protein RmuC [Candidatus Nanogingivalaceae bacterium]	diamond	414	125	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
31767058	31767058	PRJNA358049_S_NODE_16497_length_167_cov_1.220339_g16449_i0	PRJNA358049	16497	167	1.220339	2.03796613	Pseudomonadati	3379134	Bacteria	Bacteria	107	1e-25	NR	PIQ71616.1	1974857	g16449	i0	90.9	4.94011976047904	55	5	98.8	0	1	165	78	132	PIQ71616.1 MAG: hypothetical protein COV87_02360 [Candidatus Roizmanbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_37_16]	diamond	825	107	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium CG11_big_fil_rev_8_21_14_0_20_37_16
31876392	31876392	PRJNA358049_S_NODE_6077_length_250_cov_1.268657_g6029_i0	PRJNA358049	6077	250	1.268657	3.1716425	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	112	2.25e-27	NR	MCX6732311.1	2282149	g6029	i0	86.2	1.392	58	8	69.6	0	77	250	1	58	MCX6732311.1 CBS domain-containing protein [Candidatus Roizmanbacteria bacterium]	diamond	348	112	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
32066275	32066275	PRJNA358049_S_NODE_13418_length_182_cov_1.338346_g13370_i0	PRJNA358049	13418	182	1.338346	2.43578972	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	107	2.2e-27	NR	MDE2311464.1	2052139	g13370	i0	83.3	0.989010989010989	60	10	98.9	0	1	180	41	100	MDE2311464.1 signal peptidase I [Patescibacteria group bacterium]	diamond	180	107	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);;