metadata: contig_metadata: 21 rows where bioproject = "PRJNA1011833" and tax

21 rows where bioproject = "PRJNA1011833" and tax_phylum = "Bacillota"

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
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
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
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
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
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
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
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
27445814	27445814	PRJNA1011833_S_NODE_28223_length_223_cov_1.038889_g27803_i0	PRJNA1011833	28223	223	1.038889	2.31672247	unclassified Amedibacterium	3088137	Bacteria	Bacteria	42	0.05	NR	WP_233511338.1	3088137	g27803	i0	42.6	0.726457399103139	54	27	70	3	19	174	188	239	WP_233511338.1 MULTISPECIES: hypothetical protein [unclassified Amedibacterium]	diamond	162	42	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Amedibacterium
27824571	27824571	PRJNA1011833_S_NODE_34104_length_200_cov_2.369427_g33684_i0	PRJNA1011833	34104	200	2.369427	4.738854	Holdemanella biformis	1735	Bacteria	Bacteria	43.1	0.0155	NR	WP_227976277.1	1735	g33684	i0	39	1.23	82	31	97.5	3	5	199	153	232	WP_227976277.1 glycoside hydrolase family 13 protein [Holdemanella biformis]	diamond	246	43.1	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Holdemanella	Holdemanella biformis
28006468	28006468	PRJNA1011833_S_NODE_51585_length_161_cov_1.220339_g51165_i0	PRJNA1011833	51585	161	1.220339	1.96474579	Clostridia	186801	Bacteria	Bacteria	100	4.53e-24	NR	MCI5596461.1	1898203	g51165	i0	81.1	18.6335403726708	53	10	98.8	0	3	161	131	183	MCI5596461.1 UDP-glucose 4-epimerase GalE [Lachnospiraceae bacterium]	diamond	3000	101	0.99009900990099	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
28606128	28606128	PRJNA1011833_S_NODE_10727_length_360_cov_5.182965_g10308_i0	PRJNA1011833	10727	360	5.182965	18.658674	Bacteria	2	Bacteria	Bacteria	58.9	2.67e-7	NR	WP_029699112.1	1391647	g10308	i0	32.2	5.675	115	69	93.3	6	359	24	122	230	WP_029699112.1 DEAD/DEAH box helicase [Clostridium sp. Ade.TY]	diamond	2043	58.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. Ade.TY
29268978	29268978	PRJNA1011833_S_NODE_55349_length_155_cov_1.196429_g54929_i0	PRJNA1011833	55349	155	1.196429	1.85446495	root	1	Root_unresolved	Root_unresolved	42.7	0.00609	NR	WP_262458101.1	1496	g54929	i0	48.7	3.01935483870968	39	17	69.7	1	42	149	68	106	WP_262458101.1 endonuclease/exonuclease/phosphatase family protein [Clostridioides difficile]	diamond	468	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
29710860	29710860	PRJNA1011833_S_NODE_11310_length_352_cov_8.896440_g10890_i0	PRJNA1011833	11310	352	8.89644	31.3154688	Bacteria	2	Bacteria	Bacteria	112	8.130000000000001e-27	NR	WP_221880430.1	1399	g10890	i0	50.5	15.7244318181818	103	51	87.8	0	344	36	305	407	WP_221880430.1 NAD-dependent succinate-semialdehyde dehydrogenase, partial [Cytobacillus firmus]	diamond	5535	113	0.991150442477876	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus firmus
30698122	30698122	PRJNA1011833_S_NODE_16594_length_297_cov_1.854331_g16174_i0	PRJNA1011833	16594	297	1.854331	5.50736307	Leuconostoc pseudomesenteroides	33968	Bacteria	Bacteria	43.5	0.0158	NR	WP_349550031.1	33968	g16174	i0	27.2	0.818181818181818	81	53	77.8	2	51	281	30	108	WP_349550031.1 single-stranded DNA-binding protein [Leuconostoc pseudomesenteroides]	diamond	243	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc pseudomesenteroides
31267030	31267030	PRJNA1011833_S_NODE_38515_length_188_cov_0.958621_g38095_i0	PRJNA1011833	38515	188	0.958621	1.80220748	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.7	0.0174	NR	MCC8043763.1	2485925	g38095	i0	40.5	0.670212765957447	42	24	65.4	1	137	15	100	141	MCC8043763.1 sugar phosphate isomerase/epimerase [Oscillospiraceae bacterium]	diamond	126	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32057768	32057768	PRJNA1011833_S_NODE_5418_length_455_cov_12.621359_g5006_i0	PRJNA1011833	5418	455	12.621359	57.42718345	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	87.4	3.45e-19	NR	MBQ5561215.1	1898203	g5006	i0	40.7	1.21978021978022	86	51	56.7	0	292	35	16	101	MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium]	diamond	555	87.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium

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