metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA675331" 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
1923829	1923829	PRJNA675331_P_NODE_14302_length_275_cov_1.232673_g14130_i0	PRJNA675331	14302	275	1.232673	3.38985075	Bacteria	2	Bacteria	Bacteria	126	2.31e-32	NR	NLK69503.1	1898204	g14130	i0	63.3	16.5927272727273	90	33	98.2	0	4	273	303	392	NLK69503.1 elongation factor Tu [Clostridiaceae bacterium]	diamond	4563	127	0.992125984251969	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium
15950529	15950529	PRJNA675331_P_NODE_4813_length_435_cov_1.063536_g4641_i0	PRJNA675331	4813	435	1.063536	4.6263816	Evansella vedderi	38282	Bacteria	Bacteria	261	1.34e-81	NR	WP_307329272.1	38282	g4641	i0	81.9	0.993103448275862	144	26	99.3	0	434	3	244	387	WP_307329272.1 beta-glucuronidase [Evansella vedderi]	diamond	432	261	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella vedderi
15950548	15950548	PRJNA675331_P_NODE_9253_length_325_cov_1.142857_g9081_i0	PRJNA675331	9253	325	1.142857	3.71428525	Clostridia bacterium	2044939	Bacteria	Bacteria	162	2.11e-46	NR	MDD4685958.1	2044939	g9081	i0	79	47.4830769230769	105	22	96.9	0	324	10	154	258	MDD4685958.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridia bacterium]	diamond	15432	162	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27239880	27239880	PRJNA675331_P_NODE_20003_length_248_cov_0.880000_g19831_i0	PRJNA675331	20003	248	0.88	2.1824	Clostridiales bacterium	1898207	Bacteria	Bacteria	64.3	2.16e-11	NR	HBV66938.1	1898207	g19831	i0	46.7	0.725806451612903	60	32	72.6	0	229	50	17	76	HBV66938.1 hypothetical protein [Clostridiales bacterium]	diamond	180	64.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28293757	28293757	PRJNA675331_P_NODE_4586_length_444_cov_1.326146_g4414_i0	PRJNA675331	4586	444	1.326146	5.88808824	root	1	Root_unresolved	Root_unresolved	162	7.64e-46	NR	MRB67411.1	1428	g4414	i0	59.4	5.40540540540541	133	47	89.9	1	401	3	5	130	MRB67411.1 30S ribosomal protein S2 [Bacillus thuringiensis]	diamond	2400	163	0.993865030674847	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
28408406	28408406	PRJNA675331_P_NODE_19326_length_249_cov_0.875000_g19154_i0	PRJNA675331	19326	249	0.875	2.17875	Oribacterium sinus	237576	Bacteria	Bacteria	92	1.84e-19	NR	WP_304070818.1	237576	g19154	i0	53	1.98795180722892	83	39	100	0	1	249	153	235	WP_304070818.1 methyl-accepting chemotaxis protein [Oribacterium sinus]	diamond	495	92	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Oribacterium	Oribacterium sinus
28724132	28724132	PRJNA675331_P_NODE_10527_length_308_cov_2.034043_g10355_i0	PRJNA675331	10527	308	2.034043	6.26485244	Veillonella sp.	1926307	Bacteria	Bacteria	156	2.9e-47	NR	WP_366512514.1	1926307	g10355	i0	73	1.94805194805195	100	27	97.4	0	306	7	6	105	WP_366512514.1 hypothetical protein [Veillonella sp.]	diamond	600	156	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella sp.
31218986	31218986	PRJNA675331_P_NODE_13035_length_283_cov_1.114286_g12863_i0	PRJNA675331	13035	283	1.114286	3.15342938	Evansella sp. LMS18	2924033	Bacteria	Bacteria	44.3	0.0172	NR	WP_255244507.1	2924033	g12863	i0	33.8	0.816254416961131	77	51	81.6	0	4	234	325	401	WP_255244507.1 asparagine synthase-related protein [Evansella sp. LMS18]	diamond	231	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella sp. LMS18
31326014	31326014	PRJNA675331_P_NODE_16255_length_263_cov_1.215789_g16083_i0	PRJNA675331	16255	263	1.215789	3.19752507	Bacillati	1783272	Bacteria	Bacteria	43.5	0.0252	NR	WP_010246532.1	35830	g16083	i0	37.9	1.6425855513308	66	37	73	2	69	260	213	276	WP_010246532.1 hypothetical protein [Acetivibrio cellulolyticus]	diamond	432	43.9	0.990888382687927	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Acetivibrio	Acetivibrio cellulolyticus
31958628	31958628	PRJNA675331_P_NODE_8617_length_335_cov_0.881679_g8445_i0	PRJNA675331	8617	335	0.881679	2.95362465	Bacillati	1783272	Bacteria	Bacteria	111	7.090000000000001e-26	NR	MEE3392634.1	1898203	g8445	i0	55.6	4.38805970149254	81	36	72.5	0	243	1	6	86	MEE3392634.1 glutamine synthetase III [Lachnospiraceae bacterium]	diamond	1470	111	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32041836	32041836	PRJNA675331_P_NODE_1778_length_685_cov_1.570261_g1617_i0	PRJNA675331	1778	685	1.570261	10.75628785	Clostridia bacterium	2044939	Bacteria	Bacteria	47.4	0.0393	NR	MBQ3461596.1	2044939	g1617	i0	26.9	2.19416058394161	167	109	67.9	4	475	11	4766	4931	MBQ3461596.1 cadherin-like beta sandwich domain-containing protein [Clostridia bacterium]	diamond	1503	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32105037	32105037	PRJNA675331_P_NODE_7118_length_364_cov_1.054983_g6946_i0	PRJNA675331	7118	364	1.054983	3.84013812	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	47	0.00446	NR	MBO5336739.1	1898203	g6946	i0	30.6	0.593406593406593	72	50	59.3	0	93	308	404	475	MBO5336739.1 glucosyltransferase domain-containing protein [Lachnospiraceae bacterium]	diamond	216	47	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32799878	32799878	PRJNA675331_P_NODE_23620_length_242_cov_0.911243_g23448_i0	PRJNA675331	23620	242	0.911243	2.20520806	Staphylococcus aureus	1280	Bacteria	Bacteria	56.2	3.96e-7	NR	WP_275218940.1	1280	g23448	i0	84.6	0.322314049586777	26	4	32.2	0	186	109	3	28	WP_275218940.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	78	56.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus

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