contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13118213 | 13118213 | PRJNA168635_P_NODE_19231_length_185_cov_1.507353_g18815_i0 | PRJNA168635 | 19231 | 185 | 1.507353 | 2.78860305 | Metazoa | 33208 | Mollusca | Mollusca | 123 | 6.13e-31 | NR | KAH3892449.1 | 45954 | g18815 | i0 | 96.7 | 92.5783783783784 | 61 | 2 | 98.9 | 0 | 184 | 2 | 1100 | 1160 | KAH3892449.1 hypothetical protein DPMN_016567, partial [Dreissena polymorpha] | diamond | 17127 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 26838808 | 26838808 | PRJNA168635_P_NODE_22161_length_176_cov_1.598425_g21745_i0 | PRJNA168635 | 22161 | 176 | 1.598425 | 2.813228 | Saccostrea | 33508 | Mollusca | Mollusca | 68.9 | 8.73e-12 | NR | XP_062603410.1 | 36930 | g21745 | i0 | 69.4 | 3.34090909090909 | 49 | 15 | 83.5 | 0 | 10 | 156 | 4 | 52 | XP_062603410.1 LOW QUALITY PROTEIN: DNA polymerase theta-like, partial [Saccostrea cuccullata] | diamond | 588 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 27186376 | 27186376 | PRJNA168635_P_NODE_19802_length_183_cov_1.522388_g19386_i0 | PRJNA168635 | 19802 | 183 | 1.522388 | 2.78597004 | Mollusca | 6447 | Mollusca | Mollusca | 48.1 | 1.82e-5 | NR | CAI9736237.1 | 6645 | g19386 | i0 | 66.7 | 1.18032786885246 | 36 | 11 | 59 | 1 | 76 | 183 | 16 | 50 | CAI9736237.1 cytochrome c oxidase subunit 7c, mitochondrial [Octopus vulgaris] | diamond | 216 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 27326831 | 27326831 | PRJNA168635_P_NODE_32843_length_160_cov_2.657658_g32427_i0 | PRJNA168635 | 32843 | 160 | 2.657658 | 4.2522528 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 49.3 | 5.72e-5 | NR | XP_070209601.1 | 31220 | g32427 | i0 | 60.5 | 2.15625 | 38 | 15 | 71.3 | 0 | 118 | 5 | 53 | 90 | XP_070209601.1 aquaporin-7-like [Littorina saxatilis] | diamond | 345 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27849665 | 27849665 | PRJNA168635_P_NODE_24524_length_170_cov_2.314050_g24108_i0 | PRJNA168635 | 24524 | 170 | 2.31405 | 3.933885 | Metazoa | 33208 | Mollusca | Mollusca | 55.5 | 4.5e-7 | NR | XP_021358723.1 | 6573 | g24108 | i0 | 61.1 | 3.19411764705882 | 36 | 14 | 63.5 | 0 | 63 | 170 | 518 | 553 | XP_021358723.1 thyroid peroxidase-like isoform X2 [Mizuhopecten yessoensis] | diamond | 543 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28400358 | 28400358 | PRJNA168635_P_NODE_22246_length_176_cov_1.102362_g21830_i0 | PRJNA168635 | 22246 | 176 | 1.102362 | 1.94015712 | Pecten maximus | 6579 | Mollusca | Mollusca | 57.4 | 1.02e-7 | NR | XP_033725973.1 | 6579 | g21830 | i0 | 62.5 | 0.545454545454545 | 32 | 12 | 54.5 | 0 | 81 | 176 | 341 | 372 | XP_033725973.1 fibropellin-3-like [Pecten maximus] | diamond | 96 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 28589963 | 28589963 | PRJNA168635_P_NODE_3667_length_437_cov_5.845361_g3267_i0 | PRJNA168635 | 3667 | 437 | 5.845361 | 25.54422757 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 53.1 | 6.35e-5 | NR | CAE1303120.1 | 158019 | g3267 | i0 | 38.7 | 0.816933638443936 | 119 | 52 | 72.8 | 4 | 336 | 19 | 192 | 302 | CAE1303120.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 357 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28607611 | 28607611 | PRJNA168635_P_NODE_16747_length_195_cov_4.143836_g16331_i0 | PRJNA168635 | 16747 | 195 | 4.143836 | 8.0804802 | Metazoa | 33208 | Mollusca | Mollusca | 43.1 | 0.0088 | NR | CAE1255625.1 | 158019 | g16331 | i0 | 69.2 | 2.43076923076923 | 26 | 8 | 40 | 0 | 92 | 169 | 128 | 153 | CAE1255625.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 474 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28639394 | 28639394 | PRJNA168635_P_NODE_32227_length_162_cov_0.920354_g31811_i0 | PRJNA168635 | 32227 | 162 | 0.920354 | 1.49097348 | Mollusca | 6447 | Mollusca | Mollusca | 97.4 | 1.79e-23 | NR | XP_070210751.1 | 31220 | g31811 | i0 | 84.9 | 31.4074074074074 | 53 | 8 | 98.1 | 0 | 160 | 2 | 142 | 194 | XP_070210751.1 elongation factor 1-beta-like [Littorina saxatilis] | diamond | 5088 | 98.2 | 0.991853360488798 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 29000632 | 29000632 | PRJNA168635_P_NODE_25768_length_168_cov_4.084034_g25352_i0 | PRJNA168635 | 25768 | 168 | 4.084034 | 6.86117712 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 40 | 0.0436 | NR | KAH3859569.1 | 45954 | g25352 | i0 | 50 | 1.5 | 42 | 21 | 75 | 0 | 128 | 3 | 35 | 76 | KAH3859569.1 hypothetical protein DPMN_102386 [Dreissena polymorpha] | diamond | 252 | 40 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 29049781 | 29049781 | PRJNA168635_P_NODE_16268_length_198_cov_3.798658_g15852_i0 | PRJNA168635 | 16268 | 198 | 3.798658 | 7.52134284 | Metazoa | 33208 | Mollusca | Mollusca | 47.4 | 4.72e-4 | NR | KAK7508231.1 | 370345 | g15852 | i0 | 70 | 2.04545454545455 | 30 | 9 | 45.5 | 0 | 32 | 121 | 261 | 290 | KAK7508231.1 hypothetical protein BaRGS_00000470 [Batillaria attramentaria] | diamond | 405 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29586103 | 29586103 | PRJNA168635_P_NODE_24170_length_171_cov_1.688525_g23754_i0 | PRJNA168635 | 24170 | 171 | 1.688525 | 2.88737775 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 3.59e-4 | NR | XP_005095539.2 | 6500 | g23754 | i0 | 55.6 | 4.7719298245614 | 36 | 14 | 63.2 | 1 | 23 | 130 | 58 | 91 | XP_005095539.2 cytochrome b5 [Aplysia californica] | diamond | 816 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29744005 | 29744005 | PRJNA168635_P_NODE_19470_length_184_cov_1.525926_g19054_i0 | PRJNA168635 | 19470 | 184 | 1.525926 | 2.80770384 | Mollusca | 6447 | Mollusca | Mollusca | 57.8 | 8.44e-8 | NR | XP_046354187.2 | 6454 | g19054 | i0 | 55.6 | 9.65217391304348 | 54 | 24 | 88 | 0 | 184 | 23 | 175 | 228 | XP_046354187.2 uncharacterized protein LOC124133729 [Haliotis rufescens] | diamond | 1776 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 30105409 | 30105409 | PRJNA168635_P_NODE_23772_length_172_cov_1.650407_g23356_i0 | PRJNA168635 | 23772 | 172 | 1.650407 | 2.83870004 | Patella vulgata | 6465 | Mollusca | Mollusca | 73.6 | 1.98e-13 | NR | XP_050418319.1 | 6465 | g23356 | i0 | 63 | 3.76744186046512 | 54 | 20 | 94.2 | 0 | 2 | 163 | 940 | 993 | XP_050418319.1 transformation/transcription domain-associated protein [Patella vulgata] | diamond | 648 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 30154654 | 30154654 | PRJNA168635_P_NODE_33772_length_157_cov_2.083333_g33356_i0 | PRJNA168635 | 33772 | 157 | 2.083333 | 3.27083281 | Opisthokonta | 33154 | Mollusca | Mollusca | 44.7 | 0.00247 | NR | XP_060582113.1 | 129788 | g33356 | i0 | 67.9 | 3.09554140127389 | 28 | 9 | 53.5 | 0 | 157 | 74 | 331 | 358 | XP_060582113.1 serine/threonine-protein kinase MARK1-like isoform X2 [Ruditapes philippinarum] | diamond | 486 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 31527750 | 31527750 | PRJNA168635_P_NODE_27596_length_166_cov_4.435897_g27180_i0 | PRJNA168635 | 27596 | 166 | 4.435897 | 7.36358902 | Solemya velum | 13268 | Mollusca | Mollusca | 42 | 0.0255 | NR | KAL5015028.1 | 13268 | g27180 | i0 | 40 | 4.69879518072289 | 65 | 27 | 95.8 | 3 | 162 | 4 | 409 | 473 | KAL5015028.1 hypothetical protein ScPMuIL_009298 [Solemya velum] | diamond | 780 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 32128898 | 32128898 | PRJNA168635_P_NODE_17858_length_190_cov_1.446809_g17442_i0 | PRJNA168635 | 17858 | 190 | 1.446809 | 2.7489371 | Magallana gigas | 29159 | Mollusca | Mollusca | 51.6 | 1.34e-5 | NR | XP_034318849.2 | 29159 | g17442 | i0 | 43.9 | 1.81578947368421 | 57 | 32 | 90 | 0 | 183 | 13 | 196 | 252 | XP_034318849.2 procathepsin L [Magallana gigas] | diamond | 345 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 32160519 | 32160519 | PRJNA168635_P_NODE_26758_length_167_cov_2.610169_g26342_i0 | PRJNA168635 | 26758 | 167 | 2.610169 | 4.35898223 | Lottia gigantea | 225164 | Mollusca | Mollusca | 97.1 | 9.94e-22 | NR | XP_009065938.1 | 225164 | g26342 | i0 | 78.2 | 0.988023952095808 | 55 | 12 | 98.8 | 0 | 2 | 166 | 401 | 455 | XP_009065938.1 hypothetical protein LOTGIDRAFT_169374 [Lottia gigantea] | diamond | 165 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32336573 | 32336573 | PRJNA168635_P_NODE_6979_length_320_cov_14.140221_g6567_i0 | PRJNA168635 | 6979 | 320 | 14.140221 | 45.2487072 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.3 | 4.16e-11 | NR | KAK7508231.1 | 370345 | g6567 | i0 | 44.6 | 1.6875 | 92 | 43 | 78.8 | 2 | 14 | 265 | 245 | 336 | KAK7508231.1 hypothetical protein BaRGS_00000470 [Batillaria attramentaria] | diamond | 540 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria |
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);;