metadata: contig_metadata: 8 rows where bioproject = "PRJNA781427" and tax

8 rows where bioproject = "PRJNA781427" and tax_clade = "sulfur-oxidizing symbionts"

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_species
28948602	28948602	PRJNA781427_P_NODE_33068_length_402_cov_0.866261_g32187_i0	PRJNA781427	33068	402	0.866261	3.48236922	Bathymodiolus thermophilus thioautotrophic gill symbiont	2360	Bacteria	Bacteria	147	1.2499999999999997e-42	NR	CAB5496537.1	2360	g32187	i0	90.9	0.574626865671642	77	7	57.5	0	400	170	8	84	CAB5496537.1 hypothetical protein AZO1586I_33 [Bathymodiolus thermophilus thioautotrophic gill symbiont]	diamond	231	147	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus thermophilus thioautotrophic gill symbiont
29201137	29201137	PRJNA781427_P_NODE_90069_length_244_cov_0.900585_g89185_i0	PRJNA781427	90069	244	0.900585	2.1974274	Bathymodiolus thermophilus thioautotrophic gill symbiont	2360	Bacteria	Bacteria	58.9	8.36e-9	NR	CAB5496537.1	2360	g89185	i0	55.6	0.663934426229508	54	19	60.2	1	8	154	1	54	CAB5496537.1 hypothetical protein AZO1586I_33 [Bathymodiolus thermophilus thioautotrophic gill symbiont]	diamond	162	58.9	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus thermophilus thioautotrophic gill symbiont
29674248	29674248	PRJNA781427_P_NODE_60930_length_285_cov_0.891509_g60046_i0	PRJNA781427	60930	285	0.891509	2.54080065	Bathymodiolus thermophilus thioautotrophic gill symbiont	2360	Bacteria	Bacteria	45.8	0.00148	NR	CAB5496537.1	2360	g60046	i0	50	0.463157894736842	44	21	46.3	1	248	117	42	84	CAB5496537.1 hypothetical protein AZO1586I_33 [Bathymodiolus thermophilus thioautotrophic gill symbiont]	diamond	132	45.8	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus thermophilus thioautotrophic gill symbiont
31222407	31222407	PRJNA781427_P_NODE_53855_length_306_cov_0.841202_g52972_i0	PRJNA781427	53855	306	0.841202	2.57407812	Bathymodiolus thermophilus thioautotrophic gill symbiont	2360	Bacteria	Bacteria	57.8	4.72e-8	NR	CAB5496537.1	2360	g52972	i0	60.8	0.5	51	20	50	0	74	226	1	51	CAB5496537.1 hypothetical protein AZO1586I_33 [Bathymodiolus thermophilus thioautotrophic gill symbiont]	diamond	153	57.8	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus thermophilus thioautotrophic gill symbiont
31728616	31728616	PRJNA781427_P_NODE_94497_length_242_cov_0.911243_g93613_i0	PRJNA781427	94497	242	0.911243	2.20520806	Bathymodiolus thermophilus thioautotrophic gill symbiont	2360	Bacteria	Bacteria	51.6	5.55e-6	NR	CAB5496537.1	2360	g93613	i0	42.9	0.867768595041322	70	37	86.8	1	8	217	19	85	CAB5496537.1 hypothetical protein AZO1586I_33 [Bathymodiolus thermophilus thioautotrophic gill symbiont]	diamond	210	51.6	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus thermophilus thioautotrophic gill symbiont
31791767	31791767	PRJNA781427_P_NODE_97557_length_231_cov_2.145570_g96673_i0	PRJNA781427	97557	231	2.14557	4.9562667	Solemya velum gill symbiont	2340	Bacteria	Bacteria	58.2	8.94e-8	NR	WP_218669809.1	2340	g96673	i0	38.5	4.05194805194805	78	40	96.1	3	6	227	161	234	WP_218669809.1 GIY-YIG nuclease family protein, partial [Solemya velum gill symbiont]	diamond	936	58.2	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Solemya velum gill symbiont
32171838	32171838	PRJNA781427_P_NODE_87838_length_245_cov_0.895349_g86954_i0	PRJNA781427	87838	245	0.895349	2.19360505	Bathymodiolus azoricus thioautotrophic gill symbiont	235205	Bacteria	Bacteria	61.2	1.17e-8	NR	WP_202775563.1	235205	g86954	i0	65	0.489795918367347	40	14	49	0	125	244	217	256	WP_202775563.1 reverse transcriptase domain-containing protein, partial [Bathymodiolus azoricus thioautotrophic gill symbiont]	diamond	120	61.2	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus azoricus thioautotrophic gill symbiont
32424803	32424803	PRJNA781427_P_NODE_86459_length_246_cov_0.890173_g85575_i0	PRJNA781427	86459	246	0.890173	2.18982558	Bathymodiolus azoricus thioautotrophic gill symbiont	235205	Bacteria	Bacteria	41.6	0.013	NR	WP_206599462.1	235205	g85575	i0	53.5	1.15853658536585	43	20	52.4	0	159	31	12	54	WP_206599462.1 hypothetical protein, partial [Bathymodiolus azoricus thioautotrophic gill symbiont]	diamond	285	41.6	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Bathymodiolus azoricus thioautotrophic gill symbiont

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