metadata: contig_metadata: 7 rows where analysis = "diamond" and bioproject = "PRJNA529224"

7 rows where analysis = "diamond" and bioproject = "PRJNA529224"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
20240965	20240965	PRJNA529224_S_NODE_296_length_337_cov_10.461039_g289_i0	PRJNA529224	296	337	10.461039	35.25370143	Comamonadaceae bacterium	1871071	Bacteria	Bacteria	170	1.96e-49	NR	MBH2043255.1	1871071	g289	i0	70.3	0.98813056379822	111	33	98.8	0	3	335	157	267	MBH2043255.1 porin [Comamonadaceae bacterium]	diamond	333	170	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium
27425280	27425280	PRJNA529224_S_NODE_1883_length_153_cov_8.379032_g1876_i0	PRJNA529224	1883	153	8.379032	12.81991896	Acinetobacter baumannii	470	Bacteria	Bacteria	39.7	0.0237	NR	RCU35012.1	470	g1876	i0	77.8	0.529411764705882	27	6	52.9	0	103	23	3	29	RCU35012.1 hypothetical protein DVA76_18415, partial [Acinetobacter baumannii]	diamond	81	39.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
29634850	29634850	PRJNA529224_S_NODE_870_length_217_cov_7.441489_g863_i0	PRJNA529224	870	217	7.441489	16.14803113	Burkholderia sp. LMG 13	36773	Bacteria	Bacteria	145	3.03e-39	NR	WP_205191387.1	2709306	g863	i0	100	0.967741935483871	70	0	96.8	0	4	213	479	548	WP_205191387.1 NAD+ synthase [Burkholderia sp. LMG 13014]	diamond	210	145	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia sp. LMG 13014
29824515	29824515	PRJNA529224_S_NODE_1371_length_181_cov_13.447368_g1364_i0	PRJNA529224	1371	181	13.447368	24.33973608	Pseudomonas sp.	306	Bacteria	Bacteria	41.6	0.0431	NR	WP_288078465.1	306	g1364	i0	60.4	0.795580110497238	48	19	79.6	0	34	177	302	349	WP_288078465.1 beta strand repeat-containing protein, partial [Pseudomonas sp.]	diamond	144	41.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp.
31057201	31057201	PRJNA529224_S_NODE_1375_length_181_cov_4.309211_g1368_i0	PRJNA529224	1375	181	4.309211	7.79967191	Vreelandella aquamarina	77097	Bacteria	Bacteria	44.7	0.00337	NR	WP_273682536.1	77097	g1368	i0	55.9	1.93922651933702	59	25	97.8	1	3	179	217	274	WP_273682536.1 beta strand repeat-containing protein [Vreelandella aquamarina]	diamond	351	44.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Vreelandella	Vreelandella aquamarina
31341383	31341383	PRJNA529224_S_NODE_936_length_212_cov_8.464481_g929_i0	PRJNA529224	936	212	8.464481	17.94469972	Burkholderia sp. LMG 13	36773	Bacteria	Bacteria	139	9.9e-39	NR	WP_205191385.1	2709306	g929	i0	100	1.9811320754717	70	0	99.1	0	3	212	58	127	WP_205191385.1 3-deoxy-8-phosphooctulonate synthase [Burkholderia sp. LMG 13014]	diamond	420	139	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia sp. LMG 13014
31689205	31689205	PRJNA529224_S_NODE_577_length_257_cov_14.000000_g570_i0	PRJNA529224	577	257	14	35.98	Actinomycetota bacterium	2900548	Bacteria	Bacteria	90.9	1.88e-19	NR	MCA1800798.1	2900548	g570	i0	63.5	0.992217898832685	85	31	99.2	0	257	3	158	242	MCA1800798.1 hypothetical protein [Actinomycetota bacterium]	diamond	255	90.9	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota 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);;