metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA610520" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA610520" 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
6966785	6966785	PRJNA610520_S_NODE_48066_length_276_cov_2.418719_g47976_i0	PRJNA610520	48066	276	2.418719	6.67566444	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	122	1.08e-31	NR	XP_064610936.1	13599	g47976	i0	76.6	11.8152173913043	77	17	82.6	1	276	49	219	295	XP_064610936.1 copine family protein 1-like isoform X2 [Liolophura japonica]	diamond	3261	122	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
28564491	28564491	PRJNA610520_S_NODE_6027_length_466_cov_11.236641_g5939_i0	PRJNA610520	6027	466	11.236641	52.36274706	Mytilus californianus	6549	Mollusca	Mollusca	98.6	4.89e-23	NR	XP_052105361.1	6549	g5939	i0	39.7	1.30042918454936	121	65	72.7	2	457	119	17	137	XP_052105361.1 LITAF domain-containing protein-like [Mytilus californianus]	diamond	606	98.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
29209205	29209205	PRJNA610520_S_NODE_51849_length_268_cov_3.158974_g51759_i0	PRJNA610520	51849	268	3.158974	8.46605032	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	116	2.19e-29	NR	XP_064610936.1	13599	g51759	i0	72	6.78358208955224	75	20	82.8	1	266	45	221	295	XP_064610936.1 copine family protein 1-like isoform X2 [Liolophura japonica]	diamond	1818	116	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
29840544	29840544	PRJNA610520_S_NODE_35151_length_308_cov_1.638298_g35061_i0	PRJNA610520	35151	308	1.638298	5.04595784	Metazoa	33208	Mollusca	Mollusca	102	1.36e-24	NR	WAR00835.1	6604	g35061	i0	67.1	2.23051948051948	76	25	74	0	286	59	120	195	WAR00835.1 COMD5-like protein [Mya arenaria]	diamond	687	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
30933296	30933296	PRJNA610520_S_NODE_49594_length_273_cov_1.845000_g49504_i0	PRJNA610520	49594	273	1.845	5.03685	Argopecten irradians	31199	Mollusca	Mollusca	61.2	4.34e-9	NR	XP_069119487.1	31199	g49504	i0	43.8	0.703296703296703	64	34	70.3	1	272	81	126	187	XP_069119487.1 apolipoprotein D-like [Argopecten irradians]	diamond	192	61.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
31217189	31217189	PRJNA610520_S_NODE_43215_length_287_cov_2.158879_g43125_i0	PRJNA610520	43215	287	2.158879	6.19598273	Mytilus californianus	6549	Mollusca	Mollusca	80.9	1.47e-16	NR	XP_052092394.1	6549	g43125	i0	53.2	3.25087108013937	79	31	76.3	1	281	63	108	186	XP_052092394.1 ras-related protein Rap-1b [Mytilus californianus]	diamond	933	80.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
31597401	31597401	PRJNA610520_S_NODE_57876_length_256_cov_4.633880_g57786_i0	PRJNA610520	57876	256	4.6338800000000004	11.8627328	Aplysia californica	6500	Mollusca	Mollusca	82.4	2.44e-16	NR	XP_012936671.1	6500	g57786	i0	52.2	0.80859375	69	33	80.9	0	5	211	271	339	XP_012936671.1 UPF0046 protein K07C11.7 isoform X2 [Aplysia californica]	diamond	207	82.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
32892612	32892612	PRJNA610520_S_NODE_70460_length_235_cov_2.376543_g70370_i0	PRJNA610520	70460	235	2.376543	5.58487605	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	70.9	3.46e-12	NR	XP_021358516.1	6573	g70370	i0	66.7	3.07659574468085	48	16	61.3	0	1	144	314	361	XP_021358516.1 isocitrate dehydrogenase [NAD] subunit alpha, mitochondrial-like [Mizuhopecten yessoensis]	diamond	723	70.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis

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