metadata: contig_metadata: 25 rows where bioproject = "PRJNA1016321" and tax

25 rows where bioproject = "PRJNA1016321" 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
159236	159236	PRJNA1016321_P_NODE_15781_length_492_cov_4.379475_g15551_i0	PRJNA1016321	15781	492	4.379475	21.547017	Thermus thermophilus	274	Bacteria	Bacteria	874	0	NTclustered	gi\|2199618697\|dbj\|AP025605.1\|	274	g15551	i0	100	0.961382113821138	473	0	96	0	1	473	39200	38728	Thermus thermophilus SNM1-7 plasmid pTthSNM1-7c DNA, complete sequence	blastn	473	874	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
2277889	2277889	PRJNA1016321_P_NODE_36262_length_296_cov_2.775785_g36031_i0	PRJNA1016321	36262	296	2.775785	8.2163236	Deinococcus	1298	Bacteria	Bacteria	508	1.36e-139	NTclustered	gi\|2706841466\|gb\|CP149786.1\|	3112952	g36031	i0	98.611	14.1756756756757	288	3	97	1	9	296	7445	7731	Deinococcus sp. VB142 plasmid p3, complete sequence	blastn	4196	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
2710043	2710043	PRJNA1016321_P_NODE_40243_length_279_cov_1.582524_g40012_i0	PRJNA1016321	40243	279	1.582524	4.41524196	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	505	1.6399999999999995e-138	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g40012	i0	99.283	4.04659498207885	279	2	100	0	1	279	743352	743074	Thermus sp. NEB1569 chromosome, complete genome	blastn	1129	505	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
2710162	2710162	PRJNA1016321_P_NODE_45803_length_257_cov_2.586957_g45572_i0	PRJNA1016321	45803	257	2.586957	6.64847949	Deinococcus aquaticus	328692	Bacteria	Bacteria	392	1.21e-104	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g45572	i0	98.643	4.29182879377432	221	3	86	0	31	251	794111	794331	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	1103	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
5262503	5262503	PRJNA1016321_P_NODE_37285_length_291_cov_3.160550_g37054_i0	PRJNA1016321	37285	291	3.16055	9.1972005	Thermus parvatiensis	456163	Bacteria	Bacteria	483	8.069999999999998e-132	NTclustered	gi\|982539283\|gb\|CP014141.1\|	456163	g37054	i0	99.251	36.8659793814433	267	2	92	0	6	272	1779164	1778898	Thermus parvatiensis strain RL, complete genome	blastn	10728	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus parvatiensis
5262617	5262617	PRJNA1016321_P_NODE_4225_length_987_cov_3.576586_g4056_i0	PRJNA1016321	4225	987	3.576586	35.30090382	Deinococcus grandis	57498	Bacteria	Bacteria	1454	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g4056	i0	93.731	76.2958459979737	973	55	98	5	17	984	2657623	2656652	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	75304	1454	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
6105931	6105931	PRJNA1016321_P_NODE_42325_length_270_cov_4.588832_g42094_i0	PRJNA1016321	42325	270	4.588832	12.3898464	Thermus	270	Bacteria	Bacteria	455	1.6100000000000002e-123	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g42094	i0	98.456	39.2666666666667	259	3	96	1	13	270	49553	49811	Thermus thermophilus TF27 DNA, complete genome	blastn	10602	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
6105952	6105952	PRJNA1016321_P_NODE_50245_length_248_cov_0.880000_g50014_i0	PRJNA1016321	50245	248	0.88	2.1824	Thermus	270	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|939575858\|gb\|CP010824.1\|	498848	g50014	i0	98.79	3.91532258064516	248	3	100	0	1	248	868	621	Thermus aquaticus Y51MC23 plasmid pTA16, complete sequence	blastn	971	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
6538179	6538179	PRJNA1016321_P_NODE_52766_length_245_cov_0.895349_g52535_i0	PRJNA1016321	52766	245	0.895349	2.19360505	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g52535	i0	99.592	58.3632653061225	245	1	100	0	1	245	564918	564674	Thermus sp. NEB1569 chromosome, complete genome	blastn	14299	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
7380412	7380412	PRJNA1016321_P_NODE_6446_length_805_cov_2.255464_g6249_i0	PRJNA1016321	6446	805	2.255464	18.1564852	Thermus	270	Bacteria	Bacteria	1408	0	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g6249	i0	99.611	47.9329192546584	771	3	96	0	20	790	1727130	1727900	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	38586	1408	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
7812098	7812098	PRJNA1016321_P_NODE_31407_length_323_cov_1.788000_g31176_i0	PRJNA1016321	31407	323	1.788	5.77524	Thermus thermophilus	274	Bacteria	Bacteria	553	6.819999999999998e-153	NTclustered	gi\|1699893943\|dbj\|AP019794.1\|	274	g31176	i0	99.026	37.1547987616099	308	3	95	0	1	308	1801651	1801344	Thermus thermophilus AA2-29 DNA, complete genome	blastn	12001	553	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9087021	9087021	PRJNA1016321_P_NODE_29548_length_335_cov_2.041985_g29317_i0	PRJNA1016321	29548	335	2.041985	6.84064975	Deinococcus aquaticus	328692	Bacteria	Bacteria	510	4.339999999999998e-140	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g29317	i0	94.294	15.1402985074627	333	19	99	0	1	333	794311	794643	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	5072	510	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
9087130	9087130	PRJNA1016321_P_NODE_34468_length_306_cov_1.321888_g34237_i0	PRJNA1016321	34468	306	1.321888	4.04497728	Thermus aquaticus	271	Bacteria	Bacteria	566	8.239999999999998e-157	NTclustered	gi\|507890\|dbj\|D32013.1\|TTHDNAP	271	g34237	i0	100	46.7647058823529	306	0	100	0	1	306	527	222	Thermus aquaticus gene for DNA polymerase, complete cds	blastn	14310	566	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
9087650	9087650	PRJNA1016321_P_NODE_8888_length_679_cov_3.566007_g8677_i0	PRJNA1016321	8888	679	3.566007	24.21318753	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	1214	0	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g8677	i0	99.698	11.2164948453608	663	2	98	0	1	663	1953691	1954353	Thermus sp. NEB1569 chromosome, complete genome	blastn	7616	1214	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
9930765	9930765	PRJNA1016321_P_NODE_12748_length_555_cov_2.786307_g12525_i0	PRJNA1016321	12748	555	2.786307	15.46400385	Thermus	270	Bacteria	Bacteria	887	0	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g12525	i0	95.504	42.4720720720721	556	23	100	2	1	555	935126	935680	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	23572	887	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
11637761	11637761	PRJNA1016321_P_NODE_11250_length_597_cov_1.729008_g11028_i0	PRJNA1016321	11250	597	1.729008	10.32217776	Thermus sp. PS18	2849039	Bacteria	Bacteria	1042	0	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g11028	i0	98.157	38.0887772194305	597	11	100	0	1	597	1307239	1306643	Thermus sp. PS18 chromosome, complete genome	blastn	22739	1042	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
11638570	11638570	PRJNA1016321_P_NODE_54870_length_242_cov_2.633136_g54639_i0	PRJNA1016321	54870	242	2.633136	6.37218912	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|359289533\|gb\|CP003126.1\|	1111069	g54639	i0	82.988	46.6900826446281	241	14	99	9	4	242	2089044	2089259	Thermus sp. CCB_US3_UF1, complete genome	blastn	11299	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
12481550	12481550	PRJNA1016321_P_NODE_13930_length_528_cov_2.415385_g13705_i0	PRJNA1016321	13930	528	2.415385	12.7532328	Deinococcus	1298	Bacteria	Bacteria	656	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g13705	i0	89.077	299.621212121212	531	54	100	4	1	528	69054	69583	Deinococcus swuensis strain DY59, complete genome	blastn	158200	656	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
12912815	12912815	PRJNA1016321_P_NODE_1391_length_1554_cov_2.828494_g1306_i0	PRJNA1016321	1391	1554	2.828494	43.95479676	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	2109	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1306	i0	91.5	270.835907335907	1553	103	99	24	13	1554	2416885	2418419	Deinococcus sp. NW-56 chromosome, complete genome	blastn	420879	2109	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
15030465	15030465	PRJNA1016321_P_NODE_3612_length_1065_cov_4.228831_g3462_i0	PRJNA1016321	3612	1065	4.228831	45.03705015	Deinococcus	1298	Bacteria	Bacteria	850	0	NTclustered	gi\|158342661\|gb\|CP000856.1\|	319795	g3462	i0	85.609	10.3117370892019	813	113	77	3	122	932	89154	89964	Deinococcus geothermalis DSM 11300 plasmid pDGEO02, complete sequence	blastn	10982	854	0.995316159250585	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
17580542	17580542	PRJNA1016321_P_NODE_11814_length_580_cov_4.084813_g11591_i0	PRJNA1016321	11814	580	4.084813	23.6919154	Thermus	270	Bacteria	Bacteria	1037	0	NTclustered	gi\|1953559172\|dbj\|AP024270.1\|	274	g11591	i0	100	8.7051724137931	561	0	97	0	20	580	867248	866688	Thermus thermophilus HB5018 DNA, complete genome	blastn	5049	1037	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
19285559	19285559	PRJNA1016321_P_NODE_49796_length_249_cov_0.875000_g49565_i0	PRJNA1016321	49796	249	0.875	2.17875	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	147	1e-30	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g49565	i0	89.167	0.481927710843373	120	10	48	3	1	119	1409103	1408986	Thermus sp. NEB1569 chromosome, complete genome	blastn	120	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
21404847	21404847	PRJNA1016321_P_NODE_42857_length_268_cov_3.041026_g42626_i0	PRJNA1016321	42857	268	3.041026	8.14994968	Thermus	270	Bacteria	Bacteria	462	9.57e-126	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g42626	i0	99.605	61.7201492537313	253	1	94	0	1	253	200562	200814	Thermus thermophilus TF27 DNA, complete genome	blastn	16541	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
28645633	28645633	PRJNA1016321_P_NODE_20227_length_424_cov_2.227920_g19996_i0	PRJNA1016321	20227	424	2.22792	9.4463808	Meiothermus sp. Pnk-1	873128	Bacteria	Bacteria	206	2.25e-65	NR	WP_110526044.1	873128	g19996	i0	97.1	0.721698113207547	102	3	72.2	0	404	99	68	169	WP_110526044.1 hypothetical protein [Meiothermus sp. Pnk-1]	diamond	306	206	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp. Pnk-1
31646538	31646538	PRJNA1016321_P_NODE_30637_length_328_cov_1.709804_g30406_i0	PRJNA1016321	30637	328	1.709804	5.60815712	Deinococcus antarcticus	1298767	Bacteria	Bacteria	192	9.269999999999998e-55	NR	WP_380076278.1	1298767	g30406	i0	95.1	0.932926829268293	102	5	93.3	0	23	328	27	128	WP_380076278.1 ATP-binding protein [Deinococcus antarcticus]	diamond	306	192	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);;