metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
441924	441924	PRJNA453567_P_NODE_4941_length_466_cov_2.342657_g4706_i0	PRJNA453567	4941	466	2.342657	10.91678162	Shouchella clausii	79880	Bacteria	Bacteria	65.8	5.82e-6	NTclustered	gi\|2727604063\|gb\|CP154609.1\|	79880	g4706	i0	100	1.77682403433476	35	0	8	0	28	62	613321	613287	Shouchella clausii strain ANA39 chromosome	blastn	828	65.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Shouchella	Shouchella clausii
6819488	6819488	PRJNA453567_P_NODE_19986_length_198_cov_1.304348_g19749_i0	PRJNA453567	19986	198	1.304348	2.58260904	Gemella haemolysans	1379	Bacteria	Bacteria	339	1.18e-88	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g19749	i0	97.475	504.227272727273	198	5	100	0	1	198	10717	10914	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	99837	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
8094968	8094968	PRJNA453567_P_NODE_24887_length_176_cov_1.122302_g24650_i0	PRJNA453567	24887	176	1.122302	1.97525152	Paenibacillus durus	44251	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|818431484\|gb\|CP011114.1\|	1333534	g24650	i0	100	0.170454545454545	30	0	17	0	32	61	4508731	4508702	Paenibacillus durus ATCC 35681, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus durus
10645806	10645806	PRJNA453567_P_NODE_7549_length_356_cov_13.927900_g7312_i0	PRJNA453567	7549	356	13.9279	49.583324	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2318951205\|gb\|CP107213.1\|	853	g7312	i0	94.286	0.098314606741573	35	2	10	0	220	254	620937	620903	MAG: Faecalibacterium prausnitzii isolate KR001_HIC_0004 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
11920632	11920632	PRJNA453567_P_NODE_24250_length_178_cov_1.652482_g24013_i0	PRJNA453567	24250	178	1.652482	2.94141796	Heliomicrobium modesticaldum	35701	Bacteria	Bacteria	104	4.1e-18	NTclustered	gi\|171696369\|gb\|CP000930.2\|	498761	g24013	i0	78.846	18.6966292134831	156	31	87	2	24	178	2367919	2367765	Heliomicrobium modesticaldum Ice1 chromosome, complete genome	blastn	3328	104	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Heliobacteriaceae	Heliomicrobium	Heliomicrobium modesticaldum
13195493	13195493	PRJNA453567_P_NODE_33851_length_151_cov_0.964912_g33614_i0	PRJNA453567	33851	151	0.964912	1.45701712	Brevibacillus sp. 7WMA2	2683193	Bacteria	Bacteria	104	3.35e-18	NTclustered	gi\|1810936193\|gb\|CP048799.1\|	2683193	g33614	i0	94.118	10.5099337748344	68	4	45	0	84	151	2231686	2231753	Brevibacillus sp. 7WMA2 chromosome, complete genome	blastn	1587	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus sp. 7WMA2
17019240	17019240	PRJNA453567_P_NODE_7994_length_345_cov_14.613636_g7757_i0	PRJNA453567	7994	345	14.613636	50.4170442	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2318951205\|gb\|CP107213.1\|	853	g7757	i0	94.286	0.101449275362319	35	2	10	0	209	243	620937	620903	MAG: Faecalibacterium prausnitzii isolate KR001_HIC_0004 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
18944900	18944900	PRJNA453567_P_NODE_33275_length_152_cov_1.356522_g33038_i0	PRJNA453567	33275	152	1.356522	2.06191344	Gemella	1378	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g33038	i0	100	461.184210526316	152	0	100	0	1	152	12313	12162	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	70100	281	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
20219636	20219636	PRJNA453567_P_NODE_31216_length_157_cov_1.158333_g30979_i0	PRJNA453567	31216	157	1.158333	1.81858281	Anoxybacillus	150247	Bacteria	Bacteria	283	4.22e-72	NTclustered	gi\|1024273344\|gb\|CP015435.1\|	1490052	g30979	i0	99.363	872.140127388535	157	0	100	1	1	157	2564798	2564953	Anoxybacillus sp. B2M1, complete genome	blastn	136926	283	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus sp. B2M1
22118335	22118335	PRJNA453567_P_NODE_23338_length_182_cov_1.075862_g23101_i0	PRJNA453567	23338	182	1.075862	1.95806884	uncultured Anaeromusa sp.	673273	Bacteria	Bacteria	285	1.4e-72	NTclustered	gi\|2621785002\|emb\|OY781460.1\|	673273	g23101	i0	96	592.983516483516	175	7	96	0	8	182	977581	977755	MAG: uncultured Anaeromusa sp. isolate 423aa38a-05bb-4dba-a328-1f18f907f8f2 genome assembly, chromosome: 1	blastn	107923	285	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Anaeromusa	uncultured Anaeromusa sp.
22770350	22770350	PRJNA453567_P_NODE_19038_length_203_cov_1.831325_g18801_i0	PRJNA453567	19038	203	1.831325	3.71758975	root	1	Root_unresolved	Root_unresolved	370	4.3e-98	NTclustered	gi\|1784064579\|gb\|MN826479.1\|	1409	g18801	i0	99.507	115	203	1	100	0	1	203	726	524	Bacillus sp. (in: Bacteria) strain 5 SA46 16S ribosomal RNA gene, partial sequence	blastn	23345	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
24668001	24668001	PRJNA453567_P_NODE_23580_length_181_cov_1.333333_g23343_i0	PRJNA453567	23580	181	1.333333	2.41333273	Anoxybacillus sp. PDR2	1636720	Bacteria	Bacteria	285	1.39e-72	NTclustered	gi\|1790794628\|gb\|CP047158.1\|	1636720	g23343	i0	95.055	786.75138121547	182	8	100	1	1	181	14420	14239	Anoxybacillus sp. PDR2 chromosome, complete genome	blastn	142402	285	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus sp. PDR2
25319624	25319624	PRJNA453567_P_NODE_21820_length_188_cov_1.569536_g21583_i0	PRJNA453567	21820	188	1.569536	2.95072768	Leuconostoc	1243	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|507148371\|ref\|NR_103174.1\|	1244	g21583	i0	100	344	188	0	100	0	1	188	503	690	Leuconostoc gelidum strain JB7 23S ribosomal RNA gene, complete sequence	blastn	64672	348	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc gelidum

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