metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax

34 rows where analysis = "blastn", bioproject = "PRJEB83101" 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
142023	142023	PRJEB83101_P_NODE_45081_length_285_cov_1.165094_g44776_i0	PRJEB83101	45081	285	1.165094	3.3205179	Deinococcus ficus	317577	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g44776	i0	98.596	13.2947368421053	285	4	100	0	1	285	391414	391698	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	3789	505	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
2273131	2273131	PRJEB83101_P_NODE_5282_length_891_cov_2.370416_g5039_i0	PRJEB83101	5282	891	2.370416	21.12040656	Deinococcus	1298	Bacteria	Bacteria	1105	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g5039	i0	90.499	286.646464646465	842	72	94	7	1	839	74995	74159	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	255402	1107	0.998193315266486	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
2693168	2693168	PRJEB83101_P_NODE_85883_length_242_cov_0.923077_g85578_i0	PRJEB83101	85883	242	0.923077	2.23384634	Trueperaceae bacterium	2026798	Bacteria	Bacteria	143	1.2599999999999998e-29	NTclustered	gi\|2621706202\|emb\|OY764543.1\|	2026798	g85578	i0	91.509	31.8884297520661	106	5	42	3	21	122	654785	654890	MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1	blastn	7717	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
2693241	2693241	PRJEB83101_P_NODE_88783_length_234_cov_2.459627_g88478_i0	PRJEB83101	88783	234	2.459627	5.75552718	Deinococcus altitudinis	468914	Bacteria	Bacteria	185	1.9799999999999994e-42	NTclustered	gi\|2865408430\|gb\|CP129417.1\|	468914	g88478	i0	81.435	5.68803418803419	237	34	99	10	3	234	216912	216681	Deinococcus altitudinis strain LMG 24022 plasmid unnamed2, complete sequence	blastn	1331	185	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus altitudinis
3967779	3967779	PRJEB83101_P_NODE_32044_length_326_cov_1.233202_g31739_i0	PRJEB83101	32044	326	1.233202	4.02023852	Deinococcus radiophilus	32062	Bacteria	Bacteria	372	2.07e-98	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g31739	i0	88.35	3.52760736196319	309	36	95	0	18	326	18964	19272	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	1150	372	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
4826006	4826006	PRJEB83101_P_NODE_49384_length_277_cov_1.529412_g49079_i0	PRJEB83101	49384	277	1.529412	4.23647124	Thermus	270	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|1614035204\|gb\|MH827790.1\|	275	g49079	i0	99.639	101.025270758123	277	1	100	0	1	277	396	120	Thermus sp. strain 0624-2 16S ribosomal RNA gene, partial sequence	blastn	27984	512	0.990234375	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp.
5244607	5244607	PRJEB83101_P_NODE_43385_length_288_cov_1.265116_g43080_i0	PRJEB83101	43385	288	1.265116	3.64353408	Deinococcus yunweiensis	367282	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g43080	i0	99.653	1	288	1	100	0	1	288	1742575	1742862	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	288	527	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
5245752	5245752	PRJEB83101_P_NODE_86085_length_242_cov_0.923077_g85780_i0	PRJEB83101	86085	242	0.923077	2.23384634	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g85780	i0	99.587	7.94628099173554	242	1	100	0	1	242	1522494	1522253	Thermus sp. NEB1569 chromosome, complete genome	blastn	1923	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
6101340	6101340	PRJEB83101_P_NODE_78545_length_246_cov_0.901734_g78240_i0	PRJEB83101	78545	246	0.901734	2.21826564	Deinococcus	1298	Bacteria	Bacteria	165	2.74e-36	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g78240	i0	81.818	8.40650406504065	198	34	80	2	44	240	2825593	2825397	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	2068	165	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
6520829	6520829	PRJEB83101_P_NODE_67486_length_252_cov_0.871508_g67181_i0	PRJEB83101	67486	252	0.871508	2.19620016	Deinococcus maricopensis	309887	Bacteria	Bacteria	67.6	8.16e-7	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g67181	i0	95.238	0.166666666666667	42	2	17	0	153	194	3241335	3241294	Deinococcus maricopensis DSM 21211, complete genome	blastn	42	67.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
6521030	6521030	PRJEB83101_P_NODE_75486_length_247_cov_2.074713_g75181_i0	PRJEB83101	75486	247	2.074713	5.12454111	Trueperaceae bacterium	2026798	Bacteria	Bacteria	263	9.47e-66	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g75181	i0	86.307	65.7206477732794	241	33	98	0	4	244	1746329	1746569	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	16233	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
6521141	6521141	PRJEB83101_P_NODE_79966_length_245_cov_0.906977_g79661_i0	PRJEB83101	79966	245	0.906977	2.22209365	Deinococcus radiophilus	32062	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g79661	i0	99.184	1.7469387755102	245	2	100	0	1	245	1817549	1817305	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	428	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
9925690	9925690	PRJEB83101_P_NODE_26128_length_359_cov_1.681818_g25823_i0	PRJEB83101	26128	359	1.681818	6.03772662	Deinococcus	1298	Bacteria	Bacteria	508	1.68e-139	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g25823	i0	92.201	22.3871866295265	359	28	100	0	1	359	416007	416365	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	8037	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
9926310	9926310	PRJEB83101_P_NODE_87168_length_240_cov_2.706587_g86863_i0	PRJEB83101	87168	240	2.706587	6.4958088	Thermus	270	Bacteria	Bacteria	438	1.4199999999999995e-118	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g86863	i0	99.583	5.97083333333333	240	1	100	0	1	240	2344487	2344248	Thermus scotoductus SA-01, complete genome	blastn	1433	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
10344713	10344713	PRJEB83101_P_NODE_35129_length_312_cov_3.112971_g34824_i0	PRJEB83101	35129	312	3.112971	9.71246952	Deinococcus aetherius	200252	Bacteria	Bacteria	171	7.72e-38	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g34824	i0	87.248	0.878205128205128	149	19	48	0	162	310	570604	570752	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	274	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
10345698	10345698	PRJEB83101_P_NODE_71469_length_249_cov_2.886364_g71164_i0	PRJEB83101	71469	249	2.886364	7.18704636	Deinococcus puniceus	1182568	Bacteria	Bacteria	311	3.37e-80	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g71164	i0	88.889	8.1004016064257	261	17	100	4	1	249	1984652	1984912	Deinococcus puniceus strain DY1, complete genome	blastn	2017	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
11620415	11620415	PRJEB83101_P_NODE_42450_length_290_cov_1.175115_g42145_i0	PRJEB83101	42450	290	1.175115	3.4078335	Deinococcus puniceus	1182568	Bacteria	Bacteria	440	4.899999999999998e-119	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g42145	i0	94.406	0.986206896551724	286	16	99	0	1	286	1346788	1347073	Deinococcus puniceus strain DY1, complete genome	blastn	286	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
11620521	11620521	PRJEB83101_P_NODE_46050_length_283_cov_1.390476_g45745_i0	PRJEB83101	46050	283	1.390476	3.93504708	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	451	2.1999999999999995e-122	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g45745	i0	95.406	15.4240282685512	283	13	100	0	1	283	232552	232270	Deinococcus sp. NW-56 chromosome, complete genome	blastn	4365	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12477005	12477005	PRJEB83101_P_NODE_61310_length_258_cov_1.443243_g61005_i0	PRJEB83101	61310	258	1.443243	3.72356694	Thermus	270	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g61005	i0	99.225	43.4031007751938	258	2	100	0	1	258	374819	375076	Thermus scotoductus SA-01, complete genome	blastn	11198	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
12894900	12894900	PRJEB83101_P_NODE_22351_length_390_cov_1.962145_g22047_i0	PRJEB83101	22351	390	1.962145	7.6523655	Deinococcus grandis	57498	Bacteria	Bacteria	704	0	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g22047	i0	99.231	204.751282051282	390	3	100	0	1	390	116811	116422	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	79853	704	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
12896580	12896580	PRJEB83101_P_NODE_84551_length_243_cov_0.917647_g84246_i0	PRJEB83101	84551	243	0.917647	2.22988221	Deinococcus radiophilus	32062	Bacteria	Bacteria	134	7.6e-27	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g84246	i0	78.713	0.831275720164609	202	41	83	2	1	201	696833	696633	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	202	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
14170297	14170297	PRJEB83101_P_NODE_39092_length_298_cov_2.235556_g38787_i0	PRJEB83101	39092	298	2.235556	6.66195688	Deinococcus ficus	317577	Bacteria	Bacteria	355	1.8899999999999997e-93	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g38787	i0	90.406	335.848993288591	271	24	91	2	29	298	2342736	2343005	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	100083	355	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
14171098	14171098	PRJEB83101_P_NODE_67992_length_251_cov_2.179775_g67687_i0	PRJEB83101	67992	251	2.179775	5.47123525	Deinococcus geothermalis	68909	Bacteria	Bacteria	171	6.02e-38	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g67687	i0	90.076	0.725099601593626	131	13	52	0	76	206	514194	514324	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	182	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
14171624	14171624	PRJEB83101_P_NODE_88152_length_236_cov_3.184049_g87847_i0	PRJEB83101	88152	236	3.184049	7.51435564	Deinococcus ficus	317577	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g87847	i0	100	1	236	0	100	0	1	236	311925	312160	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	236	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
15026122	15026122	PRJEB83101_P_NODE_83872_length_243_cov_0.917647_g83567_i0	PRJEB83101	83872	243	0.917647	2.22988221	Deinococcus	1298	Bacteria	Bacteria	219	2.0399999999999998e-52	NTclustered	gi\|2152126279\|gb\|CP086384.1\|	32062	g83567	i0	90.361	1.36625514403292	166	16	68	0	78	243	83901	83736	Deinococcus radiophilus strain ATCC 27603 plasmid pRadio3, complete sequence	blastn	332	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
19267451	19267451	PRJEB83101_P_NODE_43396_length_288_cov_1.246512_g43091_i0	PRJEB83101	43396	288	1.246512	3.58995456	Deinococcus radiophilus	32062	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g43091	i0	99.653	2.15972222222222	288	1	100	0	1	288	745761	745474	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	622	527	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
19268370	19268370	PRJEB83101_P_NODE_78156_length_246_cov_0.901734_g77851_i0	PRJEB83101	78156	246	0.901734	2.21826564	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	322	1.53e-83	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g77851	i0	90.283	7.72764227642276	247	22	100	2	1	246	887163	887408	Deinococcus sp. NW-56 chromosome, complete genome	blastn	1901	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
20124364	20124364	PRJEB83101_P_NODE_39176_length_298_cov_1.733333_g38871_i0	PRJEB83101	39176	298	1.733333	5.16533234	Truepera	332248	Bacteria	Bacteria	407	5.1299999999999995e-109	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g38871	i0	91.275	54.5	298	26	100	0	1	298	552	849	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	16241	407	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
21819298	21819298	PRJEB83101_P_NODE_65658_length_253_cov_0.866667_g65353_i0	PRJEB83101	65658	253	0.866667	2.19266751	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	350	7.27e-92	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g65353	i0	91.667	2.78656126482213	252	21	99	0	1	252	2666579	2666328	Deinococcus sp. NW-56 chromosome, complete genome	blastn	705	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
22674890	22674890	PRJEB83101_P_NODE_57398_length_264_cov_1.408377_g57093_i0	PRJEB83101	57398	264	1.408377	3.71811528	Truepera	332248	Bacteria	Bacteria	300	7.8e-77	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g57093	i0	87.17	10.280303030303	265	32	100	2	1	264	1729849	1729586	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	2714	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
22674978	22674978	PRJEB83101_P_NODE_64978_length_253_cov_1.300000_g64673_i0	PRJEB83101	64978	253	1.3	3.289	Truepera	332248	Bacteria	Bacteria	279	9.67e-71	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g64673	i0	86.614	23.5059288537549	254	32	100	2	1	253	471	219	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	5947	279	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
23094741	23094741	PRJEB83101_P_NODE_71159_length_250_cov_0.881356_g70854_i0	PRJEB83101	71159	250	0.881356	2.20339	Thermus scotoductus	37636	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g70854	i0	100	6.004	250	0	100	0	1	250	1847178	1847427	Thermus scotoductus SA-01, complete genome	blastn	1501	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
23095102	23095102	PRJEB83101_P_NODE_84439_length_243_cov_0.917647_g84134_i0	PRJEB83101	84439	243	0.917647	2.22988221	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	339	1.4999999999999997e-88	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g84134	i0	91.77	7.89300411522634	243	20	100	0	1	243	956106	955864	Deinococcus sp. NW-56 chromosome, complete genome	blastn	1918	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
23950733	23950733	PRJEB83101_P_NODE_89019_length_233_cov_2.506250_g88714_i0	PRJEB83101	89019	233	2.50625	5.8395625	Deinococcus	1298	Bacteria	Bacteria	392	1.08e-104	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g88714	i0	96.996	207.025751072961	233	7	100	0	1	233	819	587	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	48237	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis

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