metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA600413" 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
4402658	4402658	PRJNA600413_P_NODE_75444_length_183_cov_1.052239_g74743_i0	PRJNA600413	75444	183	1.052239	1.92559737	Truepera radiovictrix	332249	Bacteria	Bacteria	114	1.26e-27	NR	WP_148221276.1	332249	g74743	i0	93.3	0.983606557377049	60	4	98.4	0	2	181	64	123	WP_148221276.1 biosynthetic arginine decarboxylase [Truepera radiovictrix]	diamond	180	114	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
26826915	26826915	PRJNA600413_P_NODE_75121_length_183_cov_1.335821_g74420_i0	PRJNA600413	75121	183	1.335821	2.44455243	Trueperaceae bacterium	2026798	Bacteria	Bacteria	58.5	2.45e-8	NR	HET8985334.1	2026798	g74420	i0	57.6	0.967213114754098	59	25	96.7	0	6	182	5	63	HET8985334.1 C4-type zinc ribbon domain-containing protein [Trueperaceae bacterium]	diamond	177	58.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
27364705	27364705	PRJNA600413_P_NODE_150463_length_161_cov_0.910714_g149762_i0	PRJNA600413	150463	161	0.910714	1.46624954	uncultured Truepera sp.	543023	Bacteria	Bacteria	98.2	2.67e-22	NR	CAA9559656.1	543023	g149762	i0	86.8	0.987577639751553	53	7	98.8	0	161	3	352	404	CAA9559656.1 MAG: Nicotinamide mononucleotide adenylyltransferase [uncultured Truepera sp.]	diamond	159	98.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27964254	27964254	PRJNA600413_P_NODE_117685_length_165_cov_0.879310_g116984_i0	PRJNA600413	117685	165	0.87931	1.4508615	Deinococcus antarcticus	1298767	Bacteria	Bacteria	52.8	3.68e-6	NR	WP_380076407.1	1298767	g116984	i0	45.8	0.872727272727273	48	26	87.3	0	21	164	166	213	WP_380076407.1 nuclease-related domain-containing protein [Deinococcus antarcticus]	diamond	144	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
28009363	28009363	PRJNA600413_P_NODE_104285_length_167_cov_0.864407_g103584_i0	PRJNA600413	104285	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	46.6	5.77e-4	NR	WP_295405121.1	1955249	g103584	i0	56.3	1.68862275449102	32	14	57.5	0	3	98	372	403	WP_295405121.1 CaiB/BaiF CoA transferase family protein [Meiothermus sp.]	diamond	282	46.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
28058979	28058979	PRJNA600413_P_NODE_148885_length_161_cov_0.910714_g148184_i0	PRJNA600413	148885	161	0.910714	1.46624954	Deinococcus metallilatus	1211322	Bacteria	Bacteria	76.6	5.23e-15	NR	MBB5293720.1	1211322	g148184	i0	81.8	0.819875776397516	44	8	82	0	29	160	1	44	MBB5293720.1 hypothetical protein [Deinococcus metallilatus]	diamond	132	76.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
28185112	28185112	PRJNA600413_P_NODE_90926_length_173_cov_1.556452_g90225_i0	PRJNA600413	90926	173	1.556452	2.69266196	Deinococcus sp.	47478	Bacteria	Bacteria	87.8	1.17e-18	NR	WP_303103337.1	47478	g90225	i0	86.3	1.76878612716763	51	7	88.4	0	20	172	280	330	WP_303103337.1 M20 aminoacylase family protein [Deinococcus sp.]	diamond	306	87.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
28216653	28216653	PRJNA600413_P_NODE_142446_length_162_cov_0.902655_g141745_i0	PRJNA600413	142446	162	0.902655	1.4623011	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	96.3	1.47e-21	NR	WP_386842375.1	536443	g141745	i0	86.5	0.962962962962963	52	7	96.3	0	5	160	70	121	WP_386842375.1 sensor histidine kinase [Deinococcus taklimakanensis]	diamond	156	96.3	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
28438068	28438068	PRJNA600413_P_NODE_140566_length_162_cov_0.902655_g139865_i0	PRJNA600413	140566	162	0.902655	1.4623011	uncultured Truepera sp.	543023	Bacteria	Bacteria	104	1.88e-24	NR	CAA9570478.1	543023	g139865	i0	88.9	1	54	6	100	0	162	1	773	826	CAA9570478.1 MAG: Fe-S protein, homolog of lactate dehydrogenase SO1521 [uncultured Truepera sp.]	diamond	162	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
29132702	29132702	PRJNA600413_P_NODE_139129_length_162_cov_0.902655_g138428_i0	PRJNA600413	139129	162	0.902655	1.4623011	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	95.9	1.97e-21	NR	WP_017869733.1	980427	g138428	i0	79.2	1.96296296296296	53	11	98.1	0	3	161	219	271	WP_017869733.1 acyl-CoA synthetase [Deinococcus wulumuqiensis]	diamond	318	95.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
29258585	29258585	PRJNA600413_P_NODE_126189_length_164_cov_0.886957_g125488_i0	PRJNA600413	126189	164	0.886957	1.45460948	Trueperaceae bacterium	2026798	Bacteria	Bacteria	108	3.0100000000000004e-27	NR	HLU83404.1	2026798	g125488	i0	85.2	1.97560975609756	54	8	98.8	0	2	163	174	227	HLU83404.1 DUF692 family protein [Trueperaceae bacterium]	diamond	324	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
30301528	30301528	PRJNA600413_P_NODE_110032_length_166_cov_0.871795_g109331_i0	PRJNA600413	110032	166	0.871795	1.4471797	Deinococcus terrestris	2651870	Bacteria	Bacteria	108	3.5e-26	NR	WP_152868949.1	2651870	g109331	i0	89.1	0.993975903614458	55	6	99.4	0	166	2	130	184	WP_152868949.1 gluconokinase [Deinococcus terrestris]	diamond	165	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus terrestris
30364691	30364691	PRJNA600413_P_NODE_145252_length_161_cov_1.410714_g144551_i0	PRJNA600413	145252	161	1.410714	2.27124954	Aminiphilus circumscriptus	290732	Bacteria	Bacteria	92.8	2.8e-20	NR	WP_169731310.1	290732	g144551	i0	91.5	0.875776397515528	47	4	87.6	0	160	20	730	776	WP_169731310.1 HD domain-containing phosphohydrolase [Aminiphilus circumscriptus]	diamond	141	92.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminiphilaceae	Aminiphilus	Aminiphilus circumscriptus
30838219	30838219	PRJNA600413_P_NODE_143714_length_161_cov_4.125000_g143013_i0	PRJNA600413	143714	161	4.125	6.64125	Allomeiothermus silvanus	52022	Bacteria	Bacteria	41.6	0.0143	NR	WP_013159895.1	52022	g143013	i0	76.9	0.484472049689441	26	6	48.4	0	3	80	76	101	WP_013159895.1 hypothetical protein [Allomeiothermus silvanus]	diamond	78	41.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
30901497	30901497	PRJNA600413_P_NODE_87174_length_175_cov_1.992063_g86473_i0	PRJNA600413	87174	175	1.992063	3.48611025	Deinococcus antarcticus	1298767	Bacteria	Bacteria	115	1.29e-28	NR	WP_380080397.1	1298767	g86473	i0	100	0.994285714285714	58	0	99.4	0	174	1	3	60	WP_380080397.1 replication initiator protein A [Deinococcus antarcticus]	diamond	174	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus
31185483	31185483	PRJNA600413_P_NODE_155035_length_154_cov_3.419048_g154334_i0	PRJNA600413	155035	154	3.419048	5.26533392	Fervidobacterium sp.	1871331	Bacteria	Bacteria	75.1	4.33e-14	NR	HUM43468.1	1871331	g154334	i0	64	1.94805194805195	50	18	97.4	0	2	151	413	462	HUM43468.1 hypothetical protein [Fervidobacterium sp.]	diamond	300	75.1	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
32293315	32293315	PRJNA600413_P_NODE_74699_length_183_cov_1.522388_g73998_i0	PRJNA600413	74699	183	1.522388	2.78597004	Meiothermus sp.	1955249	Bacteria	Bacteria	88.6	1.15e-18	NR	MDX2006041.1	1955249	g73998	i0	63.8	0.950819672131147	58	21	95.1	0	2	175	285	342	MDX2006041.1 M12 family metallopeptidase [Meiothermus sp.]	diamond	174	88.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus sp.
32811255	32811255	PRJNA600413_P_NODE_115600_length_165_cov_1.758621_g114899_i0	PRJNA600413	115600	165	1.758621	2.90172465	Bacteria	2	Bacteria	Bacteria	62.4	5.48e-10	NR	WP_028493636.1	88190	g114899	i0	61.8	15.9272727272727	55	20	98.2	1	3	164	129	183	WP_028493636.1 SPASM domain-containing protein [Thermus antranikianii]	diamond	2628	62.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
32842667	32842667	PRJNA600413_P_NODE_139140_length_162_cov_0.902655_g138439_i0	PRJNA600413	139140	162	0.902655	1.4623011	Deinococci	188787	Bacteria	Bacteria	97.4	7.35e-23	NR	MFA5551572.1	2026798	g138439	i0	83	9.81481481481481	53	9	98.1	0	161	3	187	239	MFA5551572.1 3-hydroxyacyl-CoA dehydrogenase family protein [Trueperaceae bacterium]	diamond	1590	97.8	0.995910020449898	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium

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