metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA888821" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA888821" and tax_phylum = "Balneolota"

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
4691080	4691080	PRJNA888821_P_NODE_21584_length_309_cov_5.834746_g21502_i0	PRJNA888821	21584	309	5.834746	18.02936514	Rhodohalobacter	1974209	Bacteria	Bacteria	92	3.46e-20	NR	MDX1641899.1	2053516	g21502	i0	98	2.86407766990291	49	1	47.6	0	148	2	172	220	MDX1641899.1 ATP-binding cassette domain-containing protein [Balneolaceae bacterium]	diamond	885	92	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
26992031	26992031	PRJNA888821_P_NODE_53562_length_196_cov_8.886179_g53479_i0	PRJNA888821	53562	196	8.886179	17.41691084	Rhodohalobacter sulfatireducens	2911366	Bacteria	Bacteria	115	3.51e-28	NR	WP_237856047.1	2911366	g53479	i0	85.9	1.95918367346939	64	9	98	0	3	194	432	495	WP_237856047.1 CotH kinase family protein [Rhodohalobacter sulfatireducens]	diamond	384	115	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter sulfatireducens
27852970	27852970	PRJNA888821_P_NODE_43984_length_225_cov_6.085526_g43901_i0	PRJNA888821	43984	225	6.085526	13.6924335	Fodinibius	1397106	Bacteria	Bacteria	110	3.21e-26	NR	WP_142714119.1	1214077	g43901	i0	70.3	1.97333333333333	74	22	98.7	0	222	1	517	590	WP_142714119.1 FkbM family methyltransferase [Fodinibius sediminis]	diamond	444	110	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius sediminis
27876727	27876727	PRJNA888821_P_NODE_42125_length_231_cov_8.107595_g42042_i0	PRJNA888821	42125	231	8.107595	18.72854445	Balneolaceae bacterium	2053516	Bacteria	Bacteria	111	1.11e-27	NR	MDZ7719000.1	2053516	g42042	i0	65.4	2	78	25	98.7	1	230	3	25	102	MDZ7719000.1 hypothetical protein [Balneolaceae bacterium]	diamond	462	111	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
29076717	29076717	PRJNA888821_P_NODE_31588_length_263_cov_6.694737_g31505_i0	PRJNA888821	31588	263	6.694737	17.60715831	Balneolaceae bacterium	2053516	Bacteria	Bacteria	139	5.68e-36	NR	MDZ7721013.1	2053516	g31505	i0	73.3	0.980988593155893	86	23	98.1	0	263	6	363	448	MDZ7721013.1 T9SS type A sorting domain-containing protein [Balneolaceae bacterium]	diamond	258	139	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
31003393	31003393	PRJNA888821_P_NODE_26414_length_286_cov_5.525822_g26332_i0	PRJNA888821	26414	286	5.525822	15.80385092	Rhodohalobacter sp. 614A	2908649	Bacteria	Bacteria	164	7.319999999999999e-46	NR	WP_234571517.1	2908649	g26332	i0	72.6	0.996503496503496	95	26	99.7	0	1	285	264	358	WP_234571517.1 FG-GAP repeat domain-containing protein [Rhodohalobacter sp. 614A]	diamond	285	164	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter sp. 614A
31699014	31699014	PRJNA888821_P_NODE_51697_length_201_cov_6.234375_g51614_i0	PRJNA888821	51697	201	6.234375	12.53109375	Rhodohalobacter sulfatireducens	2911366	Bacteria	Bacteria	99	3.36e-22	NR	WP_237856368.1	2911366	g51614	i0	73.8	1.94029850746269	65	17	97	0	6	200	668	732	WP_237856368.1 DUF5666 domain-containing protein, partial [Rhodohalobacter sulfatireducens]	diamond	390	99	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter sulfatireducens
32141960	32141960	PRJNA888821_P_NODE_9178_length_310_cov_12.219409_g9096_i0	PRJNA888821	9178	310	12.219409	37.880167899999996	Rhodohalobacter sp. 614A	2908649	Bacteria	Bacteria	171	1.34e-48	NR	WP_234567052.1	2908649	g9096	i0	82.9	1.0741935483871	111	10	98.7	1	2	307	61	171	WP_234567052.1 sodium:solute symporter family protein [Rhodohalobacter sp. 614A]	diamond	333	171	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter sp. 614A
32490132	32490132	PRJNA888821_P_NODE_32059_length_261_cov_5.521277_g31976_i0	PRJNA888821	32059	261	5.521277	14.41053297	Rhodohalobacter sulfatireducens	2911366	Bacteria	Bacteria	103	1.4599999999999995e-23	NR	WP_237852394.1	2911366	g31976	i0	74.6	2.44827586206897	71	18	81.6	0	260	48	391	461	WP_237852394.1 alpha/beta hydrolase [Rhodohalobacter sulfatireducens]	diamond	639	103	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter sulfatireducens

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