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

8 rows where bioproject = "PRJNA1218816", 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
15073825	15073825	PRJNA1218816_P_NODE_17452_length_543_cov_3.602128_g17023_i0	PRJNA1218816	17452	543	3.602128	19.55955504	Metazoa	33208	Mollusca	Mollusca	998	0	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g17023	i0	99.816	99.9042357274402	543	1	100	0	1	543	772	230	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	54248	1003	0.995014955134596	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
28070580	28070580	PRJNA1218816_P_NODE_48585_length_269_cov_1.408163_g48152_i0	PRJNA1218816	48585	269	1.408163	3.78795847	Metazoa	33208	Mollusca	Mollusca	94.7	2.7e-20	NR	XP_050404218.1	6465	g48152	i0	73.2	6.45724907063197	71	19	79.2	0	57	269	420	490	XP_050404218.1 annexin A6 isoform X2 [Patella vulgata]	diamond	1737	95.5	0.991623036649215	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
28607360	28607360	PRJNA1218816_P_NODE_51887_length_257_cov_1.576087_g51454_i0	PRJNA1218816	51887	257	1.576087	4.05054359	Metazoa	33208	Mollusca	Mollusca	109	3.01e-26	NR	XP_052833593.1	37653	g51454	i0	57.6	4.96108949416342	85	36	99.2	0	255	1	270	354	XP_052833593.1 CYFIP-related Rac1 interactor B isoform X1 [Octopus bimaculoides]	diamond	1275	109	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
29125646	29125646	PRJNA1218816_P_NODE_54069_length_251_cov_0.865169_g53636_i0	PRJNA1218816	54069	251	0.865169	2.17157419	Physella acuta	109671	Mollusca	Mollusca	82	6.14e-16	NR	XP_059174324.1	109671	g53636	i0	53.2	3.71713147410359	79	35	92	1	4	234	294	372	XP_059174324.1 protein kintoun-like [Physella acuta]	diamond	933	82	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
30186186	30186186	PRJNA1218816_P_NODE_62952_length_241_cov_0.916667_g62519_i0	PRJNA1218816	62952	241	0.916667	2.20916747	Biomphalaria	6525	Mollusca	Mollusca	65.1	5.03e-10	NR	XP_055863065.1	6526	g62519	i0	39	3.06224066390041	82	47	98.3	1	5	241	592	673	XP_055863065.1 myoferlin-like isoform X1 [Biomphalaria glabrata]	diamond	738	65.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
30989103	30989103	PRJNA1218816_P_NODE_56534_length_248_cov_0.880000_g56101_i0	PRJNA1218816	56534	248	0.88	2.1824	Liolophura japonica	13599	Mollusca	Mollusca	80.1	2.81e-15	NR	XP_064604938.1	13599	g56101	i0	43.2	2.93951612903226	81	45	98	1	3	245	661	740	XP_064604938.1 LOW QUALITY PROTEIN: WASH complex subunit 4-like [Liolophura japonica]	diamond	729	80.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
32222463	32222463	PRJNA1218816_P_NODE_57298_length_247_cov_0.885057_g56865_i0	PRJNA1218816	57298	247	0.885057	2.18609079	Magallana angulata	2784310	Mollusca	Mollusca	48.5	3.58e-4	NR	XP_052713675.1	2784310	g56865	i0	44	2.50202429149798	50	28	60.7	0	63	212	1340	1389	XP_052713675.1 nitric oxide synthase, salivary gland-like isoform X2 [Magallana angulata]	diamond	618	48.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana angulata
32746640	32746640	PRJNA1218816_P_NODE_43420_length_290_cov_1.230415_g42987_i0	PRJNA1218816	43420	290	1.230415	3.5682035	root	1	Root_unresolved	Root_unresolved	80.1	5.48e-17	NR	XP_012942786.1	6500	g42987	i0	45.7	2.92758620689655	94	49	97.2	1	8	289	9	100	XP_012942786.1 AAC-rich mRNA clone AAC4 protein [Aplysia californica]	diamond	849	80.1	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);;