metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA540466" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA540466" 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
5611732	5611732	PRJNA540466_S_NODE_28265_length_337_cov_2.553030_g27716_i0	PRJNA540466	28265	337	2.55303	8.6037111	Deinococcus geothermalis	68909	Bacteria	Bacteria	525	1.5599999999999995e-144	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g27716	i0	98.328	0.887240356083086	299	5	89	0	19	317	2117004	2117302	Deinococcus geothermalis DSM 11300, complete genome	blastn	299	525	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
6222032	6222032	PRJNA540466_S_NODE_23785_length_365_cov_3.205479_g23236_i0	PRJNA540466	23785	365	3.205479	11.69999835	Thermus	270	Bacteria	Bacteria	446	1.36e-120	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g23236	i0	98.8	32.9698630136986	250	3	68	0	17	266	844950	845199	Thermus scotoductus SA-01, complete genome	blastn	12034	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
6885853	6885853	PRJNA540466_S_NODE_55886_length_252_cov_4.262570_g55337_i0	PRJNA540466	55886	252	4.26257	10.7416764	Deinococcus taeanensis	2737050	Bacteria	Bacteria	291	4.45e-74	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g55337	i0	97.093	138.563492063492	172	5	68	0	69	240	1284	1113	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	34918	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
8160713	8160713	PRJNA540466_S_NODE_23047_length_370_cov_38051.855219_g22498_i0	PRJNA540466	23047	370	38051.855219	140791.8643103	Deinococcus geothermalis	68909	Bacteria	Bacteria	411	5.039999999999999e-110	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g22498	i0	98.298	108.3	235	3	63	1	14	247	2375476	2375242	Deinococcus geothermalis DSM 11300, complete genome	blastn	40071	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
8160829	8160829	PRJNA540466_S_NODE_33407_length_313_cov_3.666667_g32858_i0	PRJNA540466	33407	313	3.666667	11.47666771	Thermus antranikianii	88190	Bacteria	Bacteria	172	2.1499999999999998e-38	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g32858	i0	81.991	22.6261980830671	211	30	66	7	23	229	357538	357332	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	7082	172	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
8771513	8771513	PRJNA540466_S_NODE_50007_length_264_cov_2.104712_g49458_i0	PRJNA540466	50007	264	2.104712	5.55643968	Deinococcus	1298	Bacteria	Bacteria	292	1.31e-74	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g49458	i0	98.204	98.6515151515152	167	3	63	0	82	248	1663	1497	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	26044	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
9436454	9436454	PRJNA540466_S_NODE_52008_length_260_cov_1.561497_g51459_i0	PRJNA540466	52008	260	1.561497	4.0598922	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	394	3.419999999999999e-105	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g51459	i0	96.266	17.1346153846154	241	8	93	1	1	241	430760	430999	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	4455	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
10046933	10046933	PRJNA540466_S_NODE_63048_length_242_cov_2.869822_g62499_i0	PRJNA540466	63048	242	2.869822	6.94496924	Deinococcus	1298	Bacteria	Bacteria	263	9.250000000000001e-66	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g62499	i0	95.21	9.75619834710744	167	7	69	1	3	169	2014637	2014472	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	2361	263	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
10711977	10711977	PRJNA540466_S_NODE_23789_length_365_cov_3.126712_g23240_i0	PRJNA540466	23789	365	3.126712	11.4124988	Deinococcus geothermalis	68909	Bacteria	Bacteria	553	7.789999999999998e-153	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g23240	i0	99.029	0.846575342465753	309	2	84	1	24	331	389460	389768	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	309	553	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
12597480	12597480	PRJNA540466_S_NODE_55790_length_253_cov_0.866667_g55241_i0	PRJNA540466	55790	253	0.866667	2.19266751	Deinococcus	1298	Bacteria	Bacteria	111	3.73e-20	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g55241	i0	96.97	71.304347826087	66	2	26	0	168	233	1855	1790	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	18040	111	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
12597484	12597484	PRJNA540466_S_NODE_59130_length_248_cov_0.880000_g58581_i0	PRJNA540466	59130	248	0.88	2.1824	Thermus	270	Bacteria	Bacteria	414	2.48e-111	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g58581	i0	96.787	45.4475806451613	249	6	99	2	2	248	954357	954605	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	11271	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
15810737	15810737	PRJNA540466_S_NODE_28433_length_336_cov_3.342205_g27884_i0	PRJNA540466	28433	336	3.342205	11.2298088	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	327	4.7e-85	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g27884	i0	89.922	121.264880952381	258	20	76	5	7	262	545790	546043	Deinococcus sp. NW-56 chromosome, complete genome	blastn	40745	327	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15810892	15810892	PRJNA540466_S_NODE_45493_length_275_cov_0.846535_g44944_i0	PRJNA540466	45493	275	0.846535	2.32797125	Deinococcus grandis	57498	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g44944	i0	96.241	235.061818181818	266	10	97	0	10	275	73437	73702	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	64642	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
17085613	17085613	PRJNA540466_S_NODE_48194_length_268_cov_1.938462_g47645_i0	PRJNA540466	48194	268	1.938462	5.1950781599999996	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	422	1.62e-113	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g47645	i0	98.739	128.417910447761	238	2	88	1	28	264	410481	410718	Thermus sp. NEB1569 chromosome, complete genome	blastn	34416	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
17085616	17085616	PRJNA540466_S_NODE_48514_length_267_cov_3.417526_g47965_i0	PRJNA540466	48514	267	3.417526	9.12479442	Deinococcus geothermalis	68909	Bacteria	Bacteria	405	1.63e-108	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g47965	i0	99.55	35.7752808988764	222	1	83	0	40	261	2300742	2300963	Deinococcus geothermalis DSM 11300, complete genome	blastn	9552	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
17085792	17085792	PRJNA540466_S_NODE_69334_length_222_cov_4.845638_g68785_i0	PRJNA540466	69334	222	4.845638	10.75731636	Deinococcus geothermalis	68909	Bacteria	Bacteria	346	8.07e-91	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g68785	i0	97.087	7.81531531531532	206	4	92	1	12	215	650349	650144	Deinococcus geothermalis DSM 11300, complete genome	blastn	1735	346	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
18359497	18359497	PRJNA540466_S_NODE_32135_length_319_cov_0.926829_g31586_i0	PRJNA540466	32135	319	0.926829	2.95658451	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	436	7.069999999999999e-118	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g31586	i0	98.387	11.6175548589342	248	4	78	0	21	268	1183952	1183705	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	3706	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19634287	19634287	PRJNA540466_S_NODE_54556_length_255_cov_1.631868_g54007_i0	PRJNA540466	54556	255	1.631868	4.1612634	Deinococcus metallilatus	1211322	Bacteria	Bacteria	274	4.54e-69	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g54007	i0	89.091	84.0274509803922	220	24	86	0	17	236	613334	613115	Deinococcus metallilatus strain MA1002 chromosome	blastn	21427	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
19634348	19634348	PRJNA540466_S_NODE_62856_length_243_cov_0.870588_g62307_i0	PRJNA540466	62856	243	0.870588	2.11552884	Deinococcus geothermalis	68909	Bacteria	Bacteria	387	5.29e-103	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g62307	i0	97.788	1.06172839506173	226	2	92	3	21	243	830582	830807	Deinococcus geothermalis DSM 11300, complete genome	blastn	258	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
19634382	19634382	PRJNA540466_S_NODE_66776_length_232_cov_2.943396_g66227_i0	PRJNA540466	66776	232	2.943396	6.82867872	Deinococcus geothermalis	68909	Bacteria	Bacteria	339	1.42e-88	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g66227	i0	98.438	2.62931034482759	192	3	83	0	22	213	1476018	1476209	Deinococcus geothermalis DSM 11300, complete genome	blastn	610	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
20244921	20244921	PRJNA540466_S_NODE_44376_length_277_cov_5.156863_g43827_i0	PRJNA540466	44376	277	5.156863	14.28451051	Deinococcus	1298	Bacteria	Bacteria	394	3.68e-105	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g43827	i0	99.537	241.068592057762	216	1	78	0	21	236	1632	1847	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	66776	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
22795679	22795679	PRJNA540466_S_NODE_53138_length_258_cov_1.075676_g52589_i0	PRJNA540466	53138	258	1.075676	2.77524408	Deinococcus	1298	Bacteria	Bacteria	370	5.71e-98	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g52589	i0	96.833	12.8488372093023	221	7	86	0	1	221	126113	126333	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	3315	370	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
24733987	24733987	PRJNA540466_S_NODE_37240_length_299_cov_1.734513_g36691_i0	PRJNA540466	37240	299	1.734513	5.18619387	Thermus brockianus	56956	Bacteria	Bacteria	374	5.22e-99	NTclustered	gi\|2199615633\|dbj\|AP025595.1\|	56956	g36691	i0	97.273	0.735785953177257	220	6	74	0	9	228	23837	23618	Thermus brockianus SNM4-1 plasmid pTbrSNM4-1c DNA, complete sequence	blastn	220	374	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
25344789	25344789	PRJNA540466_S_NODE_34840_length_308_cov_1.242553_g34291_i0	PRJNA540466	34840	308	1.242553	3.82706324	Deinococcus	1298	Bacteria	Bacteria	448	3.1399999999999996e-121	NTclustered	gi\|1514756464\|dbj\|LC433574.1\|	47478	g34291	i0	98.077	89.211038961039	260	0	83	3	49	303	819	560	Deinococcus sp. TM138 gene for 16S ribosomal RNA, partial sequence	blastn	27477	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25344835	25344835	PRJNA540466_S_NODE_69140_length_224_cov_4.331126_g68591_i0	PRJNA540466	69140	224	4.331126	9.70172224	Thermus	270	Bacteria	Bacteria	322	1.37e-83	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g68591	i0	99.435	7.38392857142857	177	1	79	0	18	194	1422373	1422549	Thermus parvatiensis strain RL, complete genome	blastn	1654	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis

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