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

13 rows where analysis = "blastn", bioproject = "PRJNA1088503" 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
1469088	1469088	PRJNA1088503_P_NODE_2382_length_593_cov_2.257092_g2126_i0	PRJNA1088503	2382	593	2.257092	13.38455556	Argopecten irradians	31199	Mollusca	Mollusca	291	1.14e-73	NTclustered	gi\|22758901\|gb\|AF526229.1\|	31199	g2126	i0	77.515	55.8397976391231	507	98	84	13	45	543	607	109	Argopecten irradians isolate iolsaicl413ct453cn476 ribosomal protein L12 mRNA, complete cds	blastn	33113	291	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
2745229	2745229	PRJNA1088503_P_NODE_3303_length_492_cov_10713.894168_g2985_i0	PRJNA1088503	3303	492	10713.894168	52712.35930656	Ruditapes philippinarum	129788	Mollusca	Mollusca	307	9.28e-79	NTclustered	gi\|2616648788\|ref\|XM_060743427.1\|	129788	g2985	i0	79.905	62.5121951219512	423	81	86	4	44	464	59	479	PREDICTED: Ruditapes philippinarum large ribosomal subunit protein uL14 (LOC132753014), mRNA	blastn	30756	307	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
5297347	5297347	PRJNA1088503_P_NODE_9845_length_195_cov_1.451807_g9473_i0	PRJNA1088503	9845	195	1.451807	2.83102365	Haliotis asinina	109174	Mollusca	Mollusca	198	2.05e-46	NTclustered	gi\|2793416906\|ref\|XM_067821345.1\|	109174	g9473	i0	85.128	3.86666666666667	195	27	99	2	2	195	493	300	PREDICTED: Haliotis asinina DNA-directed RNA polymerases I, II, and III subunit RPABC1 (LOC137290420), mRNA	blastn	754	198	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
6572382	6572382	PRJNA1088503_P_NODE_3506_length_475_cov_6.766816_g3174_i0	PRJNA1088503	3506	475	6.766816	32.142376	Aplysia californica	6500	Mollusca	Mollusca	243	2.56e-59	NTclustered	gi\|325297036\|ref\|NM_001204593.1\|	6500	g3174	i0	77.831	56.4147368421053	415	76	85	15	72	475	465	56	Aplysia californica ribosomal protein L27a (LOC100533291), mRNA	blastn	26797	243	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
7847223	7847223	PRJNA1088503_P_NODE_8647_length_226_cov_2.309645_g8275_i0	PRJNA1088503	8647	226	2.309645	5.2197977	Octopus sinensis	2607531	Mollusca	Mollusca	200	6.79e-47	NTclustered	gi\|1914618571\|ref\|XM_029783759.2\|	2607531	g8275	i0	83.721	2.88495575221239	215	31	94	4	3	215	401	189	PREDICTED: Octopus sinensis cytochrome c oxidase subunit 6B1 (LOC115214677), mRNA	blastn	652	200	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
11673159	11673159	PRJNA1088503_P_NODE_10690_length_173_cov_2.319444_g10318_i0	PRJNA1088503	10690	173	2.319444	4.01263812	Pecten maximus	6579	Mollusca	Mollusca	86.1	1.43e-12	NTclustered	gi\|1835492002\|ref\|XM_033893942.1\|	6579	g10318	i0	81.553	1.08092485549133	103	19	60	0	63	165	369	267	PREDICTED: Pecten maximus 60S ribosomal protein L36-like (LOC117334363), mRNA	blastn	187	86.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
18046237	18046237	PRJNA1088503_P_NODE_4755_length_383_cov_2.813559_g4389_i0	PRJNA1088503	4755	383	2.813559	10.77593097	Aplysia californica	6500	Mollusca	Mollusca	102	3.58e-17	NTclustered	gi\|524866199\|ref\|XR_220069.1\|	6500	g4389	i0	76.531	2.75195822454308	196	40	50	3	71	263	56	248	PREDICTED: Aplysia californica uncharacterized LOC101845895 (LOC101845895), ncRNA	blastn	1054	102	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
18869134	18869134	PRJNA1088503_P_NODE_7495_length_262_cov_700.163090_g7123_i0	PRJNA1088503	7495	262	700.16309	1834.4272958	Metazoa	33208	Mollusca	Mollusca	222	1.72e-53	NTclustered	gi\|2868636770\|ref\|XM_070321055.1\|	31220	g7123	i0	91.824	61.8396946564885	159	13	61	0	104	262	109	267	PREDICTED: Littorina saxatilis actin, adductor muscle (LOC138949271), mRNA	blastn	16202	222	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
20595568	20595568	PRJNA1088503_P_NODE_2297_length_607_cov_384.475779_g2046_i0	PRJNA1088503	2297	607	384.475779	2333.76797853	Ylistrum balloti	509963	Mollusca	Mollusca	226	3.35e-54	NTclustered	gi\|2592079024\|ref\|XM_060219749.1\|	509963	g2046	i0	82.308	23.8649093904448	260	46	43	0	28	287	532	273	PREDICTED: Ylistrum balloti large ribosomal subunit protein uL23-like (LOC132555400), mRNA	blastn	14486	226	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Ylistrum	Ylistrum balloti
20595619	20595619	PRJNA1088503_P_NODE_8937_length_218_cov_2.132275_g8565_i0	PRJNA1088503	8937	218	2.132275	4.6483595	Ylistrum balloti	509963	Mollusca	Mollusca	71.3	5.32e-8	NTclustered	gi\|2592082784\|ref\|XM_060221808.1\|	509963	g8565	i0	87.097	0.284403669724771	62	8	28	0	26	87	679	740	PREDICTED: Ylistrum balloti akirin-2-like (LOC132557323), mRNA	blastn	62	71.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Ylistrum	Ylistrum balloti
21871365	21871365	PRJNA1088503_P_NODE_638_length_1041_cov_2062.838933_g553_i0	PRJNA1088503	638	1041	2062.838933	21474.15329253	Magallana gigas	29159	Mollusca	Mollusca	411	1.51e-109	NTclustered	gi\|2751295953\|ref\|XM_034456113.2\|	29159	g553	i0	86.885	31.1066282420749	366	48	35	0	72	437	129	494	PREDICTED: Magallana gigas histone H2A.V (LOC109617243), mRNA	blastn	32382	411	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
22694372	22694372	PRJNA1088503_P_NODE_3858_length_447_cov_3.849282_g3506_i0	PRJNA1088503	3858	447	3.849282	17.20629054	Metazoa	33208	Mollusca	Mollusca	180	1.9e-40	NTclustered	gi\|1835468110\|ref\|XM_033906026.1\|	6579	g3506	i0	87.421	31.5413870246085	159	17	35	3	2	157	1329	1487	PREDICTED: Pecten maximus tubulin alpha-1A chain-like (LOC117343594), mRNA	blastn	14099	180	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
23969889	23969889	PRJNA1088503_P_NODE_3919_length_441_cov_439.291262_g3565_i0	PRJNA1088503	3919	441	439.291262	1937.27446542	Magallana	147004	Mollusca	Mollusca	150	1.47e-31	NTclustered	gi\|2751307315\|ref\|XM_011455560.4\|	29159	g3565	i0	79.452	13.5555555555556	219	39	49	5	90	305	89	304	PREDICTED: Magallana gigas small nuclear ribonucleoprotein G (LOC105346836), mRNA	blastn	5978	150	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas

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