metadata: contig_metadata: 11 rows where bioproject = "PRJNA1011844", tax_clade = "FCB group" and tax

11 rows where bioproject = "PRJNA1011844", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"

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_species
14185052	14185052	PRJNA1011844_P_NODE_166212_length_234_cov_2.987578_g157631_i0	PRJNA1011844	166212	234	2.987578	6.99093252	FCB group	1783270	Bacteria	Bacteria	109	9.18e-26	NR	MAG21066.1	2026760	g157631	i0	69.9	6.51282051282051	73	22	93.6	0	15	233	434	506	MAG21066.1 NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	1524	109	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
22678625	22678625	PRJNA1011844_P_NODE_1278_length_3833_cov_69.806915_g680_i1	PRJNA1011844	1278	3833	69.806915	2675.69905195	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	451	3.61e-134	NR	MBT5268102.1	2026760	g680	i1	30.8	0.807722410644404	1032	656	78.4	19	3127	122	159	1162	MBT5268102.1 hypothetical protein [Fidelibacterota bacterium]	diamond	3096	451	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27414309	27414309	PRJNA1011844_P_NODE_41443_length_741_cov_3.395210_g33579_i0	PRJNA1011844	41443	741	3.39521	25.1585061	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	54.7	9.35e-5	NR	MEL1231778.1	2026760	g33579	i0	31.8	0.534412955465587	132	69	44.9	4	8	340	21	152	MEL1231778.1 hypothetical protein [Fidelibacterota bacterium]	diamond	396	54.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28613868	28613868	PRJNA1011844_P_NODE_35167_length_848_cov_3.425806_g27843_i0	PRJNA1011844	35167	848	3.425806	29.05083488	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	217	7.039999999999999e-66	NR	MCJ7802071.1	2026760	g27843	i0	48.4	0.76061320754717	215	108	75.4	3	8	646	58	271	MCJ7802071.1 lipase family protein [Fidelibacterota bacterium]	diamond	645	217	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29521777	29521777	PRJNA1011844_P_NODE_57790_length_546_cov_3.539112_g49421_i0	PRJNA1011844	57790	546	3.539112	19.32355152	Bacteria	2	Bacteria	Bacteria	89	7.65e-17	NR	HDR03854.1	2026760	g49421	i0	39.5	1.63186813186813	147	83	80.2	3	5	442	157	298	HDR03854.1 hypothetical protein [Fidelibacterota bacterium]	diamond	891	89	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29971574	29971574	PRJNA1011844_P_NODE_179331_length_201_cov_4.382812_g170749_i0	PRJNA1011844	179331	201	4.382812	8.80945212	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	67.8	2.93e-11	NR	MFA4838251.1	2026760	g170749	i0	54.7	0.955223880597015	64	27	95.5	1	3	194	91	152	MFA4838251.1 serine hydrolase [Fidelibacterota bacterium]	diamond	192	67.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30090146	30090146	PRJNA1011844_P_NODE_92932_length_349_cov_1.072464_g84373_i0	PRJNA1011844	92932	349	1.072464	3.74289936	Pseudomonadati	3379134	Bacteria	Bacteria	50.1	3.11e-4	NR	MBF88572.1	2026760	g84373	i0	57.1	0.945558739255014	35	15	30.1	0	322	218	339	373	MBF88572.1 aminotransferase [Fidelibacterota bacterium]	diamond	330	50.1	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30224262	30224262	PRJNA1011844_P_NODE_2392_length_3099_cov_18.685724_g1092_i1	PRJNA1011844	2392	3099	18.685724	579.07058676	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	63.5	3.12e-7	NR	PCJ12276.1	2026760	g1092	i1	36.5	0.0929332042594385	96	59	9.3	1	846	559	96	189	PCJ12276.1 MAG: hypothetical protein COA98_05575, partial [Fidelibacterota bacterium]	diamond	288	63.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30792961	30792961	PRJNA1011844_P_NODE_150874_length_248_cov_0.834286_g142295_i0	PRJNA1011844	150874	248	0.834286	2.06902928	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	119	2.14e-29	NR	MBI65199.1	2026760	g142295	i0	62.2	6.87096774193548	82	31	99.2	0	2	247	199	280	MBI65199.1 beta-glucosidase [Fidelibacterota bacterium]	diamond	1704	119	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31773047	31773047	PRJNA1011844_P_NODE_1697_length_3490_cov_17.315774_g1092_i0	PRJNA1011844	1697	3490	17.315774	604.3205126	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	63.5	3.56e-7	NR	PCJ12276.1	2026760	g1092	i0	36.5	0.0825214899713467	96	59	8.3	1	846	559	96	189	PCJ12276.1 MAG: hypothetical protein COA98_05575, partial [Fidelibacterota bacterium]	diamond	288	63.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32279654	32279654	PRJNA1011844_P_NODE_84199_length_381_cov_5.931818_g75654_i0	PRJNA1011844	84199	381	5.931818	22.60022658	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	41.6	0.0324	NR	MCJ7801247.1	2026760	g75654	i0	57.1	0.275590551181102	35	13	26	1	314	216	2	36	MCJ7801247.1 hypothetical protein [Fidelibacterota bacterium]	diamond	105	41.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota 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);;