metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA904835" 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
27308943	27308943	PRJNA904835_P_NODE_38923_length_305_cov_1.327586_g38667_i0	PRJNA904835	38923	305	1.327586	4.0491373	Succiniclasticum ruminis	40841	Bacteria	Bacteria	55.8	1.46e-6	NR	WP_177206028.1	40841	g38667	i0	54.3	1.76065573770492	46	21	45.2	0	6	143	203	248	WP_177206028.1 tetratricopeptide repeat protein [Succiniclasticum ruminis]	diamond	537	55.8	1	Bacteria	Bacillati	Bacillota	Negativicutes	Acidaminococcales	Acidaminococcaceae	Succiniclasticum	Succiniclasticum ruminis
27751083	27751083	PRJNA904835_P_NODE_20684_length_443_cov_1.245946_g20429_i0	PRJNA904835	20684	443	1.245946	5.51954078	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	46.6	0.00892	NR	MCR5294432.1	1898203	g20429	i0	28.4	0.738148984198646	109	76	73.1	2	72	395	79	186	MCR5294432.1 2'-5' RNA ligase family protein [Lachnospiraceae bacterium]	diamond	327	46.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28161502	28161502	PRJNA904835_P_NODE_21245_length_436_cov_1.236915_g20990_i0	PRJNA904835	21245	436	1.236915	5.3929494	[Clostridium] ultunense Esp	1288971	Bacteria	Bacteria	45.8	0.0223	NR	CCQ96739.1	1288971	g20990	i0	26.8	0.846330275229358	123	67	72.9	3	330	13	349	465	CCQ96739.1 FAD dependent oxidoreductase [[Clostridium] ultunense Esp]	diamond	369	45.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tepidimicrobiaceae	Schnuerera	Schnuerera ultunensis
29234902	29234902	PRJNA904835_P_NODE_51849_length_250_cov_0.870056_g51593_i0	PRJNA904835	51849	250	0.870056	2.17514	Clostridia bacterium	2044939	Bacteria	Bacteria	42.4	0.0473	NR	MBQ5579994.1	2044939	g51593	i0	32	0.6	50	34	60	0	171	22	46	95	MBQ5579994.1 lysoplasmalogenase [Clostridia bacterium]	diamond	150	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30940736	30940736	PRJNA904835_P_NODE_49754_length_254_cov_1.276243_g49498_i0	PRJNA904835	49754	254	1.276243	3.24165722	Paenibacillus apiarius	46240	Bacteria	Bacteria	43.5	0.0217	NR	WP_240463803.1	46240	g49498	i0	37.5	0.566929133858268	48	29	55.5	1	1	141	154	201	WP_240463803.1 sulfate ABC transporter substrate-binding protein [Paenibacillus apiarius]	diamond	144	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus apiarius
31319760	31319760	PRJNA904835_P_NODE_42515_length_287_cov_1.439252_g42259_i0	PRJNA904835	42515	287	1.439252	4.13065324	Bacilli bacterium	1903720	Bacteria	Bacteria	53.5	9.55e-6	NR	MBQ2408562.1	1903720	g42259	i0	28.4	0.993031358885017	95	67	98.3	1	284	3	191	285	MBQ2408562.1 DUF4116 domain-containing protein [Bacilli bacterium]	diamond	285	53.5	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31636056	31636056	PRJNA904835_P_NODE_23836_length_409_cov_1.375000_g23581_i0	PRJNA904835	23836	409	1.375	5.62375	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	47.4	0.0044	NR	MCL2254903.1	1898203	g23581	i0	34	0.689486552567237	94	53	62.3	2	364	110	23	116	MCL2254903.1 site-specific tyrosine recombinase XerD [Lachnospiraceae bacterium]	diamond	282	47.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32300851	32300851	PRJNA904835_P_NODE_14479_length_547_cov_1.559072_g14227_i0	PRJNA904835	14479	547	1.559072	8.52812384	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	139	9.36e-38	NR	MDK2802725.1	2485925	g14227	i0	52.5	1.3382084095064	122	57	66.9	1	5	370	3	123	MDK2802725.1 N-acetyltransferase [Oscillospiraceae bacterium]	diamond	732	139	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32805532	32805532	PRJNA904835_P_NODE_56360_length_244_cov_0.900585_g56104_i0	PRJNA904835	56360	244	0.900585	2.1974274	Clostridia bacterium	2044939	Bacteria	Bacteria	41.2	0.0448	NR	MBQ8893392.1	2044939	g56104	i0	40.3	0.762295081967213	62	31	68.9	2	58	225	39	100	MBQ8893392.1 DUF1064 domain-containing protein [Clostridia bacterium]	diamond	186	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32836986	32836986	PRJNA904835_P_NODE_23320_length_414_cov_1.351906_g23065_i0	PRJNA904835	23320	414	1.351906	5.59689084	Alkalihalobacillus deserti	2879466	Bacteria	Bacteria	50.4	3.06e-4	NR	WP_227937726.1	2879466	g23065	i0	27.5	1.86231884057971	142	68	85.5	5	373	20	68	198	WP_227937726.1 lipase family protein [Alkalihalobacillus deserti]	diamond	771	50.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacillus	Alkalihalobacillus deserti

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