metadata: contig_metadata: 11 rows where bioproject = "PRJNA883229", tax_clade = "FCB group" and tax

11 rows where bioproject = "PRJNA883229", 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
27339982	27339982	PRJNA883229_P_NODE_16623_length_242_cov_0.923077_g16577_i0	PRJNA883229	16623	242	0.923077	2.23384634	Fibrobacter sp.	35828	Bacteria	Bacteria	82.4	4.02e-16	NR	WP_405327992.1	35828	g16577	i0	49.4	1.98347107438017	81	40	99.2	1	241	2	67	147	WP_405327992.1 cadherin repeat domain-containing protein [Fibrobacter sp.]	diamond	480	82.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
27844895	27844895	PRJNA883229_P_NODE_14424_length_245_cov_0.906977_g14378_i0	PRJNA883229	14424	245	0.906977	2.22209365	Fibrobacter sp.	35828	Bacteria	Bacteria	68.9	2.21e-11	NR	WP_405323395.1	35828	g14378	i0	93.8	0.391836734693878	32	2	39.2	0	96	1	1	32	WP_405323395.1 IS1182 family transposase [Fibrobacter sp.]	diamond	96	68.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28192120	28192120	PRJNA883229_P_NODE_11966_length_248_cov_0.891429_g11920_i0	PRJNA883229	11966	248	0.891429	2.21074392	Fibrobacter sp.	35828	Bacteria	Bacteria	43.5	0.02	NR	MBO6075891.1	35828	g11920	i0	69.7	0.399193548387097	33	10	39.9	0	86	184	294	326	MBO6075891.1 Rpn family recombination-promoting nuclease/putative transposase [Fibrobacter sp.]	diamond	99	43.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28894817	28894817	PRJNA883229_P_NODE_6068_length_288_cov_1.162791_g6022_i0	PRJNA883229	6068	288	1.162791	3.34883808	FCB group	1783270	Bacteria	Bacteria	59.7	1.87e-9	NR	MBP5440323.1	35828	g6022	i0	100	1.08333333333333	26	0	27.1	0	286	209	47	72	MBP5440323.1 succinate dehydrogenase/fumarate reductase iron-sulfur subunit [Fibrobacter sp.]	diamond	312	59.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29423532	29423532	PRJNA883229_P_NODE_11549_length_249_cov_0.886364_g11503_i0	PRJNA883229	11549	249	0.886364	2.20704636	Fibrobacter sp. UWB1	1964355	Bacteria	Bacteria	154	2.0399999999999998e-43	NR	WP_173654691.1	1896201	g11503	i0	87.8	0.987951807228916	82	10	98.8	0	3	248	91	172	WP_173654691.1 lipopolysaccharide biosynthesis protein [Fibrobacter sp. UWB10]	diamond	246	154	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWB10
30940198	30940198	PRJNA883229_P_NODE_6454_length_282_cov_1.444976_g6408_i0	PRJNA883229	6454	282	1.444976	4.07483232	Fibrobacter sp.	35828	Bacteria	Bacteria	104	2.9599999999999993e-24	NR	MBR2211953.1	35828	g6408	i0	81	1.1595744680851101	58	11	61.7	0	281	108	338	395	MBR2211953.1 site-specific integrase [Fibrobacter sp.]	diamond	327	104	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
31635541	31635541	PRJNA883229_P_NODE_4696_length_315_cov_2.028926_g4650_i0	PRJNA883229	4696	315	2.028926	6.3911169	uncultured Fibrobacter sp.	261512	Bacteria	Bacteria	67	2.59e-10	NR	WP_295001948.1	261512	g4650	i0	39.1	0.828571428571429	87	49	81	2	3	257	374	458	WP_295001948.1 hypothetical protein [uncultured Fibrobacter sp.]	diamond	261	67	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	uncultured Fibrobacter sp.
31920298	31920298	PRJNA883229_P_NODE_11997_length_248_cov_0.891429_g11951_i0	PRJNA883229	11997	248	0.891429	2.21074392	Fibrobacter sp.	35828	Bacteria	Bacteria	79.3	2.68e-15	NR	WP_405339605.1	35828	g11951	i0	100	0.459677419354839	38	0	46	0	247	134	291	328	WP_405339605.1 PstS family phosphate ABC transporter substrate-binding protein [Fibrobacter sp.]	diamond	114	79.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32395027	32395027	PRJNA883229_P_NODE_10419_length_251_cov_0.876404_g10373_i0	PRJNA883229	10419	251	0.876404	2.19977404	Fibrobacter sp.	35828	Bacteria	Bacteria	104	5.65e-25	NR	MCF0223087.1	35828	g10373	i0	94.2	3.72908366533865	52	3	62.2	0	94	249	1	52	MCF0223087.1 GDP-L-fucose synthase [Fibrobacter sp.]	diamond	936	104	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32497984	32497984	PRJNA883229_P_NODE_13039_length_247_cov_0.896552_g12993_i0	PRJNA883229	13039	247	0.896552	2.21448344	Pseudomonadati	3379134	Bacteria	Bacteria	109	3.91e-29	NR	MBR6942073.1	35828	g12993	i0	81.8	4.0080971659919	66	12	80.2	0	48	245	1	66	MBR6942073.1 HU family DNA-binding protein [Fibrobacter sp.]	diamond	990	110	0.990909090909091	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32773468	32773468	PRJNA883229_P_NODE_3540_length_351_cov_1.122302_g3494_i0	PRJNA883229	3540	351	1.122302	3.93928002	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	73.2	1.56e-14	NR	MBO5423717.1	2652288	g3494	i0	66.1	0.478632478632479	56	19	47.9	0	72	239	1	56	MBO5423717.1 hypothetical protein [Fibrobacteraceae bacterium]	diamond	168	73.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae		Fibrobacteraceae 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);;