metadata: contig_metadata: 3 rows where bioproject = "PRJNA1182301" and tax

3 rows where bioproject = "PRJNA1182301" 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_genus	tax_species
11797111	11797111	PRJNA1182301_P_NODE_32610_length_271_cov_2.994949_g32485_i0	PRJNA1182301	32610	271	2.994949	8.11631179	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	97.8	4.21e-22	NR	MBQ9727196.1	2212473	g32485	i0	63.4	1.81549815498155	82	30	90.8	0	247	2	7	88	MBQ9727196.1 D-glycero-beta-D-manno-heptose-7-phosphate kinase [Kiritimatiellia bacterium]	diamond	492	97.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29914445	29914445	PRJNA1182301_P_NODE_26891_length_279_cov_2.116505_g26766_i0	PRJNA1182301	26891	279	2.116505	5.90504895	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	112	8.5e-27	NR	HNX35844.1	2212473	g26766	i0	51.3	1.25806451612903	117	32	98.9	1	278	3	181	297	HNX35844.1 NAD-dependent epimerase/dehydratase family protein [Kiritimatiellia bacterium]	diamond	351	112	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32840796	32840796	PRJNA1182301_P_NODE_50160_length_250_cov_0.870056_g50035_i0	PRJNA1182301	50160	250	0.870056	2.17514	Pontiella	2750657	Bacteria	Bacteria	46.2	0.00248	NR	WP_136078190.1	2750659	g50035	i0	27.3	1.944	88	49	92.4	2	17	247	30	113	WP_136078190.1 alpha-L-rhamnosidase N-terminal domain-containing protein [Pontiella desulfatans]	diamond	486	46.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Pontiellaceae	Pontiella	Pontiella desulfatans

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);;