metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA1233317" 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
1610244	1610244	PRJNA1233317_S_NODE_14562_length_201_cov_3.007042_g14526_i0	PRJNA1233317	14562	201	3.007042	6.04415442	Arthrobacter russicus	172040	Bacteria	Bacteria	149	4.24e-43	NR	WP_309796214.1	172040	g14526	i0	100	1	67	0	100	0	1	201	119	185	WP_309796214.1 class I SAM-dependent methyltransferase [Arthrobacter russicus]	diamond	201	149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter russicus
5438937	5438937	PRJNA1233317_S_NODE_9525_length_252_cov_0.948187_g9489_i0	PRJNA1233317	9525	252	0.948187	2.38943124	Microbacterium	33882	Bacteria	Bacteria	115	3.2000000000000003e-28	NR	WP_045247306.1	33882	g9489	i0	95.2	0.738095238095238	62	3	73.8	0	4	189	349	410	WP_045247306.1 MULTISPECIES: gephyrin-like molybdotransferase Glp [Microbacterium]	diamond	186	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium
13089311	13089311	PRJNA1233317_S_NODE_3651_length_345_cov_3.461538_g3615_i0	PRJNA1233317	3651	345	3.461538	11.9423061	Microbacterium	33882	Bacteria	Bacteria	219	2.07e-65	NR	WP_288453179.1	191216	g3615	i0	100	3	115	0	100	0	345	1	370	484	WP_288453179.1 type VII secretion protein EccCa, partial [uncultured Microbacterium sp.]	diamond	1035	219	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	uncultured Microbacterium sp.
26597635	26597635	PRJNA1233317_S_NODE_6581_length_292_cov_32.360515_g6545_i0	PRJNA1233317	6581	292	32.360515	94.4927038	Microthrixaceae bacterium	2497627	Bacteria	Bacteria	43.1	0.044	NR	MEZ5269981.1	2497627	g6545	i0	48.6	0.38013698630137	37	19	38	0	178	288	242	278	MEZ5269981.1 enoyl-CoA hydratase-related protein [Microthrixaceae bacterium]	diamond	111	43.1	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Microthrixaceae		Microthrixaceae bacterium
26977850	26977850	PRJNA1233317_S_NODE_8322_length_267_cov_12.062500_g8286_i0	PRJNA1233317	8322	267	12.0625	32.206875	Haloechinothrix halophila	1069073	Bacteria	Bacteria	43.9	0.019	NR	WP_034268929.1	1069073	g8286	i0	42	0.561797752808989	50	25	51.7	1	35	172	102	151	WP_034268929.1 amidohydrolase [Haloechinothrix halophila]	diamond	150	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Haloechinothrix	Haloechinothrix halophila
27294016	27294016	PRJNA1233317_S_NODE_9183_length_256_cov_3.091371_g9147_i0	PRJNA1233317	9183	256	3.091371	7.91390976	Actinomycetota bacterium	2900548	Bacteria	Bacteria	43.1	0.0305	NR	MBW3661883.1	2900548	g9147	i0	40.4	0.609375	52	27	56.3	1	255	112	201	252	MBW3661883.1 DUF222 domain-containing protein [Actinomycetota bacterium]	diamond	156	43.1	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27470848	27470848	PRJNA1233317_S_NODE_5843_length_304_cov_3.648980_g5807_i0	PRJNA1233317	5843	304	3.64898	11.0928992	Bacillati	1783272	Bacteria	Bacteria	198	2.66e-61	NR	PYC99595.1	57043	g5807	i0	100	1.83552631578947	93	0	91.8	0	280	2	22	114	PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum]	diamond	558	198	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
27692044	27692044	PRJNA1233317_S_NODE_9704_length_249_cov_3.784211_g9668_i0	PRJNA1233317	9704	249	3.784211	9.42268539	Bacillati	1783272	Bacteria	Bacteria	106	4.6e-27	NR	PYC99492.1	57043	g9668	i0	78.3	1.66265060240964	69	15	83.1	0	246	40	84	152	PYC99492.1 hypothetical protein B4U78_016815, partial [Microbacterium esteraromaticum]	diamond	414	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
28872743	28872743	PRJNA1233317_S_NODE_16568_length_187_cov_3.257812_g16532_i0	PRJNA1233317	16568	187	3.257812	6.09210844	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	41.6	0.0449	NR	WP_362335506.1	3155130	g16532	i0	39.5	0.689839572192513	43	26	69	0	39	167	444	486	WP_362335506.1 protein kinase domain-containing protein [Streptomyces sp. NPDC041068]	diamond	129	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC041068
29125681	29125681	PRJNA1233317_S_NODE_8029_length_272_cov_0.976526_g7993_i0	PRJNA1233317	8029	272	0.976526	2.65615072	Streptomyces triticiradicis	2651189	Bacteria	Bacteria	43.1	0.037	NR	WP_151473195.1	2651189	g7993	i0	33.8	0.816176470588235	74	38	73.9	2	70	270	28	97	WP_151473195.1 M20 family metallopeptidase [Streptomyces triticiradicis]	diamond	222	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces triticiradicis
30009735	30009735	PRJNA1233317_S_NODE_15251_length_196_cov_5.043796_g15215_i0	PRJNA1233317	15251	196	5.043796	9.88584016	Ornithinimicrobium avium	2283195	Bacteria	Bacteria	85.1	6.1e-18	NR	WP_162802826.1	2283195	g15215	i0	67.2	0.979591836734694	64	21	98	0	4	195	57	120	WP_162802826.1 Flp pilus assembly protein CpaB [Ornithinimicrobium avium]	diamond	192	85.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Ornithinimicrobiaceae	Ornithinimicrobium	Ornithinimicrobium avium
31368586	31368586	PRJNA1233317_S_NODE_9936_length_246_cov_2.935829_g9900_i0	PRJNA1233317	9936	246	2.935829	7.22213934	Streptomyces roseolus	67358	Bacteria	Bacteria	42.4	0.0083	NR	WP_359530280.1	67358	g9900	i0	45.7	0.560975609756098	46	23	56.1	1	98	235	29	72	WP_359530280.1 chaplin [Streptomyces roseolus]	diamond	138	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces roseolus
32114832	32114832	PRJNA1233317_S_NODE_10158_length_244_cov_1.772973_g10122_i0	PRJNA1233317	10158	244	1.772973	4.32605412	Bacillati	1783272	Bacteria	Bacteria	153	3.81e-44	NR	PYC99595.1	57043	g10122	i0	100	1.99180327868852	81	0	99.6	0	2	244	153	233	PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum]	diamond	486	153	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum

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