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

5 rows where bioproject = "PRJNA493827", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

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
8125259	8125259	PRJNA493827_P_NODE_226827_length_242_cov_0.911243_g224629_i0	PRJNA493827	226827	242	0.911243	2.20520806	Rhodothermus sp.	2591385	Bacteria	Bacteria	106	5.47e-27	NR	MDQ7039865.1	2591385	g224629	i0	71.8	2.91322314049587	78	22	96.7	0	8	241	57	134	MDQ7039865.1 OmpH family outer membrane protein [Rhodothermus sp.]	diamond	705	106	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus sp.
28813470	28813470	PRJNA493827_P_NODE_46388_length_528_cov_2.129670_g44199_i0	PRJNA493827	46388	528	2.12967	11.2446576	Rhodothermaceae bacterium TMED1	2026787	Bacteria	Bacteria	58.2	7.33e-7	NR	RPF81769.1	1986665	g44199	i0	28.7	0.8125	143	92	76.7	2	525	121	40	180	RPF81769.1 MAG: hypothetical protein CBC65_001900 [Rhodothermaceae bacterium TMED105]	diamond	429	58.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium TMED105
32163361	32163361	PRJNA493827_P_NODE_134558_length_294_cov_2.090498_g132360_i0	PRJNA493827	134558	294	2.090498	6.14606412	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	145	9.97e-41	NR	WP_166979467.1	2558931	g132360	i0	65.6	3.91836734693878	96	33	98	0	1	288	27	122	WP_166979467.1 IS5 family transposase [Rhodocaloribacter litoris]	diamond	1152	145	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
32226671	32226671	PRJNA493827_P_NODE_193678_length_249_cov_0.875000_g191480_i0	PRJNA493827	193678	249	0.875	2.17875	Rhodothermales bacterium	2306054	Bacteria	Bacteria	153	8.059999999999998e-42	NR	HYE57485.1	2306054	g191480	i0	84.1	0.987951807228916	82	13	98.8	0	3	248	338	419	HYE57485.1 amylo-alpha-1,6-glucosidase [Rhodothermales bacterium]	diamond	246	153	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32857908	32857908	PRJNA493827_P_NODE_222020_length_243_cov_0.905882_g219822_i0	PRJNA493827	222020	243	0.905882	2.20129326	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	74.3	2.78e-13	NR	WP_166978516.1	2558931	g219822	i0	43.4	0.938271604938272	76	43	93.8	0	239	12	359	434	WP_166978516.1 TonB-dependent receptor [Rhodocaloribacter litoris]	diamond	228	74.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris

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