contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA255848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26979066 | 26979066 | PRJNA255848_P_NODE_38482_length_166_cov_0.871795_g38164_i0 | PRJNA255848 | 38482 | 166 | 0.871795 | 1.4471797 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 79.7 | 1.22e-15 | NR | XP_055877482.1 | 6526 | g38164 | i0 | 50.9 | 0.993975903614458 | 55 | 27 | 99.4 | 0 | 2 | 166 | 993 | 1047 | XP_055877482.1 uncharacterized protein LOC129924775 [Biomphalaria glabrata] | diamond | 165 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27217931 | 27217931 | PRJNA255848_P_NODE_29102_length_184_cov_1.629630_g28784_i0 | PRJNA255848 | 29102 | 184 | 1.62963 | 2.9985192 | root | 1 | Root_unresolved | Root_unresolved | 124 | 5.79e-34 | NR | XP_050414269.1 | 6465 | g28784 | i0 | 98.4 | 460.451086956522 | 61 | 1 | 99.5 | 0 | 1 | 183 | 36 | 96 | XP_050414269.1 ras-like GTP-binding protein RHO isoform X1 [Patella vulgata] | diamond | 84723 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 28905408 | 28905408 | PRJNA255848_P_NODE_41408_length_164_cov_0.886957_g41090_i0 | PRJNA255848 | 41408 | 164 | 0.886957 | 1.45460948 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 108 | 2.9e-26 | NR | KAK6980048.1 | 6526 | g41090 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 3 | 164 | 197 | 250 | KAK6980048.1 A disintegrin and metalloproteinase with thrombospondin motifs 9, partial [Biomphalaria glabrata] | diamond | 162 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29144732 | 29144732 | PRJNA255848_P_NODE_42349_length_164_cov_0.886957_g42031_i0 | PRJNA255848 | 42349 | 164 | 0.886957 | 1.45460948 | Metazoa | 33208 | Mollusca | Mollusca | 127 | 1.2499999999999999e-34 | NR | XP_046365003.1 | 6454 | g42031 | i0 | 100 | 303.091463414634 | 54 | 0 | 98.8 | 0 | 164 | 3 | 170 | 223 | XP_046365003.1 zinc finger CCHC domain-containing protein 24-like isoform X4 [Haliotis rufescens] | diamond | 49707 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29207722 | 29207722 | PRJNA255848_P_NODE_39689_length_165_cov_0.879310_g39371_i0 | PRJNA255848 | 39689 | 165 | 0.87931 | 1.4508615 | Metazoa | 33208 | Mollusca | Mollusca | 108 | 8.49e-29 | NR | XP_052070663.1 | 6549 | g39371 | i0 | 94.4 | 140.4 | 54 | 3 | 98.2 | 0 | 4 | 165 | 45 | 98 | XP_052070663.1 NHP2-like protein 1 [Mytilus californianus] | diamond | 23166 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 29379269 | 29379269 | PRJNA255848_P_NODE_41169_length_164_cov_0.886957_g40851_i0 | PRJNA255848 | 41169 | 164 | 0.886957 | 1.45460948 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 57.4 | 5.45e-8 | NR | CAC5426311.1 | 42192 | g40851 | i0 | 51 | 1.8109756097561 | 49 | 24 | 89.6 | 0 | 154 | 8 | 144 | 192 | CAC5426311.1 unnamed protein product [Mytilus coruscus] | diamond | 297 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 29459829 | 29459829 | PRJNA255848_P_NODE_33390_length_171_cov_1.672131_g33072_i0 | PRJNA255848 | 33390 | 171 | 1.672131 | 2.85934401 | Metazoa | 33208 | Mollusca | Mollusca | 47.4 | 3.22e-4 | NR | XP_053382588.1 | 6596 | g33072 | i0 | 64.5 | 3.70175438596491 | 31 | 11 | 54.4 | 0 | 170 | 78 | 400 | 430 | XP_053382588.1 sal-like protein 1 isoform X6 [Mercenaria mercenaria] | diamond | 633 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29505432 | 29505432 | PRJNA255848_P_NODE_14070_length_268_cov_1.287671_g13752_i0 | PRJNA255848 | 14070 | 268 | 1.287671 | 3.45095828 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 48.5 | 4.77e-4 | NR | VDI70803.1 | 29158 | g13752 | i0 | 87.5 | 0.671641791044776 | 24 | 3 | 26.9 | 0 | 1 | 72 | 812 | 835 | VDI70803.1 Hypothetical predicted protein, partial [Mytilus galloprovincialis] | diamond | 180 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 29586129 | 29586129 | PRJNA255848_P_NODE_34890_length_167_cov_1.474576_g34572_i0 | PRJNA255848 | 34890 | 167 | 1.474576 | 2.46254192 | Metazoa | 33208 | Mollusca | Mollusca | 118 | 2.69e-29 | NR | XP_050400908.1 | 6465 | g34572 | i0 | 98.1 | 318.161676646707 | 54 | 1 | 97 | 0 | 2 | 163 | 1394 | 1447 | XP_050400908.1 DNA (cytosine-5)-methyltransferase 1 [Patella vulgata] | diamond | 53133 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 29617651 | 29617651 | PRJNA255848_P_NODE_25310_length_198_cov_1.134228_g24992_i0 | PRJNA255848 | 25310 | 198 | 1.134228 | 2.24577144 | Metazoa | 33208 | Mollusca | Mollusca | 133 | 1.73e-37 | NR | XP_053376697.1 | 6596 | g24992 | i0 | 98.5 | 145.757575757576 | 65 | 1 | 98.5 | 0 | 196 | 2 | 117 | 181 | XP_053376697.1 40S ribosomal protein S23-like [Mercenaria mercenaria] | diamond | 28860 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29933970 | 29933970 | PRJNA255848_P_NODE_17391_length_239_cov_1.610526_g17073_i0 | PRJNA255848 | 17391 | 239 | 1.610526 | 3.84915714 | Metazoa | 33208 | Mollusca | Mollusca | 45.4 | 0.00391 | NR | OWF51016.1 | 6573 | g17073 | i0 | 95.5 | 56.0585774058577 | 22 | 1 | 27.6 | 0 | 238 | 173 | 509 | 530 | OWF51016.1 Tubulin alpha-1A chain [Mizuhopecten yessoensis] | diamond | 13398 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30249976 | 30249976 | PRJNA255848_P_NODE_35152_length_167_cov_0.864407_g34834_i0 | PRJNA255848 | 35152 | 167 | 0.864407 | 1.44355969 | Pectinidae | 6566 | Mollusca | Mollusca | 67 | 1.99e-12 | NR | XP_033740569.1 | 6579 | g34834 | i0 | 64 | 1.79640718562874 | 50 | 18 | 89.8 | 0 | 150 | 1 | 60 | 109 | XP_033740569.1 prefoldin subunit 1-like isoform X2 [Pecten maximus] | diamond | 300 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 30281743 | 30281743 | PRJNA255848_P_NODE_29232_length_184_cov_1.133333_g28914_i0 | PRJNA255848 | 29232 | 184 | 1.133333 | 2.08533272 | Metazoa | 33208 | Mollusca | Mollusca | 124 | 1.13e-32 | NR | XP_050408485.1 | 6465 | g28914 | i0 | 96.7 | 85.5326086956522 | 61 | 2 | 99.5 | 0 | 184 | 2 | 154 | 214 | XP_050408485.1 DDB1- and CUL4-associated factor 7 [Patella vulgata] | diamond | 15738 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 30453428 | 30453428 | PRJNA255848_P_NODE_47533_length_161_cov_0.910714_g47215_i0 | PRJNA255848 | 47533 | 161 | 0.910714 | 1.46624954 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 82 | 5.28e-17 | NR | OWF36543.1 | 6573 | g47215 | i0 | 90.7 | 8.51552795031056 | 43 | 4 | 80.1 | 0 | 130 | 2 | 36 | 78 | OWF36543.1 Proteasome subunit alpha type-6 [Mizuhopecten yessoensis] | diamond | 1371 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30547914 | 30547914 | PRJNA255848_P_NODE_30673_length_179_cov_1.961538_g30355_i0 | PRJNA255848 | 30673 | 179 | 1.961538 | 3.51115302 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 101 | 1.82e-24 | NR | XP_060589418.1 | 129788 | g30355 | i0 | 98 | 25.8268156424581 | 50 | 1 | 83.8 | 0 | 28 | 177 | 18 | 67 | XP_060589418.1 proteasome subunit alpha type-4-like [Ruditapes philippinarum] | diamond | 4623 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 30642584 | 30642584 | PRJNA255848_P_NODE_13173_length_278_cov_6.676856_g12855_i0 | PRJNA255848 | 13173 | 278 | 6.676856 | 18.561659680000002 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 79.3 | 7.1e-17 | NR | KAK3580123.1 | 2493646 | g12855 | i0 | 54.1 | 0.91726618705036 | 85 | 34 | 89.6 | 2 | 249 | 1 | 2 | 83 | KAK3580123.1 hypothetical protein CHS0354_034063 [Potamilus streckersoni] | diamond | 255 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 31545656 | 31545656 | PRJNA255848_P_NODE_32916_length_173_cov_1.177419_g32598_i0 | PRJNA255848 | 32916 | 173 | 1.177419 | 2.03693487 | root | 1 | Root_unresolved | Root_unresolved | 63.2 | 2.21e-11 | NR | CAL1530465.1 | 6523 | g32598 | i0 | 96.9 | 26.0635838150289 | 32 | 1 | 55.5 | 0 | 2 | 97 | 47 | 78 | CAL1530465.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 4509 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 31577242 | 31577242 | PRJNA255848_P_NODE_45016_length_162_cov_0.902655_g44698_i0 | PRJNA255848 | 45016 | 162 | 0.902655 | 1.4623011 | Metazoa | 33208 | Mollusca | Mollusca | 48.5 | 1.15e-4 | NR | WAR18151.1 | 6604 | g44698 | i0 | 58.6 | 11.1481481481481 | 29 | 12 | 53.7 | 0 | 1 | 87 | 78 | 106 | WAR18151.1 ZN658-like protein [Mya arenaria] | diamond | 1806 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31970560 | 31970560 | PRJNA255848_P_NODE_21078_length_217_cov_1.214286_g20760_i0 | PRJNA255848 | 21078 | 217 | 1.214286 | 2.63500062 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 99 | 1.6000000000000002e-22 | NR | KAJ8318490.1 | 220873 | g20760 | i0 | 90.4 | 34.8801843317972 | 52 | 5 | 71.9 | 0 | 157 | 2 | 8 | 59 | KAJ8318490.1 hypothetical protein KUTeg_003581 [Tegillarca granosa] | diamond | 7569 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 32477031 | 32477031 | PRJNA255848_P_NODE_32479_length_174_cov_1.456000_g32161_i0 | PRJNA255848 | 32479 | 174 | 1.456 | 2.53344 | Aplysia californica | 6500 | Mollusca | Mollusca | 55.5 | 7.38e-8 | NR | XP_005093289.1 | 6500 | g32161 | i0 | 95.5 | 7.96551724137931 | 22 | 1 | 37.9 | 0 | 174 | 109 | 105 | 126 | XP_005093289.1 histidine triad nucleotide-binding protein 1 [Aplysia californica] | diamond | 1386 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;