metadata: contig_metadata: 4 rows where bioproject = "PRJNA575566" and tax

4 rows where bioproject = "PRJNA575566" 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
17137591	17137591	PRJNA575566_P_NODE_134_length_2186_cov_4.372235_g104_i0	PRJNA575566	134	2186	4.372235	95.5770571	Spirochaetota bacterium	2202144	Bacteria	Bacteria	143	1.3e-28	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g104	i0	81.461	7.10475754803294	178	30	8	3	1345	1520	74373	74549	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	15531	143	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
26763012	26763012	PRJNA575566_P_NODE_22821_length_216_cov_2.058065_g22624_i0	PRJNA575566	22821	216	2.058065	4.4454204	Spirochaetae bacterium HGW-Spirochaetae-1	2013832	Bacteria	Bacteria	62	4.09e-9	NR	PKL37824.1	2013832	g22624	i0	45.7	0.972222222222222	70	36	97.2	1	3	212	417	484	PKL37824.1 MAG: F0F1 ATP synthase subunit alpha [Spirochaetae bacterium HGW-Spirochaetae-1]	diamond	210	62	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-1
28009264	28009264	PRJNA575566_P_NODE_19505_length_238_cov_1.084746_g19308_i0	PRJNA575566	19505	238	1.084746	2.58169548	root	1	Root_unresolved	Root_unresolved	114	7.7199999999999995e-28	NR	WP_184652782.1	157	g19308	i0	68.4	2.98739495798319	79	21	99.6	2	1	237	337	411	WP_184652782.1 MULTISPECIES: asparagine--tRNA ligase [Treponema]	diamond	711	114	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
31976043	31976043	PRJNA575566_P_NODE_21978_length_222_cov_1.385093_g21781_i0	PRJNA575566	21978	222	1.385093	3.07490646	Borrelia turcica	229155	Bacteria	Bacteria	78.6	5.29e-15	NR	WP_120103846.1	229155	g21781	i0	53.4	3.94594594594595	73	33	98.6	1	220	2	228	299	WP_120103846.1 PQQ-dependent sugar dehydrogenase [Borrelia turcica]	diamond	876	78.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turcica

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