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

25 rows where analysis = "blastn", bioproject = "PRJNA934332" 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
2186010	2186010	PRJNA934332_P_NODE_9242_length_246_cov_1.780347_g9155_i0	PRJNA934332	9242	246	1.780347	4.37965362	Fastidiosipila sanguinis	236753	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1359121252\|gb\|CP027226.1\|	236753	g9155	i0	100	1	246	0	100	0	1	246	1564237	1564482	Fastidiosipila sanguinis strain CCUG 47711 chromosome, complete genome	blastn	246	455	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Fastidiosipila	Fastidiosipila sanguinis
2531095	2531095	PRJNA934332_P_NODE_3922_length_330_cov_1.089494_g3835_i0	PRJNA934332	3922	330	1.089494	3.5953302	Bacillati	1783272	Bacteria	Bacteria	610	4.09e-170	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g3835	i0	100	433.057575757576	330	0	100	0	1	330	1219158	1219487	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	142909	610	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
3461465	3461465	PRJNA934332_P_NODE_10363_length_243_cov_1.358824_g10276_i0	PRJNA934332	10363	243	1.358824	3.30194232	Christensenellaceae bacterium	2054177	Bacteria	Bacteria	182	2.68e-41	NTclustered	gi\|2621705955\|emb\|OY764017.1\|	2054177	g10276	i0	81.223	81.9382716049383	229	39	93	4	1	227	46896	46670	MAG: Christensenellaceae bacterium isolate da863df8-3121-48c8-a9fd-195775925dd7 genome assembly, chromosome: 1	blastn	19911	182	1	Bacteria	Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae		Christensenellaceae bacterium
3807462	3807462	PRJNA934332_P_NODE_6463_length_269_cov_1.571429_g6376_i0	PRJNA934332	6463	269	1.571429	4.22714401	Enterococcus	1350	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|2437787960\|gb\|CP116571.1\|	1351	g6376	i0	100	100	269	0	100	0	1	269	2044434	2044702	Enterococcus faecalis strain K190-1 chromosome, complete genome	blastn	26900	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
3807466	3807466	PRJNA934332_P_NODE_7423_length_252_cov_0.860335_g7336_i0	PRJNA934332	7423	252	0.860335	2.1680442	Bacillaceae	186817	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1839114216\|gb\|MT437014.1\|	1409	g7336	i0	100	144.035714285714	252	0	100	0	1	252	281	30	Bacillus sp. (in: Bacteria) strain P12-35 16S ribosomal RNA gene, partial sequence	blastn	36297	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. (in: firmicutes)
5083752	5083752	PRJNA934332_P_NODE_4164_length_321_cov_2.016129_g4077_i0	PRJNA934332	4164	321	2.016129	6.47177409	Bacillales	1385	Bacteria	Bacteria	593	3.9899999999999986e-165	NTclustered	gi\|2556673542\|gb\|OR367734.1\|	1282	g4077	i0	100	109.990654205607	321	0	100	0	1	321	116	436	Staphylococcus epidermidis strain A3 16S ribosomal RNA gene, partial sequence	blastn	35307	593	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
6359457	6359457	PRJNA934332_P_NODE_2645_length_385_cov_1.365385_g2558_i0	PRJNA934332	2645	385	1.365385	5.25673225	Streptococcus	1301	Bacteria	Bacteria	706	0	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g2558	i0	99.74	345.005194805195	385	1	100	0	1	385	424406	424022	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	132827	712	0.991573033707865	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
6359473	6359473	PRJNA934332_P_NODE_7565_length_251_cov_0.865169_g7478_i0	PRJNA934332	7565	251	0.865169	2.17157419	Anoxybacillus	150247	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g7478	i0	99.203	2.99601593625498	251	2	100	0	1	251	1880634	1880384	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	752	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
6359479	6359479	PRJNA934332_P_NODE_9925_length_245_cov_0.895349_g9838_i0	PRJNA934332	9925	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g9838	i0	100	100	245	0	100	0	1	245	2376309	2376065	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24500	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
8563587	8563587	PRJNA934332_P_NODE_5767_length_281_cov_1.384615_g5680_i0	PRJNA934332	5767	281	1.384615	3.89076815	Faecalibacterium prausnitzii	853	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|2446175570\|gb\|CP117963.1\|	853	g5680	i0	100	19.3024911032028	281	0	100	0	1	281	2604072	2604352	Faecalibacterium prausnitzii strain AP34BHI chromosome, complete genome	blastn	5424	520	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Faecalibacterium	Faecalibacterium prausnitzii
8908221	8908221	PRJNA934332_P_NODE_6967_length_260_cov_1.454545_g6880_i0	PRJNA934332	6967	260	1.454545	3.781817	Carnobacterium	2747	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g6880	i0	100	5.66923076923077	260	0	100	0	1	260	707390	707131	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	1474	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
8908226	8908226	PRJNA934332_P_NODE_7687_length_251_cov_0.865169_g7600_i0	PRJNA934332	7687	251	0.865169	2.17157419	Carnobacterium	2747	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g7600	i0	99.203	4	251	2	100	0	1	251	2779113	2779363	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	1004	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
11459187	11459187	PRJNA934332_P_NODE_3829_length_333_cov_1.776923_g3742_i0	PRJNA934332	3829	333	1.776923	5.91715359	Paenibacillus	44249	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|1125819267\|gb\|CP011420.1\|	1406	g3742	i0	100	1109.4984984985	333	0	100	0	1	333	15737	15405	Paenibacillus polymyxa strain ATCC 15970 chromosome, complete genome	blastn	369463	616	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
11459195	11459195	PRJNA934332_P_NODE_6269_length_272_cov_2.829146_g6182_i0	PRJNA934332	6269	272	2.829146	7.69527712	Listeria	1637	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|2514039015\|gb\|CP096154.1\|	1639	g6182	i0	100	101.018382352941	272	0	100	0	1	272	1961957	1962228	Listeria monocytogenes strain FSL F2-0695 chromosome, complete genome	blastn	27477	503	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
12734865	12734865	PRJNA934332_P_NODE_9990_length_244_cov_2.432749_g9903_i0	PRJNA934332	9990	244	2.432749	5.93590756	Paenibacillus	44249	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1125819267\|gb\|CP011420.1\|	1406	g9903	i0	100	1115.23360655738	244	0	100	0	1	244	14685	14928	Paenibacillus polymyxa strain ATCC 15970 chromosome, complete genome	blastn	272117	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus polymyxa
13664181	13664181	PRJNA934332_P_NODE_11351_length_241_cov_0.916667_g11264_i0	PRJNA934332	11351	241	0.916667	2.20916747	Staphylococcus epidermidis	1282	Bacteria	Bacteria	438	1.4299999999999999e-118	NTclustered	gi\|2709261975\|dbj\|AP028322.1\|	1282	g11264	i0	99.585	100	241	0	100	1	1	241	682114	681875	Staphylococcus epidermidis KSE124-2 DNA, complete genome	blastn	24100	438	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
16557966	16557966	PRJNA934332_P_NODE_9853_length_245_cov_0.895349_g9766_i0	PRJNA934332	9853	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|9623890\|gb\|AF269987.1\|AF269987	1282	g9766	i0	99.592	100	245	1	100	0	1	245	1304	1060	Staphylococcus epidermidis strain SR1 clone step.1038g08 genomic sequence	blastn	24500	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18762330	18762330	PRJNA934332_P_NODE_9055_length_247_cov_0.885057_g8968_i0	PRJNA934332	9055	247	0.885057	2.18609079	Streptococcus sp. Marseille-Q3533	2759692	Bacteria	Bacteria	416	6.869999999999999e-112	NTclustered	gi\|2237347942\|emb\|OW724079.1\|	2759692	g8968	i0	97.154	6.95951417004049	246	7	99	0	1	246	866902	867147	Streptococcus sp. Marseille-Q3533 genome assembly, chromosome: contig00001	blastn	1719	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sp. Marseille-Q3533
20381721	20381721	PRJNA934332_P_NODE_10956_length_242_cov_0.911243_g10869_i0	PRJNA934332	10956	242	0.911243	2.20520806	Staphylococcus	1279	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1982319721\|gb\|CP052971.1\|	1282	g10869	i0	100	100	242	0	100	0	1	242	200069	200310	Staphylococcus epidermidis strain HD33-1 chromosome, complete genome	blastn	24200	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20381758	20381758	PRJNA934332_P_NODE_9676_length_245_cov_0.895349_g9589_i0	PRJNA934332	9676	245	0.895349	2.19360505	Staphylococcus	1279	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2489625674\|gb\|CP121231.1\|	1282	g9589	i0	99.592	101	245	1	100	0	1	245	1765069	1765313	Staphylococcus epidermidis strain 9 chromosome	blastn	24745	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
22933243	22933243	PRJNA934332_P_NODE_11018_length_242_cov_0.911243_g10931_i0	PRJNA934332	11018	242	0.911243	2.20520806	Enterococcus	1350	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1963838897\|emb\|LR962850.1\|	1351	g10931	i0	99.587	100	242	1	100	0	1	242	3078397	3078638	Enterococcus faecalis isolate 27688_1#342 genome assembly, chromosome: 1	blastn	24200	442	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
22933256	22933256	PRJNA934332_P_NODE_6678_length_266_cov_0.797927_g6591_i0	PRJNA934332	6678	266	0.797927	2.12248582	Bacteria	2	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|1042399388\|gb\|KU555885.1\|	1292	g6591	i0	97.744	434.018796992481	266	6	100	0	1	266	596	861	Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	115449	459	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
22933267	22933267	PRJNA934332_P_NODE_9258_length_246_cov_1.468208_g9171_i0	PRJNA934332	9258	246	1.468208	3.61179168	Carnobacterium	2747	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|1051011622\|gb\|CP016844.1\|	2751	g9171	i0	99.405	4.41869918699187	168	1	100	0	79	246	25582	25415	Carnobacterium maltaromaticum strain TMW 2.1581 chromosome, complete genome	blastn	1087	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium maltaromaticum
23863015	23863015	PRJNA934332_P_NODE_9439_length_246_cov_0.890173_g9352_i0	PRJNA934332	9439	246	0.890173	2.18982558	Staphylococcus epidermidis	1282	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2716021442\|gb\|CP114450.1\|	1282	g9352	i0	100	100	246	0	100	0	1	246	235612	235367	Staphylococcus epidermidis strain SE 4.8 chromosome, complete genome	blastn	24600	455	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25481992	25481992	PRJNA934332_P_NODE_2960_length_369_cov_0.966216_g2873_i0	PRJNA934332	2960	369	0.966216	3.56533704	Weissella	46255	Bacteria	Bacteria	676	0	NTclustered	gi\|2788849649\|gb\|CP166847.1\|	1583	g2873	i0	99.73	613.970189701897	370	0	100	1	1	369	20767	20398	Weissella confusa strain HYF86 chromosome HYF86, complete sequence	blastn	226555	676	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella confusa

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