metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA396510" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA396510" 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
26980402	26980402	PRJNA396510_P_NODE_7722_length_214_cov_0.927273_g7653_i0	PRJNA396510	7722	214	0.927273	1.98436422	Microbacterium algeriense	2615184	Bacteria	Bacteria	136	3.7e-39	NR	WP_270366854.1	2615184	g7653	i0	98.6	0.995327102803738	71	1	99.5	0	1	213	87	157	WP_270366854.1 hypothetical protein [Microbacterium algeriense]	diamond	213	136	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium algeriense
27043759	27043759	PRJNA396510_P_NODE_13842_length_166_cov_0.871795_g13773_i0	PRJNA396510	13842	166	0.871795	1.4471797	Microbacterium suwonense	683047	Bacteria	Bacteria	94.7	3.62e-21	NR	WP_286299404.1	683047	g13773	i0	83.6	1.98795180722892	55	9	99.4	0	1	165	183	237	WP_286299404.1 ATP-binding protein [Microbacterium suwonense]	diamond	330	94.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium suwonense
27138141	27138141	PRJNA396510_P_NODE_13942_length_166_cov_0.871795_g13873_i0	PRJNA396510	13942	166	0.871795	1.4471797	Microbacterium algeriense	2615184	Bacteria	Bacteria	111	7.260000000000001e-27	NR	WP_319031288.1	2615184	g13873	i0	98.2	0.993975903614458	55	1	99.4	0	165	1	1510	1564	WP_319031288.1 DUF7507 domain-containing protein [Microbacterium algeriense]	diamond	165	111	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium algeriense
27233436	27233436	PRJNA396510_P_NODE_15243_length_163_cov_0.894737_g15174_i0	PRJNA396510	15243	163	0.894737	1.45842131	Microbacterium sp. TS-1	1344956	Bacteria	Bacteria	47	4.09e-4	NR	WP_023953597.1	1344956	g15174	i0	49	0.901840490797546	49	19	88.3	2	7	150	269	312	WP_023953597.1 glycoside hydrolase family 2 protein [Microbacterium sp. TS-1]	diamond	147	47	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. TS-1
27896516	27896516	PRJNA396510_P_NODE_5765_length_242_cov_1.191710_g5696_i0	PRJNA396510	5765	242	1.19171	2.8839382	Microbacterium sp. KKR3/1	2904241	Bacteria	Bacteria	148	2.8299999999999993e-42	NR	WP_232761915.1	2904241	g5696	i0	81.4	1.06611570247934	86	10	99.2	1	2	241	87	172	WP_232761915.1 bifunctional DNA primase/polymerase [Microbacterium sp. KKR3/1]	diamond	258	148	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. KKR3/1
28559830	28559830	PRJNA396510_P_NODE_16327_length_161_cov_0.910714_g16258_i0	PRJNA396510	16327	161	0.910714	1.46624954	Actinomycetota bacterium	2900548	Bacteria	Bacteria	54.3	3.08e-7	NR	MSW51030.1	2900548	g16258	i0	46.2	0.968944099378882	52	28	96.9	0	4	159	71	122	MSW51030.1 GNAT family N-acetyltransferase [Actinomycetota bacterium]	diamond	156	54.3	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
28828872	28828872	PRJNA396510_P_NODE_10188_length_189_cov_0.928571_g10119_i0	PRJNA396510	10188	189	0.928571	1.75499919	Microbacterium	33882	Bacteria	Bacteria	112	3.44e-30	NR	WP_147805346.1	322686	g10119	i0	98.4	2.95238095238095	62	1	98.4	0	187	2	26	87	WP_147805346.1 hypothetical protein [Microbacterium sp. R1]	diamond	558	112	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. R1
29822428	29822428	PRJNA396510_P_NODE_13611_length_166_cov_0.871795_g13542_i0	PRJNA396510	13611	166	0.871795	1.4471797	Microlunatus sp.	39595	Bacteria	Bacteria	41.6	0.0328	NR	HEU5484225.1	39595	g13542	i0	34.8	0.831325301204819	46	30	83.1	0	164	27	346	391	HEU5484225.1 cytochrome P450 [Microlunatus sp.]	diamond	138	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
29949063	29949063	PRJNA396510_P_NODE_16031_length_162_cov_0.902655_g15962_i0	PRJNA396510	16031	162	0.902655	1.4623011	Microbacterium maritypicum	33918	Bacteria	Bacteria	104	1.74e-24	NR	WP_141385741.1	33918	g15962	i0	87	2.98148148148148	54	7	100	0	1	162	396	449	WP_141385741.1 zinc-ribbon domain-containing protein [Microbacterium maritypicum]	diamond	483	104	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
30043705	30043705	PRJNA396510_P_NODE_12631_length_170_cov_1.264463_g12562_i0	PRJNA396510	12631	170	1.264463	2.1495871	Microbacterium maritypicum	33918	Bacteria	Bacteria	105	6.09e-26	NR	WP_141385734.1	33918	g12562	i0	94.6	0.988235294117647	56	3	98.8	0	1	168	83	138	WP_141385734.1 FAD-dependent thymidylate synthase [Microbacterium maritypicum]	diamond	168	105	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
30360211	30360211	PRJNA396510_P_NODE_14852_length_164_cov_0.886957_g14783_i0	PRJNA396510	14852	164	0.886957	1.45460948	Microbacterium oleivorans	273677	Bacteria	Bacteria	73.6	4.66e-14	NR	WP_251577210.1	273677	g14783	i0	71.7	1.82926829268293	46	13	84.1	0	2	139	176	221	WP_251577210.1 peptidase E [Microbacterium oleivorans]	diamond	300	73.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oleivorans
30376876	30376876	PRJNA396510_P_NODE_11812_length_176_cov_1.204724_g11743_i0	PRJNA396510	11812	176	1.204724	2.12031424	Microbacterium	33882	Bacteria	Bacteria	62	7.38e-10	NR	WP_204938144.1	67574	g11743	i0	73.2	4.17613636363636	41	9	69.9	1	47	169	147	185	WP_204938144.1 acyl-CoA desaturase [Microbacterium keratanolyticum]	diamond	735	62.4	0.993589743589744	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium keratanolyticum
30517721	30517721	PRJNA396510_P_NODE_13233_length_167_cov_0.864407_g13164_i0	PRJNA396510	13233	167	0.864407	1.44355969	Microbacterium maritypicum	33918	Bacteria	Bacteria	85.5	8.25e-18	NR	WP_141385742.1	33918	g13164	i0	88.9	0.808383233532934	45	5	80.8	0	166	32	362	406	WP_141385742.1 helix-turn-helix domain-containing protein [Microbacterium maritypicum]	diamond	135	85.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium maritypicum
31560938	31560938	PRJNA396510_P_NODE_13176_length_167_cov_0.864407_g13107_i0	PRJNA396510	13176	167	0.864407	1.44355969	Microbacterium oxydans	82380	Bacteria	Bacteria	71.6	2.86e-13	NR	WP_371861860.1	82380	g13107	i0	72	0.898203592814371	50	13	88	1	147	1	1	50	WP_371861860.1 ATP-binding protein [Microbacterium oxydans]	diamond	150	71.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium oxydans
32066788	32066788	PRJNA396510_P_NODE_10038_length_190_cov_1.085106_g9969_i0	PRJNA396510	10038	190	1.085106	2.0617014	Microbacterium terricola	344163	Bacteria	Bacteria	72.4	1.24e-13	NR	WP_263797845.1	344163	g9969	i0	74.5	0.742105263157895	47	12	74.2	0	189	49	95	141	WP_263797845.1 DUF5343 domain-containing protein [Microbacterium terricola]	diamond	141	72.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium terricola
32446809	32446809	PRJNA396510_P_NODE_12719_length_169_cov_1.700000_g12650_i0	PRJNA396510	12719	169	1.7	2.873	Agrococcus jenensis	46353	Bacteria	Bacteria	73.6	7.75e-14	NR	WP_123695993.1	46353	g12650	i0	60.7	1.98816568047337	56	22	99.4	0	168	1	89	144	WP_123695993.1 hypothetical protein [Agrococcus jenensis]	diamond	336	73.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agrococcus	Agrococcus jenensis
32573373	32573373	PRJNA396510_P_NODE_16479_length_161_cov_0.910714_g16410_i0	PRJNA396510	16479	161	0.910714	1.46624954	Microbacterium algeriense	2615184	Bacteria	Bacteria	99.8	1.49e-23	NR	WP_151458817.1	2615184	g16410	i0	98.1	0.987577639751553	53	1	98.8	0	3	161	73	125	WP_151458817.1 hypothetical protein [Microbacterium algeriense]	diamond	159	99.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium algeriense
32762034	32762034	PRJNA396510_P_NODE_10980_length_182_cov_1.533835_g10911_i0	PRJNA396510	10980	182	1.533835	2.7915797	Kitasatospora saccharophila	407973	Bacteria	Bacteria	42.4	0.0193	NR	WP_380276580.1	407973	g10911	i0	42.6	0.89010989010989	54	25	79.1	3	181	38	40	93	WP_380276580.1 haloacid dehalogenase-like hydrolase [Kitasatospora saccharophila]	diamond	162	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora saccharophila

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