metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA788929" 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
26610306	26610306	PRJNA788929_P_NODE_13341_length_469_cov_44.328283_g12684_i0	PRJNA788929	13341	469	44.328283	207.89964727	Haliotis rufescens	6454	Mollusca	Mollusca	57	4.68e-6	NR	XP_046365028.2	6454	g12684	i0	33.3	2.136460554371	84	53	53.7	1	406	155	2731	2811	XP_046365028.2 uncharacterized protein LOC124141157 isoform X1 [Haliotis rufescens]	diamond	1002	57	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
26832249	26832249	PRJNA788929_P_NODE_48821_length_206_cov_5.368421_g48160_i0	PRJNA788929	48821	206	5.368421	11.05894726	Patella caerulea	87958	Mollusca	Mollusca	73.6	1.98e-13	NR	KAK6181968.1	87958	g48160	i0	55.9	1.71844660194175	59	26	85.9	0	22	198	239	297	KAK6181968.1 hypothetical protein SNE40_009743 [Patella caerulea]	diamond	354	73.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella caerulea
28262928	28262928	PRJNA788929_P_NODE_46086_length_223_cov_8.193333_g45425_i0	PRJNA788929	46086	223	8.193333	18.27113259	Opisthokonta	33154	Mollusca	Mollusca	99	3.0200000000000002e-22	NR	XP_033735422.1	6579	g45425	i0	84.9	8.55605381165919	53	8	71.3	0	201	43	403	455	XP_033735422.1 UTP--glucose-1-phosphate uridylyltransferase-like isoform X3 [Pecten maximus]	diamond	1908	100	0.99	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
28853578	28853578	PRJNA788929_P_NODE_34708_length_264_cov_6.041885_g34047_i0	PRJNA788929	34708	264	6.041885	15.9505764	Mercenaria mercenaria	6596	Mollusca	Mollusca	96.7	5.59e-21	NR	XP_053406128.1	6596	g34047	i0	56.1	2.61363636363636	82	33	90.9	2	1	240	2762	2842	XP_053406128.1 deleted in malignant brain tumors 1 protein-like isoform X1 [Mercenaria mercenaria]	diamond	690	96.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29210473	29210473	PRJNA788929_P_NODE_9209_length_598_cov_46.255238_g8558_i0	PRJNA788929	9209	598	46.255238	276.60632324	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	92	1.36e-19	NR	XP_045182503.1	6596	g8558	i0	32.9	4.91137123745819	146	94	73.2	1	38	475	21	162	XP_045182503.1 neo-calmodulin-like [Mercenaria mercenaria]	diamond	2937	92.4	0.995670995670996	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29304943	29304943	PRJNA788929_P_NODE_22989_length_337_cov_10.280303_g22328_i0	PRJNA788929	22989	337	10.280303	34.64462111	Mollusca	6447	Mollusca	Mollusca	53.9	1.39e-5	NR	XP_048754288.2	37623	g22328	i0	31.9	7.35311572700297	113	67	92.6	3	24	335	3957	4068	XP_048754288.2 uncharacterized protein LOC125665609 isoform X1 [Ostrea edulis]	diamond	2478	53.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
29359016	29359016	PRJNA788929_P_NODE_14749_length_440_cov_20.730245_g14090_i0	PRJNA788929	14749	440	20.730245	91.213078	Mytilus galloprovincialis	29158	Mollusca	Mollusca	103	2.49e-25	NR	CAQ63457.1	29158	g14090	i0	63.4	1.53409090909091	112	40	75.7	1	348	16	1	112	CAQ63457.1 ribosomal protein [Mytilus galloprovincialis]	diamond	675	103	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
29864142	29864142	PRJNA788929_P_NODE_19931_length_366_cov_17.310580_g19271_i0	PRJNA788929	19931	366	17.31058	63.3567228	Pomacea canaliculata	400727	Mollusca	Mollusca	77.8	1.02e-15	NR	XP_025092661.1	400727	g19271	i0	44.9	0.729508196721312	89	44	72.1	4	328	65	27	111	XP_025092661.1 venom protein 164-like [Pomacea canaliculata]	diamond	267	77.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
29927503	29927503	PRJNA788929_P_NODE_16271_length_414_cov_33.340176_g15612_i0	PRJNA788929	16271	414	33.340176	138.02832864	Pomacea canaliculata	400727	Mollusca	Mollusca	78.2	2.14e-15	NR	XP_025078419.1	400727	g15612	i0	52.5	0.442028985507246	61	29	44.2	0	390	208	53	113	XP_025078419.1 uncharacterized protein LOC112554688 [Pomacea canaliculata]	diamond	183	78.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
31254349	31254349	PRJNA788929_P_NODE_8915_length_611_cov_44.553903_g8265_i0	PRJNA788929	8915	611	44.553903	272.22434733	Elysia marginata	1093978	Mollusca	Mollusca	127	8.53e-34	NR	GFR81050.1	1093978	g8265	i0	53.6	1.28641571194763	125	51	60.4	3	516	148	19	138	GFR81050.1 nucleoredoxin-like [Elysia marginata]	diamond	786	127	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata

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