metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA385396" 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
10610612	10610612	PRJNA385396_P_NODE_15589_length_248_cov_1.651429_g15497_i0	PRJNA385396	15589	248	1.651429	4.09554392	Caldibacillus debilis	301148	Bacteria	Bacteria	149	4.37e-43	NR	WP_276675552.1	301148	g15497	i0	91.5	1.98387096774194	82	7	99.2	0	3	248	62	143	WP_276675552.1 response regulator transcription factor [Caldibacillus debilis]	diamond	492	149	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus debilis
27011881	27011881	PRJNA385396_P_NODE_18942_length_244_cov_0.900585_g18850_i0	PRJNA385396	18942	244	0.900585	2.1974274	Aliicoccus persicus	930138	Bacteria	Bacteria	147	1.78e-40	NR	WP_091474597.1	930138	g18850	i0	91.3	0.983606557377049	80	7	98.4	0	242	3	157	236	WP_091474597.1 MBL fold metallo-hydrolase [Aliicoccus persicus]	diamond	240	147	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Aliicoccus	Aliicoccus persicus
28275237	28275237	PRJNA385396_P_NODE_13466_length_251_cov_0.865169_g13374_i0	PRJNA385396	13466	251	0.865169	2.17157419	Paenibacillaceae bacterium P15	3160968	Bacteria	Bacteria	44.3	0.0114	NR	WP_416215402.1	3160968	g13374	i0	32.9	0.944223107569721	79	52	93.2	1	2	235	124	202	WP_416215402.1 hypothetical protein [Paenibacillus mesotrionivorans]	diamond	237	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus mesotrionivorans
28622834	28622834	PRJNA385396_P_NODE_12927_length_254_cov_1.701657_g12835_i0	PRJNA385396	12927	254	1.701657	4.32220878	uncultured Peptoniphilus sp.	254354	Bacteria	Bacteria	113	7.94e-28	NR	WP_288164751.1	254354	g12835	i0	98.3	0.68503937007874	58	1	68.5	0	81	254	1	58	WP_288164751.1 aminotransferase class V-fold PLP-dependent enzyme [uncultured Peptoniphilus sp.]	diamond	174	113	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	uncultured Peptoniphilus sp.
28622835	28622835	PRJNA385396_P_NODE_13707_length_251_cov_0.865169_g13615_i0	PRJNA385396	13707	251	0.865169	2.17157419	Ruminococcus sp.	41978	Bacteria	Bacteria	104	5.94e-25	NR	MBP8797906.1	41978	g13615	i0	100	0.573705179282869	48	0	57.4	0	108	251	1	48	MBP8797906.1 spore germination protein [Ruminococcus sp.]	diamond	144	104	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
29222789	29222789	PRJNA385396_P_NODE_21229_length_241_cov_0.916667_g21137_i0	PRJNA385396	21229	241	0.916667	2.20916747	Caldibacillus debilis	301148	Bacteria	Bacteria	141	1.06e-40	NR	WP_276704888.1	301148	g21137	i0	97.5	0.995850622406639	80	2	99.6	0	2	241	28	107	WP_276704888.1 hypothetical protein [Caldibacillus debilis]	diamond	240	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus debilis
29380453	29380453	PRJNA385396_P_NODE_16389_length_247_cov_1.396552_g16297_i0	PRJNA385396	16389	247	1.396552	3.44948344	Enterococcus faecalis	1351	Bacteria	Bacteria	78.6	6.38e-17	NR	WP_375855466.1	1351	g16297	i0	63.6	0.668016194331984	55	20	66.8	0	246	82	6	60	WP_375855466.1 hypothetical protein [Enterococcus faecalis]	diamond	165	78.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
30770470	30770470	PRJNA385396_P_NODE_13994_length_251_cov_0.865169_g13902_i0	PRJNA385396	13994	251	0.865169	2.17157419	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	142	1.63e-37	NR	MDD6194527.1	1898203	g13902	i0	88	0.99203187250996006	83	10	99.2	0	250	2	3	85	MDD6194527.1 PBP1A family penicillin-binding protein [Lachnospiraceae bacterium]	diamond	249	142	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31560787	31560787	PRJNA385396_P_NODE_13896_length_251_cov_0.865169_g13804_i0	PRJNA385396	13896	251	0.865169	2.17157419	Caldibacillus debilis	301148	Bacteria	Bacteria	177	1.58e-53	NR	WP_276675051.1	301148	g13804	i0	100	0.99203187250996006	83	0	99.2	0	1	249	51	133	WP_276675051.1 nucleotidyltransferase-like protein [Caldibacillus debilis]	diamond	249	177	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus debilis
31781817	31781817	PRJNA385396_P_NODE_11917_length_264_cov_1.350785_g11825_i0	PRJNA385396	11917	264	1.350785	3.5660724	uncultured Oscillibacter sp.	876091	Bacteria	Bacteria	42	0.0442	NR	WP_294854701.1	876091	g11825	i0	32.9	0.829545454545455	73	45	83	1	219	1	64	132	WP_294854701.1 hypothetical protein [uncultured Oscillibacter sp.]	diamond	219	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Oscillibacter	uncultured Oscillibacter sp.
32810112	32810112	PRJNA385396_P_NODE_13600_length_251_cov_0.865169_g13508_i0	PRJNA385396	13600	251	0.865169	2.17157419	Ruminococcus	1263	Bacteria	Bacteria	182	5.7e-54	NR	MFR3812664.1	40519	g13508	i0	100	6.94422310756972	83	0	99.2	0	249	1	72	154	MFR3812664.1 glycoside hydrolase family 9 protein [Ruminococcus callidus]	diamond	1743	182	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus callidus

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