metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA782235" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA782235" 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
763473	763473	PRJNA782235_P_NODE_5141_length_385_cov_2.804487_g4952_i0	PRJNA782235	5141	385	2.804487	10.79727495	Trueperaceae bacterium	2026798	Bacteria	Bacteria	544	4.969999999999998e-150	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g4952	i0	93.443	541.916883116883	366	24	95	0	20	385	3600884	3600519	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	208638	544	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
3314549	3314549	PRJNA782235_P_NODE_16163_length_251_cov_1.297753_g15974_i0	PRJNA782235	16163	251	1.297753	3.25736003	Deinococcus ficus	317577	Bacteria	Bacteria	372	1.54e-98	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g15974	i0	93.307	187.051792828685	254	13	100	3	1	251	2342569	2342821	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	46950	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
3314647	3314647	PRJNA782235_P_NODE_22603_length_246_cov_0.890173_g22414_i0	PRJNA782235	22603	246	0.890173	2.18982558	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	333	7.089999999999999e-87	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g22414	i0	91.057	250.906504065041	246	22	100	0	1	246	545693	545938	Deinococcus sp. NW-56 chromosome, complete genome	blastn	61723	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3764078	3764078	PRJNA782235_P_NODE_3263_length_501_cov_2.186916_g3076_i0	PRJNA782235	3263	501	2.186916	10.95644916	Deinococcus	1298	Bacteria	Bacteria	881	0	NTclustered	gi\|1073549716\|gb\|KX946495.1\|	47478	g3076	i0	98.403	108.157684630739	501	8	100	0	1	501	876	376	Deinococcus sp. strain FX4 16S ribosomal RNA gene, partial sequence	blastn	54187	881	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
5040673	5040673	PRJNA782235_P_NODE_24764_length_244_cov_0.900585_g24575_i0	PRJNA782235	24764	244	0.900585	2.1974274	Deinococcus	1298	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g24575	i0	99.18	2.42213114754098	244	2	100	0	1	244	265867	266110	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	591	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5040714	5040714	PRJNA782235_P_NODE_5144_length_385_cov_2.070513_g4955_i0	PRJNA782235	5144	385	2.070513	7.97147505	Deinococcus	1298	Bacteria	Bacteria	701	0	NTclustered	gi\|105990360\|gb\|DQ514091.1\|	158789	g4955	i0	99.481	100.028571428571	385	2	100	0	1	385	405	21	Uncultured Deinococcus sp. clone 100M2_A8 16S ribosomal RNA gene, partial sequence	blastn	38511	706	0.992917847025496	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
5866717	5866717	PRJNA782235_P_NODE_13225_length_269_cov_1.311224_g13036_i0	PRJNA782235	13225	269	1.311224	3.52719256	Deinococcus gobiensis	502394	Bacteria	Bacteria	252	2.26e-62	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g13036	i0	84.98	42.6505576208178	253	32	93	6	16	265	1189659	1189410	Deinococcus gobiensis I-0, complete genome	blastn	11473	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
5866945	5866945	PRJNA782235_P_NODE_3185_length_508_cov_3.177011_g2998_i0	PRJNA782235	3185	508	3.177011	16.13921588	Trueperaceae bacterium	2026798	Bacteria	Bacteria	656	0	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g2998	i0	91.304	220.011811023622	483	39	95	3	1	482	3600962	3601442	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	111766	656	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7590346	7590346	PRJNA782235_P_NODE_10146_length_288_cov_1.879070_g9957_i0	PRJNA782235	10146	288	1.87907	5.4117216	Deinococcus	1298	Bacteria	Bacteria	366	8.38e-97	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g9957	i0	89.583	26.4826388888889	288	30	100	0	1	288	1596249	1595962	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	7627	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
9691817	9691817	PRJNA782235_P_NODE_24928_length_244_cov_0.900585_g24739_i0	PRJNA782235	24928	244	0.900585	2.1974274	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	370	5.35e-98	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g24739	i0	94.262	2.27049180327869	244	11	100	2	1	244	1988071	1988311	Deinococcus sp. NW-56 chromosome, complete genome	blastn	554	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
10967370	10967370	PRJNA782235_P_NODE_15349_length_256_cov_1.431694_g15160_i0	PRJNA782235	15349	256	1.431694	3.66513664	Deinococcus radiopugnans	57497	Bacteria	Bacteria	263	9.88e-66	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g15160	i0	85.156	8.0546875	256	38	100	0	1	256	1119871	1120126	Deinococcus swuensis strain DY59, complete genome	blastn	2062	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
10967600	10967600	PRJNA782235_P_NODE_4549_length_411_cov_1.943787_g4360_i0	PRJNA782235	4549	411	1.943787	7.98896457	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	676	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g4360	i0	96.35	252.768856447689	411	15	100	0	1	411	2418008	2417598	Deinococcus sp. NW-56 chromosome, complete genome	blastn	103888	676	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12242794	12242794	PRJNA782235_P_NODE_10850_length_284_cov_1.199052_g10661_i0	PRJNA782235	10850	284	1.199052	3.40530768	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	220	6.79e-53	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g10661	i0	93.836	0.922535211267606	146	9	92	0	1	146	553257	553402	Deinococcus sp. NW-56 chromosome, complete genome	blastn	262	220	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13517076	13517076	PRJNA782235_P_NODE_15671_length_254_cov_1.353591_g15482_i0	PRJNA782235	15671	254	1.353591	3.43812114	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	370	5.61e-98	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g15482	i0	92.913	36.996062992126	254	18	100	0	1	254	429961	429708	Deinococcus sp. NW-56 chromosome, complete genome	blastn	9397	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
17341524	17341524	PRJNA782235_P_NODE_18454_length_249_cov_0.875000_g18265_i0	PRJNA782235	18454	249	0.875	2.17875	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g18265	i0	93.574	235.156626506024	249	16	100	0	1	249	69301	69053	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	58554	372	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
17341562	17341562	PRJNA782235_P_NODE_20934_length_247_cov_0.885057_g20745_i0	PRJNA782235	20934	247	0.885057	2.18609079	Deinococcus ficus	317577	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g20745	i0	99.19	1	247	2	100	0	1	247	2027282	2027528	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	247	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
18614942	18614942	PRJNA782235_P_NODE_19435_length_248_cov_2.834286_g19246_i0	PRJNA782235	19435	248	2.834286	7.02902928	Trueperaceae bacterium	2026798	Bacteria	Bacteria	353	5.49e-93	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g19246	i0	92.369	452.709677419355	249	18	100	1	1	248	6530	6778	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	112272	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
18615027	18615027	PRJNA782235_P_NODE_26295_length_242_cov_1.775148_g26106_i0	PRJNA782235	26295	242	1.775148	4.29585816	Deinococcus radiophilus	32062	Bacteria	Bacteria	331	2.5e-86	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g26106	i0	91.322	3.97520661157025	242	21	100	0	1	242	113134	112893	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	962	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
20338817	20338817	PRJNA782235_P_NODE_5596_length_372_cov_0.969900_g5407_i0	PRJNA782235	5596	372	0.9699	3.608028	Deinococcus	1298	Bacteria	Bacteria	518	2.9e-142	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g5407	i0	91.935	193.77688172043	372	27	100	2	1	372	1793580	1793212	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	72085	518	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21166046	21166046	PRJNA782235_P_NODE_3517_length_478_cov_1.582716_g3329_i0	PRJNA782235	3517	478	1.582716	7.56538248	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	562	1.74e-155	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g3329	i0	87.967	205.891213389121	482	50	100	8	1	478	543276	543753	Deinococcus sp. NW-56 chromosome, complete genome	blastn	98416	562	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
22889974	22889974	PRJNA782235_P_NODE_20758_length_247_cov_1.189655_g20569_i0	PRJNA782235	20758	247	1.189655	2.93844785	Deinococcus	1298	Bacteria	Bacteria	377	3.24e-100	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g20569	i0	94.355	189.943319838057	248	11	100	3	1	247	1429	1674	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	46916	379	0.994722955145119	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
22889981	22889981	PRJNA782235_P_NODE_22918_length_246_cov_0.815029_g22729_i0	PRJNA782235	22918	246	0.815029	2.00497134	Truepera	332248	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g22729	i0	97.967	624.463414634146	246	5	100	0	1	246	2917	2672	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	153618	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24164050	24164050	PRJNA782235_P_NODE_8399_length_312_cov_2.167364_g8210_i0	PRJNA782235	8399	312	2.167364	6.76217568	Deinococcus	1298	Bacteria	Bacteria	560	3.92e-155	NTclustered	gi\|2136551946\|gb\|MT672570.2\|	47478	g8210	i0	99.038	104.637820512821	312	3	100	0	1	312	30	341	Deinococcus sp. strain HSC-46F16 16S ribosomal RNA gene, partial sequence	blastn	32647	560	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25439177	25439177	PRJNA782235_P_NODE_28700_length_233_cov_2.850000_g28511_i0	PRJNA782235	28700	233	2.85	6.6405	Deinococcus	1298	Bacteria	Bacteria	392	1.08e-104	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g28511	i0	97.009	231.772532188841	234	5	100	2	1	233	1454036	1454268	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	54003	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142

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