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

10 rows where bioproject = "PRJNA438111" 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_species
27202220	27202220	PRJNA438111_P_NODE_80742_length_157_cov_3.328125_g80117_i0	PRJNA438111	80742	157	3.328125	5.22515625	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	53.1	2.37e-6	NR	HSP88578.1	2651163	g80117	i0	54.2	0.917197452229299	48	18	91.7	1	155	12	269	312	HSP88578.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Ignavibacteriaceae bacterium]	diamond	144	53.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
28370765	28370765	PRJNA438111_P_NODE_69806_length_164_cov_6.288889_g69181_i0	PRJNA438111	69806	164	6.288889	10.31377796	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	43.5	0.00107	NR	MDZ7764720.1	2614255	g69181	i0	43.5	0.841463414634146	46	26	84.1	0	8	145	5	50	MDZ7764720.1 hypothetical protein [Melioribacteraceae bacterium]	diamond	138	43.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
29002763	29002763	PRJNA438111_P_NODE_71088_length_164_cov_1.051852_g70463_i0	PRJNA438111	71088	164	1.051852	1.72503728	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	60.5	6.75e-9	NR	MBI5020544.1	2049428	g70463	i0	56	0.914634146341463	50	22	91.5	0	1	150	167	216	MBI5020544.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	150	60.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
29317950	29317950	PRJNA438111_P_NODE_14129_length_278_cov_2.554217_g13504_i0	PRJNA438111	14129	278	2.554217	7.10072326	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	77.4	3.7e-14	NR	MCB0731344.1	2026749	g13504	i0	38.9	2.01798561151079	95	54	99.3	2	278	3	581	674	MCB0731344.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	561	77.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
29696517	29696517	PRJNA438111_P_NODE_21010_length_234_cov_13.458537_g20385_i0	PRJNA438111	21010	234	13.458537	31.49297658	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	49.7	1.19e-4	NR	MCB0731344.1	2026749	g20385	i0	49	1.17948717948718	49	20	57.7	2	221	87	624	671	MCB0731344.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	276	49.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
30345586	30345586	PRJNA438111_P_NODE_3992_length_493_cov_7.812500_g3466_i0	PRJNA438111	3992	493	7.8125	38.515625	Bacteria	2	Bacteria	Bacteria	58.5	3.93e-7	NR	QQS34838.1	2049428	g3466	i0	34.1	2.58620689655172	88	57	53.5	1	20	283	94	180	QQS34838.1 MAG: DUF4476 domain-containing protein [Ignavibacteriales bacterium]	diamond	1275	58.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
32383832	32383832	PRJNA438111_P_NODE_35639_length_203_cov_3.109195_g35014_i0	PRJNA438111	35639	203	3.109195	6.31166585	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	72.8	5.64e-13	NR	MCB0731344.1	2026749	g35014	i0	47.8	2.00985221674877	69	34	99	1	1	201	589	657	MCB0731344.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	408	72.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
32699500	32699500	PRJNA438111_P_NODE_41860_length_191_cov_4.888889_g41235_i0	PRJNA438111	41860	191	4.888889	9.33777799	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	57	1.72e-7	NR	MCX6143336.1	2049428	g41235	i0	75	6.04712041884817	40	10	62.8	0	189	70	225	264	MCX6143336.1 class I SAM-dependent DNA methyltransferase [Ignavibacteriales bacterium]	diamond	1155	57	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
32841771	32841771	PRJNA438111_P_NODE_71100_length_164_cov_1.051852_g70475_i0	PRJNA438111	71100	164	1.051852	1.72503728	Bacteria	2	Bacteria	Bacteria	67.8	1.86e-11	NR	MBI4810933.1	2049428	g70475	i0	56.6	5.90853658536585	53	23	97	0	5	163	9	61	MBI4810933.1 PAS domain S-box protein [Ignavibacteriales bacterium]	diamond	969	67.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
32888384	32888384	PRJNA438111_P_NODE_40660_length_193_cov_3.890244_g40035_i0	PRJNA438111	40660	193	3.890244	7.50817092	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	115	2.98e-28	NR	MBN8571997.1	2053306	g40035	i0	98.4	0.994818652849741	64	1	99.5	0	2	193	303	366	MBN8571997.1 sodium:solute symporter [Ignavibacteria bacterium]	diamond	192	115	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);;