contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA879067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5957609 | 5957609 | PRJNA879067_P_NODE_21565_length_960_cov_9.497182_g18562_i0 | PRJNA879067 | 21565 | 960 | 9.497182 | 91.1729472 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 3.8100000000000005e-64 | NR | XP_052092394.1 | 6549 | g18562 | i0 | 49.4 | 26.671875 | 251 | 56 | 76.6 | 2 | 183 | 917 | 1 | 186 | XP_052092394.1 ras-related protein Rap-1b [Mytilus californianus] | diamond | 25605 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 25081176 | 25081176 | PRJNA879067_P_NODE_44600_length_574_cov_2.934132_g41138_i0 | PRJNA879067 | 44600 | 574 | 2.934132 | 16.84191768 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 77.4 | 2.85e-13 | NR | XP_061170018.1 | 191078 | g41138 | i0 | 71.7 | 2.13240418118467 | 46 | 13 | 24 | 0 | 92 | 229 | 74 | 119 | XP_061170018.1 L-proline trans-4-hydroxylase-like [Saccostrea echinata] | diamond | 1224 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 27379608 | 27379608 | PRJNA879067_P_NODE_85943_length_314_cov_1.917012_g82457_i0 | PRJNA879067 | 85943 | 314 | 1.917012 | 6.01941768 | Metazoa | 33208 | Mollusca | Mollusca | 84 | 1.8e-17 | NR | KAK6166320.1 | 87958 | g82457 | i0 | 47 | 1.69108280254777 | 83 | 44 | 79.3 | 0 | 274 | 26 | 101 | 183 | KAK6166320.1 hypothetical protein SNE40_023045 [Patella caerulea] | diamond | 531 | 84.3 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 27568743 | 27568743 | PRJNA879067_P_NODE_34424_length_695_cov_2.443730_g31039_i0 | PRJNA879067 | 34424 | 695 | 2.44373 | 16.9839235 | Bivalvia | 6544 | Mollusca | Mollusca | 124 | 7.58e-30 | NR | XP_045161197.2 | 6596 | g31039 | i0 | 43.3 | 2.30935251798561 | 157 | 80 | 66.5 | 5 | 541 | 80 | 186 | 336 | XP_045161197.2 uncharacterized protein DDB_G0292642-like [Mercenaria mercenaria] | diamond | 1605 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27915988 | 27915988 | PRJNA879067_P_NODE_19385_length_1030_cov_53.656217_g12059_i1 | PRJNA879067 | 19385 | 1030 | 53.656217 | 552.6590351 | Mollusca | 6447 | Mollusca | Mollusca | 126 | 1.2299999999999998e-29 | NR | XP_064602326.1 | 13599 | g12059 | i1 | 37.2 | 5.78446601941748 | 183 | 74 | 53 | 3 | 1 | 546 | 81 | 223 | XP_064602326.1 uncharacterized protein LOC135468167 [Liolophura japonica] | diamond | 5958 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 28294982 | 28294982 | PRJNA879067_P_NODE_23226_length_911_cov_47.229117_g12059_i3 | PRJNA879067 | 23226 | 911 | 47.229117 | 430.25725587 | Metazoa | 33208 | Mollusca | Mollusca | 115 | 4.78e-26 | NR | KAL5008616.1 | 13268 | g12059 | i3 | 36.8 | 2.69374313940724 | 163 | 62 | 53.3 | 3 | 487 | 2 | 66 | 188 | KAL5008616.1 hypothetical protein ScPMuIL_014197 [Solemya velum] | diamond | 2454 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 29707399 | 29707399 | PRJNA879067_P_NODE_65690_length_412_cov_5.191740_g62205_i0 | PRJNA879067 | 65690 | 412 | 5.19174 | 21.3899688 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 115 | 6.15e-30 | NR | BFZ04022.1 | 145626 | g62205 | i0 | 77 | 0.538834951456311 | 74 | 17 | 53.9 | 0 | 412 | 191 | 27 | 100 | BFZ04022.1 hypothetical protein BsWGS_07061 [Bradybaena similaris] | diamond | 222 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 30023850 | 30023850 | PRJNA879067_P_NODE_104371_length_249_cov_3.136364_g100885_i0 | PRJNA879067 | 104371 | 249 | 3.136364 | 7.80954636 | Mya arenaria | 6604 | Mollusca | Mollusca | 82.8 | 2.01e-17 | NR | WAR00835.1 | 6604 | g100885 | i0 | 68.9 | 3.78313253012048 | 61 | 19 | 73.5 | 0 | 246 | 64 | 135 | 195 | WAR00835.1 COMD5-like protein [Mya arenaria] | diamond | 942 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30031787 | 30031787 | PRJNA879067_P_NODE_14651_length_1242_cov_41.782720_g12059_i0 | PRJNA879067 | 14651 | 1242 | 41.78272 | 518.9413824 | Mollusca | 6447 | Mollusca | Mollusca | 108 | 1.39e-22 | NR | XP_064602326.1 | 13599 | g12059 | i0 | 30.7 | 2.91787439613527 | 225 | 73 | 54.1 | 4 | 1 | 672 | 81 | 223 | XP_064602326.1 uncharacterized protein LOC135468167 [Liolophura japonica] | diamond | 3624 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 30086783 | 30086783 | PRJNA879067_P_NODE_40292_length_619_cov_68.606227_g12059_i5 | PRJNA879067 | 40292 | 619 | 68.606227 | 424.67254513 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 112 | 4.81e-26 | NR | VDI22696.1 | 29158 | g12059 | i5 | 32.2 | 6.98384491114701 | 208 | 71 | 99.8 | 4 | 619 | 2 | 70 | 209 | VDI22696.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 4323 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 30094741 | 30094741 | PRJNA879067_P_NODE_94312_length_283_cov_1.085714_g90826_i0 | PRJNA879067 | 94312 | 283 | 1.085714 | 3.07257062 | Metazoa | 33208 | Mollusca | Mollusca | 91.7 | 7.57e-20 | NR | XP_064610305.1 | 13599 | g90826 | i0 | 44.7 | 1.99293286219081 | 94 | 51 | 99.6 | 1 | 282 | 1 | 100 | 192 | XP_064610305.1 shiftless antiviral inhibitor of ribosomal frameshifting protein homolog [Liolophura japonica] | diamond | 564 | 92 | 0.996739130434783 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 30126276 | 30126276 | PRJNA879067_P_NODE_91032_length_294_cov_2.511312_g87546_i0 | PRJNA879067 | 91032 | 294 | 2.511312 | 7.38325728 | Metazoa | 33208 | Mollusca | Mollusca | 89 | 1.28e-18 | NR | XP_021360166.1 | 6573 | g87546 | i0 | 48.4 | 2.89795918367347 | 93 | 46 | 94.9 | 1 | 1 | 279 | 206 | 296 | XP_021360166.1 very-long-chain 3-oxoacyl-CoA reductase-like [Mizuhopecten yessoensis] | diamond | 852 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 31264015 | 31264015 | PRJNA879067_P_NODE_25655_length_852_cov_57.370988_g12059_i4 | PRJNA879067 | 25655 | 852 | 57.370988 | 488.80081776 | Metazoa | 33208 | Mollusca | Mollusca | 115 | 2.98e-26 | NR | KAL5008616.1 | 13268 | g12059 | i4 | 36.8 | 2.88028169014085 | 163 | 62 | 57 | 3 | 366 | 851 | 66 | 188 | KAL5008616.1 hypothetical protein ScPMuIL_014197 [Solemya velum] | diamond | 2454 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 31287433 | 31287433 | PRJNA879067_P_NODE_105335_length_248_cov_0.880000_g101849_i0 | PRJNA879067 | 105335 | 248 | 0.88 | 2.1824 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 90.9 | 8.64e-22 | NR | OWF51731.1 | 6573 | g101849 | i0 | 55.3 | 0.919354838709677 | 76 | 32 | 91.9 | 1 | 240 | 13 | 11 | 84 | OWF51731.1 hypothetical protein KP79_PYT00678 [Mizuhopecten yessoensis] | diamond | 228 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32236992 | 32236992 | PRJNA879067_P_NODE_69418_length_391_cov_2.924528_g65933_i0 | PRJNA879067 | 69418 | 391 | 2.924528 | 11.43490448 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 46.6 | 0.00785 | NR | CAE1243621.1 | 158019 | g65933 | i0 | 40.2 | 0.629156010230179 | 82 | 40 | 56 | 2 | 36 | 254 | 115 | 196 | CAE1243621.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 246 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32686891 | 32686891 | PRJNA879067_P_NODE_22720_length_924_cov_52.775558_g12059_i2 | PRJNA879067 | 22720 | 924 | 52.775558 | 487.64615592 | Metazoa | 33208 | Mollusca | Mollusca | 115 | 5.24e-26 | NR | KAL5008616.1 | 13268 | g12059 | i2 | 36.8 | 2.65584415584416 | 163 | 62 | 52.6 | 3 | 438 | 923 | 66 | 188 | KAL5008616.1 hypothetical protein ScPMuIL_014197 [Solemya velum] | diamond | 2454 | 115 | 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);;