metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Candidatus Zambryskiibacteriota"

4 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_phylum = "Candidatus Zambryskiibacteriota"

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
27168727	27168727	PRJNA283169_P_NODE_3482_length_222_cov_1.179191_g3419_i0	PRJNA283169	3482	222	1.179191	2.61780402	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	85.1	3.42e-17	NR	OHA88224.1	1802734	g3419	i0	43.8	0.986486486486487	73	41	98.6	0	1	219	435	507	OHA88224.1 MAG: single-stranded-DNA-specific exonuclease RecJ [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_43_25]	diamond	219	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_43_25
29694764	29694764	PRJNA283169_P_NODE_3890_length_212_cov_1.208589_g3827_i0	PRJNA283169	3890	212	1.208589	2.56220868	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	102	2.4299999999999998e-23	NR	MFH0804201.1	2053652	g3827	i0	84.1	0.891509433962264	63	9	89.2	1	189	1	229	290	MFH0804201.1 ATP-dependent DNA helicase [Candidatus Zambryskiibacteriota bacterium]	diamond	189	102	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
30927395	30927395	PRJNA283169_P_NODE_7514_length_164_cov_0.904348_g7451_i0	PRJNA283169	7514	164	0.904348	1.48313072	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	79.3	1.25e-15	NR	OHA86622.1	1802733	g7451	i0	70.8	0.878048780487805	48	14	87.8	0	162	19	321	368	OHA86622.1 MAG: hypothetical protein A2644_01905 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_39_63]	diamond	144	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_39_63
32540494	32540494	PRJNA283169_S_NODE_2739_length_175_cov_0.095238_g2725_i0	PRJNA283169	2739	175	0.095238	0.1666665	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	59.7	5.51e-9	NR	OHA92873.1	1802743	g2725	i0	78.4	0.634285714285714	37	8	63.4	0	175	65	153	189	OHA92873.1 MAG: hypothetical protein A2W51_01190 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_39_10]	diamond	111	59.7	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_39_10

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);;