metadata: contig_metadata: 6 rows where bioproject = "PRJNA1086823", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA1086823", 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
20143766	20143766	PRJNA1086823_P_NODE_19496_length_235_cov_2.864198_g19379_i0	PRJNA1086823	19496	235	2.864198	6.7308653	Metazoa	33208	Mollusca	Mollusca	435	1.79e-117	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g19379	i0	100	100	235	0	100	0	1	235	273	507	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	23500	435	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
27216715	27216715	PRJNA1086823_P_NODE_18962_length_242_cov_0.923077_g18845_i0	PRJNA1086823	18962	242	0.923077	2.23384634	Metazoa	33208	Mollusca	Mollusca	107	1.09e-25	NR	XP_046584242.1	36100	g18845	i0	63.6	3.63223140495868	77	27	95.5	1	235	5	76	151	XP_046584242.1 cathepsin B-like [Haliotis rubra]	diamond	879	107	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
27983462	27983462	PRJNA1086823_P_NODE_4725_length_364_cov_1.343643_g4608_i0	PRJNA1086823	4725	364	1.343643	4.89086052	Mytilus galloprovincialis	29158	Mollusca	Mollusca	94	1.64e-19	NR	VDI48492.1	29158	g4608	i0	38.7	3.06593406593407	124	68	95.6	3	17	364	457	580	VDI48492.1 Hypothetical predicted protein [Mytilus galloprovincialis]	diamond	1116	94	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
29679610	29679610	PRJNA1086823_P_NODE_2990_length_441_cov_4.350543_g2873_i0	PRJNA1086823	2990	441	4.350543	19.18589463	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	112	4.509999999999999e-28	NR	XP_052072593.1	6549	g2873	i0	49.7	5.96598639455782	147	70	99.3	3	438	1	26	169	XP_052072593.1 60S ribosomal protein L23a-like [Mytilus californianus]	diamond	2631	112	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
30289054	30289054	PRJNA1086823_P_NODE_11512_length_257_cov_2.108696_g11395_i0	PRJNA1086823	11512	257	2.108696	5.41934872	Crassostrea virginica	6565	Mollusca	Mollusca	96.3	3.71e-21	NR	XP_022332183.1	6565	g11395	i0	56.8	1.0272373540856	88	31	99.2	3	2	256	315	398	XP_022332183.1 elongation factor 1-gamma-like [Crassostrea virginica]	diamond	264	96.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
31449506	31449506	PRJNA1086823_P_NODE_9616_length_276_cov_1.536946_g9499_i0	PRJNA1086823	9616	276	1.536946	4.24197096	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	116	1.28e-29	NR	XP_065931584.1	29159	g9499	i0	62.5	28.695652173913	88	33	95.7	0	2	265	152	239	XP_065931584.1 large ribosomal subunit protein eL8 [Magallana gigas]	diamond	7920	116	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas

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