metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA608660" 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
26668341	26668341	PRJNA608660_P_NODE_40901_length_185_cov_1.183824_g40544_i0	PRJNA608660	40901	185	1.183824	2.1900744	Lymnaea stagnalis	6523	Mollusca	Mollusca	42.4	0.0233	NR	CAL1531800.1	6523	g40544	i0	46.3	0.664864864864865	41	19	61.6	1	62	175	137	177	CAL1531800.1 unnamed protein product, partial [Lymnaea stagnalis]	diamond	123	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
27029979	27029979	PRJNA608660_P_NODE_31582_length_226_cov_2.853107_g31226_i0	PRJNA608660	31582	226	2.853107	6.44802182	Metazoa	33208	Mollusca	Mollusca	123	3.54e-32	NR	XP_013070859.1	6526	g31226	i0	85.9	19.5663716814159	71	9	94.2	1	10	222	245	314	XP_013070859.1 casein kinase I isoform X2 [Biomphalaria glabrata]	diamond	4422	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
27409526	27409526	PRJNA608660_P_NODE_32043_length_224_cov_1.245714_g31687_i0	PRJNA608660	32043	224	1.245714	2.79039936	Mollusca	6447	Mollusca	Mollusca	47.4	6.89e-4	NR	KAL5009466.1	13268	g31687	i0	62.5	4.16517857142857	40	14	53.6	1	102	221	795	833	KAL5009466.1 hypothetical protein ScPMuIL_011771 [Solemya velum]	diamond	933	47.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
30142933	30142933	PRJNA608660_P_NODE_41932_length_181_cov_1.272727_g41575_i0	PRJNA608660	41932	181	1.272727	2.30363587	Liolophura japonica	13599	Mollusca	Mollusca	41.6	0.0424	NR	XP_064610839.1	13599	g41575	i0	40	0.828729281767956	50	26	79.6	2	19	162	111	158	XP_064610839.1 uncharacterized protein LOC135475035 [Liolophura japonica]	diamond	150	41.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
32230053	32230053	PRJNA608660_P_NODE_8498_length_512_cov_4.872570_g8163_i0	PRJNA608660	8498	512	4.87257	24.9475584	Pinctada imbricata	66713	Mollusca	Mollusca	49.7	0.00148	NR	KAK3099525.1	66713	g8163	i0	36.8	0.3984375	68	32	39.8	2	375	172	15	71	KAK3099525.1 hypothetical protein FSP39_005772 [Pinctada imbricata]	diamond	204	49.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata

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