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

17 rows where analysis = "diamond", bioproject = "PRJNA1087264" and tax_phylum = "Bacillota"

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
26877935	26877935	PRJNA1087264_P_NODE_19321_length_163_cov_0.894737_g19239_i0	PRJNA1087264	19321	163	0.894737	1.45842131	Lacicoccus qingdaonensis	576118	Bacteria	Bacteria	115	1.15e-30	NR	WP_176754027.1	576118	g19239	i0	100	0.993865030674847	54	0	99.4	0	2	163	99	152	WP_176754027.1 class I SAM-dependent methyltransferase [Lacicoccus qingdaonensis]	diamond	162	115	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Salinicoccaceae	Lacicoccus	Lacicoccus qingdaonensis
26900875	26900875	PRJNA1087264_P_NODE_10361_length_196_cov_1.000000_g10279_i0	PRJNA1087264	10361	196	1	1.96	FCB group	1783270	Bacteria	Bacteria	57.8	1e-7	NR	WP_315369194.1	237576	g10279	i0	39.1	6.96428571428571	64	39	98	0	2	193	272	335	WP_315369194.1 oleate hydratase [Oribacterium sinus]	diamond	1365	57.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Oribacterium	Oribacterium sinus
27469874	27469874	PRJNA1087264_P_NODE_21143_length_161_cov_0.910714_g21061_i0	PRJNA1087264	21143	161	0.910714	1.46624954	Lactobacillaceae	33958	Bacteria	Bacteria	41.6	0.00624	NR	WP_023860568.1	137357	g21061	i0	48.1	4.52795031055901	52	23	89.4	2	148	5	5	56	WP_023860568.1 acyl carrier protein [Ligilactobacillus equi]	diamond	729	41.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus equi
27699675	27699675	PRJNA1087264_P_NODE_3044_length_379_cov_1.551515_g2963_i0	PRJNA1087264	3044	379	1.551515	5.88024185	Bacillus solimangrovi	1305675	Bacteria	Bacteria	178	2.1399999999999993e-52	NR	WP_069718583.1	1305675	g2963	i0	65.3	8.73878627968338	124	41	96.6	1	374	9	17	140	WP_069718583.1 alcohol dehydrogenase AdhP [Bacillus solimangrovi]	diamond	3312	178	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus solimangrovi
28204332	28204332	PRJNA1087264_P_NODE_8846_length_212_cov_0.895706_g8764_i0	PRJNA1087264	8846	212	0.895706	1.89889672	Bacillota bacterium	1879010	Bacteria	Bacteria	96.7	2.01e-21	NR	NLZ93608.1	1879010	g8764	i0	55.1	2.90094339622642	69	31	97.6	0	207	1	307	375	NLZ93608.1 proline--tRNA ligase [Bacillota bacterium]	diamond	615	96.7	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29120406	29120406	PRJNA1087264_P_NODE_19389_length_163_cov_0.894737_g19307_i0	PRJNA1087264	19389	163	0.894737	1.45842131	Sporomusa rhizae	357999	Bacteria	Bacteria	48.5	2.91e-5	NR	WP_371363029.1	357999	g19307	i0	48.8	0.791411042944785	43	21	79.1	1	143	15	6	47	WP_371363029.1 IS66 family insertion sequence element accessory protein TnpA [Sporomusa rhizae]	diamond	129	48.5	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa rhizae
29530688	29530688	PRJNA1087264_P_NODE_11290_length_188_cov_1.100719_g11208_i0	PRJNA1087264	11290	188	1.100719	2.06935172	Eubacteriales bacterium	2831996	Bacteria	Bacteria	42.4	0.0069	NR	MDY5941155.1	2831996	g11208	i0	43.6	0.622340425531915	39	21	62.2	1	148	32	63	100	MDY5941155.1 hypothetical protein [Eubacteriales bacterium]	diamond	117	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
29624876	29624876	PRJNA1087264_P_NODE_13930_length_168_cov_1.285714_g13848_i0	PRJNA1087264	13930	168	1.285714	2.15999952	Clostridia bacterium	2044939	Bacteria	Bacteria	58.5	2.86e-8	NR	MBR3838117.1	2044939	g13848	i0	59.1	0.785714285714286	44	18	78.6	0	133	2	124	167	MBR3838117.1 acetylglutamate kinase [Clostridia bacterium]	diamond	132	58.5	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29742850	29742850	PRJNA1087264_P_NODE_7390_length_232_cov_0.907104_g7308_i0	PRJNA1087264	7390	232	0.907104	2.10448128	root	1	Root_unresolved	Root_unresolved	65.9	1.96e-10	NR	ACV20892.1	1396	g7308	i0	63.8	6.51724137931035	69	25	89.2	0	6	212	169	237	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	1512	65.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
30320821	30320821	PRJNA1087264_P_NODE_9632_length_203_cov_1.207792_g9550_i0	PRJNA1087264	9632	203	1.207792	2.45181776	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42	0.0413	NR	MBE6951160.1	2485925	g9550	i0	42.5	0.591133004926108	40	23	59.1	0	79	198	49	88	MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium]	diamond	120	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
30478372	30478372	PRJNA1087264_P_NODE_16073_length_166_cov_0.871795_g15991_i0	PRJNA1087264	16073	166	0.871795	1.4471797	Staphylococcus pseudintermedius	283734	Bacteria	Bacteria	60.8	4.56e-9	NR	WP_200265155.1	283734	g15991	i0	57.7	4.73493975903614	52	22	94	0	162	7	46	97	WP_200265155.1 bile acid:sodium symporter family protein [Staphylococcus pseudintermedius]	diamond	786	60.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pseudintermedius
30762712	30762712	PRJNA1087264_P_NODE_2754_length_402_cov_1.861190_g2673_i0	PRJNA1087264	2754	402	1.86119	7.4819838	Dethiobacter sp.	2093370	Bacteria	Bacteria	122	2.06e-29	NR	MBS3886829.1	2093370	g2673	i0	63.2	7.76119402985075	95	32	70.9	2	402	118	447	538	MBS3886829.1 hydroxylamine reductase [Dethiobacter sp.]	diamond	3120	122	1	Bacteria	Bacillati	Bacillota	Dethiobacteria	Dethiobacterales	Dethiobacteraceae	Dethiobacter	Dethiobacter sp.
31006806	31006806	PRJNA1087264_P_NODE_12854_length_176_cov_1.204724_g12772_i0	PRJNA1087264	12854	176	1.204724	2.12031424	root	1	Root_unresolved	Root_unresolved	50.8	2.07e-5	NR	MCI9541060.1	1898203	g12772	i0	44.6	4.89204545454545	56	27	95.5	2	8	175	312	363	MCI9541060.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	861	50.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32018788	32018788	PRJNA1087264_P_NODE_15678_length_166_cov_0.871795_g15596_i0	PRJNA1087264	15678	166	0.871795	1.4471797	FCB group	1783270	Bacteria	Bacteria	42.4	0.0187	NR	WP_311900221.1	319970	g15596	i0	45.2	6.77710843373494	42	23	75.9	0	132	7	1155	1196	WP_311900221.1 Cna B-type domain-containing protein [Enterococcus devriesei]	diamond	1125	42.7	0.992974238875878	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus devriesei
32082000	32082000	PRJNA1087264_P_NODE_15718_length_166_cov_0.871795_g15636_i0	PRJNA1087264	15718	166	0.871795	1.4471797	Bacillota	1239	Bacteria	Bacteria	54.7	7.1e-7	NR	WP_253217188.1	1307	g15636	i0	47.3	9.81325301204819	55	23	99.4	1	166	2	28	76	WP_253217188.1 aldo/keto reductase [Streptococcus suis]	diamond	1629	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
32185691	32185691	PRJNA1087264_P_NODE_6398_length_251_cov_2.965347_g6316_i0	PRJNA1087264	6398	251	2.965347	7.44302097	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	43.1	0.0299	NR	MEA5061696.1	2049044	g6316	i0	33.8	0.812749003984064	68	38	75.3	2	223	35	183	248	MEA5061696.1 ComEC/Rec2 family competence protein [Erysipelotrichaceae bacterium]	diamond	204	43.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
32407150	32407150	PRJNA1087264_P_NODE_8759_length_213_cov_1.006098_g8677_i0	PRJNA1087264	8759	213	1.006098	2.14298874	Paenibacillus silvisoli	3110539	Bacteria	Bacteria	85.9	1.24e-19	NR	WP_308634904.1	3110539	g8677	i0	64.1	2.70422535211268	64	23	90.1	0	17	208	21	84	WP_308634904.1 group 1 truncated hemoglobin [Paenibacillus silvisoli]	diamond	576	85.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus silvisoli

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