contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA384462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1680177 | 1680177 | PRJNA384462_S_NODE_3522_length_279_cov_1.321739_g3406_i0 | PRJNA384462 | 3522 | 279 | 1.321739 | 3.68765181 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 127 | 6.18e-34 | NR | KAK3603469.1 | 2493646 | g3406 | i0 | 65.2 | 11.8817204301075 | 92 | 31 | 98.9 | 1 | 2 | 277 | 122 | 212 | KAK3603469.1 hypothetical protein CHS0354_030309 [Potamilus streckersoni] | diamond | 3315 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 20806928 | 20806928 | PRJNA384462_S_NODE_5777_length_226_cov_1.463277_g5661_i0 | PRJNA384462 | 5777 | 226 | 1.463277 | 3.30700602 | Gastropoda | 6448 | Mollusca | Mollusca | 105 | 7.34e-27 | NR | XP_070200580.1 | 31220 | g5661 | i0 | 64.9 | 5.8938053097345096 | 74 | 26 | 98.2 | 0 | 224 | 3 | 7 | 80 | XP_070200580.1 small ribosomal subunit protein uS17-like [Littorina saxatilis] | diamond | 1332 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 26648716 | 26648716 | PRJNA384462_S_NODE_8561_length_195_cov_0.986301_g8445_i0 | PRJNA384462 | 8561 | 195 | 0.986301 | 1.92328695 | Metazoa | 33208 | Mollusca | Mollusca | 65.5 | 1.86e-10 | NR | XP_022341649.1 | 6565 | g8445 | i0 | 47.5 | 4.76923076923077 | 61 | 32 | 93.8 | 0 | 3 | 185 | 481 | 541 | XP_022341649.1 LOW QUALITY PROTEIN: all-trans-retinol 13,14-reductase-like [Crassostrea virginica] | diamond | 930 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 28008215 | 28008215 | PRJNA384462_S_NODE_10885_length_178_cov_1.186047_g10769_i0 | PRJNA384462 | 10885 | 178 | 1.186047 | 2.11116366 | Aplysiida | 6497 | Mollusca | Mollusca | 100 | 9.77e-23 | NR | XP_005096557.1 | 6500 | g10769 | i0 | 72.9 | 5.89887640449438 | 59 | 16 | 99.4 | 0 | 177 | 1 | 186 | 244 | XP_005096557.1 peroxisomal multifunctional enzyme type 2 isoform X2 [Aplysia californica] | diamond | 1050 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 28323661 | 28323661 | PRJNA384462_S_NODE_4506_length_251_cov_0.886139_g4390_i0 | PRJNA384462 | 4506 | 251 | 0.886139 | 2.22420889 | Mytilus | 6548 | Mollusca | Mollusca | 53.1 | 8.85e-6 | NR | XP_071166893.1 | 6550 | g4390 | i0 | 46.7 | 2.15139442231076 | 60 | 21 | 69.3 | 2 | 246 | 73 | 689 | 739 | XP_071166893.1 multiple C2 and transmembrane domain-containing protein 1-like isoform X8 [Mytilus edulis] | diamond | 540 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 28811746 | 28811746 | PRJNA384462_S_NODE_4848_length_243_cov_3.690722_g4732_i0 | PRJNA384462 | 4848 | 243 | 3.690722 | 8.96845446 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0138 | NR | XP_067657806.1 | 109174 | g4732 | i0 | 35.4 | 1.58024691358025 | 65 | 36 | 79 | 2 | 9 | 200 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 29334167 | 29334167 | PRJNA384462_S_NODE_1749_length_395_cov_1.563584_g1633_i0 | PRJNA384462 | 1749 | 395 | 1.563584 | 6.1761568 | Opisthokonta | 33154 | Mollusca | Mollusca | 64.7 | 1.43e-9 | NR | XP_011441080.1 | 29159 | g1633 | i0 | 40.2 | 1.04810126582278 | 82 | 49 | 62.3 | 0 | 1 | 246 | 145 | 226 | XP_011441080.1 uncharacterized protein [Magallana gigas] | diamond | 414 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 30328468 | 30328468 | PRJNA384462_S_NODE_6592_length_215_cov_1.204819_g6476_i0 | PRJNA384462 | 6592 | 215 | 1.204819 | 2.59036085 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 73.9 | 6.28e-15 | NR | KAK3579783.1 | 2493646 | g6476 | i0 | 53.3 | 4.31162790697674 | 75 | 27 | 93.5 | 3 | 13 | 213 | 37 | 111 | KAK3579783.1 hypothetical protein CHS0354_018220 [Potamilus streckersoni] | diamond | 927 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 30580474 | 30580474 | PRJNA384462_S_NODE_5173_length_236_cov_4.582888_g5057_i0 | PRJNA384462 | 5173 | 236 | 4.582888 | 10.81561568 | Mytilus edulis | 6550 | Mollusca | Mollusca | 47.8 | 5.38e-4 | NR | CAG2187267.1 | 6550 | g5057 | i0 | 44.6 | 0.711864406779661 | 56 | 25 | 63.6 | 2 | 154 | 5 | 192 | 247 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 168 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30913700 | 30913700 | PRJNA384462_S_NODE_1494_length_426_cov_1.307692_g1378_i0 | PRJNA384462 | 1494 | 426 | 1.307692 | 5.57076792 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 3.42e-30 | NR | XP_064604422.1 | 13599 | g1378 | i0 | 52.5 | 9.85211267605634 | 120 | 54 | 84.5 | 2 | 424 | 65 | 285 | 401 | XP_064604422.1 aminomethyltransferase, mitochondrial-like [Liolophura japonica] | diamond | 4197 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31212180 | 31212180 | PRJNA384462_S_NODE_13955_length_164_cov_1.330435_g13839_i0 | PRJNA384462 | 13955 | 164 | 1.330435 | 2.1819134 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 46.6 | 5.49e-4 | NR | XP_045175560.2 | 6596 | g13839 | i0 | 73.1 | 1.42682926829268 | 26 | 7 | 47.6 | 0 | 5 | 82 | 303 | 328 | XP_045175560.2 MYG1 exonuclease-like [Mercenaria mercenaria] | diamond | 234 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31212181 | 31212181 | PRJNA384462_S_NODE_1715_length_398_cov_3.000000_g1599_i0 | PRJNA384462 | 1715 | 398 | 3 | 11.94 | Mya arenaria | 6604 | Mollusca | Mollusca | 47.4 | 0.005 | NR | XP_052762250.1 | 6604 | g1599 | i0 | 35.7 | 0.633165829145729 | 84 | 39 | 52.8 | 5 | 388 | 179 | 69 | 151 | XP_052762250.1 receptor-type tyrosine-protein phosphatase kappa-like [Mya arenaria] | diamond | 252 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31275804 | 31275804 | PRJNA384462_S_NODE_14935_length_162_cov_0.902655_g14819_i0 | PRJNA384462 | 14935 | 162 | 0.902655 | 1.4623011 | Patella vulgata | 6465 | Mollusca | Mollusca | 65.5 | 1.16e-10 | NR | XP_050403090.1 | 6465 | g14819 | i0 | 72.5 | 0.740740740740741 | 40 | 11 | 74.1 | 0 | 15 | 134 | 448 | 487 | XP_050403090.1 lipoamide acyltransferase component of branched-chain alpha-keto acid dehydrogenase complex, mitochondrial [Patella vulgata] | diamond | 120 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 31845103 | 31845103 | PRJNA384462_S_NODE_4197_length_259_cov_1.123810_g4081_i0 | PRJNA384462 | 4197 | 259 | 1.12381 | 2.9106679 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 62 | 7.83e-9 | NR | XP_041374776.1 | 1735272 | g4081 | i0 | 59.6 | 0.544401544401544 | 47 | 17 | 54.4 | 1 | 177 | 37 | 3784 | 3828 | XP_041374776.1 uncharacterized protein LOC121387655 [Gigantopelta aegis] | diamond | 141 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32730412 | 32730412 | PRJNA384462_S_NODE_13560_length_165_cov_1.318966_g13444_i0 | PRJNA384462 | 13560 | 165 | 1.318966 | 2.1762939 | Elysia crispata | 231223 | Mollusca | Mollusca | 50.8 | 5.18e-6 | NR | KAK3785968.1 | 231223 | g13444 | i0 | 41.5 | 1.90909090909091 | 53 | 31 | 96.4 | 0 | 161 | 3 | 82 | 134 | KAK3785968.1 hypothetical protein RRG08_018512 [Elysia crispata] | diamond | 315 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata |
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);;