metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA473641" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA473641" 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
1095448	1095448	PRJNA473641_P_NODE_15181_length_266_cov_1.512953_g15098_i0	PRJNA473641	15181	266	1.512953	4.02445498	Staphylococcus	1279	Bacteria	Bacteria	449	7.38e-122	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g15098	i0	99.593	426.398496240602	246	1	92	0	1	246	708415	708170	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	113422	449	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
2370896	2370896	PRJNA473641_P_NODE_19122_length_249_cov_0.875000_g19039_i0	PRJNA473641	19122	249	0.875	2.17875	Pediococcus	1253	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2906344067\|gb\|CP180278.1\|	1255	g19039	i0	99.598	98.6144578313253	249	1	100	0	1	249	655519	655767	Pediococcus pentosaceus strain K6 chromosome, complete genome	blastn	24555	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
2995881	2995881	PRJNA473641_P_NODE_543_length_990_cov_2.637950_g486_i0	PRJNA473641	543	990	2.63795	26.115705	Bacillus thuringiensis	1428	Bacteria	Bacteria	1829	0	NTclustered	gi\|1008814182\|gb\|CP014284.1\|	1428	g486	i0	100	28.2343434343434	990	0	100	0	1	990	42455	43444	Bacillus thuringiensis strain Bt185 plasmid pBT1850294, complete sequence	blastn	27952	1829	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
3646625	3646625	PRJNA473641_P_NODE_7843_length_344_cov_1.162362_g7760_i0	PRJNA473641	7843	344	1.162362	3.99852528	Streptococcus	1301	Bacteria	Bacteria	630	3.289999999999999e-176	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g7760	i0	99.709	313.375	344	1	100	0	1	344	17690	17347	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	107801	630	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
4923619	4923619	PRJNA473641_P_NODE_18604_length_249_cov_1.630682_g18521_i0	PRJNA473641	18604	249	1.630682	4.06039818	Bacillus	1386	Bacteria	Bacteria	459	1.1399999999999998e-124	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g18521	i0	100	99.5983935742972	248	0	99	0	1	248	4917266	4917019	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	24800	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
6198622	6198622	PRJNA473641_P_NODE_5785_length_383_cov_4.606452_g5702_i0	PRJNA473641	5785	383	4.606452	17.64271116	Pediococcus	1253	Bacteria	Bacteria	708	0	NTclustered	gi\|2522199379\|gb\|CP127868.1\|	1255	g5702	i0	100	100.921671018277	383	0	100	0	1	383	935698	936080	Pediococcus pentosaceus strain SMFM2016-YK1 chromosome, complete genome	blastn	38653	708	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
7473446	7473446	PRJNA473641_P_NODE_12586_length_289_cov_1.425926_g12503_i0	PRJNA473641	12586	289	1.425926	4.12092614	Pediococcus	1253	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|2906344067\|gb\|CP180278.1\|	1255	g12503	i0	100	93.083044982699	289	0	100	0	1	289	872545	872257	Pediococcus pentosaceus strain K6 chromosome, complete genome	blastn	26901	534	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
8098140	8098140	PRJNA473641_P_NODE_22007_length_245_cov_1.430233_g21924_i0	PRJNA473641	22007	245	1.430233	3.50407085	Anoxybacteroides amylolyticum	294699	Bacteria	Bacteria	422	1.46e-113	NTclustered	gi\|1024277742\|gb\|CP015438.1\|	294699	g21924	i0	97.571	861.14693877551	247	4	100	1	1	245	2162	2408	Anoxybacteroides amylolyticum strain DSM 15939 chromosome, complete genome	blastn	210981	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides amylolyticum
8748435	8748435	PRJNA473641_P_NODE_17667_length_251_cov_0.865169_g17584_i0	PRJNA473641	17667	251	0.865169	2.17157419	Bacillus	1386	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2905561765\|gb\|CP180234.1\|	1396	g17584	i0	99.602	46.7768924302789	251	1	100	0	1	251	1320105	1319855	Bacillus cereus strain Ba 4 chromosome, complete genome	blastn	11741	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
8748448	8748448	PRJNA473641_P_NODE_3307_length_478_cov_1.975309_g3224_i0	PRJNA473641	3307	478	1.975309	9.44197702	Bacillus	1386	Bacteria	Bacteria	883	0	NTclustered	gi\|2905561765\|gb\|CP180234.1\|	1396	g3224	i0	100	170.483263598326	478	0	100	0	1	478	1374945	1374468	Bacillus cereus strain Ba 4 chromosome, complete genome	blastn	81491	883	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
10023772	10023772	PRJNA473641_P_NODE_7928_length_342_cov_15.576208_g7845_i0	PRJNA473641	7928	342	15.576208	53.27063136	Bacillus	1386	Bacteria	Bacteria	632	9.079999999999999e-177	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g7845	i0	100	100	342	0	100	0	1	342	4834214	4834555	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	34200	632	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
11298712	11298712	PRJNA473641_P_NODE_8989_length_328_cov_1.207843_g8906_i0	PRJNA473641	8989	328	1.207843	3.96172504	root	1	Root_unresolved	Root_unresolved	595	1.1399999999999998e-165	NTclustered	gi\|2094528054\|gb\|CP065379.1\|	853	g8906	i0	99.39	109.716463414634	328	2	100	0	1	328	1224896	1225223	Faecalibacterium prausnitzii strain Fp40 chromosome, complete genome	blastn	35987	595	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
12574427	12574427	PRJNA473641_P_NODE_14130_length_275_cov_2.287129_g14047_i0	PRJNA473641	14130	275	2.287129	6.28960475	Bacillus	1386	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g14047	i0	100	99.1381818181818	272	0	99	0	4	275	1701655	1701384	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	27263	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
16398079	16398079	PRJNA473641_P_NODE_23133_length_244_cov_0.900585_g23050_i0	PRJNA473641	23133	244	0.900585	2.1974274	Bacillus	1386	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2905561765\|gb\|CP180234.1\|	1396	g23050	i0	100	100.622950819672	244	0	100	0	1	244	815165	814922	Bacillus cereus strain Ba 4 chromosome, complete genome	blastn	24552	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
17673078	17673078	PRJNA473641_P_NODE_10954_length_305_cov_10.245690_g10871_i0	PRJNA473641	10954	305	10.24569	31.2493545	Bacillus	1386	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g10871	i0	100	100	305	0	100	0	1	305	2256929	2257233	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	30500	564	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
18946942	18946942	PRJNA473641_P_NODE_14355_length_273_cov_3.060000_g14272_i0	PRJNA473641	14355	273	3.06	8.3538	Bacillus	1386	Bacteria	Bacteria	505	1.6e-138	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g14272	i0	100	100	273	0	100	0	1	273	2070405	2070133	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	27300	505	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
19570955	19570955	PRJNA473641_P_NODE_4836_length_411_cov_3.236686_g4753_i0	PRJNA473641	4836	411	3.236686	13.30277946	Bulleidia sp. 10714-15	3241172	Bacteria	Bacteria	69.4	3.92e-7	NTclustered	gi\|2793725965\|dbj\|AP036017.1\|	3241172	g4753	i0	81.818	3.37226277372263	88	11	21	5	91	175	140367	140452	Bulleidia sp. 10714-15 DNA, complete genome	blastn	1386	69.4	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Bulleidia	Bulleidia sp. 10714-15
19570958	19570958	PRJNA473641_P_NODE_496_length_1023_cov_2.798947_g440_i0	PRJNA473641	496	1023	2.798947	28.63322781	Bacillus thuringiensis	1428	Bacteria	Bacteria	1890	0	NTclustered	gi\|1008814182\|gb\|CP014284.1\|	1428	g440	i0	100	52.4623655913978	1023	0	100	0	1	1023	2240	3262	Bacillus thuringiensis strain Bt185 plasmid pBT1850294, complete sequence	blastn	53669	1890	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
20846410	20846410	PRJNA473641_P_NODE_1257_length_710_cov_1.632653_g1179_i0	PRJNA473641	1257	710	1.632653	11.5918363	Bacillus thuringiensis	1428	Bacteria	Bacteria	1312	0	NTclustered	gi\|1008814182\|gb\|CP014284.1\|	1428	g1179	i0	100	19.3380281690141	710	0	100	0	1	710	44245	43536	Bacillus thuringiensis strain Bt185 plasmid pBT1850294, complete sequence	blastn	13730	1312	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
20846689	20846689	PRJNA473641_P_NODE_22617_length_245_cov_0.895349_g22534_i0	PRJNA473641	22617	245	0.895349	2.19360505	Kineothrix sp. MB12-C1	3070215	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2567103984\|gb\|CP132957.1\|	3070215	g22534	i0	96.774	0.126530612244898	31	1	13	0	185	215	958993	959023	Kineothrix sp. MB12-C1 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Kineothrix	Kineothrix sp. MB12-C1
21497296	21497296	PRJNA473641_P_NODE_1037_length_773_cov_1.455714_g967_i0	PRJNA473641	1037	773	1.455714	11.25266922	Bacillus	1386	Bacteria	Bacteria	1428	0	NTclustered	gi\|2311313809\|gb\|CP106675.1\|	1396	g967	i0	100	100.288486416559	773	0	100	0	1	773	1508469	1509241	Bacillus cereus strain SRCM116293 chromosome, complete genome	blastn	77523	1428	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
21497301	21497301	PRJNA473641_P_NODE_14317_length_274_cov_1.169154_g14234_i0	PRJNA473641	14317	274	1.169154	3.20348196	Bacillus	1386	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g14234	i0	100	100	274	0	100	0	1	274	4917553	4917280	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	27400	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
21497306	21497306	PRJNA473641_P_NODE_20017_length_248_cov_0.880000_g19934_i0	PRJNA473641	20017	248	0.88	2.1824	Bacillus	1386	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2212750716\|gb\|CP063975.1\|	1396	g19934	i0	100	100	248	0	100	0	1	248	5060953	5060706	Bacillus cereus strain N435-1 chromosome, complete genome	blastn	24800	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
22772463	22772463	PRJNA473641_P_NODE_10738_length_308_cov_0.982979_g10655_i0	PRJNA473641	10738	308	0.982979	3.02757532	Metabacillus	2675233	Bacteria	Bacteria	536	6.51e-148	NTclustered	gi\|1891105402\|gb\|CP055263.1\|	2745198	g10655	i0	98.052	937.233766233766	308	6	100	0	1	308	616855	616548	Metabacillus sp. KUDC1714 chromosome, complete genome	blastn	288668	536	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus elymi
22772493	22772493	PRJNA473641_P_NODE_5178_length_401_cov_0.939024_g5095_i0	PRJNA473641	5178	401	0.939024	3.76548624	Pediococcus	1253	Bacteria	Bacteria	732	0	NTclustered	gi\|2697105090\|gb\|CP146862.1\|	1255	g5095	i0	99.749	90.3416458852868	399	1	99	0	3	401	645231	644833	Pediococcus pentosaceus strain XY62 chromosome, complete genome	blastn	36227	732	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
23397427	23397427	PRJNA473641_P_NODE_459_length_1060_cov_2.459980_g405_i0	PRJNA473641	459	1060	2.45998	26.075788	Bacillus thuringiensis	1428	Bacteria	Bacteria	1947	0	NTclustered	gi\|1008814182\|gb\|CP014284.1\|	1428	g405	i0	99.811	23.6009433962264	1060	2	100	0	1	1060	45527	44468	Bacillus thuringiensis strain Bt185 plasmid pBT1850294, complete sequence	blastn	25017	1947	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
24047422	24047422	PRJNA473641_P_NODE_23599_length_244_cov_0.888889_g23516_i0	PRJNA473641	23599	244	0.888889	2.16888916	Staphylococcus	1279	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g23516	i0	100	99.2008196721311	244	0	100	0	1	244	828295	828052	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	24205	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
24047438	24047438	PRJNA473641_P_NODE_9899_length_317_cov_1.028689_g9816_i0	PRJNA473641	9899	317	1.028689	3.26094413	Pediococcus	1253	Bacteria	Bacteria	580	3.0599999999999993e-161	NTclustered	gi\|1035434175\|gb\|CP015918.1\|	1255	g9816	i0	99.685	99.782334384858	317	1	100	0	1	317	1386013	1386329	Pediococcus pentosaceus strain wikim20, complete genome	blastn	31631	580	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus

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