metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1215813" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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
1045797	1045797	PRJNA1215813_P_NODE_2141_length_507_cov_2.836406_g2061_i0	PRJNA1215813	2141	507	2.836406	14.38057842	Nocardiaceae	85025	Bacteria	Bacteria	937	0	NTclustered	gi\|2589057681\|gb\|CP135915.1\|	293050	g2061	i0	100	392.483234714004	507	0	100	0	1	507	436172	436678	Rhodococcoides kroppenstedtii strain K07-23T chromosome, complete genome	blastn	198989	937	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides kroppenstedtii
2321142	2321142	PRJNA1215813_P_NODE_10902_length_248_cov_0.891429_g10822_i0	PRJNA1215813	10902	248	0.891429	2.21074392	Cellulomonas	1707	Bacteria	Bacteria	80.5	1.03e-10	NTclustered	gi\|1540063786\|emb\|LR134387.1\|	1708	g10822	i0	87.143	7.20161290322581	70	9	28	0	171	240	1562157	1562226	Cellulomonas fimi strain NCTC7547 genome assembly, chromosome: 1	blastn	1786	80.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas fimi
2882650	2882650	PRJNA1215813_P_NODE_12523_length_242_cov_0.923077_g12443_i0	PRJNA1215813	12523	242	0.923077	2.23384634	Christensenella sp.	1935934	Bacteria	Bacteria	300	7.05e-77	NTclustered	gi\|2189457697\|gb\|CP091723.1\|	1935934	g12443	i0	91.031	854.681818181818	223	19	92	1	19	240	544776	544554	MAG: Christensenella sp. isolate nC33_lr_bin.267.fa chromosome	blastn	206833	300	1	Bacteria		Bacillati	Bacillota	Clostridia	Christensenellales	Christensenellaceae	Christensenella	Christensenella sp.
2882713	2882713	PRJNA1215813_P_NODE_5643_length_327_cov_1.228346_g5563_i0	PRJNA1215813	5643	327	1.228346	4.01669142	Lentzea guizhouensis	1586287	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1050298341\|gb\|CP016793.1\|	1586287	g5563	i0	92.105	0.201834862385321	38	3	12	0	38	75	7713625	7713588	Lentzea guizhouensis strain DHS C013 chromosome, complete genome	blastn	66	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Lentzea	Lentzea guizhouensis
2882753	2882753	PRJNA1215813_P_NODE_7623_length_284_cov_2.218009_g7543_i0	PRJNA1215813	7623	284	2.218009	6.29914556	Synechococcus sp. CBW1107	2789857	Bacteria	Bacteria	137	7.04e-28	NTclustered	gi\|2638498304\|emb\|OY986430.1\|	2789857	g7543	i0	79	12.669014084507	200	42	70	0	41	240	1782203	1782402	Synechococcus sp. CBW1107 isolate KAC_114 genome assembly, chromosome: 1	blastn	3598	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
4158755	4158755	PRJNA1215813_P_NODE_2704_length_459_cov_1.098446_g2624_i0	PRJNA1215813	2704	459	1.098446	5.04186714	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	60.2	2.66e-4	NTclustered	gi\|2893356068\|emb\|OZ220491.1\|	2201156	g2624	i0	97.143	0.137254901960784	35	1	8	0	215	249	2527342	2527376	MAG: Acidimicrobiales bacterium isolate 383ba79e-94a5-4396-b72d-754c03a60d81 genome assembly, chromosome: 1	blastn	63	60.2	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
7985103	7985103	PRJNA1215813_P_NODE_12027_length_244_cov_0.912281_g11947_i0	PRJNA1215813	12027	244	0.912281	2.22596564	Lentzea sp. JNUCC 0626	3367513	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2837414742\|gb\|CP171635.1\|	3367513	g11947	i0	100	0.241803278688525	31	0	13	0	144	174	6040136	6040106	Lentzea sp. JNUCC 0626 strain JNUCC chromosome, complete genome	blastn	59	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Lentzea	Lentzea sp. JNUCC 0626
10535534	10535534	PRJNA1215813_P_NODE_10429_length_249_cov_0.886364_g10349_i0	PRJNA1215813	10429	249	0.886364	2.20704636	Streptomyces sp. NBC_00582	2975783	Bacteria	Bacteria	195	3.5399999999999996e-45	NTclustered	gi\|2667469075\|gb\|CP107772.1\|	2975783	g10349	i0	80.8	76.8714859437751	250	46	100	2	1	249	6486101	6485853	Streptomyces sp. NBC_00582 chromosome, complete genome	blastn	19141	195	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00582
10535561	10535561	PRJNA1215813_P_NODE_12609_length_241_cov_2.321429_g12529_i0	PRJNA1215813	12609	241	2.321429	5.59464389	Clostridium cadaveris	1529	Bacteria	Bacteria	71.3	5.99e-8	NTclustered	gi\|2154003691\|gb\|CP076620.1\|	1529	g12529	i0	90.566	0.219917012448133	53	5	22	0	41	93	2478644	2478696	Clostridium cadaveris strain IFB3C5 chromosome, complete genome	blastn	53	71.3	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium cadaveris
11810375	11810375	PRJNA1215813_P_NODE_11890_length_244_cov_0.912281_g11810_i0	PRJNA1215813	11890	244	0.912281	2.22596564	Streptomyces sp. Je 1-369	2966192	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2410828879\|gb\|CP101750.1\|	2966192	g11810	i0	100	0.114754098360656	28	0	11	0	162	189	2438542	2438515	Streptomyces sp. Je 1-369 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Je 1-369
13085355	13085355	PRJNA1215813_P_NODE_11631_length_245_cov_0.906977_g11551_i0	PRJNA1215813	11631	245	0.906977	2.22209365	Brevibacillus brevis	1393	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1539922203\|emb\|LR134338.1\|	1393	g11551	i0	100	0.228571428571429	28	0	11	0	152	179	2323372	2323345	Brevibacillus brevis strain NCTC2611 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus brevis
15073409	15073409	PRJNA1215813_P_NODE_10832_length_248_cov_0.891429_g10752_i0	PRJNA1215813	10832	248	0.891429	2.21074392	root	1	Root_unresolved	Root_unresolved	459	1.13e-124	NTclustered	gi\|1663099664\|gb\|CP039167.1\|	1280	g10752	i0	100	100	248	0	100	0	1	248	2842784	2843031	Staphylococcus aureus strain R50 chromosome, complete genome	blastn	24800	459	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
15073430	15073430	PRJNA1215813_P_NODE_7412_length_288_cov_1.451163_g7332_i0	PRJNA1215813	7412	288	1.451163	4.17934944	Nocardiaceae	85025	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2589057681\|gb\|CP135915.1\|	293050	g7332	i0	100	398.6875	288	0	100	0	1	288	435542	435829	Rhodococcoides kroppenstedtii strain K07-23T chromosome, complete genome	blastn	114822	532	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides kroppenstedtii
16348311	16348311	PRJNA1215813_P_NODE_8233_length_273_cov_1.465000_g8153_i0	PRJNA1215813	8233	273	1.465	3.99945	root	1	Root_unresolved	Root_unresolved	488	1.6099999999999996e-133	NTclustered	gi\|2484084529\|gb\|CP121497.1\|	1282	g8153	i0	98.901	152	273	3	100	0	1	273	896904	897176	Staphylococcus epidermidis strain 24FSE04 chromosome, complete genome	blastn	41496	488	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
18897336	18897336	PRJNA1215813_P_NODE_7895_length_279_cov_3.053398_g7815_i0	PRJNA1215813	7895	279	3.053398	8.51898042	Streptomyces	1883	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2028478505\|gb\|CP073042.1\|	371608	g7815	i0	100	0.211469534050179	28	0	10	0	78	105	4017220	4017247	Streptomyces philanthi bv. triangulum 23Af2, complete genome sequence	blastn	59	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Candidatus Streptomyces philanthi
19457725	19457725	PRJNA1215813_P_NODE_11216_length_247_cov_0.896552_g11136_i0	PRJNA1215813	11216	247	0.896552	2.21448344	Streptacidiphilus sp. P02-A3a	2704468	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1886153837\|gb\|CP048289.1\|	2704468	g11136	i0	96.774	0.125506072874494	31	1	13	0	135	165	8541783	8541753	Streptacidiphilus sp. P02-A3a chromosome, complete genome	blastn	31	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptacidiphilus	Streptacidiphilus sp. P02-A3a
20733148	20733148	PRJNA1215813_P_NODE_12057_length_243_cov_1.823529_g11977_i0	PRJNA1215813	12057	243	1.823529	4.43117547	uncultured Thermoleophilaceae bacterium	349283	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2874253973\|emb\|OY970298.1\|	349283	g11977	i0	100	0.11522633744856	28	0	12	0	178	205	915212	915239	MAG: uncultured Thermoleophilaceae bacterium isolate MFD04935.bin.1.10 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Thermoleophilales	Thermoleophilaceae		uncultured Thermoleophilaceae bacterium
21447702	21447702	PRJNA1215813_P_NODE_5217_length_338_cov_1.132075_g5137_i0	PRJNA1215813	5217	338	1.132075	3.8264135	Fimbriimonas	1005038	Bacteria	Bacteria	422	2.11e-113	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g5137	i0	89.381	143.786982248521	339	31	100	4	1	338	28703	28369	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	48600	422	1	Bacteria		Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
22008385	22008385	PRJNA1215813_P_NODE_11018_length_247_cov_0.896552_g10938_i0	PRJNA1215813	11018	247	0.896552	2.21448344	Arthrobacter sp. NicSoilC5	2831000	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2089593438\|dbj\|AP024660.1\|	2831000	g10938	i0	94.118	0.137651821862348	34	2	14	0	76	109	1894775	1894742	Arthrobacter sp. NicSoilC5 DNA, complete genome	blastn	34	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. NicSoilC5
24557868	24557868	PRJNA1215813_P_NODE_1000_length_719_cov_4.168731_g927_i0	PRJNA1215813	1000	719	4.168731	29.97317589	Clavibacter seminis	2860285	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2187984480\|gb\|CP083439.1\|	2860285	g927	i0	100	0.0848400556328234	31	0	4	0	571	601	2714627	2714657	Clavibacter sp. A6099 chromosome, complete genome	blastn	61	58.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter seminis
24557935	24557935	PRJNA1215813_P_NODE_4420_length_364_cov_2.000000_g4340_i0	PRJNA1215813	4420	364	2	7.28	Fictibacillus sp. KU28468	2991053	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2328448629\|gb\|CP110666.1\|	2991053	g4340	i0	100	0.0769230769230769	28	0	8	0	288	315	3334048	3334075	Fictibacillus sp. KU28468 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Fictibacillaceae	Fictibacillus	Fictibacillus sp. KU28468
24558021	24558021	PRJNA1215813_P_NODE_9760_length_252_cov_0.871508_g9680_i0	PRJNA1215813	9760	252	0.871508	2.19620016	Laceyella sacchari	37482	Bacteria	Bacteria	335	2.0299999999999998e-87	NTclustered	gi\|2294964232\|gb\|CP103866.1\|	37482	g9680	i0	90.8	767.531746031746	250	23	99	0	1	250	114066	113817	Laceyella sacchari strain FBKL4.014 chromosome, complete genome	blastn	193418	335	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Laceyella	Laceyella sacchari

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