metadata: contig_metadata: 6 rows where bioproject = "PRJEB11748", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJEB11748", 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
26678224	26678224	PRJEB11748_P_NODE_81881_length_464_cov_2.607940_g79716_i0	PRJEB11748	81881	464	2.60794	12.1008416	root	1	Root_unresolved	Root_unresolved	127	4.41e-32	NR	MBC8257279.1	2026760	g79716	i0	57.1	5.22413793103448	112	47	71.8	1	343	11	175	286	MBC8257279.1 phosphonopyruvate decarboxylase [Fidelibacterota bacterium]	diamond	2424	127	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27317438	27317438	PRJEB11748_P_NODE_142203_length_345_cov_6.073944_g140024_i0	PRJEB11748	142203	345	6.073944	20.9551068	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	93.6	1.98e-19	NR	MDG1089699.1	2026760	g140024	i0	54.8	6.40869565217391	93	42	80.9	0	297	19	59	151	MDG1089699.1 phage tail tape measure protein [Fidelibacterota bacterium]	diamond	2211	93.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27722084	27722084	PRJEB11748_P_NODE_111924_length_393_cov_6.400602_g109750_i0	PRJEB11748	111924	393	6.400602	25.15436586	root	1	Root_unresolved	Root_unresolved	138	5.49e-35	NR	MCF7804398.1	2026760	g109750	i0	54	15.763358778626	124	56	93.9	1	382	14	177	300	MCF7804398.1 M1 family metallopeptidase [Fidelibacterota bacterium]	diamond	6195	138	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29527789	29527789	PRJEB11748_P_NODE_94790_length_429_cov_14.301630_g92622_i0	PRJEB11748	94790	429	14.30163	61.3539927	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	57.8	1.3e-6	NR	MFL2983777.1	2026760	g92622	i0	37.7	0.482517482517482	69	40	46.2	2	404	207	58	126	MFL2983777.1 GNAT family N-acetyltransferase [Fidelibacterota bacterium]	diamond	207	57.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30980962	30980962	PRJEB11748_P_NODE_273274_length_233_cov_3.098837_g271091_i0	PRJEB11748	273274	233	3.098837	7.22029021	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	84.3	7.17e-17	NR	MFQ6613057.1	2026760	g271091	i0	56.4	1.00429184549356	78	31	96.6	2	229	5	79	156	MFQ6613057.1 hypothetical protein [Fidelibacterota bacterium]	diamond	234	84.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31834320	31834320	PRJEB11748_P_NODE_273177_length_233_cov_3.534884_g270994_i0	PRJEB11748	273177	233	3.534884	8.23627972	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	70.9	3.92e-12	NR	MCD6099136.1	2026760	g270994	i0	47.6	0.811158798283262	63	33	81.1	0	212	24	16	78	MCD6099136.1 hypothetical protein [Fidelibacterota bacterium]	diamond	189	70.9	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);;