metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA562549" 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
1821515	1821515	PRJNA562549_P_NODE_4142_length_559_cov_105.317269_g3958_i0	PRJNA562549	4142	559	105.317269	588.72353371	Pecten maximus	6579	Mollusca	Mollusca	281	6.45e-71	NTclustered	gi\|1835542110\|ref\|XM_033878112.1\|	6579	g3958	i0	80.886	61.4883720930233	361	65	64	4	161	519	434	76	PREDICTED: Pecten maximus histone H2A (LOC117323101), mRNA	blastn	34372	281	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
10750145	10750145	PRJNA562549_P_NODE_33789_length_207_cov_0.890411_g33556_i0	PRJNA562549	33789	207	0.890411	1.84315077	Octopus sinensis	2607531	Mollusca	Mollusca	143	1.04e-29	NTclustered	gi\|1914626990\|ref\|XM_029786969.2\|	2607531	g33556	i0	80.208	2.8695652173913	192	36	92	2	1	191	882	692	PREDICTED: Octopus sinensis 26S proteasome regulatory subunit 4 (LOC115217316), mRNA	blastn	594	143	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
10750233	10750233	PRJNA562549_P_NODE_8569_length_392_cov_3.401813_g8336_i0	PRJNA562549	8569	392	3.401813	13.33510696	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.037	NTclustered	gi\|2912999747\|dbj\|AP039606.1\|	145626	g8336	i0	100	0.0714285714285714	28	0	7	0	50	77	2800657	2800684	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
12024810	12024810	PRJNA562549_P_NODE_24570_length_236_cov_2.737143_g24337_i0	PRJNA562549	24570	236	2.737143	6.45965748	Lottia gigantea	225164	Mollusca	Mollusca	139	1.58e-28	NTclustered	gi\|676473099\|ref\|XM_009061459.1\|	225164	g24337	i0	88.034	6.70762711864407	117	14	50	0	1	117	313	197	Lottia gigantea hypothetical protein mRNA	blastn	1583	139	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
13299960	13299960	PRJNA562549_P_NODE_5851_length_476_cov_7.503614_g5618_i0	PRJNA562549	5851	476	7.503614	35.717202639999996	Octopus sinensis	2607531	Mollusca	Mollusca	257	9.150000000000001e-64	NTclustered	gi\|1914654315\|ref\|XM_029797635.2\|	2607531	g5618	i0	81.47	71.0819327731092	313	58	66	0	157	469	325	13	PREDICTED: Octopus sinensis histone H4 (LOC115226622), mRNA	blastn	33835	257	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
14574741	14574741	PRJNA562549_P_NODE_24992_length_234_cov_11.809249_g24759_i0	PRJNA562549	24992	234	11.809249	27.63364266	Lottia gigantea	225164	Mollusca	Mollusca	135	2.02e-27	NTclustered	gi\|676477813\|ref\|XM_009062978.1\|	225164	g24759	i0	85.185	15.8119658119658	135	16	56	4	98	229	1441	1308	Lottia gigantea hypothetical protein mRNA	blastn	3700	135	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
14574848	14574848	PRJNA562549_P_NODE_4192_length_556_cov_4.593939_g4008_i0	PRJNA562549	4192	556	4.593939	25.54230084	Haliotis rubra	36100	Mollusca	Mollusca	340	1.04e-88	NTclustered	gi\|2194171671\|ref\|XM_046698346.1\|	36100	g4008	i0	79.381	40.5323741007194	485	98	87	2	2	485	769	1252	PREDICTED: Haliotis rubra actin-1-like (LOC124263687), mRNA	blastn	22536	340	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
15158900	15158900	PRJNA562549_P_NODE_27972_length_223_cov_1.382716_g27739_i0	PRJNA562549	27972	223	1.382716	3.08345668	Metazoa	33208	Mollusca	Mollusca	147	8.83e-31	NTclustered	gi\|2334776009\|ref\|XM_052212625.1\|	6549	g27739	i0	85.714	52.1076233183856	140	18	62	2	85	223	1494	1356	PREDICTED: Mytilus californianus tubulin alpha-1A chain-like (LOC127707877), mRNA	blastn	11620	148	0.993243243243243	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
17123486	17123486	PRJNA562549_P_NODE_3134_length_634_cov_3.287958_g2995_i0	PRJNA562549	3134	634	3.287958	20.84565372	Mytilus californianus	6549	Mollusca	Mollusca	492	3.1299999999999993e-134	NTclustered	gi\|2334772166\|ref\|XR_007984668.1\|	6549	g2995	i0	80.854	31.9069400630915	632	115	99	4	4	632	1096	468	PREDICTED: Mytilus californianus ruvB-like 2 (LOC127706951), transcript variant X2, misc_RNA	blastn	20229	492	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
18397768	18397768	PRJNA562549_P_NODE_5775_length_479_cov_59.846890_g5543_i0	PRJNA562549	5775	479	59.84689	286.6666031	Saccostrea cuccullata	36930	Mollusca	Mollusca	285	4.22e-72	NTclustered	gi\|2669087831\|ref\|XM_062722976.1\|	36930	g5543	i0	85.609	31.4634655532359	271	39	57	0	33	303	144	414	PREDICTED: Saccostrea cucullata dynein light chain 2, cytoplasmic (LOC134240871), mRNA	blastn	15071	285	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
19672230	19672230	PRJNA562549_P_NODE_2556_length_693_cov_13.618671_g2428_i0	PRJNA562549	2556	693	13.618671	94.37739003	Octopus sinensis	2607531	Mollusca	Mollusca	387	1.67e-102	NTclustered	gi\|1914636139\|ref\|XM_029791122.2\|	2607531	g2428	i0	79.775	16.5743145743146	534	106	77	2	53	585	404	936	PREDICTED: Octopus sinensis cilia- and flagella-associated protein 20 (LOC115220923), mRNA	blastn	11486	387	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
22222718	22222718	PRJNA562549_P_NODE_17838_length_274_cov_1.427230_g17605_i0	PRJNA562549	17838	274	1.42723	3.9106102	Bradybaena similaris	145626	Mollusca	Mollusca	63.9	1.16e-5	NTclustered	gi\|2912988862\|dbj\|AP039593.1\|	145626	g17605	i0	100	6.91605839416058	34	0	12	0	186	219	68280801	68280768	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence	blastn	1895	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
24772029	24772029	PRJNA562549_P_NODE_31920_length_210_cov_1.308725_g31687_i0	PRJNA562549	31920	210	1.308725	2.7483225	Aplysia californica	6500	Mollusca	Mollusca	78.7	3.04e-10	NTclustered	gi\|871227362\|ref\|XM_005096663.2\|	6500	g31687	i0	97.778	0.866666666666667	45	1	21	0	143	187	413	457	PREDICTED: Aplysia californica cathepsin L1 (LOC101862643), transcript variant X1, mRNA	blastn	182	78.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica

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