metadata: contig_metadata: 30 rows where bioproject = "PRJNA796639" and tax

30 rows where bioproject = "PRJNA796639" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
7158942	7158942	PRJNA796639_P_NODE_6286_length_248_cov_0.880000_g6161_i0	PRJNA796639	6286	248	0.88	2.1824	Mycolicibacterium chitae	1792	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1806410789\|dbj\|AP022604.1\|	1792	g6161	i0	100	0.233870967741935	29	0	12	0	28	56	4866058	4866086	Mycolicibacterium chitae JCM 12403 DNA, nearly complete genome	blastn	58	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium chitae
9708761	9708761	PRJNA796639_P_NODE_6228_length_248_cov_0.880000_g6103_i0	PRJNA796639	6228	248	0.88	2.1824	uncultured Eubacteriales bacterium	172733	Bacteria	Bacteria	340	4.27e-89	NTclustered	gi\|2729058706\|emb\|OZ007006.1\|	172733	g6103	i0	91.498	8.96774193548387	247	21	99	0	1	247	7078	7324	MAG: uncultured Eubacteriales bacterium isolate metabat2_pooled_hifiasm.126 MAG genome assembly, chromosome: 1	blastn	2224	340	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			uncultured Eubacteriales bacterium
12260021	12260021	PRJNA796639_P_NODE_4810_length_268_cov_1.579487_g4685_i0	PRJNA796639	4810	268	1.579487	4.23302516	Apilactobacillus apisilvae	2923364	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2239972674\|gb\|CP093362.1\|	2923364	g4685	i0	100	0.108208955223881	29	0	11	0	72	100	96647	96619	Apilactobacillus apisilvae strain SG5_A10 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Apilactobacillus	Apilactobacillus apisilvae
12260064	12260064	PRJNA796639_P_NODE_7370_length_243_cov_0.905882_g7245_i0	PRJNA796639	7370	243	0.905882	2.20129326	Nocardioides sp. S5	2017486	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1999037722\|gb\|CP022296.1\|	2017486	g7245	i0	100	230.102880658436	243	0	100	0	1	243	1843263	1843505	Nocardioides sp. S5 chromosome, complete genome	blastn	55915	449	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S5
12696259	12696259	PRJNA796639_P_NODE_7830_length_241_cov_0.916667_g7705_i0	PRJNA796639	7830	241	0.916667	2.20916747	Peribacillus	2675229	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1906925978\|gb\|CP050509.1\|	421767	g7705	i0	99.585	1139.9377593361	241	1	100	0	1	241	5138452	5138692	Peribacillus butanolivorans strain KJ40 chromosome, complete genome	blastn	274725	440	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus butanolivorans
13534145	13534145	PRJNA796639_P_NODE_3431_length_304_cov_1.129870_g3306_i0	PRJNA796639	3431	304	1.12987	3.4348048	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g3306	i0	100	0.0921052631578947	28	0	9	0	254	281	995425	995398	Streptomyces sp. cg36 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36
14809083	14809083	PRJNA796639_P_NODE_5632_length_251_cov_0.865169_g5507_i0	PRJNA796639	5632	251	0.865169	2.17157419	Crocosphaera subtropica	2546360	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g5507	i0	100	0.111553784860558	28	0	11	0	24	51	2156137	2156164	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
16519500	16519500	PRJNA796639_P_NODE_1313_length_491_cov_1.031100_g1188_i0	PRJNA796639	1313	491	1.0311	5.062701	Cutibacterium	1912216	Bacteria	Bacteria	898	0	NTclustered	gi\|2548746222\|gb\|CP129004.1\|	1747	g1188	i0	99.594	270.720977596741	493	0	100	1	1	491	608443	608935	Cutibacterium acnes strain EASDk81B chromosome, complete genome	blastn	132924	898	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
19068301	19068301	PRJNA796639_P_NODE_4275_length_280_cov_1.681159_g4150_i0	PRJNA796639	4275	280	1.681159	4.7072452	Nocardioides	1839	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|1605178659\|gb\|CP038267.1\|	2518370	g4150	i0	98.929	235.482142857143	280	3	100	0	1	280	573651	573372	Nocardioides euryhalodurans strain MMS17-SY117 chromosome, complete genome	blastn	65935	501	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides euryhalodurans
24168233	24168233	PRJNA796639_P_NODE_5659_length_251_cov_0.865169_g5534_i0	PRJNA796639	5659	251	0.865169	2.17157419	Lactiplantibacillus	2767842	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2739944818\|emb\|OZ061355.1\|	1589	g5534	i0	100	480.358565737052	251	0	100	0	1	251	1279560	1279310	Lactiplantibacillus pentosus isolate Lactiplantibacillus pentosus CNRZ1547 genome assembly, chromosome: 1	blastn	120570	464	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus pentosus
25006969	25006969	PRJNA796639_P_NODE_6600_length_247_cov_0.885057_g6475_i0	PRJNA796639	6600	247	0.885057	2.18609079	Enterococcus faecalis	1351	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1963785894\|emb\|LR962464.1\|	1351	g6475	i0	100	100	247	0	100	0	1	247	2123226	2122980	Enterococcus faecalis isolate 28157_4#317 genome assembly, chromosome: 1	blastn	24700	457	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
25443370	25443370	PRJNA796639_P_NODE_1860_length_410_cov_2.323442_g1735_i0	PRJNA796639	1860	410	2.323442	9.5261122	Cutibacterium	1912216	Bacteria	Bacteria	758	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1735	i0	100	250.648780487805	410	0	100	0	1	410	55374	55783	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	102766	758	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
26705406	26705406	PRJNA796639_P_NODE_6141_length_249_cov_0.875000_g6016_i0	PRJNA796639	6141	249	0.875	2.17875	Streptomyces	1883	Bacteria	Bacteria	44.3	0.0102	NR	WP_126915786.1	1883	g6016	i0	40	0.602409638554217	50	28	60.2	2	97	246	35	82	WP_126915786.1 MULTISPECIES: prepilin peptidase [Streptomyces]	diamond	150	44.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
26958720	26958720	PRJNA796639_P_NODE_6062_length_249_cov_0.875000_g5937_i0	PRJNA796639	6062	249	0.875	2.17875	Jiangellaceae bacterium	2768363	Bacteria	Bacteria	45.4	0.00437	NR	HSI94084.1	2768363	g5937	i0	35.2	1.09638554216867	91	47	95.2	2	1	237	7	97	HSI94084.1 chorismate-binding protein [Jiangellaceae bacterium]	diamond	273	45.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Jiangellales	Jiangellaceae		Jiangellaceae bacterium
27022245	27022245	PRJNA796639_P_NODE_2822_length_335_cov_1.011450_g2697_i0	PRJNA796639	2822	335	1.01145	3.3883575	Cryptosporangium aurantiacum	134849	Bacteria	Bacteria	43.5	0.0449	NR	WP_073258352.1	134849	g2697	i0	37.5	0.501492537313433	56	31	46.6	1	170	325	34	89	WP_073258352.1 TIGR03089 family protein [Cryptosporangium aurantiacum]	diamond	168	43.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Cryptosporangiales	Cryptosporangiaceae	Cryptosporangium	Cryptosporangium aurantiacum
27085518	27085518	PRJNA796639_P_NODE_6402_length_247_cov_1.724138_g6277_i0	PRJNA796639	6402	247	1.724138	4.25862086	Clostridia bacterium	2044939	Bacteria	Bacteria	85.9	8.3e-18	NR	HML69499.1	2044939	g6277	i0	51.9	0.983805668016194	81	38	98.4	1	5	247	53	132	HML69499.1 nucleoside hydrolase [Clostridia bacterium]	diamond	243	85.9	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
27780531	27780531	PRJNA796639_P_NODE_5384_length_254_cov_1.386740_g5259_i0	PRJNA796639	5384	254	1.38674	3.5223196	Pseudonocardia nematodicida	1206997	Bacteria	Bacteria	43.5	0.0221	NR	WP_349300394.1	1206997	g5259	i0	33	1.14566929133858	97	50	96.9	2	252	7	210	306	WP_349300394.1 CynX/NimT family MFS transporter [Pseudonocardia nematodicida]	diamond	291	43.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia nematodicida
28096114	28096114	PRJNA796639_P_NODE_4865_length_267_cov_1.319588_g4740_i0	PRJNA796639	4865	267	1.319588	3.52329996	Synechococcus sp. Nb3U1	1914529	Bacteria	Bacteria	43.9	0.0159	NR	WP_235278608.1	1914529	g4740	i0	39.7	0.820224719101124	73	36	73	3	55	249	67	139	WP_235278608.1 hypothetical protein [Synechococcus sp. Nb3U1]	diamond	219	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. Nb3U1
28222259	28222259	PRJNA796639_P_NODE_7306_length_243_cov_0.905882_g7181_i0	PRJNA796639	7306	243	0.905882	2.20129326	Clostridium sp.	1506	Bacteria	Bacteria	41.6	0.0371	NR	MDR0964144.1	1506	g7181	i0	44.4	0.333333333333333	27	15	33.3	0	53	133	4	30	MDR0964144.1 hypothetical protein [Clostridium sp.]	diamond	81	41.6	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
28380264	28380264	PRJNA796639_P_NODE_6166_length_248_cov_2.514286_g6041_i0	PRJNA796639	6166	248	2.514286	6.23542928	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	45.4	0.00441	NR	HKA49911.1	2052315	g6041	i0	47.1	0.616935483870968	51	25	59.3	1	182	36	63	113	HKA49911.1 hypothetical protein [Candidatus Dormiibacterota bacterium]	diamond	153	45.4	1	Bacteria		Bacillati	Candidatus Dormiibacterota					Candidatus Dormiibacterota bacterium
28506613	28506613	PRJNA796639_P_NODE_6607_length_247_cov_0.879310_g6482_i0	PRJNA796639	6607	247	0.87931	2.1718957	Nonomuraea helvata	37484	Bacteria	Bacteria	47	4.26e-4	NR	WP_344984142.1	37484	g6482	i0	40.9	0.801619433198381	66	38	80.2	1	45	242	38	102	WP_344984142.1 hypothetical protein [Nonomuraea helvata]	diamond	198	47	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea helvata
28664529	28664529	PRJNA796639_P_NODE_5507_length_251_cov_0.887640_g5382_i0	PRJNA796639	5507	251	0.88764	2.2279764	Leifsonia sp. TF	1870902	Bacteria	Bacteria	44.7	0.00829	NR	WP_208040632.1	2815212	g5382	i0	45.6	0.681274900398406	57	26	66.9	2	218	51	115	167	WP_208040632.1 sensor histidine kinase [Leifsonia sp. TF02-11]	diamond	171	44.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
30622403	30622403	PRJNA796639_P_NODE_3873_length_289_cov_1.120370_g3748_i0	PRJNA796639	3873	289	1.12037	3.2378693	Bifidobacteriaceae bacterium	2291324	Bacteria	Bacteria	43.1	0.042	NR	MDR1153033.1	2291324	g3748	i0	39.4	0.737024221453287	71	41	71.6	1	21	227	94	164	MDR1153033.1 hypothetical protein [Bifidobacteriaceae bacterium]	diamond	213	43.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae		Bifidobacteriaceae bacterium
31222673	31222673	PRJNA796639_P_NODE_6455_length_247_cov_0.885057_g6330_i0	PRJNA796639	6455	247	0.885057	2.18609079	Mycobacterium bohemicum	56425	Bacteria	Bacteria	171	4.81e-49	NR	ORV00101.1	56425	g6330	i0	98.8	1.96761133603239	81	1	98.4	0	246	4	55	135	ORV00101.1 hypothetical protein AWB93_09720 [Mycobacterium bohemicum]	diamond	486	171	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium bohemicum
31539312	31539312	PRJNA796639_P_NODE_2356_length_365_cov_1.054795_g2231_i0	PRJNA796639	2356	365	1.054795	3.85000175	Sphaerisporangium album	509200	Bacteria	Bacteria	78.2	3.7e-14	NR	WP_114033542.1	509200	g2231	i0	38.3	3.81369863013699	120	62	94.5	3	346	2	30	142	WP_114033542.1 cellulose binding domain-containing protein [Sphaerisporangium album]	diamond	1392	78.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Sphaerisporangium	Sphaerisporangium album
31823718	31823718	PRJNA796639_P_NODE_4297_length_280_cov_1.246377_g4172_i0	PRJNA796639	4297	280	1.246377	3.4898556	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.9	0.0197	NR	MFQ5933018.1	2026734	g4172	i0	34.7	0.771428571428571	72	40	77.1	2	249	34	69	133	MFQ5933018.1 phosphatase PAP2 family protein [Dehalococcoidia bacterium]	diamond	216	43.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31855413	31855413	PRJNA796639_P_NODE_5517_length_251_cov_0.865169_g5392_i0	PRJNA796639	5517	251	0.865169	2.17157419	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	159	1.97e-43	NR	MBQ3252338.1	2485925	g5392	i0	94	6.94422310756972	83	5	99.2	0	2	250	131	213	MBQ3252338.1 glutamine synthetase III [Oscillospiraceae bacterium]	diamond	1743	159	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32425069	32425069	PRJNA796639_P_NODE_7279_length_243_cov_1.500000_g7154_i0	PRJNA796639	7279	243	1.5	3.645	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.7	0.0072	NR	MFN6337432.1	2847862	g7154	i0	41.5	0.506172839506173	41	23	49.4	1	5	124	92	132	MFN6337432.1 4a-hydroxytetrahydrobiopterin dehydratase [Cyanobacteriota bacterium]	diamond	123	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32456841	32456841	PRJNA796639_P_NODE_6459_length_247_cov_0.885057_g6334_i0	PRJNA796639	6459	247	0.885057	2.18609079	Caldilinea sp.	2293560	Bacteria	Bacteria	43.5	0.0177	NR	MFO7631691.1	2293560	g6334	i0	42.4	0.801619433198381	66	34	80.2	2	227	30	5	66	MFO7631691.1 A24 family peptidase [Caldilinea sp.]	diamond	198	43.5	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp.
32456842	32456842	PRJNA796639_P_NODE_7519_length_242_cov_0.911243_g7394_i0	PRJNA796639	7519	242	0.911243	2.20520806	Dermatophilaceae bacterium	2728912	Bacteria	Bacteria	43.9	0.0147	NR	HEY5179339.1	2728912	g7394	i0	45.8	0.731404958677686	59	24	70.7	2	32	202	1129	1181	HEY5179339.1 MobF family relaxase [Dermatophilaceae bacterium]	diamond	177	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae		Dermatophilaceae 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);;