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

10 rows where analysis = "diamond", bioproject = "PRJNA683902" 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
22342513	22342513	PRJNA683902_S_NODE_18358_length_256_cov_1.771689_g17914_i0	PRJNA683902	18358	256	1.771689	4.53552384	Bacteria	2	Bacteria	Bacteria	92.4	1.28e-20	NR	WP_115310898.1	103891	g17914	i0	48.8	2.91796875	82	42	96.1	0	256	11	35	116	WP_115310898.1 glycosyltransferase family 2 protein [Veillonella criceti]	diamond	747	93.2	0.991416309012876	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella criceti
26607179	26607179	PRJNA683902_S_NODE_31541_length_173_cov_1.661765_g31097_i0	PRJNA683902	31541	173	1.661765	2.87485345	Lachnospiraceae bacterium RM5	1200721	Bacteria	Bacteria	42	0.0273	NR	SEQ39217.1	1200721	g31097	i0	35.2	0.936416184971098	54	29	83.2	1	154	11	402	455	SEQ39217.1 putative efflux protein, MATE family [Lachnospiraceae bacterium RM5]	diamond	162	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium RM5
27271824	27271824	PRJNA683902_S_NODE_27803_length_188_cov_1.536424_g27359_i0	PRJNA683902	27803	188	1.536424	2.88847712	Exiguobacterium sp. S22-S28	3342768	Bacteria	Bacteria	89.4	6.360000000000001e-21	NR	WP_393966238.1	3342768	g27359	i0	59	5.8563829787234	61	25	97.3	0	4	186	13	73	WP_393966238.1 DUF1801 domain-containing protein [Exiguobacterium sp. S22-S28]	diamond	1101	89.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium sp. S22-S28
27504772	27504772	PRJNA683902_S_NODE_34323_length_164_cov_1.228346_g33879_i0	PRJNA683902	34323	164	1.228346	2.01448744	Bacteria	2	Bacteria	Bacteria	106	6.22e-28	NR	KZK52508.1	1359	g33879	i0	100	2.96341463414634	54	0	98.8	0	1	162	54	107	KZK52508.1 Mobile element protein [Lactococcus cremoris]	diamond	486	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
27587801	27587801	PRJNA683902_S_NODE_12804_length_355_cov_2.270440_g12360_i0	PRJNA683902	12804	355	2.27044	8.060062	Fredinandcohnia sp. 179-A 1	2837515	Bacteria	Bacteria	51.2	1.36e-4	NR	WP_412966700.1	3235176	g12360	i0	58.5	0.346478873239437	41	17	34.6	0	2	124	83	123	WP_412966700.1 leucine-rich repeat domain-containing protein [Fredinandcohnia sp. 179-A 10B2 NHS]	diamond	123	51.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Fredinandcohnia	Fredinandcohnia sp. 179-A 10B2 NHS
30461772	30461772	PRJNA683902_S_NODE_33833_length_165_cov_2.382812_g33389_i0	PRJNA683902	33833	165	2.382812	3.9316398	Clostridiaceae bacterium	1898204	Bacteria	Bacteria	42	0.00616	NR	NLL65181.1	1898204	g33389	i0	65.5	0.527272727272727	29	10	52.7	0	77	163	1	29	NLL65181.1 riboflavin biosynthesis protein RibD [Clostridiaceae bacterium]	diamond	87	42	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium
30599173	30599173	PRJNA683902_S_NODE_29853_length_179_cov_1.612676_g29409_i0	PRJNA683902	29853	179	1.612676	2.88669004	Bacteria	2	Bacteria	Bacteria	54.3	1.23e-6	NR	WP_102712320.1	474957	g29409	i0	71.4	1.6927374301676	35	10	58.7	0	1	105	259	293	WP_102712320.1 methionyl-tRNA formyltransferase [Paenibacillus castaneae]	diamond	303	54.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus castaneae
30757318	30757318	PRJNA683902_S_NODE_24834_length_204_cov_1.401198_g24390_i0	PRJNA683902	24834	204	1.401198	2.85844392	Bacillati	1783272	Bacteria	Bacteria	90.5	4.71e-21	NR	WP_275532484.1	1965578	g24390	i0	60	1.89705882352941	65	26	95.6	0	200	6	86	150	WP_275532484.1 pyroglutamyl-peptidase I [Pseudoflavonifractor sp. An187]	diamond	387	91.3	0.991237677984666	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pseudoflavonifractor	Pseudoflavonifractor sp. An187
32548567	32548567	PRJNA683902_S_NODE_18979_length_249_cov_1.830189_g18535_i0	PRJNA683902	18979	249	1.830189	4.55717061	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0166	NR	MBQ7327491.1	2044939	g18535	i0	38.3	0.72289156626506	60	33	72.3	2	224	45	9	64	MBQ7327491.1 30S ribosomal protein S11 [Clostridia bacterium]	diamond	180	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32705722	32705722	PRJNA683902_S_NODE_34540_length_163_cov_2.166667_g34096_i0	PRJNA683902	34540	163	2.166667	3.53166721	Neobacillus cucumis	1740721	Bacteria	Bacteria	99.4	1.72e-24	NR	MFC4290748.1	1740721	g34096	i0	100	0.993865030674847	54	0	99.4	0	162	1	20	73	MFC4290748.1 hypothetical protein [Neobacillus cucumis]	diamond	162	99.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus cucumis

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