metadata: contig_metadata: 14 rows where bioproject = "PRJNA1028258", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA1028258", tax_clade = "FCB group" 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
163299	163299	PRJNA1028258_P_NODE_123421_length_241_cov_1.930233_g122858_i0	PRJNA1028258	123421	241	1.930233	4.65186153	Pseudomonadati	3379134	Bacteria	Bacteria	127	4.4899999999999997e-32	NR	MBK7986584.1	2053306	g122858	i0	83.8	1.99170124481328	80	13	99.6	0	2	241	317	396	MBK7986584.1 type I DNA topoisomerase [Ignavibacteria bacterium]	diamond	480	127	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
23958101	23958101	PRJNA1028258_P_NODE_53699_length_347_cov_1.021583_g53136_i0	PRJNA1028258	53699	347	1.021583	3.54489301	Pseudomonadati	3379134	Bacteria	Bacteria	99	4.86e-22	NR	MBN8545414.1	2053306	g53136	i0	45.2	5.02305475504323	115	49	99.4	1	347	3	50	150	MBN8545414.1 RNA ligase (ATP) [Ignavibacteria bacterium]	diamond	1743	99	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
24390138	24390138	PRJNA1028258_P_NODE_169940_length_226_cov_1.681529_g169377_i0	PRJNA1028258	169940	226	1.681529	3.80025554	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	58.4	4.32e-4	NTclustered	gi\|2621704225\|emb\|OY761615.1\|	2651163	g169377	i0	100	0.265486725663717	31	0	14	0	25	55	3872139	3872169	MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1	blastn	60	58.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
26647030	26647030	PRJNA1028258_P_NODE_173821_length_225_cov_2.371795_g173258_i0	PRJNA1028258	173821	225	2.371795	5.33653875	Pseudomonadati	3379134	Bacteria	Bacteria	124	5.68e-33	NR	MBK7987894.1	2053306	g173258	i0	74.7	2	75	19	100	0	1	225	8	82	MBK7987894.1 DUF1573 domain-containing protein [Ignavibacteria bacterium]	diamond	450	124	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
27785514	27785514	PRJNA1028258_P_NODE_106404_length_255_cov_1.790323_g105841_i0	PRJNA1028258	106404	255	1.790323	4.56532365	Pseudomonadati	3379134	Bacteria	Bacteria	121	4.2000000000000004e-30	NR	MBK7986661.1	2053306	g105841	i0	67.9	4.94117647058824	84	27	98.8	0	254	3	271	354	MBK7986661.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	1260	121	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28164237	28164237	PRJNA1028258_P_NODE_112785_length_250_cov_1.458564_g112222_i0	PRJNA1028258	112785	250	1.458564	3.64641	Pseudomonadati	3379134	Bacteria	Bacteria	111	6.910000000000001e-27	NR	MBK7987578.1	2053306	g112222	i0	65.3	2.652	75	26	90	0	249	25	230	304	MBK7987578.1 hypothetical protein [Ignavibacteria bacterium]	diamond	663	111	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28929922	28929922	PRJNA1028258_P_NODE_67108_length_313_cov_1.036885_g66545_i0	PRJNA1028258	67108	313	1.036885	3.24545005	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	77	7.19e-14	NR	MEO6695585.1	2053306	g66545	i0	41.7	0.920127795527157	96	52	90.1	2	30	311	27	120	MEO6695585.1 hypothetical protein [Ignavibacteria bacterium]	diamond	288	77	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
30856474	30856474	PRJNA1028258_P_NODE_100394_length_260_cov_1.926702_g99831_i0	PRJNA1028258	100394	260	1.926702	5.0094252	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	44.7	0.00964	NR	MCU7490130.1	2053306	g99831	i0	45.7	1.35	46	25	53.1	0	46	183	493	538	MCU7490130.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	351	44.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
31101224	31101224	PRJNA1028258_P_NODE_101115_length_260_cov_1.136126_g100552_i0	PRJNA1028258	101115	260	1.136126	2.9539276	Bacteria	2	Bacteria	Bacteria	73.9	3.95e-14	NR	MBX3007277.1	2614255	g100552	i0	49.1	2.88461538461538	57	29	65.8	0	221	51	107	163	MBX3007277.1 lipocalin family protein [Melioribacteraceae bacterium]	diamond	750	73.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
31986830	31986830	PRJNA1028258_P_NODE_179438_length_222_cov_2.542484_g178875_i0	PRJNA1028258	179438	222	2.542484	5.64431448	Pseudomonadati	3379134	Bacteria	Bacteria	88.2	2.77e-18	NR	MBK7986087.1	2053306	g178875	i0	54.2	3.89189189189189	72	33	97.3	0	2	217	742	813	MBK7986087.1 PKD domain-containing protein [Ignavibacteria bacterium]	diamond	864	88.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32216487	32216487	PRJNA1028258_P_NODE_70318_length_306_cov_1.683544_g69755_i0	PRJNA1028258	70318	306	1.683544	5.15164464	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	71.6	4.41e-12	NR	MFA7290324.1	2614255	g69755	i0	44.1	1.82352941176471	93	40	85.3	2	262	2	36	122	MFA7290324.1 T9SS type A sorting domain-containing protein [Melioribacteraceae bacterium]	diamond	558	71.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
32406318	32406318	PRJNA1028258_P_NODE_179759_length_221_cov_2.203947_g179196_i0	PRJNA1028258	179759	221	2.203947	4.87072287	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	65.1	3.61e-10	NR	MBK7986791.1	2053306	g179196	i0	51.4	1.94117647058824	70	34	95	0	2	211	147	216	MBK7986791.1 O-antigen ligase family protein [Ignavibacteria bacterium]	diamond	429	65.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32721889	32721889	PRJNA1028258_P_NODE_152880_length_230_cov_1.639752_g152317_i0	PRJNA1028258	152880	230	1.639752	3.7714296	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	159	1.06e-43	NR	MBK7987829.1	2053306	g152317	i0	98.7	0.991304347826087	76	1	99.1	0	3	230	474	549	MBK7987829.1 elongation factor G [Ignavibacteria bacterium]	diamond	228	159	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32753359	32753359	PRJNA1028258_P_NODE_174200_length_225_cov_1.692308_g173637_i0	PRJNA1028258	174200	225	1.692308	3.807693	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	95.1	8.650000000000001e-21	NR	MBK7985650.1	2053306	g173637	i0	71.1	1.01333333333333	76	21	100	1	1	225	24	99	MBK7985650.1 flagellar filament capping protein FliD [Ignavibacteria bacterium]	diamond	228	95.1	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);;