metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Deinococcota"

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
293965	293965	PRJNA1148190_P_NODE_318681_length_312_cov_1.288703_g307508_i0	PRJNA1148190	318681	312	1.288703	4.02075336	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g307508	i0	100	0.092948717948718	29	0	9	0	176	204	1294955	1294983	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
1573067	1573067	PRJNA1148190_P_NODE_650822_length_248_cov_0.880000_g639649_i0	PRJNA1148190	650822	248	0.88	2.1824	Deinococcus gobiensis	502394	Bacteria	Bacteria	244	3.45e-60	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g639649	i0	86.818	54.0443548387097	220	27	88	2	2	220	2690114	2689896	Deinococcus gobiensis I-0, complete genome	blastn	13403	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
2843887	2843887	PRJNA1148190_P_NODE_255163_length_341_cov_0.839552_g243993_i0	PRJNA1148190	255163	341	0.839552	2.86287232	Trueperaceae bacterium	2026798	Bacteria	Bacteria	274	6.32e-69	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g243993	i0	81.471	1.33431085043988	340	57	99	4	5	341	3738443	3738779	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	455	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
2846418	2846418	PRJNA1148190_P_NODE_426183_length_281_cov_1.375000_g415010_i0	PRJNA1148190	426183	281	1.375	3.86375	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	259	1.42e-64	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g415010	i0	84.211	1.8932384341637	266	42	95	0	16	281	593902	594167	Deinococcus sp. QL22 chromosome, complete genome	blastn	532	259	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
2850024	2850024	PRJNA1148190_P_NODE_699903_length_245_cov_0.895349_g688730_i0	PRJNA1148190	699903	245	0.895349	2.19360505	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	309	1.19e-79	NTclustered	gi\|2197029093\|gb\|CP092187.1\|	2917691	g688730	i0	89.388	99.1061224489796	245	26	100	0	1	245	74763	75007	Deinococcus sp. KNUC1210 plasmid unnamed1, complete sequence	blastn	24281	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
6138848	6138848	PRJNA1148190_P_NODE_672485_length_247_cov_0.885057_g661312_i0	PRJNA1148190	672485	247	0.885057	2.18609079	PVC group	1783257	Bacteria	Bacteria	217	7.479999999999999e-52	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g661312	i0	85.308	85.5991902834008	211	29	85	2	26	235	2707019	2707228	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	21143	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
6671883	6671883	PRJNA1148190_P_NODE_325626_length_309_cov_2.572034_g314453_i0	PRJNA1148190	325626	309	2.572034	7.94758506	Deinococcota bacterium DY0809b	3396280	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2904223141\|gb\|CP179936.1\|	3396280	g314453	i0	100	0.0970873786407767	30	0	10	0	161	190	615545	615516	Deinococcota bacterium DY0809b chromosome, complete genome	blastn	30	56.5	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium DY0809b
6677388	6677388	PRJNA1148190_P_NODE_730066_length_244_cov_0.900585_g718893_i0	PRJNA1148190	730066	244	0.900585	2.1974274	Marinithermus hydrothermalis	186192	Bacteria	Bacteria	167	7.529999999999998e-37	NTclustered	gi\|328449864\|gb\|CP002630.1\|	869210	g718893	i0	83.152	20.5327868852459	184	29	75	2	18	200	1638928	1639110	Marinithermus hydrothermalis DSM 14884, complete genome	blastn	5010	167	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Marinithermus	Marinithermus hydrothermalis
7950591	7950591	PRJNA1148190_P_NODE_576027_length_252_cov_1.385475_g564854_i0	PRJNA1148190	576027	252	1.385475	3.491397	Trueperaceae bacterium	2026798	Bacteria	Bacteria	115	2.8700000000000003e-21	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g564854	i0	79.191	0.686507936507937	173	31	67	4	49	218	2698933	2698763	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	173	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
7951914	7951914	PRJNA1148190_P_NODE_677347_length_246_cov_1.335260_g666174_i0	PRJNA1148190	677347	246	1.33526	3.2847396	Trueperaceae bacterium	2026798	Bacteria	Bacteria	117	7.77e-22	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g666174	i0	93.59	0.638211382113821	78	5	32	0	101	178	2006658	2006735	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	157	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
8687865	8687865	PRJNA1148190_P_NODE_315227_length_313_cov_2.137500_g304054_i0	PRJNA1148190	315227	313	2.1375	6.690375	Thermus	270	Bacteria	Bacteria	63.9	1.35e-5	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g304054	i0	97.297	0.364217252396166	37	1	12	0	240	276	673575	673611	Thermus aquaticus Y51MC23, complete genome	blastn	114	63.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
13051428	13051428	PRJNA1148190_P_NODE_598131_length_250_cov_1.740113_g586958_i0	PRJNA1148190	598131	250	1.740113	4.3502825	Trueperaceae bacterium	2026798	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g586958	i0	80.769	1.108	234	34	92	10	2	230	27137	27364	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	277	172	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
14320567	14320567	PRJNA1148190_P_NODE_173952_length_400_cov_1.758410_g162783_i0	PRJNA1148190	173952	400	1.75841	7.03364	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g162783	i0	92.308	0.1925	39	2	10	1	273	310	1420348	1420310	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	77	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
14321874	14321874	PRJNA1148190_P_NODE_252672_length_342_cov_1.144981_g241502_i0	PRJNA1148190	252672	342	1.144981	3.91583502	Trueperaceae bacterium	2026798	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g241502	i0	100	0.0818713450292398	28	0	8	0	144	171	1409541	1409514	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
15599684	15599684	PRJNA1148190_P_NODE_51793_length_826_cov_1.792829_g40974_i0	PRJNA1148190	51793	826	1.792829	14.80876754	Deinococcus radiomollis	468916	Bacteria	Bacteria	62.1	1.38e-4	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g40974	i0	94.872	0.0472154963680387	39	2	5	0	751	789	2388491	2388529	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	39	62.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
17613330	17613330	PRJNA1148190_P_NODE_538854_length_259_cov_1.440860_g527681_i0	PRJNA1148190	538854	259	1.44086	3.7318274	Bacteria	2	Bacteria	Bacteria	95.3	3.86e-15	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g527681	i0	82.727	0.822393822393822	110	15	42	4	1	108	2376401	2376508	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	213	95.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
17613921	17613921	PRJNA1148190_P_NODE_718274_length_244_cov_0.900585_g707101_i0	PRJNA1148190	718274	244	0.900585	2.1974274	Deinococcus	1298	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g707101	i0	100	1.84426229508197	30	0	12	0	159	188	414368	414397	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	450	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
19419133	19419133	PRJNA1148190_P_NODE_256956_length_340_cov_1.037453_g245786_i0	PRJNA1148190	256956	340	1.037453	3.5273402	Deinococcus sonorensis	309891	Bacteria	Bacteria	89.8	2.45e-13	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g245786	i0	82.243	0.314705882352941	107	16	31	3	16	120	1107753	1107858	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	107	89.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
20698716	20698716	PRJNA1148190_P_NODE_552657_length_256_cov_1.879781_g541484_i0	PRJNA1148190	552657	256	1.879781	4.81223936	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	65.8	2.99e-6	NTclustered	gi\|2636772739\|gb\|CP140100.1\|	3093660	g541484	i0	93.182	2.42578125	44	3	17	0	1	44	37870	37827	Deinococcus sp. AB2017081 plasmid unnamed2, complete sequence	blastn	621	65.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
21968386	21968386	PRJNA1148190_P_NODE_167458_length_407_cov_1.736527_g156289_i0	PRJNA1148190	167458	407	1.736527	7.06766489	Oceanithermus profundus	187137	Bacteria	Bacteria	348	4.45e-91	NTclustered	gi\|313151615\|gb\|CP002361.1\|	670487	g156289	i0	82.63	39.1425061425061	403	60	98	9	8	405	1189087	1188690	Oceanithermus profundus DSM 14977, complete genome	blastn	15931	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Oceanithermus	Oceanithermus profundus
21973187	21973187	PRJNA1148190_P_NODE_489538_length_269_cov_0.841837_g478365_i0	PRJNA1148190	489538	269	0.841837	2.26454153	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	104	6.71e-18	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g478365	i0	86.957	2.72118959107807	92	12	34	0	111	202	2602816	2602725	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	732	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
21976740	21976740	PRJNA1148190_P_NODE_769478_length_242_cov_0.911243_g758305_i0	PRJNA1148190	769478	242	0.911243	2.20520806	Deinococcus sonorensis	309891	Bacteria	Bacteria	159	1.2499999999999999e-34	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g758305	i0	79.412	35.3429752066116	238	39	96	9	9	241	254141	254373	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	8553	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
23244731	23244731	PRJNA1148190_P_NODE_221239_length_361_cov_1.048611_g210069_i0	PRJNA1148190	221239	361	1.048611	3.78548571	Deinococcus radiomollis	468916	Bacteria	Bacteria	159	1.9599999999999998e-34	NTclustered	gi\|2865413288\|gb\|CP129907.1\|	468916	g210069	i0	79.149	6.53739612188366	235	45	65	4	129	361	635745	635513	Deinococcus radiomollis strain PO-04-20-132 plasmid unnamed1, complete sequence	blastn	2360	159	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
23246690	23246690	PRJNA1148190_P_NODE_348779_length_301_cov_1.241228_g337606_i0	PRJNA1148190	348779	301	1.241228	3.73609628	Trueperaceae bacterium	2026798	Bacteria	Bacteria	152	2.6799999999999996e-32	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g337606	i0	84.416	10.8305647840532	154	24	51	0	140	293	2816836	2816989	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	3260	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
24525981	24525981	PRJNA1148190_P_NODE_77660_length_623_cov_1.950909_g66542_i0	PRJNA1148190	77660	623	1.950909	12.15416307	Trueperaceae bacterium	2026798	Bacteria	Bacteria	327	9.17e-85	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g66542	i0	78.817	3.23595505617978	524	83	82	25	10	519	3282417	3282926	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	2016	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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