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

9 rows where analysis = "diamond", bioproject = "PRJNA1122875" and tax_phylum = "Deinococcota"

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
2828188	2828188	PRJNA1122875_P_NODE_22043_length_353_cov_1.439286_g21819_i0	PRJNA1122875	22043	353	1.439286	5.08067958	Deinococcus xinjiangensis	457454	Bacteria	Bacteria	99.4	2.4899999999999998e-23	NR	WP_353542942.1	457454	g21819	i0	58.7	1.39376770538244	92	29	78.2	1	278	3	56	138	WP_353542942.1 hypothetical protein [Deinococcus xinjiangensis]	diamond	492	99.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xinjiangensis
16331266	16331266	PRJNA1122875_P_NODE_51793_length_243_cov_0.905882_g51569_i0	PRJNA1122875	51793	243	0.905882	2.20129326	FCB group	1783270	Bacteria	Bacteria	100	1.41e-23	NR	MDQ3458296.1	1913990	g51569	i0	55.6	3.97530864197531	81	36	100	0	243	1	129	209	MDQ3458296.1 tryptophan-rich sensory protein [Deinococcota bacterium]	diamond	966	101	0.99009900990099	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
27027689	27027689	PRJNA1122875_P_NODE_40682_length_259_cov_2.693548_g40458_i0	PRJNA1122875	40682	259	2.693548	6.97628932	Bacteria	2	Bacteria	Bacteria	43.5	0.00551	NR	MEX2542640.1	2026798	g40458	i0	45	1.86486486486486	60	27	66	2	19	189	33	89	MEX2542640.1 stage V sporulation protein S [Trueperaceae bacterium]	diamond	483	43.9	0.990888382687927	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
27070087	27070087	PRJNA1122875_P_NODE_25222_length_330_cov_2.097276_g24998_i0	PRJNA1122875	25222	330	2.097276	6.9210108	Trueperaceae bacterium	2026798	Bacteria	Bacteria	70.5	1.2e-12	NR	MDZ7705414.1	2026798	g24998	i0	46.4	0.881818181818182	97	51	88.2	1	296	6	54	149	MDZ7705414.1 universal stress protein [Trueperaceae bacterium]	diamond	291	70.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29312257	29312257	PRJNA1122875_P_NODE_33549_length_284_cov_2.601896_g33325_i0	PRJNA1122875	33549	284	2.601896	7.38938464	Thermus brockianus	56956	Bacteria	Bacteria	66.2	3.31e-10	NR	WP_071676922.1	56956	g33325	i0	39.1	0.971830985915493	92	32	97.2	1	5	280	667	734	WP_071676922.1 penicillin acylase family protein [Thermus brockianus]	diamond	276	66.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus brockianus
29585291	29585291	PRJNA1122875_P_NODE_20510_length_368_cov_1.044068_g20286_i0	PRJNA1122875	20510	368	1.044068	3.84217024	Bacteria	2	Bacteria	Bacteria	253	3.91e-77	NR	1TAQ_A	271	g20286	i0	100	3.97826086956522	122	0	99.5	0	3	368	76	197	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	1464	253	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
29722411	29722411	PRJNA1122875_P_NODE_47050_length_247_cov_1.729885_g46826_i0	PRJNA1122875	47050	247	1.729885	4.27281595	Meiothermus sp.	1955249	Bacteria	Bacteria	43.9	0.0148	NR	WP_337869854.1	1955249	g46826	i0	29.6	0.862348178137652	71	50	86.2	0	17	229	162	232	WP_337869854.1 baseplate J/gp47 family protein [Meiothermus sp.]	diamond	213	43.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
32315131	32315131	PRJNA1122875_P_NODE_44319_length_250_cov_0.870056_g44095_i0	PRJNA1122875	44319	250	0.870056	2.17514	Deinococcus malanensis	1706855	Bacteria	Bacteria	75.9	8.66e-14	NR	WP_189009313.1	1706855	g44095	i0	47	7.932	83	39	99.6	1	250	2	349	426	WP_189009313.1 threonine ammonia-lyase, biosynthetic [Deinococcus malanensis]	diamond	1983	75.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus malanensis
32399018	32399018	PRJNA1122875_P_NODE_44559_length_250_cov_0.870056_g44335_i0	PRJNA1122875	44559	250	0.870056	2.17514	FCB group	1783270	Bacteria	Bacteria	125	1.2699999999999998e-31	NR	WP_188961577.1	393059	g44335	i0	69.5	10.812	82	24	98.4	1	3	248	123	203	WP_188961577.1 malate synthase A [Deinococcus aquiradiocola]	diamond	2703	125	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquiradiocola

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