contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA177642" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11843985 | 11843985 | PRJNA177642_P_NODE_13410_length_253_cov_1.250000_g12185_i0 | PRJNA177642 | 13410 | 253 | 1.25 | 3.1625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 4.35e-18 | NR | OMJ89868.1 | 5963 | g12185 | i0 | 49.4 | 16.4110671936759 | 83 | 42 | 98.4 | 0 | 249 | 1 | 577 | 659 | OMJ89868.1 hypothetical protein SteCoe_7852 [Stentor coeruleus] | diamond | 4152 | 89 | 0.991011235955056 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 14394634 | 14394634 | PRJNA177642_P_NODE_18852_length_158_cov_2.209302_g17627_i0 | PRJNA177642 | 18852 | 158 | 2.209302 | 3.49069716 | root | 1 | Root_unresolved | Root_unresolved | 97.4 | 5.56e-24 | NR | XP_067184550.1 | 310047 | g17627 | i0 | 82.7 | 3.9493670886076 | 52 | 9 | 98.7 | 0 | 2 | 157 | 106 | 157 | XP_067184550.1 uncharacterized protein FG379_000932 [Cryptosporidium bovis] | diamond | 624 | 97.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 15668434 | 15668434 | PRJNA177642_P_NODE_5193_length_629_cov_3.531667_g4136_i0 | PRJNA177642 | 5193 | 629 | 3.531667 | 22.21418543 | root | 1 | Root_unresolved | Root_unresolved | 163 | 3.2199999999999996e-45 | NR | OMJ94284.1 | 5963 | g4136 | i0 | 54 | 16.2352941176471 | 163 | 72 | 76.8 | 2 | 628 | 146 | 147 | 308 | OMJ94284.1 hypothetical protein SteCoe_2628 [Stentor coeruleus] | diamond | 10212 | 164 | 0.99390243902439 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 25281183 | 25281183 | PRJNA177642_P_NODE_15900_length_179_cov_1.106667_g14675_i0 | PRJNA177642 | 15900 | 179 | 1.106667 | 1.98093393 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.7099999999999998e-23 | NR | KAJ1415384.1 | 483371 | g14675 | i0 | 86.4 | 0.988826815642458 | 59 | 8 | 98.9 | 0 | 2 | 178 | 4 | 62 | KAJ1415384.1 ribosomal protein S3Ae [Ochromonadaceae sp. CCMP2298] | diamond | 177 | 99 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 26630800 | 26630800 | PRJNA177642_P_NODE_11241_length_330_cov_0.800664_g10016_i0 | PRJNA177642 | 11241 | 330 | 0.800664 | 2.6421912 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0488 | NR | XP_067808354.1 | 2853593 | g10016 | i0 | 56.7 | 0.272727272727273 | 30 | 13 | 27.3 | 0 | 91 | 2 | 60 | 89 | XP_067808354.1 MAG: uncharacterized protein KVP18_004117 [Porospora cf. gigantea A] | diamond | 90 | 42 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 26662118 | 26662118 | PRJNA177642_P_NODE_3761_length_780_cov_6.478029_g2850_i0 | PRJNA177642 | 3761 | 780 | 6.478029 | 50.5286262 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 6.16e-7 | NR | CDW86772.1 | 5949 | g2850 | i0 | 37.6 | 0.480769230769231 | 125 | 68 | 45.4 | 5 | 60 | 413 | 18 | 139 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 375 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 26902065 | 26902065 | PRJNA177642_P_NODE_16461_length_172_cov_1.006993_g15236_i0 | PRJNA177642 | 16461 | 172 | 1.006993 | 1.73202796 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.21e-16 | NR | CAE7596792.1 | 878477 | g15236 | i0 | 63.2 | 2.98255813953488 | 57 | 21 | 99.4 | 0 | 171 | 1 | 248 | 304 | CAE7596792.1 BAM3 [Symbiodinium natans] | diamond | 513 | 82.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans | |||
| 26965117 | 26965117 | PRJNA177642_P_NODE_16902_length_169_cov_1.514286_g15677_i0 | PRJNA177642 | 16902 | 169 | 1.514286 | 2.55914334 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 7.73e-17 | NR | KAG5175216.1 | 303371 | g15677 | i0 | 71.7 | 4.68639053254438 | 53 | 15 | 94.1 | 0 | 168 | 10 | 75 | 127 | KAG5175216.1 ribosomal protein L32e [Tribonema minus] | diamond | 792 | 78.6 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 27028489 | 27028489 | PRJNA177642_P_NODE_13802_length_234_cov_1.160976_g12577_i0 | PRJNA177642 | 13802 | 234 | 1.160976 | 2.71668384 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 3.07e-18 | NR | XP_001435272.1 | 5888 | g12577 | i0 | 53.8 | 4.03846153846154 | 78 | 35 | 98.7 | 1 | 1 | 231 | 189 | 266 | XP_001435272.1 uncharacterized protein GSPATT00036656001 [Paramecium tetraurelia] | diamond | 945 | 87.4 | 0.995423340961098 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 27073899 | 27073899 | PRJNA177642_P_NODE_13062_length_279_cov_2.276000_g11837_i0 | PRJNA177642 | 13062 | 279 | 2.276 | 6.35004 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.26e-20 | NR | CAK0838259.1 | 89957 | g11837 | i0 | 47.8 | 5.78494623655914 | 90 | 47 | 96.8 | 0 | 6 | 275 | 239 | 328 | CAK0838259.1 unnamed protein product [Polarella glacialis] | diamond | 1614 | 95.1 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 27597401 | 27597401 | PRJNA177642_P_NODE_15764_length_181_cov_1.763158_g14539_i0 | PRJNA177642 | 15764 | 181 | 1.763158 | 3.19131598 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.16e-17 | NR | KRW98416.1 | 266149 | g14539 | i0 | 69 | 6.7292817679558 | 58 | 18 | 96.1 | 0 | 179 | 6 | 97 | 154 | KRW98416.1 Ribosomal protein S5 domain 2-type fold [Pseudocohnilembus persalinus] | diamond | 1218 | 84 | 0.990476190476191 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 27755381 | 27755381 | PRJNA177642_P_NODE_5084_length_640_cov_1.957447_g4034_i0 | PRJNA177642 | 5084 | 640 | 1.957447 | 12.5276608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 7.77e-32 | NR | TMW60079.1 | 41045 | g4034 | i0 | 33.3 | 9.9796875 | 225 | 128 | 97.5 | 3 | 634 | 11 | 1 | 220 | TMW60079.1 hypothetical protein Poli38472_000121 [Pythium oligandrum] | diamond | 6387 | 129 | 0.992248062015504 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28021645 | 28021645 | PRJNA177642_P_NODE_5265_length_623_cov_2.183502_g4206_i0 | PRJNA177642 | 5265 | 623 | 2.183502 | 13.60321746 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 8.5e-52 | NR | CDW89587.1 | 5949 | g4206 | i0 | 57.4 | 0.746388443017656 | 155 | 47 | 66 | 2 | 3 | 413 | 34 | 187 | CDW89587.1 UNKNOWN [Stylonychia lemnae] | diamond | 465 | 175 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28386547 | 28386547 | PRJNA177642_P_NODE_14686_length_204_cov_1.645714_g13461_i0 | PRJNA177642 | 14686 | 204 | 1.645714 | 3.35725656 | root | 1 | Root_unresolved | Root_unresolved | 103 | 5.9899999999999996e-24 | NR | XP_001437608.1 | 5888 | g13461 | i0 | 76.1 | 13.7647058823529 | 67 | 16 | 98.5 | 0 | 3 | 203 | 410 | 476 | XP_001437608.1 uncharacterized protein GSPATT00038313001 [Paramecium tetraurelia] | diamond | 2808 | 104 | 0.990384615384615 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 29189887 | 29189887 | PRJNA177642_P_NODE_16549_length_171_cov_1.823944_g15324_i0 | PRJNA177642 | 16549 | 171 | 1.823944 | 3.11894424 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 1.57e-15 | NR | KAJ1394928.1 | 483371 | g15324 | i0 | 66.1 | 0.982456140350877 | 56 | 19 | 98.2 | 0 | 169 | 2 | 6 | 61 | KAJ1394928.1 ribosomal protein L34 [Ochromonadaceae sp. CCMP2298] | diamond | 168 | 74.7 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29459808 | 29459808 | PRJNA177642_P_NODE_14970_length_198_cov_1.313609_g13745_i0 | PRJNA177642 | 14970 | 198 | 1.313609 | 2.60094582 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.49e-19 | NR | CAD8050189.1 | 65129 | g13745 | i0 | 61 | 3.5 | 59 | 23 | 89.4 | 0 | 197 | 21 | 88 | 146 | CAD8050189.1 unnamed protein product [Paramecium sonneborni] | diamond | 693 | 84.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 30042307 | 30042307 | PRJNA177642_P_NODE_12911_length_290_cov_3.233716_g11686_i0 | PRJNA177642 | 12911 | 290 | 3.233716 | 9.3777764 | Cyclotella atomus | 382360 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0343 | NR | KAL3797695.1 | 382360 | g11686 | i0 | 31.3 | 0.662068965517241 | 64 | 44 | 66.2 | 0 | 53 | 244 | 278 | 341 | KAL3797695.1 hypothetical protein ACHAWO_005301 [Cyclotella atomus] | diamond | 192 | 43.5 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella atomus | ||
| 30200092 | 30200092 | PRJNA177642_P_NODE_17172_length_168_cov_1.035971_g15947_i0 | PRJNA177642 | 17172 | 168 | 1.035971 | 1.74043128 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 9.01e-9 | NR | CAD8208970.1 | 43137 | g15947 | i0 | 52 | 3.57142857142857 | 50 | 24 | 89.3 | 0 | 18 | 167 | 37 | 86 | CAD8208970.1 unnamed protein product [Paramecium octaurelia] | diamond | 600 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 30642490 | 30642490 | PRJNA177642_P_NODE_13533_length_246_cov_1.658986_g12308_i0 | PRJNA177642 | 13533 | 246 | 1.658986 | 4.08110556 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.3899999999999998e-23 | NR | CDW86772.1 | 5949 | g12308 | i0 | 64 | 0.914634146341463 | 75 | 26 | 90.2 | 1 | 3 | 224 | 67 | 141 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 225 | 97.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30769121 | 30769121 | PRJNA177642_P_NODE_16354_length_173_cov_1.000000_g15129_i0 | PRJNA177642 | 16354 | 173 | 1 | 1.73 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.56e-11 | NR | OQS02928.1 | 74557 | g15129 | i0 | 63.6 | 2.86127167630058 | 55 | 20 | 95.4 | 0 | 173 | 9 | 1007 | 1061 | OQS02928.1 hypothetical protein THRCLA_04746 [Thraustotheca clavata] | diamond | 495 | 68.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31021837 | 31021837 | PRJNA177642_P_NODE_14975_length_198_cov_1.278107_g13750_i0 | PRJNA177642 | 14975 | 198 | 1.278107 | 2.53065186 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00782 | NR | KRX07275.1 | 266149 | g13750 | i0 | 37.7 | 1.04545454545455 | 69 | 35 | 92.4 | 2 | 197 | 15 | 76 | 144 | KRX07275.1 hypothetical protein PPERSA_06890 [Pseudocohnilembus persalinus] | diamond | 207 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31053680 | 31053680 | PRJNA177642_P_NODE_16995_length_169_cov_1.028571_g15770_i0 | PRJNA177642 | 16995 | 169 | 1.028571 | 1.73828499 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 4.06e-27 | NR | KAJ1439392.1 | 483371 | g15770 | i0 | 96.4 | 0.976331360946746 | 55 | 2 | 97.6 | 0 | 167 | 3 | 77 | 131 | KAJ1439392.1 60S ribosomal protein L26 [Ochromonadaceae sp. CCMP2298] | diamond | 165 | 104 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 32223737 | 32223737 | PRJNA177642_P_NODE_17198_length_168_cov_1.035971_g15973_i0 | PRJNA177642 | 17198 | 168 | 1.035971 | 1.74043128 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.15e-7 | NR | XP_001027342.1 | 312017 | g15973 | i0 | 51.9 | 1.83928571428571 | 52 | 24 | 92.9 | 1 | 164 | 9 | 217 | 267 | XP_001027342.1 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 309 | 57 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32255669 | 32255669 | PRJNA177642_P_NODE_15538_length_185_cov_1.807692_g14313_i0 | PRJNA177642 | 15538 | 185 | 1.807692 | 3.3442302 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 1.36e-18 | NR | AGE89250.1 | 153251 | g14313 | i0 | 71.9 | 3.85945945945946 | 57 | 16 | 92.4 | 0 | 171 | 1 | 89 | 145 | AGE89250.1 60S ribosomal protein L27A [Cryptocaryon irritans] | diamond | 714 | 83.6 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 32508675 | 32508675 | PRJNA177642_P_NODE_3999_length_749_cov_2.220833_g3062_i0 | PRJNA177642 | 3999 | 749 | 2.220833 | 16.63403917 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 0.00252 | NR | KAG9408400.1 | 112091 | g3062 | i0 | 41.5 | 0.260347129506008 | 65 | 34 | 24.8 | 2 | 210 | 25 | 86 | 149 | KAG9408400.1 hypothetical protein AC1031_021638 [Aphanomyces cochlioides] | diamond | 195 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides |
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);;