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

12 rows where bioproject = "PRJNA193544", 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
365871	365871	PRJNA193544_S_NODE_1761_length_201_cov_377.488372_g1746_i0	PRJNA193544	1761	201	377.488372	758.75162772	Spirochaeta aurantia	147	Bacteria	Bacteria	235	1.62e-57	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1746	i0	95.27	205.233830845771	148	7	74	0	52	199	3508	3361	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	41252	235	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
365875	365875	PRJNA193544_S_NODE_201_length_398_cov_12.878049_g186_i0	PRJNA193544	201	398	12.878049	51.25463502	Spirochaeta aurantia	147	Bacteria	Bacteria	468	3.19e-127	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g186	i0	90.909	265.168341708543	352	26	88	6	49	398	2555	2208	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	105537	468	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
1640688	1640688	PRJNA193544_S_NODE_362_length_344_cov_72.368254_g347_i0	PRJNA193544	362	344	72.368254	248.94679376	Spirochaeta aurantia	147	Bacteria	Bacteria	586	7.209999999999997e-163	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g347	i0	97.384	307.537790697674	344	9	100	0	1	344	2466	2809	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	105793	586	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
4192990	4192990	PRJNA193544_S_NODE_2804_length_165_cov_2.867647_g2789_i0	PRJNA193544	2804	165	2.867647	4.73161755	Spirochaetia bacterium	2053615	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2891483193\|emb\|OZ220223.1\|	2053615	g2789	i0	90.698	0.521212121212121	43	3	26	1	87	129	1056688	1056647	MAG: Spirochaetia bacterium isolate 03e4f5d5-dacf-4468-93a7-e7b19fb300a1 genome assembly, chromosome: 2	blastn	86	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
5469229	5469229	PRJNA193544_S_NODE_245_length_376_cov_16.605187_g230_i0	PRJNA193544	245	376	16.605187	62.43550312	Spirochaeta aurantia	147	Bacteria	Bacteria	420	8.519999999999998e-113	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g230	i0	87.634	130.369680851064	372	32	98	12	1	368	3985	3624	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	49019	420	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
9293984	9293984	PRJNA193544_S_NODE_2668_length_169_cov_10.135714_g2653_i0	PRJNA193544	2668	169	10.135714	17.12935666	Leptospira cinconiae	3235173	Bacteria	Bacteria	84.2	5e-12	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g2653	i0	76.163	2.30177514792899	172	34	100	6	1	169	754099	754266	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	389	84.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
13808652	13808652	PRJNA193544_S_NODE_2171_length_184_cov_23672.445161_g2156_i0	PRJNA193544	2171	184	23672.445161	43557.29909624	Bacteria	2	Bacteria	Bacteria	139	1.17e-28	NTclustered	gi\|2621703426\|emb\|OY760686.1\|	2202144	g2156	i0	83.019	449.695652173913	159	22	84	5	30	184	2084	2241	MAG: Spirochaetota bacterium isolate b615e79e-4617-45ea-95f9-f7a736470f88 genome assembly, chromosome: 1	blastn	82744	139	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
14394971	14394971	PRJNA193544_S_NODE_2072_length_188_cov_24367.622642_g2057_i0	PRJNA193544	2072	188	24367.622642	45811.13056696	Spirochaeta aurantia	147	Bacteria	Bacteria	217	5.4e-52	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g2057	i0	94.928	291.446808510638	138	7	73	0	31	168	3194	3057	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	54792	217	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
18906705	18906705	PRJNA193544_S_NODE_775_length_276_cov_2535.566802_g760_i0	PRJNA193544	775	276	2535.566802	6998.16437352	Turneriella	338321	Bacteria	Bacteria	366	7.98e-97	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g760	i0	94.894	3.66666666666667	235	11	85	1	1	234	255	489	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	1012	368	0.994565217391304	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
19491862	19491862	PRJNA193544_S_NODE_1456_length_215_cov_19805.129032_g1441_i0	PRJNA193544	1456	215	19805.129032	42581.0274188	Spirochaeta aurantia	147	Bacteria	Bacteria	342	9.999999999999999e-90	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1441	i0	100	124.074418604651	185	0	86	0	31	215	2964	2780	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	26676	342	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
19491908	19491908	PRJNA193544_S_NODE_736_length_281_cov_15513.293651_g721_i0	PRJNA193544	736	281	15513.293651	43592.35515931	Turneriella parva	29510	Bacteria	Bacteria	169	2.4699999999999997e-37	NTclustered	gi\|390609540\|gb\|CP002959.1\|	869212	g721	i0	100	30.3807829181495	91	0	33	0	158	248	2844746	2844836	Turneriella parva DSM 21527, complete genome	blastn	8537	169	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
20767446	20767446	PRJNA193544_S_NODE_817_length_270_cov_16311.385892_g802_i0	PRJNA193544	817	270	16311.385892	44040.7419084	Spirochaeta aurantia	147	Bacteria	Bacteria	333	7.8899999999999995e-87	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g802	i0	91.983	133.592592592593	237	19	88	0	34	270	4741	4505	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	36070	333	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia

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