metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA756891" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA756891" 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
3283318	3283318	PRJNA756891_P_NODE_14043_length_246_cov_2.248555_g13974_i0	PRJNA756891	14043	246	2.248555	5.5314453	root	1	Root_unresolved	Root_unresolved	164	7.98e-46	NR	AAX47270.1	271	g13974	i0	100	3.95121951219512	81	0	98.8	0	244	2	250	330	AAX47270.1 DNA polymerase large fragment, partial [Thermus aquaticus]	diamond	972	164	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
5835558	5835558	PRJNA756891_P_NODE_225_length_1436_cov_3.232575_g204_i0	PRJNA756891	225	1436	3.232575	46.419777	Deinococcus	1298	Bacteria	Bacteria	171	4.0799999999999996e-43	NR	WP_034341698.1	392413	g204	i0	38.8	1.70473537604457	255	151	52.4	3	1425	673	212	465	WP_034341698.1 DEAD/DEAH box helicase [Deinococcus misasensis]	diamond	2448	172	0.994186046511628	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus misasensis
9660478	9660478	PRJNA756891_P_NODE_14408_length_246_cov_0.890173_g14339_i0	PRJNA756891	14408	246	0.890173	2.18982558	Deinococcus budaensis	1665626	Bacteria	Bacteria	138	9.94e-36	NR	WP_184027207.1	1665626	g14339	i0	90.1	0.98780487804878	81	8	98.8	0	244	2	606	686	WP_184027207.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Deinococcus budaensis]	diamond	243	138	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
16034687	16034687	PRJNA756891_P_NODE_8613_length_296_cov_1.035874_g8544_i0	PRJNA756891	8613	296	1.035874	3.06618704	root	1	Root_unresolved	Root_unresolved	186	5.37e-57	NR	MCL5964846.1	47478	g8544	i0	85.7	19.8648648648649	98	14	99.3	0	296	3	62	159	MCL5964846.1 catalase [Deinococcus sp.]	diamond	5880	186	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
29421140	29421140	PRJNA756891_P_NODE_7389_length_318_cov_0.942857_g7320_i0	PRJNA756891	7389	318	0.942857	2.99828526	Deinococcus metallilatus	1211322	Bacteria	Bacteria	48.9	7.75e-5	NR	WP_129117237.1	1211322	g7320	i0	35.9	0.735849056603774	78	49	73.6	1	234	1	3	79	WP_129117237.1 antibiotic biosynthesis monooxygenase family protein [Deinococcus metallilatus]	diamond	234	48.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
29778371	29778371	PRJNA756891_P_NODE_1751_length_621_cov_3.372263_g1684_i0	PRJNA756891	1751	621	3.372263	20.94175323	Bacteria	2	Bacteria	Bacteria	94	5.5e-20	NR	WP_183987292.1	521158	g1684	i0	36	6.01932367149758	139	79	67.1	4	609	193	66	194	WP_183987292.1 TerD family protein [Deinobacterium chartae]	diamond	3738	94	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinobacterium	Deinobacterium chartae
32843832	32843832	PRJNA756891_P_NODE_15800_length_243_cov_0.905882_g15731_i0	PRJNA756891	15800	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	78.2	8.33e-15	NR	MBR0034851.1	2053624	g15731	i0	49.3	11	75	38	92.6	0	14	238	120	194	MBR0034851.1 alanine--glyoxylate aminotransferase family protein [Synergistaceae bacterium]	diamond	2673	78.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium

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