metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA638724" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA638724" 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
3706983	3706983	PRJNA638724_P_NODE_7363_length_242_cov_5.295858_g7277_i0	PRJNA638724	7363	242	5.295858	12.81597636	Staphylococcus	1279	Bacteria	Bacteria	372	1.47e-98	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g7277	i0	100	392.590909090909	201	0	83	0	1	201	750671	750471	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	95007	374	0.994652406417112	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8262830	8262830	PRJNA638724_P_NODE_5847_length_265_cov_1.781250_g5761_i0	PRJNA638724	5847	265	1.78125	4.7203125	Bacillus pseudomycoides	64104	Bacteria	Bacteria	414	2.68e-111	NTclustered	gi\|673968774\|gb\|CP007621.1\|	64104	g5761	i0	96.429	14.9660377358491	252	7	95	2	5	255	3134	3384	Bacillus pseudomycoides strain 219298 plasmid, complete sequence	blastn	3966	414	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus pseudomycoides
8262835	8262835	PRJNA638724_P_NODE_7467_length_241_cov_2.880952_g7381_i0	PRJNA638724	7467	241	2.880952	6.94309432	Eubacterium ventriosum	39496	Bacteria	Bacteria	255	1.54e-63	NTclustered	gi\|2299453608\|gb\|CP102282.1\|	39496	g7381	i0	88.372	401.190871369295	215	21	88	4	20	232	186053	186265	Eubacterium ventriosum strain ATCC 27560 chromosome, complete genome	blastn	96687	255	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium ventriosum
8808251	8808251	PRJNA638724_P_NODE_2227_length_400_cov_5.544343_g2141_i0	PRJNA638724	2227	400	5.544343	22.177372	Bacillales	1385	Bacteria	Bacteria	708	0	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g2141	i0	99.235	466.525	392	3	98	0	1	392	771988	771597	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	186610	713	0.992987377279102	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
9538139	9538139	PRJNA638724_P_NODE_7328_length_243_cov_0.905882_g7242_i0	PRJNA638724	7328	243	0.905882	2.20129326	Paucilactobacillus nenjiangensis	1296540	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|1747837594\|gb\|CP043939.1\|	1296540	g7242	i0	99.149	433.847736625514	235	0	96	1	1	233	861395	861161	Paucilactobacillus nenjiangensis strain SH-Y15 chromosome, complete genome	blastn	105425	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Paucilactobacillus	Paucilactobacillus nenjiangensis
10083835	10083835	PRJNA638724_P_NODE_1588_length_464_cov_2.342711_g1502_i0	PRJNA638724	1588	464	2.342711	10.87017904	Bacillales	1385	Bacteria	Bacteria	839	0	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g1502	i0	100	112.536637931034	454	0	98	0	11	464	88	541	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	52217	841	0.997621878715815	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10083840	10083840	PRJNA638724_P_NODE_7748_length_235_cov_4.197531_g7662_i0	PRJNA638724	7748	235	4.197531	9.86419785	Bacillales	1385	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g7662	i0	99.574	521.757446808511	235	1	100	0	1	235	750206	749972	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	122613	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10813780	10813780	PRJNA638724_P_NODE_4169_length_307_cov_1.581197_g4083_i0	PRJNA638724	4169	307	1.581197	4.85427479	Stomatobaculum sp. F0698	3059030	Bacteria	Bacteria	278	4.34e-70	NTclustered	gi\|2557572515\|gb\|CP130060.1\|	3059030	g4083	i0	88.312	347.28338762215	231	27	86	0	43	273	1919304	1919074	Stomatobaculum sp. F0698 chromosome, complete genome	blastn	106616	278	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Stomatobaculum	Stomatobaculum sp. F0698
11358745	11358745	PRJNA638724_P_NODE_4969_length_285_cov_1.405660_g4883_i0	PRJNA638724	4969	285	1.40566	4.006131	Mediterraneibacter	2316020	Bacteria	Bacteria	359	1.39e-94	NTclustered	gi\|2813041538\|emb\|OZ186740.1\|	33038	g4883	i0	90.182	467.063157894737	275	27	96	0	1	275	711810	711536	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD030 genome assembly, chromosome: 1	blastn	133113	359	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
11358746	11358746	PRJNA638724_P_NODE_5069_length_283_cov_0.957143_g4983_i0	PRJNA638724	5069	283	0.957143	2.70871469	root	1	Root_unresolved	Root_unresolved	440	4.769999999999998e-119	NTclustered	gi\|1721134208\|emb\|LR699010.1\|	617123	g4983	i0	95.324	457.014134275618	278	12	98	1	1	277	488874	488597	Lachnoanaerobaculum umeaense isolate MGYG-HGUT-02522 genome assembly, chromosome: 1	blastn	129335	440	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnoanaerobaculum	Lachnoanaerobaculum umeaense
12088994	12088994	PRJNA638724_P_NODE_7410_length_242_cov_1.355030_g7324_i0	PRJNA638724	7410	242	1.35503	3.2791726	Bacillus thuringiensis	1428	Bacteria	Bacteria	274	4.27e-69	NTclustered	gi\|2257811600\|gb\|CP085412.1\|	1428	g7324	i0	87.866	6.71487603305785	239	22	96	1	1	232	2919	2681	Bacillus thuringiensis strain KF1 plasmid unnamed3, complete sequence	blastn	1625	274	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
12634375	12634375	PRJNA638724_P_NODE_7230_length_244_cov_0.900585_g7144_i0	PRJNA638724	7230	244	0.900585	2.1974274	Exiguobacterium	33986	Bacteria	Bacteria	333	7.019999999999999e-87	NTclustered	gi\|407059973\|gb\|CP003063.1\|	1087448	g7144	i0	92.308	4.81967213114754	234	18	96	0	1	234	1395540	1395307	Exiguobacterium antarcticum B7, complete genome	blastn	1176	333	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium antarcticum
13363751	13363751	PRJNA638724_P_NODE_3591_length_328_cov_1.521569_g3505_i0	PRJNA638724	3591	328	1.521569	4.99074632	Mediterraneibacter gnavus	33038	Bacteria	Bacteria	466	9.299999999999999e-127	NTclustered	gi\|2813041527\|emb\|OZ186729.1\|	33038	g3505	i0	92.879	481.170731707317	323	19	97	3	1	319	434616	434294	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD035 genome assembly, chromosome: 1	blastn	157824	466	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
13909276	13909276	PRJNA638724_P_NODE_3131_length_347_cov_2.759124_g3045_i0	PRJNA638724	3131	347	2.759124	9.57416028	Streptococcus	1301	Bacteria	Bacteria	617	2.58e-172	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g3045	i0	99.703	335.057636887608	337	1	97	0	11	347	424070	424406	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	116265	623	0.990369181380417	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
13909278	13909278	PRJNA638724_P_NODE_5811_length_266_cov_1.424870_g5725_i0	PRJNA638724	5811	266	1.42487	3.7901542	Leuconostoc	1243	Bacteria	Bacteria	473	4.379999999999999e-129	NTclustered	gi\|1799531339\|gb\|CP028255.1\|	1245	g5725	i0	100	333.954887218045	256	0	96	0	1	256	68198	67943	Leuconostoc mesenteroides strain SRCM102735 chromosome, complete genome	blastn	88832	473	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
14638485	14638485	PRJNA638724_P_NODE_6512_length_253_cov_1.394444_g6426_i0	PRJNA638724	6512	253	1.394444	3.52794332	Peptostreptococcus porci	2652282	Bacteria	Bacteria	87.9	6.29e-13	NTclustered	gi\|2677426753\|dbj\|AP029254.1\|	2652282	g6426	i0	86.42	0.320158102766798	81	10	32	1	3	82	222784	222704	Peptostreptococcus porci GAI11004 DNA, complete genome	blastn	81	87.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus	Peptostreptococcus porci
14638486	14638486	PRJNA638724_P_NODE_6572_length_252_cov_1.351955_g6486_i0	PRJNA638724	6572	252	1.351955	3.4069266	Selenomonas sp. oral taxon 920	1884263	Bacteria	Bacteria	444	3.2299999999999996e-120	NTclustered	gi\|1061029751\|gb\|CP017042.1\|	1884263	g6486	i0	99.588	73.9761904761905	243	1	96	0	1	243	346352	346110	Selenomonas sp. oral taxon 920 strain W5150 chromosome, complete sequence	blastn	18642	444	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas sp. oral taxon 920
15912464	15912464	PRJNA638724_P_NODE_4473_length_298_cov_1.657778_g4387_i0	PRJNA638724	4473	298	1.657778	4.94017844	Bacillus mycoides	1405	Bacteria	Bacteria	518	2.2699999999999998e-142	NTclustered	gi\|2592571199\|gb\|CP136379.1\|	1405	g4387	i0	99.648	35.2751677852349	284	0	95	1	11	293	3854	3571	Bacillus mycoides strain PAMC 29434 plasmid unnamed7, complete sequence	blastn	10512	518	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
16458087	16458087	PRJNA638724_P_NODE_8193_length_222_cov_4.395973_g8107_i0	PRJNA638724	8193	222	4.395973	9.75906006	Lactobacillus	1578	Bacteria	Bacteria	377	2.86e-100	NTclustered	gi\|1193133691\|gb\|CP021136.1\|	83684	g8107	i0	100	520.117117117117	204	0	92	0	1	204	460946	461149	Lactobacillus delbrueckii subsp. delbrueckii strain TUA4408L, complete genome	blastn	115466	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii
19736320	19736320	PRJNA638724_P_NODE_3636_length_326_cov_1.407115_g3550_i0	PRJNA638724	3636	326	1.407115	4.5871949	Helcococcus ovis	72026	Bacteria	Bacteria	366	9.64e-97	NTclustered	gi\|2873000570\|gb\|CP121192.1\|	72026	g3550	i0	91.144	774.064417177914	271	22	83	1	48	316	204027	203757	Helcococcus ovis strain KG38 chromosome, complete genome	blastn	252345	366	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Helcococcus	Helcococcus ovis
19736321	19736321	PRJNA638724_P_NODE_4336_length_302_cov_1.030568_g4250_i0	PRJNA638724	4336	302	1.030568	3.11231536	Bacillus mycoides	1405	Bacteria	Bacteria	409	1.45e-109	NTclustered	gi\|2070286654\|gb\|CP067056.1\|	1405	g4250	i0	92.334	3.70529801324503	287	22	95	0	16	302	1997	1711	Bacillus mycoides strain JAS 83/3 plasmid pl7, complete sequence	blastn	1119	409	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
19736326	19736326	PRJNA638724_P_NODE_6976_length_247_cov_0.885057_g6890_i0	PRJNA638724	6976	247	0.885057	2.18609079	Catenibacterium mitsuokai	100886	Bacteria	Bacteria	433	6.82e-117	NTclustered	gi\|2299336055\|gb\|CP102271.1\|	100886	g6890	i0	99.578	434.866396761134	237	1	96	0	1	237	143730	143494	Catenibacterium mitsuokai strain DSM 15897 chromosome, complete genome	blastn	107412	433	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Catenibacterium	Catenibacterium mitsuokai
20281753	20281753	PRJNA638724_P_NODE_4836_length_288_cov_1.418605_g4750_i0	PRJNA638724	4836	288	1.418605	4.0855824	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2633045940\|gb\|CP132148.1\|	1496	g4750	i0	92.5	1.35763888888889	40	2	14	1	105	144	117172	117134	Clostridioides difficile strain SC084-01-01 plasmid p840101_2, complete sequence	blastn	391	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
21557232	21557232	PRJNA638724_P_NODE_1317_length_502_cov_2.818182_g1232_i0	PRJNA638724	1317	502	2.818182	14.14727364	Streptococcus	1301	Bacteria	Bacteria	904	0	NTclustered	gi\|1943213388\|gb\|CP065706.1\|	1303	g1232	i0	99.797	328.870517928287	492	1	98	0	1	492	198352	197861	Streptococcus oralis strain FDAARGOS_886 chromosome, complete genome	blastn	165093	904	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
23562201	23562201	PRJNA638724_P_NODE_1599_length_463_cov_2.638462_g1513_i0	PRJNA638724	1599	463	2.638462	12.21607906	[Clostridium] symbiosum	1512	Bacteria	Bacteria	660	0	NTclustered	gi\|2188832615\|dbj\|AP025571.1\|	1512	g1513	i0	92.967	464.578833693305	455	28	98	4	1	453	18896	18444	[Clostridium] symbiosum CE91-St65 DNA, complete genome	blastn	215100	660	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Otoolea	[Clostridium] symbiosum
24107264	24107264	PRJNA638724_P_NODE_5239_length_279_cov_1.660194_g5153_i0	PRJNA638724	5239	279	1.660194	4.63194126	Erysipelotrichaceae	128827	Bacteria	Bacteria	335	2.2799999999999993e-87	NTclustered	gi\|2589153872\|dbj\|AP028934.1\|	102148	g5153	i0	94.47	436.885304659498	217	12	78	0	1	217	147935	147719	Solobacterium moorei JCM 10645 DNA, complete genome	blastn	121891	335	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Solobacterium	Solobacterium moorei
25381700	25381700	PRJNA638724_P_NODE_8560_length_199_cov_4.658730_g8474_i0	PRJNA638724	8560	199	4.65873	9.2708727	Lactobacillus	1578	Bacteria	Bacteria	346	7.070000000000001e-91	NTclustered	gi\|2913931147\|gb\|CP181267.1\|	1584	g8474	i0	99.474	505.130653266332	190	1	95	0	10	199	301300	301111	MAG: Lactobacillus delbrueckii isolate UW_FK_LACTO1_1 chromosome	blastn	100521	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii

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