metadata: contig_metadata: 18 rows where bioproject = "PRJNA741997" and tax

18 rows where bioproject = "PRJNA741997" 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
721601	721601	PRJNA741997_P_NODE_66801_length_262_cov_1.444444_g65681_i0	PRJNA741997	66801	262	1.444444	3.78444328	Deinococcus	1298	Bacteria	Bacteria	87.4	5.22e-20	NR	WP_019010841.1	519440	g65681	i0	58.3	1.88931297709924	84	34	95	1	12	260	3	86	WP_019010841.1 DUF1304 domain-containing protein [Deinococcus aquatilis]	diamond	495	87.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquatilis
1997603	1997603	PRJNA741997_P_NODE_63362_length_270_cov_1.558376_g62242_i0	PRJNA741997	63362	270	1.558376	4.2076152	Thermus thermophilus	274	Bacteria	Bacteria	316	7.95e-82	NTclustered	gi\|2074862859\|dbj\|AP024933.1\|	274	g62242	i0	88.015	4.05925925925926	267	32	99	0	3	269	890444	890710	Thermus thermophilus AA3-7 DNA, complete genome	blastn	1096	316	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
3749888	3749888	PRJNA741997_P_NODE_71883_length_251_cov_0.865169_g70763_i0	PRJNA741997	71883	251	0.865169	2.17157419	Thermus	270	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g70763	i0	99.602	63.4223107569721	251	1	100	0	1	251	1137553	1137803	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	15919	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
7100281	7100281	PRJNA741997_P_NODE_63386_length_270_cov_1.487310_g62266_i0	PRJNA741997	63386	270	1.48731	4.015737	Meiothermus ruber	277	Bacteria	Bacteria	477	3.4499999999999986e-130	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g62266	i0	98.519	2.56296296296296	270	4	100	0	1	270	2925218	2924949	Meiothermus ruber DSM 1279, complete genome	blastn	692	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
11401851	11401851	PRJNA741997_P_NODE_56709_length_285_cov_1.452830_g55589_i0	PRJNA741997	56709	285	1.45283	4.1405655	Thermus	270	Bacteria	Bacteria	510	3.61e-140	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g55589	i0	98.947	5.99649122807018	285	3	100	0	1	285	2326372	2326656	Thermus scotoductus SA-01, complete genome	blastn	1709	510	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
12200846	12200846	PRJNA741997_P_NODE_40130_length_343_cov_0.629630_g39010_i0	PRJNA741997	40130	343	0.62963	2.1596309	Deinococcus ficus	317577	Bacteria	Bacteria	569	7.239999999999998e-158	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g39010	i0	97.321	215.763848396501	336	7	98	2	1	335	2341818	2342152	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	74007	569	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
12677769	12677769	PRJNA741997_P_NODE_84770_length_244_cov_0.900585_g83650_i0	PRJNA741997	84770	244	0.900585	2.1974274	Deinococcus	1298	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g83650	i0	99.18	165.573770491803	244	2	100	0	1	244	1455345	1455102	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	40400	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
21124007	21124007	PRJNA741997_P_NODE_38737_length_349_cov_0.913043_g37617_i0	PRJNA741997	38737	349	0.913043	3.18652007	root	1	Root_unresolved	Root_unresolved	138	3.69e-36	NR	WP_310582884.1	47478	g37617	i0	79.3	2.3810888252149	87	18	74.8	0	89	349	375	461	WP_310582884.1 aminopeptidase [Deinococcus sp.]	diamond	831	138	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
22398964	22398964	PRJNA741997_P_NODE_50378_length_304_cov_1.229437_g49258_i0	PRJNA741997	50378	304	1.229437	3.73748848	root	1	Root_unresolved	Root_unresolved	99	2.76e-24	NR	WP_236100038.1	47054	g49258	i0	58.1	6.49342105263158	93	39	91.8	0	282	4	13	105	WP_236100038.1 MULTISPECIES: 50S ribosomal protein L20 [Dethiosulfovibrio]	diamond	1974	100	0.99	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio
27684723	27684723	PRJNA741997_P_NODE_58604_length_281_cov_1.283654_g57484_i0	PRJNA741997	58604	281	1.283654	3.60706774	Deinococcus budaensis	1665626	Bacteria	Bacteria	43.1	0.00797	NR	WP_184028251.1	1665626	g57484	i0	34.4	0.683274021352313	64	38	64.1	2	36	215	18	81	WP_184028251.1 hypothetical protein [Deinococcus budaensis]	diamond	192	43.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
28104802	28104802	PRJNA741997_P_NODE_41425_length_337_cov_2.208333_g40305_i0	PRJNA741997	41425	337	2.208333	7.44208221	Bacteria	2	Bacteria	Bacteria	103	3.68e-25	NR	MDO4264703.1	47478	g40305	i0	50.5	5.18991097922849	101	48	89.9	1	307	5	3	101	MDO4264703.1 NAD(P)H-dependent oxidoreductase [Deinococcus sp.]	diamond	1749	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28389070	28389070	PRJNA741997_P_NODE_90526_length_233_cov_2.368750_g89406_i0	PRJNA741997	90526	233	2.36875	5.5191875	root	1	Root_unresolved	Root_unresolved	106	4.77e-25	NR	RKX49497.1	28240	g89406	i0	62.2	19.1330472103004	74	28	95.3	0	230	9	160	233	RKX49497.1 MAG: acyl-CoA synthetase, partial [Thermotoga sp.]	diamond	4458	107	0.990654205607477	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga sp.
29326113	29326113	PRJNA741997_P_NODE_57909_length_282_cov_2.186603_g56789_i0	PRJNA741997	57909	282	2.186603	6.16622046	Synergistaceae bacterium	2053624	Bacteria	Bacteria	69.3	4.12e-12	NR	MDR2523788.1	2053624	g56789	i0	41.5	3.88297872340426	94	40	88.3	3	251	3	23	112	MDR2523788.1 TerD family protein [Synergistaceae bacterium]	diamond	1095	69.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29578552	29578552	PRJNA741997_P_NODE_38170_length_351_cov_1.884892_g37050_i0	PRJNA741997	38170	351	1.884892	6.61597092	Deinococcus misasensis	392413	Bacteria	Bacteria	48.5	0.00122	NR	WP_034337211.1	392413	g37050	i0	37.1	0.897435897435897	105	53	82.1	4	330	43	12	112	WP_034337211.1 DUF5060 domain-containing protein [Deinococcus misasensis]	diamond	315	48.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
29778271	29778271	PRJNA741997_P_NODE_52731_length_296_cov_1.076233_g51611_i0	PRJNA741997	52731	296	1.076233	3.18564968	Bacteria	2	Bacteria	Bacteria	47.8	0.0011	NR	WP_189002764.1	392414	g51611	i0	69	0.587837837837838	29	9	29.4	0	6	92	235	263	WP_189002764.1 hypothetical protein [Deinococcus roseus]	diamond	174	47.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus roseus
30874013	30874013	PRJNA741997_P_NODE_62914_length_271_cov_1.555556_g61794_i0	PRJNA741997	62914	271	1.555556	4.21555676	Trueperaceae bacterium	2026798	Bacteria	Bacteria	42	0.0398	NR	MFO7546763.1	2026798	g61794	i0	37.1	0.774907749077491	70	39	77.5	1	35	244	64	128	MFO7546763.1 hypothetical protein [Trueperaceae bacterium]	diamond	210	42	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
32329163	32329163	PRJNA741997_P_NODE_74359_length_250_cov_0.870056_g73239_i0	PRJNA741997	74359	250	0.870056	2.17514	Synergistaceae bacterium	2053624	Bacteria	Bacteria	47.4	7.39e-5	NR	HOU32647.1	2053624	g73239	i0	41.8	0.804	67	34	80.4	3	36	236	6	67	HOU32647.1 hypothetical protein [Synergistaceae bacterium]	diamond	201	47.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32802144	32802144	PRJNA741997_P_NODE_18640_length_537_cov_1.806034_g17526_i0	PRJNA741997	18640	537	1.806034	9.69840258	Thermus brockianus	56956	Bacteria	Bacteria	60.5	3.8e-7	NR	WP_244363811.1	56956	g17526	i0	48.5	1.4804469273743	130	64	70.9	1	156	536	181	310	WP_244363811.1 RCC1 domain-containing protein [Thermus brockianus]	diamond	795	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus

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