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

30 rows where analysis = "blastn", bioproject = "PRJNA169559" 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
1054854	1054854	PRJNA169559_P_NODE_27621_length_278_cov_9.128514_g25545_i0	PRJNA169559	27621	278	9.128514	25.37726892	root	1	Root_unresolved	Root_unresolved	505	1.63e-138	NTclustered	gi\|51863285\|gb\|AY672461.1\|	1260	g25545	i0	99.638	99.3021582733813	276	1	99	0	1	276	289	14	Finegoldia magna strain EP3 16S ribosomal RNA gene, partial sequence	blastn	27606	510	0.990196078431373	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
1639813	1639813	PRJNA169559_P_NODE_28862_length_271_cov_1.520661_g26786_i0	PRJNA169559	28862	271	1.520661	4.12099131	Chordicoccus furentiruminis	2709410	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2072779649\|gb\|CP048829.1\|	2709410	g26786	i0	96.97	0.328413284132841	33	1	12	0	231	263	2715112	2715080	Chordicoccus furentiruminis strain MP1D12 chromosome, complete genome	blastn	89	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Chordicoccus	Chordicoccus furentiruminis
1639887	1639887	PRJNA169559_P_NODE_4442_length_800_cov_7.448768_g3195_i0	PRJNA169559	4442	800	7.448768	59.590144	Megasphaera stantonii	2144175	Bacteria	Bacteria	795	0	NTclustered	gi\|1444866017\|gb\|CP029462.1\|	2144175	g3195	i0	89.432	500.82125	634	61	99	6	1	630	1280475	1279844	Megasphaera stantonii strain AJH120 chromosome, complete genome	blastn	400657	795	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera stantonii
3605268	3605268	PRJNA169559_P_NODE_39023_length_237_cov_2.221154_g36946_i0	PRJNA169559	39023	237	2.221154	5.26413498	Bacteria	2	Bacteria	Bacteria	130	9.55e-26	NTclustered	gi\|2325889609\|gb\|CP110383.1\|	69823	g36946	i0	76.891	27.4430379746835	238	49	99	6	3	237	1206885	1206651	Selenomonas sputigena strain KCOM 1787 chromosome	blastn	6504	130	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sputigena
4191917	4191917	PRJNA169559_P_NODE_11544_length_495_cov_67.793991_g9710_i0	PRJNA169559	11544	495	67.793991	335.58025545	Dolosigranulum pigrum	29394	Bacteria	Bacteria	909	0	NTclustered	gi\|2020658269\|gb\|CP040423.1\|	29394	g9710	i0	99.798	397.860606060606	495	1	100	0	1	495	1398208	1398702	Dolosigranulum pigrum strain KPL3043 chromosome, complete genome	blastn	196941	909	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Dolosigranulum	Dolosigranulum pigrum
4882792	4882792	PRJNA169559_P_NODE_46424_length_194_cov_41.981818_g44347_i0	PRJNA169559	46424	194	41.981818	81.44472692	Staphylococcus	1279	Bacteria	Bacteria	292	9.06e-75	NTclustered	gi\|2071683663\|gb\|CP073835.1\|	1282	g44347	i0	93.814	490.030927835052	194	12	100	0	1	194	2137904	2137711	Staphylococcus epidermidis strain B1230143 chromosome, complete genome	blastn	95066	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6157578	6157578	PRJNA169559_P_NODE_46125_length_199_cov_2.923529_g44048_i0	PRJNA169559	46125	199	2.923529	5.81782271	FCB group	1783270	Bacteria	Bacteria	305	1.2e-78	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g44048	i0	94.444	524.35175879397	198	11	99	0	2	199	522294	522097	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	104346	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
6157582	6157582	PRJNA169559_P_NODE_47645_length_173_cov_7.479167_g45568_i0	PRJNA169559	47645	173	7.479167	12.93895891	Megasphaera	906	Bacteria	Bacteria	267	4.77e-67	NTclustered	gi\|2777638275\|dbj\|AP031433.1\|	907	g45568	i0	94.798	201.092485549133	173	6	100	3	1	173	2305154	2305323	Megasphaera elsdenii i33-0019-1i4 DNA, complete genome	blastn	34789	267	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera elsdenii
6157598	6157598	PRJNA169559_P_NODE_8765_length_574_cov_4.322936_g7100_i0	PRJNA169559	8765	574	4.322936	24.81365264	Finegoldia	150022	Bacteria	Bacteria	737	0	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g7100	i0	96.629	429.08362369338	445	13	89	2	1	444	374974	375417	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	246294	737	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
7432723	7432723	PRJNA169559_P_NODE_25046_length_301_cov_81.014706_g22970_i0	PRJNA169559	25046	301	81.014706	243.85426506	root	1	Root_unresolved	Root_unresolved	512	1.07e-140	NTclustered	gi\|2886140208\|gb\|PQ867405.1\|	1306	g22970	i0	97.342	105.890365448505	301	8	100	0	1	301	15	315	Streptococcus sp. strain IMAU11621 16S ribosomal RNA gene, partial sequence	blastn	31873	512	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
7432753	7432753	PRJNA169559_P_NODE_9686_length_545_cov_132.213178_g7955_i0	PRJNA169559	9686	545	132.213178	720.5618201	Streptococcus	1301	Bacteria	Bacteria	636	1.16e-177	NTclustered	gi\|1737764884\|gb\|MN446969.1\|	1308	g7955	i0	98.093	67.3284403669725	367	3	67	3	1	364	366	1	Streptococcus thermophilus strain A6894 16S ribosomal RNA gene, partial sequence	blastn	36694	636	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
8018465	8018465	PRJNA169559_P_NODE_46047_length_200_cov_3.210526_g43970_i0	PRJNA169559	46047	200	3.210526	6.421052	Peptoniphilus harei	54005	Bacteria	Bacteria	178	2.75e-40	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g43970	i0	97.143	109.34	105	3	80	0	3	107	766652	766756	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	21868	178	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
9982853	9982853	PRJNA169559_P_NODE_47548_length_175_cov_18.294521_g45471_i0	PRJNA169559	47548	175	18.294521	32.01541175	Staphylococcaceae	90964	Bacteria	Bacteria	285	1.3399999999999998e-72	NTclustered	gi\|2710592888\|gb\|CP121234.2\|	1280	g45471	i0	96	523.022857142857	175	7	100	0	1	175	396642	396468	Staphylococcus aureus strain OD001 chromosome, complete genome	blastn	91529	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
10569207	10569207	PRJNA169559_P_NODE_47749_length_171_cov_12.978873_g45672_i0	PRJNA169559	47749	171	12.978873	22.19387283	Thermaerobacillus caldiproteolyticus	247480	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|1929914214\|gb\|CP064060.1\|	247480	g45672	i0	98.83	904.391812865497	171	2	100	0	1	171	2548318	2548488	Thermaerobacillus caldiproteolyticus strain U458 chromosome, complete genome	blastn	154651	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Thermaerobacillus	Thermaerobacillus caldiproteolyticus
11258042	11258042	PRJNA169559_P_NODE_2109_length_1137_cov_7.698556_g1293_i0	PRJNA169559	2109	1137	7.698556	87.53258172	Megasphaera	906	Bacteria	Bacteria	837	0	NTclustered	gi\|2777638275\|dbj\|AP031433.1\|	907	g1293	i0	91.368	375.795074758135	614	50	54	3	524	1136	2304940	2304329	Megasphaera elsdenii i33-0019-1i4 DNA, complete genome	blastn	427279	843	0.99288256227758	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera elsdenii
11258053	11258053	PRJNA169559_P_NODE_25989_length_292_cov_1.117871_g23913_i0	PRJNA169559	25989	292	1.117871	3.26418332	Brevibacillus	55080	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1563146209\|gb\|CP026363.1\|	51101	g23913	i0	100	0.287671232876712	28	0	10	0	246	273	2334567	2334594	Brevibacillus agri strain DSM 6348 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus agri
12533423	12533423	PRJNA169559_P_NODE_2210_length_1110_cov_7.839038_g1293_i1	PRJNA169559	2210	1110	7.839038	87.0133218	Megasphaera	906	Bacteria	Bacteria	859	0	NTclustered	gi\|507148370\|ref\|NR_103173.1\|	907	g1293	i1	91.774	398.376576576577	620	48	56	3	2	620	997	380	Megasphaera elsdenii strain DSM 20460 23S ribosomal RNA gene, complete sequence	blastn	442198	861	0.997677119628339	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera elsdenii
12533434	12533434	PRJNA169559_P_NODE_28790_length_271_cov_2.669421_g26714_i0	PRJNA169559	28790	271	2.669421	7.23413091	Staphylococcus	1279	Bacteria	Bacteria	239	1.78e-58	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g26714	i0	100	85.6088560885609	129	0	86	0	143	271	2335746	2335874	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	23200	239	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13808199	13808199	PRJNA169559_P_NODE_19231_length_385_cov_2.185393_g17209_i0	PRJNA169559	19231	385	2.185393	8.41376305	Paenibacillus	44249	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1774453940\|gb\|CP045802.1\|	2660554	g17209	i0	100	0.155844155844156	30	0	8	0	150	179	270721	270692	Paenibacillus sp. B01 chromosome, complete genome	blastn	60	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. B01
16942279	16942279	PRJNA169559_P_NODE_28234_length_274_cov_3.628571_g26158_i0	PRJNA169559	28234	274	3.628571	9.94228454	Peptoniphilus harei	54005	Bacteria	Bacteria	462	9.81e-126	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g26158	i0	97.08	512.576642335766	274	8	100	0	1	274	765840	765567	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	140446	462	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
17632465	17632465	PRJNA169559_P_NODE_48594_length_156_cov_2.141732_g46517_i0	PRJNA169559	48594	156	2.141732	3.34110192	root	1	Root_unresolved	Root_unresolved	283	4.1899999999999994e-72	NTclustered	gi\|2057483962\|gb\|MZ443983.1\|	1351	g46517	i0	99.359	133	156	1	100	0	1	156	253	98	Enterococcus faecalis strain HAPH10 16S ribosomal RNA gene, partial sequence	blastn	20748	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
18216717	18216717	PRJNA169559_P_NODE_2935_length_965_cov_8.986111_g1293_i2	PRJNA169559	2935	965	8.986111	86.71597115	Finegoldia magna	1260	Bacteria	Bacteria	998	0	NTclustered	gi\|2722736583\|dbj\|AP031486.1\|	1260	g1293	i2	85.553	483.611398963731	976	116	99	17	2	965	172366	171404	Finegoldia magna NBRC 113804 DNA, complete genome: sequence1	blastn	466685	998	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
18216766	18216766	PRJNA169559_P_NODE_38495_length_238_cov_5.708134_g36418_i0	PRJNA169559	38495	238	5.708134	13.58535892	Finegoldia magna	1260	Bacteria	Bacteria	433	6.53e-117	NTclustered	gi\|2722736583\|dbj\|AP031486.1\|	1260	g36418	i0	99.578	476.5	237	1	99	0	2	238	636512	636276	Finegoldia magna NBRC 113804 DNA, complete genome: sequence1	blastn	113407	433	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
19490994	19490994	PRJNA169559_P_NODE_29896_length_265_cov_2.711864_g27820_i0	PRJNA169559	29896	265	2.711864	7.1864396	Peptacetobacter hiranonis	89152	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1957925084\|gb\|CP066811.1\|	89152	g27820	i0	100	1049.9320754717	265	0	100	0	1	265	19997	19733	Peptacetobacter hiranonis strain DGF055142 chromosome, complete genome	blastn	278232	490	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptacetobacter	Peptacetobacter hiranonis
19491128	19491128	PRJNA169559_P_NODE_48396_length_159_cov_4.115385_g46319_i0	PRJNA169559	48396	159	4.115385	6.54346215	Thermaerobacillus caldiproteolyticus	247480	Bacteria	Bacteria	276	7.18e-70	NTclustered	gi\|1929914214\|gb\|CP064060.1\|	247480	g46319	i0	98.101	744.937106918239	158	3	99	0	1	158	3682075	3682232	Thermaerobacillus caldiproteolyticus strain U458 chromosome, complete genome	blastn	118445	276	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Thermaerobacillus	Thermaerobacillus caldiproteolyticus
20766746	20766746	PRJNA169559_P_NODE_8697_length_576_cov_8.985375_g7034_i0	PRJNA169559	8697	576	8.985375	51.75576	Megasphaera stantonii	2144175	Bacteria	Bacteria	416	1.75e-111	NTclustered	gi\|2729058675\|emb\|OZ006975.1\|	2144175	g7034	i0	88.791	125.881944444444	339	38	59	0	2	340	87873	87535	MAG: Megasphaera stantonii isolate 6755_HET_CTRL_contig_17144_metaflye_large MAG genome assembly, chromosome: 1	blastn	72508	416	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera stantonii
22731599	22731599	PRJNA169559_P_NODE_28198_length_274_cov_19.367347_g26122_i0	PRJNA169559	28198	274	19.367347	53.06653078	Anoxybacillaceae	3120669	Bacteria	Bacteria	473	4.53e-129	NTclustered	gi\|1024277742\|gb\|CP015438.1\|	294699	g26122	i0	97.81	929.57299270073	274	6	100	0	1	274	1548	1821	Anoxybacteroides amylolyticum strain DSM 15939 chromosome, complete genome	blastn	254703	473	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides amylolyticum
22731612	22731612	PRJNA169559_P_NODE_46478_length_193_cov_186.841463_g44401_i0	PRJNA169559	46478	193	186.841463	360.60402359	root	1	Root_unresolved	Root_unresolved	337	4.099999999999999e-88	NTclustered	gi\|2621740771\|gb\|CP138360.1\|	1280	g44401	i0	98.429	113.766839378238	191	3	99	0	1	191	506706	506516	Staphylococcus aureus strain 17CS1042 chromosome, complete genome	blastn	21957	340	0.991176470588235	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
24006776	24006776	PRJNA169559_P_NODE_21419_length_351_cov_217.751553_g19356_i0	PRJNA169559	21419	351	217.751553	764.30795103	Bacillota	1239	Bacteria	Bacteria	621	2.02e-173	NTclustered	gi\|2313057121\|gb\|CP094729.1\|	1282	g19356	i0	98.575	352.014245014245	351	5	100	0	1	351	778253	778603	Staphylococcus epidermidis strain IVB6210 chromosome, complete genome	blastn	123557	627	0.990430622009569	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25280870	25280870	PRJNA169559_P_NODE_24720_length_305_cov_50.231884_g22644_i0	PRJNA169559	24720	305	50.231884	153.2072462	Staphylococcaceae	90964	Bacteria	Bacteria	503	6.53e-138	NTclustered	gi\|2032419101\|gb\|CP046590.1\|	1855823	g22644	i0	96.405	550.304918032787	306	9	100	2	1	305	839459	839763	Macrococcoides canis strain LI021 chromosome, complete genome	blastn	167843	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcoides	Macrococcoides canis

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