contig_metadata
16 rows where bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12033290 | 12033290 | PRJNA564810_S_NODE_2170_length_329_cov_2.268939_g2148_i0 | PRJNA564810 | 2170 | 329 | 2.268939 | 7.46480931 | Opisthokonta | 33154 | Mollusca | Mollusca | 129 | 3.42e-33 | NR | WAR25636.1 | 6604 | g2148 | i0 | 80.9 | 4.96048632218845 | 68 | 13 | 62 | 0 | 329 | 126 | 338 | 405 | WAR25636.1 MAP2-like protein [Mya arenaria] | diamond | 1632 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 15856853 | 15856853 | PRJNA564810_S_NODE_4933_length_255_cov_1.542105_g4911_i0 | PRJNA564810 | 4933 | 255 | 1.542105 | 3.93236775 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1397730177|ref|XM_025256400.1| | 400727 | g4911 | i0 | 100 | 0.341176470588235 | 29 | 0 | 11 | 0 | 93 | 121 | 1176 | 1148 | PREDICTED: Pomacea canaliculata protein FAM102A-like (LOC112574958), transcript variant X3, mRNA | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 20956274 | 20956274 | PRJNA564810_S_NODE_4757_length_258_cov_1.756477_g4735_i0 | PRJNA564810 | 4757 | 258 | 1.756477 | 4.53171066 | Aplysia californica | 6500 | Mollusca | Mollusca | 84.7 | 7.52e-17 | NR | XP_005105873.1 | 6500 | g4735 | i0 | 65.6 | 3.54651162790698 | 61 | 19 | 70.9 | 2 | 255 | 73 | 489 | 547 | XP_005105873.1 digestive cysteine proteinase 1 [Aplysia californica] | diamond | 915 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 23506498 | 23506498 | PRJNA564810_S_NODE_1279_length_378_cov_12.744409_g1257_i0 | PRJNA564810 | 1279 | 378 | 12.744409 | 48.17386602 | Metazoa | 33208 | Mollusca | Mollusca | 164 | 7.24e-47 | NR | XP_052764962.1 | 6604 | g1257 | i0 | 73.3 | 13.4603174603175 | 101 | 27 | 80.2 | 0 | 373 | 71 | 234 | 334 | XP_052764962.1 cathepsin B-like [Mya arenaria] | diamond | 5088 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 23506506 | 23506506 | PRJNA564810_S_NODE_4259_length_268_cov_1.339901_g4237_i0 | PRJNA564810 | 4259 | 268 | 1.339901 | 3.59093468 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.27e-4 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g4237 | i0 | 97.059 | 0.126865671641791 | 34 | 1 | 13 | 0 | 192 | 225 | 44400296 | 44400263 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26808351 | 26808351 | PRJNA564810_S_NODE_1201_length_384_cov_13.987461_g1179_i0 | PRJNA564810 | 1201 | 384 | 13.987461 | 53.71185024 | Metazoa | 33208 | Mollusca | Mollusca | 108 | 3.04e-26 | NR | XP_052087583.1 | 6549 | g1179 | i0 | 71.2 | 7.328125 | 73 | 21 | 57 | 0 | 382 | 164 | 183 | 255 | XP_052087583.1 40S ribosomal protein S4-like isoform X1 [Mytilus californianus] | diamond | 2814 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 27504040 | 27504040 | PRJNA564810_S_NODE_5623_length_243_cov_1.269663_g5601_i0 | PRJNA564810 | 5623 | 243 | 1.269663 | 3.08528109 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.6 | 5.24e-13 | NR | XP_033726568.1 | 6579 | g5601 | i0 | 67.9 | 6.69135802469136 | 53 | 16 | 64.2 | 1 | 1 | 156 | 465 | 517 | XP_033726568.1 inositol-3-phosphate synthase 1-A-like [Pecten maximus] | diamond | 1626 | 73.9 | 0.995940460081191 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27711571 | 27711571 | PRJNA564810_S_NODE_3864_length_276_cov_2.023697_g3842_i0 | PRJNA564810 | 3864 | 276 | 2.023697 | 5.58540372 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 54.3 | 8.14e-7 | NR | XP_061169722.1 | 191078 | g3842 | i0 | 45.5 | 0.478260869565217 | 44 | 24 | 47.8 | 0 | 274 | 143 | 86 | 129 | XP_061169722.1 von Willebrand factor A domain-containing protein 5A-like [Saccostrea echinata] | diamond | 132 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 27837268 | 27837268 | PRJNA564810_S_NODE_4424_length_264_cov_1.587940_g4402_i0 | PRJNA564810 | 4424 | 264 | 1.58794 | 4.1921616 | Elysia crispata | 231223 | Mollusca | Mollusca | 53.1 | 1.05e-5 | NR | KAK3767218.1 | 231223 | g4402 | i0 | 61.9 | 0.477272727272727 | 42 | 16 | 47.7 | 0 | 55 | 180 | 533 | 574 | KAK3767218.1 hypothetical protein RRG08_018088 [Elysia crispata] | diamond | 126 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 28500589 | 28500589 | PRJNA564810_S_NODE_2787_length_305_cov_1.983333_g2765_i0 | PRJNA564810 | 2787 | 305 | 1.983333 | 6.04916565 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 61.2 | 2.46e-8 | NR | XP_041369682.1 | 1735272 | g2765 | i0 | 36.4 | 1.74098360655738 | 88 | 54 | 86.6 | 2 | 5 | 268 | 649 | 734 | XP_041369682.1 uncharacterized protein LOC121383654 [Gigantopelta aegis] | diamond | 531 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28500590 | 28500590 | PRJNA564810_S_NODE_3847_length_276_cov_3.265403_g3825_i0 | PRJNA564810 | 3847 | 276 | 3.265403 | 9.01251228 | Patella vulgata | 6465 | Mollusca | Mollusca | 68.2 | 6.12e-11 | NR | XP_050394025.1 | 6465 | g3825 | i0 | 38.2 | 2.32608695652174 | 68 | 42 | 73.9 | 0 | 251 | 48 | 489 | 556 | XP_050394025.1 neuroligin-4, X-linked [Patella vulgata] | diamond | 642 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 29258013 | 29258013 | PRJNA564810_S_NODE_789_length_433_cov_4.635870_g767_i0 | PRJNA564810 | 789 | 433 | 4.63587 | 20.0733171 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 105 | 2.2899999999999998e-23 | NR | CAC5369506.1 | 42192 | g767 | i0 | 44.5 | 1.46189376443418 | 110 | 60 | 75.5 | 1 | 50 | 376 | 476 | 585 | CAC5369506.1 TXNDC5 [Mytilus coruscus] | diamond | 633 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 29903592 | 29903592 | PRJNA564810_S_NODE_6071_length_236_cov_1.438596_g6049_i0 | PRJNA564810 | 6071 | 236 | 1.438596 | 3.39508656 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 3.98e-38 | NR | KAL5007246.1 | 13268 | g6049 | i0 | 76.9 | 20.8220338983051 | 78 | 18 | 99.2 | 0 | 235 | 2 | 15 | 92 | KAL5007246.1 hypothetical protein ScPMuIL_016052 [Solemya velum] | diamond | 4914 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 32211200 | 32211200 | PRJNA564810_S_NODE_3738_length_279_cov_1.509346_g3716_i0 | PRJNA564810 | 3738 | 279 | 1.509346 | 4.21107534 | Mollusca | 6447 | Mollusca | Mollusca | 53.9 | 2.41e-6 | NR | XP_005100682.1 | 6500 | g3716 | i0 | 65.9 | 2.90322580645161 | 41 | 14 | 44.1 | 0 | 62 | 184 | 119 | 159 | XP_005100682.1 vitamin K epoxide reductase complex subunit 1 [Aplysia californica] | diamond | 810 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 32369552 | 32369552 | PRJNA564810_S_NODE_5179_length_250_cov_2.929730_g5157_i0 | PRJNA564810 | 5179 | 250 | 2.92973 | 7.324325 | Lepetellida | 2315723 | Mollusca | Mollusca | 48.9 | 2.75e-4 | NR | XP_046546500.1 | 36100 | g5157 | i0 | 52.3 | 2.112 | 44 | 16 | 52.8 | 2 | 250 | 119 | 552 | 590 | XP_046546500.1 anti-sigma-I factor RsgI6-like [Haliotis rubra] | diamond | 528 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 32590873 | 32590873 | PRJNA564810_S_NODE_5819_length_240_cov_1.542857_g5797_i0 | PRJNA564810 | 5819 | 240 | 1.542857 | 3.7028568 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.6 | 9.61e-16 | NR | XP_062620663.1 | 36930 | g5797 | i0 | 60.3 | 11.9875 | 63 | 25 | 78.8 | 0 | 1 | 189 | 144 | 206 | XP_062620663.1 T-complex protein 1 subunit beta-like, partial [Saccostrea cuccullata] | diamond | 2877 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata |
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);;