metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Kaiseribacteriota"

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_species
8706947	8706947	PRJNA168635_P_NODE_16107_length_199_cov_5.546667_g15691_i0	PRJNA168635	16107	199	5.546667	11.03786733	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	72	3.26e-14	NR	HCM43806.1	2030810	g15691	i0	75	0.663316582914573	44	11	66.3	0	173	42	7	50	HCM43806.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	132	72	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
26630770	26630770	PRJNA168635_P_NODE_20021_length_182_cov_2.030075_g19605_i0	PRJNA168635	20021	182	2.030075	3.6947365	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	76.3	2.42e-14	NR	MCR4286296.1	2030810	g19605	i0	49.2	0.972527472527473	59	30	97.3	0	179	3	336	394	MCR4286296.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	177	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
29852858	29852858	PRJNA168635_P_NODE_24431_length_170_cov_3.264463_g24015_i0	PRJNA168635	24431	170	3.264463	5.5495871	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	71.2	1.1e-12	NR	MBI3572376.1	2030810	g24015	i0	57.1	0.988235294117647	56	24	98.8	0	2	169	65	120	MBI3572376.1 type II secretion system F family protein [Candidatus Kaiserbacteria bacterium]	diamond	168	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
30042294	30042294	PRJNA168635_P_NODE_26351_length_168_cov_0.873950_g25935_i0	PRJNA168635	26351	168	0.87395	1.468236	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	66.6	1.69e-12	NR	QQR64461.1	2030810	g25935	i0	58.3	1.73214285714286	48	19	85.7	1	150	7	40	86	QQR64461.1 MAG: co-chaperone GroES [Candidatus Kaiserbacteria bacterium]	diamond	291	66.6	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
32083174	32083174	PRJNA168635_P_NODE_17798_length_190_cov_2.198582_g17382_i0	PRJNA168635	17798	190	2.198582	4.1773058	Bacteria	2	Bacteria	Bacteria	104	5.840000000000001e-26	NR	MCA9365380.1	2030810	g17382	i0	73	2.98421052631579	63	17	99.5	0	1	189	140	202	MCA9365380.1 hypothetical protein [Candidatus Kaiserbacteria bacterium]	diamond	567	105	0.990476190476191	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria 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);;