metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA492406" 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
1099240	1099240	PRJNA492406_P_NODE_21701_length_275_cov_1.524752_g21402_i0	PRJNA492406	21701	275	1.524752	4.193068	Enterococcus	1350	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|1777963221\|gb\|CP046123.1\|	37734	g21402	i0	100	21	275	0	100	0	1	275	1958526	1958252	Enterococcus casseliflavus strain EC291 chromosome, complete genome	blastn	5775	508	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
1099267	1099267	PRJNA492406_P_NODE_24221_length_262_cov_1.746032_g23922_i0	PRJNA492406	24221	262	1.746032	4.57460384	Streptococcus	1301	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g23922	i0	100	564.148854961832	262	0	100	0	1	262	18167	17906	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	147807	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
1727055	1727055	PRJNA492406_P_NODE_15002_length_323_cov_12.000000_g14703_i0	PRJNA492406	15002	323	12	38.76	Paraclostridium bifermentans	1490	Bacteria	Bacteria	597	3.11e-166	NTclustered	gi\|2223161236\|gb\|CP094933.1\|	1490	g14703	i0	100	100.736842105263	323	0	100	0	1	323	359754	360076	Paraclostridium bifermentans strain HD0315_2 chromosome, complete genome	blastn	32538	597	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
1727574	1727574	PRJNA492406_P_NODE_7022_length_456_cov_1.530026_g6723_i0	PRJNA492406	7022	456	1.530026	6.97691856	Clostridium culturomicium	1499683	Bacteria	Bacteria	747	0	NTclustered	gi\|2831321202\|gb\|CP171113.1\|	1499683	g6723	i0	96.264	976.333333333333	455	17	99	0	2	456	49059	48605	Clostridium culturomicium strain WGS1527 chromosome, complete genome	blastn	445208	747	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium culturomicium
3003026	3003026	PRJNA492406_P_NODE_15003_length_323_cov_6.884000_g14704_i0	PRJNA492406	15003	323	6.884	22.23532	Paraclostridium bifermentans	1490	Bacteria	Bacteria	564	3.1499999999999995e-156	NTclustered	gi\|2091226359\|gb\|CP079737.1\|	1490	g14704	i0	98.142	1129.1919504644	323	6	100	0	1	323	13903	14225	Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome	blastn	364729	564	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
3003323	3003323	PRJNA492406_P_NODE_29243_length_246_cov_0.890173_g28944_i0	PRJNA492406	29243	246	0.890173	2.18982558	Streptococcus sp. KHUD_011	3157334	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|2874289904\|gb\|CP157578.1\|	3157334	g28944	i0	97.561	100	246	6	100	0	1	246	1392381	1392136	Streptococcus sp. KHUD_011 chromosome KHUD011, complete sequence	blastn	24600	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. KHUD_011
6202425	6202425	PRJNA492406_P_NODE_25585_length_255_cov_2.302198_g25286_i0	PRJNA492406	25585	255	2.302198	5.8706049	Enterococcus	1350	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g25286	i0	99.608	20.6588235294118	255	1	100	0	1	255	87117	86863	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	5268	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
7477275	7477275	PRJNA492406_P_NODE_24686_length_260_cov_1.449198_g24387_i0	PRJNA492406	24686	260	1.449198	3.7679148	Alicyclobacillus	29330	Bacteria	Bacteria	475	1.1899999999999999e-129	NTclustered	gi\|470489048\|ref\|NR_076903.1\|	1388	g24387	i0	99.615	276.726923076923	260	1	100	0	1	260	2005	2264	Alicyclobacillus acidocaldarius subsp. acidocaldarius strain Tc-4-1 23S ribosomal RNA gene, complete sequence	blastn	71949	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus acidocaldarius
8105336	8105336	PRJNA492406_P_NODE_1087_length_1161_cov_21.873162_g886_i0	PRJNA492406	1087	1161	21.873162	253.94741082	Clostridium culturomicium	1499683	Bacteria	Bacteria	2045	0	NTclustered	gi\|2831321202\|gb\|CP171113.1\|	1499683	g886	i0	98.451	854.23428079242	1162	17	100	1	1	1161	11830	12991	Clostridium culturomicium strain WGS1527 chromosome, complete genome	blastn	991766	2045	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium culturomicium
8105978	8105978	PRJNA492406_P_NODE_8707_length_414_cov_1.313783_g8408_i0	PRJNA492406	8707	414	1.313783	5.43906162	Domibacillus sp. DTU_2020_1001157_1_SI_ALB_TIR_016	3077789	Bacteria	Bacteria	671	0	NTclustered	gi\|2587855252\|gb\|CP135439.1\|	3077789	g8408	i0	95.913	892.48309178744	416	13	100	4	1	414	2727	3140	Domibacillus sp. DTU_2020_1001157_1_SI_ALB_TIR_016 chromosome 2, complete sequence	blastn	369488	671	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Domibacillus	Domibacillus sp. DTU_2020_1001157_1_SI_ALB_TIR_016
8752102	8752102	PRJNA492406_P_NODE_13967_length_335_cov_2.351145_g13668_i0	PRJNA492406	13967	335	2.351145	7.87633575	Exiguobacterium	33986	Bacteria	Bacteria	612	1.16e-170	NTclustered	gi\|2446540574\|gb\|CP118099.1\|	273528	g13668	i0	99.701	57.334328358209	334	1	99	0	2	335	1922538	1922871	Exiguobacterium marinum strain a-1 chromosome, complete genome	blastn	19207	617	0.991896272285251	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium marinum
8752191	8752191	PRJNA492406_P_NODE_27287_length_250_cov_0.870056_g26988_i0	PRJNA492406	27287	250	0.870056	2.17514	Exiguobacterium	33986	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2047031806\|gb\|CP075897.1\|	41170	g26988	i0	100	8.992	250	0	100	0	1	250	230670	230421	Exiguobacterium acetylicum strain SI17 chromosome, complete genome	blastn	2248	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
9380153	9380153	PRJNA492406_P_NODE_13968_length_335_cov_2.335878_g13669_i0	PRJNA492406	13968	335	2.335878	7.8251913	Domibacillus sp. DTU_2020_1001157_1_SI_ALB_TIR_016	3077789	Bacteria	Bacteria	619	6.91e-173	NTclustered	gi\|2587855252\|gb\|CP135439.1\|	3077789	g13669	i0	100	1064.52835820896	335	0	100	0	1	335	1121	787	Domibacillus sp. DTU_2020_1001157_1_SI_ALB_TIR_016 chromosome 2, complete sequence	blastn	356617	619	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Domibacillus	Domibacillus sp. DTU_2020_1001157_1_SI_ALB_TIR_016
9380285	9380285	PRJNA492406_P_NODE_19668_length_285_cov_1.325472_g19369_i0	PRJNA492406	19668	285	1.325472	3.7775952	Enterococcus casseliflavus	37734	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g19369	i0	99.649	20.3298245614035	285	1	100	0	1	285	2146481	2146197	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	5794	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
12578216	12578216	PRJNA492406_P_NODE_30910_length_243_cov_0.905882_g30611_i0	PRJNA492406	30910	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	438	1.4399999999999996e-118	NTclustered	gi\|1913493076\|gb\|CP050490.1\|	37734	g30611	i0	99.177	98.9547325102881	243	2	100	0	1	243	2480253	2480495	Enterococcus casseliflavus strain EGM182 chromosome, complete genome	blastn	24046	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
13206334	13206334	PRJNA492406_P_NODE_28031_length_248_cov_1.548571_g27732_i0	PRJNA492406	28031	248	1.548571	3.84045608	Enterococcus casseliflavus	37734	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1489980470\|gb\|CP032739.1\|	37734	g27732	i0	100	20.9274193548387	248	0	100	0	1	248	2402260	2402013	Enterococcus casseliflavus strain EC-369 chromosome, complete genome	blastn	5190	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
13852940	13852940	PRJNA492406_P_NODE_7631_length_439_cov_1.404372_g7332_i0	PRJNA492406	7631	439	1.404372	6.16519308	Clostridium	1485	Bacteria	Bacteria	806	0	NTclustered	gi\|2029792361\|gb\|CP073279.1\|	1520	g7332	i0	99.772	954.321184510251	439	1	100	0	1	439	5767860	5767422	Clostridium beijerinckii strain CBEI chromosome, complete genome	blastn	418947	806	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
15127279	15127279	PRJNA492406_P_NODE_25092_length_258_cov_1.432432_g24793_i0	PRJNA492406	25092	258	1.432432	3.69567456	Enterococcus	1350	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1489980470\|gb\|CP032739.1\|	37734	g24793	i0	100	6.00387596899225	258	0	100	0	1	258	157828	157571	Enterococcus casseliflavus strain EC-369 chromosome, complete genome	blastn	1549	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
15755242	15755242	PRJNA492406_P_NODE_29153_length_246_cov_1.375723_g28854_i0	PRJNA492406	29153	246	1.375723	3.38427858	Exiguobacterium acetylicum	41170	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2192017529\|gb\|CP081878.1\|	41170	g28854	i0	100	755.678861788618	246	0	100	0	1	246	31182	31427	Exiguobacterium acetylicum strain UTDF19-27C chromosome, complete genome	blastn	185897	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
16401852	16401852	PRJNA492406_P_NODE_26233_length_252_cov_1.614525_g25934_i0	PRJNA492406	26233	252	1.614525	4.068603	Lysinibacillus	400634	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2007734766\|gb\|CP071738.1\|	1421	g25934	i0	99.603	1056.8253968254	252	1	100	0	1	252	14399	14650	Lysinibacillus sphaericus strain BS-pTAND672-2 chromosome	blastn	266320	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sphaericus
17029667	17029667	PRJNA492406_P_NODE_18434_length_290_cov_1.884793_g18135_i0	PRJNA492406	18434	290	1.884793	5.4658997	Planococcus rifietoensis	200991	Bacteria	Bacteria	503	6.17e-138	NTclustered	gi\|982516258\|gb\|CP013659.2\|	200991	g18135	i0	97.938	845.9	291	4	100	2	1	290	234216	234505	Planococcus rifietoensis strain M8 chromosome, complete genome	blastn	245311	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus rifietoensis
17677014	17677014	PRJNA492406_P_NODE_9774_length_393_cov_1.778125_g9475_i0	PRJNA492406	9774	393	1.778125	6.98803125	Exiguobacterium	33986	Bacteria	Bacteria	715	0	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g9475	i0	99.491	12.9974554707379	393	2	100	0	1	393	1197672	1197280	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	5108	715	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
18304270	18304270	PRJNA492406_P_NODE_30575_length_244_cov_0.900585_g30276_i0	PRJNA492406	30575	244	0.900585	2.1974274	Staphylococcus epidermidis	1282	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g30276	i0	100	100.004098360656	244	0	100	0	1	244	2209313	2209070	Staphylococcus epidermidis strain 9 chromosome	blastn	24401	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18950829	18950829	PRJNA492406_P_NODE_32975_length_200_cov_12.078740_g32676_i0	PRJNA492406	32975	200	12.07874	24.15748	Paraclostridium	1849822	Bacteria	Bacteria	342	9.209999999999999e-90	NTclustered	gi\|2091226359\|gb\|CP079737.1\|	1490	g32676	i0	97.5	1140.015	200	5	100	0	1	200	15203	15402	Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome	blastn	228003	342	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
20225603	20225603	PRJNA492406_P_NODE_12916_length_348_cov_1.934545_g12617_i0	PRJNA492406	12916	348	1.934545	6.7322166	Bacillati	1783272	Bacteria	Bacteria	641	1.5399999999999996e-179	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g12617	i0	100	510.186781609195	347	0	99	0	1	347	2278232	2277886	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	177545	641	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20225725	20225725	PRJNA492406_P_NODE_32976_length_200_cov_5.740157_g32677_i0	PRJNA492406	32976	200	5.740157	11.480314	Paraclostridium	1849822	Bacteria	Bacteria	337	4.28e-88	NTclustered	gi\|2091226359\|gb\|CP079737.1\|	1490	g32677	i0	97	1131.94	200	6	100	0	1	200	15203	15402	Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome	blastn	226388	337	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
20854004	20854004	PRJNA492406_P_NODE_16797_length_305_cov_1.926724_g16498_i0	PRJNA492406	16797	305	1.926724	5.8765082	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	165	3.5e-36	NTclustered	gi\|2046525510\|gb\|CP075603.1\|	47714	g16498	i0	85.455	128.350819672131	165	16	52	5	141	300	783	944	Lacticaseibacillus paracasei subsp. paracasei strain BD5115 chromosome	blastn	39147	165	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
22128757	22128757	PRJNA492406_P_NODE_16918_length_304_cov_1.701299_g16619_i0	PRJNA492406	16918	304	1.701299	5.17194896	Paraclostridium bifermentans	1490	Bacteria	Bacteria	551	2.289999999999999e-152	NTclustered	gi\|2223161236\|gb\|CP094933.1\|	1490	g16619	i0	99.342	94.7960526315789	304	2	100	0	1	304	2770509	2770812	Paraclostridium bifermentans strain HD0315_2 chromosome, complete genome	blastn	28818	551	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
22776415	22776415	PRJNA492406_P_NODE_9858_length_391_cov_7.600629_g9559_i0	PRJNA492406	9858	391	7.600629	29.71845939	Lachnospirales	3085636	Bacteria	Bacteria	58.4	8.03e-4	NTclustered	gi\|2509460602\|gb\|CP092441.1\|	2918914	g9559	i0	92.683	1.04859335038363	41	2	10	1	25	65	325851	325812	Chakrabartyella piscis strain BP5G chromosome, complete genome	blastn	410	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Chakrabartyella	Chakrabartyella piscis
24051189	24051189	PRJNA492406_P_NODE_31179_length_242_cov_2.710059_g30880_i0	PRJNA492406	31179	242	2.710059	6.55834278	Lactiplantibacillus	2767842	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1611638273\|gb\|CP033616.1\|	1590	g30880	i0	100	480.053719008264	242	0	100	0	1	242	747335	747576	Lactiplantibacillus plantarum strain J26 chromosome, complete genome	blastn	116173	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
24678712	24678712	PRJNA492406_P_NODE_32140_length_241_cov_0.916667_g31841_i0	PRJNA492406	32140	241	0.916667	2.20916747	Sporosarcina ureae	1571	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1174585705\|gb\|CP015109.1\|	1571	g31841	i0	100	0.116182572614108	28	0	12	0	52	79	2479004	2478977	Sporosarcina ureae strain P17a chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina ureae

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