metadata: contig_metadata: 16 rows where bioproject = "PRJNA556992", tax_clade = "FCB group" and tax

16 rows where bioproject = "PRJNA556992", 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
18377965	18377965	PRJNA556992_P_NODE_253875_length_303_cov_2.669565_g251686_i0	PRJNA556992	253875	303	2.669565	8.08878195	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	80.1	3.49e-16	NR	HXP90955.1	2725311	g251686	i0	82.2	0.445544554455446	45	8	44.6	0	1	135	139	183	HXP90955.1 isochorismatase family cysteine hydrolase [Fibrobacteria bacterium]	diamond	135	80.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
27994845	27994845	PRJNA556992_P_NODE_920605_length_238_cov_7.775758_g918415_i0	PRJNA556992	920605	238	7.775758	18.50630404	Fibrobacter sp.	35828	Bacteria	Bacteria	124	2.02e-33	NR	MDO5577652.1	35828	g918415	i0	95.4	1.63865546218487	65	3	81.9	0	197	3	1	65	MDO5577652.1 hypothetical protein [Fibrobacter sp.]	diamond	390	124	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28152517	28152517	PRJNA556992_P_NODE_331545_length_284_cov_2.815166_g329356_i0	PRJNA556992	331545	284	2.815166	7.99507144	Fibrobacter sp.	35828	Bacteria	Bacteria	89.4	2.57e-18	NR	MBR2305987.1	35828	g329356	i0	46.2	0.982394366197183	93	49	98.2	1	1	279	173	264	MBR2305987.1 hypothetical protein [Fibrobacter sp.]	diamond	279	89.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28562769	28562769	PRJNA556992_P_NODE_1172087_length_196_cov_9.268293_g1169896_i0	PRJNA556992	1172087	196	9.268293	18.16585428	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	86.3	1.45e-19	NR	MDB5103524.1	2052160	g1169896	i0	75.9	1.83673469387755	58	14	88.8	0	176	3	31	88	MDB5103524.1 hypothetical protein [Fibrobacterota bacterium]	diamond	360	86.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
28562965	28562965	PRJNA556992_P_NODE_494367_length_268_cov_0.974359_g492178_i0	PRJNA556992	494367	268	0.974359	2.61128212	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	181	5.269999999999999e-54	NR	HQF53746.1	2725311	g492178	i0	98.9	0.985074626865672	88	1	98.5	0	266	3	7	94	HQF53746.1 metallophosphoesterase [Fibrobacteria bacterium]	diamond	264	181	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
28689612	28689612	PRJNA556992_P_NODE_926547_length_238_cov_2.842424_g924357_i0	PRJNA556992	926547	238	2.842424	6.76496912	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	41.6	0.0119	NR	MCB9497105.1	2725311	g924357	i0	54.1	0.466386554621849	37	17	46.6	0	236	126	23	59	MCB9497105.1 hypothetical protein [Fibrobacteria bacterium]	diamond	111	41.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
28815283	28815283	PRJNA556992_P_NODE_668688_length_253_cov_3.061111_g666499_i0	PRJNA556992	668688	253	3.061111	7.74461083	Fibrobacter sp.	35828	Bacteria	Bacteria	164	2.16e-46	NR	NLW32215.1	35828	g666499	i0	98.8	0.99604743083004	84	1	99.6	0	252	1	49	132	NLW32215.1 peptidoglycan DD-metalloendopeptidase family protein [Fibrobacter sp.]	diamond	252	164	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28815337	28815337	PRJNA556992_P_NODE_790748_length_246_cov_3.034682_g788558_i0	PRJNA556992	790748	246	3.034682	7.46531772	Fibrobacter sp.	35828	Bacteria	Bacteria	76.6	4.02e-14	NR	NLD99064.1	35828	g788558	i0	42.7	3	82	47	100	0	1	246	185	266	NLD99064.1 endo-1,4-beta-xylanase [Fibrobacter sp.]	diamond	738	76.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29068307	29068307	PRJNA556992_P_NODE_732588_length_249_cov_3.153409_g730399_i0	PRJNA556992	732588	249	3.153409	7.85198841	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	149	2.95e-40	NR	HQF54585.1	2725311	g730399	i0	100	0.867469879518072	72	0	86.7	0	3	218	468	539	HQF54585.1 response regulator [Fibrobacteria bacterium]	diamond	216	149	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
29573088	29573088	PRJNA556992_P_NODE_524950_length_265_cov_1.890625_g522761_i0	PRJNA556992	524950	265	1.890625	5.01015625	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	76.6	1.7e-15	NR	MEO7778486.1	2725311	g522761	i0	72	1.13207547169811	50	14	56.6	0	150	1	1	50	MEO7778486.1 hypothetical protein [Fibrobacteria bacterium]	diamond	300	76.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
30363291	30363291	PRJNA556992_P_NODE_437312_length_273_cov_1.465000_g435123_i0	PRJNA556992	437312	273	1.465	3.99945	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	51.6	1.86e-5	NR	MBQ5610039.1	2652288	g435123	i0	77.8	1.18681318681319	27	6	29.7	0	192	272	24	50	MBQ5610039.1 restriction endonuclease subunit S [Fibrobacteraceae bacterium]	diamond	324	51.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae		Fibrobacteraceae bacterium
31215833	31215833	PRJNA556992_P_NODE_943135_length_236_cov_3.883436_g940945_i0	PRJNA556992	943135	236	3.883436	9.16490896	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	138	7.52e-36	NR	MEN9353420.1	2052160	g940945	i0	80.8	0.991525423728814	78	15	99.2	0	2	235	224	301	MEN9353420.1 hypothetical protein [Fibrobacterota bacterium]	diamond	234	138	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
31325205	31325205	PRJNA556992_P_NODE_998275_length_230_cov_7.165605_g996085_i0	PRJNA556992	998275	230	7.165605	16.4808915	Fibrobacter	832	Bacteria	Bacteria	53.5	4.2e-6	NR	MBR5694322.1	35828	g996085	i0	42.1	2.98695652173913	76	43	97.8	1	228	4	166	241	MBR5694322.1 hypothetical protein [Fibrobacter sp.]	diamond	687	53.9	0.992578849721707	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
32133692	32133692	PRJNA556992_P_NODE_888658_length_241_cov_2.601190_g886468_i0	PRJNA556992	888658	241	2.60119	6.2688679	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	148	5.069999999999999e-42	NR	MBL8026242.1	2052160	g886468	i0	88.6	2.95020746887967	79	9	98.3	0	3	239	112	190	MBL8026242.1 phosphatidylserine decarboxylase [Fibrobacterota bacterium]	diamond	711	148	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32228424	32228424	PRJNA556992_P_NODE_454758_length_271_cov_2.292929_g452569_i0	PRJNA556992	454758	271	2.292929	6.21383759	Fibrobacter sp. UWH4	1896210	Bacteria	Bacteria	77.4	1.85e-16	NR	WP_139258077.1	1896210	g452569	i0	73.9	0.509225092250922	46	12	50.9	0	238	101	1	46	WP_139258077.1 hypothetical protein [Fibrobacter sp. UWH4]	diamond	138	77.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWH4
32670368	32670368	PRJNA556992_P_NODE_1062160_length_221_cov_20.898649_g1059970_i0	PRJNA556992	1062160	221	20.898649	46.18601429	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	147	3.23e-39	NR	HPW94320.1	2652288	g1059970	i0	100	1.98190045248869	73	0	99.1	0	3	221	675	747	HPW94320.1 exodeoxyribonuclease V subunit gamma [Fibrobacteraceae bacterium]	diamond	438	147	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);;