metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1249042" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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
354210	354210	PRJNA1249042_S_NODE_2581_length_580_cov_17.722533_g2393_i0	PRJNA1249042	2581	580	17.722533	102.7906914	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	647	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g2393	i0	88.561	268.829310344828	542	50	93	11	44	580	543113	543647	Deinococcus sp. NW-56 chromosome, complete genome	blastn	155921	647	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
2327572	2327572	PRJNA1249042_S_NODE_2322_length_640_cov_21.951424_g2155_i0	PRJNA1249042	2322	640	21.951424	140.4891136	Deinococcus	1298	Bacteria	Bacteria	961	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g2155	i0	93.779	441.825	643	34	100	5	1	640	2084185	2084824	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	282768	961	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
2905020	2905020	PRJNA1249042_S_NODE_11823_length_296_cov_53.320158_g11609_i0	PRJNA1249042	11823	296	53.320158	157.82766768	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	514	2.92e-141	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g11609	i0	97.973	235.712837837838	296	6	100	0	1	296	1362514	1362219	Deinococcus sp. QL22 chromosome, complete genome	blastn	69771	514	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
2905294	2905294	PRJNA1249042_S_NODE_45903_length_215_cov_3.302326_g45689_i0	PRJNA1249042	45903	215	3.302326	7.1000009	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	309	1.02e-79	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g45689	i0	92.558	9.57674418604651	215	16	100	0	1	215	2324461	2324675	Deinococcus sp. AJ005 chromosome, complete genome	blastn	2059	309	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
3602777	3602777	PRJNA1249042_S_NODE_49723_length_210_cov_2.688623_g49509_i0	PRJNA1249042	49723	210	2.688623	5.6461083	Deinococcus	1298	Bacteria	Bacteria	305	1.28e-78	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g49509	i0	92.857	203.7	210	15	100	0	1	210	2027	2236	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	42777	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
4181670	4181670	PRJNA1249042_S_NODE_4404_length_414_cov_15.312668_g4191_i0	PRJNA1249042	4404	414	15.312668	63.39444552	Deinococcus geothermalis	68909	Bacteria	Bacteria	483	1.19e-131	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g4191	i0	87.828	327.504830917874	419	42	100	9	1	414	326389	325975	Deinococcus geothermalis DSM 11300, complete genome	blastn	135587	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
4181994	4181994	PRJNA1249042_S_NODE_8664_length_320_cov_2.996390_g8450_i0	PRJNA1249042	8664	320	2.99639	9.588448	Trueperaceae bacterium	2026798	Bacteria	Bacteria	403	7.19e-108	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g8450	i0	91.246	868.284375	297	25	93	1	3	298	6817	6521	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	277851	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4181997	4181997	PRJNA1249042_S_NODE_8744_length_319_cov_19.090580_g8530_i0	PRJNA1249042	8744	319	19.09058	60.8989502	Deinococcus aquaticus	328692	Bacteria	Bacteria	390	5.5799999999999996e-104	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g8530	i0	88.889	218.467084639498	324	27	100	5	1	319	715881	716200	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	69691	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4880241	4880241	PRJNA1249042_S_NODE_11824_length_296_cov_47.699605_g11610_i0	PRJNA1249042	11824	296	47.699605	141.1908308	Deinococcus	1298	Bacteria	Bacteria	531	2.899999999999999e-146	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g11610	i0	98.99	236.371621621622	297	1	100	2	1	296	70487	70192	Deinococcus swuensis strain DY59, complete genome	blastn	69966	536	0.990671641791045	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
5457729	5457729	PRJNA1249042_S_NODE_23385_length_255_cov_3.042453_g23171_i0	PRJNA1249042	23385	255	3.042453	7.75825515	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	449	7.03e-122	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g23171	i0	98.431	22.9450980392157	255	4	100	0	1	255	15085	15339	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	5851	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
6154916	6154916	PRJNA1249042_S_NODE_11345_length_299_cov_10.078125_g11131_i0	PRJNA1249042	11345	299	10.078125	30.13359375	Deinococcus	1298	Bacteria	Bacteria	496	1.0699999999999999e-135	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g11131	i0	96.667	448.137123745819	300	7	100	2	1	299	69588	69291	Deinococcus swuensis strain DY59, complete genome	blastn	133993	496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
6732343	6732343	PRJNA1249042_S_NODE_53246_length_206_cov_1.852761_g53032_i0	PRJNA1249042	53246	206	1.852761	3.81668766	Deinococcus radiophilus	32062	Bacteria	Bacteria	375	9.41e-100	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g53032	i0	99.515	195.368932038835	206	1	100	0	1	206	1812822	1813027	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	40246	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
7430204	7430204	PRJNA1249042_S_NODE_5246_length_381_cov_29.263314_g5032_i0	PRJNA1249042	5246	381	29.263314	111.49322634	Deinococcus	1298	Bacteria	Bacteria	647	0	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g5032	i0	97.375	217.005249343832	381	9	100	1	1	381	2017558	2017937	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	82679	652	0.992331288343558	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
8007595	8007595	PRJNA1249042_S_NODE_114467_length_151_cov_4.351852_g114253_i0	PRJNA1249042	114467	151	4.351852	6.57129652	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	241	2.4500000000000008e-59	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g114253	i0	95.364	209.258278145695	151	7	100	0	1	151	545140	545290	Deinococcus sp. NW-56 chromosome, complete genome	blastn	31598	241	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
8007769	8007769	PRJNA1249042_S_NODE_2987_length_521_cov_23.079498_g2784_i0	PRJNA1249042	2987	521	23.079498	120.24418458	Deinococcus grandis	57498	Bacteria	Bacteria	569	1.1399999999999996e-157	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g2784	i0	89.301	186.767754318618	458	44	87	4	24	477	116446	116902	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	97306	569	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8705053	8705053	PRJNA1249042_S_NODE_41547_length_222_cov_1.251397_g41333_i0	PRJNA1249042	41547	222	1.251397	2.77810134	Deinococcus	1298	Bacteria	Bacteria	411	2.8199999999999996e-110	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g41333	i0	100	127.815315315315	222	0	100	0	1	222	231	452	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	28375	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
8705086	8705086	PRJNA1249042_S_NODE_5287_length_380_cov_27.887240_g5073_i0	PRJNA1249042	5287	380	27.88724	105.971512	Deinococcus	1298	Bacteria	Bacteria	619	7.92e-173	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g5073	i0	96.053	214.986842105263	380	15	100	0	1	380	2017558	2017937	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	81695	625	0.9904	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
11255556	11255556	PRJNA1249042_S_NODE_3609_length_464_cov_23.619952_g3398_i0	PRJNA1249042	3609	464	23.619952	109.59657728	Deinococcus	1298	Bacteria	Bacteria	516	1.33e-141	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g3398	i0	87.013	189.211206896552	462	55	99	5	3	464	881519	881063	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	87794	516	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
11833492	11833492	PRJNA1249042_S_NODE_93610_length_166_cov_2.097561_g93396_i0	PRJNA1249042	93610	166	2.097561	3.48195126	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g93396	i0	100	1	166	0	100	0	1	166	296459	296624	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	166	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
12530847	12530847	PRJNA1249042_S_NODE_2310_length_643_cov_28.840000_g2144_i0	PRJNA1249042	2310	643	28.84	185.4412	Deinococcus	1298	Bacteria	Bacteria	987	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g2144	i0	94.436	454.503888024883	647	27	100	9	1	643	2341634	2342275	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	292246	987	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
12530893	12530893	PRJNA1249042_S_NODE_4010_length_434_cov_20.782609_g3798_i0	PRJNA1249042	4010	434	20.782609	90.19652306	Deinococcus	1298	Bacteria	Bacteria	691	0	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g3798	i0	95.423	404.691244239631	437	15	100	3	1	434	2672312	2672746	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	175636	691	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
14383576	14383576	PRJNA1249042_S_NODE_40292_length_223_cov_6.100000_g40078_i0	PRJNA1249042	40292	223	6.1	13.603	Deinococcus taeanensis	2737050	Bacteria	Bacteria	318	1.77e-82	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g40078	i0	92.411	163.188340807175	224	15	100	2	1	223	1489	1711	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	36391	318	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
14383668	14383668	PRJNA1249042_S_NODE_51952_length_207_cov_3.768293_g51738_i0	PRJNA1249042	51952	207	3.768293	7.80036651	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	228	2.8e-55	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g51738	i0	86.603	146.855072463768	209	24	100	3	1	207	97775	97569	Deinococcus sp. AJ005 chromosome, complete genome	blastn	30399	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
16354672	16354672	PRJNA1249042_S_NODE_3813_length_447_cov_7.722772_g3601_i0	PRJNA1249042	3813	447	7.722772	34.52079084	root	1	Root_unresolved	Root_unresolved	689	0	NTclustered	gi\|2444916559\|dbj\|LC733524.2\|	47478	g3601	i0	94.444	105.523489932886	450	21	100	4	1	447	506	58	Deinococcus sp. AKn-1 gene for 16S rRNA, partial sequence	blastn	47169	689	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
16354746	16354746	PRJNA1249042_S_NODE_76093_length_181_cov_3.826087_g75879_i0	PRJNA1249042	76093	181	3.826087	6.92521747	Truepera	332248	Bacteria	Bacteria	313	6.39e-81	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g75879	i0	97.802	382.386740331492	182	3	100	1	1	181	2624	2443	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	69212	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
17629949	17629949	PRJNA1249042_S_NODE_2314_length_642_cov_33.080134_g2148_i0	PRJNA1249042	2314	642	33.080134	212.37446028	Deinococcus	1298	Bacteria	Bacteria	1090	0	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g2148	i0	97.352	409.453271028037	642	16	100	1	1	642	880095	880735	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	262869	1090	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
20755786	20755786	PRJNA1249042_S_NODE_14617_length_283_cov_2.545833_g14403_i0	PRJNA1249042	14617	283	2.545833	7.20470739	Deinococcus metallilatus	1211322	Bacteria	Bacteria	366	8.21e-97	NTclustered	gi\|1609450184\|gb\|CP038510.1\|	1211322	g14403	i0	90.614	8.61837455830389	277	25	98	1	1	276	515947	515671	Deinococcus metallilatus strain MA1002 plasmid unnamed1, complete sequence	blastn	2439	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
24004205	24004205	PRJNA1249042_S_NODE_2279_length_651_cov_33.595395_g2115_i0	PRJNA1249042	2279	651	33.595395	218.70602145	Deinococcus	1298	Bacteria	Bacteria	1031	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g2115	i0	95.245	456.986175115207	652	30	100	1	1	651	69617	70268	Deinococcus swuensis strain DY59, complete genome	blastn	297498	1031	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
24580580	24580580	PRJNA1249042_S_NODE_12340_length_293_cov_32.112000_g12126_i0	PRJNA1249042	12340	293	32.112	94.08816	Deinococcus metallilatus	1211322	Bacteria	Bacteria	468	2.28e-127	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g12126	i0	95.563	203.440273037543	293	11	100	2	1	293	329422	329712	Deinococcus metallilatus strain MA1002 chromosome	blastn	59608	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
24580710	24580710	PRJNA1249042_S_NODE_2700_length_560_cov_7.069632_g2506_i0	PRJNA1249042	2700	560	7.069632	39.5899392	Trueperaceae bacterium	2026798	Bacteria	Bacteria	664	0	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g2506	i0	88.971	288.351785714286	544	51	96	5	1	537	8207	7666	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	161477	664	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
25278328	25278328	PRJNA1249042_S_NODE_2580_length_580_cov_24.929236_g2392_i0	PRJNA1249042	2580	580	24.929236	144.5895688	Deinococcus	1298	Bacteria	Bacteria	693	0	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g2392	i0	88.428	299.436206896552	579	61	99	5	1	578	880946	881519	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	173673	693	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
25278369	25278369	PRJNA1249042_S_NODE_3960_length_437_cov_28.766497_g3748_i0	PRJNA1249042	3960	437	28.766497	125.70959189	Deinococcus	1298	Bacteria	Bacteria	773	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g3748	i0	98.624	399.070938215103	436	6	99	0	1	436	69291	69726	Deinococcus swuensis strain DY59, complete genome	blastn	174394	773	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans

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