metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA229468" 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
1056633	1056633	PRJNA229468_S_NODE_961_length_173_cov_1.233871_g948_i0	PRJNA229468	961	173	1.233871	2.13459683	Rothia	32207	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g948	i0	100	291.132947976879	173	0	100	0	1	173	652615	652443	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	50366	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
4884545	4884545	PRJNA229468_S_NODE_644_length_203_cov_0.948052_g631_i0	PRJNA229468	644	203	0.948052	1.92454556	Micrococcales	85006	Bacteria	Bacteria	326	9.44e-85	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g631	i0	95.567	360.162561576355	203	9	100	0	1	203	652910	653112	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	73113	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8020686	8020686	PRJNA229468_S_NODE_1007_length_170_cov_1.264463_g994_i0	PRJNA229468	1007	170	1.264463	2.1495871	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	300	4.6e-77	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g994	i0	98.256	276.317647058824	172	1	100	1	1	170	552297	552468	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	46974	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
8020687	8020687	PRJNA229468_S_NODE_287_length_292_cov_1.263374_g274_i0	PRJNA229468	287	292	1.263374	3.68905208	Arthrobacter dokdonellae	2211210	Bacteria	Bacteria	510	3.71e-140	NTclustered	gi\|1409665507\|gb\|CP029642.1\|	2211210	g274	i0	98.282	458.366438356164	291	5	99	0	2	292	551070	550780	Arthrobacter dokdonellae, complete genome	blastn	133843	510	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter dokdonellae
11259789	11259789	PRJNA229468_S_NODE_1149_length_164_cov_1.208696_g1136_i0	PRJNA229468	1149	164	1.208696	1.98226144	Corynebacterium	1716	Bacteria	Bacteria	272	9.65e-69	NTclustered	gi\|2212856580\|gb\|CP051667.1\|	37637	g1136	i0	96.933	323.018292682927	163	3	100	2	4	164	1103762	1103600	Corynebacterium pseudodiphtheriticum strain 10700 chromosome	blastn	52975	272	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudodiphtheriticum
11259790	11259790	PRJNA229468_S_NODE_1169_length_163_cov_2.421053_g1156_i0	PRJNA229468	1169	163	2.421053	3.94631639	Paenibacillus	44249	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1240338366\|gb\|MF872593.1\|	58172	g1156	i0	100	226	163	0	100	0	1	163	1342	1180	Paenibacillus sp. strain 16H1F15 16S ribosomal RNA gene, partial sequence	blastn	36838	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp.
11259793	11259793	PRJNA229468_S_NODE_449_length_234_cov_1.578378_g436_i0	PRJNA229468	449	234	1.578378	3.69340452	Paenibacillus	44249	Bacteria	Bacteria	431	2.3e-116	NTclustered	gi\|686561105\|gb\|CP009428.1\|	189426	g436	i0	100	965.32905982906	233	0	99	0	1	233	14719	14951	Paenibacillus odorifer strain DSM 15391, complete genome	blastn	225887	431	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus odorifer
13809992	13809992	PRJNA229468_S_NODE_1231_length_162_cov_0.902655_g1218_i0	PRJNA229468	1231	162	0.902655	1.4623011	Bacillales	1385	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2264387772\|gb\|CP015553.1\|	1281	g1218	i0	99.383	486.006172839506	162	1	100	0	1	162	124482	124321	Staphylococcus carnosus strain TMW 2.1596 chromosome, complete genome	blastn	78733	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus carnosus
13809994	13809994	PRJNA229468_S_NODE_611_length_207_cov_0.955696_g598_i0	PRJNA229468	611	207	0.955696	1.97829072	Modestobacter	88138	Bacteria	Bacteria	363	7.369999999999998e-96	NTclustered	gi\|470491309\|ref\|NR_077032.1\|	477641	g598	i0	99.01	379.289855072464	202	2	98	0	1	202	1018	817	Modestobacter marinus strain BC501 23S ribosomal RNA, complete sequence	blastn	78513	363	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter marinus
15670093	15670093	PRJNA229468_S_NODE_713_length_195_cov_1.527397_g700_i0	PRJNA229468	713	195	1.527397	2.97842415	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	333	5.369999999999999e-87	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g700	i0	97.436	614.671794871795	195	5	100	0	1	195	5033557	5033751	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	119861	333	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
16944567	16944567	PRJNA229468_S_NODE_174_length_361_cov_1.634615_g161_i0	PRJNA229468	174	361	1.634615	5.90096015	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	592	1.6299999999999996e-164	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g161	i0	96.143	543.487534626039	363	12	100	2	1	361	5032293	5032655	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	196199	592	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
17634189	17634189	PRJNA229468_S_NODE_834_length_182_cov_1.646617_g821_i0	PRJNA229468	834	182	1.646617	2.99684294	Arthrobacter	1663	Bacteria	Bacteria	320	3.84e-83	NTclustered	gi\|2921126289\|gb\|CP102608.1\|	619291	g821	i0	98.352	428.796703296703	182	3	100	0	1	182	459346	459165	Arthrobacter sp. N1 chromosome, complete genome	blastn	78041	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. N1
19493238	19493238	PRJNA229468_S_NODE_1016_length_169_cov_2.775000_g1003_i0	PRJNA229468	1016	169	2.775	4.68975	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	252	1.3e-62	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1003	i0	93.529	700.585798816568	170	10	100	1	1	169	5031878	5032047	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	118399	252	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
21458301	21458301	PRJNA229468_S_NODE_357_length_265_cov_2.222222_g344_i0	PRJNA229468	357	265	2.222222	5.8888883	Cutibacterium	1912216	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g344	i0	100	268.256603773585	265	0	100	0	1	265	56512	56248	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	71088	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22043870	22043870	PRJNA229468_S_NODE_598_length_209_cov_2.018750_g585_i0	PRJNA229468	598	209	2.01875	4.2191875	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	287	4.61e-73	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g585	i0	91.429	405.832535885167	210	16	100	2	1	209	5033288	5033496	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	84819	287	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
22733344	22733344	PRJNA229468_S_NODE_38_length_727_cov_4.001475_g32_i0	PRJNA229468	38	727	4.001475	29.09072325	Cutibacterium	1912216	Bacteria	Bacteria	1343	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g32	i0	100	282.95598349381	727	0	100	0	1	727	56164	55438	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	205709	1343	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23319334	23319334	PRJNA229468_S_NODE_1139_length_165_cov_0.775862_g1126_i0	PRJNA229468	1139	165	0.775862	1.2801723	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	213	5.98e-51	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1126	i0	91.139	386.018181818182	158	12	96	1	8	165	5032914	5033069	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	63693	213	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
24008524	24008524	PRJNA229468_S_NODE_139_length_410_cov_1.637119_g126_i0	PRJNA229468	139	410	1.637119	6.7121879	Paenibacillus	44249	Bacteria	Bacteria	747	0	NTclustered	gi\|686522490\|gb\|CP009281.1\|	1536770	g126	i0	99.512	1055.00731707317	410	2	100	0	1	410	15308	15717	Paenibacillus sp. FSL R5-0345, complete genome	blastn	432553	747	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0345
24008526	24008526	PRJNA229468_S_NODE_739_length_191_cov_0.894366_g726_i0	PRJNA229468	739	191	0.894366	1.70823906	Streptococcus	1301	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g726	i0	100	617.952879581152	191	0	100	0	1	191	17677	17487	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	118029	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
25282653	25282653	PRJNA229468_S_NODE_20_length_915_cov_3.091224_g16_i0	PRJNA229468	20	915	3.091224	28.2846996	Cutibacterium	1912216	Bacteria	Bacteria	1674	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g16	i0	99.672	280.55737704918	915	3	100	0	1	915	56490	57404	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	256710	1674	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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