metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
1561842	1561842	PRJNA1144090_P_NODE_34202_length_445_cov_4.540323_g33667_i0	PRJNA1144090	34202	445	4.540323	20.20443735	Thiospirochaeta perfilievii	252967	Bacteria	Bacteria	219	4.01e-52	NTclustered	gi\|1735508175\|gb\|CP035807.1\|	252967	g33667	i0	78.723	62.038202247191	329	68	74	2	118	445	580066	579739	Thiospirochaeta perfilievii strain P chromosome, complete genome	blastn	27607	219	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Thiospirochaeta	Thiospirochaeta perfilievii
5390654	5390654	PRJNA1144090_P_NODE_56225_length_339_cov_1.466165_g55690_i0	PRJNA1144090	56225	339	1.466165	4.97029935	Entomospira entomophila	2719988	Bacteria	Bacteria	65.8	4.11e-6	NTclustered	gi\|2446642546\|gb\|CP118174.1\|	2719988	g55690	i0	95.122	0.12094395280236	41	2	12	0	35	75	107783	107743	Entomospira entomophila strain BR193 chromosome	blastn	41	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Entomospira	Entomospira entomophila
12511763	12511763	PRJNA1144090_P_NODE_96510_length_255_cov_1.203297_g95975_i0	PRJNA1144090	96510	255	1.203297	3.06840735	Borreliella	64895	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2561334454\|gb\|CP116883.1\|	62088	g95975	i0	100	0.43921568627451	28	0	11	0	167	194	13953	13980	Borreliella valaisiana strain 89B13 plasmid p_lp36, complete sequence	blastn	112	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella valaisiana
15590312	15590312	PRJNA1144090_P_NODE_53633_length_347_cov_4.675182_g53098_i0	PRJNA1144090	53633	347	4.675182	16.22288154	Spirochaetia bacterium	2053615	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2621700913\|emb\|OY759747.1\|	2053615	g53098	i0	100	0.0806916426512968	28	0	8	0	79	106	2846437	2846410	MAG: Spirochaetia bacterium isolate 029c9a96-c795-42b2-9c0d-59f5314b817a genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
20689405	20689405	PRJNA1144090_P_NODE_98717_length_251_cov_2.280899_g98182_i0	PRJNA1144090	98717	251	2.280899	5.72505649	Brachyspira intermedia	84377	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g98182	i0	100	0.111553784860558	28	0	11	0	218	245	1324487	1324514	Brachyspira intermedia PWS/A, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia

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