metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA609258" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA609258" 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
587979	587979	PRJNA609258_P_NODE_58061_length_244_cov_0.912281_g57676_i0	PRJNA609258	58061	244	0.912281	2.22596564	Enterococcus casseliflavus	37734	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|1948649597\|gb\|CP066024.1\|	37734	g57676	i0	97.951	16.2295081967213	244	5	100	0	1	244	148991	148748	Enterococcus casseliflavus strain FDAARGOS_998 chromosome, complete genome	blastn	3960	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
3138795	3138795	PRJNA609258_P_NODE_56303_length_246_cov_0.901734_g55918_i0	PRJNA609258	56303	246	0.901734	2.21826564	Abiotrophia defectiva	46125	Bacteria	Bacteria	289	1.56e-73	NTclustered	gi\|1848537030\|gb\|CP053988.1\|	46125	g55918	i0	88.066	1.98780487804878	243	29	99	0	4	246	331895	331653	Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome	blastn	489	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Abiotrophia	Abiotrophia defectiva
3698807	3698807	PRJNA609258_P_NODE_14683_length_504_cov_1.447796_g14301_i0	PRJNA609258	14683	504	1.447796	7.29689184	root	1	Root_unresolved	Root_unresolved	931	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g14301	i0	100	42.8452380952381	504	0	100	0	1	504	2426505	2427008	Staphylococcus aureus strain WH9628 chromosome	blastn	21594	931	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
6250926	6250926	PRJNA609258_P_NODE_16005_length_481_cov_1.470588_g15621_i0	PRJNA609258	16005	481	1.470588	7.07352828	Dialister	39948	Bacteria	Bacteria	878	0	NTclustered	gi\|1493601541\|gb\|MH883587.1\|	278064	g15621	i0	99.584	574.002079002079	481	2	100	0	1	481	1233	1713	Uncultured Dialister sp. clone PMB_contig_12 genomic sequence	blastn	276095	878	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Dialister	uncultured Dialister sp.
9515811	9515811	PRJNA609258_P_NODE_42208_length_281_cov_1.125000_g41823_i0	PRJNA609258	42208	281	1.125	3.16125	Lentibacillus daqui	2911514	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2416166552\|gb\|CP114176.1\|	2911514	g41823	i0	100	0.099644128113879	28	0	10	0	19	46	680872	680899	Lentibacillus daqui strain ZS110521 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lentibacillus	Lentibacillus daqui
11350695	11350695	PRJNA609258_P_NODE_34689_length_315_cov_1.272727_g34304_i0	PRJNA609258	34689	315	1.272727	4.00909005	Risungbinella	1763555	Bacteria	Bacteria	582	8.459999999999998e-162	NTclustered	gi\|380849511\|gb\|JQ259779.1\|	1163934	g34304	i0	100	109.869841269841	315	0	100	0	1	315	323	9	Bacillales bacterium 'ARUP UnID 595' strain ARUP UnID 595 16S ribosomal RNA gene, partial sequence	blastn	34609	582	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales bacterium 'ARUP UnID 595'
11350788	11350788	PRJNA609258_P_NODE_6849_length_754_cov_1.954479_g6505_i0	PRJNA609258	6849	754	1.954479	14.73677166	Streptococcus	1301	Bacteria	Bacteria	1312	0	NTclustered	gi\|2269666911\|gb\|CP100330.1\|	1307	g6505	i0	98.018	389.525198938992	757	12	100	3	1	754	21184	21940	Streptococcus suis strain STC85 chromosome, complete genome	blastn	293702	1317	0.996203492786636	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
12626282	12626282	PRJNA609258_P_NODE_39090_length_294_cov_1.248869_g38705_i0	PRJNA609258	39090	294	1.248869	3.67167486	root	1	Root_unresolved	Root_unresolved	544	3.69e-150	NTclustered	gi\|2702654880\|gb\|CP148059.1\|	1280	g38705	i0	100	249.302721088435	294	0	100	0	1	294	1932606	1932313	Staphylococcus aureus strain BSN156 chromosome	blastn	73295	544	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
13341196	13341196	PRJNA609258_P_NODE_33271_length_322_cov_2.493976_g32886_i0	PRJNA609258	33271	322	2.493976	8.03060272	Ureibacillus chungkukjangi	1202712	Bacteria	Bacteria	590	5.18e-164	NTclustered	gi\|2851175656\|gb\|CP085009.1\|	1202712	g32886	i0	99.689	1082.18633540373	322	1	100	0	1	322	13267	13588	Ureibacillus chungkukjangi strain SLM-173 chromosome, complete genome	blastn	348464	590	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Ureibacillus	Ureibacillus chungkukjangi
13341804	13341804	PRJNA609258_P_NODE_50751_length_252_cov_0.871508_g50366_i0	PRJNA609258	50751	252	0.871508	2.19620016	Streptococcus mitis	28037	Bacteria	Bacteria	427	3.2499999999999993e-115	NTclustered	gi\|2886503043\|emb\|OZ217341.1\|	28037	g50366	i0	97.222	99.2063492063492	252	7	100	0	1	252	1515237	1514986	Streptococcus mitis isolate S. mitis C22 genome assembly, chromosome: 1	blastn	25000	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
13341922	13341922	PRJNA609258_P_NODE_54131_length_248_cov_0.891429_g53746_i0	PRJNA609258	54131	248	0.891429	2.21074392	Gemella haemolysans	1379	Bacteria	Bacteria	436	5.3e-118	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g53746	i0	98.387	3	248	4	100	0	1	248	1613742	1613989	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	744	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
13901242	13901242	PRJNA609258_P_NODE_33831_length_319_cov_3.134146_g33446_i0	PRJNA609258	33831	319	3.134146	9.99792574	Bacillaceae	186817	Bacteria	Bacteria	590	5.1299999999999986e-164	NTclustered	gi\|1899225375\|gb\|MT967839.1\|	83428	g33446	i0	100	1145.18808777429	319	0	100	0	1	319	2164	1846	Uncultured Bacillus sp. clone asv_338_2196 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	365315	590	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	uncultured Bacillus sp.
14616342	14616342	PRJNA609258_P_NODE_39952_length_290_cov_1.437788_g39567_i0	PRJNA609258	39952	290	1.437788	4.1695852	Metabacillus halosaccharovorans	930124	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|2780438057\|gb\|CP162630.1\|	930124	g39567	i0	100	1090.5275862069	290	0	100	0	1	290	36348	36059	Metabacillus halosaccharovorans strain Hao 2024 chromosome, complete genome	blastn	316253	536	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus halosaccharovorans
15175525	15175525	PRJNA609258_P_NODE_28012_length_354_cov_1.736655_g27627_i0	PRJNA609258	28012	354	1.736655	6.1477587	Dialister	39948	Bacteria	Bacteria	636	7.269999999999998e-178	NTclustered	gi\|2318958994\|gb\|CP107218.1\|	2049049	g27627	i0	98.883	444.036723163842	358	0	100	1	1	354	635442	635085	MAG: Veillonellaceae bacterium isolate KR001_HIC_0043 chromosome, complete genome	blastn	157189	636	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae		Veillonellaceae bacterium
15175558	15175558	PRJNA609258_P_NODE_35252_length_312_cov_1.510460_g34867_i0	PRJNA609258	35252	312	1.51046	4.7126352	Bacteria	2	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|529813127\|gb\|KF306379.1\|	1292	g34867	i0	100	100	312	0	100	0	1	312	518	207	Staphylococcus warneri strain y357 16S ribosomal RNA gene, partial sequence	blastn	31200	577	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
15175623	15175623	PRJNA609258_P_NODE_55632_length_247_cov_0.896552_g55247_i0	PRJNA609258	55632	247	0.896552	2.21448344	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1686074568\|gb\|MN075328.1\|	29380	g55247	i0	100	124	247	0	100	0	1	247	16	262	Staphylococcus caprae strain MBF24 16S ribosomal RNA gene, partial sequence	blastn	30628	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus caprae
15890744	15890744	PRJNA609258_P_NODE_52733_length_250_cov_0.881356_g52348_i0	PRJNA609258	52733	250	0.881356	2.20339	Streptococcus mitis	28037	Bacteria	Bacteria	385	1.97e-102	NTclustered	gi\|2886512733\|emb\|OZ217346.1\|	28037	g52348	i0	94.4	100	250	14	100	0	1	250	1112902	1112653	Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1	blastn	25000	385	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
17725151	17725151	PRJNA609258_P_NODE_20794_length_417_cov_1.360465_g20410_i0	PRJNA609258	20794	417	1.360465	5.67313905	Bacteria	2	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2299436630\|gb\|CP102281.1\|	39492	g20410	i0	100	0.134292565947242	28	0	7	0	219	246	793288	793315	[Eubacterium] siraeum strain DSM 15702 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		[Eubacterium] siraeum
17725246	17725246	PRJNA609258_P_NODE_52174_length_250_cov_0.881356_g51789_i0	PRJNA609258	52174	250	0.881356	2.20339	Streptococcus	1301	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1780487221\|gb\|CP046335.1\|	28037	g51789	i0	99.6	100	250	1	100	0	1	250	213595	213844	Streptococcus mitis strain FDAARGOS_684 chromosome, complete genome	blastn	25000	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
19714277	19714277	PRJNA609258_P_NODE_50496_length_252_cov_0.871508_g50111_i0	PRJNA609258	50496	252	0.871508	2.19620016	Streptococcus gwangjuensis	1433513	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1487526603\|gb\|CP032621.1\|	1433513	g50111	i0	100	99.4404761904762	252	0	100	0	1	252	1111296	1111547	Streptococcus gwangjuense strain ChDC B345 chromosome, complete genome	blastn	25059	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gwangjuensis
21549180	21549180	PRJNA609258_P_NODE_50697_length_252_cov_0.871508_g50312_i0	PRJNA609258	50697	252	0.871508	2.19620016	Paenibacillus	44249	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|1373996327\|gb\|CP028366.1\|	59843	g50312	i0	99.603	5.98809523809524	252	1	100	0	1	252	4168863	4169114	Paenibacillus glucanolyticus strain W10507 chromosome	blastn	1509	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
24814121	24814121	PRJNA609258_P_NODE_53660_length_249_cov_0.886364_g53275_i0	PRJNA609258	53660	249	0.886364	2.20704636	Ureibacillus chungkukjangi	1202712	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2851175656\|gb\|CP085009.1\|	1202712	g53275	i0	100	93.710843373494	249	0	100	0	1	249	1628794	1629042	Ureibacillus chungkukjangi strain SLM-173 chromosome, complete genome	blastn	23334	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Ureibacillus	Ureibacillus chungkukjangi

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