metadata: contig_metadata: 5 rows where bioproject = "PRJNA980585" and tax

5 rows where bioproject = "PRJNA980585" 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
26709309	26709309	PRJNA980585_P_NODE_62181_length_226_cov_2.006536_g61927_i0	PRJNA980585	62181	226	2.006536	4.53477136	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	58.2	1.06e-7	NR	MFQ6606286.1	2026760	g61927	i0	39.7	1.55309734513274	68	36	90.3	1	6	209	97	159	MFQ6606286.1 AMP-dependent synthetase/ligase [Fidelibacterota bacterium]	diamond	351	58.2	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28826010	28826010	PRJNA980585_P_NODE_21788_length_313_cov_1.283333_g21534_i0	PRJNA980585	21788	313	1.283333	4.01683229	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	55.1	4.18e-6	NR	MFC1483700.1	2026760	g21534	i0	41	0.747603833865815	78	44	74.8	1	271	38	379	454	MFC1483700.1 T9SS type A sorting domain-containing protein [Fidelibacterota bacterium]	diamond	234	55.1	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29173742	29173742	PRJNA980585_P_NODE_18369_length_334_cov_0.885057_g18115_i0	PRJNA980585	18369	334	0.885057	2.95609038	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	46.6	0.00171	NR	MDA8753885.1	2026760	g18115	i0	30.4	0.709580838323353	79	51	71	2	275	39	23	97	MDA8753885.1 GAF domain-containing protein [Fidelibacterota bacterium]	diamond	237	46.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29274245	29274245	PRJNA980585_P_NODE_39589_length_253_cov_1.383333_g39335_i0	PRJNA980585	39589	253	1.383333	3.49983249	Bacteria	2	Bacteria	Bacteria	97.4	6.51e-22	NR	MEL1234496.1	2026760	g39335	i0	54.2	2.95256916996047	83	38	98.4	0	251	3	87	169	MEL1234496.1 DUF885 domain-containing protein [Fidelibacterota bacterium]	diamond	747	97.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30879197	30879197	PRJNA980585_P_NODE_46134_length_248_cov_1.651429_g45880_i0	PRJNA980585	46134	248	1.651429	4.09554392	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	48.5	3.69e-4	NR	GIS03688.1	2026760	g45880	i0	61.3	3.78629032258065	31	12	37.5	0	235	143	33	63	GIS03688.1 MAG: hypothetical protein CM15mP106_1350 [Fidelibacterota bacterium]	diamond	939	48.5	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);;