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

5 rows where bioproject = "PRJNA533114", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"

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
27218897	27218897	PRJNA533114_P_NODE_62362_length_302_cov_1.344978_g62110_i0	PRJNA533114	62362	302	1.344978	4.06183356	Pseudomonadati	3379134	Bacteria	Bacteria	62.4	9.64e-9	NR	MBR3670842.1	35828	g62110	i0	36	3.83443708609272	89	56	88.4	1	287	21	962	1049	MBR3670842.1 ankyrin repeat domain-containing protein [Fibrobacter sp.]	diamond	1158	62.8	0.993630573248408	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29351372	29351372	PRJNA533114_P_NODE_114189_length_243_cov_0.905882_g113937_i0	PRJNA533114	114189	243	0.905882	2.20129326	Chitinispirillales bacterium	2872172	Bacteria	Bacteria	43.5	0.0207	NR	MDR0305053.1	2872172	g113937	i0	35.4	1.01234567901235	82	42	100	3	1	243	111	182	MDR0305053.1 hypothetical protein [Chitinispirillales bacterium]	diamond	246	43.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales			Chitinispirillales bacterium
30519947	30519947	PRJNA533114_P_NODE_108713_length_245_cov_1.441860_g108461_i0	PRJNA533114	108713	245	1.44186	3.532557	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	75.1	1.41e-13	NR	MBN1130101.1	2813024	g108461	i0	45.7	0.991836734693878	81	38	91.8	2	242	18	117	197	MBN1130101.1 cellulase family glycosylhydrolase [Chitinispirillaceae bacterium]	diamond	243	75.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae bacterium
31119933	31119933	PRJNA533114_P_NODE_113375_length_244_cov_0.900585_g113123_i0	PRJNA533114	113375	244	0.900585	2.1974274	Fibrobacter sp.	35828	Bacteria	Bacteria	55.8	9.23e-7	NR	NLE01329.1	35828	g113123	i0	46.4	2.8155737704918	56	30	68.9	0	190	23	337	392	NLE01329.1 glycoside hydrolase family 3 protein [Fibrobacter sp.]	diamond	687	55.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32795575	32795575	PRJNA533114_P_NODE_65620_length_295_cov_1.040541_g65368_i0	PRJNA533114	65620	295	1.040541	3.06959595	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	55.5	1.96e-6	NR	HEX2613226.1	2725311	g65368	i0	52.3	0.894915254237288	44	21	44.7	0	132	1	6	49	HEX2613226.1 oxygen-dependent coproporphyrinogen oxidase [Fibrobacteria bacterium]	diamond	264	55.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria 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);;