metadata: contig_metadata: 27 rows where bioproject = "PRJNA591127" and tax

27 rows where bioproject = "PRJNA591127" 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
565201	565201	PRJNA591127_P_NODE_661_length_768_cov_599.629275_g36_i3	PRJNA591127	661	768	599.629275	4605.152832	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	1175	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g36	i3	94.43	222.348958333333	772	29	100	10	1	768	544248	545009	Deinococcus sp. NW-56 chromosome, complete genome	blastn	170764	1175	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
1840510	1840510	PRJNA591127_P_NODE_1182_length_607_cov_10.756140_g1043_i0	PRJNA591127	1182	607	10.75614	65.2897698	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	459	3.03e-124	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1043	i0	90.423	147.146622734761	355	25	58	9	1	352	543602	543254	Deinococcus sp. NW-56 chromosome, complete genome	blastn	89318	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3116095	3116095	PRJNA591127_P_NODE_503_length_853_cov_544.735294_g36_i2	PRJNA591127	503	853	544.735294	4646.59205782	Deinococcus grandis	57498	Bacteria	Bacteria	1225	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g36	i2	92.882	249.799531066823	857	39	100	15	1	853	74132	73294	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	213079	1225	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
3690254	3690254	PRJNA591127_P_NODE_26623_length_160_cov_1.617886_g26454_i0	PRJNA591127	26623	160	1.617886	2.5886176	Thermus	270	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g26454	i0	99.375	135.98125	160	1	100	0	1	160	514	355	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	21757	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3690257	3690257	PRJNA591127_P_NODE_26803_length_159_cov_2.147541_g26634_i0	PRJNA591127	26803	159	2.147541	3.41459019	Bacteria	2	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|37223182\|gb\|AY379549.1\|	274	g26634	i0	100	136.012578616352	159	0	100	0	1	159	1351	1509	Thermus thermophilus TT700 23S ribosomal RNA, 5S ribosomal RNA, and tRNA-Gly genes, complete sequence	blastn	21626	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3690336	3690336	PRJNA591127_P_NODE_5103_length_323_cov_12.251748_g4935_i0	PRJNA591127	5103	323	12.251748	39.57314604	Deinococcus	1298	Bacteria	Bacteria	390	5.659999999999999e-104	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g4935	i0	95.868	160.643962848297	242	8	75	2	1	242	881239	881478	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	51888	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
5668718	5668718	PRJNA591127_P_NODE_12485_length_208_cov_2.508772_g12316_i0	PRJNA591127	12485	208	2.508772	5.21824576	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	292	9.86e-75	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g12316	i0	92.611	29.3365384615385	203	15	99	0	4	206	69238	69036	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	6102	292	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6943336	6943336	PRJNA591127_P_NODE_5986_length_300_cov_1.809886_g5818_i0	PRJNA591127	5986	300	1.809886	5.429658	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	233	9.29e-57	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g5818	i0	85.526	83.2933333333333	228	28	84	5	17	241	68590	68365	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	24988	233	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6943352	6943352	PRJNA591127_P_NODE_8546_length_252_cov_3.176744_g8378_i0	PRJNA591127	8546	252	3.176744	8.00539488	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	311	3.41e-80	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g8378	i0	90.336	53.4920634920635	238	21	100	2	1	237	69600	69836	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	13480	311	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
9493397	9493397	PRJNA591127_P_NODE_1408_length_566_cov_24.321361_g1263_i0	PRJNA591127	1408	566	24.321361	137.65890326	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	710	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g1263	i0	91.082	199.544169611307	527	44	93	3	1	525	2417411	2417936	Deinococcus sp. NW-56 chromosome, complete genome	blastn	112942	710	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
11341992	11341992	PRJNA591127_P_NODE_10209_length_230_cov_7.621762_g10041_i0	PRJNA591127	10209	230	7.621762	17.5300526	Deinococcus	1298	Bacteria	Bacteria	398	2.2899999999999997e-106	NTclustered	gi\|2678098150\|gb\|PP359631.1\|	47478	g10041	i0	97.826	102.386956521739	230	5	100	0	1	230	262	33	Deinococcus sp. strain BFCQ1 16S ribosomal RNA gene, partial sequence	blastn	23549	398	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11342104	11342104	PRJNA591127_P_NODE_1809_length_510_cov_3008.945032_g1653_i0	PRJNA591127	1809	510	3008.945032	15345.6196632	Deinococcus	1298	Bacteria	Bacteria	761	0	NTclustered	gi\|1219686863\|gb\|MF524660.1\|	47478	g1653	i0	93.725	102.250980392157	510	29	99	3	1	509	599	92	Deinococcus sp. strain MadaFrogSkinBac.DB-.3438 16S ribosomal RNA gene, partial sequence	blastn	52148	767	0.992177314211212	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
11342122	11342122	PRJNA591127_P_NODE_2009_length_489_cov_3.404867_g1851_i0	PRJNA591127	2009	489	3.404867	16.64979963	Deinococcus	1298	Bacteria	Bacteria	409	2.46e-109	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g1851	i0	84.762	141.173824130879	420	50	85	13	1	414	299562	299151	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	69034	409	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
11342171	11342171	PRJNA591127_P_NODE_24709_length_170_cov_1.827068_g24540_i0	PRJNA591127	24709	170	1.827068	3.1060156	Deinococcus	1298	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|1095429301\|gb\|KY056229.1\|	47478	g24540	i0	100	101.535294117647	170	0	100	0	1	170	9	178	Deinococcus sp. strain 6004 16S ribosomal RNA gene, partial sequence	blastn	17261	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
12044083	12044083	PRJNA591127_P_NODE_1070_length_631_cov_41.538721_g937_i0	PRJNA591127	1070	631	41.538721	262.10932951	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	1000	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g937	i0	95.268	246.648177496038	634	24	99	6	1	630	2418036	2417405	Deinococcus sp. NW-56 chromosome, complete genome	blastn	155635	1000	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13319139	13319139	PRJNA591127_P_NODE_8511_length_253_cov_1.486111_g8343_i0	PRJNA591127	8511	253	1.486111	3.75986083	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	302	2.06e-77	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g8343	i0	88.492	71.2371541501976	252	26	100	3	4	253	2282098	2281848	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	18023	302	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
13892859	13892859	PRJNA591127_P_NODE_27951_length_154_cov_1.777778_g27782_i0	PRJNA591127	27951	154	1.777778	2.73777812	Deinococcus	1298	Bacteria	Bacteria	211	1.97e-50	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g27782	i0	96.124	43.3441558441558	129	5	84	0	1	129	2634762	2634890	Deinococcus swuensis strain DY59, complete genome	blastn	6675	211	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18416819	18416819	PRJNA591127_P_NODE_11735_length_215_cov_3.207865_g11566_i0	PRJNA591127	11735	215	3.207865	6.89690975	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	296	7.93e-76	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g11566	i0	91.705	104.702325581395	217	13	100	5	1	215	68677	68890	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	22511	296	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18416910	18416910	PRJNA591127_P_NODE_21695_length_190_cov_3.444444_g21526_i0	PRJNA591127	21695	190	3.444444	6.5444436	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	302	1.47e-77	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g21526	i0	95.288	77.1473684210526	191	8	100	1	1	190	69255	69445	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	14658	302	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
19691482	19691482	PRJNA591127_P_NODE_25076_length_168_cov_1.916031_g24907_i0	PRJNA591127	25076	168	1.916031	3.21893208	Deinococcus ficus	317577	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g24907	i0	100	156.154761904762	168	0	100	0	1	168	2342654	2342821	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	26234	311	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
19691585	19691585	PRJNA591127_P_NODE_7936_length_261_cov_6.361607_g7768_i0	PRJNA591127	7936	261	6.361607	16.60379427	Deinococcus sp. W1.10-137-3	1341489	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|509724113\|gb\|JX458441.1\|	1341489	g7768	i0	100	105.712643678161	261	0	100	0	1	261	264	4	Deinococcus sp. W1.10-137-3 16S ribosomal RNA gene, partial sequence	blastn	27591	483	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. W1.10-137-3
20265158	20265158	PRJNA591127_P_NODE_116_length_1375_cov_344.434230_g36_i1	PRJNA591127	116	1375	344.43423	4735.9706625	Deinococcus	1298	Bacteria	Bacteria	1989	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g36	i1	92.909	365.107636363636	1382	76	100	15	1	1375	74132	72766	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	502023	2008	0.990537848605578	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
24090840	24090840	PRJNA591127_P_NODE_599_length_794_cov_38.347424_g504_i0	PRJNA591127	599	794	38.347424	304.47854656	Deinococcus	1298	Bacteria	Bacteria	1155	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g504	i0	93.108	223.755667506297	798	40	100	9	1	794	73492	72706	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	177662	1155	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
25364995	25364995	PRJNA591127_P_NODE_1820_length_509_cov_34.095339_g1664_i0	PRJNA591127	1820	509	34.095339	173.54527551	Truepera	332248	Bacteria	Bacteria	640	8.36e-179	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g1664	i0	89.37	336.840864440079	508	54	99	0	2	509	521	14	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	171452	641	0.998439937597504	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
27504143	27504143	PRJNA591127_P_NODE_30703_length_151_cov_2.631579_g30534_i0	PRJNA591127	30703	151	2.631579	3.97368429	Bacteria	2	Bacteria	Bacteria	46.6	4.64e-4	NR	MCL4454784.1	47478	g30534	i0	96	41.8609271523179	25	1	49.7	0	1	75	10	34	MCL4454784.1 nitronate monooxygenase [Deinococcus sp.]	diamond	6321	47	0.991489361702128	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28627395	28627395	PRJNA591127_P_NODE_14107_length_197_cov_5.025000_g13938_i0	PRJNA591127	14107	197	5.025	9.89925	Fervidobacterium sp.	1871331	Bacteria	Bacteria	55.5	6.43e-7	NR	HOA17490.1	1871331	g13938	i0	100	0.365482233502538	24	0	36.5	0	195	124	317	340	HOA17490.1 dihydroorotase [Fervidobacterium sp.]	diamond	72	55.5	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32306476	32306476	PRJNA591127_P_NODE_29239_length_151_cov_4.263158_g29070_i0	PRJNA591127	29239	151	4.263158	6.43736858	Thermotogales	2419	Bacteria	Bacteria	54.3	4.48e-7	NR	HRT01669.1	1871331	g29070	i0	100	1.90728476821192	24	0	47.7	0	74	3	52	75	HRT01669.1 DNA-processing protein DprA [Fervidobacterium sp.]	diamond	288	54.3	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.

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