metadata: contig_metadata: 23 rows where bioproject = "PRJNA1215813" and tax

23 rows where bioproject = "PRJNA1215813" 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
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.
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
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
15634675	15634675	PRJNA1215813_P_NODE_2373_length_484_cov_1.343066_g2293_i0	PRJNA1215813	2373	484	1.343066	6.50043944	Eubacteriales bacterium	2831996	Bacteria	Bacteria	182	3.739999999999999e-52	NR	MDD4121937.1	2831996	g2293	i0	56.7	5.04545454545455	164	60	99.8	3	2	484	268	423	MDD4121937.1 asparagine--tRNA ligase [Eubacteriales bacterium]	diamond	2442	182	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
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
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
26724057	26724057	PRJNA1215813_P_NODE_6261_length_312_cov_1.305439_g6181_i0	PRJNA1215813	6261	312	1.305439	4.07296968	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	52.4	3.57e-6	NR	MCR4856049.1	2049044	g6181	i0	41.5	2.69230769230769	65	35	62.5	1	202	8	19	80	MCR4856049.1 YbaB/EbfC family nucleoid-associated protein [Erysipelotrichaceae bacterium]	diamond	840	52.4	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae bacterium
27483501	27483501	PRJNA1215813_P_NODE_8623_length_265_cov_1.625000_g8543_i0	PRJNA1215813	8623	265	1.625	4.30625	Clostridiaceae bacterium M8S5	3035240	Bacteria	Bacteria	118	1.71e-29	NR	WDV47814.1	3035240	g8543	i0	62.4	2.88679245283019	85	32	96.2	0	3	257	83	167	WDV47814.1 pyridoxal phosphate-dependent aminotransferase [Clostridiaceae bacterium M8S5]	diamond	765	118	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium M8S5
27515075	27515075	PRJNA1215813_P_NODE_9803_length_251_cov_1.752809_g9723_i0	PRJNA1215813	9803	251	1.752809	4.39955059	Vagococcus humatus	1889241	Bacteria	Bacteria	86.3	1.77e-19	NR	WP_125942389.1	1889241	g9723	i0	58.1	5.09163346613546	62	26	74.1	0	62	247	9	70	WP_125942389.1 glycine cleavage system protein GcvH [Vagococcus humatus]	diamond	1278	86.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Vagococcus	Vagococcus humatus
28354719	28354719	PRJNA1215813_P_NODE_11246_length_246_cov_1.352601_g11166_i0	PRJNA1215813	11246	246	1.352601	3.32739846	PVC group	1783257	Bacteria	Bacteria	44.7	0.0064	NR	MDI9503863.1	1879010	g11166	i0	35.7	4.04878048780488	84	45	95.1	2	11	244	100	180	MDI9503863.1 hypothetical protein [Bacillota bacterium]	diamond	996	44.7	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
28354721	28354721	PRJNA1215813_P_NODE_1766_length_561_cov_0.997951_g1687_i0	PRJNA1215813	1766	561	0.997951	5.59850511	FCB group	1783270	Bacteria	Bacteria	216	2.24e-67	NR	WP_172244303.1	2060666	g1687	i0	58.1	4.97860962566845	186	78	99.5	0	559	2	2	187	WP_172244303.1 SDR family oxidoreductase [Saccharibacillus endophyticus]	diamond	2793	216	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Saccharibacillus	Saccharibacillus endophyticus
28872669	28872669	PRJNA1215813_P_NODE_9128_length_255_cov_2.362637_g9048_i0	PRJNA1215813	9128	255	2.362637	6.02472435	Metabacillus sp.	2675275	Bacteria	Bacteria	86.3	5.47e-20	NR	HZH60916.1	2675275	g9048	i0	73.4	1.50588235294118	64	17	75.3	0	194	3	12	75	HZH60916.1 ATP synthase subunit C family protein [Metabacillus sp.]	diamond	384	86.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus sp.
29302039	29302039	PRJNA1215813_P_NODE_8469_length_268_cov_1.600000_g8389_i0	PRJNA1215813	8469	268	1.6	4.288	PVC group	1783257	Bacteria	Bacteria	67.8	6.21e-11	NR	HWI56871.1	1879010	g8389	i0	37.2	2.88805970149254	86	42	96.3	2	267	10	59	132	HWI56871.1 alpha-amylase family glycosyl hydrolase [Bacillota bacterium]	diamond	774	67.8	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
30294253	30294253	PRJNA1215813_P_NODE_10792_length_248_cov_0.891429_g10712_i0	PRJNA1215813	10792	248	0.891429	2.21074392	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	44.3	0.0105	NR	MCR5222760.1	1898203	g10712	i0	47.6	1.4758064516129	42	22	50.8	0	3	128	61	102	MCR5222760.1 hypothetical protein [Lachnospiraceae bacterium]	diamond	366	44.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30736129	30736129	PRJNA1215813_P_NODE_12094_length_243_cov_0.917647_g12014_i0	PRJNA1215813	12094	243	0.917647	2.22988221	Caryophanon sp.	2306576	Bacteria	Bacteria	90.9	3.8e-21	NR	MEE1131226.1	2306576	g12014	i0	58	2	81	34	100	0	243	1	36	116	MEE1131226.1 low molecular weight protein arginine phosphatase [Caryophanon sp.]	diamond	486	90.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Caryophanon	Caryophanon sp.
30767819	30767819	PRJNA1215813_P_NODE_11454_length_246_cov_0.901734_g11374_i0	PRJNA1215813	11454	246	0.901734	2.21826564	Paenibacillus sp. FSL R5-	58172	Bacteria	Bacteria	45.1	0.00625	NR	WP_342571259.1	2921657	g11374	i0	40.9	0.804878048780488	66	32	75.6	3	19	204	124	186	WP_342571259.1 S-layer homology domain-containing protein [Paenibacillus sp. FSL R5-0749]	diamond	198	45.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL R5-0749
30849747	30849747	PRJNA1215813_P_NODE_474_length_972_cov_2.077864_g424_i0	PRJNA1215813	474	972	2.077864	20.19683808	Bacillota	1239	Bacteria	Bacteria	123	2.34e-29	NR	WP_020619181.1	135193	g424	i0	31.2	2.31172839506173	260	163	77.8	5	849	94	6	257	WP_020619181.1 class I SAM-dependent methyltransferase [Paenibacillus daejeonensis]	diamond	2247	123	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus daejeonensis
30881307	30881307	PRJNA1215813_P_NODE_4694_length_354_cov_1.110320_g4614_i0	PRJNA1215813	4694	354	1.11032	3.9305328	Bacillaceae	186817	Bacteria	Bacteria	110	3.19e-26	NR	WP_044338627.1	189382	g4614	i0	46.8	2.76271186440678	109	58	92.4	0	331	5	97	205	WP_044338627.1 cyanophycinase [Rossellomorea aquimaris]	diamond	978	110	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Rossellomorea	Rossellomorea aquimaris
31178270	31178270	PRJNA1215813_P_NODE_5895_length_321_cov_1.028226_g5815_i0	PRJNA1215813	5895	321	1.028226	3.30060546	Butyrivibrio sp. AE2	28121	Bacteria	Bacteria	45.4	0.01	NR	WP_026667371.1	1496722	g5815	i0	33.3	0.813084112149533	87	47	71	3	46	273	256	342	WP_026667371.1 permease prefix domain 1-containing protein [Butyrivibrio sp. AE2005]	diamond	261	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Butyrivibrio	Butyrivibrio sp. AE2005
31273398	31273398	PRJNA1215813_P_NODE_4835_length_349_cov_1.695652_g4755_i0	PRJNA1215813	4835	349	1.695652	5.91782548	unclassified Streptococcus	2608887	Bacteria	Bacteria	43.9	0.0393	NR	WP_008534286.1	2608887	g4755	i0	30.9	0.833810888252149	97	53	79.1	4	290	15	7	94	WP_008534286.1 MULTISPECIES: RNA-binding protein [unclassified Streptococcus]	diamond	291	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus
31273403	31273403	PRJNA1215813_P_NODE_9675_length_252_cov_0.871508_g9595_i0	PRJNA1215813	9675	252	0.871508	2.19620016	Thermoflavimicrobium dichotomicum	46223	Bacteria	Bacteria	87.4	2.9e-18	NR	WP_093229000.1	46223	g9595	i0	62.3	0.821428571428571	69	25	82.1	1	248	42	259	326	WP_093229000.1 alpha/beta hydrolase family esterase [Thermoflavimicrobium dichotomicum]	diamond	207	87.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Thermoflavimicrobium	Thermoflavimicrobium dichotomicum

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