metadata: contig_metadata: 26 rows where bioproject = "PRJNA326068" and tax

26 rows where bioproject = "PRJNA326068" 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
1069209	1069209	PRJNA326068_P_NODE_2481_length_695_cov_11.079580_g1907_i0	PRJNA326068	2481	695	11.07958	77.003081	Staphylococcus	1279	Bacteria	Bacteria	1205	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1907	i0	98.121	485.925179856115	692	12	99	1	1	692	2277928	2278618	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	337718	1205	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
1069214	1069214	PRJNA326068_P_NODE_4861_length_500_cov_97.611465_g4053_i0	PRJNA326068	4861	500	97.611465	488.057325	Streptococcus	1301	Bacteria	Bacteria	924	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g4053	i0	100	345.072	500	0	100	0	1	500	1571094	1571593	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	172536	924	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
1664171	1664171	PRJNA326068_P_NODE_8522_length_355_cov_17.530675_g7573_i0	PRJNA326068	8522	355	17.530675	62.23389625	Streptococcus australis	113107	Bacteria	Bacteria	405	2.24e-108	NTclustered	gi\|1654236162\|emb\|LR594040.1\|	113107	g7573	i0	92.014	279.208450704225	288	23	81	0	1	288	19513	19800	Streptococcus australis strain NCTC5338 genome assembly, chromosome: 1	blastn	99119	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus australis
2344452	2344452	PRJNA326068_P_NODE_1222_length_950_cov_23.391965_g874_i0	PRJNA326068	1222	950	23.391965	222.2236675	Streptococcus	1301	Bacteria	Bacteria	1262	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g874	i0	97.074	339.425263157895	752	17	99	4	1	750	1570710	1569962	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	322454	1264	0.998417721518987	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
3619868	3619868	PRJNA326068_P_NODE_2483_length_695_cov_10.953453_g1909_i0	PRJNA326068	2483	695	10.953453	76.12649835	Staphylococcus	1279	Bacteria	Bacteria	1216	0	NTclustered	gi\|1700448853\|gb\|MK015782.1\|	28035	g1909	i0	98.41	453.211510791367	692	10	99	1	4	695	2931	3621	Staphylococcus lugdunensis strain PL447 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	314982	1216	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lugdunensis
5492953	5492953	PRJNA326068_P_NODE_15145_length_218_cov_41.275132_g14182_i0	PRJNA326068	15145	218	41.275132	89.97978776	Streptococcus thermophilus	1308	Bacteria	Bacteria	370	4.68e-98	NTclustered	gi\|2793135482\|gb\|CP072428.1\|	1308	g14182	i0	97.248	367.009174311927	218	6	100	0	1	218	1654416	1654199	Streptococcus thermophilus strain S24749 chromosome, complete genome	blastn	80008	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
7447055	7447055	PRJNA326068_P_NODE_10306_length_309_cov_6.496429_g9346_i0	PRJNA326068	10306	309	6.496429	20.07396561	Neobacillus	2675232	Bacteria	Bacteria	455	1.88e-123	NTclustered	gi\|2182427223\|gb\|CP091110.1\|	220684	g9346	i0	93.226	1117.26213592233	310	19	100	2	1	309	15668	15360	Neobacillus drentensis strain JC05 chromosome, complete genome	blastn	345234	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus drentensis
7447063	7447063	PRJNA326068_P_NODE_13426_length_243_cov_10.518692_g12463_i0	PRJNA326068	13426	243	10.518692	25.56042156	Bacteria	2	Bacteria	Bacteria	99	2.77e-16	NTclustered	gi\|288511\|emb\|X68428.1\|	2741	g12463	i0	84.314	51.0082304526749	102	15	42	1	142	243	1569	1669	P.niger gene for 23S rRNA	blastn	12395	100	0.99	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae	Peptococcus	Peptococcus niger
8721747	8721747	PRJNA326068_P_NODE_19507_length_157_cov_6.132812_g18544_i0	PRJNA326068	19507	157	6.132812	9.62851484	Bacillati	1783272	Bacteria	Bacteria	226	7.209999999999998e-55	NTclustered	gi\|1778011102\|emb\|LR735421.1\|	1282	g18544	i0	94.521	462.515923566879	146	8	93	0	1	146	973144	972999	Staphylococcus epidermidis strain none genome assembly, chromosome: 1	blastn	72615	226	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8721749	8721749	PRJNA326068_P_NODE_19707_length_154_cov_49.672000_g18744_i0	PRJNA326068	19707	154	49.672	76.49488	PVC group	1783257	Bacteria	Bacteria	91.6	2.68e-14	NTclustered	gi\|1532072102\|gb\|CP034248.1\|	1338368	g18744	i0	79.452	138.207792207792	146	17	88	11	14	149	864556	864698	Paenibacillus lentus strain DSM 25539 chromosome, complete genome	blastn	21284	91.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus lentus
8721756	8721756	PRJNA326068_P_NODE_6307_length_434_cov_104.372840_g5407_i0	PRJNA326068	6307	434	104.37284	452.9781256	Streptococcus	1301	Bacteria	Bacteria	717	0	NTclustered	gi\|2179899321\|gb\|CP046523.1\|	1303	g5407	i0	97.613	320.608294930876	419	9	97	1	1	419	17418	17001	Streptococcus oralis strain SOD chromosome, complete genome	blastn	139144	717	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9997313	9997313	PRJNA326068_P_NODE_10608_length_301_cov_646.808824_g9647_i0	PRJNA326068	10608	301	646.808824	1946.89456024	Bacillota	1239	Bacteria	Bacteria	315	3.239999999999999e-81	NTclustered	gi\|2723282184\|gb\|CP151943.1\|	2954672	g9647	i0	87.589	862.159468438538	282	21	94	4	4	284	216746	217014	Neobacillus sp. FSL H8-0543 chromosome, complete genome	blastn	259510	316	0.996835443037975	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus sp. FSL H8-0543
10593113	10593113	PRJNA326068_P_NODE_14409_length_227_cov_6.525253_g13446_i0	PRJNA326068	14409	227	6.525253	14.81232431	Aneurinibacillus uraniidurans	2966586	Bacteria	Bacteria	121	5.46e-23	NTclustered	gi\|2440572284\|gb\|CP116902.1\|	2966586	g13446	i0	83.721	224.114537444934	129	19	57	2	48	175	3688049	3687922	Aneurinibacillus uraniidurans strain B1 chromosome, complete genome	blastn	50874	121	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Aneurinibacillus	Aneurinibacillus uraniidurans
10593114	10593114	PRJNA326068_P_NODE_14509_length_226_cov_2.116751_g13546_i0	PRJNA326068	14509	226	2.116751	4.7838572599999996	Caldalkalibacillus thermarum	296745	Bacteria	Bacteria	198	2.44e-46	NTclustered	gi\|2088805434\|gb\|CP082237.1\|	986075	g13546	i0	83.111	350.203539823009	225	31	99	5	1	224	598194	598412	Caldalkalibacillus thermarum TA2.A1 chromosome, complete genome	blastn	79146	198	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldalkalibacillus	Caldalkalibacillus thermarum
11272380	11272380	PRJNA326068_P_NODE_18569_length_171_cov_2.936620_g17606_i0	PRJNA326068	18569	171	2.93662	5.0216202	Staphylococcus	1279	Bacteria	Bacteria	209	8.03e-50	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g17606	i0	88.083	112.865497076023	193	1	100	1	1	171	2335689	2335881	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	19300	209	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11868033	11868033	PRJNA326068_P_NODE_17950_length_181_cov_4.940789_g16987_i0	PRJNA326068	17950	181	4.940789	8.94282809	Neomoorella humiferrea	676965	Bacteria	Bacteria	108	3.24e-19	NTclustered	gi\|2702393359\|gb\|CP136418.1\|	676965	g16987	i0	79.114	203.988950276243	158	31	87	2	25	181	151534	151378	Moorella humiferrea strain LNE chromosome, complete genome	blastn	36922	108	1	Bacteria	Bacillati	Bacillota	Clostridia	Neomoorellales	Neomoorellaceae	Neomoorella	Neomoorella humiferrea
13822648	13822648	PRJNA326068_P_NODE_4811_length_503_cov_10.620253_g4004_i0	PRJNA326068	4811	503	10.620253	53.41987259	Staphylococcus	1279	Bacteria	Bacteria	902	0	NTclustered	gi\|2071692135\|gb\|CP073824.1\|	1282	g4004	i0	99.008	546.842942345924	504	4	100	1	1	503	699812	700315	Staphylococcus epidermidis strain B1200599 chromosome, complete genome	blastn	275062	902	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18241041	18241041	PRJNA326068_P_NODE_12295_length_265_cov_1.987288_g11332_i0	PRJNA326068	12295	265	1.987288	5.2663132	Tepidibacter aestuarii	2925782	Bacteria	Bacteria	202	2.27e-47	NTclustered	gi\|2231814819\|emb\|OW235315.1\|	2925782	g11332	i0	80.916	154.237735849057	262	45	98	5	4	263	85107	85365	Tepidibacter sp. 8C15b genome assembly, chromosome: T8CH	blastn	40873	202	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Tepidibacter	Tepidibacter aestuarii
20195246	20195246	PRJNA326068_P_NODE_14336_length_228_cov_7.256281_g13373_i0	PRJNA326068	14336	228	7.256281	16.54432068	Oscillospiraceae	216572	Bacteria	Bacteria	121	5.49e-23	NTclustered	gi\|2058324695\|gb\|CP034413.3\|	2093857	g13373	i0	80.892	322.69298245614	157	27	68	3	1	154	171701	171545	Dysosmobacter welbionis strain J115 chromosome, complete genome	blastn	73574	121	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Dysosmobacter	Dysosmobacter welbionis
20790945	20790945	PRJNA326068_P_NODE_5737_length_460_cov_10.484919_g4883_i0	PRJNA326068	5737	460	10.484919	48.2306274	Aneurinibacillus soli	1500254	Bacteria	Bacteria	206	3.2399999999999996e-48	NTclustered	gi\|974000791\|dbj\|AP017312.1\|	1500254	g4883	i0	80.42	140.591304347826	286	43	61	11	135	413	289695	289974	Aneurinibacillus soli DNA, complete genome	blastn	64672	206	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Aneurinibacillus	Aneurinibacillus soli
21470920	21470920	PRJNA326068_P_NODE_3577_length_585_cov_69.433453_g2864_i0	PRJNA326068	3577	585	69.433453	406.18570005	Bacillati	1783272	Bacteria	Bacteria	348	6.580000000000001e-91	NTclustered	gi\|2844697739\|gb\|CP172402.1\|	1380675	g2864	i0	81.948	415.929914529915	421	67	71	9	2	418	184005	183590	Haloimpatiens lingqiaonensis strain ZC-CMC3 chromosome, complete genome	blastn	243319	348	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Haloimpatiens	Haloimpatiens lingqiaonensis
22746085	22746085	PRJNA326068_P_NODE_3438_length_596_cov_103.312169_g2739_i0	PRJNA326068	3438	596	103.312169	615.74052724	Streptococcus	1301	Bacteria	Bacteria	1024	0	NTclustered	gi\|2213330959\|gb\|CP094226.1\|	1303	g2739	i0	97.651	335.062080536913	596	14	100	0	1	596	16752	17347	Streptococcus oralis strain 1648 chromosome, complete genome	blastn	199697	1024	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
24020969	24020969	PRJNA326068_P_NODE_1239_length_946_cov_100.231189_g889_i0	PRJNA326068	1239	946	100.231189	948.18704794	Anoxybacillus	150247	Bacteria	Bacteria	558	4.63e-154	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g889	i0	77.871	795.88689217759	958	173	99	39	6	946	2056112	2055177	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	752909	558	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
24020990	24020990	PRJNA326068_P_NODE_599_length_1254_cov_91.172245_g409_i0	PRJNA326068	599	1254	91.172245	1143.2999523	Clostridiaceae	31979	Bacteria	Bacteria	749	0	NTclustered	gi\|2545365079\|dbj\|AP024979.1\|	1502	g409	i0	78.022	469.717703349282	1274	222	99	54	6	1254	54699	55939	Clostridium perfringens A18-256 DNA, complete genome	blastn	589026	752	0.996010638297872	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
24020996	24020996	PRJNA326068_P_NODE_7879_length_374_cov_31.373913_g6935_i0	PRJNA326068	7879	374	31.373913	117.33843462	Dehalobacter	56112	Bacteria	Bacteria	233	1.1799999999999998e-56	NTclustered	gi\|2753147090\|gb\|CP148032.1\|	55583	g6935	i0	82.246	614.385026737968	276	44	74	5	99	373	233315	233586	MAG: Dehalobacter restrictus isolate SAD chromosome, complete genome	blastn	229780	233	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Dehalobacter	Dehalobacter restrictus
24615524	24615524	PRJNA326068_P_NODE_17000_length_198_cov_2.295858_g16037_i0	PRJNA326068	17000	198	2.295858	4.54579884	Alicyclobacillus sp. SO9	2665646	Bacteria	Bacteria	82.4	2.19e-11	NTclustered	gi\|1950041829\|gb\|CP066339.1\|	2665646	g16037	i0	75.127	6.65151515151515	197	37	96	12	2	192	14609	14799	Alicyclobacillus sp. SO9 chromosome, complete genome	blastn	1317	82.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus sp. SO9

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