metadata: contig_metadata: 3 rows where bioproject = "PRJNA781453" and tax

3 rows where bioproject = "PRJNA781453" and tax_phylum = "Spirochaetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
29201139	29201139	PRJNA781453_P_NODE_2449_length_925_cov_1.623239_g2369_i0	PRJNA781453	2449	925	1.623239	15.01496075	Spirochaetia bacterium	2053615	Bacteria	Bacteria	120	2.26e-30	NR	MFO7729640.1	2053615	g2369	i0	62.6	0.295135135135135	91	33	29.2	1	446	177	11	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	273	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31823481	31823481	PRJNA781453_P_NODE_34737_length_248_cov_0.880000_g34622_i0	PRJNA781453	34737	248	0.88	2.1824	Brachyspira aalborgi	29522	Bacteria	Bacteria	120	9.21e-30	NR	WP_147526710.1	29522	g34622	i0	89.6	0.810483870967742	67	7	81	0	203	3	2	68	WP_147526710.1 RNA polymerase sigma factor RpoD [Brachyspira aalborgi]	diamond	201	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira aalborgi
32076747	32076747	PRJNA781453_P_NODE_4738_length_687_cov_1.850163_g4633_i0	PRJNA781453	4738	687	1.850163	12.71061981	Spirochaetia bacterium	2053615	Bacteria	Bacteria	149	2.7299999999999993e-42	NR	MFO7729640.1	2053615	g4633	i0	91.4	0.353711790393013	81	6	35.4	1	444	686	9	88	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	243	149	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia 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);;