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

19 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_phylum = "Actinomycetota"

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
26759535	26759535	PRJNA473201_P_NODE_63401_length_257_cov_1.505435_g62659_i0	PRJNA473201	63401	257	1.505435	3.86896795	Fodinibacter luteus	552064	Bacteria	Bacteria	160	6.12e-45	NR	WP_345204570.1	552064	g62659	i0	88.1	0.980544747081712	84	10	98.1	0	256	5	71	154	WP_345204570.1 hypothetical protein [Fodinibacter luteus]	diamond	252	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Fodinibacter (ex Wang et al. 2009)	Fodinibacter luteus
26871228	26871228	PRJNA473201_P_NODE_76201_length_246_cov_0.890173_g75459_i0	PRJNA473201	76201	246	0.890173	2.18982558	Bacillati	1783272	Bacteria	Bacteria	85.1	7.61e-18	NR	HJA38874.1	2838516	g75459	i0	57.7	2.64634146341463	71	30	86.6	0	6	218	8	78	HJA38874.1 enoyl-CoA hydratase [Candidatus Brevibacterium intestinigallinarum]	diamond	651	85.5	0.9953216374269	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Candidatus Brevibacterium intestinigallinarum
27329178	27329178	PRJNA473201_P_NODE_83783_length_242_cov_0.911243_g83041_i0	PRJNA473201	83783	242	0.911243	2.20520806	Frigoribacterium sp. R865	1880915	Bacteria	Bacteria	42.7	0.0358	NR	WP_396599809.1	3093850	g83041	i0	35.7	0.694214876033058	56	36	69.4	0	213	46	18	73	WP_396599809.1 hypothetical protein [Frigoribacterium sp. R86507]	diamond	168	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Frigoribacterium	Frigoribacterium sp. R86507
27424042	27424042	PRJNA473201_P_NODE_26783_length_381_cov_1.133117_g26041_i0	PRJNA473201	26783	381	1.133117	4.31717577	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	44.7	0.0338	NR	HET6954584.1	2201156	g26041	i0	34.5	0.456692913385827	58	37	45.7	1	197	370	271	327	HET6954584.1 glycosyltransferase family 39 protein [Acidimicrobiales bacterium]	diamond	174	44.7	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
28465909	28465909	PRJNA473201_P_NODE_55346_length_278_cov_10.292683_g54604_i0	PRJNA473201	55346	278	10.292683	28.61365874	Actinacidiphila cocklensis	887465	Bacteria	Bacteria	49.7	1.4e-5	NR	CAG6391361.1	887465	g54604	i0	56.1	0.442446043165468	41	18	44.2	0	274	152	22	62	CAG6391361.1 hypothetical protein SCOCK_1180002 [Actinacidiphila cocklensis]	diamond	123	49.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Actinacidiphila	Actinacidiphila cocklensis
28749949	28749949	PRJNA473201_P_NODE_70147_length_249_cov_0.875000_g69405_i0	PRJNA473201	70147	249	0.875	2.17875	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	151	5.13e-41	NR	WP_304136095.1	1528099	g69405	i0	98.8	0.987951807228916	82	1	98.8	0	3	248	51	132	WP_304136095.1 hypothetical protein [Lawsonella clevelandensis]	diamond	246	151	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
28812746	28812746	PRJNA473201_P_NODE_80248_length_244_cov_0.894737_g79506_i0	PRJNA473201	80248	244	0.894737	2.18315828	unclassified Corynebacterium	2624378	Bacteria	Bacteria	142	2.06e-41	NR	WP_156904634.1	2624378	g79506	i0	100	0.860655737704918	70	0	86.1	0	3	212	71	140	WP_156904634.1 MULTISPECIES: hypothetical protein [unclassified Corynebacterium]	diamond	210	142	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium
28876193	28876193	PRJNA473201_P_NODE_72528_length_248_cov_0.880000_g71786_i0	PRJNA473201	72528	248	0.88	2.1824	Amycolatopsis cihanbeyliensis	1128664	Bacteria	Bacteria	122	2.9299999999999996e-31	NR	WP_142002862.1	1128664	g71786	i0	66.7	5.89112903225806	81	27	98	0	4	246	105	185	WP_142002862.1 class II histone deacetylase [Amycolatopsis cihanbeyliensis]	diamond	1461	122	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis cihanbeyliensis
28939511	28939511	PRJNA473201_P_NODE_66148_length_251_cov_0.865169_g65406_i0	PRJNA473201	66148	251	0.865169	2.17157419	Serinibacter arcticus	1655435	Bacteria	Bacteria	43.1	0.0301	NR	WP_135849703.1	1655435	g65406	i0	46.2	0.621513944223108	52	25	58.6	2	222	76	493	544	WP_135849703.1 glycoside hydrolase family 127 protein [Serinibacter arcticus]	diamond	156	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Beutenbergiaceae	Serinibacter	Serinibacter arcticus
29539170	29539170	PRJNA473201_P_NODE_75350_length_246_cov_0.890173_g74608_i0	PRJNA473201	75350	246	0.890173	2.18982558	Nocardiaceae	85025	Bacteria	Bacteria	43.5	0.02	NR	WP_068423374.1	85025	g74608	i0	54.8	0.378048780487805	31	14	37.8	0	151	243	216	246	WP_068423374.1 MULTISPECIES: amidohydrolase family protein [Nocardiaceae]	diamond	93	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae
29712942	29712942	PRJNA473201_P_NODE_75470_length_246_cov_0.890173_g74728_i0	PRJNA473201	75470	246	0.890173	2.18982558	Frigoribacterium	96492	Bacteria	Bacteria	43.5	0.0196	NR	WP_162240660.1	1736293	g74728	i0	36.7	3.85365853658537	79	44	89	1	246	28	68	146	WP_162240660.1 NADPH-dependent F420 reductase [Frigoribacterium sp. Leaf186]	diamond	948	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Frigoribacterium	Frigoribacterium sp. Leaf186
30377123	30377123	PRJNA473201_P_NODE_72352_length_248_cov_0.880000_g71610_i0	PRJNA473201	72352	248	0.88	2.1824	Bacillati	1783272	Bacteria	Bacteria	127	2.06e-33	NR	WP_174181598.1	1671	g71610	i0	78	27.4959677419355	82	18	99.2	0	1	246	36	117	WP_174181598.1 GDP-L-fucose synthase family protein [Pseudarthrobacter oxydans]	diamond	6819	127	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
30408619	30408619	PRJNA473201_P_NODE_71493_length_248_cov_0.880000_g70751_i0	PRJNA473201	71493	248	0.88	2.1824	Streptomyces	1883	Bacteria	Bacteria	42.7	0.0416	NR	WP_114055375.1	68209	g70751	i0	48.9	1.13709677419355	47	23	55.6	1	26	163	8989	9035	WP_114055375.1 type I polyketide synthase [Streptomyces globosus]	diamond	282	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces globosus
30487019	30487019	PRJNA473201_P_NODE_80473_length_243_cov_1.747059_g79731_i0	PRJNA473201	80473	243	1.747059	4.24535337	Mycolicibacterium phocaicum	319706	Bacteria	Bacteria	139	1.6e-37	NR	WP_197746729.1	319706	g79731	i0	79.7	2.92592592592593	79	16	97.5	0	239	3	150	228	WP_197746729.1 TniQ family protein [Mycolicibacterium phocaicum]	diamond	711	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
30739640	30739640	PRJNA473201_P_NODE_71634_length_248_cov_0.880000_g70892_i0	PRJNA473201	71634	248	0.88	2.1824	Yaniella sp.	2773929	Bacteria	Bacteria	162	1.65e-45	NR	HEY4577632.1	2773929	g70892	i0	98.8	0.991935483870968	82	1	99.2	0	247	2	88	169	HEY4577632.1 asparagine synthase (glutamine-hydrolyzing) [Yaniella sp.]	diamond	246	162	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Yaniella	Yaniella sp.
31308427	31308427	PRJNA473201_P_NODE_82075_length_243_cov_0.905882_g81333_i0	PRJNA473201	82075	243	0.905882	2.20129326	Micrococcus cohnii	993416	Bacteria	Bacteria	155	2.63e-44	NR	WP_184241982.1	993416	g81333	i0	100	0.987654320987654	80	0	98.8	0	242	3	12	91	WP_184241982.1 universal stress protein [Micrococcus cohnii]	diamond	240	155	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus cohnii
31593376	31593376	PRJNA473201_P_NODE_84176_length_242_cov_0.857988_g83434_i0	PRJNA473201	84176	242	0.857988	2.07633096	Nesterenkonia marinintestina	2979865	Bacteria	Bacteria	142	6.6299999999999996e-40	NR	WP_261625096.1	2979865	g83434	i0	86.1	0.979338842975207	79	11	97.9	0	2	238	114	192	WP_261625096.1 tryptophan 2,3-dioxygenase [Nesterenkonia marinintestina]	diamond	237	142	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia marinintestina
32004443	32004443	PRJNA473201_P_NODE_71538_length_248_cov_0.880000_g70796_i0	PRJNA473201	71538	248	0.88	2.1824	Dactylosporangium sp. NPDC	60453	Bacteria	Bacteria	70.9	4.91e-12	NR	WP_350618833.1	3154365	g70796	i0	38.8	2.90322580645161	80	47	96.8	1	2	241	618	695	WP_350618833.1 IPT/TIG domain-containing protein [Dactylosporangium sp. NPDC000244]	diamond	720	70.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium sp. NPDC000244
32432024	32432024	PRJNA473201_P_NODE_58559_length_270_cov_1.299492_g57817_i0	PRJNA473201	58559	270	1.299492	3.5086284	Enteractinococcus	1164863	Bacteria	Bacteria	92.8	1.27e-19	NR	WP_379985465.1	1027633	g57817	i0	91.8	1.08888888888889	49	4	54.4	0	122	268	1	49	WP_379985465.1 DEAD/DEAH box helicase [Enteractinococcus coprophilus]	diamond	294	93.6	0.991452991452991	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Enteractinococcus	Enteractinococcus coprophilus

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