metadata: contig_metadata: 5 rows where bioproject = "PRJNA1233317", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA1233317", tax_kingdom = "Metazoa" 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
1610269	1610269	PRJNA1233317_S_NODE_2102_length_388_cov_4.130699_g2066_i0	PRJNA1233317	2102	388	4.130699	16.02711212	Haliotis rubra	36100	Mollusca	Mollusca	100	1.31e-16	NTclustered	gi\|2194125487\|ref\|XM_046718739.1\|	36100	g2066	i0	95.312	16.1572164948454	64	2	16	1	326	388	1397	1460	PREDICTED: Haliotis rubra farnesyl pyrophosphate synthase-like (LOC124282719), transcript variant X2, mRNA	blastn	6269	100	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
2886524	2886524	PRJNA1233317_S_NODE_15783_length_193_cov_3.126866_g15747_i0	PRJNA1233317	15783	193	3.126866	6.03485138	Mya arenaria	6604	Mollusca	Mollusca	56.5	0.001	NTclustered	gi\|2427493488\|ref\|XM_052949677.1\|	6604	g15747	i0	100	0.155440414507772	30	0	16	0	109	138	879	908	PREDICTED: Mya arenaria uncharacterized LOC128235002 (LOC128235002), mRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
6713351	6713351	PRJNA1233317_S_NODE_3246_length_354_cov_6.352542_g3210_i0	PRJNA1233317	3246	354	6.352542	22.48799868	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.033	NTclustered	gi\|2913000417\|dbj\|AP039607.1\|	145626	g3210	i0	100	0.0790960451977401	28	0	8	0	229	256	8953149	8953122	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
9263666	9263666	PRJNA1233317_S_NODE_15408_length_195_cov_7.463235_g15372_i0	PRJNA1233317	15408	195	7.463235	14.55330825	Bradybaena similaris	145626	Mollusca	Mollusca	60.2	1.01e-4	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g15372	i0	87.037	19.6769230769231	54	5	27	1	1	52	43054078	43054025	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	3837	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11814303	11814303	PRJNA1233317_S_NODE_7370_length_281_cov_6.509009_g7334_i0	PRJNA1233317	7370	281	6.509009	18.29031529	Haliotis rufescens	6454	Mollusca	Mollusca	110	5.93e-26	NR	XP_046350536.2	6454	g7334	i0	55.8	2.7864768683274	86	38	91.8	0	273	16	493	578	XP_046350536.2 uncharacterized protein LOC124131356 isoform X1 [Haliotis rufescens]	diamond	783	110	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);;