metadata: contig_metadata: 10 rows where bioproject = "PRJNA1009807" and tax

10 rows where bioproject = "PRJNA1009807" 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
1429599	1429599	PRJNA1009807_S_NODE_3882_length_167_cov_1.546875_g3854_i0	PRJNA1009807	3882	167	1.546875	2.58328125	Clostridium taeniosporum	394958	Bacteria	Bacteria	124	2.9299999999999998e-24	NTclustered	gi\|1326041695\|gb\|CP017253.2\|	394958	g3854	i0	80.864	217.467065868263	162	27	95	3	8	165	14488	14327	Clostridium taeniosporum strain 1/k chromosome, complete genome	blastn	36317	124	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium taeniosporum
2276535	2276535	PRJNA1009807_S_NODE_2182_length_211_cov_3.296512_g2154_i0	PRJNA1009807	2182	211	3.296512	6.95564032	Paraclostridium	1849822	Bacteria	Bacteria	335	1.6399999999999994e-87	NTclustered	gi\|2695214537\|gb\|CP124295.1\|	1505	g2154	i0	95.261	1121.11848341232	211	10	100	0	1	211	49723	49933	Paraclostridium sordellii strain C116 chromosome, complete genome	blastn	236556	335	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium sordellii
9082282	9082282	PRJNA1009807_S_NODE_2488_length_200_cov_1.583851_g2460_i0	PRJNA1009807	2488	200	1.583851	3.167702	Desulfitobacterium hafniense	49338	Bacteria	Bacteria	117	6.0700000000000005e-22	NTclustered	gi\|698320587\|emb\|LK996023.1\|	49338	g2460	i0	85.088	484.01	114	17	57	0	10	123	323	436	Desulfitobacterium hafniense strain PCE-S genome assembly, scaffold: scaffold6	blastn	96802	117	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfitobacterium	Desulfitobacterium hafniense
14183450	14183450	PRJNA1009807_S_NODE_2292_length_207_cov_2.630952_g2264_i0	PRJNA1009807	2292	207	2.630952	5.44607064	[Eubacterium] minutum	76124	Bacteria	Bacteria	93.5	1.07e-14	NTclustered	gi\|1229039483\|gb\|CP016202.1\|	888721	g2264	i0	92.424	1.55072463768116	66	4	59	1	10	74	511793	511858	Eubacterium minutum ATCC 700079 sequence	blastn	321	93.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae		[Eubacterium] minutum
15457384	15457384	PRJNA1009807_S_NODE_1373_length_258_cov_1.589041_g1345_i0	PRJNA1009807	1373	258	1.589041	4.09972578	Romboutsia hominis	1507512	Bacteria	Bacteria	372	1.59e-98	NTclustered	gi\|1363978562\|emb\|LN650648.1\|	1507512	g1345	i0	92.996	1040.21705426357	257	15	99	1	2	258	2814810	2815063	Romboutsia sp. Frifi strain FRIFI genome assembly, chromosome: chromosome1	blastn	268376	372	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Romboutsia	Romboutsia hominis
18853077	18853077	PRJNA1009807_S_NODE_1195_length_277_cov_7.310924_g1167_i0	PRJNA1009807	1195	277	7.310924	20.25125948	Anoxybacillus	150247	Bacteria	Bacteria	296	1.07e-75	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g1167	i0	85.971	1009.3321299639	278	37	100	2	1	277	1490025	1489749	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	279585	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
21403504	21403504	PRJNA1009807_S_NODE_477_length_416_cov_14.970822_g449_i0	PRJNA1009807	477	416	14.970822	62.27861952	Weissella	46255	Bacteria	Bacteria	316	1.29e-81	NTclustered	gi\|2666877296\|gb\|CP130559.1\|	1249	g449	i0	80.796	358.774038461538	427	62	100	18	1	416	1180665	1180248	Weissella paramesenteroides strain MbWp-142 chromosome, complete genome	blastn	149250	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella paramesenteroides
21831601	21831601	PRJNA1009807_S_NODE_4298_length_160_cov_2.487603_g4270_i0	PRJNA1009807	4298	160	2.487603	3.9801648	Paraclostridium ghonii	29358	Bacteria	Bacteria	285	1.2e-72	NTclustered	gi\|2789028785\|gb\|CP161000.1\|	29358	g4270	i0	98.75	1099.1125	160	2	100	0	1	160	13587	13428	Paraclostridium ghonii strain NCTR 3900 chromosome, complete genome	blastn	175858	285	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium ghonii
28108234	28108234	PRJNA1009807_S_NODE_3645_length_171_cov_2.227273_g3617_i0	PRJNA1009807	3645	171	2.227273	3.80863683	Acetivibrio thermocellus BC1	1349417	Bacteria	Bacteria	62	3.71e-10	NR	CDG37541.1	1349417	g3617	i0	58	0.87719298245614	50	21	87.7	0	150	1	52	101	CDG37541.1 hypothetical protein CTHBC1_2972 [Acetivibrio thermocellus BC1]	diamond	150	62	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Acetivibrio	Acetivibrio thermocellus
32184267	32184267	PRJNA1009807_S_NODE_2898_length_188_cov_1.355705_g2870_i0	PRJNA1009807	2898	188	1.355705	2.5487254	Veillonella	29465	Bacteria	Bacteria	40.4	0.0426	NR	WP_369407422.1	29465	g2870	i0	34	0.845744680851064	53	33	84.6	1	163	5	35	85	WP_369407422.1 MULTISPECIES: pentapeptide repeat-containing protein [Veillonella]	diamond	159	40.4	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella

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