metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax

7 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
3837225	3837225	PRJDB9741_P_NODE_42884_length_153_cov_2.355769_g42567_i0	PRJDB9741	42884	153	2.355769	3.60432657	Saccostrea echinata	191078	Mollusca	Mollusca	60.2	7.49e-5	NTclustered	gi\|2628580761\|ref\|XM_061306332.1\|	191078	g42567	i0	92.683	20.359477124183	41	3	27	0	70	110	165	205	PREDICTED: Saccostrea echinata transcription elongation factor SPT6-like (LOC133171567), mRNA	blastn	3115	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
6389130	6389130	PRJDB9741_P_NODE_24566_length_171_cov_1.278689_g24249_i0	PRJDB9741	24566	171	1.278689	2.18655819	Doryteuthis gahi	1051064	Mollusca	Mollusca	115	1.8e-21	NTclustered	gi\|23168245\|gb\|AY083911.1\|	1051064	g24249	i0	89.362	0.549707602339181	94	6	55	2	34	127	320	409	Loligo gahi Lgah9 microsatellite sequence	blastn	94	115	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Myopsida	Loliginidae	Doryteuthis	Doryteuthis gahi
7663198	7663198	PRJDB9741_P_NODE_21447_length_175_cov_2.325397_g21130_i0	PRJDB9741	21447	175	2.325397	4.06944475	Uroteuthis chinensis	78424	Mollusca	Mollusca	52.8	0.015	NTclustered	gi\|288189914\|gb\|FJ980015.1\|	78424	g21130	i0	100	0.16	28	0	16	0	4	31	397	370	Uroteuthis chinensis clone 06 microsatellite sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Myopsida	Loliginidae	Uroteuthis	Uroteuthis chinensis
12764619	12764619	PRJDB9741_P_NODE_5931_length_258_cov_2.296651_g5614_i0	PRJDB9741	5931	258	2.296651	5.92535958	Bradybaena similaris	145626	Mollusca	Mollusca	84.2	8.33e-12	NTclustered	gi\|2913002590\|dbj\|AP039619.1\|	145626	g5614	i0	79.07	1	129	21	49	6	38	163	251355	251230	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored10, sequence	blastn	258	84.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15313138	15313138	PRJDB9741_P_NODE_30793_length_165_cov_2.327586_g30476_i0	PRJDB9741	30793	165	2.327586	3.8405169	Sepioteuthis lessoniana	34570	Mollusca	Mollusca	91.6	2.92e-14	NTclustered	gi\|290771289\|dbj\|AB520798.1\|	34570	g30476	i0	87.342	5.02424242424242	79	10	48	0	51	129	149	71	Sepioteuthis lessoniana DNA, Sepioth-SINE1 sequence, clone: 4	blastn	829	91.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Myopsida	Loliginidae	Sepioteuthis	Sepioteuthis lessoniana
23934273	23934273	PRJDB9741_P_NODE_35079_length_163_cov_1.789474_g34762_i0	PRJDB9741	35079	163	1.789474	2.91684262	Ruditapes	186463	Mollusca	Mollusca	302	1.22e-77	NTclustered	gi\|2710387645\|dbj\|LC807132.1\|	129788	g34762	i0	100	74.8159509202454	163	0	100	0	1	163	309	147	Ruditapes philippinarum IDEA_shell301 gene for 28S rRNA, partial sequence	blastn	12195	302	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
25207903	25207903	PRJDB9741_P_NODE_17780_length_182_cov_1.225564_g17463_i0	PRJDB9741	17780	182	1.225564	2.23052648	Metazoa	33208	Mollusca	Mollusca	52.8	0.015	NTclustered	gi\|2442025540\|ref\|XM_045322421.2\|	6596	g17463	i0	100	0.604395604395604	28	0	15	0	101	128	1335	1308	PREDICTED: Mercenaria mercenaria lariat debranching enzyme A-like (LOC123538372), mRNA	blastn	110	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria

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