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

10 rows where analysis = "blastn", bioproject = "PRJNA666695" 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
1908437	1908437	PRJNA666695_S_NODE_37222_length_329_cov_1.475694_g36128_i0	PRJNA666695	37222	329	1.475694	4.85503326	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2621786047\|emb\|OY782505.1\|	2791017	g36128	i0	100	0.0851063829787234	28	0	9	0	150	177	794950	794977	MAG: Sphaerochaetaceae bacterium isolate dbdf49c1-f841-4570-9102-cd3a9ce64f89 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
6266269	6266269	PRJNA666695_S_NODE_110945_length_209_cov_1.642857_g109851_i0	PRJNA666695	110945	209	1.642857	3.43357113	Leptospira	171	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2197053765\|gb\|CP092157.1\|	173	g109851	i0	94.118	12.0334928229665	34	2	16	0	45	78	101950	101917	Leptospira interrogans strain FMAS_AP6 chromosome 2, complete sequence	blastn	2515	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
8285154	8285154	PRJNA666695_S_NODE_24807_length_382_cov_6.090909_g23714_i0	PRJNA666695	24807	382	6.090909	23.26727238	Borrelia persica	44448	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|308922591\|gb\|HM131216.1\|	44448	g23714	i0	100	0.0732984293193717	28	0	7	0	170	197	5037	5010	Borrelia persica strain HL2610 23S ribosomal RNA (rrlA) gene, partial sequence; hydrolase, hypoxanthine phosphoribosyltransferase (hpt), adenylosuccinate synthase (purA), adenylosuccinate lyase (purB), and 3-methyladenine DNA glycosylase (mag) genes, complete cds; and tRNA-Ile (ileT), tRNA-Ala (alaT), and 16S ribosomal RNA (rrs) genes, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia persica
10834565	10834565	PRJNA666695_S_NODE_124629_length_197_cov_1.179487_g123535_i0	PRJNA666695	124629	197	1.179487	2.32358939	Borreliella garinii	29519	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2371376074\|gb\|CP075225.1\|	29519	g123535	i0	100	0.152284263959391	30	0	15	0	117	146	263444	263415	Borreliella garinii strain JAASAAM1103 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
17208594	17208594	PRJNA666695_S_NODE_130654_length_192_cov_1.523179_g129560_i0	PRJNA666695	130654	192	1.523179	2.92450368	Borreliella spielmanii	88916	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2537422926\|gb\|CP124042.1\|	88916	g129560	i0	96.875	0.166666666666667	32	1	17	0	83	114	750682	750651	Borreliella spielmanii strain Pmew chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella spielmanii
19014504	19014504	PRJNA666695_S_NODE_22655_length_395_cov_12.870056_g21562_i0	PRJNA666695	22655	395	12.870056	50.8367212	Leptospira	171	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2891609709\|gb\|CP130638.1\|	173	g21562	i0	90.698	4.34177215189873	43	2	11	2	331	373	1007585	1007545	Leptospira interrogans strain Mankarso chromosome I, complete sequence	blastn	1715	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
19760423	19760423	PRJNA666695_S_NODE_91196_length_229_cov_2.750000_g90102_i0	PRJNA666695	91196	229	2.75	6.2975	Brachyspira murdochii	84378	Bacteria	Bacteria	71.3	5.64e-8	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g90102	i0	100	0.331877729257642	38	0	17	0	192	229	3174533	3174496	Brachyspira murdochii DSM 12563, complete genome	blastn	76	71.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
21035872	21035872	PRJNA666695_S_NODE_85837_length_235_cov_3.716495_g84743_i0	PRJNA666695	85837	235	3.716495	8.73376325	Brachyspira intermedia	84377	Bacteria	Bacteria	73.1	1.62e-8	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g84743	i0	77.519	0.548936170212766	129	23	54	6	107	232	2582460	2582335	Brachyspira intermedia PWS/A, complete genome	blastn	129	73.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
21565036	21565036	PRJNA666695_S_NODE_38097_length_326_cov_1.950877_g37003_i0	PRJNA666695	38097	326	1.950877	6.35985902	Borrelia	138	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2111391439\|gb\|CP084623.1\|	140	g37003	i0	100	0.773006134969325	28	0	9	0	254	281	647994	647967	Borrelia hermsii strain ML2 chromosome, complete genome	blastn	252	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia hermsii
23582682	23582682	PRJNA666695_S_NODE_1039_length_1451_cov_48.184397_g674_i0	PRJNA666695	1039	1451	48.184397	699.15560047	Borreliella japonica	34095	Bacteria	Bacteria	110	8.71e-19	NTclustered	gi\|2537434022\|gb\|CP124062.1\|	34095	g674	i0	96.923	5.00344589937974	65	2	4	0	84	148	503407	503343	Borreliella japonica strain Miyazaki2E chromosome, complete genome	blastn	7260	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella japonica

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