metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax_clade = "FCB group"

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
26789311	26789311	PRJNA263496_P_NODE_21181_length_167_cov_0.864407_g20928_i0	PRJNA263496	21181	167	0.864407	1.44355969	Candidatus Cryptobacteroides sp.	2952915	Bacteria	Bacteria	41.2	0.0477	NR	MDY4481293.1	2952915	g20928	i0	39.6	0.862275449101796	48	29	86.2	0	144	1	501	548	MDY4481293.1 DNA methyltransferase [Candidatus Cryptobacteroides sp.]	diamond	144	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales		Candidatus Cryptobacteroides	Candidatus Cryptobacteroides sp.
26996698	26996698	PRJNA263496_P_NODE_20762_length_168_cov_1.605042_g20509_i0	PRJNA263496	20762	168	1.605042	2.69647056	Gillisia	244698	Bacteria	Bacteria	70.5	1.48e-12	NR	WP_006987546.1	195907	g20509	i0	63.6	2.91071428571429	55	20	98.2	0	167	3	14	68	WP_006987546.1 aldo/keto reductase [Gillisia limnaea]	diamond	489	70.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Gillisia	Gillisia limnaea
28432091	28432091	PRJNA263496_P_NODE_21006_length_167_cov_1.296610_g20753_i0	PRJNA263496	21006	167	1.29661	2.1653387	Bacteroidales bacterium	2030927	Bacteria	Bacteria	107	2.22e-25	NR	MFO7827122.1	2030927	g20753	i0	94.2	0.934131736526946	52	3	93.4	0	11	166	971	1022	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	156	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28810564	28810564	PRJNA263496_P_NODE_5828_length_341_cov_3.191781_g5575_i0	PRJNA263496	5828	341	3.191781	10.88397321	Aequorivita sinensis	1382458	Bacteria	Bacteria	96.7	5.1799999999999987e-23	NR	WP_282033232.1	1382458	g5575	i0	58.1	0.818181818181818	93	28	73.9	2	258	7	25	115	WP_282033232.1 hypothetical protein, partial [Aequorivita sinensis]	diamond	279	96.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aequorivita	Aequorivita sinensis
28874021	28874021	PRJNA263496_P_NODE_23868_length_163_cov_0.894737_g23615_i0	PRJNA263496	23868	163	0.894737	1.45842131	Flavobacterium sp.	239	Bacteria	Bacteria	116	1.66e-28	NR	MBP7397580.1	239	g23615	i0	100	0.993865030674847	54	0	99.4	0	162	1	544	597	MBP7397580.1 FAD-dependent oxidoreductase [Flavobacterium sp.]	diamond	162	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29726296	29726296	PRJNA263496_P_NODE_13110_length_216_cov_1.514970_g12857_i0	PRJNA263496	13110	216	1.51497	3.2723352	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	43.1	0.0172	NR	RYG34286.1	1869212	g12857	i0	42.2	0.625	45	25	62.5	1	78	212	131	174	RYG34286.1 MAG: RNA methyltransferase [Chitinophagaceae bacterium]	diamond	135	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30958781	30958781	PRJNA263496_P_NODE_13294_length_215_cov_0.813253_g13041_i0	PRJNA263496	13294	215	0.813253	1.74849395	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	61.6	1.39e-10	NR	MFO7863651.1	2053305	g13041	i0	75.6	0.572093023255814	41	10	57.2	0	67	189	33	73	MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium]	diamond	123	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae bacterium
30958785	30958785	PRJNA263496_P_NODE_23154_length_164_cov_0.886957_g22901_i0	PRJNA263496	23154	164	0.886957	1.45460948	Bacteroidales bacterium	2030927	Bacteria	Bacteria	112	2.7300000000000003e-27	NR	MFO7827122.1	2030927	g22901	i0	100	0.98780487804878	54	0	98.8	0	163	2	498	551	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	162	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31147855	31147855	PRJNA263496_P_NODE_3395_length_477_cov_3.207944_g3142_i0	PRJNA263496	3395	477	3.207944	15.30189288	Aequorivita sinensis	1382458	Bacteria	Bacteria	75.1	5.98e-14	NR	WP_282033232.1	1382458	g3142	i0	70.8	0.30188679245283	48	14	30.2	0	200	343	78	125	WP_282033232.1 hypothetical protein, partial [Aequorivita sinensis]	diamond	144	75.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aequorivita	Aequorivita sinensis
31812426	31812426	PRJNA263496_P_NODE_21277_length_167_cov_0.864407_g21024_i0	PRJNA263496	21277	167	0.864407	1.44355969	Chishuiella sp.	1969467	Bacteria	Bacteria	115	1.05e-29	NR	WP_313384120.1	1969467	g21024	i0	100	0.988023952095808	55	0	98.8	0	1	165	90	144	WP_313384120.1 glycosyltransferase family A protein [Chishuiella sp.]	diamond	165	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chishuiella	Chishuiella sp.
32160646	32160646	PRJNA263496_P_NODE_19178_length_177_cov_1.132812_g18925_i0	PRJNA263496	19178	177	1.132812	2.00507724	Flavobacterium subsaxonicum	426226	Bacteria	Bacteria	99.8	9.82e-26	NR	WP_035755264.1	426226	g18925	i0	89.5	5.84745762711864	57	6	96.6	0	6	176	1	57	WP_035755264.1 lipocalin/fatty-acid binding family protein, partial [Flavobacterium subsaxonicum]	diamond	1035	99.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium subsaxonicum

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