contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA454503" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2992845 | 2992845 | PRJNA454503_P_NODE_23803_length_254_cov_1.010363_g23474_i0 | PRJNA454503 | 23803 | 254 | 1.010363 | 2.56632202 | Metazoa | 33208 | Mollusca | Mollusca | 123 | 1.11e-32 | NR | CAG5119797.1 | 100452 | g23474 | i0 | 67.9 | 14.8818897637795 | 84 | 27 | 99.2 | 0 | 252 | 1 | 94 | 177 | CAG5119797.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 3780 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 13196300 | 13196300 | PRJNA454503_P_NODE_63991_length_208_cov_1.326531_g63662_i0 | PRJNA454503 | 63991 | 208 | 1.326531 | 2.75918448 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 129 | 3.31e-35 | NR | KAK7487898.1 | 370345 | g63662 | i0 | 84.1 | 8.95673076923077 | 69 | 11 | 99.5 | 0 | 1 | 207 | 98 | 166 | KAK7487898.1 hypothetical protein BaRGS_00020799 [Batillaria attramentaria] | diamond | 1863 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 15744930 | 15744930 | PRJNA454503_P_NODE_29813_length_240_cov_0.798883_g29484_i0 | PRJNA454503 | 29813 | 240 | 0.798883 | 1.9173192 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 82 | 2.01e-16 | NR | CAG5118257.1 | 100452 | g29484 | i0 | 63.8 | 3.5875 | 58 | 21 | 72.5 | 0 | 224 | 51 | 137 | 194 | CAG5118257.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 861 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 21495737 | 21495737 | PRJNA454503_P_NODE_82917_length_203_cov_0.915493_g82588_i0 | PRJNA454503 | 82917 | 203 | 0.915493 | 1.85845079 | Gastropoda | 6448 | Mollusca | Mollusca | 114 | 1.3800000000000002e-27 | NR | KAK7112907.1 | 31220 | g82588 | i0 | 80.3 | 3.90147783251232 | 66 | 13 | 97.5 | 0 | 202 | 5 | 227 | 292 | KAK7112907.1 hypothetical protein V1264_012283 [Littorina saxatilis] | diamond | 792 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27218519 | 27218519 | PRJNA454503_P_NODE_57762_length_210_cov_0.872483_g57433_i0 | PRJNA454503 | 57762 | 210 | 0.872483 | 1.8322143 | Metazoa | 33208 | Mollusca | Mollusca | 134 | 1.28e-34 | NR | XP_050417664.1 | 6465 | g57433 | i0 | 86.8 | 210.8 | 68 | 9 | 97.1 | 0 | 2 | 205 | 509 | 576 | XP_050417664.1 brain tumor protein [Patella vulgata] | diamond | 44268 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 27945218 | 27945218 | PRJNA454503_P_NODE_10445_length_347_cov_1.360140_g10116_i0 | PRJNA454503 | 10445 | 347 | 1.36014 | 4.7196858 | Metazoa | 33208 | Mollusca | Mollusca | 56.6 | 1.6e-6 | NR | XP_014774550.1 | 37653 | g10116 | i0 | 40.2 | 1.68587896253602 | 82 | 46 | 70.9 | 1 | 77 | 322 | 5 | 83 | XP_014774550.1 sialin, partial [Octopus bimaculoides] | diamond | 585 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 28529059 | 28529059 | PRJNA454503_P_NODE_55107_length_211_cov_0.866667_g54778_i0 | PRJNA454503 | 55107 | 211 | 0.866667 | 1.82866737 | Argopecten irradians | 31199 | Mollusca | Mollusca | 58.9 | 4.97e-8 | NR | XP_069108705.1 | 31199 | g54778 | i0 | 72.2 | 3.58293838862559 | 36 | 10 | 51.2 | 0 | 108 | 1 | 2371 | 2406 | XP_069108705.1 low-density lipoprotein receptor-related protein 2-like isoform X6 [Argopecten irradians] | diamond | 756 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 29271085 | 29271085 | PRJNA454503_P_NODE_72909_length_206_cov_0.896552_g72580_i0 | PRJNA454503 | 72909 | 206 | 0.896552 | 1.84689712 | Mollusca | 6447 | Mollusca | Mollusca | 101 | 5.649999999999999e-23 | NR | VDI59418.1 | 29158 | g72580 | i0 | 78.5 | 10.2961165048544 | 65 | 14 | 94.7 | 0 | 204 | 10 | 691 | 755 | VDI59418.1 Hypothetical predicted protein, partial [Mytilus galloprovincialis] | diamond | 2121 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 29602062 | 29602062 | PRJNA454503_P_NODE_55450_length_211_cov_0.866667_g55121_i0 | PRJNA454503 | 55450 | 211 | 0.866667 | 1.82866737 | Ostrea edulis | 37623 | Mollusca | Mollusca | 118 | 2.45e-30 | NR | XP_048735686.2 | 37623 | g55121 | i0 | 75.7 | 0.995260663507109 | 70 | 17 | 99.5 | 0 | 210 | 1 | 30 | 99 | XP_048735686.2 uncharacterized protein LOC125651138 [Ostrea edulis] | diamond | 210 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 29997714 | 29997714 | PRJNA454503_P_NODE_12971_length_316_cov_1.019608_g12642_i0 | PRJNA454503 | 12971 | 316 | 1.019608 | 3.22196128 | root | 1 | Root_unresolved | Root_unresolved | 65.5 | 4.6e-11 | NR | XP_062617118.1 | 36930 | g12642 | i0 | 55.8 | 3.90189873417722 | 52 | 23 | 49.4 | 0 | 76 | 231 | 69 | 120 | XP_062617118.1 universal stress protein in QAH/OAS sulfhydrylase 3'region-like isoform X4 [Saccostrea cuccullata] | diamond | 1233 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 30250555 | 30250555 | PRJNA454503_P_NODE_33052_length_235_cov_1.862069_g32723_i0 | PRJNA454503 | 33052 | 235 | 1.862069 | 4.37586215 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 7.74e-4 | NR | KAK3101413.1 | 66713 | g32723 | i0 | 39.4 | 4.55744680851064 | 71 | 37 | 85.5 | 3 | 205 | 5 | 194 | 262 | KAK3101413.1 hypothetical protein FSP39_003367 [Pinctada imbricata] | diamond | 1071 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 32400439 | 32400439 | PRJNA454503_P_NODE_45239_length_221_cov_1.218750_g44910_i0 | PRJNA454503 | 45239 | 221 | 1.21875 | 2.6934375 | Neogastropoda | 6479 | Mollusca | Mollusca | 64.3 | 5.69e-11 | NR | KAH9513575.1 | 55810 | g44910 | i0 | 52.6 | 4.08597285067873 | 57 | 27 | 77.4 | 0 | 194 | 24 | 1 | 57 | KAH9513575.1 hypothetical protein Btru_033396 [Bulinus truncatus] | diamond | 903 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 32415846 | 32415846 | PRJNA454503_P_NODE_71959_length_206_cov_0.896552_g71630_i0 | PRJNA454503 | 71959 | 206 | 0.896552 | 1.84689712 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 58.9 | 4.48e-8 | NR | XP_062598636.1 | 36930 | g71630 | i0 | 48.1 | 0.757281553398058 | 52 | 27 | 75.7 | 0 | 43 | 198 | 175 | 226 | XP_062598636.1 LOW QUALITY PROTEIN: uncharacterized protein LOC134260066 [Saccostrea cuccullata] | diamond | 156 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata |
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);;