metadata: contig_metadata: 4 rows where bioproject = "PRJNA340009", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Blackburniibacteriota"

4 rows where bioproject = "PRJNA340009", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Blackburniibacteriota"

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
29807543	29807543	PRJNA340009_P_NODE_78731_length_157_cov_8.379630_g78424_i0	PRJNA340009	78731	157	8.37963	13.1560191	Bacteria	2	Bacteria	Bacteria	57.4	7.56e-8	NR	OGY06952.1	1797512	g78424	i0	57.7	1.98726114649682	52	21	97.5	1	155	3	29	80	OGY06952.1 MAG: hypothetical protein A2694_04190 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17]	diamond	312	57.4	1	Bacteria	Bacteria candidate phyla	Candidatus Blackburniibacteriota	Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17
30927961	30927961	PRJNA340009_P_NODE_77594_length_160_cov_15.234234_g77287_i0	PRJNA340009	77594	160	15.234234	24.3747744	Candidatus Blackburnbacteria bacterium	2053523	Bacteria	Bacteria	54.3	4.16e-8	NR	MBI4029482.1	2053523	g77287	i0	85.7	0.525	28	4	52.5	0	155	72	33	60	MBI4029482.1 hypothetical protein [Candidatus Blackburnbacteria bacterium]	diamond	84	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Blackburniibacteriota	Candidatus Blackburnbacteria bacterium
31338580	31338580	PRJNA340009_P_NODE_25496_length_243_cov_22.391753_g25189_i0	PRJNA340009	25496	243	22.391753	54.41195979	Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_	2053523	Bacteria	Bacteria	76.3	5.61e-14	NR	OGY06826.1	1797512	g25189	i0	58.3	1.79012345679012	72	30	88.9	0	241	26	133	204	OGY06826.1 MAG: hypothetical protein A2694_00715 [Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17]	diamond	435	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Blackburniibacteriota	Candidatus Blackburnbacteria bacterium RIFCSPHIGHO2_01_FULL_40_17
31925208	31925208	PRJNA340009_P_NODE_77857_length_160_cov_2.549550_g77550_i0	PRJNA340009	77857	160	2.54955	4.07928	Bacteria	2	Bacteria	Bacteria	58.5	3.22e-8	NR	MBI2268403.1	2053523	g77550	i0	71.9	2.45625	32	9	60	0	154	59	61	92	MBI2268403.1 hypothetical protein [Candidatus Blackburnbacteria bacterium]	diamond	393	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Blackburniibacteriota	Candidatus Blackburnbacteria 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);;