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

30 rows where analysis = "blastn", bioproject = "PRJNA1020641" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
160539	160539	PRJNA1020641_P_NODE_6921_length_244_cov_0.900585_g6878_i0	PRJNA1020641	6921	244	0.900585	2.1974274	Mesomycoplasma lagogenitalium	171286	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2495165145\|gb\|CP122979.1\|	171286	g6878	i0	100	0.114754098360656	28	0	11	0	40	67	234018	234045	Mesomycoplasma lagogenitalium strain 12MS chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma lagogenitalium
1002995	1002995	PRJNA1020641_P_NODE_3901_length_309_cov_0.944915_g3858_i0	PRJNA1020641	3901	309	0.944915	2.91978735	Rhodococcus	1827	Bacteria	Bacteria	477	4.0199999999999996e-130	NTclustered	gi\|2921205402\|gb\|CP134707.1\|	37919	g3858	i0	94.516	404.333333333333	310	16	100	1	1	309	2199209	2199518	Rhodococcus opacus strain DSM 43205 chromosome, complete genome	blastn	124939	477	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus opacus
1435382	1435382	PRJNA1020641_P_NODE_4502_length_284_cov_2.014218_g4459_i0	PRJNA1020641	4502	284	2.014218	5.72037912	Candidatus Improbicoccus pseudotrichonymphae	3033792	Bacteria	Bacteria	250	8.66e-62	NTclustered	gi\|2567582841\|dbj\|AP027924.1\|	3033792	g4459	i0	82.699	54.7816901408451	289	42	100	8	1	284	414101	414386	MAG: Candidatus Improbicoccus pseudotrichonymphae CfP3-15 DNA, complete genome	blastn	15558	250	1	Bacteria		Bacillati	Bacillota	Clostridia			Candidatus Improbicoccus	Candidatus Improbicoccus pseudotrichonymphae
1435390	1435390	PRJNA1020641_P_NODE_5822_length_250_cov_0.870056_g5779_i0	PRJNA1020641	5822	250	0.870056	2.17514	Anoxybacillus flavithermus	33934	Bacteria	Bacteria	272	1.6e-68	NTclustered	gi\|212559329\|gb\|CP000922.1\|	491915	g5779	i0	93.889	0.72	180	11	72	0	2	181	1513782	1513603	Anoxybacillus flavithermus WK1, complete genome	blastn	180	272	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
2278068	2278068	PRJNA1020641_P_NODE_2582_length_380_cov_1.504886_g2539_i0	PRJNA1020641	2582	380	1.504886	5.7185668	Cutibacterium	1912216	Bacteria	Bacteria	702	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2539	i0	100	247.776315789474	380	0	100	0	1	380	55417	55796	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	94155	702	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2710939	2710939	PRJNA1020641_P_NODE_5963_length_249_cov_0.875000_g5920_i0	PRJNA1020641	5963	249	0.875	2.17875	cyanobacterium NIES-2125	2510788	Bacteria	Bacteria	377	3.27e-100	NTclustered	gi\|1566846232\|dbj\|LC455610.1\|	2510788	g5920	i0	94.024	169.401606425703	251	11	100	4	1	249	547	299	Cyanobacterium NIES-2125 gene for 23S ribosomal RNA, partial sequence	blastn	42181	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-2125
2710946	2710946	PRJNA1020641_P_NODE_983_length_603_cov_1.003774_g941_i0	PRJNA1020641	983	603	1.003774	6.05275722	Tissierella sp. Yu-01	3035694	Bacteria	Bacteria	135	5.7600000000000005e-27	NTclustered	gi\|2473436845\|gb\|CP120677.1\|	3035694	g941	i0	89.815	40.1243781094527	108	8	18	2	346	452	513554	513449	Tissierella sp. Yu-01 chromosome, complete genome	blastn	24195	135	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Tissierella	Tissierella sp. Yu-01
3987150	3987150	PRJNA1020641_P_NODE_6504_length_246_cov_0.890173_g6461_i0	PRJNA1020641	6504	246	0.890173	2.18982558	Pseudobutyrivibrio xylanivorans	185007	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|1760103922\|gb\|CP043028.1\|	185007	g6461	i0	97.154	2.47967479674797	246	7	100	0	1	246	2417614	2417859	Pseudobutyrivibrio xylanivorans strain MA3014 chromosome 1, complete sequence	blastn	610	416	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Pseudobutyrivibrio	Pseudobutyrivibrio xylanivorans
7813181	7813181	PRJNA1020641_P_NODE_7087_length_243_cov_0.905882_g7044_i0	PRJNA1020641	7087	243	0.905882	2.20129326	Butyrivibrio sp. JL13D10	3236815	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2867859768\|gb\|CP172574.1\|	3236815	g7044	i0	96.708	1	243	8	100	0	1	243	444549	444791	Butyrivibrio sp. JL13D10 chromosome 2, complete sequence	blastn	243	405	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Butyrivibrio	Butyrivibrio sp. JL13D10
9088147	9088147	PRJNA1020641_P_NODE_5888_length_249_cov_1.096591_g5845_i0	PRJNA1020641	5888	249	1.096591	2.73051159	Enterococcus faecalis	1351	Bacteria	Bacteria	97.1	1.03e-15	NTclustered	gi\|229892390\|gb\|FJ872410.1\|	1351	g5845	i0	80.8	0.502008032128514	125	22	50	2	116	239	44384	44507	Enterococcus faecalis strain N03-0233 VanG2 mobile element, complete sequence	blastn	125	97.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
9088148	9088148	PRJNA1020641_P_NODE_5908_length_249_cov_0.875000_g5865_i0	PRJNA1020641	5908	249	0.875	2.17875	Ruminococcus albus	1264	Bacteria	Bacteria	121	6.09e-23	NTclustered	gi\|315447000\|gb\|CP002403.1\|	697329	g5865	i0	81.757	0.594377510040161	148	24	58	2	105	249	2989478	2989625	Ruminococcus albus 7, complete genome	blastn	148	121	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus albus
9931052	9931052	PRJNA1020641_P_NODE_4968_length_268_cov_1.143590_g4925_i0	PRJNA1020641	4968	268	1.14359	3.0648212	Bacillota	1239	Bacteria	Bacteria	479	9.499999999999996e-131	NTclustered	gi\|1721134215\|emb\|LR699017.1\|	853	g4925	i0	98.881	73.9477611940299	268	3	100	0	1	268	2742340	2742607	Faecalibacterium prausnitzii isolate MGYG-HGUT-02545 genome assembly, chromosome: 1	blastn	19818	479	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
10363776	10363776	PRJNA1020641_P_NODE_4269_length_294_cov_0.819005_g4226_i0	PRJNA1020641	4269	294	0.819005	2.4078747	Clostridium septicum	1504	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2260370548\|gb\|CP099799.1\|	1504	g4226	i0	100	0.476190476190476	28	0	10	0	69	96	2761009	2760982	Clostridium septicum strain RMA 8861 chromosome, complete genome	blastn	140	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium septicum
10363788	10363788	PRJNA1020641_P_NODE_7169_length_242_cov_0.911243_g7126_i0	PRJNA1020641	7169	242	0.911243	2.20520806	Anoxybacillus sp. FSL W8-1294	2954655	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2709517709\|gb\|CP150179.1\|	2954655	g7126	i0	100	1.85123966942149	242	0	100	0	1	242	1504316	1504557	Anoxybacillus sp. FSL W8-1294 chromosome, complete genome	blastn	448	448	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus sp. FSL W8-1294
11206244	11206244	PRJNA1020641_P_NODE_4669_length_278_cov_1.468293_g4626_i0	PRJNA1020641	4669	278	1.468293	4.08185454	Actinomycetes	1760	Bacteria	Bacteria	425	1.31e-114	NTclustered	gi\|1345633730\|emb\|LT985188.1\|	75385	g4626	i0	94.245	312.053956834532	278	16	100	0	1	278	1730498	1730221	Micropruina glycogenica isolate 1 genome assembly, chromosome: 1	blastn	86751	425	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Micropruina	Micropruina glycogenica
11639167	11639167	PRJNA1020641_P_NODE_2550_length_383_cov_0.796774_g2507_i0	PRJNA1020641	2550	383	0.796774	3.05164442	Clostridium septicum	1504	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2260370548\|gb\|CP099799.1\|	1504	g2507	i0	100	0.365535248041775	28	0	7	0	7	34	1015789	1015762	Clostridium septicum strain RMA 8861 chromosome, complete genome	blastn	140	52.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium septicum
12914277	12914277	PRJNA1020641_P_NODE_5791_length_250_cov_0.870056_g5748_i0	PRJNA1020641	5791	250	0.870056	2.17514	Ezakiella coagulans	46507	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g5748	i0	99.6	331.212	250	1	100	0	1	250	160491	160740	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	82803	457	1	Bacteria		Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
15463307	15463307	PRJNA1020641_P_NODE_6633_length_245_cov_0.895349_g6590_i0	PRJNA1020641	6633	245	0.895349	2.19360505	Ruoffia tabacinasalis	87458	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2686201366\|gb\|CP144682.1\|	87458	g6590	i0	99.592	558.318367346939	245	1	100	0	1	245	2884	2640	Ruoffia tabacinasalis strain jzb001 chromosome, complete genome	blastn	136788	448	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Ruoffia	Ruoffia tabacinasalis
15463309	15463309	PRJNA1020641_P_NODE_6953_length_244_cov_0.865497_g6910_i0	PRJNA1020641	6953	244	0.865497	2.11181268	Mycoplasmopsis meleagridis	29561	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2917220006\|gb\|CP182213.1\|	29561	g6910	i0	100	0.245901639344262	30	0	12	0	134	163	423295	423266	Mycoplasmopsis meleagridis strain W24_02583 chromosome	blastn	60	56.5	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis meleagridis
15463311	15463311	PRJNA1020641_P_NODE_7133_length_243_cov_0.870588_g7090_i0	PRJNA1020641	7133	243	0.870588	2.11552884	Pedococcus sp. KACC 23699	3149228	Bacteria	Bacteria	124	4.579999999999999e-24	NTclustered	gi\|2739524205\|gb\|CP157483.1\|	3149228	g7090	i0	96.053	26.7448559670782	76	3	31	0	103	178	3703373	3703298	Pedococcus sp. KACC 23699 chromosome, complete genome	blastn	6499	124	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Pedococcus	Pedococcus sp. KACC 23699
15463312	15463312	PRJNA1020641_P_NODE_7393_length_241_cov_0.916667_g7350_i0	PRJNA1020641	7393	241	0.916667	2.20916747	Geobacillus subterraneus	129338	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1831368328\|gb\|CP051162.1\|	129338	g7350	i0	100	1	241	0	100	0	1	241	3514054	3513814	Geobacillus subterraneus strain CPW16 chromosome, complete genome	blastn	241	446	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus subterraneus
16737519	16737519	PRJNA1020641_P_NODE_6114_length_248_cov_0.880000_g6071_i0	PRJNA1020641	6114	248	0.88	2.1824	Candidatus Malacoplasma girerdii	1318617	Bacteria	Bacteria	219	2.0899999999999994e-52	NTclustered	gi\|701168938\|gb\|CP007711.1\|	1318617	g6071	i0	85.185	3.56048387096774	216	28	85	4	37	248	91143	91358	Candidatus Mycoplasma girerdii strain VCU_M1, complete genome	blastn	883	219	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Candidatus Malacoplasma girerdii
17580852	17580852	PRJNA1020641_P_NODE_6854_length_244_cov_0.900585_g6811_i0	PRJNA1020641	6854	244	0.900585	2.1974274	Bacillota	1239	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1721134215\|emb\|LR699017.1\|	853	g6811	i0	100	132.540983606557	244	0	100	0	1	244	2739190	2739433	Faecalibacterium prausnitzii isolate MGYG-HGUT-02545 genome assembly, chromosome: 1	blastn	32340	451	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
18854652	18854652	PRJNA1020641_P_NODE_2415_length_393_cov_1.212500_g2372_i0	PRJNA1020641	2415	393	1.2125	4.765125	Corynebacterium	1716	Bacteria	Bacteria	669	0	NTclustered	gi\|1899780227\|gb\|CP061031.1\|	2735136	g2372	i0	97.692	285.681933842239	390	8	100	1	1	390	710642	711030	Corynebacterium wankanglinii strain zg-913 chromosome, complete genome	blastn	112273	675	0.991111111111111	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium wankanglinii
20129433	20129433	PRJNA1020641_P_NODE_6876_length_244_cov_0.900585_g6833_i0	PRJNA1020641	6876	244	0.900585	2.1974274	Clostridium	1485	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1389517133\|gb\|CP029329.1\|	1520	g6833	i0	100	1002.02049180328	244	0	100	0	1	244	271647	271890	Clostridium beijerinckii isolate WB53 chromosome, complete genome	blastn	244493	451	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
20561727	20561727	PRJNA1020641_P_NODE_4137_length_299_cov_0.871681_g4094_i0	PRJNA1020641	4137	299	0.871681	2.60632619	Pseudonocardia sp. EC080625-04	1096868	Bacteria	Bacteria	514	2.95e-141	NTclustered	gi\|928461215\|gb\|CP010989.1\|	1096868	g4094	i0	97.659	371.080267558528	299	7	100	0	1	299	2981890	2981592	Pseudonocardia sp. EC080625-04, complete genome	blastn	110953	514	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia sp. EC080625-04
20561733	20561733	PRJNA1020641_P_NODE_5937_length_249_cov_0.875000_g5894_i0	PRJNA1020641	5937	249	0.875	2.17875	Butyrivibrio fibrisolvens	831	Bacteria	Bacteria	272	1.5899999999999998e-68	NTclustered	gi\|2232665663\|gb\|CP065801.1\|	831	g5894	i0	86.345	1	249	34	100	0	1	249	228736	228488	Butyrivibrio fibrisolvens strain ASCUSDY19 chromosome 2, complete sequence	blastn	249	272	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Butyrivibrio	Butyrivibrio fibrisolvens
21837418	21837418	PRJNA1020641_P_NODE_5798_length_250_cov_0.870056_g5755_i0	PRJNA1020641	5798	250	0.870056	2.17514	Clostridiales bacterium	1898207	Bacteria	Bacteria	357	4.28e-94	NTclustered	gi\|2016505355\|gb\|CP069419.1\|	1898207	g5755	i0	92.4	1	250	19	100	0	1	250	990657	990408	Clostridiales bacterium strain XBB3002 chromosome, complete genome	blastn	250	357	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
23112861	23112861	PRJNA1020641_P_NODE_2839_length_364_cov_1.003436_g2796_i0	PRJNA1020641	2839	364	1.003436	3.65250704	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2638498304\|emb\|OY986430.1\|	2789857	g2796	i0	100	0.0769230769230769	28	0	8	0	103	130	401398	401425	Synechococcus sp. CBW1107 isolate KAC_114 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
23112871	23112871	PRJNA1020641_P_NODE_6939_length_244_cov_0.900585_g6896_i0	PRJNA1020641	6939	244	0.900585	2.1974274	Anoxybacillus flavithermus	33934	Bacteria	Bacteria	392	1.14e-104	NTclustered	gi\|212559329\|gb\|CP000922.1\|	491915	g6896	i0	95.868	4.54098360655738	242	10	99	0	1	242	498755	498514	Anoxybacillus flavithermus WK1, complete genome	blastn	1108	392	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus

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