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

11 rows where bioproject = "PRJNA315399", 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
9311011	9311011	PRJNA315399_P_NODE_38908_length_254_cov_3.668203_g38461_i0	PRJNA315399	38908	254	3.668203	9.31723562	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g38461	i0	100	0.110236220472441	28	0	11	0	26	53	4488437	4488410	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
14412269	14412269	PRJNA315399_P_NODE_451672_length_156_cov_3.201681_g451224_i0	PRJNA315399	451672	156	3.2016810000000002	4.99462236	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	198	1.56e-46	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g451224	i0	93.893	53.5769230769231	131	8	84	0	8	138	1594904	1594774	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	8358	198	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
26789714	26789714	PRJNA315399_P_NODE_445141_length_157_cov_1.275000_g444693_i0	PRJNA315399	445141	157	1.275	2.00175	Fibrobacter sp.	35828	Bacteria	Bacteria	91.3	3.91e-20	NR	NLL14664.1	35828	g444693	i0	74	1.91082802547771	50	13	95.5	0	154	5	205	254	NLL14664.1 right-handed parallel beta-helix repeat-containing protein [Fibrobacter sp.]	diamond	300	91.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
27137151	27137151	PRJNA315399_P_NODE_170362_length_187_cov_3.053333_g169914_i0	PRJNA315399	170362	187	3.053333	5.70973271	Fibrobacter sp.	35828	Bacteria	Bacteria	44.3	0.005	NR	MDR1760251.1	35828	g169914	i0	57.1	1.71657754010695	35	15	56.1	0	78	182	564	598	MDR1760251.1 DNA polymerase III subunit alpha [Fibrobacter sp.]	diamond	321	44.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28810969	28810969	PRJNA315399_P_NODE_385348_length_163_cov_4.904762_g384900_i0	PRJNA315399	385348	163	4.904762	7.99476206	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	49.3	5.95e-5	NR	MCD6025108.1	2725311	g384900	i0	100	0.404907975460123	22	0	40.5	0	149	84	737	758	MCD6025108.1 two component regulator propeller family protein [Fibrobacteria bacterium]	diamond	66	49.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
29221991	29221991	PRJNA315399_P_NODE_440449_length_157_cov_4.466667_g440001_i0	PRJNA315399	440449	157	4.466667	7.01266719	Candidatus Fibrimonadaceae bacterium	2872174	Bacteria	Bacteria	54.3	9.66e-7	NR	MDR2583992.1	2872174	g440001	i0	43.9	1.08917197452229	57	18	82.2	2	17	145	312	368	MDR2583992.1 DUF262 domain-containing protein [Candidatus Fibrimonadaceae bacterium]	diamond	171	54.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales	Candidatus Fibrimonadaceae		Candidatus Fibrimonadaceae bacterium
29569040	29569040	PRJNA315399_P_NODE_454170_length_156_cov_1.462185_g453722_i0	PRJNA315399	454170	156	1.462185	2.2810086	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	41.2	0.0401	NR	MCD6025426.1	2725311	g453722	i0	58.1	0.596153846153846	31	13	59.6	0	142	50	969	999	MCD6025426.1 hypothetical protein [Fibrobacteria bacterium]	diamond	93	41.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
29663489	29663489	PRJNA315399_S_NODE_162110_length_158_cov_1.462810_g161909_i0	PRJNA315399	162110	158	1.46281	2.3112398	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	71.2	3.38e-14	NR	MCD6025332.1	2725311	g161909	i0	78.6	0.79746835443038	42	9	79.7	0	127	2	1	42	MCD6025332.1 domain containing protein [Fibrobacteria bacterium]	diamond	126	71.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
30660584	30660584	PRJNA315399_S_NODE_198253_length_150_cov_2.477876_g198052_i0	PRJNA315399	198253	150	2.477876	3.716814	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	1.98e-8	NR	WP_173475118.1	833	g198052	i0	54.5	3.64	44	20	88	0	1	132	219	262	WP_173475118.1 DUF3383 family protein [Fibrobacter succinogenes]	diamond	546	58.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
30737811	30737811	PRJNA315399_P_NODE_391614_length_162_cov_7.416000_g391166_i0	PRJNA315399	391614	162	7.416	12.01392	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	87.8	1.32e-18	NR	MCD6023596.1	2725311	g391166	i0	89.6	1.77777777777778	48	5	88.9	0	14	157	235	282	MCD6023596.1 efflux family protein [Fibrobacteria bacterium]	diamond	288	87.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
30881689	30881689	PRJNA315399_P_NODE_401114_length_161_cov_6.403226_g400666_i0	PRJNA315399	401114	161	6.403226	10.30919386	Fibrobacter	832	Bacteria	Bacteria	98.2	3.58e-22	NR	WP_290958416.1	35828	g400666	i0	75.8	16.1552795031056	62	5	96.9	1	5	160	483	544	WP_290958416.1 ribonuclease R family protein [Fibrobacter sp.]	diamond	2601	98.2	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);;