metadata: contig_metadata: 10 rows where bioproject = "PRJEB10140" and tax

10 rows where bioproject = "PRJEB10140" 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
3838519	3838519	PRJEB10140_P_NODE_24464_length_1319_cov_3.618110_g14496_i0	PRJEB10140	24464	1319	3.61811	47.7228709	Bacteria	2	Bacteria	Bacteria	633	3.849999999999998e-224	NR	OGU29913.1	1798418	g14496	i0	69	38.035633055345	439	136	99.8	0	2	1318	41	479	OGU29913.1 MAG: phosphogluconate dehydrogenase (NADP(+)-dependent, decarboxylating) [Ignavibacteria bacterium GWA2_35_9]	diamond	50169	633	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium GWA2_35_9
27443792	27443792	PRJEB10140_P_NODE_237223_length_173_cov_1.217742_g219914_i0	PRJEB10140	237223	173	1.217742	2.10669366	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	89.7	1.72e-19	NR	MBN8571677.1	2053306	g219914	i0	64.9	0.988439306358382	57	20	98.8	0	172	2	16	72	MBN8571677.1 DUF262 domain-containing protein [Ignavibacteria bacterium]	diamond	171	89.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29590257	29590257	PRJEB10140_P_NODE_82110_length_446_cov_2.438287_g64851_i0	PRJEB10140	82110	446	2.438287	10.87476002	Ignavibacterium sp.	2651167	Bacteria	Bacteria	48.5	0.00308	NR	WP_348343028.1	2651167	g64851	i0	42.4	0.396860986547085	59	32	39.7	1	23	199	372	428	WP_348343028.1 two-component regulator propeller domain-containing protein [Ignavibacterium sp.]	diamond	177	48.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
30032736	30032736	PRJEB10140_P_NODE_275271_length_164_cov_0.904348_g257962_i0	PRJEB10140	275271	164	0.904348	1.48313072	Ignavibacterium sp.	2651167	Bacteria	Bacteria	104	5.67e-27	NR	MCX7610229.1	2651167	g257962	i0	94.2	0.951219512195122	52	3	95.1	0	156	1	88	139	MCX7610229.1 hypothetical protein [Ignavibacterium sp.]	diamond	156	104	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
30601297	30601297	PRJEB10140_P_NODE_72533_length_506_cov_2.943107_g55381_i0	PRJEB10140	72533	506	2.943107	14.89212142	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	58.2	2.03e-6	NR	MCL4280086.1	2651163	g55381	i0	27.3	2.8695652173913	121	87	71.1	1	466	107	166	286	MCL4280086.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	1452	58.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
31106756	31106756	PRJEB10140_P_NODE_264935_length_166_cov_0.888889_g247626_i0	PRJEB10140	264935	166	0.888889	1.47555574	Ignavibacterium sp.	2651167	Bacteria	Bacteria	77.8	4.29e-15	NR	MCX7610404.1	2651167	g247626	i0	67.3	1.98795180722892	55	18	99.4	0	2	166	149	203	MCX7610404.1 phage major capsid protein [Ignavibacterium sp.]	diamond	330	77.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
31518048	31518048	PRJEB10140_P_NODE_212596_length_187_cov_1.463768_g195287_i0	PRJEB10140	212596	187	1.463768	2.73724616	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	63.9	5.62e-10	NR	MBL8016171.1	2053306	g195287	i0	50	0.93048128342246	58	29	93	0	185	12	202	259	MBL8016171.1 caspase family protein [Ignavibacteria bacterium]	diamond	174	63.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31834164	31834164	PRJEB10140_P_NODE_87557_length_418_cov_2.173442_g70279_i0	PRJEB10140	87557	418	2.173442	9.08498756	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	45.1	0.0343	NR	MBI9072100.1	2614255	g70279	i0	33.8	0.552631578947368	77	42	48.8	3	163	366	380	456	MBI9072100.1 response regulator [Melioribacteraceae bacterium]	diamond	231	45.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
32650144	32650144	PRJEB10140_P_NODE_253640_length_168_cov_0.865546_g236331_i0	PRJEB10140	253640	168	0.865546	1.45411728	Pseudomonadati	3379134	Bacteria	Bacteria	107	2.06e-25	NR	MCX6170435.1	2049428	g236331	i0	90.9	1.96428571428571	55	5	98.2	0	166	2	219	273	MCX6170435.1 amidase [Ignavibacteriales bacterium]	diamond	330	107	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
32687908	32687908	PRJEB10140_P_NODE_96060_length_381_cov_1.837349_g78766_i0	PRJEB10140	96060	381	1.837349	7.00029969	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	155	1.28e-45	NR	MBL8008632.1	2053306	g78766	i0	65.9	0.968503937007874	123	41	96.1	1	15	380	25	147	MBL8008632.1 hypothetical protein [Ignavibacteria bacterium]	diamond	369	155	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;