metadata: contig_metadata: 6 rows where bioproject = "PRJNA688352", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA688352", 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
15969631	15969631	PRJNA688352_P_NODE_9653_length_246_cov_0.890173_g9550_i0	PRJNA688352	9653	246	0.890173	2.18982558	Fibrobacter	832	Bacteria	Bacteria	172	3.65e-51	NR	MBR6454568.1	35828	g9550	i0	97.6	6	82	2	100	0	1	246	163	244	MBR6454568.1 UDP-glucose 4-epimerase GalE [Fibrobacter sp.]	diamond	1476	172	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
27840130	27840130	PRJNA688352_P_NODE_6804_length_255_cov_1.054945_g6701_i0	PRJNA688352	6804	255	1.054945	2.69010975	Fibrobacter sp.	35828	Bacteria	Bacteria	58.9	1.28e-8	NR	MBR3669325.1	35828	g6701	i0	38.6	2	88	49	97.6	2	7	255	22	109	MBR3669325.1 hypothetical protein [Fibrobacter sp.]	diamond	510	58.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28913602	28913602	PRJNA688352_P_NODE_10268_length_245_cov_0.895349_g10165_i0	PRJNA688352	10268	245	0.895349	2.19360505	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	108	9.25e-26	NR	MEN9354857.1	2052160	g10165	i0	64.2	1.95918367346939	81	29	99.2	0	2	244	224	304	MEN9354857.1 hypothetical protein [Fibrobacterota bacterium]	diamond	480	108	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29766218	29766218	PRJNA688352_P_NODE_9211_length_247_cov_0.885057_g9108_i0	PRJNA688352	9211	247	0.885057	2.18609079	Fibrobacter sp.	35828	Bacteria	Bacteria	57	3.74e-7	NR	MBQ3777121.1	35828	g9108	i0	61.4	0.534412955465587	44	15	51	1	113	238	613	656	MBQ3777121.1 DUF262 domain-containing protein [Fibrobacter sp.]	diamond	132	57	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
30555973	30555973	PRJNA688352_P_NODE_11273_length_243_cov_0.905882_g11170_i0	PRJNA688352	11273	243	0.905882	2.20129326	Fibrobacter sp. UBA43	35828	Bacteria	Bacteria	145	3.16e-40	NR	WP_290743597.1	1946537	g11170	i0	86.3	1.97530864197531	80	11	98.8	0	241	2	232	311	WP_290743597.1 hypothetical protein [Fibrobacter sp. UBA4309]	diamond	480	145	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UBA4309
31662334	31662334	PRJNA688352_P_NODE_11397_length_243_cov_0.905882_g11294_i0	PRJNA688352	11397	243	0.905882	2.20129326	Fibrobacter sp. UWP2	1896216	Bacteria	Bacteria	93.2	4.69e-20	NR	WP_143153065.1	1896216	g11294	i0	60	0.987654320987654	80	29	98.8	1	242	3	120	196	WP_143153065.1 tetratricopeptide repeat protein [Fibrobacter sp. UWP2]	diamond	240	93.2	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWP2

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