metadata: contig_metadata: 4 rows where bioproject = "PRJNA397736", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJNA397736", 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
2962893	2962893	PRJNA397736_S_NODE_883_length_304_cov_3.774545_g847_i0	PRJNA397736	883	304	3.774545	11.4746168	Planorbella duryi	129831	Mollusca	Mollusca	492	1.41e-134	NTclustered	gi\|46451271\|gb\|AY577472.1\|	129831	g847	i0	100	84.1085526315789	266	0	88	0	1	266	266	1	Helisoma duryi 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	25569	492	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Planorbella	Planorbella duryi
18263781	18263781	PRJNA397736_S_NODE_1435_length_234_cov_4.039024_g1399_i0	PRJNA397736	1435	234	4.039024	9.45131616	Planorbella duryi	129831	Mollusca	Mollusca	394	3.02e-105	NTclustered	gi\|1150882693\|gb\|KY514384.1\|	129831	g1399	i0	97.021	90.4487179487179	235	5	100	2	1	234	2297	2530	Planorbella duryi mitochondrion, complete genome	blastn	21165	394	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Planorbella	Planorbella duryi
22088653	22088653	PRJNA397736_S_NODE_558_length_389_cov_11.086111_g522_i0	PRJNA397736	558	389	11.086111	43.12497179	Physella acuta	109671	Mollusca	Mollusca	52.8	0.037	NTclustered	gi\|2572411827\|ref\|XM_059320587.1\|	109671	g522	i0	96.774	0.0796915167095116	31	1	8	0	160	190	2165	2135	PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
29428691	29428691	PRJNA397736_S_NODE_1689_length_212_cov_126.775956_g1653_i0	PRJNA397736	1689	212	126.775956	268.76502672	Metazoa	33208	Mollusca	Mollusca	107	5.6e-25	NR	XP_052805111.1	6604	g1653	i0	100	119.179245283019	52	0	73.6	0	157	2	327	378	XP_052805111.1 heat shock 70 kDa protein cognate 4 isoform X1 [Mya arenaria]	diamond	25266	107	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria

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