metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJDB3785" and tax

20 rows where analysis = "diamond", bioproject = "PRJDB3785" 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
27627001	27627001	PRJDB3785_S_NODE_7324_length_277_cov_4.763158_g7171_i0	PRJDB3785	7324	277	4.763158	13.19394766	root	1	Root_unresolved	Root_unresolved	127	1.7e-34	NR	MCJ0157548.1	1496	g7171	i0	81	48.0324909747292	79	15	85.6	0	237	1	5	83	MCJ0157548.1 40S ribosomal protein S3a/S1 [Clostridioides difficile]	diamond	13305	128	0.9921875	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
28858124	28858124	PRJDB3785_S_NODE_10428_length_234_cov_3.551351_g10275_i0	PRJDB3785	10428	234	3.551351	8.31016134	Bacteria	2	Bacteria	Bacteria	120	9.61e-31	NR	WP_328207969.1	1422	g10275	i0	80.5	23.6794871794872	77	15	98.7	0	1	231	101	177	WP_328207969.1 Hsp70 family protein, partial [Geobacillus stearothermophilus]	diamond	5541	121	0.991735537190083	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
28959051	28959051	PRJDB3785_S_NODE_18408_length_184_cov_1.133333_g18255_i0	PRJDB3785	18408	184	1.133333	2.08533272	Ruminococcus sp.	41978	Bacteria	Bacteria	44.3	0.00459	NR	MBQ9515284.1	41978	g18255	i0	42.6	4.09239130434783	54	30	88	1	17	178	69	121	MBQ9515284.1 amidohydrolase family protein [Ruminococcus sp.]	diamond	753	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
28990695	28990695	PRJDB3785_S_NODE_12268_length_219_cov_0.900000_g12115_i0	PRJDB3785	12268	219	0.9	1.971	Ruminococcus sp. CAG:382	1262957	Bacteria	Bacteria	42	0.0494	NR	CDD04498.1	1262957	g12115	i0	36.2	0.643835616438356	47	30	64.4	0	171	31	143	189	CDD04498.1 undecaprenyl-diphosphatase 1 [Ruminococcus sp. CAG:382]	diamond	141	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. CAG:382
29211609	29211609	PRJDB3785_S_NODE_7989_length_266_cov_0.940092_g7836_i0	PRJDB3785	7989	266	0.940092	2.50064472	Niameybacter sp.	2033640	Bacteria	Bacteria	72	2.48e-12	NR	MEG0952103.1	2033640	g7836	i0	48.6	1.62406015037594	72	35	81.2	1	41	256	262	331	MEG0952103.1 DUF3794 domain-containing protein [Niameybacter sp.]	diamond	432	72	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Niameybacter	Niameybacter sp.
29995138	29995138	PRJDB3785_S_NODE_19211_length_181_cov_1.060606_g19058_i0	PRJDB3785	19211	181	1.060606	1.91969686	Eubacterium	1730	Bacteria	Bacteria	45.1	0.00249	NR	MFR2205283.1	142586	g19058	i0	52.3	2.38674033149171	44	19	72.9	1	1	132	189	230	MFR2205283.1 alpha-amylase family glycosyl hydrolase [Eubacterium sp.]	diamond	432	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
30063946	30063946	PRJDB3785_S_NODE_21552_length_172_cov_1.243902_g21399_i0	PRJDB3785	21552	172	1.243902	2.13951144	Paenibacillus sp. FSL R7-	58172	Bacteria	Bacteria	54.3	8.92e-7	NR	WP_342565768.1	2954535	g21399	i0	54.3	3.36627906976744	46	21	80.2	0	34	171	5	50	WP_342565768.1 SDR family NAD(P)-dependent oxidoreductase [Paenibacillus sp. FSL R7-0345]	diamond	579	54.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R7-0345
30317317	30317317	PRJDB3785_S_NODE_1012_length_797_cov_5.870321_g915_i0	PRJDB3785	1012	797	5.870321	46.78645837	Bacillus cereus group	86661	Bacteria	Bacteria	93.6	1.17e-18	NR	WP_128267372.1	86661	g915	i0	25.6	0.809284818067754	215	153	79.4	3	149	781	46	257	WP_128267372.1 MULTISPECIES: hypothetical protein [Bacillus cereus group]	diamond	645	93.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
30411912	30411912	PRJDB3785_S_NODE_11073_length_228_cov_2.005587_g10920_i0	PRJDB3785	11073	228	2.005587	4.57273836	Candidatus Epulonipiscium sp.	3100283	Bacteria	Bacteria	89.7	6.16e-19	NR	NLK37549.1	3100283	g10920	i0	55.4	3.51315789473684	65	29	85.5	0	199	5	222	286	NLK37549.1 aminopeptidase P family protein [Candidatus Epulonipiscium sp.]	diamond	801	89.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Candidatus Epulonipiscium	Candidatus Epulonipiscium sp.
30443338	30443338	PRJDB3785_S_NODE_3473_length_412_cov_3.283747_g3320_i0	PRJDB3785	3473	412	3.283747	13.52903764	Brevibacillus fulvus	1125967	Bacteria	Bacteria	144	1.64e-41	NR	WP_204516782.1	1125967	g3320	i0	61.1	5.03155339805825	113	44	82.3	0	48	386	2	114	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	2073	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
30822333	30822333	PRJDB3785_S_NODE_3314_length_425_cov_2.281915_g3161_i0	PRJDB3785	3314	425	2.281915	9.69813875	Bacilli bacterium	1903720	Bacteria	Bacteria	136	5.61e-34	NR	MBR4617798.1	1903720	g3161	i0	57.1	0.790588235294118	112	48	79.1	0	423	88	6	117	MBR4617798.1 hypothetical protein [Bacilli bacterium]	diamond	336	136	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
30980513	30980513	PRJDB3785_S_NODE_18974_length_182_cov_1.112782_g18821_i0	PRJDB3785	18974	182	1.112782	2.02526324	Symbiobacteriaceae bacterium	2602712	Bacteria	Bacteria	56.2	2.68e-7	NR	MDF2629472.1	2602712	g18821	i0	48.3	0.989010989010989	60	28	98.9	2	2	181	53	109	MDF2629472.1 zinc-binding dehydrogenase [Symbiobacteriaceae bacterium]	diamond	180	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae		Symbiobacteriaceae bacterium
31201053	31201053	PRJDB3785_S_NODE_11195_length_227_cov_1.679775_g11042_i0	PRJDB3785	11195	227	1.679775	3.81308925	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	119	7.36e-30	NR	MDY4494644.1	2049044	g11042	i0	74.7	14.4185022026432	75	19	99.1	0	226	2	322	396	MDY4494644.1 asparagine--tRNA ligase [Erysipelotrichaceae bacterium]	diamond	3273	119	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
31322009	31322009	PRJDB3785_S_NODE_19415_length_180_cov_1.167939_g19262_i0	PRJDB3785	19415	180	1.167939	2.1022902	root	1	Root_unresolved	Root_unresolved	42.7	0.00347	NR	MRA94204.1	1428	g19262	i0	44.9	1.91666666666667	49	22	73.3	1	139	8	5	53	MRA94204.1 hypothetical protein [Bacillus thuringiensis]	diamond	345	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
31480541	31480541	PRJDB3785_S_NODE_10036_length_239_cov_1.342105_g9883_i0	PRJDB3785	10036	239	1.342105	3.20763095	PVC group	1783257	Bacteria	Bacteria	107	6.79e-25	NR	MBS5518113.1	1898207	g9883	i0	63.3	3.96652719665272	79	29	99.2	0	239	3	147	225	MBS5518113.1 glutamine--tRNA ligase/YqeY domain fusion protein [Clostridiales bacterium]	diamond	948	107	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
31733142	31733142	PRJDB3785_S_NODE_24517_length_165_cov_0.879310_g24364_i0	PRJDB3785	24517	165	0.87931	1.4508615	Bacillati	1783272	Bacteria	Bacteria	42	0.025	NR	MFA5687200.1	1903720	g24364	i0	41.8	5	55	31	100	1	165	1	50	103	MFA5687200.1 redox-regulated ATPase YchF [Bacilli bacterium]	diamond	825	42.4	0.990566037735849	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31954614	31954614	PRJDB3785_S_NODE_6517_length_295_cov_1.451220_g6364_i0	PRJDB3785	6517	295	1.45122	4.281099	Bacillota	1239	Bacteria	Bacteria	110	1.1199999999999999e-28	NR	WP_002845271.1	1257	g6364	i0	60.5	7.96271186440678	86	34	87.5	0	2	259	36	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	2349	110	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
32207933	32207933	PRJDB3785_S_NODE_27338_length_161_cov_0.910714_g27185_i0	PRJDB3785	27338	161	0.910714	1.46624954	root	1	Root_unresolved	Root_unresolved	78.6	3.17e-17	NR	MRC56865.1	1428	g27185	i0	100	270.242236024845	34	0	63.4	0	161	60	73	106	MRC56865.1 30S ribosomal protein S19 [Bacillus thuringiensis]	diamond	43509	78.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
32492791	32492791	PRJDB3785_S_NODE_15639_length_197_cov_1.351351_g15486_i0	PRJDB3785	15639	197	1.351351	2.66216147	Faecousia	2840588	Bacteria	Bacteria	41.2	0.045	NR	MCI6957315.1	1898207	g15486	i0	39.2	1.55329949238579	51	30	77.7	1	35	187	15	64	MCI6957315.1 DUF2975 domain-containing protein [Clostridiales bacterium]	diamond	306	41.6	0.990384615384615	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
32562096	32562096	PRJDB3785_S_NODE_14679_length_202_cov_2.464052_g14526_i0	PRJDB3785	14679	202	2.464052	4.97738504	Enterococcus sp.	35783	Bacteria	Bacteria	42.4	0.0296	NR	MFV0559300.1	35783	g14526	i0	38	1.05445544554455	71	37	96.5	2	2	196	233	302	MFV0559300.1 endonuclease/exonuclease/phosphatase family protein [Enterococcus sp.]	diamond	213	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus sp.

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