metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA495917" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA495917" 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
1752447	1752447	PRJNA495917_S_NODE_15382_length_154_cov_1.008403_g15188_i0	PRJNA495917	15382	154	1.008403	1.55294062	Microbacterium sp. NPDC	51671	Bacteria	Bacteria	84	2.11e-19	NR	WP_378822112.1	3346941	g15188	i0	93.8	2.84415584415584	48	3	93.5	0	1	144	49	96	WP_378822112.1 ATP-binding protein, partial [Microbacterium sp. NPDC059771]	diamond	438	84	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. NPDC059771
7486052	7486052	PRJNA495917_S_NODE_9486_length_178_cov_0.958042_g9292_i0	PRJNA495917	9486	178	0.958042	1.70531476	Bacteria	2	Bacteria	Bacteria	98.2	3.89e-25	NR	WP_409111299.1	1930	g9292	i0	95.8	1.61797752808989	48	2	80.9	0	33	176	2	49	WP_409111299.1 aldo/keto reductase, partial [Streptomyces scabiei]	diamond	288	98.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces scabiei
13231353	13231353	PRJNA495917_S_NODE_16891_length_150_cov_1.043478_g16697_i0	PRJNA495917	16891	150	1.043478	1.565217	Kocuria	57493	Bacteria	Bacteria	92.4	2.84e-22	NR	WP_259915722.1	262208	g16697	i0	89.8	1.96	49	5	98	0	3	149	86	134	WP_259915722.1 MaoC family dehydratase N-terminal domain-containing protein [Kocuria carniphila]	diamond	294	92.8	0.995689655172414	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria carniphila
13861498	13861498	PRJNA495917_S_NODE_13711_length_159_cov_0.959677_g13517_i0	PRJNA495917	13711	159	0.959677	1.52588643	Leifsonia sp. TF	1870902	Bacteria	Bacteria	102	1.3e-25	NR	WP_208042582.1	2815212	g13517	i0	100	0.981132075471698	52	0	98.1	0	3	158	45	96	WP_208042582.1 TetR/AcrR family transcriptional regulator [Leifsonia sp. TF02-11]	diamond	156	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
27614249	27614249	PRJNA495917_S_NODE_16484_length_151_cov_1.034483_g16290_i0	PRJNA495917	16484	151	1.034483	1.56206933	Actinomycetota bacterium	2900548	Bacteria	Bacteria	98.6	4.24e-24	NR	MBN9630891.1	2900548	g16290	i0	100	0.993377483443709	50	0	99.3	0	2	151	61	110	MBN9630891.1 TetR family transcriptional regulator [Actinomycetota bacterium]	diamond	150	98.6	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27803673	27803673	PRJNA495917_S_NODE_3384_length_266_cov_4.696970_g3190_i0	PRJNA495917	3384	266	4.69697	12.4939402	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	41.6	0.0291	NR	MBM3808033.1	2080302	g3190	i0	35.7	0.789473684210526	70	32	71.1	4	224	36	24	87	MBM3808033.1 DUF1624 domain-containing protein [Acidimicrobiia bacterium]	diamond	210	41.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
28276991	28276991	PRJNA495917_S_NODE_15566_length_153_cov_1.355932_g15372_i0	PRJNA495917	15566	153	1.355932	2.07457596	Mycobacterium tuberculosis	1773	Bacteria	Bacteria	107	6.57e-29	NR	WP_210015665.1	1773	g15372	i0	100	2	51	0	100	0	1	153	17	67	WP_210015665.1 acyltransferase family protein, partial [Mycobacterium tuberculosis]	diamond	306	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
28403456	28403456	PRJNA495917_S_NODE_5646_length_214_cov_1.927374_g5452_i0	PRJNA495917	5646	214	1.927374	4.12458036	Candidatus Planktophila sp.	2175601	Bacteria	Bacteria	111	8.79e-27	NR	MBU3735315.1	2175601	g5452	i0	71.4	0.981308411214953	70	20	98.1	0	3	212	189	258	MBU3735315.1 hypothetical protein [Candidatus Planktophila sp.]	diamond	210	111	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales	Candidatus Nanopelagicaceae	Candidatus Planktophila	Candidatus Planktophila sp.
28592988	28592988	PRJNA495917_S_NODE_14647_length_156_cov_0.991736_g14453_i0	PRJNA495917	14647	156	0.991736	1.54710816	Arthrobacter sp. Leaf141	1736273	Bacteria	Bacteria	87	1.86e-18	NR	WP_056599505.1	1736273	g14453	i0	72	0.961538461538462	50	14	96.2	0	2	151	164	213	WP_056599505.1 FAD-dependent monooxygenase [Arthrobacter sp. Leaf141]	diamond	150	87	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. Leaf141
28624665	28624665	PRJNA495917_S_NODE_14667_length_156_cov_0.991736_g14473_i0	PRJNA495917	14667	156	0.991736	1.54710816	Kocuria sp.	1871328	Bacteria	Bacteria	110	2.41e-28	NR	WP_303381675.1	1871328	g14473	i0	100	1	52	0	100	0	156	1	12	63	WP_303381675.1 peptidyl-tRNA hydrolase [Kocuria sp.]	diamond	156	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria sp.
28782150	28782150	PRJNA495917_S_NODE_16887_length_150_cov_1.043478_g16693_i0	PRJNA495917	16887	150	1.043478	1.565217	Microbacterium sp. p3-SID336	2916212	Bacteria	Bacteria	105	1.0999999999999998e-24	NR	WP_259979199.1	2916212	g16693	i0	100	0.98	49	0	98	0	149	3	713	761	WP_259979199.1 hypothetical protein [Microbacterium sp. p3-SID336]	diamond	147	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. p3-SID336
28940389	28940389	PRJNA495917_S_NODE_9448_length_178_cov_1.342657_g9254_i0	PRJNA495917	9448	178	1.342657	2.38992946	Mycobacterium tuberculosis	1773	Bacteria	Bacteria	85.5	3.41e-20	NR	MBR7560535.1	1773	g9254	i0	97.6	0.691011235955056	41	1	69.1	0	56	178	1	41	MBR7560535.1 hypothetical protein [Mycobacterium tuberculosis]	diamond	123	85.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
29003813	29003813	PRJNA495917_S_NODE_11568_length_167_cov_1.212121_g11374_i0	PRJNA495917	11568	167	1.212121	2.02424207	Cutibacterium acnes	1747	Bacteria	Bacteria	81.6	1.02e-18	NR	MES6505856.1	1747	g11374	i0	92.1	0.682634730538922	38	3	68.3	0	114	1	1	38	MES6505856.1 hypothetical protein [Cutibacterium acnes]	diamond	114	81.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
30471806	30471806	PRJNA495917_S_NODE_6373_length_204_cov_1.893491_g6179_i0	PRJNA495917	6373	204	1.893491	3.86272164	Bacteria	2	Bacteria	Bacteria	131	2.5099999999999996e-37	NR	WP_271190726.1	85006	g6179	i0	100	2	68	0	100	0	1	204	4	71	WP_271190726.1 MULTISPECIES: hypothetical protein [Micrococcales]	diamond	408	131	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales
31514884	31514884	PRJNA495917_S_NODE_10256_length_173_cov_2.028986_g10062_i0	PRJNA495917	10256	173	2.028986	3.51014578	Actinomycetes	1760	Bacteria	Bacteria	112	6.59e-30	NR	MES6505837.1	1747	g10062	i0	100	1.97687861271676	57	0	98.8	0	171	1	58	114	MES6505837.1 IS5 family transposase [Cutibacterium acnes]	diamond	342	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
31562594	31562594	PRJNA495917_S_NODE_14156_length_157_cov_1.696721_g13962_i0	PRJNA495917	14156	157	1.696721	2.66385197	Mycobacterium tuberculosis	1773	Bacteria	Bacteria	109	6.87e-30	NR	MBR7552429.1	1773	g13962	i0	92.3	0.993630573248408	52	4	99.4	0	157	2	3	54	MBR7552429.1 hypothetical protein [Mycobacterium tuberculosis]	diamond	156	109	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium tuberculosis
32068409	32068409	PRJNA495917_S_NODE_7478_length_193_cov_2.240506_g7284_i0	PRJNA495917	7478	193	2.240506	4.32417658	uncultured Mycobacterium sp.	171292	Bacteria	Bacteria	79.7	8.91e-16	NR	WP_375488955.1	171292	g7284	i0	57.7	3.37305699481865	71	22	97.9	1	5	193	119	189	WP_375488955.1 porin [uncultured Mycobacterium sp.]	diamond	651	79.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	uncultured Mycobacterium sp.

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