contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA415636" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1693935 | 1693935 | PRJNA415636_S_NODE_1542_length_355_cov_2.152597_g1495_i0 | PRJNA415636 | 1542 | 355 | 2.152597 | 7.64171935 | Conidiobolus coronatus NRRL 28638 | 796925 | Fungi | Fungi | 171 | 1.17e-51 | NR | KXN66694.1 | 796925 | g1495 | i0 | 68.1 | 0.980281690140845 | 116 | 37 | 98 | 0 | 353 | 6 | 74 | 189 | KXN66694.1 60S ribosomal protein L6 [Conidiobolus coronatus NRRL 28638] | diamond | 348 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 20209474 | 20209474 | PRJNA415636_S_NODE_6136_length_210_cov_1.184049_g6089_i0 | PRJNA415636 | 6136 | 210 | 1.184049 | 2.4865029 | Diploptera punctata | 6984 | Arthropoda | Arthropoda | 110 | 3.32e-29 | NR | KAJ9590993.1 | 6984 | g6089 | i0 | 65.7 | 3 | 70 | 24 | 100 | 0 | 1 | 210 | 50 | 119 | KAJ9590993.1 hypothetical protein L9F63_027798, partial [Diploptera punctata] | diamond | 630 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blaberidae | Diploptera | Diploptera punctata | |
| 23371225 | 23371225 | PRJNA415636_S_NODE_4399_length_239_cov_3.666667_g4352_i0 | PRJNA415636 | 4399 | 239 | 3.666667 | 8.76333413 | Fungi | 4751 | Fungi | Fungi | 67.8 | 1.11e-11 | NR | XP_069243892.1 | 4840 | g4352 | i0 | 52.8 | 3.90376569037657 | 72 | 32 | 90.4 | 1 | 220 | 5 | 126 | 195 | XP_069243892.1 60S ribosomal protein eL6 [Rhizomucor pusillus] | diamond | 933 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 26790835 | 26790835 | PRJNA415636_S_NODE_5981_length_212_cov_1.545455_g5934_i0 | PRJNA415636 | 5981 | 212 | 1.545455 | 3.2763646 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 78.6 | 3.47e-16 | NR | XP_062522407.1 | 121492 | g5934 | i0 | 60.6 | 3.70754716981132 | 66 | 24 | 93.4 | 1 | 1 | 198 | 113 | 176 | XP_062522407.1 large ribosomal subunit protein eL20-like [Corticium candelabrum] | diamond | 786 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27471543 | 27471543 | PRJNA415636_S_NODE_5783_length_215_cov_0.910714_g5736_i0 | PRJNA415636 | 5783 | 215 | 0.910714 | 1.9580351 | Metazoa | 33208 | Arthropoda | Arthropoda | 93.2 | 4.3e-20 | NR | XP_059087636.1 | 6832 | g5736 | i0 | 60.6 | 18.446511627907 | 71 | 28 | 99.1 | 0 | 3 | 215 | 485 | 555 | XP_059087636.1 adenylyl cyclase-associated protein 1-like isoform X4 [Tigriopus californicus] | diamond | 3966 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Harpacticoida | Harpacticidae | Tigriopus | Tigriopus californicus | |
| 27850155 | 27850155 | PRJNA415636_S_NODE_6764_length_198_cov_2.205298_g6717_i0 | PRJNA415636 | 6764 | 198 | 2.205298 | 4.36649004 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 6.25e-5 | NR | XP_071498330.1 | 105358 | g6717 | i0 | 77.8 | 1.22727272727273 | 27 | 6 | 40.9 | 0 | 198 | 118 | 137 | 163 | XP_071498330.1 peptidyl-prolyl cis-trans isomerase-like [Diadema antillarum] | diamond | 243 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27865092 | 27865092 | PRJNA415636_S_NODE_4685_length_234_cov_1.352941_g4638_i0 | PRJNA415636 | 4685 | 234 | 1.352941 | 3.16588194 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 64.3 | 8e-10 | NR | KAK9763865.1 | 34480 | g4638 | i0 | 46 | 1.61538461538462 | 63 | 34 | 80.8 | 0 | 45 | 233 | 470 | 532 | KAK9763865.1 hypothetical protein K7432_009104 [Basidiobolus ranarum] | diamond | 378 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 27913265 | 27913265 | PRJNA415636_S_NODE_4845_length_231_cov_2.070652_g4798_i0 | PRJNA415636 | 4845 | 231 | 2.070652 | 4.78320612 | Trichogramma | 7490 | Arthropoda | Arthropoda | 105 | 1.24e-24 | NR | XP_023315593.1 | 7493 | g4798 | i0 | 67.5 | 5.93506493506494 | 77 | 24 | 98.7 | 1 | 1 | 228 | 32 | 108 | XP_023315593.1 peptidyl-prolyl cis-trans isomerase FKBP4 isoform X2 [Trichogramma pretiosum] | diamond | 1371 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Trichogrammatidae | Trichogramma | Trichogramma pretiosum | |
| 27928413 | 27928413 | PRJNA415636_S_NODE_2185_length_313_cov_6.849624_g2138_i0 | PRJNA415636 | 2185 | 313 | 6.849624 | 21.43932312 | Erythrolamprus reginae | 121349 | Chordata | Chordata | 75.5 | 4.49e-15 | NR | XP_070621438.1 | 121349 | g2138 | i0 | 62.3 | 2.92332268370607 | 61 | 23 | 58.5 | 0 | 311 | 129 | 10 | 70 | XP_070621438.1 large ribosomal subunit protein P2 [Erythrolamprus reginae] | diamond | 915 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dipsadidae | Erythrolamprus | Erythrolamprus reginae | |
| 27991677 | 27991677 | PRJNA415636_S_NODE_4365_length_240_cov_1.559585_g4318_i0 | PRJNA415636 | 4365 | 240 | 1.559585 | 3.743004 | Dichotomocladium elegans | 101130 | Fungi | Fungi | 54.3 | 2.63e-7 | NR | KAI9313930.1 | 101130 | g4318 | i0 | 68.3 | 0.5125 | 41 | 8 | 51.3 | 1 | 239 | 117 | 63 | 98 | KAI9313930.1 hypothetical protein BX666DRAFT_1974862 [Dichotomocladium elegans] | diamond | 123 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Dichotomocladium | Dichotomocladium elegans | |
| 28023198 | 28023198 | PRJNA415636_S_NODE_5005_length_228_cov_1.464088_g4958_i0 | PRJNA415636 | 5005 | 228 | 1.464088 | 3.33812064 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 45.4 | 0.00168 | NR | CAF1117118.1 | 2762511 | g4958 | i0 | 36.2 | 1.64473684210526 | 69 | 38 | 90.8 | 2 | 18 | 224 | 3 | 65 | CAF1117118.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 375 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28387023 | 28387023 | PRJNA415636_S_NODE_4366_length_240_cov_1.528497_g4319_i0 | PRJNA415636 | 4366 | 240 | 1.528497 | 3.6683928 | Fungi | 4751 | Fungi | Fungi | 109 | 1.12e-26 | NR | XP_023627252.1 | 112498 | g4319 | i0 | 70.1 | 6.0375 | 67 | 20 | 83.8 | 0 | 9 | 209 | 276 | 342 | XP_023627252.1 related to MYG1 protein [Ramularia collo-cygni] | diamond | 1449 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28465286 | 28465286 | PRJNA415636_S_NODE_2226_length_311_cov_2.625000_g2179_i0 | PRJNA415636 | 2226 | 311 | 2.625 | 8.16375 | Leptotrombidium deliense | 299467 | Arthropoda | Arthropoda | 84 | 8.42e-18 | NR | RWS28058.1 | 299467 | g2179 | i0 | 60 | 2.44051446945338 | 85 | 30 | 80.1 | 3 | 1 | 249 | 83 | 165 | RWS28058.1 60S ribosomal protein L21-like protein [Leptotrombidium deliense] | diamond | 759 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 28686423 | 28686423 | PRJNA415636_S_NODE_2247_length_310_cov_1.368821_g2200_i0 | PRJNA415636 | 2247 | 310 | 1.368821 | 4.2433451 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 75.9 | 2.39e-14 | NR | XP_002113999.1 | 10228 | g2200 | i0 | 49.4 | 0.745161290322581 | 77 | 39 | 74.5 | 0 | 301 | 71 | 129 | 205 | XP_002113999.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 231 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29507003 | 29507003 | PRJNA415636_S_NODE_5450_length_220_cov_1.768786_g5403_i0 | PRJNA415636 | 5450 | 220 | 1.768786 | 3.8913292 | Acaulospora morrowiae | 94023 | Fungi | Fungi | 97.1 | 1.3899999999999998e-23 | NR | CAG8656846.1 | 94023 | g5403 | i0 | 75.8 | 4.22727272727273 | 62 | 15 | 84.5 | 0 | 220 | 35 | 90 | 151 | CAG8656846.1 3016_t:CDS:2 [Acaulospora morrowiae] | diamond | 930 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae | |
| 29839431 | 29839431 | PRJNA415636_S_NODE_3791_length_254_cov_1.676329_g3744_i0 | PRJNA415636 | 3791 | 254 | 1.676329 | 4.25787566 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 2.08e-34 | NR | XP_055937680.1 | 94029 | g3744 | i0 | 73.5 | 13.6535433070866 | 83 | 22 | 98 | 0 | 3 | 251 | 31 | 113 | XP_055937680.1 60S ribosomal protein L31 [Argiope bruennichi] | diamond | 3468 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Argiope | Argiope bruennichi | |
| 30138363 | 30138363 | PRJNA415636_S_NODE_3632_length_258_cov_3.080569_g3585_i0 | PRJNA415636 | 3632 | 258 | 3.080569 | 7.94786802 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 44.3 | 0.0129 | NR | XP_065888507.1 | 196820 | g3585 | i0 | 44.4 | 0.732558139534884 | 63 | 29 | 66.3 | 2 | 178 | 8 | 455 | 517 | XP_065888507.1 E3 ubiquitin-protein ligase CBL-B-B-like [Dysidea avara] | diamond | 189 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 30250410 | 30250410 | PRJNA415636_S_NODE_6172_length_209_cov_3.845679_g6125_i0 | PRJNA415636 | 6172 | 209 | 3.845679 | 8.03746911 | Fungi | 4751 | Fungi | Fungi | 99.8 | 1.84e-25 | NR | XP_054124123.1 | 37727 | g6125 | i0 | 70.6 | 23.4832535885167 | 68 | 19 | 97.6 | 1 | 2 | 205 | 15 | 81 | XP_054124123.1 uncharacterized protein EYB26_008897 [Talaromyces marneffei] | diamond | 4908 | 100 | 0.998 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 30597580 | 30597580 | PRJNA415636_S_NODE_1093_length_397_cov_34.262857_g1046_i0 | PRJNA415636 | 1093 | 397 | 34.262857 | 136.02354229 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 4.85e-5 | NR | GBN61280.1 | 182803 | g1046 | i0 | 50.9 | 3.68765743073048 | 53 | 26 | 40.1 | 0 | 122 | 280 | 1136 | 1188 | GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] | diamond | 1464 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 31592751 | 31592751 | PRJNA415636_S_NODE_6416_length_205_cov_2.525316_g6369_i0 | PRJNA415636 | 6416 | 205 | 2.525316 | 5.1768978 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 61.2 | 6.76e-9 | NR | XP_052263433.1 | 45954 | g6369 | i0 | 49.1 | 0.775609756097561 | 53 | 27 | 77.6 | 0 | 1 | 159 | 364 | 416 | XP_052263433.1 lysine-specific demethylase 8-like isoform X2 [Dreissena polymorpha] | diamond | 159 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 31672388 | 31672388 | PRJNA415636_S_NODE_4277_length_242_cov_1.630769_g4230_i0 | PRJNA415636 | 4277 | 242 | 1.630769 | 3.94646098 | Metazoa | 33208 | Arthropoda | Arthropoda | 127 | 2.02e-34 | NR | NP_001040464.1 | 7091 | g4230 | i0 | 73.8 | 39.9421487603306 | 80 | 21 | 99.2 | 0 | 3 | 242 | 124 | 203 | NP_001040464.1 thioredoxin peroxidase [Bombyx mori] | diamond | 9666 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 31798780 | 31798780 | PRJNA415636_S_NODE_6817_length_197_cov_2.040000_g6770_i0 | PRJNA415636 | 6817 | 197 | 2.04 | 4.0188 | root | 1 | Root_unresolved | Root_unresolved | 87.4 | 6.110000000000001e-21 | NR | XP_501463.1 | 4952 | g6770 | i0 | 79.7 | 11.8172588832487 | 59 | 11 | 89.8 | 1 | 11 | 187 | 12 | 69 | XP_501463.1 40S ribosomal protein eS28 [Yarrowia lipolytica] | diamond | 2328 | 88.2 | 0.99092970521542 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 31908881 | 31908881 | PRJNA415636_S_NODE_5497_length_219_cov_3.674419_g5450_i0 | PRJNA415636 | 5497 | 219 | 3.674419 | 8.04697761 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 50.4 | 4.98e-5 | NR | KAI9152416.1 | 1313167 | g5450 | i0 | 48 | 0.684931506849315 | 50 | 20 | 68.5 | 2 | 218 | 69 | 330 | 373 | KAI9152416.1 hypothetical protein H9P43_009207 [Blastocladiella emersonii ATCC 22665] | diamond | 150 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 32066974 | 32066974 | PRJNA415636_S_NODE_1018_length_405_cov_5.578212_g971_i0 | PRJNA415636 | 1018 | 405 | 5.578212 | 22.5917586 | Pneumocystis wakefieldiae | 38082 | Fungi | Fungi | 122 | 1.23e-32 | NR | QSL65967.1 | 38082 | g971 | i0 | 53 | 1.68148148148148 | 100 | 47 | 74.1 | 0 | 307 | 8 | 57 | 156 | QSL65967.1 hypothetical protein MERGE_003104 [Pneumocystis wakefieldiae] | diamond | 681 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis wakefieldiae | |
| 32162158 | 32162158 | PRJNA415636_S_NODE_3198_length_271_cov_14.165179_g3151_i0 | PRJNA415636 | 3198 | 271 | 14.165179 | 38.38763509 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47 | 2.91e-4 | NR | KAJ8043773.1 | 206669 | g3151 | i0 | 51.1 | 1.07380073800738 | 47 | 23 | 52 | 0 | 31 | 171 | 53 | 99 | KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] | diamond | 291 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32288950 | 32288950 | PRJNA415636_S_NODE_3139_length_273_cov_6.300885_g3092_i0 | PRJNA415636 | 3139 | 273 | 6.300885 | 17.20141605 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0196 | NR | XP_067657806.1 | 109174 | g3092 | i0 | 35.4 | 1.40659340659341 | 65 | 36 | 70.3 | 2 | 241 | 50 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 32478643 | 32478643 | PRJNA415636_S_NODE_3599_length_259_cov_2.858491_g3552_i0 | PRJNA415636 | 3599 | 259 | 2.858491 | 7.40349169 | Dinochytrium kinnereticum | 1774096 | Fungi | Fungi | 68.6 | 1.52e-11 | NR | KAJ3220079.1 | 1774096 | g3552 | i0 | 54.2 | 2.74517374517375 | 59 | 27 | 68.3 | 0 | 259 | 83 | 190 | 248 | KAJ3220079.1 40S ribosomal protein S21 [Dinochytrium kinnereticum] | diamond | 711 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Dinochytrium | Dinochytrium kinnereticum |
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);;