contig_metadata
20 rows where bioproject = "PRJNA529924", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 503279 | 503279 | PRJNA529924_P_NODE_3141_length_240_cov_2.241706_g2967_i0 | PRJNA529924 | 3141 | 240 | 2.241706 | 5.3800944 | Aplysiida | 6497 | Mollusca | Mollusca | 108 | 8.07e-28 | NR | XP_005096044.1 | 6500 | g2967 | i0 | 81 | 3.1375 | 63 | 12 | 78.8 | 0 | 50 | 238 | 1 | 63 | XP_005096044.1 soma ferritin [Aplysia californica] | diamond | 753 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 503286 | 503286 | PRJNA529924_P_NODE_4281_length_183_cov_1.967532_g4107_i0 | PRJNA529924 | 4281 | 183 | 1.967532 | 3.60058356 | Mollusca | 6447 | Mollusca | Mollusca | 107 | 9.16e-26 | NR | AFI56369.1 | 6551 | g4107 | i0 | 86 | 3.83606557377049 | 57 | 8 | 93.4 | 0 | 12 | 182 | 37 | 93 | AFI56369.1 isocitrate dehydrogenase [Mytilus trossulus] | diamond | 702 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 2392721 | 2392721 | PRJNA529924_P_NODE_2342_length_311_cov_7.134752_g2168_i0 | PRJNA529924 | 2342 | 311 | 7.134752 | 22.18907872 | Metazoa | 33208 | Mollusca | Mollusca | 158 | 5.9899999999999985e-34 | NTclustered | gi|2334673389|ref|XM_052235946.1| | 6549 | g2168 | i0 | 87.97 | 40.8102893890675 | 133 | 16 | 43 | 0 | 1 | 133 | 1351 | 1483 | PREDICTED: Mytilus californianus tubulin alpha-1A chain-like (LOC127728525), mRNA | blastn | 12692 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 4330193 | 4330193 | PRJNA529924_P_NODE_1224_length_515_cov_9.386831_g1059_i0 | PRJNA529924 | 1224 | 515 | 9.386831 | 48.34217965 | Aplysia californica | 6500 | Mollusca | Mollusca | 289 | 3.53e-73 | NTclustered | gi|1897919841|ref|XM_013080763.2| | 6500 | g1059 | i0 | 78.936 | 83.2466019417476 | 451 | 75 | 86 | 19 | 17 | 457 | 502 | 62 | PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA | blastn | 42872 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 4330197 | 4330197 | PRJNA529924_P_NODE_2584_length_288_cov_2.945946_g2410_i0 | PRJNA529924 | 2584 | 288 | 2.945946 | 8.48432448 | Lottia gigantea | 225164 | Mollusca | Mollusca | 289 | 1.87e-73 | NTclustered | gi|676453046|ref|XM_009054981.1| | 225164 | g2410 | i0 | 88.382 | 45.6840277777778 | 241 | 27 | 84 | 1 | 1 | 241 | 359 | 120 | Lottia gigantea hypothetical protein mRNA | blastn | 13157 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 4330205 | 4330205 | PRJNA529924_P_NODE_3604_length_211_cov_1.615385_g3430_i0 | PRJNA529924 | 3604 | 211 | 1.615385 | 3.40846235 | Physella acuta | 109671 | Mollusca | Mollusca | 385 | 1.61e-102 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g3430 | i0 | 99.526 | 97.9857819905213 | 211 | 1 | 100 | 0 | 1 | 211 | 841 | 1051 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 20675 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 4330212 | 4330212 | PRJNA529924_P_NODE_4884_length_156_cov_2.425197_g4710_i0 | PRJNA529924 | 4884 | 156 | 2.425197 | 3.78330732 | Physella acuta | 109671 | Mollusca | Mollusca | 237 | 3.31e-58 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g4710 | i0 | 93.413 | 85.8782051282051 | 167 | 0 | 100 | 1 | 1 | 156 | 683 | 849 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 13397 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 8770277 | 8770277 | PRJNA529924_P_NODE_3407_length_221_cov_1.927083_g3233_i0 | PRJNA529924 | 3407 | 221 | 1.927083 | 4.25885343 | Metazoa | 33208 | Mollusca | Mollusca | 159 | 1.12e-34 | NTclustered | gi|2912449415|ref|XM_071275985.1| | 6550 | g3233 | i0 | 80.374 | 6.14027149321267 | 214 | 38 | 96 | 4 | 10 | 221 | 652 | 863 | PREDICTED: Mytilus edulis aconitate hydratase, mitochondrial-like (LOC139489502), mRNA | blastn | 1357 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 18354655 | 18354655 | PRJNA529924_P_NODE_2675_length_278_cov_3.028112_g2501_i0 | PRJNA529924 | 2675 | 278 | 3.028112 | 8.41815136 | Opisthokonta | 33154 | Mollusca | Mollusca | 115 | 3.1699999999999998e-31 | NR | XP_048755150.1 | 37623 | g2501 | i0 | 75 | 1.6294964028777 | 76 | 17 | 82 | 1 | 229 | 2 | 3 | 76 | XP_048755150.1 acyl-CoA-binding protein-like [Ostrea edulis] | diamond | 453 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 20905339 | 20905339 | PRJNA529924_P_NODE_1917_length_370_cov_2.533724_g1743_i0 | PRJNA529924 | 1917 | 370 | 2.533724 | 9.3747788 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 107 | 1.19e-26 | NR | KAJ8307171.1 | 220873 | g1743 | i0 | 56 | 1.88108108108108 | 125 | 33 | 83.5 | 3 | 61 | 369 | 29 | 153 | KAJ8307171.1 hypothetical protein KUTeg_015255 [Tegillarca granosa] | diamond | 696 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 22179920 | 22179920 | PRJNA529924_P_NODE_2478_length_297_cov_4.164179_g2304_i0 | PRJNA529924 | 2478 | 297 | 4.164179 | 12.36761163 | Patella vulgata | 6465 | Mollusca | Mollusca | 172 | 2.03e-38 | NTclustered | gi|2506339511|ref|XM_050561182.2| | 6465 | g2304 | i0 | 90.299 | 42.7979797979798 | 134 | 10 | 44 | 1 | 1 | 131 | 1311 | 1444 | PREDICTED: Patella vulgata tubulin alpha-2/alpha-4 chain (LOC126830781), mRNA | blastn | 12711 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 25343614 | 25343614 | PRJNA529924_P_NODE_980_length_600_cov_2.507881_g830_i0 | PRJNA529924 | 980 | 600 | 2.507881 | 15.047286 | Metazoa | 33208 | Mollusca | Mollusca | 335 | 1.26e-108 | NR | XP_050390465.1 | 6465 | g830 | i0 | 81 | 38 | 200 | 37 | 99.5 | 1 | 3 | 599 | 363 | 562 | XP_050390465.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1 isoform X5 [Patella vulgata] | diamond | 22800 | 337 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 26634348 | 26634348 | PRJNA529924_P_NODE_2381_length_308_cov_2.724014_g2207_i0 | PRJNA529924 | 2381 | 308 | 2.724014 | 8.3899631200000009 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 70.1 | 1.96e-11 | NR | XP_022345813.1 | 6565 | g2207 | i0 | 73.9 | 3.20454545454545 | 46 | 12 | 44.8 | 0 | 170 | 307 | 1 | 46 | XP_022345813.1 polyadenylate-binding protein 4-like [Crassostrea virginica] | diamond | 987 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 27061042 | 27061042 | PRJNA529924_P_NODE_4842_length_158_cov_2.031008_g4668_i0 | PRJNA529924 | 4842 | 158 | 2.031008 | 3.20899264 | Metazoa | 33208 | Mollusca | Mollusca | 96.7 | 1.1e-21 | NR | OWF50798.1 | 6573 | g4668 | i0 | 86.5 | 13.8227848101266 | 52 | 7 | 98.7 | 0 | 156 | 1 | 392 | 443 | OWF50798.1 T-complex protein 1 subunit eta [Mizuhopecten yessoensis] | diamond | 2184 | 97.4 | 0.992813141683778 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28656736 | 28656736 | PRJNA529924_P_NODE_3747_length_204_cov_3.234286_g3573_i0 | PRJNA529924 | 3747 | 204 | 3.234286 | 6.59794344 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 66.2 | 2.19e-11 | NR | XP_053408348.1 | 6596 | g3573 | i0 | 65.2 | 2.60294117647059 | 46 | 16 | 67.6 | 0 | 138 | 1 | 40 | 85 | XP_053408348.1 kielin/chordin-like protein [Mercenaria mercenaria] | diamond | 531 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 28656738 | 28656738 | PRJNA529924_P_NODE_4907_length_155_cov_2.095238_g4733_i0 | PRJNA529924 | 4907 | 155 | 2.095238 | 3.2476189 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 77.4 | 1.54e-15 | NR | KAH9524057.1 | 55810 | g4733 | i0 | 66.7 | 2.65161290322581 | 45 | 15 | 87.1 | 0 | 146 | 12 | 33 | 77 | KAH9524057.1 Acyl-CoA 6-desaturase [Bulinus truncatus] | diamond | 411 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 29650059 | 29650059 | PRJNA529924_P_NODE_2630_length_284_cov_1.878431_g2456_i0 | PRJNA529924 | 2630 | 284 | 1.878431 | 5.33474404 | Bivalvia | 6544 | Mollusca | Mollusca | 61.2 | 1.9e-8 | NR | XP_045190811.2 | 6596 | g2456 | i0 | 39.3 | 1.1830985915493 | 56 | 34 | 59.2 | 0 | 273 | 106 | 659 | 714 | XP_045190811.2 peroxidase-like [Mercenaria mercenaria] | diamond | 336 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31246601 | 31246601 | PRJNA529924_P_NODE_2355_length_310_cov_2.302491_g2181_i0 | PRJNA529924 | 2355 | 310 | 2.302491 | 7.1377221 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 73.2 | 1.71e-12 | NR | XP_048258469.1 | 6454 | g2181 | i0 | 69.6 | 0.445161290322581 | 46 | 13 | 44.5 | 1 | 10 | 147 | 644 | 688 | XP_048258469.1 prestalk protein-like isoform X2 [Haliotis rufescens] | diamond | 138 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31641190 | 31641190 | PRJNA529924_P_NODE_2216_length_327_cov_2.818792_g2042_i0 | PRJNA529924 | 2216 | 327 | 2.818792 | 9.21744984 | Metazoa | 33208 | Mollusca | Mollusca | 210 | 2.88e-64 | NR | XP_070196833.1 | 31220 | g2042 | i0 | 88.9 | 12.8715596330275 | 108 | 12 | 99.1 | 0 | 2 | 325 | 69 | 176 | XP_070196833.1 adenosylhomocysteinase-like [Littorina saxatilis] | diamond | 4209 | 212 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 32305992 | 32305992 | PRJNA529924_P_NODE_4579_length_170_cov_2.581560_g4405_i0 | PRJNA529924 | 4579 | 170 | 2.58156 | 4.388652 | Metazoa | 33208 | Mollusca | Mollusca | 116 | 1.19e-28 | NR | CAG2221827.1 | 6550 | g4405 | i0 | 98.2 | 44.4705882352941 | 56 | 1 | 98.8 | 0 | 2 | 169 | 194 | 249 | CAG2221827.1 NOG1 [Mytilus edulis] | diamond | 7560 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus 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);;