metadata: contig_metadata: 8 rows where bioproject = "PRJNA1086823", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA1086823", 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
11220843	11220843	PRJNA1086823_P_NODE_8049_length_292_cov_1.406393_g7932_i0	PRJNA1086823	8049	292	1.406393	4.10666756	Bacteria	2	Bacteria	Bacteria	534	2.1999999999999998e-147	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g7932	i0	99.658	113.948630136986	292	1	100	0	1	292	317081	317372	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	33273	534	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
26718941	26718941	PRJNA1086823_P_NODE_6941_length_311_cov_3.710084_g6824_i0	PRJNA1086823	6941	311	3.710084	11.53836124	Spirochaetes bacterium ADurb.Bin218	1852906	Bacteria	Bacteria	76.3	3.22e-14	NR	OQA94110.1	1852906	g6824	i0	55.4	0.540192926045016	56	25	54	0	141	308	68	123	OQA94110.1 MAG: DNA primase [Spirochaetes bacterium ADurb.Bin218]	diamond	168	76.3	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium ADurb.Bin218
27888662	27888662	PRJNA1086823_P_NODE_6485_length_320_cov_2.226721_g6368_i0	PRJNA1086823	6485	320	2.226721	7.1255072	Spirochaetia bacterium	2053615	Bacteria	Bacteria	85.1	4.8e-18	NR	NBU99643.1	2053615	g6368	i0	48.9	0.8625	92	38	77.8	2	6	254	87	178	NBU99643.1 hypothetical protein [Spirochaetia bacterium]	diamond	276	85.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28046609	28046609	PRJNA1086823_P_NODE_3065_length_436_cov_2.677686_g2948_i0	PRJNA1086823	3065	436	2.677686	11.67471096	Spirochaetota bacterium	2202144	Bacteria	Bacteria	119	3.42e-31	NR	HNR90762.1	2202144	g2948	i0	47.9	0.832568807339449	121	61	83.3	1	395	33	4	122	HNR90762.1 hypothetical protein [Spirochaetota bacterium]	diamond	363	119	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31078713	31078713	PRJNA1086823_P_NODE_12095_length_253_cov_0.866667_g11978_i0	PRJNA1086823	12095	253	0.866667	2.19266751	Spirochaetales bacterium	2026792	Bacteria	Bacteria	43.5	0.0223	NR	MBE7440161.1	2026792	g11978	i0	35.8	0.960474308300395	81	49	94.9	2	250	11	190	268	MBE7440161.1 dihydrolipoyl dehydrogenase [Spirochaetales bacterium]	diamond	243	43.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31299795	31299795	PRJNA1086823_P_NODE_16835_length_245_cov_2.180233_g16718_i0	PRJNA1086823	16835	245	2.180233	5.34157085	Spirochaetia bacterium	2053615	Bacteria	Bacteria	51.6	3.34e-6	NR	NBU98508.1	2053615	g16718	i0	77.8	0.661224489795918	27	6	33.1	0	2	82	75	101	NBU98508.1 hypothetical protein [Spirochaetia bacterium]	diamond	162	51.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31900817	31900817	PRJNA1086823_P_NODE_7377_length_303_cov_1.556522_g7260_i0	PRJNA1086823	7377	303	1.556522	4.71626166	Spirochaetia bacterium	2053615	Bacteria	Bacteria	48.9	6.38e-5	NR	NBU99834.1	2053615	g7260	i0	65.7	0.693069306930693	35	12	34.7	0	105	1	2	36	NBU99834.1 hypothetical protein [Spirochaetia bacterium]	diamond	210	48.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32280731	32280731	PRJNA1086823_P_NODE_18919_length_242_cov_0.923077_g18802_i0	PRJNA1086823	18919	242	0.923077	2.23384634	Spirochaetota bacterium	2202144	Bacteria	Bacteria	119	2.76e-29	NR	MBN1531750.1	2202144	g18802	i0	76.6	0.954545454545455	77	18	95.5	0	236	6	29	105	MBN1531750.1 DUF115 domain-containing protein [Spirochaetota bacterium]	diamond	231	119	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;