metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
3563774	3563774	PRJNA1067370_P_NODE_16763_length_454_cov_1.572178_g16215_i0	PRJNA1067370	16763	454	1.572178	7.13768812	Spirochaeta	146	Bacteria	Bacteria	512	1.68e-140	NTclustered	gi\|507148391\|ref\|NR_103194.1\|	46355	g16215	i0	87.033	611.057268722467	455	57	99	2	1	453	2074	2528	Spirochaeta africana strain Z-7692 23S ribosomal RNA gene, complete sequence	blastn	277420	516	0.992248062015504	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta africana
6559193	6559193	PRJNA1067370_S_NODE_1746_length_379_cov_2.039216_g1720_i0	PRJNA1067370	1746	379	2.039216	7.72862864	Treponema parvum	138851	Bacteria	Bacteria	346	1.4799999999999999e-90	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g1720	i0	83.377	161.290237467018	385	52	100	11	1	379	1517776	1518154	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	61129	346	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
7833622	7833622	PRJNA1067370_P_NODE_78007_length_253_cov_0.977778_g77458_i0	PRJNA1067370	78007	253	0.977778	2.47377834	Spirochaetia bacterium	2053615	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|2891483193\|emb\|OZ220223.1\|	2053615	g77458	i0	82.946	136.158102766798	258	32	99	11	1	252	1056274	1056525	MAG: Spirochaetia bacterium isolate 03e4f5d5-dacf-4468-93a7-e7b19fb300a1 genome assembly, chromosome: 2	blastn	34448	222	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
9108582	9108582	PRJNA1067370_P_NODE_65988_length_271_cov_0.984848_g65439_i0	PRJNA1067370	65988	271	0.984848	2.66893808	Breznakiella homolactica	2798577	Bacteria	Bacteria	339	1.7e-88	NTclustered	gi\|2093987262\|gb\|CP067089.2\|	2798577	g65439	i0	89.299	168.708487084871	271	27	99	2	1	270	9825	9556	Breznakiella homolactica strain RmG30 chromosome, complete genome	blastn	45720	339	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Breznakiella	Breznakiella homolactica
12934676	12934676	PRJNA1067370_P_NODE_54171_length_289_cov_0.893519_g53622_i0	PRJNA1067370	54171	289	0.893519	2.58226991	Treponemataceae bacterium	2854022	Bacteria	Bacteria	473	4.819999999999999e-129	NTclustered	gi\|2814788384\|emb\|OY762953.2\|	2854022	g53622	i0	96.194	193.813148788927	289	11	100	0	1	289	1491109	1490821	MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1	blastn	56012	473	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
15483539	15483539	PRJNA1067370_P_NODE_29913_length_356_cov_1.074205_g29365_i0	PRJNA1067370	29913	356	1.074205	3.8241698	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	320	8.369999999999998e-83	NTclustered	gi\|2621785415\|emb\|OY781873.1\|	886478	g29365	i0	83.106	168.63202247191	367	46	100	16	1	356	1914515	1914154	MAG: uncultured Sphaerochaeta sp. isolate d3c3752c-658c-4035-93a5-350d78b9f8a8 genome assembly, chromosome: 1	blastn	60033	320	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
15483604	15483604	PRJNA1067370_P_NODE_39353_length_321_cov_1.387097_g38805_i0	PRJNA1067370	39353	321	1.387097	4.45258137	Brachyspira hampsonii	1287055	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1214564172\|gb\|CP019914.1\|	1287055	g38805	i0	88.372	0.133956386292835	43	5	13	0	9	51	1999824	1999782	Brachyspira hampsonii strain NSH-16 chromosome, complete genome	blastn	43	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hampsonii
15483742	15483742	PRJNA1067370_P_NODE_62013_length_277_cov_1.039216_g61464_i0	PRJNA1067370	62013	277	1.039216	2.87862832	Treponemataceae bacterium	2854022	Bacteria	Bacteria	390	4.749999999999999e-104	NTclustered	gi\|2814788384\|emb\|OY762953.2\|	2854022	g61464	i0	92.115	119.176895306859	279	19	100	2	1	277	1490252	1489975	MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1	blastn	33012	390	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
16757987	16757987	PRJNA1067370_P_NODE_73714_length_259_cov_1.451613_g73165_i0	PRJNA1067370	73714	259	1.451613	3.75967767	Treponema medium	58231	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g73165	i0	100	193.888030888031	259	0	100	0	1	259	1012718	1012976	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	50217	479	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
16758059	16758059	PRJNA1067370_P_NODE_84614_length_250_cov_0.870056_g84065_i0	PRJNA1067370	84614	250	0.870056	2.17514	Spirochaetia bacterium	2053615	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2621706806\|emb\|OY764868.1\|	2053615	g84065	i0	100	0.112	28	0	11	0	119	146	461772	461745	MAG: Spirochaetia bacterium isolate 011fa16d-6e6a-4572-b8a7-e5a7f8581680 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
18032603	18032603	PRJNA1067370_P_NODE_44495_length_310_cov_2.223629_g43947_i0	PRJNA1067370	44495	310	2.223629	6.8932499	Borreliella tanukii	56146	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2918227553\|gb\|CP179589.1\|	56146	g43947	i0	90.476	0.135483870967742	42	1	13	3	259	297	25025	24984	Borreliella tanukii strain TanegashimaAS13 plasmid lp36, complete sequence	blastn	42	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella tanukii
19306495	19306495	PRJNA1067370_P_NODE_4396_length_836_cov_2.318480_g3923_i0	PRJNA1067370	4396	836	2.31848	19.3824928	Salinispira pacifica	1307761	Bacteria	Bacteria	852	0	NTclustered	gi\|565679415\|gb\|CP006939.1\|	1307761	g3923	i0	85.34	237.864832535885	839	106	99	12	4	835	385017	385845	Salinispira pacifica strain L21-RPul-D2, complete genome	blastn	198855	852	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Salinispira	Salinispira pacifica
21415235	21415235	PRJNA1067370_P_NODE_32277_length_346_cov_1.358974_g31729_i0	PRJNA1067370	32277	346	1.358974	4.70205004	Treponema	157	Bacteria	Bacteria	640	5.4999999999999996e-179	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g31729	i0	100	194.060693641618	346	0	100	0	1	346	1014721	1015066	Treponema medium strain T19 chromosome, complete genome	blastn	67145	640	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium

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