metadata: contig_metadata: 31 rows where bioproject = "PRJNA1089179" and tax

31 rows where bioproject = "PRJNA1089179" 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
194873	194873	PRJNA1089179_P_NODE_17861_length_230_cov_2.242038_g17843_i0	PRJNA1089179	17861	230	2.242038	5.1566874	Alkalihalobacterium alkalinitrilicum	427920	Bacteria	Bacteria	124	2.76e-32	NR	WP_078428490.1	427920	g17843	i0	76.3	2.94782608695652	76	18	99.1	0	1	228	260	335	WP_078428490.1 prephenate dehydrogenase [Alkalihalobacterium alkalinitrilicum]	diamond	678	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium alkalinitrilicum
1469403	1469403	PRJNA1089179_P_NODE_11922_length_272_cov_53.914573_g11904_i0	PRJNA1089179	11922	272	53.914573	146.64763856	Evansella sp. LMS18	2924033	Bacteria	Bacteria	294	3.76e-75	NTclustered	gi\|2273830600\|gb\|CP093301.1\|	2924033	g11904	i0	89.121	726.669117647059	239	22	87	4	19	255	912878	913114	Evansella sp. LMS18 chromosome, complete genome	blastn	197654	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella sp. LMS18
1469425	1469425	PRJNA1089179_P_NODE_17442_length_240_cov_2.155689_g17424_i0	PRJNA1089179	17442	240	2.155689	5.1736536	Exiguobacterium acetylicum	41170	Bacteria	Bacteria	427	3.07e-115	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g17424	i0	98.75	11.1708333333333	240	3	100	0	1	240	990180	989941	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	2681	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
9122426	9122426	PRJNA1089179_P_NODE_17088_length_241_cov_30.333333_g17070_i0	PRJNA1089179	17088	241	30.333333	73.10333253	Streptococcus oralis	1303	Bacteria	Bacteria	335	1.9199999999999993e-87	NTclustered	gi\|1878156058\|gb\|CP054135.1\|	1891914	g17070	i0	96.985	19.8091286307054	199	6	83	0	22	220	1910731	1910533	Streptococcus oralis subsp. oralis strain ATCC 10557 chromosome	blastn	4774	335	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11220973	11220973	PRJNA1089179_P_NODE_12289_length_269_cov_2.576531_g12271_i0	PRJNA1089179	12289	269	2.576531	6.93086839	Lottiidibacillus patelloidae	2670334	Bacteria	Bacteria	132	5.24e-34	NR	WP_094923241.1	2670334	g12271	i0	71.9	2.97769516728625	89	25	99.3	0	1	267	158	246	WP_094923241.1 DNA polymerase/3'-5' exonuclease PolX [Lottiidibacillus patelloidae]	diamond	801	132	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lottiidibacillus	Lottiidibacillus patelloidae
11673507	11673507	PRJNA1089179_P_NODE_9330_length_300_cov_2.343612_g9312_i0	PRJNA1089179	9330	300	2.343612	7.030836	Acetivibrio saccincola	1677857	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1315080541\|gb\|CP025197.1\|	1677857	g9312	i0	100	0.0966666666666667	29	0	10	0	231	259	884049	884077	Acetivibrio saccincola strain GGR1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Acetivibrio	Acetivibrio saccincola
12948481	12948481	PRJNA1089179_P_NODE_17331_length_241_cov_0.916667_g17313_i0	PRJNA1089179	17331	241	0.916667	2.20916747	Peribacillus deserti	673318	Bacteria	Bacteria	124	1.5299999999999998e-32	NR	WP_101641096.1	673318	g17313	i0	79.7	2.76348547717842	74	15	92.1	0	222	1	1	74	WP_101641096.1 manganese-dependent inorganic pyrophosphatase [Peribacillus deserti]	diamond	666	124	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus deserti
13770912	13770912	PRJNA1089179_P_NODE_8311_length_314_cov_48.041494_g8293_i0	PRJNA1089179	8311	314	48.041494	150.85029116	Clostridium	1485	Bacteria	Bacteria	388	1.97e-103	NTclustered	gi\|301051484\|gb\|FJ546745.1\|	1550	g8293	i0	92.058	736.245222929936	277	21	88	1	25	300	337	613	Clostridium subterminale strain DSM 758 23S ribosomal RNA gene, partial sequence	blastn	231181	388	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium subterminale
16771784	16771784	PRJNA1089179_P_NODE_12434_length_268_cov_1.579487_g12416_i0	PRJNA1089179	12434	268	1.579487	4.23302516	Roseburia rectibacter	2763062	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2206258461\|gb\|CP092473.1\|	2763062	g12416	i0	96.97	0.123134328358209	33	1	12	0	210	242	2892630	2892662	Roseburia rectibacter strain NSJ-69 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia rectibacter
18046529	18046529	PRJNA1089179_P_NODE_17975_length_227_cov_13.461039_g17957_i0	PRJNA1089179	17975	227	13.461039	30.55655853	Clostridium thermarum	1716543	Bacteria	Bacteria	209	1.13e-49	NTclustered	gi\|1685740129\|gb\|CP040924.1\|	1716543	g17957	i0	91.083	27.0660792951542	157	11	68	3	53	207	13128	12973	Clostridium thermarum strain SYSU GA15002 chromosome, complete genome	blastn	6144	209	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium thermarum
23146989	23146989	PRJNA1089179_P_NODE_17699_length_234_cov_2.229814_g17681_i0	PRJNA1089179	17699	234	2.229814	5.21776476	Streptococcus sanguinis	1305	Bacteria	Bacteria	329	8.65e-86	NTclustered	gi\|1864132248\|gb\|CP040556.1\|	1305	g17681	i0	92.241	7.88461538461539	232	18	99	0	3	234	463782	464013	Streptococcus sanguinis strain CGMH010 chromosome, complete genome	blastn	1845	329	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
24420646	24420646	PRJNA1089179_P_NODE_10280_length_289_cov_1.425926_g10262_i0	PRJNA1089179	10280	289	1.425926	4.12092614	Weissella cibaria	137591	Bacteria	Bacteria	507	4.75e-139	NTclustered	gi\|2435979498\|gb\|CP116385.1\|	137591	g10262	i0	98.27	19	289	5	100	0	1	289	433060	432772	Weissella cibaria strain BAL3C-5 C120T chromosome, complete genome	blastn	5491	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
28417130	28417130	PRJNA1089179_P_NODE_13526_length_258_cov_2.113514_g13508_i0	PRJNA1089179	13526	258	2.113514	5.45286612	Bacillales	1385	Bacteria	Bacteria	72.8	3.15e-14	NR	WP_129077873.1	1548597	g13508	i0	77.3	1.53488372093023	44	10	51.2	0	257	126	78	121	WP_129077873.1 response regulator [Anaerobacillus alkaliphilus]	diamond	396	72.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Anaerobacillus	Anaerobacillus alkaliphilus
28646687	28646687	PRJNA1089179_P_NODE_6707_length_342_cov_0.925651_g6689_i0	PRJNA1089179	6707	342	0.925651	3.16572642	Bacillota bacterium	1879010	Bacteria	Bacteria	166	4.5099999999999985e-47	NR	MDP4157745.1	1879010	g6689	i0	74.6	2	114	29	100	0	1	342	195	308	MDP4157745.1 IS5 family transposase [Bacillota bacterium]	diamond	684	166	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
28678319	28678319	PRJNA1089179_P_NODE_8087_length_318_cov_1.277551_g8069_i0	PRJNA1089179	8087	318	1.277551	4.06261218	Anaerovoracaceae bacterium	3030912	Bacteria	Bacteria	69.3	2.9099999999999998e-11	NR	HKK96156.1	3030912	g8069	i0	61.2	1.38679245283019	49	19	46.2	0	317	171	280	328	HKK96156.1 DDE-type integrase/transposase/recombinase [Anaerovoracaceae bacterium]	diamond	441	69.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		Anaerovoracaceae bacterium
28953962	28953962	PRJNA1089179_P_NODE_14228_length_252_cov_1.290503_g14210_i0	PRJNA1089179	14228	252	1.290503	3.25206756	FCB group	1783270	Bacteria	Bacteria	112	1.55e-28	NR	WP_126809147.1	180344	g14210	i0	79	11.1904761904762	62	13	73.8	0	3	188	176	237	WP_126809147.1 MIP/aquaporin family protein [Vagococcus elongatus]	diamond	2820	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus elongatus
29057146	29057146	PRJNA1089179_P_NODE_15028_length_249_cov_0.875000_g15010_i0	PRJNA1089179	15028	249	0.875	2.17875	Serpentinicella alkaliphila	1734049	Bacteria	Bacteria	70.1	9.02e-12	NR	WP_132847831.1	1734049	g15010	i0	42.7	0.903614457831325	75	43	90.4	0	3	227	210	284	WP_132847831.1 protease complex subunit PrcB family protein [Serpentinicella alkaliphila]	diamond	225	70.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Natronincolaceae	Serpentinicella	Serpentinicella alkaliphila
29183518	29183518	PRJNA1089179_P_NODE_15309_length_248_cov_0.880000_g15291_i0	PRJNA1089179	15309	248	0.88	2.1824	Shouchella clausii	79880	Bacteria	Bacteria	93.2	2.64e-20	NR	WP_216924262.1	79880	g15291	i0	67.7	1.51209677419355	62	20	75	0	3	188	299	360	WP_216924262.1 polysaccharide pyruvyl transferase family protein [Shouchella clausii]	diamond	375	93.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Shouchella	Shouchella clausii
29215137	29215137	PRJNA1089179_P_NODE_11349_length_278_cov_1.980488_g11331_i0	PRJNA1089179	11349	278	1.980488	5.50575664	Alkalihalobacterium chitinilyticum	2980103	Bacteria	Bacteria	86.7	2.09e-17	NR	WP_275120141.1	2980103	g11331	i0	51.1	0.992805755395683	92	45	99.3	0	277	2	167	258	WP_275120141.1 chemotaxis protein CheW [Alkalihalobacterium chitinilyticum]	diamond	276	86.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium chitinilyticum
29553405	29553405	PRJNA1089179_P_NODE_2510_length_495_cov_1.876777_g2492_i0	PRJNA1089179	2510	495	1.876777	9.29004615	root	1	Root_unresolved	Root_unresolved	72	1.94e-13	NR	CDC16701.1	1262960	g2492	i0	82.5	5.15151515151515	40	7	24.2	0	134	253	24	63	CDC16701.1 pyruvate phosphate dikinase [Ruminococcus sp. CAG:55]	diamond	2550	72	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. CAG:55
30130365	30130365	PRJNA1089179_P_NODE_17732_length_233_cov_2.450000_g17714_i0	PRJNA1089179	17732	233	2.45	5.7085	Alkalihalobacterium chitinilyticum	2980103	Bacteria	Bacteria	129	3.0299999999999995e-35	NR	WP_275120864.1	2980103	g17714	i0	81.3	0.965665236051502	75	14	96.6	0	227	3	108	182	WP_275120864.1 HAD family hydrolase [Alkalihalobacterium chitinilyticum]	diamond	225	129	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium chitinilyticum
30257447	30257447	PRJNA1089179_P_NODE_15752_length_246_cov_0.890173_g15734_i0	PRJNA1089179	15752	246	0.890173	2.18982558	Clostridia bacterium	2044939	Bacteria	Bacteria	108	4.83e-26	NR	MDD4111389.1	2044939	g15734	i0	60.5	0.98780487804878	81	32	98.8	0	3	245	74	154	MDD4111389.1 glycosyltransferase family 4 protein [Clostridia bacterium]	diamond	243	108	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
30312209	30312209	PRJNA1089179_P_NODE_12472_length_268_cov_1.184615_g12454_i0	PRJNA1089179	12472	268	1.184615	3.1747682	Bacillaceae	186817	Bacteria	Bacteria	56.2	3.33e-8	NR	WP_075388401.1	427920	g12454	i0	82.4	1.5	34	6	38.1	0	2	103	37	70	WP_075388401.1 hypothetical protein [Alkalihalobacterium alkalinitrilicum]	diamond	402	56.6	0.992932862190813	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium alkalinitrilicum
30880377	30880377	PRJNA1089179_P_NODE_13454_length_259_cov_1.279570_g13436_i0	PRJNA1089179	13454	259	1.27957	3.3140863	Bacteria	2	Bacteria	Bacteria	61.6	2.89e-10	NR	WP_369675335.1	1352	g13436	i0	86.7	1.41312741312741	30	3	33.6	1	259	173	48	77	WP_369675335.1 DUF3551 domain-containing protein, partial [Enterococcus faecium]	diamond	366	61.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
31047302	31047302	PRJNA1089179_P_NODE_6355_length_349_cov_1.000000_g6337_i0	PRJNA1089179	6355	349	1	3.49	Streptococcus anginosus SK52 = DSM 2	1000570	Bacteria	Bacteria	42.4	0.0213	NR	GAD37668.1	1000570	g6337	i0	43.6	0.472779369627507	55	27	43.8	1	195	347	8	62	GAD37668.1 hypothetical protein ANG1_1855 [Streptococcus anginosus SK52 = DSM 20563]	diamond	165	42.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
31173038	31173038	PRJNA1089179_P_NODE_15755_length_246_cov_0.890173_g15737_i0	PRJNA1089179	15755	246	0.890173	2.18982558	Desertibacillus haloalkaliphilus	1328930	Bacteria	Bacteria	60.5	1.34e-8	NR	WP_217227709.1	1328930	g15737	i0	58	0.609756097560976	50	20	61	1	1	150	205	253	WP_217227709.1 siderophore-iron reductase FhuF [Desertibacillus haloalkaliphilus]	diamond	150	60.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Desertibacillus	Desertibacillus haloalkaliphilus
31204531	31204531	PRJNA1089179_P_NODE_15495_length_247_cov_0.885057_g15477_i0	PRJNA1089179	15495	247	0.885057	2.18609079	Alkalihalobacterium chitinilyticum	2980103	Bacteria	Bacteria	55.1	1.76e-6	NR	WP_275119600.1	2980103	g15477	i0	67.1	0.995951417004049	82	27	99.6	0	246	1	247	328	WP_275119600.1 methyl-accepting chemotaxis protein [Alkalihalobacterium chitinilyticum]	diamond	246	55.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium chitinilyticum
31797119	31797119	PRJNA1089179_P_NODE_17177_length_241_cov_1.464286_g17159_i0	PRJNA1089179	17177	241	1.464286	3.52892926	Alkalihalobacterium	2893050	Bacteria	Bacteria	134	2.67e-34	NR	WP_078428997.1	427920	g17159	i0	87.3	4.95435684647303	79	10	98.3	0	240	4	152	230	WP_078428997.1 transglycosylase domain-containing protein [Alkalihalobacterium alkalinitrilicum]	diamond	1194	134	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium alkalinitrilicum
31995798	31995798	PRJNA1089179_P_NODE_12538_length_267_cov_1.587629_g12520_i0	PRJNA1089179	12538	267	1.587629	4.23896943	Massilistercora timonensis	2086584	Bacteria	Bacteria	45.8	0.00158	NR	WP_106790073.1	2086584	g12520	i0	41.2	0.573033707865168	51	30	57.3	0	174	22	31	81	WP_106790073.1 DMT family transporter [Massilistercora timonensis]	diamond	153	45.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Massilistercora	Massilistercora timonensis
32208675	32208675	PRJNA1089179_P_NODE_15518_length_247_cov_0.885057_g15500_i0	PRJNA1089179	15518	247	0.885057	2.18609079	Bacillaceae	186817	Bacteria	Bacteria	46.6	0.00176	NR	WP_158211661.1	427920	g15500	i0	37.7	2.50202429149798	69	43	83.8	0	208	2	311	379	WP_158211661.1 ATP-binding protein [Alkalihalobacterium alkalinitrilicum]	diamond	618	46.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium alkalinitrilicum
32344050	32344050	PRJNA1089179_P_NODE_13359_length_260_cov_1.197861_g13341_i0	PRJNA1089179	13359	260	1.197861	3.1144386	Bacillus alkalicellulosilyticus	1912214	Bacteria	Bacteria	112	1.02e-26	NR	WP_078552823.1	1912214	g13341	i0	64	1.98461538461538	86	31	99.2	0	259	2	269	354	WP_078552823.1 peptidoglycan D,D-transpeptidase FtsI family protein [Bacillus alkalicellulosilyticus]	diamond	516	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Alkalihalobacterium	Alkalihalobacterium alkalicellulosilyticum

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