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

5 rows where bioproject = "PRJEB58983", 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
3542629	3542629	PRJEB58983_P_NODE_19183_length_295_cov_1.387387_g18768_i0	PRJEB58983	19183	295	1.387387	4.09279165	Turneriella	338321	Bacteria	Bacteria	505	1.75e-138	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g18768	i0	97.324	219.508474576271	299	4	100	2	1	295	1029	1327	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	64755	505	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
4820053	4820053	PRJEB58983_P_NODE_22184_length_278_cov_2.204878_g21769_i0	PRJEB58983	22184	278	2.204878	6.12956084	Bacteria	2	Bacteria	Bacteria	124	5.2499999999999996e-31	NR	TVR55516.1	1898206	g21769	i0	70	28.0035971223022	90	23	97.1	2	2	271	391	476	TVR55516.1 MAG: adenosylhomocysteinase [Spirochaetaceae bacterium]	diamond	7785	125	0.992	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
10327880	10327880	PRJEB58983_P_NODE_21409_length_282_cov_2.086124_g20994_i0	PRJEB58983	21409	282	2.086124	5.88286968	Spirochaetia bacterium	2053615	Bacteria	Bacteria	193	1.47e-44	NTclustered	gi\|2626255577\|emb\|OY843750.1\|	2053615	g20994	i0	79.004	5.47517730496454	281	59	99	0	1	281	1357364	1357644	MAG: Spirochaetia bacterium isolate 7728ca74-1c7a-4d85-adbe-0c26628de7b6 genome assembly, chromosome: 1	blastn	1544	193	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
10327937	10327937	PRJEB58983_P_NODE_24369_length_268_cov_1.441026_g23954_i0	PRJEB58983	24369	268	1.441026	3.86194968	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g23954	i0	100	102.261194029851	268	0	100	0	1	268	257300	257567	Leptospira sp. severe_002 chromosome 1	blastn	27406	496	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
28921491	28921491	PRJEB58983_P_NODE_25928_length_261_cov_1.106383_g25513_i0	PRJEB58983	25928	261	1.106383	2.88765963	Bacteria	2	Bacteria	Bacteria	43.5	0.0248	NR	MBP7095020.1	2053615	g25513	i0	49.1	1.17241379310345	53	23	60.9	1	160	2	212	260	MBP7095020.1 cadherin-like beta sandwich domain-containing protein [Spirochaetia bacterium]	diamond	306	43.5	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);;