metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA1073183" 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
26718833	26718833	PRJNA1073183_P_NODE_8661_length_434_cov_1.052632_g8567_i0	PRJNA1073183	8661	434	1.052632	4.56842288	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	67.8	4.83e-10	NR	MCI7805223.1	2485925	g8567	i0	42.1	0.73963133640553	107	54	69.1	3	112	411	15	120	MCI7805223.1 SH3 domain-containing protein [Oscillospiraceae bacterium]	diamond	321	67.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27003979	27003979	PRJNA1073183_P_NODE_27142_length_250_cov_0.870056_g27047_i0	PRJNA1073183	27142	250	0.870056	2.17514	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	43.5	0.00307	NR	MBR5404772.1	2485925	g27047	i0	44.7	0.564	47	26	56.4	0	109	249	16	62	MBR5404772.1 KH domain-containing protein [Oscillospiraceae bacterium]	diamond	141	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27257033	27257033	PRJNA1073183_P_NODE_8743_length_432_cov_1.272981_g8649_i0	PRJNA1073183	8743	432	1.272981	5.49927792	Gracilibacillus dipsosauri	178340	Bacteria	Bacteria	122	1.14e-29	NR	WP_277680174.1	178340	g8649	i0	52	2.02777777777778	98	47	68.1	0	50	343	232	329	WP_277680174.1 pyridoxal phosphate-dependent decarboxylase family protein [Gracilibacillus dipsosauri]	diamond	876	122	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Gracilibacillus	Gracilibacillus dipsosauri
27415313	27415313	PRJNA1073183_P_NODE_20383_length_289_cov_1.425926_g20288_i0	PRJNA1073183	20383	289	1.425926	4.12092614	Clostridia bacterium	2044939	Bacteria	Bacteria	93.2	1.2e-19	NR	GHU57210.1	2044939	g20288	i0	58.2	0.820069204152249	79	32	81	1	14	247	124	202	GHU57210.1 hypothetical protein AGMMS49975_22260 [Clostridia bacterium]	diamond	237	93.2	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
27415321	27415321	PRJNA1073183_P_NODE_30783_length_246_cov_0.890173_g30688_i0	PRJNA1073183	30783	246	0.890173	2.18982558	Heyndrickxia ginsengihumi	363870	Bacteria	Bacteria	87	3.63e-20	NR	WP_025728619.1	363870	g30688	i0	97.5	0.48780487804878	40	1	48.8	0	126	245	1	40	WP_025728619.1 HesB/YadR/YfhF family protein [Heyndrickxia ginsengihumi]	diamond	120	87	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia ginsengihumi
27848446	27848446	PRJNA1073183_P_NODE_18264_length_306_cov_1.884120_g18169_i0	PRJNA1073183	18264	306	1.88412	5.7654072	Bacillati	1783272	Bacteria	Bacteria	54.7	2.98e-6	NR	WP_154527325.1	2606632	g18169	i0	35.7	3.90196078431373	98	57	90.2	2	18	293	131	228	WP_154527325.1 MIP/aquaporin family protein [Porcincola intestinalis]	diamond	1194	55.1	0.992740471869329	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Porcincola	Porcincola intestinalis
28109536	28109536	PRJNA1073183_P_NODE_19145_length_299_cov_1.106195_g19050_i0	PRJNA1073183	19145	299	1.106195	3.30752305	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	91.7	2.23e-21	NR	MDR0839482.1	2485925	g19050	i0	53.5	1.81605351170569	86	38	86.3	1	30	287	12	95	MDR0839482.1 RidA family protein [Oscillospiraceae bacterium]	diamond	543	91.7	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28353755	28353755	PRJNA1073183_P_NODE_21526_length_282_cov_2.004785_g21431_i0	PRJNA1073183	21526	282	2.004785	5.6534937	Lachnospiraceae	186803	Bacteria	Bacteria	43.5	0.0255	NR	EPD58420.1	1078090	g21431	i0	38.5	1.24468085106383	39	24	41.5	0	281	165	160	198	EPD58420.1 hypothetical protein HMPREF1215_01438 [Coprococcus sp. HPP0074]	diamond	351	43.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Coprococcus	Coprococcus sp. HPP0074
28393780	28393780	PRJNA1073183_P_NODE_24566_length_263_cov_0.857895_g24471_i0	PRJNA1073183	24566	263	0.857895	2.25626385	Clostridia bacterium	2044939	Bacteria	Bacteria	76.6	1.15e-14	NR	MBQ5761870.1	2044939	g24471	i0	38.3	2.00760456273764	94	50	98.1	2	3	260	103	196	MBQ5761870.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Clostridia bacterium]	diamond	528	76.6	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
29458572	29458572	PRJNA1073183_P_NODE_32230_length_244_cov_0.900585_g32135_i0	PRJNA1073183	32230	244	0.900585	2.1974274	Pelotomaculum	191373	Bacteria	Bacteria	136	3.67e-35	NR	WP_190238800.1	78350	g32135	i0	75	3.9344262295082	80	20	98.4	0	2	241	417	496	WP_190238800.1 class I SAM-dependent DNA methyltransferase [Pelotomaculum schinkii]	diamond	960	136	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfotomaculaceae	Pelotomaculum	Pelotomaculum schinkii
29656374	29656374	PRJNA1073183_P_NODE_23390_length_270_cov_1.228426_g23295_i0	PRJNA1073183	23390	270	1.228426	3.3167502	Bacilli bacterium	1903720	Bacteria	Bacteria	144	5.31e-40	NR	MDB5055081.1	1903720	g23295	i0	78.4	6.84444444444444	88	19	97.8	0	7	270	150	237	MDB5055081.1 aepX [Bacilli bacterium]	diamond	1848	144	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
29814577	29814577	PRJNA1073183_P_NODE_26591_length_251_cov_0.865169_g26496_i0	PRJNA1073183	26591	251	0.865169	2.17157419	Bacillus ndiopicus	1347368	Bacteria	Bacteria	43.1	0.0292	NR	WP_042475459.1	1347368	g26496	i0	38.8	0.800796812749004	67	32	77.7	3	34	228	362	421	WP_042475459.1 DUF4179 domain-containing protein [Bacillus ndiopicus]	diamond	201	43.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus ndiopicus
31679153	31679153	PRJNA1073183_P_NODE_9497_length_415_cov_4.318713_g9403_i0	PRJNA1073183	9497	415	4.318713	17.92265895	Brevibacillus fulvus	1125967	Bacteria	Bacteria	144	1.71e-41	NR	WP_204516782.1	1125967	g9403	i0	61.1	4.99518072289157	113	44	81.7	0	365	27	2	114	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	2073	144	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
31742403	31742403	PRJNA1073183_P_NODE_19557_length_295_cov_2.774775_g19462_i0	PRJNA1073183	19557	295	2.774775	8.18558625	Enterococcus faecalis	1351	Bacteria	Bacteria	138	2.4e-40	NR	WP_411401825.1	1351	g19462	i0	100	4.98305084745763	70	0	71.2	0	84	293	2	71	WP_411401825.1 hypothetical protein, partial [Enterococcus faecalis]	diamond	1470	138	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
31742414	31742414	PRJNA1073183_P_NODE_28877_length_248_cov_0.880000_g28782_i0	PRJNA1073183	28877	248	0.88	2.1824	Faecalibacillus faecis	1982628	Bacteria	Bacteria	50.4	4.84e-5	NR	WP_405315126.1	1982628	g28782	i0	33.3	0.907258064516129	75	50	90.7	0	3	227	130	204	WP_405315126.1 50S ribosomal protein L4 [Faecalibacillus faecis]	diamond	225	50.4	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Faecalibacillus	Faecalibacillus faecis
32090554	32090554	PRJNA1073183_P_NODE_20778_length_287_cov_1.219626_g20683_i0	PRJNA1073183	20778	287	1.219626	3.50032662	Enterococcus viikkiensis	930854	Bacteria	Bacteria	43.9	0.0248	NR	WP_137613817.1	930854	g20683	i0	39.1	1.33797909407666	64	37	64.8	1	202	17	336	399	WP_137613817.1 single-stranded-DNA-specific exonuclease RecJ [Enterococcus viikkiensis]	diamond	384	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus viikkiensis
32240500	32240500	PRJNA1073183_P_NODE_32098_length_244_cov_0.900585_g32003_i0	PRJNA1073183	32098	244	0.900585	2.1974274	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	106	3.84e-25	NR	WP_255306961.1	1462524	g32003	i0	62.5	4.88114754098361	80	30	98.4	0	242	3	43	122	WP_255306961.1 NAD-dependent epimerase/dehydratase family protein [Paraliobacillus sp. PM-2]	diamond	1191	107	0.990654205607477	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Paraliobacillus	Paraliobacillus sp. PM-2
32627947	32627947	PRJNA1073183_P_NODE_17440_length_313_cov_1.312500_g17345_i0	PRJNA1073183	17440	313	1.3125	4.108125	Lactobacillaceae bacterium	2291323	Bacteria	Bacteria	65.1	1.2e-9	NR	MDR3190704.1	2291323	g17345	i0	61.2	4.65814696485623	49	19	47	0	310	164	99	147	MDR3190704.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Lactobacillaceae bacterium]	diamond	1458	65.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae		Lactobacillaceae bacterium
32785431	32785431	PRJNA1073183_P_NODE_27380_length_250_cov_0.870056_g27285_i0	PRJNA1073183	27380	250	0.870056	2.17514	Clostridiaceae bacterium	1898204	Bacteria	Bacteria	48.5	3.63e-4	NR	NLU52398.1	1898204	g27285	i0	36.4	1.056	88	46	93.6	2	15	248	585	672	NLU52398.1 glutamine synthetase type III [Clostridiaceae bacterium]	diamond	264	48.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae 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);;