metadata: contig_metadata: 14 rows where bioproject = "PRJNA1196438", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA1196438", 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
5426477	5426477	PRJNA1196438_P_NODE_56045_length_264_cov_1.633508_g55618_i0	PRJNA1196438	56045	264	1.633508	4.31246112	Fibrobacter succinogenes	833	Bacteria	Bacteria	344	3.55e-90	NTclustered	gi\|261370870\|gb\|CP001792.1\|	59374	g55618	i0	90.152	2	264	26	100	0	1	264	2046751	2046488	Fibrobacter succinogenes subsp. succinogenes S85, complete genome	blastn	528	344	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
16345965	16345965	PRJNA1196438_P_NODE_6813_length_389_cov_4.170886_g6391_i0	PRJNA1196438	6813	389	4.170886	16.22474654	Pseudomonadati	3379134	Bacteria	Bacteria	99.4	8.959999999999999e-23	NR	MCQ2106959.1	35828	g6391	i0	100	1.27249357326478	55	0	42.4	0	223	387	1	55	MCQ2106959.1 hypothetical protein [Fibrobacter sp.]	diamond	495	99.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
26711308	26711308	PRJNA1196438_P_NODE_69461_length_248_cov_0.891429_g69034_i0	PRJNA1196438	69461	248	0.891429	2.21074392	FCB group	1783270	Bacteria	Bacteria	129	3.25e-36	NR	WP_072799701.1	1896224	g69034	i0	79.5	3.53225806451613	73	15	88.3	0	248	30	67	139	WP_072799701.1 adenylyltransferase/cytidyltransferase family protein [Fibrobacter sp. UWT2]	diamond	876	129	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWT2
26723836	26723836	PRJNA1196438_P_NODE_49081_length_274_cov_4.054726_g48654_i0	PRJNA1196438	49081	274	4.054726	11.10994924	Fibrobacter sp.	35828	Bacteria	Bacteria	150	5.4799999999999996e-42	NR	WP_300186788.1	35828	g48654	i0	87.1	2.79197080291971	85	11	93.1	0	1	255	256	340	WP_300186788.1 FecCD family ABC transporter permease [Fibrobacter sp.]	diamond	765	150	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
26870260	26870260	PRJNA1196438_P_NODE_62101_length_255_cov_1.714286_g61674_i0	PRJNA1196438	62101	255	1.714286	4.3714293	Fibrobacter	832	Bacteria	Bacteria	179	1.17e-53	NR	WP_072978318.1	1896210	g61674	i0	98.8	2.96470588235294	84	1	98.8	0	2	253	70	153	WP_072978318.1 family 16 glycosylhydrolase [Fibrobacter sp. UWH4]	diamond	756	179	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWH4
28051568	28051568	PRJNA1196438_P_NODE_15005_length_312_cov_4.188285_g14579_i0	PRJNA1196438	15005	312	4.188285	13.0674492	Fibrobacter sp.	35828	Bacteria	Bacteria	191	3.2999999999999994e-56	NR	WP_407451134.1	35828	g14579	i0	71.2	1.33653846153846	139	4	99	1	2	310	89	227	WP_407451134.1 FISUMP domain-containing protein [Fibrobacter sp.]	diamond	417	191	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29062121	29062121	PRJNA1196438_P_NODE_52208_length_270_cov_1.512690_g51781_i0	PRJNA1196438	52208	270	1.51269	4.084263	Fibrobacter sp. UWB13	1896204	Bacteria	Bacteria	148	3.27e-39	NR	WP_085491624.1	1896204	g51781	i0	85.4	0.988888888888889	89	11	98.9	1	2	268	130	216	WP_085491624.1 FtsK/SpoIIIE domain-containing protein [Fibrobacter sp. UWB13]	diamond	267	148	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWB13
29819581	29819581	PRJNA1196438_P_NODE_88011_length_200_cov_8.110236_g87583_i0	PRJNA1196438	88011	200	8.110236	16.220472	Fibrobacter sp.	35828	Bacteria	Bacteria	67.8	2.75e-11	NR	MCF0224100.1	35828	g87583	i0	39.4	0.99	66	38	99	1	200	3	114	177	MCF0224100.1 nucleotidyltransferase family protein [Fibrobacter sp.]	diamond	198	67.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
30628327	30628327	PRJNA1196438_P_NODE_14533_length_312_cov_4.422594_g14107_i0	PRJNA1196438	14533	312	4.422594	13.79849328	Pseudomonadati	3379134	Bacteria	Bacteria	60.1	6.15e-8	NR	MCQ2101786.1	35828	g14107	i0	61.2	0.903846153846154	49	19	47.1	0	164	310	11	59	MCQ2101786.1 glycosyltransferase [Fibrobacter sp.]	diamond	282	60.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
31114912	31114912	PRJNA1196438_P_NODE_65295_length_251_cov_4.859551_g64868_i0	PRJNA1196438	65295	251	4.859551	12.19747301	Fibrobacter sp.	35828	Bacteria	Bacteria	107	7.15e-25	NR	MCF0224128.1	35828	g64868	i0	61	1.97211155378486	82	32	98	0	251	6	152	233	MCF0224128.1 response regulator [Fibrobacter sp.]	diamond	495	107	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
31387190	31387190	PRJNA1196438_P_NODE_69716_length_247_cov_3.574713_g69289_i0	PRJNA1196438	69716	247	3.574713	8.82954111	Pseudomonadati	3379134	Bacteria	Bacteria	170	7.71e-50	NR	MCQ2101564.1	35828	g69289	i0	98.8	1.9919028340081	82	1	99.6	0	1	246	172	253	MCQ2101564.1 site-specific integrase [Fibrobacter sp.]	diamond	492	170	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
31716013	31716013	PRJNA1196438_P_NODE_68957_length_248_cov_1.782857_g68530_i0	PRJNA1196438	68957	248	1.782857	4.42148536	Fibrobacter sp.	35828	Bacteria	Bacteria	151	3.58e-42	NR	WP_405323887.1	35828	g68530	i0	81.7	0.991935483870968	82	15	99.2	0	246	1	199	280	WP_405323887.1 restriction endonuclease subunit S [Fibrobacter sp.]	diamond	246	151	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32412160	32412160	PRJNA1196438_P_NODE_66999_length_250_cov_1.570621_g66572_i0	PRJNA1196438	66999	250	1.570621	3.9265525	uncultured Fibrobacter sp.	261512	Bacteria	Bacteria	74.3	3.17e-13	NR	WP_297944426.1	261512	g66572	i0	43.2	0.888	74	42	88.8	0	243	22	784	857	WP_297944426.1 RecQ family ATP-dependent DNA helicase [uncultured Fibrobacter sp.]	diamond	222	74.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	uncultured Fibrobacter sp.
32507242	32507242	PRJNA1196438_P_NODE_70259_length_247_cov_1.678161_g69832_i0	PRJNA1196438	70259	247	1.678161	4.14505767	Fibrobacter sp.	35828	Bacteria	Bacteria	69.3	5.56e-13	NR	WP_405332665.1	35828	g69832	i0	73.2	1.49392712550607	41	11	49.8	0	4	126	74	114	WP_405332665.1 hypothetical protein [Fibrobacter sp.]	diamond	369	69.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.

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