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

5 rows where analysis = "diamond", bioproject = "PRJNA287283" 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
26648434	26648434	PRJNA287283_P_NODE_4901_length_274_cov_1.013575_g4677_i0	PRJNA287283	4901	274	1.013575	2.7771955	Mollusca	6447	Mollusca	Mollusca	105	4.99e-25	NR	XP_046355238.1	6454	g4677	i0	50.6	3.77737226277372	87	43	95.3	0	11	271	40	126	XP_046355238.1 methionine adenosyltransferase 2 subunit beta-like [Haliotis rufescens]	diamond	1035	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
26933597	26933597	PRJNA287283_P_NODE_9482_length_179_cov_0.888889_g9258_i0	PRJNA287283	9482	179	0.888889	1.59111131	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.8	6.41e-9	NR	XP_060076727.1	509963	g9258	i0	48.6	11.0446927374302	70	24	97.2	3	177	4	494	563	XP_060076727.1 thrombospondin type-1 domain-containing protein 4-like [Ylistrum balloti]	diamond	1977	61.2	0.993464052287582	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Ylistrum	Ylistrum balloti
26996735	26996735	PRJNA287283_P_NODE_9522_length_178_cov_1.848000_g9298_i0	PRJNA287283	9522	178	1.848	3.28944	Metazoa	33208	Mollusca	Mollusca	124	1.56e-32	NR	OWF38784.1	6573	g9298	i0	98.3	204.269662921348	58	1	97.8	0	175	2	217	274	OWF38784.1 Serine/threonine-protein phosphatase PP1-gamma catalytic subunit [Mizuhopecten yessoensis]	diamond	36360	125	0.992	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
27660629	27660629	PRJNA287283_P_NODE_2964_length_374_cov_2.140187_g2740_i0	PRJNA287283	2964	374	2.140187	8.00429938	Mollusca	6447	Mollusca	Mollusca	116	2.9800000000000003e-27	NR	KAK0060573.1	112525	g2740	i0	51.4	8.42245989304813	111	49	86.6	2	324	1	621	729	KAK0060573.1 tyramine beta-hydroxylase [Biomphalaria pfeifferi]	diamond	3150	117	0.991452991452991	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria pfeifferi
30628690	30628690	PRJNA287283_P_NODE_4033_length_314_cov_0.858238_g3809_i0	PRJNA287283	4033	314	0.858238	2.69486732	Opisthokonta	33154	Mollusca	Mollusca	81.6	1.69e-15	NR	KAJ8301522.1	220873	g3809	i0	44.9	4.32802547770701	98	53	92.7	1	11	301	251	348	KAJ8301522.1 hypothetical protein KUTeg_020509 [Tegillarca granosa]	diamond	1359	81.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa

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