contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26762260 | 26762260 | PRJNA557436_S_NODE_6321_length_170_cov_1.237037_g6273_i0 | PRJNA557436 | 6321 | 170 | 1.237037 | 2.1029629 | Acer saccharum | 4024 | Plants | Plants | 66.2 | 6.89e-11 | NR | KAK1548203.1 | 4024 | g6273 | i0 | 48.2 | 2.82352941176471 | 56 | 29 | 98.8 | 0 | 170 | 3 | 142 | 197 | KAK1548203.1 hypothetical protein Q3G72_018492 [Acer saccharum] | diamond | 480 | 66.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 26794069 | 26794069 | PRJNA557436_S_NODE_421_length_537_cov_2.386454_g379_i0 | PRJNA557436 | 421 | 537 | 2.386454 | 12.81525798 | Gnathostoma spinigerum | 75299 | Nematoda | Nematoda | 141 | 1.4099999999999999e-40 | NR | MFH4985130.1 | 75299 | g379 | i0 | 91 | 0.374301675977654 | 67 | 6 | 37.4 | 0 | 253 | 53 | 1 | 67 | MFH4985130.1 hypothetical protein [Gnathostoma spinigerum] | diamond | 201 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Gnathostomatidae | Gnathostoma | Gnathostoma spinigerum | |
| 26983872 | 26983872 | PRJNA557436_S_NODE_7002_length_164_cov_2.031008_g6954_i0 | PRJNA557436 | 7002 | 164 | 2.031008 | 3.33085312 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0437 | NR | XP_011130180.1 | 110365 | g6954 | i0 | 43.9 | 0.75 | 41 | 23 | 75 | 0 | 127 | 5 | 129 | 169 | XP_011130180.1 hypothetical protein GNI_067230 [Gregarina niphandrodes] | diamond | 123 | 41.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 27236830 | 27236830 | PRJNA557436_S_NODE_5143_length_182_cov_3.904762_g5095_i0 | PRJNA557436 | 5143 | 182 | 3.904762 | 7.10666684 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 115 | 1.78e-29 | NR | KAH2778379.1 | 746128 | g5095 | i0 | 100 | 0.989010989010989 | 60 | 0 | 98.9 | 0 | 181 | 2 | 217 | 276 | KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus] | diamond | 180 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 27742547 | 27742547 | PRJNA557436_S_NODE_5144_length_182_cov_3.353741_g5096_i0 | PRJNA557436 | 5144 | 182 | 3.353741 | 6.10380862 | Seminavis robusta | 568900 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0115 | NR | CAB9498495.1 | 568900 | g5096 | i0 | 63.6 | 0.362637362637363 | 22 | 8 | 36.3 | 0 | 180 | 115 | 149 | 170 | CAB9498495.1 expressed unknown protein [Seminavis robusta] | diamond | 66 | 43.1 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta | ||
| 27805548 | 27805548 | PRJNA557436_S_NODE_4144_length_197_cov_1.790123_g4096_i0 | PRJNA557436 | 4144 | 197 | 1.790123 | 3.52654231 | Acer saccharum | 4024 | Plants | Plants | 107 | 2.39e-25 | NR | KAK1548911.1 | 4024 | g4096 | i0 | 72.3 | 0.989847715736041 | 65 | 18 | 99 | 0 | 3 | 197 | 193 | 257 | KAK1548911.1 hypothetical protein Q3G72_019842 [Acer saccharum] | diamond | 195 | 107 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 27868397 | 27868397 | PRJNA557436_S_NODE_8645_length_154_cov_1.478992_g8597_i0 | PRJNA557436 | 8645 | 154 | 1.478992 | 2.27764768 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 100 | 5.29e-25 | NR | KAH2841833.1 | 746128 | g8597 | i0 | 100 | 0.993506493506494 | 51 | 0 | 99.4 | 0 | 1 | 153 | 62 | 112 | KAH2841833.1 hypothetical protein KXW36_000816, partial [Aspergillus fumigatus] | diamond | 153 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 27963220 | 27963220 | PRJNA557436_S_NODE_3165_length_218_cov_2.967213_g3117_i0 | PRJNA557436 | 3165 | 218 | 2.967213 | 6.46852434 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 77.4 | 8.03e-15 | NR | KAH2778379.1 | 746128 | g3117 | i0 | 94.7 | 0.522935779816514 | 38 | 2 | 52.3 | 0 | 104 | 217 | 75 | 112 | KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus] | diamond | 114 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 28026485 | 28026485 | PRJNA557436_S_NODE_6145_length_171_cov_2.522059_g6097_i0 | PRJNA557436 | 6145 | 171 | 2.522059 | 4.31272089 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 42 | 0.0246 | NR | KAL4444244.1 | 2728915 | g6097 | i0 | 47.8 | 0.807017543859649 | 46 | 24 | 80.7 | 0 | 26 | 163 | 95 | 140 | KAL4444244.1 hypothetical protein ABPG75_011981 [Micractinium tetrahymenae] | diamond | 138 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 28089451 | 28089451 | PRJNA557436_S_NODE_4125_length_197_cov_2.530864_g4077_i0 | PRJNA557436 | 4125 | 197 | 2.530864 | 4.98580208 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 54.3 | 1.68e-6 | NR | CAI9150999.1 | 3082113 | g4077 | i0 | 96.6 | 0.441624365482233 | 29 | 1 | 44.2 | 0 | 1 | 87 | 501 | 529 | CAI9150999.1 unnamed protein product, partial [Rangifer tarandus platyrhynchus] | diamond | 87 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 28089463 | 28089463 | PRJNA557436_S_NODE_825_length_392_cov_2.806723_g777_i0 | PRJNA557436 | 825 | 392 | 2.806723 | 11.00235416 | Apiospora phragmitis | 2905665 | Fungi | Fungi | 60.8 | 6.84e-8 | NR | XP_066709719.1 | 2905665 | g777 | i0 | 37.6 | 0.650510204081633 | 85 | 40 | 55.1 | 1 | 387 | 172 | 147 | 231 | XP_066709719.1 uncharacterized protein PG994_013349 [Apiospora phragmitis] | diamond | 255 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora phragmitis | |
| 29226452 | 29226452 | PRJNA557436_S_NODE_4729_length_187_cov_2.440789_g4681_i0 | PRJNA557436 | 4729 | 187 | 2.440789 | 4.56427543 | Pararge aegeria aegeria | 348720 | Arthropoda | Arthropoda | 40.8 | 0.0333 | NR | CAH2246697.1 | 348720 | g4681 | i0 | 32.3 | 0.994652406417112 | 62 | 39 | 94.7 | 1 | 10 | 186 | 38 | 99 | CAH2246697.1 jg3536 [Pararge aegeria aegeria] | diamond | 186 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Nymphalidae | Pararge | Pararge aegeria | |
| 29289251 | 29289251 | PRJNA557436_S_NODE_2349_length_247_cov_2.547170_g2301_i0 | PRJNA557436 | 2349 | 247 | 2.54717 | 6.2915099 | Sphagnum balticum | 128184 | Plants | Plants | 128 | 8.4e-34 | NR | CAM5998727.1 | 128184 | g2301 | i0 | 70 | 2.8663967611336 | 80 | 24 | 97.2 | 0 | 242 | 3 | 236 | 315 | CAM5998727.1 unnamed protein product [Sphagnum balticum] | diamond | 708 | 128 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 29352602 | 29352602 | PRJNA557436_S_NODE_3709_length_205_cov_2.517647_g3661_i0 | PRJNA557436 | 3709 | 205 | 2.517647 | 5.16117635 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 42 | 0.0441 | NR | PJF18462.1 | 1246581 | g3661 | i0 | 38.9 | 0.790243902439024 | 54 | 31 | 79 | 1 | 178 | 17 | 967 | 1018 | PJF18462.1 Wd-repeat-containing protein [Paramicrosporidium saccamoebae] | diamond | 162 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29618800 | 29618800 | PRJNA557436_S_NODE_5910_length_174_cov_1.143885_g5862_i0 | PRJNA557436 | 5910 | 174 | 1.143885 | 1.9903599 | root | 1 | Root_unresolved | Root_unresolved | 63.5 | 6.56e-10 | NR | KAF3334543.1 | 544730 | g5862 | i0 | 52.9 | 2.62068965517241 | 51 | 24 | 87.9 | 0 | 2 | 154 | 273 | 323 | KAF3334543.1 methyl-CpG-binding domain protein 4 [Carex littledalei] | diamond | 456 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Cyperaceae | Carex | Carex littledalei | |
| 29952460 | 29952460 | PRJNA557436_S_NODE_1951_length_268_cov_1.733906_g1903_i0 | PRJNA557436 | 1951 | 268 | 1.733906 | 4.64686808 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 127 | 4.6099999999999995e-35 | NR | KAH2821898.1 | 746128 | g1903 | i0 | 97 | 0.75 | 67 | 2 | 75 | 0 | 201 | 1 | 20 | 86 | KAH2821898.1 hypothetical protein KXV85_002502, partial [Aspergillus fumigatus] | diamond | 201 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 29952462 | 29952462 | PRJNA557436_S_NODE_2391_length_245_cov_2.595238_g2343_i0 | PRJNA557436 | 2391 | 245 | 2.595238 | 6.3583331 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 164 | 3.22e-48 | NR | KAH2778379.1 | 746128 | g2343 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 3 | 245 | 111 | 191 | KAH2778379.1 hypothetical protein KXW38_008521, partial [Aspergillus fumigatus] | diamond | 243 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 30489612 | 30489612 | PRJNA557436_S_NODE_6733_length_166_cov_2.175573_g6685_i0 | PRJNA557436 | 6733 | 166 | 2.175573 | 3.61145118 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 82.4 | 1.95e-18 | NR | KAH2843171.1 | 746128 | g6685 | i0 | 94.9 | 0.704819277108434 | 39 | 2 | 70.5 | 0 | 50 | 166 | 76 | 114 | KAH2843171.1 hypothetical protein KXW36_000308, partial [Aspergillus fumigatus] | diamond | 117 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 30742314 | 30742314 | PRJNA557436_S_NODE_8114_length_157_cov_1.286885_g8066_i0 | PRJNA557436 | 8114 | 157 | 1.286885 | 2.02040945 | Cylindrotheca closterium | 2856 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 3.35e-12 | NR | YP_009029080.1 | 2856 | g8066 | i0 | 58.8 | 0.974522292993631 | 51 | 21 | 97.5 | 0 | 3 | 155 | 92 | 142 | YP_009029080.1 hypothetical protein [Cylindrotheca closterium] | diamond | 153 | 69.7 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 31135252 | 31135252 | PRJNA557436_S_NODE_6375_length_169_cov_2.074627_g6327_i0 | PRJNA557436 | 6375 | 169 | 2.074627 | 3.50611963 | root | 1 | Root_unresolved | Root_unresolved | 70.5 | 2.19e-12 | NR | KOC58562.1 | 597456 | g6327 | i0 | 61.1 | 5.48520710059172 | 54 | 21 | 95.9 | 0 | 3 | 164 | 915 | 968 | KOC58562.1 Uncharacterized protein yejH [Habropoda laboriosa] | diamond | 927 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Habropoda | Habropoda laboriosa | |
| 31247882 | 31247882 | PRJNA557436_S_NODE_8375_length_155_cov_2.183333_g8327_i0 | PRJNA557436 | 8375 | 155 | 2.183333 | 3.38416615 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 53.5 | 1.7e-6 | NR | PWV11501.1 | 5693 | g8327 | i0 | 60 | 1.74193548387097 | 45 | 18 | 87.1 | 0 | 12 | 146 | 130 | 174 | PWV11501.1 putative thymidylate kinase [Trypanosoma cruzi] | diamond | 270 | 53.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 31451952 | 31451952 | PRJNA557436_S_NODE_7596_length_160_cov_1.600000_g7548_i0 | PRJNA557436 | 7596 | 160 | 1.6 | 2.56 | Saccharomyces | 4930 | Fungi | Fungi | 111 | 7.78e-27 | NR | ONH78992.1 | 4932 | g7548 | i0 | 98.1 | 2.925 | 52 | 1 | 97.5 | 0 | 2 | 157 | 413 | 464 | ONH78992.1 Alanine--glyoxylate aminotransferase 1 [Saccharomyces cerevisiae] | diamond | 468 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 31912165 | 31912165 | PRJNA557436_S_NODE_6197_length_171_cov_1.433824_g6149_i0 | PRJNA557436 | 6197 | 171 | 1.433824 | 2.45183904 | Fragilaria crotonensis | 210448 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 1.38e-13 | NR | KAI2511261.1 | 210448 | g6149 | i0 | 75.5 | 3.49122807017544 | 49 | 12 | 86 | 0 | 171 | 25 | 322 | 370 | KAI2511261.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] | diamond | 597 | 73.9 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Fragilariales | Fragilariaceae | Fragilaria | Fragilaria crotonensis | ||
| 32133764 | 32133764 | PRJNA557436_S_NODE_5618_length_177_cov_1.183099_g5570_i0 | PRJNA557436 | 5618 | 177 | 1.183099 | 2.09408523 | Fragilaria crotonensis | 210448 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 1.21e-8 | NR | KAI2509714.1 | 210448 | g5570 | i0 | 62.2 | 0.76271186440678 | 45 | 16 | 76.3 | 1 | 135 | 1 | 182 | 225 | KAI2509714.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] | diamond | 135 | 60.1 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Fragilariales | Fragilariaceae | Fragilaria | Fragilaria crotonensis | ||
| 32527709 | 32527709 | PRJNA557436_S_NODE_3519_length_209_cov_5.051724_g3471_i0 | PRJNA557436 | 3519 | 209 | 5.051724 | 10.55810316 | Artiodactyla | 91561 | Chordata | Chordata | 47.4 | 5.67e-4 | NR | XP_069396403.1 | 9728 | g3471 | i0 | 70.3 | 2.32535885167464 | 37 | 10 | 53.1 | 1 | 140 | 30 | 115 | 150 | XP_069396403.1 collagen alpha-1(I) chain-like, partial [Delphinus delphis] | diamond | 486 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Delphinus | Delphinus delphis | |
| 32716549 | 32716549 | PRJNA557436_S_NODE_9240_length_151_cov_2.543103_g9192_i0 | PRJNA557436 | 9240 | 151 | 2.543103 | 3.84008553 | Bacillariaceae | 33852 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 2.51e-16 | NR | YP_009029080.1 | 2856 | g9192 | i0 | 67.3 | 3.87417218543046 | 49 | 16 | 97.4 | 0 | 151 | 5 | 292 | 340 | YP_009029080.1 hypothetical protein [Cylindrotheca closterium] | diamond | 585 | 81.3 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 32796707 | 32796707 | PRJNA557436_S_NODE_3780_length_204_cov_1.343195_g3732_i0 | PRJNA557436 | 3780 | 204 | 1.343195 | 2.7401178 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 120 | 2.18e-32 | NR | KAH2823818.1 | 746128 | g3732 | i0 | 100 | 0.985294117647059 | 67 | 0 | 98.5 | 0 | 202 | 2 | 57 | 123 | KAH2823818.1 hypothetical protein KXV85_001434, partial [Aspergillus fumigatus] | diamond | 201 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus |
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);;