metadata: contig_metadata: 5 rows where bioproject = "PRJNA741997", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA741997", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

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_class	tax_order	tax_family	tax_species
27273845	27273845	PRJNA741997_P_NODE_71063_length_252_cov_1.290503_g69943_i0	PRJNA741997	71063	252	1.290503	3.25206756	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	97.4	2.47e-21	NR	MBO4447931.1	2212473	g69943	i0	48.2	12.8452380952381	83	43	98.8	0	1	249	393	475	MBO4447931.1 glycogen/starch/alpha-glucan phosphorylase [Kiritimatiellia bacterium]	diamond	3237	97.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
27652982	27652982	PRJNA741997_P_NODE_84244_length_244_cov_0.900585_g83124_i0	PRJNA741997	84244	244	0.900585	2.1974274	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	77	3.22e-14	NR	MFA7160752.1	2212473	g83124	i0	48.1	0.971311475409836	79	40	97.1	1	7	243	541	618	MFA7160752.1 alpha-mannosidase [Kiritimatiellia bacterium]	diamond	237	77	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
30557826	30557826	PRJNA741997_P_NODE_26013_length_435_cov_1.820442_g24893_i0	PRJNA741997	26013	435	1.820442	7.9189227	Kiritimatiellaceae bacterium	2026752	Bacteria	Bacteria	189	1.51e-53	NR	RZO87935.1	2026752	g24893	i0	61.6	22.5448275862069	138	53	95.2	0	418	5	463	600	RZO87935.1 MAG: acetate--CoA ligase [Kiritimatiellaceae bacterium]	diamond	9807	189	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiellaceae bacterium
30747659	30747659	PRJNA741997_P_NODE_35934_length_362_cov_1.598616_g34814_i0	PRJNA741997	35934	362	1.598616	5.78698992	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	46.2	0.00665	NR	MBP1589130.1	2212473	g34814	i0	42.1	0.472375690607735	57	33	47.2	0	16	186	158	214	MBP1589130.1 alpha/beta fold hydrolase [Kiritimatiellia bacterium]	diamond	171	46.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
30842543	30842543	PRJNA741997_P_NODE_73174_length_250_cov_1.451977_g72054_i0	PRJNA741997	73174	250	1.451977	3.6299425	Kiritimatiellaceae bacterium	2026752	Bacteria	Bacteria	67.4	8.43e-11	NR	RZO87935.1	2026752	g72054	i0	49.1	0.684	57	29	68.4	0	79	249	18	74	RZO87935.1 MAG: acetate--CoA ligase [Kiritimatiellaceae bacterium]	diamond	171	67.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiellaceae 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);;