contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1214993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 330221 | 330221 | PRJNA1214993_P_NODE_14161_length_293_cov_1.640909_g13975_i0 | PRJNA1214993 | 14161 | 293 | 1.640909 | 4.80786337 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 195 | 4.27e-45 | NTclustered | gi|2364306993|ref|XM_052380302.1| | 45954 | g13975 | i0 | 87.879 | 25.9658703071672 | 165 | 20 | 56 | 0 | 129 | 293 | 1507 | 1343 | PREDICTED: Dreissena polymorpha tubulin alpha-1A chain (LOC127848022), mRNA | blastn | 7608 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 330271 | 330271 | PRJNA1214993_P_NODE_1961_length_746_cov_2.243685_g1795_i0 | PRJNA1214993 | 1961 | 746 | 2.243685 | 16.7378901 | Pecten maximus | 6579 | Mollusca | Mollusca | 294 | 1.13e-74 | NTclustered | gi|1835546893|ref|XM_033880597.1| | 6579 | g1795 | i0 | 83.333 | 40.0750670241287 | 324 | 48 | 43 | 5 | 347 | 667 | 51 | 371 | PREDICTED: Pecten maximus calmodulin (LOC117324662), mRNA | blastn | 29896 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 330287 | 330287 | PRJNA1214993_P_NODE_2121_length_715_cov_2.610592_g1951_i0 | PRJNA1214993 | 2121 | 715 | 2.610592 | 18.6657328 | Argopecten irradians | 31199 | Mollusca | Mollusca | 329 | 2.95e-85 | NTclustered | gi|2835327062|ref|XM_069262855.1| | 31199 | g1951 | i0 | 77.419 | 12.4335664335664 | 558 | 122 | 78 | 4 | 11 | 566 | 651 | 1206 | PREDICTED: Argopecten irradians guanine nucleotide-binding protein subunit beta (LOC138319713), mRNA | blastn | 8890 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 2881254 | 2881254 | PRJNA1214993_P_NODE_23123_length_247_cov_0.885057_g22937_i0 | PRJNA1214993 | 23123 | 247 | 0.885057 | 2.18609079 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g22937 | i0 | 100 | 0.117408906882591 | 29 | 0 | 12 | 0 | 156 | 184 | 31397579 | 31397607 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2881326 | 2881326 | PRJNA1214993_P_NODE_7223_length_401_cov_4.109756_g7037_i0 | PRJNA1214993 | 7223 | 401 | 4.109756 | 16.48012156 | Physella acuta | 109671 | Mollusca | Mollusca | 641 | 1.7899999999999994e-179 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g7037 | i0 | 95.522 | 62.0423940149626 | 402 | 17 | 100 | 1 | 1 | 401 | 2768 | 3169 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 24879 | 641 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 5433539 | 5433539 | PRJNA1214993_P_NODE_3105_length_599_cov_1.570342_g2925_i0 | PRJNA1214993 | 3105 | 599 | 1.570342 | 9.40634858 | Patella vulgata | 6465 | Mollusca | Mollusca | 399 | 1.84e-106 | NTclustered | gi|2506334706|ref|XM_050554129.2| | 6465 | g2925 | i0 | 83.333 | 81.4040066777963 | 432 | 72 | 72 | 0 | 156 | 587 | 2815 | 2384 | PREDICTED: Patella vulgata sarcoplasmic/endoplasmic reticulum calcium ATPase 1 (LOC126824764), transcript variant X1, mRNA | blastn | 48761 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 7983701 | 7983701 | PRJNA1214993_P_NODE_16187_length_277_cov_2.264706_g16001_i0 | PRJNA1214993 | 16187 | 277 | 2.264706 | 6.27323562 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 204 | 6.65e-48 | NTclustered | gi|1207979951|ref|XM_021483817.1| | 6573 | g16001 | i0 | 81.226 | 19.1407942238267 | 261 | 41 | 93 | 8 | 19 | 275 | 1 | 257 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S17-B-like (LOC110440653), partial mRNA | blastn | 5302 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 8698385 | 8698385 | PRJNA1214993_P_NODE_20887_length_250_cov_2.711864_g20701_i0 | PRJNA1214993 | 20887 | 250 | 2.711864 | 6.77966 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g20701 | i0 | 92.308 | 6.7 | 39 | 3 | 16 | 0 | 177 | 215 | 46052770 | 46052732 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 1675 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9973487 | 9973487 | PRJNA1214993_P_NODE_10108_length_345_cov_1.147059_g9922_i0 | PRJNA1214993 | 10108 | 345 | 1.147059 | 3.95735355 | Metazoa | 33208 | Mollusca | Mollusca | 316 | 1.05e-81 | NTclustered | gi|2245706711|ref|XM_048385483.1| | 6454 | g9922 | i0 | 85.342 | 92.6521739130435 | 307 | 44 | 89 | 1 | 1 | 307 | 352 | 47 | PREDICTED: Haliotis rufescens tubulin beta chain-like (LOC124142795), transcript variant X3, mRNA | blastn | 31965 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 13084089 | 13084089 | PRJNA1214993_P_NODE_7111_length_404_cov_3.060423_g6926_i0 | PRJNA1214993 | 7111 | 404 | 3.060423 | 12.36410892 | Haliotis asinina | 109174 | Mollusca | Mollusca | 316 | 1.24e-81 | NTclustered | gi|2793389096|ref|XM_067806348.1| | 109174 | g6926 | i0 | 82.768 | 83.6460396039604 | 354 | 61 | 88 | 0 | 1 | 354 | 357 | 4 | PREDICTED: Haliotis asinina tubulin beta chain-like (LOC137273594), transcript variant X1, mRNA | blastn | 33793 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 14359306 | 14359306 | PRJNA1214993_P_NODE_17212_length_270_cov_1.324873_g17026_i0 | PRJNA1214993 | 17212 | 270 | 1.324873 | 3.5771571 | Patella vulgata | 6465 | Mollusca | Mollusca | 278 | 3.7500000000000005e-70 | NTclustered | gi|2506343157|ref|XM_050561934.2| | 6465 | g17026 | i0 | 85.185 | 59.1 | 270 | 40 | 100 | 0 | 1 | 270 | 858 | 1127 | PREDICTED: Patella vulgata ATP synthase subunit beta, mitochondrial (LOC126831451), mRNA | blastn | 15957 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 15633244 | 15633244 | PRJNA1214993_P_NODE_26333_length_240_cov_9.035928_g26147_i0 | PRJNA1214993 | 26333 | 240 | 9.035928 | 21.6862272 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 62.1 | 3.59e-5 | NTclustered | gi|2868657535|ref|XM_070331518.1| | 31220 | g26147 | i0 | 100 | 2.45833333333333 | 33 | 0 | 14 | 0 | 11 | 43 | 3665 | 3633 | PREDICTED: Littorina saxatilis solute carrier family 15 member 1-like (LOC138959870), transcript variant X1, mRNA | blastn | 590 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 15633313 | 15633313 | PRJNA1214993_P_NODE_8993_length_363_cov_3.679310_g8807_i0 | PRJNA1214993 | 8993 | 363 | 3.67931 | 13.3558953 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|1897922575|ref|XM_035969486.1| | 6500 | g8807 | i0 | 100 | 0.0771349862258953 | 28 | 0 | 8 | 0 | 238 | 265 | 4567 | 4594 | PREDICTED: Aplysia californica CMT1A duplicated region transcript 1 protein (LOC101846130), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 16907517 | 16907517 | PRJNA1214993_P_NODE_3594_length_559_cov_3.374486_g3411_i0 | PRJNA1214993 | 3594 | 559 | 3.374486 | 18.86337674 | Patella vulgata | 6465 | Mollusca | Mollusca | 316 | 1.7699999999999996e-81 | NTclustered | gi|2296492132|ref|XM_050552576.1| | 6465 | g3411 | i0 | 79.565 | 14.788908765653 | 460 | 81 | 81 | 10 | 30 | 481 | 660 | 206 | PREDICTED: Patella vulgata S-phase kinase-associated protein 1 (LOC130010351), mRNA | blastn | 8267 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 19456340 | 19456340 | PRJNA1214993_P_NODE_14036_length_294_cov_2.470588_g13850_i0 | PRJNA1214993 | 14036 | 294 | 2.470588 | 7.26352872 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 239 | 1.95e-58 | NTclustered | gi|2669096675|ref|XM_062727451.1| | 36930 | g13850 | i0 | 81.661 | 69.5884353741497 | 289 | 51 | 98 | 2 | 5 | 292 | 1505 | 1792 | PREDICTED: Saccostrea cucullata myosin heavy chain, striated muscle-like (LOC134245191), transcript variant X1, mRNA | blastn | 20459 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 20731734 | 20731734 | PRJNA1214993_P_NODE_16837_length_273_cov_1.170000_g16651_i0 | PRJNA1214993 | 16837 | 273 | 1.17 | 3.1941 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g16651 | i0 | 96.875 | 0.63003663003663 | 32 | 1 | 12 | 0 | 232 | 263 | 12075812 | 12075843 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 172 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20731867 | 20731867 | PRJNA1214993_P_NODE_9577_length_353_cov_1.653571_g9391_i0 | PRJNA1214993 | 9577 | 353 | 1.653571 | 5.83710563 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 75 | 7.12e-9 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g9391 | i0 | 97.674 | 11.6232294617564 | 43 | 1 | 12 | 0 | 14 | 56 | 32000379 | 32000337 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 4103 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22007216 | 22007216 | PRJNA1214993_P_NODE_9458_length_355_cov_1.907801_g9272_i0 | PRJNA1214993 | 9458 | 355 | 1.907801 | 6.77269355 | Mytilus californianus | 6549 | Mollusca | Mollusca | 139 | 2.51e-28 | NTclustered | gi|2334761650|ref|XM_052209352.1| | 6549 | g9272 | i0 | 86.508 | 24.4225352112676 | 126 | 17 | 35 | 0 | 66 | 191 | 79 | 204 | PREDICTED: Mytilus californianus 60S ribosomal protein L27a-like (LOC127705074), mRNA | blastn | 8670 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 22722332 | 22722332 | PRJNA1214993_P_NODE_5018_length_477_cov_4.118812_g4833_i0 | PRJNA1214993 | 5018 | 477 | 4.118812 | 19.64673324 | Metazoa | 33208 | Mollusca | Mollusca | 331 | 5.330000000000001e-86 | NTclustered | gi|2506339215|ref|XM_056102607.1| | 6465 | g4833 | i0 | 81.055 | 88.1907756813417 | 417 | 77 | 87 | 2 | 42 | 457 | 555 | 140 | PREDICTED: Patella vulgata ras-like GTP-binding protein RHO (LOC126828516), transcript variant X3, mRNA | blastn | 42067 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 23997519 | 23997519 | PRJNA1214993_P_NODE_6359_length_426_cov_1.325779_g6174_i0 | PRJNA1214993 | 6359 | 426 | 1.325779 | 5.64781854 | Opisthokonta | 33154 | Mollusca | Mollusca | 285 | 3.72e-72 | NTclustered | gi|2868648368|ref|XM_070357077.1| | 31220 | g6174 | i0 | 80.311 | 87.3568075117371 | 386 | 68 | 90 | 6 | 45 | 426 | 1352 | 971 | PREDICTED: Littorina saxatilis eukaryotic initiation factor 4A-I-like (LOC138983757), transcript variant X2, mRNA | blastn | 37214 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis |
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);;