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

6 rows where analysis = "diamond", bioproject = "PRJNA800053" 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
26999575	26999575	PRJNA800053_P_NODE_5742_length_384_cov_0.881029_g5579_i0	PRJNA800053	5742	384	0.881029	3.38315136	Bacteria	2	Bacteria	Bacteria	97.8	1.37e-22	NR	WP_084542836.1	68910	g5579	i0	41.3	5.6953125	126	72	96.9	1	1	372	64	189	WP_084542836.1 HNH endonuclease [Deinococcus murrayi]	diamond	2187	98.6	0.991886409736308	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus murrayi
27559436	27559436	PRJNA800053_P_NODE_21264_length_245_cov_0.895349_g21100_i0	PRJNA800053	21264	245	0.895349	2.19360505	Thermus sp. CCB_US3_UF1	1111069	Bacteria	Bacteria	136	6.649999999999999e-37	NR	WP_014515545.1	1111069	g21100	i0	85.9	0.955102040816327	78	11	95.5	0	238	5	22	99	WP_014515545.1 hypothetical protein [Thermus sp. CCB_US3_UF1]	diamond	234	136	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. CCB_US3_UF1
28475296	28475296	PRJNA800053_P_NODE_24286_length_237_cov_2.457317_g24122_i0	PRJNA800053	24286	237	2.457317	5.82384129	Thermus	270	Bacteria	Bacteria	130	6.36e-33	NR	WP_234502992.1	270	g24122	i0	84.2	0.962025316455696	76	12	96.2	0	8	235	361	436	WP_234502992.1 MULTISPECIES: BTAD domain-containing putative transcriptional regulator [Thermus]	diamond	228	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
28569912	28569912	PRJNA800053_P_NODE_23547_length_241_cov_1.345238_g23383_i0	PRJNA800053	23547	241	1.345238	3.24202358	Deinococcus antarcticus	1298767	Bacteria	Bacteria	157	3.86e-48	NR	WP_380075691.1	1298767	g23383	i0	97.3	3.89626556016598	73	2	90.9	0	220	2	1	73	WP_380075691.1 IS200/IS605 family transposase, partial [Deinococcus antarcticus]	diamond	939	157	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
28790845	28790845	PRJNA800053_P_NODE_22627_length_243_cov_0.905882_g22463_i0	PRJNA800053	22627	243	0.905882	2.20129326	Deinococcus antarcticus	1298767	Bacteria	Bacteria	67.8	3.93e-11	NR	WP_380075745.1	1298767	g22463	i0	57.6	2.35802469135802	66	28	81.5	0	217	20	4	69	WP_380075745.1 tyrosine-type recombinase/integrase [Deinococcus antarcticus]	diamond	573	67.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
30275522	30275522	PRJNA800053_P_NODE_19932_length_247_cov_0.885057_g19768_i0	PRJNA800053	19932	247	0.885057	2.18609079	Deinococcus sedimenti	1867090	Bacteria	Bacteria	58.2	3.72e-8	NR	WP_189074593.1	1867090	g19768	i0	47.8	0.558704453441296	46	24	55.9	0	105	242	2	47	WP_189074593.1 hypothetical protein [Deinococcus sedimenti]	diamond	138	58.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sedimenti

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