metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA706190" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA706190" and tax_phylum = "Bacteroidota"

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
9631330	9631330	PRJNA706190_P_NODE_75648_length_165_cov_0.896552_g75512_i0	PRJNA706190	75648	165	0.896552	1.4793108	Flaviaesturariibacter flavus	2502780	Bacteria	Bacteria	105	1.49e-26	NR	WP_131450110.1	2502780	g75512	i0	89.1	1	55	6	100	0	1	165	124	178	WP_131450110.1 ribonuclease HII [Flaviaesturariibacter flavus]	diamond	165	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flaviaestuariibacter	Flaviaesturariibacter flavus
27273169	27273169	PRJNA706190_P_NODE_7723_length_250_cov_1.791045_g7587_i0	PRJNA706190	7723	250	1.791045	4.4776125	Flavobacterium rhizophilum	3163296	Bacteria	Bacteria	102	4.019999999999999e-23	NR	WP_408075002.1	3163296	g7587	i0	74.4	0.984	82	21	98.4	0	248	3	334	415	WP_408075002.1 YfbK domain-containing protein [Flavobacterium rhizophilum]	diamond	246	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium rhizophilum
27368292	27368292	PRJNA706190_P_NODE_21323_length_204_cov_1.522581_g21187_i0	PRJNA706190	21323	204	1.522581	3.10606524	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	54.3	5.75e-7	NR	WP_249755543.1	2942477	g21187	i0	100	0.382352941176471	26	0	38.2	0	23	100	139	164	WP_249755543.1 thiamine pyrophosphate-dependent enzyme, partial [Algibacter sp. L4_22]	diamond	78	54.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22
27399699	27399699	PRJNA706190_P_NODE_89003_length_162_cov_0.920354_g88867_i0	PRJNA706190	89003	162	0.920354	1.49097348	Hallella sp.	2980186	Bacteria	Bacteria	118	2.4599999999999996e-29	NR	WP_337469263.1	2980186	g88867	i0	100	0.981481481481482	53	0	98.1	0	3	161	468	520	WP_337469263.1 GH92 family glycosyl hydrolase [Hallella sp.]	diamond	159	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hallella	Hallella sp.
27589140	27589140	PRJNA706190_P_NODE_72384_length_165_cov_0.896552_g72248_i0	PRJNA706190	72384	165	0.896552	1.4793108	Hymenobacter rubidus	1441626	Bacteria	Bacteria	92.4	2.95e-20	NR	WP_201982484.1	1441626	g72248	i0	83.3	0.981818181818182	54	9	98.2	0	163	2	105	158	WP_201982484.1 adenylosuccinate lyase [Hymenobacter rubidus]	diamond	162	92.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter rubidus
28125789	28125789	PRJNA706190_P_NODE_39865_length_177_cov_1.781250_g39729_i0	PRJNA706190	39865	177	1.78125	3.1528125	Bacteroidales bacterium	2030927	Bacteria	Bacteria	54.3	1.29e-6	NR	MCK4663537.1	2030927	g39729	i0	36.7	1.01694915254237	60	34	94.9	1	10	177	253	312	MCK4663537.1 hypothetical protein [Bacteroidales bacterium]	diamond	180	54.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28788640	28788640	PRJNA706190_P_NODE_28407_length_192_cov_1.468531_g28271_i0	PRJNA706190	28407	192	1.468531	2.81957952	Urechidicola croceus	1850246	Bacteria	Bacteria	82	2.41e-16	NR	WP_070237854.1	1850246	g28271	i0	58.1	3.890625	62	24	93.8	1	8	187	186	247	WP_070237854.1 GH1 family beta-glucosidase [Urechidicola croceus]	diamond	747	82	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Urechidicola	Urechidicola croceus
29514816	29514816	PRJNA706190_P_NODE_63510_length_167_cov_0.881356_g63374_i0	PRJNA706190	63510	167	0.881356	1.47186452	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	67	2.91e-12	NR	MBL7846895.1	2099675	g63374	i0	68.6	3.70059880239521	51	12	91.6	2	154	2	60	106	MBL7846895.1 IPExxxVDY family protein [Cyclobacteriaceae bacterium]	diamond	618	67	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
30305115	30305115	PRJNA706190_P_NODE_91732_length_162_cov_0.920354_g91596_i0	PRJNA706190	91732	162	0.920354	1.49097348	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	41.6	0.033	NR	MBR4712753.1	2748031	g91596	i0	28.3	0.851851851851852	46	33	85.2	0	7	144	146	191	MBR4712753.1 hypothetical protein [Paludibacteraceae bacterium]	diamond	138	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
31548048	31548048	PRJNA706190_P_NODE_12096_length_228_cov_1.162011_g11960_i0	PRJNA706190	12096	228	1.162011	2.64938508	Flavisolibacter	398041	Bacteria	Bacteria	118	6.36e-29	NR	RYY98697.1	1869212	g11960	i0	77.3	4.84210526315789	75	15	98.7	1	226	2	690	762	RYY98697.1 MAG: methylmalonyl-CoA mutase [Chitinophagaceae bacterium]	diamond	1104	119	0.991596638655462	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32075027	32075027	PRJNA706190_P_NODE_77298_length_164_cov_1.356522_g77162_i0	PRJNA706190	77298	164	1.356522	2.22469608	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	97.1	1.5899999999999995e-23	NR	MBL7730784.1	1869212	g77162	i0	81.1	0.969512195121951	53	10	97	0	6	164	136	188	MBL7730784.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	159	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32296886	32296886	PRJNA706190_P_NODE_1039_length_517_cov_207.331197_g903_i0	PRJNA706190	1039	517	207.331197	1071.90228849	Phocaeicola vulgatus	821	Bacteria	Bacteria	123	8.98e-33	NR	WP_050229787.1	821	g903	i0	95.2	0.731141199226306	126	6	73.1	0	510	133	1	126	WP_050229787.1 hypothetical protein [Phocaeicola vulgatus]	diamond	378	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus

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