metadata: contig_metadata: 14 rows where bioproject = "PRJNA986481" and tax

14 rows where bioproject = "PRJNA986481" 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
1272156	1272156	PRJNA986481_P_NODE_45981_length_257_cov_0.971154_g45456_i0	PRJNA986481	45981	257	0.971154	2.49586578	Thermus	270	Bacteria	Bacteria	453	5.480000000000001e-123	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g45456	i0	98.444	28.1439688715953	257	4	100	0	1	257	1862074	1862330	Thermus scotoductus SA-01, complete genome	blastn	7233	453	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
3524423	3524423	PRJNA986481_P_NODE_53663_length_248_cov_1.015075_g53138_i0	PRJNA986481	53663	248	1.015075	2.517386	Deinococcus geothermalis	68909	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g53138	i0	91.129	64.1048387096774	248	22	100	0	1	248	827822	827575	Deinococcus geothermalis DSM 11300, complete genome	blastn	15898	337	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
7351503	7351503	PRJNA986481_P_NODE_4466_length_741_cov_2.776012_g4052_i0	PRJNA986481	4466	741	2.776012	20.57024892	Pseudothermotoga sp.	2033661	Bacteria	Bacteria	125	1.04e-32	NR	WP_345967341.1	2033661	g4052	i0	51.3	0.481781376518219	119	56	47.8	2	157	510	4	121	WP_345967341.1 glycine cleavage system protein GcvH [Pseudothermotoga sp.]	diamond	357	125	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Pseudothermotoga	Pseudothermotoga sp.
7351665	7351665	PRJNA986481_P_NODE_55666_length_246_cov_1.025381_g55141_i0	PRJNA986481	55666	246	1.025381	2.52243726	Deinococcus sonorensis	309891	Bacteria	Bacteria	287	5.599999999999999e-73	NTclustered	gi\|2745307249\|gb\|CP158299.1\|	694439	g55141	i0	87.854	190.479674796748	247	26	100	4	1	246	337743	337986	Deinococcus sonorensis KR-87 chromosome, complete genome	blastn	46858	287	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
7650039	7650039	PRJNA986481_P_NODE_1086_length_1261_cov_17.301980_g337_i1	PRJNA986481	1086	1261	17.30198	218.1779678	Deinococcus	1298	Bacteria	Bacteria	1786	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g337	i1	92.508	202.41712926249	1268	64	99	26	3	1261	2416715	2417960	Deinococcus sp. NW-56 chromosome, complete genome	blastn	255248	1786	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
10200732	10200732	PRJNA986481_P_NODE_428_length_1655_cov_31.421544_g337_i0	PRJNA986481	428	1655	31.421544	520.0265532	Deinococcus	1298	Bacteria	Bacteria	2202	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g337	i0	91.254	211.410271903323	1635	116	98	27	21	1641	2418506	2416885	Deinococcus sp. NW-56 chromosome, complete genome	blastn	349884	2209	0.996831145314622	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14026047	14026047	PRJNA986481_P_NODE_51851_length_250_cov_1.004975_g51326_i0	PRJNA986481	51851	250	1.004975	2.5124375	Thermus	270	Bacteria	Bacteria	403	5.43e-108	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g51326	i0	95.968	46.688	248	10	99	0	3	250	380165	380412	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	11672	403	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
18825734	18825734	PRJNA986481_P_NODE_60455_length_241_cov_1.052083_g59930_i0	PRJNA986481	60455	241	1.052083	2.53552003	Deinococcus ficus	317577	Bacteria	Bacteria	433	6.63e-117	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g59930	i0	99.167	2.02904564315353	240	2	99	0	1	240	2017915	2018154	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	489	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
25199961	25199961	PRJNA986481_P_NODE_47500_length_255_cov_0.980583_g46975_i0	PRJNA986481	47500	255	0.980583	2.50048665	Deinococcus ficus	317577	Bacteria	Bacteria	438	1.52e-118	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g46975	i0	97.647	97.2352941176471	255	6	100	0	1	255	1710129	1709875	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	24795	438	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
26614674	26614674	PRJNA986481_P_NODE_17261_length_394_cov_5.997101_g16736_i0	PRJNA986481	17261	394	5.997101	23.62857794	Deinococcus budaensis	1665626	Bacteria	Bacteria	85.5	6.89e-17	NR	WP_184026840.1	1665626	g16736	i0	42.7	3.25888324873096	110	58	82.2	2	351	28	190	296	WP_184026840.1 alpha/beta fold hydrolase [Deinococcus budaensis]	diamond	1284	85.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
27531982	27531982	PRJNA986481_P_NODE_4303_length_750_cov_4.804565_g3895_i0	PRJNA986481	4303	750	4.804565	36.0342375	Deinococcus rhizophilus	3049544	Bacteria	Bacteria	117	1.59e-29	NR	WP_285522375.1	3049544	g3895	i0	90.8	0.26	65	6	26	0	282	88	59	123	WP_285522375.1 type II toxin-antitoxin system PemK/MazF family toxin [Deinococcus rhizophilus]	diamond	195	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus rhizophilus
29242950	29242950	PRJNA986481_P_NODE_36909_length_268_cov_1.799087_g36384_i0	PRJNA986481	36909	268	1.799087	4.82155316	root	1	Root_unresolved	Root_unresolved	107	1.2699999999999999e-24	NR	WP_027877425.1	65552	g36384	i0	55.7	8.87686567164179	88	38	97.4	1	4	264	232	319	WP_027877425.1 G8 domain-containing protein [Meiothermus cerbereus]	diamond	2379	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus cerbereus
29931849	29931849	PRJNA986481_P_NODE_57491_length_244_cov_1.035897_g56966_i0	PRJNA986481	57491	244	1.035897	2.52758868	Meiothermus sp.	1955249	Bacteria	Bacteria	44.7	0.00775	NR	MER3556030.1	1955249	g56966	i0	36.4	0.811475409836066	66	38	77.5	3	224	36	657	721	MER3556030.1 penicillin acylase family protein [Meiothermus sp.]	diamond	198	44.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
29969134	29969134	PRJNA986481_P_NODE_14971_length_424_cov_1.565333_g14446_i0	PRJNA986481	14971	424	1.565333	6.63701192	Bacteria	2	Bacteria	Bacteria	46.2	0.015	NR	WP_092264861.1	856736	g14446	i0	40	1.47877358490566	105	48	71.5	5	57	359	194	287	WP_092264861.1 DUF937 domain-containing protein [Deinococcus reticulitermitis]	diamond	627	46.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis

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