metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1074408" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1074408" 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
4017524	4017524	PRJNA1074408_S_NODE_3724_length_239_cov_1.709184_g3594_i0	PRJNA1074408	3724	239	1.709184	4.08494976	Weissella soli	155866	Bacteria	Bacteria	420	5.11e-113	NTclustered	gi\|1721182056\|gb\|CP042377.1\|	155866	g3594	i0	98.326	541.129707112971	239	4	100	0	1	239	61161	61399	Weissella soli strain CBA3633 chromosome	blastn	129330	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella soli
4017536	4017536	PRJNA1074408_S_NODE_6144_length_187_cov_2.965278_g6014_i0	PRJNA1074408	6144	187	2.965278	5.54506986	Staphylococcus epidermidis	1282	Bacteria	Bacteria	309	8.6e-80	NTclustered	gi\|2866787960\|gb\|CP064471.1\|	1282	g6014	i0	99.412	482.850267379679	170	1	91	0	18	187	2324683	2324514	Staphylococcus epidermidis strain UMCG387 chromosome, complete genome	blastn	90293	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4017537	4017537	PRJNA1074408_S_NODE_6324_length_185_cov_1.204225_g6194_i0	PRJNA1074408	6324	185	1.204225	2.22781625	Peptoniphilus lacrimalis	33031	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|2812796007\|gb\|CP165621.1\|	33031	g6194	i0	100	260.324324324324	185	0	100	0	1	185	325648	325464	Peptoniphilus lacrimalis strain F0141 isolate D048 chromosome, complete genome	blastn	48160	342	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus lacrimalis
4844602	4844602	PRJNA1074408_S_NODE_5464_length_198_cov_1.741935_g5334_i0	PRJNA1074408	5464	198	1.741935	3.4490313	Bacillati	1783272	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g5334	i0	100	505.722222222222	198	0	100	0	1	198	748930	748733	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	100133	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6119702	6119702	PRJNA1074408_S_NODE_7125_length_175_cov_2.015152_g6995_i0	PRJNA1074408	7125	175	2.015152	3.526516	root	1	Root_unresolved	Root_unresolved	324	2.83e-84	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g6995	i0	100	94.8685714285714	175	0	100	0	1	175	2753578	2753752	Staphylococcus aureus strain WH3018 chromosome	blastn	16602	324	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
7394268	7394268	PRJNA1074408_S_NODE_8286_length_163_cov_3.600000_g8156_i0	PRJNA1074408	8286	163	3.6	5.868	Staphylococcus	1279	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|2482395019\|gb\|CP094927.1\|	1280	g8156	i0	99.387	547.938650306749	163	1	100	0	1	163	969638	969476	Staphylococcus aureus strain 13 chromosome, complete genome	blastn	89314	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8669731	8669731	PRJNA1074408_S_NODE_3507_length_246_cov_1.980296_g3377_i0	PRJNA1074408	3507	246	1.980296	4.87152816	Bacillus	1386	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1783154386\|gb\|CP040336.1\|	2026191	g3377	i0	100	1125.0081300813	246	0	100	0	1	246	4388532	4388287	Bacillus luti strain FJ chromosome, complete genome	blastn	276752	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus luti
9118622	9118622	PRJNA1074408_S_NODE_5488_length_198_cov_1.141935_g5358_i0	PRJNA1074408	5488	198	1.141935	2.2610313	Bacillus sp. 3G2	3375707	Bacteria	Bacteria	361	2.51e-95	NTclustered	gi\|2844132743\|gb\|CP172246.1\|	3375707	g5358	i0	99.495	101.484848484848	198	1	100	0	1	198	3849585	3849782	Bacillus sp. 3G2 chromosome, complete genome	blastn	20094	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. 3G2
9944700	9944700	PRJNA1074408_S_NODE_8388_length_162_cov_3.403361_g8258_i0	PRJNA1074408	8388	162	3.403361	5.51344482	root	1	Root_unresolved	Root_unresolved	300	4.36e-77	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g8258	i0	100	97.0555555555556	162	0	100	0	1	162	2682524	2682363	Staphylococcus aureus strain WH3018 chromosome	blastn	15723	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
9944702	9944702	PRJNA1074408_S_NODE_8668_length_160_cov_1.478632_g8538_i0	PRJNA1074408	8668	160	1.478632	2.3658112	Clostridia	186801	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|662031610\|emb\|LK932435.1\|	1496	g8538	i0	100	242.25625	160	0	100	0	1	160	2140	1981	Peptoclostridium difficile genome assembly 7032994, scaffold BN1097_Contig_93	blastn	38761	296	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
10394290	10394290	PRJNA1074408_S_NODE_9009_length_157_cov_1.263158_g8879_i0	PRJNA1074408	9009	157	1.263158	1.98315806	Paraclostridium sordellii	1505	Bacteria	Bacteria	63.9	5.98e-6	NTclustered	gi\|731157630\|emb\|LN681234.1\|	1505	g8879	i0	100	10.2738853503185	34	0	22	0	23	56	1531733	1531700	[Clostridium] sordellii genome assembly JGS6382, chromosome : 1	blastn	1613	63.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium sordellii
11219997	11219997	PRJNA1074408_S_NODE_8909_length_158_cov_0.852174_g8779_i0	PRJNA1074408	8909	158	0.852174	1.34643492	Streptococcus	1301	Bacteria	Bacteria	248	1.55e-61	NTclustered	gi\|2179901676\|gb\|CP046524.1\|	1303	g8779	i0	94.937	303.759493670886	158	8	100	0	1	158	18420	18263	Streptococcus oralis strain SOT chromosome, complete genome	blastn	47994	248	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
12495327	12495327	PRJNA1074408_S_NODE_2470_length_291_cov_2.983871_g2340_i0	PRJNA1074408	2470	291	2.983871	8.68306461	Staphylococcus	1279	Bacteria	Bacteria	532	7.9e-147	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g2340	i0	99.656	108.996563573883	291	1	100	0	1	291	334	44	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	31718	532	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12944730	12944730	PRJNA1074408_S_NODE_6411_length_184_cov_1.021277_g6281_i0	PRJNA1074408	6411	184	1.021277	1.87914968	Bacillus sp. 3G2	3375707	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|2844132743\|gb\|CP172246.1\|	3375707	g6281	i0	100	98.9021739130435	184	0	100	0	1	184	4922141	4922324	Bacillus sp. 3G2 chromosome, complete genome	blastn	18198	340	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. 3G2
13769850	13769850	PRJNA1074408_S_NODE_6911_length_178_cov_1.066667_g6781_i0	PRJNA1074408	6911	178	1.066667	1.89866726	Candidatus Neoarthromitus	49082	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|342329141\|dbj\|AP012202.1\|	1029718	g6781	i0	99.438	3	178	1	100	0	1	178	1224869	1224692	Candidatus Arthromitus sp. SFB-mouse-Japan DNA, complete genome	blastn	534	324	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Candidatus Neoarthromitus	Candidatus Arthromitus sp. SFB-mouse
15044179	15044179	PRJNA1074408_S_NODE_6172_length_187_cov_1.437500_g6042_i0	PRJNA1074408	6172	187	1.4375	2.688125	Paenibacillus	44249	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2230200769\|gb\|CP073714.1\|	1472	g6042	i0	100	1173.6256684492	187	0	100	0	1	187	89631	89445	Paenibacillus pabuli strain E1 chromosome, complete genome	blastn	219468	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus pabuli
15044189	15044189	PRJNA1074408_S_NODE_8472_length_162_cov_1.092437_g8342_i0	PRJNA1074408	8472	162	1.092437	1.76974794	Staphylococcus	1279	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g8342	i0	99.383	100	162	1	100	0	1	162	1139031	1138870	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	16200	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
16319038	16319038	PRJNA1074408_S_NODE_2773_length_276_cov_1.394850_g2643_i0	PRJNA1074408	2773	276	1.39485	3.849786	Aerococcus	1375	Bacteria	Bacteria	466	7.65e-127	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g2643	i0	97.445	551.108695652174	274	5	99	2	4	276	18843	18571	Aerococcus viridans strain CCUG4311, complete genome	blastn	152106	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
16767940	16767940	PRJNA1074408_S_NODE_5934_length_190_cov_11.707483_g5804_i0	PRJNA1074408	5934	190	11.707483	22.2442177	Caloranaerobacter azorensis	116090	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1810187734\|gb\|CP048617.1\|	116090	g5804	i0	100	0.152631578947368	29	0	15	0	92	120	1707613	1707585	Caloranaerobacter azorensis strain T3-1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Thermohalobacteraceae	Caloranaerobacter	Caloranaerobacter azorensis
16767955	16767955	PRJNA1074408_S_NODE_8214_length_164_cov_1.586777_g8084_i0	PRJNA1074408	8214	164	1.586777	2.60231428	Bacillus sp. 3G2	3375707	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2844132743\|gb\|CP172246.1\|	3375707	g8084	i0	100	100.560975609756	164	0	100	0	1	164	1982515	1982678	Bacillus sp. 3G2 chromosome, complete genome	blastn	16492	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. 3G2
18042715	18042715	PRJNA1074408_S_NODE_2415_length_295_cov_1.178571_g2285_i0	PRJNA1074408	2415	295	1.178571	3.47678445	Lactococcus petauri	1940789	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2257541798\|gb\|CP086595.1\|	1940789	g2285	i0	100	0.0983050847457627	29	0	10	0	130	158	794780	794808	Lactococcus petauri strain LG26 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus petauri
20142913	20142913	PRJNA1074408_S_NODE_3476_length_247_cov_3.730392_g3346_i0	PRJNA1074408	3476	247	3.730392	9.21406824	Finegoldia	150022	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g3346	i0	100	371.016194331984	247	0	100	0	1	247	873664	873418	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	91641	457	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
21418581	21418581	PRJNA1074408_S_NODE_4357_length_222_cov_1.608939_g4227_i0	PRJNA1074408	4357	222	1.608939	3.57184458	Staphylococcus	1279	Bacteria	Bacteria	411	2.8199999999999996e-110	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g4227	i0	100	100	222	0	100	0	1	222	1138883	1138662	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	22200	411	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
24416915	24416915	PRJNA1074408_S_NODE_4320_length_223_cov_1.822222_g4190_i0	PRJNA1074408	4320	223	1.822222	4.06355506	Lachnospiraceae bacterium oral taxon 096	712982	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|2030188580\|gb\|CP073340.1\|	712982	g4190	i0	100	443.735426008969	223	0	100	0	1	223	162156	162378	Lachnospiraceae bacterium oral taxon 096 strain F0428 chromosome	blastn	98953	412	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium oral taxon 096

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