metadata: contig_metadata: 5 rows where bioproject = "PRJEB80557", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJEB80557", tax_kingdom = "Pseudomonadati" 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
996474	996474	PRJEB80557_S_NODE_16621_length_230_cov_8.248619_g16225_i0	PRJEB80557	16621	230	8.248619	18.9718237	Borrelia	138	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g16225	i0	100	0.243478260869565	28	0	12	0	168	195	11682	11655	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
27918606	27918606	PRJEB80557_S_NODE_24425_length_194_cov_1.662069_g24029_i0	PRJEB80557	24425	194	1.662069	3.22441386	Spirochaetia bacterium	2053615	Bacteria	Bacteria	77	1.02e-14	NR	HRV29573.1	2053615	g24029	i0	72	2.31958762886598	50	14	77.3	0	151	2	82	131	HRV29573.1 hypothetical protein [Spirochaetia bacterium]	diamond	450	77	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29213465	29213465	PRJEB80557_S_NODE_24889_length_193_cov_1.076389_g24493_i0	PRJEB80557	24889	193	1.076389	2.07743077	Spirochaetia bacterium	2053615	Bacteria	Bacteria	117	1.19e-29	NR	HRV28903.1	2053615	g24493	i0	87.1	2.82901554404145	62	8	96.4	0	7	192	244	305	HRV28903.1 recombinase RecT [Spirochaetia bacterium]	diamond	546	117	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29939668	29939668	PRJEB80557_S_NODE_7251_length_330_cov_2.729537_g6855_i0	PRJEB80557	7251	330	2.729537	9.0074721	Treponema ruminis	744515	Bacteria	Bacteria	49.3	9.36e-5	NR	WP_206173080.1	744515	g6855	i0	34.9	0.754545454545455	83	50	73.6	2	2	244	14	94	WP_206173080.1 single-stranded DNA-binding protein [Treponema ruminis]	diamond	249	49.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema ruminis
30255753	30255753	PRJEB80557_S_NODE_23332_length_198_cov_1.389262_g22936_i0	PRJEB80557	23332	198	1.389262	2.75073876	Pleomorphochaeta sp.	1920505	Bacteria	Bacteria	73.9	6.03e-14	NR	MDC7243806.1	1920505	g22936	i0	59.6	0.863636363636364	57	23	86.4	0	28	198	1	57	MDC7243806.1 Fe-S cluster assembly ATPase SufC [Pleomorphochaeta sp.]	diamond	171	73.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta sp.

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