metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA908278" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA908278" 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
890265	890265	PRJNA908278_P_NODE_23401_length_268_cov_1.430769_g23298_i0	PRJNA908278	23401	268	1.430769	3.83446092	Vagococcus intermedius	2991418	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2452954818\|gb\|CP110237.1\|	2991418	g23298	i0	100	0.208955223880597	28	0	10	0	103	130	2074236	2074263	Vagococcus intermedius strain STAA25 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus intermedius
2165621	2165621	PRJNA908278_P_NODE_24922_length_259_cov_1.580645_g24819_i0	PRJNA908278	24922	259	1.580645	4.09387055	Lactobacillus iners	147802	Bacteria	Bacteria	473	4.25e-129	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g24819	i0	99.614	514.53667953668	259	1	100	0	1	259	4577	4319	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	133265	473	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
4718696	4718696	PRJNA908278_P_NODE_14864_length_326_cov_1.747036_g14761_i0	PRJNA908278	14864	326	1.747036	5.69533736	Clostridiaceae bacterium 35-E11	3039679	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2719070735\|gb\|CP121688.1\|	3039679	g14761	i0	100	0.0889570552147239	29	0	9	0	283	311	3064708	3064736	Clostridiaceae bacterium 35-E11 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium 35-E11
5993566	5993566	PRJNA908278_P_NODE_30225_length_247_cov_0.885057_g30122_i0	PRJNA908278	30225	247	0.885057	2.18609079	Coprococcus sp. ART55/1	751585	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|295092884\|emb\|FP929039.1\|	751585	g30122	i0	100	0.506072874493927	29	0	12	0	147	175	85534	85562	Coprococcus sp. ART55/1 draft genome	blastn	125	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Coprococcus	Coprococcus sp. ART55/1
5993713	5993713	PRJNA908278_P_NODE_9125_length_397_cov_1.638889_g9022_i0	PRJNA908278	9125	397	1.638889	6.50638933	Erysipelothrix sp. HDW6A	2714928	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|1821704000\|gb\|CP049859.1\|	2714928	g9022	i0	94.118	0.0856423173803526	34	2	9	0	346	379	37312	37345	Erysipelothrix sp. HDW6A chromosome, complete genome	blastn	34	52.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Erysipelothrix	Erysipelothrix sp. HDW6A
7268322	7268322	PRJNA908278_P_NODE_17206_length_307_cov_1.299145_g17103_i0	PRJNA908278	17206	307	1.299145	3.98837515	Tissierellales bacterium	2053631	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2621785013\|emb\|OY781471.1\|	2053631	g17103	i0	100	0.0912052117263844	28	0	9	0	27	54	35863	35890	MAG: Tissierellales bacterium isolate f5db3f26-e30e-4500-98bb-a46faba182b7 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales			Tissierellales bacterium
7268352	7268352	PRJNA908278_P_NODE_20286_length_286_cov_1.446009_g20183_i0	PRJNA908278	20286	286	1.446009	4.13558574	Lactobacillus iners	147802	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g20183	i0	100	519.989510489511	286	0	100	0	1	286	3047	3332	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	148717	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
7268378	7268378	PRJNA908278_P_NODE_22606_length_273_cov_1.155000_g22503_i0	PRJNA908278	22606	273	1.155	3.15315	Mammaliicoccus sp. Dog046	3034233	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2624850201\|gb\|CP120131.1\|	3034233	g22503	i0	94.286	0.128205128205128	35	1	13	1	37	71	1366927	1366894	Mammaliicoccus sp. Dog046 chromosome, complete genome	blastn	35	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus sp. Dog046
9818310	9818310	PRJNA908278_P_NODE_5608_length_494_cov_0.814727_g5505_i0	PRJNA908278	5608	494	0.814727	4.02475138	Clostridium cadaveris	1529	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2154003691\|gb\|CP076620.1\|	1529	g5505	i0	100	0.0607287449392713	30	0	6	0	40	69	323722	323693	Clostridium cadaveris strain IFB3C5 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium cadaveris
11093776	11093776	PRJNA908278_P_NODE_14809_length_327_cov_1.051181_g14706_i0	PRJNA908278	14809	327	1.051181	3.43736187	Desulfofarcimen acetoxidans	58138	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|257777071\|gb\|CP001720.1\|	485916	g14706	i0	100	0.0856269113149847	28	0	9	0	80	107	3879309	3879282	Desulfotomaculum acetoxidans DSM 771, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Peptococcaceae	Desulfofarcimen	Desulfofarcimen acetoxidans
12369283	12369283	PRJNA908278_P_NODE_13770_length_337_cov_1.087121_g13667_i0	PRJNA908278	13770	337	1.087121	3.66359777	Ruminiclostridium papyrosolvens	29362	Bacteria	Bacteria	58.4	6.84e-4	NTclustered	gi\|2463005755\|gb\|CP119677.1\|	588581	g13667	i0	100	0.246290801186944	31	0	9	0	120	150	385504	385534	Ruminiclostridium papyrosolvens DSM 2782 chromosome, complete genome	blastn	83	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium papyrosolvens
12369336	12369336	PRJNA908278_P_NODE_18250_length_299_cov_1.252212_g18147_i0	PRJNA908278	18250	299	1.252212	3.74411388	Weissella paramesenteroides	1249	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1937010051\|gb\|CP065046.1\|	1249	g18147	i0	96.97	0.662207357859532	33	1	11	0	143	175	1155674	1155706	Weissella paramesenteroides strain STCH-BD1 chromosome	blastn	198	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella paramesenteroides
12369429	12369429	PRJNA908278_P_NODE_27030_length_251_cov_0.865169_g26927_i0	PRJNA908278	27030	251	0.865169	2.17157419	Paenibacillus sp. PK3_47	2072642	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2242625908\|gb\|CP026029.1\|	2072642	g26927	i0	89.13	0.466135458167331	46	4	28	1	148	192	838834	838879	Paenibacillus sp. PK3_47 chromosome, complete genome	blastn	117	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. PK3_47
12728526	12728526	PRJNA908278_P_NODE_22490_length_273_cov_2.350000_g22387_i0	PRJNA908278	22490	273	2.35	6.4155	Bacillus	1386	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2130655155\|gb\|CP083130.1\|	1428	g22387	i0	100	1.53846153846154	28	0	10	0	39	66	322282	322309	Bacillus thuringiensis strain NB-176 plasmid pCH_187-a	blastn	420	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
12728531	12728531	PRJNA908278_P_NODE_26050_length_252_cov_2.251397_g25947_i0	PRJNA908278	26050	252	2.251397	5.67352044	Bacteria	2	Bacteria	Bacteria	272	1.6099999999999999e-68	NTclustered	gi\|268320350\|gb\|GU137317.1\|	1264	g25947	i0	98.077	119.928571428571	156	3	62	0	97	252	474	319	Ruminococcus albus strain Ra8 16S-23S ribosomal RNA intergenic spacer, complete sequence	blastn	30222	272	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus albus
14918378	14918378	PRJNA908278_P_NODE_34312_length_242_cov_0.911243_g34209_i0	PRJNA908278	34312	242	0.911243	2.20520806	Alkaliphilus sp. B6464	2731219	Bacteria	Bacteria	58.4	4.69e-4	NTclustered	gi\|2029995422\|gb\|CP058557.1\|	2731219	g34209	i0	97.059	0.140495867768595	34	1	14	0	10	43	2800124	2800091	Alkaliphilus sp. B6464 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Natronincolaceae	Alkaliphilus	Alkaliphilus sp. B6464
16193008	16193008	PRJNA908278_P_NODE_16333_length_314_cov_0.979253_g16230_i0	PRJNA908278	16333	314	0.979253	3.07485442	Pseudobutyrivibrio xylanivorans	185007	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1760103922\|gb\|CP043028.1\|	185007	g16230	i0	100	0.089171974522293	28	0	9	0	53	80	1350722	1350695	Pseudobutyrivibrio xylanivorans strain MA3014 chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Pseudobutyrivibrio	Pseudobutyrivibrio xylanivorans
16551550	16551550	PRJNA908278_P_NODE_26773_length_251_cov_0.865169_g26670_i0	PRJNA908278	26773	251	0.865169	2.17157419	Clostridium	1485	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1947636228\|gb\|CP065874.1\|	1502	g26670	i0	100	0.669322709163347	28	0	11	0	200	227	3079583	3079556	Clostridium perfringens strain FDAARGOS_932 chromosome	blastn	168	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
16551558	16551558	PRJNA908278_P_NODE_29753_length_247_cov_1.660920_g29650_i0	PRJNA908278	29753	247	1.66092	4.1024724	Halobacillus	45667	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2562798784\|gb\|CP129016.1\|	45668	g29650	i0	100	0.360323886639676	30	0	12	0	14	43	1845631	1845602	Halobacillus litoralis strain SaN21-8 chromosome, complete genome	blastn	89	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Halobacillus	Halobacillus litoralis
20016714	20016714	PRJNA908278_P_NODE_11696_length_359_cov_2.706294_g11593_i0	PRJNA908278	11696	359	2.706294	9.71559546	Planococcus glaciei	459472	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|1717448307\|gb\|CP041323.1\|	459472	g11593	i0	100	0.155988857938719	28	0	8	0	178	205	3259334	3259361	Planococcus glaciei strain 46093 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus glaciei
20016835	20016835	PRJNA908278_P_NODE_23196_length_269_cov_1.571429_g23093_i0	PRJNA908278	23196	269	1.571429	4.22714401	Tepidibacter hydrothermalis	3036126	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2473864021\|gb\|CP120733.1\|	3036126	g23093	i0	92.308	0.144981412639405	39	1	14	2	224	260	4087071	4087033	Tepidibacter hydrothermalis strain SWIR-1 chromosome, complete genome	blastn	39	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Tepidibacter	Tepidibacter hydrothermalis
21292299	21292299	PRJNA908278_P_NODE_33577_length_243_cov_0.905882_g33474_i0	PRJNA908278	33577	243	0.905882	2.20129326	Tissierella sp. MB52-C2	3070999	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2571136226\|gb\|CP133261.1\|	3070999	g33474	i0	92.105	0.156378600823045	38	2	15	1	161	197	3501928	3501891	Tissierella sp. MB52-C2 chromosome, complete genome	blastn	38	52.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Tissierellaceae	Tissierella	Tissierella sp. MB52-C2
22567497	22567497	PRJNA908278_P_NODE_35898_length_233_cov_2.531250_g35795_i0	PRJNA908278	35898	233	2.53125	5.8978125	Anaerobacillus sp. HL2	2831971	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2276850642\|gb\|CP074438.1\|	2831971	g35795	i0	100	0.120171673819742	28	0	12	0	14	41	1167242	1167215	Anaerobacillus sp. HL2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Anaerobacillus	Anaerobacillus sp. HL2
23842356	23842356	PRJNA908278_P_NODE_11339_length_364_cov_1.563574_g11236_i0	PRJNA908278	11339	364	1.563574	5.69140936	Lentilactobacillus laojiaonis	2883998	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2124225826\|gb\|CP085278.1\|	2883998	g11236	i0	100	0.0769230769230769	28	0	8	0	197	224	752613	752586	Lentilactobacillus laojiaonis strain IM3328 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lentilactobacillus	Lentilactobacillus laojiaonis
23842504	23842504	PRJNA908278_P_NODE_26199_length_251_cov_3.157303_g26096_i0	PRJNA908278	26199	251	3.157303	7.92483053	Clostridium septicum	1504	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2260370548\|gb\|CP099799.1\|	1504	g26096	i0	100	0.557768924302789	28	0	11	0	4	31	137578	137551	Clostridium septicum strain RMA 8861 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium septicum
25116502	25116502	PRJNA908278_P_NODE_8280_length_414_cov_2.422287_g8177_i0	PRJNA908278	8280	414	2.422287	10.02826818	Lysinibacillus sp. JK80	2749809	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2419076438\|gb\|CP058997.1\|	2749809	g8177	i0	100	0.0676328502415459	28	0	7	0	356	383	201558	201585	Lysinibacillus sp. JK80 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. JK80
25475640	25475640	PRJNA908278_P_NODE_14900_length_326_cov_1.217391_g14797_i0	PRJNA908278	14900	326	1.217391	3.96869466	Lysinibacillus	400634	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2723713145\|gb\|CP152047.1\|	2921411	g14797	i0	100	0.171779141104294	28	0	9	0	198	225	1742230	1742257	Lysinibacillus sp. FSL K6-0057 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sp. FSL K6-0057

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