metadata: contig_metadata: 18 rows where bioproject = "PRJNA565584" and tax

18 rows where bioproject = "PRJNA565584" and tax_phylum = "Ignavibacteriota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18409949	18409949	PRJNA565584_P_NODE_99715_length_299_cov_1.358407_g98563_i0	PRJNA565584	99715	299	1.358407	4.06163693	FCB group	1783270	Bacteria	Bacteria	155	4.37e-46	NR	PKL85413.1	2013808	g98563	i0	74.7	19.7658862876254	99	24	99.3	1	297	1	49	146	PKL85413.1 MAG: lactoylglutathione lyase [Ignavibacteriae bacterium HGW-Ignavibacteriae-1]	diamond	5910	155	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriae bacterium HGW-Ignavibacteriae-1
26889758	26889758	PRJNA565584_P_NODE_152681_length_260_cov_2.278075_g151529_i0	PRJNA565584	152681	260	2.278075	5.922995	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	120	2.56e-29	NR	MEO8398650.1	2651163	g151529	i0	65.1	0.957692307692308	83	29	95.8	0	252	4	172	254	MEO8398650.1 T9SS type A sorting domain-containing protein [Ignavibacteriaceae bacterium]	diamond	249	120	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27458835	27458835	PRJNA565584_P_NODE_63163_length_374_cov_0.764120_g62012_i0	PRJNA565584	63163	374	0.76412	2.8578088	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	82.8	1.13e-15	NR	MCX6138687.1	2049428	g62012	i0	51.3	0.625668449197861	78	38	62.6	0	234	1	58	135	MCX6138687.1 alginate lyase family protein [Ignavibacteriales bacterium]	diamond	234	82.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
28229777	28229777	PRJNA565584_P_NODE_188526_length_247_cov_0.885057_g187374_i0	PRJNA565584	188526	247	0.885057	2.18609079	FCB group	1783270	Bacteria	Bacteria	105	1.2699999999999999e-24	NR	WP_014560433.1	591197	g187374	i0	61.7	9.80161943319838	81	31	98.4	0	3	245	194	274	WP_014560433.1 thiolase family protein [Ignavibacterium album]	diamond	2421	106	0.990566037735849	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
28311188	28311188	PRJNA565584_P_NODE_185366_length_247_cov_1.563218_g184214_i0	PRJNA565584	185366	247	1.563218	3.86114846	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	58.2	1.41e-7	NR	MDH3252717.1	2053306	g184214	i0	35.5	0.923076923076923	76	44	92.3	1	231	4	304	374	MDH3252717.1 cyclic nucleotide-binding domain-containing protein [Ignavibacteria bacterium]	diamond	228	58.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29226912	29226912	PRJNA565584_P_NODE_106069_length_291_cov_0.889908_g104917_i0	PRJNA565584	106069	291	0.889908	2.58963228	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	57.4	3.33e-7	NR	HEX2787135.1	2053306	g104917	i0	32.5	0.855670103092783	83	56	85.6	0	41	289	22	104	HEX2787135.1 nitrilase-related carbon-nitrogen hydrolase [Ignavibacteria bacterium]	diamond	249	57.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29587424	29587424	PRJNA565584_P_NODE_130550_length_275_cov_1.445545_g129398_i0	PRJNA565584	130550	275	1.445545	3.97524875	Bacteria	2	Bacteria	Bacteria	68.9	3.41e-11	NR	OQA68176.1	1852898	g129398	i0	46.3	2.19272727272727	67	34	73.1	1	248	48	386	450	OQA68176.1 MAG: Sensor histidine kinase TodS [Ignavibacteria bacterium ADurb.Bin266]	diamond	603	68.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteria bacterium ADurb.Bin266
29731790	29731790	PRJNA565584_P_NODE_86350_length_320_cov_1.093117_g85198_i0	PRJNA565584	86350	320	1.093117	3.4979744	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	131	9.73e-35	NR	HKB87607.1	2651163	g85198	i0	60.4	7.640625	101	40	94.7	0	2	304	207	307	HKB87607.1 aldo/keto reductase [Ignavibacteriaceae bacterium]	diamond	2445	131	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
30111007	30111007	PRJNA565584_P_NODE_46772_length_436_cov_1.705234_g45621_i0	PRJNA565584	46772	436	1.705234	7.43482024	Ignavibacterium sp.	2651167	Bacteria	Bacteria	79	7.33e-15	NR	MFN3874080.1	2651167	g45621	i0	59	2.51146788990826	61	24	42	1	435	253	152	211	MFN3874080.1 HAD family acid phosphatase [Ignavibacterium sp.]	diamond	1095	79	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
30187771	30187771	PRJNA565584_P_NODE_180432_length_248_cov_1.760000_g179280_i0	PRJNA565584	180432	248	1.76	4.3648	Bacteria	2	Bacteria	Bacteria	48.1	5.02e-4	NR	MCB0714257.1	2026749	g179280	i0	33.8	1.79032258064516	74	49	89.5	0	223	2	842	915	MCB0714257.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	444	48.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30269286	30269286	PRJNA565584_P_NODE_58792_length_387_cov_3.452229_g57641_i0	PRJNA565584	58792	387	3.452229	13.36012623	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	59.7	2.05e-7	NR	NLT51512.1	2053306	g57641	i0	43.7	0.550387596899225	71	36	51.9	2	1	201	219	289	NLT51512.1 deoxyribodipyrimidine photo-lyase [Ignavibacteria bacterium]	diamond	213	59.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30314754	30314754	PRJNA565584_P_NODE_206752_length_243_cov_0.905882_g205600_i0	PRJNA565584	206752	243	0.905882	2.20129326	Pseudomonadati	3379134	Bacteria	Bacteria	70.1	4.11e-13	NR	MBS4032934.1	2651167	g205600	i0	68.2	3.01234567901235	44	14	54.3	0	112	243	1	44	MBS4032934.1 peptide-methionine (R)-S-oxide reductase MsrB [Ignavibacterium sp.]	diamond	732	70.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
31153296	31153296	PRJNA565584_P_NODE_39755_length_476_cov_1.389578_g38604_i0	PRJNA565584	39755	476	1.389578	6.61439128	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	47	0.0127	NR	HEY3249713.1	2053306	g38604	i0	29	0.869747899159664	138	79	86.3	5	35	445	412	531	HEY3249713.1 M14 family zinc carboxypeptidase [Ignavibacteria bacterium]	diamond	414	47	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31944240	31944240	PRJNA565584_P_NODE_64037_length_371_cov_1.546980_g62886_i0	PRJNA565584	64037	371	1.54698	5.7392958	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	43.9	0.0457	NR	MBK9403733.1	2053306	g62886	i0	35.5	0.61455525606469	76	39	59.8	3	349	128	124	191	MBK9403733.1 M15 family metallopeptidase [Ignavibacteria bacterium]	diamond	228	43.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32039282	32039282	PRJNA565584_P_NODE_150098_length_262_cov_1.629630_g148946_i0	PRJNA565584	150098	262	1.62963	4.2696306	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	102	1.7e-24	NR	MBK7258344.1	2026749	g148946	i0	82.3	0.709923664122137	62	11	71	0	259	74	186	247	MBK7258344.1 flagellar basal-body rod protein FlgF [Ignavibacteriota bacterium]	diamond	186	102	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
32653406	32653406	PRJNA565584_P_NODE_196440_length_245_cov_0.895349_g195288_i0	PRJNA565584	196440	245	0.895349	2.19360505	Melioribacter	1134403	Bacteria	Bacteria	73.6	1.9e-14	NR	MBS3945208.1	2052167	g195288	i0	45.1	1.7265306122449	71	39	86.9	0	243	31	65	135	MBS3945208.1 hemerythrin family protein [Melioribacter sp.]	diamond	423	73.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter sp.
32797204	32797204	PRJNA565584_P_NODE_105820_length_291_cov_1.412844_g104668_i0	PRJNA565584	105820	291	1.412844	4.11137604	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	63.5	3e-9	NR	MCZ7601670.1	2614255	g104668	i0	41.1	0.979381443298969	95	54	96.9	2	9	290	30	123	MCZ7601670.1 T9SS type A sorting domain-containing protein [Melioribacteraceae bacterium]	diamond	285	63.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
32860465	32860465	PRJNA565584_P_NODE_203240_length_243_cov_1.800000_g202088_i0	PRJNA565584	203240	243	1.8	4.374	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	65.5	2.22e-10	NR	HMN49368.1	2651163	g202088	i0	48.7	3.92592592592593	78	38	96.3	1	238	5	13	88	HMN49368.1 SDR family oxidoreductase [Ignavibacteriaceae bacterium]	diamond	954	65.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae 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);;