metadata: contig_metadata: 12 rows where bioproject = "PRJNA1115053", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA1115053", 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
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
26719449	26719449	PRJNA1115053_S_NODE_51061_length_334_cov_2.903780_g49244_i0	PRJNA1115053	51061	334	2.90378	9.6986252	Spirochaetia bacterium	2053615	Bacteria	Bacteria	119	5.829999999999999e-31	NR	NBK26405.1	2053615	g49244	i0	76.4	0.646706586826347	72	17	64.7	0	218	3	136	207	NBK26405.1 hypothetical protein [Spirochaetia bacterium]	diamond	216	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29806216	29806216	PRJNA1115053_S_NODE_238411_length_179_cov_2.117647_g236594_i0	PRJNA1115053	238411	179	2.117647	3.79058813	root	1	Root_unresolved	Root_unresolved	46.2	1.5e-4	NR	WP_085169531.1	159	g236594	i0	56.4	3.92178770949721	39	17	65.4	0	117	1	9	47	WP_085169531.1 hypothetical protein [Brachyspira hyodysenteriae]	diamond	702	46.6	0.991416309012876	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
30130837	30130837	PRJNA1115053_S_NODE_251712_length_175_cov_1.454545_g249895_i0	PRJNA1115053	251712	175	1.454545	2.54545375	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	113	4.709999999999999e-31	NR	MBQ3024078.1	1898206	g249895	i0	90.9	2.79428571428571	55	5	94.3	0	173	9	36	90	MBQ3024078.1 type II toxin-antitoxin system YafQ family toxin [Spirochaetaceae bacterium]	diamond	489	113	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30225922	30225922	PRJNA1115053_S_NODE_117052_length_243_cov_2.220000_g115235_i0	PRJNA1115053	117052	243	2.22	5.3946	Treponema sp.	166	Bacteria	Bacteria	143	4.24e-39	NR	MBS7265401.1	166	g115235	i0	97.3	1.80246913580247	73	2	90.1	0	1	219	153	225	MBS7265401.1 HD domain-containing protein [Treponema sp.]	diamond	438	143	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31702548	31702548	PRJNA1115053_S_NODE_268477_length_170_cov_1.251969_g266660_i0	PRJNA1115053	268477	170	1.251969	2.1283473	Treponema	157	Bacteria	Bacteria	89	2.84e-19	NR	MBQ1175357.1	166	g266660	i0	97.7	4.55294117647059	43	1	75.9	0	2	130	226	268	MBQ1175357.1 FprA family A-type flavoprotein [Treponema sp.]	diamond	774	89	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32817637	32817637	PRJNA1115053_S_NODE_245980_length_177_cov_1.074627_g244163_i0	PRJNA1115053	245980	177	1.074627	1.90208979	Treponema sp.	166	Bacteria	Bacteria	67.4	1.48e-12	NR	MBQ5906919.1	166	g244163	i0	100	0.525423728813559	31	0	52.5	0	85	177	1	31	MBQ5906919.1 helix-turn-helix transcriptional regulator [Treponema sp.]	diamond	93	67.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema 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);;