metadata: contig_metadata: 20 rows where bioproject = "PRJNA1025141", tax_kingdom = "Bacillati" and tax

20 rows where bioproject = "PRJNA1025141", tax_kingdom = "Bacillati" 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
3554720	3554720	PRJNA1025141_P_NODE_5423_length_346_cov_1.084249_g5362_i0	PRJNA1025141	5423	346	1.084249	3.75150154	Bacilli bacterium	1903720	Bacteria	Bacteria	139	8.93e-40	NR	MCQ2795680.1	1903720	g5362	i0	57.5	0.979768786127168	113	48	98	0	344	6	10	122	MCQ2795680.1 hypothetical protein [Bacilli bacterium]	diamond	339	139	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
3989323	3989323	PRJNA1025141_P_NODE_1564_length_663_cov_1.161017_g1505_i0	PRJNA1025141	1564	663	1.161017	7.69754271	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	309	3.5500000000000006e-79	NTclustered	gi\|2188892147\|dbj\|AP025582.1\|	2485925	g1505	i0	76.965	62.1990950226244	547	122	82	4	56	600	912748	913292	Oscillospiraceae bacterium CE91-St43 DNA, complete genome	blastn	41238	309	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
3989366	3989366	PRJNA1025141_P_NODE_4024_length_405_cov_1.623494_g3963_i0	PRJNA1025141	4024	405	1.623494	6.5751507	Bacillus sp. N1-1	2682541	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1788749933\|gb\|CP046564.1\|	2682541	g3963	i0	100	0.0691358024691358	28	0	7	0	18	45	1237930	1237903	Bacillus sp. N1-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus sp. N1-1
3989403	3989403	PRJNA1025141_P_NODE_6684_length_309_cov_0.978814_g6623_i0	PRJNA1025141	6684	309	0.978814	3.02453526	Streptococcus infantis	68892	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g6623	i0	100	0.0906148867313916	28	0	9	0	54	81	1119472	1119445	Streptococcus infantis strain SO chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
9932222	9932222	PRJNA1025141_P_NODE_548_length_1067_cov_21.975855_g7_i3	PRJNA1025141	548	1067	21.975855	234.48237285	root	1	Root_unresolved	Root_unresolved	1738	0	NTclustered	gi\|2283119276\|gb\|CP071933.1\|	1390	g7	i3	96.071	137.711340206186	1069	38	100	3	1	1067	1381	315	Bacillus amyloliquefaciens strain CAS02 plasmid unnamed, complete sequence	blastn	146938	1744	0.996559633027523	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus amyloliquefaciens
11207443	11207443	PRJNA1025141_P_NODE_2549_length_513_cov_1.890909_g2488_i0	PRJNA1025141	2549	513	1.890909	9.70036317	Exiguobacterium	33986	Bacteria	Bacteria	948	0	NTclustered	gi\|2851235694\|gb\|CP085238.1\|	33987	g2488	i0	100	726.974658869396	513	0	100	0	1	513	12605	13117	Exiguobacterium aurantiacum strain ADH2-127 chromosome, complete genome	blastn	372938	948	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium aurantiacum
20564043	20564043	PRJNA1025141_P_NODE_9197_length_253_cov_1.738889_g9136_i0	PRJNA1025141	9197	253	1.738889	4.39938917	Lactobacillus iners	147802	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g9136	i0	100	486.624505928854	253	0	100	0	1	253	3139	3391	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	123116	468	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
20564056	20564056	PRJNA1025141_P_NODE_9637_length_251_cov_0.865169_g9576_i0	PRJNA1025141	9637	251	0.865169	2.17157419	Paenibacillus psychroresistens	1778678	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1780029168\|gb\|CP034235.1\|	1778678	g9576	i0	97.059	0.274900398406374	34	0	14	1	122	155	4143053	4143085	Paenibacillus psychroresistens strain ML311-T8 chromosome, complete genome	blastn	69	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus psychroresistens
24388891	24388891	PRJNA1025141_P_NODE_4620_length_378_cov_1.009836_g4559_i0	PRJNA1025141	4620	378	1.009836	3.81718008	Bacillati	1783272	Bacteria	Bacteria	199	2.48e-63	NR	WP_120188376.1	66863	g4559	i0	75.2	21.3492063492063	125	31	99.2	0	3	377	1	125	WP_120188376.1 nucleoside-diphosphate kinase [Ammoniphilus oxalaticus]	diamond	8070	199	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Ammoniphilus	Ammoniphilus oxalaticus
27161138	27161138	PRJNA1025141_P_NODE_12382_length_243_cov_0.905882_g12321_i0	PRJNA1025141	12382	243	0.905882	2.20129326	Lachnospiraceae bacterium 3-1	397288	Bacteria	Bacteria	42.7	0.0347	NR	EOS26174.1	397288	g12321	i0	41.7	0.592592592592593	48	25	55.6	1	63	197	131	178	EOS26174.1 hypothetical protein C806_01390 [Lachnospiraceae bacterium 3-1]	diamond	144	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium 3-1
27761860	27761860	PRJNA1025141_P_NODE_8984_length_258_cov_1.216216_g8923_i0	PRJNA1025141	8984	258	1.216216	3.13783728	Lactococcus paracarnosus	2749962	Bacteria	Bacteria	43.1	0.0328	NR	WP_243983675.1	2749962	g8923	i0	37.9	0.767441860465116	66	37	72.1	1	33	218	364	429	WP_243983675.1 YhgE/Pip domain-containing protein [Lactococcus paracarnosus]	diamond	198	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Pseudolactococcus	Pseudolactococcus paracarnosus
28519482	28519482	PRJNA1025141_P_NODE_1547_length_666_cov_1.569983_g1488_i0	PRJNA1025141	1547	666	1.569983	10.45608678	Eubacteriales bacterium	2831996	Bacteria	Bacteria	47.8	0.023	NR	MDO4270893.1	2831996	g1488	i0	26.2	2.15315315315315	145	94	63.1	6	552	133	395	531	MDO4270893.1 MMPL family transporter [Eubacteriales bacterium]	diamond	1434	47.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Eubacteriales bacterium
29308611	29308611	PRJNA1025141_P_NODE_5169_length_355_cov_1.148936_g5108_i0	PRJNA1025141	5169	355	1.148936	4.0787228	Clostridia bacterium	2044939	Bacteria	Bacteria	57.4	9.71e-7	NR	MBP5633135.1	2044939	g5108	i0	35.8	2.91549295774648	120	58	93	6	3	332	254	364	MBP5633135.1 NADP-dependent isocitrate dehydrogenase [Clostridia bacterium]	diamond	1035	57.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29616256	29616256	PRJNA1025141_P_NODE_4950_length_364_cov_1.402062_g4889_i0	PRJNA1025141	4950	364	1.402062	5.10350568	Bacillati	1783272	Bacteria	Bacteria	89.4	2.92e-20	NR	MCI5674686.1	1935205	g4889	i0	56	7.06318681318681	84	37	69.2	0	4	255	29	112	MCI5674686.1 50S ribosomal protein L17 [Ezakiella sp.]	diamond	2571	89.4	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella sp.
29964041	29964041	PRJNA1025141_P_NODE_8591_length_266_cov_1.098446_g8530_i0	PRJNA1025141	8591	266	1.098446	2.92186636	FCB group	1783270	Bacteria	Bacteria	91.7	3.08e-19	NR	MDD3840751.1	2044939	g8530	i0	49.4	4.7593984962406	83	42	93.6	0	6	254	62	144	MDD3840751.1 neutral/alkaline non-lysosomal ceramidase N-terminal domain-containing protein [Clostridia bacterium]	diamond	1266	92.4	0.992424242424242	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29964042	29964042	PRJNA1025141_P_NODE_9511_length_251_cov_0.865169_g9450_i0	PRJNA1025141	9511	251	0.865169	2.17157419	Bacillati	1783272	Bacteria	Bacteria	50.8	6e-5	NR	MEE0857333.1	41978	g9450	i0	42.7	2.61752988047809	75	39	84.9	2	27	239	3157	3231	MEE0857333.1 PKD domain-containing protein [Ruminococcus sp.]	diamond	657	50.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
30343635	30343635	PRJNA1025141_P_NODE_5912_length_330_cov_0.898833_g5851_i0	PRJNA1025141	5912	330	0.898833	2.9661489	Bacillati	1783272	Bacteria	Bacteria	59.7	1.15e-7	NR	WP_209458270.1	937251	g5851	i0	33.9	4.91818181818182	121	41	83.6	3	324	49	172	282	WP_209458270.1 SH3 domain-containing protein [Youngiibacter multivorans]	diamond	1623	60.1	0.993344425956739	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Youngiibacter	Youngiibacter multivorans
31393992	31393992	PRJNA1025141_P_NODE_396_length_1192_cov_1.445040_g369_i0	PRJNA1025141	396	1192	1.44504	17.2248768	Bacilli bacterium	1903720	Bacteria	Bacteria	98.2	7.67e-18	NR	MBR4618359.1	1903720	g369	i0	28.7	2.23489932885906	296	182	73	13	898	29	2177	2449	MBR4618359.1 hypothetical protein [Bacilli bacterium]	diamond	2664	98.2	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31457198	31457198	PRJNA1025141_P_NODE_3696_length_423_cov_1.294286_g3635_i0	PRJNA1025141	3696	423	1.294286	5.47482978	Bacillus methanolicus	1471	Bacteria	Bacteria	70.9	1.62e-11	NR	WP_003351243.1	1471	g3635	i0	35.8	0.971631205673759	137	74	95.7	5	2	406	133	257	WP_003351243.1 carbonic anhydrase [Bacillus methanolicus]	diamond	411	70.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus methanolicus
31481153	31481153	PRJNA1025141_P_NODE_6176_length_322_cov_1.558233_g6115_i0	PRJNA1025141	6176	322	1.558233	5.01751026	root	1	Root_unresolved	Root_unresolved	74.7	1.44e-14	NR	MRB67511.1	1428	g6115	i0	49	7.67701863354037	100	35	93.2	2	23	322	13	96	MRB67511.1 50S ribosomal protein L29 [Bacillus thuringiensis]	diamond	2472	74.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis

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