contig_metadata
15 rows where bioproject = "PRJNA1248471" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1628343 | 1628343 | PRJNA1248471_S_NODE_1762_length_343_cov_13.380952_g1662_i0 | PRJNA1248471 | 1762 | 343 | 13.380952 | 45.89666536 | Optediceros sp. h HC-2024 | 3127693 | Mollusca | Mollusca | 124 | 6.779999999999998e-24 | NTclustered | gi|2695323868|gb|PP438319.1| | 3127693 | g1662 | i0 | 93.103 | 61.4810495626822 | 87 | 2 | 59 | 4 | 139 | 223 | 153 | 69 | Optediceros sp. h HC-2024 mitochondrion, complete genome | blastn | 21088 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Assimineidae | Optediceros | Optediceros sp. h HC-2024 | |
| 11832190 | 11832190 | PRJNA1248471_S_NODE_19070_length_166_cov_0.871795_g18970_i0 | PRJNA1248471 | 19070 | 166 | 0.871795 | 1.4471797 | Acharax johnsoni | 1825698 | Mollusca | Mollusca | 78.7 | 2.29e-10 | NTclustered | gi|1211814511|dbj|LC186956.1| | 1825698 | g18970 | i0 | 95.833 | 15.4156626506024 | 48 | 2 | 29 | 0 | 24 | 71 | 1021 | 974 | Acharax johnsoni gene for 18S rRNA, partial sequence, isolate: AJK1-1 | blastn | 2559 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Acharax | Acharax johnsoni | |
| 11832221 | 11832221 | PRJNA1248471_S_NODE_22530_length_161_cov_0.964286_g22430_i0 | PRJNA1248471 | 22530 | 161 | 0.964286 | 1.55250046 | Lymnaea stagnalis | 6523 | Mollusca | Mollusca | 143 | 7.72e-30 | NTclustered | gi|354951471|emb|FR797823.1| | 6523 | g22430 | i0 | 84.106 | 22.2608695652174 | 151 | 18 | 92 | 3 | 14 | 161 | 491 | 638 | Lymnaea stagnalis partial 18S rRNA gene, specimen voucher MTD Moll 53109 | blastn | 3584 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 11832225 | 11832225 | PRJNA1248471_S_NODE_22710_length_161_cov_0.857143_g22610_i0 | PRJNA1248471 | 22710 | 161 | 0.857143 | 1.38000023 | Dentaliidae sp. | 3041381 | Mollusca | Mollusca | 134 | 4.64e-27 | NTclustered | gi|2490667076|gb|ON257236.1| | 3041381 | g22610 | i0 | 91.667 | 14.6770186335404 | 96 | 8 | 60 | 0 | 66 | 161 | 385 | 290 | Dentaliidae sp. voucher NH005 28S ribosomal RNA gene, partial sequence | blastn | 2363 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Scaphopoda | Dentaliida | Dentaliidae | Dentaliidae sp. | ||
| 13107612 | 13107612 | PRJNA1248471_S_NODE_9251_length_207_cov_1.531646_g9151_i0 | PRJNA1248471 | 9251 | 207 | 1.531646 | 3.17050722 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g9151 | i0 | 100 | 0.975845410628019 | 30 | 0 | 14 | 0 | 161 | 190 | 17491731 | 17491702 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 202 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15656686 | 15656686 | PRJNA1248471_S_NODE_8913_length_209_cov_0.831250_g8813_i0 | PRJNA1248471 | 8913 | 209 | 0.83125 | 1.7373125 | Mytilus californianus | 6549 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|2334775074|ref|XM_052212379.1| | 6549 | g8813 | i0 | 100 | 0.401913875598086 | 28 | 0 | 13 | 0 | 100 | 127 | 5707 | 5680 | PREDICTED: Mytilus californianus bifunctional heparan sulfate N-deacetylase/N-sulfotransferase-like (LOC127707701), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 16930850 | 16930850 | PRJNA1248471_S_NODE_19074_length_166_cov_0.871795_g18974_i0 | PRJNA1248471 | 19074 | 166 | 0.871795 | 1.4471797 | Xylonora atlantica | 183507 | Mollusca | Mollusca | 111 | 2.26e-20 | NTclustered | gi|1934841720|emb|LR899378.1| | 183507 | g18974 | i0 | 82.812 | 0.771084337349398 | 128 | 18 | 76 | 3 | 41 | 166 | 19 | 144 | Xylophaga atlantica partial 18S rRNA gene, isolate X_atl_LFC_74_18S | blastn | 128 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Xylophagaidae | Xylonora | Xylonora atlantica | |
| 19479632 | 19479632 | PRJNA1248471_S_NODE_16756_length_173_cov_0.709677_g16656_i0 | PRJNA1248471 | 16756 | 173 | 0.709677 | 1.22774121 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g16656 | i0 | 94.286 | 0.404624277456647 | 35 | 1 | 20 | 1 | 79 | 113 | 48332940 | 48332907 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 70 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20755211 | 20755211 | PRJNA1248471_S_NODE_917_length_401_cov_1006.616477_g835_i0 | PRJNA1248471 | 917 | 401 | 1006.616477 | 4036.53207277 | Optediceros sp. h HC-2024 | 3127693 | Mollusca | Mollusca | 124 | 8.029999999999999e-24 | NTclustered | gi|2695323868|gb|PP438319.1| | 3127693 | g835 | i0 | 93.023 | 66.3241895261845 | 86 | 4 | 58 | 2 | 114 | 197 | 154 | 69 | Optediceros sp. h HC-2024 mitochondrion, complete genome | blastn | 26596 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Assimineidae | Optediceros | Optediceros sp. h HC-2024 | |
| 22030293 | 22030293 | PRJNA1248471_S_NODE_13178_length_189_cov_0.900000_g13078_i0 | PRJNA1248471 | 13178 | 189 | 0.9 | 1.701 | Xylonora sp. ACRb | 3022217 | Mollusca | Mollusca | 93.5 | 9.56e-15 | NTclustered | gi|1934841696|emb|LR899414.1| | 3022217 | g13078 | i0 | 91.176 | 12.0952380952381 | 68 | 6 | 36 | 0 | 38 | 105 | 728 | 795 | Xylophagaidae sp. 2 MW-2020 partial 18S rRNA gene, isolate X_Rainbow63_18S | blastn | 2286 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Xylophagaidae | Xylonora | Xylonora sp. ACRb | |
| 22728867 | 22728867 | PRJNA1248471_S_NODE_7878_length_217_cov_0.732143_g7778_i0 | PRJNA1248471 | 7878 | 217 | 0.732143 | 1.58875031 | Bivalvia | 6544 | Mollusca | Mollusca | 150 | 6.609999999999999e-32 | NTclustered | gi|669033496|gb|KJ946315.1| | 183507 | g7778 | i0 | 93.137 | 44.1382488479263 | 102 | 7 | 47 | 0 | 1 | 102 | 399 | 298 | Xylophaga atlantica isolate 41-18s 18S ribosomal RNA gene, partial sequence | blastn | 9578 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Xylophagaidae | Xylonora | Xylonora atlantica | |
| 23305889 | 23305889 | PRJNA1248471_S_NODE_12039_length_195_cov_0.691781_g11939_i0 | PRJNA1248471 | 12039 | 195 | 0.691781 | 1.34897295 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 69.4 | 1.67e-7 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g11939 | i0 | 82.5 | 0.41025641025641 | 80 | 12 | 40 | 2 | 8 | 85 | 37232255 | 37232334 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 80 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27407997 | 27407997 | PRJNA1248471_S_NODE_21183_length_163_cov_0.868421_g21083_i0 | PRJNA1248471 | 21183 | 163 | 0.868421 | 1.41552623 | Elysia | 71493 | Mollusca | Mollusca | 43.9 | 0.00278 | NR | RUS68931.1 | 188477 | g21083 | i0 | 54.3 | 4.23312883435583 | 46 | 20 | 82.8 | 1 | 163 | 29 | 38 | 83 | RUS68931.1 hypothetical protein EGW08_023307 [Elysia chlorotica] | diamond | 690 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 28544637 | 28544637 | PRJNA1248471_S_NODE_15387_length_178_cov_1.139535_g15287_i0 | PRJNA1248471 | 15387 | 178 | 1.139535 | 2.0283723 | Metazoa | 33208 | Mollusca | Mollusca | 43.1 | 0.00822 | NR | CAG5115218.1 | 100452 | g15287 | i0 | 80 | 3.43820224719101 | 20 | 4 | 33.7 | 0 | 105 | 46 | 74 | 93 | CAG5115218.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 612 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 31464336 | 31464336 | PRJNA1248471_S_NODE_18916_length_166_cov_1.589744_g18816_i0 | PRJNA1248471 | 18916 | 166 | 1.589744 | 2.63897504 | Dendropoma gregarium | 169306 | Mollusca | Mollusca | 52.4 | 4.23e-6 | NR | YP_003934264.1 | 169306 | g18816 | i0 | 76.5 | 1.8433734939759 | 34 | 8 | 61.4 | 0 | 104 | 3 | 179 | 212 | YP_003934264.1 cytochrome c oxidase subunit III [Dendropoma gregarium] | diamond | 306 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Vermetidae | Dendropoma | Dendropoma gregarium |
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);;