metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax_kingdom = "Thermotogati"

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
740609	740609	PRJNA758770_S_NODE_24381_length_252_cov_0.871508_g24255_i0	PRJNA758770	24381	252	0.871508	2.19620016	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g24255	i0	99.603	1	252	1	100	0	1	252	1794097	1794348	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	252	460	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
1204669	1204669	PRJNA758770_S_NODE_31581_length_243_cov_0.917647_g31455_i0	PRJNA758770	31581	243	0.917647	2.22988221	Bacteria	2	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g31455	i0	99.588	12.9753086419753	243	1	100	0	1	243	787612	787854	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	3153	444	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
2016600	2016600	PRJNA758770_S_NODE_23322_length_253_cov_0.866667_g23196_i0	PRJNA758770	23322	253	0.866667	2.19266751	Acetomicrobium mobile	97477	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g23196	i0	98.419	1	253	4	100	0	1	253	1013034	1013286	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	253	446	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
2016784	2016784	PRJNA758770_S_NODE_31542_length_243_cov_0.917647_g31416_i0	PRJNA758770	31542	243	0.917647	2.22988221	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g31416	i0	100	1	243	0	100	0	1	243	704750	704992	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	243	449	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
3291901	3291901	PRJNA758770_S_NODE_25383_length_251_cov_0.876404_g25257_i0	PRJNA758770	25383	251	0.876404	2.19977404	Acetomicrobium mobile	97477	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g25257	i0	99.203	1	251	2	100	0	1	251	1655103	1654853	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	251	453	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
3291957	3291957	PRJNA758770_S_NODE_27723_length_248_cov_0.891429_g27597_i0	PRJNA758770	27723	248	0.891429	2.21074392	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	396	9e-106	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g27597	i0	96.639	0.959677419354839	238	8	96	0	2	239	739848	740085	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	238	396	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
8393908	8393908	PRJNA758770_S_NODE_25047_length_251_cov_0.876404_g24921_i0	PRJNA758770	25047	251	0.876404	2.19977404	Acetomicrobium mobile	97477	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g24921	i0	99.571	0.928286852589641	233	1	93	0	1	233	484608	484840	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	233	425	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
8394004	8394004	PRJNA758770_S_NODE_29467_length_246_cov_0.901734_g29341_i0	PRJNA758770	29467	246	0.901734	2.21826564	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	351	1.96e-92	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g29341	i0	92.623	0.991869918699187	244	18	99	0	1	244	1632397	1632154	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	244	351	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
9669013	9669013	PRJNA758770_S_NODE_20868_length_266_cov_1.207254_g20742_i0	PRJNA758770	20868	266	1.207254	3.21129564	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	492	1.2099999999999999e-134	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g20742	i0	100	1	266	0	100	0	1	266	727226	726961	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	266	492	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
9669120	9669120	PRJNA758770_S_NODE_25768_length_250_cov_0.881356_g25642_i0	PRJNA758770	25768	250	0.881356	2.20339	Synergistaceae bacterium	2053624	Bacteria	Bacteria	344	3.34e-90	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g25642	i0	91.566	0.996	249	21	99	0	2	250	1961477	1961229	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	249	344	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
9669153	9669153	PRJNA758770_S_NODE_27028_length_249_cov_0.886364_g26902_i0	PRJNA758770	27028	249	0.886364	2.20704636	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g26902	i0	100	1	249	0	100	0	1	249	29751	29503	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	249	460	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
10944805	10944805	PRJNA758770_S_NODE_27829_length_248_cov_0.891429_g27703_i0	PRJNA758770	27829	248	0.891429	2.21074392	Acetomicrobium mobile	97477	Bacteria	Bacteria	241	4.46e-59	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g27703	i0	99.248	1.92338709677419	133	1	54	0	1	133	1744507	1744375	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	477	241	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
10944837	10944837	PRJNA758770_S_NODE_29029_length_246_cov_0.901734_g28903_i0	PRJNA758770	29029	246	0.901734	2.21826564	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	217	7.449999999999999e-52	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g28903	i0	91.25	1.47967479674797	160	13	65	1	1	160	1881028	1880870	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	364	217	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
12220324	12220324	PRJNA758770_S_NODE_26930_length_249_cov_0.886364_g26804_i0	PRJNA758770	26930	249	0.886364	2.20704636	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g26804	i0	100	1	249	0	100	0	1	249	325492	325244	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	249	460	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
12220348	12220348	PRJNA758770_S_NODE_27950_length_248_cov_0.891429_g27824_i0	PRJNA758770	27950	248	0.891429	2.21074392	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g27824	i0	99.197	1.00403225806452	249	1	100	1	1	248	890727	890975	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	249	448	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
13494409	13494409	PRJNA758770_S_NODE_25031_length_251_cov_0.876404_g24905_i0	PRJNA758770	25031	251	0.876404	2.19977404	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g24905	i0	98.805	1	251	3	100	0	1	251	208969	208719	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	251	448	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
14769550	14769550	PRJNA758770_S_NODE_26692_length_249_cov_0.886364_g26566_i0	PRJNA758770	26692	249	0.886364	2.20704636	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	318	2.0099999999999998e-82	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g26566	i0	90.204	0.983935742971888	245	23	98	1	6	249	1438528	1438284	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	245	318	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
18592216	18592216	PRJNA758770_S_NODE_20535_length_268_cov_1.174359_g20409_i0	PRJNA758770	20535	268	1.174359	3.14728212	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	479	9.499999999999996e-131	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g20409	i0	98.881	22.0037313432836	268	3	100	0	1	268	1223441	1223708	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	5897	479	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
18592302	18592302	PRJNA758770_S_NODE_24355_length_252_cov_0.871508_g24229_i0	PRJNA758770	24355	252	0.871508	2.19620016	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	226	1.2699999999999999e-54	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g24229	i0	97.015	9.12698412698413	134	4	99	0	1	134	81482	81349	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	2300	226	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
18592351	18592351	PRJNA758770_S_NODE_26395_length_249_cov_1.346591_g26269_i0	PRJNA758770	26395	249	1.346591	3.35301159	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g26269	i0	98.394	30	249	4	100	0	1	249	1230143	1230391	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	7470	438	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
19867560	19867560	PRJNA758770_S_NODE_27076_length_249_cov_0.886364_g26950_i0	PRJNA758770	27076	249	0.886364	2.20704636	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g26950	i0	99.598	1	249	1	100	0	1	249	185778	185530	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	249	455	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
19867629	19867629	PRJNA758770_S_NODE_30056_length_245_cov_0.906977_g29930_i0	PRJNA758770	30056	245	0.906977	2.22209365	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g29930	i0	99.592	1	245	1	100	0	1	245	62971	62727	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	245	448	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
21143219	21143219	PRJNA758770_S_NODE_27757_length_248_cov_0.891429_g27631_i0	PRJNA758770	27757	248	0.891429	2.21074392	Acetomicrobium mobile	97477	Bacteria	Bacteria	274	4.399999999999999e-69	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g27631	i0	86.694	1	248	31	99	2	2	248	1064497	1064743	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	248	274	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
21143253	21143253	PRJNA758770_S_NODE_29097_length_246_cov_0.901734_g28971_i0	PRJNA758770	29097	246	0.901734	2.21826564	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g28971	i0	100	1	246	0	100	0	1	246	1354082	1354327	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	246	455	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
23693584	23693584	PRJNA758770_S_NODE_25099_length_251_cov_0.876404_g24973_i0	PRJNA758770	25099	251	0.876404	2.19977404	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g24973	i0	99.602	1	251	1	100	0	1	251	1771234	1771484	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	251	459	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
23693733	23693733	PRJNA758770_S_NODE_31279_length_244_cov_0.865497_g31153_i0	PRJNA758770	31279	244	0.865497	2.11181268	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g31153	i0	100	1	244	0	100	0	1	244	834694	834937	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	244	451	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
24966920	24966920	PRJNA758770_S_NODE_14520_length_308_cov_0.893617_g14394_i0	PRJNA758770	14520	308	0.893617	2.75234036	Acetomicrobium mobile	97477	Bacteria	Bacteria	540	5.03e-149	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g14394	i0	98.371	0.996753246753247	307	5	99	0	1	307	2013770	2014076	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	307	540	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile

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