contig_metadata
23 rows where bioproject = "PRJNA807685", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2082183 | 2082183 | PRJNA807685_P_NODE_19422_length_320_cov_8.318021_g18350_i0 | PRJNA807685 | 19422 | 320 | 8.318021 | 26.6176672 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 255 | 2.13e-63 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g18350 | i0 | 91.803 | 3.265625 | 183 | 15 | 57 | 0 | 1 | 183 | 11641070 | 11641252 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 1045 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7184873 | 7184873 | PRJNA807685_P_NODE_40766_length_192_cov_1.832258_g39693_i0 | PRJNA807685 | 40766 | 192 | 1.832258 | 3.51793536 | Lottia gigantea | 225164 | Mollusca | Mollusca | 93.5 | 9.74e-15 | NTclustered | gi|676486978|ref|XM_009065902.1| | 225164 | g39693 | i0 | 85.393 | 6.40104166666667 | 89 | 13 | 46 | 0 | 104 | 192 | 1313 | 1225 | Lottia gigantea hypothetical protein partial mRNA | blastn | 1229 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 13560394 | 13560394 | PRJNA807685_P_NODE_67531_length_150_cov_2.044248_g66458_i0 | PRJNA807685 | 67531 | 150 | 2.044248 | 3.066372 | Haliotis asinina | 109174 | Mollusca | Mollusca | 122 | 9.18e-24 | NTclustered | gi|2793383441|ref|XM_067802953.1| | 109174 | g66458 | i0 | 81.333 | 5.02666666666667 | 150 | 28 | 100 | 0 | 1 | 150 | 1539 | 1390 | PREDICTED: Haliotis asinina enolase-like (LOC137268387), mRNA | blastn | 754 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 19933294 | 19933294 | PRJNA807685_P_NODE_43676_length_185_cov_1.858108_g42603_i0 | PRJNA807685 | 43676 | 185 | 1.858108 | 3.4374998 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g42603 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 9 | 36 | 66900499 | 66900526 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26809928 | 26809928 | PRJNA807685_P_NODE_64421_length_153_cov_2.301724_g63348_i0 | PRJNA807685 | 64421 | 153 | 2.301724 | 3.52163772 | Metazoa | 33208 | Mollusca | Mollusca | 45.4 | 6.6e-4 | NR | XP_067660601.1 | 109174 | g63348 | i0 | 39.6 | 5.47058823529412 | 48 | 29 | 94.1 | 0 | 152 | 9 | 69 | 116 | XP_067660601.1 uncharacterized protein [Haliotis asinina] | diamond | 837 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 27063030 | 27063030 | PRJNA807685_P_NODE_38502_length_199_cov_1.172840_g37429_i0 | PRJNA807685 | 38502 | 199 | 1.17284 | 2.3339516 | Metazoa | 33208 | Mollusca | Mollusca | 45.8 | 0.0017 | NR | XP_053403435.1 | 6596 | g37429 | i0 | 76 | 3.39195979899498 | 25 | 6 | 37.7 | 0 | 77 | 3 | 2091 | 2115 | XP_053403435.1 myosin-VIIa-like isoform X4 [Mercenaria mercenaria] | diamond | 675 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27157526 | 27157526 | PRJNA807685_P_NODE_24542_length_270_cov_1.321888_g23469_i0 | PRJNA807685 | 24542 | 270 | 1.321888 | 3.5690976 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00428 | NR | XP_046346459.2 | 6454 | g23469 | i0 | 48.7 | 1.23333333333333 | 39 | 20 | 43.3 | 0 | 266 | 150 | 145 | 183 | XP_046346459.2 transient receptor potential cation channel subfamily A member 1 homolog isoform X2 [Haliotis rufescens] | diamond | 333 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27180372 | 27180372 | PRJNA807685_P_NODE_51102_length_171_cov_1.149254_g50029_i0 | PRJNA807685 | 51102 | 171 | 1.149254 | 1.96522434 | Physella acuta | 109671 | Mollusca | Mollusca | 42 | 0.0205 | NR | XP_059170503.1 | 109671 | g50029 | i0 | 43.6 | 0.684210526315789 | 39 | 22 | 68.4 | 0 | 48 | 164 | 80 | 118 | XP_059170503.1 uncharacterized protein LOC131952050 isoform X3 [Physella acuta] | diamond | 117 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 27496654 | 27496654 | PRJNA807685_P_NODE_40123_length_194_cov_1.458599_g39050_i0 | PRJNA807685 | 40123 | 194 | 1.458599 | 2.82968206 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 81.3 | 1.52e-16 | NR | XP_055888605.1 | 6526 | g39050 | i0 | 69.2 | 3.03092783505155 | 65 | 19 | 99 | 1 | 193 | 2 | 15 | 79 | XP_055888605.1 3-oxoacyl-[acyl-carrier-protein] reductase FabG-like [Biomphalaria glabrata] | diamond | 588 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27717998 | 27717998 | PRJNA807685_P_NODE_39084_length_197_cov_1.512500_g38011_i0 | PRJNA807685 | 39084 | 197 | 1.5125 | 2.979625 | Argopecten irradians | 31199 | Mollusca | Mollusca | 46.6 | 8.95e-4 | NR | XP_069108566.1 | 31199 | g38011 | i0 | 65.5 | 0.441624365482233 | 29 | 10 | 44.2 | 0 | 16 | 102 | 330 | 358 | XP_069108566.1 zinc finger protein 493-like [Argopecten irradians] | diamond | 87 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27821341 | 27821341 | PRJNA807685_P_NODE_44344_length_184_cov_1.054422_g43271_i0 | PRJNA807685 | 44344 | 184 | 1.054422 | 1.94013648 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.7 | 0.0034 | NR | XP_046368000.2 | 6454 | g43271 | i0 | 65.2 | 3.79891304347826 | 23 | 8 | 37.5 | 0 | 6 | 74 | 134 | 156 | XP_046368000.2 protein PIF-like [Haliotis rufescens] | diamond | 699 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 28001910 | 28001910 | PRJNA807685_P_NODE_64665_length_153_cov_1.603448_g63592_i0 | PRJNA807685 | 64665 | 153 | 1.603448 | 2.45327544 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 44.3 | 0.00308 | NR | VDI18523.1 | 29158 | g63592 | i0 | 55.2 | 2.74509803921569 | 29 | 13 | 56.9 | 0 | 41 | 127 | 331 | 359 | VDI18523.1 Hypothetical predicted protein, partial [Mytilus galloprovincialis] | diamond | 420 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28380615 | 28380615 | PRJNA807685_P_NODE_34186_length_214_cov_2.000000_g33113_i0 | PRJNA807685 | 34186 | 214 | 2 | 4.28 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 49.3 | 1.23e-4 | NR | KAK3605341.1 | 2493646 | g33113 | i0 | 35.9 | 0.897196261682243 | 64 | 40 | 88.3 | 1 | 189 | 1 | 74 | 137 | KAK3605341.1 hypothetical protein CHS0354_033830 [Potamilus streckersoni] | diamond | 192 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 28989666 | 28989666 | PRJNA807685_P_NODE_27468_length_249_cov_1.834906_g26395_i0 | PRJNA807685 | 27468 | 249 | 1.834906 | 4.56891594 | Mollusca | 6447 | Mollusca | Mollusca | 70.5 | 6.36e-12 | NR | XP_048256961.1 | 6454 | g26395 | i0 | 42.3 | 5.20481927710843 | 78 | 43 | 94 | 1 | 248 | 15 | 210 | 285 | XP_048256961.1 uncharacterized protein LOC125382710 [Haliotis rufescens] | diamond | 1296 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29106943 | 29106943 | PRJNA807685_P_NODE_41928_length_189_cov_2.019737_g40855_i0 | PRJNA807685 | 41928 | 189 | 2.019737 | 3.81730293 | Patella caerulea | 87958 | Mollusca | Mollusca | 68.9 | 1.09e-11 | NR | KAK6172537.1 | 87958 | g40855 | i0 | 43.9 | 1.80952380952381 | 57 | 32 | 90.5 | 0 | 19 | 189 | 931 | 987 | KAK6172537.1 hypothetical protein SNE40_016172 [Patella caerulea] | diamond | 342 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 29210584 | 29210584 | PRJNA807685_P_NODE_47709_length_177_cov_1.107143_g46636_i0 | PRJNA807685 | 47709 | 177 | 1.107143 | 1.95964311 | Metazoa | 33208 | Mollusca | Mollusca | 82.4 | 1.51e-16 | NR | XP_021370774.1 | 6573 | g46636 | i0 | 63.6 | 2.77966101694915 | 55 | 20 | 93.2 | 0 | 9 | 173 | 225 | 279 | XP_021370774.1 dolichyl pyrophosphate Man9GlcNAc2 alpha-1,3-glucosyltransferase-like [Mizuhopecten yessoensis] | diamond | 492 | 82.8 | 0.995169082125604 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 29769767 | 29769767 | PRJNA807685_P_NODE_56151_length_163_cov_1.706349_g55078_i0 | PRJNA807685 | 56151 | 163 | 1.706349 | 2.78134887 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 59.7 | 1.24e-8 | NR | XP_053376867.1 | 6596 | g55078 | i0 | 55.6 | 0.993865030674847 | 54 | 21 | 99.4 | 1 | 162 | 1 | 62 | 112 | XP_053376867.1 uncharacterized protein LOC128547753 [Mercenaria mercenaria] | diamond | 162 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30622745 | 30622745 | PRJNA807685_P_NODE_59293_length_159_cov_1.647541_g58220_i0 | PRJNA807685 | 59293 | 159 | 1.647541 | 2.61959019 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 60.1 | 6.95e-9 | NR | CAC5425311.1 | 42192 | g58220 | i0 | 55.1 | 6.9622641509434 | 49 | 17 | 83 | 1 | 134 | 3 | 1 | 49 | CAC5425311.1 unnamed protein product [Mytilus coruscus] | diamond | 1107 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 31421873 | 31421873 | PRJNA807685_P_NODE_45976_length_180_cov_1.643357_g44903_i0 | PRJNA807685 | 45976 | 180 | 1.643357 | 2.9580426 | Metazoa | 33208 | Mollusca | Mollusca | 50.8 | 2.13e-5 | NR | XP_050402161.1 | 6465 | g44903 | i0 | 45.6 | 1.53333333333333 | 57 | 27 | 88.3 | 1 | 9 | 167 | 96 | 152 | XP_050402161.1 zinc finger protein 239-like isoform X1 [Patella vulgata] | diamond | 276 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32077296 | 32077296 | PRJNA807685_P_NODE_47638_length_177_cov_1.292857_g46565_i0 | PRJNA807685 | 47638 | 177 | 1.292857 | 2.28835689 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 50.1 | 4.11e-5 | NR | KAK3106842.1 | 66713 | g46565 | i0 | 57.1 | 1.1864406779661 | 35 | 15 | 59.3 | 0 | 177 | 73 | 370 | 404 | KAK3106842.1 hypothetical protein FSP39_001047 [Pinctada imbricata] | diamond | 210 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 32425407 | 32425407 | PRJNA807685_P_NODE_53999_length_166_cov_1.697674_g52926_i0 | PRJNA807685 | 53999 | 166 | 1.697674 | 2.81813884 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 44.3 | 0.00365 | NR | KAK3605335.1 | 2493646 | g52926 | i0 | 42 | 1.80722891566265 | 50 | 26 | 90.4 | 1 | 15 | 164 | 99 | 145 | KAK3605335.1 hypothetical protein CHS0354_033824 [Potamilus streckersoni] | diamond | 300 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 32425411 | 32425411 | PRJNA807685_P_NODE_62479_length_155_cov_2.618644_g61406_i0 | PRJNA807685 | 62479 | 155 | 2.618644 | 4.0588982 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 57.8 | 5.53e-8 | NR | XP_062571238.1 | 36930 | g61406 | i0 | 47.1 | 4.93548387096774 | 51 | 27 | 98.7 | 0 | 155 | 3 | 549 | 599 | XP_062571238.1 uncharacterized protein K02A2.6-like [Saccostrea cuccullata] | diamond | 765 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 32812629 | 32812629 | PRJNA807685_P_NODE_35780_length_208_cov_1.578947_g34707_i0 | PRJNA807685 | 35780 | 208 | 1.578947 | 3.28420976 | Metazoa | 33208 | Mollusca | Mollusca | 45.1 | 0.00347 | NR | XP_065941144.1 | 29159 | g34707 | i0 | 51.6 | 4.47115384615385 | 31 | 15 | 44.7 | 0 | 116 | 24 | 59 | 89 | XP_065941144.1 parathyroid hormone/parathyroid hormone-related peptide receptor [Magallana gigas] | diamond | 930 | 45.4 | 0.993392070484582 | 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);;