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

22 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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
1588389	1588389	PRJNA1166865_P_NODE_76262_length_251_cov_0.865169_g76021_i0	PRJNA1166865	76262	251	0.865169	2.17157419	Shouchella clausii	79880	Bacteria	Bacteria	75	4.85e-9	NTclustered	gi\|2733054080\|gb\|CP155470.1\|	79880	g76021	i0	97.674	9.06374501992032	43	1	18	0	206	248	1145882	1145840	Shouchella clausii strain FSL M8-0080 chromosome, complete genome	blastn	2275	75	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Shouchella	Shouchella clausii
3590046	3590046	PRJNA1166865_P_NODE_283_length_2189_cov_9.191399_g263_i0	PRJNA1166865	283	2189	9.191399	201.19972411	root	1	Root_unresolved	Root_unresolved	4002	0	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g263	i0	99.817	54.0977615349475	2180	2	99	2	10	2188	2426280	2428458	Staphylococcus aureus strain WH9628 chromosome	blastn	118420	4002	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4139611	4139611	PRJNA1166865_P_NODE_39404_length_347_cov_1.124088_g39163_i0	PRJNA1166865	39404	347	1.124088	3.90058536	Anaerococcus sp. Marseille-Q7828	3036300	Bacteria	Bacteria	625	1.5399999999999999e-174	NTclustered	gi\|2472116327\|emb\|OX458331.1\|	3036300	g39163	i0	99.135	326.115273775216	347	3	100	0	1	347	257535	257881	Anaerococcus sp. Marseille-Q7828 genome assembly, chromosome: contig00001	blastn	113162	625	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. Marseille-Q7828
4867707	4867707	PRJNA1166865_P_NODE_75884_length_251_cov_0.865169_g75643_i0	PRJNA1166865	75884	251	0.865169	2.17157419	Streptococcus	1301	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2579634605\|gb\|CP118306.1\|	1314	g75643	i0	100	100	251	0	100	0	1	251	244914	244664	Streptococcus pyogenes strain 20154608 chromosome, complete genome	blastn	25100	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pyogenes
6142538	6142538	PRJNA1166865_P_NODE_94745_length_241_cov_0.916667_g94504_i0	PRJNA1166865	94745	241	0.916667	2.20916747	Clostridium	1485	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2446185767\|gb\|CP118008.1\|	1502	g94504	i0	100	959.070539419087	241	0	100	0	1	241	1589621	1589861	Clostridium perfringens strain OB21 TSA 19 chromosome, complete genome	blastn	231136	446	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
7965390	7965390	PRJNA1166865_P_NODE_13827_length_575_cov_3.189243_g13590_i0	PRJNA1166865	13827	575	3.189243	18.33814725	Alkalicella caledoniensis	2731377	Bacteria	Bacteria	86.1	5.6e-12	NTclustered	gi\|1899071149\|gb\|CP058559.1\|	2731377	g13590	i0	87.013	12.8417391304348	77	9	13	1	147	222	1065959	1065883	Alkalicella caledoniensis strain LB2 chromosome, complete genome	blastn	7384	86.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Proteinivoracaceae	Alkalicella	Alkalicella caledoniensis
7966768	7966768	PRJNA1166865_P_NODE_6707_length_809_cov_1.517663_g6510_i0	PRJNA1166865	6707	809	1.517663	12.27789367	Dysosmobacter sp. Marseille-Q4140	2830675	Bacteria	Bacteria	54.7	0.023	NTclustered	gi\|2031400201\|gb\|CP073694.1\|	2830675	g6510	i0	96.875	0.0395550061804697	32	1	4	0	262	293	200174	200143	Dysosmobacter sp. Marseille-Q4140 chromosome	blastn	32	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Dysosmobacter	Dysosmobacter sp. Marseille-Q4140
9240746	9240746	PRJNA1166865_P_NODE_40128_length_344_cov_1.136531_g39887_i0	PRJNA1166865	40128	344	1.136531	3.90966664	Streptococcus parasanguinis	1318	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2582929504\|gb\|CP134147.1\|	1318	g39887	i0	100	0.0813953488372093	28	0	8	0	6	33	373046	373073	Streptococcus parasanguinis strain 30.8.10 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
9241230	9241230	PRJNA1166865_P_NODE_58588_length_289_cov_1.365741_g58347_i0	PRJNA1166865	58588	289	1.365741	3.94699149	Streptococcus gallolyticus	315405	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|288730948\|emb\|FN597254.1\|	637909	g58347	i0	94.444	0.996539792387543	36	2	12	0	119	154	659946	659981	Streptococcus gallolyticus UCN34 complete genome	blastn	288	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gallolyticus
9241371	9241371	PRJNA1166865_P_NODE_64268_length_276_cov_1.359606_g64027_i0	PRJNA1166865	64268	276	1.359606	3.75251256	Koleobacter methoxysyntrophicus	2751313	Bacteria	Bacteria	130	1.14e-25	NTclustered	gi\|1998494853\|gb\|CP059066.1\|	2751313	g64027	i0	90.909	197.967391304348	99	6	36	3	92	188	1015678	1015581	Koleobacter methoxysyntrophicus strain NRmbB1 chromosome, complete genome	blastn	54639	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Koleobacterales	Koleobacteraceae	Koleobacter	Koleobacter methoxysyntrophicus
10515732	10515732	PRJNA1166865_P_NODE_11489_length_629_cov_3.052158_g11257_i0	PRJNA1166865	11489	629	3.052158	19.19807382	Lactobacillus iners	147802	Bacteria	Bacteria	1157	0	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g11257	i0	99.841	475.777424483307	629	1	100	0	1	629	380639	380011	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	299264	1157	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
13066462	13066462	PRJNA1166865_P_NODE_42431_length_336_cov_1.019011_g42190_i0	PRJNA1166865	42431	336	1.0190109999999999	3.42387696	Flintibacter sp. KGMB00164	2610895	Bacteria	Bacteria	459	1.6e-124	NTclustered	gi\|1752759833\|gb\|CP044227.1\|	2610895	g42190	i0	91.395	243.785714285714	337	25	100	4	1	336	671252	670919	Flintibacter sp. KGMB00164 chromosome, complete genome	blastn	81912	459	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Flintibacter	Flintibacter sp. KGMB00164
14342081	14342081	PRJNA1166865_P_NODE_52212_length_305_cov_2.995690_g51971_i0	PRJNA1166865	52212	305	2.99569	9.1368545	Lactobacillus iners	147802	Bacteria	Bacteria	560	3.82e-155	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g51971	i0	100	559.727868852459	303	0	99	0	3	305	3049	2747	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	170717	560	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
14342135	14342135	PRJNA1166865_P_NODE_54532_length_299_cov_1.438053_g54291_i0	PRJNA1166865	54532	299	1.438053	4.29977847	Ruminiclostridium herbifermentans	2488810	Bacteria	Bacteria	209	1.56e-49	NTclustered	gi\|1907695262\|gb\|CP061336.1\|	2488810	g54291	i0	79.47	55.3612040133779	302	56	100	6	1	299	1202443	1202145	Ruminiclostridium herbifermentans strain MA18 chromosome, complete genome	blastn	16553	209	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium herbifermentans
15616035	15616035	PRJNA1166865_P_NODE_55953_length_295_cov_1.887387_g55712_i0	PRJNA1166865	55953	295	1.887387	5.56779165	Streptococcus sp. NPS 308	1902136	Bacteria	Bacteria	420	6.52e-113	NTclustered	gi\|1080114141\|dbj\|AP017652.1\|	1902136	g55712	i0	93.929	319.671186440678	280	13	94	4	1	278	16615	16892	Streptococcus sp. NPS 308 DNA, complete genome	blastn	94303	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. NPS 308
16342171	16342171	PRJNA1166865_P_NODE_86033_length_245_cov_1.790698_g85792_i0	PRJNA1166865	86033	245	1.790698	4.3872101	Bacteria	2	Bacteria	Bacteria	80.5	1.01e-10	NTclustered	gi\|1539772410\|emb\|LR134297.1\|	1354	g85792	i0	94.231	28.7673469387755	52	3	40	0	49	100	2027420	2027471	Enterococcus hirae strain NCTC12368 genome assembly, chromosome: 1	blastn	7048	80.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus hirae
16342189	16342189	PRJNA1166865_P_NODE_96113_length_196_cov_7.365854_g95872_i0	PRJNA1166865	96113	196	7.365854	14.43707384	root	1	Root_unresolved	Root_unresolved	363	6.899999999999998e-96	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g95872	i0	100	1955.49489795918	196	0	100	0	1	196	4000367	4000172	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	383277	363	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
17617378	17617378	PRJNA1166865_P_NODE_73834_length_253_cov_1.711111_g73593_i0	PRJNA1166865	73834	253	1.711111	4.32911083	Exiguobacterium	33986	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2621702593\|emb\|OY760436.1\|	307643	g73593	i0	100	24.7628458498024	253	0	100	0	1	253	2829558	2829306	MAG: Exiguobacterium profundum isolate 8ac3ae97-4b35-4674-8cf6-a299ed097117 genome assembly, chromosome: 1	blastn	6265	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
18164961	18164961	PRJNA1166865_P_NODE_60155_length_285_cov_1.608491_g59914_i0	PRJNA1166865	60155	285	1.608491	4.58419935	Streptococcus alactolyticus	29389	Bacteria	Bacteria	514	2.79e-141	NTclustered	gi\|2417856148\|gb\|CP114883.1\|	29389	g59914	i0	99.296	410.242105263158	284	2	99	0	2	285	18351	18068	Streptococcus alactolyticus strain LGM chromosome, complete genome	blastn	116919	514	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus alactolyticus
20713766	20713766	PRJNA1166865_P_NODE_23677_length_442_cov_1.252033_g23436_i0	PRJNA1166865	23677	442	1.252033	5.53398586	Enterococcus raffinosus	71452	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2309100492\|gb\|CP104763.1\|	71452	g23436	i0	100	0.5	31	0	7	0	330	360	876747	876777	Enterococcus raffinosus strain ATCC 49464 plasmid p1_ATCC49464, complete sequence	blastn	221	58.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus raffinosus
22716525	22716525	PRJNA1166865_P_NODE_52698_length_304_cov_1.567100_g52457_i0	PRJNA1166865	52698	304	1.5671	4.763984	Bacillaceae	186817	Bacteria	Bacteria	529	1.0699999999999996e-145	NTclustered	gi\|2579552595\|gb\|CP134494.1\|	129985	g52457	i0	98.026	1194.38157894737	304	6	100	0	1	304	12666	12969	Mesobacillus jeotgali strain PS1 chromosome, complete genome	blastn	363092	534	0.99063670411985	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Mesobacillus	Mesobacillus jeotgali
23991861	23991861	PRJNA1166865_P_NODE_93559_length_241_cov_2.750000_g93318_i0	PRJNA1166865	93559	241	2.75	6.6275	Listeria	1637	Bacteria	Bacteria	99	2.75e-16	NTclustered	gi\|2811781970\|gb\|CP139939.1\|	1639	g93318	i0	83.654	108.439834024896	104	17	43	0	1	104	716630	716527	Listeria monocytogenes strain 32 chromosome, complete genome	blastn	26134	99	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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