metadata: contig_metadata: 5 rows where bioproject = "PRJNA188516", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA188516", tax_clade = "Opisthokonta" 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
18217532	18217532	PRJNA188516_P_NODE_5575_length_164_cov_0.860870_g5525_i0	PRJNA188516	5575	164	0.86087	1.4118268	Liolophura japonica	13599	Mollusca	Mollusca	54.7	0.004	NTclustered	gi\|2724223127\|ref\|XM_064753915.1\|	13599	g5525	i0	92.105	0.231707317073171	38	3	23	0	27	64	273	236	PREDICTED: Liolophura japonica nascent polypeptide-associated complex subunit alpha-like (LOC135473952), mRNA	blastn	38	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
27105360	27105360	PRJNA188516_P_NODE_4362_length_168_cov_0.873950_g4312_i0	PRJNA188516	4362	168	0.87395	1.468236	Aplysia californica	6500	Mollusca	Mollusca	45.1	0.00198	NR	XP_005093634.1	6500	g4312	i0	46.3	0.964285714285714	54	26	96.4	1	1	162	65	115	XP_005093634.1 CD82 antigen [Aplysia californica]	diamond	162	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
27263693	27263693	PRJNA188516_P_NODE_5603_length_163_cov_1.368421_g5553_i0	PRJNA188516	5603	163	1.368421	2.23052623	Mya arenaria	6604	Mollusca	Mollusca	66.2	2.02e-12	NR	XP_052777321.1	6604	g5553	i0	77.5	2.20858895705521	40	9	73.6	0	161	42	52	91	XP_052777321.1 probable 60S ribosomal protein L37-A [Mya arenaria]	diamond	360	66.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
29965434	29965434	PRJNA188516_P_NODE_3651_length_177_cov_1.484375_g3601_i0	PRJNA188516	3651	177	1.484375	2.62734375	Metazoa	33208	Mollusca	Mollusca	43.5	0.00675	NR	CAC5372532.1	42192	g3601	i0	39.5	3.15254237288136	43	26	72.9	0	173	45	23	65	CAC5372532.1 unnamed protein product [Mytilus coruscus]	diamond	558	43.9	0.990888382687927	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
32051613	32051613	PRJNA188516_P_NODE_4458_length_168_cov_0.873950_g4408_i0	PRJNA188516	4458	168	0.87395	1.468236	Metazoa	33208	Mollusca	Mollusca	72.4	2.07e-14	NR	KAK6192495.1	87958	g4408	i0	64.2	8.42857142857143	53	19	94.6	0	7	165	12	64	KAK6192495.1 hypothetical protein SNE40_003950 [Patella caerulea]	diamond	1416	72.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella caerulea

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