metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1167252" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1167252" 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
1589016	1589016	PRJNA1167252_P_NODE_17322_length_293_cov_0.872727_g17049_i0	PRJNA1167252	17322	293	0.872727	2.55709011	Mesotoga infera	1236046	Bacteria	Bacteria	508	1.34e-139	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g17049	i0	97.952	1	293	6	100	0	1	293	1152182	1152474	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	293	508	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
1589226	1589226	PRJNA1167252_P_NODE_24042_length_251_cov_0.876404_g23769_i0	PRJNA1167252	24042	251	0.876404	2.19977404	Mesotoga infera	1236046	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g23769	i0	98.805	1	251	3	100	0	1	251	1467430	1467180	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	251	448	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
6692566	6692566	PRJNA1167252_P_NODE_28586_length_243_cov_0.917647_g28313_i0	PRJNA1167252	28586	243	0.917647	2.22988221	Mesotoga infera	1236046	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g28313	i0	100	1	243	0	100	0	1	243	2273500	2273258	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	243	449	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
9967883	9967883	PRJNA1167252_P_NODE_14268_length_325_cov_2.126984_g13995_i0	PRJNA1167252	14268	325	2.126984	6.912698	Truepera	332248	Bacteria	Bacteria	252	2.81e-62	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g13995	i0	80.781	834.295384615385	333	54	100	8	1	325	177	507	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	271146	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
11793314	11793314	PRJNA1167252_P_NODE_29270_length_242_cov_0.923077_g28997_i0	PRJNA1167252	29270	242	0.923077	2.23384634	Mesotoga infera	1236046	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g28997	i0	99.587	1	242	1	100	0	1	242	413326	413567	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	242	442	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
13067970	13067970	PRJNA1167252_P_NODE_17031_length_296_cov_1.008969_g16758_i0	PRJNA1167252	17031	296	1.008969	2.98654824	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	536	6.2199999999999986e-148	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g16758	i0	99.324	197.456081081081	296	2	100	0	1	296	57563	57268	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	58447	536	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
14343593	14343593	PRJNA1167252_P_NODE_26892_length_246_cov_0.901734_g26619_i0	PRJNA1167252	26892	246	0.901734	2.21826564	Mesotoga infera	1236046	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g26619	i0	100	1	246	0	100	0	1	246	1525584	1525829	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	246	455	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
14343842	14343842	PRJNA1167252_P_NODE_8412_length_439_cov_2.144809_g8139_i0	PRJNA1167252	8412	439	2.144809	9.41571151	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	811	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g8139	i0	100	199.321184510251	439	0	100	0	1	439	58230	57792	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	87502	811	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
15617348	15617348	PRJNA1167252_P_NODE_24493_length_250_cov_0.881356_g24220_i0	PRJNA1167252	24493	250	0.881356	2.20339	Mesotoga infera	1236046	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g24220	i0	98.8	1	250	3	100	0	1	250	1040592	1040343	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	250	446	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
16342414	16342414	PRJNA1167252_P_NODE_21633_length_260_cov_1.251337_g21360_i0	PRJNA1167252	21633	260	1.251337	3.2534762	Truepera	332248	Bacteria	Bacteria	346	9.71e-91	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g21360	i0	90.53	114.457692307692	264	21	100	3	1	260	1830	1567	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	29759	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
18166293	18166293	PRJNA1167252_P_NODE_28735_length_243_cov_0.917647_g28462_i0	PRJNA1167252	28735	243	0.917647	2.22988221	Fervidobacterium nodosum	2424	Bacteria	Bacteria	326	1.17e-84	NTclustered	gi\|154152641\|gb\|CP000771.1\|	381764	g28462	i0	90.909	0.995884773662551	242	22	99	0	1	242	634441	634200	Fervidobacterium nodosum Rt17-B1, complete genome	blastn	242	326	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium nodosum
21991290	21991290	PRJNA1167252_P_NODE_27198_length_246_cov_0.890173_g26925_i0	PRJNA1167252	27198	246	0.890173	2.18982558	Mesotoga infera	1236046	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g26925	i0	100	1	246	0	100	0	1	246	2337572	2337817	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	246	455	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera
24540522	24540522	PRJNA1167252_P_NODE_25740_length_248_cov_0.891429_g25467_i0	PRJNA1167252	25740	248	0.891429	2.21074392	Mesotoga infera	1236046	Bacteria	Bacteria	436	5.3e-118	NTclustered	gi\|1417721526\|emb\|LS974202.1\|	1236046	g25467	i0	98.387	1	248	4	100	0	1	248	312572	312819	Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF	blastn	248	436	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga infera

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