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

19 rows where analysis = "blastn", bioproject = "PRJNA1020641" 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
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
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
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
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
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
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
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
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);;