metadata: contig_metadata: 28 rows where bioproject = "PRJNA685607" and tax

28 rows where bioproject = "PRJNA685607" 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
1176452	1176452	PRJNA685607_P_NODE_65341_length_251_cov_0.865169_g64982_i0	PRJNA685607	65341	251	0.865169	2.17157419	Deinococcus	1298	Bacteria	Bacteria	224	4.5599999999999996e-54	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g64982	i0	83.402	4.61752988047809	241	40	96	0	1	241	137770	138010	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	1159	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1942271	1942271	PRJNA685607_P_NODE_33682_length_318_cov_1.224490_g33323_i0	PRJNA685607	33682	318	1.22449	3.8938782	Deinococcus aetherius	200252	Bacteria	Bacteria	571	1.8499999999999996e-158	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g33323	i0	99.06	1.40566037735849	319	2	100	1	1	318	63500	63182	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	447	571	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
1942470	1942470	PRJNA685607_P_NODE_90562_length_243_cov_0.905882_g90203_i0	PRJNA685607	90562	243	0.905882	2.20129326	Deinococcus gobiensis	502394	Bacteria	Bacteria	154	5.84e-33	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g90203	i0	78.512	2.65020576131687	242	46	98	6	2	240	2291281	2291043	Deinococcus gobiensis I-0, complete genome	blastn	644	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
3217388	3217388	PRJNA685607_P_NODE_93443_length_242_cov_0.911243_g93084_i0	PRJNA685607	93443	242	0.911243	2.20520806	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g93084	i0	85.062	24.0454545454545	241	35	99	1	1	240	1992054	1991814	Deinococcus sp. QL22 chromosome, complete genome	blastn	5819	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
3728227	3728227	PRJNA685607_P_NODE_65403_length_251_cov_0.865169_g65044_i0	PRJNA685607	65403	251	0.865169	2.17157419	Deinococcus	1298	Bacteria	Bacteria	135	2.2e-27	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g65044	i0	81.875	1.27490039840637	160	29	64	0	92	251	365362	365203	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	320	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
5770107	5770107	PRJNA685607_P_NODE_92505_length_242_cov_0.911243_g92146_i0	PRJNA685607	92505	242	0.911243	2.20520806	Deinococcus metallilatus	1211322	Bacteria	Bacteria	135	2.1e-27	NTclustered	gi\|1609450184\|gb\|CP038510.1\|	1211322	g92146	i0	77.236	1.01652892561983	246	46	99	9	1	241	784876	784636	Deinococcus metallilatus strain MA1002 plasmid unnamed1, complete sequence	blastn	246	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
7045142	7045142	PRJNA685607_P_NODE_85846_length_244_cov_0.900585_g85487_i0	PRJNA685607	85846	244	0.900585	2.1974274	Deinococcus aestuarii	2774531	Bacteria	Bacteria	119	1.8099999999999999e-31	NR	WP_216326326.1	2774531	g85487	i0	79.5	0.959016393442623	78	16	95.9	0	3	236	13	90	WP_216326326.1 LutC/YkgG family protein [Deinococcus aestuarii]	diamond	234	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
8829481	8829481	PRJNA685607_P_NODE_94647_length_241_cov_0.916667_g94288_i0	PRJNA685607	94647	241	0.916667	2.20916747	Thermaceae	188786	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g94288	i0	98.34	48.850622406639	241	4	100	0	1	241	1887935	1887695	Meiothermus ruber DSM 1279, complete genome	blastn	11773	424	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
9594935	9594935	PRJNA685607_P_NODE_50948_length_276_cov_1.458128_g50589_i0	PRJNA685607	50948	276	1.458128	4.02443328	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	359	1.34e-94	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g50589	i0	90.217	3.66304347826087	276	26	99	1	2	276	1592415	1592140	Deinococcus sp. QL22 chromosome, complete genome	blastn	1011	359	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
13930451	13930451	PRJNA685607_P_NODE_77411_length_247_cov_0.885057_g77052_i0	PRJNA685607	77411	247	0.885057	2.18609079	Truepera	332248	Bacteria	Bacteria	111	3.63e-20	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g77052	i0	83.333	5.49392712550607	126	15	50	5	1	123	1979908	1980030	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	1357	111	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
14695196	14695196	PRJNA685607_P_NODE_13952_length_430_cov_1.820728_g13594_i0	PRJNA685607	13952	430	1.820728	7.8291304	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g13594	i0	100	0.0674418604651163	29	0	7	0	301	329	1334995	1335023	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	29	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17244236	17244236	PRJNA685607_P_NODE_25334_length_348_cov_0.956364_g24975_i0	PRJNA685607	25334	348	0.956364	3.32814672	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	377	4.79e-100	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g24975	i0	95.726	2.03448275862069	234	10	100	0	115	348	293389	293622	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	708	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19028227	19028227	PRJNA685607_P_NODE_8935_length_519_cov_0.995516_g8579_i0	PRJNA685607	8935	519	0.995516	5.16672804	Deinococcus antarcticus	1298767	Bacteria	Bacteria	188	3.0300000000000003e-58	NR	WP_380078269.1	1298767	g8579	i0	99	0.589595375722543	102	1	59	0	308	3	1	102	WP_380078269.1 CBS domain-containing protein [Deinococcus antarcticus]	diamond	306	188	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
19793375	19793375	PRJNA685607_P_NODE_78276_length_247_cov_0.885057_g77917_i0	PRJNA685607	78276	247	0.885057	2.18609079	Deinococcus sp. QL22	2939437	Bacteria	Bacteria	313	9.28e-81	NTclustered	gi\|2238957582\|gb\|CP097149.1\|	2939437	g77917	i0	89.474	5.49392712550607	247	26	100	0	1	247	1543237	1543483	Deinococcus sp. QL22 chromosome, complete genome	blastn	1357	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. QL22
22343547	22343547	PRJNA685607_P_NODE_22418_length_362_cov_1.041522_g22059_i0	PRJNA685607	22418	362	1.041522	3.77030964	Deinococcus radiopugnans	57497	Bacteria	Bacteria	237	8.830000000000001e-58	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g22059	i0	80.183	2.69060773480663	328	55	89	7	13	335	2266105	2265783	Deinococcus swuensis strain DY59, complete genome	blastn	974	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
23619247	23619247	PRJNA685607_P_NODE_69459_length_250_cov_0.870056_g69100_i0	PRJNA685607	69459	250	0.870056	2.17514	Deinococcus aetherius	200252	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g69100	i0	99.2	1	250	2	100	0	1	250	517069	516820	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	250	451	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
23619348	23619348	PRJNA685607_P_NODE_93039_length_242_cov_0.911243_g92680_i0	PRJNA685607	93039	242	0.911243	2.20520806	Deinococcus geothermalis	68909	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g92680	i0	99.587	1.98760330578512	242	1	100	0	1	242	93169	92928	Deinococcus geothermalis DSM 11300, complete genome	blastn	481	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
24892539	24892539	PRJNA685607_P_NODE_76860_length_247_cov_0.885057_g76501_i0	PRJNA685607	76860	247	0.885057	2.18609079	uncultured Truepera sp.	543023	Bacteria	Bacteria	92.8	1.78e-20	NR	CAA9557627.1	543023	g76501	i0	85.4	0.582995951417004	48	7	58.3	0	145	2	22	69	CAA9557627.1 MAG: proline iminopeptidase-related protein [uncultured Truepera sp.]	diamond	144	92.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
25402869	25402869	PRJNA685607_P_NODE_50620_length_277_cov_1.132353_g50261_i0	PRJNA685607	50620	277	1.132353	3.13661781	Deinococcus	1298	Bacteria	Bacteria	292	1.38e-74	NTclustered	gi\|2444123840\|gb\|CP115166.1\|	328692	g50261	i0	86.131	6.63537906137184	274	34	98	4	5	276	276805	276534	Deinococcus aquaticus strain PB-314 plasmid pDATS01, complete sequence	blastn	1838	294	0.993197278911565	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
26702193	26702193	PRJNA685607_P_NODE_81181_length_246_cov_0.890173_g80822_i0	PRJNA685607	81181	246	0.890173	2.18982558	Deinococcus antarcticus	1298767	Bacteria	Bacteria	170	4.3700000000000003e-51	NR	WP_380080614.1	1298767	g80822	i0	98.8	1	82	1	100	0	246	1	1	82	WP_380080614.1 alpha/beta hydrolase [Deinococcus antarcticus]	diamond	246	170	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
29292692	29292692	PRJNA685607_P_NODE_87289_length_244_cov_0.900585_g86930_i0	PRJNA685607	87289	244	0.900585	2.1974274	Deinococcus cavernae	2320857	Bacteria	Bacteria	157	2.6199999999999994e-42	NR	WP_158591524.1	2320857	g86930	i0	98.8	1.9672131147541	80	1	98.4	0	243	4	740	819	WP_158591524.1 phospholipase D-like domain-containing protein [Deinococcus cavernae]	diamond	480	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae
30062059	30062059	PRJNA685607_P_NODE_66451_length_251_cov_0.865169_g66092_i0	PRJNA685607	66451	251	0.865169	2.17157419	Thermus	270	Bacteria	Bacteria	65.5	3.98e-10	NR	WP_185747603.1	1214928	g66092	i0	50.7	1.69721115537849	71	33	84.9	1	213	1	446	514	WP_185747603.1 DUF5591 domain-containing protein [Thermus tengchongensis]	diamond	426	65.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus tengchongensis
30082070	30082070	PRJNA685607_P_NODE_71212_length_249_cov_0.875000_g70853_i0	PRJNA685607	71212	249	0.875	2.17875	Deinococcus antarcticus	1298767	Bacteria	Bacteria	119	2.91e-32	NR	WP_380078512.1	1298767	g70853	i0	87.9	0.795180722891566	66	8	79.5	0	248	51	66	131	WP_380078512.1 hypothetical protein [Deinococcus antarcticus]	diamond	198	119	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30145111	30145111	PRJNA685607_P_NODE_74532_length_248_cov_0.880000_g74173_i0	PRJNA685607	74532	248	0.88	2.1824	Deinococcus piscis	394230	Bacteria	Bacteria	112	1.09e-26	NR	WP_189643872.1	394230	g74173	i0	85.3	0.82258064516129	68	10	82.3	0	248	45	412	479	WP_189643872.1 type I-C CRISPR-associated protein Cas8c/Csd1 [Deinococcus piscis]	diamond	204	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
30840551	30840551	PRJNA685607_P_NODE_18534_length_387_cov_0.980892_g18176_i0	PRJNA685607	18534	387	0.980892	3.79605204	Deinococcus antarcticus	1298767	Bacteria	Bacteria	199	1.51e-63	NR	WP_380080835.1	1298767	g18176	i0	98.1	0.821705426356589	106	2	82.2	0	318	1	1	106	WP_380080835.1 hypothetical protein [Deinococcus antarcticus]	diamond	318	199	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
31314565	31314565	PRJNA685607_P_NODE_95615_length_241_cov_0.916667_g95256_i0	PRJNA685607	95615	241	0.916667	2.20916747	Deinococcus fonticola	2528713	Bacteria	Bacteria	127	4.45e-32	NR	WP_135228095.1	2528713	g95256	i0	92.6	0.846473029045643	68	5	84.6	0	206	3	202	269	WP_135228095.1 2',3'-cyclic-nucleotide 2'-phosphodiesterase [Deinococcus fonticola]	diamond	204	127	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
31599390	31599390	PRJNA685607_P_NODE_65156_length_251_cov_0.865169_g64797_i0	PRJNA685607	65156	251	0.865169	2.17157419	Deinococcus ficus	317577	Bacteria	Bacteria	100	1.9300000000000001e-22	NR	WP_084473728.1	317577	g64797	i0	72.5	0.956175298804781	80	22	95.6	0	12	251	450	529	WP_084473728.1 tetratricopeptide repeat protein [Deinococcus ficus]	diamond	240	100	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
32168905	32168905	PRJNA685607_P_NODE_91978_length_242_cov_0.911243_g91619_i0	PRJNA685607	91978	242	0.911243	2.20520806	Deinococcus antarcticus	1298767	Bacteria	Bacteria	145	2.71e-40	NR	WP_380079439.1	1298767	g91619	i0	94.9	0.979338842975207	79	4	97.9	0	5	241	125	203	WP_380079439.1 glycosyltransferase [Deinococcus antarcticus]	diamond	237	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus

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