metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA690234" 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
26861221	26861221	PRJNA690234_P_NODE_25461_length_252_cov_1.743017_g25094_i0	PRJNA690234	25461	252	1.743017	4.39240284	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	136	3.36e-36	NR	MFI5203427.1	2021391	g25094	i0	75	32.7738095238095	84	21	100	0	252	1	245	328	MFI5203427.1 ornithine--oxo-acid transaminase [Flavobacteriales bacterium]	diamond	8259	136	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27335409	27335409	PRJNA690234_P_NODE_6043_length_526_cov_20.041943_g5679_i0	PRJNA690234	6043	526	20.041943	105.42062018	Candidatus Aegiribacteria sp.	2528271	Bacteria	Bacteria	94.7	5.88e-22	NR	MFO8183585.1	2528271	g5679	i0	57.7	1.39733840304182	78	33	44.5	0	505	272	2	79	MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.]	diamond	735	94.7	1	Bacteria	FCB group	Pseudomonadati					Candidatus Aegiribacteria	Candidatus Aegiribacteria sp.
27430268	27430268	PRJNA690234_P_NODE_10703_length_390_cov_1.637224_g10337_i0	PRJNA690234	10703	390	1.637224	6.3851736	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	44.3	0.0444	NR	MBI34595.1	2021391	g10337	i0	32.4	0.569230769230769	74	47	56.9	1	228	7	118	188	MBI34595.1 hypothetical protein [Flavobacteriales bacterium]	diamond	222	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27682961	27682961	PRJNA690234_P_NODE_2024_length_929_cov_5.154206_g1746_i0	PRJNA690234	2024	929	5.154206	47.88257374	Yeosuana aromativorans	288019	Bacteria	Bacteria	52.8	4.14e-4	NR	WP_188650315.1	288019	g1746	i0	26.8	0.67491926803014	209	131	62.3	6	859	281	9	211	WP_188650315.1 LolA family protein [Yeosuana aromativorans]	diamond	627	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Yeosuana	Yeosuana aromativorans
27883445	27883445	PRJNA690234_P_NODE_23765_length_260_cov_1.363636_g23398_i0	PRJNA690234	23765	260	1.363636	3.5454536	FCB group	1783270	Bacteria	Bacteria	67.8	6.88e-11	NR	MFT5210989.1	239	g23398	i0	48.2	10.4884615384615	85	43	98.1	1	256	2	196	279	MFT5210989.1 choline dehydrogenase-like flavoprotein [Flavobacterium sp.]	diamond	2727	67.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
27883446	27883446	PRJNA690234_P_NODE_25405_length_253_cov_0.866667_g25038_i0	PRJNA690234	25405	253	0.866667	2.19266751	Flavobacteriales	200644	Bacteria	Bacteria	58.2	1.44e-7	NR	HEY6143543.1	239	g25038	i0	82.4	3.61660079051383	34	6	40.3	0	152	253	1	34	HEY6143543.1 acyltransferase family protein [Flavobacterium sp.]	diamond	915	58.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30082240	30082240	PRJNA690234_P_NODE_27892_length_248_cov_1.337143_g27525_i0	PRJNA690234	27892	248	1.337143	3.31611464	Bacteroidales bacterium	2030927	Bacteria	Bacteria	61.6	7.29e-9	NR	MCX7953585.1	2030927	g27525	i0	46.6	2.84274193548387	58	31	70.2	0	73	246	22	79	MCX7953585.1 NAD-dependent epimerase/dehydratase family protein [Bacteroidales bacterium]	diamond	705	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30461978	30461978	PRJNA690234_P_NODE_22333_length_268_cov_2.507692_g21966_i0	PRJNA690234	22333	268	2.507692	6.72061456	Parafilimonas sp.	1969739	Bacteria	Bacteria	89.4	1.03e-18	NR	HYK45670.1	1969739	g21966	i0	50.6	0.951492537313433	85	42	95.1	0	268	14	35	119	HYK45670.1 HesA/MoeB/ThiF family protein [Parafilimonas sp.]	diamond	255	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Parafilimonas	Parafilimonas sp.
30650848	30650848	PRJNA690234_P_NODE_12173_length_363_cov_1.851724_g11806_i0	PRJNA690234	12173	363	1.851724	6.72175812	Lacibacter sp.	1915409	Bacteria	Bacteria	47	0.00307	NR	WP_324232586.1	1915409	g11806	i0	31.9	0.776859504132231	94	63	76.9	1	44	322	3	96	WP_324232586.1 hypothetical protein [Lacibacter sp.]	diamond	282	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp.
30650851	30650851	PRJNA690234_P_NODE_16013_length_318_cov_0.918367_g15646_i0	PRJNA690234	16013	318	0.918367	2.92040706	Bacteroidia bacterium	2044936	Bacteria	Bacteria	43.5	0.0474	NR	MEI8115686.1	2044936	g15646	i0	36.1	0.575471698113208	61	36	57.5	1	119	301	621	678	MEI8115686.1 Ig-like domain-containing protein [Bacteroidia bacterium]	diamond	183	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
31314721	31314721	PRJNA690234_P_NODE_22895_length_265_cov_1.625000_g22528_i0	PRJNA690234	22895	265	1.625	4.30625	Weeksellaceae bacterium A-14	3143028	Bacteria	Bacteria	42.4	0.0473	NR	MEN2436866.1	3143028	g22528	i0	34.8	1.00754716981132	89	50	95.1	2	263	12	92	177	MEN2436866.1 hypothetical protein [Weeksellaceae bacterium A-14]	diamond	267	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium A-14
31441174	31441174	PRJNA690234_P_NODE_26296_length_251_cov_0.876404_g25929_i0	PRJNA690234	26296	251	0.876404	2.19977404	Kaistella carnis	1241979	Bacteria	Bacteria	126	1.7399999999999999e-31	NR	WP_312820434.1	1241979	g25929	i0	75.9	0.99203187250996006	83	20	99.2	0	250	2	175	257	WP_312820434.1 UvrD-helicase domain-containing protein [Kaistella carnis]	diamond	249	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella carnis
31757531	31757531	PRJNA690234_P_NODE_21197_length_275_cov_2.361386_g20830_i0	PRJNA690234	21197	275	2.361386	6.4938115	Salibacteraceae bacterium	2832350	Bacteria	Bacteria	52.4	2.11e-5	NR	MDC1222222.1	2832350	g20830	i0	41	2.07272727272727	61	35	65.5	1	94	273	2	62	MDC1222222.1 DnaJ domain-containing protein [Salibacteraceae bacterium]	diamond	570	52.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Salibacteraceae		Salibacteraceae 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);;