metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB81327" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB81327" and tax_phylum = "Gemmatimonadota"

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
11200547	11200547	PRJEB81327_P_NODE_67409_length_232_cov_2.572327_g66801_i0	PRJEB81327	67409	232	2.572327	5.96779864	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	141	4.11e-37	NR	GJG85456.1	2839016	g66801	i0	85.7	2.98706896551724	77	11	99.6	0	232	2	76	152	GJG85456.1 glucosamine-6-phosphate deaminase [Gemmatimonadetes bacterium T265]	diamond	693	141	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
16299567	16299567	PRJEB81327_P_NODE_24593_length_288_cov_1.432558_g23985_i0	PRJEB81327	24593	288	1.432558	4.12576704	Longimicrobium sp.	2029185	Bacteria	Bacteria	101	5.22e-24	NR	HEX8673236.1	2029185	g23985	i0	90.9	2.29166666666667	55	5	57.3	0	1	165	197	251	HEX8673236.1 HrcA family transcriptional regulator [Longimicrobium sp.]	diamond	660	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
17991729	17991729	PRJEB81327_P_NODE_63835_length_241_cov_4.809524_g63227_i0	PRJEB81327	63835	241	4.809524	11.59095284	Gemmatirosa sp.	2510638	Bacteria	Bacteria	116	1.47e-30	NR	HEY0780523.1	2510638	g63227	i0	82.1	1.95435684647303	78	14	97.1	0	2	235	35	112	HEY0780523.1 DUF979 family protein [Gemmatirosa sp.]	diamond	471	116	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
28739678	28739678	PRJEB81327_P_NODE_60067_length_244_cov_0.900585_g59459_i0	PRJEB81327	60067	244	0.900585	2.1974274	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.4	0.0453	NR	MEX2526726.1	2026742	g59459	i0	35	0.983606557377049	80	51	97.1	1	6	242	142	221	MEX2526726.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	240	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29813067	29813067	PRJEB81327_P_NODE_64991_length_241_cov_0.916667_g64383_i0	PRJEB81327	64991	241	0.916667	2.20916747	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	50.8	5.15e-5	NR	HWJ14826.1	2026741	g64383	i0	62.8	1.13278008298755	43	14	51	1	106	228	4	46	HWJ14826.1 alpha-glucuronidase family glycosyl hydrolase [Gemmatimonadaceae bacterium]	diamond	273	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29869056	29869056	PRJEB81327_P_NODE_45491_length_252_cov_1.363128_g44883_i0	PRJEB81327	45491	252	1.363128	3.43508256	Gemmatimonas	173479	Bacteria	Bacteria	42.7	0.0405	NR	WP_337171994.1	173480	g44883	i0	40.3	1.21428571428571	62	34	73.8	1	24	209	327	385	WP_337171994.1 cytochrome b N-terminal domain-containing protein [Gemmatimonas aurantiaca]	diamond	306	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
30508222	30508222	PRJEB81327_P_NODE_51833_length_248_cov_0.880000_g51225_i0	PRJEB81327	51833	248	0.88	2.1824	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.8	3.75e-5	NR	MBT5145793.1	2026742	g51225	i0	47.9	1.16129032258065	48	25	58.1	0	4	147	88	135	MBT5145793.1 pentapeptide repeat-containing protein [Gemmatimonadota bacterium]	diamond	288	50.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30974966	30974966	PRJEB81327_P_NODE_62294_length_242_cov_1.822485_g61686_i0	PRJEB81327	62294	242	1.822485	4.4104137	Gemmatimonas	173479	Bacteria	Bacteria	150	3.629999999999999e-42	NR	WP_396204666.1	1962908	g61686	i0	86.3	4.95867768595041	80	11	99.2	0	241	2	26	105	WP_396204666.1 NAD-dependent epimerase/dehydratase family protein [Gemmatimonas sp.]	diamond	1200	150	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
31045675	31045675	PRJEB81327_P_NODE_54155_length_247_cov_0.885057_g53547_i0	PRJEB81327	54155	247	0.885057	2.18609079	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	138	3.64e-39	NR	HWO88676.1	2448054	g53547	i0	88.8	0.97165991902834	80	9	97.2	0	1	240	125	204	HWO88676.1 response regulator transcription factor [Gemmatimonadales bacterium]	diamond	240	138	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31361605	31361605	PRJEB81327_P_NODE_52496_length_248_cov_0.880000_g51888_i0	PRJEB81327	52496	248	0.88	2.1824	Longimicrobium sp.	2029185	Bacteria	Bacteria	128	7.120000000000001e-33	NR	HEX8430016.1	2029185	g51888	i0	72	1.98387096774194	82	23	99.2	0	2	247	162	243	HEX8430016.1 hypothetical protein [Longimicrobium sp.]	diamond	492	128	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31361606	31361606	PRJEB81327_P_NODE_53796_length_247_cov_0.885057_g53188_i0	PRJEB81327	53796	247	0.885057	2.18609079	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	84	1.18e-16	NR	MBV9774374.1	2026742	g53188	i0	78.2	2.07692307692308	55	12	66.8	0	82	246	4	58	MBV9774374.1 FAD-dependent oxidoreductase [Gemmatimonadota bacterium]	diamond	513	84	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31899200	31899200	PRJEB81327_P_NODE_63577_length_242_cov_0.911243_g62969_i0	PRJEB81327	63577	242	0.911243	2.20520806	Longimicrobium sp.	2029185	Bacteria	Bacteria	126	1.47e-32	NR	WP_329685498.1	2029185	g62969	i0	77.5	1.98347107438017	80	18	99.2	0	3	242	33	112	WP_329685498.1 low temperature requirement protein A [Longimicrobium sp.]	diamond	480	126	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31994087	31994087	PRJEB81327_P_NODE_25518_length_286_cov_2.577465_g24910_i0	PRJEB81327	25518	286	2.577465	7.3715499	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	185	7.089999999999999e-55	NR	HSJ10138.1	2910168	g24910	i0	86.3	1.99300699300699	95	13	99.7	0	285	1	189	283	HSJ10138.1 serine hydrolase [Longimicrobiales bacterium]	diamond	570	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32120802	32120802	PRJEB81327_P_NODE_65478_length_241_cov_0.916667_g64870_i0	PRJEB81327	65478	241	0.916667	2.20916747	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	106	1.49e-24	NR	HXG72790.1	2026741	g64870	i0	57	0.983402489626556	79	34	98.3	0	237	1	99	177	HXG72790.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	237	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;