metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA924320" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA924320" 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
1252183	1252183	PRJNA924320_S_NODE_33261_length_191_cov_1.330986_g33119_i0	PRJNA924320	33261	191	1.330986	2.54218326	Streptococcus	1301	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|1578096036\|emb\|LR216035.1\|	1313	g33119	i0	100	331.979057591623	191	0	100	0	1	191	1835287	1835097	Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1	blastn	63408	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
2527858	2527858	PRJNA924320_S_NODE_19882_length_232_cov_1.469945_g19740_i0	PRJNA924320	19882	232	1.469945	3.4102724	Staphylococcus	1279	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g19740	i0	99.569	455.51724137931	232	1	100	0	1	232	919182	919413	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	105680	424	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
8552362	8552362	PRJNA924320_S_NODE_55727_length_162_cov_0.902655_g55585_i0	PRJNA924320	55727	162	0.902655	1.4623011	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	292	7.3e-75	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g55585	i0	99.379	42.7345679012346	161	1	99	0	1	161	339038	338878	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	6923	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
8904991	8904991	PRJNA924320_S_NODE_26807_length_207_cov_4.613924_g26665_i0	PRJNA924320	26807	207	4.613924	9.55082268	root	1	Root_unresolved	Root_unresolved	383	5.65e-102	NTclustered	gi\|1663099664\|gb\|CP039167.1\|	1280	g26665	i0	100	100	207	0	100	0	1	207	2842769	2842975	Staphylococcus aureus strain R50 chromosome, complete genome	blastn	20700	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8905004	8905004	PRJNA924320_S_NODE_36447_length_184_cov_1.822222_g36305_i0	PRJNA924320	36447	184	1.822222	3.35288848	root	1	Root_unresolved	Root_unresolved	329	6.47e-86	NTclustered	gi\|1370563981\|gb\|CP027781.1\|	1491	g36305	i0	98.913	1955.3152173913	184	2	100	0	1	184	4000368	4000185	Clostridium botulinum strain MAP 5 chromosome, complete genome	blastn	359778	329	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
8905050	8905050	PRJNA924320_S_NODE_8067_length_341_cov_1.811644_g7925_i0	PRJNA924320	8067	341	1.811644	6.17770604	root	1	Root_unresolved	Root_unresolved	628	1.1699999999999999e-175	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g7925	i0	100	36.4486803519062	340	0	99	0	1	340	2427827	2428166	Staphylococcus aureus strain WH9628 chromosome	blastn	12429	628	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12378111	12378111	PRJNA924320_S_NODE_11170_length_295_cov_1.849593_g11028_i0	PRJNA924320	11170	295	1.849593	5.45629935	Anaerococcus obesiensis	1287640	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1954927112\|gb\|CP067016.1\|	1287640	g11028	i0	100	0.0949152542372881	28	0	9	0	247	274	787843	787870	Anaerococcus obesiensis strain FDAARGOS_989 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus obesiensis
14006210	14006210	PRJNA924320_S_NODE_50551_length_165_cov_0.879310_g50409_i0	PRJNA924320	50551	165	0.87931	1.4508615	Staphylococcus	1279	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2663184963\|gb\|CP142855.1\|	1290	g50409	i0	100	55.6363636363636	165	0	100	0	1	165	1171223	1171059	Staphylococcus hominis strain Sh8213 chromosome, complete genome	blastn	9180	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
14927313	14927313	PRJNA924320_S_NODE_52432_length_164_cov_0.886957_g52290_i0	PRJNA924320	52432	164	0.886957	1.45460948	Streptococcus salivarius	1304	Bacteria	Bacteria	276	7.46e-70	NTclustered	gi\|2878122784\|gb\|CP145866.1\|	1304	g52290	i0	96.951	39.5121951219512	164	5	100	0	1	164	1535021	1535184	Streptococcus salivarius strain KSS9 chromosome, complete genome	blastn	6480	276	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
15280173	15280173	PRJNA924320_S_NODE_33152_length_191_cov_1.690141_g33010_i0	PRJNA924320	33152	191	1.690141	3.22816931	Bacillales	1385	Bacteria	Bacteria	344	2.42e-90	NTclustered	gi\|2692800537\|gb\|CP146065.1\|	1283	g33010	i0	98.964	484.455497382199	193	0	100	1	1	191	771635	771827	Staphylococcus haemolyticus strain SPS12 chromosome, complete genome	blastn	92531	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
17477261	17477261	PRJNA924320_S_NODE_19854_length_232_cov_1.672131_g19712_i0	PRJNA924320	19854	232	1.672131	3.87934392	Paenibacillus silvisoli	3110539	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2567904410\|gb\|CP133017.1\|	3110539	g19712	i0	100	0.125	29	0	13	0	191	219	2465937	2465965	Paenibacillus silvisoli strain TW38 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus silvisoli
17477272	17477272	PRJNA924320_S_NODE_21214_length_226_cov_2.881356_g21072_i0	PRJNA924320	21214	226	2.881356	6.51186456	Priestia aryabhattai	412384	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2094564781\|gb\|CP083269.1\|	412384	g21072	i0	96.97	0.146017699115044	33	1	15	0	106	138	2866979	2867011	Priestia aryabhattai strain NM1_A2 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia aryabhattai
18750927	18750927	PRJNA924320_S_NODE_48815_length_166_cov_0.871795_g48673_i0	PRJNA924320	48815	166	0.871795	1.4471797	Pediococcus pentosaceus	1255	Bacteria	Bacteria	230	5.98e-56	NTclustered	gi\|1943285247\|gb\|CP065723.1\|	1255	g48673	i0	91.566	3	166	14	100	0	1	166	712631	712466	Pediococcus pentosaceus strain FDAARGOS_873 chromosome, complete genome	blastn	498	230	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Pediococcus	Pediococcus pentosaceus
19103640	19103640	PRJNA924320_S_NODE_41135_length_175_cov_1.388889_g40993_i0	PRJNA924320	41135	175	1.388889	2.43055575	root	1	Root_unresolved	Root_unresolved	318	1.32e-82	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g40993	i0	99.429	43.6171428571429	175	1	100	0	1	175	2427659	2427833	Staphylococcus aureus strain WH9628 chromosome	blastn	7633	318	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19103647	19103647	PRJNA924320_S_NODE_43715_length_170_cov_3.826446_g43573_i0	PRJNA924320	43715	170	3.826446	6.5049582	root	1	Root_unresolved	Root_unresolved	309	7.64e-80	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g43573	i0	99.412	99.9117647058823	170	1	100	0	1	170	2463858	2463689	Staphylococcus aureus strain WH9628 chromosome	blastn	16985	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
21301099	21301099	PRJNA924320_S_NODE_22657_length_221_cov_1.220930_g22515_i0	PRJNA924320	22657	221	1.22093	2.6982553	Trichococcus flocculiformis	82803	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2621701196\|emb\|OY759718.1\|	82803	g22515	i0	100	0.126696832579186	28	0	13	0	100	127	1191779	1191752	MAG: Trichococcus flocculiformis isolate 659e37ff-3402-4023-a990-0c9469b16b9d genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Trichococcus	Trichococcus flocculiformis
21654448	21654448	PRJNA924320_S_NODE_48117_length_166_cov_0.871795_g47975_i0	PRJNA924320	48117	166	0.871795	1.4471797	Staphylococcus	1279	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g47975	i0	100	100	166	0	100	0	1	166	1570153	1569988	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	16600	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21654465	21654465	PRJNA924320_S_NODE_9577_length_316_cov_1.891386_g9435_i0	PRJNA924320	9577	316	1.891386	5.97677976	root	1	Root_unresolved	Root_unresolved	584	2.359999999999999e-162	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g9435	i0	100	43.3512658227848	316	0	100	0	1	316	2428136	2428451	Staphylococcus aureus strain WH9628 chromosome	blastn	13699	584	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
22576450	22576450	PRJNA924320_S_NODE_51958_length_164_cov_0.886957_g51816_i0	PRJNA924320	51958	164	0.886957	1.45460948	Staphylococcus epidermidis	1282	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g51816	i0	100	99.9634146341463	164	0	100	0	1	164	1254800	1254637	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	16394	303	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis

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