contig_metadata
22 rows where bioproject = "PRJNA760976", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5033310 | 5033310 | PRJNA760976_P_NODE_51944_length_245_cov_0.895349_g51623_i0 | PRJNA760976 | 51944 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|1897945107|ref|XM_035973584.1| | 6500 | g51623 | i0 | 100 | 8.03265306122449 | 30 | 0 | 12 | 0 | 59 | 88 | 856 | 885 | PREDICTED: Aplysia californica nuclear receptor corepressor 2 (LOC101853904), partial mRNA | blastn | 1968 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 7121129 | 7121129 | PRJNA760976_P_NODE_36846_length_280_cov_1.772947_g36525_i0 | PRJNA760976 | 36846 | 280 | 1.772947 | 4.9642516 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 139 | 6.25e-40 | NR | XP_060589897.1 | 129788 | g36525 | i0 | 76.1 | 1.875 | 88 | 21 | 94.3 | 0 | 16 | 279 | 11 | 98 | XP_060589897.1 eukaryotic translation initiation factor 5A-1-like [Ruditapes philippinarum] | diamond | 525 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 10946439 | 10946439 | PRJNA760976_P_NODE_20869_length_344_cov_1.184502_g20548_i0 | PRJNA760976 | 20869 | 344 | 1.184502 | 4.07468688 | Metazoa | 33208 | Mollusca | Mollusca | 160 | 1.66e-47 | NR | XP_064597479.1 | 13599 | g20548 | i0 | 75 | 22.5959302325581 | 112 | 28 | 97.7 | 0 | 3 | 338 | 52 | 163 | XP_064597479.1 large ribosomal subunit protein eL19-like [Liolophura japonica] | diamond | 7773 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 13496080 | 13496080 | PRJNA760976_P_NODE_16451_length_373_cov_2.630000_g16130_i0 | PRJNA760976 | 16451 | 373 | 2.63 | 9.8099 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 113 | 1.6e-20 | NTclustered | gi|2034271035|ref|XR_005960499.1| | 1735272 | g16130 | i0 | 79.096 | 7.2627345844504 | 177 | 27 | 47 | 8 | 192 | 365 | 3686 | 3517 | PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA | blastn | 2709 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 19056780 | 19056780 | PRJNA760976_P_NODE_38395_length_276_cov_1.408867_g38074_i0 | PRJNA760976 | 38395 | 276 | 1.408867 | 3.88847292 | Metazoa | 33208 | Mollusca | Mollusca | 152 | 2.43e-32 | NTclustered | gi|449139007|gb|KC161208.1| | 36095 | g38074 | i0 | 87.692 | 50.8949275362319 | 130 | 16 | 47 | 0 | 122 | 251 | 266 | 137 | Haliotis diversicolor heat shock protein 90 mRNA, complete cds | blastn | 14047 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis diversicolor | |
| 22419643 | 22419643 | PRJNA760976_P_NODE_25898_length_319_cov_0.841463_g25577_i0 | PRJNA760976 | 25898 | 319 | 0.841463 | 2.68426697 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 58.4 | 6.43e-4 | NTclustered | gi|1397715626|ref|XM_025249024.1| | 400727 | g25577 | i0 | 100 | 12.1065830721003 | 31 | 0 | 10 | 0 | 234 | 264 | 4023 | 4053 | PREDICTED: Pomacea canaliculata homeobox protein otx5-A-like (LOC112570536), transcript variant X4, mRNA | blastn | 3862 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 23695282 | 23695282 | PRJNA760976_P_NODE_24899_length_323_cov_1.392000_g24578_i0 | PRJNA760976 | 24899 | 323 | 1.392 | 4.49616 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 174 | 6.2e-39 | NTclustered | gi|1207980183|ref|XM_021483941.1| | 6573 | g24578 | i0 | 78.598 | 1.80185758513932 | 271 | 52 | 83 | 4 | 40 | 306 | 395 | 127 | PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L3-B-like (LOC110440810), mRNA | blastn | 582 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 24968946 | 24968946 | PRJNA760976_P_NODE_22880_length_333_cov_0.819231_g22559_i0 | PRJNA760976 | 22880 | 333 | 0.819231 | 2.72803923 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 155 | 3.71e-46 | NR | XP_025086345.1 | 400727 | g22559 | i0 | 66.4 | 4.85585585585586 | 107 | 36 | 96.4 | 0 | 322 | 2 | 1 | 107 | XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata] | diamond | 1617 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 27337715 | 27337715 | PRJNA760976_P_NODE_12603_length_411_cov_1.781065_g12283_i0 | PRJNA760976 | 12603 | 411 | 1.781065 | 7.32017715 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 45.1 | 0.00782 | NR | VDI71037.1 | 29158 | g12283 | i0 | 29 | 0.72992700729927 | 100 | 61 | 71.5 | 4 | 387 | 94 | 27 | 118 | VDI71037.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 300 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28862737 | 28862737 | PRJNA760976_P_NODE_34368_length_288_cov_1.041860_g34047_i0 | PRJNA760976 | 34368 | 288 | 1.04186 | 3.0005568 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 98.2 | 1.08e-21 | NR | XP_022332183.1 | 6565 | g34047 | i0 | 49.5 | 4.92708333333333 | 97 | 42 | 97.9 | 3 | 3 | 284 | 313 | 405 | XP_022332183.1 elongation factor 1-gamma-like [Crassostrea virginica] | diamond | 1419 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 29105945 | 29105945 | PRJNA760976_P_NODE_22068_length_337_cov_1.454545_g21747_i0 | PRJNA760976 | 22068 | 337 | 1.454545 | 4.90181665 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 128 | 5.95e-34 | NR | KAK7485198.1 | 370345 | g21747 | i0 | 52.7 | 1.95845697329377 | 110 | 52 | 97.9 | 0 | 3 | 332 | 126 | 235 | KAK7485198.1 hypothetical protein BaRGS_00023608 [Batillaria attramentaria] | diamond | 660 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29768738 | 29768738 | PRJNA760976_P_NODE_36171_length_282_cov_1.555024_g35850_i0 | PRJNA760976 | 36171 | 282 | 1.555024 | 4.38516768 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 44.3 | 0.0162 | NR | CAC5382961.1 | 42192 | g35850 | i0 | 32.4 | 0.787234042553192 | 74 | 49 | 78.7 | 1 | 277 | 56 | 258 | 330 | CAC5382961.1 unnamed protein product [Mytilus coruscus] | diamond | 222 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 30084586 | 30084586 | PRJNA760976_P_NODE_49232_length_249_cov_0.863636_g48911_i0 | PRJNA760976 | 49232 | 249 | 0.863636 | 2.15045364 | Lottia gigantea | 225164 | Mollusca | Mollusca | 79 | 7.19e-15 | NR | XP_009057887.1 | 225164 | g48911 | i0 | 49.3 | 0.903614457831325 | 75 | 38 | 90.4 | 0 | 242 | 18 | 987 | 1061 | XP_009057887.1 hypothetical protein LOTGIDRAFT_153611 [Lottia gigantea] | diamond | 225 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 30379139 | 30379139 | PRJNA760976_P_NODE_25272_length_321_cov_2.133065_g24951_i0 | PRJNA760976 | 25272 | 321 | 2.133065 | 6.84713865 | Pectinidae | 6566 | Mollusca | Mollusca | 101 | 9.35e-24 | NR | OWF38638.1 | 6573 | g24951 | i0 | 66.7 | 1.99065420560748 | 66 | 22 | 61.7 | 0 | 123 | 320 | 48 | 113 | OWF38638.1 Countin-1 [Mizuhopecten yessoensis] | diamond | 639 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30432649 | 30432649 | PRJNA760976_P_NODE_23113_length_331_cov_1.724806_g22792_i0 | PRJNA760976 | 23113 | 331 | 1.724806 | 5.70910786 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 89 | 1.34e-19 | NR | KAK3606436.1 | 2493646 | g22792 | i0 | 48.6 | 2.23867069486405 | 109 | 54 | 98.8 | 1 | 327 | 1 | 5 | 111 | KAK3606436.1 hypothetical protein CHS0354_041377 [Potamilus streckersoni] | diamond | 741 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 30558446 | 30558446 | PRJNA760976_P_NODE_28213_length_309_cov_1.457627_g27892_i0 | PRJNA760976 | 28213 | 309 | 1.457627 | 4.50406743 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 56.2 | 3.75e-7 | NR | XP_045191035.2 | 6596 | g27892 | i0 | 38 | 0.970873786407767 | 100 | 45 | 97.1 | 4 | 303 | 4 | 59 | 141 | XP_045191035.2 perlucin-like protein [Mercenaria mercenaria] | diamond | 300 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31064415 | 31064415 | PRJNA760976_P_NODE_9535_length_458_cov_1.168831_g9216_i0 | PRJNA760976 | 9535 | 458 | 1.168831 | 5.35324598 | Elysia crispata | 231223 | Mollusca | Mollusca | 45.8 | 0.0217 | NR | KAK3795005.1 | 231223 | g9216 | i0 | 37.3 | 0.982532751091703 | 75 | 44 | 47.2 | 1 | 19 | 234 | 151 | 225 | KAK3795005.1 hypothetical protein RRG08_019770 [Elysia crispata] | diamond | 450 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 31348825 | 31348825 | PRJNA760976_P_NODE_44416_length_260_cov_1.176471_g44095_i0 | PRJNA760976 | 44416 | 260 | 1.176471 | 3.0588246 | Solemya velum | 13268 | Mollusca | Mollusca | 124 | 2.3499999999999998e-32 | NR | KAL5013675.1 | 13268 | g44095 | i0 | 69.8 | 2.97692307692308 | 86 | 26 | 99.2 | 0 | 259 | 2 | 175 | 260 | KAL5013675.1 hypothetical protein ScPMuIL_007945 [Solemya velum] | diamond | 774 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 32149328 | 32149328 | PRJNA760976_P_NODE_9838_length_452_cov_2.139842_g9519_i0 | PRJNA760976 | 9838 | 452 | 2.139842 | 9.67208584 | Mollusca | 6447 | Mollusca | Mollusca | 218 | 2.29e-69 | NR | XP_070177131.1 | 31220 | g9519 | i0 | 70.1 | 10.5066371681416 | 147 | 42 | 97.6 | 1 | 446 | 6 | 13 | 157 | XP_070177131.1 small ribosomal subunit protein uS7 [Littorina saxatilis] | diamond | 4749 | 218 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 32180989 | 32180989 | PRJNA760976_P_NODE_37858_length_277_cov_1.926471_g37537_i0 | PRJNA760976 | 37858 | 277 | 1.926471 | 5.33632467 | Mytilus | 6548 | Mollusca | Mollusca | 68.9 | 3.56e-11 | NR | CAG2198421.1 | 6550 | g37537 | i0 | 36.6 | 3.02166064981949 | 93 | 57 | 98.6 | 1 | 277 | 5 | 826 | 918 | CAG2198421.1 CYFIP [Mytilus edulis] | diamond | 837 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32244475 | 32244475 | PRJNA760976_P_NODE_25698_length_319_cov_2.195122_g25377_i0 | PRJNA760976 | 25698 | 319 | 2.195122 | 7.00243918 | Bivalvia | 6544 | Mollusca | Mollusca | 128 | 1.1599999999999999e-34 | NR | WAR00266.1 | 6604 | g25377 | i0 | 66.3 | 55.166144200627 | 104 | 30 | 97.8 | 1 | 312 | 1 | 77 | 175 | WAR00266.1 RL17-like protein, partial [Mya arenaria] | diamond | 17598 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32519490 | 32519490 | PRJNA760976_P_NODE_8379_length_481_cov_2.595588_g8060_i0 | PRJNA760976 | 8379 | 481 | 2.595588 | 12.48477828 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 94 | 2.72e-21 | NR | KAH3866887.1 | 45954 | g8060 | i0 | 57.7 | 0.442827442827443 | 71 | 30 | 44.3 | 0 | 264 | 52 | 60 | 130 | KAH3866887.1 hypothetical protein DPMN_030010 [Dreissena polymorpha] | diamond | 213 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha |
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);;