metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax

24 rows where analysis = "diamond", bioproject = "PRJEB12982" 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
8948019	8948019	PRJEB12982_P_NODE_5028_length_334_cov_1.726316_g4865_i0	PRJEB12982	5028	334	1.726316	5.76589544	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	187	2.94e-58	NR	MBX9724270.1	2364082	g4865	i0	96.7	0.817365269461078	91	3	81.7	0	333	61	80	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	273	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
11189020	11189020	PRJEB12982_P_NODE_18969_length_164_cov_0.886957_g18806_i0	PRJEB12982	18969	164	0.886957	1.45460948	Nocardiopsis composta	157465	Bacteria	Bacteria	96.3	4.31e-22	NR	WP_184390384.1	157465	g18806	i0	97.8	0.823170731707317	45	1	82.3	0	28	162	1	45	WP_184390384.1 YbgA family protein [Nocardiopsis composta]	diamond	135	96.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis composta
15323160	15323160	PRJEB12982_P_NODE_2093_length_538_cov_2.049080_g1934_i0	PRJEB12982	2093	538	2.04908	11.0240504	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	218	8.8e-70	NR	MCP3885490.1	2021380	g1934	i0	71.8	0.830855018587361	149	42	83.1	0	504	58	3	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	447	218	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
16288398	16288398	PRJEB12982_P_NODE_5793_length_308_cov_2.073359_g5630_i0	PRJEB12982	5793	308	2.073359	6.38594572	Thermosynechococcus	146785	Bacteria	Bacteria	203	1.6899999999999998e-60	NR	WP_231833792.1	146786	g5630	i0	99	3.97402597402597	102	1	99.4	0	307	2	39	140	WP_231833792.1 group II intron reverse transcriptase/maturase [Thermosynechococcus vestitus]	diamond	1224	204	0.995098039215686	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus
17872551	17872551	PRJEB12982_P_NODE_16955_length_167_cov_0.864407_g16792_i0	PRJEB12982	16955	167	0.864407	1.44355969	Miltoncostaeales bacterium	3022881	Bacteria	Bacteria	115	4.28e-29	NR	HRC07934.1	3022881	g16792	i0	94.5	0.988023952095808	55	3	98.8	0	167	3	102	156	HRC07934.1 hypothetical protein [Miltoncostaeales bacterium]	diamond	165	115	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Miltoncostaeales			Miltoncostaeales bacterium
26811557	26811557	PRJEB12982_P_NODE_7081_length_273_cov_1.366071_g6918_i0	PRJEB12982	7081	273	1.366071	3.72937383	Actinomycetota bacterium	2900548	Bacteria	Bacteria	47.4	7.87e-5	NR	MBS1889943.1	2900548	g6918	i0	66.7	0.395604395604396	36	12	39.6	0	162	269	2	37	MBS1889943.1 hypothetical protein [Actinomycetota bacterium]	diamond	108	47.4	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
26969660	26969660	PRJEB12982_P_NODE_9862_length_225_cov_1.386364_g9699_i0	PRJEB12982	9862	225	1.386364	3.119319	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	88.6	3.07e-20	NR	MCP3885490.1	2021380	g9699	i0	65.7	0.893333333333333	67	23	89.3	0	2	202	85	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	201	88.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
27570109	27570109	PRJEB12982_P_NODE_19584_length_163_cov_0.894737_g19421_i0	PRJEB12982	19584	163	0.894737	1.45842131	Sporosarcina sp. FSL K6-3457	2978204	Bacteria	Bacteria	53.5	1.84e-6	NR	WP_340738690.1	2978204	g19421	i0	50	1.71165644171779	50	24	92	1	14	163	124	172	WP_340738690.1 serine/threonine-protein kinase [Sporosarcina sp. FSL K6-3457]	diamond	279	53.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina sp. FSL K6-3457
28075253	28075253	PRJEB12982_P_NODE_11425_length_208_cov_1.509434_g11262_i0	PRJEB12982	11425	208	1.509434	3.13962272	Thermosynechococcus vestitus BP-1	197221	Bacteria	Bacteria	76.3	1.63e-15	NR	BAC08550.1	197221	g11262	i0	92.7	1.77403846153846	41	3	59.1	0	83	205	1	41	BAC08550.1 reverse transcriptase [Thermosynechococcus vestitus BP-1]	diamond	369	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus
28359375	28359375	PRJEB12982_P_NODE_19566_length_163_cov_0.894737_g19403_i0	PRJEB12982	19566	163	0.894737	1.45842131	Lawsonella	1847725	Bacteria	Bacteria	111	3.3799999999999993e-28	NR	WP_290595444.1	1847725	g19403	i0	100	0.993865030674847	54	0	99.4	0	163	2	202	255	WP_290595444.1 MULTISPECIES: GIY-YIG nuclease family protein [Lawsonella]	diamond	162	111	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28485843	28485843	PRJEB12982_P_NODE_3287_length_425_cov_1.627660_g3126_i0	PRJEB12982	3287	425	1.62766	6.917555	Anaeromicropila populeti	37658	Bacteria	Bacteria	61.6	4.64e-9	NR	WP_092562468.1	37658	g3126	i0	57.1	1.76470588235294	56	23	38.8	1	202	38	3	58	WP_092562468.1 DnaJ domain-containing protein [Anaeromicropila populeti]	diamond	750	61.6	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaeromicropila	Anaeromicropila populeti
28769910	28769910	PRJEB12982_P_NODE_14727_length_181_cov_1.159091_g14564_i0	PRJEB12982	14727	181	1.159091	2.09795471	Bogoriella caseilytica	56055	Bacteria	Bacteria	42	0.0302	NR	WP_123304230.1	56055	g14564	i0	36	0.828729281767956	50	32	82.9	0	16	165	182	231	WP_123304230.1 hypothetical protein [Bogoriella caseilytica]	diamond	150	42	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Bogoriellaceae	Bogoriella	Bogoriella caseilytica
28927838	28927838	PRJEB12982_P_NODE_11268_length_210_cov_1.099379_g11105_i0	PRJEB12982	11268	210	1.099379	2.3086959	Clostridia bacterium	2044939	Bacteria	Bacteria	44.3	0.00675	NR	MBR1686885.1	2044939	g11105	i0	44.9	0.7	49	26	68.6	1	60	203	88	136	MBR1686885.1 MATE family efflux transporter [Clostridia bacterium]	diamond	147	44.3	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
29022946	29022946	PRJEB12982_P_NODE_18728_length_164_cov_1.695652_g18565_i0	PRJEB12982	18728	164	1.695652	2.78086928	uncultured Anaerococcus sp.	293428	Bacteria	Bacteria	93.2	4.91e-23	NR	WP_297790668.1	293428	g18565	i0	98	0.914634146341463	50	1	91.5	0	152	3	1	50	WP_297790668.1 hypothetical protein [uncultured Anaerococcus sp.]	diamond	150	93.2	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	uncultured Anaerococcus sp.
29559210	29559210	PRJEB12982_P_NODE_10610_length_217_cov_0.910714_g10447_i0	PRJEB12982	10610	217	0.910714	1.97624938	Bacillota bacterium	1879010	Bacteria	Bacteria	63.5	8.2e-10	NR	MBR4149758.1	1879010	g10447	i0	56.1	0.788018433179724	57	25	78.8	0	1	171	207	263	MBR4149758.1 SMP-30/gluconolactonase/LRE family protein [Bacillota bacterium]	diamond	171	63.5	1	Bacteria		Bacillati	Bacillota					Bacillota bacterium
29653687	29653687	PRJEB12982_P_NODE_7070_length_273_cov_1.982143_g6907_i0	PRJEB12982	7070	273	1.982143	5.41125039	Thermosynechococcus vestitus	146786	Bacteria	Bacteria	190	1.0299999999999995e-55	NR	WP_231833792.1	146786	g6907	i0	98.9	0.989010989010989	90	1	98.9	0	271	2	150	239	WP_231833792.1 group II intron reverse transcriptase/maturase [Thermosynechococcus vestitus]	diamond	270	190	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus
29837058	29837058	PRJEB12982_P_NODE_10211_length_221_cov_1.186047_g10048_i0	PRJEB12982	10211	221	1.186047	2.62116387	Lactobacillus	1578	Bacteria	Bacteria	90.9	3.07e-19	NR	WP_003652924.1	1596	g10048	i0	59.7	10.6289592760181	67	27	91	0	221	21	71	137	WP_003652924.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Lactobacillus gasseri]	diamond	2349	91.3	0.995618838992333	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus gasseri
30127559	30127559	PRJEB12982_P_NODE_20912_length_161_cov_0.910714_g20749_i0	PRJEB12982	20912	161	0.910714	1.46624954	Phototrophicales bacterium	2364211	Bacteria	Bacteria	68.2	3.1e-13	NR	PJF33856.1	2364211	g20749	i0	49.1	0.987577639751553	53	27	98.8	0	160	2	9	61	PJF33856.1 MAG: hypothetical protein CUN57_01060 [Phototrophicales bacterium]	diamond	159	68.2	1	Bacteria		Bacillati	Chloroflexota	Candidatus Thermofontia	Phototrophicales			Phototrophicales bacterium
30437712	30437712	PRJEB12982_P_NODE_20393_length_162_cov_0.902655_g20230_i0	PRJEB12982	20393	162	0.902655	1.4623011	Blastococcus	38501	Bacteria	Bacteria	51.2	1.24e-5	NR	WP_208092257.1	1564164	g20230	i0	66.7	2.46296296296296	36	12	66.7	0	53	160	40	75	WP_208092257.1 carboxylesterase/lipase family protein [Blastococcus xanthinilyticus]	diamond	399	51.6	0.992248062015504	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus xanthinilyticus
31107166	31107166	PRJEB12982_P_NODE_21375_length_161_cov_0.910714_g21212_i0	PRJEB12982	21375	161	0.910714	1.46624954	Coriobacteriales bacterium	2478480	Bacteria	Bacteria	52.4	4.82e-6	NR	MDR3315660.1	2478480	g21212	i0	48.8	2.16149068322981	41	21	76.4	0	6	128	450	490	MDR3315660.1 RICIN domain-containing protein [Coriobacteriales bacterium]	diamond	348	52.4	1	Bacteria		Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales			Coriobacteriales bacterium
31290506	31290506	PRJEB12982_P_NODE_20055_length_162_cov_1.805310_g19892_i0	PRJEB12982	20055	162	1.80531	2.9246022	Bacteria	2	Bacteria	Bacteria	50.1	9.85e-6	NR	MDH3605859.1	2080302	g19892	i0	41.5	2.81481481481481	53	31	98.1	0	160	2	1	53	MDH3605859.1 SRPBCC family protein [Acidimicrobiia bacterium]	diamond	456	50.1	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
31455180	31455180	PRJEB12982_P_NODE_8576_length_245_cov_0.923469_g8413_i0	PRJEB12982	8576	245	0.923469	2.26249905	Nocardia transvalensis	37333	Bacteria	Bacteria	40.8	0.0374	NR	WP_195111351.1	37333	g8413	i0	46.5	0.52653061224489806	43	19	52.7	1	5	133	42	80	WP_195111351.1 hypothetical protein [Nocardia transvalensis]	diamond	129	40.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia transvalensis
31613252	31613252	PRJEB12982_P_NODE_12116_length_202_cov_0.888889_g11953_i0	PRJEB12982	12116	202	0.888889	1.79555578	Glycomyces amatae	2881355	Bacteria	Bacteria	42	0.0421	NR	WP_230601727.1	2881355	g11953	i0	35.4	0.965346534653465	65	40	96.5	1	4	198	285	347	WP_230601727.1 SCO7613 C-terminal domain-containing membrane protein [Glycomyces amatae]	diamond	195	42	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Glycomycetales	Glycomycetaceae	Glycomyces	Glycomyces amatae
32397993	32397993	PRJEB12982_P_NODE_15139_length_178_cov_1.186047_g14976_i0	PRJEB12982	15139	178	1.186047	2.11116366	Actinomycetes	1760	Bacteria	Bacteria	54.7	9.3e-7	NR	WP_274044837.1	1384038	g14976	i0	61	2.29213483146067	41	15	69.1	1	132	10	244	283	WP_274044837.1 C40 family peptidase [Streptomyces iconiensis]	diamond	408	55.1	0.992740471869329	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces iconiensis

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