metadata: contig_metadata: 7 rows where bioproject = "PRJNA1103784", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA1103784", 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
24438060	24438060	PRJNA1103784_P_NODE_6040_length_249_cov_0.875000_g5985_i0	PRJNA1103784	6040	249	0.875	2.17875	Potamilus streckersoni	2493646	Mollusca	Mollusca	124	9.969999999999999e-35	NR	KAK3592046.1	2493646	g5985	i0	69.4	4.63855421686747	85	23	98.8	1	247	2	3	87	KAK3592046.1 hypothetical protein CHS0354_019301 [Potamilus streckersoni]	diamond	1155	124	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
26678921	26678921	PRJNA1103784_P_NODE_6041_length_249_cov_0.875000_g5986_i0	PRJNA1103784	6041	249	0.875	2.17875	Metazoa	33208	Mollusca	Mollusca	93.2	6.51e-20	NR	XP_062598428.1	36930	g5986	i0	53.2	7.56626506024096	77	36	92.8	0	231	1	172	248	XP_062598428.1 transmembrane protein 184C-like [Saccostrea cuccullata]	diamond	1884	94	0.991489361702128	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
26932447	26932447	PRJNA1103784_P_NODE_6602_length_246_cov_2.225434_g6547_i0	PRJNA1103784	6602	246	2.225434	5.47456764	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	47	0.00123	NR	XP_052810381.1	6604	g6547	i0	38.6	4.23170731707317	70	39	85.4	1	236	27	824	889	XP_052810381.1 staphylococcal nuclease domain-containing protein 1-like [Mya arenaria]	diamond	1041	47.4	0.991561181434599	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
29395822	29395822	PRJNA1103784_P_NODE_5949_length_250_cov_0.870056_g5894_i0	PRJNA1103784	5949	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.1	1.76e-6	NR	XP_071132249.1	6550	g5894	i0	66.7	3.78	33	11	39.6	0	99	1	5	37	XP_071132249.1 arf-GAP with dual PH domain-containing protein 1-like isoform X8 [Mytilus edulis]	diamond	945	55.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
29427137	29427137	PRJNA1103784_P_NODE_6989_length_245_cov_0.895349_g6934_i0	PRJNA1103784	6989	245	0.895349	2.19360505	Metazoa	33208	Mollusca	Mollusca	84	5.36e-17	NR	XP_012938905.1	6500	g6934	i0	46.8	4.54285714285714	77	39	91.8	1	225	1	227	303	XP_012938905.1 cathepsin B [Aplysia californica]	diamond	1113	84	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
29625049	29625049	PRJNA1103784_P_NODE_4290_length_276_cov_1.517241_g4235_i0	PRJNA1103784	4290	276	1.517241	4.18758516	Bulinus truncatus	55810	Mollusca	Mollusca	67.8	3.81e-11	NR	KAH9503697.1	55810	g4235	i0	43.6	3.06521739130435	94	50	98.9	1	273	1	41	134	KAH9503697.1 60S ribosomal protein L10A [Bulinus truncatus]	diamond	846	67.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Bulinus	Bulinus truncatus
32272127	32272127	PRJNA1103784_P_NODE_698_length_578_cov_5.691089_g644_i0	PRJNA1103784	698	578	5.691089	32.89449442	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	234	1.72e-73	NR	XP_064606932.1	13599	g644	i0	63.5	12.0934256055363	189	60	98.1	2	3	569	58	237	XP_064606932.1 small ribosomal subunit protein uS2-like [Liolophura japonica]	diamond	6990	236	0.991525423728814	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica

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