metadata: contig_metadata: 10 rows where bioproject = "PRJNA527965" and tax

10 rows where bioproject = "PRJNA527965" 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
496867	496867	PRJNA527965_S_NODE_1_length_2687_cov_15.765083_g0_i0	PRJNA527965	1	2687	15.765083	423.60778021	Spirochaetota bacterium	2202144	Bacteria	Bacteria	171	7.38e-37	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g0	i0	84.27	14.4216598436918	178	25	7	3	1923	2098	74373	74549	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	38751	171	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
6874601	6874601	PRJNA527965_S_NODE_726_length_413_cov_168.711640_g643_i0	PRJNA527965	726	413	168.71164	696.7790732	Spirochaeta aurantia	147	Bacteria	Bacteria	616	1.1199999999999996e-171	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g643	i0	93.51	95.0338983050847	416	23	100	4	1	413	3522	3936	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	39249	616	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
10700897	10700897	PRJNA527965_S_NODE_5089_length_166_cov_2.137405_g5006_i0	PRJNA527965	5089	166	2.1374050000000002	3.5480923	Spirochaeta aurantia	147	Bacteria	Bacteria	207	2.8e-49	NTclustered	gi\|40074290\|gb\|AY487827.1\|	555314	g5006	i0	89.286	3.03012048192771	168	14	100	4	1	166	746	911	Spirochaeta aurantia 16S ribosomal RNA gene, partial sequence; tRNA-Ala gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	503	207	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
10700901	10700901	PRJNA527965_S_NODE_5249_length_163_cov_3.109375_g5166_i0	PRJNA527965	5249	163	3.109375	5.06828125	Spirochaeta aurantia	147	Bacteria	Bacteria	252	1.25e-62	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g5166	i0	94.479	43.9386503067485	163	9	100	0	1	163	2014	2176	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	7162	252	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
17074231	17074231	PRJNA527965_S_NODE_6134_length_151_cov_7.750000_g6051_i0	PRJNA527965	6134	151	7.75	11.7025	Spirochaeta aurantia	147	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g6051	i0	100	151.086092715232	151	0	100	0	1	151	4112	3962	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	22814	279	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
20898998	20898998	PRJNA527965_S_NODE_2977_length_221_cov_3.596774_g2894_i0	PRJNA527965	2977	221	3.596774	7.94887054	Spirochaeta aurantia	147	Bacteria	Bacteria	375	1.0199999999999998e-99	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g2894	i0	97.706	141.877828054299	218	5	99	0	1	218	3274	3057	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	31355	375	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
21516257	21516257	PRJNA527965_S_NODE_1437_length_319_cov_16.443662_g1354_i0	PRJNA527965	1437	319	16.443662	52.45528178	Spirochaetia	203692	Bacteria	Bacteria	361	4.38e-95	NTclustered	gi\|110264527\|gb\|DQ522190.1\|	173	g1354	i0	90.741	98.4545454545455	270	25	85	0	50	319	517	786	Leptospira interrogans clone BEL08MA_1 16S ribosomal RNA gene, partial sequence	blastn	31407	361	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
22791412	22791412	PRJNA527965_S_NODE_2378_length_250_cov_2.897674_g2295_i0	PRJNA527965	2378	250	2.897674	7.244185	Treponema	157	Bacteria	Bacteria	252	2.08e-62	NTclustered	gi\|1732601887\|gb\|CP042818.1\|	162	g2295	i0	85.2	192.304	250	32	99	5	3	250	2502861	2503107	Treponema phagedenis strain B43.1 chromosome, complete genome	blastn	48076	252	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
23449222	23449222	PRJNA527965_S_NODE_1979_length_278_cov_5.650206_g1896_i0	PRJNA527965	1979	278	5.650206	15.70757268	Spirochaeta aurantia	147	Bacteria	Bacteria	294	3.85e-75	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g1896	i0	89.831	299.111510791367	236	15	83	7	1	231	2531	2300	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	83153	294	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
23449319	23449319	PRJNA527965_S_NODE_779_length_402_cov_30.258856_g696_i0	PRJNA527965	779	402	30.258856	121.64060112	Spirochaeta aurantia	147	Bacteria	Bacteria	603	8.479999999999998e-168	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g696	i0	93.827	305.778606965174	405	18	99	6	2	402	3113	2712	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	122923	603	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);;