metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1174234" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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
1040936	1040936	PRJNA1174234_P_NODE_20881_length_302_cov_1.344978_g20685_i0	PRJNA1174234	20881	302	1.344978	4.06183356	Streptococcus	1301	Bacteria	Bacteria	553	6.32e-153	NTclustered	gi\|2886512733\|emb\|OZ217346.1\|	28037	g20685	i0	99.669	344.135761589404	302	1	100	0	1	302	18884	19185	Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1	blastn	103929	553	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
1040950	1040950	PRJNA1174234_P_NODE_35781_length_241_cov_0.916667_g35585_i0	PRJNA1174234	35781	241	0.916667	2.20916747	Staphylococcus	1279	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g35585	i0	99.585	23.1701244813278	241	1	100	0	1	241	474901	474661	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	5584	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
1590767	1590767	PRJNA1174234_P_NODE_24382_length_279_cov_1.082524_g24186_i0	PRJNA1174234	24382	279	1.082524	3.02024196	Limosilactobacillus fermentum	1613	Bacteria	Bacteria	60.2	1.54e-4	NTclustered	gi\|1135565308\|dbj\|AP017973.1\|	1613	g24186	i0	100	0.114695340501792	32	0	11	0	53	84	1518540	1518571	Lactobacillus fermentum DNA, complete genome, strain: MTCC 25067	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus fermentum
3591403	3591403	PRJNA1174234_P_NODE_28603_length_253_cov_1.711111_g28407_i0	PRJNA1174234	28603	253	1.711111	4.32911083	Bacillus	1386	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2766254272\|gb\|CP160000.1\|	324767	g28407	i0	100	0.221343873517787	28	0	11	0	86	113	2594208	2594181	Bacillus infantis strain AR001 chromosome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus infantis
4143021	4143021	PRJNA1174234_P_NODE_22684_length_289_cov_2.439815_g22488_i0	PRJNA1174234	22684	289	2.439815	7.05106535	Tepidibacter hydrothermalis	3036126	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2473864021\|gb\|CP120733.1\|	3036126	g22488	i0	100	0.103806228373702	30	0	10	0	34	63	1211094	1211123	Tepidibacter hydrothermalis strain SWIR-1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Tepidibacter	Tepidibacter hydrothermalis
4869000	4869000	PRJNA1174234_P_NODE_29164_length_251_cov_0.865169_g28968_i0	PRJNA1174234	29164	251	0.865169	2.17157419	Lactobacillus	1578	Bacteria	Bacteria	462	8.869999999999999e-126	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g28968	i0	100	630.366533864542	250	0	99	0	2	251	142143	142392	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	158222	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
6694097	6694097	PRJNA1174234_P_NODE_33726_length_244_cov_0.900585_g33530_i0	PRJNA1174234	33726	244	0.900585	2.1974274	Clostridium estertheticum	238834	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2557236457\|gb\|CP077610.1\|	238834	g33530	i0	94.286	0.14344262295082	35	2	14	0	157	191	1368486	1368520	Clostridium estertheticum strain CF005 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium estertheticum
7969351	7969351	PRJNA1174234_P_NODE_17987_length_325_cov_1.134921_g17791_i0	PRJNA1174234	17987	325	1.134921	3.68849325	Ornithinibacillus sp. FSL M8-0202	2921616	Bacteria	Bacteria	562	1.14e-155	NTclustered	gi\|2709838836\|gb\|CP150248.1\|	2921616	g17791	i0	97.846	844.083076923077	325	7	100	0	1	325	3255331	3255655	Ornithinibacillus sp. FSL M8-0202 chromosome, complete genome	blastn	274327	562	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ornithinibacillus	Ornithinibacillus sp. FSL M8-0202
8693892	8693892	PRJNA1174234_P_NODE_14547_length_361_cov_1.437500_g14351_i0	PRJNA1174234	14547	361	1.4375	5.189375	Lactobacillus	1578	Bacteria	Bacteria	656	0	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g14351	i0	99.446	414.97783933518	361	2	100	0	1	361	90700	90340	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	149807	656	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
9244099	9244099	PRJNA1174234_P_NODE_32348_length_246_cov_0.890173_g32152_i0	PRJNA1174234	32348	246	0.890173	2.18982558	Streptococcus sp. Marseille-Q6470	2972784	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2306632708\|emb\|OX336385.1\|	2972784	g32152	i0	94.118	0.138211382113821	34	2	14	0	207	240	1390940	1390973	Streptococcus sp. Marseille-Q6470 genome assembly, chromosome: contig00001	blastn	34	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q6470
9969045	9969045	PRJNA1174234_P_NODE_27428_length_260_cov_1.262032_g27232_i0	PRJNA1174234	27428	260	1.262032	3.2812832	Finegoldia	150022	Bacteria	Bacteria	459	1.19e-124	NTclustered	gi\|2127667581\|gb\|CP085957.1\|	1260	g27232	i0	98.833	372.769230769231	257	3	99	0	1	257	162200	161944	Finegoldia magna strain FDAARGOS_1556 chromosome, complete genome	blastn	96920	459	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
9969053	9969053	PRJNA1174234_P_NODE_30348_length_249_cov_0.875000_g30152_i0	PRJNA1174234	30348	249	0.875	2.17875	Clostridium	1485	Bacteria	Bacteria	451	1.9e-122	NTclustered	gi\|2425298477\|gb\|CP114763.1\|	1492	g30152	i0	99.203	1011.18473895582	251	0	100	1	1	249	11877	12127	Clostridium butyricum strain LV1 chromosome 1, complete sequence	blastn	251785	451	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium butyricum
9969057	9969057	PRJNA1174234_P_NODE_31688_length_247_cov_0.885057_g31492_i0	PRJNA1174234	31688	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g31492	i0	100	42	247	0	100	0	1	247	556018	556264	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	10374	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
12519606	12519606	PRJNA1174234_P_NODE_23950_length_281_cov_1.677885_g23754_i0	PRJNA1174234	23950	281	1.677885	4.71485685	root	1	Root_unresolved	Root_unresolved	516	7.64e-142	NTclustered	gi\|1129645506\|gb\|KU922148.1\|	1282	g23754	i0	100	147.939501779359	279	0	99	0	1	279	1095	1373	Staphylococcus epidermidis strain M44 16S ribosomal RNA gene, partial sequence	blastn	41571	516	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12519611	12519611	PRJNA1174234_P_NODE_27190_length_261_cov_2.122340_g26994_i0	PRJNA1174234	27190	261	2.12234	5.5393074	Staphylococcus	1279	Bacteria	Bacteria	477	3.3099999999999986e-130	NTclustered	gi\|1928723242\|gb\|CP042341.1\|	29388	g26994	i0	99.617	102	261	1	100	0	1	261	2337549	2337809	Staphylococcus capitis strain BN2 chromosome, complete genome	blastn	26622	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
13069619	13069619	PRJNA1174234_P_NODE_11731_length_402_cov_2.106383_g11535_i0	PRJNA1174234	11731	402	2.106383	8.46765966	Ezakiella coagulans	46507	Bacteria	Bacteria	743	0	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g11535	i0	100	415.601990049751	402	0	100	0	1	402	159890	160291	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	167072	743	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
14345063	14345063	PRJNA1174234_P_NODE_19632_length_311_cov_1.920168_g19436_i0	PRJNA1174234	19632	311	1.920168	5.97172248	Ezakiella coagulans	46507	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g19436	i0	100	651.816720257235	311	0	100	0	1	311	160507	160817	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	202715	575	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
15068614	15068614	PRJNA1174234_P_NODE_11632_length_404_cov_1.634441_g11436_i0	PRJNA1174234	11632	404	1.634441	6.60314164	Lactobacillus	1578	Bacteria	Bacteria	686	0	NTclustered	gi\|2769791464\|gb\|CP160084.1\|	109790	g11436	i0	97.277	429.950495049505	404	11	100	0	1	404	957147	956744	Lactobacillus jensenii strain 188_F1_4 chromosome, complete genome	blastn	173700	686	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus jensenii
15068622	15068622	PRJNA1174234_P_NODE_20692_length_304_cov_0.896104_g20496_i0	PRJNA1174234	20692	304	0.896104	2.72415616	Dialister	39948	Bacteria	Bacteria	390	5.289999999999999e-104	NTclustered	gi\|1493601541\|gb\|MH883587.1\|	278064	g20496	i0	90.785	158.286184210526	293	26	96	1	12	304	1190	899	Uncultured Dialister sp. clone PMB_contig_12 genomic sequence	blastn	48119	390	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Dialister	uncultured Dialister sp.
15068636	15068636	PRJNA1174234_P_NODE_32112_length_246_cov_1.254335_g31916_i0	PRJNA1174234	32112	246	1.254335	3.0856641	Finegoldia	150022	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g31916	i0	99.593	490.483739837398	246	1	100	0	1	246	874235	874480	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	120659	449	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
16343483	16343483	PRJNA1174234_P_NODE_23713_length_283_cov_1.100000_g23517_i0	PRJNA1174234	23713	283	1.1	3.113	Staphylococcus	1279	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g23517	i0	100	100	283	0	100	0	1	283	734847	734565	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	28300	523	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
16893113	16893113	PRJNA1174234_P_NODE_10054_length_435_cov_1.256906_g9858_i0	PRJNA1174234	10054	435	1.256906	5.4675411	Finegoldia magna	1260	Bacteria	Bacteria	782	0	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g9858	i0	99.08	319.363218390805	435	4	100	0	1	435	375812	376246	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	138923	782	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
17618735	17618735	PRJNA1174234_P_NODE_23434_length_285_cov_0.877358_g23238_i0	PRJNA1174234	23434	285	0.877358	2.5004703	Lysinibacillus	400634	Bacteria	Bacteria	189	1.9199999999999993e-43	NTclustered	gi\|2623570137\|gb\|CP137622.1\|	2115968	g23238	i0	81.624	80.0385964912281	234	37	81	6	31	261	119527	119757	Lysinibacillus capsici strain Lm01 chromosome, complete genome	blastn	22811	189	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus capsici
18892451	18892451	PRJNA1174234_P_NODE_11595_length_405_cov_1.237952_g11399_i0	PRJNA1174234	11595	405	1.237952	5.0137056	Exiguobacterium	33986	Bacteria	Bacteria	743	0	NTclustered	gi\|1735050952\|gb\|CP030931.1\|	41170	g11399	i0	99.753	724.987654320988	405	1	100	0	1	405	150111	149707	Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome	blastn	293620	743	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium acetylicum
18892473	18892473	PRJNA1174234_P_NODE_32035_length_246_cov_1.491329_g31839_i0	PRJNA1174234	32035	246	1.491329	3.66866934	Lactobacillus	1578	Bacteria	Bacteria	436	5.25e-118	NTclustered	gi\|2913177562\|gb\|CP180627.1\|	47770	g31839	i0	98.776	419.955284552846	245	3	99	0	1	245	1143536	1143292	Lactobacillus crispatus strain T31e chromosome, complete genome	blastn	103309	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
20167245	20167245	PRJNA1174234_P_NODE_14896_length_357_cov_1.355634_g14700_i0	PRJNA1174234	14896	357	1.355634	4.83961338	Lactobacillus	1578	Bacteria	Bacteria	660	0	NTclustered	gi\|1517399434\|gb\|CP033426.1\|	47770	g14700	i0	100	399.851540616246	357	0	100	0	1	357	308532	308888	Lactobacillus crispatus strain CO3MRSI1 chromosome, complete genome	blastn	142747	660	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
20167264	20167264	PRJNA1174234_P_NODE_26276_length_267_cov_1.577320_g26080_i0	PRJNA1174234	26276	267	1.57732	4.2114444	Lactobacillus	1578	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g26080	i0	100	426.423220973783	267	0	100	0	1	267	90993	90727	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	113855	494	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
21992726	21992726	PRJNA1174234_P_NODE_23218_length_286_cov_1.192488_g23022_i0	PRJNA1174234	23218	286	1.192488	3.41051568	Ornithinibacillus sp. FSL M8-0202	2921616	Bacteria	Bacteria	507	4.69e-139	NTclustered	gi\|2709838836\|gb\|CP150248.1\|	2921616	g23022	i0	98.601	1016.81818181818	286	4	100	0	1	286	1019639	1019924	Ornithinibacillus sp. FSL M8-0202 chromosome, complete genome	blastn	290810	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Ornithinibacillus	Ornithinibacillus sp. FSL M8-0202
21992854	21992854	PRJNA1174234_P_NODE_9618_length_445_cov_1.040323_g9422_i0	PRJNA1174234	9618	445	1.040323	4.62943735	Enterococcus faecalis	1351	Bacteria	Bacteria	62.1	7.16e-5	NTclustered	gi\|2859726696\|gb\|CP173761.1\|	1351	g9422	i0	100	0.148314606741573	33	0	7	0	261	293	2526961	2526929	Enterococcus faecalis strain CM4 chromosome, complete genome	blastn	66	62.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
23993103	23993103	PRJNA1174234_P_NODE_15059_length_355_cov_1.563830_g14863_i0	PRJNA1174234	15059	355	1.56383	5.5515965	Streptococcus	1301	Bacteria	Bacteria	651	0	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g14863	i0	99.718	543.459154929577	355	1	100	0	1	355	162978	163332	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	192928	651	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
24542117	24542117	PRJNA1174234_P_NODE_29860_length_250_cov_0.870056_g29664_i0	PRJNA1174234	29860	250	0.870056	2.17514	Streptococcus oralis	1303	Bacteria	Bacteria	405	1.51e-108	NTclustered	gi\|2886501130\|emb\|OZ217340.1\|	1303	g29664	i0	95.984	35.16	249	10	99	0	1	249	310107	310355	Streptococcus oralis isolate S. oralis A22 genome assembly, chromosome: 1	blastn	8790	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis

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