contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135238 | 135238 | PRJEB7366_P_NODE_12421_length_228_cov_2.450777_g11987_i0 | PRJEB7366 | 12421 | 228 | 2.450777 | 5.58777156 | Pecten maximus | 6579 | Mollusca | Mollusca | 183 | 6.909999999999998e-42 | NTclustered | gi|1835454412|ref|XM_033892547.1| | 6579 | g11987 | i0 | 82.464 | 57.3947368421053 | 211 | 35 | 92 | 2 | 19 | 228 | 128 | 337 | PREDICTED: Pecten maximus dynein light chain 2, cytoplasmic-like (LOC117333310), mRNA | blastn | 13086 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 995543 | 995543 | PRJEB7366_P_NODE_21121_length_165_cov_1.223077_g20687_i0 | PRJEB7366 | 21121 | 165 | 1.223077 | 2.01807705 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2427390617|ref|XM_052917999.1| | 6604 | g20687 | i0 | 100 | 2.66666666666667 | 28 | 0 | 17 | 0 | 125 | 152 | 5153 | 5126 | PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA | blastn | 440 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 1409821 | 1409821 | PRJEB7366_P_NODE_13642_length_215_cov_1.544444_g13208_i0 | PRJEB7366 | 13642 | 215 | 1.544444 | 3.3205546 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 82.4 | 2.42e-11 | NTclustered | gi|2911900731|ref|XM_071228667.1| | 6455 | g13208 | i0 | 82.609 | 4.86511627906977 | 92 | 16 | 43 | 0 | 119 | 210 | 527 | 436 | PREDICTED: Haliotis cracherodii AP-1 complex subunit sigma-2 (LOC139447359), transcript variant X2, mRNA | blastn | 1046 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 2685322 | 2685322 | PRJEB7366_P_NODE_20223_length_169_cov_1.477612_g19789_i0 | PRJEB7366 | 20223 | 169 | 1.477612 | 2.49716428 | Haliotis asinina | 109174 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2793396579|ref|XM_067810234.1| | 109174 | g19789 | i0 | 100 | 0.355029585798817 | 30 | 0 | 18 | 0 | 81 | 110 | 1812 | 1783 | PREDICTED: Haliotis asinina uncharacterized protein (LOC137278111), transcript variant X1, mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 3961358 | 3961358 | PRJEB7366_P_NODE_22764_length_158_cov_0.975610_g22330_i0 | PRJEB7366 | 22764 | 158 | 0.97561 | 1.5414638 | Patella vulgata | 6465 | Mollusca | Mollusca | 69.4 | 1.3e-7 | NTclustered | gi|2296487029|ref|XM_050550550.1| | 6465 | g22330 | i0 | 87.931 | 0.664556962025316 | 58 | 7 | 37 | 0 | 62 | 119 | 724 | 781 | PREDICTED: Patella vulgata DNA-directed RNA polymerases I and III subunit RPAC1 (LOC126821922), mRNA | blastn | 105 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 6513384 | 6513384 | PRJEB7366_P_NODE_5526_length_382_cov_2.170029_g5093_i0 | PRJEB7366 | 5526 | 382 | 2.170029 | 8.28951078 | Saccostrea kegaki | 182713 | Mollusca | Mollusca | 60.2 | 2.18e-4 | NTclustered | gi|194068384|dbj|AB374934.1| | 182713 | g5093 | i0 | 94.737 | 0.772251308900524 | 38 | 2 | 10 | 0 | 180 | 217 | 548 | 585 | Saccostrea kegaki mRNA for high mobility group 1 protein, partial cds | blastn | 295 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea kegaki | |
| 7787659 | 7787659 | PRJEB7366_P_NODE_6187_length_356_cov_1.501558_g5754_i0 | PRJEB7366 | 6187 | 356 | 1.501558 | 5.34554648 | Argopecten irradians | 31199 | Mollusca | Mollusca | 209 | 1.89e-49 | NTclustered | gi|2835328318|ref|XM_069268921.1| | 31199 | g5754 | i0 | 78.378 | 2.98033707865169 | 333 | 64 | 92 | 5 | 4 | 332 | 256 | 584 | PREDICTED: Argopecten irradians charged multivesicular body protein 2a-like (LOC138323954), transcript variant X2, mRNA | blastn | 1061 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 7787664 | 7787664 | PRJEB7366_P_NODE_827_length_1071_cov_5.915058_g610_i0 | PRJEB7366 | 827 | 1071 | 5.915058 | 63.35027118 | Mya arenaria | 6604 | Mollusca | Mollusca | 58.4 | 0.002 | NTclustered | gi|2427531503|ref|XM_052963179.1| | 6604 | g610 | i0 | 100 | 0.0840336134453782 | 31 | 0 | 3 | 0 | 767 | 797 | 1836 | 1806 | PREDICTED: Mya arenaria uncharacterized LOC128244994 (LOC128244994), partial mRNA | blastn | 90 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 7787668 | 7787668 | PRJEB7366_P_NODE_8987_length_281_cov_3.800813_g8553_i0 | PRJEB7366 | 8987 | 281 | 3.800813 | 10.68028453 | Lottia gigantea | 225164 | Mollusca | Mollusca | 158 | 5.34e-34 | NTclustered | gi|676496756|ref|XM_009069071.1| | 225164 | g8553 | i0 | 88.06 | 73.4590747330961 | 134 | 14 | 47 | 2 | 149 | 281 | 733 | 601 | Lottia gigantea hypothetical protein mRNA | blastn | 20642 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 10338311 | 10338311 | PRJEB7366_P_NODE_24209_length_152_cov_1.709402_g23775_i0 | PRJEB7366 | 24209 | 152 | 1.709402 | 2.59829104 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g23775 | i0 | 100 | 0.572368421052632 | 30 | 0 | 20 | 0 | 109 | 138 | 61988571 | 61988542 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 87 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11198829 | 11198829 | PRJEB7366_P_NODE_14869_length_203_cov_4.398810_g14435_i0 | PRJEB7366 | 14869 | 203 | 4.39881 | 8.9295843 | Mollusca | 6447 | Mollusca | Mollusca | 145 | 2.84e-30 | NTclustered | gi|2364282944|ref|XM_052359824.1| | 45954 | g14435 | i0 | 88.333 | 16.3891625615764 | 120 | 14 | 59 | 0 | 84 | 203 | 180 | 299 | PREDICTED: Dreissena polymorpha dynein light chain 1, cytoplasmic-like (LOC127834179), mRNA | blastn | 3327 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 11613748 | 11613748 | PRJEB7366_P_NODE_17290_length_185_cov_2.126667_g16856_i0 | PRJEB7366 | 17290 | 185 | 2.126667 | 3.93433395 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 148 | 1.96e-31 | NTclustered | gi|2592066134|ref|XM_060212732.1| | 509963 | g16856 | i0 | 81.319 | 0.983783783783784 | 182 | 34 | 98 | 0 | 2 | 183 | 13621 | 13802 | PREDICTED: Ylistrum balloti dynein axonemal heavy chain 10-like (LOC132548837), mRNA | blastn | 182 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 16298171 | 16298171 | PRJEB7366_P_NODE_12473_length_228_cov_1.176166_g12039_i0 | PRJEB7366 | 12473 | 228 | 1.176166 | 2.68165848 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 1.21e-4 | NTclustered | gi|2868681482|ref|XM_070325302.1| | 31220 | g12039 | i0 | 97.143 | 1.49122807017544 | 35 | 1 | 15 | 0 | 172 | 206 | 500 | 466 | PREDICTED: Littorina saxatilis nucleolar and coiled-body phosphoprotein 1-like (LOC138953464), transcript variant X2, mRNA | blastn | 340 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 16711946 | 16711946 | PRJEB7366_P_NODE_2614_length_595_cov_2.428571_g2220_i0 | PRJEB7366 | 2614 | 595 | 2.428571 | 14.44999745 | Mytilus californianus | 6549 | Mollusca | Mollusca | 370 | 1.43e-97 | NTclustered | gi|2334627999|ref|XM_052218573.1| | 6549 | g2220 | i0 | 80.119 | 78.0235294117647 | 503 | 94 | 84 | 5 | 2 | 501 | 968 | 1467 | PREDICTED: Mytilus californianus tubulin alpha-1A chain-like (LOC127712247), mRNA | blastn | 46424 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 20122066 | 20122066 | PRJEB7366_P_NODE_7436_length_317_cov_2.127660_g7002_i0 | PRJEB7366 | 7436 | 317 | 2.12766 | 6.7446822 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g7002 | i0 | 100 | 0.845425867507886 | 30 | 0 | 9 | 0 | 188 | 217 | 43153522 | 43153493 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 268 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20536127 | 20536127 | PRJEB7366_P_NODE_11497_length_240_cov_1.790244_g11063_i0 | PRJEB7366 | 11497 | 240 | 1.790244 | 4.2965856 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g11063 | i0 | 96.774 | 0.129166666666667 | 31 | 1 | 13 | 0 | 102 | 132 | 52424515 | 52424545 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20536206 | 20536206 | PRJEB7366_P_NODE_9357_length_275_cov_1.254167_g8923_i0 | PRJEB7366 | 9357 | 275 | 1.254167 | 3.44895925 | Ostrea edulis | 37623 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2507386821|ref|XM_048906436.2| | 37623 | g8923 | i0 | 96.97 | 0.12 | 33 | 0 | 12 | 1 | 140 | 171 | 1456 | 1488 | PREDICTED: Ostrea edulis mucin-22-like (LOC125670972), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis |
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);;