metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA900028" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA900028" 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
26936791	26936791	PRJNA900028_P_NODE_92502_length_179_cov_1.569231_g91753_i0	PRJNA900028	92502	179	1.569231	2.80892349	Metazoa	33208	Mollusca	Mollusca	112	6.3200000000000006e-27	NR	KAK7094181.1	31220	g91753	i0	88.1	41.5139664804469	59	7	98.9	0	2	178	570	628	KAK7094181.1 hypothetical protein V1264_007837 [Littorina saxatilis]	diamond	7431	112	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
28003570	28003570	PRJNA900028_P_NODE_186285_length_162_cov_0.884956_g185536_i0	PRJNA900028	186285	162	0.884956	1.43362872	Dreissena polymorpha	45954	Mollusca	Mollusca	50.1	6.1e-6	NR	KAH3829362.1	45954	g185536	i0	51.2	0.759259259259259	41	20	75.9	0	9	131	29	69	KAH3829362.1 hypothetical protein DPMN_131358 [Dreissena polymorpha]	diamond	123	50.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
28823982	28823982	PRJNA900028_P_NODE_141868_length_165_cov_1.318966_g141119_i0	PRJNA900028	141868	165	1.318966	2.1762939	Mya arenaria	6604	Mollusca	Mollusca	41.2	0.0454	NR	XP_052816150.1	6604	g141119	i0	40.7	1.07272727272727	59	30	98.2	1	164	3	407	465	XP_052816150.1 uncharacterized protein LOC128242833 isoform X1 [Mya arenaria]	diamond	177	41.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
29045401	29045401	PRJNA900028_P_NODE_101588_length_175_cov_1.285714_g100839_i0	PRJNA900028	101588	175	1.285714	2.2499995	Magallana gigas	29159	Mollusca	Mollusca	82	2.15e-16	NR	XP_065940897.1	29159	g100839	i0	67.3	0.891428571428571	52	17	89.1	0	156	1	803	854	XP_065940897.1 retrovirus-related Pol polyprotein from transposon 412 [Magallana gigas]	diamond	156	82	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
29045409	29045409	PRJNA900028_P_NODE_129088_length_166_cov_1.743590_g128339_i0	PRJNA900028	129088	166	1.74359	2.8943594	Haliotis rufescens	6454	Mollusca	Mollusca	53.1	2.77e-6	NR	XP_048251812.1	6454	g128339	i0	45.1	3.77710843373494	51	24	92.2	1	157	5	202	248	XP_048251812.1 uncharacterized protein LOC125379948 [Haliotis rufescens]	diamond	627	53.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens

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