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

13 rows where analysis = "diamond", bioproject = "PRJNA1004255" 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
153257	153257	PRJNA1004255_S_NODE_16461_length_160_cov_3.273504_g16253_i0	PRJNA1004255	16461	160	3.273504	5.2376064	Prevotella pectinovora	1602169	Bacteria	Bacteria	100	3.929999999999999e-23	NR	WP_044074180.1	1602169	g16253	i0	100	1.725	46	0	86.3	0	23	160	1	46	WP_044074180.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Prevotella pectinovora]	diamond	276	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella pectinovora
6531400	6531400	PRJNA1004255_S_NODE_13726_length_175_cov_1.068182_g13518_i0	PRJNA1004255	13726	175	1.068182	1.8693185	Asinibacterium sp. OR53	925409	Bacteria	Bacteria	116	2.57e-29	NR	WP_232214798.1	925409	g13518	i0	100	1.98857142857143	58	0	99.4	0	174	1	112	169	WP_232214798.1 Ldh family oxidoreductase [Asinibacterium sp. OR53]	diamond	348	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Asinibacterium	Asinibacterium sp. OR53
7805779	7805779	PRJNA1004255_S_NODE_10107_length_200_cov_3.566879_g9899_i0	PRJNA1004255	10107	200	3.566879	7.133758	Adhaeribacter	299566	Bacteria	Bacteria	124	1.33e-32	NR	MDQ3289789.1	1898104	g9899	i0	90.9	3.96	66	6	99	0	3	200	108	173	MDQ3289789.1 acetyl-CoA carboxylase, carboxyltransferase subunit beta [Bacteroidota bacterium]	diamond	792	125	0.992	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
10356401	10356401	PRJNA1004255_S_NODE_13189_length_178_cov_1.740741_g12981_i0	PRJNA1004255	13189	178	1.740741	3.09851898	FCB group	1783270	Bacteria	Bacteria	112	7.31e-31	NR	MBQ5912914.1	2212467	g12981	i0	92.7	5.56179775280899	55	4	92.7	0	2	166	11	65	MBQ5912914.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase [Bacteroidaceae bacterium]	diamond	990	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
10356449	10356449	PRJNA1004255_S_NODE_9289_length_207_cov_5.475610_g9081_i0	PRJNA1004255	9289	207	5.47561	11.3345127	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	146	8.71e-41	NR	WP_092723363.1	1235997	g9081	i0	100	0.971014492753623	67	0	97.1	0	207	7	65	131	WP_092723363.1 formylglycine-generating enzyme family protein [Hydrobacter penzbergensis]	diamond	201	146	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis
27311729	27311729	PRJNA1004255_S_NODE_4303_length_277_cov_3.615385_g4095_i0	PRJNA1004255	4303	277	3.615385	10.01461645	Mucilaginibacter	423349	Bacteria	Bacteria	151	6.68e-41	NR	WP_157524534.1	2682091	g4095	i0	82.6	1.9927797833935	92	16	99.6	0	1	276	377	468	WP_157524534.1 S41 family peptidase [Mucilaginibacter ginkgonis]	diamond	552	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginkgonis
27887229	27887229	PRJNA1004255_S_NODE_11465_length_189_cov_3.863014_g11257_i0	PRJNA1004255	11465	189	3.863014	7.30109646	Bacteroides neonati	1347393	Bacteria	Bacteria	54.7	1.14e-7	NR	WP_042372622.1	1347393	g11257	i0	85.7	0.444444444444444	28	4	44.4	0	85	2	12	39	WP_042372622.1 hypothetical protein [Bacteroides neonati]	diamond	84	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides neonati
29182054	29182054	PRJNA1004255_S_NODE_3569_length_295_cov_2.603175_g3361_i0	PRJNA1004255	3569	295	2.603175	7.67936625	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	163	4.5e-47	NR	MBX9781503.1	1869212	g3361	i0	100	0.772881355932203	76	0	77.3	0	2	229	272	347	MBX9781503.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	228	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29465633	29465633	PRJNA1004255_S_NODE_12630_length_181_cov_4.427536_g12422_i0	PRJNA1004255	12630	181	4.427536	8.01384016	Bacteroidota bacterium	1898104	Bacteria	Bacteria	56.6	1.86e-7	NR	MEC8883054.1	1898104	g12422	i0	70.6	1.14364640883978	34	10	56.4	0	76	177	134	167	MEC8883054.1 DDE-type integrase/transposase/recombinase [Bacteroidota bacterium]	diamond	207	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30816902	30816902	PRJNA1004255_S_NODE_8834_length_212_cov_1.390533_g8626_i0	PRJNA1004255	8834	212	1.390533	2.94792996	Bacteroidota	976	Bacteria	Bacteria	73.6	3.37e-13	NR	HOD10674.1	239	g8626	i0	46.6	4.07547169811321	73	35	97.6	2	3	209	288	360	HOD10674.1 DUF3987 domain-containing protein [Flavobacterium sp.]	diamond	864	73.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30824319	30824319	PRJNA1004255_S_NODE_5054_length_262_cov_4.068493_g4846_i0	PRJNA1004255	5054	262	4.068493	10.65945166	Paraflavitalea devenefica	2716334	Bacteria	Bacteria	43.5	0.026	NR	WP_167288051.1	2716334	g4846	i0	37.7	0.606870229007634	53	32	59.5	1	103	258	248	300	WP_167288051.1 DUF6603 domain-containing protein [Paraflavitalea devenefica]	diamond	159	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Paraflavitalea	Paraflavitalea devenefica
31139924	31139924	PRJNA1004255_S_NODE_12135_length_184_cov_8.035461_g11927_i0	PRJNA1004255	12135	184	8.035461	14.78524824	Compostibacter hankyongensis	1007089	Bacteria	Bacteria	116	8.37e-30	NR	WP_344980545.1	1007089	g11927	i0	94.9	5.77173913043478	59	3	96.2	0	7	183	178	236	WP_344980545.1 ribonucleoside-diphosphate reductase small subunit [Compostibacter hankyongensis]	diamond	1062	116	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Compostibacter	Compostibacter hankyongensis
31393444	31393444	PRJNA1004255_S_NODE_4616_length_270_cov_5.740088_g4408_i0	PRJNA1004255	4616	270	5.740088	15.4982376	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	137	2.78e-35	NR	WP_092723501.1	1235997	g4408	i0	100	0.811111111111111	73	0	81.1	0	221	3	1	73	WP_092723501.1 preprotein translocase subunit SecA [Hydrobacter penzbergensis]	diamond	219	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis

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