metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA1046144" 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
7824527	7824527	PRJNA1046144_P_NODE_1787_length_1124_cov_26.473934_g1214_i1	PRJNA1046144	1787	1124	26.473934	297.56701816	Oenococcus oeni	1247	Bacteria	Bacteria	389	2.98e-132	NR	WP_208337836.1	1247	g1214	i1	100	0.71797153024911	269	0	71.8	0	1063	257	1	269	WP_208337836.1 hypothetical protein, partial [Oenococcus oeni]	diamond	807	389	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Oenococcus	Oenococcus oeni
9099362	9099362	PRJNA1046144_P_NODE_1328_length_1270_cov_22.562032_g1214_i0	PRJNA1046144	1328	1270	22.562032	286.5378064	Oenococcus oeni	1247	Bacteria	Bacteria	287	2.19e-91	NR	WP_208337836.1	1247	g1214	i0	99.3	0.333070866141732	141	1	33.3	0	1209	787	1	141	WP_208337836.1 hypothetical protein, partial [Oenococcus oeni]	diamond	423	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Oenococcus	Oenococcus oeni
23124985	23124985	PRJNA1046144_P_NODE_60539_length_232_cov_0.883436_g60244_i0	PRJNA1046144	60539	232	0.883436	2.04957152	Bacteria	2	Bacteria	Bacteria	142	2.88e-42	NR	MBN9924068.1	1639	g60244	i0	100	3.89224137931034	70	0	90.5	0	231	22	22	91	MBN9924068.1 hypothetical protein [Listeria monocytogenes]	diamond	903	143	0.993006993006993	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
26813768	26813768	PRJNA1046144_P_NODE_57021_length_234_cov_2.618182_g56726_i0	PRJNA1046144	57021	234	2.618182	6.12654588	Enterococcus faecium	1352	Bacteria	Bacteria	141	1e-41	NR	WP_161985621.1	1352	g56726	i0	86.7	0.961538461538462	75	10	96.2	0	232	8	35	109	WP_161985621.1 hypothetical protein [Enterococcus faecium]	diamond	225	141	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
27098413	27098413	PRJNA1046144_P_NODE_44042_length_261_cov_2.020833_g43747_i0	PRJNA1046144	44042	261	2.020833	5.27437413	Geobacillus thermoleovorans	33941	Bacteria	Bacteria	77.4	4.19e-15	NR	AZM68782.1	33941	g43747	i0	75	0.735632183908046	64	14	73.6	2	70	261	14	75	AZM68782.1 hypothetical protein, partial [Geobacillus thermoleovorans]	diamond	192	77.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus thermoleovorans
28077448	28077448	PRJNA1046144_P_NODE_50005_length_248_cov_1.089385_g49710_i0	PRJNA1046144	50005	248	1.089385	2.7016748	Geobacillus thermoleovorans	33941	Bacteria	Bacteria	64.7	2.4e-10	NR	AZM68782.1	33941	g49710	i0	68.4	0.689516129032258	57	16	69	2	174	4	13	67	AZM68782.1 hypothetical protein, partial [Geobacillus thermoleovorans]	diamond	171	64.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus thermoleovorans
28701134	28701134	PRJNA1046144_P_NODE_57907_length_234_cov_0.872727_g57612_i0	PRJNA1046144	57907	234	0.872727	2.04218118	Geobacillus	129337	Bacteria	Bacteria	75.5	1.56e-14	NR	AZM68782.1	33941	g57612	i0	72.9	1.48717948717949	59	14	75.6	2	17	193	14	70	AZM68782.1 hypothetical protein, partial [Geobacillus thermoleovorans]	diamond	348	75.9	0.994729907773386	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus thermoleovorans
28732630	28732630	PRJNA1046144_P_NODE_58287_length_234_cov_0.872727_g57992_i0	PRJNA1046144	58287	234	0.872727	2.04218118	Bacillaceae	186817	Bacteria	Bacteria	137	7.13e-38	NR	WP_239429214.1	86664	g57992	i0	89.6	1.97435897435897	77	8	98.7	0	233	3	97	173	WP_239429214.1 tyrosine-type recombinase/integrase [Priestia flexa]	diamond	462	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia flexa
28930089	28930089	PRJNA1046144_P_NODE_52648_length_242_cov_1.329480_g52353_i0	PRJNA1046144	52648	242	1.32948	3.2173416	Listeria monocytogenes	1639	Bacteria	Bacteria	112	2.12e-30	NR	MCB2621752.1	1639	g52353	i0	98.2	0.706611570247934	57	1	70.7	0	2	172	16	72	MCB2621752.1 hypothetical protein [Listeria monocytogenes]	diamond	171	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
29025130	29025130	PRJNA1046144_P_NODE_16808_length_394_cov_2.569231_g16513_i0	PRJNA1046144	16808	394	2.569231	10.12277014	Clostridia bacterium	2044939	Bacteria	Bacteria	132	3.21e-36	NR	MEG2376863.1	2044939	g16513	i0	64.5	0.708121827411167	93	33	70.8	0	110	388	1	93	MEG2376863.1 HNH endonuclease [Clostridia bacterium]	diamond	279	132	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29340637	29340637	PRJNA1046144_P_NODE_35729_length_285_cov_1.398148_g35434_i0	PRJNA1046144	35729	285	1.398148	3.9847218	Fructilactobacillus sanfranciscensis	1625	Bacteria	Bacteria	109	2.45e-28	NR	POH17992.1	1625	g35434	i0	71.7	0.968421052631579	92	26	96.8	0	285	10	5	96	POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis]	diamond	276	109	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Fructilactobacillus	Fructilactobacillus sanfranciscensis
30161397	30161397	PRJNA1046144_P_NODE_46972_length_254_cov_2.221622_g46677_i0	PRJNA1046144	46972	254	2.221622	5.64291988	Clostridioides difficile	1496	Bacteria	Bacteria	160	2.11e-49	NR	MBH9879343.1	1496	g46677	i0	100	0.94488188976378	80	0	94.5	0	1	240	5	84	MBH9879343.1 hypothetical protein [Clostridioides difficile]	diamond	240	160	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Clostridioides	Clostridioides difficile
30280380	30280380	PRJNA1046144_P_NODE_56332_length_235_cov_0.867470_g56037_i0	PRJNA1046144	56332	235	0.86747	2.0385545	Aedoeadaptatus	2981628	Bacteria	Bacteria	146	1e-41	NR	WP_068367295.1	755172	g56037	i0	96.1	1.97872340425532	77	3	98.3	0	1	231	45	121	WP_068367295.1 ABC transporter ATP-binding protein [Aedoeadaptatus coxii]	diamond	465	146	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Aedoeadaptatus	Aedoeadaptatus coxii
32248508	32248508	PRJNA1046144_P_NODE_11438_length_470_cov_2.456359_g11143_i0	PRJNA1046144	11438	470	2.456359	11.5448873	Clostridia bacterium	2044939	Bacteria	Bacteria	196	3.719999999999999e-55	NR	MEG2569817.1	2044939	g11143	i0	62.2	1.99148936170213	156	55	99.6	1	1	468	211	362	MEG2569817.1 host specificity factor TipJ family phage tail protein [Clostridia bacterium]	diamond	936	196	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32430058	32430058	PRJNA1046144_P_NODE_67379_length_227_cov_1.822785_g67084_i0	PRJNA1046144	67379	227	1.822785	4.13772195	FCB group	1783270	Bacteria	Bacteria	144	4.9199999999999985e-43	NR	MFV7789207.1	1352	g67084	i0	96	1.98237885462555	75	3	99.1	0	1	225	9	83	MFV7789207.1 circularly permuted type 2 ATP-grasp protein [Enterococcus faecium]	diamond	450	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecium
32839806	32839806	PRJNA1046144_P_NODE_34740_length_288_cov_2.977169_g34445_i0	PRJNA1046144	34740	288	2.977169	8.57424672	Oscillospiraceae	216572	Bacteria	Bacteria	45.1	0.00999	NR	WP_073260934.1	1720313	g34445	i0	45	1.66666666666667	40	22	41.7	0	218	99	1246	1285	WP_073260934.1 PolC-type DNA polymerase III [Bittarella massiliensis (ex Durand et al. 2017)]	diamond	480	45.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Bittarella (ex Durand et al. 2017)	Bittarella massiliensis (ex Durand et al. 2017)

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