contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA306153" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4203539 | 4203539 | PRJNA306153_S_NODE_844_length_260_cov_4.554113_g831_i0 | PRJNA306153 | 844 | 260 | 4.554113 | 11.8406938 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 1.44e-31 | NR | MES1907458.1 | 1215613 | g831 | i0 | 70.2 | 1.95 | 84 | 25 | 96.9 | 0 | 4 | 255 | 76 | 159 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 507 | 121 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 5479839 | 5479839 | PRJNA306153_S_NODE_1945_length_178_cov_2.342282_g1932_i0 | PRJNA306153 | 1945 | 178 | 2.342282 | 4.16926196 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.54e-25 | NR | AAT09077.1 | 227086 | g1932 | i0 | 84.2 | 1.93820224719101 | 57 | 9 | 96.1 | 0 | 178 | 8 | 59 | 115 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 345 | 101 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 13130174 | 13130174 | PRJNA306153_S_NODE_871_length_256_cov_4.145374_g858_i0 | PRJNA306153 | 871 | 256 | 4.145374 | 10.61215744 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.74e-39 | NR | CAE8642508.1 | 89957 | g858 | i0 | 81 | 9.84375 | 84 | 16 | 98.4 | 0 | 3 | 254 | 11 | 94 | CAE8642508.1 unnamed protein product [Polarella glacialis] | diamond | 2520 | 144 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 15089898 | 15089898 | PRJNA306153_S_NODE_1192_length_220_cov_4.429319_g1179_i0 | PRJNA306153 | 1192 | 220 | 4.429319 | 9.7445018 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 9.53e-28 | NR | KAJ8552402.1 | 4785 | g1179 | i0 | 78.1 | 13.9363636363636 | 73 | 16 | 99.5 | 0 | 2 | 220 | 706 | 778 | KAJ8552402.1 hypothetical protein ON010_g10144 [Phytophthora cinnamomi] | diamond | 3066 | 116 | 0.991379310344828 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 15679126 | 15679126 | PRJNA306153_S_NODE_453_length_338_cov_8.889968_g440_i0 | PRJNA306153 | 453 | 338 | 8.889968 | 30.04809184 | Microchloropsis | 2511164 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 1.79e-53 | NR | TFJ84086.1 | 1027361 | g440 | i0 | 75.9 | 3.97633136094675 | 112 | 27 | 99.4 | 0 | 3 | 338 | 103 | 214 | TFJ84086.1 hypothetical protein NSK_004559 [Nannochloropsis salina CCMP1776] | diamond | 1344 | 184 | 0.994565217391304 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Microchloropsis | Microchloropsis salina | |||
| 16953729 | 16953729 | PRJNA306153_S_NODE_374_length_364_cov_3.934328_g361_i0 | PRJNA306153 | 374 | 364 | 3.934328 | 14.32095392 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.42e-38 | NR | KAG9399474.1 | 112091 | g361 | i0 | 62.4 | 2.53021978021978 | 101 | 38 | 83.2 | 0 | 7 | 309 | 46 | 146 | KAG9399474.1 60S ribosomal protein L18A [Aphanomyces cochlioides] | diamond | 921 | 137 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 23328387 | 23328387 | PRJNA306153_S_NODE_599_length_302_cov_5.344322_g586_i0 | PRJNA306153 | 599 | 302 | 5.344322 | 16.13985244 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 1.56e-34 | NR | CAK0811067.1 | 89957 | g586 | i0 | 78.6 | 8.34437086092715 | 84 | 18 | 83.4 | 0 | 257 | 6 | 254 | 337 | CAK0811067.1 unnamed protein product [Polarella glacialis] | diamond | 2520 | 131 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 27074208 | 27074208 | PRJNA306153_S_NODE_1822_length_183_cov_3.896104_g1809_i0 | PRJNA306153 | 1822 | 183 | 3.896104 | 7.12987032 | Blastocystis sp. Blastoise | 3128533 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 5.59e-14 | NR | KAK8805645.1 | 3128533 | g1809 | i0 | 54.1 | 1 | 61 | 28 | 100 | 0 | 183 | 1 | 165 | 225 | KAK8805645.1 hypothetical protein WA158_002301 [Blastocystis sp. Blastoise] | diamond | 183 | 74.7 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. Blastoise | |||
| 27674689 | 27674689 | PRJNA306153_S_NODE_1844_length_182_cov_4.555556_g1831_i0 | PRJNA306153 | 1844 | 182 | 4.555556 | 8.29111192 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 6.71e-21 | NR | CEP02379.1 | 37360 | g1831 | i0 | 73.3 | 1.97802197802198 | 60 | 16 | 98.9 | 0 | 181 | 2 | 22 | 81 | CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] | diamond | 360 | 93.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27863809 | 27863809 | PRJNA306153_S_NODE_1785_length_185_cov_4.224359_g1772_i0 | PRJNA306153 | 1785 | 185 | 4.224359 | 7.81506415 | Skeletonema marinoi | 267567 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.005 | NR | KAK1743969.1 | 267567 | g1772 | i0 | 64.3 | 0.454054054054054 | 28 | 10 | 45.4 | 0 | 183 | 100 | 61 | 88 | KAK1743969.1 60S ribosomal protein L38 [Skeletonema marinoi] | diamond | 84 | 42.4 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Skeletonemataceae | Skeletonema | Skeletonema marinoi | ||
| 27895409 | 27895409 | PRJNA306153_S_NODE_1805_length_184_cov_2.406452_g1792_i0 | PRJNA306153 | 1805 | 184 | 2.406452 | 4.42787168 | Blastocystis sp. ATCC 5 | 46767 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 1.2e-7 | NR | OAO12965.1 | 478820 | g1792 | i0 | 58.5 | 0.668478260869565 | 41 | 17 | 66.8 | 0 | 128 | 6 | 5 | 45 | OAO12965.1 60S ribosomal protein L35a-4 [Blastocystis sp. ATCC 50177/Nand II] | diamond | 123 | 54.7 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 27927076 | 27927076 | PRJNA306153_S_NODE_1825_length_183_cov_3.402597_g1812_i0 | PRJNA306153 | 1825 | 183 | 3.402597 | 6.22675251 | Nannochloropsis gaditana | 72520 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 2.91e-12 | NR | EWM20906.1 | 72520 | g1812 | i0 | 72.5 | 1.68852459016393 | 51 | 14 | 83.6 | 0 | 182 | 30 | 65 | 115 | EWM20906.1 Ribosomal protein L7A/L8 [Nannochloropsis gaditana] | diamond | 309 | 69.3 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis gaditana | |||
| 28211049 | 28211049 | PRJNA306153_S_NODE_2046_length_174_cov_2.262069_g2033_i0 | PRJNA306153 | 2046 | 174 | 2.262069 | 3.93600006 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 1.73e-10 | NR | XP_001012596.1 | 312017 | g2033 | i0 | 56.9 | 2.98275862068966 | 58 | 22 | 98.3 | 2 | 174 | 4 | 191 | 246 | XP_001012596.1 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 519 | 65.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28323395 | 28323395 | PRJNA306153_S_NODE_2206_length_168_cov_4.366906_g2193_i0 | PRJNA306153 | 2206 | 168 | 4.366906 | 7.33640208 | Pelagomonadaceae | 3235057 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 5.04e-5 | NR | CAH0374219.1 | 35677 | g2193 | i0 | 63.2 | 1.35714285714286 | 38 | 14 | 67.9 | 0 | 166 | 53 | 82 | 119 | CAH0374219.1 unnamed protein product [Pelagomonas calceolata] | diamond | 228 | 48.5 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata | |||
| 28369026 | 28369026 | PRJNA306153_S_NODE_2646_length_154_cov_5.280000_g2633_i0 | PRJNA306153 | 2646 | 154 | 5.28 | 8.1312 | Blastocystis hominis | 12968 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 2.8e-7 | NR | XP_012893805.1 | 12968 | g2633 | i0 | 52.2 | 6.27272727272727 | 46 | 22 | 89.6 | 0 | 142 | 5 | 40 | 85 | XP_012893805.1 uncharacterized protein [Blastocystis hominis] | diamond | 966 | 53.1 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 28495544 | 28495544 | PRJNA306153_S_NODE_2487_length_158_cov_4.875969_g2474_i0 | PRJNA306153 | 2487 | 158 | 4.875969 | 7.70403102 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 2.69e-11 | NR | CEP03344.1 | 37360 | g2474 | i0 | 70.7 | 0.778481012658228 | 41 | 12 | 77.8 | 0 | 158 | 36 | 150 | 190 | CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] | diamond | 123 | 65.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28621829 | 28621829 | PRJNA306153_S_NODE_1987_length_176_cov_4.000000_g1974_i0 | PRJNA306153 | 1987 | 176 | 4 | 7.04 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 8.7e-11 | NR | CEM00847.1 | 1169540 | g1974 | i0 | 59.6 | 0.971590909090909 | 57 | 23 | 97.2 | 0 | 171 | 1 | 26 | 82 | CEM00847.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 171 | 63.5 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 29333910 | 29333910 | PRJNA306153_S_NODE_1829_length_183_cov_2.662338_g1816_i0 | PRJNA306153 | 1829 | 183 | 2.662338 | 4.87207854 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.49e-27 | NR | CEP01219.1 | 37360 | g1816 | i0 | 81.7 | 6.83606557377049 | 60 | 11 | 98.4 | 0 | 2 | 181 | 141 | 200 | CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] | diamond | 1251 | 110 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29442380 | 29442380 | PRJNA306153_S_NODE_1090_length_229_cov_5.260000_g1077_i0 | PRJNA306153 | 1090 | 229 | 5.26 | 12.0454 | Tribonema minus | 303371 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 4.1e-20 | NR | KAG5177524.1 | 303371 | g1077 | i0 | 56.8 | 0.96943231441048 | 74 | 32 | 96.9 | 0 | 222 | 1 | 35 | 108 | KAG5177524.1 ribosomal protein L14-domain-containing protein [Tribonema minus] | diamond | 222 | 87.8 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 29600228 | 29600228 | PRJNA306153_S_NODE_450_length_339_cov_5.209677_g437_i0 | PRJNA306153 | 450 | 339 | 5.209677 | 17.66080503 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 4.18e-41 | NR | DBA01623.1 | 4803 | g437 | i0 | 63.4 | 7.95575221238938 | 112 | 40 | 98.2 | 1 | 335 | 3 | 73 | 184 | DBA01623.1 TPA: hypothetical protein N0F65_011379, partial [Lagenidium giganteum] | diamond | 2697 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29947944 | 29947944 | PRJNA306153_S_NODE_1231_length_216_cov_3.267380_g1218_i0 | PRJNA306153 | 1231 | 216 | 3.26738 | 7.0575408 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 6.18e-7 | NR | CEP02593.1 | 37360 | g1218 | i0 | 59.5 | 1.27777777777778 | 42 | 17 | 58.3 | 0 | 215 | 90 | 61 | 102 | CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] | diamond | 276 | 53.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 30042605 | 30042605 | PRJNA306153_S_NODE_571_length_308_cov_3.892473_g558_i0 | PRJNA306153 | 571 | 308 | 3.892473 | 11.98881684 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.05e-29 | NR | DAZ98414.1 | 4803 | g558 | i0 | 68.8 | 1.55844155844156 | 80 | 25 | 77.9 | 0 | 306 | 67 | 602 | 681 | DAZ98414.1 TPA: hypothetical protein N0F65_000128 [Lagenidium giganteum] | diamond | 480 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30313517 | 30313517 | PRJNA306153_S_NODE_2652_length_154_cov_4.600000_g2639_i0 | PRJNA306153 | 2652 | 154 | 4.6 | 7.084 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00795 | NR | OMJ68960.1 | 5963 | g2639 | i0 | 48.3 | 4.24675324675325 | 29 | 15 | 56.5 | 0 | 66 | 152 | 184 | 212 | OMJ68960.1 hypothetical protein SteCoe_33440 [Stentor coeruleus] | diamond | 654 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31148060 | 31148060 | PRJNA306153_S_NODE_1335_length_209_cov_3.105556_g1322_i0 | PRJNA306153 | 1335 | 209 | 3.105556 | 6.49061204 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 3.23e-15 | NR | CAL69925.1 | 37360 | g1322 | i0 | 58 | 0.990430622009569 | 69 | 21 | 99 | 1 | 3 | 209 | 13 | 73 | CAL69925.1 hypothetical protein [Plasmodiophora brassicae] | diamond | 207 | 77.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31749241 | 31749241 | PRJNA306153_S_NODE_257_length_421_cov_3.512755_g245_i0 | PRJNA306153 | 257 | 421 | 3.512755 | 14.78869855 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2.96e-34 | NR | CAE7785894.1 | 2951 | g245 | i0 | 68.6 | 0.748218527315915 | 105 | 32 | 74.8 | 1 | 3 | 317 | 18 | 121 | CAE7785894.1 Rpl35, partial [Symbiodinium microadriaticum] | diamond | 315 | 125 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 32463149 | 32463149 | PRJNA306153_S_NODE_2179_length_169_cov_3.914286_g2166_i0 | PRJNA306153 | 2179 | 169 | 3.914286 | 6.61514334 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 5.0300000000000005e-22 | NR | KAF4747601.1 | 32597 | g2166 | i0 | 84.6 | 28.6686390532544 | 52 | 8 | 92.3 | 0 | 1 | 156 | 13 | 64 | KAF4747601.1 40S ribosomal protein S17 [Perkinsus olseni] | diamond | 4845 | 90.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32589659 | 32589659 | PRJNA306153_S_NODE_2359_length_162_cov_4.225564_g2346_i0 | PRJNA306153 | 2359 | 162 | 4.225564 | 6.84541368 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.01e-17 | NR | KAF4686433.1 | 32597 | g2346 | i0 | 77.4 | 4.90740740740741 | 53 | 12 | 98.1 | 0 | 2 | 160 | 119 | 171 | KAF4686433.1 40S ribosomal protein S6 [Perkinsus olseni] | diamond | 795 | 83.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32778252 | 32778252 | PRJNA306153_S_NODE_580_length_305_cov_5.804348_g567_i0 | PRJNA306153 | 580 | 305 | 5.804348 | 17.7032614 | Pelagomonadaceae | 3235057 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.33e-4 | NR | CAH0377697.1 | 35677 | g567 | i0 | 42.9 | 1.51475409836066 | 77 | 39 | 74.8 | 2 | 268 | 41 | 61 | 133 | CAH0377697.1 unnamed protein product [Pelagomonas calceolata] | diamond | 462 | 49.3 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata |
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);;