metadata: contig_metadata: 15 rows where bioproject = "PRJEB64798" and tax

15 rows where bioproject = "PRJEB64798" 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
15432161	15432161	PRJEB64798_P_NODE_86993_length_212_cov_15.190184_g85227_i0	PRJEB64798	86993	212	15.190184	32.20319008	Pseudomonadati	3379134	Bacteria	Bacteria	65.5	2.41e-10	NR	MBT3299657.1	2026760	g85227	i0	54.2	72.5660377358491	59	21	83.5	1	177	1	1	53	MBT3299657.1 excinuclease ABC subunit UvrA [Fidelibacterota bacterium]	diamond	15384	65.9	0.993930197268589	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
23081055	23081055	PRJEB64798_P_NODE_52019_length_271_cov_6.626126_g50254_i0	PRJEB64798	52019	271	6.626126	17.95680146	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	109	1.44e-25	NR	MBO01610.1	2026760	g50254	i0	61.8	1.97047970479705	89	34	98.5	0	3	269	115	203	MBO01610.1 elongation factor G [Fidelibacterota bacterium]	diamond	534	109	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27191642	27191642	PRJEB64798_P_NODE_164562_length_181_cov_4.219697_g162796_i0	PRJEB64798	164562	181	4.219697	7.63765157	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	49.7	5.6e-5	NR	MDD5766468.1	2026760	g162796	i0	41.4	2.88397790055249	58	33	96.1	1	176	3	495	551	MDD5766468.1 T9SS type A sorting domain-containing protein [Fidelibacterota bacterium]	diamond	522	49.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28455216	28455216	PRJEB64798_P_NODE_250966_length_151_cov_8.882353_g249200_i0	PRJEB64798	250966	151	8.882353	13.41235303	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	60.1	7.4e-9	NR	MAP67221.1	2026760	g249200	i0	57.4	1.8476821192053	47	19	93.4	1	146	6	132	177	MAP67221.1 UV damage repair endonuclease UvsE [Fidelibacterota bacterium]	diamond	279	60.1	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28770698	28770698	PRJEB64798_P_NODE_236747_length_156_cov_5.018692_g234981_i0	PRJEB64798	236747	156	5.018692	7.82915952	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	82.4	3.38e-17	NR	MCJ7802608.1	2026760	g234981	i0	78.4	0.980769230769231	51	11	98.1	0	155	3	55	105	MCJ7802608.1 cysteine desulfurase [Fidelibacterota bacterium]	diamond	153	82.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29212947	29212947	PRJEB64798_P_NODE_202829_length_166_cov_16.717949_g201063_i0	PRJEB64798	202829	166	16.717949	27.75179534	Fidelibacterota bacterium 46_43	1635280	Bacteria	Bacteria	44.3	0.00214	NR	KUK92034.1	1635280	g201063	i0	49.1	0.957831325301205	53	27	95.8	0	165	7	73	125	KUK92034.1 MAG: hypothetical protein XE04_0694 [Fidelibacterota bacterium 46_43]	diamond	159	44.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium 46_43
30697135	30697135	PRJEB64798_P_NODE_180634_length_174_cov_2.912000_g178868_i0	PRJEB64798	180634	174	2.912	5.06688	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	41.6	0.0154	NR	MDP6338739.1	2026760	g178868	i0	44.2	0.741379310344828	43	24	74.1	0	169	41	80	122	MDP6338739.1 hypothetical protein [Fidelibacterota bacterium]	diamond	129	41.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30753602	30753602	PRJEB64798_P_NODE_240294_length_155_cov_3.235849_g238528_i0	PRJEB64798	240294	155	3.235849	5.01556595	FCB group	1783270	Bacteria	Bacteria	58.5	8.63e-9	NR	RKY53294.1	2026760	g238528	i0	80.6	11.4387096774194	31	6	60	0	149	57	1	31	RKY53294.1 MAG: glycosyl hydrolase, partial [Fidelibacterota bacterium]	diamond	1773	58.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31551019	31551019	PRJEB64798_P_NODE_45476_length_291_cov_13.698347_g43711_i0	PRJEB64798	45476	291	13.698347	39.86218977	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	49.3	3.31e-4	NR	MAP67231.1	2026760	g43711	i0	35.6	1.04123711340206	101	54	94.8	4	278	3	892	990	MAP67231.1 hypothetical protein [Fidelibacterota bacterium]	diamond	303	49.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31645355	31645355	PRJEB64798_P_NODE_115537_length_208_cov_12.213836_g113771_i0	PRJEB64798	115537	208	12.213836	25.40477888	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	67	6.54e-11	NR	MBT4661501.1	2026760	g113771	i0	43.2	1.26923076923077	88	30	98.1	2	207	4	106	193	MBT4661501.1 DNA polymerase [Fidelibacterota bacterium]	diamond	264	67	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32563296	32563296	PRJEB64798_P_NODE_138059_length_194_cov_6.544828_g136293_i0	PRJEB64798	138059	194	6.544828	12.69696632	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	66.6	7.15e-11	NR	HIB32903.1	2026760	g136293	i0	74	2.11855670103093	50	10	77.3	1	1	150	338	384	HIB32903.1 replicative DNA helicase [Fidelibacterota bacterium]	diamond	411	66.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32587949	32587949	PRJEB64798_P_NODE_223879_length_161_cov_3.410714_g222113_i0	PRJEB64798	223879	161	3.410714	5.49124954	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	3.56e-7	NR	MDP7608612.1	2026760	g222113	i0	47.1	2.66459627329193	51	27	95	0	160	8	84	134	MDP7608612.1 hypothetical protein [Fidelibacterota bacterium]	diamond	429	55.1	0.992740471869329	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32619192	32619192	PRJEB64798_P_NODE_189920_length_170_cov_5.239669_g188154_i0	PRJEB64798	189920	170	5.239669	8.9074373	Pseudomonadati	3379134	Bacteria	Bacteria	55.5	4.49e-7	NR	MCF7803953.1	2026760	g188154	i0	50	2.77058823529412	54	27	95.3	0	8	169	439	492	MCF7803953.1 DegV family EDD domain-containing protein [Fidelibacterota bacterium]	diamond	471	55.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32657351	32657351	PRJEB64798_P_NODE_80820_length_214_cov_7.139394_g79054_i0	PRJEB64798	80820	214	7.139394	15.27830316	Fidelibacterota bacterium CG	2026760	Bacteria	Bacteria	51.6	1.9e-5	NR	PIS31213.1	1975524	g79054	i0	40.9	0.925233644859813	66	37	92.5	1	13	210	274	337	PIS31213.1 MAG: hypothetical protein COT43_00120 [Fidelibacterota bacterium CG08_land_8_20_14_0_20_45_22]	diamond	198	51.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium CG08_land_8_20_14_0_20_45_22
32783537	32783537	PRJEB64798_P_NODE_91280_length_212_cov_6.006135_g89514_i0	PRJEB64798	91280	212	6.006135	12.7330062	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	46.6	8.19e-4	NR	MCS5615199.1	2026760	g89514	i0	62.5	0.566037735849057	40	15	56.6	0	121	2	9	48	MCS5615199.1 trypsin-like peptidase domain-containing protein [Fidelibacterota bacterium]	diamond	120	46.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);;