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

5 rows where bioproject = "PRJNA640143", 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
11358857	11358857	PRJNA640143_S_NODE_23569_length_181_cov_17.479167_g23359_i0	PRJNA640143	23569	181	17.479167	31.63729227	Metazoa	33208	Mollusca	Mollusca	124	3.2099999999999994e-24	NTclustered	gi\|2428833149\|gb\|ON840106.1\|	387446	g23359	i0	88.462	48.4806629834254	104	10	57	2	46	148	8817	8715	Lambis lambis voucher LESGBCT-SY001 mitochondrion, complete genome	blastn	8775	124	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Strombidae	Lambis	Lambis lambis
24836288	24836288	PRJNA640143_S_NODE_25660_length_174_cov_2.299270_g25450_i0	PRJNA640143	25660	174	2.29927	4.0007298	Gigantopelta aegis	1735272	Mollusca	Mollusca	52.8	0.015	NTclustered	gi\|2034321162\|ref\|XM_041502455.1\|	1735272	g25450	i0	100	0.804597701149425	28	0	16	0	4	31	10936	10963	PREDICTED: Gigantopelta aegis neurobeachin-like (LOC121375173), transcript variant X3, mRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
30017927	30017927	PRJNA640143_S_NODE_13291_length_238_cov_5.701493_g13081_i0	PRJNA640143	13291	238	5.701493	13.56955334	Bulinus truncatus	55810	Mollusca	Mollusca	95.5	2.16e-22	NR	KAH9515110.1	55810	g13081	i0	73.8	2.45798319327731	65	17	81.9	0	196	2	64	128	KAH9515110.1 60S ribosomal protein L23A [Bulinus truncatus]	diamond	585	95.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Bulinus	Bulinus truncatus
31230747	31230747	PRJNA640143_S_NODE_28855_length_162_cov_1.672000_g28645_i0	PRJNA640143	28855	162	1.672	2.70864	Mollusca	6447	Mollusca	Mollusca	62.8	8.66e-10	NR	Q93134.1	6526	g28645	i0	86.7	11.1296296296296	30	4	55.6	0	103	14	283	312	Q93134.1 RecName: Full=Small ribosomal subunit protein RACK1; AltName: Full=Guanine nucleotide-binding protein subunit beta-2-like 1; AltName: Full=Receptor of activated protein kinase C; Short=RACK [Biomphalaria glabrata]	diamond	1803	63.2	0.993670886075949	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
31281624	31281624	PRJNA640143_S_NODE_21935_length_188_cov_1.801325_g21725_i0	PRJNA640143	21935	188	1.801325	3.386491	Haliotis rufescens	6454	Mollusca	Mollusca	49.7	6.43e-5	NR	XP_046359210.2	6454	g21725	i0	46	1.56382978723404	50	27	79.8	0	188	39	666	715	XP_046359210.2 ankyrin-3-like isoform X1 [Haliotis rufescens]	diamond	294	49.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens

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