metadata: contig_metadata: 12 rows where bioproject = "PRJNA1139127" and tax

12 rows where bioproject = "PRJNA1139127" 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
1559782	1559782	PRJNA1139127_P_NODE_31042_length_312_cov_8.682008_g30550_i0	PRJNA1139127	31042	312	8.682008	27.08786496	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	540	5.11e-149	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g30550	i0	100	67.3653846153846	292	0	94	0	21	312	111338	111629	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	21018	540	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
11763989	11763989	PRJNA1139127_P_NODE_5830_length_936_cov_3.454229_g5472_i0	PRJNA1139127	5830	936	3.454229	32.33158344	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	872	0	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g5472	i0	83.917	9.97863247863248	914	145	98	2	1	913	335967	336879	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	9340	872	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
16334746	16334746	PRJNA1139127_P_NODE_50013_length_227_cov_7.129870_g49520_i0	PRJNA1139127	50013	227	7.12987	16.1848049	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	381	2.2699999999999995e-101	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g49520	i0	100	187.202643171806	206	0	91	0	22	227	115255	115460	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	42495	381	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
27670821	27670821	PRJNA1139127_P_NODE_11564_length_619_cov_1.708791_g11097_i0	PRJNA1139127	11564	619	1.708791	10.57741629	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	256	4.8799999999999985e-81	NR	HSX07579.1	2973664	g11097	i0	74.7	1.64781906300485	170	43	82.4	0	3	512	212	381	HSX07579.1 cysteine desulfurase family protein [Candidatus Saccharimonadales bacterium]	diamond	1020	256	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27734110	27734110	PRJNA1139127_P_NODE_20044_length_424_cov_0.937322_g19553_i0	PRJNA1139127	20044	424	0.937322	3.97424528	Parcubacteria group bacterium Gr	2026774	Bacteria	Bacteria	195	5.61e-59	NR	TSC89202.1	2017173	g19553	i0	72.4	2.625	123	34	87	0	369	1	29	151	TSC89202.1 MAG: molybdopterin and thiamine biosynthesis dinucleotide-utilizing enzyme [Parcubacteria group bacterium Gr01-1014_3]	diamond	1113	195	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium Gr01-1014_3
28428520	28428520	PRJNA1139127_P_NODE_38406_length_269_cov_1.739796_g37913_i0	PRJNA1139127	38406	269	1.739796	4.68005124	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	65.9	3.35e-10	NR	MEK7637872.1	2052139	g37913	i0	54.4	1.73977695167286	57	26	63.6	0	98	268	18	74	MEK7637872.1 FtsW/RodA/SpoVE family cell cycle protein [Patescibacteria group bacterium]	diamond	468	65.9	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
28838781	28838781	PRJNA1139127_P_NODE_8548_length_747_cov_2.649852_g8122_i0	PRJNA1139127	8548	747	2.649852	19.79439444	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	146	1.85e-36	NR	HKA28429.1	2838779	g8122	i0	41.4	0.795180722891566	198	101	76.7	7	601	29	129	318	HKA28429.1 thaumatin family protein [Candidatus Binatia bacterium]	diamond	594	146	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29049057	29049057	PRJNA1139127_P_NODE_48948_length_242_cov_0.923077_g48455_i0	PRJNA1139127	48948	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	62	4.09e-9	NR	OYV63841.1	1970249	g48455	i0	54.8	1.42561983471074	62	25	76.9	1	212	27	1	59	OYV63841.1 MAG: hypothetical protein B7X03_00170 [Parcubacteria group bacterium 21-58-10]	diamond	345	62	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium 21-58-10
29964750	29964750	PRJNA1139127_P_NODE_35731_length_283_cov_1.480952_g35238_i0	PRJNA1139127	35731	283	1.480952	4.19109416	Bacteria	2	Bacteria	Bacteria	89.4	9.42e-19	NR	OGH02508.1	1798588	g35238	i0	60.8	3.11660777385159	74	29	78.4	0	18	239	173	246	OGH02508.1 MAG: hypothetical protein A2798_02565 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_37_17]	diamond	882	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_37_17
31271138	31271138	PRJNA1139127_P_NODE_48255_length_243_cov_0.917647_g47762_i0	PRJNA1139127	48255	243	0.917647	2.22988221	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	59.7	2.92e-8	NR	RJQ26094.1	2762014	g47762	i0	58.5	0.506172839506173	41	17	50.6	0	117	239	2	42	RJQ26094.1 MAG: hypothetical protein C4577_04130, partial [Candidatus Parcubacteria bacterium]	diamond	123	59.7	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
32093490	32093490	PRJNA1139127_P_NODE_23818_length_376_cov_2.290429_g23327_i0	PRJNA1139127	23818	376	2.290429	8.61201304	Candidatus Microgenomates bacterium	2093373	Bacteria	Bacteria	67	1.26e-10	NR	RJR16228.1	2093373	g23327	i0	53.3	0.478723404255319	60	28	47.9	0	181	2	2	61	RJR16228.1 MAG: 2'-5' RNA ligase family protein [Candidatus Microgenomates bacterium]	diamond	180	67	1	Bacteria	Bacteria candidate phyla	Candidatus Microgenomatota					Candidatus Microgenomates bacterium
32283674	32283674	PRJNA1139127_P_NODE_28599_length_331_cov_1.209302_g28107_i0	PRJNA1139127	28599	331	1.209302	4.00278962	Candidatus Brennerbacteria bacterium	2750072	Bacteria	Bacteria	82	3.36e-16	NR	MBI2278936.1	2750072	g28107	i0	81.8	1.26888217522659	44	8	39.9	0	198	67	216	259	MBI2278936.1 IS3 family transposase [Candidatus Brennerbacteria bacterium]	diamond	420	82	1	Bacteria	Bacteria candidate phyla	Candidatus Brenneribacteriota					Candidatus Brennerbacteria 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);;