metadata: contig_metadata: 13 rows where bioproject = "PRJNA704949", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA704949", 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
7066567	7066567	PRJNA704949_P_NODE_125026_length_714_cov_1.769925_g112004_i0	PRJNA704949	125026	714	1.769925	12.6372645	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	72	3.93e-12	NR	MBN1983541.1	2663014	g112004	i0	32.7	0.949579831932773	113	76	47.5	0	56	394	1	113	MBN1983541.1 STAS domain-containing protein [Chitinivibrionales bacterium]	diamond	678	72	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
18543351	18543351	PRJNA704949_P_NODE_1698875_length_185_cov_1.382353_g1683536_i0	PRJNA704949	1698875	185	1.382353	2.55735305	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g1683536	i0	100	1.1027027027027	30	0	16	0	107	136	315284	315255	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	204	56.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
22367853	22367853	PRJNA704949_P_NODE_157058_length_649_cov_1.340000_g143497_i0	PRJNA704949	157058	649	1.34	8.6966	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	236	2.3e-70	NR	MDQ3001051.1	2052160	g143497	i0	61	3.77657935285054	205	79	94.8	1	647	33	122	325	MDQ3001051.1 MFS transporter [Fibrobacterota bacterium]	diamond	2451	236	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26734428	26734428	PRJNA704949_P_NODE_1467161_length_204_cov_1.174194_g1451823_i0	PRJNA704949	1467161	204	1.174194	2.39535576	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	59.7	2.33e-8	NR	MDB5050711.1	2052160	g1451823	i0	44.1	0.867647058823529	59	33	86.8	0	9	185	537	595	MDB5050711.1 alpha-2-macroglobulin domain protein [Fibrobacterota bacterium]	diamond	177	59.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
27082948	27082948	PRJNA704949_P_NODE_125482_length_713_cov_1.465361_g112455_i0	PRJNA704949	125482	713	1.465361	10.44802393	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	117	5.48e-26	NR	MDB5103953.1	2052160	g112455	i0	51.6	1.0140252454418	122	57	50.9	2	21	383	847	967	MDB5103953.1 hypothetical protein [Fibrobacterota bacterium]	diamond	723	117	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
27241454	27241454	PRJNA704949_P_NODE_947963_length_269_cov_1.418182_g932628_i0	PRJNA704949	947963	269	1.418182	3.81490958	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	117	1.35e-29	NR	MEO6096773.1	2725311	g932628	i0	70.5	0.869888475836431	78	23	87	0	236	3	183	260	MEO6096773.1 YihY/virulence factor BrkB family protein [Fibrobacteria bacterium]	diamond	234	117	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
28346489	28346489	PRJNA704949_P_NODE_2152426_length_162_cov_1.840708_g2137087_i0	PRJNA704949	2152426	162	1.840708	2.98194696	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	74.7	6.76e-14	NR	HKP94857.1	2725311	g2137087	i0	82.6	0.851851851851852	46	7	85.2	1	25	162	575	619	HKP94857.1 DUF3656 domain-containing protein [Fibrobacteria bacterium]	diamond	138	74.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
30051473	30051473	PRJNA704949_P_NODE_2077851_length_165_cov_0.896552_g2062512_i0	PRJNA704949	2077851	165	0.896552	1.4793108	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	60.1	1.6e-9	NR	MDB5049109.1	2052160	g2062512	i0	61.2	0.890909090909091	49	19	89.1	0	17	163	97	145	MDB5049109.1 hypothetical protein [Fibrobacterota bacterium]	diamond	147	60.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30051698	30051698	PRJNA704949_P_NODE_849991_length_287_cov_2.184874_g834657_i0	PRJNA704949	849991	287	2.184874	6.27058838	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	43.1	0.0446	NR	MCD6024798.1	2725311	g834657	i0	40.9	0.45993031358885	44	23	42.9	1	257	135	54	97	MCD6024798.1 Molybdopterin oxidoreductase [Fibrobacteria bacterium]	diamond	132	43.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
30525390	30525390	PRJNA704949_P_NODE_1812893_length_176_cov_5.354331_g1797554_i0	PRJNA704949	1812893	176	5.354331	9.42362256	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	42	0.0283	NR	MBW8889006.1	2052160	g1797554	i0	39.4	1.125	66	26	95.5	4	6	173	184	245	MBW8889006.1 hypothetical protein [Fibrobacterota bacterium]	diamond	198	42	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30662714	30662714	PRJNA704949_P_NODE_1768293_length_180_cov_1.190840_g1752954_i0	PRJNA704949	1768293	180	1.19084	2.143512	Bacteria	2	Bacteria	Bacteria	92	6.78e-22	NR	MBW8888290.1	2052160	g1752954	i0	73.3	2	60	16	100	0	1	180	25	84	MBW8888290.1 SRPBCC family protein [Fibrobacterota bacterium]	diamond	360	92	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
31631864	31631864	PRJNA704949_P_NODE_403856_length_428_cov_1.416887_g388744_i0	PRJNA704949	403856	428	1.416887	6.06427636	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	100	3.77e-22	NR	MDB5048999.1	2052160	g388744	i0	44.4	0.995327102803738	142	74	99.5	3	3	428	116	252	MDB5048999.1 glycoside hydrolase [Fibrobacterota bacterium]	diamond	426	100	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32675173	32675173	PRJNA704949_P_NODE_1977280_length_168_cov_0.873950_g1961941_i0	PRJNA704949	1977280	168	0.87395	1.468236	Cellulosispirillum alkaliphilum	3039283	Bacteria	Bacteria	69.7	3.91e-12	NR	MDG5814689.1	3039283	g1961941	i0	60	0.982142857142857	55	22	98.2	0	166	2	303	357	MDG5814689.1 glycosyltransferase family 4 protein [Chitinispirillales bacterium ANBcel5]	diamond	165	69.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae	Cellulosispirillum	Cellulosispirillum alkaliphilum

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