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

8 rows where analysis = "diamond", bioproject = "PRJEB2925" 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
2575918	2575918	PRJEB2925_P_NODE_12703_length_298_cov_1.866920_g11426_i0	PRJEB2925	12703	298	1.86692	5.5634216	Metazoa	33208	Mollusca	Mollusca	134	1.53e-38	NR	XP_021373399.1	6573	g11426	i0	74.1	11.0939597315436	85	22	85.6	0	255	1	1	85	XP_021373399.1 probable 60S ribosomal protein L37-A [Mizuhopecten yessoensis]	diamond	3306	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
22978162	22978162	PRJEB2925_P_NODE_8759_length_410_cov_1.485333_g7503_i0	PRJEB2925	8759	410	1.485333	6.0898653	Candidula unifasciata	100452	Mollusca	Mollusca	66.6	9.58e-10	NR	CAG5115437.1	100452	g7503	i0	77.8	2.51707317073171	36	8	26.3	0	327	220	367	402	CAG5115437.1 unnamed protein product [Candidula unifasciata]	diamond	1032	66.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata
26646620	26646620	PRJEB2925_P_NODE_13641_length_281_cov_1.585366_g12363_i0	PRJEB2925	13641	281	1.585366	4.45487846	Haliotis	6452	Mollusca	Mollusca	90.9	2.54e-19	NR	XP_048242137.1	6454	g12363	i0	46.2	4.9644128113879	93	50	99.3	0	1	279	43	135	XP_048242137.1 procathepsin L-like [Haliotis rufescens]	diamond	1395	91.7	0.991275899672846	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
27033196	27033196	PRJEB2925_P_NODE_14782_length_264_cov_2.026201_g13504_i0	PRJEB2925	14782	264	2.026201	5.34917064	Patella caerulea	87958	Mollusca	Mollusca	48.9	2.33e-4	NR	KAK6171456.1	87958	g13504	i0	61.8	1.02272727272727	34	12	37.5	1	157	59	121	154	KAK6171456.1 hypothetical protein SNE40_019642 [Patella caerulea]	diamond	270	48.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella caerulea
28517674	28517674	PRJEB2925_P_NODE_12327_length_306_cov_1.335793_g11051_i0	PRJEB2925	12327	306	1.335793	4.08752658	Mercenaria mercenaria	6596	Mollusca	Mollusca	75.1	3.11e-14	NR	XP_045193494.1	6596	g11051	i0	41	0.980392156862745	100	54	98	3	300	1	60	154	XP_045193494.1 apolipoprotein D-like [Mercenaria mercenaria]	diamond	300	75.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29048004	29048004	PRJEB2925_P_NODE_9888_length_370_cov_2.134328_g8616_i0	PRJEB2925	9888	370	2.134328	7.8970136	Metazoa	33208	Mollusca	Mollusca	85.9	4.52e-18	NR	XP_011452281.3	29159	g8616	i0	52.5	2.43243243243243	101	28	65.7	2	4	246	86	186	XP_011452281.3 translocon-associated protein subunit gamma [Magallana gigas]	diamond	900	86.3	0.995365005793743	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
30785014	30785014	PRJEB2925_P_NODE_13514_length_283_cov_2.169355_g12236_i0	PRJEB2925	13514	283	2.169355	6.13927465	Metazoa	33208	Mollusca	Mollusca	65.1	1.67e-10	NR	KAK3594341.1	2493646	g12236	i0	74.4	2.69257950530035	43	11	45.6	0	129	1	33	75	KAK3594341.1 hypothetical protein CHS0354_026218 [Potamilus streckersoni]	diamond	762	65.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
31986418	31986418	PRJEB2925_P_NODE_16638_length_238_cov_2.054187_g15360_i0	PRJEB2925	16638	238	2.054187	4.88896506	Metazoa	33208	Mollusca	Mollusca	62.4	3.57e-9	NR	XP_060582686.1	129788	g15360	i0	37.4	9.30252100840336	91	29	79.4	1	193	5	6	96	XP_060582686.1 procathepsin L-like [Ruditapes philippinarum]	diamond	2214	62.8	0.993630573248408	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum

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