metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA577580" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA577580" 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
5667778	5667778	PRJNA577580_P_NODE_5_length_4308_cov_17.888548_g2_i0	PRJNA577580	5	4308	17.888548	770.63864784	Clostridium beijerinckii	1520	Bacteria	Bacteria	91.6	9.52e-13	NTclustered	gi\|1389517133\|gb\|CP029329.1\|	1520	g2	i0	85.227	1.53365831012071	88	13	12	0	1416	1503	3143907	3143994	Clostridium beijerinckii isolate WB53 chromosome, complete genome	blastn	6607	91.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
5667818	5667818	PRJNA577580_P_NODE_9365_length_298_cov_1.333333_g9287_i0	PRJNA577580	9365	298	1.333333	3.97333234	Clostridium culturomicium	1499683	Bacteria	Bacteria	374	5.2e-99	NTclustered	gi\|2831321202\|gb\|CP171113.1\|	1499683	g9287	i0	89.298	824.127516778523	299	31	100	1	1	298	12662	12960	Clostridium culturomicium strain WGS1527 chromosome, complete genome	blastn	245590	374	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium culturomicium
8217169	8217169	PRJNA577580_P_NODE_107_length_1859_cov_9.563270_g89_i0	PRJNA577580	107	1859	9.56327	177.7811893	Bacillus sp. FSL R5-0560	2954588	Bacteria	Bacteria	398	2.1399999999999995e-105	NTclustered	gi\|2709607542\|gb\|CP150195.1\|	2954588	g89	i0	77.367	297.212479827864	676	149	36	4	556	1228	848530	849204	Bacillus sp. FSL R5-0560 chromosome, complete genome	blastn	552518	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. FSL R5-0560
9492461	9492461	PRJNA577580_P_NODE_3368_length_491_cov_2.215311_g3290_i0	PRJNA577580	3368	491	2.215311	10.87717701	Tumebacillus algifaecis	1214604	Bacteria	Bacteria	132	5.98e-26	NTclustered	gi\|1229072455\|gb\|CP022657.1\|	1214604	g3290	i0	88.182	1.54989816700611	110	13	22	0	375	484	1334370	1334261	Tumebacillus algifaecis strain THMBR28, complete genome	blastn	761	132	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Alicyclobacillaceae	Tumebacillus	Tumebacillus algifaecis
10066651	10066651	PRJNA577580_P_NODE_15348_length_246_cov_0.901734_g15270_i0	PRJNA577580	15348	246	0.901734	2.21826564	root	1	Root_unresolved	Root_unresolved	182	2.72e-41	NTclustered	gi\|2246265477\|gb\|CP097639.1\|	1624	g15270	i0	83.673	80.6707317073171	196	28	79	4	9	202	629962	629769	Ligilactobacillus salivarius strain S01 chromosome, complete genome	blastn	19845	183	0.994535519125683	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
10768275	10768275	PRJNA577580_P_NODE_129_length_1768_cov_6.435398_g111_i0	PRJNA577580	129	1768	6.435398	113.77783664	Clostridium gasigenes	94869	Bacteria	Bacteria	143	1.05e-28	NTclustered	gi\|2005129914\|gb\|CP071376.1\|	94869	g111	i0	71.609	6.30712669683258	553	147	31	10	617	1164	403977	403430	Clostridium gasigenes strain CGAS001 chromosome CGAS001, complete sequence	blastn	11151	143	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium gasigenes
10768380	10768380	PRJNA577580_P_NODE_9_length_4165_cov_19.684018_g5_i0	PRJNA577580	9	4165	19.684018	819.8393497	Gottfriedia acidiceleris	371036	Bacteria	Bacteria	56.5	0.034	NTclustered	gi\|2230637776\|gb\|CP096034.1\|	371036	g5	i0	100	0.00720288115246098	30	0	1	0	3191	3220	1001757	1001728	Gottfriedia acidiceleris strain LH14 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gottfriedia	Gottfriedia acidiceleris
11341427	11341427	PRJNA577580_P_NODE_13249_length_255_cov_1.538462_g13171_i0	PRJNA577580	13249	255	1.538462	3.9230781	Bacillaceae	186817	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2530477131\|gb\|CP128801.1\|	189381	g13171	i0	100	0.454901960784314	29	0	11	0	141	169	3576657	3576629	Rossellomorea marisflavi strain SRCM125375 chromosome, complete genome	blastn	116	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea marisflavi
12617145	12617145	PRJNA577580_P_NODE_11410_length_273_cov_1.460000_g11332_i0	PRJNA577580	11410	273	1.46	3.9858	Lysinibacillus	400634	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2805658246\|gb\|CP167119.1\|	28031	g11332	i0	92.105	0.52014652014652	38	2	14	1	101	138	1493237	1493273	Lysinibacillus fusiformis strain LS1 chromosome, complete genome	blastn	142	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus fusiformis
14592945	14592945	PRJNA577580_P_NODE_7752_length_324_cov_1.569721_g7674_i0	PRJNA577580	7752	324	1.569721	5.08589604	Paenibacillus cellulosilyticus	375489	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1858325381\|gb\|CP054612.1\|	375489	g7674	i0	100	0.0895061728395062	29	0	9	0	1	29	3074876	3074848	Paenibacillus cellulosilyticus strain KACC 14175 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus cellulosilyticus
15866718	15866718	PRJNA577580_P_NODE_4653_length_416_cov_0.932945_g4575_i0	PRJNA577580	4653	416	0.932945	3.8810512	Bacillus glycinifermentans	1664069	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|1250084931\|gb\|CP023481.1\|	1664069	g4575	i0	100	0.201923076923077	28	0	7	0	164	191	473506	473533	Bacillus glycinifermentans strain KBN06P03352 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus glycinifermentans
18415928	18415928	PRJNA577580_P_NODE_175_length_1615_cov_10.304150_g153_i0	PRJNA577580	175	1615	10.30415	166.4120225	Clostridium beijerinckii	1520	Bacteria	Bacteria	137	4.4600000000000006e-27	NTclustered	gi\|1389517133\|gb\|CP029329.1\|	1520	g153	i0	80.214	12.959133126935	187	33	16	4	601	785	3144029	3143845	Clostridium beijerinckii isolate WB53 chromosome, complete genome	blastn	20929	137	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium beijerinckii
19690453	19690453	PRJNA577580_P_NODE_16756_length_236_cov_2.012270_g16678_i0	PRJNA577580	16756	236	2.01227	4.7489572	Clostridium sp. JS66	3064705	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2620058225\|gb\|CP131467.1\|	3064705	g16678	i0	100	0.11864406779661	28	0	12	0	180	207	2977768	2977741	Clostridium sp. JS66 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. JS66
20966203	20966203	PRJNA577580_P_NODE_16857_length_233_cov_2.412500_g16779_i0	PRJNA577580	16857	233	2.4125	5.621125	Novibacillus thermophilus	1471761	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1148968360\|gb\|CP019699.1\|	1471761	g16779	i0	96.774	0.133047210300429	31	1	13	0	178	208	2718441	2718471	Novibacillus thermophilus strain SG-1 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Novibacillus	Novibacillus thermophilus
23516410	23516410	PRJNA577580_P_NODE_119_length_1812_cov_21.118459_g101_i0	PRJNA577580	119	1812	21.118459	382.66647708	Bacillus cereus	1396	Bacteria	Bacteria	268	1.7e-66	NTclustered	gi\|2170512269\|dbj\|AP022890.1\|	1396	g101	i0	74.845	10.8565121412804	644	137	37	22	529	1155	8461	7826	Bacillus cereus MRY14-0074 plasmid pMRY14-0074_4 DNA, complete sequence	blastn	19672	268	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
24090004	24090004	PRJNA577580_P_NODE_11559_length_271_cov_2.252525_g11481_i0	PRJNA577580	11559	271	2.252525	6.10434275	Streptococcus	1301	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|2288405307\|gb\|CP076703.1\|	1335	g11481	i0	99.631	519.405904059041	271	1	100	0	1	271	19280	19550	Streptococcus equinus strain S1 chromosome, complete genome	blastn	140759	496	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus

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