metadata: contig_metadata: 5 rows where bioproject = "PRJNA900028", tax_clade = "Bacteria candidate phyla" and tax

5 rows where bioproject = "PRJNA900028", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"

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_species
26866230	26866230	PRJNA900028_P_NODE_197501_length_161_cov_0.910714_g196752_i0	PRJNA900028	197501	161	0.910714	1.46624954	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	102	3.58e-24	NR	MDR3549265.1	2053589	g196752	i0	88.7	0.987577639751553	53	6	98.8	0	1	159	200	252	MDR3549265.1 DDE-type integrase/transposase/recombinase [Candidatus Paceibacterota bacterium]	diamond	159	102	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
28476992	28476992	PRJNA900028_P_NODE_78386_length_186_cov_1.043796_g77637_i0	PRJNA900028	78386	186	1.043796	1.94146056	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	120	3.5999999999999997e-33	NR	MFN3188793.1	3120121	g77637	i0	90.3	1	62	6	100	0	186	1	87	148	MFN3188793.1 chemotaxis protein CheX [Minisyncoccia bacterium]	diamond	186	120	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Minisyncoccia bacterium
30908961	30908961	PRJNA900028_P_NODE_134454_length_166_cov_0.871795_g133705_i0	PRJNA900028	134454	166	0.871795	1.4471797	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	50.8	1.87e-5	NR	HEY6020690.1	2053589	g133705	i0	50	1.01204819277108	56	25	97.6	2	162	1	1829	1883	HEY6020690.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	168	50.8	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
31224704	31224704	PRJNA900028_P_NODE_181935_length_162_cov_0.902655_g181186_i0	PRJNA900028	181935	162	0.902655	1.4623011	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	81.3	1.09e-17	NR	HXK39028.1	2053589	g181186	i0	75	0.962962962962963	52	13	96.3	0	5	160	86	137	HXK39028.1 SIS domain-containing protein [Candidatus Paceibacterota bacterium]	diamond	156	81.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
31414666	31414666	PRJNA900028_P_NODE_93956_length_178_cov_2.217054_g93207_i0	PRJNA900028	93956	178	2.217054	3.94635612	Minisyncoccia bacterium	3120121	Bacteria	Bacteria	114	2.16e-28	NR	MFN3188794.1	3120121	g93207	i0	91.5	0.99438202247191	59	5	99.4	0	177	1	220	278	MFN3188794.1 IS1380 family transposase [Minisyncoccia bacterium]	diamond	177	114	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Minisyncoccia 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);;