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

10 rows where analysis = "diamond", bioproject = "PRJNA971676" 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
2220064	2220064	PRJNA971676_P_NODE_23662_length_241_cov_0.916667_g23573_i0	PRJNA971676	23662	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	148	4.14e-41	NR	WP_066821091.1	420412	g23573	i0	86.3	20.9128630705394	80	11	99.6	0	241	2	217	296	WP_066821091.1 isocitrate/isopropylmalate family dehydrogenase [Clostridium tepidiprofundi]	diamond	5040	149	0.993288590604027	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium tepidiprofundi
26994078	26994078	PRJNA971676_P_NODE_3662_length_415_cov_2.880117_g3573_i0	PRJNA971676	3662	415	2.880117	11.95248555	Bacillota bacterium	1879010	Bacteria	Bacteria	44.3	0.0137	NR	HBF39622.1	1879010	g3573	i0	42.2	0.325301204819277	45	26	32.5	0	305	171	56	100	HBF39622.1 hypothetical protein [Bacillota bacterium]	diamond	135	44.3	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
28510364	28510364	PRJNA971676_P_NODE_23207_length_241_cov_0.916667_g23118_i0	PRJNA971676	23207	241	0.916667	2.20916747	Ruminococcus sp.	41978	Bacteria	Bacteria	45.4	9.96e-4	NR	MBQ2944544.1	41978	g23118	i0	50	0.348547717842324	28	14	34.9	0	28	111	85	112	MBQ2944544.1 zinc ribbon domain-containing protein [Ruminococcus sp.]	diamond	84	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
28573422	28573422	PRJNA971676_P_NODE_5407_length_359_cov_1.632867_g5318_i0	PRJNA971676	5407	359	1.632867	5.86199253	Virgibacillus proomii	84407	Bacteria	Bacteria	52.4	5.61e-5	NR	WP_245799799.1	84407	g5318	i0	33.3	0.752089136490251	90	58	75.2	2	274	5	53	140	WP_245799799.1 M4 family metallopeptidase [Virgibacillus proomii]	diamond	270	52.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus proomii
28889132	28889132	PRJNA971676_P_NODE_13948_length_251_cov_0.865169_g13859_i0	PRJNA971676	13948	251	0.865169	2.17157419	Clostridia bacterium	2044939	Bacteria	Bacteria	86.3	2.8e-18	NR	MQY59129.1	2044939	g13859	i0	60.2	1.9840637450199201	83	31	99.2	1	249	1	64	144	MQY59129.1 DUF4386 family protein [Clostridia bacterium]	diamond	498	86.3	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29741449	29741449	PRJNA971676_P_NODE_8410_length_306_cov_1.321888_g8321_i0	PRJNA971676	8410	306	1.321888	4.04497728	Limosilactobacillus reuteri	1598	Bacteria	Bacteria	86.3	5.41e-18	NR	WP_229280234.1	1598	g8321	i0	42.6	0.990196078431373	101	55	99	1	303	1	92	189	WP_229280234.1 glycosyltransferase family 32 protein [Limosilactobacillus reuteri]	diamond	303	86.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus reuteri
29773131	29773131	PRJNA971676_P_NODE_11431_length_273_cov_1.155000_g11342_i0	PRJNA971676	11431	273	1.155	3.15315	Limosilactobacillus reuteri	1598	Bacteria	Bacteria	113	7.99e-29	NR	WP_229396297.1	1598	g11342	i0	54.4	0.989010989010989	90	41	98.9	0	2	271	4	93	WP_229396297.1 glycosyltransferase family 32 protein [Limosilactobacillus reuteri]	diamond	270	113	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus reuteri
30594562	30594562	PRJNA971676_P_NODE_20953_length_244_cov_0.900585_g20864_i0	PRJNA971676	20953	244	0.900585	2.1974274	Limosilactobacillus reuteri	1598	Bacteria	Bacteria	100	1.2800000000000001e-22	NR	WP_122480865.1	1598	g20864	i0	59.7	0.94672131147541	77	31	94.7	0	242	12	793	869	WP_122480865.1 hypothetical protein [Limosilactobacillus reuteri]	diamond	231	100	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus reuteri
31258245	31258245	PRJNA971676_P_NODE_20755_length_244_cov_0.900585_g20666_i0	PRJNA971676	20755	244	0.900585	2.1974274	Clostridia bacterium	2044939	Bacteria	Bacteria	68.2	9.03e-12	NR	MQY75568.1	2044939	g20666	i0	75	0.639344262295082	52	13	63.9	0	24	179	1	52	MQY75568.1 hypothetical protein [Clostridia bacterium]	diamond	156	68.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31669403	31669403	PRJNA971676_P_NODE_23157_length_241_cov_0.916667_g23068_i0	PRJNA971676	23157	241	0.916667	2.20916747	Desmospora activa	500615	Bacteria	Bacteria	57	2.51e-7	NR	WP_107727495.1	500615	g23068	i0	33.8	0.95850622406639	77	50	94.6	1	239	12	121	197	WP_107727495.1 hypothetical protein [Desmospora activa]	diamond	231	57	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Desmospora	Desmospora activa

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