metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA949785" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA949785" 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	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
933143	933143	PRJNA949785_P_NODE_15601_length_251_cov_0.865169_g15404_i0	PRJNA949785	15601	251	0.865169	2.17157419	Liquorilactobacillus hordei	468911	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1318759364\|gb\|CP018176.1\|	468911	g15404	i0	100	0.111553784860558	28	0	11	184	211	892941	892914	Liquorilactobacillus hordei strain TMW 1.1822 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Liquorilactobacillus	Liquorilactobacillus hordei
933175	933175	PRJNA949785_P_NODE_17941_length_244_cov_0.900585_g17744_i0	PRJNA949785	17941	244	0.900585	2.1974274	Staphylococcus epidermidis	1282	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g17744	i0	99.18	100	244	2	100	1	244	1116108	1115865	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	24400	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2208461	2208461	PRJNA949785_P_NODE_16602_length_248_cov_0.880000_g16405_i0	PRJNA949785	16602	248	0.88	2.1824	Candidatus Syntrophocurvum alkaliphilum	2293317	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1782150439\|gb\|CP046457.1\|	2293317	g16405	i0	100	0.116935483870968	29	0	12	89	117	1433565	1433593	Candidatus Syntrophocurvum alkaliphilum isolate B(2M) chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae	Candidatus Syntrophocurvum	Candidatus Syntrophocurvum alkaliphilum
2208484	2208484	PRJNA949785_P_NODE_18322_length_243_cov_0.905882_g18125_i0	PRJNA949785	18322	243	0.905882	2.20129326	Granulicatella elegans	137732	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g18125	i0	97.942	1	243	5	100	1	243	517512	517270	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	243	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
2208488	2208488	PRJNA949785_P_NODE_18522_length_242_cov_0.911243_g18325_i0	PRJNA949785	18522	242	0.911243	2.20520806	Streptococcus sanguinis	1305	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1854466684\|gb\|CP054570.1\|	1305	g18325	i0	99.587	9	242	1	100	1	242	320134	320375	Streptococcus sanguinis strain FDAARGOS_770 chromosome, complete genome	blastn	2178	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
2537705	2537705	PRJNA949785_P_NODE_18742_length_242_cov_0.911243_g18545_i0	PRJNA949785	18742	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	448	2.3799999999999995e-121	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g18545	i0	100	100	242	0	100	1	242	1763599	1763358	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24200	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2537724	2537724	PRJNA949785_P_NODE_7562_length_391_cov_1.937107_g7365_i0	PRJNA949785	7562	391	1.937107	7.57408837	Staphylococcus	1279	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g7365	i0	100	1.21739130434783	28	0	7	178	205	1493689	1493716	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	476	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
3483788	3483788	PRJNA949785_P_NODE_15243_length_253_cov_2.138889_g15046_i0	PRJNA949785	15243	253	2.138889	5.41138917	Loigolactobacillus backii	375175	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1036644015\|gb\|CP014623.1\|	375175	g15046	i0	100	0.553359683794466	28	0	11	47	74	1024573	1024600	Loigolactobacillus backii strain TMW 1.1988, complete sequence.	blastn	140	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Loigolactobacillus	Loigolactobacillus backii
3483792	3483792	PRJNA949785_P_NODE_15523_length_251_cov_0.865169_g15326_i0	PRJNA949785	15523	251	0.865169	2.17157419	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2536850969\|gb\|CP129362.1\|	1283	g15326	i0	100	81.7768924302789	251	0	100	1	251	2011505	2011755	Staphylococcus haemolyticus strain CCSH-121 chromosome, complete genome	blastn	20526	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
3483793	3483793	PRJNA949785_P_NODE_15643_length_251_cov_0.865169_g15446_i0	PRJNA949785	15643	251	0.865169	2.17157419	Lactococcus lactis	1358	Bacteria	Bacteria	248	2.7e-61	NTclustered	gi\|2269476428\|gb\|CP092749.1\|	1358	g15446	i0	99.27	16.4302788844622	137	1	55	115	251	12007	11871	Lactococcus lactis strain 17M1 plasmid p1, complete sequence	blastn	4124	248	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
3814043	3814043	PRJNA949785_P_NODE_15883_length_250_cov_0.870056_g15686_i0	PRJNA949785	15883	250	0.870056	2.17514	Staphylococcaceae	90964	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1243896256\|gb\|CP017156.1\|	1898474	g15686	i0	100	9.716	250	0	100	1	250	2070701	2070950	Macrococcus sp. IME1552 chromosome, complete genome	blastn	2429	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Macrococcus	Macrococcus sp. IME1552
4761559	4761559	PRJNA949785_P_NODE_12984_length_281_cov_1.480769_g12787_i0	PRJNA949785	12984	281	1.480769	4.16096089	Streptococcus sp. NPS 308	1902136	Bacteria	Bacteria	462	1.01e-125	NTclustered	gi\|1080114141\|dbj\|AP017652.1\|	1902136	g12787	i0	96.429	21.3594306049822	280	10	99	2	281	1458846	1458567	Streptococcus sp. NPS 308 DNA, complete genome	blastn	6002	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. NPS 308
8586141	8586141	PRJNA949785_P_NODE_15807_length_250_cov_0.870056_g15610_i0	PRJNA949785	15807	250	0.870056	2.17514	Staphylococcus hominis	1290	Bacteria	Bacteria	438	1.4899999999999995e-118	NTclustered	gi\|1854288993\|gb\|CP054550.1\|	1290	g15610	i0	98.394	25.944	249	4	99	2	250	643211	643459	Staphylococcus hominis strain FDAARGOS_661 chromosome, complete genome	blastn	6486	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
8914759	8914759	PRJNA949785_P_NODE_17647_length_245_cov_0.895349_g17450_i0	PRJNA949785	17647	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|831183028\|gb\|CP007601.1\|	72758	g17450	i0	99.592	42	245	1	100	1	245	1572684	1572928	Staphylococcus capitis subsp. capitis strain AYP1020, complete genome	blastn	10290	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
10190696	10190696	PRJNA949785_P_NODE_13368_length_276_cov_1.517241_g13171_i0	PRJNA949785	13368	276	1.517241	4.18758516	Staphylococcus	1279	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g13171	i0	100	102.420289855072	276	0	100	1	276	1854742	1855017	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	28268	510	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
10190773	10190773	PRJNA949785_P_NODE_9908_length_330_cov_1.852140_g9711_i0	PRJNA949785	9908	330	1.85214	6.112062	Staphylococcus	1279	Bacteria	Bacteria	610	4.09e-170	NTclustered	gi\|403220077\|emb\|HE800585.1\|	1282	g9711	i0	100	114	330	0	100	1	330	19	348	Staphylococcus epidermidis partial 16S rRNA gene, isolate AH008	blastn	37620	610	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11136796	11136796	PRJNA949785_P_NODE_16609_length_248_cov_0.880000_g16412_i0	PRJNA949785	16609	248	0.88	2.1824	Staphylococcus epidermidis	1282	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g16412	i0	100	99.991935483871	248	0	100	1	248	918883	918636	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	24798	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
11136801	11136801	PRJNA949785_P_NODE_16989_length_247_cov_0.885057_g16792_i0	PRJNA949785	16989	247	0.885057	2.18609079	Staphylococcus massiliensis	555791	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2831308571\|gb\|CP171119.1\|	555791	g16792	i0	100	1	247	0	100	1	247	1969835	1970081	Staphylococcus massiliensis strain WGS1515 chromosome, complete genome	blastn	247	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus massiliensis
11136824	11136824	PRJNA949785_P_NODE_19089_length_241_cov_0.916667_g18892_i0	PRJNA949785	19089	241	0.916667	2.20916747	Aerococcus viridans	1377	Bacteria	Bacteria	379	8.759999999999998e-101	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g18892	i0	95.021	7.63900414937759	241	12	100	1	241	2057746	2057986	Aerococcus viridans strain CCUG4311, complete genome	blastn	1841	379	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
11465761	11465761	PRJNA949785_P_NODE_13369_length_276_cov_1.517241_g13172_i0	PRJNA949785	13369	276	1.517241	4.18758516	Streptococcus	1301	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1438634269\|gb\|CP031248.1\|	1313	g13172	i0	100	100	276	0	100	1	276	1261263	1260988	Streptococcus pneumoniae strain M26365 chromosome, complete genome	blastn	27600	510	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
12412274	12412274	PRJNA949785_P_NODE_15990_length_250_cov_0.870056_g15793_i0	PRJNA949785	15990	250	0.870056	2.17514	Veillonella dispar	39778	Bacteria	Bacteria	412	9.02e-111	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g15793	i0	96.4	13	250	9	100	1	250	1728830	1729079	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	3250	412	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
14015836	14015836	PRJNA949785_P_NODE_15951_length_250_cov_0.870056_g15754_i0	PRJNA949785	15951	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	462	8.83e-126	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g15754	i0	100	103	250	0	100	1	250	1572976	1572727	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	25750	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
14960997	14960997	PRJNA949785_P_NODE_16132_length_249_cov_0.875000_g15935_i0	PRJNA949785	16132	249	0.875	2.17875	Anaerococcus prevotii	33034	Bacteria	Bacteria	418	1.9299999999999995e-112	NTclustered	gi\|256797400\|gb\|CP001708.1\|	525919	g15935	i0	97.166	0.991967871485944	247	7	99	1	247	583736	583982	Anaerococcus prevotii DSM 20548, complete genome	blastn	247	418	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
14961065	14961065	PRJNA949785_P_NODE_7172_length_403_cov_3.387879_g6975_i0	PRJNA949785	7172	403	3.387879	13.65315237	Aerococcus sp. Group 1	2976812	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|326650014\|gb\|CP002512.1\|	2976812	g6975	i0	100	0.0719602977667494	29	0	7	71	99	893051	893023	Aerococcus urinae ACS-120-V-Col10a, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus sp. Group 1
16236003	16236003	PRJNA949785_P_NODE_17253_length_246_cov_0.890173_g17056_i0	PRJNA949785	17253	246	0.890173	2.18982558	Peptoniphilus genitalis	3036303	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|2246887130\|gb\|CP097885.1\|	3036303	g17056	i0	98.374	3.92682926829268	246	4	100	1	246	570126	570371	Peptoniphilus genitalis strain SAHP1 chromosome, complete genome	blastn	966	433	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus genitalis
18784946	18784946	PRJNA949785_P_NODE_18255_length_243_cov_0.905882_g18058_i0	PRJNA949785	18255	243	0.905882	2.20129326	Streptococcus toyakuensis	2819619	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2231684047\|dbj\|AP024523.1\|	2819619	g18058	i0	96.708	100	243	8	100	1	243	986161	985919	Streptococcus toyakuensis TP1632 DNA, complete genome	blastn	24300	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus toyakuensis
20059880	20059880	PRJNA949785_P_NODE_18376_length_243_cov_0.905882_g18179_i0	PRJNA949785	18376	243	0.905882	2.20129326	Blautia wexlerae	418240	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|2250075743\|gb\|CP098409.1\|	418240	g18179	i0	97.942	4	243	5	100	1	243	1683650	1683892	Blautia wexlerae strain NB2B-9-FAA chromosome	blastn	972	422	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia wexlerae
20388296	20388296	PRJNA949785_P_NODE_14196_length_266_cov_1.487047_g13999_i0	PRJNA949785	14196	266	1.487047	3.95554502	root	1	Root_unresolved	Root_unresolved	492	1.2099999999999999e-134	NTclustered	gi\|285185122\|gb\|GU420995.1\|	28037	g13999	i0	100	100	266	0	100	1	266	335	70	Streptococcus mitis clone ATC_A6_11 16S ribosomal RNA gene, partial sequence	blastn	26600	492	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
21335243	21335243	PRJNA949785_P_NODE_14417_length_263_cov_1.621053_g14220_i0	PRJNA949785	14417	263	1.621053	4.26336939	Paenibacillus konkukensis	2020716	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2242672127\|gb\|CP027059.1\|	2020716	g14220	i0	100	0.106463878326996	28	0	11	41	68	7883133	7883106	Paenibacillus konkukensis strain SK3146 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus konkukensis
22939778	22939778	PRJNA949785_P_NODE_17078_length_246_cov_1.341040_g16881_i0	PRJNA949785	17078	246	1.34104	3.2989584	Staphylococcus	1279	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g16881	i0	100	466.861788617886	246	0	100	1	246	707311	707066	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	114848	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
23885573	23885573	PRJNA949785_P_NODE_16799_length_247_cov_0.885057_g16602_i0	PRJNA949785	16799	247	0.885057	2.18609079	Agathobacter rectalis	39491	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|2777750333\|dbj\|AP031452.1\|	39491	g16602	i0	98.785	7	247	3	100	1	247	696895	696649	Agathobacter rectalis k41-0107-C12 DNA, complete genome	blastn	1729	440	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
24213687	24213687	PRJNA949785_P_NODE_8679_length_357_cov_1.894366_g8482_i0	PRJNA949785	8679	357	1.894366	6.76288662	Streptococcus	1301	Bacteria	Bacteria	621	2.05e-173	NTclustered	gi\|1948603152\|gb\|CP066021.1\|	1303	g8482	i0	98.039	495.058823529412	357	7	100	1	357	673578	673222	Streptococcus oralis strain FDAARGOS_1020 chromosome, complete genome	blastn	176736	621	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
25159319	25159319	PRJNA949785_P_NODE_16200_length_249_cov_0.875000_g16003_i0	PRJNA949785	16200	249	0.875	2.17875	Streptococcus mitis	28037	Bacteria	Bacteria	411	3.2299999999999996e-110	NTclustered	gi\|2886503043\|emb\|OZ217341.1\|	28037	g16003	i0	96.386	100	249	9	100	1	249	360735	360983	Streptococcus mitis isolate S. mitis C22 genome assembly, chromosome: 1	blastn	24900	411	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis

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