metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax_kingdom = "Bacillati"

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
12054983	12054983	PRJNA602115_P_NODE_4710_length_289_cov_1.122807_g4685_i0	PRJNA602115	4710	289	1.1228070000000001	3.24491223	root	1	Root_unresolved	Root_unresolved	105	8.39e-27	NR	MRA94127.1	1428	g4685	i0	81.3	47.8339100346021	64	12	66.4	0	289	98	68	131	MRA94127.1 30S ribosomal protein S9 [Bacillus thuringiensis]	diamond	13824	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
27996026	27996026	PRJNA602115_P_NODE_8805_length_209_cov_0.864865_g8780_i0	PRJNA602115	8805	209	0.864865	1.80756785	Intestinimonas	1392389	Bacteria	Bacteria	68.6	2.28e-13	NR	WP_195615481.1	1392389	g8780	i0	77.8	0.645933014354067	45	10	64.6	0	137	3	1	45	WP_195615481.1 MULTISPECIES: helix-turn-helix transcriptional regulator [Intestinimonas]	diamond	135	68.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Intestinimonas
28943430	28943430	PRJNA602115_P_NODE_11188_length_203_cov_0.901408_g11163_i0	PRJNA602115	11188	203	0.901408	1.82985824	Streptomyces sp. NBC_	1931	Bacteria	Bacteria	43.1	0.0159	NR	WP_329376215.1	2903833	g11163	i0	51.4	1.0935960591133	37	16	51.7	1	48	152	69	105	WP_329376215.1 mannosyltransferase family protein [Streptomyces sp. NBC_01351]	diamond	222	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01351
28974846	28974846	PRJNA602115_P_NODE_11448_length_202_cov_0.907801_g11423_i0	PRJNA602115	11448	202	0.907801	1.83375802	Paenibacillus mucilaginosus	61624	Bacteria	Bacteria	41.2	0.0163	NR	WP_014371261.1	61624	g11423	i0	37.8	0.54950495049505	37	23	55	0	157	47	48	84	WP_014371261.1 DUF7667 family protein [Paenibacillus mucilaginosus]	diamond	111	41.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus mucilaginosus
29448076	29448076	PRJNA602115_P_NODE_2570_length_377_cov_0.911392_g2545_i0	PRJNA602115	2570	377	0.911392	3.43594784	Vagococcus fluvialis	2738	Bacteria	Bacteria	77	1.03e-15	NR	WP_349738039.1	2738	g2545	i0	53.1	0.509283819628647	64	30	50.9	0	175	366	7	70	WP_349738039.1 hypothetical protein [Vagococcus fluvialis]	diamond	192	77	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus fluvialis
29605830	29605830	PRJNA602115_P_NODE_6610_length_247_cov_1.150538_g6585_i0	PRJNA602115	6610	247	1.150538	2.84182886	Brevibacillus agri	51101	Bacteria	Bacteria	67.4	7.8e-11	NR	WP_327944806.1	51101	g6585	i0	43.8	1.93117408906883	80	44	96	1	245	9	250	329	WP_327944806.1 fibronectin type III domain-containing protein [Brevibacillus agri]	diamond	477	67.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus agri
29668967	29668967	PRJNA602115_P_NODE_3730_length_318_cov_0.887160_g3705_i0	PRJNA602115	3730	318	0.88716	2.8211688	Bacillus amyloliquefaciens group	1938374	Bacteria	Bacteria	43.1	0.0065	NR	WP_032859190.1	1938374	g3705	i0	29.5	1.13207547169811	61	43	57.5	0	36	218	4	64	WP_032859190.1 MULTISPECIES: hypothetical protein [Bacillus amyloliquefaciens group]	diamond	360	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus
30333196	30333196	PRJNA602115_P_NODE_7932_length_223_cov_1.185185_g7907_i0	PRJNA602115	7932	223	1.185185	2.64296255	unclassified Micromonospora	2617518	Bacteria	Bacteria	48.1	3.28e-4	NR	WP_377583842.1	2617518	g7907	i0	44.8	0.780269058295964	58	26	71.3	2	42	200	169	225	WP_377583842.1 MULTISPECIES: winged helix-turn-helix domain-containing protein [unclassified Micromonospora]	diamond	174	48.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora
30616960	30616960	PRJNA602115_P_NODE_8793_length_209_cov_0.864865_g8768_i0	PRJNA602115	8793	209	0.864865	1.80756785	Streptomyces sp. Ag82_O1-15	1938855	Bacteria	Bacteria	42	0.0445	NR	WP_095850585.1	1938855	g8768	i0	38.7	0.889952153110048	62	35	87.6	2	2	184	384	443	WP_095850585.1 MBL fold metallo-hydrolase [Streptomyces sp. Ag82_O1-15]	diamond	186	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Ag82_O1-15
30869786	30869786	PRJNA602115_P_NODE_634_length_730_cov_1.415546_g610_i0	PRJNA602115	634	730	1.415546	10.3334858	Clostridium chromiireducens	225345	Bacteria	Bacteria	346	1.4099999999999995e-116	NR	WP_160358929.1	225345	g610	i0	67.5	2.92191780821918	237	77	97.4	0	712	2	1	237	WP_160358929.1 replication protein [Clostridium chromiireducens]	diamond	2133	346	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium chromiireducens
31185502	31185502	PRJNA602115_P_NODE_2735_length_366_cov_1.259016_g2710_i0	PRJNA602115	2735	366	1.259016	4.60799856	Trichococcus patagoniensis	382641	Bacteria	Bacteria	92.4	8.32e-22	NR	WP_108033865.1	382641	g2710	i0	60.3	0.598360655737705	73	29	59.8	0	19	237	11	83	WP_108033865.1 hypothetical protein [Trichococcus patagoniensis]	diamond	219	92.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus patagoniensis
31312207	31312207	PRJNA602115_P_NODE_7895_length_224_cov_0.975460_g7870_i0	PRJNA602115	7895	224	0.97546	2.1850304	Williamsia serinedens	391736	Bacteria	Bacteria	71.2	1.77e-14	NR	MCP2159627.1	391736	g7870	i0	92.3	0.522321428571429	39	3	52.2	0	119	3	1	39	MCP2159627.1 hypothetical protein [Williamsia serinedens]	diamond	117	71.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia serinedens
31438693	31438693	PRJNA602115_P_NODE_11056_length_203_cov_0.901408_g11031_i0	PRJNA602115	11056	203	0.901408	1.82985824	Eubacteriaceae bacterium	2049045	Bacteria	Bacteria	67.4	2.71e-11	NR	MBR6801278.1	2049045	g11031	i0	44.8	0.990147783251232	67	37	99	0	1	201	157	223	MBR6801278.1 protein rep [Eubacteriaceae bacterium]	diamond	201	67.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae		Eubacteriaceae bacterium
32274807	32274807	PRJNA602115_P_NODE_7098_length_238_cov_1.050847_g7073_i0	PRJNA602115	7098	238	1.050847	2.50101586	Bacillales	1385	Bacteria	Bacteria	119	1.66e-32	NR	WP_029053042.1	1569	g7073	i0	75.9	17.8739495798319	79	19	99.6	0	238	2	59	137	WP_029053042.1 MULTISPECIES: nucleoside-diphosphate kinase [Sporosarcina]	diamond	4254	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina
32356501	32356501	PRJNA602115_P_NODE_639_length_725_cov_1.418675_g615_i0	PRJNA602115	639	725	1.418675	10.28539375	Vagococcus fluvialis	2738	Bacteria	Bacteria	180	1.3799999999999999e-52	NR	WP_349738044.1	2738	g615	i0	66.2	0.562758620689655	136	40	53.8	1	392	3	1	136	WP_349738044.1 hypothetical protein [Vagococcus fluvialis]	diamond	408	180	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus fluvialis

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