metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA929522" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA929522" 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
8558266	8558266	PRJNA929522_S_NODE_5507_length_299_cov_0.858407_g5437_i0	PRJNA929522	5507	299	0.858407	2.56663693	Ruditapes philippinarum	129788	Mollusca	Mollusca	171	7.36e-38	NTclustered	gi\|2616500200\|ref\|XM_060704328.1\|	129788	g5437	i0	77.152	9.08695652173913	302	63	100	6	1	299	1077	779	PREDICTED: Ruditapes philippinarum ruvB-like 1 (LOC132720236), mRNA	blastn	2717	171	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
8558290	8558290	PRJNA929522_S_NODE_8927_length_248_cov_1.120000_g8857_i0	PRJNA929522	8927	248	1.12	2.7776	Physella acuta	109671	Mollusca	Mollusca	65.8	2.88e-6	NTclustered	gi\|2572359212\|ref\|XM_059306639.1\|	109671	g8857	i0	97.368	12.7943548387097	38	1	15	0	211	248	1244	1207	PREDICTED: Physella acuta actin, adductor muscle (LOC131946008), mRNA	blastn	3173	65.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
12384412	12384412	PRJNA929522_S_NODE_1330_length_568_cov_14.525253_g1261_i0	PRJNA929522	1330	568	14.525253	82.50343704	Mytilus coruscus	42192	Mollusca	Mollusca	200	1.8899999999999998e-46	NTclustered	gi\|2277726852\|gb\|MZ665472.1\|	42192	g1261	i0	78.827	30.8292253521127	307	57	53	6	228	530	303	1	Mytilus coruscus histone H4 mRNA, complete cds	blastn	17511	200	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
16208284	16208284	PRJNA929522_S_NODE_4253_length_332_cov_1.096525_g4183_i0	PRJNA929522	4253	332	1.096525	3.640463	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.031	NTclustered	gi\|2912993551\|dbj\|AP039598.1\|	145626	g4183	i0	100	0.0843373493975904	28	0	8	0	22	49	42692086	42692059	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18756898	18756898	PRJNA929522_S_NODE_6895_length_273_cov_1.155000_g6825_i0	PRJNA929522	6895	273	1.155	3.15315	Haliotis cracherodii	6455	Mollusca	Mollusca	52.8	0.025	NTclustered	gi\|2911887020\|ref\|XM_071223955.1\|	6455	g6825	i0	100	0.205128205128205	28	0	10	0	217	244	1235	1208	PREDICTED: Haliotis cracherodii lipoxygenase homology domain-containing protein 1-like (LOC139443033), transcript variant X1, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis cracherodii
18756909	18756909	PRJNA929522_S_NODE_835_length_688_cov_5.125203_g774_i0	PRJNA929522	835	688	5.125203	35.26139664	Littorina saxatilis	31220	Mollusca	Mollusca	111	1.12e-19	NTclustered	gi\|2868636770\|ref\|XM_070321055.1\|	31220	g774	i0	96.97	9.51162790697674	66	2	10	0	1	66	1176	1241	PREDICTED: Littorina saxatilis actin, adductor muscle (LOC138949271), mRNA	blastn	6544	111	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
19104879	19104879	PRJNA929522_S_NODE_4415_length_326_cov_2.055336_g4345_i0	PRJNA929522	4415	326	2.055336	6.70039536	Metazoa	33208	Mollusca	Mollusca	204	7.99e-48	NTclustered	gi\|1242750317\|ref\|XR_002637476.1\|	6565	g4345	i0	78.248	90.7300613496933	331	62	100	8	1	326	145	470	PREDICTED: Crassostrea virginica actin-like (LOC111118646), misc_RNA	blastn	29578	204	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
20031988	20031988	PRJNA929522_S_NODE_3656_length_352_cov_3.462366_g3586_i0	PRJNA929522	3656	352	3.462366	12.18752832	Mya arenaria	6604	Mollusca	Mollusca	309	1.7900000000000002e-79	NTclustered	gi\|2427418402\|ref\|XM_052927352.1\|	6604	g3586	i0	83.901	73.5511363636364	323	52	92	0	30	352	87	409	PREDICTED: Mya arenaria tubulin beta chain-like (LOC128219534), mRNA	blastn	25890	309	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
21307408	21307408	PRJNA929522_S_NODE_2237_length_444_cov_2.412399_g2167_i0	PRJNA929522	2237	444	2.412399	10.71105156	Patella vulgata	6465	Mollusca	Mollusca	331	4.930000000000001e-86	NTclustered	gi\|2506330923\|ref\|XM_050549233.2\|	6465	g2167	i0	81.934	14.8355855855856	393	69	88	2	2	393	149	540	PREDICTED: Patella vulgata ras-related protein Rab-1A (LOC126820989), mRNA	blastn	6587	331	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata

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