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

5 rows where analysis = "diamond", bioproject = "PRJEB28062" 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
26938116	26938116	PRJEB28062_P_NODE_130802_length_241_cov_0.916667_g128438_i0	PRJEB28062	130802	241	0.916667	2.20916747	Bradybaena similaris	145626	Mollusca	Mollusca	88.2	1.67e-18	NR	BFZ17186.1	145626	g128438	i0	49.4	0.95850622406639	77	39	95.9	0	240	10	40	116	BFZ17186.1 hypothetical protein BsWGS_20225 [Bradybaena similaris]	diamond	231	88.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
27570267	27570267	PRJEB28062_P_NODE_126864_length_247_cov_0.885057_g124500_i0	PRJEB28062	126864	247	0.885057	2.18609079	Mytilus coruscus	42192	Mollusca	Mollusca	43.5	0.02	NR	CAC5385414.1	42192	g124500	i0	34.1	0.995951417004049	82	49	99.6	1	1	246	197	273	CAC5385414.1 unnamed protein product [Mytilus coruscus]	diamond	246	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
28423053	28423053	PRJEB28062_P_NODE_67566_length_420_cov_22.919308_g65205_i0	PRJEB28062	67566	420	22.919308	96.2610936	Argopecten irradians	31199	Mollusca	Mollusca	79	5.68e-14	NR	XP_069122271.1	31199	g65205	i0	54.1	0.435714285714286	61	27	43.6	1	202	384	303	362	XP_069122271.1 uncharacterized protein [Argopecten irradians]	diamond	183	79	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
29180803	29180803	PRJEB28062_P_NODE_19109_length_861_cov_14.953046_g17093_i0	PRJEB28062	19109	861	14.953046	128.74572606	Acanthosepion pharaonis	158019	Mollusca	Mollusca	48.1	0.0431	NR	CAE1236277.1	158019	g17093	i0	33.8	0.947735191637631	272	127	84.3	14	831	106	736	984	CAE1236277.1 unnamed protein product [Acanthosepion pharaonis]	diamond	816	48.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
29622193	29622193	PRJEB28062_P_NODE_40170_length_573_cov_52.324000_g37837_i0	PRJEB28062	40170	573	52.324	299.81652	Mytilus californianus	6549	Mollusca	Mollusca	54.3	9.17e-5	NR	XP_052083749.1	6549	g37837	i0	42	0.581151832460733	69	34	33.5	3	446	255	2816	2883	XP_052083749.1 uncharacterized protein LOC127721113 [Mytilus californianus]	diamond	333	54.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus

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