metadata: contig_metadata: 4 rows where bioproject = "PRJNA846086" and tax

4 rows where bioproject = "PRJNA846086" and tax_phylum = "Mollusca"

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
16135536	16135536	PRJNA846086_P_NODE_1153_length_345_cov_1.698529_g1087_i0	PRJNA846086	1153	345	1.698529	5.85992505	Scabrotrophon scitulus	3038943	Mollusca	Mollusca	108	6.87e-19	NTclustered	gi\|2478459912\|gb\|OQ780419.1\|	3038943	g1087	i0	85.586	19.7710144927536	111	7	32	6	186	295	2796	2898	Scabrotrophon scitulus isolate Haima24 large subunit ribosomal RNA gene, partial sequence	blastn	6821	108	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Muricidae	Scabrotrophon	Scabrotrophon scitulus
20357571	20357571	PRJNA846086_P_NODE_4376_length_246_cov_0.890173_g4310_i0	PRJNA846086	4376	246	0.890173	2.18982558	Metazoa	33208	Mollusca	Mollusca	455	1.4500000000000002e-123	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g4310	i0	100	100	246	0	100	0	1	246	537	782	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	24600	455	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
30307993	30307993	PRJNA846086_P_NODE_2972_length_252_cov_1.575419_g2906_i0	PRJNA846086	2972	252	1.575419	3.97005588	Plakobranchus ocellatus	259542	Mollusca	Mollusca	64.3	1.79e-11	NR	GFO30817.1	259542	g2906	i0	47.1	0.833333333333333	70	35	83.3	1	250	41	4	71	GFO30817.1 Copper transport protein [Plakobranchus ocellatus]	diamond	210	64.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
31824598	31824598	PRJNA846086_P_NODE_1817_length_287_cov_1.439252_g1751_i0	PRJNA846086	1817	287	1.439252	4.13065324	Ruditapes philippinarum	129788	Mollusca	Mollusca	120	7.04e-30	NR	XP_060564635.1	129788	g1751	i0	58.2	1.90243902439024	91	38	95.1	0	14	286	121	211	XP_060564635.1 alkylglycerol monooxygenase-like [Ruditapes philippinarum]	diamond	546	120	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum

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