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

22 rows where analysis = "blastn", bioproject = "PRJNA1011833" 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
1430235	1430235	PRJNA1011833_S_NODE_41722_length_180_cov_1.255474_g41302_i0	PRJNA1011833	41722	180	1.255474	2.2598532	Microcystis aeruginosa	1126	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2924414\|emb\|AJ224715.1\|	267867	g41302	i0	100	0.155555555555556	28	0	16	0	93	120	508	535	Microcystis aeruginosa gene encoding peptide synthetase, strain PCC7820, partial	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
2705566	2705566	PRJNA1011833_S_NODE_19383_length_274_cov_3.212121_g18963_i0	PRJNA1011833	19383	274	3.212121	8.80121154	Brochothrix thermosphacta	2756	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2688293211\|gb\|CP145608.1\|	1121126	g18963	i0	100	0.102189781021898	28	0	10	0	10	37	2383089	2383062	Brochothrix thermosphacta DSM 20171 = FSL F6-1036 strain DSM 20171 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Brochothrix	Brochothrix thermosphacta
3552168	3552168	PRJNA1011833_S_NODE_29863_length_216_cov_1.109827_g29443_i0	PRJNA1011833	29863	216	1.109827	2.39722632	Kurthia	1649	Bacteria	Bacteria	399	5.909999999999999e-107	NTclustered	gi\|2700494444\|gb\|CP147847.1\|	33946	g29443	i0	100	991.555555555556	216	0	100	0	1	216	94817	94602	Kurthia gibsonii strain ND2 chromosome, complete genome	blastn	214176	399	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Kurthia	Kurthia gibsonii
3552175	3552175	PRJNA1011833_S_NODE_37323_length_191_cov_1.195946_g36903_i0	PRJNA1011833	37323	191	1.195946	2.28425686	Paenibacillus	44249	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|2886624468\|gb\|CP177044.1\|	1401	g36903	i0	100	1014.34031413613	191	0	100	0	1	191	14537	14727	Paenibacillus lautus strain MPB09 chromosome, complete genome	blastn	193739	353	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus lautus
4829618	4829618	PRJNA1011833_S_NODE_57264_length_153_cov_0.872727_g56844_i0	PRJNA1011833	57264	153	0.872727	1.33527231	Corynebacterium	1716	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g56844	i0	100	377.764705882353	153	0	100	0	1	153	293976	294128	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	57798	283	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
6533703	6533703	PRJNA1011833_S_NODE_60306_length_150_cov_1.794393_g59886_i0	PRJNA1011833	60306	150	1.794393	2.6915895	Mycoplasma wenyonii	65123	Bacteria	Bacteria	267	4.009999999999999e-67	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g59886	i0	98.667	1	150	2	100	0	1	150	232348	232199	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	150	267	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7807970	7807970	PRJNA1011833_S_NODE_34307_length_200_cov_1.152866_g33887_i0	PRJNA1011833	34307	200	1.152866	2.305732	Roseburia rectibacter	2763062	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2206258461\|gb\|CP092473.1\|	2763062	g33887	i0	96.97	0.165	33	1	17	0	167	199	2892662	2892630	Roseburia rectibacter strain NSJ-69 chromosome, complete genome	blastn	33	56.5	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia rectibacter
8654740	8654740	PRJNA1011833_S_NODE_947_length_849_cov_2.070720_g718_i0	PRJNA1011833	947	849	2.07072	17.5804128	root	1	Root_unresolved	Root_unresolved	1520	0	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g718	i0	99.055	147.262661955241	847	8	99	0	3	849	1086	240	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	125026	1526	0.996068152031455	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10358594	10358594	PRJNA1011833_S_NODE_44949_length_173_cov_1.476923_g44529_i0	PRJNA1011833	44949	173	1.476923	2.55507679	Bacillus cereus	1396	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2212326042\|gb\|CP093928.1\|	1396	g44529	i0	100	10	173	0	100	0	1	173	964299	964471	Bacillus cereus strain AH7-7 chromosome, complete genome	blastn	1730	320	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
11634069	11634069	PRJNA1011833_S_NODE_45570_length_172_cov_1.116279_g45150_i0	PRJNA1011833	45570	172	1.116279	1.91999988	Mycoplasma wenyonii	65123	Bacteria	Bacteria	302	1.3e-77	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g45150	i0	98.256	1	172	3	100	0	1	172	149450	149279	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	172	302	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
12480412	12480412	PRJNA1011833_S_NODE_37450_length_190_cov_2.802721_g37030_i0	PRJNA1011833	37450	190	2.802721	5.3251699	root	1	Root_unresolved	Root_unresolved	346	6.690000000000001e-91	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g37030	i0	99.474	100.705263157895	190	1	100	0	1	190	2729976	2729787	Staphylococcus aureus strain WH3018 chromosome	blastn	19134	346	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
12909150	12909150	PRJNA1011833_S_NODE_47031_length_169_cov_1.142857_g46611_i0	PRJNA1011833	47031	169	1.142857	1.93142833	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g46611	i0	98.817	290.940828402367	169	2	100	0	1	169	1857378	1857210	Calothrix sp. PCC 7716 DNA, complete genome	blastn	49169	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
15029350	15029350	PRJNA1011833_S_NODE_4132_length_495_cov_2.736726_g3731_i0	PRJNA1011833	4132	495	2.736726	13.5467937	Bacillus	1386	Bacteria	Bacteria	909	0	NTclustered	gi\|1297880378\|gb\|CP024655.1\|	1396	g3731	i0	99.798	1246.22828282828	495	1	100	0	1	495	5333572	5333078	Bacillus cereus strain MLY1 chromosome MLY1.0, complete sequence	blastn	616883	909	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
16732471	16732471	PRJNA1011833_S_NODE_54534_length_156_cov_1.274336_g54114_i0	PRJNA1011833	54534	156	1.274336	1.98796416	Microbacterium sp. PM5	2014534	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|1419380645\|gb\|CP022162.1\|	2014534	g54114	i0	100	158.00641025641	156	0	100	0	1	156	1408598	1408443	Microbacterium sp. PM5 genome	blastn	24649	289	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. PM5
17579448	17579448	PRJNA1011833_S_NODE_13214_length_331_cov_1.322917_g12794_i0	PRJNA1011833	13214	331	1.322917	4.37885527	Bacillus	1386	Bacteria	Bacteria	612	1.14e-170	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g12794	i0	100	1233.25679758308	331	0	100	0	1	331	13159	12829	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	408208	612	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
20128049	20128049	PRJNA1011833_S_NODE_46336_length_170_cov_1.889764_g45916_i0	PRJNA1011833	46336	170	1.889764	3.2125988	root	1	Root_unresolved	Root_unresolved	309	7.64e-80	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g45916	i0	99.412	97.6058823529412	170	1	100	0	1	170	2741958	2742127	Staphylococcus aureus strain WH3018 chromosome	blastn	16593	309	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
20556524	20556524	PRJNA1011833_S_NODE_25037_length_238_cov_1.451282_g24617_i0	PRJNA1011833	25037	238	1.451282	3.45405116	Cutibacterium modestum	2559073	Bacteria	Bacteria	353	5.23e-93	NTclustered	gi\|1061027374\|gb\|CP017040.1\|	2559073	g24617	i0	94.043	283.445378151261	235	10	98	4	6	238	776437	776205	Cutibacterium modestum strain F0672, complete sequence	blastn	67460	353	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium modestum
20556732	20556732	PRJNA1011833_S_NODE_60557_length_150_cov_1.345794_g60137_i0	PRJNA1011833	60557	150	1.345794	2.018691	Mycoplasma wenyonii	65123	Bacteria	Bacteria	255	8.680000000000001e-64	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g60137	i0	97.333	1	150	4	100	0	1	150	454718	454867	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	150	255	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21832290	21832290	PRJNA1011833_S_NODE_50138_length_163_cov_2.000000_g49718_i0	PRJNA1011833	50138	163	2	3.26	Cohnella candidum	2674991	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1509749284\|gb\|CP033433.1\|	2674991	g49718	i0	100	0.171779141104294	28	0	17	0	87	114	4911098	4911071	Cohnella candidum strain 18JY8-7 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella candidum
23107808	23107808	PRJNA1011833_S_NODE_48559_length_166_cov_1.560976_g48139_i0	PRJNA1011833	48559	166	1.560976	2.59122016	Mycoplasma wenyonii	65123	Bacteria	Bacteria	215	1.68e-51	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g48139	i0	93.197	37.5963855421687	147	9	89	1	1	147	52236	52381	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	6241	215	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23953923	23953923	PRJNA1011833_S_NODE_18779_length_279_cov_2.440678_g18359_i0	PRJNA1011833	18779	279	2.440678	6.80949162	Microbacterium	33882	Bacteria	Bacteria	510	3.5299999999999996e-140	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g18359	i0	99.642	186.372759856631	279	1	100	0	1	279	551	273	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	51998	510	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
23953950	23953950	PRJNA1011833_S_NODE_53279_length_158_cov_1.252174_g52859_i0	PRJNA1011833	53279	158	1.252174	1.97843492	Paenibacillus	44249	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|686561105\|gb\|CP009428.1\|	189426	g52859	i0	100	1135.99367088608	158	0	100	0	1	158	16029	15872	Paenibacillus odorifer strain DSM 15391, complete genome	blastn	179487	292	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus odorifer

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