metadata: contig_metadata: 8 rows where bioproject = "PRJNA358490", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA358490", 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
3623915	3623915	PRJNA358490_P_NODE_4203_length_688_cov_5.354391_g3963_i0	PRJNA358490	4203	688	5.354391	36.83821008	Magallana	147004	Mollusca	Mollusca	1197	0	NTclustered	gi\|2751238176\|ref\|XM_011423421.4\|	29159	g3963	i0	99.246	43.1787790697674	663	5	96	0	22	684	241	903	PREDICTED: Magallana gigas small ribosomal subunit protein eS1 (LOC105324356), mRNA	blastn	29707	1197	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
5502549	5502549	PRJNA358490_P_NODE_12345_length_239_cov_2.220000_g12001_i0	PRJNA358490	12345	239	2.22	5.3058	Arion vulgaris	1028688	Mollusca	Mollusca	392	1.11e-104	NTclustered	gi\|1819290676\|ref\|NC_046044.1\|	1028688	g12001	i0	99.087	18.0753138075314	219	1	92	1	1	219	2126	1909	Arion vulgaris mitochondrion, complete genome	blastn	4320	392	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Arionidae	Arion	Arion vulgaris
5502687	5502687	PRJNA358490_P_NODE_5865_length_554_cov_4.170874_g5552_i0	PRJNA358490	5865	554	4.170874	23.10664196	Arion vulgaris	1028688	Mollusca	Mollusca	944	0	NTclustered	gi\|1819290676\|ref\|NC_046044.1\|	1028688	g5552	i0	98.51	76.6552346570397	537	4	96	3	22	554	2057	2593	Arion vulgaris mitochondrion, complete genome	blastn	42467	944	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Arionidae	Arion	Arion vulgaris
18250645	18250645	PRJNA358490_P_NODE_17415_length_157_cov_1.500000_g17071_i0	PRJNA358490	17415	157	1.5	2.355	Bradybaena similaris	145626	Mollusca	Mollusca	100	4.56e-17	NTclustered	gi\|2912984370\|dbj\|AP039589.1\|	145626	g17071	i0	80.952	7.43949044585987	126	24	80	0	1	126	74259755	74259630	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence	blastn	1168	100	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23351078	23351078	PRJNA358490_P_NODE_7599_length_455_cov_2.420673_g7260_i0	PRJNA358490	7599	455	2.420673	11.01406215	Cornu aspersum	6535	Mollusca	Mollusca	819	0	NTclustered	gi\|38489863\|gb\|AY345052.1\|	6535	g7260	i0	99.121	81.3450549450549	455	4	100	0	1	455	2482	2028	Helix aspersa cytochrome c oxidase subunit I gene, partial cds; tRNA-Val, large subunit ribosomal RNA, tRNA-Leu, and tRNA-Ala genes, complete sequence; NADH dehydrogenase subunit 6 gene, complete cds; tRNA-Pro gene, complete sequence; and NADH dehydrogenase subunit 5 gene, partial cds; mitochondrial	blastn	37012	819	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Helicidae	Cornu	Cornu aspersum
24024970	24024970	PRJNA358490_P_NODE_3719_length_741_cov_4.509972_g3494_i0	PRJNA358490	3719	741	4.509972	33.41889252	Metazoa	33208	Mollusca	Mollusca	490	1.3299999999999996e-133	NTclustered	gi\|2442010545\|ref\|XM_045347654.2\|	6596	g3494	i0	81.757	82.8744939271255	592	102	79	6	125	713	1218	630	PREDICTED: Mercenaria mercenaria actin, adductor muscle (LOC123556721), mRNA	blastn	61410	490	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
28022563	28022563	PRJNA358490_P_NODE_10945_length_289_cov_3.280000_g10603_i0	PRJNA358490	10945	289	3.28	9.4792	Mytilus coruscus	42192	Mollusca	Mollusca	71.6	1.34e-12	NR	CAC5378609.1	42192	g10603	i0	37.2	1.99307958477509	94	55	93.4	2	287	18	146	239	CAC5378609.1 Glycine receptor subunit beta,Glycine receptor subunit alpha-4,Glycine receptor subunit alpha-2,Glycine receptor subunit alpha-1 [Mytilus coruscus]	diamond	576	71.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
31054612	31054612	PRJNA358490_P_NODE_2915_length_839_cov_13.617500_g2715_i0	PRJNA358490	2915	839	13.6175	114.250825	Aplysia californica	6500	Mollusca	Mollusca	72.8	2.53e-10	NR	XP_005096259.1	6500	g2715	i0	35	0.643623361144219	180	101	59.4	4	818	321	576	753	XP_005096259.1 protein DD3-3 [Aplysia californica]	diamond	540	72.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica

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