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

27 rows where analysis = "diamond", bioproject = "PRJNA396510" and tax_kingdom = "Bacillati"

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
411888	411888	PRJNA396510_P_NODE_15361_length_163_cov_0.894737_g15292_i0	PRJNA396510	15361	163	0.894737	1.45842131	Streptococcus thermophilus	1308	Bacteria	Bacteria	112	5.08e-27	NR	TKW62483.1	1308	g15292	i0	100	1.98773006134969	54	0	99.4	0	1	162	550	603	TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus]	diamond	324	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
26726804	26726804	PRJNA396510_P_NODE_14301_length_165_cov_0.879310_g14232_i0	PRJNA396510	14301	165	0.87931	1.4508615	Levyella massiliensis	938289	Bacteria	Bacteria	112	2.9e-28	NR	WP_019190309.1	938289	g14232	i0	96.3	0.981818181818182	54	2	98.2	0	3	164	116	169	WP_019190309.1 MaoC/PaaZ C-terminal domain-containing protein [Levyella massiliensis]	diamond	162	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Levyella	Levyella massiliensis
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
28243762	28243762	PRJNA396510_P_NODE_11306_length_180_cov_1.053435_g11237_i0	PRJNA396510	11306	180	1.053435	1.896183	Anaerolineae bacterium	2052143	Bacteria	Bacteria	40.8	0.0245	NR	NIV31772.1	2052143	g11237	i0	43.8	0.8	48	25	80	1	10	153	37	82	NIV31772.1 hypothetical protein [Anaerolineae bacterium]	diamond	144	40.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
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
28797221	28797221	PRJNA396510_P_NODE_15507_length_163_cov_0.894737_g15438_i0	PRJNA396510	15507	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	106	7.45e-28	NR	MBN9993869.1	1639	g15438	i0	100	3.97546012269939	54	0	99.4	0	163	2	28	81	MBN9993869.1 hypothetical protein [Listeria monocytogenes]	diamond	648	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
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.
29949062	29949062	PRJNA396510_P_NODE_13351_length_167_cov_0.864407_g13282_i0	PRJNA396510	13351	167	0.864407	1.44355969	Chloroflexia bacterium	2448782	Bacteria	Bacteria	107	2.65e-25	NR	MBA3275463.1	2448782	g13282	i0	94.5	6.89820359281437	55	3	98.8	0	166	2	265	319	MBA3275463.1 succinate dehydrogenase flavoprotein subunit [Chloroflexia bacterium]	diamond	1152	107	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
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
30486162	30486162	PRJNA396510_P_NODE_9953_length_191_cov_0.838028_g9884_i0	PRJNA396510	9953	191	0.838028	1.60063348	Paenibacillus gyeongsangnamensis	3388067	Bacteria	Bacteria	41.6	0.0479	NR	WP_269884168.1	3388067	g9884	i0	31	0.910994764397906	58	38	91.1	2	184	11	65	120	WP_269884168.1 uracil/xanthine transporter [Paenibacillus gyeongsangnamensis]	diamond	174	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus gyeongsangnamensis
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
31577575	31577575	PRJNA396510_P_NODE_5156_length_254_cov_1.087805_g5087_i0	PRJNA396510	5156	254	1.087805	2.7630247	Paenibacillus	44249	Bacteria	Bacteria	42.7	0.0402	NR	WP_238655226.1	1089681	g5087	i0	36.2	1.37007874015748	58	37	68.5	0	33	206	143	200	WP_238655226.1 alpha/beta hydrolase [Paenibacillus piscarius]	diamond	348	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus piscarius
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
32130356	32130356	PRJNA396510_P_NODE_15258_length_163_cov_0.894737_g15189_i0	PRJNA396510	15258	163	0.894737	1.45842131	Mediannikoviicoccus vaginalis	2899727	Bacteria	Bacteria	92.4	3.82e-20	NR	WP_237036350.1	2899727	g15189	i0	92.5	0.975460122699387	53	4	97.5	0	3	161	801	853	WP_237036350.1 DNA mismatch repair protein MutS [Mediannikoviicoccus vaginalis]	diamond	159	92.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Mediannikoviicoccus	Mediannikoviicoccus vaginalis
32351877	32351877	PRJNA396510_P_NODE_13979_length_166_cov_0.863248_g13910_i0	PRJNA396510	13979	166	0.863248	1.43299168	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	47.4	3.1e-4	NR	MBE6951160.1	2485925	g13910	i0	45	0.72289156626506	40	22	72.3	0	40	159	49	88	MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	120	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
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);;