metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1105232" 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
212542	212542	PRJNA1105232_S_NODE_10721_length_196_cov_1.414966_g10505_i0	PRJNA1105232	10721	196	1.414966	2.77333336	Hathewaya histolytica	1498	Bacteria	Bacteria	357	3.2099999999999996e-94	NTclustered	gi\|4760823\|dbj\|D87215.1\|	1498	g10505	i0	99.49	2.98979591836735	196	1	100	0	1	196	3011	2816	Clostridium histolyticum orfluG, colG, mscL, orf2dG, orf3dG genes, complete cds	blastn	586	357	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
2763293	2763293	PRJNA1105232_S_NODE_3863_length_293_cov_3.512295_g3647_i0	PRJNA1105232	3863	293	3.512295	10.29102435	Hathewaya histolytica	1498	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g3647	i0	100	817.21843003413	293	0	100	0	1	293	10760	11052	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	239445	542	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
3570939	3570939	PRJNA1105232_S_NODE_14523_length_172_cov_1.861789_g14307_i0	PRJNA1105232	14523	172	1.861789	3.20227708	root	1	Root_unresolved	Root_unresolved	313	5.989999999999998e-81	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g14307	i0	99.419	119.744186046512	172	1	100	0	1	172	571	400	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	20596	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
4848430	4848430	PRJNA1105232_S_NODE_6504_length_239_cov_1.842105_g6288_i0	PRJNA1105232	6504	239	1.842105	4.40263095	Streptococcus	1301	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g6288	i0	99.582	345.004184100418	239	1	100	0	1	239	424456	424218	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	82456	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
5315466	5315466	PRJNA1105232_S_NODE_17425_length_162_cov_0.858407_g17209_i0	PRJNA1105232	17425	162	0.858407	1.39061934	Staphylococcus epidermidis	1282	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2271285580\|gb\|CP090941.1\|	1282	g17209	i0	99.383	100	162	1	100	0	1	162	720331	720170	Staphylococcus epidermidis strain HAF242 chromosome, complete genome	blastn	16200	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6123449	6123449	PRJNA1105232_S_NODE_8325_length_217_cov_0.928571_g8109_i0	PRJNA1105232	8325	217	0.928571	2.01499907	Paenibacillus	44249	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|1373996327\|gb\|CP028366.1\|	59843	g8109	i0	100	6	217	0	100	0	1	217	2680339	2680555	Paenibacillus glucanolyticus strain W10507 chromosome	blastn	1302	401	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
6590701	6590701	PRJNA1105232_S_NODE_726_length_549_cov_2.780000_g518_i0	PRJNA1105232	726	549	2.78	15.2622	Hathewaya histolytica	1498	Bacteria	Bacteria	1014	0	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g518	i0	100	779.216757741348	549	0	100	0	1	549	12435	11887	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	427790	1014	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
7865309	7865309	PRJNA1105232_S_NODE_1727_length_396_cov_2.821326_g1511_i0	PRJNA1105232	1727	396	2.821326	11.17245096	Hathewaya histolytica	1498	Bacteria	Bacteria	726	0	NTclustered	gi\|3080568\|dbj\|AB013091.1\|	1498	g1511	i0	99.748	919.888888888889	397	0	100	1	1	396	586	190	Clostridium histolyticum rrlC gene for 23S rRNA, partial sequence	blastn	364276	726	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
7865361	7865361	PRJNA1105232_S_NODE_9907_length_203_cov_1.012987_g9691_i0	PRJNA1105232	9907	203	1.012987	2.05636361	Streptococcus mitis	28037	Bacteria	Bacteria	327	2.62e-85	NTclustered	gi\|2886504969\|emb\|OZ217342.1\|	28037	g9691	i0	96.02	98.8522167487685	201	8	99	0	3	203	1325746	1325946	Streptococcus mitis isolate S. mitis B22 genome assembly, chromosome: 1	blastn	20067	327	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
9140152	9140152	PRJNA1105232_S_NODE_10368_length_199_cov_0.973333_g10152_i0	PRJNA1105232	10368	199	0.973333	1.93693267	Niallia taxi	2499688	Bacteria	Bacteria	363	7.019999999999998e-96	NTclustered	gi\|2593272489\|gb\|CP102589.1\|	2499688	g10152	i0	99.497	1	199	1	100	0	1	199	1490056	1489858	Niallia taxi strain NBC_Nia chromosome, complete genome	blastn	199	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia taxi
10416019	10416019	PRJNA1105232_S_NODE_17329_length_162_cov_0.920354_g17113_i0	PRJNA1105232	17329	162	0.920354	1.49097348	Niallia taxi	2499688	Bacteria	Bacteria	267	4.419999999999999e-67	NTclustered	gi\|2593272489\|gb\|CP102589.1\|	2499688	g17113	i0	96.296	1	162	6	100	0	1	162	164932	165093	Niallia taxi strain NBC_Nia chromosome, complete genome	blastn	162	267	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia taxi
10416045	10416045	PRJNA1105232_S_NODE_6309_length_242_cov_1.347150_g6093_i0	PRJNA1105232	6309	242	1.34715	3.260103	Niallia taxi	2499688	Bacteria	Bacteria	414	2.41e-111	NTclustered	gi\|2593272489\|gb\|CP102589.1\|	2499688	g6093	i0	97.521	2.00413223140496	242	6	100	0	1	242	2858751	2858510	Niallia taxi strain NBC_Nia chromosome, complete genome	blastn	485	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia taxi
10416055	10416055	PRJNA1105232_S_NODE_8169_length_218_cov_2.461538_g7953_i0	PRJNA1105232	8169	218	2.461538	5.36615284	Clostridium botulinum	1491	Bacteria	Bacteria	58.4	4.14e-4	NTclustered	gi\|1944081129\|gb\|CP063959.1\|	1491	g7953	i0	100	0.284403669724771	31	0	14	0	130	160	2490451	2490481	Clostridium botulinum strain 3859/11 chromosome, complete genome	blastn	62	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
11691277	11691277	PRJNA1105232_S_NODE_2030_length_374_cov_2.433846_g1814_i0	PRJNA1105232	2030	374	2.433846	9.10258404	Virgibacillus dokdonensis	302167	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1318753741\|gb\|CP018622.1\|	302167	g1814	i0	96.875	0.0855614973262032	32	0	9	1	98	129	330469	330499	Virgibacillus dokdonensis strain 21D chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus dokdonensis
12966409	12966409	PRJNA1105232_S_NODE_13051_length_180_cov_2.770992_g12835_i0	PRJNA1105232	13051	180	2.770992	4.9877856	Hathewaya histolytica	1498	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|40527\|emb\|X63673.1\|	1498	g12835	i0	100	2	180	0	100	0	1	180	1681	1502	C.histolyticum closI gene for alpha-clostripain	blastn	360	333	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
14241442	14241442	PRJNA1105232_S_NODE_9632_length_205_cov_1.333333_g9416_i0	PRJNA1105232	9632	205	1.333333	2.73333265	Staphylococcus caprae	29380	Bacteria	Bacteria	363	7.279999999999998e-96	NTclustered	gi\|1467488938\|dbj\|AP018587.1\|	29380	g9416	i0	98.537	5.97073170731707	205	3	100	0	1	205	575720	575516	Staphylococcus caprae JMUB898 DNA, complete genome	blastn	1224	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus caprae
15515244	15515244	PRJNA1105232_S_NODE_8113_length_219_cov_1.429412_g7897_i0	PRJNA1105232	8113	219	1.429412	3.13041228	Niallia taxi	2499688	Bacteria	Bacteria	361	2.83e-95	NTclustered	gi\|2593272489\|gb\|CP102589.1\|	2499688	g7897	i0	96.347	1.1324200913242	219	8	100	0	1	219	1247908	1248126	Niallia taxi strain NBC_Nia chromosome, complete genome	blastn	248	361	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Niallia	Niallia taxi
16322920	16322920	PRJNA1105232_S_NODE_11953_length_187_cov_1.833333_g11737_i0	PRJNA1105232	11953	187	1.833333	3.42833271	Ligilactobacillus	2767887	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2508735984\|gb\|CP114501.1\|	1624	g11737	i0	100	536.96256684492	187	0	100	0	1	187	148447	148633	Ligilactobacillus salivarius strain S99 chromosome, complete genome	blastn	100412	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus salivarius
16789695	16789695	PRJNA1105232_S_NODE_10494_length_198_cov_1.046980_g10278_i0	PRJNA1105232	10494	198	1.04698	2.0730204	Hathewaya histolytica	1498	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g10278	i0	100	3.6010101010101	198	0	100	0	1	198	1222488	1222685	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	713	366	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
16789745	16789745	PRJNA1105232_S_NODE_5814_length_250_cov_1.293532_g5598_i0	PRJNA1105232	5814	250	1.293532	3.23383	Carnobacterium sp. TMP28	3397060	Bacteria	Bacteria	71.3	6.25e-8	NTclustered	gi\|2905474739\|gb\|CP180212.1\|	3397060	g5598	i0	100	0.152	38	0	15	0	176	213	1276624	1276587	Carnobacterium sp. TMP28 isolate 11T.7.20.2 chromosome, complete genome	blastn	38	71.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium sp. TMP28
16789753	16789753	PRJNA1105232_S_NODE_7434_length_227_cov_0.876404_g7218_i0	PRJNA1105232	7434	227	0.876404	1.98943708	Clostridium taeniosporum	394958	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1326041695\|gb\|CP017253.2\|	394958	g7218	i0	100	0.123348017621145	28	0	12	0	166	193	1011469	1011496	Clostridium taeniosporum strain 1/k chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium taeniosporum
17598103	17598103	PRJNA1105232_S_NODE_6794_length_235_cov_1.403226_g6578_i0	PRJNA1105232	6794	235	1.403226	3.2975811	Carnobacterium	2747	Bacteria	Bacteria	351	1.85e-92	NTclustered	gi\|470488194\|ref\|NR_076855.1\|	208596	g6578	i0	93.617	401.863829787234	235	15	100	0	1	235	1467	1233	Carnobacterium sp. 17-4 strain 17-4 23S ribosomal RNA, complete sequence	blastn	94438	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium sp. 17-4
18871983	18871983	PRJNA1105232_S_NODE_16075_length_166_cov_1.333333_g15859_i0	PRJNA1105232	16075	166	1.333333	2.21333278	Streptococcus	1301	Bacteria	Bacteria	292	7.52e-75	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g15859	i0	98.225	101.807228915663	169	0	100	2	1	166	2102016	2102184	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	16900	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
21422431	21422431	PRJNA1105232_S_NODE_14757_length_171_cov_1.278689_g14541_i0	PRJNA1105232	14757	171	1.278689	2.18655819	Bacillati	1783272	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|1624799676\|gb\|MK841091.1\|	48221	g14541	i0	100	107	171	0	100	0	1	171	68	238	Carnobacterium sp. strain CEM13 16S ribosomal RNA gene, partial sequence	blastn	18297	316	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium sp.
23164849	23164849	PRJNA1105232_S_NODE_14919_length_170_cov_2.033058_g14703_i0	PRJNA1105232	14919	170	2.033058	3.4561986	Hathewaya histolytica	1498	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|4760823\|dbj\|D87215.1\|	1498	g14703	i0	100	3	170	0	100	0	1	170	2463	2294	Clostridium histolyticum orfluG, colG, mscL, orf2dG, orf3dG genes, complete cds	blastn	510	315	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica

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