metadata: contig_metadata: 8 rows where bioproject = "PRJNA814235" and tax

8 rows where bioproject = "PRJNA814235" and tax_phylum = "Lentisphaerota"

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_species
2094373	2094373	PRJNA814235_P_NODE_89822_length_203_cov_3.451807_g88427_i0	PRJNA814235	89822	203	3.451807	7.00716821	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	135	1.71e-27	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g88427	i0	98.684	49.1083743842365	76	1	74	0	1	76	2340784	2340859	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	9969	135	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
4643665	4643665	PRJNA814235_P_NODE_105164_length_203_cov_2.222892_g103769_i0	PRJNA814235	105164	203	2.222892	4.51247076	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	141	3.67e-29	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g103769	i0	100	253.497536945813	76	0	74	0	1	76	2339999	2340074	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	51460	141	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallales bacterium CCUG 44730
8879435	8879435	PRJNA814235_P_NODE_171267_length_158_cov_2.049587_g169872_i0	PRJNA814235	171267	158	2.049587	3.23834746	Bacteria	2	Bacteria	Bacteria	259	7.17e-65	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g169872	i0	96.203	23.0443037974684	158	6	100	0	1	158	1584974	1585131	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	3641	259	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota bacterium
21629514	21629514	PRJNA814235_P_NODE_76197_length_218_cov_1.845304_g74802_i0	PRJNA814235	76197	218	1.845304	4.02276272	Bacteria	2	Bacteria	Bacteria	121	5.209999999999999e-23	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g74802	i0	86.916	73.0779816513761	107	14	50	0	109	215	2383944	2384050	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	15931	121	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerae bacterium WC36
24179316	24179316	PRJNA814235_P_NODE_85039_length_206_cov_2.165680_g83644_i0	PRJNA814235	85039	206	2.16568	4.4613008	Bacteria	2	Bacteria	Bacteria	185	1.7e-42	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g83644	i0	87.117	436.339805825243	163	21	83	0	35	197	2382820	2382982	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	89886	185	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerae bacterium WC36
29936793	29936793	PRJNA814235_P_NODE_104071_length_203_cov_2.265060_g102676_i0	PRJNA814235	104071	203	2.26506	4.5980718	Bacteria	2	Bacteria	Bacteria	45.1	0.00339	NR	MEI6423523.1	1932692	g102676	i0	81	0.931034482758621	21	4	31	0	12	74	131	151	MEI6423523.1 alpha-amylase family protein [Lentisphaerota bacterium]	diamond	189	45.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota bacterium
30410997	30410997	PRJNA814235_P_NODE_109073_length_203_cov_2.096386_g107678_i0	PRJNA814235	109073	203	2.096386	4.25566358	Bacteria	2	Bacteria	Bacteria	45.8	0.00182	NR	MEI8248428.1	1932692	g107678	i0	40.3	1.935960591133	67	35	99	1	3	203	458	519	MEI8248428.1 glycosyl hydrolase [Lentisphaerota bacterium]	diamond	393	45.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota bacterium
32394055	32394055	PRJNA814235_P_NODE_91339_length_203_cov_3.162651_g89944_i0	PRJNA814235	91339	203	3.162651	6.42018153	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	52.8	6.46e-6	NR	NLF22904.1	1932692	g89944	i0	100	0.354679802955665	24	0	35.5	0	2	73	402	425	NLF22904.1 DUF4838 domain-containing protein [Lentisphaerota bacterium]	diamond	72	52.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota			Lentisphaerota 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);;