metadata: contig_metadata: 7 rows where bioproject = "PRJNA741997" and tax

7 rows where bioproject = "PRJNA741997" 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
5026376	5026376	PRJNA741997_P_NODE_52204_length_298_cov_0.773333_g51084_i0	PRJNA741997	52204	298	0.773333	2.30453234	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	96.3	2.5399999999999994e-23	NR	MBL7135702.1	2026760	g51084	i0	58.3	0.845637583892617	84	35	84.6	0	254	3	16	99	MBL7135702.1 50S ribosomal protein L20 [Fidelibacterota bacterium]	diamond	252	96.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28757840	28757840	PRJNA741997_P_NODE_89967_length_241_cov_0.916667_g88847_i0	PRJNA741997	89967	241	0.916667	2.20916747	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	47.8	5.38e-4	NR	MBD24914.1	2026760	g88847	i0	43.2	0.547717842323652	44	25	54.8	0	1	132	213	256	MBD24914.1 hypothetical protein [Fidelibacterota bacterium]	diamond	132	47.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31095084	31095084	PRJNA741997_P_NODE_13575_length_660_cov_1.839864_g12496_i0	PRJNA741997	13575	660	1.839864	12.1431024	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	226	2.61e-70	NR	MCJ7802071.1	2026760	g12496	i0	49.8	0.968181818181818	213	105	95.9	2	660	28	59	271	MCJ7802071.1 lipase family protein [Fidelibacterota bacterium]	diamond	639	226	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31548231	31548231	PRJNA741997_P_NODE_56636_length_285_cov_1.452830_g55516_i0	PRJNA741997	56636	285	1.45283	4.1405655	Bacteria	2	Bacteria	Bacteria	124	1.01e-30	NR	MBL7025556.1	2026760	g55516	i0	63.2	4.96842105263158	95	32	100	1	285	1	348	439	MBL7025556.1 NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	1416	124	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32139018	32139018	PRJNA741997_P_NODE_68698_length_258_cov_1.248649_g67578_i0	PRJNA741997	68698	258	1.248649	3.22151442	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	110	4.73e-26	NR	MBN2279630.1	2026760	g67578	i0	62.4	1.97674418604651	85	32	98.8	0	257	3	367	451	MBN2279630.1 glutamine synthetase III [Fidelibacterota bacterium]	diamond	510	110	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32613291	32613291	PRJNA741997_P_NODE_33540_length_376_cov_1.221122_g32420_i0	PRJNA741997	33540	376	1.221122	4.59141872	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	46.6	0.00707	NR	MDP7558079.1	2026760	g32420	i0	33.3	1.1968085106383	75	49	59	1	71	292	173	247	MDP7558079.1 hypothetical protein [Fidelibacterota bacterium]	diamond	450	46.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32843715	32843715	PRJNA741997_P_NODE_71320_length_251_cov_1.634831_g70200_i0	PRJNA741997	71320	251	1.634831	4.10342581	Pseudomonadati	3379134	Bacteria	Bacteria	85.9	8.74e-18	NR	MCF7804489.1	2026760	g70200	i0	87.5	2.96414342629482	48	6	57.4	0	108	251	5	52	MCF7804489.1 thioredoxin-disulfide reductase [Fidelibacterota bacterium]	diamond	744	85.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);;