metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA724039" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA724039" 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
711213	711213	PRJNA724039_S_NODE_5881_length_284_cov_5.376518_g5674_i0	PRJNA724039	5881	284	5.376518	15.26931112	Deinococcus taeanensis	2737050	Bacteria	Bacteria	335	2.319999999999999e-87	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g5674	i0	88.38	5.30281690140845	284	26	100	4	1	284	230943	231219	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	1506	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
1194146	1194146	PRJNA724039_S_NODE_2081_length_530_cov_162.103448_g1885_i0	PRJNA724039	2081	530	162.103448	859.1482744	Deinococcus	1298	Bacteria	Bacteria	822	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g1885	i0	94.915	226.72641509434	531	18	99	9	1	525	2341700	2341173	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	120165	822	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1987061	1987061	PRJNA724039_S_NODE_11402_length_191_cov_1.422078_g11195_i0	PRJNA724039	11402	191	1.422078	2.71616898	Deinococcus taeanensis	2737050	Bacteria	Bacteria	189	1.1999999999999999e-43	NTclustered	gi\|2105692036\|gb\|CP083455.1\|	2737050	g11195	i0	90.278	0.979057591623037	144	14	75	0	48	191	2599429	2599286	Deinococcus taeanensis strain TS293 chromosome, complete genome	blastn	187	189	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
1987104	1987104	PRJNA724039_S_NODE_13882_length_171_cov_16.104478_g13675_i0	PRJNA724039	13882	171	16.104478	27.53865738	Deinococcus aquaticus	328692	Bacteria	Bacteria	311	2.14e-80	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g13675	i0	99.415	153.076023391813	171	1	100	0	1	171	714932	714762	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	26176	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
3262369	3262369	PRJNA724039_S_NODE_13443_length_174_cov_180.182482_g13236_i0	PRJNA724039	13443	174	180.182482	313.51751868	Deinococcus grandis	57498	Bacteria	Bacteria	289	1.02e-73	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g13236	i0	96.571	256.304597701149	175	4	100	2	1	174	73467	73294	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	44597	289	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
5022442	5022442	PRJNA724039_S_NODE_2644_length_456_cov_244.510740_g1428_i2	PRJNA724039	2644	456	244.51074	1114.9689744	Deinococcus	1298	Bacteria	Bacteria	710	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g1428	i2	94.748	316.34649122807	457	23	100	1	1	456	73259	72803	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	144254	717	0.99023709902371	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
5814680	5814680	PRJNA724039_S_NODE_14805_length_166_cov_1.209302_g14598_i0	PRJNA724039	14805	166	1.209302	2.00744132	Deinococcus metallilatus	1211322	Bacteria	Bacteria	230	5.98e-56	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g14598	i0	92.5	8.18072289156627	160	12	96	0	6	165	1099638	1099479	Deinococcus metallilatus strain MA1002 chromosome	blastn	1358	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
5814799	5814799	PRJNA724039_S_NODE_4905_length_316_cov_104.781362_g4698_i0	PRJNA724039	4905	316	104.781362	331.10910392	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	468	2.48e-127	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g4698	i0	93.651	246.958860759494	315	16	99	2	1	315	544482	544172	Deinococcus sp. NW-56 chromosome, complete genome	blastn	78039	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6298187	6298187	PRJNA724039_S_NODE_1605_length_627_cov_152.562712_g1428_i0	PRJNA724039	1605	627	152.562712	956.56820424	Deinococcus	1298	Bacteria	Bacteria	830	0	NTclustered	gi\|1028459476\|gb\|CP011387.1\|	1182568	g1428	i0	92.894	185.712918660287	577	31	91	9	1	571	71488	72060	Deinococcus puniceus strain DY1, complete genome	blastn	116442	830	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus puniceus
6298208	6298208	PRJNA724039_S_NODE_3165_length_410_cov_7.621984_g2958_i0	PRJNA724039	3165	410	7.621984	31.2501344	Deinococcus	1298	Bacteria	Bacteria	747	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g2958	i0	99.512	59.280487804878	410	2	100	0	1	410	1057242	1057651	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	24305	747	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7572009	7572009	PRJNA724039_S_NODE_2646_length_456_cov_216.028640_g1428_i3	PRJNA724039	2646	456	216.02864	985.0905984	Deinococcus	1298	Bacteria	Bacteria	728	0	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g1428	i3	95.455	260.997807017544	462	12	100	7	1	456	1026	568	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	119015	728	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
8847195	8847195	PRJNA724039_S_NODE_4907_length_316_cov_91.724014_g4700_i0	PRJNA724039	4907	316	91.724014	289.84788424	Deinococcus	1298	Bacteria	Bacteria	582	8.489999999999998e-162	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g4700	i0	100	214.433544303797	315	0	99	0	2	316	2672108	2671794	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	67761	582	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
9639710	9639710	PRJNA724039_S_NODE_5028_length_312_cov_79.883636_g4821_i0	PRJNA724039	5028	312	79.883636	249.23694432	Deinococcus metallilatus	1211322	Bacteria	Bacteria	481	3.14e-131	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g4821	i0	94.551	544.432692307692	312	15	99	2	2	312	329916	330226	Deinococcus metallilatus strain MA1002 chromosome	blastn	169863	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
10915280	10915280	PRJNA724039_S_NODE_4749_length_322_cov_162.757895_g4542_i0	PRJNA724039	4749	322	162.757895	524.0804219	Deinococcus grandis	57498	Bacteria	Bacteria	521	1.9199999999999993e-143	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g4542	i0	96.273	224.919254658385	322	4	100	5	1	322	73607	73294	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	72424	521	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
12190589	12190589	PRJNA724039_S_NODE_8710_length_222_cov_11.308108_g8503_i0	PRJNA724039	8710	222	11.308108	25.10399976	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	250	6.51e-62	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g8503	i0	89.216	205.563063063063	204	16	91	5	11	212	545827	546026	Deinococcus sp. NW-56 chromosome, complete genome	blastn	45635	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12673773	12673773	PRJNA724039_S_NODE_4750_length_322_cov_107.624561_g4543_i0	PRJNA724039	4750	322	107.624561	346.55108642	Deinococcus	1298	Bacteria	Bacteria	483	9.039999999999999e-132	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g4543	i0	93.789	227.77950310559	322	18	99	2	2	322	69933	70253	Deinococcus swuensis strain DY59, complete genome	blastn	73345	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
13464932	13464932	PRJNA724039_S_NODE_2071_length_531_cov_207.378543_g1875_i0	PRJNA724039	2071	531	207.378543	1101.18006333	Deinococcus taeanensis	2737050	Bacteria	Bacteria	830	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g1875	i0	95.265	228.453860640301	528	17	98	8	9	531	1950	1426	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	121309	830	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
13948010	13948010	PRJNA724039_S_NODE_2091_length_529_cov_74.837398_g1895_i0	PRJNA724039	2091	529	74.837398	395.88983542	Deinococcus	1298	Bacteria	Bacteria	621	3.1499999999999995e-173	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g1895	i0	88.18	280.697542533081	533	47	99	14	1	527	2560	2038	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	148489	621	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
14740225	14740225	PRJNA724039_S_NODE_2072_length_531_cov_169.613360_g1876_i0	PRJNA724039	2072	531	169.61336	900.6469416	Deinococcus taeanensis	2737050	Bacteria	Bacteria	830	0	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g1876	i0	95.247	228.060263653484	526	21	98	4	9	531	1950	1426	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	121100	830	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
16013816	16013816	PRJNA724039_S_NODE_9933_length_206_cov_66.124260_g9726_i0	PRJNA724039	9933	206	66.12426	136.2159756	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g9726	i0	100	194.004854368932	206	0	100	0	1	206	1636291	1636086	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	39965	381	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
17289178	17289178	PRJNA724039_S_NODE_2034_length_537_cov_119.218000_g1839_i0	PRJNA724039	2034	537	119.218	640.20066	Deinococcus grandis	57498	Bacteria	Bacteria	948	0	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g1839	i0	98.513	95.0260707635009	538	7	100	1	1	537	118229	118766	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	51029	948	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18563059	18563059	PRJNA724039_S_NODE_9935_length_206_cov_44.520710_g9728_i0	PRJNA724039	9935	206	44.52071	91.7126626	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	375	9.41e-100	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g9728	i0	100	167.78640776699	203	0	99	0	4	206	56722	56924	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	34564	375	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
22388561	22388561	PRJNA724039_S_NODE_2018_length_540_cov_101.560636_g1824_i0	PRJNA724039	2018	540	101.560636	548.4274344	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	808	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g1824	i0	93.75	101.764814814815	544	25	99	7	2	540	477642	478181	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	54953	808	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
22871655	22871655	PRJNA724039_S_NODE_2998_length_422_cov_212.057143_g2791_i0	PRJNA724039	2998	422	212.057143	894.88114346	Deinococcus	1298	Bacteria	Bacteria	780	0	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g2791	i0	100	105.973933649289	422	0	100	0	1	422	839	418	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	44721	780	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23664248	23664248	PRJNA724039_S_NODE_4799_length_320_cov_119.752650_g4592_i0	PRJNA724039	4799	320	119.75265	383.20848	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	514	3.18e-141	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g4592	i0	95.625	226.909375	320	14	100	0	1	320	74586	74267	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	72611	514	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
24937641	24937641	PRJNA724039_S_NODE_17000_length_155_cov_0.983051_g16793_i0	PRJNA724039	17000	155	0.983051	1.52372905	Deinococcus metallilatus	1211322	Bacteria	Bacteria	252	1.17e-62	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g16793	i0	96.689	71.6193548387097	151	5	97	0	4	154	2718363	2718213	Deinococcus metallilatus strain MA1002 chromosome	blastn	11101	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
24937718	24937718	PRJNA724039_S_NODE_4800_length_320_cov_83.756184_g4593_i0	PRJNA724039	4800	320	83.756184	268.0197888	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	525	1.4699999999999994e-144	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g4593	i0	96.25	218.0375	320	12	100	0	1	320	74267	74586	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	69772	525	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
24937731	24937731	PRJNA724039_S_NODE_5400_length_299_cov_12.015267_g5193_i0	PRJNA724039	5400	299	12.015267	35.92564833	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	424	5.11e-114	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g5193	i0	98.347	168.655518394649	242	3	81	1	1	242	58008	58248	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	50428	424	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
25420743	25420743	PRJNA724039_S_NODE_5000_length_313_cov_90.840580_g4793_i0	PRJNA724039	5000	313	90.84058	284.3310154	Deinococcus	1298	Bacteria	Bacteria	579	1.0899999999999999e-160	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g4793	i0	100	450.996805111821	313	0	100	0	1	313	2148126	2147814	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	141162	579	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis

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