metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA980839" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA980839" 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
28005658	28005658	PRJNA980839_P_NODE_235245_length_242_cov_0.911243_g231461_i0	PRJNA980839	235245	242	0.911243	2.20520806	uncultured Truepera sp.	543023	Bacteria	Bacteria	42	0.0461	NR	CAA9558971.1	543023	g231461	i0	58.6	0.359504132231405	29	12	36	0	89	3	1	29	CAA9558971.1 MAG: Two-component transcriptional response regulator, LuxR family [uncultured Truepera sp.]	diamond	87	42	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
28194658	28194658	PRJNA980839_P_NODE_159806_length_278_cov_3.292683_g156022_i0	PRJNA980839	159806	278	3.292683	9.15365874	Deinococcus aestuarii	2774531	Bacteria	Bacteria	147	1.32e-38	NR	WP_216326300.1	2774531	g156022	i0	71.7	2.9568345323741	92	26	99.3	0	3	278	115	206	WP_216326300.1 glycoside hydrolase family 78 protein [Deinococcus aestuarii]	diamond	822	147	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aestuarii
29205432	29205432	PRJNA980839_P_NODE_206369_length_249_cov_0.875000_g202585_i0	PRJNA980839	206369	249	0.875	2.17875	Thermus brockianus	56956	Bacteria	Bacteria	42.7	0.0325	NR	WP_244363896.1	56956	g202585	i0	36.4	0.662650602409639	55	28	66.3	1	15	179	62	109	WP_244363896.1 nickel permease [Thermus brockianus]	diamond	165	42.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
30279422	30279422	PRJNA980839_P_NODE_247812_length_200_cov_4.362205_g244028_i0	PRJNA980839	247812	200	4.362205	8.72441	Deinococcus budaensis	1665626	Bacteria	Bacteria	112	8.54e-27	NR	WP_343057851.1	1665626	g244028	i0	87.9	0.99	66	8	99	0	1	198	136	201	WP_343057851.1 replication restart helicase PriA [Deinococcus budaensis]	diamond	198	112	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus budaensis
32681336	32681336	PRJNA980839_P_NODE_223020_length_245_cov_0.895349_g219236_i0	PRJNA980839	223020	245	0.895349	2.19360505	Meiothermus hypogaeus	884155	Bacteria	Bacteria	68.2	1.01e-11	NR	WP_244947016.1	884155	g219236	i0	48.6	0.857142857142857	70	34	85.7	1	231	22	130	197	WP_244947016.1 DUF6423 family protein [Meiothermus hypogaeus]	diamond	210	68.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus hypogaeus

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