metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJEB55122" and tax

16 rows where analysis = "diamond", bioproject = "PRJEB55122" 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
17972784	17972784	PRJEB55122_P_NODE_35255_length_173_cov_1.314516_g34858_i0	PRJEB55122	35255	173	1.314516	2.27411268	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	101	2.5599999999999998e-23	NR	NQX99034.1	2021391	g34858	i0	89.5	1.97687861271676	57	6	98.8	0	3	173	357	413	NQX99034.1 molecular chaperone HtpG [Flavobacteriales bacterium]	diamond	342	101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27507732	27507732	PRJEB55122_P_NODE_37103_length_169_cov_0.866667_g36706_i0	PRJEB55122	37103	169	0.866667	1.46466723	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	64.7	1.68e-10	NR	MBF1060726.1	2049047	g36706	i0	87.9	0.585798816568047	33	4	58.6	0	169	71	254	286	MBF1060726.1 DUF4007 family protein [Prevotellaceae bacterium]	diamond	99	64.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
28201966	28201966	PRJEB55122_P_NODE_39666_length_166_cov_0.888889_g39269_i0	PRJEB55122	39666	166	0.888889	1.47555574	Flavobacterium ajazii	2692318	Bacteria	Bacteria	114	3.74e-28	NR	WP_163407520.1	2692318	g39269	i0	92.7	1.98795180722892	55	4	99.4	0	165	1	359	413	WP_163407520.1 Dyp-type peroxidase [Flavobacterium ajazii]	diamond	330	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ajazii
28486380	28486380	PRJEB55122_P_NODE_42487_length_163_cov_0.912281_g42090_i0	PRJEB55122	42487	163	0.912281	1.48701803	Bacteroidota bacterium	1898104	Bacteria	Bacteria	42	0.0241	NR	TMI86168.1	1898104	g42090	i0	50	1.41717791411043	38	14	69.9	1	121	8	390	422	TMI86168.1 MAG: hypothetical protein E6H10_00775 [Bacteroidota bacterium]	diamond	231	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28833629	28833629	PRJEB55122_P_NODE_7288_length_511_cov_2.967532_g6897_i0	PRJEB55122	7288	511	2.967532	15.16408852	Fibrobacter sp.	35828	Bacteria	Bacteria	46.6	0.0238	NR	NLE01614.1	35828	g6897	i0	28.9	0.569471624266145	97	66	55.2	1	365	84	61	157	NLE01614.1 hypothetical protein [Fibrobacter sp.]	diamond	291	46.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
28896689	28896689	PRJEB55122_P_NODE_26988_length_205_cov_1.000000_g26591_i0	PRJEB55122	26988	205	1	2.05	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.9	0.00914	NR	MFO7827238.1	2030927	g26591	i0	56.4	0.570731707317073	39	17	57.1	0	34	150	874	912	MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium]	diamond	117	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29118039	29118039	PRJEB55122_P_NODE_43969_length_159_cov_3.490909_g43572_i0	PRJEB55122	43969	159	3.490909	5.55054531	Lewinellaceae bacterium	2760807	Bacteria	Bacteria	42.7	0.0124	NR	MCB9080362.1	2760807	g43572	i0	42.6	1.0188679245283	54	21	86.8	2	16	153	201	252	MCB9080362.1 Na+:solute symporter [Lewinellaceae bacterium]	diamond	162	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae		Lewinellaceae bacterium
29275546	29275546	PRJEB55122_P_NODE_9889_length_410_cov_1.135734_g9495_i0	PRJEB55122	9889	410	1.135734	4.6565094	Bacteroidales bacterium	2030927	Bacteria	Bacteria	102	2.4e-22	NR	MFO7827238.1	2030927	g9495	i0	46.7	0.878048780487805	120	64	87.8	0	392	33	812	931	MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium]	diamond	360	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29685816	29685816	PRJEB55122_P_NODE_14570_length_309_cov_1.715385_g14173_i0	PRJEB55122	14570	309	1.715385	5.30053965	Amoebophilaceae bacterium	2053498	Bacteria	Bacteria	80.5	1.92e-16	NR	MBX9889905.1	2053498	g14173	i0	61.7	1.16504854368932	60	23	58.3	0	183	4	32	91	MBX9889905.1 hypothetical protein [Amoebophilaceae bacterium]	diamond	360	80.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Amoebophilaceae		Amoebophilaceae bacterium
30444449	30444449	PRJEB55122_P_NODE_18673_length_260_cov_1.668246_g18276_i0	PRJEB55122	18673	260	1.668246	4.3374396	Fulvivirga sp.	1931237	Bacteria	Bacteria	43.1	0.034	NR	WP_350108489.1	1931237	g18276	i0	42.4	0.680769230769231	59	31	64.6	1	222	55	582	640	WP_350108489.1 hypothetical protein [Fulvivirga sp.]	diamond	177	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga sp.
30981629	30981629	PRJEB55122_P_NODE_39794_length_166_cov_0.888889_g39397_i0	PRJEB55122	39794	166	0.888889	1.47555574	Bacteroidales bacterium	2030927	Bacteria	Bacteria	50.8	1.86e-5	NR	MFO7827238.1	2030927	g39397	i0	72.7	0.596385542168675	33	9	59.6	0	162	64	605	637	MFO7827238.1 reverse transcriptase domain-containing protein [Bacteroidales bacterium]	diamond	99	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31392565	31392565	PRJEB55122_P_NODE_42256_length_163_cov_0.912281_g41859_i0	PRJEB55122	42256	163	0.912281	1.48701803	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	58.2	1.94e-8	NR	MCX5759579.1	2030809	g41859	i0	61.4	1.65644171779141	44	17	81	0	148	17	14	57	MCX5759579.1 extracellular solute-binding protein [Candidatus Hydrogenedentota bacterium]	diamond	270	58.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota					Candidatus Hydrogenedentota bacterium
31455715	31455715	PRJEB55122_P_NODE_12136_length_353_cov_1.993421_g11739_i0	PRJEB55122	12136	353	1.993421	7.03677613	Psychroflexus montanilacus	2873598	Bacteria	Bacteria	43.9	0.0461	NR	WP_224464835.1	2873598	g11739	i0	29.3	0.696883852691218	82	55	67.1	1	104	340	205	286	WP_224464835.1 hypothetical protein [Psychroflexus montanilacus]	diamond	246	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroflexus	Psychroflexus montanilacus
31455719	31455719	PRJEB55122_P_NODE_29636_length_193_cov_1.541667_g29239_i0	PRJEB55122	29636	193	1.541667	2.97541731	Chryseobacterium sp.	1871047	Bacteria	Bacteria	42.4	0.0274	NR	WP_312079121.1	1871047	g29239	i0	36.5	0.808290155440414	52	31	80.8	1	181	26	841	890	WP_312079121.1 T9SS type B sorting domain-containing protein [Chryseobacterium sp.]	diamond	156	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
31582286	31582286	PRJEB55122_P_NODE_21856_length_234_cov_1.805405_g21459_i0	PRJEB55122	21856	234	1.805405	4.2246477	Bacteroidales bacterium	2030927	Bacteria	Bacteria	74.7	1.8e-13	NR	MFO7827122.1	2030927	g21459	i0	44.2	0.987179487179487	77	43	98.7	0	232	2	345	421	MFO7827122.1 reverse transcriptase family protein [Bacteroidales bacterium]	diamond	231	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32783181	32783181	PRJEB55122_P_NODE_38700_length_167_cov_0.881356_g38303_i0	PRJEB55122	38700	167	0.881356	1.47186452	Mucilaginibacter lappiensis	354630	Bacteria	Bacteria	107	3.42e-26	NR	WP_183584955.1	354630	g38303	i0	100	0.988023952095808	55	0	98.8	0	3	167	230	284	WP_183584955.1 acyltransferase family protein [Mucilaginibacter lappiensis]	diamond	165	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter lappiensis

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