contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA683669" and tax_phylum = "Mollusca"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3215699 | 3215699 | PRJNA683669_P_NODE_12283_length_369_cov_1.003378_g12052_i0 | PRJNA683669 | 12283 | 369 | 1.003378 | 3.70246482 | Aplysia californica | 6500 | Mollusca | Mollusca | 58.4 | 7.54e-4 | NTclustered | gi|1897941042|ref|XM_005109892.3| | 6500 | g12052 | i0 | 97.059 | 0.0921409214092141 | 34 | 1 | 9 | 0 | 61 | 94 | 1800 | 1767 | PREDICTED: Aplysia californica histone-lysine N-methyltransferase PRDM16 (LOC101858582), partial mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 3215762 | 3215762 | PRJNA683669_P_NODE_19823_length_289_cov_2.018519_g19591_i0 | PRJNA683669 | 19823 | 289 | 2.018519 | 5.83351991 | Haliotis rubra | 36100 | Mollusca | Mollusca | 158 | 5.51e-34 | NTclustered | gi|2194112991|ref|XM_046712554.1| | 36100 | g19591 | i0 | 90.678 | 39.3771626297578 | 118 | 11 | 41 | 0 | 1 | 118 | 1271 | 1388 | PREDICTED: Haliotis rubra tubulin alpha-1A chain-like (LOC124276889), mRNA | blastn | 11380 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 3215858 | 3215858 | PRJNA683669_P_NODE_3103_length_745_cov_5.218750_g2895_i0 | PRJNA683669 | 3103 | 745 | 5.21875 | 38.8796875 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 4.46e-4 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g2895 | i0 | 89.796 | 0.703355704697987 | 49 | 2 | 6 | 3 | 346 | 392 | 75018836 | 75018789 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 524 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4492842 | 4492842 | PRJNA683669_P_NODE_16404_length_320_cov_1.214575_g16173_i0 | PRJNA683669 | 16404 | 320 | 1.214575 | 3.88664 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|2502171094|ref|XM_056029622.1| | 6526 | g16173 | i0 | 100 | 0.0875 | 28 | 0 | 9 | 0 | 109 | 136 | 511 | 538 | PREDICTED: Biomphalaria glabrata cannabinoid receptor 1-like (LOC129926311), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 7552880 | 7552880 | PRJNA683669_P_NODE_8966_length_427_cov_2.833333_g8735_i0 | PRJNA683669 | 8966 | 427 | 2.833333 | 12.09833191 | Metazoa | 33208 | Mollusca | Mollusca | 761 | 0 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g8735 | i0 | 98.829 | 49.8501170960187 | 427 | 5 | 100 | 0 | 1 | 427 | 1890 | 2316 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 21286 | 761 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 8318192 | 8318192 | PRJNA683669_P_NODE_33287_length_242_cov_0.911243_g33055_i0 | PRJNA683669 | 33287 | 242 | 0.911243 | 2.20520806 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 141 | 4.52e-29 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g33055 | i0 | 80.851 | 22.5909090909091 | 188 | 28 | 76 | 7 | 45 | 229 | 53070354 | 53070536 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 5467 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9593600 | 9593600 | PRJNA683669_P_NODE_24968_length_257_cov_1.603261_g24736_i0 | PRJNA683669 | 24968 | 257 | 1.603261 | 4.12038077 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g24736 | i0 | 94.444 | 0.470817120622568 | 36 | 2 | 14 | 0 | 112 | 147 | 14099718 | 14099753 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 121 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10103569 | 10103569 | PRJNA683669_P_NODE_3148_length_740_cov_1.457271_g2939_i0 | PRJNA683669 | 3148 | 740 | 1.457271 | 10.7838054 | Opisthokonta | 33154 | Mollusca | Mollusca | 60.2 | 4.43e-4 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g2939 | i0 | 97.143 | 1.73108108108108 | 35 | 1 | 5 | 0 | 254 | 288 | 21319642 | 21319676 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 1281 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10868969 | 10868969 | PRJNA683669_P_NODE_25269_length_255_cov_1.692308_g25037_i0 | PRJNA683669 | 25269 | 255 | 1.692308 | 4.3153854 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.38e-4 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g25037 | i0 | 97.143 | 0.286274509803922 | 35 | 1 | 14 | 0 | 52 | 86 | 35003224 | 35003258 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 73 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10869005 | 10869005 | PRJNA683669_P_NODE_30029_length_246_cov_0.890173_g29797_i0 | PRJNA683669 | 30029 | 246 | 0.890173 | 2.18982558 | Tridacna squamosa | 80830 | Mollusca | Mollusca | 231 | 2.6599999999999996e-56 | NTclustered | gi|1243362299|gb|MF458997.1| | 80830 | g29797 | i0 | 84.1 | 1.90243902439024 | 239 | 38 | 97 | 0 | 8 | 246 | 5020 | 5258 | Tridacna squamosa symbiodinium glutamate synthase mRNA, complete cds | blastn | 468 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Cardiidae | Tridacna | Tridacna squamosa | |
| 12144336 | 12144336 | PRJNA683669_P_NODE_23270_length_268_cov_1.820513_g23038_i0 | PRJNA683669 | 23270 | 268 | 1.820513 | 4.87897484 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 182 | 3e-41 | NTclustered | gi|1242850398|ref|XM_022450908.1| | 6565 | g23038 | i0 | 92.8 | 43.4813432835821 | 125 | 9 | 47 | 0 | 1 | 125 | 1392 | 1516 | PREDICTED: Crassostrea virginica tubulin alpha-1A chain (LOC111112993), mRNA | blastn | 11653 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 12144487 | 12144487 | PRJNA683669_P_NODE_8210_length_446_cov_2.458445_g7979_i0 | PRJNA683669 | 8210 | 446 | 2.458445 | 10.9646647 | Haliotis asinina | 109174 | Mollusca | Mollusca | 52.8 | 0.043 | NTclustered | gi|2793355103|ref|XM_067820893.1| | 109174 | g7979 | i0 | 100 | 0.188340807174888 | 28 | 0 | 6 | 0 | 137 | 164 | 12054 | 12027 | PREDICTED: Haliotis asinina histone-lysine N-methyltransferase 2A-like (LOC137289995), transcript variant X1, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 12654411 | 12654411 | PRJNA683669_P_NODE_9990_length_406_cov_0.960961_g9759_i0 | PRJNA683669 | 9990 | 406 | 0.960961 | 3.90150166 | Opisthokonta | 33154 | Mollusca | Mollusca | 226 | 2.1699999999999998e-54 | NTclustered | gi|2912405201|ref|XM_071315472.1| | 6550 | g9759 | i0 | 89.385 | 106.027093596059 | 179 | 19 | 44 | 0 | 228 | 406 | 1504 | 1326 | PREDICTED: Mytilus edulis polyubiquitin-C (LOC139521828), mRNA | blastn | 43047 | 228 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 13419016 | 13419016 | PRJNA683669_P_NODE_34351_length_231_cov_2.341772_g34119_i0 | PRJNA683669 | 34351 | 231 | 2.341772 | 5.40949332 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 108 | 4.34e-19 | NTclustered | gi|2868657593|ref|XM_070331548.1| | 31220 | g34119 | i0 | 78.363 | 8.88311688311688 | 171 | 33 | 73 | 4 | 63 | 231 | 2893 | 2725 | PREDICTED: Littorina saxatilis myosin heavy chain, striated muscle-like (LOC138959884), transcript variant X6, mRNA | blastn | 2052 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 15967752 | 15967752 | PRJNA683669_P_NODE_32073_length_243_cov_1.658824_g31841_i0 | PRJNA683669 | 32073 | 243 | 1.658824 | 4.03094232 | Physella acuta | 109671 | Mollusca | Mollusca | 449 | 6.65e-122 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g31841 | i0 | 100 | 95.8271604938272 | 243 | 0 | 100 | 0 | 1 | 243 | 1115 | 873 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 23286 | 449 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 19791797 | 19791797 | PRJNA683669_P_NODE_10176_length_403_cov_1.118182_g9945_i0 | PRJNA683669 | 10176 | 403 | 1.118182 | 4.50627346 | Lottia gigantea | 225164 | Mollusca | Mollusca | 220 | 1e-52 | NTclustered | gi|676454882|ref|XM_009055577.1| | 225164 | g9945 | i0 | 80.851 | 8.14640198511166 | 282 | 52 | 70 | 2 | 23 | 303 | 183 | 463 | Lottia gigantea hypothetical protein mRNA | blastn | 3283 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 21067316 | 21067316 | PRJNA683669_P_NODE_10677_length_394_cov_1.112150_g10446_i0 | PRJNA683669 | 10677 | 394 | 1.11215 | 4.381871 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.038 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g10446 | i0 | 100 | 0.0710659898477157 | 28 | 0 | 7 | 0 | 50 | 77 | 23102596 | 23102569 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21067338 | 21067338 | PRJNA683669_P_NODE_12797_length_361_cov_2.440972_g12566_i0 | PRJNA683669 | 12797 | 361 | 2.440972 | 8.81190892 | Argopecten irradians | 31199 | Mollusca | Mollusca | 115 | 4.3e-21 | NTclustered | gi|2835353845|ref|XM_069249315.1| | 31199 | g12566 | i0 | 95.775 | 18.9667590027701 | 71 | 3 | 20 | 0 | 1 | 71 | 1219 | 1289 | PREDICTED: Argopecten irradians tubulin beta chain-like (LOC138308320), mRNA | blastn | 6847 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 21067405 | 21067405 | PRJNA683669_P_NODE_21557_length_279_cov_1.281553_g21325_i0 | PRJNA683669 | 21557 | 279 | 1.281553 | 3.57553287 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g21325 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 2 | 29 | 4971322 | 4971349 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21067434 | 21067434 | PRJNA683669_P_NODE_25537_length_253_cov_2.305556_g25305_i0 | PRJNA683669 | 25537 | 253 | 2.305556 | 5.83305668 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2572323566|ref|XM_059298067.1| | 109671 | g25305 | i0 | 100 | 0.442687747035573 | 28 | 0 | 11 | 0 | 87 | 114 | 3093 | 3066 | PREDICTED: Physella acuta uncharacterized LOC131939634 (LOC131939634), transcript variant X3, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 22342280 | 22342280 | PRJNA683669_P_NODE_27718_length_249_cov_0.875000_g27486_i0 | PRJNA683669 | 27718 | 249 | 0.875 | 2.17875 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2868634935|ref|XM_070320332.1| | 31220 | g27486 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 160 | 187 | 92 | 119 | PREDICTED: Littorina saxatilis sodium/glucose cotransporter 4-like (LOC138948726), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 23617774 | 23617774 | PRJNA683669_P_NODE_14379_length_342_cov_0.784387_g14148_i0 | PRJNA683669 | 14379 | 342 | 0.784387 | 2.68260354 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 6.95e-4 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g14148 | i0 | 97.143 | 0.347953216374269 | 35 | 0 | 10 | 1 | 202 | 236 | 61691667 | 61691634 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 119 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25401400 | 25401400 | PRJNA683669_P_NODE_25280_length_255_cov_1.598901_g25048_i0 | PRJNA683669 | 25280 | 255 | 1.598901 | 4.07719755 | Octopus | 6643 | Mollusca | Mollusca | 180 | 1.02e-40 | NTclustered | gi|2427209734|ref|XM_014929914.2| | 37653 | g25048 | i0 | 80 | 22.0470588235294 | 255 | 42 | 98 | 9 | 6 | 254 | 1092 | 841 | PREDICTED: Octopus bimaculoides endoplasmic reticulum chaperone BiP (LOC106880098), mRNA | blastn | 5622 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides |
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);;