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

27 rows where analysis = "diamond", bioproject = "PRJNA280983" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
14400649	14400649	PRJNA280983_P_NODE_2592_length_437_cov_4.440722_g2477_i0	PRJNA280983	2592	437	4.440722	19.40595514	Culicoidibacter larvae	2579976	Bacteria	Bacteria	185	6.399999999999999e-55	NR	WP_138191546.1	2579976	g2477	i0	69.9	0.844393592677345	123	34	82.4	1	68	427	3	125	WP_138191546.1 TIGR01212 family radical SAM protein [Culicoidibacter larvae]	diamond	369	185	1	Bacteria		Bacillati	Bacillota	Culicoidibacteria	Culicoidibacterales	Culicoidibacteraceae	Culicoidibacter	Culicoidibacter larvae
23323698	23323698	PRJNA280983_P_NODE_439_length_1093_cov_2.160920_g374_i0	PRJNA280983	439	1093	2.16092	23.6188556	Bacilli bacterium	1903720	Bacteria	Bacteria	278	1.25e-84	NR	MEG1506368.1	1903720	g374	i0	95.9	0.406221408966148	148	6	40.6	0	445	2	51	198	MEG1506368.1 replication initiation protein [Bacilli bacterium]	diamond	444	278	1	Bacteria		Bacillati	Bacillota	Bacilli				Bacilli bacterium
26630958	26630958	PRJNA280983_P_NODE_10301_length_165_cov_0.879310_g10186_i0	PRJNA280983	10301	165	0.87931	1.4508615	Lawsonella	1847725	Bacteria	Bacteria	111	3.95e-28	NR	WP_290599322.1	1847725	g10186	i0	100	1	55	0	100	0	1	165	89	143	WP_290599322.1 MULTISPECIES: hypothetical protein [Lawsonella]	diamond	165	111	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
26630961	26630961	PRJNA280983_P_NODE_9721_length_168_cov_0.915966_g9606_i0	PRJNA280983	9721	168	0.915966	1.53882288	Firmicutes bacterium CAG:345	1263020	Bacteria	Bacteria	41.2	0.0457	NR	CDD23844.1	1263020	g9606	i0	48.5	0.589285714285714	33	17	58.9	0	166	68	133	165	CDD23844.1 probable inorganic polyphosphate/ATP-NAD kinase [Firmicutes bacterium CAG:345]	diamond	99	41.2	1	Bacteria		Bacillati	Bacillota					Firmicutes bacterium CAG:345
26789392	26789392	PRJNA280983_P_NODE_7861_length_201_cov_0.940789_g7746_i0	PRJNA280983	7861	201	0.940789	1.89098589	Cyanothece sp. SIO2G6	2607797	Bacteria	Bacteria	45.8	0.00176	NR	NEQ98296.1	2607797	g7746	i0	37.5	0.835820895522388	56	31	83.6	1	11	178	1497	1548	NEQ98296.1 TIR domain-containing protein [Cyanothece sp. SIO2G6]	diamond	168	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. SIO2G6
26821120	26821120	PRJNA280983_P_NODE_10201_length_165_cov_1.715517_g10086_i0	PRJNA280983	10201	165	1.715517	2.83060305	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	61.2	4.15e-11	NR	MBL8086392.1	2711154	g10086	i0	96.7	0.545454545454545	30	1	54.5	0	55	144	1	30	MBL8086392.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	90	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28116285	28116285	PRJNA280983_P_NODE_10265_length_165_cov_0.879310_g10150_i0	PRJNA280983	10265	165	0.87931	1.4508615	Listeria monocytogenes	1639	Bacteria	Bacteria	44.7	2.93e-4	NR	WP_369697475.1	1639	g10150	i0	92.6	0.490909090909091	27	2	49.1	0	165	85	38	64	WP_369697475.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	81	44.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28260171	28260171	PRJNA280983_P_NODE_3326_length_374_cov_1.796923_g3211_i0	PRJNA280983	3326	374	1.796923	6.72049202	Thermoactinomycetaceae	186824	Bacteria	Bacteria	104	1.94e-24	NR	WP_107728182.1	500615	g3211	i0	47.4	1.83689839572193	114	60	91.4	0	29	370	128	241	WP_107728182.1 ParB/RepB/Spo0J family partition protein [Desmospora activa]	diamond	687	104	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Desmospora	Desmospora activa
28337424	28337424	PRJNA280983_P_NODE_11566_length_151_cov_5.313725_g11451_i0	PRJNA280983	11566	151	5.313725	8.02372475	Galactobacter valiniphilus	2676122	Bacteria	Bacteria	40.8	0.0464	NR	WP_119424843.1	2676122	g11451	i0	39.6	0.95364238410596	48	27	95.4	1	7	150	42	87	WP_119424843.1 DedA family protein [Galactobacter valiniphilus]	diamond	144	40.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Galactobacter	Galactobacter valiniphilus
28463846	28463846	PRJNA280983_P_NODE_10646_length_164_cov_0.886957_g10531_i0	PRJNA280983	10646	164	0.886957	1.45460948	Priestia aryabhattai	412384	Bacteria	Bacteria	50.4	2.4e-5	NR	WP_413028423.1	412384	g10531	i0	48	0.914634146341463	50	25	91.5	1	13	162	178	226	WP_413028423.1 glutathionylspermidine synthase family protein [Priestia aryabhattai]	diamond	150	50.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia aryabhattai
28716378	28716378	PRJNA280983_P_NODE_2887_length_409_cov_1.036111_g2772_i0	PRJNA280983	2887	409	1.036111	4.23769399	Culicoidibacter larvae	2579976	Bacteria	Bacteria	56.2	3.24e-6	NR	WP_138189773.1	2579976	g2772	i0	59.5	0.271393643031785	37	15	27.1	0	12	122	258	294	WP_138189773.1 ParB/RepB/Spo0J family partition protein [Culicoidibacter larvae]	diamond	111	56.2	1	Bacteria		Bacillati	Bacillota	Culicoidibacteria	Culicoidibacterales	Culicoidibacteraceae	Culicoidibacter	Culicoidibacter larvae
29095313	29095313	PRJNA280983_P_NODE_7208_length_216_cov_1.526946_g7093_i0	PRJNA280983	7208	216	1.526946	3.29820336	Thermicanus aegyptius	94009	Bacteria	Bacteria	48.1	3.16e-4	NR	WP_028986873.1	94009	g7093	i0	40.9	0.916666666666667	66	37	88.9	1	17	208	248	313	WP_028986873.1 cell division protein FtsA [Thermicanus aegyptius]	diamond	198	48.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Thermicanus	Thermicanus aegyptius
29316183	29316183	PRJNA280983_P_NODE_10069_length_166_cov_0.871795_g9954_i0	PRJNA280983	10069	166	0.871795	1.4471797	Clostridia bacterium	2044939	Bacteria	Bacteria	43.9	4.27e-4	NR	MBQ6324469.1	2044939	g9954	i0	57.7	0.469879518072289	26	11	47	0	123	46	21	46	MBQ6324469.1 hypothetical protein [Clostridia bacterium]	diamond	78	43.9	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
29663136	29663136	PRJNA280983_P_NODE_10870_length_163_cov_0.894737_g10755_i0	PRJNA280983	10870	163	0.894737	1.45842131	Streptosporangiaceae bacterium	2339230	Bacteria	Bacteria	43.9	0.00473	NR	HEY2692445.1	2339230	g10755	i0	43.4	0.975460122699387	53	29	95.7	1	162	7	128	180	HEY2692445.1 MBL fold metallo-hydrolase [Streptosporangiaceae bacterium]	diamond	159	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium
29694757	29694757	PRJNA280983_P_NODE_1410_length_627_cov_3.856401_g1303_i0	PRJNA280983	1410	627	3.856401	24.17963427	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	50.8	0.00142	NR	MBO4267086.1	1898203	g1303	i0	28.9	0.679425837320574	142	81	60.3	5	501	124	185	322	MBO4267086.1 tetratricopeptide repeat protein [Lachnospiraceae bacterium]	diamond	426	50.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
29789659	29789659	PRJNA280983_P_NODE_11111_length_162_cov_0.902655_g10996_i0	PRJNA280983	11111	162	0.902655	1.4623011	Bacillota bacterium	1879010	Bacteria	Bacteria	48.5	5.67e-5	NR	MCL6557201.1	1879010	g10996	i0	88.9	0.5	27	3	50	0	81	161	1	27	MCL6557201.1 HK97 gp10 family phage protein [Bacillota bacterium]	diamond	81	48.5	1	Bacteria		Bacillati	Bacillota					Bacillota bacterium
29821142	29821142	PRJNA280983_P_NODE_4171_length_325_cov_1.847826_g4056_i0	PRJNA280983	4171	325	1.847826	6.0054345	Clostridioides difficile	1496	Bacteria	Bacteria	56.2	3.73e-7	NR	WP_320076599.1	1496	g4056	i0	75.8	0.304615384615385	33	8	30.5	0	104	202	114	146	WP_320076599.1 hypothetical protein, partial [Clostridioides difficile]	diamond	99	56.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29902333	29902333	PRJNA280983_P_NODE_3771_length_346_cov_2.387205_g3656_i0	PRJNA280983	3771	346	2.387205	8.2597293	Bacillales	1385	Bacteria	Bacteria	104	7.35e-26	NR	WP_128122244.1	2292355	g3656	i0	68	12.9884393063584	75	24	65	0	346	122	59	133	WP_128122244.1 rRNA maturation RNase YbeY [Exiguobacterium sp. AM39-5BH]	diamond	4494	105	0.990476190476191	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium sp. AM39-5BH
29916326	29916326	PRJNA280983_P_NODE_8871_length_182_cov_1.360902_g8756_i0	PRJNA280983	8871	182	1.360902	2.47684164	Chloroflexota bacterium	2026724	Bacteria	Bacteria	58.5	4.35e-8	NR	MEA2671793.1	2026724	g8756	i0	63.8	1.91208791208791	47	17	77.5	0	178	38	445	491	MEA2671793.1 F-type H+/Na+-transporting ATPase subunit beta [Chloroflexota bacterium]	diamond	348	58.5	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
30611098	30611098	PRJNA280983_P_NODE_4513_length_308_cov_6.007722_g4398_i0	PRJNA280983	4513	308	6.007722	18.50378376	Clostridioides difficile	1496	Bacteria	Bacteria	111	1.05e-28	NR	WP_320076599.1	1496	g4398	i0	91.4	0.564935064935065	58	5	56.5	0	133	306	1	58	WP_320076599.1 hypothetical protein, partial [Clostridioides difficile]	diamond	174	111	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
31165721	31165721	PRJNA280983_P_NODE_2195_length_484_cov_3.521839_g2082_i0	PRJNA280983	2195	484	3.521839	17.04570076	Romboutsia	1501226	Bacteria	Bacteria	205	3.5400000000000004e-64	NR	WP_071119150.1	1776391	g2082	i0	63.2	2.82644628099174	152	56	94.2	0	465	10	55	206	WP_071119150.1 PH domain-containing protein [Romboutsia timonensis]	diamond	1368	207	0.990338164251208	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia timonensis
31306365	31306365	PRJNA280983_P_NODE_9935_length_167_cov_0.864407_g9820_i0	PRJNA280983	9935	167	0.864407	1.44355969	Candidatus Limnocylindrales bacterium	2952938	Bacteria	Bacteria	64.3	3.24e-10	NR	HUQ85556.1	2952938	g9820	i0	63.3	0.880239520958084	49	18	88	0	19	165	1	49	HUQ85556.1 DUF4012 domain-containing protein [Candidatus Limnocylindrales bacterium]	diamond	147	64.3	1	Bacteria		Bacillati	Chloroflexota	Candidatus Limnocylindria	Candidatus Limnocylindrales			Candidatus Limnocylindrales bacterium
31432910	31432910	PRJNA280983_P_NODE_2256_length_474_cov_2.247059_g2143_i0	PRJNA280983	2256	474	2.247059	10.65105966	Culicoidibacter larvae	2579976	Bacteria	Bacteria	186	3.1099999999999988e-55	NR	WP_138190957.1	2579976	g2143	i0	60.8	1	158	61	100	1	1	474	61	217	WP_138190957.1 2-oxoacid:acceptor oxidoreductase family protein [Culicoidibacter larvae]	diamond	474	186	1	Bacteria		Bacillati	Bacillota	Culicoidibacteria	Culicoidibacterales	Culicoidibacteraceae	Culicoidibacter	Culicoidibacter larvae
32319080	32319080	PRJNA280983_P_NODE_4799_length_295_cov_0.959350_g4684_i0	PRJNA280983	4799	295	0.95935	2.8300825	Armatimonadota bacterium	2033014	Bacteria	Bacteria	43.9	0.0268	NR	NCP28680.1	2033014	g4684	i0	45.8	0.976271186440678	48	19	48.8	2	147	290	102	142	NCP28680.1 right-handed parallel beta-helix repeat-containing protein [Armatimonadota bacterium]	diamond	288	43.9	1	Bacteria		Bacillati	Armatimonadota					Armatimonadota bacterium
32572073	32572073	PRJNA280983_P_NODE_10599_length_164_cov_0.886957_g10484_i0	PRJNA280983	10599	164	0.886957	1.45460948	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	58.5	3.4e-8	NR	HUP69390.1	2201156	g10484	i0	51.7	2.15853658536585	60	20	97	2	159	1	1653	1710	HUP69390.1 kelch repeat-containing protein [Acidimicrobiales bacterium]	diamond	354	58.5	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
32666239	32666239	PRJNA280983_P_NODE_10800_length_163_cov_0.894737_g10685_i0	PRJNA280983	10800	163	0.894737	1.45842131	Saccharopolyspora indica	1229659	Bacteria	Bacteria	90.5	1.13e-21	NR	WP_334270782.1	1229659	g10685	i0	88.7	0.975460122699387	53	6	97.5	0	160	2	57	109	WP_334270782.1 hypothetical protein, partial [Saccharopolyspora indica]	diamond	159	90.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharopolyspora	Saccharopolyspora indica
32872747	32872747	PRJNA280983_P_NODE_9920_length_167_cov_0.864407_g9805_i0	PRJNA280983	9920	167	0.864407	1.44355969	Dietzia	37914	Bacteria	Bacteria	47.8	2.26e-4	NR	WP_230928816.1	983873	g9805	i0	67.6	6.64670658682635	34	11	61.1	0	166	65	428	461	WP_230928816.1 DUF349 domain-containing protein [Dietzia aurantiaca]	diamond	1110	48.1	0.993762993762994	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia aurantiaca

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