contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26922801 | 26922801 | PRJNA635874_P_NODE_19062_length_359_cov_0.905594_g18915_i0 | PRJNA635874 | 19062 | 359 | 0.905594 | 3.25108246 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 47 | 0.00453 | NR | KAL3877911.1 | 1069815 | g18915 | i0 | 30.5 | 1.58774373259053 | 95 | 58 | 73.5 | 3 | 282 | 19 | 616 | 709 | KAL3877911.1 hypothetical protein ACJMK2_035553 [Sinanodonta woodiana] | diamond | 570 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 27365755 | 27365755 | PRJNA635874_P_NODE_48503_length_250_cov_1.305085_g48356_i0 | PRJNA635874 | 48503 | 250 | 1.305085 | 3.2627125 | Solemya velum | 13268 | Mollusca | Mollusca | 65.5 | 4.04e-10 | NR | KAL5022008.1 | 13268 | g48356 | i0 | 46.6 | 2.652 | 73 | 37 | 87.6 | 2 | 1 | 219 | 122 | 192 | KAL5022008.1 hypothetical protein ScPMuIL_001163 [Solemya velum] | diamond | 663 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27554658 | 27554658 | PRJNA635874_P_NODE_22184_length_339_cov_1.345865_g22037_i0 | PRJNA635874 | 22184 | 339 | 1.345865 | 4.56248235 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 93.2 | 8.56e-20 | NR | CAE1283158.1 | 158019 | g22037 | i0 | 39.8 | 1 | 113 | 59 | 100 | 2 | 1 | 339 | 103 | 206 | CAE1283158.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 339 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28249382 | 28249382 | PRJNA635874_P_NODE_73886_length_241_cov_0.916667_g73739_i0 | PRJNA635874 | 73886 | 241 | 0.916667 | 2.20916747 | Magallana gigas | 29159 | Mollusca | Mollusca | 119 | 4.98e-30 | NR | XP_011446138.3 | 29159 | g73739 | i0 | 69.6 | 2.95020746887967 | 79 | 24 | 98.3 | 0 | 239 | 3 | 302 | 380 | XP_011446138.3 2-aminoethylphosphonate--pyruvate transaminase [Magallana gigas] | diamond | 711 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28754722 | 28754722 | PRJNA635874_P_NODE_30927_length_299_cov_1.022124_g30780_i0 | PRJNA635874 | 30927 | 299 | 1.022124 | 3.05615076 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 57.8 | 1.6e-7 | NR | KAK7498057.1 | 370345 | g30780 | i0 | 41.1 | 1.80602006688963 | 90 | 48 | 90.3 | 2 | 297 | 28 | 121 | 205 | KAK7498057.1 hypothetical protein BaRGS_00010645 [Batillaria attramentaria] | diamond | 540 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29114596 | 29114596 | PRJNA635874_P_NODE_44048_length_257_cov_1.255435_g43901_i0 | PRJNA635874 | 44048 | 257 | 1.255435 | 3.22646795 | Metazoa | 33208 | Mollusca | Mollusca | 50.4 | 8.26e-5 | NR | XP_021365239.1 | 6573 | g43901 | i0 | 75 | 3.1284046692607 | 28 | 7 | 32.7 | 0 | 58 | 141 | 187 | 214 | XP_021365239.1 RCC1-like G exchanging factor-like protein isoform X2 [Mizuhopecten yessoensis] | diamond | 804 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30807708 | 30807708 | PRJNA635874_P_NODE_51374_length_249_cov_0.875000_g51227_i0 | PRJNA635874 | 51374 | 249 | 0.875 | 2.17875 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 51.6 | 2.97e-5 | NR | XP_025085556.1 | 400727 | g51227 | i0 | 41.5 | 2.91566265060241 | 82 | 48 | 98.8 | 0 | 3 | 248 | 486 | 567 | XP_025085556.1 kinesin-like protein KIF3A isoform X3 [Pomacea canaliculata] | diamond | 726 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 30997297 | 30997297 | PRJNA635874_P_NODE_31414_length_297_cov_1.191964_g31267_i0 | PRJNA635874 | 31414 | 297 | 1.191964 | 3.54013308 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 47.8 | 3.17e-4 | NR | XP_029636397.1 | 2607531 | g31267 | i0 | 30.3 | 0.767676767676768 | 76 | 53 | 76.8 | 0 | 16 | 243 | 1 | 76 | XP_029636397.1 ubiquitin-60S ribosomal protein L40 [Octopus sinensis] | diamond | 228 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 31186545 | 31186545 | PRJNA635874_P_NODE_47975_length_251_cov_0.865169_g47828_i0 | PRJNA635874 | 47975 | 251 | 0.865169 | 2.17157419 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 75.1 | 1.32e-13 | NR | XP_060579328.1 | 129788 | g47828 | i0 | 51.2 | 3.25099601593626 | 82 | 33 | 92 | 3 | 15 | 245 | 269 | 348 | XP_060579328.1 UPF0046 protein C25E10.12-like [Ruditapes philippinarum] | diamond | 816 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 31218038 | 31218038 | PRJNA635874_P_NODE_57615_length_247_cov_0.885057_g57468_i0 | PRJNA635874 | 57615 | 247 | 0.885057 | 2.18609079 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 103 | 8.06e-25 | NR | PVD22824.1 | 400727 | g57468 | i0 | 61.7 | 0.983805668016194 | 81 | 31 | 98.4 | 0 | 243 | 1 | 25 | 105 | PVD22824.1 hypothetical protein C0Q70_16080 [Pomacea canaliculata] | diamond | 243 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 31357552 | 31357552 | PRJNA635874_P_NODE_49496_length_250_cov_0.870056_g49349_i0 | PRJNA635874 | 49496 | 250 | 0.870056 | 2.17514 | Mollusca | 6447 | Mollusca | Mollusca | 53.1 | 8.55e-6 | NR | XP_022332114.1 | 6565 | g49349 | i0 | 40.8 | 1.68 | 71 | 39 | 81.6 | 1 | 228 | 25 | 153 | 223 | XP_022332114.1 ribosome biogenesis protein NOP53-like isoform X1 [Crassostrea virginica] | diamond | 420 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32842913 | 32842913 | PRJNA635874_P_NODE_50120_length_250_cov_0.870056_g49973_i0 | PRJNA635874 | 50120 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47 | 3.13e-4 | NR | KAL5016484.1 | 13268 | g49973 | i0 | 45.8 | 6.12 | 59 | 23 | 60 | 1 | 2 | 151 | 46 | 104 | KAL5016484.1 hypothetical protein ScPMuIL_006073 [Solemya velum] | diamond | 1530 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum |
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);;