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

14 rows where bioproject = "PRJNA637219" 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
1155116	1155116	PRJNA637219_S_NODE_821_length_464_cov_1.937349_g776_i0	PRJNA637219	821	464	1.937349	8.98929936	Deinococcus	1298	Bacteria	Bacteria	577	6.01e-160	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g776	i0	94.195	129.799568965517	379	20	81	2	1	378	2671807	2672184	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	60227	577	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
3159735	3159735	PRJNA637219_S_NODE_16343_length_162_cov_0.876106_g16298_i0	PRJNA637219	16343	162	0.876106	1.41929172	Deinococcus aquaticus	328692	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g16298	i0	88.272	18.0679012345679	162	19	100	0	1	162	1110482	1110643	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	2927	195	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
4436461	4436461	PRJNA637219_S_NODE_13704_length_164_cov_0.886957_g13659_i0	PRJNA637219	13704	164	0.886957	1.45460948	Deinococcus	1298	Bacteria	Bacteria	107	5.820000000000001e-26	NR	GBF08110.1	200253	g13659	i0	88.9	7.90243902439024	54	6	98.8	0	164	3	372	425	GBF08110.1 peptide chain release factor 2, partial [Deinococcus aerius]	diamond	1296	108	0.990740740740741	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aerius
4436495	4436495	PRJNA637219_S_NODE_15704_length_162_cov_0.902655_g15659_i0	PRJNA637219	15704	162	0.902655	1.4623011	Deinococcus geothermalis	68909	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|110746139\|gb\|CP000358.2\|	319795	g15659	i0	100	2	162	0	100	0	1	162	148157	147996	Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence	blastn	324	300	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
5712373	5712373	PRJNA637219_S_NODE_1245_length_388_cov_2.486726_g1200_i0	PRJNA637219	1245	388	2.486726	9.64849688	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	706	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g1200	i0	99.485	321.868556701031	388	2	100	0	1	388	57605	57218	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	124885	706	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
14637776	14637776	PRJNA637219_S_NODE_5512_length_212_cov_2.343558_g5467_i0	PRJNA637219	5512	212	2.343558	4.96834296	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	331	2.1400000000000006e-86	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g5467	i0	95.673	193.169811320755	208	5	98	3	4	208	55639	55433	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	40952	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
17186767	17186767	PRJNA637219_S_NODE_17394_length_161_cov_0.875000_g17349_i0	PRJNA637219	17394	161	0.875	1.40875	Deinococcus	1298	Bacteria	Bacteria	91.3	7.36e-20	NR	WP_184030676.1	1665626	g17349	i0	88.7	2.96273291925466	53	6	98.8	0	2	160	267	319	WP_184030676.1 M28 family peptidase [Deinococcus budaensis]	diamond	477	91.7	0.995637949836423	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
18460895	18460895	PRJNA637219_S_NODE_1595_length_351_cov_2.254967_g1550_i0	PRJNA637219	1595	351	2.254967	7.91493417	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	643	4.3e-180	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g1550	i0	99.715	174.524216524217	351	1	100	0	1	351	57606	57956	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	61258	643	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
18460921	18460921	PRJNA637219_S_NODE_17615_length_158_cov_2.339450_g17570_i0	PRJNA637219	17615	158	2.33945	3.696331	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g17570	i0	100	201.056962025316	158	0	100	0	1	158	58177	58020	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	31767	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
19735465	19735465	PRJNA637219_S_NODE_14056_length_164_cov_0.886957_g14011_i0	PRJNA637219	14056	164	0.886957	1.45460948	Deinococcus grandis	57498	Bacteria	Bacteria	202	1.28e-47	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g14011	i0	90.323	26.6524390243902	155	14	95	1	1	155	2249592	2249745	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	4371	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
28451634	28451634	PRJNA637219_S_NODE_10786_length_167_cov_0.864407_g10741_i0	PRJNA637219	10786	167	0.864407	1.44355969	root	1	Root_unresolved	Root_unresolved	109	4.69e-26	NR	1TAQ_A	271	g10741	i0	100	5.92814371257485	55	0	98.8	0	167	3	461	515	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	990	109	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
28596996	28596996	PRJNA637219_S_NODE_14727_length_163_cov_0.894737_g14682_i0	PRJNA637219	14727	163	0.894737	1.45842131	Synergistes jonesii	2754	Bacteria	Bacteria	69.3	1.06e-12	NR	KEJ91116.1	2754	g14682	i0	62.5	2.02453987730061	56	19	99.4	1	1	162	8	63	KEJ91116.1 hypothetical protein EH55_13135 [Synergistes jonesii]	diamond	330	69.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Synergistes	Synergistes jonesii
29764961	29764961	PRJNA637219_S_NODE_11591_length_166_cov_0.871795_g11546_i0	PRJNA637219	11591	166	0.871795	1.4471797	Deinococcus budaensis	1665626	Bacteria	Bacteria	94.4	7.790000000000001e-21	NR	WP_184031675.1	1665626	g11546	i0	87.3	0.993975903614458	55	7	99.4	0	1	165	160	214	WP_184031675.1 carbohydrate ABC transporter permease [Deinococcus budaensis]	diamond	165	94.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
29764965	29764965	PRJNA637219_S_NODE_4031_length_239_cov_1.994737_g3986_i0	PRJNA637219	4031	239	1.994737	4.76742143	Thermus oshimai	56957	Bacteria	Bacteria	41.2	0.0248	NR	GAA6741988.1	56957	g3986	i0	44.8	0.841004184100418	67	37	84.1	0	35	235	17	83	GAA6741988.1 hypothetical protein Thermus77359_21750 [Thermus oshimai]	diamond	201	41.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai

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