metadata: contig_metadata: 5 rows where bioproject = "PRJNA1160211", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA1160211", tax_clade = "FCB group" and tax_phylum = "Balneolota"

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
18161363	18161363	PRJNA1160211_S_NODE_2075_length_1167_cov_16.787934_g1736_i0	PRJNA1160211	2075	1167	16.787934	195.91518978	Fodinibius roseus	1194090	Bacteria	Bacteria	420	1.7399999999999995e-143	NR	WP_073062483.1	1194090	g1736	i0	62.9	2.45501285347044	321	119	82.5	0	59	1021	1	321	WP_073062483.1 ATP-dependent 6-phosphofructokinase [Fodinibius roseus]	diamond	2865	420	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius roseus
28271982	28271982	PRJNA1160211_S_NODE_72126_length_516_cov_8.539503_g70917_i0	PRJNA1160211	72126	516	8.539503	44.06383548	Balneolaceae bacterium	2053516	Bacteria	Bacteria	56.6	8.21e-6	NR	MFA5669396.1	2053516	g70917	i0	29.4	0.732558139534884	126	75	72.1	4	477	106	25	138	MFA5669396.1 hypothetical protein [Balneolaceae bacterium]	diamond	378	56.6	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
28366761	28366761	PRJNA1160211_S_NODE_67606_length_527_cov_40.647577_g66404_i0	PRJNA1160211	67606	527	40.647577	214.21273079	Aliifodinibius sp. S!AR15-1	1872440	Bacteria	Bacteria	79	1.33e-14	NR	WP_310684582.1	2950437	g66404	i0	29.4	0.870967741935484	153	107	86.5	1	474	19	1	153	WP_310684582.1 hypothetical protein [Aliifodinibius sp. S!AR15-10]	diamond	459	79	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Aliifodinibius sp. S!AR15-10
31652097	31652097	PRJNA1160211_S_NODE_69597_length_522_cov_22.329621_g68392_i0	PRJNA1160211	69597	522	22.329621	116.56062162	Fodinibius halophilus	1736908	Bacteria	Bacteria	58.2	5.39e-7	NR	WP_165269261.1	1736908	g68392	i0	31.8	0.488505747126437	85	58	48.9	0	254	508	66	150	WP_165269261.1 hypothetical protein [Fodinibius halophilus]	diamond	255	58.2	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius halophilus
32000256	32000256	PRJNA1160211_S_NODE_3918_length_1002_cov_13.938644_g3423_i0	PRJNA1160211	3918	1002	13.938644	139.66521288	Fodinibius salicampi	1920655	Bacteria	Bacteria	65.9	2.22e-8	NR	WP_265790207.1	1920655	g3423	i0	32.8	0.347305389221557	116	74	33.5	4	660	995	8	123	WP_265790207.1 hypothetical protein [Fodinibius salicampi]	diamond	348	65.9	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salicampi

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