metadata: contig_metadata: 6 rows where bioproject = "PRJNA390533", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA390533", tax_clade = "Opisthokonta" 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
1684526	1684526	PRJNA390533_P_NODE_24502_length_317_cov_3.712230_g23475_i0	PRJNA390533	24502	317	3.71223	11.7677691	Bradybaena similaris	145626	Mollusca	Mollusca	60.2	1.77e-4	NTclustered	gi\|2912988862\|dbj\|AP039593.1\|	145626	g23475	i0	91.304	0.627760252365931	46	1	15	2	193	238	36171894	36171852	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence	blastn	199	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15712302	15712302	PRJNA390533_P_NODE_22713_length_344_cov_2.747541_g21689_i0	PRJNA390533	22713	344	2.747541	9.45154104	Candidula unifasciata	100452	Mollusca	Mollusca	207	3.4399999999999997e-66	NR	CAG5119246.1	100452	g21689	i0	92.5	0.924418604651163	106	8	92.4	0	23	340	71	176	CAG5119246.1 unnamed protein product [Candidula unifasciata]	diamond	318	207	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata
17655649	17655649	PRJNA390533_P_NODE_10774_length_595_cov_2.034173_g9874_i0	PRJNA390533	10774	595	2.034173	12.10332935	Arion	6542	Mollusca	Mollusca	678	0	NTclustered	gi\|2056243379\|gb\|MW927710.1\|	2751868	g9874	i0	88.087	34.4285714285714	596	39	99	18	5	595	1690	2258	Arion ater ater mitochondrion, complete genome	blastn	20485	678	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Arionidae	Arion	Arion ater
27028837	27028837	PRJNA390533_P_NODE_17462_length_428_cov_3.064267_g16446_i0	PRJNA390533	17462	428	3.064267	13.11506276	Metazoa	33208	Mollusca	Mollusca	103	1.1e-22	NR	XP_045191736.1	6596	g16446	i0	61.3	2.10280373831776	75	29	52.6	0	21	245	571	645	XP_045191736.1 phosphoenolpyruvate carboxykinase, cytosolic [GTP]-like isoform X2 [Mercenaria mercenaria]	diamond	900	103	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29411993	29411993	PRJNA390533_P_NODE_23789_length_328_cov_10.574394_g22765_i0	PRJNA390533	23789	328	10.574394	34.68401232	Bradybaena similaris	145626	Mollusca	Mollusca	97.1	9.11e-21	NR	BFZ11159.1	145626	g22765	i0	97.7	0.393292682926829	43	1	39.3	0	23	151	834	876	BFZ11159.1 hypothetical protein BsWGS_14198 [Bradybaena similaris]	diamond	129	97.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
30913729	30913729	PRJNA390533_P_NODE_13534_length_516_cov_10.379455_g12562_i0	PRJNA390533	13534	516	10.379455	53.5579878	Metazoa	33208	Mollusca	Mollusca	94	7.07e-21	NR	XP_046565203.1	36100	g12562	i0	54.5	2.76162790697674	77	35	44.8	0	494	264	74	150	XP_046565203.1 Golgi-associated plant pathogenesis-related protein 1-like [Haliotis rubra]	diamond	1425	94.4	0.995762711864407	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra

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