metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA940501" 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
920812	920812	PRJNA940501_S_NODE_353021_length_157_cov_1.236842_g352203_i0	PRJNA940501	353021	157	1.236842	1.94184194	Treponema rectale	744512	Bacteria	Bacteria	147	5.78e-31	NTclustered	gi\|1919550644\|gb\|CP031517.1\|	744512	g352203	i0	83.439	1	157	26	100	0	1	157	1269446	1269290	Treponema rectale strain CHPA chromosome, complete genome	blastn	157	147	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema rectale
6023440	6023440	PRJNA940501_S_NODE_292325_length_169_cov_1.119048_g291507_i0	PRJNA940501	292325	169	1.119048	1.89119112	Brachyspira pilosicoli	52584	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|404429427\|emb\|HE793032.1\|	1161918	g291507	i0	91.892	0.218934911242604	37	3	22	0	79	115	2815687	2815723	Brachyspira pilosicoli WesB complete genome	blastn	37	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
9846153	9846153	PRJNA940501_S_NODE_141388_length_215_cov_2.075581_g140570_i0	PRJNA940501	141388	215	2.075581	4.46249915	Treponema succinifaciens	167	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|328447254\|gb\|CP002631.1\|	869209	g140570	i0	98.14	2	215	4	100	0	1	215	1740372	1740586	Treponema succinifaciens DSM 2489, complete genome	blastn	430	375	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema succinifaciens
9846506	9846506	PRJNA940501_S_NODE_162768_length_206_cov_1.595092_g161950_i0	PRJNA940501	162768	206	1.595092	3.28588952	Treponema bryantii	163	Bacteria	Bacteria	58.4	3.87e-4	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g161950	i0	100	0.150485436893204	31	0	15	0	82	112	2322952	2322982	Treponema bryantii JCM 32280 DNA, complete genome	blastn	31	58.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
16560136	16560136	PRJNA940501_S_NODE_204233_length_191_cov_25.108108_g203415_i0	PRJNA940501	204233	191	25.108108	47.95648628	Borrelia	138	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g203415	i0	100	0.293193717277487	28	0	15	0	40	67	11655	11682	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
16560405	16560405	PRJNA940501_S_NODE_260713_length_176_cov_1.413534_g259895_i0	PRJNA940501	260713	176	1.413534	2.48781984	Leptospira	171	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1464599676\|gb\|CP030142.1\|	1137606	g259895	i0	100	0.795454545454545	28	0	16	0	6	33	352889	352862	Leptospira mayottensis strain VS2413 chromosome I, complete sequence	blastn	140	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mayottensis
21660732	21660732	PRJNA940501_S_NODE_78077_length_254_cov_2.227488_g77259_i0	PRJNA940501	78077	254	2.227488	5.65781952	Treponema	157	Bacteria	Bacteria	429	9.119999999999999e-116	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g77259	i0	97.244	194.07874015748	254	6	100	1	1	254	2079449	2079701	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	49296	429	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
22596875	22596875	PRJNA940501_S_NODE_261298_length_176_cov_1.330827_g260480_i0	PRJNA940501	261298	176	1.330827	2.34225552	Treponema peruense	2787628	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1946838279\|gb\|CP064936.1\|	2787628	g260480	i0	100	0.159090909090909	28	0	16	0	63	90	265934	265907	Treponema peruense strain RCC2812 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema peruense
22935570	22935570	PRJNA940501_S_NODE_233758_length_183_cov_1.342857_g232940_i0	PRJNA940501	233758	183	1.342857	2.45742831	Treponema	157	Bacteria	Bacteria	333	4.97e-87	NTclustered	gi\|3132611\|gb\|AF061347.1\|AF061347	76133	g232940	i0	99.454	104.098360655738	183	1	100	0	1	183	264	82	Treponema sp. I:Q:AT20 16S ribosomal RNA gene, complete sequence	blastn	19050	333	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. I:Q:AT20

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