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

5 rows where analysis = "diamond", bioproject = "PRJNA498309" 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
17059914	17059914	PRJNA498309_S_NODE_53674_length_152_cov_1.982906_g51506_i0	PRJNA498309	53674	152	1.982906	3.01401712	Potamilus streckersoni	2493646	Mollusca	Mollusca	103	5.44e-24	NR	KAK3604820.1	2493646	g51506	i0	96	1.97368421052632	50	2	98.7	0	152	3	549	598	KAK3604820.1 hypothetical protein CHS0354_000482 [Potamilus streckersoni]	diamond	300	103	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
28166464	28166464	PRJNA498309_P_NODE_96625_length_202_cov_2.606061_g94476_i0	PRJNA498309	96625	202	2.606061	5.26424322	Metazoa	33208	Mollusca	Mollusca	61.2	6.51e-9	NR	XP_005109163.1	6500	g94476	i0	66.7	13.7079207920792	36	12	53.5	0	16	123	141	176	XP_005109163.1 cyclin-L1 [Aplysia californica]	diamond	2769	61.6	0.993506493506494	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
29003857	29003857	PRJNA498309_P_NODE_85968_length_232_cov_1.379487_g83819_i0	PRJNA498309	85968	232	1.379487	3.20040984	Bradybaena similaris	145626	Mollusca	Mollusca	50.4	6.19e-5	NR	BFZ13139.1	145626	g83819	i0	47.5	0.762931034482759	59	25	68.5	1	74	232	2	60	BFZ13139.1 hypothetical protein BsWGS_16177 [Bradybaena similaris]	diamond	177	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
29761049	29761049	PRJNA498309_P_NODE_99451_length_195_cov_2.449367_g97302_i0	PRJNA498309	99451	195	2.449367	4.77626565	Elysia marginata	1093978	Mollusca	Mollusca	42.4	0.0274	NR	GFR89747.1	1093978	g97302	i0	53.6	0.430769230769231	28	13	43.1	0	72	155	806	833	GFR89747.1 polycystic kidney disease protein 1-like 2 [Elysia marginata]	diamond	84	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
32889453	32889453	PRJNA498309_P_NODE_39820_length_438_cov_19.543641_g37715_i0	PRJNA498309	39820	438	19.543641	85.60114758	Candidula unifasciata	100452	Mollusca	Mollusca	115	8.530000000000001e-27	NR	CAG5134995.1	100452	g37715	i0	41.7	1.87671232876712	132	76	89.7	1	396	4	218	349	CAG5134995.1 unnamed protein product [Candidula unifasciata]	diamond	822	115	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata

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