metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1022139" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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
161654	161654	PRJNA1022139_P_NODE_31761_length_260_cov_1.513369_g31656_i0	PRJNA1022139	31761	260	1.513369	3.9347594	Bacillus mycoides	1405	Bacteria	Bacteria	279	9.98e-71	NTclustered	gi\|2049781968\|gb\|CP036148.1\|	1405	g31656	i0	86.8	17.2769230769231	250	33	96	0	6	255	286953	286704	Bacillus mycoides strain JAS94/5 plasmid p347	blastn	4492	279	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
2711989	2711989	PRJNA1022139_P_NODE_22343_length_297_cov_1.308036_g22238_i0	PRJNA1022139	22343	297	1.308036	3.88486692	Caloramator sp. Dgby_cultured_2	3029174	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2449838143\|gb\|CP118396.1\|	3029174	g22238	i0	96.875	0.107744107744108	32	0	10	1	115	145	1255811	1255842	Caloramator sp. Dgby_cultured_2 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Caloramator	Caloramator sp. Dgby_cultured_2
2712094	2712094	PRJNA1022139_P_NODE_35143_length_250_cov_0.870056_g35038_i0	PRJNA1022139	35143	250	0.870056	2.17514	Lactococcus lactis	1358	Bacteria	Bacteria	429	8.949999999999998e-116	NTclustered	gi\|1173059443\|gb\|CP016699.1\|	1360	g35038	i0	97.6	659.688	250	6	100	0	1	250	72785	73034	Lactococcus lactis subsp. lactis strain 275 plasmid p275A, complete sequence	blastn	164922	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
2712108	2712108	PRJNA1022139_P_NODE_36403_length_249_cov_0.875000_g36298_i0	PRJNA1022139	36403	249	0.875	2.17875	Parvimonas micra	33033	Bacteria	Bacteria	448	2.46e-121	NTclustered	gi\|1540134846\|emb\|LR134472.1\|	33033	g36298	i0	99.194	9.94779116465863	248	2	99	0	1	248	711492	711245	Parvimonas micra strain NCTC11808 genome assembly, chromosome: 1	blastn	2477	448	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
2712116	2712116	PRJNA1022139_P_NODE_37063_length_248_cov_0.880000_g36958_i0	PRJNA1022139	37063	248	0.88	2.1824	Exiguobacterium profundum	307643	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g36958	i0	99.597	4.98387096774194	248	1	100	0	1	248	1735118	1735365	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	1236	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
4831620	4831620	PRJNA1022139_P_NODE_37804_length_247_cov_0.885057_g37699_i0	PRJNA1022139	37804	247	0.885057	2.18609079	Oscillospiraceae	216572	Bacteria	Bacteria	58.4	4.8e-4	NTclustered	gi\|2058324695\|gb\|CP034413.3\|	2093857	g37699	i0	100	0.376518218623482	31	0	13	0	133	163	2807419	2807449	Dysosmobacter welbionis strain J115 chromosome, complete genome	blastn	93	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Dysosmobacter	Dysosmobacter welbionis
6539768	6539768	PRJNA1022139_P_NODE_14006_length_364_cov_1.041237_g13901_i0	PRJNA1022139	14006	364	1.041237	3.79010268	Candidatus Faecalibacterium intestinigallinarum	2838581	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2729058703\|emb\|OZ007003.1\|	2838581	g13901	i0	92.308	0.107142857142857	39	3	11	0	101	139	101612	101574	MAG: Candidatus Faecalibacterium intestinigallinarum isolate 6755_HET_CTRL_s271.ctg000340c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	39	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Candidatus Faecalibacterium intestinigallinarum
6539833	6539833	PRJNA1022139_P_NODE_25106_length_284_cov_1.507109_g25001_i0	PRJNA1022139	25106	284	1.507109	4.28018956	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	486	6.069999999999999e-133	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g25001	i0	97.535	3	284	7	100	0	1	284	768620	768903	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	852	486	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
6539896	6539896	PRJNA1022139_P_NODE_33706_length_253_cov_0.933333_g33601_i0	PRJNA1022139	33706	253	0.933333	2.36133249	[Eubacterium] sulci	143393	Bacteria	Bacteria	58.4	4.93e-4	NTclustered	gi\|908720056\|gb\|CP012068.1\|	888727	g33601	i0	90.698	0.1699604743083	43	4	17	0	67	109	1336918	1336960	Eubacterium sulci ATCC 35585, complete genome	blastn	43	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		[Eubacterium] sulci
6539943	6539943	PRJNA1022139_P_NODE_38326_length_246_cov_2.352601_g38221_i0	PRJNA1022139	38326	246	2.352601	5.78739846	Staphylococcus cohnii	29382	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g38221	i0	100	12.5325203252033	246	0	100	0	1	246	1909194	1909439	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	3083	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
6539964	6539964	PRJNA1022139_P_NODE_41486_length_243_cov_0.905882_g41381_i0	PRJNA1022139	41486	243	0.905882	2.20129326	Streptococcus sanguinis	1305	Bacteria	Bacteria	414	2.4299999999999998e-111	NTclustered	gi\|1539215237\|emb\|LR134002.1\|	1305	g41381	i0	97.521	10.9300411522634	242	6	99	0	2	243	59525	59766	Streptococcus sanguinis strain NCTC10904 genome assembly, chromosome: 1	blastn	2656	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
8656767	8656767	PRJNA1022139_P_NODE_38847_length_246_cov_0.890173_g38742_i0	PRJNA1022139	38847	246	0.890173	2.18982558	Staphylococcus	1279	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1678596494\|gb\|CP035288.1\|	1282	g38742	i0	100	37.890243902439	246	0	100	0	1	246	103229	103474	Staphylococcus epidermidis strain ATCC 14990 chromosome, complete genome	blastn	9321	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9089282	9089282	PRJNA1022139_P_NODE_35848_length_249_cov_1.750000_g35743_i0	PRJNA1022139	35848	249	1.75	4.3575	Intestinibaculum porci	2487118	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1514766016\|dbj\|AP019309.1\|	2487118	g35743	i0	100	0.112449799196787	28	0	11	0	216	243	856834	856861	Erysipelotrichaceae bacterium SG0102 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Intestinibaculum	Intestinibaculum porci
9089403	9089403	PRJNA1022139_P_NODE_8_length_3668_cov_12.609179_g6_i0	PRJNA1022139	8	3668	12.609179	462.50468572	Candidatus Faecalibacterium intestinigallinarum	2838581	Bacteria	Bacteria	56.5	0.03	NTclustered	gi\|2729058703\|emb\|OZ007003.1\|	2838581	g6	i0	96.97	0.00899672846237732	33	1	1	0	2640	2672	1049234	1049266	MAG: Candidatus Faecalibacterium intestinigallinarum isolate 6755_HET_CTRL_s271.ctg000340c_hifiasm_circ MAG genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Candidatus Faecalibacterium intestinigallinarum
11640230	11640230	PRJNA1022139_P_NODE_29110_length_270_cov_1.497462_g29005_i0	PRJNA1022139	29110	270	1.497462	4.0431474	Erysipelothrix sp. HDW6B	2714929	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1821142185\|gb\|CP049860.1\|	2714929	g29005	i0	100	0.107407407407407	29	0	11	0	211	239	378632	378604	Erysipelothrix sp. HDW6B chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix sp. HDW6B
11640240	11640240	PRJNA1022139_P_NODE_30230_length_266_cov_1.357513_g30125_i0	PRJNA1022139	30230	266	1.357513	3.6109845800000002	Staphylococcus hominis	1290	Bacteria	Bacteria	492	1.2099999999999999e-134	NTclustered	gi\|2669657801\|gb\|CP090014.1\|	1290	g30125	i0	100	26	266	0	100	0	1	266	154230	154495	Staphylococcus hominis strain acrlk chromosome, complete genome	blastn	6916	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
11640247	11640247	PRJNA1022139_P_NODE_30_length_2890_cov_2.893504_g26_i0	PRJNA1022139	30	2890	2.893504	83.6222656	Bacillus thuringiensis	1428	Bacteria	Bacteria	230	1.2899999999999997e-54	NTclustered	gi\|942009880\|gb\|CP013000.1\|	1428	g26	i0	84.716	0.790311418685121	229	35	8	0	2425	2653	2009241	2009013	Bacillus thuringiensis strain XL6 chromosome, complete genome	blastn	2284	230	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
11640345	11640345	PRJNA1022139_P_NODE_43050_length_241_cov_0.916667_g42945_i0	PRJNA1022139	43050	241	0.916667	2.20916747	Peptoniphilus harei	54005	Bacteria	Bacteria	357	4.1099999999999997e-94	NTclustered	gi\|1540270891\|emb\|LR134524.1\|	54005	g42945	i0	93.361	195.54356846473	241	16	100	0	1	241	219628	219388	Peptoniphilus harei strain NCTC13077 genome assembly, chromosome: 1	blastn	47126	357	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
12482466	12482466	PRJNA1022139_P_NODE_41330_length_243_cov_0.905882_g41225_i0	PRJNA1022139	41330	243	0.905882	2.20129326	Staphylococcus	1279	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g41225	i0	100	100	243	0	100	0	1	243	2050382	2050140	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24300	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
15464440	15464440	PRJNA1022139_P_NODE_36373_length_249_cov_0.875000_g36268_i0	PRJNA1022139	36373	249	0.875	2.17875	Staphylococcus epidermidis	1282	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|1388788816\|gb\|MH090918.1\|	1282	g36268	i0	96.787	1	249	8	100	0	1	249	1336	1088	Staphylococcus epidermidis strain 23S plasmid pLF23/2, complete sequence	blastn	249	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18013456	18013456	PRJNA1022139_P_NODE_24995_length_285_cov_1.084906_g24890_i0	PRJNA1022139	24995	285	1.084906	3.0919821	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|2175038431\|gb\|CP085279.1\|	170573	g24890	i0	98.596	3	285	4	100	0	1	285	1371883	1371599	Staphylococcus pettenkoferi strain SP165 chromosome	blastn	855	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
18855234	18855234	PRJNA1022139_P_NODE_31135_length_262_cov_2.222222_g31030_i0	PRJNA1022139	31135	262	2.222222	5.82222164	Staphylococcus	1279	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g31030	i0	99.618	52.9236641221374	262	1	100	0	1	262	1567811	1567550	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	13866	479	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
19287414	19287414	PRJNA1022139_P_NODE_37076_length_248_cov_0.880000_g36971_i0	PRJNA1022139	37076	248	0.88	2.1824	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	320	5.57e-83	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g36971	i0	89.919	51.9637096774194	248	25	100	0	1	248	511894	511647	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	12887	320	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
20562884	20562884	PRJNA1022139_P_NODE_38217_length_247_cov_0.885057_g38112_i0	PRJNA1022139	38217	247	0.885057	2.18609079	Caproiciproducens sp. CPB-2	3030017	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2663189403\|gb\|CP142860.1\|	3030017	g38112	i0	100	0.11336032388664	28	0	11	0	160	187	3105546	3105573	Caproiciproducens sp. CPB-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Acutalibacteraceae	Caproiciproducens	Caproiciproducens sp. CPB-2
21405672	21405672	PRJNA1022139_P_NODE_1897_length_882_cov_2.970334_g1820_i0	PRJNA1022139	1897	882	2.970334	26.19834588	Leuconostoc	1243	Bacteria	Bacteria	237	2.29e-57	NTclustered	gi\|1721181998\|gb\|CP042376.1\|	1252	g1820	i0	84.937	4.49433106575964	239	30	27	3	66	304	5857	6089	Leuconostoc carnosum strain CBA3620 plasmid unnamed2, complete sequence	blastn	3964	237	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc carnosum
21838474	21838474	PRJNA1022139_P_NODE_27198_length_277_cov_1.382353_g27093_i0	PRJNA1022139	27198	277	1.382353	3.82911781	Gemella haemolysans	1379	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g27093	i0	100	359.072202166065	277	0	100	0	1	277	735742	735466	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	99463	512	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
23114009	23114009	PRJNA1022139_P_NODE_39079_length_245_cov_3.279070_g38974_i0	PRJNA1022139	39079	245	3.27907	8.0337215	uncultured Peptococcaceae bacterium	329911	Bacteria	Bacteria	237	5.69e-58	NTclustered	gi\|2729058704\|emb\|OZ007004.1\|	329911	g38974	i0	86.792	383.889795918367	212	28	87	0	34	245	187881	187670	MAG: uncultured Peptococcaceae bacterium isolate 6732_HOM_VAC_s129.ctg000173l_hifiasm_large MAG genome assembly, chromosome: 1	blastn	94053	237	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae		uncultured Peptococcaceae bacterium
24387749	24387749	PRJNA1022139_P_NODE_27880_length_274_cov_2.208955_g27775_i0	PRJNA1022139	27880	274	2.208955	6.0525367	Staphylococcus hominis	1290	Bacteria	Bacteria	481	2.71e-131	NTclustered	gi\|1854288993\|gb\|CP054550.1\|	1290	g27775	i0	98.885	12.7956204379562	269	3	98	0	1	269	211094	211362	Staphylococcus hominis strain FDAARGOS_661 chromosome, complete genome	blastn	3506	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
25229803	25229803	PRJNA1022139_P_NODE_29720_length_268_cov_1.287179_g29615_i0	PRJNA1022139	29720	268	1.287179	3.44963972	Staphylococcus	1279	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g29615	i0	100	26	268	0	100	0	1	268	694138	694405	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	6968	496	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis

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