metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax

6 rows where analysis = "diamond", 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
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
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
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);;