contig_metadata
19 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 960718 | 960718 | PRJNA980839_P_NODE_99761_length_363_cov_1.324138_g95977_i0 | PRJNA980839 | 99761 | 363 | 1.324138 | 4.80662094 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 93.5 | 2.03e-14 | NTclustered | gi|2442016429|ref|XR_008367939.1| | 6596 | g95977 | i0 | 98.113 | 84.129476584022 | 53 | 1 | 15 | 0 | 311 | 363 | 1096 | 1148 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123541009 (LOC123541009), ncRNA | blastn | 30539 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 6061905 | 6061905 | PRJNA980839_P_NODE_209465_length_248_cov_0.880000_g205681_i0 | PRJNA980839 | 209465 | 248 | 0.88 | 2.1824 | Mytilus californianus | 6549 | Mollusca | Mollusca | 58.4 | 4.82e-4 | NTclustered | gi|2334651268|ref|XM_052230318.1| | 6549 | g205681 | i0 | 92.5 | 0.161290322580645 | 40 | 3 | 16 | 0 | 135 | 174 | 189 | 150 | PREDICTED: Mytilus californianus uncharacterized LOC127723618 (LOC127723618), mRNA | blastn | 40 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 8611943 | 8611943 | PRJNA980839_P_NODE_229727_length_243_cov_0.905882_g225943_i0 | PRJNA980839 | 229727 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g225943 | i0 | 100 | 0.119341563786008 | 29 | 0 | 12 | 0 | 159 | 187 | 1436319 | 1436291 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9886708 | 9886708 | PRJNA980839_P_NODE_209608_length_248_cov_0.880000_g205824_i0 | PRJNA980839 | 209608 | 248 | 0.88 | 2.1824 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g205824 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 85 | 112 | 1064979 | 1064952 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17535343 | 17535343 | PRJNA980839_P_NODE_149394_length_287_cov_3.971963_g145610_i0 | PRJNA980839 | 149394 | 287 | 3.971963 | 11.39953381 | Elysia crispata | 231223 | Mollusca | Mollusca | 531 | 2.799999999999999e-146 | NTclustered | gi|2634110168|emb|OY973781.1| | 231223 | g145610 | i0 | 100 | 4.39024390243902 | 287 | 0 | 100 | 0 | 1 | 287 | 8385 | 8671 | Elysia crispata genome assembly, organelle: mitochondrion | blastn | 1260 | 531 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 18808743 | 18808743 | PRJNA980839_P_NODE_124155_length_318_cov_1.608163_g120371_i0 | PRJNA980839 | 124155 | 318 | 1.608163 | 5.11395834 | Elysia crispata | 231223 | Mollusca | Mollusca | 582 | 8.549999999999998e-162 | NTclustered | gi|2634110168|emb|OY973781.1| | 231223 | g120371 | i0 | 99.686 | 53.9591194968553 | 318 | 1 | 100 | 0 | 1 | 318 | 13155 | 13472 | Elysia crispata genome assembly, organelle: mitochondrion | blastn | 17159 | 582 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 20084456 | 20084456 | PRJNA980839_P_NODE_176656_length_265_cov_1.604167_g172872_i0 | PRJNA980839 | 176656 | 265 | 1.604167 | 4.25104255 | Elysia crispata | 231223 | Mollusca | Mollusca | 118 | 4.08e-31 | NR | KAK3759322.1 | 231223 | g172872 | i0 | 70.7 | 9.50943396226415 | 75 | 22 | 84.9 | 0 | 231 | 7 | 30 | 104 | KAK3759322.1 hypothetical protein RRG08_013707 [Elysia crispata] | diamond | 2520 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 20086249 | 20086249 | PRJNA980839_P_NODE_48836_length_618_cov_6.196330_g45105_i0 | PRJNA980839 | 48836 | 618 | 6.19633 | 38.2933194 | Elysia crispata | 231223 | Mollusca | Mollusca | 1125 | 0 | NTclustered | gi|2634110168|emb|OY973781.1| | 231223 | g45105 | i0 | 99.515 | 72.5388349514563 | 618 | 3 | 100 | 0 | 1 | 618 | 8644 | 9261 | Elysia crispata genome assembly, organelle: mitochondrion | blastn | 44829 | 1125 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 22634246 | 22634246 | PRJNA980839_P_NODE_136198_length_302_cov_1.344978_g132414_i0 | PRJNA980839 | 136198 | 302 | 1.344978 | 4.06183356 | Elysia marginata | 1093978 | Mollusca | Mollusca | 179 | 8.76e-56 | NR | GFR81435.1 | 1093978 | g132414 | i0 | 97 | 0.983443708609272 | 99 | 3 | 98.3 | 0 | 297 | 1 | 37 | 135 | GFR81435.1 endothelial differentiation-related factor 1 [Elysia marginata] | diamond | 297 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 27063903 | 27063903 | PRJNA980839_P_NODE_124682_length_317_cov_2.192623_g120898_i0 | PRJNA980839 | 124682 | 317 | 2.192623 | 6.95061491 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 181 | 3.64e-56 | NR | XP_053393208.1 | 6596 | g120898 | i0 | 83.7 | 12.0567823343849 | 98 | 16 | 92.7 | 0 | 312 | 19 | 4 | 101 | XP_053393208.1 peptidyl-prolyl cis-trans isomerase-like isoform X2 [Mercenaria mercenaria] | diamond | 3822 | 182 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27374270 | 27374270 | PRJNA980839_P_NODE_229783_length_243_cov_0.905882_g225999_i0 | PRJNA980839 | 229783 | 243 | 0.905882 | 2.20129326 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 46.2 | 0.00217 | NR | XP_045194633.2 | 6596 | g225999 | i0 | 58.3 | 0.444444444444444 | 36 | 15 | 44.4 | 0 | 26 | 133 | 87 | 122 | XP_045194633.2 BTB/POZ domain-containing protein 9-like [Mercenaria mercenaria] | diamond | 108 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27595094 | 27595094 | PRJNA980839_P_NODE_160604_length_278_cov_1.346341_g156820_i0 | PRJNA980839 | 160604 | 278 | 1.346341 | 3.74282798 | Patella caerulea | 87958 | Mollusca | Mollusca | 91.3 | 5.05e-19 | NR | KAK6178710.1 | 87958 | g156820 | i0 | 63.9 | 0.658273381294964 | 61 | 22 | 65.8 | 0 | 264 | 82 | 318 | 378 | KAK6178710.1 hypothetical protein SNE40_011231 [Patella caerulea] | diamond | 183 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28826100 | 28826100 | PRJNA980839_P_NODE_161628_length_277_cov_1.509804_g157844_i0 | PRJNA980839 | 161628 | 277 | 1.509804 | 4.18215708 | Elysia crispata | 231223 | Mollusca | Mollusca | 129 | 5.36e-33 | NR | KAK3777224.1 | 231223 | g157844 | i0 | 100 | 0.714801444043321 | 66 | 0 | 71.5 | 0 | 1 | 198 | 458 | 523 | KAK3777224.1 hypothetical protein RRG08_047844 [Elysia crispata] | diamond | 198 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 30531722 | 30531722 | PRJNA980839_P_NODE_226453_length_244_cov_0.900585_g222669_i0 | PRJNA980839 | 226453 | 244 | 0.900585 | 2.1974274 | Elysia crispata | 231223 | Mollusca | Mollusca | 163 | 1.09e-49 | NR | KAK3792339.1 | 231223 | g222669 | i0 | 100 | 0.971311475409836 | 79 | 0 | 97.1 | 0 | 8 | 244 | 32 | 110 | KAK3792339.1 hypothetical protein RRG08_046648 [Elysia crispata] | diamond | 237 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 31100356 | 31100356 | PRJNA980839_P_NODE_214735_length_247_cov_0.885057_g210951_i0 | PRJNA980839 | 214735 | 247 | 0.885057 | 2.18609079 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 44.3 | 0.011 | NR | KAK3096760.1 | 66713 | g210951 | i0 | 52.6 | 1.84615384615385 | 38 | 18 | 46.2 | 0 | 245 | 132 | 162 | 199 | KAK3096760.1 hypothetical protein FSP39_003001 [Pinctada imbricata] | diamond | 456 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 31416699 | 31416699 | PRJNA980839_P_NODE_159436_length_279_cov_1.320388_g155652_i0 | PRJNA980839 | 159436 | 279 | 1.320388 | 3.68388252 | Elysia crispata | 231223 | Mollusca | Mollusca | 165 | 9.499999999999999e-48 | NR | KAK3802587.1 | 231223 | g155652 | i0 | 81.5 | 0.989247311827957 | 92 | 17 | 98.9 | 0 | 2 | 277 | 120 | 211 | KAK3802587.1 hypothetical protein RRG08_027217 [Elysia crispata] | diamond | 276 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 31669685 | 31669685 | PRJNA980839_P_NODE_242017_length_236_cov_2.147239_g238233_i0 | PRJNA980839 | 242017 | 236 | 2.147239 | 5.06748404 | Elysia crispata | 231223 | Mollusca | Mollusca | 61.6 | 6.66e-10 | NR | KAK3762271.1 | 231223 | g238233 | i0 | 100 | 0.343220338983051 | 27 | 0 | 34.3 | 0 | 1 | 81 | 102 | 128 | KAK3762271.1 hypothetical protein RRG08_005536 [Elysia crispata] | diamond | 81 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 32555926 | 32555926 | PRJNA980839_P_NODE_236299_length_241_cov_1.833333_g232515_i0 | PRJNA980839 | 236299 | 241 | 1.833333 | 4.41833253 | Elysia crispata | 231223 | Mollusca | Mollusca | 160 | 1.43e-45 | NR | KAK3748152.1 | 231223 | g232515 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 1 | 240 | 139 | 218 | KAK3748152.1 hypothetical protein RRG08_062484 [Elysia crispata] | diamond | 240 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 32907946 | 32907946 | PRJNA980839_P_NODE_183300_length_260_cov_2.005348_g179516_i0 | PRJNA980839 | 183300 | 260 | 2.005348 | 5.2139048 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 2.97e-22 | NR | XP_064610646.1 | 13599 | g179516 | i0 | 62.5 | 2.67692307692308 | 72 | 26 | 83.1 | 1 | 260 | 45 | 413 | 483 | XP_064610646.1 uncharacterized protein LOC135474904 isoform X1 [Liolophura japonica] | diamond | 696 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica |
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);;