metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
177258	177258	PRJNA1059246_P_NODE_52701_length_281_cov_1.245192_g52075_i0	PRJNA1059246	52701	281	1.245192	3.49898952	Deinococcus psychrotolerans	2489213	Bacteria	Bacteria	420	6.16e-113	NTclustered	gi\|1527207717\|gb\|CP034187.1\|	2489213	g52075	i0	93.594	1	281	18	100	0	1	281	152750	153030	Deinococcus psychrotolerans strain S14-83 plasmid unnamed3, complete sequence	blastn	281	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus psychrotolerans
1011452	1011452	PRJNA1059246_P_NODE_28681_length_412_cov_1.061947_g28056_i0	PRJNA1059246	28681	412	1.061947	4.37522164	Truepera	332248	Bacteria	Bacteria	568	3.179999999999999e-157	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g28056	i0	91.505	555.895631067961	412	35	100	0	1	412	568	979	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	229029	568	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
1452041	1452041	PRJNA1059246_P_NODE_64822_length_248_cov_0.880000_g64196_i0	PRJNA1059246	64822	248	0.88	2.1824	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	193	1.27e-44	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g64196	i0	87.059	36.241935483871	170	22	69	0	79	248	785158	785327	Deinococcus sp. NW-56 chromosome, complete genome	blastn	8988	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3562119	3562119	PRJNA1059246_P_NODE_29883_length_401_cov_1.868902_g29258_i0	PRJNA1059246	29883	401	1.868902	7.49429702	Bacteria	2	Bacteria	Bacteria	736	0	NTclustered	gi\|2866351997\|gb\|PQ721879.1\|	47478	g29258	i0	99.751	105.476309226933	401	1	100	0	1	401	302	702	Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence	blastn	42296	741	0.993252361673414	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
5279971	5279971	PRJNA1059246_P_NODE_51405_length_285_cov_1.179245_g50779_i0	PRJNA1059246	51405	285	1.179245	3.36084825	Deinococcus rubellus	1889240	Bacteria	Bacteria	405	1.75e-108	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g50779	i0	92.281	64.7438596491228	285	22	100	0	1	285	1488502	1488786	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	18452	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
5280123	5280123	PRJNA1059246_P_NODE_63785_length_249_cov_0.875000_g63159_i0	PRJNA1059246	63785	249	0.875	2.17875	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g63159	i0	99.197	2	249	2	100	0	1	249	1155035	1154787	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	498	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
6555387	6555387	PRJNA1059246_P_NODE_69686_length_244_cov_0.900585_g69060_i0	PRJNA1059246	69686	244	0.900585	2.1974274	Deinococcus rubellus	1889240	Bacteria	Bacteria	331	2.5200000000000006e-86	NTclustered	gi\|2304456361\|gb\|CP104213.1\|	1889240	g69060	i0	91.393	5.07786885245902	244	17	99	4	3	244	1946725	1946484	Deinococcus rubellus strain Ant6 chromosome, complete genome	blastn	1239	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rubellus
9104829	9104829	PRJNA1059246_P_NODE_51868_length_283_cov_2.195238_g51242_i0	PRJNA1059246	51868	283	2.195238	6.21252354	Thermanaerovibrio acidaminovorans	81462	Bacteria	Bacteria	518	2.14e-142	NTclustered	gi\|269099254\|gb\|CP001818.1\|	525903	g51242	i0	99.647	1.9469964664311	283	1	100	0	1	283	314733	314451	Thermanaerovibrio acidaminovorans DSM 6589, complete genome	blastn	551	518	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
10380425	10380425	PRJNA1059246_P_NODE_43529_length_319_cov_1.252033_g42903_i0	PRJNA1059246	43529	319	1.252033	3.99398527	Trueperaceae bacterium	2026798	Bacteria	Bacteria	424	5.5e-114	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g42903	i0	90.491	645.677115987461	326	24	100	3	1	319	3600777	3601102	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	205971	424	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
10380774	10380774	PRJNA1059246_P_NODE_72569_length_241_cov_0.916667_g71943_i0	PRJNA1059246	72569	241	0.916667	2.20916747	Deinococcus ficus	317577	Bacteria	Bacteria	228	3.3599999999999994e-55	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g71943	i0	83.951	28.792531120332	243	33	99	6	2	241	1371792	1372031	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	6939	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
11655782	11655782	PRJNA1059246_P_NODE_53330_length_279_cov_1.223301_g52704_i0	PRJNA1059246	53330	279	1.223301	3.41300979	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	481	2.77e-131	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g52704	i0	97.842	350.025089605735	278	6	99	0	2	279	2417429	2417706	Deinococcus sp. NW-56 chromosome, complete genome	blastn	97657	481	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
12931140	12931140	PRJNA1059246_P_NODE_70131_length_243_cov_0.905882_g69505_i0	PRJNA1059246	70131	243	0.905882	2.20129326	Thermus scotoductus	37636	Bacteria	Bacteria	416	6.739999999999998e-112	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g69505	i0	97.531	10.037037037037	243	6	100	0	1	243	47061	46819	Thermus scotoductus SA-01, complete genome	blastn	2439	416	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
14206004	14206004	PRJNA1059246_P_NODE_62052_length_251_cov_0.865169_g61426_i0	PRJNA1059246	62052	251	0.865169	2.17157419	Deinococcus ficus	317577	Bacteria	Bacteria	250	7.52e-62	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g61426	i0	85.246	7.38645418326693	244	34	97	2	1	243	311565	311323	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	1854	250	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
15480181	15480181	PRJNA1059246_P_NODE_63173_length_250_cov_0.870056_g62547_i0	PRJNA1059246	63173	250	0.870056	2.17514	Deinococcus sonorensis	309891	Bacteria	Bacteria	196	9.88e-46	NTclustered	gi\|2745310155\|gb\|CP158300.1\|	694439	g62547	i0	80.8	23.872	250	48	100	0	1	250	4577	4826	Deinococcus sonorensis KR-87 plasmid pDson02, complete sequence	blastn	5968	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
16313968	16313968	PRJNA1059246_P_NODE_54953_length_274_cov_1.149254_g54327_i0	PRJNA1059246	54953	274	1.149254	3.14895596	Meiothermus	65551	Bacteria	Bacteria	63.9	1.16e-5	NTclustered	gi\|452192166\|ref\|NR_075680.1\|	277	g54327	i0	85.484	1.58394160583942	62	7	22	2	72	132	78	18	Meiothermus ruber 5S ribosomal RNA gene, complete sequence	blastn	434	63.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
17589352	17589352	PRJNA1059246_P_NODE_62774_length_250_cov_0.870056_g62148_i0	PRJNA1059246	62774	250	0.870056	2.17514	Deinococcus	1298	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g62148	i0	100	26.424	250	0	100	0	1	250	2394477	2394726	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	6606	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
18028548	18028548	PRJNA1059246_P_NODE_14755_length_611_cov_2.763941_g14159_i0	PRJNA1059246	14755	611	2.763941	16.88767951	Thermus brockianus	56956	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|1102955210\|gb\|CP016312.1\|	56956	g14159	i0	92.5	0.130932896890344	40	0	6	3	419	456	283075	283113	Thermus brockianus strain GE-1 chromosome, complete genome	blastn	80	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
18029113	18029113	PRJNA1059246_P_NODE_64455_length_249_cov_0.875000_g63829_i0	PRJNA1059246	64455	249	0.875	2.17875	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	411	3.2299999999999996e-110	NTclustered	gi\|2905211496\|gb\|CP179945.1\|	3385567	g63829	i0	96.386	2.00401606425703	249	9	100	0	1	249	2608836	2609084	Deinococcus sp. VB343 chromosome 1, complete sequence	blastn	499	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
19302973	19302973	PRJNA1059246_P_NODE_53356_length_279_cov_1.121359_g52730_i0	PRJNA1059246	53356	279	1.121359	3.12859161	Deinococcus gobiensis	502394	Bacteria	Bacteria	246	1.1e-60	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g52730	i0	82.918	1.11111111111111	281	40	99	7	1	277	1356381	1356105	Deinococcus gobiensis I-0, complete genome	blastn	310	246	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
19303093	19303093	PRJNA1059246_P_NODE_63776_length_249_cov_0.875000_g63150_i0	PRJNA1059246	63776	249	0.875	2.17875	Deinococcus geothermalis	68909	Bacteria	Bacteria	121	6.09e-23	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g63150	i0	78.571	0.730923694779116	182	39	73	0	8	189	331299	331118	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	182	121	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
20137998	20137998	PRJNA1059246_P_NODE_64456_length_249_cov_0.875000_g63830_i0	PRJNA1059246	64456	249	0.875	2.17875	Deinococcus	1298	Bacteria	Bacteria	183	7.659999999999998e-42	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g63830	i0	81.466	2.67068273092369	232	35	92	7	1	228	2879459	2879686	Deinococcus swuensis strain DY59, complete genome	blastn	665	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
20578460	20578460	PRJNA1059246_P_NODE_68057_length_245_cov_0.895349_g67431_i0	PRJNA1059246	68057	245	0.895349	2.19360505	Deinococcus gobiensis	502394	Bacteria	Bacteria	117	7.73e-22	NTclustered	gi\|380002081\|gb\|CP002193.1\|	745776	g67431	i0	78.947	2.70612244897959	190	26	100	13	6	188	159172	159354	Deinococcus gobiensis I-0 plasmid P2, complete sequence	blastn	663	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
20578517	20578517	PRJNA1059246_P_NODE_72597_length_241_cov_0.916667_g71971_i0	PRJNA1059246	72597	241	0.916667	2.20916747	Deinococcus radiomollis	468916	Bacteria	Bacteria	110	1.27e-19	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g71971	i0	80.537	1.15352697095436	149	23	61	6	45	190	807485	807340	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	278	110	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
23129516	23129516	PRJNA1059246_P_NODE_49819_length_290_cov_1.004608_g49193_i0	PRJNA1059246	49819	290	1.004608	2.9133632	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	339	1.84e-88	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g49193	i0	88.421	17.4931034482759	285	27	97	5	9	290	1817075	1817356	Deinococcus sp. NW-56 chromosome, complete genome	blastn	5073	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
23129517	23129517	PRJNA1059246_P_NODE_49919_length_289_cov_1.768519_g49293_i0	PRJNA1059246	49919	289	1.768519	5.1110199100000004	Deinococcus maricopensis	309887	Bacteria	Bacteria	261	4.08e-65	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g49293	i0	84.674	3.23875432525952	261	40	90	0	1	261	2147444	2147704	Deinococcus maricopensis DSM 21211, complete genome	blastn	936	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
23129518	23129518	PRJNA1059246_P_NODE_50059_length_289_cov_1.259259_g49433_i0	PRJNA1059246	50059	289	1.259259	3.63925851	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	313	1.11e-80	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g49433	i0	86.598	1.86851211072664	291	29	100	6	1	289	1721325	1721043	Deinococcus sp. NW-56 chromosome, complete genome	blastn	540	313	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
23963895	23963895	PRJNA1059246_P_NODE_34999_length_365_cov_1.386986_g34373_i0	PRJNA1059246	34999	365	1.386986	5.0624989	Truepera	332248	Bacteria	Bacteria	534	2.819999999999999e-147	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g34373	i0	93.151	160.016438356164	365	24	99	1	2	365	1965	1601	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	58406	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24403437	24403437	PRJNA1059246_P_NODE_72020_length_241_cov_0.916667_g71394_i0	PRJNA1059246	72020	241	0.916667	2.20916747	Deinococcus maricopensis	309887	Bacteria	Bacteria	213	9.4e-51	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g71394	i0	82.773	16.4564315352697	238	41	99	0	4	241	2646357	2646120	Deinococcus maricopensis DSM 21211, complete genome	blastn	3966	213	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis

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