metadata: contig_metadata: 34 rows where bioproject = "PRJNA1012699" and tax

34 rows where bioproject = "PRJNA1012699" 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
158011	158011	PRJNA1012699_P_NODE_2721_length_252_cov_3.480447_g2689_i0	PRJNA1012699	2721	252	3.480447	8.77072644	Finegoldia magna	1260	Bacteria	Bacteria	464	2.4799999999999998e-126	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g2689	i0	100	298.734126984127	251	0	99	0	2	252	163603	163353	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	75281	464	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
1002465	1002465	PRJNA1012699_P_NODE_2021_length_279_cov_1.509709_g1989_i0	PRJNA1012699	2021	279	1.509709	4.21208811	Streptococcus	1301	Bacteria	Bacteria	460	3.5999999999999997e-125	NTclustered	gi\|1247204361\|gb\|CP023507.1\|	1303	g1989	i0	96.739	98.9247311827957	276	9	99	0	2	277	1994754	1995029	Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome	blastn	27600	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
1432830	1432830	PRJNA1012699_P_NODE_2342_length_264_cov_1.403141_g2310_i0	PRJNA1012699	2342	264	1.403141	3.70429224	Staphylococcus warneri	1292	Bacteria	Bacteria	484	2.0099999999999994e-132	NTclustered	gi\|1539664116\|emb\|LR134242.1\|	1292	g2310	i0	100	98.7462121212121	262	0	99	0	2	263	1857145	1856884	Staphylococcus warneri strain NCTC4133 genome assembly, chromosome: 1	blastn	26069	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
2708375	2708375	PRJNA1012699_P_NODE_3903_length_243_cov_0.911765_g3871_i0	PRJNA1012699	3903	243	0.911765	2.21558895	Kurthia zopfii	1650	Bacteria	Bacteria	399	6.789999999999999e-107	NTclustered	gi\|1540140676\|emb\|LR134474.1\|	1650	g3871	i0	96.016	617.860082304527	251	0	99	1	2	242	706225	706475	Kurthia zopfii strain NCTC404 genome assembly, chromosome: 1	blastn	150140	399	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Kurthia	Kurthia zopfii
3552982	3552982	PRJNA1012699_P_NODE_4023_length_242_cov_0.917160_g3991_i0	PRJNA1012699	4023	242	0.91716	2.2195272	Staphylococcus	1279	Bacteria	Bacteria	444	3.08e-120	NTclustered	gi\|1143273938\|gb\|CP019597.1\|	29382	g3991	i0	100	97.9669421487603	240	0	99	0	2	241	528025	528264	Staphylococcus cohnii strain SNUDS-2 chromosome, complete genome	blastn	23708	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
4830445	4830445	PRJNA1012699_P_NODE_2884_length_251_cov_0.876404_g2852_i0	PRJNA1012699	2884	251	0.876404	2.19977404	Streptococcus	1301	Bacteria	Bacteria	462	8.869999999999999e-126	NTclustered	gi\|1578069334\|emb\|LR216032.1\|	1313	g2852	i0	100	100.597609561753	250	0	99	0	2	251	852787	853036	Streptococcus pneumoniae strain 2245STDY5775874 genome assembly, chromosome: 1	blastn	25250	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
5260871	5260871	PRJNA1012699_P_NODE_2565_length_255_cov_1.708791_g2533_i0	PRJNA1012699	2565	255	1.708791	4.35741705	Streptococcus sp. SN-1	3074854	Bacteria	Bacteria	307	4.48e-79	NTclustered	gi\|2747375947\|dbj\|AP028929.1\|	3074854	g2533	i0	88.417	32.5137254901961	259	25	100	4	1	255	1440916	1440659	Streptococcus sp. SN-1 DNA, complete genome	blastn	8291	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. SN-1
5260885	5260885	PRJNA1012699_P_NODE_3505_length_246_cov_0.901734_g3473_i0	PRJNA1012699	3505	246	0.901734	2.21826564	Gemella haemolysans	1379	Bacteria	Bacteria	396	8.909999999999996e-106	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g3473	i0	95.902	2.89837398373984	244	10	99	0	2	245	1854112	1854355	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	713	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
5260888	5260888	PRJNA1012699_P_NODE_3625_length_245_cov_0.906977_g3593_i0	PRJNA1012699	3625	245	0.906977	2.22209365	Streptococcus oralis	1303	Bacteria	Bacteria	396	8.869999999999996e-106	NTclustered	gi\|1708318049\|gb\|CP034442.1\|	1458253	g3593	i0	95.902	98.8081632653061	244	10	99	0	1	244	746060	745817	Streptococcus oralis subsp. dentisani strain F0392 chromosome, complete genome	blastn	24208	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
7380068	7380068	PRJNA1012699_P_NODE_2166_length_272_cov_1.567839_g2134_i0	PRJNA1012699	2166	272	1.567839	4.26452208	Staphylococcus	1279	Bacteria	Bacteria	501	2.06e-137	NTclustered	gi\|1143273938\|gb\|CP019597.1\|	29382	g2134	i0	100	98.4338235294118	271	0	99	0	1	271	96139	95869	Staphylococcus cohnii strain SNUDS-2 chromosome, complete genome	blastn	26774	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
8655610	8655610	PRJNA1012699_P_NODE_4047_length_239_cov_3.084337_g4015_i0	PRJNA1012699	4047	239	3.084337	7.37156543	Anaerococcus	165779	Bacteria	Bacteria	405	1.43e-108	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g4015	i0	97.468	295.577405857741	237	6	99	0	2	238	179827	179591	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	70643	405	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
9085571	9085571	PRJNA1012699_P_NODE_1568_length_303_cov_3.643478_g1536_i0	PRJNA1012699	1568	303	3.643478	11.03973834	Anaerococcus sp. WGS1579	3366809	Bacteria	Bacteria	536	6.389999999999999e-148	NTclustered	gi\|2831319668\|gb\|CP171106.1\|	3366809	g1536	i0	98.997	620.211221122112	299	3	99	0	2	300	371540	371242	Anaerococcus sp. WGS1579 chromosome, complete genome	blastn	187924	536	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1579
9085603	9085603	PRJNA1012699_P_NODE_3388_length_247_cov_0.896552_g3356_i0	PRJNA1012699	3388	247	0.896552	2.21448344	Staphylococcus ureilyticus	94138	Bacteria	Bacteria	448	2.4399999999999993e-121	NTclustered	gi\|2905461398\|gb\|CP180185.1\|	94138	g3356	i0	99.593	0.995951417004049	246	0	99	1	1	246	2489182	2488938	Staphylococcus ureilyticus strain RSM-JSascm chromosome	blastn	246	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus ureilyticus
9085609	9085609	PRJNA1012699_P_NODE_3788_length_243_cov_2.105882_g3756_i0	PRJNA1012699	3788	243	2.105882	5.11729326	Streptococcus koreensis	2382163	Bacteria	Bacteria	436	5.18e-118	NTclustered	gi\|1487524770\|gb\|CP032620.1\|	2382163	g3756	i0	99.174	466.707818930041	242	2	99	0	1	242	67153	66912	Streptococcus koreensis strain JS71 chromosome, complete genome	blastn	113410	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus koreensis
9930455	9930455	PRJNA1012699_P_NODE_2008_length_279_cov_4.825243_g1976_i0	PRJNA1012699	2008	279	4.825243	13.46242797	Anaerococcus	165779	Bacteria	Bacteria	460	3.5999999999999997e-125	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g1976	i0	96.429	354.336917562724	280	8	99	1	2	279	180799	180520	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	98860	460	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
11205704	11205704	PRJNA1012699_P_NODE_2649_length_253_cov_0.866667_g2617_i0	PRJNA1012699	2649	253	0.866667	2.19266751	Bacillales	1385	Bacteria	Bacteria	466	6.9199999999999996e-127	NTclustered	gi\|2432632113\|gb\|OP378667.1\|	1280	g2617	i0	100	99.604743083004	252	0	99	0	2	253	14425	14676	Staphylococcus aureus strain MRSA10075 plasmid pMRSA10075_2, complete sequence	blastn	25200	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12911644	12911644	PRJNA1012699_P_NODE_4011_length_242_cov_0.923077_g3979_i0	PRJNA1012699	4011	242	0.923077	2.23384634	Streptococcus sp. LPB0220	2610896	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1752759834\|gb\|CP044230.1\|	2610896	g3979	i0	100	10.1818181818182	239	0	99	0	1	239	1611285	1611523	Streptococcus sp. LPB0220 chromosome, complete genome	blastn	2464	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. LPB0220
14186639	14186639	PRJNA1012699_P_NODE_2992_length_250_cov_0.881356_g2960_i0	PRJNA1012699	2992	250	0.881356	2.20339	Aerococcus mictus	2976810	Bacteria	Bacteria	411	3.239999999999999e-110	NTclustered	gi\|2678451185\|gb\|CP145132.1\|	2976810	g2960	i0	96.386	82.312	249	9	99	0	1	249	2067722	2067970	Aerococcus mictus strain UMB1016 chromosome, complete genome	blastn	20578	411	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus mictus
15030173	15030173	PRJNA1012699_P_NODE_892_length_383_cov_3.867742_g860_i0	PRJNA1012699	892	383	3.867742	14.81345186	Anaerococcus	165779	Bacteria	Bacteria	671	0	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g860	i0	98.429	373.195822454308	382	5	99	1	2	382	180267	179886	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	142934	671	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
16304905	16304905	PRJNA1012699_P_NODE_833_length_395_cov_1.857143_g801_i0	PRJNA1012699	833	395	1.857143	7.33571485	Anaerococcus	165779	Bacteria	Bacteria	708	0	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g801	i0	99.237	54.526582278481	393	2	99	1	2	394	398	7	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	21538	708	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
16734996	16734996	PRJNA1012699_P_NODE_4114_length_231_cov_3.360759_g4082_i0	PRJNA1012699	4114	231	3.360759	7.76335329	Finegoldia magna	1260	Bacteria	Bacteria	418	1.7699999999999994e-112	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g4082	i0	99.563	414.424242424242	229	1	99	0	2	230	162572	162800	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	95732	418	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
17580283	17580283	PRJNA1012699_P_NODE_574_length_456_cov_3.610966_g542_i0	PRJNA1012699	574	456	3.610966	16.46600496	Streptococcus	1301	Bacteria	Bacteria	835	0	NTclustered	gi\|1539702073\|emb\|LR134266.1\|	78535	g542	i0	99.78	335.276315789474	455	1	99	0	2	456	18324	18778	Streptococcus viridans strain NCTC3166 genome assembly, chromosome: 1	blastn	152886	835	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus viridans
18854102	18854102	PRJNA1012699_P_NODE_3415_length_247_cov_0.890805_g3383_i0	PRJNA1012699	3415	247	0.890805	2.20028835	Staphylococcus	1279	Bacteria	Bacteria	449	6.78e-122	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3383	i0	99.593	99.5951417004049	246	1	99	0	1	246	981212	980967	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24600	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18854103	18854103	PRJNA1012699_P_NODE_3695_length_244_cov_0.912281_g3663_i0	PRJNA1012699	3695	244	0.912281	2.22596564	Streptococcus	1301	Bacteria	Bacteria	436	5.2e-118	NTclustered	gi\|2886512733\|emb\|OZ217346.1\|	28037	g3663	i0	99.174	12.5081967213115	242	2	99	0	2	243	260917	261158	Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1	blastn	3052	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
18854104	18854104	PRJNA1012699_P_NODE_4135_length_230_cov_2.254777_g4103_i0	PRJNA1012699	4135	230	2.254777	5.1859871	Streptococcus	1301	Bacteria	Bacteria	422	1.36e-113	NTclustered	gi\|2796999144\|gb\|PQ270397.1\|	1306	g4103	i0	100	105.086956521739	228	0	99	0	2	229	131	358	Streptococcus sp. strain 3Hb1 16S ribosomal RNA gene, partial sequence	blastn	24170	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp.
19283635	19283635	PRJNA1012699_P_NODE_2116_length_274_cov_2.437811_g2084_i0	PRJNA1012699	2116	274	2.437811	6.67960214	Streptococcus mitis	28037	Bacteria	Bacteria	505	1.61e-138	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g2084	i0	100	342.729927007299	273	0	99	0	1	273	17379	17107	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	93908	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
20128820	20128820	PRJNA1012699_P_NODE_2916_length_251_cov_0.876404_g2884_i0	PRJNA1012699	2916	251	0.876404	2.19977404	Staphylococcus	1279	Bacteria	Bacteria	455	1.48e-123	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g2884	i0	99.598	25.792828685259	249	1	99	0	2	250	1537771	1537523	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	6474	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
20559201	20559201	PRJNA1012699_P_NODE_2817_length_252_cov_0.871508_g2785_i0	PRJNA1012699	2817	252	0.871508	2.19620016	Veillonella parvula	29466	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g2785	i0	99.206	10	252	2	100	0	1	252	804891	804640	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	2520	455	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
20559209	20559209	PRJNA1012699_P_NODE_3117_length_249_cov_0.886364_g3085_i0	PRJNA1012699	3117	249	0.886364	2.20704636	Staphylococcus epidermidis	1282	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|1979651145\|gb\|CP052959.1\|	1282	g3085	i0	97.59	91.0682730923695	249	4	99	2	1	248	798544	798791	Staphylococcus epidermidis strain HD46-1 chromosome, complete genome	blastn	22676	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21834860	21834860	PRJNA1012699_P_NODE_3038_length_250_cov_0.881356_g3006_i0	PRJNA1012699	3038	250	0.881356	2.20339	Streptococcus sp. 116-D4	2598453	Bacteria	Bacteria	398	2.5199999999999997e-106	NTclustered	gi\|1778008955\|dbj\|AP021887.1\|	2598453	g3006	i0	95.565	99.212	248	11	99	0	2	249	679846	679599	Streptococcus sp. 116-D4 DNA, complete genome	blastn	24803	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. 116-D4
22679235	22679235	PRJNA1012699_P_NODE_3618_length_245_cov_0.906977_g3586_i0	PRJNA1012699	3618	245	0.906977	2.22209365	Streptococcus	1301	Bacteria	Bacteria	361	3.2399999999999996e-95	NTclustered	gi\|1948640724\|gb\|CP066041.1\|	1303	g3586	i0	93.416	17.7673469387755	243	16	99	0	2	244	1503728	1503970	Streptococcus oralis strain FDAARGOS_1075 chromosome, complete genome	blastn	4353	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
25228672	25228672	PRJNA1012699_P_NODE_1540_length_306_cov_1.944206_g1508_i0	PRJNA1012699	1540	306	1.944206	5.94927036	Anaerococcus	165779	Bacteria	Bacteria	551	2.309999999999999e-152	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g1508	i0	99.342	520.382352941176	304	2	99	0	2	305	1214	1517	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	159237	551	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
30658996	30658996	PRJNA1012699_P_NODE_3333_length_247_cov_0.896552_g3301_i0	PRJNA1012699	3333	247	0.896552	2.21448344	Bacteria	2	Bacteria	Bacteria	59.7	4.16e-8	NR	WP_196426878.1	44253	g3301	i0	54.5	9.78947368421053	66	26	80.2	2	6	203	1989	2050	WP_196426878.1 DUF4347 domain-containing protein [Paenibacillus validus]	diamond	2418	59.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus validus
31077662	31077662	PRJNA1012699_P_NODE_3835_length_243_cov_0.917647_g3803_i0	PRJNA1012699	3835	243	0.917647	2.22988221	Streptococcus oralis	1303	Bacteria	Bacteria	157	2.3499999999999994e-42	NR	WP_285300881.1	1303	g3803	i0	97.5	2.95061728395062	80	2	98.8	0	241	2	307	386	WP_285300881.1 SEC10/PgrA surface exclusion domain-containing protein [Streptococcus oralis]	diamond	717	157	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis

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