metadata: contig_metadata: 25 rows where bioproject = "PRJNA602115" and tax

25 rows where 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
2418174	2418174	PRJNA602115_P_NODE_11122_length_203_cov_0.901408_g11097_i0	PRJNA602115	11122	203	0.901408	1.82985824	Cutibacterium	1912216	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11097	i0	100	51	203	0	100	0	1	203	1187493	1187695	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10353	375	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2418177	2418177	PRJNA602115_P_NODE_2142_length_408_cov_1.023055_g2117_i0	PRJNA602115	2142	408	1.023055	4.1740644	Cutibacterium	1912216	Bacteria	Bacteria	754	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2117	i0	100	300.303921568627	408	0	100	0	1	408	55601	56008	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	122524	754	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2418179	2418179	PRJNA602115_P_NODE_2782_length_362_cov_1.684385_g2757_i0	PRJNA602115	2782	362	1.684385	6.0974737	Mycobacteriaceae	1762	Bacteria	Bacteria	664	0	NTclustered	gi\|1935556990\|gb\|CP062008.1\|	1226753	g2757	i0	99.724	187.055248618785	362	1	100	0	1	362	1387858	1387497	Mycolicibacterium mucogenicum DSM 44124 chromosome, complete genome	blastn	67714	669	0.992526158445441	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mucogenicum
8229093	8229093	PRJNA602115_P_NODE_9887_length_206_cov_0.882759_g9862_i0	PRJNA602115	9887	206	0.882759	1.81848354	Williamsia herbipolensis	1603258	Bacteria	Bacteria	335	1.5999999999999997e-87	NTclustered	gi\|2658946156\|gb\|CP108021.1\|	1603258	g9862	i0	96.117	325.417475728155	206	7	100	1	1	206	3888	3684	Williamsia herbipolensis strain NBC_00319 chromosome, complete genome	blastn	67036	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia herbipolensis
9504244	9504244	PRJNA602115_P_NODE_9228_length_208_cov_0.870748_g9203_i0	PRJNA602115	9228	208	0.870748	1.81115584	Geodermatophilaceae bacterium NBWT11	2596920	Bacteria	Bacteria	219	1.7e-52	NTclustered	gi\|1891431189\|gb\|CP043652.1\|	2596920	g9203	i0	88.043	78.7596153846154	184	22	88	0	25	208	121409	121592	Geodermatophilaceae bacterium NBWT11 chromosome, complete genome	blastn	16382	219	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae		Geodermatophilaceae bacterium NBWT11
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
12621920	12621920	PRJNA602115_P_NODE_8770_length_209_cov_0.864865_g8745_i0	PRJNA602115	8770	209	0.864865	1.80756785	Actinomycetes	1760	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1021079766\|dbj\|AP017424.1\|	39478	g8745	i0	100	0.267942583732057	28	0	13	0	68	95	68121	68148	Streptomyces laurentii DNA, complete genome, strain: ATCC 31255	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces laurentii
17153300	17153300	PRJNA602115_P_NODE_10214_length_205_cov_0.888889_g10189_i0	PRJNA602115	10214	205	0.888889	1.82222245	Mycolicibacterium aubagnense	319707	Bacteria	Bacteria	350	5.669999999999999e-92	NTclustered	gi\|1806292234\|dbj\|AP022577.1\|	319707	g10189	i0	97.549	5.97073170731707	204	5	99	0	1	204	3328729	3328932	Mycolicibacterium aubagnense JCM 15296 DNA, complete genome	blastn	1224	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aubagnense
21544792	21544792	PRJNA602115_P_NODE_8477_length_213_cov_2.572368_g8452_i0	PRJNA602115	8477	213	2.572368	5.47914384	Exiguobacterium	33986	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g8452	i0	100	494.018779342723	213	0	100	0	1	213	40915	40703	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	105226	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
24801907	24801907	PRJNA602115_P_NODE_3500_length_327_cov_0.778195_g3475_i0	PRJNA602115	3500	327	0.778195	2.54469765	Corynebacterium matruchotii	43768	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g3475	i0	100	0.171253822629969	28	0	9	0	151	178	2042681	2042708	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
25369198	25369198	PRJNA602115_P_NODE_4000_length_309_cov_1.161290_g3975_i0	PRJNA602115	4000	309	1.16129	3.5883861	Mycobacteriaceae	1762	Bacteria	Bacteria	449	8.76e-122	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g3975	i0	92.903	155.145631067961	310	20	100	2	1	309	1313246	1312938	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	47940	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
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);;