metadata: contig_metadata: 22 rows where bioproject = "PRJNA951388" and tax

22 rows where bioproject = "PRJNA951388" 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
3814793	3814793	PRJNA951388_S_NODE_10503_length_254_cov_2.232044_g10376_i0	PRJNA951388	10503	254	2.232044	5.66939176	Paenibacillus	44249	Bacteria	Bacteria	451	1.95e-122	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g10376	i0	98.819	4.97637795275591	254	2	100	1	1	254	3891529	3891781	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1264	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
5091099	5091099	PRJNA951388_S_NODE_6004_length_346_cov_1.974359_g5877_i0	PRJNA951388	6004	346	1.974359	6.83128214	Paenibacillus	44249	Bacteria	Bacteria	623	5.529999999999999e-174	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g5877	i0	99.133	5	346	3	100	0	1	346	1480794	1481139	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1730	623	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
6037878	6037878	PRJNA951388_S_NODE_11765_length_235_cov_3.783951_g11638_i0	PRJNA951388	11765	235	3.783951	8.89228485	Staphylococcus cohnii	29382	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g11638	i0	100	99.2255319148936	235	0	100	0	1	235	538828	538594	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	23318	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
6366800	6366800	PRJNA951388_S_NODE_10925_length_248_cov_1.245714_g10798_i0	PRJNA951388	10925	248	1.245714	3.08937072	Bacillales	1385	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g10798	i0	100	471.778225806452	248	0	100	0	1	248	771518	771765	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	117001	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
11138416	11138416	PRJNA951388_S_NODE_9969_length_262_cov_1.201058_g9842_i0	PRJNA951388	9969	262	1.201058	3.14677196	Paenibacillus glucanolyticus	59843	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g9842	i0	100	5	262	0	100	0	1	262	3900129	3900390	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	1310	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
12413860	12413860	PRJNA951388_S_NODE_7950_length_300_cov_1.356828_g7823_i0	PRJNA951388	7950	300	1.356828	4.070484	Dolosigranulum pigrum	29394	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|2020672664\|gb\|CP040417.1\|	29394	g7823	i0	100	25	300	0	100	0	1	300	1749628	1749329	Dolosigranulum pigrum strain KPL3077 chromosome	blastn	7500	555	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
12413866	12413866	PRJNA951388_S_NODE_9710_length_266_cov_1.797927_g9583_i0	PRJNA951388	9710	266	1.797927	4.78248582	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	486	5.629999999999999e-133	NTclustered	gi\|2094528057\|gb\|CP065376.1\|	853	g9583	i0	99.624	374.65037593985	266	1	100	0	1	266	1907144	1907409	Faecalibacterium prausnitzii strain Fp360 chromosome, complete genome	blastn	99657	486	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
13688414	13688414	PRJNA951388_S_NODE_7631_length_307_cov_2.303419_g7504_i0	PRJNA951388	7631	307	2.303419	7.07149633	Mammaliicoccus stepanovicii	643214	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1231729876\|emb\|LT906462.1\|	643214	g7504	i0	94.286	0.11400651465798	35	1	11	1	108	142	1704667	1704700	Staphylococcus stepanovicii strain NCTC13839 genome assembly, chromosome: 1	blastn	35	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus stepanovicii
16565290	16565290	PRJNA951388_S_NODE_6633_length_330_cov_1.354086_g6506_i0	PRJNA951388	6633	330	1.354086	4.4684838	Streptococcus	1301	Bacteria	Bacteria	610	4.09e-170	NTclustered	gi\|2288405307\|gb\|CP076703.1\|	1335	g6506	i0	100	538.990909090909	330	0	100	0	1	330	19075	19404	Streptococcus equinus strain S1 chromosome, complete genome	blastn	177867	610	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
17512877	17512877	PRJNA951388_S_NODE_13054_length_204_cov_23.015267_g12927_i0	PRJNA951388	13054	204	23.015267	46.95114468	Caloranaerobacter azorensis	116090	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1810187734\|gb\|CP048617.1\|	116090	g12927	i0	100	0.142156862745098	29	0	14	0	47	75	1707585	1707613	Caloranaerobacter azorensis strain T3-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Thermohalobacteraceae	Caloranaerobacter	Caloranaerobacter azorensis
19114105	19114105	PRJNA951388_S_NODE_7635_length_307_cov_1.970085_g7508_i0	PRJNA951388	7635	307	1.970085	6.04816095	Staphylococcus	1279	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|2521904872\|gb\|CP127705.1\|	1280	g7508	i0	100	506.026058631922	307	0	100	0	1	307	2019802	2020108	Staphylococcus aureus strain C351 chromosome, complete genome	blastn	155350	568	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
21336811	21336811	PRJNA951388_S_NODE_11037_length_246_cov_3.115607_g10910_i0	PRJNA951388	11037	246	3.115607	7.66439322	Caproiciproducens sp. CPB-2	3030017	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2663189403\|gb\|CP142860.1\|	3030017	g10910	i0	100	0.121951219512195	30	0	12	0	67	96	1892626	1892655	Caproiciproducens sp. CPB-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae	Caproiciproducens	Caproiciproducens sp. CPB-2
22940511	22940511	PRJNA951388_S_NODE_5498_length_360_cov_3.473868_g5371_i0	PRJNA951388	5498	360	3.473868	12.5059248	Paenibacillus	44249	Bacteria	Bacteria	654	0	NTclustered	gi\|2700521045\|gb\|CP147845.1\|	59843	g5371	i0	99.444	13.7638888888889	360	2	100	0	1	360	4099727	4100086	Paenibacillus glucanolyticus strain GlSt238 chromosome, complete genome	blastn	4955	654	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
27474541	27474541	PRJNA951388_S_NODE_10103_length_260_cov_1.390374_g9976_i0	PRJNA951388	10103	260	1.390374	3.6149724	root	1	Root_unresolved	Root_unresolved	81.6	5.62e-16	NR	ACV20892.1	1396	g9976	i0	74.2	3.04615384615385	66	17	76.2	0	19	216	107	172	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	792	81.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
27664190	27664190	PRJNA951388_S_NODE_4144_length_403_cov_3.696970_g4017_i0	PRJNA951388	4144	403	3.69697	14.8987891	Bacteria	2	Bacteria	Bacteria	58.9	4.18e-7	NR	WP_021800335.1	36845	g4017	i0	34.5	4.68982630272953	113	73	84.1	1	3	341	277	388	WP_021800335.1 threonine ammonia-lyase [Clostridium intestinale]	diamond	1890	58.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium intestinale
27822071	27822071	PRJNA951388_S_NODE_11284_length_243_cov_2.264706_g11157_i0	PRJNA951388	11284	243	2.264706	5.50323558	root	1	Root_unresolved	Root_unresolved	61.2	1.06e-8	NR	ACV20892.1	1396	g11157	i0	54.4	4.76543209876543	79	36	97.5	0	1	237	153	231	ACV20892.1 enhanced green fluorescent protein [Bacillus cereus]	diamond	1158	61.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
28573050	28573050	PRJNA951388_S_NODE_5487_length_360_cov_5.540070_g5360_i0	PRJNA951388	5487	360	5.54007	19.944252	Salinibacillus aidingensis	237684	Bacteria	Bacteria	44.3	0.0379	NR	WP_343844082.1	237684	g5360	i0	28.9	0.75	90	55	71.7	3	3	260	394	478	WP_343844082.1 hypothetical protein [Salinibacillus aidingensis]	diamond	270	44.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salinibacillus	Salinibacillus aidingensis
30405145	30405145	PRJNA951388_S_NODE_1933_length_519_cov_7.130045_g1810_i0	PRJNA951388	1933	519	7.130045	37.00493355	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	78.2	1.37e-13	NR	MBO5113168.1	1898203	g1810	i0	46.7	3.65895953757225	92	46	51.4	1	518	252	222	313	MBO5113168.1 DnaJ domain-containing protein [Lachnospiraceae bacterium]	diamond	1899	78.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30910416	30910416	PRJNA951388_S_NODE_2434_length_482_cov_8.092910_g2308_i0	PRJNA951388	2434	482	8.09291	39.0078262	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	88.2	2.28e-19	NR	MBQ5561215.1	1898203	g2308	i0	40.7	1.1701244813278	86	51	53.5	0	322	65	16	101	MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium]	diamond	564	88.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
31352843	31352843	PRJNA951388_S_NODE_9456_length_271_cov_1.555556_g9329_i0	PRJNA951388	9456	271	1.555556	4.21555676	Acutalibacteraceae bacterium	3077420	Bacteria	Bacteria	189	4.5399999999999995e-57	NR	MEE1353258.1	3077420	g9329	i0	100	0.996309963099631	90	0	99.6	0	271	2	57	146	MEE1353258.1 nickel insertion protein [Acutalibacteraceae bacterium]	diamond	270	189	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae		Acutalibacteraceae bacterium
31890424	31890424	PRJNA951388_S_NODE_2897_length_456_cov_2.355091_g2770_i0	PRJNA951388	2897	456	2.355091	10.73921496	Allobacillus	1400133	Bacteria	Bacteria	46.6	0.0148	NR	WP_186279493.1	1400133	g2770	i0	37	0.480263157894737	73	42	45.4	1	182	388	4	76	WP_186279493.1 MULTISPECIES: ATP-dependent DNA helicase DinG [Allobacillus]	diamond	219	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Allobacillus
32245420	32245420	PRJNA951388_S_NODE_6118_length_343_cov_2.777778_g5991_i0	PRJNA951388	6118	343	2.777778	9.52777854	root	1	Root_unresolved	Root_unresolved	58.5	3.01e-7	NR	WP_013859697.1	1398	g5991	i0	43.3	3.6997084548105	97	27	83.1	2	341	57	35	105	WP_013859697.1 molecular chaperone DnaJ [Heyndrickxia coagulans]	diamond	1269	58.9	0.99320882852292	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia coagulans

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