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

6 rows where analysis = "diamond", bioproject = "PRJNA879067" 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
4683861	4683861	PRJNA879067_P_NODE_56944_length_471_cov_1.542714_g53459_i0	PRJNA879067	56944	471	1.542714	7.26618294	Deinococcus grandis	57498	Bacteria	Bacteria	199	3.23e-61	NR	WP_058974321.1	57498	g53459	i0	94.9	0.624203821656051	98	5	62.4	0	469	176	167	264	WP_058974321.1 thymidylate synthase [Deinococcus grandis]	diamond	294	199	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
6343227	6343227	PRJNA879067_P_NODE_80705_length_336_cov_1.471483_g77219_i0	PRJNA879067	80705	336	1.471483	4.94418288	Truepera radiovictrix	332249	Bacteria	Bacteria	102	6e-23	NR	WP_013177001.1	332249	g77219	i0	54.3	0.9375	105	45	92	2	313	5	33	136	WP_013177001.1 hypothetical protein [Truepera radiovictrix]	diamond	315	102	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16157835	16157835	PRJNA879067_P_NODE_45493_length_565_cov_2.603659_g42030_i0	PRJNA879067	45493	565	2.603659	14.71067335	Deinococcus koreensis	2054903	Bacteria	Bacteria	293	6.830000000000001e-91	NR	WP_103312966.1	2054903	g42030	i0	84	0.961061946902655	181	29	96.1	0	544	2	436	616	WP_103312966.1 ATP-dependent helicase HrpB [Deinococcus koreensis]	diamond	543	293	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus koreensis
25080635	25080635	PRJNA879067_P_NODE_27660_length_809_cov_21.243207_g24410_i0	PRJNA879067	27660	809	21.243207	171.85754463	Deinococcus antarcticus	1298767	Bacteria	Bacteria	288	1.9399999999999998e-95	NR	WP_380081003.1	1298767	g24410	i0	96.7	0.559950556242274	151	5	56	0	144	596	1	151	WP_380081003.1 hypothetical protein [Deinococcus antarcticus]	diamond	453	288	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
28760516	28760516	PRJNA879067_P_NODE_82087_length_330_cov_1.797665_g78601_i0	PRJNA879067	82087	330	1.797665	5.9322945	Deinococcus aluminii	1656885	Bacteria	Bacteria	182	1.97e-54	NR	WP_345457128.1	1656885	g78601	i0	91.1	1.83636363636364	101	9	91.8	0	328	26	183	283	WP_345457128.1 glycosyltransferase family 1 protein [Deinococcus aluminii]	diamond	606	182	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aluminii
31129153	31129153	PRJNA879067_P_NODE_66795_length_406_cov_2.075075_g63310_i0	PRJNA879067	66795	406	2.075075	8.4248045	Truepera radiovictrix	332249	Bacteria	Bacteria	108	1.42e-26	NR	WP_148221163.1	332249	g63310	i0	76.1	2.97044334975369	71	17	52.5	0	382	170	61	131	WP_148221163.1 glycosyltransferase family 2 protein [Truepera radiovictrix]	diamond	1206	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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