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

31 rows where analysis = "blastn", bioproject = "PRJNA485080" 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
449419	449419	PRJNA485080_P_NODE_41641_length_242_cov_0.911243_g41547_i0	PRJNA485080	41641	242	0.911243	2.20520806	Streptococcus anginosus	1328	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|1987912294\|gb\|CP069892.1\|	1328	g41547	i0	99.153	16.9214876033058	236	2	98	0	1	236	1632126	1631891	Streptococcus anginosus strain FDAARGOS_1357 chromosome, complete genome	blastn	4095	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus anginosus
1723820	1723820	PRJNA485080_P_NODE_25222_length_250_cov_0.870056_g25128_i0	PRJNA485080	25222	250	0.870056	2.17514	Solobacterium moorei	102148	Bacteria	Bacteria	427	3.22e-115	NTclustered	gi\|2589153872\|dbj\|AP028934.1\|	102148	g25128	i0	97.59	2.644	249	6	99	0	1	249	484617	484369	Solobacterium moorei JCM 10645 DNA, complete genome	blastn	661	427	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Solobacterium	Solobacterium moorei
1724122	1724122	PRJNA485080_P_NODE_8562_length_352_cov_1.379928_g8468_i0	PRJNA485080	8562	352	1.379928	4.85734656	Nosocomiicoccus ampullae	489910	Bacteria	Bacteria	612	1.2199999999999996e-170	NTclustered	gi\|2073000562\|gb\|CP079109.1\|	489910	g8468	i0	98.011	416.485795454545	352	7	100	0	1	352	208585	208936	Nosocomiicoccus ampullae strain 19-00310 chromosome, complete genome	blastn	146603	612	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Nosocomiicoccus	Nosocomiicoccus ampullae
2999946	2999946	PRJNA485080_P_NODE_30103_length_247_cov_0.885057_g30009_i0	PRJNA485080	30103	247	0.885057	2.18609079	Pseudoflavonifractor gallinarum	2779352	Bacteria	Bacteria	248	2.65e-61	NTclustered	gi\|2777655128\|dbj\|AP031438.1\|	2779352	g30009	i0	84.959	14.8704453441296	246	35	99	2	1	245	3203088	3203332	Pseudoflavonifractor gallinarum i42-0019-1B4 DNA, complete genome	blastn	3673	248	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pseudoflavonifractor	Pseudoflavonifractor gallinarum
4276259	4276259	PRJNA485080_P_NODE_30344_length_247_cov_0.885057_g30250_i0	PRJNA485080	30344	247	0.885057	2.18609079	Jeotgalicoccus sp. ATCC 8456	946435	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1949519824\|gb\|CP066224.1\|	946435	g30250	i0	100	1060.5951417004	247	0	100	0	1	247	13871	13625	Jeotgalicoccus sp. ATCC 8456 chromosome, complete genome	blastn	261967	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. ATCC 8456
4276358	4276358	PRJNA485080_P_NODE_37024_length_244_cov_0.900585_g36930_i0	PRJNA485080	37024	244	0.900585	2.1974274	uncultured Faecalibacterium sp.	259315	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|2729058713\|emb\|OZ007013.1\|	259315	g36930	i0	87.705	48.9467213114754	244	30	100	0	1	244	2346118	2346361	MAG: uncultured Faecalibacterium sp. isolate 6755_HET_CTRL_contig_16021_metaflye_large MAG genome assembly, chromosome: 1	blastn	11943	285	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	uncultured Faecalibacterium sp.
4276509	4276509	PRJNA485080_P_NODE_8564_length_352_cov_1.304659_g8470_i0	PRJNA485080	8564	352	1.304659	4.59239968	Nosocomiicoccus ampullae	489910	Bacteria	Bacteria	597	3.41e-166	NTclustered	gi\|2072998956\|gb\|CP079110.1\|	489910	g8470	i0	97.436	88.9005681818182	351	7	100	1	4	352	1487427	1487077	Nosocomiicoccus ampullae strain DSM 19163 chromosome, complete genome	blastn	31293	597	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Nosocomiicoccus	Nosocomiicoccus ampullae
6826959	6826959	PRJNA485080_P_NODE_43606_length_241_cov_0.916667_g43512_i0	PRJNA485080	43606	241	0.916667	2.20916747	Staphylococcus saccharolyticus	33028	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1948644436\|gb\|CP066042.1\|	33028	g43512	i0	99.585	28.0082987551867	241	1	100	0	1	241	40514	40754	Staphylococcus saccharolyticus strain FDAARGOS_1074 chromosome, complete genome	blastn	6750	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus saccharolyticus
6827008	6827008	PRJNA485080_P_NODE_8166_length_358_cov_1.021053_g8072_i0	PRJNA485080	8166	358	1.021053	3.65536974	uncultured Blautia sp.	765821	Bacteria	Bacteria	651	0	NTclustered	gi\|1997760553\|emb\|LR994469.1\|	765821	g8072	i0	99.441	473.262569832402	358	2	100	0	1	358	726406	726763	uncultured Blautia sp. isolate Blautia sp. canine HQ MAG genome assembly, chromosome: 1	blastn	169428	651	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	uncultured Blautia sp.
8750353	8750353	PRJNA485080_P_NODE_24987_length_250_cov_0.870056_g24893_i0	PRJNA485080	24987	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g24893	i0	99.6	26	250	1	100	0	1	250	1582692	1582941	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	6500	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
9376728	9376728	PRJNA485080_P_NODE_11628_length_320_cov_0.935223_g11534_i0	PRJNA485080	11628	320	0.935223	2.9927136	Jeotgalicoccus sp. ATCC 8456	946435	Bacteria	Bacteria	575	1.44e-159	NTclustered	gi\|1949519824\|gb\|CP066224.1\|	946435	g11534	i0	100	462.13125	311	0	97	0	1	311	15502	15812	Jeotgalicoccus sp. ATCC 8456 chromosome, complete genome	blastn	147882	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. ATCC 8456
10652679	10652679	PRJNA485080_P_NODE_14449_length_297_cov_1.031250_g14355_i0	PRJNA485080	14449	297	1.03125	3.0628125	Sporomusa aerivorans	204936	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2790708428\|gb\|CP156926.1\|	204936	g14355	i0	100	0.0942760942760943	28	0	9	0	160	187	1376800	1376773	Sporomusa aerivorans strain DSM 13326 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa aerivorans
11927904	11927904	PRJNA485080_P_NODE_3350_length_507_cov_1.082949_g3256_i0	PRJNA485080	3350	507	1.082949	5.49055143	Lactococcus formosensis	1281486	Bacteria	Bacteria	52.8	0.05	NTclustered	gi\|2718649204\|gb\|CP146743.1\|	2906461	g3256	i0	96.875	0.0631163708086785	32	0	6	1	340	371	1056618	1056588	Lactococcus formosensis subsp. formosensis strain L5 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus formosensis
11928001	11928001	PRJNA485080_P_NODE_39930_length_242_cov_1.822485_g39836_i0	PRJNA485080	39930	242	1.822485	4.4104137	Staphylococcus hominis	1290	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2211476211\|gb\|CP093539.1\|	1290	g39836	i0	100	26	242	0	100	0	1	242	133816	134057	Staphylococcus hominis strain C5 chromosome, complete genome	blastn	6292	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
12576366	12576366	PRJNA485080_P_NODE_12070_length_316_cov_1.267490_g11976_i0	PRJNA485080	12070	316	1.26749	4.0052684	Streptococcus	1301	Bacteria	Bacteria	579	1.0999999999999999e-160	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g11976	i0	99.684	381.006329113924	316	1	100	0	1	316	424324	424009	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	120398	584	0.991438356164384	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
13202630	13202630	PRJNA485080_P_NODE_16791_length_281_cov_1.014423_g16697_i0	PRJNA485080	16791	281	1.014423	2.85052863	Lactobacillus crispatus	47770	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2741280599\|gb\|CP157745.1\|	47770	g16697	i0	100	0.103202846975089	29	0	10	0	121	149	1036582	1036610	Lactobacillus crispatus strain BC1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
13202797	13202797	PRJNA485080_P_NODE_29851_length_247_cov_0.885057_g29757_i0	PRJNA485080	29851	247	0.885057	2.18609079	Paraclostridium bifermentans	1490	Bacteria	Bacteria	383	6.97e-102	NTclustered	gi\|2091226359\|gb\|CP079737.1\|	1490	g29757	i0	95.062	98.2307692307692	243	12	98	0	5	247	86552	86310	Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome	blastn	24263	383	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
14477656	14477656	PRJNA485080_P_NODE_22452_length_251_cov_0.865169_g22358_i0	PRJNA485080	22452	251	0.865169	2.17157419	Selenomonas sp. oral taxon 126	712528	Bacteria	Bacteria	387	5.489999999999998e-103	NTclustered	gi\|1043179811\|gb\|CP016201.1\|	712528	g22358	i0	94.422	8.43426294820717	251	14	100	0	1	251	2770144	2770394	Selenomonas sp. oral taxon 126 strain W7667 chromosome, partial genome	blastn	2117	387	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp. oral taxon 126
14477862	14477862	PRJNA485080_P_NODE_37232_length_244_cov_0.900585_g37138_i0	PRJNA485080	37232	244	0.900585	2.1974274	Staphylococcus hominis	1290	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1373834430\|emb\|LT963438.1\|	1290	g37138	i0	98.77	96.1475409836066	244	3	100	0	1	244	498415	498172	Staphylococcus hominis isolate Staphylococcus hominis J11 genome assembly, chromosome: I	blastn	23460	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
14477984	14477984	PRJNA485080_P_NODE_652_length_974_cov_2.186459_g594_i0	PRJNA485080	652	974	2.186459	21.29611066	Paraclostridium sordellii	1505	Bacteria	Bacteria	261	1.51e-64	NTclustered	gi\|2695199495\|gb\|CP124274.1\|	1505	g594	i0	87.665	4.68993839835729	227	25	23	3	615	838	3300778	3301004	Paraclostridium sordellii strain C173 chromosome, complete genome	blastn	4568	261	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium sordellii
16399942	16399942	PRJNA485080_P_NODE_17393_length_277_cov_0.887255_g17299_i0	PRJNA485080	17393	277	0.887255	2.45769635	Streptococcus	1301	Bacteria	Bacteria	462	9.929999999999999e-126	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g17299	i0	97.761	544.880866425993	268	6	100	0	10	277	161971	161704	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	150932	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
16399943	16399943	PRJNA485080_P_NODE_19573_length_263_cov_0.810526_g19479_i0	PRJNA485080	19573	263	0.810526	2.13168338	Veillonella	29465	Bacteria	Bacteria	470	5.59e-128	NTclustered	gi\|2021399589\|dbj\|AP022322.1\|	2682455	g19479	i0	100	549.688212927757	254	0	97	0	10	263	1509281	1509534	Veillonella sp. S12025-13 DNA, complete genome	blastn	144568	470	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella orientalis
17675048	17675048	PRJNA485080_P_NODE_5594_length_407_cov_1.347305_g5500_i0	PRJNA485080	5594	407	1.347305	5.48353135	Streptococcus	1301	Bacteria	Bacteria	728	0	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g5500	i0	99.015	541.628992628993	406	4	99	0	1	406	162530	162935	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	220443	728	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
18948877	18948877	PRJNA485080_P_NODE_11235_length_323_cov_1.756000_g11141_i0	PRJNA485080	11235	323	1.756	5.67188	Streptococcus	1301	Bacteria	Bacteria	597	3.11e-166	NTclustered	gi\|2890261556\|gb\|CP177179.1\|	1304	g11141	i0	100	570.015479876161	323	0	100	0	1	323	19149	18827	Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome	blastn	184115	597	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
20223738	20223738	PRJNA485080_P_NODE_12676_length_311_cov_1.226891_g12582_i0	PRJNA485080	12676	311	1.226891	3.81563101	root	1	Root_unresolved	Root_unresolved	569	6.489999999999998e-158	NTclustered	gi\|511633707\|gb\|KF011975.1\|	1282	g12582	i0	99.678	305.173633440514	311	1	100	0	1	311	326	16	Staphylococcus epidermidis strain O1 16S ribosomal RNA gene, partial sequence	blastn	94909	569	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20850809	20850809	PRJNA485080_P_NODE_30337_length_247_cov_0.885057_g30243_i0	PRJNA485080	30337	247	0.885057	2.18609079	Staphylococcus hominis	1290	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1780389983\|gb\|CP046301.1\|	1290	g30243	i0	100	65.17004048583	247	0	100	0	1	247	1564921	1564675	Staphylococcus hominis strain FDAARGOS_747 chromosome, complete genome	blastn	16097	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
21499224	21499224	PRJNA485080_P_NODE_18237_length_271_cov_1.555556_g18143_i0	PRJNA485080	18237	271	1.555556	4.21555676	Bacilli	91061	Bacteria	Bacteria	468	2.08e-127	NTclustered	gi\|453201778\|gb\|JQ999686.1\|	165192	g18143	i0	97.786	581.335793357934	271	6	100	0	1	271	325	55	Uncultured Pediococcus sp. clone GKJWQY101AMK4B 23S ribosomal RNA gene, partial sequence	blastn	157542	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	uncultured Pediococcus sp.
21499241	21499241	PRJNA485080_P_NODE_33657_length_246_cov_0.890173_g33563_i0	PRJNA485080	33657	246	0.890173	2.18982558	Lactobacillus	1578	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g33563	i0	100	32	246	0	100	0	1	246	1628780	1629025	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	7872	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
21499256	21499256	PRJNA485080_P_NODE_38017_length_243_cov_1.352941_g37923_i0	PRJNA485080	38017	243	1.352941	3.28764663	Ligilactobacillus	2767887	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1072300941\|emb\|LT604074.1\|	1624	g37923	i0	100	2.74074074074074	29	0	12	0	171	199	420681	420709	Lactobacillus salivarius isolate LPM01 genome assembly, chromosome: I	blastn	666	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
23401244	23401244	PRJNA485080_P_NODE_15599_length_288_cov_1.827907_g15505_i0	PRJNA485080	15599	288	1.827907	5.26437216	Oscillospiraceae bacterium JHJ	2789326	Bacteria	Bacteria	152	2.55e-32	NTclustered	gi\|2221423809\|gb\|CP072107.1\|	2789326	g15505	i0	87.313	0.791666666666667	134	15	46	2	1	133	1202581	1202713	Oscillospiraceae bacterium CM chromosome, complete genome	blastn	228	152	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium JHJ
24675371	24675371	PRJNA485080_P_NODE_41740_length_242_cov_0.911243_g41646_i0	PRJNA485080	41740	242	0.911243	2.20520806	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	185	2.06e-42	NTclustered	gi\|2739155447\|gb\|CP157368.1\|	853	g41646	i0	80.913	22.5330578512397	241	40	98	5	1	238	521392	521155	Faecalibacterium prausnitzii strain 4 chromosome, complete genome	blastn	5453	185	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii

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