metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA512103" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA512103" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
486194	486194	PRJNA512103_P_NODE_31741_length_167_cov_0.881356_g31329_i0	PRJNA512103	31741	167	0.881356	1.47186452	Micrococcus luteus	1270	Bacteria	Bacteria	278	2.12e-70	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g31329	i0	100	18.502994011976	150	0	90	0	10	159	902916	903065	Micrococcus luteus strain ML chromosome, complete genome	blastn	3090	278	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
486231	486231	PRJNA512103_P_NODE_32941_length_165_cov_0.896552_g32529_i0	PRJNA512103	32941	165	0.896552	1.4793108	Gordonia sp. 135	2676309	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|1779023796\|gb\|CP046257.1\|	2676309	g32529	i0	98.529	94.0242424242424	136	0	82	2	21	156	4580504	4580637	Gordonia sp. 135 chromosome, complete genome	blastn	15514	239	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia sp. 135
1761069	1761069	PRJNA512103_P_NODE_21102_length_208_cov_0.867925_g20690_i0	PRJNA512103	21102	208	0.867925	1.8052840000000001	Gordonia sp. MP11Mi	3022769	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2592691643\|gb\|CP128986.1\|	3022769	g20690	i0	96.875	0.153846153846154	32	1	15	0	123	154	1291122	1291153	Gordonia sp. MP11Mi chromosome, complete genome	blastn	32	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia sp. MP11Mi
4939104	4939104	PRJNA512103_P_NODE_29984_length_170_cov_1.958678_g29572_i0	PRJNA512103	29984	170	1.958678	3.3297526	Bacillati	1783272	Bacteria	Bacteria	143	8.2e-30	NTclustered	gi\|2753147090\|gb\|CP148032.1\|	55583	g29572	i0	86.923	92.7294117647059	130	13	75	4	16	142	233546	233418	MAG: Dehalobacter restrictus isolate SAD chromosome, complete genome	blastn	15764	143	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Dehalobacter	Dehalobacter restrictus
5589608	5589608	PRJNA512103_P_NODE_20545_length_211_cov_1.024691_g20133_i0	PRJNA512103	20545	211	1.024691	2.16209801	Brevibacterium sp. BRM-1	2999062	Bacteria	Bacteria	294	2.79e-75	NTclustered	gi\|2407432046\|gb\|CP113788.1\|	2999062	g20133	i0	94.301	222.265402843602	193	9	91	2	10	202	1090972	1090782	Brevibacterium sp. BRM-1 chromosome, complete genome	blastn	46898	294	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium sp. BRM-1
5590220	5590220	PRJNA512103_P_NODE_5345_length_632_cov_2.404803_g4961_i0	PRJNA512103	5345	632	2.404803	15.19835496	Cylindrospermum stagnale	142864	Bacteria	Bacteria	1007	0	NTclustered	gi\|485099135\|ref\|NR_102530.1\|	56107	g4961	i0	95.833	296.466772151899	624	25	99	1	10	632	2495	1872	Cylindrospermum stagnale PCC 7417 strain PCC 7417 23S ribosomal RNA, complete sequence	blastn	187367	1007	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
7488944	7488944	PRJNA512103_P_NODE_32926_length_165_cov_0.896552_g32514_i0	PRJNA512103	32926	165	0.896552	1.4793108	Actinomycetota	201174	Bacteria	Bacteria	110	8.07e-20	NTclustered	gi\|1865334670\|gb\|CP058322.1\|	47853	g32514	i0	80.822	72.230303030303	146	22	87	5	10	152	3450549	3450691	Micromonospora carbonacea strain aurantiaca chromosome, complete genome	blastn	11918	110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora carbonacea
8763855	8763855	PRJNA512103_P_NODE_17207_length_238_cov_1.190476_g16795_i0	PRJNA512103	17207	238	1.190476	2.83333288	Streptococcus	1301	Bacteria	Bacteria	407	3.9599999999999994e-109	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g16795	i0	100	394.802521008403	220	0	92	0	10	229	18061	17842	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	93963	407	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8763856	8763856	PRJNA512103_P_NODE_21907_length_203_cov_0.954545_g21495_i0	PRJNA512103	21907	203	0.954545	1.93772635	Corynebacterium	1716	Bacteria	Bacteria	342	9.369999999999999e-90	NTclustered	gi\|1954924873\|gb\|CP067012.1\|	1979527	g21495	i0	100	345.07881773399	185	0	91	0	10	194	597848	598032	Corynebacterium kefirresidentii strain FDAARGOS_1055 chromosome, complete genome	blastn	70051	342	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
10039392	10039392	PRJNA512103_P_NODE_18108_length_230_cov_1.016575_g17696_i0	PRJNA512103	18108	230	1.016575	2.3381225	Micrococcus	1269	Bacteria	Bacteria	387	4.96e-103	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g17696	i0	99.07	263.108695652174	215	2	93	0	16	230	2260514	2260728	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	60515	387	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
10039394	10039394	PRJNA512103_P_NODE_24288_length_191_cov_1.577465_g23876_i0	PRJNA512103	24288	191	1.577465	3.01295815	root	1	Root_unresolved	Root_unresolved	320	4.08e-83	NTclustered	gi\|2450068752\|gb\|OQ540790.1\|	1303	g23876	i0	100	90.5759162303665	173	0	91	0	10	182	443	271	Streptococcus oralis strain DM3 16S ribosomal RNA gene, partial sequence	blastn	17300	320	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11314038	11314038	PRJNA512103_P_NODE_31629_length_167_cov_1.042373_g31217_i0	PRJNA512103	31629	167	1.042373	1.74076291	Peribacillus	2675229	Bacteria	Bacteria	281	1.64e-71	NTclustered	gi\|1002184699\|gb\|CP011009.1\|	1478	g31217	i0	98.734	965.784431137725	158	2	95	0	1	158	165685	165842	Bacillus simplex strain SH-B26 plasmid pSHB26, complete sequence	blastn	161286	281	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus simplex
11964511	11964511	PRJNA512103_P_NODE_19530_length_218_cov_1.224852_g19118_i0	PRJNA512103	19530	218	1.224852	2.67017736	Actinokineospora sp. UTMC 2448	2268449	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2290867056\|gb\|CP031087.1\|	2268449	g19118	i0	100	0.334862385321101	29	0	13	0	78	106	5593237	5593209	Actinokineospora sp. UTMC 2448 chromosome, complete genome	blastn	73	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinokineospora	Actinokineospora sp. UTMC 2448
11964646	11964646	PRJNA512103_P_NODE_23030_length_197_cov_1.114865_g22618_i0	PRJNA512103	23030	197	1.114865	2.19628405	Rothia mucilaginosa	43675	Bacteria	Bacteria	344	2.51e-90	NTclustered	gi\|2894495941\|gb\|CP178327.1\|	43675	g22618	i0	99.471	295.543147208122	189	1	96	0	1	189	1093748	1093560	Rothia mucilaginosa strain SOSUI004 chromosome, complete genome	blastn	58222	344	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
11964885	11964885	PRJNA512103_P_NODE_29270_length_173_cov_1.000000_g28858_i0	PRJNA512103	29270	173	1	1.73	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	252	1.33e-62	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28858	i0	95.541	132.878612716763	157	7	91	0	9	165	3682357	3682201	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	22988	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12589807	12589807	PRJNA512103_P_NODE_22830_length_198_cov_1.060403_g22418_i0	PRJNA512103	22830	198	1.060403	2.09959794	root	1	Root_unresolved	Root_unresolved	364	1.9399999999999995e-96	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g22418	i0	100	26.6565656565657	197	0	99	0	2	198	2428000	2428196	Staphylococcus aureus strain WH9628 chromosome	blastn	5278	364	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12589816	12589816	PRJNA512103_P_NODE_8330_length_438_cov_2.128535_g7919_i0	PRJNA512103	8330	438	2.128535	9.3229833	Brachybacterium	43668	Bacteria	Bacteria	573	7.309999999999997e-159	NTclustered	gi\|1654137461\|gb\|CP027295.1\|	2571029	g7919	i0	90.455	247.869863013699	440	35	99	6	1	436	5712	6148	Brachybacterium sp. SGAir0954 chromosome, complete genome	blastn	108567	573	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. SGAir0954
13864638	13864638	PRJNA512103_P_NODE_29391_length_172_cov_1.617886_g28979_i0	PRJNA512103	29391	172	1.617886	2.78276392	Rhodococcus	1827	Bacteria	Bacteria	285	1.31e-72	NTclustered	gi\|2660106423\|gb\|CP138905.1\|	1831	g28979	i0	100	45.3372093023256	154	0	90	0	10	163	2878167	2878320	MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome	blastn	7798	285	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. (in: high G+C Gram-positive bacteria)
13864646	13864646	PRJNA512103_P_NODE_8031_length_451_cov_2.368159_g7622_i0	PRJNA512103	8031	451	2.368159	10.68039709	Bacillati	1783272	Bacteria	Bacteria	817	0	NTclustered	gi\|2328902616\|gb\|CP110363.1\|	1604	g7622	i0	100	369.155210643015	442	0	98	0	10	451	652485	652926	Lactobacillus amylovorus strain CICC 6090 chromosome, complete genome	blastn	166489	817	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus amylovorus
15138913	15138913	PRJNA512103_P_NODE_18752_length_225_cov_0.909091_g18340_i0	PRJNA512103	18752	225	0.909091	2.04545475	Streptococcus	1301	Bacteria	Bacteria	357	3.79e-94	NTclustered	gi\|926460225\|gb\|CP012588.1\|	1308	g18340	i0	97.596	511.226666666667	208	5	92	0	9	216	162489	162696	Streptococcus thermophilus strain MN-BM-A01, complete genome	blastn	115026	357	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
15138922	15138922	PRJNA512103_P_NODE_9452_length_394_cov_1.530435_g9040_i0	PRJNA512103	9452	394	1.530435	6.0299139	Micrococcus	1269	Bacteria	Bacteria	728	0	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g9040	i0	100	239.616751269036	394	0	100	0	1	394	403269	402876	Micrococcus luteus strain ML chromosome, complete genome	blastn	94409	728	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15788165	15788165	PRJNA512103_P_NODE_11493_length_335_cov_1.234266_g11081_i0	PRJNA512103	11493	335	1.234266	4.1347911	Corynebacterium anserum	2684406	Bacteria	Bacteria	383	9.86e-102	NTclustered	gi\|1894829214\|gb\|CP046883.1\|	2684406	g11081	i0	93.462	308.597014925373	260	13	77	2	77	333	115053	115311	Corynebacterium anserum strain 23H37-10 chromosome, complete genome	blastn	103380	383	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium anserum
17688731	17688731	PRJNA512103_P_NODE_32894_length_165_cov_0.896552_g32482_i0	PRJNA512103	32894	165	0.896552	1.4793108	Staphylococcus	1279	Bacteria	Bacteria	268	1.26e-67	NTclustered	gi\|1848617844\|gb\|CP053957.1\|	29388	g32482	i0	99.324	77.4969696969697	148	1	90	0	10	157	1958160	1958013	Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome	blastn	12787	268	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus capitis
18337172	18337172	PRJNA512103_P_NODE_12695_length_308_cov_1.370656_g12283_i0	PRJNA512103	12695	308	1.370656	4.22162048	Hathewaya histolytica	1498	Bacteria	Bacteria	198	3.4899999999999993e-46	NTclustered	gi\|1640036048\|emb\|LR590481.1\|	1498	g12283	i0	81.59	27.7402597402597	239	44	78	0	68	306	1403202	1403440	Hathewaya histolytica strain NCTC503 genome assembly, chromosome: 1	blastn	8544	198	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Hathewaya	Hathewaya histolytica
20237286	20237286	PRJNA512103_P_NODE_16736_length_243_cov_0.958763_g16324_i0	PRJNA512103	16736	243	0.958763	2.32979409	Micrococcus	1269	Bacteria	Bacteria	431	2.4099999999999995e-116	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g16324	i0	99.163	356.958847736626	239	2	98	0	5	243	346129	346367	Micrococcus luteus strain V017 chromosome, complete genome	blastn	86741	431	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
20237299	20237299	PRJNA512103_P_NODE_8676_length_422_cov_2.372654_g8265_i0	PRJNA512103	8676	422	2.372654	10.01259988	Nostocaceae	1162	Bacteria	Bacteria	595	1.5e-165	NTclustered	gi\|75699950\|gb\|CP000117.1\|	240292	g8265	i0	92.736	285.758293838863	413	29	98	1	1	413	1005440	1005029	Anabaena variabilis ATCC 29413, complete genome	blastn	120590	595	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus variabilis
20888112	20888112	PRJNA512103_P_NODE_26197_length_184_cov_0.903704_g25785_i0	PRJNA512103	26197	184	0.903704	1.66281536	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	315	1.81e-81	NTclustered	gi\|2874253711\|emb\|OY969553.1\|	3039803	g25785	i0	98.864	512.934782608696	176	2	96	0	9	184	463098	463273	MAG: uncultured Actinomycetota bacterium isolate MFD04212.bin.1.1 genome assembly, chromosome: 1	blastn	94380	315	1	Bacteria		Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
22162661	22162661	PRJNA512103_P_NODE_21418_length_206_cov_0.942675_g21006_i0	PRJNA512103	21418	206	0.942675	1.9419105	Paenibacillus urinalis	521520	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|2446590601\|gb\|CP118106.1\|	521520	g21006	i0	85.075	19.0582524271845	67	7	32	3	20	84	2087659	2087724	Paenibacillus urinalis strain 2022CK-00833 chromosome, complete genome	blastn	3926	65.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus urinalis
22787892	22787892	PRJNA512103_P_NODE_13858_length_285_cov_0.987288_g13446_i0	PRJNA512103	13858	285	0.987288	2.8137708	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|975008075\|gb\|CP011146.1\|	1396	g13446	i0	100	0.792982456140351	29	0	10	0	190	218	237600	237628	Bacillus cereus strain FORC_013 plasmid pFORC13, complete sequence	blastn	226	54.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
22787894	22787894	PRJNA512103_P_NODE_15238_length_262_cov_1.164319_g14826_i0	PRJNA512103	15238	262	1.164319	3.05051578	Brachybacterium	43668	Bacteria	Bacteria	457	4.34e-124	NTclustered	gi\|1442783620\|gb\|CP031356.1\|	556288	g14826	i0	99.209	265.370229007634	253	2	97	0	10	262	909190	909442	Brachybacterium saurashtrense strain DSM 23186 chromosome, complete genome	blastn	69527	457	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium saurashtrense
24712535	24712535	PRJNA512103_P_NODE_6700_length_526_cov_1.836478_g6296_i0	PRJNA512103	6700	526	1.836478	9.65987428	uncultured Anaerolineaceae bacterium	310067	Bacteria	Bacteria	835	0	NTclustered	gi\|339830809\|gb\|JN038290.1\|	310067	g6296	i0	95.922	98.0038022813688	515	21	98	0	10	524	738	224	Uncultured Anaerolineaceae bacterium clone EK_Ca689 16S ribosomal RNA gene, partial sequence	blastn	51550	835	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		uncultured Anaerolineaceae bacterium
25337264	25337264	PRJNA512103_P_NODE_1760_length_1349_cov_2.340769_g1565_i0	PRJNA512103	1760	1349	2.340769	31.57697381	Nostocales	1161	Bacteria	Bacteria	1013	0	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g1565	i0	96.135	263.352853965901	621	22	86	2	9	629	8016240	8015622	Tolypothrix sp. PCC 7601 chromosome, complete genome	blastn	355263	1018	0.995088408644401	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7601

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