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

25 rows where analysis = "blastn", bioproject = "PRJNA633835" and tax_kingdom = "Bacillati"

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
4431558	4431558	PRJNA633835_S_NODE_8304_length_264_cov_1.209424_g8236_i0	PRJNA633835	8304	264	1.209424	3.19287936	Rothia mucilaginosa	43675	Bacteria	Bacteria	429	9.529999999999999e-116	NTclustered	gi\|2236340155\|gb\|CP097094.1\|	43675	g8236	i0	96.875	9.66287878787879	256	8	97	0	9	264	981554	981809	MAG: Rothia mucilaginosa isolate JCVI-JB-Rm27 chromosome, complete genome	blastn	2551	429	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
5707434	5707434	PRJNA633835_S_NODE_4805_length_313_cov_2.566667_g4737_i0	PRJNA633835	4805	313	2.566667	8.03366771	Gemella sanguinis	84135	Bacteria	Bacteria	555	1.8299999999999998e-153	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g4737	i0	98.718	5.86581469648562	312	4	99	0	2	313	1210635	1210324	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	1836	555	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
5707439	5707439	PRJNA633835_S_NODE_5545_length_300_cov_1.418502_g5477_i0	PRJNA633835	5545	300	1.418502	4.255506	Rothia mucilaginosa	43675	Bacteria	Bacteria	532	8.18e-147	NTclustered	gi\|2236340155\|gb\|CP097094.1\|	43675	g5477	i0	98.667	5.75666666666667	300	4	100	0	1	300	2220820	2220521	MAG: Rothia mucilaginosa isolate JCVI-JB-Rm27 chromosome, complete genome	blastn	1727	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8256964	8256964	PRJNA633835_S_NODE_11107_length_245_cov_0.895349_g11039_i0	PRJNA633835	11107	245	0.895349	2.19360505	Rothia mucilaginosa	43675	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|2236340155\|gb\|CP097094.1\|	43675	g11039	i0	98.367	20.6897959183673	245	4	100	0	1	245	1032170	1032414	MAG: Rothia mucilaginosa isolate JCVI-JB-Rm27 chromosome, complete genome	blastn	5069	431	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8256999	8256999	PRJNA633835_S_NODE_5587_length_299_cov_2.384956_g5519_i0	PRJNA633835	5587	299	2.384956	7.13101844	Gemella haemolysans	1379	Bacteria	Bacteria	388	1.87e-103	NTclustered	gi\|1829987927\|gb\|CP050965.1\|	1379	g5519	i0	90.541	0.989966555183946	296	24	98	2	1	294	1786653	1786360	Gemella haemolysans strain FDAARGOS_740 chromosome	blastn	296	388	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
9532358	9532358	PRJNA633835_S_NODE_7588_length_272_cov_1.155779_g7520_i0	PRJNA633835	7588	272	1.155779	3.14371888	Rothia mucilaginosa	43675	Bacteria	Bacteria	392	1.2899999999999997e-104	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g7520	i0	92.963	9.89338235294118	270	17	99	2	4	272	1982871	1983139	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	2691	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
10807986	10807986	PRJNA633835_S_NODE_10289_length_249_cov_0.869318_g10221_i0	PRJNA633835	10289	249	0.869318	2.16460182	Actinomyces oris	544580	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1948687139\|gb\|CP066060.1\|	544580	g10221	i0	99.598	9.00401606425703	249	1	100	0	1	249	2458701	2458949	Actinomyces oris strain FDAARGOS_1051 chromosome, complete genome	blastn	2242	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
11355692	11355692	PRJNA633835_S_NODE_889_length_542_cov_2.249467_g822_i0	PRJNA633835	889	542	2.249467	12.19211114	Bacteria	2	Bacteria	Bacteria	996	0	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g822	i0	99.815	117.557195571956	542	1	100	0	1	542	52	593	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	63716	996	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13358041	13358041	PRJNA633835_S_NODE_8871_length_258_cov_2.318919_g8803_i0	PRJNA633835	8871	258	2.318919	5.98281102	Rothia mucilaginosa	43675	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2894492453\|gb\|CP178326.1\|	43675	g8803	i0	100	99.5813953488372	258	0	100	0	1	258	56213	56470	Rothia mucilaginosa strain SOSUI007 chromosome, complete genome	blastn	25692	477	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
15906602	15906602	PRJNA633835_S_NODE_1073_length_509_cov_6.722477_g1005_i0	PRJNA633835	1073	509	6.722477	34.21740793	Rothia mucilaginosa	43675	Bacteria	Bacteria	560	6.69e-155	NTclustered	gi\|283133067\|dbj\|AP011540.1\|	680646	g1005	i0	87.525	9.49115913555992	497	47	98	6	13	509	166696	167177	Rothia mucilaginosa DY-18 DNA, complete genome	blastn	4831	560	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
16455019	16455019	PRJNA633835_S_NODE_9413_length_253_cov_1.211111_g9345_i0	PRJNA633835	9413	253	1.211111	3.06411083	root	1	Root_unresolved	Root_unresolved	453	5.39e-123	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g9345	i0	99.203	101.869565217391	251	2	99	0	1	251	1149	1399	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	25773	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17181799	17181799	PRJNA633835_S_NODE_5634_length_299_cov_1.022124_g5566_i0	PRJNA633835	5634	299	1.022124	3.05615076	Rothia mucilaginosa	43675	Bacteria	Bacteria	542	1.35e-149	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g5566	i0	99.331	9.30434782608696	299	2	100	0	1	299	803850	804148	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	2782	542	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
17181800	17181800	PRJNA633835_S_NODE_5974_length_293_cov_1.745455_g5906_i0	PRJNA633835	5974	293	1.745455	5.11418315	Rothia mucilaginosa	43675	Bacteria	Bacteria	536	6.149999999999998e-148	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g5906	i0	99.659	27.6587030716724	293	1	100	0	1	293	1483562	1483270	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	8104	536	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
17181817	17181817	PRJNA633835_S_NODE_9894_length_250_cov_1.259887_g9826_i0	PRJNA633835	9894	250	1.259887	3.1497175	Rothia mucilaginosa	43675	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g9826	i0	98.4	13.072	250	4	100	0	1	250	1103261	1103012	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	3268	440	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
19730432	19730432	PRJNA633835_S_NODE_1776_length_432_cov_1.855153_g1708_i0	PRJNA633835	1776	432	1.855153	8.01426096	Mycoplasma wenyonii	65123	Bacteria	Bacteria	749	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g1708	i0	98.135	0.993055555555556	429	8	99	0	4	432	287738	288166	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	429	749	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21006230	21006230	PRJNA633835_S_NODE_3817_length_337_cov_0.875000_g3749_i0	PRJNA633835	3817	337	0.875	2.94875	Rothia mucilaginosa	43675	Bacteria	Bacteria	490	5.69e-134	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g3749	i0	92.571	10.8813056379822	350	13	100	3	1	337	1797557	1797906	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	3667	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
21006244	21006244	PRJNA633835_S_NODE_6877_length_280_cov_2.386473_g6809_i0	PRJNA633835	6877	280	2.386473	6.6821244	Mycoplasma wenyonii	65123	Bacteria	Bacteria	196	1.13e-45	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g6809	i0	93.233	2.44642857142857	133	9	52	0	1	133	35689	35821	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	685	196	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21554163	21554163	PRJNA633835_S_NODE_12117_length_241_cov_0.916667_g12049_i0	PRJNA633835	12117	241	0.916667	2.20916747	Rothia	32207	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|2894492453\|gb\|CP178326.1\|	43675	g12049	i0	98.34	10	241	4	100	0	1	241	1724254	1724494	Rothia mucilaginosa strain SOSUI007 chromosome, complete genome	blastn	2410	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
22829706	22829706	PRJNA633835_S_NODE_4358_length_323_cov_1.552000_g4290_i0	PRJNA633835	4358	323	1.552	5.01296	Rothia	32207	Bacteria	Bacteria	597	3.11e-166	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g4290	i0	100	44.8204334365325	323	0	100	0	1	323	1937346	1937668	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	14477	597	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
23556398	23556398	PRJNA633835_S_NODE_11679_length_243_cov_0.900000_g11611_i0	PRJNA633835	11679	243	0.9	2.187	Rothia mucilaginosa	43675	Bacteria	Bacteria	398	2.4399999999999997e-106	NTclustered	gi\|1928744956\|gb\|CP061536.1\|	43675	g11611	i0	96.296	8.31275720164609	243	8	100	1	1	243	1230234	1229993	Rothia mucilaginosa strain CECT30005 chromosome	blastn	2020	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
23556406	23556406	PRJNA633835_S_NODE_12119_length_241_cov_0.916667_g12051_i0	PRJNA633835	12119	241	0.916667	2.20916747	Rothia mucilaginosa	43675	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g12051	i0	100	9.89626556016598	241	0	100	0	1	241	1316269	1316509	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	2385	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
23556428	23556428	PRJNA633835_S_NODE_4919_length_311_cov_2.058824_g4851_i0	PRJNA633835	4919	311	2.058824	6.40294264	Mycoplasma wenyonii	65123	Bacteria	Bacteria	337	7.17e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4851	i0	86.262	8.58520900321543	313	39	100	4	1	311	393246	393556	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	2670	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23556436	23556436	PRJNA633835_S_NODE_6239_length_290_cov_1.000000_g6171_i0	PRJNA633835	6239	290	1	2.9	Rothia mucilaginosa	43675	Bacteria	Bacteria	497	2.8699999999999993e-136	NTclustered	gi\|2236340155\|gb\|CP097094.1\|	43675	g6171	i0	97.586	10.1896551724138	290	7	100	0	1	290	2092299	2092010	MAG: Rothia mucilaginosa isolate JCVI-JB-Rm27 chromosome, complete genome	blastn	2955	497	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
23556438	23556438	PRJNA633835_S_NODE_6679_length_283_cov_1.833333_g6611_i0	PRJNA633835	6679	283	1.833333	5.18833239	Rothia mucilaginosa	43675	Bacteria	Bacteria	479	1.01e-130	NTclustered	gi\|915386764\|dbj\|AP014938.1\|	43675	g6611	i0	97.183	9.09187279151944	284	7	100	1	1	283	1152771	1153054	Rothia mucilaginosa DNA, complete genome, strain: NUM-Rm6536	blastn	2573	479	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
24830074	24830074	PRJNA633835_S_NODE_11800_length_242_cov_1.153846_g11732_i0	PRJNA633835	11800	242	1.153846	2.79230732	Rothia mucilaginosa	43675	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2236340155\|gb\|CP097094.1\|	43675	g11732	i0	98.347	9.99586776859504	242	4	100	0	1	242	26284	26525	MAG: Rothia mucilaginosa isolate JCVI-JB-Rm27 chromosome, complete genome	blastn	2419	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa

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