metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax

3 rows where analysis = "diamond", bioproject = "PRJNA546018" 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
27299233	27299233	PRJNA546018_S_NODE_24803_length_320_cov_3.054054_g24478_i0	PRJNA546018	24803	320	3.054054	9.7729728	Mytilus edulis	6550	Mollusca	Mollusca	48.1	0.00109	NR	CAG2204155.1	6550	g24478	i0	27	1.040625	111	71	94.7	2	320	18	121	231	CAG2204155.1 unnamed protein product [Mytilus edulis]	diamond	333	48.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
27661565	27661565	PRJNA546018_S_NODE_39704_length_244_cov_2.420765_g39379_i0	PRJNA546018	39704	244	2.420765	5.9066666	Mytilus	6548	Mollusca	Mollusca	44.3	0.0104	NR	CAG2218763.1	6550	g39379	i0	35.5	3.73770491803279	76	37	88.5	3	16	231	206	273	CAG2218763.1 Tenascin-R,Angiopoietin-related protein 1,Ryncolin-1,Fibrinogen C domain-containing protein 1-A,Fibrinogen C domain-containing protein 1,Fibrinogen C domain-containing protein 1-B,Angiopoietin-2,Fibroleukin,Fibrinogen-like protein 1,Ficolin-2,Tenascin,Ficolin-1,Fibrinogen-like protein A,Microfibril-associated glycoprotein 4,Angiopoietin-related protein 7,Ryncolin-4 [Mytilus edulis]	diamond	912	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
30472022	30472022	PRJNA546018_S_NODE_1853_length_1361_cov_9.640000_g1707_i0	PRJNA546018	1853	1361	9.64	131.2004	Opisthokonta	33154	Mollusca	Mollusca	118	3.2200000000000004e-27	NR	XP_053393133.1	6596	g1707	i0	37	5.76193975018369	184	82	38.8	4	629	1156	1	158	XP_053393133.1 ras-related protein Rac1-like isoform X2 [Mercenaria mercenaria]	diamond	7842	119	0.991596638655462	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria

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