metadata: contig_metadata: 5 rows where bioproject = "PRJEB10140", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJEB10140", 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
27664581	27664581	PRJEB10140_P_NODE_102224_length_358_cov_1.511327_g84926_i0	PRJEB10140	102224	358	1.511327	5.41055066	Fibrobacter sp. UWH1	1964354	Bacteria	Bacteria	50.8	2.03e-4	NR	WP_088665446.1	1964354	g84926	i0	33.3	0.829608938547486	99	61	79.6	2	293	9	562	659	WP_088665446.1 cadherin repeat domain-containing protein [Fibrobacter sp. UWH1]	diamond	297	50.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWH1
28106409	28106409	PRJEB10140_P_NODE_277785_length_164_cov_0.895652_g260476_i0	PRJEB10140	277785	164	0.895652	1.46886928	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	112	4.76e-28	NR	MBQ5611498.1	2652288	g260476	i0	100	0.98780487804878	54	0	98.8	0	3	164	199	252	MBQ5611498.1 tRNA-dihydrouridine synthase [Fibrobacteraceae bacterium]	diamond	162	112	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae		Fibrobacteraceae bacterium
28138373	28138373	PRJEB10140_P_NODE_289145_length_162_cov_0.920354_g271836_i0	PRJEB10140	289145	162	0.920354	1.49097348	Fibrobacter sp. UWB1	1964355	Bacteria	Bacteria	114	6.89e-29	NR	WP_088656607.1	1964355	g271836	i0	100	0.981481481481482	53	0	98.1	0	161	3	59	111	WP_088656607.1 hypothetical protein [Fibrobacter sp. UWB1]	diamond	159	114	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp. UWB1
28453995	28453995	PRJEB10140_P_NODE_228066_length_178_cov_1.379845_g210757_i0	PRJEB10140	228066	178	1.379845	2.4561241	Chitinispirillales bacterium	2872172	Bacteria	Bacteria	49.3	6.35e-5	NR	MDR0331160.1	2872172	g210757	i0	43.3	3.7247191011236	60	33	99.4	1	178	2	84	143	MDR0331160.1 hypothetical protein [Chitinispirillales bacterium]	diamond	663	49.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales			Chitinispirillales bacterium
32656128	32656128	PRJEB10140_P_NODE_265880_length_166_cov_0.880342_g248571_i0	PRJEB10140	265880	166	0.880342	1.46136772	Fibrobacteraceae bacterium	2652288	Bacteria	Bacteria	82.4	1.12e-16	NR	MBQ5610464.1	2652288	g248571	i0	95.2	0.759036144578313	42	2	75.9	0	39	164	1	42	MBQ5610464.1 tRNA (N(6)-L-threonylcarbamoyladenosine(37)-C(2))-methylthiotransferase [Fibrobacteraceae bacterium]	diamond	126	82.4	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);;