metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA217180" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA217180" 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
1641876	1641876	PRJNA217180_P_NODE_14882_length_162_cov_0.902655_g14782_i0	PRJNA217180	14882	162	0.902655	1.4623011	Aurantimicrobium photophilum	1987356	Bacteria	Bacteria	171	3.57e-38	NTclustered	gi\|1395829960\|gb\|CP023994.1\|	1987356	g14782	i0	89.13	0.851851851851852	138	14	85	1	5	142	1364261	1364397	Aurantimicrobium photophilum strain MWH-Mo1 chromosome, complete genome	blastn	138	171	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aurantimicrobium	Aurantimicrobium photophilum
2331330	2331330	PRJNA217180_P_NODE_2842_length_338_cov_1.688581_g2742_i0	PRJNA217180	2842	338	1.688581	5.70740378	Cutibacterium	1912216	Bacteria	Bacteria	625	1.4999999999999999e-174	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2742	i0	100	248.822485207101	338	0	100	0	1	338	55368	55705	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	84102	625	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3606535	3606535	PRJNA217180_P_NODE_5863_length_241_cov_2.463542_g5763_i0	PRJNA217180	5863	241	2.463542	5.93713622	Brevibacterium	1696	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|1948580264\|gb\|CP065989.1\|	33889	g5763	i0	99.174	358.717842323651	242	1	100	1	1	241	1415520	1415279	Brevibacterium casei strain FDAARGOS_990 chromosome, complete genome	blastn	86451	435	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
4194181	4194181	PRJNA217180_P_NODE_14364_length_163_cov_0.894737_g14264_i0	PRJNA217180	14364	163	0.894737	1.45842131	Streptococcus cristatus	45634	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1823511124\|gb\|CP050133.1\|	889201	g14264	i0	98.773	96.4662576687117	163	2	100	0	1	163	2020424	2020586	Streptococcus cristatus ATCC 51100 chromosome, complete genome	blastn	15724	291	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus cristatus
6158767	6158767	PRJNA217180_P_NODE_4345_length_275_cov_0.902655_g4245_i0	PRJNA217180	4345	275	0.902655	2.48230125	Cutibacterium	1912216	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2493043383\|gb\|CP114012.1\|	1747	g4245	i0	100	50.9854545454545	275	0	100	0	1	275	1581626	1581900	Cutibacterium acnes strain CBS-BPNBT19269 chromosome, complete genome	blastn	14021	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6158775	6158775	PRJNA217180_P_NODE_9765_length_188_cov_1.467626_g9665_i0	PRJNA217180	9765	188	1.467626	2.75913688	Cutibacterium	1912216	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9665	i0	100	94.5265957446808	188	0	100	0	1	188	2087701	2087888	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	17771	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6744709	6744709	PRJNA217180_P_NODE_10706_length_181_cov_1.545455_g10606_i0	PRJNA217180	10706	181	1.545455	2.79727355	Amycolatopsis sp. EV170708-02-1	2919322	Bacteria	Bacteria	84.2	5.45e-12	NTclustered	gi\|2203495119\|gb\|CP092497.1\|	2919322	g10606	i0	87.5	1.15469613259669	72	9	40	0	44	115	5076822	5076751	Amycolatopsis sp. EV170708-02-1 chromosome	blastn	209	84.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. EV170708-02-1
8020494	8020494	PRJNA217180_P_NODE_13347_length_165_cov_0.879310_g13247_i0	PRJNA217180	13347	165	0.87931	1.4508615	Micrococcus antarcticus	86171	Bacteria	Bacteria	255	9.8e-64	NTclustered	gi\|2851356301\|gb\|CP085253.1\|	86171	g13247	i0	94.545	2	165	9	100	0	1	165	162194	162030	Micrococcus antarcticus strain ABH-515 chromosome, complete genome	blastn	330	255	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus antarcticus
8020514	8020514	PRJNA217180_P_NODE_4787_length_264_cov_0.948837_g4687_i0	PRJNA217180	4787	264	0.948837	2.50492968	Brevibacterium epidermidis	1698	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|39466\|emb\|X13555.1\|	1698	g4687	i0	100	1	264	0	100	0	1	264	543	806	Brevibacterium epidermidis BepI modification methylase gene	blastn	264	488	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium epidermidis
8708744	8708744	PRJNA217180_P_NODE_8347_length_204_cov_1.548387_g8247_i0	PRJNA217180	8347	204	1.548387	3.15870948	Geobacillus	129337	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|2529062746\|gb\|CP128458.1\|	1422	g8247	i0	100	918.470588235294	204	0	100	0	1	204	14224	14427	Geobacillus stearothermophilus strain EF60133 chromosome, complete genome	blastn	187368	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
10571208	10571208	PRJNA217180_P_NODE_9929_length_187_cov_1.442029_g9829_i0	PRJNA217180	9929	187	1.442029	2.69659423	Pseudarthrobacter oxydans	1671	Bacteria	Bacteria	302	1.44e-77	NTclustered	gi\|2666964057\|dbj\|AP029193.1\|	1671	g9829	i0	95.722	86.0534759358289	187	8	100	0	1	187	3229802	3229988	Pseudarthrobacter oxydans JCM 2521 DNA, complete genome	blastn	16092	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
11259267	11259267	PRJNA217180_P_NODE_9829_length_188_cov_1.129496_g9729_i0	PRJNA217180	9829	188	1.129496	2.12345248	Cutibacterium	1912216	Bacteria	Bacteria	342	8.539999999999999e-90	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g9729	i0	99.468	51	188	1	100	0	1	188	992157	991970	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	9588	342	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
11845673	11845673	PRJNA217180_P_NODE_15470_length_161_cov_0.910714_g15370_i0	PRJNA217180	15470	161	0.910714	1.46624954	Janibacter sp. CX7	2963431	Bacteria	Bacteria	276	7.29e-70	NTclustered	gi\|2274439729\|gb\|CP101464.1\|	2963431	g15370	i0	97.516	9.46583850931677	161	4	100	0	1	161	2138097	2138257	Janibacter sp. CX7 chromosome, complete genome	blastn	1524	276	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter sp. CX7
12534646	12534646	PRJNA217180_P_NODE_11230_length_176_cov_1.606299_g11130_i0	PRJNA217180	11230	176	1.606299	2.82708624	Cutibacterium	1912216	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11130	i0	100	61.9886363636364	176	0	100	0	1	176	2094194	2094019	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10910	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
14396141	14396141	PRJNA217180_P_NODE_13332_length_165_cov_0.879310_g13232_i0	PRJNA217180	13332	165	0.87931	1.4508615	Candidatus Avichristensenella intestinipullorum	2840693	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2729058690\|emb\|OZ006990.1\|	2840693	g13232	i0	94.444	0.218181818181818	36	1	22	1	92	127	2040746	2040712	MAG: Candidatus Avichristensenella intestinipullorum isolate metabat2_pooled_hifiasm.151 MAG genome assembly, chromosome: 1	blastn	36	54.7	1	Bacteria	Bacillati	Bacillota	Clostridia			Candidatus Avichristensenella	Candidatus Avichristensenella intestinipullorum
15083613	15083613	PRJNA217180_P_NODE_15892_length_153_cov_2.192308_g15792_i0	PRJNA217180	15892	153	2.192308	3.35423124	Cutibacterium	1912216	Bacteria	Bacteria	171	3.32e-38	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g15792	i0	100	50.6666666666667	92	0	99	0	1	92	1280630	1280721	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	7752	171	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17633653	17633653	PRJNA217180_P_NODE_2394_length_372_cov_0.857585_g2294_i0	PRJNA217180	2394	372	0.857585	3.1902162	Corynebacterium	1716	Bacteria	Bacteria	604	2.17e-168	NTclustered	gi\|2550471320\|gb\|CP100376.1\|	38284	g2294	i0	96.467	374.922043010753	368	9	98	3	1	366	2342295	2342660	Corynebacterium accolens strain CA7 chromosome	blastn	139471	610	0.99016393442623	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
18907502	18907502	PRJNA217180_P_NODE_13475_length_165_cov_0.879310_g13375_i0	PRJNA217180	13475	165	0.87931	1.4508615	Streptococcus	1301	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g13375	i0	100	563.163636363636	165	0	100	0	1	165	17959	18123	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	92922	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
20768656	20768656	PRJNA217180_P_NODE_9757_length_188_cov_1.467626_g9657_i0	PRJNA217180	9757	188	1.467626	2.75913688	Corynebacterium sp. LaCa117	3391424	Bacteria	Bacteria	348	1.84e-91	NTclustered	gi\|2888572763\|gb\|CP177102.1\|	3391424	g9657	i0	100	36.313829787234	188	0	100	0	1	188	1137552	1137739	Corynebacterium sp. LaCa117 chromosome, complete genome	blastn	6827	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. LaCa117
21457787	21457787	PRJNA217180_P_NODE_14857_length_162_cov_0.902655_g14757_i0	PRJNA217180	14857	162	0.902655	1.4623011	Cutibacterium	1912216	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g14757	i0	100	51	162	0	100	0	1	162	1919862	1920023	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	8262	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22043657	22043657	PRJNA217180_P_NODE_13058_length_166_cov_0.871795_g12958_i0	PRJNA217180	13058	166	0.871795	1.4471797	Candidatus Planktophila sulfonica	1884904	Bacteria	Bacteria	235	1.2899999999999998e-57	NTclustered	gi\|1240552849\|gb\|CP016773.1\|	1884904	g12958	i0	92.216	5.01807228915663	167	11	100	2	1	166	1320637	1320802	Candidatus Planktophila sulfonica, complete genome	blastn	833	235	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales	Candidatus Nanopelagicaceae	Candidatus Planktophila	Candidatus Planktophila sulfonica
22732812	22732812	PRJNA217180_P_NODE_10318_length_184_cov_1.466667_g10218_i0	PRJNA217180	10318	184	1.466667	2.69866728	Cutibacterium	1912216	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10218	i0	100	62.820652173913	184	0	100	0	1	184	2233440	2233257	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	11559	340	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23319144	23319144	PRJNA217180_P_NODE_10079_length_186_cov_1.138686_g9979_i0	PRJNA217180	10079	186	1.138686	2.11795596	Staphylococcus cohnii	29382	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|1373834432\|emb\|LT963440.1\|	29382	g9979	i0	100	54.2311827956989	186	0	100	0	1	186	1302308	1302493	Staphylococcus cohnii isolate Staphylococcus cohnii ATCC 29974 genome assembly, chromosome: I	blastn	10087	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
24008001	24008001	PRJNA217180_P_NODE_4159_length_280_cov_4.588745_g4059_i0	PRJNA217180	4159	280	4.588745	12.848486	Cutibacterium	1912216	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4059	i0	99.643	268.228571428571	280	1	100	0	1	280	56469	56190	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	75104	512	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24008005	24008005	PRJNA217180_P_NODE_6739_length_227_cov_1.432584_g6639_i0	PRJNA217180	6739	227	1.432584	3.25196568	Micrococcus	1269	Bacteria	Bacteria	409	1.04e-109	NTclustered	gi\|2873038046\|gb\|CP176570.1\|	1270	g6639	i0	99.119	355.004405286344	227	2	100	0	1	227	1554637	1554863	Micrococcus luteus strain SZ.RS01 chromosome, complete genome	blastn	80586	409	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25282122	25282122	PRJNA217180_P_NODE_15540_length_161_cov_0.910714_g15440_i0	PRJNA217180	15540	161	0.910714	1.46624954	root	1	Root_unresolved	Root_unresolved	298	1.56e-76	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g15440	i0	100	5.95652173913043	161	0	100	0	1	161	355148	355308	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	959	298	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis

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