metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
23404567	23404567	PRJNA492406_P_NODE_12739_length_350_cov_2.252708_g12440_i0	PRJNA492406	12739	350	2.252708	7.884478	Deinococcus xianganensis	1507289	Bacteria	Bacteria	122	1.47e-32	NR	WP_160978709.1	1507289	g12440	i0	63.4	0.96	112	37	95.1	2	2	334	11	119	WP_160978709.1 spore coat protein U domain-containing protein [Deinococcus xianganensis]	diamond	336	122	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus xianganensis
26727801	26727801	PRJNA492406_P_NODE_2021_length_855_cov_5.127877_g1757_i0	PRJNA492406	2021	855	5.127877	43.84334835	Deinococcus	1298	Bacteria	Bacteria	116	8.9e-27	NR	WP_157459620.1	1298	g1757	i0	43.8	0.617543859649123	176	93	59.6	3	307	816	5	180	WP_157459620.1 MULTISPECIES: hypothetical protein [Deinococcus]	diamond	528	116	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
27424296	27424296	PRJNA492406_P_NODE_28523_length_247_cov_1.672414_g28224_i0	PRJNA492406	28523	247	1.672414	4.13086258	Deinococcus sp. JMULE3	2518341	Bacteria	Bacteria	130	1.18e-33	NR	WP_174365940.1	2518341	g28224	i0	90.2	0.995951417004049	82	8	99.6	0	246	1	151	232	WP_174365940.1 hypothetical protein [Deinococcus sp. JMULE3]	diamond	246	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. JMULE3
27692895	27692895	PRJNA492406_P_NODE_12924_length_348_cov_1.625455_g12625_i0	PRJNA492406	12924	348	1.625455	5.6565834	Deinococcus	1298	Bacteria	Bacteria	88.6	1.3e-19	NR	AKH15864.1	1309411	g12625	i0	62.1	1.70689655172414	66	25	56.9	0	4	201	84	149	AKH15864.1 hypothetical protein SY84_01060 [Deinococcus soli (ex Cha et al. 2016)]	diamond	594	88.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
28907774	28907774	PRJNA492406_P_NODE_28188_length_248_cov_0.880000_g27889_i0	PRJNA492406	28188	248	0.88	2.1824	Deinococcus sp. 14RED	47478	Bacteria	Bacteria	132	1.56e-37	NR	WP_230289903.1	2745874	g27889	i0	100	0.786290322580645	65	0	78.6	0	195	1	1	65	WP_230289903.1 hypothetical protein [Deinococcus sp. 14RED07]	diamond	195	132	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. 14RED07
29003207	29003207	PRJNA492406_P_NODE_18988_length_288_cov_1.316279_g18689_i0	PRJNA492406	18988	288	1.316279	3.79088352	Deinococcus humi	662880	Bacteria	Bacteria	142	7.59e-41	NR	MBB5366490.1	662880	g18689	i0	76.5	0.885416666666667	85	20	88.5	0	34	288	1	85	MBB5366490.1 hypothetical protein [Deinococcus humi]	diamond	255	142	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus humi
29413113	29413113	PRJNA492406_P_NODE_29169_length_246_cov_1.335260_g28870_i0	PRJNA492406	29169	246	1.33526	3.2847396	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	154	1.62e-41	NR	WP_092263339.1	856736	g28870	i0	92.6	0.98780487804878	81	6	98.8	0	245	3	288	368	WP_092263339.1 S8 family serine peptidase [Deinococcus reticulitermitis]	diamond	243	154	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
30329695	30329695	PRJNA492406_P_NODE_23132_length_268_cov_1.210256_g22833_i0	PRJNA492406	23132	268	1.210256	3.24348608	Deinococcus soli (ex Cha et al. 2	1309411	Bacteria	Bacteria	68.9	2.95e-12	NR	WP_188844116.1	1309411	g22833	i0	88.6	0.391791044776119	35	4	39.2	0	266	162	27	61	WP_188844116.1 hypothetical protein [Deinococcus soli (ex Cha et al. 2016)]	diamond	105	68.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
30329703	30329703	PRJNA492406_P_NODE_30752_length_243_cov_1.405882_g30453_i0	PRJNA492406	30752	243	1.405882	3.41629326	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	152	6.599999999999998e-41	NR	WP_295814506.1	158789	g30453	i0	85	0.987654320987654	80	12	98.8	0	2	241	270	349	WP_295814506.1 phage portal protein [uncultured Deinococcus sp.]	diamond	240	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
30361264	30361264	PRJNA492406_P_NODE_31572_length_242_cov_0.911243_g31273_i0	PRJNA492406	31572	242	0.911243	2.20520806	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	67	5.54e-11	NR	WP_015237158.1	432329	g31273	i0	50.8	1.68595041322314	63	31	78.1	0	4	192	31	93	WP_015237158.1 translation elongation factor Ts [Deinococcus peraridilitoris]	diamond	408	67	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
32384335	32384335	PRJNA492406_P_NODE_28199_length_248_cov_0.880000_g27900_i0	PRJNA492406	28199	248	0.88	2.1824	Deinococcus sedimenti	1867090	Bacteria	Bacteria	84	2.05e-17	NR	WP_189074852.1	1867090	g27900	i0	93.6	0.568548387096774	47	3	56.9	0	143	3	1	47	WP_189074852.1 2,3-dihydro-2,3-dihydroxybenzoate dehydrogenase [Deinococcus sedimenti]	diamond	141	84	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);;