metadata: contig_metadata: 16 rows where bioproject = "PRJNA1134759" and tax

16 rows where bioproject = "PRJNA1134759" 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
2834810	2834810	PRJNA1134759_P_NODE_36163_length_284_cov_1.872038_g35987_i0	PRJNA1134759	36163	284	1.872038	5.31658792	Caloramator sp. mosi_1	3023090	Bacteria	Bacteria	231	3.14e-56	NTclustered	gi\|2444358925\|gb\|CP117677.1\|	3023090	g35987	i0	81.72	3.42605633802817	279	49	98	2	7	284	878331	878054	Caloramator sp. mosi_1 chromosome, complete genome	blastn	973	231	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Caloramator	Caloramator sp. mosi_1
6134733	6134733	PRJNA1134759_P_NODE_56525_length_242_cov_0.923077_g56349_i0	PRJNA1134759	56525	242	0.923077	2.23384634	Streptococcus	1301	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|1239731491\|gb\|CP017064.1\|	1308	g56349	i0	97.934	100	242	5	100	0	1	242	1415074	1415315	Streptococcus thermophilus strain ST3 chromosome, complete genome	blastn	24200	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
14313123	14313123	PRJNA1134759_P_NODE_51552_length_249_cov_0.886364_g51376_i0	PRJNA1134759	51552	249	0.886364	2.20704636	Staphylococcus epidermidis	1282	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g51376	i0	100	100	249	0	100	0	1	249	556630	556382	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	24900	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
19410101	19410101	PRJNA1134759_P_NODE_51536_length_249_cov_0.886364_g51360_i0	PRJNA1134759	51536	249	0.886364	2.20704636	Cytobacillus firmus	1399	Bacteria	Bacteria	231	2.7e-56	NTclustered	gi\|2511383467\|gb\|CP126108.1\|	1399	g51360	i0	83.468	76.9357429718875	248	41	99	0	1	248	110336	110583	Cytobacillus firmus strain SQ11 chromosome, complete genome	blastn	19157	231	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Cytobacillus	Cytobacillus firmus
20685598	20685598	PRJNA1134759_P_NODE_54977_length_244_cov_0.912281_g54801_i0	PRJNA1134759	54977	244	0.912281	2.22596564	Lactobacillus crispatus	47770	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g54801	i0	100	30	244	0	100	0	1	244	1268306	1268063	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	7320	451	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
25258195	25258195	PRJNA1134759_P_NODE_27180_length_319_cov_1.585366_g27004_i0	PRJNA1134759	27180	319	1.585366	5.05731754	Clostridium	1485	Bacteria	Bacteria	239	2.14e-58	NTclustered	gi\|1943187032\|gb\|CP065677.1\|	1502	g27004	i0	80.495	66.3134796238244	323	53	99	8	2	319	694276	694593	Clostridium perfringens strain FDAARGOS_904 chromosome, complete genome	blastn	21154	239	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
27386614	27386614	PRJNA1134759_P_NODE_48743_length_253_cov_0.866667_g48567_i0	PRJNA1134759	48743	253	0.866667	2.19266751	Sediminibacillus albus	407036	Bacteria	Bacteria	94.7	3.61e-22	NR	WP_093216320.1	407036	g48567	i0	52.6	0.924901185770751	78	36	92.5	1	252	19	68	144	WP_093216320.1 RNA 2',3'-cyclic phosphodiesterase [Sediminibacillus albus]	diamond	234	94.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Sediminibacillus	Sediminibacillus albus
27596667	27596667	PRJNA1134759_P_NODE_55044_length_244_cov_0.912281_g54868_i0	PRJNA1134759	55044	244	0.912281	2.22596564	Bacillaceae	186817	Bacteria	Bacteria	97.8	7.93e-22	NR	WP_276703522.1	301148	g54868	i0	54.3	3.98360655737705	81	37	99.6	0	2	244	139	219	WP_276703522.1 M16 family metallopeptidase [Caldibacillus debilis]	diamond	972	97.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus debilis
27891470	27891470	PRJNA1134759_P_NODE_55025_length_244_cov_0.912281_g54849_i0	PRJNA1134759	55025	244	0.912281	2.22596564	Salibacterium salarium	284579	Bacteria	Bacteria	133	8.549999999999999e-38	NR	WP_125556713.1	284579	g54849	i0	72.5	0.983606557377049	80	22	98.4	0	242	3	31	110	WP_125556713.1 DUF6884 domain-containing protein [Salibacterium salarium]	diamond	240	133	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Salibacterium	Salibacterium salarium
29490856	29490856	PRJNA1134759_P_NODE_52190_length_248_cov_0.891429_g52014_i0	PRJNA1134759	52190	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	43.5	0.0208	NR	WP_031585911.1	416586	g52014	i0	43.8	2.12903225806452	48	26	58.1	1	64	207	433	479	WP_031585911.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Selenomonas bovis]	diamond	528	43.5	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Selenomonadaceae	Selenomonas	Selenomonas bovis
29564993	29564993	PRJNA1134759_P_NODE_17590_length_383_cov_0.738710_g17414_i0	PRJNA1134759	17590	383	0.73871	2.8292593	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	173	2.2299999999999996e-47	NR	MBS3812162.1	2094029	g17414	i0	77.2	0.994778067885117	127	29	99.5	0	3	383	61	187	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	381	173	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
30038740	30038740	PRJNA1134759_P_NODE_11031_length_471_cov_2.130653_g10855_i0	PRJNA1134759	11031	471	2.130653	10.03537563	Planococcus shixiaomingii	3058393	Bacteria	Bacteria	64.7	7.75e-9	NR	WP_301723276.1	3058393	g10855	i0	31.8	0.961783439490446	151	99	93.6	2	31	471	169	319	WP_301723276.1 hypothetical protein [Planococcus shixiaomingii]	diamond	453	64.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus shixiaomingii
30323680	30323680	PRJNA1134759_P_NODE_55052_length_244_cov_0.912281_g54876_i0	PRJNA1134759	55052	244	0.912281	2.22596564	Bacillus songklensis	1069116	Bacteria	Bacteria	91.3	4.13e-20	NR	WP_377915312.1	1069116	g54876	i0	71.7	0.737704918032787	60	17	73.8	0	1	180	78	137	WP_377915312.1 transporter substrate-binding domain-containing protein [Bacillus songklensis]	diamond	180	91.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus songklensis
30733816	30733816	PRJNA1134759_P_NODE_9274_length_510_cov_2.372998_g9098_i0	PRJNA1134759	9274	510	2.372998	12.1022898	Planococcus shixiaomingii	3058393	Bacteria	Bacteria	52	2.66e-4	NR	WP_301723276.1	3058393	g9098	i0	28.2	0.917647058823529	156	96	88.2	4	478	29	9	154	WP_301723276.1 hypothetical protein [Planococcus shixiaomingii]	diamond	468	52	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Planococcus	Planococcus shixiaomingii
31112811	31112811	PRJNA1134759_P_NODE_50835_length_250_cov_0.881356_g50659_i0	PRJNA1134759	50835	250	0.881356	2.20339	Halanaerobiales bacterium	2094029	Bacteria	Bacteria	53.1	8.59e-6	NR	MBS3812162.1	2094029	g50659	i0	64.1	0.468	39	11	43.2	1	138	245	690	728	MBS3812162.1 hypothetical protein [Halanaerobiales bacterium]	diamond	117	53.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales			Halanaerobiales bacterium
32505027	32505027	PRJNA1134759_P_NODE_53499_length_246_cov_0.901734_g53323_i0	PRJNA1134759	53499	246	0.901734	2.21826564	Bacillales bacterium	1904864	Bacteria	Bacteria	64.3	3.78e-11	NR	HET7578327.1	1904864	g53323	i0	93.8	0.390243902439024	32	2	39	0	97	2	1	32	HET7578327.1 DUF3870 domain-containing protein [Bacillales bacterium]	diamond	96	64.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales 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);;