metadata: contig_metadata: 5 rows where bioproject = "PRJNA1120586" and tax

5 rows where bioproject = "PRJNA1120586" 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
2826839	2826839	PRJNA1120586_P_NODE_40043_length_235_cov_0.867470_g39852_i0	PRJNA1120586	40043	235	0.86747	2.0385545	Bradybaena similaris	145626	Mollusca	Mollusca	63.9	9.73e-6	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g39852	i0	93.182	2.16595744680851	44	1	18	2	85	127	17575674	17575632	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	509	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
19402007	19402007	PRJNA1120586_P_NODE_36716_length_242_cov_1.664740_g36525_i0	PRJNA1120586	36716	242	1.66474	4.0286708	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	4.69e-4	NTclustered	gi\|2912995509\|dbj\|AP039600.1\|	145626	g36525	i0	92.683	0.475206611570248	41	2	17	1	200	239	6865481	6865521	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence	blastn	115	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
21953134	21953134	PRJNA1120586_P_NODE_48518_length_229_cov_0.900000_g48327_i0	PRJNA1120586	48518	229	0.9	2.061	Octopus bimaculoides	37653	Mollusca	Mollusca	52.8	0.02	NTclustered	gi\|2427240814\|ref\|XM_052967605.1\|	37653	g48327	i0	100	0.733624454148472	28	0	12	0	63	90	3573	3600	PREDICTED: Octopus bimaculoides rho GTPase-activating protein 18 (LOC106884256), transcript variant X4, mRNA	blastn	168	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
26880421	26880421	PRJNA1120586_P_NODE_27701_length_268_cov_1.185930_g27510_i0	PRJNA1120586	27701	268	1.18593	3.1782924	Mytilus edulis	6550	Mollusca	Mollusca	45.1	0.00739	NR	XP_071161096.1	6550	g27510	i0	44.7	2.55223880597015	76	42	85.1	0	1	228	196	271	XP_071161096.1 uncharacterized protein [Mytilus edulis]	diamond	684	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
27922881	27922881	PRJNA1120586_P_NODE_32385_length_254_cov_1.124324_g32194_i0	PRJNA1120586	32385	254	1.124324	2.85578296	Mytilus edulis	6550	Mollusca	Mollusca	56.6	4.61e-7	NR	CAG2187267.1	6550	g32194	i0	42.9	0.74409448818897606	63	35	73.2	1	204	19	192	254	CAG2187267.1 unnamed protein product [Mytilus edulis]	diamond	189	56.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis

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