metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA407087" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA407087" 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
27313587	27313587	PRJNA407087_S_NODE_4443_length_257_cov_7.122807_g3980_i0	PRJNA407087	4443	257	7.122807	18.30561399	root	1	Root_unresolved	Root_unresolved	170	9.32e-53	NR	MDK0657390.1	1502	g3980	i0	98.8	79.3774319066148	85	1	99.2	0	3	257	27	111	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	20400	171	0.994152046783626	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
27629415	27629415	PRJNA407087_S_NODE_5484_length_218_cov_4.735450_g5021_i0	PRJNA407087	5484	218	4.73545	10.323281	Peptostreptococcus	1257	Bacteria	Bacteria	92	5.45e-22	NR	WP_002845271.1	1257	g5021	i0	62	7.55504587155963	71	27	97.7	0	214	2	51	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	1647	92.8	0.991379310344828	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
28166055	28166055	PRJNA407087_S_NODE_1945_length_473_cov_9.945946_g1495_i0	PRJNA407087	1945	473	9.945946	47.04432458	Paenibacillaceae	186822	Bacteria	Bacteria	141	3.02e-40	NR	WP_239631023.1	185978	g1495	i0	61.2	7.3446088794926	116	45	73.6	0	410	63	1	116	WP_239631023.1 MULTISPECIES: group I truncated hemoglobin [unclassified Paenibacillus]	diamond	3474	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus
28450335	28450335	PRJNA407087_S_NODE_9746_length_152_cov_4.186992_g9283_i0	PRJNA407087	9746	152	4.186992	6.36422784	root	1	Root_unresolved	Root_unresolved	48.1	1.33e-4	NR	WP_007545792.1	1069827	g9283	i0	42.6	5.58552631578947	47	27	92.8	0	152	12	22	68	WP_007545792.1 cation-translocating P-type ATPase, partial [Listeria fleischmannii]	diamond	849	48.5	0.991752577319588	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria fleischmannii
28906851	28906851	PRJNA407087_S_NODE_5768_length_211_cov_4.390110_g5305_i0	PRJNA407087	5768	211	4.39011	9.2631321	Listeria monocytogenes	1639	Bacteria	Bacteria	44.7	7.7e-4	NR	WP_333731483.1	1639	g5305	i0	35	0.853080568720379	60	39	85.3	0	32	211	13	72	WP_333731483.1 hypothetical protein, partial [Listeria monocytogenes]	diamond	180	44.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
28923620	28923620	PRJNA407087_S_NODE_9168_length_158_cov_1.581395_g8705_i0	PRJNA407087	9168	158	1.581395	2.4986041	FCB group	1783270	Bacteria	Bacteria	60.1	8.83e-9	NR	MBQ8925958.1	2044939	g8705	i0	49	15.0949367088608	51	26	96.8	0	4	156	463	513	MBQ8925958.1 alpha-glucosidase [Clostridia bacterium]	diamond	2385	60.1	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29239562	29239562	PRJNA407087_S_NODE_8769_length_161_cov_7.628788_g8306_i0	PRJNA407087	8769	161	7.628788	12.28234868	root	1	Root_unresolved	Root_unresolved	62.4	1.39e-9	NR	QHG77622.1	1280	g8306	i0	86.8	24.6894409937888	53	7	98.8	0	3	161	27	79	QHG77622.1 30S ribosomal protein S5 [Staphylococcus aureus]	diamond	3975	62.8	0.993630573248408	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29443591	29443591	PRJNA407087_S_NODE_6170_length_202_cov_2.843931_g5707_i0	PRJNA407087	6170	202	2.843931	5.74474062	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	96.3	3.0300000000000003e-21	NR	MBR5474511.1	1898203	g5707	i0	65.2	2.95544554455446	66	23	98	0	199	2	144	209	MBR5474511.1 alpha-glucosidase [Lachnospiraceae bacterium]	diamond	597	96.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30265327	30265327	PRJNA407087_S_NODE_9332_length_156_cov_2.472441_g8869_i0	PRJNA407087	9332	156	2.472441	3.85700796	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	43.5	0.0014	NR	MBP5263707.1	1898203	g8869	i0	43.5	0.884615384615385	46	25	86.5	1	16	150	18	63	MBP5263707.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	138	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30360273	30360273	PRJNA407087_S_NODE_3092_length_346_cov_2.889590_g2629_i0	PRJNA407087	3092	346	2.88959	9.9979814	Lutispora saccharofermentans	3024236	Bacteria	Bacteria	44.3	0.0331	NR	WP_255227675.1	3024236	g2629	i0	32.3	0.858381502890173	99	58	78.9	4	21	293	181	278	WP_255227675.1 sensor histidine kinase [Lutispora saccharofermentans]	diamond	297	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lutisporales	Lutisporaceae	Lutispora	Lutispora saccharofermentans
30675612	30675612	PRJNA407087_S_NODE_933_length_747_cov_6.920613_g510_i1	PRJNA407087	933	747	6.920613	51.69697911	Bacilli bacterium	1903720	Bacteria	Bacteria	62	5e-7	NR	MBO6195346.1	1903720	g510	i1	28.2	0.855421686746988	213	147	83.5	3	31	654	228	439	MBO6195346.1 TMEM198/TM7SF3 family protein [Bacilli bacterium]	diamond	639	62	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31750447	31750447	PRJNA407087_S_NODE_5357_length_222_cov_2.518135_g4894_i0	PRJNA407087	5357	222	2.518135	5.5902597	Bacilli bacterium	1903720	Bacteria	Bacteria	86.7	9.53e-18	NR	MBP3799570.1	1903720	g4894	i0	58.1	6.10810810810811	74	28	100	2	222	1	57	127	MBP3799570.1 dynamin family protein [Bacilli bacterium]	diamond	1356	86.7	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31893803	31893803	PRJNA407087_S_NODE_9657_length_153_cov_2.911290_g9194_i0	PRJNA407087	9657	153	2.91129	4.4542737	Staphylococcus	1279	Bacteria	Bacteria	53.1	2.27e-6	NR	WP_002481138.1	1279	g9194	i0	48	15.1176470588235	50	25	98	1	151	2	572	620	WP_002481138.1 MULTISPECIES: valine--tRNA ligase [Staphylococcus]	diamond	2313	53.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus
32225256	32225256	PRJNA407087_S_NODE_2618_length_389_cov_36.750000_g2157_i0	PRJNA407087	2618	389	36.75	142.9575	Brevibacillus fulvus	1125967	Bacteria	Bacteria	144	8.87e-42	NR	WP_204516782.1	1125967	g2157	i0	61.9	2.62982005141388	113	43	87.1	0	51	389	2	114	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	1023	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
32305459	32305459	PRJNA407087_S_NODE_2259_length_430_cov_8.341646_g1798_i0	PRJNA407087	2259	430	8.341646	35.8690778	Peptostreptococcus	1257	Bacteria	Bacteria	124	1.04e-33	NR	WP_002845271.1	1257	g1798	i0	54.5	4.80697674418605	112	49	78.1	1	35	370	12	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	2067	124	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
32667535	32667535	PRJNA407087_S_NODE_4080_length_274_cov_3.522449_g3617_i0	PRJNA407087	4080	274	3.522449	9.65151026	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	118	3.8e-29	NR	MBR5569308.1	2485925	g3617	i0	60.4	6.97445255474453	91	36	99.6	0	274	2	184	274	MBR5569308.1 aldehyde dehydrogenase [Oscillospiraceae bacterium]	diamond	1911	118	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium

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