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

5 rows where bioproject = "PRJNA881257", 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
4687002	4687002	PRJNA881257_P_NODE_3644_length_425_cov_0.978723_g3401_i0	PRJNA881257	3644	425	0.978723	4.15957275	Saccostrea cuccullata	36930	Mollusca	Mollusca	52.8	0.041	NTclustered	gi\|2669156586\|ref\|XM_062755599.1\|	36930	g3401	i0	100	0.0658823529411765	28	0	7	0	386	413	1393	1420	PREDICTED: Saccostrea cucullata MFS-type transporter SLC18B1-like (LOC134273402), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
5961858	5961858	PRJNA881257_P_NODE_4065_length_395_cov_5.606936_g3821_i0	PRJNA881257	4065	395	5.606936	22.1473972	Ruditapes philippinarum	129788	Mollusca	Mollusca	52.8	0.038	NTclustered	gi\|2616658881\|ref\|XM_060747556.1\|	129788	g3821	i0	100	0.0708860759493671	28	0	7	0	208	235	272	245	PREDICTED: Ruditapes philippinarum heat shock 70 kDa protein 12B-like (LOC132756477), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
14886620	14886620	PRJNA881257_P_NODE_5652_length_313_cov_2.553030_g5408_i0	PRJNA881257	5652	313	2.55303	7.9909839	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.029	NTclustered	gi\|2913000417\|dbj\|AP039607.1\|	145626	g5408	i0	100	0.0894568690095847	28	0	9	0	139	166	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
22535311	22535311	PRJNA881257_P_NODE_2678_length_515_cov_1.871245_g2439_i0	PRJNA881257	2678	515	1.871245	9.63691175	Magallana gigas	29159	Mollusca	Mollusca	56.5	0.004	NTclustered	gi\|2751260125\|ref\|XM_066080886.1\|	29159	g2439	i0	94.595	0.0718446601941748	37	1	7	1	275	311	827	792	PREDICTED: Magallana gigas receptor-type tyrosine-protein phosphatase zeta-like (LOC136274339), transcript variant X2, mRNA	blastn	37	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
27055424	27055424	PRJNA881257_P_NODE_14062_length_169_cov_2.016667_g13817_i0	PRJNA881257	14062	169	2.016667	3.40816723	Littorina saxatilis	31220	Mollusca	Mollusca	41.2	0.0494	NR	XP_070176500.1	31220	g13817	i0	39.5	0.763313609467456	43	26	76.3	0	41	169	505	547	XP_070176500.1 uncharacterized protein [Littorina saxatilis]	diamond	129	41.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis

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