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

10 rows where analysis = "diamond", bioproject = "PRJNA512103" 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
26665397	26665397	PRJNA512103_P_NODE_26761_length_181_cov_1.863636_g26349_i0	PRJNA512103	26761	181	1.863636	3.37318116	Mytilus galloprovincialis	29158	Mollusca	Mollusca	81.6	2.39e-16	NR	VDI51986.1	29158	g26349	i0	58.5	5.43646408839779	53	22	87.8	0	8	166	332	384	VDI51986.1 Hypothetical predicted protein [Mytilus galloprovincialis]	diamond	984	81.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
26743994	26743994	PRJNA512103_P_NODE_15521_length_258_cov_1.239234_g15109_i0	PRJNA512103	15521	258	1.239234	3.19722372	Metazoa	33208	Mollusca	Mollusca	101	1.22e-22	NR	XP_055860289.1	6526	g15109	i0	60	6.55813953488372	80	32	93	0	7	246	993	1072	XP_055860289.1 uncharacterized protein LOC129921730 [Biomphalaria glabrata]	diamond	1692	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
27519537	27519537	PRJNA512103_P_NODE_26663_length_182_cov_1.060150_g26251_i0	PRJNA512103	26663	182	1.06015	1.929473	Pinctada fucata	50426	Mollusca	Mollusca	73.9	1.05e-14	NR	AAV73912.1	50426	g26251	i0	60.3	0.956043956043956	58	23	95.6	0	3	176	23	80	AAV73912.1 calmodulin-like protein [Pinctada fucata]	diamond	174	73.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada fucata
27898267	27898267	PRJNA512103_P_NODE_30165_length_170_cov_1.148760_g29753_i0	PRJNA512103	30165	170	1.14876	1.952892	Ruditapes philippinarum	129788	Mollusca	Mollusca	41.2	0.0499	NR	XP_060573600.1	129788	g29753	i0	43.2	0.776470588235294	44	25	77.6	0	26	157	830	873	XP_060573600.1 uncharacterized protein LOC132731436 [Ruditapes philippinarum]	diamond	132	41.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
28498485	28498485	PRJNA512103_P_NODE_21267_length_207_cov_0.936709_g20855_i0	PRJNA512103	21267	207	0.936709	1.93898763	Saccostrea cuccullata	36930	Mollusca	Mollusca	43.9	0.00679	NR	XP_062569145.1	36930	g20855	i0	43.3	1.43478260869565	60	31	82.6	1	207	37	133	192	XP_062569145.1 uncharacterized protein LOC134231228 [Saccostrea cuccullata]	diamond	297	43.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
30235098	30235098	PRJNA512103_P_NODE_20052_length_214_cov_1.424242_g19640_i0	PRJNA512103	20052	214	1.424242	3.04787788	Batillaria attramentaria	370345	Mollusca	Mollusca	65.5	2.43e-10	NR	KAK7486736.1	370345	g19640	i0	53.6	1.42990654205607	56	25	77.1	1	40	204	40	95	KAK7486736.1 hypothetical protein BaRGS_00022020 [Batillaria attramentaria]	diamond	306	65.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Batillariidae	Batillaria	Batillaria attramentaria
30250777	30250777	PRJNA512103_P_NODE_24852_length_189_cov_1.085714_g24440_i0	PRJNA512103	24852	189	1.085714	2.05199946	Metazoa	33208	Mollusca	Mollusca	68.9	1.06e-11	NR	KAL5021526.1	13268	g24440	i0	63.6	50.8095238095238	55	20	87.3	0	165	1	133	187	KAL5021526.1 hypothetical protein ScPMuIL_000681 [Solemya velum]	diamond	9603	69.3	0.994227994227994	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
30835418	30835418	PRJNA512103_P_NODE_20434_length_212_cov_0.852761_g20022_i0	PRJNA512103	20434	212	0.852761	1.80785332	Argopecten irradians	31199	Mollusca	Mollusca	50.1	5.91e-5	NR	XP_069132890.1	31199	g20022	i0	43.9	0.806603773584906	57	30	80.7	1	39	209	65	119	XP_069132890.1 uncharacterized protein [Argopecten irradians]	diamond	171	50.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
31910475	31910475	PRJNA512103_P_NODE_33397_length_164_cov_0.904348_g32985_i0	PRJNA512103	33397	164	0.904348	1.48313072	Acanthosepion pharaonis	158019	Mollusca	Mollusca	43.1	0.00942	NR	CAE1309668.1	158019	g32985	i0	62.1	2.17682926829268	29	11	53	0	162	76	204	232	CAE1309668.1 Craniofacial development protein 2 [Acanthosepion pharaonis]	diamond	357	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
32700673	32700673	PRJNA512103_P_NODE_14060_length_281_cov_1.254310_g13648_i0	PRJNA512103	14060	281	1.25431	3.5246111	Mercenaria mercenaria	6596	Mollusca	Mollusca	86.3	3.02e-17	NR	XP_053373150.1	6596	g13648	i0	44	0.97153024911032	91	51	97.2	0	281	9	1177	1267	XP_053373150.1 uncharacterized protein LOC123533634 [Mercenaria mercenaria]	diamond	273	86.3	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);;