metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1011833" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1011833" 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
27445814	27445814	PRJNA1011833_S_NODE_28223_length_223_cov_1.038889_g27803_i0	PRJNA1011833	28223	223	1.038889	2.31672247	unclassified Amedibacterium	3088137	Bacteria	Bacteria	42	0.05	NR	WP_233511338.1	3088137	g27803	i0	42.6	0.726457399103139	54	27	70	3	19	174	188	239	WP_233511338.1 MULTISPECIES: hypothetical protein [unclassified Amedibacterium]	diamond	162	42	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Amedibacterium
27824571	27824571	PRJNA1011833_S_NODE_34104_length_200_cov_2.369427_g33684_i0	PRJNA1011833	34104	200	2.369427	4.738854	Holdemanella biformis	1735	Bacteria	Bacteria	43.1	0.0155	NR	WP_227976277.1	1735	g33684	i0	39	1.23	82	31	97.5	3	5	199	153	232	WP_227976277.1 glycoside hydrolase family 13 protein [Holdemanella biformis]	diamond	246	43.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Holdemanella	Holdemanella biformis
28006468	28006468	PRJNA1011833_S_NODE_51585_length_161_cov_1.220339_g51165_i0	PRJNA1011833	51585	161	1.220339	1.96474579	Clostridia	186801	Bacteria	Bacteria	100	4.53e-24	NR	MCI5596461.1	1898203	g51165	i0	81.1	18.6335403726708	53	10	98.8	0	3	161	131	183	MCI5596461.1 UDP-glucose 4-epimerase GalE [Lachnospiraceae bacterium]	diamond	3000	101	0.99009900990099	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28606128	28606128	PRJNA1011833_S_NODE_10727_length_360_cov_5.182965_g10308_i0	PRJNA1011833	10727	360	5.182965	18.658674	Bacteria	2	Bacteria	Bacteria	58.9	2.67e-7	NR	WP_029699112.1	1391647	g10308	i0	32.2	5.675	115	69	93.3	6	359	24	122	230	WP_029699112.1 DEAD/DEAH box helicase [Clostridium sp. Ade.TY]	diamond	2043	58.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. Ade.TY
29268978	29268978	PRJNA1011833_S_NODE_55349_length_155_cov_1.196429_g54929_i0	PRJNA1011833	55349	155	1.196429	1.85446495	root	1	Root_unresolved	Root_unresolved	42.7	0.00609	NR	WP_262458101.1	1496	g54929	i0	48.7	3.01935483870968	39	17	69.7	1	42	149	68	106	WP_262458101.1 endonuclease/exonuclease/phosphatase family protein [Clostridioides difficile]	diamond	468	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29710860	29710860	PRJNA1011833_S_NODE_11310_length_352_cov_8.896440_g10890_i0	PRJNA1011833	11310	352	8.89644	31.3154688	Bacteria	2	Bacteria	Bacteria	112	8.130000000000001e-27	NR	WP_221880430.1	1399	g10890	i0	50.5	15.7244318181818	103	51	87.8	0	344	36	305	407	WP_221880430.1 NAD-dependent succinate-semialdehyde dehydrogenase, partial [Cytobacillus firmus]	diamond	5535	113	0.991150442477876	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus firmus
30698122	30698122	PRJNA1011833_S_NODE_16594_length_297_cov_1.854331_g16174_i0	PRJNA1011833	16594	297	1.854331	5.50736307	Leuconostoc pseudomesenteroides	33968	Bacteria	Bacteria	43.5	0.0158	NR	WP_349550031.1	33968	g16174	i0	27.2	0.818181818181818	81	53	77.8	2	51	281	30	108	WP_349550031.1 single-stranded DNA-binding protein [Leuconostoc pseudomesenteroides]	diamond	243	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc pseudomesenteroides
31267030	31267030	PRJNA1011833_S_NODE_38515_length_188_cov_0.958621_g38095_i0	PRJNA1011833	38515	188	0.958621	1.80220748	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.7	0.0174	NR	MCC8043763.1	2485925	g38095	i0	40.5	0.670212765957447	42	24	65.4	1	137	15	100	141	MCC8043763.1 sugar phosphate isomerase/epimerase [Oscillospiraceae bacterium]	diamond	126	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32057768	32057768	PRJNA1011833_S_NODE_5418_length_455_cov_12.621359_g5006_i0	PRJNA1011833	5418	455	12.621359	57.42718345	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	87.4	3.45e-19	NR	MBQ5561215.1	1898203	g5006	i0	40.7	1.21978021978022	86	51	56.7	0	292	35	16	101	MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium]	diamond	555	87.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae 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);;