metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
230429	230429	PRJNA1118794_P_NODE_19921_length_339_cov_1.496241_g19171_i0	PRJNA1118794	19921	339	1.496241	5.07225699	Spirochaeta aurantia	147	Bacteria	Bacteria	455	2.0900000000000003e-123	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g19171	i0	90.936	191.964601769911	342	26	100	5	1	339	3258	3597	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	65076	455	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
4057204	4057204	PRJNA1118794_P_NODE_16084_length_366_cov_2.614334_g15334_i0	PRJNA1118794	16084	366	2.614334	9.56846244	Spirochaeta aurantia	147	Bacteria	Bacteria	496	1.34e-135	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g15334	i0	91.257	224.967213114754	366	28	100	3	1	366	3124	3485	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	82338	496	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
6608530	6608530	PRJNA1118794_P_NODE_22306_length_326_cov_1.217391_g21556_i0	PRJNA1118794	22306	326	1.217391	3.96869466	Brachyspira intermedia	84377	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g21556	i0	100	0.0889570552147239	29	0	9	0	77	105	1081224	1081196	Brachyspira intermedia PWS/A, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
9158126	9158126	PRJNA1118794_P_NODE_12668_length_403_cov_2.012121_g11918_i0	PRJNA1118794	12668	403	2.012121	8.10884763	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	124	8.07e-24	NTclustered	gi\|2621785465\|emb\|OY781923.1\|	2791017	g11918	i0	91.304	82.7841191066997	92	6	23	2	223	313	114021	114111	MAG: Sphaerochaetaceae bacterium isolate 77f26d43-b2b0-4d0d-8c29-067165085957 genome assembly, chromosome: 1	blastn	33362	124	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
9158396	9158396	PRJNA1118794_P_NODE_33188_length_284_cov_1.426540_g32438_i0	PRJNA1118794	33188	284	1.42654	4.0513736	Brachyspira pilosicoli	52584	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|404429427\|emb\|HE793032.1\|	1161918	g32438	i0	100	0.102112676056338	29	0	10	0	185	213	1162397	1162369	Brachyspira pilosicoli WesB complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
14259580	14259580	PRJNA1118794_P_NODE_30252_length_291_cov_2.825688_g29502_i0	PRJNA1118794	30252	291	2.825688	8.22275208	Spirochaeta aurantia	147	Bacteria	Bacteria	488	1.7299999999999995e-133	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g29502	i0	96.907	155.824742268041	291	9	100	0	1	291	4875	4585	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	45345	488	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
15052624	15052624	PRJNA1118794_P_NODE_50432_length_250_cov_1.903955_g49682_i0	PRJNA1118794	50432	250	1.903955	4.7598875	Treponema	157	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g49682	i0	98.4	185.584	250	4	100	0	1	250	2079204	2078955	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	46396	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
18876553	18876553	PRJNA1118794_P_NODE_13835_length_388_cov_2.260317_g13085_i0	PRJNA1118794	13835	388	2.260317	8.77002996	Turneriella	338321	Bacteria	Bacteria	634	2.8899999999999995e-177	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g13085	i0	96.134	675.113402061856	388	15	100	0	1	388	1533	1920	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	261944	634	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
21426856	21426856	PRJNA1118794_P_NODE_10477_length_437_cov_1.250000_g9729_i0	PRJNA1118794	10477	437	1.25	5.4625	Turneriella	338321	Bacteria	Bacteria	763	0	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g9729	i0	98.169	172.903890160183	437	8	100	0	1	437	642	206	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	75559	763	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
21907567	21907567	PRJNA1118794_P_NODE_35558_length_278_cov_2.634146_g34808_i0	PRJNA1118794	35558	278	2.634146	7.32292588	Spirochaeta aurantia	147	Bacteria	Bacteria	387	6.179999999999998e-103	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g34808	i0	91.844	445.352517985611	282	15	99	8	1	277	2590	2312	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	123808	387	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);;