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

5 rows where bioproject = "PRJNA1237347" and tax_phylum = "candidate division WOR-3"

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_phylum	tax_species
26629722	26629722	PRJNA1237347_P_NODE_192461_length_445_cov_0.827957_g185889_i0	PRJNA1237347	192461	445	0.827957	3.68440865	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	139	6.59e-36	NR	MBN2380620.1	2052148	g185889	i0	46.7	1.83370786516854	135	64	91	1	405	1	31	157	MBN2380620.1 serine hydrolase [candidate division WOR-3 bacterium]	diamond	816	139	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
27104693	27104693	PRJNA1237347_P_NODE_46662_length_1100_cov_8.356378_g41935_i0	PRJNA1237347	46662	1100	8.356378	91.920158	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	95.5	1.14e-18	NR	MBN1619556.1	2052148	g41935	i0	32.6	0.501818181818182	184	107	47.5	4	524	3	7	183	MBN1619556.1 GNAT family N-acetyltransferase [candidate division WOR-3 bacterium]	diamond	552	95.5	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
28967702	28967702	PRJNA1237347_P_NODE_106908_length_653_cov_2.239655_g100461_i0	PRJNA1237347	106908	653	2.239655	14.62494715	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	49.7	0.0018600000000000001	NR	MEO0271676.1	2052148	g100461	i0	32.8	0.532924961715161	116	65	48.7	3	83	400	59	171	MEO0271676.1 hypothetical protein [candidate division WOR-3 bacterium]	diamond	348	49.7	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
30041439	30041439	PRJNA1237347_P_NODE_333771_length_312_cov_2.004184_g327198_i0	PRJNA1237347	333771	312	2.004184	6.25305408	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	128	1.95e-33	NR	MBN1694299.1	2052148	g327198	i0	65.9	0.788461538461538	82	28	78.8	0	308	63	234	315	MBN1694299.1 cellulase family glycosylhydrolase [candidate division WOR-3 bacterium]	diamond	246	128	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 bacterium
32178178	32178178	PRJNA1237347_P_NODE_305198_length_330_cov_2.357977_g298625_i0	PRJNA1237347	305198	330	2.357977	7.7813241	Pseudomonadati	3379134	Bacteria	Bacteria	57.4	8.62e-8	NR	MEO0102517.1	2052148	g298625	i0	51.9	0.990909090909091	54	26	49.1	0	170	9	3	56	MEO0102517.1 HTH domain-containing protein [candidate division WOR-3 bacterium]	diamond	327	57.8	0.993079584775087	Bacteria	Bacteria candidate phyla	candidate division WOR-3	candidate division WOR-3 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);;