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

30 rows where analysis = "blastn", bioproject = "PRJNA631119" 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
1151809	1151809	PRJNA631119_P_NODE_17121_length_314_cov_1.854772_g17003_i0	PRJNA631119	17121	314	1.854772	5.82398408	Ligilactobacillus	2767887	Bacteria	Bacteria	580	3.0299999999999992e-161	NTclustered	gi\|2508735984\|gb\|CP114501.1\|	1624	g17003	i0	100	580.34076433121	314	0	100	0	1	314	60431	60744	Ligilactobacillus salivarius strain S99 chromosome, complete genome	blastn	182227	580	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
1879441	1879441	PRJNA631119_P_NODE_35762_length_245_cov_0.895349_g35644_i0	PRJNA631119	35762	245	0.895349	2.19360505	Selenobaculum gibii	3054208	Bacteria	Bacteria	82.4	2.82e-11	NTclustered	gi\|2519780754\|gb\|CP120678.1\|	3054208	g35644	i0	88.235	1.31836734693878	68	8	28	0	176	243	2535114	2535181	Selenobaculum gibii strain ICN-92133 chromosome, complete genome	blastn	323	82.4	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenobaculum	Selenobaculum gibii
1879457	1879457	PRJNA631119_P_NODE_38982_length_241_cov_1.375000_g38864_i0	PRJNA631119	38982	241	1.375	3.31375	Caldinitratiruptor microaerophilus	671077	Bacteria	Bacteria	159	1.24e-34	NTclustered	gi\|2317219343\|dbj\|AP025628.1\|	671077	g38864	i0	80.976	69.5352697095436	205	35	84	3	13	215	2461634	2461432	Caldinitratiruptor microaerophilus JCM 16183 DNA, complete genome	blastn	16758	159	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Symbiobacteriaceae	Caldinitratiruptor	Caldinitratiruptor microaerophilus
1879473	1879473	PRJNA631119_P_NODE_5082_length_502_cov_2.135198_g4964_i0	PRJNA631119	5082	502	2.135198	10.71869396	Ligilactobacillus ruminis	1623	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2299462274\|gb\|CP102284.1\|	1623	g4964	i0	96.875	0.0637450199203187	32	0	6	1	376	407	1354181	1354151	Ligilactobacillus ruminis strain ATCC 25644 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus ruminis
3703422	3703422	PRJNA631119_P_NODE_11123_length_368_cov_0.854237_g11005_i0	PRJNA631119	11123	368	0.854237	3.14359216	Bacillus	1386	Bacteria	Bacteria	453	8.2e-123	NTclustered	gi\|300373910\|gb\|CP001746.1\|	637380	g11005	i0	89.918	373.078804347826	367	15	99	3	1	367	255888	255544	Bacillus cereus biovar anthracis str. CI, complete genome	blastn	137293	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
3703423	3703423	PRJNA631119_P_NODE_11143_length_367_cov_3.132653_g11025_i0	PRJNA631119	11143	367	3.132653	11.49683651	Ligilactobacillus	2767887	Bacteria	Bacteria	678	0	NTclustered	gi\|1063816371\|gb\|CP017107.1\|	1624	g11025	i0	100	96.6784741144414	367	0	100	0	1	367	420561	420927	Ligilactobacillus salivarius strain CICC 23174 chromosome, complete genome	blastn	35481	678	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
3703579	3703579	PRJNA631119_P_NODE_34243_length_247_cov_0.885057_g34125_i0	PRJNA631119	34243	247	0.885057	2.18609079	Bacillus	1386	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2263617782\|gb\|CP099801.1\|	2026186	g34125	i0	100	99.9757085020243	247	0	100	0	1	247	3818196	3818442	Bacillus paranthracis strain SSBC101 chromosome, complete genome	blastn	24694	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paranthracis
4430899	4430899	PRJNA631119_P_NODE_19704_length_298_cov_2.471111_g19586_i0	PRJNA631119	19704	298	2.471111	7.36391078	Aerococcaceae bacterium zg-1292	2774330	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1948496008\|gb\|CP065955.1\|	2774330	g19586	i0	96.875	0.10738255033557	32	0	11	1	193	224	1458164	1458134	Aerococcaceae bacterium zg-1292 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae		Aerococcaceae bacterium zg-1292
4979990	4979990	PRJNA631119_P_NODE_14264_length_335_cov_4.076336_g14146_i0	PRJNA631119	14264	335	4.076336	13.6557256	root	1	Root_unresolved	Root_unresolved	614	3.209999999999999e-171	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g14146	i0	99.701	99.9223880597015	335	1	100	0	1	335	2463661	2463327	Staphylococcus aureus strain WH9628 chromosome	blastn	33474	614	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
5706761	5706761	PRJNA631119_P_NODE_16045_length_322_cov_1.232932_g15927_i0	PRJNA631119	16045	322	1.232932	3.97004104	Leuconostoc carnosum	1252	Bacteria	Bacteria	176	1.72e-39	NTclustered	gi\|1721181998\|gb\|CP042376.1\|	1252	g15927	i0	85.714	34.3633540372671	168	22	54	2	7	173	6662	6496	Leuconostoc carnosum strain CBA3620 plasmid unnamed2, complete sequence	blastn	11065	176	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc carnosum
12082721	12082721	PRJNA631119_P_NODE_36350_length_244_cov_1.508772_g36232_i0	PRJNA631119	36350	244	1.508772	3.68140368	Ligilactobacillus salivarius	1624	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1063816371\|gb\|CP017107.1\|	1624	g36232	i0	99.59	148.618852459016	244	1	100	0	1	244	956488	956245	Ligilactobacillus salivarius strain CICC 23174 chromosome, complete genome	blastn	36263	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
12630890	12630890	PRJNA631119_P_NODE_16970_length_315_cov_1.785124_g16852_i0	PRJNA631119	16970	315	1.785124	5.6231406	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2053344737\|gb\|CP063150.1\|	1423	g16852	i0	100	7.93333333333333	30	0	10	0	286	315	3139456	3139485	Bacillus subtilis strain s-16 chromosome, complete genome	blastn	2499	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus subtilis
14632188	14632188	PRJNA631119_P_NODE_32232_length_249_cov_1.750000_g32114_i0	PRJNA631119	32232	249	1.75	4.3575	Paenibacillus sp. FSL H8-0280	2921382	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2710109906\|gb\|CP150296.1\|	2921382	g32114	i0	96.774	0.124497991967871	31	1	12	0	146	176	1283307	1283277	Paenibacillus sp. FSL H8-0280 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL H8-0280
15180273	15180273	PRJNA631119_P_NODE_27592_length_262_cov_2.767196_g27474_i0	PRJNA631119	27592	262	2.767196	7.25005352	Bacillus	1386	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g27474	i0	100	1231.13358778626	262	0	100	0	1	262	13885	14146	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	322557	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
15906114	15906114	PRJNA631119_P_NODE_38353_length_242_cov_0.911243_g38235_i0	PRJNA631119	38353	242	0.911243	2.20520806	Xylocopilactobacillus apis	2932183	Bacteria	Bacteria	65.8	2.8e-6	NTclustered	gi\|2518651862\|dbj\|AP026801.1\|	2932183	g38235	i0	100	0.351239669421488	35	0	14	0	17	51	553670	553636	Xylocopilactobacillus apis DNA, complete genome	blastn	85	65.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Xylocopilactobacillus	Xylocopilactobacillus apis
16454702	16454702	PRJNA631119_P_NODE_39633_length_240_cov_3.580838_g39515_i0	PRJNA631119	39633	240	3.580838	8.5940112	Bacillales	1385	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|461489464\|gb\|KC734533.1\|	1392	g39515	i0	100	333.141666666667	240	0	100	0	1	240	24	263	Bacillus anthracis strain TRTYP13 16S ribosomal RNA gene, partial sequence	blastn	79954	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
17181168	17181168	PRJNA631119_P_NODE_17434_length_312_cov_1.853556_g17316_i0	PRJNA631119	17434	312	1.853556	5.78309472	Ligilactobacillus salivarius	1624	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|1063816371\|gb\|CP017107.1\|	1624	g17316	i0	100	51.6538461538462	312	0	100	0	1	312	96012	95701	Ligilactobacillus salivarius strain CICC 23174 chromosome, complete genome	blastn	16116	577	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
17181279	17181279	PRJNA631119_P_NODE_38474_length_242_cov_0.911243_g38356_i0	PRJNA631119	38474	242	0.911243	2.20520806	Lactobacillus iners	147802	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1810931560\|gb\|CP048798.1\|	147802	g38356	i0	100	13	242	0	100	0	1	242	1310508	1310749	Lactobacillus iners strain KY chromosome, complete genome	blastn	3146	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
17729626	17729626	PRJNA631119_P_NODE_11254_length_366_cov_1.699659_g11136_i0	PRJNA631119	11254	366	1.699659	6.22075194	Bacillales	1385	Bacteria	Bacteria	610	4.569999999999999e-170	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g11136	i0	96.978	531.103825136612	364	10	99	1	3	366	2277669	2278031	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	194384	610	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17729677	17729677	PRJNA631119_P_NODE_16494_length_318_cov_2.302041_g16376_i0	PRJNA631119	16494	318	2.302041	7.32049038	Bacillales	1385	Bacteria	Bacteria	75	6.36e-9	NTclustered	gi\|1185663818\|gb\|CP020814.1\|	199441	g16376	i0	87.879	17.3018867924528	66	5	20	3	4	67	138697	138633	Halalkalibacter krulwichiae strain AM31D chromosome, complete genome	blastn	5502	75	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halalkalibacter	Halalkalibacter krulwichiae
19003349	19003349	PRJNA631119_P_NODE_30975_length_251_cov_0.865169_g30857_i0	PRJNA631119	30975	251	0.865169	2.17157419	Staphylococcus	1279	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g30857	i0	100	482.035856573705	251	0	100	0	1	251	2168093	2167843	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	120991	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
20278321	20278321	PRJNA631119_P_NODE_25296_length_272_cov_1.537688_g25178_i0	PRJNA631119	25296	272	1.537688	4.18251136	Streptococcus	1301	Bacteria	Bacteria	497	2.67e-136	NTclustered	gi\|2890261556\|gb\|CP177179.1\|	1304	g25178	i0	99.632	203.992647058824	272	1	100	0	1	272	15243	14972	Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome	blastn	55486	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
20278419	20278419	PRJNA631119_P_NODE_5456_length_488_cov_2.416867_g5338_i0	PRJNA631119	5456	488	2.416867	11.79431096	Ligilactobacillus	2767887	Bacteria	Bacteria	902	0	NTclustered	gi\|1063816371\|gb\|CP017107.1\|	1624	g5338	i0	100	95.2622950819672	488	0	100	0	1	488	419946	419459	Ligilactobacillus salivarius strain CICC 23174 chromosome, complete genome	blastn	46488	902	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
21553748	21553748	PRJNA631119_P_NODE_1577_length_834_cov_1.404731_g1478_i0	PRJNA631119	1577	834	1.404731	11.71545654	Streptococcus	1301	Bacteria	Bacteria	1520	0	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g1478	i0	99.639	346.442446043165	832	3	99	0	1	832	903376	902545	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	288933	1531	0.992815153494448	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
23555852	23555852	PRJNA631119_P_NODE_35659_length_245_cov_0.895349_g35541_i0	PRJNA631119	35659	245	0.895349	2.19360505	Paenibacillus sp. IHBB 10380	1566358	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|766900424\|gb\|CP010976.1\|	1566358	g35541	i0	100	0.114285714285714	28	0	11	0	141	168	1026268	1026241	Paenibacillus sp. IHBB 10380, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. IHBB 10380
23555867	23555867	PRJNA631119_P_NODE_40319_length_232_cov_2.836478_g40201_i0	PRJNA631119	40319	232	2.836478	6.58062896	Metabacillus endolithicus	1535204	Bacteria	Bacteria	58.4	4.46e-4	NTclustered	gi\|2227776225\|gb\|CP095550.1\|	1535204	g40201	i0	92.5	0.448275862068966	40	3	17	0	172	211	3945930	3945969	Metabacillus endolithicus strain KCTC 33579 chromosome	blastn	104	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus endolithicus
24103655	24103655	PRJNA631119_P_NODE_12679_length_350_cov_2.296029_g12561_i0	PRJNA631119	12679	350	2.296029	8.0361015	Staphylococcus	1279	Bacteria	Bacteria	647	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g12561	i0	100	543.688571428571	350	0	100	0	1	350	748546	748895	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	190291	647	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24103660	24103660	PRJNA631119_P_NODE_13559_length_342_cov_1.416357_g13441_i0	PRJNA631119	13559	342	1.416357	4.84394094	Ligilactobacillus	2767887	Bacteria	Bacteria	623	5.459999999999999e-174	NTclustered	gi\|1063816371\|gb\|CP017107.1\|	1624	g13441	i0	99.706	93.0175438596491	340	1	99	0	1	340	1434000	1433661	Ligilactobacillus salivarius strain CICC 23174 chromosome, complete genome	blastn	31812	623	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
25378319	25378319	PRJNA631119_P_NODE_40100_length_235_cov_2.259259_g39982_i0	PRJNA631119	40100	235	2.259259	5.30925865	Bacillati	1783272	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g39982	i0	99.574	496.068085106383	235	1	100	0	1	235	2278158	2278392	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	116576	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25378354	25378354	PRJNA631119_P_NODE_8100_length_416_cov_1.466472_g7982_i0	PRJNA631119	8100	416	1.466472	6.10052352	Ligilactobacillus	2767887	Bacteria	Bacteria	606	6.809999999999996e-169	NTclustered	gi\|2508735984\|gb\|CP114501.1\|	1624	g7982	i0	100	553.014423076923	328	0	100	0	89	416	59649	59322	Ligilactobacillus salivarius strain S99 chromosome, complete genome	blastn	230054	606	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius

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