contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJDB12134" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14028032 | 14028032 | PRJDB12134_P_NODE_10012_length_289_cov_1.162037_g9877_i0 | PRJDB12134 | 10012 | 289 | 1.162037 | 3.35828693 | Homarus americanus | 6706 | Arthropoda | Arthropoda | 149 | 4.34e-44 | NR | KAG7167476.1 | 6706 | g9877 | i0 | 85.4 | 0.85121107266436 | 82 | 12 | 85.1 | 0 | 2 | 247 | 50 | 131 | KAG7167476.1 60S ribosomal protein L27a-like, partial [Homarus americanus] | diamond | 246 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Nephropidae | Homarus | Homarus americanus | |
| 26652255 | 26652255 | PRJDB12134_P_NODE_9921_length_290_cov_1.552995_g9786_i0 | PRJDB12134 | 9921 | 290 | 1.552995 | 4.5036855 | Phaeosphaeriaceae sp. SRC1lsM3a | 765868 | Fungi | Fungi | 79.7 | 6.58e-15 | NR | OAL01598.1 | 765868 | g9786 | i0 | 43.9 | 0.848275862068966 | 82 | 46 | 84.8 | 0 | 246 | 1 | 133 | 214 | OAL01598.1 HET-domain-containing protein [Phaeosphaeriaceae sp. SRC1lsM3a] | diamond | 246 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Phaeosphaeriaceae sp. SRC1lsM3a | ||
| 26937312 | 26937312 | PRJDB12134_P_NODE_11502_length_266_cov_1.253886_g11367_i0 | PRJDB12134 | 11502 | 266 | 1.253886 | 3.33533676 | Stegodyphus dumicola | 202533 | Arthropoda | Arthropoda | 48.1 | 6.08e-4 | NR | XP_035219410.1 | 202533 | g11367 | i0 | 63.6 | 0.37218045112782 | 33 | 12 | 37.2 | 0 | 207 | 109 | 1 | 33 | XP_035219410.1 endosome/lysosome-associated apoptosis and autophagy regulator family member 2-like [Stegodyphus dumicola] | diamond | 99 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Eresidae | Stegodyphus | Stegodyphus dumicola | |
| 27095538 | 27095538 | PRJDB12134_P_NODE_11022_length_273_cov_1.560000_g10887_i0 | PRJDB12134 | 11022 | 273 | 1.56 | 4.2588 | Pneumocystis canis | 2698477 | Fungi | Fungi | 43.9 | 0.0206 | NR | KAG5440696.1 | 2698477 | g10887 | i0 | 42.6 | 0.516483516483517 | 47 | 22 | 51.6 | 1 | 102 | 242 | 208 | 249 | KAG5440696.1 hypothetical protein PCK2_000284 [Pneumocystis canis] | diamond | 141 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis canis | |
| 27126755 | 27126755 | PRJDB12134_P_NODE_10662_length_279_cov_1.509709_g10527_i0 | PRJDB12134 | 10662 | 279 | 1.509709 | 4.21208811 | Polyporus arcularius HHB13444 | 1314778 | Fungi | Fungi | 96.7 | 6.240000000000001e-21 | NR | TFK82823.1 | 1314778 | g10527 | i0 | 78 | 0.537634408602151 | 50 | 11 | 53.8 | 0 | 201 | 52 | 153 | 202 | TFK82823.1 acyl-CoA dehydrogenase NM domain-like protein [Polyporus arcularius HHB13444] | diamond | 150 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Polyporus | Polyporus arcularius | |
| 27538022 | 27538022 | PRJDB12134_P_NODE_12404_length_252_cov_0.871508_g12269_i0 | PRJDB12134 | 12404 | 252 | 0.871508 | 2.19620016 | Sus scrofa | 9823 | Chordata | Chordata | 59.3 | 6.08e-8 | NR | XP_020937328.1 | 9823 | g12269 | i0 | 61.7 | 0.55952380952381 | 47 | 18 | 56 | 0 | 17 | 157 | 18 | 64 | XP_020937328.1 collagen alpha-2(I) chain-like [Sus scrofa] | diamond | 141 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 27538027 | 27538027 | PRJDB12134_P_NODE_6624_length_393_cov_1.290625_g6489_i0 | PRJDB12134 | 6624 | 393 | 1.290625 | 5.07215625 | Trinorchestia longiramus | 1923959 | Arthropoda | Arthropoda | 124 | 5.429999999999999e-31 | NR | KAF2367561.1 | 1923959 | g6489 | i0 | 58.7 | 1.6412213740458 | 104 | 42 | 78.6 | 1 | 49 | 357 | 257 | 360 | KAF2367561.1 Reverse transcriptase domain [Trinorchestia longiramus] | diamond | 645 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Amphipoda | Talitridae | Trinorchestia | Trinorchestia longiramus | |
| 27727740 | 27727740 | PRJDB12134_P_NODE_8864_length_316_cov_1.901235_g8729_i0 | PRJDB12134 | 8864 | 316 | 1.901235 | 6.0079026 | Petrolisthes manimaculis | 1843537 | Arthropoda | Arthropoda | 62 | 1.42e-8 | NR | KAK4315231.1 | 1843537 | g8729 | i0 | 39.2 | 0.920886075949367 | 97 | 49 | 85.4 | 3 | 2 | 271 | 314 | 407 | KAK4315231.1 hypothetical protein Pmani_013537 [Petrolisthes manimaculis] | diamond | 291 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes manimaculis | |
| 27790648 | 27790648 | PRJDB12134_P_NODE_6584_length_395_cov_1.419255_g6449_i0 | PRJDB12134 | 6584 | 395 | 1.419255 | 5.60605725 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 120 | 1.9e-32 | NR | KAK3890218.1 | 88211 | g6449 | i0 | 61.1 | 0.721518987341772 | 95 | 37 | 72.2 | 0 | 394 | 110 | 24 | 118 | KAK3890218.1 hypothetical protein Pcinc_005753 [Petrolisthes cinctipes] | diamond | 285 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 28011754 | 28011754 | PRJDB12134_P_NODE_2865_length_661_cov_2.824830_g2739_i0 | PRJDB12134 | 2865 | 661 | 2.82483 | 18.6721263 | Chionoecetes opilio | 41210 | Arthropoda | Arthropoda | 46.6 | 0.0485 | NR | KAG0699337.1 | 41210 | g2739 | i0 | 39.7 | 0.354009077155825 | 78 | 33 | 30.4 | 3 | 102 | 302 | 446 | 520 | KAG0699337.1 Solute carrier family 22 member 13 [Chionoecetes opilio] | diamond | 234 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Majidae | Chionoecetes | Chionoecetes opilio | |
| 28422194 | 28422194 | PRJDB12134_P_NODE_11166_length_271_cov_1.666667_g11031_i0 | PRJDB12134 | 11166 | 271 | 1.666667 | 4.51666757 | Procambarus clarkii | 6728 | Arthropoda | Arthropoda | 53.1 | 1.16e-5 | NR | XP_069186597.1 | 6728 | g11031 | i0 | 75.8 | 0.365313653136531 | 33 | 8 | 36.5 | 0 | 99 | 1 | 543 | 575 | XP_069186597.1 uncharacterized protein [Procambarus clarkii] | diamond | 99 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Cambaridae | Procambarus | Procambarus clarkii | |
| 28737792 | 28737792 | PRJDB12134_P_NODE_9987_length_289_cov_1.439815_g9852_i0 | PRJDB12134 | 9987 | 289 | 1.439815 | 4.16106535 | Tilletiaria anomala UBC 951 | 1037660 | Fungi | Fungi | 161 | 1.5699999999999996e-43 | NR | XP_013241569.1 | 1037660 | g9852 | i0 | 84.2 | 0.986159169550173 | 95 | 15 | 98.6 | 0 | 3 | 287 | 630 | 724 | XP_013241569.1 uncharacterized protein K437DRAFT_258484 [Tilletiaria anomala UBC 951] | diamond | 285 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Tilletiariaceae | Tilletiaria | Tilletiaria anomala | |
| 29621331 | 29621331 | PRJDB12134_P_NODE_10870_length_276_cov_1.221675_g10735_i0 | PRJDB12134 | 10870 | 276 | 1.221675 | 3.371823 | Trachymyrmex zeteki | 64791 | Arthropoda | Arthropoda | 48.5 | 3.89e-5 | NR | KYQ51146.1 | 64791 | g10735 | i0 | 70 | 0.793478260869565 | 40 | 12 | 43.5 | 0 | 201 | 82 | 1 | 40 | KYQ51146.1 hypothetical protein ALC60_09794 [Trachymyrmex zeteki] | diamond | 219 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Mycetomoellerius | Mycetomoellerius zeteki | |
| 29653059 | 29653059 | PRJDB12134_P_NODE_8610_length_324_cov_2.167331_g8475_i0 | PRJDB12134 | 8610 | 324 | 2.167331 | 7.02215244 | Portunus trituberculatus | 210409 | Arthropoda | Arthropoda | 64.7 | 3.75e-10 | NR | MPC32819.1 | 210409 | g8475 | i0 | 50 | 0.555555555555556 | 60 | 30 | 55.6 | 0 | 141 | 320 | 47 | 106 | MPC32819.1 hypothetical protein [Portunus trituberculatus] | diamond | 180 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Portunidae | Portunus | Portunus trituberculatus | |
| 30158505 | 30158505 | PRJDB12134_P_NODE_14052_length_243_cov_2.664706_g13917_i0 | PRJDB12134 | 14052 | 243 | 2.664706 | 6.47523558 | Polyplosphaeria fusca | 682080 | Fungi | Fungi | 142 | 7.13e-38 | NR | KAF2726653.1 | 682080 | g13917 | i0 | 80.2 | 4 | 81 | 16 | 100 | 0 | 1 | 243 | 374 | 454 | KAF2726653.1 purine-cytosine permease FCY21 [Polyplosphaeria fusca] | diamond | 972 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Tetraplosphaeriaceae | Polyplosphaeria | Polyplosphaeria fusca | |
| 30285542 | 30285542 | PRJDB12134_P_NODE_10852_length_276_cov_1.458128_g10717_i0 | PRJDB12134 | 10852 | 276 | 1.458128 | 4.02443328 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 62 | 9.22e-9 | NR | KAK3890060.1 | 88211 | g10717 | i0 | 71.1 | 0.41304347826087 | 38 | 11 | 41.3 | 0 | 149 | 262 | 751 | 788 | KAK3890060.1 hypothetical protein Pcinc_005975 [Petrolisthes cinctipes] | diamond | 114 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 30343028 | 30343028 | PRJDB12134_P_NODE_13072_length_249_cov_0.880682_g12937_i0 | PRJDB12134 | 13072 | 249 | 0.880682 | 2.19289818 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 84 | 8.35e-17 | NR | KAJ8029733.1 | 206669 | g12937 | i0 | 50.6 | 3.8433734939759 | 79 | 39 | 95.2 | 0 | 242 | 6 | 270 | 348 | KAJ8029733.1 hypothetical protein HOLleu_29203 [Holothuria leucospilota] | diamond | 957 | 84.3 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30348872 | 30348872 | PRJDB12134_P_NODE_13092_length_249_cov_0.880682_g12957_i0 | PRJDB12134 | 13092 | 249 | 0.880682 | 2.19289818 | Stegodyphus dumicola | 202533 | Arthropoda | Arthropoda | 73.6 | 5.66e-13 | NR | XP_035210635.1 | 202533 | g12957 | i0 | 44.4 | 0.867469879518072 | 72 | 40 | 86.7 | 0 | 217 | 2 | 668 | 739 | XP_035210635.1 uncharacterized protein LOC118184981 [Stegodyphus dumicola] | diamond | 216 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Eresidae | Stegodyphus | Stegodyphus dumicola | |
| 30437541 | 30437541 | PRJDB12134_P_NODE_5173_length_467_cov_3.370558_g5039_i0 | PRJDB12134 | 5173 | 467 | 3.370558 | 15.74050586 | root | 1 | Root_unresolved | Root_unresolved | 190 | 1.52e-56 | NR | KAK9406952.1 | 8729 | g5039 | i0 | 67.2 | 93.8672376873662 | 125 | 41 | 80.3 | 0 | 93 | 467 | 158 | 282 | KAK9406952.1 ras-related C3 botulinum toxin substrate 3 [Crotalus adamanteus] | diamond | 43836 | 190 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 30695805 | 30695805 | PRJDB12134_P_NODE_5454_length_450_cov_1.490716_g5320_i0 | PRJDB12134 | 5454 | 450 | 1.490716 | 6.708222 | Eriocheir sinensis | 95602 | Arthropoda | Arthropoda | 139 | 1.67e-36 | NR | XP_050695649.1 | 95602 | g5320 | i0 | 49.3 | 1.97333333333333 | 148 | 75 | 98.7 | 0 | 450 | 7 | 224 | 371 | XP_050695649.1 uncharacterized protein LOC126985138 [Eriocheir sinensis] | diamond | 888 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Varunidae | Eriocheir | Eriocheir sinensis | |
| 31549580 | 31549580 | PRJDB12134_P_NODE_14376_length_242_cov_0.917160_g14241_i0 | PRJDB12134 | 14376 | 242 | 0.91716 | 2.2195272 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 42.4 | 0.049 | NR | XP_064758673.1 | 1690604 | g14241 | i0 | 50.8 | 0.731404958677686 | 59 | 20 | 71.9 | 3 | 212 | 39 | 1 | 51 | XP_064758673.1 uncharacterized protein LTR64_001607 [Lithohypha guttulata] | diamond | 177 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 31770679 | 31770679 | PRJDB12134_P_NODE_12857_length_250_cov_0.875706_g12722_i0 | PRJDB12134 | 12857 | 250 | 0.875706 | 2.189265 | Naganishia albida | 100951 | Fungi | Fungi | 166 | 1.5099999999999998e-45 | NR | KAI5455025.1 | 100951 | g12722 | i0 | 98.8 | 0.984 | 82 | 1 | 98.4 | 0 | 248 | 3 | 501 | 582 | KAI5455025.1 hypothetical protein NCC49_002300 [Naganishia albida] | diamond | 246 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 31992161 | 31992161 | PRJDB12134_P_NODE_14258_length_242_cov_1.668639_g14123_i0 | PRJDB12134 | 14258 | 242 | 1.668639 | 4.03810638 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 57.4 | 2.55e-7 | NR | KAK3887192.1 | 88211 | g14123 | i0 | 67.3 | 0.607438016528926 | 49 | 10 | 60.7 | 2 | 232 | 86 | 177 | 219 | KAK3887192.1 hypothetical protein Pcinc_008673 [Petrolisthes cinctipes] | diamond | 147 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 32461071 | 32461071 | PRJDB12134_P_NODE_12199_length_254_cov_1.629834_g12064_i0 | PRJDB12134 | 12199 | 254 | 1.629834 | 4.13977836 | Mytilus | 6548 | Mollusca | Mollusca | 65.5 | 3.72e-10 | NR | CAG2226471.1 | 6550 | g12064 | i0 | 59.3 | 5.72834645669291 | 54 | 22 | 63.8 | 0 | 252 | 91 | 13 | 66 | CAG2226471.1 unnamed protein product [Mytilus edulis] | diamond | 1455 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32467077 | 32467077 | PRJDB12134_P_NODE_10159_length_287_cov_1.271028_g10024_i0 | PRJDB12134 | 10159 | 287 | 1.271028 | 3.64785036 | Portunus trituberculatus | 210409 | Arthropoda | Arthropoda | 62.4 | 4.02e-10 | NR | MPC31817.1 | 210409 | g10024 | i0 | 48.4 | 1.27526132404181 | 62 | 31 | 64.8 | 1 | 102 | 287 | 31 | 91 | MPC31817.1 hypothetical protein [Portunus trituberculatus] | diamond | 366 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Portunidae | Portunus | Portunus trituberculatus | |
| 32813600 | 32813600 | PRJDB12134_P_NODE_6620_length_393_cov_1.696875_g6485_i0 | PRJDB12134 | 6620 | 393 | 1.696875 | 6.66871875 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 62.8 | 2.08e-8 | NR | KAK3871028.1 | 88211 | g6485 | i0 | 60.6 | 4.33587786259542 | 71 | 27 | 53.4 | 1 | 212 | 3 | 933 | 1003 | KAK3871028.1 hypothetical protein Pcinc_023796, partial [Petrolisthes cinctipes] | diamond | 1704 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes |
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);;