metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA473201" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA473201" 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
1094812	1094812	PRJNA473201_P_NODE_39961_length_316_cov_2.440329_g39219_i0	PRJNA473201	39961	316	2.440329	7.71143964	Lactobacillus	1578	Bacteria	Bacteria	584	2.359999999999999e-162	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g39219	i0	100	434.053797468354	316	0	100	0	1	316	90682	90367	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	137161	584	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
1719386	1719386	PRJNA473201_P_NODE_78282_length_245_cov_0.895349_g77540_i0	PRJNA473201	78282	245	0.895349	2.19360505	Finegoldia magna	1260	Bacteria	Bacteria	326	1.18e-84	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g77540	i0	90.612	5.42040816326531	245	23	100	0	1	245	1136577	1136333	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	1328	326	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
2994544	2994544	PRJNA473201_P_NODE_43483_length_308_cov_17.459574_g42741_i0	PRJNA473201	43483	308	17.459574	53.77548792	Turicibacter sanguinis	154288	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1840485543\|gb\|CP053187.1\|	154288	g42741	i0	96.774	0.100649350649351	31	1	10	0	18	48	662990	662960	Turicibacter sanguinis strain MOL361 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sanguinis
3646404	3646404	PRJNA473201_P_NODE_73043_length_247_cov_1.522989_g72301_i0	PRJNA473201	73043	247	1.522989	3.76178283	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g72301	i0	100	42.0971659919028	247	0	100	0	1	247	504718	504964	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	10398	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
4923273	4923273	PRJNA473201_P_NODE_62364_length_260_cov_1.235294_g61622_i0	PRJNA473201	62364	260	1.235294	3.2117644	Priestia	2800373	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2473387707\|gb\|CP120608.1\|	1404	g61622	i0	100	826	260	0	100	0	1	260	2621993	2622252	Priestia megaterium strain DSM 32 chromosome, complete genome	blastn	214760	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
4923333	4923333	PRJNA473201_P_NODE_67104_length_251_cov_0.865169_g66362_i0	PRJNA473201	67104	251	0.865169	2.17157419	Streptococcus	1301	Bacteria	Bacteria	462	8.869999999999999e-126	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g66362	i0	100	556.661354581673	250	0	99	0	2	251	17955	17706	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	139722	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
6198267	6198267	PRJNA473201_P_NODE_61905_length_261_cov_1.335106_g61163_i0	PRJNA473201	61905	261	1.335106	3.48462666	Staphylococcus	1279	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g61163	i0	100	461.057471264368	261	0	100	0	1	261	708445	708185	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	120336	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
6198458	6198458	PRJNA473201_P_NODE_77325_length_245_cov_0.895349_g76583_i0	PRJNA473201	77325	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g76583	i0	100	100	245	0	100	0	1	245	215321	215077	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24500	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6822257	6822257	PRJNA473201_P_NODE_81486_length_243_cov_0.905882_g80744_i0	PRJNA473201	81486	243	0.905882	2.20129326	Staphylococcus aureus	1280	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g80744	i0	100	100	243	0	100	0	1	243	1425489	1425247	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	24300	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6822316	6822316	PRJNA473201_P_NODE_84306_length_241_cov_1.815476_g83564_i0	PRJNA473201	84306	241	1.815476	4.37529716	Neobacillus sp. PS3-12	3070677	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2570967879\|gb\|CP133268.1\|	3070677	g83564	i0	100	0.116182572614108	28	0	12	0	34	61	1725546	1725573	Neobacillus sp. PS3-12 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus sp. PS3-12
9372255	9372255	PRJNA473201_P_NODE_75508_length_246_cov_0.890173_g74766_i0	PRJNA473201	75508	246	0.890173	2.18982558	Geobacillus sp. FSL K6-0789	2954744	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2723360730\|gb\|CP151966.1\|	2954744	g74766	i0	99.593	61.0243902439024	246	1	100	0	1	246	3021401	3021646	Geobacillus sp. FSL K6-0789 chromosome, complete genome	blastn	15012	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus sp. FSL K6-0789
10023448	10023448	PRJNA473201_P_NODE_64148_length_255_cov_1.664835_g63406_i0	PRJNA473201	64148	255	1.664835	4.24532925	Staphylococcus	1279	Bacteria	Bacteria	472	1.5e-128	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g63406	i0	100	103	255	0	100	0	1	255	2104103	2104357	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	26265	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
10023594	10023594	PRJNA473201_P_NODE_75788_length_246_cov_0.890173_g75046_i0	PRJNA473201	75788	246	0.890173	2.18982558	Lactobacillus	1578	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1543693276\|gb\|CP026503.1\|	47770	g75046	i0	100	11	246	0	100	0	1	246	534057	534302	Lactobacillus crispatus strain AB70 chromosome, complete genome	blastn	2706	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
11297756	11297756	PRJNA473201_P_NODE_28069_length_372_cov_1.321070_g27327_i0	PRJNA473201	28069	372	1.32107	4.9143804	Staphylococcus	1279	Bacteria	Bacteria	682	0	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g27327	i0	99.731	109.994623655914	372	1	100	0	1	372	705345	704974	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	40918	688	0.991279069767442	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
13848892	13848892	PRJNA473201_P_NODE_73671_length_247_cov_0.885057_g72929_i0	PRJNA473201	73671	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1908784908\|gb\|CP051991.1\|	1280	g72929	i0	100	100	247	0	100	0	1	247	2019589	2019343	Staphylococcus aureus strain ER08597.3 chromosome, complete genome	blastn	24700	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
14473235	14473235	PRJNA473201_P_NODE_81232_length_243_cov_0.905882_g80490_i0	PRJNA473201	81232	243	0.905882	2.20129326	Clostridium botulinum	1491	Bacteria	Bacteria	195	3.4399999999999997e-45	NTclustered	gi\|169119423\|gb\|CP000939.1\|	498213	g80490	i0	83.182	18.761316872428	220	30	90	6	24	241	357983	357769	Clostridium botulinum B1 str. Okra, complete genome	blastn	4559	195	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
15747187	15747187	PRJNA473201_P_NODE_77613_length_245_cov_0.895349_g76871_i0	PRJNA473201	77613	245	0.895349	2.19360505	Veillonella rogosae	423477	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2446175566\|gb\|CP117967.1\|	423477	g76871	i0	100	10.6897959183673	245	0	100	0	1	245	282704	282460	Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome	blastn	2619	453	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
16397866	16397866	PRJNA473201_P_NODE_72773_length_248_cov_0.880000_g72031_i0	PRJNA473201	72773	248	0.88	2.1824	Staphylococcus	1279	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2359411665\|gb\|CP110784.1\|	29388	g72031	i0	100	41	248	0	100	0	1	248	72914	73161	Staphylococcus capitis strain CCSM0123 chromosome, complete genome	blastn	10168	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
17021816	17021816	PRJNA473201_P_NODE_74374_length_247_cov_0.885057_g73632_i0	PRJNA473201	74374	247	0.885057	2.18609079	Weissella soli	155866	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1721182056\|gb\|CP042377.1\|	155866	g73632	i0	100	2	247	0	100	0	1	247	655725	655971	Weissella soli strain CBA3633 chromosome	blastn	494	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella soli
17022081	17022081	PRJNA473201_P_NODE_87734_length_215_cov_22.908451_g86992_i0	PRJNA473201	87734	215	22.908451	49.25316965	uncultured Acetobacterium sp.	217139	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2907625634\|emb\|OZ223194.1\|	217139	g86992	i0	96.97	0.153488372093023	33	0	15	1	21	52	1135266	1135298	MAG: uncultured Acetobacterium sp. isolate 6abcf8f7-2dc5-46ce-9e35-983ba889e1c3 genome assembly, chromosome: 4	blastn	33	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Acetobacterium	uncultured Acetobacterium sp.
17672616	17672616	PRJNA473201_P_NODE_52814_length_285_cov_1.212264_g52072_i0	PRJNA473201	52814	285	1.212264	3.4549524	Latilactobacillus	2767885	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|2472948865\|gb\|CP120512.1\|	1599	g52072	i0	100	48	285	0	100	0	1	285	790757	791041	Latilactobacillus sakei strain PMC104 chromosome, complete genome	blastn	13680	527	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Latilactobacillus	Latilactobacillus sakei
18295600	18295600	PRJNA473201_P_NODE_50955_length_289_cov_8.652778_g50213_i0	PRJNA473201	50955	289	8.652778	25.00652842	Terrisporobacter mayombei	1541	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2574030511\|gb\|CP101637.1\|	1541	g50213	i0	100	0.100346020761246	29	0	10	0	242	270	28520	28492	Terrisporobacter mayombei strain DSM 6539 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Terrisporobacter	Terrisporobacter mayombei
20221541	20221541	PRJNA473201_P_NODE_70096_length_249_cov_0.875000_g69354_i0	PRJNA473201	70096	249	0.875	2.17875	Staphylococcus	1279	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1908784908\|gb\|CP051991.1\|	1280	g69354	i0	100	100	249	0	100	0	1	249	872253	872501	Staphylococcus aureus strain ER08597.3 chromosome, complete genome	blastn	24900	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
20221566	20221566	PRJNA473201_P_NODE_72436_length_248_cov_0.880000_g71694_i0	PRJNA473201	72436	248	0.88	2.1824	Staphylococcus	1279	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g71694	i0	100	100	248	0	100	0	1	248	1443062	1443309	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	24800	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
20221716	20221716	PRJNA473201_P_NODE_85296_length_241_cov_0.916667_g84554_i0	PRJNA473201	85296	241	0.916667	2.20916747	Staphylococcus	1279	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g84554	i0	100	21.8838174273859	241	0	100	0	1	241	1702135	1702375	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	5274	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
21496747	21496747	PRJNA473201_P_NODE_47897_length_296_cov_28.789238_g47155_i0	PRJNA473201	47897	296	28.789238	85.21614448	Clostridium	1485	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|743960172\|dbj\|AP014696.1\|	1491	g47155	i0	100	2.5472972972973	29	0	10	0	3	31	2159478	2159450	Clostridium botulinum DNA, complete genome, strain: 111	blastn	754	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
22120906	22120906	PRJNA473201_P_NODE_71198_length_248_cov_1.422857_g70456_i0	PRJNA473201	71198	248	1.422857	3.52868536	Geobacillus stearothermophilus	1422	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|1919315002\|gb\|CP063162.1\|	1422	g70456	i0	100	865.713709677419	239	0	96	0	5	243	157801	158039	Geobacillus stearothermophilus strain DG-1 chromosome, complete genome	blastn	214697	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
23396652	23396652	PRJNA473201_P_NODE_74219_length_247_cov_0.885057_g73477_i0	PRJNA473201	74219	247	0.885057	2.18609079	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g73477	i0	96.97	0.133603238866397	33	0	13	1	191	223	756220	756251	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	33	54.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
23396890	23396890	PRJNA473201_P_NODE_85199_length_241_cov_0.916667_g84457_i0	PRJNA473201	85199	241	0.916667	2.20916747	Lactobacillus crispatus	47770	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g84457	i0	99.585	50.655601659751	241	1	100	0	1	241	475995	476235	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	12208	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
25321255	25321255	PRJNA473201_P_NODE_54620_length_280_cov_2.159420_g53878_i0	PRJNA473201	54620	280	2.15942	6.046376	Priestia	2800373	Bacteria	Bacteria	518	2.12e-142	NTclustered	gi\|2866365417\|gb\|CP174470.1\|	1404	g53878	i0	100	742.021428571429	280	0	100	0	1	280	10768	11047	Priestia megaterium strain WSY10 chromosome, complete genome	blastn	207766	518	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium

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