metadata: contig_metadata: 44 rows where analysis = "blastn", bioproject = "PRJNA613025" and tax

44 rows where analysis = "blastn", bioproject = "PRJNA613025" 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
591693	591693	PRJNA613025_S_NODE_18681_length_232_cov_1.377049_g18527_i0	PRJNA613025	18681	232	1.377049	3.19475368	Bacillus velezensis	492670	Bacteria	Bacteria	141	4.3e-29	NTclustered	gi\|2699715645\|gb\|CP147655.1\|	492670	g18527	i0	77.966	7.14224137931035	236	45	100	7	1	232	373663	373895	Bacillus velezensis strain M1 chromosome, complete genome	blastn	1657	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus velezensis
591953	591953	PRJNA613025_S_NODE_30201_length_167_cov_0.864407_g30047_i0	PRJNA613025	30201	167	0.864407	1.44355969	Gemella morbillorum	29391	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|1403530627\|emb\|LS483440.1\|	29391	g30047	i0	98.802	9.1437125748503	167	2	100	0	1	167	1623472	1623306	Gemella morbillorum strain NCTC11323 genome assembly, chromosome: 1	blastn	1527	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella morbillorum
1148799	1148799	PRJNA613025_S_NODE_14621_length_285_cov_2.351695_g14467_i0	PRJNA613025	14621	285	2.351695	6.70233075	Exiguobacterium	33986	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|2844360308\|gb\|CP172296.1\|	340146	g14467	i0	99.649	715.884210526316	285	1	100	0	1	285	478182	478466	Exiguobacterium mexicanum strain MM chromosome, complete genome	blastn	204027	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium mexicanum
2424039	2424039	PRJNA613025_S_NODE_23942_length_194_cov_1.406897_g23788_i0	PRJNA613025	23942	194	1.406897	2.72938018	Exiguobacterium	33986	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g23788	i0	100	745.237113402062	194	0	100	0	1	194	14500	14693	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	144576	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
3700346	3700346	PRJNA613025_S_NODE_16123_length_261_cov_4.740566_g15969_i0	PRJNA613025	16123	261	4.740566	12.37287726	Bacillales	1385	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g15969	i0	100	122.896551724138	261	0	100	0	1	261	750	490	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	32076	483	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
5695293	5695293	PRJNA613025_S_NODE_20865_length_213_cov_1.457317_g20711_i0	PRJNA613025	20865	213	1.457317	3.10408521	Enterococcus faecium	1352	Bacteria	Bacteria	78.7	3.09e-10	NTclustered	gi\|1878067685\|dbj\|LC566215.1\|	1352	g20711	i0	91.379	18.7652582159624	58	3	27	2	156	213	141	86	Enterococcus faecium EV0426-12 plasmid pIHVA-EV0426-12 DNA, complete sequence	blastn	3997	78.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
5695364	5695364	PRJNA613025_S_NODE_23465_length_197_cov_0.952703_g23311_i0	PRJNA613025	23465	197	0.952703	1.87682491	Lactobacillus iners	147802	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|1818008110\|gb\|CP049223.1\|	147802	g23311	i0	100	462.822335025381	197	0	100	0	1	197	55945	56141	Lactobacillus iners strain C0094A1 chromosome, complete genome	blastn	91176	364	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
5695447	5695447	PRJNA613025_S_NODE_27545_length_177_cov_0.781250_g27391_i0	PRJNA613025	27545	177	0.78125	1.3828125	Paenibacillus sp. RS8	3242681	Bacteria	Bacteria	303	3.74e-78	NTclustered	gi\|2805686923\|gb\|CP168131.1\|	3242681	g27391	i0	98.83	964.112994350283	171	1	96	1	1	170	1678	1848	Paenibacillus sp. RS8 chromosome	blastn	170648	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. RS8
5695466	5695466	PRJNA613025_S_NODE_28625_length_172_cov_1.658537_g28471_i0	PRJNA613025	28625	172	1.658537	2.85268364	Syntrophothermus lipocalidus	86170	Bacteria	Bacteria	239	1.03e-58	NTclustered	gi\|297144051\|gb\|CP002048.1\|	643648	g28471	i0	94.771	309.28488372093	153	8	89	0	20	172	748393	748545	Syntrophothermus lipocalidus DSM 12680, complete genome	blastn	53197	239	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae	Syntrophothermus	Syntrophothermus lipocalidus
6252559	6252559	PRJNA613025_S_NODE_29085_length_170_cov_2.074380_g28931_i0	PRJNA613025	29085	170	2.07438	3.526446	Enterococcus	1350	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|2557993987\|gb\|CP130912.1\|	1352	g28931	i0	100	568.364705882353	170	0	100	0	1	170	519376	519207	Enterococcus faecium strain C0019EM0002 chromosome, complete genome	blastn	96622	315	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
7526499	7526499	PRJNA613025_S_NODE_13426_length_308_cov_1.216216_g13272_i0	PRJNA613025	13426	308	1.216216	3.74594528	root	1	Root_unresolved	Root_unresolved	547	3.0099999999999987e-151	NTclustered	gi\|1214359213\|gb\|MF424753.1\|	1613	g13272	i0	98.701	196	308	4	100	0	1	308	712	405	Limosilactobacillus fermentum strain CAU6386 16S ribosomal RNA gene, partial sequence	blastn	60368	547	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus fermentum
8244905	8244905	PRJNA613025_S_NODE_25007_length_188_cov_1.748201_g24853_i0	PRJNA613025	25007	188	1.748201	3.28661788	Enterococcus faecium	1352	Bacteria	Bacteria	339	1.1e-88	NTclustered	gi\|290563848\|gb\|GU460394.1\|	1352	g24853	i0	98.936	107.904255319149	188	2	100	0	1	188	4	191	Enterococcus faecium strain UPAA31 16S ribosomal RNA gene, partial sequence	blastn	20286	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
8801600	8801600	PRJNA613025_S_NODE_12567_length_325_cov_33.047101_g12413_i0	PRJNA613025	12567	325	33.047101	107.40307825	Clostridium	1485	Bacteria	Bacteria	569	6.819999999999998e-158	NTclustered	gi\|369724618\|gb\|JN792331.1\|	59620	g12413	i0	100	95.0215384615385	308	0	95	0	1	308	308	1	Uncultured Clostridium sp. clone PLYFP65 16S ribosomal RNA gene, partial sequence	blastn	30882	571	0.996497373029772	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
8801738	8801738	PRJNA613025_S_NODE_27187_length_178_cov_1.581395_g27033_i0	PRJNA613025	27187	178	1.581395	2.8148831	Cellulosilyticum	698776	Bacteria	Bacteria	185	1.4199999999999999e-42	NTclustered	gi\|326539903\|gb\|CP002582.1\|	642492	g27033	i0	88.312	28.0842696629213	154	18	87	0	6	159	1181934	1181781	Clostridium lentocellum DSM 5427, complete genome	blastn	4999	185	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Cellulosilyticaceae	Cellulosilyticum	Cellulosilyticum lentocellum
8801775	8801775	PRJNA613025_S_NODE_31127_length_165_cov_1.517241_g30973_i0	PRJNA613025	31127	165	1.517241	2.50344765	Anoxybacillus	150247	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g30973	i0	100	943.260606060606	165	0	100	0	1	165	1490719	1490883	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	155638	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
11352222	11352222	PRJNA613025_S_NODE_20109_length_219_cov_0.994118_g19955_i0	PRJNA613025	20109	219	0.994118	2.17711842	Megasphaera	906	Bacteria	Bacteria	305	1.35e-78	NTclustered	gi\|507148370\|ref\|NR_103173.1\|	907	g19955	i0	95.767	515.146118721461	189	8	86	0	31	219	1414	1226	Megasphaera elsdenii strain DSM 20460 23S ribosomal RNA gene, complete sequence	blastn	112817	305	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera elsdenii
11352308	11352308	PRJNA613025_S_NODE_31149_length_165_cov_1.318966_g30995_i0	PRJNA613025	31149	165	1.318966	2.1762939	Bacillales	1385	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|26985544\|emb\|AJ534336.1\|	1409	g30995	i0	100	7	165	0	100	0	1	165	1783	1619	Bacillus sp. gene for nicking endonuclease N.BspD6I	blastn	1155	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
13346115	13346115	PRJNA613025_S_NODE_34071_length_160_cov_2.297297_g33917_i0	PRJNA613025	34071	160	2.297297	3.6756752	Paenibacillus silvisoli	3110539	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2567904410\|gb\|CP133017.1\|	3110539	g33917	i0	90.698	0.26875	43	3	26	1	28	69	6373024	6373066	Paenibacillus silvisoli strain TW38 chromosome, complete genome	blastn	43	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus silvisoli
13902757	13902757	PRJNA613025_S_NODE_27931_length_175_cov_1.277778_g27777_i0	PRJNA613025	27931	175	1.277778	2.2361115	Exiguobacterium	33986	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|2274429004\|gb\|CP101462.1\|	33987	g27777	i0	98.857	434.531428571429	175	2	100	0	1	175	13882	14056	Exiguobacterium aurantiacum strain CX2 chromosome, complete genome	blastn	76043	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
14620963	14620963	PRJNA613025_S_NODE_33772_length_161_cov_0.910714_g33618_i0	PRJNA613025	33772	161	0.910714	1.46624954	Companilactobacillus alimentarius	1602	Bacteria	Bacteria	80.5	6.14e-11	NTclustered	gi\|1318697760\|gb\|CP018867.1\|	1423720	g33618	i0	84.337	2.06211180124224	83	12	52	1	50	132	55104	55023	Companilactobacillus alimentarius DSM 20249, complete sequence	blastn	332	80.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Companilactobacillus	Companilactobacillus alimentarius
15177120	15177120	PRJNA613025_S_NODE_22872_length_200_cov_1.543046_g22718_i0	PRJNA613025	22872	200	1.543046	3.086092	Anoxybacillus	150247	Bacteria	Bacteria	309	9.34e-80	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g22718	i0	94.527	883.235	201	9	100	2	1	200	1491132	1490933	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	176647	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
15894934	15894934	PRJNA613025_S_NODE_33013_length_162_cov_1.345133_g32859_i0	PRJNA613025	33013	162	1.345133	2.17911546	Alicyclobacillus sp. ALC3	2796143	Bacteria	Bacteria	198	1.64e-46	NTclustered	gi\|2447014254\|gb\|CP066784.1\|	2796143	g32859	i0	88.957	576.493827160494	163	15	100	3	1	162	250542	250382	Alicyclobacillus sp. ALC3 chromosome, complete genome	blastn	93392	198	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Alicyclobacillus	Alicyclobacillus sp. ALC3
16451638	16451638	PRJNA613025_S_NODE_28493_length_173_cov_1.193548_g28339_i0	PRJNA613025	28493	173	1.193548	2.06483804	root	1	Root_unresolved	Root_unresolved	292	7.87e-75	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g28339	i0	97.11	35.4161849710983	173	5	100	0	1	173	2068439	2068267	Staphylococcus aureus strain WH3018 chromosome	blastn	6127	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16451707	16451707	PRJNA613025_S_NODE_5313_length_656_cov_6.517298_g5170_i0	PRJNA613025	5313	656	6.517298	42.75347488	Bacillus	1386	Bacteria	Bacteria	983	0	NTclustered	gi\|896574136\|gb\|CP012099.1\|	1428	g5170	i0	93.656	1253.32926829268	662	34	100	6	1	656	743838	744497	Bacillus thuringiensis strain HS18-1, complete genome	blastn	822184	989	0.993933265925177	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
16451708	16451708	PRJNA613025_S_NODE_5353_length_652_cov_7.081260_g5210_i0	PRJNA613025	5353	652	7.08126	46.1698152	Streptococcus	1301	Bacteria	Bacteria	1166	0	NTclustered	gi\|1948603152\|gb\|CP066021.1\|	1303	g5210	i0	98.928	345.530674846626	653	6	100	1	1	652	673711	673059	Streptococcus oralis strain FDAARGOS_1020 chromosome, complete genome	blastn	225286	1171	0.995730145175064	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17169769	17169769	PRJNA613025_S_NODE_28974_length_171_cov_1.073770_g28820_i0	PRJNA613025	28974	171	1.07377	1.8361467	Hydrogenibacillus sp. N12	2866627	Bacteria	Bacteria	219	1.33e-52	NTclustered	gi\|2082039851\|gb\|CP080953.1\|	2866627	g28820	i0	93.836	332.40350877193	146	8	85	1	2	147	85033	85177	Hydrogenibacillus sp. N12 chromosome, complete genome	blastn	56841	219	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillales Family X. Incertae Sedis	Hydrogenibacillus	Hydrogenibacillus sp. N12
18444115	18444115	PRJNA613025_S_NODE_5015_length_683_cov_4.141956_g4874_i0	PRJNA613025	5015	683	4.141956	28.28955948	Paenibacillus alvei	44250	Bacteria	Bacteria	246	2.91e-60	NTclustered	gi\|1465383833\|emb\|LS992241.1\|	44250	g4874	i0	78.261	479.225475841874	414	69	61	19	14	418	24229	23828	Paenibacillus alvei isolate Paenibacillus B-LR1 genome assembly, chromosome: PBLR	blastn	327311	246	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus alvei
19000254	19000254	PRJNA613025_S_NODE_26595_length_181_cov_0.863636_g26441_i0	PRJNA613025	26595	181	0.863636	1.56318116	Bacillota	1239	Bacteria	Bacteria	259	8.44e-65	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g26441	i0	97.368	15.5966850828729	152	4	84	0	30	181	2419257	2419106	Staphylococcus aureus strain WH9628 chromosome	blastn	2823	259	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19718557	19718557	PRJNA613025_S_NODE_33716_length_161_cov_1.026786_g33562_i0	PRJNA613025	33716	161	1.026786	1.65312546	Bacillus weihaiensis	1547283	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|1110984809\|gb\|CP016020.1\|	1547283	g33562	i0	98.758	1039.57763975155	161	2	100	0	1	161	3846207	3846047	Bacillus weihaiensis strain Alg07 chromosome, complete genome	blastn	167372	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus weihaiensis
20275193	20275193	PRJNA613025_S_NODE_16736_length_253_cov_3.696078_g16582_i0	PRJNA613025	16736	253	3.696078	9.35107734	Bacteria	2	Bacteria	Bacteria	457	4.16e-124	NTclustered	gi\|238835991\|gb\|FJ957671.1\|	189668	g16582	i0	99.209	367	253	2	100	0	1	253	1107	1359	Uncultured Staphylococcus sp. clone JPL-S4_E09 16S ribosomal RNA gene, partial sequence	blastn	92851	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	uncultured Staphylococcus sp.
20275337	20275337	PRJNA613025_S_NODE_32476_length_163_cov_1.008772_g32322_i0	PRJNA613025	32476	163	1.008772	1.64429836	root	1	Root_unresolved	Root_unresolved	206	9.86e-49	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g32322	i0	96.063	13.5153374233129	127	3	77	2	1	126	2266878	2266753	Staphylococcus aureus strain WH3018 chromosome	blastn	2203	206	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
22826087	22826087	PRJNA613025_S_NODE_18298_length_236_cov_1.165775_g18144_i0	PRJNA613025	18298	236	1.165775	2.751229	root	1	Root_unresolved	Root_unresolved	392	1.0999999999999999e-104	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g18144	i0	100	14.4872881355932	212	0	92	0	1	212	2267761	2267550	Staphylococcus aureus strain WH3018 chromosome	blastn	3419	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
22826198	22826198	PRJNA613025_S_NODE_29858_length_167_cov_5.237288_g29704_i0	PRJNA613025	29858	167	5.237288	8.74627096	Streptococcus	1301	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g29704	i0	100	342	167	0	100	0	1	167	1571320	1571486	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	57114	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22826267	22826267	PRJNA613025_S_NODE_7038_length_526_cov_7.211740_g6886_i0	PRJNA613025	7038	526	7.21174	37.9337524	Bacillati	1783272	Bacteria	Bacteria	848	0	NTclustered	gi\|1855699928\|gb\|CP046111.1\|	1351	g6886	i0	95.677	388.802281368821	532	15	100	7	1	526	74042	73513	Enterococcus faecalis strain 111540047-1 chromosome, complete genome	blastn	204510	852	0.995305164319249	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
23544172	23544172	PRJNA613025_S_NODE_19579_length_223_cov_3.442529_g19425_i0	PRJNA613025	19579	223	3.442529	7.67683967	Enterococcus faecium	1352	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|2557993987\|gb\|CP130912.1\|	1352	g19425	i0	100	585.663677130045	223	0	100	0	1	223	517410	517188	Enterococcus faecium strain C0019EM0002 chromosome, complete genome	blastn	130603	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
23544291	23544291	PRJNA613025_S_NODE_24119_length_193_cov_1.430556_g23965_i0	PRJNA613025	24119	193	1.430556	2.76097308	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	176	9.46e-40	NTclustered	gi\|1721134157\|emb\|LR698958.1\|	1898203	g23965	i0	85.549	4.10362694300518	173	19	88	6	1	170	2163766	2163935	Lachnospiraceae bacterium isolate MGYG-HGUT-01373 genome assembly, chromosome: 1	blastn	792	176	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
24100577	24100577	PRJNA613025_S_NODE_16719_length_254_cov_1.204878_g16565_i0	PRJNA613025	16719	254	1.204878	3.06039012	root	1	Root_unresolved	Root_unresolved	435	1.9600000000000003e-117	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g16565	i0	98.381	28.6968503937008	247	4	97	0	1	247	2267300	2267546	Staphylococcus aureus strain WH3018 chromosome	blastn	7289	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
24100712	24100712	PRJNA613025_S_NODE_31319_length_165_cov_0.879310_g31165_i0	PRJNA613025	31319	165	0.87931	1.4508615	Staphylococcus	1279	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g31165	i0	100	100	165	0	100	0	1	165	982423	982587	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	16500	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24818252	24818252	PRJNA613025_S_NODE_32860_length_162_cov_2.619469_g32706_i0	PRJNA613025	32860	162	2.619469	4.24353978	Exiguobacterium mexicanum	340146	Bacteria	Bacteria	298	1.57e-76	NTclustered	gi\|2844360308\|gb\|CP172296.1\|	340146	g32706	i0	100	622.734567901235	161	0	99	0	2	162	33562	33722	Exiguobacterium mexicanum strain MM chromosome, complete genome	blastn	100883	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium mexicanum
25375062	25375062	PRJNA613025_S_NODE_16200_length_260_cov_2.815166_g16046_i0	PRJNA613025	16200	260	2.815166	7.3194316	Enterococcus	1350	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2210168414\|gb\|ON032309.1\|	1351	g16046	i0	100	574.715384615385	260	0	100	0	1	260	876	617	Enterococcus faecalis strain LZD1 23S ribosomal RNA gene, partial sequence	blastn	149426	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
25375096	25375096	PRJNA613025_S_NODE_21020_length_212_cov_1.202454_g20866_i0	PRJNA613025	21020	212	1.202454	2.54920248	root	1	Root_unresolved	Root_unresolved	248	2.2099999999999997e-61	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g20866	i0	91.758	6.77830188679245	182	10	86	2	31	212	2068557	2068381	Staphylococcus aureus strain WH3018 chromosome	blastn	1437	248	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
25375192	25375192	PRJNA613025_S_NODE_30240_length_167_cov_0.864407_g30086_i0	PRJNA613025	30240	167	0.864407	1.44355969	Bacillales	1385	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|26985544\|emb\|AJ534336.1\|	1409	g30086	i0	100	7	167	0	100	0	1	167	2062	1896	Bacillus sp. gene for nicking endonuclease N.BspD6I	blastn	1169	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
25375200	25375200	PRJNA613025_S_NODE_30980_length_166_cov_0.837607_g30826_i0	PRJNA613025	30980	166	0.837607	1.39042762	root	1	Root_unresolved	Root_unresolved	119	1.35e-22	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g30826	i0	98.507	11.7168674698795	67	1	64	0	100	166	2068923	2068989	Staphylococcus aureus strain WH3018 chromosome	blastn	1945	119	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
25375286	25375286	PRJNA613025_S_NODE_9460_length_413_cov_3.153846_g9307_i0	PRJNA613025	9460	413	3.153846	13.02538398	Bacillati	1783272	Bacteria	Bacteria	758	0	NTclustered	gi\|2851146212\|gb\|CP085027.1\|	1283	g9307	i0	99.758	448.053268765133	413	1	100	0	1	413	730028	730440	Staphylococcus haemolyticus strain SLM-175 chromosome, complete genome	blastn	185046	763	0.993446920052425	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus

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