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

11 rows where bioproject = "PRJNA798905" 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_species
26610608	26610608	PRJNA798905_S_NODE_44021_length_212_cov_4.733813_g43572_i0	PRJNA798905	44021	212	4.733813	10.03568356	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	42	0.0411	NR	MBP7875839.1	2026804	g43572	i0	38.6	0.622641509433962	44	25	59.4	1	82	207	178	221	MBP7875839.1 oligosaccharide flippase family protein [Candidatus Woesebacteria bacterium]	diamond	132	42	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota				Candidatus Woesebacteria bacterium
27116972	27116972	PRJNA798905_S_NODE_26542_length_293_cov_3.845455_g26093_i0	PRJNA798905	26542	293	3.845455	11.26718315	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	50.8	9.58e-5	NR	NOR46303.1	2044594	g26093	i0	36.2	1.55631399317406	69	40	70.6	1	220	14	206	270	NOR46303.1 hypothetical protein [Candidatus Delongbacteria bacterium]	diamond	456	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota				Candidatus Delongbacteria bacterium
27812336	27812336	PRJNA798905_S_NODE_26444_length_294_cov_1.647059_g25995_i0	PRJNA798905	26444	294	1.647059	4.84235346	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	67.4	7e-11	NR	MDN5274245.1	2026720	g25995	i0	73.7	0.387755102040816	38	10	38.8	0	181	294	1	38	MDN5274245.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	114	67.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
28538535	28538535	PRJNA798905_S_NODE_41807_length_231_cov_4.069620_g41358_i0	PRJNA798905	41807	231	4.06962	9.4008222	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	53.5	4.73e-6	NR	MDD3301326.1	2052139	g41358	i0	55.1	0.636363636363636	49	22	63.6	0	199	53	27	75	MDD3301326.1 YibE/F family protein [Patescibacteria group bacterium]	diamond	147	53.5	1	Bacteria	Bacteria candidate phyla					Patescibacteria group bacterium
31001932	31001932	PRJNA798905_S_NODE_26754_length_292_cov_3.164384_g26305_i0	PRJNA798905	26754	292	3.164384	9.24000128	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	137	8.3e-38	NR	MDN5274245.1	2026720	g26305	i0	66	0.996575342465753	97	33	99.7	0	2	292	32	128	MDN5274245.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	291	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
31191067	31191067	PRJNA798905_S_NODE_35335_length_252_cov_3.871508_g34886_i0	PRJNA798905	35335	252	3.871508	9.75620016	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	62	6.01e-9	NR	MBS7346620.1	2830836	g34886	i0	48.7	0.928571428571429	78	35	91.7	2	234	4	90	163	MBS7346620.1 hypothetical protein [Candidatus Saccharimonadaceae bacterium]	diamond	234	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonadaceae bacterium
31254608	31254608	PRJNA798905_S_NODE_12455_length_401_cov_1.963415_g12006_i0	PRJNA798905	12455	401	1.963415	7.87329415	candidate division NC1	1640516	Bacteria	Bacteria	53.9	1.95e-5	NR	KRT69385.1	1640516	g12006	i0	40.3	1.20448877805486	72	43	53.9	0	7	222	198	269	KRT69385.1 MAG: hypothetical protein XU15_C0011G0067 [candidate division NC10 bacterium CSP1-5]	diamond	483	53.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota				candidate division NC10 bacterium CSP1-5
31539443	31539443	PRJNA798905_S_NODE_32936_length_262_cov_3.259259_g32487_i0	PRJNA798905	32936	262	3.259259	8.53925858	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	48.5	3.69e-4	NR	RME56992.1	2762014	g32487	i0	60.5	0.435114503816794	38	15	43.5	0	232	119	221	258	RME56992.1 MAG: hypothetical protein D6779_09605, partial [Candidatus Parcubacteria bacterium]	diamond	114	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria				Candidatus Parcubacteria bacterium
31571143	31571143	PRJNA798905_S_NODE_17756_length_349_cov_6.054348_g17307_i0	PRJNA798905	17756	349	6.054348	21.12967452	Candidatus Wolfebacteria bacterium	2030812	Bacteria	Bacteria	60.8	5.17e-8	NR	NCQ02552.1	2030812	g17307	i0	81.3	0.550143266475645	32	6	27.5	0	252	347	1	32	NCQ02552.1 glycine--tRNA ligase [Candidatus Wolfebacteria bacterium]	diamond	192	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota				Candidatus Wolfebacteria bacterium
32362148	32362148	PRJNA798905_S_NODE_3779_length_686_cov_5.453507_g3347_i0	PRJNA798905	3779	686	5.453507	37.41105802	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	55.5	1.91e-6	NR	MCX6558684.1	2052149	g3347	i0	46.3	0.494169096209913	41	22	17.9	0	48	170	37	77	MCX6558684.1 HNH endonuclease [Candidatus Aminicenantes bacterium]	diamond	339	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota				Candidatus Aminicenantes bacterium
32677502	32677502	PRJNA798905_S_NODE_17080_length_355_cov_2.730496_g16631_i0	PRJNA798905	17080	355	2.730496	9.6932608	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	56.6	7.22e-7	NR	HPI81844.1	2053589	g16631	i0	38.8	0.71830985915493	85	47	71.8	2	312	58	90	169	HPI81844.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	255	56.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota				Minisyncoccota 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);;