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

19 rows where analysis = "blastn", bioproject = "PRJNA610520" 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
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
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
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
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
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
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
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
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
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
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

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