metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJEB83711" and tax

31 rows where analysis = "blastn", bioproject = "PRJEB83711" 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
144612	144612	PRJEB83711_P_NODE_71421_length_246_cov_0.901734_g71155_i0	PRJEB83711	71421	246	0.901734	2.21826564	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	135	2.14e-27	NTclustered	gi\|1339790004\|gb\|CP026517.1\|	2080419	g71155	i0	91.837	0.398373983739837	98	7	39	1	11	107	52964	52867	Deinococcus sp. NW-56 plasmid unnamed1, complete sequence	blastn	98	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
998835	998835	PRJEB83711_P_NODE_66041_length_248_cov_3.297143_g65775_i0	PRJEB83711	66041	248	3.297143	8.17691464	Deinococcus	1298	Bacteria	Bacteria	257	4.43e-64	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g65775	i0	86.864	171.931451612903	236	24	94	7	17	248	2342736	2342968	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	42639	259	0.992277992277992	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1418200	1418200	PRJEB83711_P_NODE_23402_length_367_cov_2.282313_g23136_i0	PRJEB83711	23402	367	2.282313	8.37608871	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	645	1.2599999999999995e-180	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g23136	i0	98.374	210.989100817439	369	3	100	3	1	367	73320	73687	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	77433	645	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
3549463	3549463	PRJEB83711_P_NODE_71303_length_246_cov_0.901734_g71037_i0	PRJEB83711	71303	246	0.901734	2.21826564	Thermus	270	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g71037	i0	99.187	8.79268292682927	246	2	100	0	1	246	2334770	2334525	Thermus scotoductus SA-01, complete genome	blastn	2163	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
3970454	3970454	PRJEB83711_P_NODE_53744_length_260_cov_0.978610_g53478_i0	PRJEB83711	53744	260	0.97861	2.544386	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	239	1.69e-58	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g53478	i0	83.462	9.48076923076923	260	39	99	4	1	258	1453000	1452743	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	2465	239	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
4826989	4826989	PRJEB83711_P_NODE_79584_length_241_cov_6.720238_g79318_i0	PRJEB83711	79584	241	6.720238	16.19577358	Deinococcus	1298	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g79318	i0	94.191	193.643153526971	241	14	100	0	1	241	1691	1451	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	46668	368	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
6522795	6522795	PRJEB83711_P_NODE_65886_length_249_cov_0.886364_g65620_i0	PRJEB83711	65886	249	0.886364	2.20704636	Deinococcus proteolyticus	55148	Bacteria	Bacteria	313	9.359999999999999e-81	NTclustered	gi\|324316040\|gb\|CP002537.1\|	693977	g65620	i0	90.336	7.98795180722892	238	23	96	0	12	249	285939	285702	Deinococcus proteolyticus MRP plasmid pDEIPR01, complete sequence	blastn	1989	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
6522833	6522833	PRJEB83711_P_NODE_67266_length_248_cov_0.891429_g67000_i0	PRJEB83711	67266	248	0.891429	2.21074392	Trueperaceae bacterium	2026798	Bacteria	Bacteria	169	2.13e-37	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g67000	i0	81.91	0.80241935483871	199	36	80	0	46	244	3535563	3535761	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	199	169	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
6523016	6523016	PRJEB83711_P_NODE_76306_length_243_cov_0.917647_g76040_i0	PRJEB83711	76306	243	0.917647	2.22988221	Deinococcus yunweiensis	367282	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g76040	i0	100	1	243	0	100	0	1	243	683205	682963	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	243	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
8651822	8651822	PRJEB83711_P_NODE_44267_length_279_cov_1.271845_g44001_i0	PRJEB83711	44267	279	1.271845	3.54844755	Truepera	332248	Bacteria	Bacteria	182	3.14e-41	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g44001	i0	79.688	1.96774193548387	256	48	91	4	3	256	1074579	1074326	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	549	182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
9071437	9071437	PRJEB83711_P_NODE_45928_length_275_cov_1.544554_g45662_i0	PRJEB83711	45928	275	1.544554	4.2475235	Deinococcus gobiensis	502394	Bacteria	Bacteria	348	2.88e-91	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g45662	i0	89.455	30.88	275	29	100	0	1	275	3037747	3038021	Deinococcus gobiensis I-0, complete genome	blastn	8492	348	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
9926943	9926943	PRJEB83711_P_NODE_76928_length_243_cov_0.917647_g76662_i0	PRJEB83711	76928	243	0.917647	2.22988221	Thermus	270	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g76662	i0	100	14.3662551440329	243	0	100	0	1	243	2060948	2061190	Thermus scotoductus SA-01, complete genome	blastn	3491	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10346278	10346278	PRJEB83711_P_NODE_10769_length_548_cov_1.926316_g10507_i0	PRJEB83711	10769	548	1.926316	10.55621168	Deinococcus radiophilus	32062	Bacteria	Bacteria	549	1.5699999999999994e-151	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g10507	i0	90.931	12.9835766423358	408	37	100	0	3	410	1413604	1413197	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	7115	549	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
11202240	11202240	PRJEB83711_P_NODE_83169_length_197_cov_4.387097_g82903_i0	PRJEB83711	83169	197	4.387097	8.64258109	Deinococcus	1298	Bacteria	Bacteria	291	3.32e-74	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g82903	i0	93.367	20.8934010152284	196	13	99	0	1	196	90531	90336	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	4116	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11623039	11623039	PRJEB83711_P_NODE_64090_length_250_cov_0.881356_g63824_i0	PRJEB83711	64090	250	0.881356	2.20339	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g63824	i0	97.581	2.976	248	6	99	0	3	250	639893	639646	Deinococcus sp. NW-56 chromosome, complete genome	blastn	744	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12477583	12477583	PRJEB83711_P_NODE_44390_length_279_cov_0.830097_g44124_i0	PRJEB83711	44390	279	0.830097	2.31597063	Deinococcus	1298	Bacteria	Bacteria	364	2.909999999999999e-96	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g44124	i0	91.386	166.308243727599	267	21	95	2	8	273	70036	70301	Deinococcus swuensis strain DY59, complete genome	blastn	46400	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
14173433	14173433	PRJEB83711_P_NODE_83172_length_197_cov_4.250000_g82906_i0	PRJEB83711	83172	197	4.25	8.3725	Thermus thermophilus	274	Bacteria	Bacteria	359	8.98e-95	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g82906	i0	99.492	49.3248730964467	197	1	100	0	1	197	307527	307723	Thermus thermophilus TF27 DNA, complete genome	blastn	9717	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
15026671	15026671	PRJEB83711_P_NODE_64252_length_249_cov_2.363636_g63986_i0	PRJEB83711	64252	249	2.363636	5.88545364	Deinococcus	1298	Bacteria	Bacteria	359	1.19e-94	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g63986	i0	92.771	351.694779116466	249	16	99	2	2	249	70110	69863	Deinococcus swuensis strain DY59, complete genome	blastn	87572	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
16720251	16720251	PRJEB83711_P_NODE_20294_length_393_cov_2.940625_g20028_i0	PRJEB83711	20294	393	2.940625	11.55665625	Deinococcus altitudinis	468914	Bacteria	Bacteria	586	8.33e-163	NTclustered	gi\|2865404944\|gb\|CP129415.1\|	468914	g20028	i0	93.655	189.666666666667	394	21	100	4	1	393	2511694	2512084	Deinococcus altitudinis strain LMG 24022 chromosome, complete genome	blastn	74539	586	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
16720562	16720562	PRJEB83711_P_NODE_32914_length_314_cov_1.294606_g32648_i0	PRJEB83711	32914	314	1.294606	4.06506284	Deinococcus proteolyticus	55148	Bacteria	Bacteria	213	1.27e-50	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g32648	i0	78.914	0.996815286624204	313	66	99	0	2	314	500655	500343	Deinococcus proteolyticus MRP, complete genome	blastn	313	213	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
16720968	16720968	PRJEB83711_P_NODE_50514_length_266_cov_1.347150_g50248_i0	PRJEB83711	50514	266	1.34715	3.583419	Deinococcus aetherius	200252	Bacteria	Bacteria	254	6.21e-63	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g50248	i0	83.895	1.00375939849624	267	41	100	2	1	266	238785	238520	Deinococcus aetherius ST0316 DNA, complete genome	blastn	267	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
16721204	16721204	PRJEB83711_P_NODE_60834_length_251_cov_1.601124_g60568_i0	PRJEB83711	60834	251	1.601124	4.01882124	Deinococcus proteolyticus	55148	Bacteria	Bacteria	80.5	1.04e-10	NTclustered	gi\|324316631\|gb\|CP002540.1\|	693977	g60568	i0	95.918	0.195219123505976	49	2	20	0	182	230	57184	57232	Deinococcus proteolyticus MRP plasmid pDEIPR04, complete sequence	blastn	49	80.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
17996244	17996244	PRJEB83711_P_NODE_68475_length_247_cov_0.896552_g68209_i0	PRJEB83711	68475	247	0.896552	2.21448344	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g68209	i0	99.595	6.98785425101215	247	1	100	0	1	247	301375	301621	Thermus sp. NEB1569 chromosome, complete genome	blastn	1726	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
18850168	18850168	PRJEB83711_P_NODE_24115_length_362_cov_1.564014_g23849_i0	PRJEB83711	24115	362	1.564014	5.66173068	Truepera	332248	Bacteria	Bacteria	377	4.99e-100	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g23849	i0	88.462	10.5082872928177	312	36	88	0	50	361	811569	811258	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	3804	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19269783	19269783	PRJEB83711_P_NODE_54616_length_258_cov_1.470270_g54350_i0	PRJEB83711	54616	258	1.47027	3.7932966	uncultured Deinococcaceae bacterium	310706	Bacteria	Bacteria	442	1.1899999999999995e-119	NTclustered	gi\|380705981\|gb\|JQ178049.1\|	310706	g54350	i0	97.674	103.527131782946	258	5	100	1	1	258	279	23	Uncultured Deinococcaceae bacterium clone PM6_-1.1-34 16S ribosomal RNA gene, partial sequence	blastn	26710	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae		uncultured Deinococcaceae bacterium
19269930	19269930	PRJEB83711_P_NODE_61176_length_251_cov_0.876404_g60910_i0	PRJEB83711	61176	251	0.876404	2.19977404	Deinococcus proteolyticus	55148	Bacteria	Bacteria	150	7.84e-32	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g60910	i0	78.327	1.04780876494024	263	36	100	15	1	251	1640923	1640670	Deinococcus proteolyticus MRP, complete genome	blastn	263	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
19270369	19270369	PRJEB83711_P_NODE_81896_length_228_cov_2.012903_g81630_i0	PRJEB83711	81896	228	2.012903	4.5894188400000004	Thermus scotoductus	37636	Bacteria	Bacteria	322	1.4e-83	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g81630	i0	92.105	4.97368421052632	228	18	100	0	1	228	2111765	2111538	Thermus scotoductus SA-01, complete genome	blastn	1134	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
20545754	20545754	PRJEB83711_P_NODE_72637_length_245_cov_0.906977_g72371_i0	PRJEB83711	72637	245	0.906977	2.22209365	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	102	2.16e-17	NTclustered	gi\|1339790004\|gb\|CP026517.1\|	2080419	g72371	i0	80	0.571428571428571	140	26	57	2	10	148	306651	306789	Deinococcus sp. NW-56 plasmid unnamed1, complete sequence	blastn	140	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
21820533	21820533	PRJEB83711_P_NODE_32258_length_317_cov_0.959016_g31992_i0	PRJEB83711	32258	317	0.959016	3.04008072	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	569	6.629999999999998e-158	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g31992	i0	99.054	41.4637223974763	317	3	100	0	1	317	1079572	1079888	Thermus sp. NEB1569 chromosome, complete genome	blastn	13144	569	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
23951156	23951156	PRJEB83711_P_NODE_52099_length_263_cov_1.221053_g51833_i0	PRJEB83711	52099	263	1.221053	3.21136939	Deinococcus	1298	Bacteria	Bacteria	198	2.9099999999999993e-46	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g51833	i0	82.328	1.7680608365019	232	37	87	2	31	260	2964394	2964623	Deinococcus puniceus strain DY1, complete genome	blastn	465	198	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
24370432	24370432	PRJEB83711_P_NODE_69620_length_247_cov_0.896552_g69354_i0	PRJEB83711	69620	247	0.896552	2.21448344	Deinococcus proteolyticus	55148	Bacteria	Bacteria	270	5.659999999999999e-68	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g69354	i0	89.041	6.7085020242915	219	22	88	2	30	247	860286	860503	Deinococcus proteolyticus MRP, complete genome	blastn	1657	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus

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