metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA827593" 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
16123467	16123467	PRJNA827593_P_NODE_19973_length_476_cov_2.054591_g19675_i0	PRJNA827593	19973	476	2.054591	9.77985316	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	306	6.229999999999998e-103	NR	WP_386844773.1	536443	g19675	i0	97.4	0.957983193277311	152	4	95.8	0	3	458	52	203	WP_386844773.1 metalloenzyme domain protein [Deinococcus taklimakanensis]	diamond	456	306	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
16123959	16123959	PRJNA827593_P_NODE_46793_length_294_cov_1.393665_g46494_i0	PRJNA827593	46793	294	1.393665	4.0973751	Deinococcus antarcticus	1298767	Bacteria	Bacteria	181	3.3799999999999996e-56	NR	WP_380076054.1	1298767	g46494	i0	88.7	0.989795918367347	97	11	99	0	292	2	46	142	WP_380076054.1 DinB family protein [Deinococcus antarcticus]	diamond	291	181	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
20354717	20354717	PRJNA827593_P_NODE_38016_length_330_cov_1.797665_g37717_i0	PRJNA827593	38016	330	1.797665	5.9322945	Deinococcus aerolatus	522487	Bacteria	Bacteria	69.3	5.17e-11	NR	WP_188970448.1	522487	g37717	i0	45.6	1.03636363636364	114	57	99.1	2	1	327	1441	1554	WP_188970448.1 DUF2272 domain-containing protein [Deinococcus aerolatus]	diamond	342	69.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aerolatus
26642858	26642858	PRJNA827593_P_NODE_43261_length_307_cov_1.974359_g42962_i0	PRJNA827593	43261	307	1.974359	6.06128213	Deinococcus betulae	2873312	Bacteria	Bacteria	57.4	4.89e-7	NR	WP_224573642.1	2873312	g42962	i0	61	0.400651465798046	41	16	40.1	0	24	146	292	332	WP_224573642.1 ParB/RepB/Spo0J family partition protein [Deinococcus betulae]	diamond	123	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus betulae
27180713	27180713	PRJNA827593_P_NODE_42102_length_312_cov_1.518828_g41803_i0	PRJNA827593	42102	312	1.518828	4.73874336	Deinococcus aquiradiocola	393059	Bacteria	Bacteria	113	9.02e-27	NR	WP_188960334.1	393059	g41803	i0	100	0.548076923076923	57	0	54.8	0	311	141	529	585	WP_188960334.1 PQQ-binding-like beta-propeller repeat protein [Deinococcus aquiradiocola]	diamond	171	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquiradiocola
28002306	28002306	PRJNA827593_P_NODE_67965_length_241_cov_0.916667_g67666_i0	PRJNA827593	67965	241	0.916667	2.20916747	Deinococcus sp. KNUC121	47478	Bacteria	Bacteria	60.5	2.05e-8	NR	WP_239051809.1	2917691	g67666	i0	51.8	2.09128630705394	56	21	62.2	2	1	150	298	353	WP_239051809.1 M57 family metalloprotease [Deinococcus sp. KNUC1210]	diamond	504	60.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
28065255	28065255	PRJNA827593_P_NODE_52245_length_275_cov_2.801980_g51946_i0	PRJNA827593	52245	275	2.80198	7.705445	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	76.6	6.62e-14	NR	WP_386844361.1	536443	g51946	i0	43	1.01454545454545	93	50	98.2	2	272	3	852	944	WP_386844361.1 hypothetical protein [Deinococcus taklimakanensis]	diamond	279	76.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
28191299	28191299	PRJNA827593_P_NODE_33826_length_353_cov_1.400000_g33527_i0	PRJNA827593	33826	353	1.4	4.942	Deinococcus antarcticus	1298767	Bacteria	Bacteria	227	2.98e-71	NR	WP_380075471.1	1298767	g33527	i0	96.4	0.943342776203966	111	4	94.3	0	1	333	122	232	WP_380075471.1 NAD(P)/FAD-dependent oxidoreductase [Deinococcus antarcticus]	diamond	333	227	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
29233600	29233600	PRJNA827593_P_NODE_59629_length_255_cov_1.269231_g59330_i0	PRJNA827593	59629	255	1.269231	3.23653905	Deinococcus antarcticus	1298767	Bacteria	Bacteria	120	6.269999999999999e-32	NR	WP_380076602.1	1298767	g59330	i0	96.7	0.717647058823529	61	2	71.8	0	254	72	168	228	WP_380076602.1 HAD family hydrolase [Deinococcus antarcticus]	diamond	183	120	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30149145	30149145	PRJNA827593_P_NODE_66652_length_243_cov_0.905882_g66353_i0	PRJNA827593	66652	243	0.905882	2.20129326	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	72	1.45e-13	NR	WP_386843892.1	536443	g66353	i0	100	0.407407407407407	33	0	40.7	0	6	104	134	166	WP_386843892.1 pyridoxamine 5'-phosphate oxidase family protein [Deinococcus taklimakanensis]	diamond	99	72	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30402514	30402514	PRJNA827593_P_NODE_49233_length_285_cov_2.179245_g48934_i0	PRJNA827593	49233	285	2.179245	6.21084825	Deinococcus apachensis	309886	Bacteria	Bacteria	86.3	3.74e-18	NR	WP_019588719.1	309886	g48934	i0	65.7	1.4	67	20	69.5	2	200	3	1	65	WP_019588719.1 DNA/RNA non-specific endonuclease [Deinococcus apachensis]	diamond	399	86.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus apachensis
30623112	30623112	PRJNA827593_P_NODE_67813_length_241_cov_1.375000_g67514_i0	PRJNA827593	67813	241	1.375	3.31375	Deinococcus antarcticus	1298767	Bacteria	Bacteria	150	6.379999999999998e-42	NR	WP_380075471.1	1298767	g67514	i0	98.7	0.983402489626556	79	1	98.3	0	5	241	15	93	WP_380075471.1 NAD(P)/FAD-dependent oxidoreductase [Deinococcus antarcticus]	diamond	237	150	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
32741407	32741407	PRJNA827593_P_NODE_48700_length_287_cov_1.789720_g48401_i0	PRJNA827593	48700	287	1.78972	5.1364964	Deinococcus yavapaiensis	309889	Bacteria	Bacteria	57.4	4.13e-7	NR	WP_110884932.1	309889	g48401	i0	66.7	0.439024390243902	42	14	43.9	0	268	143	326	367	WP_110884932.1 glutathionylspermidine synthase family protein [Deinococcus yavapaiensis]	diamond	126	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
32835615	32835615	PRJNA827593_P_NODE_54200_length_270_cov_1.172589_g53901_i0	PRJNA827593	54200	270	1.172589	3.1659903	Deinococcus cavernae	2320857	Bacteria	Bacteria	134	1.81e-35	NR	WP_119763708.1	2320857	g53901	i0	79.3	2.71111111111111	82	17	91.1	0	3	248	300	381	WP_119763708.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Deinococcus cavernae]	diamond	732	134	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus cavernae

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