metadata: contig_metadata: 8 rows where bioproject = "PRJNA550047", tax_clade = "FCB group" and tax

8 rows where bioproject = "PRJNA550047", 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
22194549	22194549	PRJNA550047_P_NODE_545918_length_215_cov_6.640845_g543945_i0	PRJNA550047	545918	215	6.640845	14.27781675	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	353	4.64e-93	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g543945	i0	96.279	126.027906976744	215	8	100	0	1	215	2980871	2980657	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	27096	353	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26808102	26808102	PRJNA550047_P_NODE_585721_length_202_cov_10.410853_g583748_i0	PRJNA550047	585721	202	10.410853	21.02992306	Pseudomonadati	3379134	Bacteria	Bacteria	62.4	1.79e-9	NR	WP_295057743.1	261512	g583748	i0	45.3	2.88118811881188	64	34	93.6	1	191	3	165	228	WP_295057743.1 ArdC family protein [uncultured Fibrobacter sp.]	diamond	582	62.8	0.993630573248408	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	uncultured Fibrobacter sp.
27583602	27583602	PRJNA550047_P_NODE_554404_length_212_cov_8.942446_g552431_i0	PRJNA550047	554404	212	8.942446	18.95798552	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	48.9	1.64e-4	NR	MDB5049187.1	2052160	g552431	i0	52.2	0.650943396226415	46	22	65.1	0	151	14	10	55	MDB5049187.1 hypothetical protein [Fibrobacterota bacterium]	diamond	138	48.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
29477667	29477667	PRJNA550047_P_NODE_270190_length_299_cov_11.942478_g268221_i0	PRJNA550047	270190	299	11.942478	35.70800922	Fibrobacter sp.	35828	Bacteria	Bacteria	70.9	1.22e-12	NR	WP_407448093.1	35828	g268221	i0	68.2	2.64882943143813	44	14	44.1	0	2	133	113	156	WP_407448093.1 acyltransferase [Fibrobacter sp.]	diamond	792	70.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29825151	29825151	PRJNA550047_P_NODE_279971_length_299_cov_4.424779_g278002_i0	PRJNA550047	279971	299	4.424779	13.23008921	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	68.6	2.34e-11	NR	HSQ42303.1	2652288	g278002	i0	41.8	1.40468227424749	91	49	87.3	1	261	1	101	191	HSQ42303.1 cache domain-containing protein [Fibrobacteraceae bacterium]	diamond	420	68.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae		Fibrobacteraceae bacterium
30426050	30426050	PRJNA550047_P_NODE_308053_length_296_cov_8.295964_g306084_i0	PRJNA550047	308053	296	8.295964	24.55605344	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	86.7	1.6e-18	NR	HNY31473.1	2725311	g306084	i0	56.3	1.2972972972973	64	28	64.9	0	6	197	149	212	HNY31473.1 MBL fold metallo-hydrolase [Fibrobacteria bacterium]	diamond	384	86.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
31089014	31089014	PRJNA550047_P_NODE_199115_length_343_cov_8.288889_g197154_i0	PRJNA550047	199115	343	8.288889	28.43088927	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	50.8	1.63e-4	NR	MDQ3002704.1	2052160	g197154	i0	45.1	0.446064139941691	51	25	42	1	1	144	386	436	MDQ3002704.1 hypothetical protein [Fibrobacterota bacterium]	diamond	153	50.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
32701607	32701607	PRJNA550047_P_NODE_301360_length_297_cov_6.803571_g299391_i0	PRJNA550047	301360	297	6.803571	20.20660587	Fibrobacter sp.	35828	Bacteria	Bacteria	93.2	2.02e-22	NR	MCF0224523.1	35828	g299391	i0	85.2	0.545454545454545	54	8	54.5	0	295	134	34	87	MCF0224523.1 ribonucleoside-triphosphate reductase [Fibrobacter sp.]	diamond	162	93.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);;