metadata: contig_metadata: 10 rows where bioproject = "PRJNA1123436", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA1123436", 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
280086	280086	PRJNA1123436_P_NODE_60121_length_321_cov_56.995968_g58907_i0	PRJNA1123436	60121	321	56.995968	182.95705728	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	267	9.88e-67	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g58907	i0	97.436	76.3426791277259	156	4	92	0	3	158	2982697	2982852	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	24506	267	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
1554696	1554696	PRJNA1123436_P_NODE_60122_length_321_cov_56.717742_g58908_i0	PRJNA1123436	60122	321	56.717742	182.06395182	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	267	9.88e-67	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g58908	i0	97.436	75.6666666666667	156	4	92	0	164	319	2982852	2982697	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	24289	267	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
11759244	11759244	PRJNA1123436_P_NODE_90090_length_259_cov_1.408602_g88876_i0	PRJNA1123436	90090	259	1.408602	3.64827918	Bacteria	2	Bacteria	Bacteria	163	2.1200000000000001e-44	NR	MCL2690240.1	2604142	g88876	i0	90.7	9.96138996138996	86	8	99.6	0	1	258	753	838	MCL2690240.1 DNA mismatch repair protein MutS [Chitinispirillia bacterium]	diamond	2580	164	0.99390243902439	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia				Chitinispirillia bacterium
15582852	15582852	PRJNA1123436_P_NODE_57573_length_328_cov_83.227451_g56359_i0	PRJNA1123436	57573	328	83.227451	272.98603928	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	267	1.01e-66	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g56359	i0	97.436	79.2774390243902	156	4	93	0	171	326	2982852	2982697	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	26003	267	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
15582880	15582880	PRJNA1123436_P_NODE_59053_length_324_cov_141.354582_g57839_i0	PRJNA1123436	59053	324	141.354582	457.98884568	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	250	1.01e-61	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g57839	i0	96.078	78.1543209876543	153	6	90	0	14	166	2062342	2062190	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	25322	250	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
18132013	18132013	PRJNA1123436_P_NODE_71455_length_294_cov_162.556561_g70241_i0	PRJNA1123436	71455	294	162.556561	477.91628934	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	224	5.459999999999999e-54	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g70241	i0	95.714	60.9489795918367	140	4	95	2	154	292	2062074	2061936	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	17919	224	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
26911954	26911954	PRJNA1123436_P_NODE_123962_length_242_cov_0.911243_g122748_i0	PRJNA1123436	123962	242	0.911243	2.20520806	Fibrobacter sp.	35828	Bacteria	Bacteria	72	1.39e-12	NR	NLE01892.1	35828	g122748	i0	69	0.520661157024793	42	13	52.1	0	2	127	315	356	NLE01892.1 DUF362 domain-containing protein [Fibrobacter sp.]	diamond	126	72	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
30070128	30070128	PRJNA1123436_P_NODE_119512_length_243_cov_1.005882_g118298_i0	PRJNA1123436	119512	243	1.005882	2.44429326	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	134	7.189999999999998e-35	NR	MBN1984137.1	2663014	g118298	i0	80	6.88888888888889	80	16	98.8	0	241	2	216	295	MBN1984137.1 DUF3883 domain-containing protein [Chitinivibrionales bacterium]	diamond	1674	134	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
30070168	30070168	PRJNA1123436_P_NODE_98592_length_250_cov_0.870056_g97378_i0	PRJNA1123436	98592	250	0.870056	2.17514	Fibrobacter sp.	35828	Bacteria	Bacteria	53.9	3.77e-6	NR	NLD99924.1	35828	g97378	i0	46.1	1.884	76	35	87.6	2	230	12	153	225	NLD99924.1 flagellin [Fibrobacter sp.]	diamond	471	53.9	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
30596348	30596348	PRJNA1123436_P_NODE_121333_length_243_cov_0.905882_g120119_i0	PRJNA1123436	121333	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	61.6	8.41e-9	NR	MDB5049237.1	2052160	g120119	i0	56.3	6.67901234567901	64	28	79	0	2	193	1847	1910	MDB5049237.1 hypothetical protein [Fibrobacterota bacterium]	diamond	1623	61.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota 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);;