metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA489308" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA489308" 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
450291	450291	PRJNA489308_P_NODE_28121_length_258_cov_1.637838_g28045_i0	PRJNA489308	28121	258	1.637838	4.22562204	Parvimonas micra	33033	Bacteria	Bacteria	416	7.229999999999998e-112	NTclustered	gi\|2702638792\|gb\|CP148048.1\|	33033	g28045	i0	95.753	274.476744186047	259	10	100	1	1	258	311261	311003	Parvimonas micra strain JM503A chromosome, complete genome	blastn	70815	416	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
1098118	1098118	PRJNA489308_P_NODE_39961_length_233_cov_2.912500_g39885_i0	PRJNA489308	39961	233	2.9125	6.786125	Staphylococcus	1279	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g39885	i0	99.571	477.957081545064	233	1	100	0	1	233	730199	730431	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	111364	425	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
2373573	2373573	PRJNA489308_P_NODE_18402_length_294_cov_1.597285_g18326_i0	PRJNA489308	18402	294	1.597285	4.6960179	Staphylococcus	1279	Bacteria	Bacteria	512	1.04e-140	NTclustered	gi\|46370575\|gb\|AY538683.1\|	269290	g18326	i0	97.959	109.955782312925	294	6	100	0	1	294	322	29	Staphylococcus sp. Smarlab 3301073 16S ribosomal RNA gene, partial sequence	blastn	32327	516	0.992248062015504	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus sp. Smarlab 3301073
3000964	3000964	PRJNA489308_P_NODE_28883_length_256_cov_1.415301_g28807_i0	PRJNA489308	28883	256	1.415301	3.62317056	Gemella haemolysans	1379	Bacteria	Bacteria	462	9.07e-126	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g28807	i0	99.219	426.21484375	256	2	100	0	1	256	11006	10751	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	109111	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
3000991	3000991	PRJNA489308_P_NODE_32303_length_249_cov_0.875000_g32227_i0	PRJNA489308	32303	249	0.875	2.17875	Lactobacillus acetotolerans	1600	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1782776542\|gb\|CP046528.1\|	1600	g32227	i0	100	0.112449799196787	28	0	11	0	205	232	373782	373809	Lactobacillus acetotolerans strain CN247 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acetotolerans
4277270	4277270	PRJNA489308_P_NODE_32324_length_249_cov_0.875000_g32248_i0	PRJNA489308	32324	249	0.875	2.17875	Solobacterium moorei	102148	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2589153872\|dbj\|AP028934.1\|	102148	g32248	i0	99.197	1	249	2	100	0	1	249	1512423	1512175	Solobacterium moorei JCM 10645 DNA, complete genome	blastn	249	449	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Solobacterium	Solobacterium moorei
4926217	4926217	PRJNA489308_P_NODE_16944_length_301_cov_3.109649_g16868_i0	PRJNA489308	16944	301	3.109649	9.36004349	Paenibacillus	44249	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1373996327\|gb\|CP028366.1\|	59843	g16868	i0	100	0.770764119601329	30	0	10	0	155	184	6305051	6305080	Paenibacillus glucanolyticus strain W10507 chromosome	blastn	232	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
8103406	8103406	PRJNA489308_P_NODE_38847_length_241_cov_0.916667_g38771_i0	PRJNA489308	38847	241	0.916667	2.20916747	Thermoanaerobacterium sp. RBIITD	1550240	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1239558912\|emb\|LT906662.1\|	1550240	g38771	i0	100	0.12448132780083	30	0	12	0	44	73	1175289	1175260	Thermoanaerobacterium sp. RBIITD genome assembly, chromosome: I	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium sp. RBIITD
10654026	10654026	PRJNA489308_P_NODE_7569_length_395_cov_1.745342_g7493_i0	PRJNA489308	7569	395	1.745342	6.8941009	Oceanobacillus sp. FSL K6-3682	2921503	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2709943379\|gb\|CP150263.1\|	2921503	g7493	i0	100	0.0708860759493671	28	0	7	0	64	91	3450803	3450776	Oceanobacillus sp. FSL K6-3682 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus sp. FSL K6-3682
12577085	12577085	PRJNA489308_P_NODE_27330_length_260_cov_2.058824_g27254_i0	PRJNA489308	27330	260	2.058824	5.3529424	Latilactobacillus	2767885	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2254143037\|gb\|CP017273.1\|	1599	g27254	i0	100	582.388461538462	260	0	100	0	1	260	1430447	1430706	Latilactobacillus sakei strain TMW 1.1396 chromosome, complete genome	blastn	151421	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Latilactobacillus	Latilactobacillus sakei
12577088	12577088	PRJNA489308_P_NODE_35430_length_245_cov_0.895349_g35354_i0	PRJNA489308	35430	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	71.3	6.11e-8	NTclustered	gi\|2049754127\|gb\|CP036116.1\|	1405	g35354	i0	95.455	19.1918367346939	44	2	18	0	79	122	74377	74420	Bacillus mycoides strain JAS481 plasmid p124	blastn	4702	71.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus mycoides
13203754	13203754	PRJNA489308_P_NODE_16171_length_306_cov_1.622318_g16095_i0	PRJNA489308	16171	306	1.622318	4.96429308	Metasolibacillus sp. FSL K6-0083	2921416	Bacteria	Bacteria	106	2.16e-18	NTclustered	gi\|2723706368\|gb\|CP152046.1\|	2921416	g16095	i0	75.325	0.754901960784314	231	51	75	6	64	291	1889978	1890205	Metasolibacillus sp. FSL K6-0083 chromosome, complete genome	blastn	231	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Metasolibacillus	Metasolibacillus sp. FSL K6-0083
14478830	14478830	PRJNA489308_P_NODE_35712_length_245_cov_0.895349_g35636_i0	PRJNA489308	35712	245	0.895349	2.19360505	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g35636	i0	98.776	2.98367346938775	245	3	100	0	1	245	2066063	2066307	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	731	436	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
16400649	16400649	PRJNA489308_P_NODE_34033_length_247_cov_0.885057_g33957_i0	PRJNA489308	34033	247	0.885057	2.18609079	Staphylococcus	1279	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1958228241\|gb\|CP068069.1\|	246432	g33957	i0	100	51.3724696356275	247	0	100	0	1	247	928700	928946	Staphylococcus equorum strain FDAARGOS_1149 chromosome, complete genome	blastn	12689	457	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus equorum
16400650	16400650	PRJNA489308_P_NODE_35053_length_245_cov_2.395349_g34977_i0	PRJNA489308	35053	245	2.395349	5.86860505	Streptococcus	1301	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2182940285\|gb\|OM368584.1\|	28037	g34977	i0	100	97.4775510204082	245	0	100	0	1	245	261	17	Streptococcus mitis strain FC6538 16S ribosomal RNA gene, partial sequence	blastn	23882	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
16400655	16400655	PRJNA489308_P_NODE_37753_length_242_cov_1.349112_g37677_i0	PRJNA489308	37753	242	1.349112	3.26485104	Clostridium	1485	Bacteria	Bacteria	62.1	3.62e-5	NTclustered	gi\|1944079066\|gb\|CP063822.1\|	1491	g37677	i0	88.235	1.75206611570248	51	6	21	0	154	204	2140388	2140438	Clostridium botulinum strain 1873 chromosome, complete genome	blastn	424	62.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
18301814	18301814	PRJNA489308_P_NODE_28235_length_258_cov_1.210811_g28159_i0	PRJNA489308	28235	258	1.210811	3.12389238	Neobacillus sp. 114	3048535	Bacteria	Bacteria	60.2	1.4e-4	NTclustered	gi\|2511738003\|gb\|CP126144.1\|	3048535	g28159	i0	100	0.124031007751938	32	0	12	0	169	200	5125867	5125836	Neobacillus sp. 114 chromosome, complete genome	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus sp. 114
18301855	18301855	PRJNA489308_P_NODE_34015_length_247_cov_0.885057_g33939_i0	PRJNA489308	34015	247	0.885057	2.18609079	Aeribacillus sp. FSL k6-2211	2954608	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2709550449\|gb\|CP150190.1\|	2954608	g33939	i0	99.595	8	247	1	100	0	1	247	1903522	1903768	Aeribacillus sp. FSL k6-2211 chromosome, complete genome	blastn	1976	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Aeribacillus	Aeribacillus sp. FSL k6-2211
19575909	19575909	PRJNA489308_P_NODE_18256_length_295_cov_1.387387_g18180_i0	PRJNA489308	18256	295	1.387387	4.09279165	Priestia koreensis	284581	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2210150307\|gb\|CP061868.1\|	284581	g18180	i0	100	0.0949152542372881	28	0	9	0	218	245	2335808	2335835	Priestia koreensis strain FS-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia koreensis
20851753	20851753	PRJNA489308_P_NODE_16117_length_306_cov_2.248927_g16041_i0	PRJNA489308	16117	306	2.248927	6.88171662	Parvimonas micra	33033	Bacteria	Bacteria	549	8.3e-152	NTclustered	gi\|2418010290\|gb\|CP101408.1\|	33033	g16041	i0	99.02	373.558823529412	306	3	100	0	1	306	334660	334965	Parvimonas micra strain PM79KC-AC-2 chromosome, complete genome	blastn	114309	549	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
24676052	24676052	PRJNA489308_P_NODE_10640_length_349_cov_1.652174_g10564_i0	PRJNA489308	10640	349	1.652174	5.76608726	Cytobacillus dafuensis	1742359	Bacteria	Bacteria	195	5.1699999999999995e-45	NTclustered	gi\|1722682188\|gb\|CP042593.1\|	1742359	g10564	i0	79.636	46.2578796561605	275	52	78	4	1	273	2075248	2074976	Cytobacillus dafuensis strain FJAT-25496 chromosome, complete genome	blastn	16144	195	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus dafuensis

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