metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
3805048	3805048	PRJNA928559_P_NODE_22743_length_670_cov_4.775544_g21253_i0	PRJNA928559	22743	670	4.775544	31.9961448	Turneriella	338321	Bacteria	Bacteria	1029	0	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g21253	i0	94.486	232.083582089552	671	32	99	5	1	668	775	107	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	155496	1029	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
6006112	6006112	PRJNA928559_P_NODE_16925_length_763_cov_2.694203_g15513_i0	PRJNA928559	16925	763	2.694203	20.55676889	Spirochaetota bacterium	2202144	Bacteria	Bacteria	148	9.49e-31	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g15513	i0	80.193	18.8335517693316	207	34	27	5	158	360	74345	74548	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	14370	148	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
6356877	6356877	PRJNA928559_P_NODE_175885_length_262_cov_5.021164_g174316_i0	PRJNA928559	175885	262	5.021164	13.15544968	Turneriella	338321	Bacteria	Bacteria	411	3.419999999999999e-110	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g174316	i0	95.057	149.599236641221	263	9	99	2	2	260	1214	1476	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	39195	411	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
7631096	7631096	PRJNA928559_P_NODE_217426_length_238_cov_3.903030_g215857_i0	PRJNA928559	217426	238	3.9030300000000002	9.2892114	Treponema	157	Bacteria	Bacteria	435	1.8200000000000003e-117	NTclustered	gi\|1826584176\|gb\|MT257120.1\|	162155	g215857	i0	99.58	149.794117647059	238	1	100	0	1	238	596	359	Uncultured Treponema sp. clone BOC15 23S ribosomal RNA gene, partial sequence	blastn	35651	435	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
11456575	11456575	PRJNA928559_P_NODE_170129_length_268_cov_1.333333_g168560_i0	PRJNA928559	170129	268	1.333333	3.57333244	Entomospira	2834378	Bacteria	Bacteria	158	5.05e-34	NTclustered	gi\|2446641004\|gb\|CP118168.1\|	2719987	g168560	i0	77.941	212.847014925373	272	46	99	13	1	264	323022	323287	Entomospira nematocerorum strain BR208 chromosome	blastn	57043	158	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Entomospira	Entomospira nematocerorum
12732280	12732280	PRJNA928559_P_NODE_180250_length_259_cov_1.268817_g178681_i0	PRJNA928559	180250	259	1.268817	3.28623603	Leptospira	171	Bacteria	Bacteria	169	2.24e-37	NTclustered	gi\|2777203535\|gb\|CP162142.1\|	3235171	g178681	i0	80.085	22.046332046332	236	40	90	6	21	253	2717395	2717164	Leptospira iowaensis strain WS39.C2 chromosome 1, complete sequence	blastn	5710	169	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira iowaensis
14931944	14931944	PRJNA928559_P_NODE_4072_length_1462_cov_27.092873_g3362_i0	PRJNA928559	4072	1462	27.092873	396.09780326	Spirochaetota bacterium	2202144	Bacteria	Bacteria	143	8.65e-29	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g3362	i0	81.461	10.5266757865937	178	30	12	3	653	828	74549	74373	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	15390	143	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
16205256	16205256	PRJNA928559_P_NODE_128273_length_313_cov_20.783333_g126704_i0	PRJNA928559	128273	313	20.783333	65.05183229	Borrelia turcica	229155	Bacteria	Bacteria	102	2.87e-17	NTclustered	gi\|1484376061\|gb\|CP028884.1\|	1104446	g126704	i0	86	0.603833865814696	100	8	31	6	126	222	776056	776152	Borrelia turcica IST7 chromosome, complete genome	blastn	189	102	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turcica
16555625	16555625	PRJNA928559_P_NODE_49973_length_484_cov_4.739659_g48411_i0	PRJNA928559	49973	484	4.739659	22.93994956	Turneriella	338321	Bacteria	Bacteria	833	0	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g48411	i0	98.316	246.45867768595	475	8	98	0	10	484	1211	737	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	119286	833	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
24204315	24204315	PRJNA928559_P_NODE_158239_length_279_cov_2.033981_g156670_i0	PRJNA928559	158239	279	2.033981	5.67480699	Pseudomonadati	3379134	Bacteria	Bacteria	115	3.23e-21	NTclustered	gi\|2581921758\|dbj\|AP025291.1\|	165	g156670	i0	97.059	119.530465949821	68	2	24	0	211	278	6763	6830	Treponema saccharophilum JCM 32279 plasmid pTSrrn DNA, complete genome	blastn	33349	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema saccharophilum
25130119	25130119	PRJNA928559_P_NODE_39640_length_531_cov_13.122271_g38084_i0	PRJNA928559	39640	531	13.122271	69.67925901	Spirochaetota bacterium	2202144	Bacteria	Bacteria	165	6.42e-36	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g38084	i0	83.616	44.7947269303202	177	28	33	1	356	531	74373	74549	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	23786	165	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);;