metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax

14 rows where analysis = "blastn", bioproject = "PRJEB8827" 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
25617818	25617818	PRJEB8827h_S_NODE_17081_length_184_cov_2.899329_g17062_i0	PRJEB8827	17081	184	2.899329	5.33476536	Deinococcus	1298	Bacteria	Bacteria	220	4.06e-53	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g17062	i0	88.587	222.641304347826	184	17	100	4	1	184	881358	881179	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	40966	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
25617836	25617836	PRJEB8827h_S_NODE_41_length_647_cov_8.145425_g27_i0	PRJEB8827	41	647	8.145425	52.70089975	Bacteria	2	Bacteria	Bacteria	688	0	NTclustered	gi\|2866351997\|gb\|PQ721879.1\|	47478	g27	i0	87.919	99.870170015456	596	57	92	10	1	595	768	187	Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence	blastn	64616	693	0.992784992784993	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25666296	25666296	PRJEB8827h_S_NODE_37194_length_169_cov_15.902985_g37175_i0	PRJEB8827	37194	169	15.902985	26.87604465	Deinococcus ficus	317577	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g37175	i0	93.529	113.881656804734	170	8	99	2	2	168	2343020	2342851	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	19246	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
25754041	25754041	PRJEB8827h_S_NODE_1002_length_293_cov_2173.042636_g983_i0	PRJEB8827	1002	293	2173.042636	6367.01492348	Truepera	332248	Bacteria	Bacteria	316	8.73e-82	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g983	i0	91.667	521.215017064846	228	19	78	0	15	242	762020	762247	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	152716	316	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
25754045	25754045	PRJEB8827h_S_NODE_1266_length_271_cov_5.190678_g1247_i0	PRJEB8827	1266	271	5.190678	14.06673738	Deinococcus	1298	Bacteria	Bacteria	243	1.37e-59	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g1247	i0	88.614	163.630996309963	202	20	74	3	62	261	1584	1784	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	44344	243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
25802464	25802464	PRJEB8827h_S_NODE_35419_length_171_cov_3.830882_g35400_i0	PRJEB8827	35419	171	3.830882	6.55080822	Deinococcus gobiensis I-	502394	Bacteria	Bacteria	244	2.2e-60	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g35400	i0	92.398	187.380116959064	171	13	100	0	1	171	111721	111891	Deinococcus gobiensis I-0, complete genome	blastn	32042	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
25889664	25889664	PRJEB8827f_S_NODE_24747_length_161_cov_1.031746_g24727_i0	PRJEB8827	24747	161	1.031746	1.66111106	Deinococcus	1298	Bacteria	Bacteria	276	7.29e-70	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g24727	i0	97.516	219.888198757764	161	4	100	0	1	161	1792058	1791898	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	35402	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
25938685	25938685	PRJEB8827h_S_NODE_21700_length_181_cov_30.376712_g21681_i0	PRJEB8827	21700	181	30.376712	54.98184872	Deinococcus gobiensis I-	502394	Bacteria	Bacteria	279	6.48e-71	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g21681	i0	94.972	167.71270718232	179	8	99	1	3	181	803372	803195	Deinococcus gobiensis I-0, complete genome	blastn	30356	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
25938691	25938691	PRJEB8827h_S_NODE_2468_length_222_cov_2.000000_g2449_i0	PRJEB8827	2468	222	2	4.44	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	333	6.279999999999999e-87	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g2449	i0	93.694	155.779279279279	222	14	100	0	1	222	1792514	1792293	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	34583	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
26162230	26162230	PRJEB8827h_S_NODE_1325_length_266_cov_5.212121_g1306_i0	PRJEB8827	1325	266	5.212121	13.86424186	Deinococcus	1298	Bacteria	Bacteria	298	2.8299999999999997e-76	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g1306	i0	87.037	980.458646616541	270	28	100	5	1	266	1369	1103	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	260802	298	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
26210579	26210579	PRJEB8827f_S_NODE_3454_length_239_cov_818.931373_g3434_i0	PRJEB8827	3454	239	818.931373	1957.24598147	Deinococcus sp. KNUC121	47478	Bacteria	Bacteria	217	7.2e-52	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g3434	i0	86.765	39.9121338912134	204	15	81	9	44	237	1426996	1426795	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	9539	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
26210921	26210921	PRJEB8827h_S_NODE_47086_length_154_cov_1.798319_g47067_i0	PRJEB8827	47086	154	1.798319	2.76941126	Trueperaceae bacterium	2026798	Bacteria	Bacteria	191	2.57e-44	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g47067	i0	89.032	2.01298701298701	155	15	100	2	1	154	6986	6833	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	310	191	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
26297834	26297834	PRJEB8827e_S_NODE_2998_length_249_cov_13.644860_g2970_i0	PRJEB8827	2998	249	13.64486	33.9757014	Truepera	332248	Bacteria	Bacteria	324	4.33e-84	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g2970	i0	92.14	608.301204819277	229	18	92	0	8	236	762248	762020	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	151467	324	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26433842	26433842	PRJEB8827b_S_NODE_2295_length_234_cov_4.804020_g2243_i0	PRJEB8827	2295	234	4.80402	11.2414068	Truepera	332248	Bacteria	Bacteria	318	1.87e-82	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2243	i0	93.458	599.57264957265	214	14	91	0	21	234	214	1	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	140300	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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