metadata: contig_metadata: 11 rows where bioproject = "PRJNA688931" and tax

11 rows where bioproject = "PRJNA688931" 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
26607327	26607327	PRJNA688931_P_NODE_43921_length_162_cov_0.902655_g43708_i0	PRJNA688931	43921	162	0.902655	1.4623011	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	93.6	6.110000000000001e-21	NR	MBY0491440.1	2026741	g43708	i0	97.8	2.55555555555556	46	1	85.2	0	23	160	1	46	MBY0491440.1 transaldolase [Gemmatimonadaceae bacterium]	diamond	414	93.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28104359	28104359	PRJNA688931_P_NODE_41885_length_163_cov_0.912281_g41672_i0	PRJNA688931	41885	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	42.7	0.0123	NR	HET7585569.1	2026741	g41672	i0	40	3	55	31	97.5	1	161	3	69	123	HET7585569.1 NAD(P)/FAD-dependent oxidoreductase [Gemmatimonadaceae bacterium]	diamond	489	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28672938	28672938	PRJNA688931_P_NODE_25527_length_202_cov_1.437908_g25314_i0	PRJNA688931	25527	202	1.437908	2.90457416	Bacteria	2	Bacteria	Bacteria	70.9	2.35e-12	NR	HTK49688.1	2026741	g25314	i0	55.4	17.5990099009901	56	25	83.2	0	196	29	20	75	HTK49688.1 J domain-containing protein [Gemmatimonadaceae bacterium]	diamond	3555	71.2	0.995786516853933	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28945773	28945773	PRJNA688931_P_NODE_44768_length_152_cov_2.009709_g44555_i0	PRJNA688931	44768	152	2.009709	3.05475768	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	78.2	1.3e-16	NR	HET7423079.1	2448054	g44555	i0	78.7	0.927631578947368	47	10	92.8	0	152	12	108	154	HET7423079.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Gemmatimonadales bacterium]	diamond	141	78.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30587671	30587671	PRJNA688931_P_NODE_19953_length_229_cov_1.483333_g19740_i0	PRJNA688931	19953	229	1.483333	3.39683257	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	99.8	2.49e-24	NR	MDH3455568.1	2026742	g19740	i0	65.8	3.9825327510917	76	26	99.6	0	228	1	72	147	MDH3455568.1 hypoxanthine phosphoribosyltransferase [Gemmatimonadota bacterium]	diamond	912	99.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30682399	30682399	PRJNA688931_P_NODE_25593_length_202_cov_1.215686_g25380_i0	PRJNA688931	25593	202	1.215686	2.45568572	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	51.2	2.17e-5	NR	MCY4544981.1	2026742	g25380	i0	40.7	1.76732673267327	59	35	87.6	0	177	1	81	139	MCY4544981.1 histidinol-phosphate transaminase [Gemmatimonadota bacterium]	diamond	357	51.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30840623	30840623	PRJNA688931_P_NODE_21674_length_220_cov_1.081871_g21461_i0	PRJNA688931	21674	220	1.081871	2.3801162	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	43.1	0.0192	NR	HKP75895.1	3047548	g21461	i0	41.1	1.93636363636364	73	37	94.1	2	209	3	3	73	HKP75895.1 S8 family peptidase [Longimicrobiaceae bacterium]	diamond	426	43.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
31883899	31883899	PRJNA688931_P_NODE_36497_length_168_cov_0.865546_g36284_i0	PRJNA688931	36497	168	0.865546	1.45411728	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	80.9	4.22e-16	NR	MBP7549800.1	2026741	g36284	i0	69.1	4.91071428571429	55	17	98.2	0	166	2	78	132	MBP7549800.1 M20/M25/M40 family metallo-hydrolase [Gemmatimonadaceae bacterium]	diamond	825	80.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32042210	32042210	PRJNA688931_P_NODE_38538_length_166_cov_0.880342_g38325_i0	PRJNA688931	38538	166	0.880342	1.46136772	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	97.1	7.290000000000001e-22	NR	HEX5575431.1	2448054	g38325	i0	81.8	15.9036144578313	55	10	99.4	0	1	165	71	125	HEX5575431.1 Glu/Leu/Phe/Val dehydrogenase [Gemmatimonadales bacterium]	diamond	2640	97.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32263979	32263979	PRJNA688931_P_NODE_6558_length_427_cov_1.777778_g6345_i0	PRJNA688931	6558	427	1.777778	7.59111206	uncultured Gemmatimonadota bacterium	203437	Bacteria	Bacteria	92.8	1.14e-19	NR	CAA9369372.1	203437	g6345	i0	47.7	4.84074941451991	107	51	75.2	2	104	424	33	134	CAA9369372.1 MAG: hypothetical protein AVDCRST_MAG68-5340 [uncultured Gemmatimonadota bacterium]	diamond	2067	92.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadota bacterium
32768803	32768803	PRJNA688931_P_NODE_12500_length_294_cov_3.400000_g12287_i0	PRJNA688931	12500	294	3.4	9.996	Gemmatimonas sp.	1962908	Bacteria	Bacteria	121	5.800000000000001e-30	NR	WP_373064520.1	1962908	g12287	i0	67.7	1.01020408163265	99	31	100	1	294	1	281	379	WP_373064520.1 S8 family serine peptidase [Gemmatimonas sp.]	diamond	297	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.

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