metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax

7 rows where analysis = "diamond", bioproject = "PRJEB27957" 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
26646606	26646606	PRJEB27957_P_NODE_7341_length_469_cov_2.469048_g7233_i0	PRJEB27957	7341	469	2.469048	11.57983512	Mollusca	6447	Mollusca	Mollusca	51.2	2.62e-4	NR	KAK7112920.1	31220	g7233	i0	42.6	1.56076759061834	61	35	39	0	2	184	118	178	KAK7112920.1 hypothetical protein V1264_012294 [Littorina saxatilis]	diamond	732	51.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
27469295	27469295	PRJEB27957_P_NODE_107843_length_167_cov_12.559322_g107733_i0	PRJEB27957	107843	167	12.559322	20.97406774	Metazoa	33208	Mollusca	Mollusca	41.2	0.0473	NR	OWF51016.1	6573	g107733	i0	95	71.497005988024	20	1	35.9	0	165	106	511	530	OWF51016.1 Tubulin alpha-1A chain [Mizuhopecten yessoensis]	diamond	11940	41.6	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
28738575	28738575	PRJEB27957_P_NODE_7047_length_476_cov_2.182670_g6940_i0	PRJEB27957	7047	476	2.18267	10.389509200000001	Littorina saxatilis	31220	Mollusca	Mollusca	58.9	4.03e-7	NR	KAK7105128.1	31220	g6940	i0	39.7	3.28991596638655	78	40	44.7	1	262	474	55	132	KAK7105128.1 hypothetical protein V1264_019730 [Littorina saxatilis]	diamond	1566	58.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
30222689	30222689	PRJEB27957_P_NODE_89152_length_182_cov_1.563910_g89042_i0	PRJEB27957	89152	182	1.56391	2.8463162	Patella caerulea	87958	Mollusca	Mollusca	49.7	4.97e-5	NR	KAK6175889.1	87958	g89042	i0	54.8	2.35714285714286	42	19	69.2	0	173	48	150	191	KAK6175889.1 hypothetical protein SNE40_014266 [Patella caerulea]	diamond	429	49.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella caerulea
31613397	31613397	PRJEB27957_P_NODE_58196_length_218_cov_2.153846_g58086_i0	PRJEB27957	58196	218	2.153846	4.69538428	Solemya velum	13268	Mollusca	Mollusca	43.9	0.0106	NR	KAL5017366.1	13268	g58086	i0	59.5	1.10091743119266	42	17	57.8	0	126	1	211	252	KAL5017366.1 hypothetical protein ScPMuIL_006955 [Solemya velum]	diamond	240	43.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
32303273	32303273	PRJEB27957_P_NODE_70739_length_202_cov_1.359477_g70629_i0	PRJEB27957	70739	202	1.359477	2.74614354	root	1	Root_unresolved	Root_unresolved	43.1	0.0153	NR	KAL4240342.1	2302425	g70629	i0	51.4	1.0990099009901	37	18	55	0	131	21	79	115	KAL4240342.1 hypothetical protein ACF0H5_001132 [Mactra antiquata]	diamond	222	43.5	0.990804597701149	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
32625418	32625418	PRJEB27957_P_NODE_78360_length_193_cov_1.444444_g78250_i0	PRJEB27957	78360	193	1.444444	2.78777692	Acanthosepion pharaonis	158019	Mollusca	Mollusca	43.5	0.0106	NR	CAE1162969.1	158019	g78250	i0	50	0.932642487046632	60	20	88.6	4	192	22	623	675	CAE1162969.1 unnamed protein product [Acanthosepion pharaonis]	diamond	180	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis

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