contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA399711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25837703 | 25837703 | PRJNA399711_S_NODE_99523_length_155_cov_3.271186_g99381_i0 | PRJNA399711 | 99523 | 155 | 3.271186 | 5.0703383 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 3.01e-17 | NR | KRX09037.1 | 266149 | g99381 | i0 | 73.5 | 6.63870967741935 | 49 | 13 | 94.8 | 0 | 147 | 1 | 160 | 208 | KRX09037.1 hypothetical protein PPERSA_01924 [Pseudocohnilembus persalinus] | diamond | 1029 | 82 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32951965 | 32951965 | PRJNA399711_S_NODE_34074_length_228_cov_4.476440_g33932_i0 | PRJNA399711 | 34074 | 228 | 4.47644 | 10.2062832 | Vaucheria litorea | 109269 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.39e-28 | NR | YP_002327517.1 | 109269 | g33932 | i0 | 80.3 | 1.85526315789474 | 71 | 14 | 93.4 | 0 | 1 | 213 | 119 | 189 | YP_002327517.1 ribosomal protein S5 [Vaucheria litorea] | diamond | 423 | 110 | 1 | Eukaryota | Sar | Xanthophyceae | Vaucheriales | Vaucheriaceae | Vaucheria | Vaucheria litorea | |||
| 32951985 | 32951985 | PRJNA399711_S_NODE_3770_length_465_cov_6.943925_g3637_i0 | PRJNA399711 | 3770 | 465 | 6.943925 | 32.28925125 | Triparma laevis f. longispina | 1714387 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 1.49e-10 | NR | GMH75098.1 | 1714387 | g3637 | i0 | 60.6 | 0.67741935483871 | 66 | 21 | 39.4 | 2 | 3 | 185 | 26 | 91 | GMH75098.1 hypothetical protein TrLO_g12819 [Triparma laevis f. longispina] | diamond | 315 | 65.5 | 1 | Eukaryota | Sar | Bolidophyceae | Parmales | Triparmaceae | Triparma | Triparma laevis | |||
| 32969315 | 32969315 | PRJNA399711_S_NODE_58066_length_188_cov_8.768212_g57924_i0 | PRJNA399711 | 58066 | 188 | 8.768212 | 16.48423856 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 3.64e-8 | NR | CAK9111081.1 | 1381693 | g57924 | i0 | 89.3 | 1.38829787234043 | 28 | 3 | 44.7 | 0 | 186 | 103 | 110 | 137 | CAK9111081.1 FK506-binding protein 59 (Peptidyl-prolyl cis-trans isomerase) (PPIase) (Rotamase) (dFKBP59) [Durusdinium trenchii] | diamond | 261 | 57.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 32969403 | 32969403 | PRJNA399711_S_NODE_75746_length_171_cov_3.791045_g75604_i0 | PRJNA399711 | 75746 | 171 | 3.791045 | 6.48268695 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.03e-5 | NR | KAJ1426575.1 | 483371 | g75604 | i0 | 49 | 0.894736842105263 | 51 | 22 | 89.5 | 1 | 18 | 170 | 448 | 494 | KAJ1426575.1 Sodium/calcium exchanger protein-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 153 | 51.6 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 33020368 | 33020368 | PRJNA399711_S_NODE_73732_length_173_cov_2.110294_g73590_i0 | PRJNA399711 | 73732 | 173 | 2.110294 | 3.65080862 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 5.38e-12 | NR | KAF4718031.1 | 32597 | g73590 | i0 | 75 | 3.06936416184971 | 44 | 10 | 76.3 | 1 | 172 | 41 | 145 | 187 | KAF4718031.1 40S ribosomal protein S9 [Perkinsus olseni] | diamond | 531 | 67.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 33060659 | 33060659 | PRJNA399711_S_NODE_42085_length_212_cov_2.034286_g41943_i0 | PRJNA399711 | 42085 | 212 | 2.034286 | 4.31268632 | Rhodophyta | 2763 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 3.52e-9 | NR | CAK0816265.1 | 89957 | g41943 | i0 | 54 | 2.09433962264151 | 50 | 23 | 70.8 | 0 | 3 | 152 | 274 | 323 | CAK0816265.1 unnamed protein product [Polarella glacialis] | diamond | 444 | 62.4 | 0.993589743589744 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 33071264 | 33071264 | PRJNA399711_S_NODE_39253_length_217_cov_5.683333_g39111_i0 | PRJNA399711 | 39253 | 217 | 5.683333 | 12.33283261 | Skeletonema marinoi | 267567 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 1.02e-13 | NR | KAK1746487.1 | 267567 | g39111 | i0 | 67.3 | 0.67741935483871 | 49 | 16 | 67.7 | 0 | 217 | 71 | 297 | 345 | KAK1746487.1 transaldolase [Skeletonema marinoi] | diamond | 147 | 74.7 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Skeletonemataceae | Skeletonema | Skeletonema marinoi | ||
| 33071268 | 33071268 | PRJNA399711_S_NODE_39589_length_216_cov_24.134078_g39447_i0 | PRJNA399711 | 39589 | 216 | 24.134078 | 52.12960848 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 3.31e-7 | NR | GBG30880.1 | 2315210 | g39447 | i0 | 92.6 | 0.75 | 27 | 2 | 37.5 | 0 | 3 | 83 | 116 | 142 | GBG30880.1 40S ribosomal protein S12 [Hondaea fermentalgiana] | diamond | 162 | 54.7 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 33088425 | 33088425 | PRJNA399711_S_NODE_39502_length_217_cov_2.083333_g39360_i0 | PRJNA399711 | 39502 | 217 | 2.083333 | 4.52083261 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.06e-24 | NR | KAJ0412831.1 | 114742 | g39360 | i0 | 69.2 | 3.59447004608295 | 65 | 20 | 89.9 | 0 | 2 | 196 | 527 | 591 | KAJ0412831.1 hypothetical protein ATCC90586_002461 [Pythium insidiosum] | diamond | 780 | 106 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 33088607 | 33088607 | PRJNA399711_S_NODE_63118_length_183_cov_2.273973_g62976_i0 | PRJNA399711 | 63118 | 183 | 2.273973 | 4.16137059 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 6.15e-8 | NR | CEO97302.1 | 37360 | g62976 | i0 | 62.5 | 2.0655737704918 | 40 | 15 | 65.6 | 0 | 19 | 138 | 382 | 421 | CEO97302.1 hypothetical protein PBRA_000647, partial [Plasmodiophora brassicae] | diamond | 378 | 58.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 33105298 | 33105298 | PRJNA399711_S_NODE_109966_length_150_cov_1.371681_g109824_i0 | PRJNA399711 | 109966 | 150 | 1.371681 | 2.0575215 | Chaetoceros tenuissimus | 426638 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 8.99e-10 | NR | GFH49172.1 | 426638 | g109824 | i0 | 73.5 | 1.96 | 49 | 13 | 98 | 0 | 2 | 148 | 139 | 187 | GFH49172.1 hypothetical protein CTEN210_05648 [Chaetoceros tenuissimus] | diamond | 294 | 61.2 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 33111816 | 33111816 | PRJNA399711_S_NODE_38366_length_219_cov_2.978022_g38224_i0 | PRJNA399711 | 38366 | 219 | 2.978022 | 6.52186818 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.92e-24 | NR | XP_004039566.1 | 5932 | g38224 | i0 | 94 | 5.47945205479452 | 50 | 3 | 68.5 | 0 | 2 | 151 | 200 | 249 | XP_004039566.1 parkin co-regulated gene protein, putative [Ichthyophthirius multifiliis] | diamond | 1200 | 101 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 33122505 | 33122505 | PRJNA399711_S_NODE_35455_length_225_cov_2.648936_g35313_i0 | PRJNA399711 | 35455 | 225 | 2.648936 | 5.960106 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 9.2e-4 | NR | GBG24970.1 | 2315210 | g35313 | i0 | 45.3 | 0.706666666666667 | 53 | 29 | 70.7 | 0 | 221 | 63 | 316 | 368 | GBG24970.1 TLD domain-containing protein 1 [Hondaea fermentalgiana] | diamond | 159 | 47 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 33139817 | 33139817 | PRJNA399711_S_NODE_74567_length_172_cov_3.377778_g74425_i0 | PRJNA399711 | 74567 | 172 | 3.377778 | 5.80977816 | Symbiodinium natans | 878477 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0108 | NR | CAE7489168.1 | 878477 | g74425 | i0 | 33.3 | 2.98255813953488 | 57 | 38 | 99.4 | 0 | 2 | 172 | 116 | 172 | CAE7489168.1 GIP [Symbiodinium natans] | diamond | 513 | 43.1 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans |
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);;