contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA393181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1685498 | 1685498 | PRJNA393181_S_NODE_35722_length_182_cov_3.434483_g35616_i0 | PRJNA393181 | 35722 | 182 | 3.434483 | 6.25075906 | root | 1 | Root_unresolved | Root_unresolved | 99 | 1.32e-22 | NR | XP_046859871.1 | 2897299 | g35616 | i0 | 66.1 | 1.94505494505495 | 59 | 20 | 97.3 | 0 | 6 | 182 | 184 | 242 | XP_046859871.1 fumarylacetoacetase-like [Xenia sp. Carnegie-2017] | diamond | 354 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 10614284 | 10614284 | PRJNA393181_S_NODE_2829_length_625_cov_2.544218_g2747_i0 | PRJNA393181 | 2829 | 625 | 2.544218 | 15.9013625 | Leptodontidium sp. MPI-SDFR-AT- | 1920929 | Fungi | Fungi | 174 | 1.75e-49 | NR | KAH6700579.1 | 2826080 | g2747 | i0 | 67.8 | 2.3088 | 121 | 38 | 57.6 | 1 | 362 | 3 | 2 | 122 | KAH6700579.1 hypothetical protein BKA61DRAFT_620796 [Leptodontidium sp. MPI-SDFR-AT-0119] | diamond | 1443 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Leptodontidiaceae | Leptodontidium | Leptodontidium sp. MPI-SDFR-AT-0119 | |
| 13164090 | 13164090 | PRJNA393181_S_NODE_22391_length_246_cov_2.636364_g22285_i0 | PRJNA393181 | 22391 | 246 | 2.636364 | 6.48545544 | root | 1 | Root_unresolved | Root_unresolved | 70.5 | 2e-12 | NR | MEE6515959.1 | 8439 | g22285 | i0 | 44.3 | 9.40243902439024 | 79 | 33 | 82.9 | 1 | 3 | 206 | 67 | 145 | MEE6515959.1 hypothetical protein [Ascaphus truei] | diamond | 2313 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 14439528 | 14439528 | PRJNA393181_S_NODE_36852_length_179_cov_1.338028_g36746_i0 | PRJNA393181 | 36852 | 179 | 1.338028 | 2.39507012 | Agaricomycetes | 155619 | Fungi | Fungi | 95.5 | 8.429999999999999e-23 | NR | TEB38703.1 | 71717 | g36746 | i0 | 79.3 | 252.45251396648 | 58 | 12 | 97.2 | 0 | 1 | 174 | 12 | 69 | TEB38703.1 ras-domain-containing protein [Coprinellus micaceus] | diamond | 45189 | 95.9 | 0.995828988529718 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus micaceus | |
| 20812271 | 20812271 | PRJNA393181_S_NODE_35277_length_184_cov_1.850340_g35171_i0 | PRJNA393181 | 35277 | 184 | 1.85034 | 3.4046256 | root | 1 | Root_unresolved | Root_unresolved | 57 | 1.59e-7 | NR | VVC97936.1 | 189913 | g35171 | i0 | 69 | 11.0217391304348 | 42 | 12 | 68.5 | 1 | 126 | 1 | 92 | 132 | VVC97936.1 unnamed protein product [Leptidea sinapis] | diamond | 2028 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Pieridae | Leptidea | Leptidea sinapis | |
| 24030140 | 24030140 | PRJNA393181_S_NODE_24799_length_231_cov_1.994845_g24693_i0 | PRJNA393181 | 24799 | 231 | 1.994845 | 4.60809195 | Mollusca | 6447 | Mollusca | Mollusca | 81.3 | 8.83e-16 | NR | XP_048243562.1 | 6454 | g24693 | i0 | 52.1 | 1.8961038961039 | 71 | 33 | 92.2 | 1 | 228 | 16 | 127 | 196 | XP_048243562.1 putative L-amino-acid oxidase YobN isoform X1 [Haliotis rufescens] | diamond | 438 | 82 | 0.991463414634146 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27265017 | 27265017 | PRJNA393181_S_NODE_23163_length_241_cov_1.995098_g23057_i0 | PRJNA393181 | 23163 | 241 | 1.995098 | 4.80818618 | Fonticula alba | 691883 | Root_unresolved | Root_unresolved | 92.4 | 9.99e-20 | NR | XP_009494630.1 | 691883 | g23057 | i0 | 54.4 | 0.983402489626556 | 79 | 36 | 98.3 | 0 | 239 | 3 | 331 | 409 | XP_009494630.1 hypothetical protein H696_02451 [Fonticula alba] | diamond | 237 | 92.4 | 1 | Eukaryota | Opisthokonta | Rotosphaerida | Fonticulaceae | Fonticula | Fonticula alba | ||||
| 27265038 | 27265038 | PRJNA393181_S_NODE_39583_length_170_cov_2.315789_g39477_i0 | PRJNA393181 | 39583 | 170 | 2.315789 | 3.9368413 | Amoeboaphelidium occidentale | 1498855 | Root_unresolved | Root_unresolved | 57.4 | 2.14e-9 | NR | KAI3661009.1 | 1498855 | g39477 | i0 | 92.3 | 95.9294117647059 | 26 | 2 | 45.9 | 0 | 2 | 79 | 26 | 51 | KAI3661009.1 hypothetical protein MP638_007564 [Amoeboaphelidium occidentale] | diamond | 16308 | 57.4 | 1 | Eukaryota | Opisthokonta | Aphelidea | Amoeboaphelidium | Amoeboaphelidium occidentale | |||||
| 27265041 | 27265041 | PRJNA393181_S_NODE_41563_length_165_cov_1.203125_g41457_i0 | PRJNA393181 | 41563 | 165 | 1.203125 | 1.98515625 | Penicillium decumbens | 69771 | Fungi | Fungi | 47.4 | 8.85e-5 | NR | OQD78233.1 | 69771 | g41457 | i0 | 44.2 | 2.87272727272727 | 52 | 27 | 92.7 | 2 | 10 | 162 | 29 | 79 | OQD78233.1 hypothetical protein PENDEC_c001G06406 [Penicillium decumbens] | diamond | 474 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium decumbens | |
| 27675797 | 27675797 | PRJNA393181_S_NODE_26384_length_222_cov_2.178378_g26278_i0 | PRJNA393181 | 26384 | 222 | 2.178378 | 4.83599916 | Lacerta agilis | 80427 | Chordata | Chordata | 79.7 | 2.77e-15 | NR | XP_033002290.1 | 80427 | g26278 | i0 | 63.1 | 1.75675675675676 | 65 | 21 | 87.8 | 2 | 195 | 1 | 1191 | 1252 | XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis] | diamond | 390 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Lacerta | Lacerta agilis | |
| 27739073 | 27739073 | PRJNA393181_S_NODE_44764_length_157_cov_1.300000_g44658_i0 | PRJNA393181 | 44764 | 157 | 1.3 | 2.041 | Mirounga leonina | 9715 | Chordata | Chordata | 45.8 | 8.35e-4 | NR | KAF3830524.1 | 9715 | g44658 | i0 | 64.7 | 0.974522292993631 | 51 | 18 | 97.5 | 0 | 155 | 3 | 98 | 148 | KAF3830524.1 hypothetical protein GH733_004343 [Mirounga leonina] | diamond | 153 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga leonina | |
| 27864851 | 27864851 | PRJNA393181_S_NODE_37385_length_177_cov_1.821429_g37279_i0 | PRJNA393181 | 37385 | 177 | 1.821429 | 3.22392933 | Lacerta agilis | 80427 | Chordata | Chordata | 91.7 | 8.89e-20 | NR | XP_033002290.1 | 80427 | g37279 | i0 | 77.2 | 2.89830508474576 | 57 | 13 | 96.6 | 0 | 3 | 173 | 387 | 443 | XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis] | diamond | 513 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Lacerta | Lacerta agilis | |
| 28418763 | 28418763 | PRJNA393181_S_NODE_44306_length_158_cov_1.487603_g44200_i0 | PRJNA393181 | 44306 | 158 | 1.487603 | 2.35041274 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.0138 | NR | TQV90680.1 | 43265 | g44200 | i0 | 42.2 | 2.56329113924051 | 45 | 26 | 85.4 | 0 | 18 | 152 | 62 | 106 | TQV90680.1 macro domain-containing protein [Cordyceps javanica] | diamond | 405 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps javanica | |
| 28906718 | 28906718 | PRJNA393181_S_NODE_27948_length_214_cov_2.355932_g27842_i0 | PRJNA393181 | 27948 | 214 | 2.355932 | 5.04169448 | Strigops habroptila | 2489341 | Chordata | Chordata | 42 | 0.0482 | NR | XP_030331398.1 | 2489341 | g27842 | i0 | 36.2 | 0.658878504672897 | 47 | 30 | 65.9 | 0 | 195 | 55 | 105 | 151 | XP_030331398.1 ancient ubiquitous protein 1 isoform X1 [Strigops habroptila] | diamond | 141 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Psittaciformes | Psittacidae | Strigops | Strigops habroptila | |
| 29854232 | 29854232 | PRJNA393181_S_NODE_32131_length_196_cov_1.421384_g32025_i0 | PRJNA393181 | 32131 | 196 | 1.421384 | 2.78591264 | Cladophialophora bantiana CBS 173.52 | 1442370 | Fungi | Fungi | 109 | 4.94e-27 | NR | XP_016613449.1 | 1442370 | g32025 | i0 | 75.4 | 4.94387755102041 | 65 | 16 | 99.5 | 0 | 195 | 1 | 251 | 315 | XP_016613449.1 uncharacterized protein Z519_12566 [Cladophialophora bantiana CBS 173.52] | diamond | 969 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora bantiana | |
| 29917462 | 29917462 | PRJNA393181_S_NODE_30691_length_202_cov_1.339394_g30585_i0 | PRJNA393181 | 30691 | 202 | 1.339394 | 2.70557588 | Lacerta agilis | 80427 | Chordata | Chordata | 99 | 3.53e-22 | NR | XP_033002290.1 | 80427 | g30585 | i0 | 66.7 | 3.07425742574257 | 69 | 21 | 99.5 | 1 | 201 | 1 | 244 | 312 | XP_033002290.1 uncharacterized protein K02A2.6-like [Lacerta agilis] | diamond | 621 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Lacerta | Lacerta agilis | |
| 30296937 | 30296937 | PRJNA393181_S_NODE_20692_length_258_cov_2.294118_g20586_i0 | PRJNA393181 | 20692 | 258 | 2.294118 | 5.91882444 | Cunninghamella echinulata | 76405 | Fungi | Fungi | 49.7 | 1.05e-4 | NR | KAI9300859.1 | 76405 | g20586 | i0 | 34.5 | 0.976744186046512 | 84 | 53 | 96.5 | 2 | 257 | 9 | 74 | 156 | KAI9300859.1 OSCP/delta subunit of ATPase [Cunninghamella echinulata] | diamond | 252 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Cunninghamella | Cunninghamella echinulata | |
| 30865127 | 30865127 | PRJNA393181_S_NODE_40494_length_168_cov_1.190840_g40388_i0 | PRJNA393181 | 40494 | 168 | 1.19084 | 2.0006112 | Malassezia restricta | 76775 | Fungi | Fungi | 90.9 | 2.51e-21 | NR | XP_027485772.1 | 76775 | g40388 | i0 | 78.2 | 0.982142857142857 | 55 | 12 | 98.2 | 0 | 166 | 2 | 96 | 150 | XP_027485772.1 peptidyl-tRNA hydrolase, PTH2 family [Malassezia restricta] | diamond | 165 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30896957 | 30896957 | PRJNA393181_S_NODE_18574_length_275_cov_2.457983_g18468_i0 | PRJNA393181 | 18574 | 275 | 2.457983 | 6.75945325 | Polyplax serrata | 468196 | Arthropoda | Arthropoda | 64.7 | 4.56e-10 | NR | KAK6619586.1 | 468196 | g18468 | i0 | 75 | 0.698181818181818 | 32 | 8 | 34.9 | 0 | 3 | 98 | 183 | 214 | KAK6619586.1 hypothetical protein RUM43_012343 [Polyplax serrata] | diamond | 192 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Polyplacidae | Polyplax | Polyplax serrata | |
| 31086384 | 31086384 | PRJNA393181_S_NODE_43375_length_160_cov_1.894309_g43269_i0 | PRJNA393181 | 43375 | 160 | 1.894309 | 3.0308944 | Testicularia cyperi | 1882483 | Fungi | Fungi | 83.6 | 2.93e-17 | NR | PWZ01463.1 | 1882483 | g43269 | i0 | 77.4 | 7.95 | 53 | 12 | 99.4 | 0 | 2 | 160 | 297 | 349 | PWZ01463.1 NAD-dependent glycerol-3-phosphate dehydrogenase [Testicularia cyperi] | diamond | 1272 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Anthracoideaceae | Testicularia | Testicularia cyperi | |
| 31402707 | 31402707 | PRJNA393181_S_NODE_47456_length_151_cov_1.350877_g47350_i0 | PRJNA393181 | 47456 | 151 | 1.350877 | 2.03982427 | Westerdykella ornata | 318751 | Fungi | Fungi | 40.4 | 0.0292 | NR | XP_033653906.1 | 318751 | g47350 | i0 | 50 | 0.834437086092715 | 42 | 20 | 81.5 | 1 | 133 | 11 | 71 | 112 | XP_033653906.1 uncharacterized protein EI97DRAFT_37200 [Westerdykella ornata] | diamond | 126 | 40.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Sporormiaceae | Westerdykella | Westerdykella ornata | |
| 31592470 | 31592470 | PRJNA393181_S_NODE_34216_length_188_cov_1.291391_g34110_i0 | PRJNA393181 | 34216 | 188 | 1.291391 | 2.42781508 | Clunio marinus | 568069 | Arthropoda | Arthropoda | 116 | 1.04e-29 | NR | CRL02559.1 | 568069 | g34110 | i0 | 85.5 | 0.98936170212766 | 62 | 9 | 98.9 | 0 | 186 | 1 | 251 | 312 | CRL02559.1 CLUMA_CG015843, isoform A [Clunio marinus] | diamond | 186 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Clunio | Clunio marinus | |
| 32383209 | 32383209 | PRJNA393181_S_NODE_24819_length_231_cov_1.726804_g24713_i0 | PRJNA393181 | 24819 | 231 | 1.726804 | 3.98891724 | Madurella fahalii | 1157608 | Fungi | Fungi | 42.4 | 0.0449 | NR | XP_070919493.1 | 1157608 | g24713 | i0 | 38.6 | 0.74025974025974 | 57 | 31 | 74 | 1 | 52 | 222 | 291 | 343 | XP_070919493.1 uncharacterized protein MFIFM68171_07972 [Madurella fahalii] | diamond | 171 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Madurella | Madurella fahalii | ||
| 32446742 | 32446742 | PRJNA393181_S_NODE_24059_length_235_cov_3.010101_g23953_i0 | PRJNA393181 | 24059 | 235 | 3.010101 | 7.07373735 | Acarospora aff. strigata | 2871812 | Fungi | Fungi | 43.1 | 0.0236 | NR | MCJ1366958.1 | 2871812 | g23953 | i0 | 36.4 | 0.702127659574468 | 55 | 33 | 67.7 | 1 | 72 | 230 | 326 | 380 | MCJ1366958.1 hypothetical protein [Acarospora aff. strigata] | diamond | 165 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Acarosporales | Acarosporaceae | Acarospora | Acarospora aff. strigata |
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);;