metadata: contig_metadata: 31 rows where bioproject = "PRJEB4632", tax_kingdom = "Bacillati" and tax

31 rows where bioproject = "PRJEB4632", tax_kingdom = "Bacillati" 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
61615	61615	PRJEB4632_P_NODE_441_length_330_cov_1.019455_g403_i0	PRJEB4632	441	330	1.019455	3.3642015	Agathobacter rectalis	39491	Bacteria	Bacteria	449	9.43e-122	NTclustered	gi\|2669501798\|gb\|CP143947.1\|	39491	g403	i0	91.291	428.763636363636	333	23	100	5	1	330	14462	14133	Agathobacter rectalis strain DFI.5.28 chromosome, complete genome	blastn	141492	449	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
990067	990067	PRJEB4632_P_NODE_361_length_374_cov_1.611296_g323_i0	PRJEB4632	361	374	1.611296	6.02624704	Bacillati	1783272	Bacteria	Bacteria	675	0	NTclustered	gi\|1720583674\|gb\|CP031778.1\|	1396	g323	i0	99.198	1048.30481283422	374	3	100	0	1	374	6160608	6160235	Bacillus cereus strain Co1-1 chromosome	blastn	392066	675	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
990072	990072	PRJEB4632_P_NODE_681_length_267_cov_1.190722_g643_i0	PRJEB4632	681	267	1.190722	3.17922774	Lachnospiraceae	186803	Bacteria	Bacteria	350	7.74e-92	NTclustered	gi\|1721134208\|emb\|LR699010.1\|	617123	g643	i0	90.299	479.071161048689	268	25	100	1	1	267	487096	486829	Lachnoanaerobaculum umeaense isolate MGYG-HGUT-02522 genome assembly, chromosome: 1	blastn	127912	350	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum umeaense
990077	990077	PRJEB4632_P_NODE_921_length_244_cov_0.900585_g883_i0	PRJEB4632	921	244	0.900585	2.1974274	Streptococcus	1301	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|1948640724\|gb\|CP066041.1\|	1303	g883	i0	98.361	22	244	4	100	0	1	244	1485690	1485933	Streptococcus oralis strain FDAARGOS_1075 chromosome, complete genome	blastn	5368	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
2265289	2265289	PRJEB4632_P_NODE_882_length_246_cov_0.884393_g844_i0	PRJEB4632	882	246	0.884393	2.17560678	Lacticaseibacillus	2759736	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|507722052\|gb\|KC336483.1\|	1582	g844	i0	100	124	246	0	100	0	1	246	343	98	Lactobacillus casei strain JNLAB-2 16S ribosomal RNA gene, partial sequence	blastn	30504	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus casei
4817904	4817904	PRJEB4632_P_NODE_344_length_387_cov_0.856688_g306_i0	PRJEB4632	344	387	0.856688	3.31538256	Enterocloster	2719313	Bacteria	Bacteria	540	6.47e-149	NTclustered	gi\|1842226806\|gb\|CP053229.1\|	208479	g306	i0	92.651	455.824289405685	381	19	97	9	13	387	3321912	3321535	Enterocloster bolteae strain CBBP-2 chromosome, complete genome	blastn	176404	545	0.990825688073395	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster bolteae
5163911	5163911	PRJEB4632_P_NODE_525_length_307_cov_8.286325_g487_i0	PRJEB4632	525	307	8.286325	25.43901775	Anaeromicropila herbilytica	2785025	Bacteria	Bacteria	363	1.17e-95	NTclustered	gi\|1948445656\|dbj\|AP024169.1\|	2785025	g487	i0	89.583	446.876221498371	288	26	93	4	22	307	13784	14069	Anaeromicropila herbilytica DNA, complete genome	blastn	137191	363	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaeromicropila	Anaeromicropila herbilytica
6439705	6439705	PRJEB4632_P_NODE_686_length_265_cov_2.697917_g648_i0	PRJEB4632	686	265	2.697917	7.14948005	Saccharococcus caldoxylosilyticus	81408	Bacteria	Bacteria	481	2.61e-131	NTclustered	gi\|2069581432\|gb\|CP040553.1\|	81408	g648	i0	99.62	834.203773584906	263	1	99	0	3	265	1464875	1465137	Saccharococcus caldoxylosilyticus strain ER4B chromosome, complete genome	blastn	221064	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Saccharococcus	Saccharococcus caldoxylosilyticus
8643181	8643181	PRJEB4632_P_NODE_1067_length_213_cov_11.221429_g1029_i0	PRJEB4632	1067	213	11.221429	23.90164377	root	1	Root_unresolved	Root_unresolved	394	2.7e-105	NTclustered	gi\|1463803524\|gb\|MG254805.1\|	1409	g1029	i0	100	102	213	0	100	0	1	213	681	469	Bacillus sp. (in: Bacteria) strain T3211-1-2 16S ribosomal RNA gene, partial sequence	blastn	21726	394	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
9918221	9918221	PRJEB4632_P_NODE_528_length_307_cov_2.418803_g490_i0	PRJEB4632	528	307	2.418803	7.42572521	Bacillati	1783272	Bacteria	Bacteria	542	1.39e-149	NTclustered	gi\|1720583674\|gb\|CP031778.1\|	1396	g490	i0	99.01	1113.05211726384	303	1	99	2	1	302	6160786	6160485	Bacillus cereus strain Co1-1 chromosome	blastn	341707	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
10264397	10264397	PRJEB4632_P_NODE_389_length_354_cov_2.451957_g351_i0	PRJEB4632	389	354	2.451957	8.67992778	Finegoldia magna	1260	Bacteria	Bacteria	638	2.02e-178	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g351	i0	99.153	236.937853107345	354	3	100	0	1	354	1361389	1361036	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	83876	638	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
11193413	11193413	PRJEB4632_P_NODE_369_length_370_cov_1.491582_g331_i0	PRJEB4632	369	370	1.491582	5.5188534	Lentilactobacillus	2767893	Bacteria	Bacteria	678	0	NTclustered	gi\|1783091508\|gb\|CP029971.1\|	33962	g331	i0	99.73	409.248648648649	370	1	100	0	1	370	29726	29357	Lentilactobacillus kefiri strain DH5 chromosome, complete genome	blastn	151422	678	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lentilactobacillus	Lentilactobacillus kefiri
11193415	11193415	PRJEB4632_P_NODE_569_length_295_cov_3.364865_g531_i0	PRJEB4632	569	295	3.364865	9.92635175	Exiguobacterium	33986	Bacteria	Bacteria	544	3.71e-150	NTclustered	gi\|171988566\|gb\|CP001022.1\|	262543	g531	i0	100	753.637288135593	294	0	99	0	2	295	13982	13689	Exiguobacterium sibiricum 255-15, complete genome	blastn	222323	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium artemiae
11539795	11539795	PRJEB4632_P_NODE_490_length_317_cov_1.262295_g452_i0	PRJEB4632	490	317	1.262295	4.00147515	Saccharibacillus sacchari	456493	Bacteria	Bacteria	510	4.08e-140	NTclustered	gi\|343205890\|ref\|NR_044375.1\|	456493	g452	i0	95.639	173.533123028391	321	8	100	4	1	317	1061	1379	Saccharibacillus sacchari strain GR21 16S ribosomal RNA, partial sequence	blastn	55010	510	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Saccharibacillus	Saccharibacillus sacchari
12469119	12469119	PRJEB4632_P_NODE_470_length_321_cov_5.165323_g432_i0	PRJEB4632	470	321	5.165323	16.58068683	Lachnospiraceae	186803	Bacteria	Bacteria	335	2.6699999999999986e-87	NTclustered	gi\|2530912390\|dbj\|AP028249.1\|	33039	g432	i0	87.889	411.707165109034	289	29	89	5	36	321	93525	93240	[Ruminococcus] torques 17EGH124 DNA, complete genome	blastn	132158	335	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	[Ruminococcus] torques
12469121	12469121	PRJEB4632_P_NODE_710_length_259_cov_1.430108_g672_i0	PRJEB4632	710	259	1.430108	3.70397972	Anaerococcus	165779	Bacteria	Bacteria	451	1.99e-122	NTclustered	gi\|1948596785\|gb\|CP066014.1\|	33037	g672	i0	98.069	192.316602316602	259	5	100	0	1	259	179367	179109	Anaerococcus vaginalis strain FDAARGOS_988 chromosome, complete genome	blastn	49810	451	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus vaginalis
12469122	12469122	PRJEB4632_P_NODE_830_length_248_cov_0.880000_g792_i0	PRJEB4632	830	248	0.88	2.1824	Staphylococcus	1279	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g792	i0	100	100	248	0	100	0	1	248	1053584	1053337	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24800	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12815026	12815026	PRJEB4632_P_NODE_671_length_268_cov_0.948718_g633_i0	PRJEB4632	671	268	0.948718	2.54256424	Megasphaera hexanoica	1675036	Bacteria	Bacteria	424	4.5099999999999996e-114	NTclustered	gi\|2840670333\|gb\|CP171746.1\|	1675036	g633	i0	95.149	558.537313432836	268	13	100	0	1	268	4013	4280	Megasphaera hexanoica strain MH chromosome, complete genome	blastn	149688	424	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera hexanoica
14089957	14089957	PRJEB4632_P_NODE_412_length_344_cov_7.188192_g374_i0	PRJEB4632	412	344	7.188192	24.72738048	Gemella haemolysans	1379	Bacteria	Bacteria	625	1.5299999999999996e-174	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g374	i0	99.419	512.938953488372	344	2	100	0	1	344	1589633	1589976	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	176451	625	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
15363796	15363796	PRJEB4632_P_NODE_733_length_254_cov_2.093923_g695_i0	PRJEB4632	733	254	2.093923	5.31856442	Selenomonas dianae	135079	Bacteria	Bacteria	346	9.45e-91	NTclustered	gi\|2557568019\|gb\|CP128650.1\|	135079	g695	i0	96.667	384.377952755906	210	4	82	3	46	254	1004619	1004412	Selenomonas dianae strain ATCC 43527 chromosome, complete genome	blastn	97632	346	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas dianae
15363799	15363799	PRJEB4632_P_NODE_833_length_248_cov_0.880000_g795_i0	PRJEB4632	833	248	0.88	2.1824	Enterocloster clostridioformis	1531	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2777707209\|dbj\|AP031445.1\|	1531	g795	i0	99.194	11.633064516129	248	2	100	0	1	248	4719376	4719129	Enterocloster clostridioformis k19-0097-F3 DNA, complete genome	blastn	2885	448	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Enterocloster	Enterocloster clostridioformis
16638357	16638357	PRJEB4632_P_NODE_914_length_244_cov_0.900585_g876_i0	PRJEB4632	914	244	0.900585	2.1974274	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	169	2.09e-37	NTclustered	gi\|2188895606\|dbj\|AP025583.1\|	2485925	g876	i0	79.352	110.315573770492	247	45	100	6	1	244	2642105	2642348	Oscillospiraceae bacterium CE91-St40 DNA, complete genome	blastn	26917	169	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
17567868	17567868	PRJEB4632_P_NODE_594_length_288_cov_5.902326_g556_i0	PRJEB4632	594	288	5.902326	16.99869888	Lactobacillus	1578	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g556	i0	100	427.010416666667	288	0	100	0	1	288	90634	90921	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	122979	532	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
17567870	17567870	PRJEB4632_P_NODE_834_length_248_cov_0.880000_g796_i0	PRJEB4632	834	248	0.88	2.1824	Selenomonas	970	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|470488416\|ref\|NR_076868.1\|	69823	g796	i0	99.194	276.346774193548	248	2	100	0	1	248	693	446	Selenomonas sputigena 23S ribosomal RNA gene, complete sequence	blastn	68534	448	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sputigena
17567871	17567871	PRJEB4632_P_NODE_994_length_240_cov_2.706587_g956_i0	PRJEB4632	994	240	2.706587	6.4958088	Anaerostipes	207244	Bacteria	Bacteria	320	5.36e-83	NTclustered	gi\|2870220852\|gb\|CP152073.1\|	105841	g956	i0	91.775	425.166666666667	231	17	98	2	12	240	1394	1164	Anaerostipes caccae strain LAHUC chromosome, complete genome	blastn	102040	320	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerostipes	Anaerostipes caccae
17913091	17913091	PRJEB4632_P_NODE_535_length_305_cov_3.051724_g497_i0	PRJEB4632	535	305	3.051724	9.3077582	Finegoldia magna	1260	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g497	i0	100	279.245901639344	305	0	100	0	1	305	425894	426198	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	85170	564	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
18841723	18841723	PRJEB4632_P_NODE_515_length_310_cov_2.890295_g477_i0	PRJEB4632	515	310	2.890295	8.9599145	Lactobacillus	1578	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g477	i0	100	433.590322580645	310	0	100	0	1	310	90657	90348	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	134413	573	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
20116593	20116593	PRJEB4632_P_NODE_776_length_250_cov_1.661017_g738_i0	PRJEB4632	776	250	1.661017	4.1525425	Waltera	2815781	Bacteria	Bacteria	339	1.55e-88	NTclustered	gi\|2188860891\|dbj\|AP025576.1\|	1898203	g738	i0	94.521	420.872	219	12	88	0	1	219	3847223	3847441	Lachnospiraceae bacterium CE91-St56 DNA, complete genome	blastn	105218	339	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
20462425	20462425	PRJEB4632_P_NODE_197_length_549_cov_4.682773_g159_i0	PRJEB4632	197	549	4.682773	25.70842377	Lactobacillus iners	147802	Bacteria	Bacteria	1003	0	NTclustered	gi\|1818008110\|gb\|CP049223.1\|	147802	g159	i0	99.636	508.642987249545	549	2	100	0	1	549	568220	568768	Lactobacillus iners strain C0094A1 chromosome, complete genome	blastn	279245	1003	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
22666944	22666944	PRJEB4632_P_NODE_898_length_244_cov_4.187135_g860_i0	PRJEB4632	898	244	4.187135	10.2166094	Clostridia	186801	Bacteria	Bacteria	363	8.949999999999999e-96	NTclustered	gi\|1988050162\|gb\|CP070036.1\|	33038	g860	i0	93.469	480.930327868852	245	14	100	2	1	244	439218	439461	Mediterraneibacter gnavus strain FDAARGOS_1342 chromosome, complete genome	blastn	117347	366	0.991803278688525	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
25216185	25216185	PRJEB4632_P_NODE_720_length_257_cov_3.625000_g682_i0	PRJEB4632	720	257	3.625	9.31625	FCB group	1783270	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g682	i0	100	531.852140077821	257	0	100	0	1	257	523053	523309	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	136686	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis

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