contig_metadata
19 rows where bioproject = "PRJNA929940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9837102 | 9837102 | PRJNA929940_S_NODE_1568_length_573_cov_8.651119_g1360_i0 | PRJNA929940 | 1568 | 573 | 8.651119 | 49.57091187 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.004 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g1360 | i0 | 100 | 1.60034904013962 | 30 | 0 | 5 | 0 | 90 | 119 | 51407249 | 51407278 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 917 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26905499 | 26905499 | PRJNA929940_S_NODE_31181_length_193_cov_1.461538_g30946_i0 | PRJNA929940 | 31181 | 193 | 1.461538 | 2.82076834 | Metazoa | 33208 | Mollusca | Mollusca | 127 | 2.9599999999999996e-32 | NR | XP_005102304.1 | 6500 | g30946 | i0 | 96.9 | 193.974093264249 | 64 | 2 | 99.5 | 0 | 1 | 192 | 279 | 342 | XP_005102304.1 ATP-dependent Clp protease ATP-binding subunit clpX-like, mitochondrial [Aplysia californica] | diamond | 37437 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 27119484 | 27119484 | PRJNA929940_S_NODE_48502_length_162_cov_2.400000_g48267_i0 | PRJNA929940 | 48502 | 162 | 2.4 | 3.888 | Haliotis discus hannai | 42344 | Mollusca | Mollusca | 114 | 5.46e-28 | NR | ANH56800.1 | 42344 | g48267 | i0 | 100 | 2 | 54 | 0 | 100 | 0 | 162 | 1 | 383 | 436 | ANH56800.1 matrix metalloproteinase 2, partial [Haliotis discus hannai] | diamond | 324 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis discus | |
| 27316665 | 27316665 | PRJNA929940_S_NODE_35343_length_183_cov_5.712329_g35108_i0 | PRJNA929940 | 35343 | 183 | 5.712329 | 10.45356207 | Metazoa | 33208 | Mollusca | Mollusca | 41.6 | 0.0398 | NR | WAR02124.1 | 6604 | g35108 | i0 | 94.7 | 1.52459016393443 | 19 | 1 | 31.1 | 0 | 58 | 2 | 20 | 38 | WAR02124.1 RU17-like protein [Mya arenaria] | diamond | 279 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 27751746 | 27751746 | PRJNA929940_S_NODE_47804_length_163_cov_2.031746_g47569_i0 | PRJNA929940 | 47804 | 163 | 2.031746 | 3.31174598 | Mytilus edulis | 6550 | Mollusca | Mollusca | 72 | 4.59e-14 | NR | AAW47933.1 | 6550 | g47569 | i0 | 75 | 5.88957055214724 | 40 | 10 | 73.6 | 0 | 132 | 13 | 91 | 130 | AAW47933.1 p53, partial [Mytilus edulis] | diamond | 960 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27814900 | 27814900 | PRJNA929940_S_NODE_16404_length_247_cov_4.647619_g16169_i0 | PRJNA929940 | 16404 | 247 | 4.647619 | 11.479618930000001 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 46.2 | 0.0023 | NR | CAC5381415.1 | 42192 | g16169 | i0 | 65.7 | 0.425101214574899 | 35 | 12 | 42.5 | 0 | 105 | 1 | 45 | 79 | CAC5381415.1 unnamed protein product [Mytilus coruscus] | diamond | 105 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 27853234 | 27853234 | PRJNA929940_S_NODE_56324_length_153_cov_1.974138_g56089_i0 | PRJNA929940 | 56324 | 153 | 1.974138 | 3.02043114 | Metazoa | 33208 | Mollusca | Mollusca | 50.1 | 2.66e-5 | NR | XP_025102436.1 | 400727 | g56089 | i0 | 61.3 | 2.72549019607843 | 31 | 12 | 60.8 | 0 | 153 | 61 | 136 | 166 | XP_025102436.1 gastrula zinc finger protein XlCGF7.1-like [Pomacea canaliculata] | diamond | 417 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 28705927 | 28705927 | PRJNA929940_S_NODE_20207_length_228_cov_2.643979_g19972_i0 | PRJNA929940 | 20207 | 228 | 2.643979 | 6.02827212 | Metazoa | 33208 | Mollusca | Mollusca | 90.9 | 1.03e-20 | NR | CAE1263541.1 | 158019 | g19972 | i0 | 72.9 | 2.17105263157895 | 59 | 16 | 77.6 | 0 | 226 | 50 | 4 | 62 | CAE1263541.1 APC8 [Acanthosepion pharaonis] | diamond | 495 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28768848 | 28768848 | PRJNA929940_S_NODE_25107_length_209_cov_8.837209_g24872_i0 | PRJNA929940 | 25107 | 209 | 8.837209 | 18.46976681 | Metazoa | 33208 | Mollusca | Mollusca | 45.8 | 0.00194 | NR | OWF51016.1 | 6573 | g24872 | i0 | 100 | 64.1052631578947 | 22 | 0 | 31.6 | 0 | 207 | 142 | 509 | 530 | OWF51016.1 Tubulin alpha-1A chain [Mizuhopecten yessoensis] | diamond | 13398 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 29172516 | 29172516 | PRJNA929940_S_NODE_19749_length_230_cov_2.642487_g19514_i0 | PRJNA929940 | 19749 | 230 | 2.642487 | 6.0777201 | Mytilus edulis | 6550 | Mollusca | Mollusca | 44.3 | 0.0093 | NR | XP_071152255.1 | 6550 | g19514 | i0 | 61.3 | 0.404347826086957 | 31 | 12 | 40.4 | 0 | 180 | 88 | 575 | 605 | XP_071152255.1 uncharacterized protein [Mytilus edulis] | diamond | 93 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29368891 | 29368891 | PRJNA929940_S_NODE_58829_length_150_cov_5.761062_g58594_i0 | PRJNA929940 | 58829 | 150 | 5.761062 | 8.641593 | Metazoa | 33208 | Mollusca | Mollusca | 40.8 | 0.0477 | NR | XP_046344173.1 | 6454 | g58594 | i0 | 100 | 71.82 | 19 | 0 | 38 | 0 | 149 | 93 | 172 | 190 | XP_046344173.1 splicing factor U2AF 35 kDa subunit-like isoform X1 [Haliotis rufescens] | diamond | 10773 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29400409 | 29400409 | PRJNA929940_S_NODE_19029_length_233_cov_6.433673_g18794_i0 | PRJNA929940 | 19029 | 233 | 6.433673 | 14.99045809 | Opisthokonta | 33154 | Mollusca | Mollusca | 89.7 | 9.2e-20 | NR | XP_022332225.1 | 6565 | g18794 | i0 | 68.1 | 2.96137339055794 | 69 | 22 | 88.8 | 0 | 209 | 3 | 17 | 85 | XP_022332225.1 ras-related protein Rab-1A [Crassostrea virginica] | diamond | 690 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 29487906 | 29487906 | PRJNA929940_S_NODE_46970_length_164_cov_2.275591_g46735_i0 | PRJNA929940 | 46970 | 164 | 2.275591 | 3.73196924 | Aplysia californica | 6500 | Mollusca | Mollusca | 56.2 | 2.22e-7 | NR | XP_012936858.1 | 6500 | g46735 | i0 | 57.4 | 7.90243902439024 | 54 | 23 | 98.8 | 0 | 2 | 163 | 1539 | 1592 | XP_012936858.1 myosin-10 isoform X1 [Aplysia californica] | diamond | 1296 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29551046 | 29551046 | PRJNA929940_S_NODE_43190_length_169_cov_8.712121_g42955_i0 | PRJNA929940 | 43190 | 169 | 8.712121 | 14.72348449 | Haliotis discus hannai | 42344 | Mollusca | Mollusca | 47.4 | 3.24e-4 | NR | ANH56800.1 | 42344 | g42955 | i0 | 90.9 | 0.781065088757396 | 22 | 2 | 39.1 | 0 | 169 | 104 | 526 | 547 | ANH56800.1 matrix metalloproteinase 2, partial [Haliotis discus hannai] | diamond | 132 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis discus | |
| 30790268 | 30790268 | PRJNA929940_S_NODE_57174_length_152_cov_2.060870_g56939_i0 | PRJNA929940 | 57174 | 152 | 2.06087 | 3.1325224 | Metazoa | 33208 | Mollusca | Mollusca | 60.5 | 5.9e-9 | NR | KAI8797840.1 | 6526 | g56939 | i0 | 45.1 | 6.03947368421053 | 51 | 26 | 98.7 | 2 | 152 | 3 | 89 | 138 | KAI8797840.1 protein jagged-1, partial [Biomphalaria glabrata] | diamond | 918 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 30916853 | 30916853 | PRJNA929940_S_NODE_9174_length_307_cov_4.833333_g8939_i0 | PRJNA929940 | 9174 | 307 | 4.833333 | 14.83833231 | Metazoa | 33208 | Mollusca | Mollusca | 109 | 2.34e-25 | NR | CAG2221323.1 | 6550 | g8939 | i0 | 100 | 25.3778501628664 | 53 | 0 | 51.8 | 0 | 147 | 305 | 1 | 53 | CAG2221323.1 Structural maintenance of chromosomes protein 3 [Mytilus edulis] | diamond | 7791 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31137551 | 31137551 | PRJNA929940_S_NODE_54235_length_155_cov_2.559322_g54000_i0 | PRJNA929940 | 54235 | 155 | 2.559322 | 3.9669491 | Metazoa | 33208 | Mollusca | Mollusca | 106 | 4.32e-25 | NR | XP_046369162.1 | 6454 | g54000 | i0 | 100 | 701.825806451613 | 51 | 0 | 98.7 | 0 | 154 | 2 | 249 | 299 | XP_046369162.1 serine/threonine-protein phosphatase 2A 56 kDa regulatory subunit gamma isoform-like isoform X3 [Haliotis rufescens] | diamond | 108783 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31707085 | 31707085 | PRJNA929940_S_NODE_14637_length_258_cov_3.954751_g14402_i0 | PRJNA929940 | 14637 | 258 | 3.954751 | 10.20325758 | Metazoa | 33208 | Mollusca | Mollusca | 109 | 1.68e-25 | NR | CAG2221323.1 | 6550 | g14402 | i0 | 100 | 30.2093023255814 | 53 | 0 | 61.6 | 0 | 161 | 3 | 1 | 53 | CAG2221323.1 Structural maintenance of chromosomes protein 3 [Mytilus edulis] | diamond | 7794 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32245252 | 32245252 | PRJNA929940_S_NODE_20438_length_227_cov_2.321053_g20203_i0 | PRJNA929940 | 20438 | 227 | 2.321053 | 5.26879031 | Mollusca | 6447 | Mollusca | Mollusca | 65.1 | 4.06e-10 | NR | OWF56218.1 | 6573 | g20203 | i0 | 64.1 | 3.6079295154185 | 39 | 14 | 51.5 | 0 | 225 | 109 | 367 | 405 | OWF56218.1 Neurogenic locus notch protein-like [Mizuhopecten yessoensis] | diamond | 819 | 65.5 | 0.993893129770992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis |
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);;