metadata: contig_metadata: 5 rows where bioproject = "PRJNA789095" and tax

5 rows where bioproject = "PRJNA789095" 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
26705298	26705298	PRJNA789095_P_NODE_60741_length_262_cov_0.867725_g59407_i0	PRJNA789095	60741	262	0.867725	2.2734395	Solemya elarraichensis gill symbiont	1918949	Bacteria	Bacteria	73.2	9.22e-13	NR	WP_135568224.1	1918949	g59407	i0	51.2	0.938931297709924	82	40	93.9	0	247	2	450	531	WP_135568224.1 reverse transcriptase domain-containing protein, partial [Solemya elarraichensis gill symbiont]	diamond	246	73.2	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Solemya elarraichensis gill symbiont
29484982	29484982	PRJNA789095_P_NODE_15170_length_698_cov_3.884800_g13879_i0	PRJNA789095	15170	698	3.8848	27.115904	Solemya velum gill symbiont	2340	Bacteria	Bacteria	199	7.9500000000000005e-59	NR	WP_144078572.1	2340	g13879	i0	51.6	10.3409742120344	186	90	79.9	0	698	141	96	281	WP_144078572.1 RNA-directed DNA polymerase, partial [Solemya velum gill symbiont]	diamond	7218	199	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Solemya velum gill symbiont
29800902	29800902	PRJNA789095_P_NODE_76771_length_237_cov_3.530488_g75437_i0	PRJNA789095	76771	237	3.530488	8.36725656	Solemya velum gill symbiont	2340	Bacteria	Bacteria	83.2	3.64e-18	NR	WP_218670479.1	2340	g75437	i0	51.9	8	79	37	98.7	1	235	2	33	111	WP_218670479.1 reverse transcriptase domain-containing protein, partial [Solemya velum gill symbiont]	diamond	1896	83.2	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Solemya velum gill symbiont
31444136	31444136	PRJNA789095_P_NODE_10996_length_933_cov_7.068605_g9865_i0	PRJNA789095	10996	933	7.068605	65.95008465	Solemya velum gill symbiont	2340	Bacteria	Bacteria	196	1.01e-53	NR	WP_179116290.1	2340	g9865	i0	37.5	2.94533762057878	304	182	96.8	4	1	903	187	485	WP_179116290.1 ribonuclease H family protein, partial [Solemya velum gill symbiont]	diamond	2748	196	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Solemya velum gill symbiont
31737888	31737888	PRJNA789095_P_NODE_82117_length_198_cov_4.976000_g80783_i0	PRJNA789095	82117	198	4.976	9.85248	Bacteria	2	Bacteria	Bacteria	72.4	5.57e-13	NR	WP_144078572.1	2340	g80783	i0	58.5	12.8030303030303	65	27	98.5	0	3	197	158	222	WP_144078572.1 RNA-directed DNA polymerase, partial [Solemya velum gill symbiont]	diamond	2535	72.4	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Solemya velum 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);;