metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1115053" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1115053" 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
1024357	1024357	PRJNA1115053_S_NODE_238301_length_179_cov_2.338235_g236484_i0	PRJNA1115053	238301	179	2.338235	4.18544065	Brachyspira	29521	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2620055352\|gb\|CP117021.1\|	159	g236484	i0	100	0.46927374301676	28	0	16	0	52	79	2618433	2618406	Brachyspira hyodysenteriae strain ZH1179 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
5328876	5328876	PRJNA1115053_S_NODE_246385_length_177_cov_1.074627_g244568_i0	PRJNA1115053	246385	177	1.074627	1.90208979	Brucepastera parasyntrophica	2880008	Bacteria	Bacteria	58.4	3.21e-4	NTclustered	gi\|2198899484\|gb\|CP084606.1\|	2880008	g244568	i0	94.737	0.214689265536723	38	1	21	1	57	94	1855623	1855659	Brucepastera parasyntrophica strain RmG11 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Brucepastera	Brucepastera parasyntrophica
6607569	6607569	PRJNA1115053_S_NODE_80546_length_282_cov_1.807531_g78729_i0	PRJNA1115053	80546	282	1.807531	5.09723742	Treponema saccharophilum	165	Bacteria	Bacteria	58.4	5.59e-4	NTclustered	gi\|2581918939\|dbj\|AP025288.1\|	165	g78729	i0	100	10.7340425531915	31	0	11	0	46	76	1667165	1667135	Treponema saccharophilum JCM 32279 DNA, complete genome	blastn	3027	58.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema saccharophilum
15052343	15052343	PRJNA1115053_S_NODE_54912_length_325_cov_3.769504_g53095_i0	PRJNA1115053	54912	325	3.769504	12.250888	Brachyspira	29521	Bacteria	Bacteria	479	1.1799999999999993e-130	NTclustered	gi\|507148214\|ref\|NR_103021.1\|	84377	g53095	i0	93.231	118.926153846154	325	22	100	0	1	325	487	163	Brachyspira intermedia strain PWS/A 23S ribosomal RNA gene, complete sequence	blastn	38651	479	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
20151176	20151176	PRJNA1115053_S_NODE_87136_length_273_cov_53.934783_g85319_i0	PRJNA1115053	87136	273	53.934783	147.24195759	Borrelia	138	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g85319	i0	100	0.205128205128205	28	0	10	0	172	199	11682	11655	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
23177249	23177249	PRJNA1115053_S_NODE_2059_length_1117_cov_8.033520_g1372_i0	PRJNA1115053	2059	1117	8.03352	89.7344184	Spirochaetota bacterium	2202144	Bacteria	Bacteria	143	6.56e-29	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g1372	i0	81.461	13.585496866607	178	30	16	3	345	520	74373	74549	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	15175	143	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);;