metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA380660" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA380660" 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
26695054	26695054	PRJNA380660_P_NODE_6561_length_292_cov_2.779468_g6161_i0	PRJNA380660	6561	292	2.779468	8.11604656	Flavipsychrobacter sp.	2307286	Bacteria	Bacteria	56.6	8.82e-7	NR	HTN45986.1	2307286	g6161	i0	35.4	1.81849315068493	99	54	97.6	2	2	286	318	410	HTN45986.1 DEAD/DEAH box helicase [Flavipsychrobacter sp.]	diamond	531	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavipsychrobacter	Flavipsychrobacter sp.
26822000	26822000	PRJNA380660_P_NODE_2201_length_570_cov_3.959335_g1857_i0	PRJNA380660	2201	570	3.959335	22.5682095	Candidatus Zhuqueibacterota bacterium	2172550	Bacteria	Bacteria	149	1.98e-39	NR	MCA9743856.1	2172550	g1857	i0	45	2.67894736842105	180	87	94.2	3	550	14	266	434	MCA9743856.1 Glu/Leu/Phe/Val dehydrogenase [Candidatus Zhuqueibacterota bacterium]	diamond	1527	149	1	Bacteria	FCB group	Pseudomonadati						Candidatus Zhuqueibacterota bacterium
27201234	27201234	PRJNA380660_P_NODE_1142_length_809_cov_4.344872_g878_i0	PRJNA380660	1142	809	4.344872	35.15001448	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	43.1	0.0412	NR	MFK7984121.1	2202734	g878	i0	45.5	0.163164400494438	44	24	16.3	0	800	669	1	44	MFK7984121.1 Myb-like DNA-binding domain-containing protein [Saprospiraceae bacterium]	diamond	132	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
27281787	27281787	PRJNA380660_P_NODE_1683_length_651_cov_2.606109_g1364_i0	PRJNA380660	1683	651	2.606109	16.96576959	root	1	Root_unresolved	Root_unresolved	81.6	4.32e-14	NR	WP_345369466.1	1162670	g1364	i0	30.2	1.80184331797235	192	117	84.3	7	554	6	222	405	WP_345369466.1 hypothetical protein [Algivirga pacifica]	diamond	1173	82.4	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Algivirga	Algivirga pacifica
27376802	27376802	PRJNA380660_P_NODE_2903_length_491_cov_2.320346_g2533_i0	PRJNA380660	2903	491	2.320346	11.39289886	Bacteria	2	Bacteria	Bacteria	84.7	1.06e-15	NR	WP_242627216.1	376469	g2533	i0	34	8.63951120162933	156	89	89.8	3	444	4	62	212	WP_242627216.1 MULTISPECIES: sulfatase [Olivibacter]	diamond	4242	84.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Olivibacter
27991129	27991129	PRJNA380660_P_NODE_4125_length_401_cov_3.155914_g3730_i0	PRJNA380660	4125	401	3.155914	12.65521514	Lewinella sp.	2004506	Bacteria	Bacteria	48.1	0.0028	NR	MFK8165220.1	2004506	g3730	i0	34.2	0.591022443890274	79	41	59.1	2	296	60	687	754	MFK8165220.1 proprotein convertase P-domain-containing protein [Lewinella sp.]	diamond	237	48.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	Lewinella sp.
28085633	28085633	PRJNA380660_P_NODE_485_length_1238_cov_5.240695_g347_i0	PRJNA380660	485	1238	5.240695	64.8798041	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	139	1.2699999999999998e-31	NR	MCA6493018.1	1869212	g347	i0	38.8	0.530694668820679	219	118	51.1	9	635	3	146	356	MCA6493018.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	657	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
28165939	28165939	PRJNA380660_P_NODE_2925_length_488_cov_4.740741_g2555_i0	PRJNA380660	2925	488	4.740741	23.13481608	Bacteroidota	976	Bacteria	Bacteria	46.6	0.02	NR	NNK61291.1	1871037	g2555	i0	26.3	3.73770491803279	152	97	90.4	4	26	466	491	632	NNK61291.1 hypothetical protein [Flavobacteriaceae bacterium]	diamond	1824	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
28496334	28496334	PRJNA380660_P_NODE_5127_length_348_cov_2.673981_g4729_i0	PRJNA380660	5127	348	2.673981	9.30545388	Pedobacter metabolipauper	425513	Bacteria	Bacteria	60.5	3.82e-8	NR	WP_133576526.1	425513	g4729	i0	44.3	1.64655172413793	88	42	75.9	1	2	265	10	90	WP_133576526.1 SDR family oxidoreductase [Pedobacter metabolipauper]	diamond	573	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter metabolipauper
29681106	29681106	PRJNA380660_P_NODE_11950_length_170_cov_1.673759_g11550_i0	PRJNA380660	11950	170	1.673759	2.8453903	Pseudomonadati	3379134	Bacteria	Bacteria	80.1	9.33e-16	NR	HIB70907.1	2026760	g11550	i0	60.7	3.95294117647059	56	22	98.8	0	170	3	294	349	HIB70907.1 hypothetical protein [Fidelibacterota bacterium]	diamond	672	80.1	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
30169643	30169643	PRJNA380660_P_NODE_2832_length_497_cov_7.809829_g2463_i0	PRJNA380660	2832	497	7.809829	38.81485013	Phocaeicola vulgatus	821	Bacteria	Bacteria	124	2.48e-33	NR	WP_050229787.1	821	g2463	i0	95.2	0.76056338028169	126	6	76.1	0	473	96	1	126	WP_050229787.1 hypothetical protein [Phocaeicola vulgatus]	diamond	378	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
30485810	30485810	PRJNA380660_P_NODE_6173_length_306_cov_2.191336_g5773_i0	PRJNA380660	6173	306	2.191336	6.70548816	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	63.5	3.92e-9	NR	MCA6493490.1	1869212	g5773	i0	54.1	0.725490196078431	74	29	69.6	4	31	243	608	679	MCA6493490.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	222	63.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31054772	31054772	PRJNA380660_P_NODE_8495_length_236_cov_1.913043_g8095_i0	PRJNA380660	8495	236	1.913043	4.51478148	Bacteroidota bacterium	1898104	Bacteria	Bacteria	65.1	4.04e-10	NR	MDP4280606.1	1898104	g8095	i0	47.5	0.775423728813559	61	32	77.5	0	27	209	151	211	MDP4280606.1 NAD-dependent epimerase/dehydratase family protein [Bacteroidota bacterium]	diamond	183	65.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31686811	31686811	PRJNA380660_P_NODE_2437_length_541_cov_1.968750_g2081_i0	PRJNA380660	2437	541	1.96875	10.6509375	Chitinophaga	79328	Bacteria	Bacteria	318	2.38e-108	NR	WP_095836226.1	79328	g2081	i0	86.4	0.975970425138632	176	24	97.6	0	530	3	11	186	WP_095836226.1 MULTISPECIES: manganese efflux pump [Chitinophaga]	diamond	528	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga
31781617	31781617	PRJNA380660_P_NODE_12697_length_154_cov_2.768000_g12297_i0	PRJNA380660	12697	154	2.768	4.26272	Tannerella sp. oral taxon 8	2382127	Bacteria	Bacteria	40.4	0.0399	NR	PNE24543.1	712711	g12297	i0	35.4	0.935064935064935	48	31	93.5	0	147	4	2	49	PNE24543.1 hypothetical protein BHU16_06450 [Tannerella sp. oral taxon 808]	diamond	144	40.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella sp. oral taxon 808

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