metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1195374" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1195374" 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
9971033	9971033	PRJNA1195374_P_NODE_6888_length_818_cov_2.464430_g6592_i0	PRJNA1195374	6888	818	2.46443	20.1590374	root	1	Root_unresolved	Root_unresolved	299	1.37e-98	NR	WP_291426924.1	47478	g6592	i0	64.9	23.6772616136919	248	86	90.6	1	40	780	5	252	WP_291426924.1 3-hydroxyacyl-CoA dehydrogenase [Deinococcus sp.]	diamond	19368	301	0.993355481727575	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
20169226	20169226	PRJNA1195374_P_NODE_7756_length_780_cov_1.521924_g7450_i0	PRJNA1195374	7756	780	1.521924	11.8710072	Bacteria	2	Bacteria	Bacteria	295	3.93e-97	NR	WP_303102018.1	47478	g7450	i0	65	41.3346153846154	243	84	93.1	1	3	728	10	252	WP_303102018.1 3-hydroxyacyl-CoA dehydrogenase [Deinococcus sp.]	diamond	32241	295	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
23994915	23994915	PRJNA1195374_P_NODE_51279_length_306_cov_1.622318_g50935_i0	PRJNA1195374	51279	306	1.622318	4.96429308	Bacteria	2	Bacteria	Bacteria	174	3.36e-48	NR	1TAQ_A	271	g50935	i0	98.9	2.73529411764706	93	1	91.2	0	306	28	740	832	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	837	174	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
26711278	26711278	PRJNA1195374_P_NODE_69261_length_255_cov_1.269231_g68917_i0	PRJNA1195374	69261	255	1.269231	3.23653905	root	1	Root_unresolved	Root_unresolved	161	5.65e-44	NR	1TAQ_A	271	g68917	i0	97.6	3.95294117647059	84	2	98.8	0	2	253	465	548	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1008	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27312916	27312916	PRJNA1195374_P_NODE_60543_length_278_cov_1.502439_g60199_i0	PRJNA1195374	60543	278	1.502439	4.17678042	root	1	Root_unresolved	Root_unresolved	177	1.72e-49	NR	1TAQ_A	271	g60199	i0	100	5.9568345323741	92	0	99.3	0	2	277	387	478	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1656	177	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27483198	27483198	PRJNA1195374_P_NODE_17243_length_545_cov_1.864407_g16901_i0	PRJNA1195374	17243	545	1.864407	10.16101815	Thermosipho melanesiensis	46541	Bacteria	Bacteria	124	4.27e-31	NR	WP_012057074.1	46541	g16901	i0	47.6	9.35229357798165	124	63	68.3	2	170	541	4	125	WP_012057074.1 purine-nucleoside phosphorylase [Thermosipho melanesiensis]	diamond	5097	124	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Thermosipho	Thermosipho melanesiensis
27944306	27944306	PRJNA1195374_P_NODE_65205_length_266_cov_1.196891_g64861_i0	PRJNA1195374	65205	266	1.196891	3.18373006	Bacteria	2	Bacteria	Bacteria	178	7.68e-50	NR	1TAQ_A	271	g64861	i0	100	4.96240601503759	88	0	99.2	0	264	1	615	702	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1320	178	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
30407702	30407702	PRJNA1195374_P_NODE_54233_length_296_cov_0.946188_g53889_i0	PRJNA1195374	54233	296	0.946188	2.80071648	Bacteria	2	Bacteria	Bacteria	73.2	1.44e-12	NR	WP_072757930.1	44754	g53889	i0	46.3	4.48986486486486	95	48	95.3	3	4	285	966	1058	WP_072757930.1 cellobiose phosphorylase [Fervidobacterium gondwanense]	diamond	1329	73.6	0.994565217391304	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
31545290	31545290	PRJNA1195374_P_NODE_43156_length_338_cov_1.947170_g42812_i0	PRJNA1195374	43156	338	1.94717	6.5814346	Bacteria	2	Bacteria	Bacteria	233	8.48e-70	NR	1TAQ_A	271	g42812	i0	100	3.96745562130178	112	0	99.4	0	2	337	100	211	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1341	233	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus

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