contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB6055" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5228093 | 5228093 | PRJEB6055_S_NODE_265_length_402_cov_10006.141689_g241_i0 | PRJEB6055 | 265 | 402 | 10006.141689 | 40224.68958978 | Fungi | 4751 | Fungi | Fungi | 126 | 7.049999999999999e-35 | NR | XP_054124123.1 | 37727 | g241 | i0 | 66.7 | 8.19402985074627 | 93 | 30 | 69.4 | 1 | 388 | 110 | 1 | 92 | XP_054124123.1 uncharacterized protein EYB26_008897 [Talaromyces marneffei] | diamond | 3294 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 7369760 | 7369760 | PRJEB6055_S_NODE_4786_length_163_cov_2.414062_g4762_i0 | PRJEB6055 | 4786 | 163 | 2.414062 | 3.93492106 | Agaricomycetes | 155619 | Fungi | Fungi | 92.4 | 2.02e-22 | NR | VWO94102.1 | 34458 | g4762 | i0 | 80.9 | 4.10429447852761 | 47 | 9 | 86.5 | 0 | 2 | 142 | 67 | 113 | VWO94102.1 2-cysteine peroxiredoxin, partial [Ganoderma boninense] | diamond | 669 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 23077567 | 23077567 | PRJEB6055_S_NODE_4359_length_169_cov_1.492537_g4335_i0 | PRJEB6055 | 4359 | 169 | 1.492537 | 2.52238753 | Ceraceosorus guamensis | 1522189 | Fungi | Fungi | 87.8 | 2.51e-19 | NR | XP_025368547.1 | 1522189 | g4335 | i0 | 75 | 0.994082840236686 | 56 | 14 | 99.4 | 0 | 2 | 169 | 166 | 221 | XP_025368547.1 ribosomal protein S3Ae [Ceraceosorus guamensis] | diamond | 168 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Ceraceosorales | Ceraceosoraceae | Ceraceosorus | Ceraceosorus guamensis | |
| 26646705 | 26646705 | PRJEB6055_S_NODE_5841_length_151_cov_3.043103_g5817_i0 | PRJEB6055 | 5841 | 151 | 3.043103 | 4.59508553 | Opisthokonta | 33154 | Fungi | Fungi | 60.8 | 2.3e-10 | NR | KAK9680935.1 | 34480 | g5817 | i0 | 75.7 | 8.06622516556291 | 37 | 9 | 73.5 | 0 | 150 | 40 | 64 | 100 | KAK9680935.1 60S ribosomal protein L9B [Basidiobolus ranarum] | diamond | 1218 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 26685312 | 26685312 | PRJEB6055_S_NODE_2781_length_196_cov_2.552795_g2757_i0 | PRJEB6055 | 2781 | 196 | 2.552795 | 5.0034782 | Diaphorina citri | 121845 | Arthropoda | Arthropoda | 44.3 | 0.00556 | NR | KAI5702344.1 | 121845 | g2757 | i0 | 53.5 | 5.9234693877551 | 43 | 18 | 65.8 | 1 | 63 | 191 | 43 | 83 | KAI5702344.1 hypothetical protein M8J77_016943 [Diaphorina citri] | diamond | 1161 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Psyllidae | Diaphorina | Diaphorina citri | |
| 26812142 | 26812142 | PRJEB6055_S_NODE_5741_length_152_cov_2.307692_g5717_i0 | PRJEB6055 | 5741 | 152 | 2.307692 | 3.50769184 | Coemansia asiatica | 1052880 | Fungi | Fungi | 46.2 | 4.83e-4 | NR | KAJ1647732.1 | 1052880 | g5717 | i0 | 55.3 | 1.85526315789474 | 47 | 21 | 92.8 | 0 | 2 | 142 | 157 | 203 | KAJ1647732.1 60S ribosomal protein L16A [Coemansia asiatica] | diamond | 282 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia asiatica | |
| 26907079 | 26907079 | PRJEB6055_S_NODE_4362_length_169_cov_1.335821_g4338_i0 | PRJEB6055 | 4362 | 169 | 1.335821 | 2.25753749 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 74.3 | 7.62e-14 | NR | CAF1267090.1 | 249248 | g4338 | i0 | 83.8 | 1.97041420118343 | 37 | 6 | 65.7 | 0 | 168 | 58 | 320 | 356 | CAF1267090.1 unnamed protein product [Adineta ricciae] | diamond | 333 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28069119 | 28069119 | PRJEB6055_S_NODE_3005_length_191_cov_3.391026_g2981_i0 | PRJEB6055 | 3005 | 191 | 3.391026 | 6.47685966 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82 | 2.41e-16 | NR | KAJ1369248.1 | 148309 | g2981 | i0 | 59.6 | 7.31937172774869 | 52 | 21 | 81.7 | 0 | 1 | 156 | 405 | 456 | KAJ1369248.1 hypothetical protein KIN20_030662 [Parelaphostrongylus tenuis] | diamond | 1398 | 82.4 | 0.995145631067961 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Parelaphostrongylus | Parelaphostrongylus tenuis | |
| 28518055 | 28518055 | PRJEB6055_S_NODE_1907_length_222_cov_3.320856_g1883_i0 | PRJEB6055 | 1907 | 222 | 3.320856 | 7.37230032 | Nephila pilipes | 299642 | Arthropoda | Arthropoda | 47 | 6.35e-4 | NR | GFT36626.1 | 299642 | g1883 | i0 | 49.2 | 2.21621621621622 | 59 | 26 | 79.7 | 2 | 40 | 216 | 66 | 120 | GFT36626.1 hypothetical protein NPIL_642691 [Nephila pilipes] | diamond | 492 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Nephila | Nephila pilipes | |
| 29079600 | 29079600 | PRJEB6055_S_NODE_5508_length_155_cov_1.000000_g5484_i0 | PRJEB6055 | 5508 | 155 | 1 | 1.55 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57 | 3.4e-8 | NR | KAF8568914.1 | 34504 | g5484 | i0 | 51 | 7.70322580645161 | 51 | 25 | 98.7 | 0 | 153 | 1 | 106 | 156 | KAF8568914.1 hypothetical protein P879_01172 [Paragonimus westermani] | diamond | 1194 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29181228 | 29181228 | PRJEB6055_S_NODE_5849_length_151_cov_2.051724_g5825_i0 | PRJEB6055 | 5849 | 151 | 2.051724 | 3.09810324 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 65.9 | 7.12e-11 | NR | KAJ3077812.1 | 2654861 | g5825 | i0 | 65.9 | 0.874172185430464 | 44 | 15 | 87.4 | 0 | 149 | 18 | 270 | 313 | KAJ3077812.1 hypothetical protein HK102_004949 [Quaeritorhiza haematococci] | diamond | 132 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 29622595 | 29622595 | PRJEB6055_S_NODE_2050_length_217_cov_3.620879_g2026_i0 | PRJEB6055 | 2050 | 217 | 3.620879 | 7.85730743 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 95.9 | 5.230000000000001e-21 | NR | KAL2917375.1 | 2732419 | g2026 | i0 | 68.5 | 0.746543778801843 | 54 | 17 | 74.7 | 0 | 217 | 56 | 776 | 829 | KAL2917375.1 translation elongation factor 2 [Polyrhizophydium stewartii] | diamond | 162 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 29742335 | 29742335 | PRJEB6055_S_NODE_4410_length_168_cov_1.263158_g4386_i0 | PRJEB6055 | 4410 | 168 | 1.263158 | 2.12210544 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 48.1 | 1.66e-4 | NR | CAD7399651.1 | 61476 | g4386 | i0 | 59.5 | 5.67857142857143 | 37 | 15 | 66.1 | 0 | 160 | 50 | 53 | 89 | CAD7399651.1 unnamed protein product [Timema cristinae] | diamond | 954 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema cristinae | |
| 30216268 | 30216268 | PRJEB6055_S_NODE_832_length_293_cov_1.860465_g808_i0 | PRJEB6055 | 832 | 293 | 1.860465 | 5.45116245 | Mollusca | 6447 | Mollusca | Mollusca | 97.1 | 4.36e-22 | NR | XP_050391847.1 | 6465 | g808 | i0 | 64.5 | 8.31399317406143 | 62 | 22 | 63.5 | 0 | 292 | 107 | 196 | 257 | XP_050391847.1 40S ribosomal protein S4 [Patella vulgata] | diamond | 2436 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 30855069 | 30855069 | PRJEB6055_S_NODE_2874_length_194_cov_1.509434_g2850_i0 | PRJEB6055 | 2874 | 194 | 1.509434 | 2.92830196 | Argopecten irradians | 31199 | Mollusca | Mollusca | 53.9 | 6.55e-7 | NR | XP_069123020.1 | 31199 | g2850 | i0 | 70.5 | 3.44845360824742 | 44 | 13 | 68 | 0 | 15 | 146 | 114 | 157 | XP_069123020.1 small ribosomal subunit protein eS24-like isoform X2 [Argopecten irradians] | diamond | 669 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 30943228 | 30943228 | PRJEB6055_S_NODE_3994_length_174_cov_1.438849_g3970_i0 | PRJEB6055 | 3994 | 174 | 1.438849 | 2.50359726 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.00519 | NR | XP_019038176.1 | 683960 | g3970 | i0 | 60 | 1.06896551724138 | 30 | 11 | 51.7 | 1 | 171 | 82 | 29 | 57 | XP_019038176.1 uncharacterized protein WICANDRAFT_63473 [Wickerhamomyces anomalus NRRL Y-366-8] | diamond | 186 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces anomalus | |
| 31487546 | 31487546 | PRJEB6055_S_NODE_976_length_278_cov_9.740741_g952_i0 | PRJEB6055 | 976 | 278 | 9.740741 | 27.07925998 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 41.6 | 0.0271 | NR | KAE8168712.1 | 4952 | g952 | i0 | 78.3 | 0.485611510791367 | 23 | 5 | 24.8 | 0 | 223 | 155 | 31 | 53 | KAE8168712.1 hypothetical protein BKA90DRAFT_10915 [Yarrowia lipolytica] | diamond | 135 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 32056689 | 32056689 | PRJEB6055_S_NODE_1538_length_237_cov_2.856436_g1514_i0 | PRJEB6055 | 1538 | 237 | 2.856436 | 6.76975332 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 98.2 | 2.48e-22 | NR | XP_029635157.1 | 2607531 | g1514 | i0 | 75 | 1.9873417721519 | 52 | 13 | 65.8 | 0 | 2 | 157 | 284 | 335 | XP_029635157.1 cathepsin B [Octopus sinensis] | diamond | 471 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 32056690 | 32056690 | PRJEB6055_S_NODE_2498_length_203_cov_5.738095_g2474_i0 | PRJEB6055 | 2498 | 203 | 5.738095 | 11.64833285 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 76.3 | 7.54e-15 | NR | CAF0713792.1 | 433720 | g2474 | i0 | 72.9 | 3.54679802955665 | 48 | 13 | 70.9 | 0 | 201 | 58 | 146 | 193 | CAF0713792.1 unnamed protein product [Adineta steineri] | diamond | 720 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32088363 | 32088363 | PRJEB6055_S_NODE_4638_length_165_cov_1.223077_g4614_i0 | PRJEB6055 | 4638 | 165 | 1.223077 | 2.01807705 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 79.3 | 3.27e-16 | NR | XP_038051326.1 | 46514 | g4614 | i0 | 76.7 | 2.34545454545455 | 43 | 10 | 78.2 | 0 | 3 | 131 | 204 | 246 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 387 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32404873 | 32404873 | PRJEB6055_S_NODE_2739_length_197_cov_2.561728_g2715_i0 | PRJEB6055 | 2739 | 197 | 2.561728 | 5.04660416 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 60.8 | 1.41e-9 | NR | RKP13868.1 | 1907219 | g2715 | i0 | 81.6 | 4.06598984771574 | 38 | 6 | 57.9 | 1 | 5 | 118 | 120 | 156 | RKP13868.1 ribosomal protein S17-domain-containing protein [Piptocephalis cylindrospora] | diamond | 801 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 32499923 | 32499923 | PRJEB6055_S_NODE_2399_length_206_cov_3.403509_g2375_i0 | PRJEB6055 | 2399 | 206 | 3.403509 | 7.01122854 | Byssothecium circinans | 147558 | Fungi | Fungi | 45.4 | 2.35e-4 | NR | KAF1948084.1 | 147558 | g2375 | i0 | 59.5 | 1.09223300970874 | 37 | 15 | 53.9 | 0 | 90 | 200 | 9 | 45 | KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans] | diamond | 225 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Massarinaceae | Byssothecium | Byssothecium circinans | |
| 32745242 | 32745242 | PRJEB6055_S_NODE_1880_length_223_cov_5.643617_g1856_i0 | PRJEB6055 | 1880 | 223 | 5.643617 | 12.58526591 | Saccharomycetaceae | 4893 | Fungi | Fungi | 54.3 | 6.08e-7 | NR | KAF4001137.1 | 4932 | g1856 | i0 | 52.5 | 4.0762331838565 | 61 | 19 | 82.1 | 1 | 12 | 194 | 56 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 909 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae |
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);;