metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1111146" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1111146" 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
27952273	27952273	PRJNA1111146_P_NODE_425265_length_177_cov_1.838710_g424127_i0	PRJNA1111146	425265	177	1.83871	3.2545167	Tegillarca granosa	220873	Mollusca	Mollusca	42.7	0.0153	NR	KAJ8315036.1	220873	g424127	i0	39.2	6.38983050847458	51	31	86.4	0	155	3	198	248	KAJ8315036.1 hypothetical protein KUTeg_007186 [Tegillarca granosa]	diamond	1131	43.1	0.990719257540603	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa
28195903	28195903	PRJNA1111146_P_NODE_420586_length_178_cov_0.904000_g419448_i0	PRJNA1111146	420586	178	0.904	1.60912	Metazoa	33208	Mollusca	Mollusca	45.8	0.00129	NR	XP_052786368.1	6604	g419448	i0	34.7	5.96629213483146	49	32	82.6	0	153	7	251	299	XP_052786368.1 mitochondrial Rho GTPase 1-like isoform X2 [Mya arenaria]	diamond	1062	45.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
28804483	28804483	PRJNA1111146_P_NODE_352348_length_182_cov_0.883721_g351210_i0	PRJNA1111146	352348	182	0.883721	1.60837222	Elysia chlorotica	188477	Mollusca	Mollusca	65.9	9.47e-12	NR	RUS77281.1	188477	g351210	i0	83.9	1.53296703296703	31	5	51.1	0	180	88	97	127	RUS77281.1 hypothetical protein EGW08_014945, partial [Elysia chlorotica]	diamond	279	65.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia chlorotica
31742827	31742827	PRJNA1111146_P_NODE_375217_length_181_cov_0.867188_g374079_i0	PRJNA1111146	375217	181	0.867188	1.56961028	Mytilus edulis	6550	Mollusca	Mollusca	47.4	3.59e-4	NR	CAG2214739.1	6550	g374079	i0	76.9	0.994475138121547	26	6	43.1	0	156	79	224	249	CAG2214739.1 unnamed protein product [Mytilus edulis]	diamond	180	47.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
31987119	31987119	PRJNA1111146_P_NODE_226298_length_201_cov_1.472973_g225160_i0	PRJNA1111146	226298	201	1.472973	2.96067573	Stylommatophora	6527	Mollusca	Mollusca	59.3	2.84e-8	NR	BFZ09631.1	145626	g225160	i0	56.4	5.64179104477612	55	24	82.1	0	197	33	237	291	BFZ09631.1 hypothetical protein BsWGS_12670 [Bradybaena similaris]	diamond	1134	59.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
32090974	32090974	PRJNA1111146_P_NODE_220478_length_202_cov_1.516779_g219340_i0	PRJNA1111146	220478	202	1.516779	3.06389358	Mytilus coruscus	42192	Mollusca	Mollusca	60.5	8.86e-9	NR	CAC5395605.1	42192	g219340	i0	66.7	1.76732673267327	45	13	66.8	1	191	57	60	102	CAC5395605.1 unnamed protein product [Mytilus coruscus]	diamond	357	60.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
32122797	32122797	PRJNA1111146_P_NODE_90878_length_249_cov_1.071429_g89740_i0	PRJNA1111146	90878	249	1.071429	2.66785821	Acanthosepion pharaonis	158019	Mollusca	Mollusca	42.4	0.0372	NR	CAE1316284.1	158019	g89740	i0	60.5	0.518072289156627	43	12	49.4	2	110	232	114	153	CAE1316284.1 unnamed protein product [Acanthosepion pharaonis]	diamond	129	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
32525492	32525492	PRJNA1111146_P_NODE_314079_length_185_cov_0.863636_g312941_i0	PRJNA1111146	314079	185	0.863636	1.5977266	Metazoa	33208	Mollusca	Mollusca	43.1	0.0128	NR	XP_059177648.1	109671	g312941	i0	41.5	2.96756756756757	53	31	85.9	0	7	165	166	218	XP_059177648.1 uncharacterized protein K02A2.6-like [Physella acuta]	diamond	549	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta

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