metadata: contig_metadata: 9 rows where bioproject = "PRJNA1046144", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA1046144", 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
1446570	1446570	PRJNA1046144_P_NODE_17382_length_388_cov_4.241379_g17087_i0	PRJNA1046144	17382	388	4.241379	16.45655052	Dreissena polymorpha	45954	Mollusca	Mollusca	54.7	0.01	NTclustered	gi\|2364497457\|ref\|XM_052362702.1\|	45954	g17087	i0	94.444	0.265463917525773	36	0	9	1	155	188	225	190	PREDICTED: Dreissena polymorpha uncharacterized LOC127836222 (LOC127836222), mRNA	blastn	103	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
2722264	2722264	PRJNA1046144_P_NODE_13803_length_431_cov_3.820442_g13508_i0	PRJNA1046144	13803	431	3.820442	16.46610502	Dreissena polymorpha	45954	Mollusca	Mollusca	52.8	0.042	NTclustered	gi\|2364297603\|ref\|XM_052404870.1\|	45954	g13508	i0	100	0.0649651972157773	28	0	6	0	142	169	4553	4526	PREDICTED: Dreissena polymorpha FMRFamide receptor-like (LOC127865016), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
6549986	6549986	PRJNA1046144_P_NODE_19746_length_366_cov_2.767677_g19451_i0	PRJNA1046144	19746	366	2.767677	10.12969782	Liolophura japonica	13599	Mollusca	Mollusca	161	5.529999999999998e-35	NTclustered	gi\|2724250457\|ref\|XM_064750877.1\|	13599	g19451	i0	82.703	3.10655737704918	185	28	50	4	5	187	228	46	PREDICTED: Liolophura japonica U6 snRNA-associated Sm-like protein LSm3 (LOC135471590), mRNA	blastn	1137	161	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
6550304	6550304	PRJNA1046144_P_NODE_38286_length_276_cov_2.845411_g37991_i0	PRJNA1046144	38286	276	2.845411	7.85333436	Bradybaena similaris	145626	Mollusca	Mollusca	60.2	1.52e-4	NTclustered	gi\|2912986657\|dbj\|AP039591.1\|	145626	g37991	i0	100	0.626811594202899	32	0	12	0	65	96	76841313	76841282	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence	blastn	173	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11650429	11650429	PRJNA1046144_P_NODE_18750_length_375_cov_2.267974_g18455_i0	PRJNA1046144	18750	375	2.267974	8.5049025	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.036	NTclustered	gi\|2912994531\|dbj\|AP039599.1\|	145626	g18455	i0	100	0.0746666666666667	28	0	7	0	310	337	53406159	53406132	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15475127	15475127	PRJNA1046144_P_NODE_4013_length_775_cov_7.790368_g3762_i0	PRJNA1046144	4013	775	7.790368	60.375352	Ostrea edulis	37623	Mollusca	Mollusca	571	4.819999999999998e-158	NTclustered	gi\|2507395507\|ref\|XM_048877989.2\|	37623	g3762	i0	83.307	158.841290322581	623	100	81	3	10	630	1705	1085	PREDICTED: Ostrea edulis polyubiquitin-C (LOC125650051), mRNA	blastn	123102	571	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
28701133	28701133	PRJNA1046144_P_NODE_48887_length_250_cov_1.585635_g48592_i0	PRJNA1046144	48887	250	1.585635	3.9640875	Metazoa	33208	Mollusca	Mollusca	54.7	2.4e-6	NR	XP_048253896.1	6454	g48592	i0	42.9	4.908	63	34	73.2	1	250	68	287	349	XP_048253896.1 histone-lysine N-methyltransferase SETMAR-like [Haliotis rufescens]	diamond	1227	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
29111597	29111597	PRJNA1046144_P_NODE_56988_length_234_cov_3.175758_g56693_i0	PRJNA1046144	56988	234	3.175758	7.43127372	Metazoa	33208	Mollusca	Mollusca	141	1.7e-37	NR	XP_022293018.1	6565	g56693	i0	83.1	8.87179487179487	77	13	98.7	0	233	3	228	304	XP_022293018.1 importin subunit alpha-7-like isoform X2 [Crassostrea virginica]	diamond	2076	142	0.992957746478873	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30090236	30090236	PRJNA1046144_P_NODE_58052_length_234_cov_0.872727_g57757_i0	PRJNA1046144	58052	234	0.872727	2.04218118	Metazoa	33208	Mollusca	Mollusca	42.4	0.0456	NR	XP_045183462.2	6596	g57757	i0	31.1	1.46153846153846	61	41	76.9	1	19	198	155	215	XP_045183462.2 uncharacterized protein F54H12.2-like [Mercenaria mercenaria]	diamond	342	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria

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