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

6 rows where bioproject = "PRJNA773247", 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
28411467	28411467	PRJNA773247_P_NODE_24246_length_285_cov_10.504717_g24162_i0	PRJNA773247	24246	285	10.504717	29.93844345	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	77.4	3.92e-14	NR	MFA5436705.1	2026760	g24162	i0	41.8	0.957894736842105	91	51	95.8	1	281	9	488	576	MFA5436705.1 DEAD/DEAH box helicase family protein [Fidelibacterota bacterium]	diamond	273	77.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29178814	29178814	PRJNA773247_P_NODE_11729_length_449_cov_1.763298_g11646_i0	PRJNA773247	11729	449	1.763298	7.91720802	FCB group	1783270	Bacteria	Bacteria	68.2	4.4e-10	NR	MFA7195739.1	2026760	g11646	i0	38.3	1.42984409799555	107	59	66.8	3	445	146	478	584	MFA7195739.1 hypothetical protein [Fidelibacterota bacterium]	diamond	642	68.2	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29421526	29421526	PRJNA773247_P_NODE_23089_length_294_cov_1.565611_g23005_i0	PRJNA773247	23089	294	1.565611	4.60289634	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	58.2	1.34e-8	NR	MBT4130952.1	2026760	g23005	i0	47.5	1.19387755102041	59	28	59.2	2	2	175	33	89	MBT4130952.1 hypothetical protein [Fidelibacterota bacterium]	diamond	351	58.2	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29610849	29610849	PRJNA773247_P_NODE_16910_length_355_cov_5.184397_g16826_i0	PRJNA773247	16910	355	5.184397	18.40460935	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	95.5	5.02e-23	NR	MEE9571970.1	2026760	g16826	i0	57.3	0.633802816901408	75	32	63.4	0	353	129	10	84	MEE9571970.1 hypothetical protein [Fidelibacterota bacterium]	diamond	225	95.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30685098	30685098	PRJNA773247_P_NODE_14153_length_398_cov_4.587692_g14069_i0	PRJNA773247	14153	398	4.587692	18.25901416	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	48.9	4.25e-4	NR	MBT6472492.1	2026760	g14069	i0	38.2	0.57286432160804	76	46	57.3	1	132	359	16	90	MBT6472492.1 hypothetical protein [Fidelibacterota bacterium]	diamond	228	48.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32456341	32456341	PRJNA773247_P_NODE_21759_length_304_cov_11.502165_g21675_i0	PRJNA773247	21759	304	11.502165	34.9665816	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	57.4	4.72e-7	NR	MFA5706304.1	2026760	g21675	i0	46.2	0.513157894736842	52	28	51.3	0	140	295	1	52	MFA5706304.1 hypothetical protein [Fidelibacterota bacterium]	diamond	156	57.4	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);;