metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA473824" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA473824" 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
27360912	27360912	PRJNA473824_P_NODE_81023_length_173_cov_3.345588_g80385_i0	PRJNA473824	81023	173	3.345588	5.78786724	Deinococcus antarcticus	1298767	Bacteria	Bacteria	56.6	1.34e-7	NR	WP_380078807.1	1298767	g80385	i0	100	0.433526011560694	25	0	43.4	0	1	75	134	158	WP_380078807.1 glycine-rich domain-containing protein [Deinococcus antarcticus]	diamond	75	56.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
27739979	27739979	PRJNA473824_P_NODE_53504_length_173_cov_6.338235_g52866_i0	PRJNA473824	53504	173	6.338235	10.96514655	Deinococcus aetherius	200252	Bacteria	Bacteria	51.6	9.59e-6	NR	BDP44292.1	200252	g52866	i0	47.5	1.05780346820809	61	27	97.1	1	4	171	159	219	BDP44292.1 MerR family transcriptional regulator [Deinococcus aetherius]	diamond	183	51.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
28118411	28118411	PRJNA473824_P_NODE_89385_length_173_cov_3.095588_g88747_i0	PRJNA473824	89385	173	3.095588	5.35536724	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	53.9	1.65e-6	NR	WP_288481860.1	158789	g88747	i0	100	0.416184971098266	24	0	41.6	0	2	73	611	634	WP_288481860.1 S-layer homology domain-containing protein [uncultured Deinococcus sp.]	diamond	72	53.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
28703069	28703069	PRJNA473824_P_NODE_110147_length_173_cov_2.551471_g109509_i0	PRJNA473824	110147	173	2.551471	4.41404483	Bacteria	2	Bacteria	Bacteria	57.4	9.14e-8	NR	WP_013158641.1	52022	g109509	i0	75.6	5.46242774566474	45	9	74.6	1	43	171	197	241	WP_013158641.1 flotillin-like protein FloA [Allomeiothermus silvanus]	diamond	945	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
29381496	29381496	PRJNA473824_P_NODE_91989_length_173_cov_2.992647_g91351_i0	PRJNA473824	91989	173	2.992647	5.17727931	Deinococcus sp. Leaf326	1736338	Bacteria	Bacteria	47	4.6e-4	NR	WP_082505507.1	1736338	g91351	i0	80	0.433526011560694	25	5	43.4	0	99	173	411	435	WP_082505507.1 DNA modification methylase [Deinococcus sp. Leaf326]	diamond	75	47	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Leaf326
29475920	29475920	PRJNA473824_P_NODE_73690_length_173_cov_3.698529_g73052_i0	PRJNA473824	73690	173	3.698529	6.39845517	Thermus	270	Bacteria	Bacteria	46.2	7.01e-4	NR	WP_053766895.1	270	g73052	i0	100	0.398843930635838	23	0	39.9	0	105	173	1	23	WP_053766895.1 MULTISPECIES: helix-turn-helix domain-containing protein [Thermus]	diamond	69	46.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus
29633674	29633674	PRJNA473824_P_NODE_57630_length_173_cov_5.205882_g56992_i0	PRJNA473824	57630	173	5.205882	9.00617586	Thermus caliditerrae	1330700	Bacteria	Bacteria	55.5	1.66e-7	NR	WP_038045255.1	1330700	g56992	i0	92	0.433526011560694	25	2	43.4	0	172	98	92	116	WP_038045255.1 GTP-binding protein [Thermus caliditerrae]	diamond	75	55.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus caliditerrae
29696804	29696804	PRJNA473824_P_NODE_158810_length_151_cov_3.043860_g158172_i0	PRJNA473824	158810	151	3.04386	4.5962286	Deinococcus oregonensis	1805970	Bacteria	Bacteria	42	0.0201	NR	WP_380007819.1	1805970	g158172	i0	69.2	0.516556291390728	26	8	51.7	0	151	74	208	233	WP_380007819.1 PH domain-containing protein [Deinococcus oregonensis]	diamond	78	42	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus oregonensis
30139029	30139029	PRJNA473824_P_NODE_148972_length_151_cov_3.850877_g148334_i0	PRJNA473824	148972	151	3.850877	5.81482427	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	53.9	1.21e-6	NR	WP_386842813.1	536443	g148334	i0	96	0.496688741721854	25	1	49.7	0	75	1	720	744	WP_386842813.1 ATP-dependent Clp protease ATP-binding subunit [Deinococcus taklimakanensis]	diamond	75	53.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30424161	30424161	PRJNA473824_P_NODE_108093_length_173_cov_2.610294_g107455_i0	PRJNA473824	108093	173	2.610294	4.51580862	Deinococcus petrolearius	1751295	Bacteria	Bacteria	52	4.29e-6	NR	WP_380050232.1	1751295	g107455	i0	100	0.867052023121387	25	0	43.4	0	173	99	142	166	WP_380050232.1 AAA family ATPase [Deinococcus petrolearius]	diamond	150	52	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus petrolearius
31466887	31466887	PRJNA473824_P_NODE_87716_length_173_cov_3.147059_g87078_i0	PRJNA473824	87716	173	3.147059	5.44441207	Thermus aquaticus	271	Bacteria	Bacteria	57.4	9.84e-8	NR	KOX91153.1	271	g87078	i0	100	0.867052023121387	25	0	43.4	0	99	173	745	769	KOX91153.1 Alkaline phosphatase synthesis sensor protein PhoR [Thermus aquaticus]	diamond	150	57.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
31672546	31672546	PRJNA473824_P_NODE_105517_length_173_cov_2.661765_g104879_i0	PRJNA473824	105517	173	2.661765	4.60485345	Deinococcus	1298	Bacteria	Bacteria	53.1	2.08e-6	NR	WP_380050253.1	1751295	g104879	i0	66.7	2.4971098265896	48	12	83.2	1	145	2	173	216	WP_380050253.1 vWA domain-containing protein [Deinococcus petrolearius]	diamond	432	53.5	0.992523364485981	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus petrolearius
31909576	31909576	PRJNA473824_P_NODE_64717_length_173_cov_4.330882_g64079_i0	PRJNA473824	64717	173	4.330882	7.49242586	Deinococcus antarcticus	1298767	Bacteria	Bacteria	50.4	2.31e-5	NR	WP_380076255.1	1298767	g64079	i0	100	0.433526011560694	25	0	43.4	0	172	98	212	236	WP_380076255.1 RNase H family protein [Deinococcus antarcticus]	diamond	75	50.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
32131248	32131248	PRJNA473824_P_NODE_92898_length_173_cov_2.948529_g92260_i0	PRJNA473824	92898	173	2.948529	5.10095517	Thermus aquaticus	271	Bacteria	Bacteria	55.8	1.7e-7	NR	WP_211256759.1	271	g92260	i0	100	0.867052023121387	25	0	43.4	0	3	77	71	95	WP_211256759.1 hypothetical protein, partial [Thermus aquaticus]	diamond	150	55.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus

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