metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1247234" 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
27122978	27122978	PRJNA1247234_P_NODE_25562_length_245_cov_0.906977_g25406_i0	PRJNA1247234	25562	245	0.906977	2.22209365	Metazoa	33208	Mollusca	Mollusca	90.9	4.4e-19	NR	XP_005107775.1	6500	g25406	i0	100	159.183673469388	40	0	49	0	3	122	473	512	XP_005107775.1 membrane-bound transcription factor site-1 protease [Aplysia californica]	diamond	39000	90.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
27786808	27786808	PRJNA1247234_P_NODE_21984_length_250_cov_1.762712_g21828_i0	PRJNA1247234	21984	250	1.762712	4.40678	Metazoa	33208	Mollusca	Mollusca	94	3.73e-20	NR	XP_060606781.1	129788	g21828	i0	51.2	8.748	84	39	98.4	1	3	248	267	350	XP_060606781.1 uncharacterized protein LOC132759074 [Ruditapes philippinarum]	diamond	2187	94.7	0.992608236536431	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
28526512	28526512	PRJNA1247234_P_NODE_14267_length_296_cov_1.399103_g14111_i0	PRJNA1247234	14267	296	1.399103	4.14134488	Sinanodonta woodiana	1069815	Mollusca	Mollusca	51.2	7.02e-5	NR	KAL3891136.1	1069815	g14111	i0	61.3	1.86486486486486	31	12	31.4	0	295	203	6	36	KAL3891136.1 hypothetical protein ACJMK2_003399 [Sinanodonta woodiana]	diamond	552	51.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Sinanodonta	Sinanodonta woodiana
29144641	29144641	PRJNA1247234_P_NODE_25929_length_245_cov_0.906977_g25773_i0	PRJNA1247234	25929	245	0.906977	2.22209365	Opisthokonta	33154	Mollusca	Mollusca	107	2.29e-26	NR	XP_052089784.1	6549	g25773	i0	73.8	10.3469387755102	65	17	79.6	0	245	51	114	178	XP_052089784.1 diphthine methyl ester synthase-like [Mytilus californianus]	diamond	2535	108	0.990740740740741	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
29680738	29680738	PRJNA1247234_P_NODE_7430_length_384_cov_3.508039_g7274_i0	PRJNA1247234	7430	384	3.508039	13.47086976	Metazoa	33208	Mollusca	Mollusca	84.3	2.94e-17	NR	XP_052231030.1	45954	g7274	i0	38.9	7.9453125	126	74	98.4	2	383	6	33	155	XP_052231030.1 probable glutathione S-transferase 7 [Dreissena polymorpha]	diamond	3051	84.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
29915791	29915791	PRJNA1247234_P_NODE_5131_length_448_cov_1.114667_g4977_i0	PRJNA1247234	5131	448	1.114667	4.99370816	Saccostrea echinata	191078	Mollusca	Mollusca	105	3.11e-23	NR	XP_061176776.1	191078	g4977	i0	55.2	2.16294642857143	105	46	70.3	1	1	315	312	415	XP_061176776.1 circularly permutated Ras protein 1-like [Saccostrea echinata]	diamond	969	105	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
31084673	31084673	PRJNA1247234_P_NODE_21995_length_250_cov_1.762712_g21839_i0	PRJNA1247234	21995	250	1.762712	4.40678	Dreissena polymorpha	45954	Mollusca	Mollusca	50.4	1.75e-5	NR	KAH3897447.1	45954	g21839	i0	66.7	3.072	30	10	36	0	250	161	1	30	KAH3897447.1 hypothetical protein DPMN_021635 [Dreissena polymorpha]	diamond	768	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
31514048	31514048	PRJNA1247234_P_NODE_20596_length_253_cov_0.866667_g20440_i0	PRJNA1247234	20596	253	0.866667	2.19266751	Metazoa	33208	Mollusca	Mollusca	52	2.15e-5	NR	XP_052765316.1	6604	g20440	i0	65.5	19.5652173913043	29	10	34.4	0	3	89	326	354	XP_052765316.1 zinc finger protein 768-like isoform X39 [Mya arenaria]	diamond	4950	52.4	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
32760240	32760240	PRJNA1247234_P_NODE_8640_length_363_cov_1.044828_g8484_i0	PRJNA1247234	8640	363	1.044828	3.79272564	Mactra antiquata	2302425	Mollusca	Mollusca	73.2	1.47e-13	NR	KAL4222489.1	2302425	g8484	i0	34	1.70247933884298	100	65	82.6	1	54	353	15	113	KAL4222489.1 Phosphatidylglycerol/phosphatidylinositol transfer protein [Mactra antiquata]	diamond	618	73.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata

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