metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA610520" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA610520" and tax_kingdom = "Bacillati"

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
588390	588390	PRJNA610520_S_NODE_30841_length_320_cov_2.805668_g30751_i0	PRJNA610520	30841	320	2.805668	8.9781376	Jeotgalicoccus sp. WY2	2708346	Bacteria	Bacteria	470	6.989999999999998e-128	NTclustered	gi\|2043521547\|gb\|CP049818.1\|	2708346	g30751	i0	93.125	17.9875	320	22	100	0	1	320	971184	971503	Jeotgalicoccus sp. WY2 chromosome, complete genome	blastn	5756	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. WY2
588511	588511	PRJNA610520_S_NODE_56941_length_258_cov_2.837838_g56851_i0	PRJNA610520	56941	258	2.837838	7.32162204	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	451	1.98e-122	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g56851	i0	98.438	364.56976744186	256	4	99	0	1	256	552752	553007	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	94059	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
588575	588575	PRJNA610520_S_NODE_70521_length_234_cov_5.260870_g70431_i0	PRJNA610520	70521	234	5.26087	12.3104358	Staphylococcus cohnii	29382	Bacteria	Bacteria	433	6.41e-117	NTclustered	gi\|2624852950\|gb\|CP119997.1\|	29382	g70431	i0	100	8.01282051282051	234	0	100	0	1	234	1078531	1078764	Staphylococcus cohnii strain Dog166 chromosome, complete genome	blastn	1875	433	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
2422664	2422664	PRJNA610520_S_NODE_11042_length_410_cov_12.884273_g10952_i0	PRJNA610520	11042	410	12.884273	52.8255193	Cutibacterium	1912216	Bacteria	Bacteria	736	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10952	i0	100	258.034146341463	398	0	97	0	13	410	56605	56208	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	105794	736	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2422668	2422668	PRJNA610520_S_NODE_27942_length_329_cov_7.976562_g27852_i0	PRJNA610520	27942	329	7.976562	26.24288898	root	1	Root_unresolved	Root_unresolved	608	1.4599999999999995e-169	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g27852	i0	100	99.9331306990882	329	0	100	0	1	329	2463663	2463335	Staphylococcus aureus strain WH9628 chromosome	blastn	32878	608	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4415972	4415972	PRJNA610520_S_NODE_33184_length_313_cov_3.491667_g33094_i0	PRJNA610520	33184	313	3.491667	10.92891771	Megamonas funiformis	437897	Bacteria	Bacteria	433	8.95e-117	NTclustered	gi\|1810213142\|gb\|CP048627.1\|	437897	g33094	i0	91.693	1	313	24	99	2	1	312	149255	149566	Megamonas funiformis strain JCM 14723 chromosome, complete genome	blastn	313	433	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Megamonas	Megamonas funiformis
5692068	5692068	PRJNA610520_S_NODE_49645_length_273_cov_1.540000_g49555_i0	PRJNA610520	49645	273	1.54	4.2042	Mycobacterium sp. SMC-16	3385967	Bacteria	Bacteria	472	1.62e-128	NTclustered	gi\|2872563150\|gb\|CP176427.1\|	3385967	g49555	i0	97.802	26.7216117216117	273	6	100	0	1	273	3200715	3200443	Mycobacterium sp. SMC-16 chromosome, complete genome	blastn	7295	472	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. SMC-16
6966818	6966818	PRJNA610520_S_NODE_54906_length_262_cov_2.851852_g54816_i0	PRJNA610520	54906	262	2.851852	7.47185224	Staphylococcus cohnii	29382	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g54816	i0	100	100	262	0	100	0	1	262	541375	541636	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	26200	484	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
8241509	8241509	PRJNA610520_S_NODE_46167_length_280_cov_3.241546_g46077_i0	PRJNA610520	46167	280	3.241546	9.0763288	Anoxybacteroides amylolyticum	294699	Bacteria	Bacteria	226	1.4399999999999994e-54	NTclustered	gi\|1024277742\|gb\|CP015438.1\|	294699	g46077	i0	83.673	9.8	245	34	86	5	28	269	2288006	2288247	Anoxybacteroides amylolyticum strain DSM 15939 chromosome, complete genome	blastn	2744	226	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides amylolyticum
9516854	9516854	PRJNA610520_S_NODE_57908_length_256_cov_3.786885_g57818_i0	PRJNA610520	57908	256	3.786885	9.6944256	Megamonas funiformis	437897	Bacteria	Bacteria	468	1.95e-127	NTclustered	gi\|2075925919\|dbj\|AP024966.1\|	437897	g57818	i0	99.611	4.015625	257	0	100	1	1	256	1077458	1077202	Megamonas funiformis 1CBH44 DNA, complete genome	blastn	1028	468	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Megamonas	Megamonas funiformis
11350863	11350863	PRJNA610520_S_NODE_39849_length_295_cov_3.382883_g39759_i0	PRJNA610520	39849	295	3.382883	9.97950485	Mycetocola	76634	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1380445227\|gb\|CP026949.1\|	2079792	g39759	i0	100	192.010169491525	295	0	100	0	1	295	189404	189110	Mycetocola zhujimingii strain 449 = CGMCC 1.16372 chromosome, complete genome	blastn	56643	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Mycetocola	Mycetocola zhujimingii
11350864	11350864	PRJNA610520_S_NODE_59049_length_254_cov_2.701657_g58959_i0	PRJNA610520	59049	254	2.701657	6.86220878	Streptococcus	1301	Bacteria	Bacteria	431	2.539999999999999e-116	NTclustered	gi\|1441452222\|gb\|CP025838.1\|	1313	g58959	i0	97.244	105.968503937008	254	7	100	0	1	254	261133	261386	Streptococcus pneumoniae strain SPN XDR SMC1710-32 chromosome, complete genome	blastn	26916	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
12067827	12067827	PRJNA610520_S_NODE_43250_length_287_cov_1.822430_g43160_i0	PRJNA610520	43250	287	1.82243	5.2303741	Modestobacter italicus	2732864	Bacteria	Bacteria	470	6.18e-128	NTclustered	gi\|388483940\|emb\|FO203431.1\|	2732864	g43160	i0	96.491	360.989547038328	285	8	99	2	4	287	4339690	4339973	Modestobacter marinus str. BC501 chromosome, complete genome	blastn	103604	470	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter italicus
12067878	12067878	PRJNA610520_S_NODE_56970_length_258_cov_2.497297_g56880_i0	PRJNA610520	56970	258	2.497297	6.44302626	Staphylococcus cohnii	29382	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g56880	i0	100	100.321705426357	258	0	100	0	1	258	559115	559372	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	25883	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
12626438	12626438	PRJNA610520_S_NODE_51070_length_270_cov_1.563452_g50980_i0	PRJNA610520	51070	270	1.563452	4.2213204	Mediterraneibacter	2316020	Bacteria	Bacteria	398	2.759999999999999e-106	NTclustered	gi\|2813041504\|emb\|OZ186706.1\|	33038	g50980	i0	94.574	70.2333333333333	258	12	95	2	1	256	1414495	1414238	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD028 genome assembly, chromosome: 1	blastn	18963	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
12626445	12626445	PRJNA610520_S_NODE_69790_length_239_cov_2.307229_g69700_i0	PRJNA610520	69790	239	2.307229	5.51427731	Loigolactobacillus	2767889	Bacteria	Bacteria	438	1.4099999999999996e-118	NTclustered	gi\|1721207632\|gb\|CP042392.1\|	1610	g69700	i0	100	429.338912133891	237	0	99	0	3	239	277723	277959	Loigolactobacillus coryniformis strain CBA3616 chromosome, complete genome	blastn	102612	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Loigolactobacillus	Loigolactobacillus coryniformis
13342646	13342646	PRJNA610520_S_NODE_72471_length_203_cov_4.607692_g72381_i0	PRJNA610520	72471	203	4.607692	9.35361476	Jeotgalicoccus sp. WY2	2708346	Bacteria	Bacteria	320	4.39e-83	NTclustered	gi\|2043521547\|gb\|CP049818.1\|	2708346	g72381	i0	95.074	38.3300492610837	203	10	100	0	1	203	1177128	1176926	Jeotgalicoccus sp. WY2 chromosome, complete genome	blastn	7781	320	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp. WY2
13901386	13901386	PRJNA610520_S_NODE_12791_length_398_cov_2.261538_g12701_i0	PRJNA610520	12791	398	2.261538	9.00092124	Corynebacterium	1716	Bacteria	Bacteria	676	0	NTclustered	gi\|2869858840\|gb\|CP175793.1\|	3383589	g12701	i0	98.942	336.675879396985	378	4	95	0	21	398	724814	724437	Corynebacterium sp. YSMAA1_1_D6 chromosome, complete genome	blastn	133997	676	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_D6
14617348	14617348	PRJNA610520_S_NODE_30592_length_321_cov_2.173387_g30502_i0	PRJNA610520	30592	321	2.173387	6.97657227	Staphylococcus sp. S9	3135640	Bacteria	Bacteria	361	4.409999999999999e-95	NTclustered	gi\|2725928415\|gb\|CP150678.1\|	3135640	g30502	i0	86.957	26.7320872274143	322	40	100	2	1	321	1477798	1478118	Staphylococcus sp. S9 chromosome, complete genome	blastn	8581	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus sp. S9
15175729	15175729	PRJNA610520_S_NODE_39852_length_295_cov_3.243243_g39762_i0	PRJNA610520	39852	295	3.243243	9.56756685	Cutibacterium	1912216	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g39762	i0	100	263.545762711864	295	0	100	0	1	295	55825	55531	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	77746	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16450148	16450148	PRJNA610520_S_NODE_32253_length_316_cov_1.901235_g32163_i0	PRJNA610520	32253	316	1.901235	6.0079026	Mediterraneibacter	2316020	Bacteria	Bacteria	584	2.359999999999999e-162	NTclustered	gi\|2884834358\|gb\|CP176629.1\|	33038	g32163	i0	100	476.946202531646	316	0	100	0	1	316	806872	806557	Mediterraneibacter gnavus strain SFAD61 chromosome, complete genome	blastn	150715	584	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
17166219	17166219	PRJNA610520_S_NODE_35034_length_308_cov_2.625532_g34944_i0	PRJNA610520	35034	308	2.625532	8.08663856	Streptacidiphilus sp. PB12-B1b	2705012	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1886146638\|gb\|CP048405.1\|	2705012	g34944	i0	100	0.0941558441558442	29	0	9	0	256	284	2578194	2578222	Streptacidiphilus sp. PB12-B1b chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptacidiphilus	Streptacidiphilus sp. PB12-B1b
17166244	17166244	PRJNA610520_S_NODE_41814_length_290_cov_4.364055_g41724_i0	PRJNA610520	41814	290	4.364055	12.6557595	Streptococcus sp. SN-1	3074854	Bacteria	Bacteria	152	2.5699999999999997e-32	NTclustered	gi\|2747375947\|dbj\|AP028929.1\|	3074854	g41724	i0	96.703	0.644827586206897	91	3	64	0	200	290	290801	290711	Streptococcus sp. SN-1 DNA, complete genome	blastn	187	152	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. SN-1
17166392	17166392	PRJNA610520_S_NODE_9194_length_427_cov_2.610169_g9106_i0	PRJNA610520	9194	427	2.610169	11.14542163	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	58.4	8.85e-4	NTclustered	gi\|2318961074\|gb\|CP107211.1\|	2485925	g9106	i0	94.737	0.0889929742388759	38	1	9	1	212	248	88264	88227	MAG: Oscillospiraceae bacterium isolate KR001_HAM_0066 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
18998845	18998845	PRJNA610520_S_NODE_22155_length_350_cov_4.620939_g22065_i0	PRJNA610520	22155	350	4.620939	16.1732865	Streptomyces	1883	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2034371340\|gb\|CP074102.1\|	68239	g22065	i0	100	0.24	28	0	8	0	292	319	3071847	3071874	Streptomyces mirabilis strain P16B-1 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces mirabilis
21549292	21549292	PRJNA610520_S_NODE_65637_length_245_cov_1.686047_g65547_i0	PRJNA610520	65637	245	1.686047	4.13081515	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g65547	i0	100	100	245	0	100	0	1	245	1695554	1695798	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24500	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
22824765	22824765	PRJNA610520_S_NODE_57158_length_258_cov_1.502703_g57068_i0	PRJNA610520	57158	258	1.502703	3.87697374	Megamonas	158846	Bacteria	Bacteria	468	1.97e-127	NTclustered	gi\|2104390565\|gb\|CP084018.1\|	437897	g57068	i0	99.231	64.9806201550388	260	0	100	1	1	258	1241537	1241278	Megamonas funiformis strain NBRC 114415 chromosome, complete genome	blastn	16765	468	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Megamonas	Megamonas funiformis
23540972	23540972	PRJNA610520_S_NODE_64779_length_246_cov_1.930636_g64689_i0	PRJNA610520	64779	246	1.930636	4.74936456	Helcococcus ovis	72026	Bacteria	Bacteria	202	2.08e-47	NTclustered	gi\|2873000570\|gb\|CP121192.1\|	72026	g64689	i0	83.721	0.873983739837398	215	34	87	1	31	244	267627	267413	Helcococcus ovis strain KG38 chromosome, complete genome	blastn	215	202	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Helcococcus	Helcococcus ovis
25373718	25373718	PRJNA610520_S_NODE_42600_length_288_cov_6.148837_g42510_i0	PRJNA610520	42600	288	6.148837	17.70865056	Streptomyces	1883	Bacteria	Bacteria	108	5.61e-19	NTclustered	gi\|924539656\|gb\|CP011522.1\|	1649184	g42510	i0	81.618	6.70486111111111	136	19	46	6	78	210	1295435	1295567	Streptomyces sp. CFMR 7 strain CFMR-7, complete genome	blastn	1931	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CFMR 7

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