metadata: contig_metadata: 14 rows where bioproject = "PRJNA939415" and tax

14 rows where bioproject = "PRJNA939415" 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
2532479	2532479	PRJNA939415_P_NODE_88382_length_247_cov_0.885057_g87960_i0	PRJNA939415	88382	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	307	4.32e-79	NTclustered	gi\|1938788434\|gb\|CP054181.1\|	2053306	g87960	i0	89.069	99.2631578947368	247	27	100	0	1	247	1073711	1073957	Ignavibacteria bacterium isolate H1_BAC2 chromosome	blastn	24518	307	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
21317824	21317824	PRJNA939415_P_NODE_54737_length_279_cov_1.567961_g54315_i0	PRJNA939415	54737	279	1.567961	4.37461119	Bacteria	2	Bacteria	Bacteria	182	3.9e-52	NR	RPI01485.1	2026749	g54315	i0	93.5	5	93	6	100	0	279	1	181	273	RPI01485.1 MAG: preprotein translocase subunit SecA, partial [Ignavibacteriota bacterium]	diamond	1395	183	0.994535519125683	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
26778905	26778905	PRJNA939415_P_NODE_22801_length_325_cov_3.376984_g22380_i0	PRJNA939415	22801	325	3.376984	10.975198	root	1	Root_unresolved	Root_unresolved	194	1.78e-58	NR	MCB0703597.1	2026749	g22380	i0	82.2	2.95384615384615	107	19	98.8	0	3	323	195	301	MCB0703597.1 DUF262 domain-containing protein [Ignavibacteriota bacterium]	diamond	960	194	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
27000175	27000175	PRJNA939415_P_NODE_15282_length_397_cov_1.567901_g14862_i0	PRJNA939415	15282	397	1.567901	6.22456697	FCB group	1783270	Bacteria	Bacteria	107	8.860000000000001e-27	NR	GMU87236.1	2049428	g14862	i0	47.2	3.79345088161209	125	65	93.7	1	397	26	8	132	GMU87236.1 MAG: N-acetyltransferase [Ignavibacteriales bacterium]	diamond	1506	107	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
27088435	27088435	PRJNA939415_P_NODE_59222_length_274_cov_3.597015_g58800_i0	PRJNA939415	59222	274	3.597015	9.8558211	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	133	1.4299999999999998e-37	NR	MCU0414782.1	2651163	g58800	i0	71.4	1.99270072992701	91	25	99.6	1	274	2	59	148	MCU0414782.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	546	133	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27593923	27593923	PRJNA939415_P_NODE_35004_length_308_cov_2.272340_g34582_i0	PRJNA939415	35004	308	2.27234	6.9988072	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	89.4	1.34e-18	NR	MBE2218426.1	2053306	g34582	i0	42.2	0.993506493506494	102	57	99.4	1	306	1	224	323	MBE2218426.1 DUF3298 domain-containing protein [Ignavibacteria bacterium]	diamond	306	89.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28130627	28130627	PRJNA939415_P_NODE_101505_length_232_cov_4.358491_g101083_i0	PRJNA939415	101505	232	4.358491	10.11169912	Ignavibacterium sp.	2651167	Bacteria	Bacteria	76.6	3.63e-14	NR	WP_297839416.1	2651167	g101083	i0	66	2.74137931034483	53	18	68.5	0	228	70	443	495	WP_297839416.1 cryptochrome/photolyase family protein [Ignavibacterium sp.]	diamond	636	76.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
28484849	28484849	PRJNA939415_P_NODE_58426_length_275_cov_2.752475_g58004_i0	PRJNA939415	58426	275	2.752475	7.56930625	FCB group	1783270	Bacteria	Bacteria	94	3.17e-20	NR	MCX7879594.1	2053306	g58004	i0	57.6	6.69818181818182	85	36	92.7	0	257	3	270	354	MCX7879594.1 competence/damage-inducible protein A [Ignavibacteria bacterium]	diamond	1842	94.7	0.992608236536431	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29361963	29361963	PRJNA939415_P_NODE_24509_length_312_cov_1.815900_g24087_i0	PRJNA939415	24509	312	1.8159	5.665608	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	75.1	2.98e-13	NR	MBI1804135.1	2053306	g24087	i0	46.3	4.56730769230769	80	41	75	1	312	79	306	385	MBI1804135.1 beta-propeller fold lactonase family protein [Ignavibacteria bacterium]	diamond	1425	75.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30095091	30095091	PRJNA939415_P_NODE_15952_length_389_cov_2.344937_g15532_i0	PRJNA939415	15952	389	2.344937	9.12180493	Bacteria	2	Bacteria	Bacteria	93.6	1.2600000000000002e-21	NR	MBI5471162.1	2026749	g15532	i0	47.4	4.1413881748072	97	50	74	1	100	387	4	100	MBI5471162.1 DUF423 domain-containing protein [Ignavibacteriota bacterium]	diamond	1611	93.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30404716	30404716	PRJNA939415_P_NODE_94933_length_241_cov_3.482143_g94511_i0	PRJNA939415	94933	241	3.482143	8.39196463	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	62.8	3.25e-9	NR	MBI5214917.1	2026749	g94511	i0	47.2	0.659751037344398	53	28	66	0	240	82	1047	1099	MBI5214917.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	159	62.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
31225555	31225555	PRJNA939415_P_NODE_15695_length_392_cov_2.326019_g15275_i0	PRJNA939415	15695	392	2.326019	9.11799448	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	89	9.35e-18	NR	HED38278.1	2053306	g15275	i0	40.2	0.857142857142857	112	65	85.7	1	356	21	79	188	HED38278.1 hypothetical protein [Ignavibacteria bacterium]	diamond	336	89	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31384013	31384013	PRJNA939415_P_NODE_44016_length_289_cov_3.694444_g43594_i0	PRJNA939415	44016	289	3.694444	10.67694316	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	102	6.669999999999999e-23	NR	MCF8259790.1	2614255	g43594	i0	51	1.99307958477509	96	47	99.7	0	288	1	387	482	MCF8259790.1 carbohydrate kinase [Melioribacteraceae bacterium]	diamond	576	102	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
32491256	32491256	PRJNA939415_P_NODE_101439_length_232_cov_4.968553_g101017_i0	PRJNA939415	101439	232	4.968553	11.52704296	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	54.3	5.64e-7	NR	MCX6161168.1	2026749	g101017	i0	41.4	0.905172413793103	70	37	86.6	2	10	210	45	113	MCX6161168.1 DcaP family trimeric outer membrane transporter [Ignavibacteriota bacterium]	diamond	210	54.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota 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);;