metadata: contig_metadata: 12 rows where bioproject = "PRJNA642647" and tax

12 rows where bioproject = "PRJNA642647" 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
4986900	4986900	PRJNA642647_P_NODE_2324_length_226_cov_1.566138_g2274_i0	PRJNA642647	2324	226	1.566138	3.53947188	Turneriella	338321	Bacteria	Bacteria	364	2.2699999999999992e-96	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g2274	i0	96	514.230088495575	225	8	99	1	3	226	1058	834	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	116216	364	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
7536467	7536467	PRJNA642647_P_NODE_4486_length_171_cov_3.835821_g4436_i0	PRJNA642647	4486	171	3.835821	6.55925391	Turneriella	338321	Bacteria	Bacteria	294	2.16e-75	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g4436	i0	98.225	183.520467836257	169	2	98	1	3	170	2100	2268	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	31382	294	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
15920851	15920851	PRJNA642647_P_NODE_3473_length_190_cov_1.692810_g3423_i0	PRJNA642647	3473	190	1.69281	3.216339	Spirochaetota bacterium	2202144	Bacteria	Bacteria	119	1.59e-22	NTclustered	gi\|2621703426\|emb\|OY760686.1\|	2202144	g3423	i0	78.462	101.226315789474	195	32	100	10	1	190	1825	2014	MAG: Spirochaetota bacterium isolate b615e79e-4617-45ea-95f9-f7a736470f88 genome assembly, chromosome: 1	blastn	19233	119	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
26954518	26954518	PRJNA642647_P_NODE_6562_length_151_cov_1.342105_g6512_i0	PRJNA642647	6562	151	1.342105	2.02657855	Turneriella sp.	2717305	Bacteria	Bacteria	44.3	0.002	NR	HNJ67394.1	2717305	g6512	i0	50	0.913907284768212	46	23	91.4	0	148	11	49	94	HNJ67394.1 siphovirus Gp157 family protein [Turneriella sp.]	diamond	138	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella sp.
27618489	27618489	PRJNA642647_P_NODE_3884_length_182_cov_1.903448_g3834_i0	PRJNA642647	3884	182	1.903448	3.46427536	Spirochaetota bacterium	2202144	Bacteria	Bacteria	40	0.0298	NR	TXH08899.1	2202144	g3834	i0	42.4	0.972527472527473	59	34	97.3	0	179	3	9	67	TXH08899.1 MAG: hypothetical protein E6R04_09835 [Spirochaetota bacterium]	diamond	177	40	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27681839	27681839	PRJNA642647_P_NODE_5284_length_165_cov_2.828125_g5234_i0	PRJNA642647	5284	165	2.828125	4.66640625	Spirochaetia bacterium	2053615	Bacteria	Bacteria	41.6	0.0143	NR	NCC91549.1	2053615	g5234	i0	66.7	1.30909090909091	24	8	43.6	0	92	163	87	110	NCC91549.1 hypothetical protein [Spirochaetia bacterium]	diamond	216	41.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
28976132	28976132	PRJNA642647_P_NODE_4088_length_178_cov_2.418440_g4038_i0	PRJNA642647	4088	178	2.41844	4.3048232	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	62	1.18e-10	NR	MBK8396134.1	2026757	g4038	i0	62.5	0.808988764044944	48	17	79.2	1	32	172	32	79	MBK8396134.1 hypothetical protein [Leptospiraceae bacterium]	diamond	144	62	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29670298	29670298	PRJNA642647_P_NODE_3830_length_183_cov_1.746575_g3780_i0	PRJNA642647	3830	183	1.746575	3.19623225	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.5	0.00917	NR	TXH10007.1	2202144	g3780	i0	60.7	0.901639344262295	28	11	45.9	0	4	87	409	436	TXH10007.1 MAG: hypothetical protein E6R04_06540 [Spirochaetota bacterium]	diamond	165	43.5	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29954924	29954924	PRJNA642647_P_NODE_3831_length_183_cov_1.691781_g3781_i0	PRJNA642647	3831	183	1.691781	3.09595923	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	44.3	0.00499	NR	MCY4372447.1	1898206	g3781	i0	41.2	1.70491803278689	51	28	83.6	1	168	16	641	689	MCY4372447.1 hypothetical protein [Spirochaetaceae bacterium]	diamond	312	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30441245	30441245	PRJNA642647_P_NODE_5913_length_157_cov_1.041667_g5863_i0	PRJNA642647	5913	157	1.041667	1.63541719	root	1	Root_unresolved	Root_unresolved	94.7	4.6800000000000005e-21	NR	HMW08365.1	2026757	g5863	i0	84.3	2.92356687898089	51	8	97.5	0	2	154	376	426	HMW08365.1 baseplate J/gp47 family protein [Leptospiraceae bacterium]	diamond	459	94.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30902797	30902797	PRJNA642647_P_NODE_1414_length_294_cov_2.206226_g1364_i0	PRJNA642647	1414	294	2.206226	6.48630444	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	91.3	5.4e-21	NR	MBK7056569.1	2026757	g1364	i0	52.9	1.93877551020408	85	35	86.7	1	256	2	29	108	MBK7056569.1 single-stranded DNA-binding protein [Leptospiraceae bacterium]	diamond	570	91.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32685568	32685568	PRJNA642647_P_NODE_2880_length_206_cov_1.301775_g2830_i0	PRJNA642647	2880	206	1.301775	2.6816565	root	1	Root_unresolved	Root_unresolved	70.1	1.57e-12	NR	MBQ1948735.1	166	g2830	i0	53.1	2.79611650485437	64	30	93.2	0	203	12	74	137	MBQ1948735.1 DUF2184 domain-containing protein [Treponema sp.]	diamond	576	70.5	0.994326241134752	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.

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