metadata: contig_metadata: 4 rows where bioproject = "PRJNA529241", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA529241", 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
10705534	10705534	PRJNA529241_P_NODE_499649_length_151_cov_5.008772_g497327_i0	PRJNA529241	499649	151	5.008772	7.56324572	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	79.7	9.81e-16	NR	MCD6024725.1	2725311	g497327	i0	74.1	5.70198675496689	58	7	99.3	1	151	2	428	485	MCD6024725.1 ppk [Fibrobacteria bacterium]	diamond	861	79.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
27693176	27693176	PRJNA529241_P_NODE_46984_length_297_cov_8.330769_g44662_i0	PRJNA529241	46984	297	8.330769	24.74238393	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.0099	NR	WP_014547271.1	833	g44662	i0	87	0.95959595959596	23	3	23.2	0	71	3	5	27	WP_014547271.1 polysaccharide pyruvyl transferase family protein [Fibrobacter succinogenes]	diamond	285	45.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
28766329	28766329	PRJNA529241_P_NODE_436487_length_161_cov_12.685484_g434165_i0	PRJNA529241	436487	161	12.685484	20.42362924	Fibrobacter	832	Bacteria	Bacteria	69.7	3.45e-12	NR	MDY6331772.1	35828	g434165	i0	76.2	4.69565217391304	42	10	78.3	0	34	159	282	323	MDY6331772.1 polysaccharide pyruvyl transferase family protein [Fibrobacter sp.]	diamond	756	70.1	0.994293865905849	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29982692	29982692	PRJNA529241_P_NODE_303411_length_173_cov_3.485294_g301089_i0	PRJNA529241	303411	173	3.485294	6.02955862	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	55.1	6.34e-7	NR	MFP4013251.1	2813024	g301089	i0	67.4	1.52601156069364	43	10	74.6	1	43	171	276	314	MFP4013251.1 mechanosensitive ion channel family protein [Chitinispirillaceae bacterium]	diamond	264	55.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae 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);;