contig_metadata
24 rows where bioproject = "PRJNA1143173" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 286334 | 286334 | PRJNA1143173_P_NODE_3321_length_447_cov_6.572193_g3295_i0 | PRJNA1143173 | 3321 | 447 | 6.572193 | 29.37770271 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 2.33e-79 | NTclustered | gi|209883090|ref|XM_002142934.1| | 441375 | g3295 | i0 | 84.498 | 0.736017897091723 | 329 | 34 | 73 | 12 | 1 | 325 | 649 | 964 | Cryptosporidium muris RN66 uncharacterized protein (CMU_002460), partial mRNA | blastn | 329 | 309 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 2836845 | 2836845 | PRJNA1143173_P_NODE_19843_length_287_cov_6.733645_g19817_i0 | PRJNA1143173 | 19843 | 287 | 6.733645 | 19.32556115 | root | 1 | Root_unresolved | Root_unresolved | 144 | 1.32e-37 | NR | CAE7860305.1 | 2951 | g19817 | i0 | 74.2 | 1.96515679442509 | 93 | 24 | 97.2 | 0 | 281 | 3 | 648 | 740 | CAE7860305.1 gdhA [Symbiodinium microadriaticum] | diamond | 564 | 145 | 0.993103448275862 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 4113092 | 4113092 | PRJNA1143173_P_NODE_17224_length_295_cov_2.932432_g17198_i0 | PRJNA1143173 | 17224 | 295 | 2.932432 | 8.6506744 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2806430765|ref|XM_068522508.1| | 2853592 | g17198 | i0 | 100 | 0.386440677966102 | 29 | 0 | 10 | 0 | 236 | 264 | 392 | 364 | MAG: Porospora cf. gigantea B uncharacterized protein (KVP17_004375), partial mRNA | blastn | 114 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 4113504 | 4113504 | PRJNA1143173_P_NODE_37024_length_237_cov_3.384146_g36998_i0 | PRJNA1143173 | 37024 | 237 | 3.384146 | 8.02042602 | Poteriospumella sp. | 2003111 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4e-118 | NTclustered | gi|1209404931|gb|KX442736.1| | 2003111 | g36998 | i0 | 100 | 76.789029535865 | 237 | 0 | 100 | 0 | 1 | 237 | 1131 | 1367 | Poteriospumella sp. strain JBAS36 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18199 | 438 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella sp. | |||
| 7939463 | 7939463 | PRJNA1143173_P_NODE_33487_length_248_cov_1.457143_g33461_i0 | PRJNA1143173 | 33487 | 248 | 1.457143 | 3.61371464 | uncultured Ochromonas | 240148 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.45e-71 | NTclustered | gi|390198152|gb|JQ859673.1| | 240148 | g33461 | i0 | 87.449 | 83.1935483870968 | 247 | 25 | 98 | 5 | 1 | 242 | 114 | 359 | Uncultured Ochromonas sp. clone SV462 16S ribosomal RNA gene, partial sequence; plastid | blastn | 20632 | 279 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | uncultured Ochromonas | |||
| 9960911 | 9960911 | PRJNA1143173_P_NODE_30688_length_256_cov_2.120219_g30662_i0 | PRJNA1143173 | 30688 | 256 | 2.120219 | 5.42776064 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.95e-127 | NTclustered | gi|166046545|emb|CU367662.1| | 100861 | g30662 | i0 | 99.609 | 44.34765625 | 256 | 1 | 100 | 0 | 1 | 256 | 422 | 167 | Aphanomyces euteiches cDNA | blastn | 11353 | 468 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10490229 | 10490229 | PRJNA1143173_P_NODE_44249_length_200_cov_4.629921_g44223_i0 | PRJNA1143173 | 44249 | 200 | 4.629921 | 9.259842 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 2.02e-76 | NTclustered | gi|209883090|ref|XM_002142934.1| | 441375 | g44223 | i0 | 93.5 | 1.29 | 200 | 13 | 100 | 0 | 1 | 200 | 241 | 440 | Cryptosporidium muris RN66 uncharacterized protein (CMU_002460), partial mRNA | blastn | 258 | 298 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 11765251 | 11765251 | PRJNA1143173_P_NODE_42530_length_211_cov_7.297101_g42504_i0 | PRJNA1143173 | 42530 | 211 | 7.297101 | 15.39688311 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 2.17e-71 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g42504 | i0 | 90.952 | 115.725118483412 | 210 | 17 | 99 | 2 | 1 | 210 | 681 | 888 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 24418 | 281 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 18137823 | 18137823 | PRJNA1143173_P_NODE_17775_length_293_cov_5.550000_g17749_i0 | PRJNA1143173 | 17775 | 293 | 5.55 | 16.2615 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.5299999999999993e-52 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g17749 | i0 | 94.366 | 2.43344709897611 | 142 | 8 | 99 | 0 | 150 | 291 | 157471 | 157330 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 713 | 219 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19412174 | 19412174 | PRJNA1143173_P_NODE_23876_length_275_cov_5.851485_g23850_i0 | PRJNA1143173 | 23876 | 275 | 5.851485 | 16.09158375 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.859999999999999e-96 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g23850 | i0 | 90.545 | 7.86181818181818 | 275 | 26 | 100 | 0 | 1 | 275 | 157437 | 157711 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2162 | 364 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20688078 | 20688078 | PRJNA1143173_P_NODE_42777_length_210_cov_4.350365_g42751_i0 | PRJNA1143173 | 42777 | 210 | 4.350365 | 9.1357665 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 8.17e-32 | NR | TMW64105.1 | 41045 | g42751 | i0 | 86.8 | 14.5857142857143 | 68 | 9 | 97.1 | 0 | 5 | 208 | 71 | 138 | TMW64105.1 hypothetical protein Poli38472_014222 [Pythium oligandrum] | diamond | 3063 | 125 | 0.992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 25259052 | 25259052 | PRJNA1143173_P_NODE_2260_length_505_cov_4.368056_g2234_i0 | PRJNA1143173 | 2260 | 505 | 4.368056 | 22.0586828 | Chromulinales | 96792 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 4.079999999999999e-137 | NTclustered | gi|2055919756|gb|MZ420314.1| | 1955568 | g2234 | i0 | 89.646 | 78.2455445544554 | 396 | 30 | 78 | 6 | 1 | 394 | 1448 | 1834 | Spumella sp. strain Woeam021018A5 large subunit ribosomal RNA gene, partial sequence | blastn | 39514 | 503 | 0.996023856858847 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. | |||
| 26595363 | 26595363 | PRJNA1143173_P_NODE_31161_length_254_cov_5.287293_g31135_i0 | PRJNA1143173 | 31161 | 254 | 5.287293 | 13.42972422 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 4.17e-20 | NR | CAE7860319.1 | 2951 | g31135 | i0 | 47.4 | 0.921259842519685 | 78 | 41 | 92.1 | 0 | 236 | 3 | 153 | 230 | CAE7860319.1 20 [Symbiodinium microadriaticum] | diamond | 234 | 94 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 27070366 | 27070366 | PRJNA1143173_P_NODE_11862_length_310_cov_2.654008_g11836_i0 | PRJNA1143173 | 11862 | 310 | 2.654008 | 8.2274248 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.53e-5 | NR | CAE7860319.1 | 2951 | g11836 | i0 | 46.9 | 0.474193548387097 | 49 | 25 | 47.4 | 1 | 162 | 308 | 1154 | 1201 | CAE7860319.1 20 [Symbiodinium microadriaticum] | diamond | 147 | 52.8 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 27639282 | 27639282 | PRJNA1143173_P_NODE_9644_length_310_cov_4.763713_g9618_i0 | PRJNA1143173 | 9644 | 310 | 4.763713 | 14.7675103 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 7.93e-14 | NR | CAE7860319.1 | 2951 | g9618 | i0 | 66.7 | 0.464516129032258 | 48 | 16 | 46.5 | 0 | 306 | 163 | 125 | 172 | CAE7860319.1 20 [Symbiodinium microadriaticum] | diamond | 144 | 77 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 28238782 | 28238782 | PRJNA1143173_P_NODE_40666_length_222_cov_7.181208_g40640_i0 | PRJNA1143173 | 40666 | 222 | 7.181208 | 15.94228176 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 2.15e-18 | NR | CAE7860322.1 | 2951 | g40640 | i0 | 59.7 | 0.905405405405405 | 67 | 27 | 90.5 | 0 | 207 | 7 | 466 | 532 | CAE7860322.1 17 [Symbiodinium microadriaticum] | diamond | 201 | 88.6 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 28807062 | 28807062 | PRJNA1143173_P_NODE_44408_length_199_cov_5.039683_g44382_i0 | PRJNA1143173 | 44408 | 199 | 5.039683 | 10.02896917 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.12e-18 | NR | CAE7860228.1 | 2951 | g44382 | i0 | 54.5 | 1.98994974874372 | 66 | 30 | 99.5 | 0 | 1 | 198 | 1043 | 1108 | CAE7860228.1 prkA [Symbiodinium microadriaticum] | diamond | 396 | 89 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 29743335 | 29743335 | PRJNA1143173_P_NODE_41450_length_218_cov_4.806897_g41424_i0 | PRJNA1143173 | 41450 | 218 | 4.806897 | 10.47903546 | root | 1 | Root_unresolved | Root_unresolved | 107 | 3.42e-25 | NR | CAE7860319.1 | 2951 | g41424 | i0 | 68.1 | 1.98165137614679 | 72 | 23 | 99.1 | 0 | 217 | 2 | 1540 | 1611 | CAE7860319.1 20 [Symbiodinium microadriaticum] | diamond | 432 | 108 | 0.990740740740741 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 30165030 | 30165030 | PRJNA1143173_P_NODE_34412_length_245_cov_3.936047_g34386_i0 | PRJNA1143173 | 34412 | 245 | 3.936047 | 9.64331515 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 4.45e-29 | NR | CAE7860226.1 | 2951 | g34386 | i0 | 65.4 | 0.991836734693878 | 81 | 28 | 99.2 | 0 | 243 | 1 | 781 | 861 | CAE7860226.1 dnaE [Symbiodinium microadriaticum] | diamond | 243 | 119 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 30375820 | 30375820 | PRJNA1143173_P_NODE_9092_length_310_cov_5.514768_g9066_i0 | PRJNA1143173 | 9092 | 310 | 5.514768 | 17.0957808 | root | 1 | Root_unresolved | Root_unresolved | 108 | 8.93e-25 | NR | CAE7860283.1 | 2951 | g9066 | i0 | 43.7 | 3.65806451612903 | 126 | 46 | 97.7 | 1 | 307 | 5 | 1090 | 1215 | CAE7860283.1 18 [Symbiodinium microadriaticum] | diamond | 1134 | 108 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 31271155 | 31271155 | PRJNA1143173_P_NODE_25235_length_271_cov_8.070707_g25209_i0 | PRJNA1143173 | 25235 | 271 | 8.070707 | 21.87161597 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 3.68e-44 | NR | CAE7860319.1 | 2951 | g25209 | i0 | 86.7 | 1.99261992619926 | 90 | 12 | 99.6 | 0 | 2 | 271 | 1598 | 1687 | CAE7860319.1 20 [Symbiodinium microadriaticum] | diamond | 540 | 162 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 31397769 | 31397769 | PRJNA1143173_P_NODE_29616_length_259_cov_2.198925_g29590_i0 | PRJNA1143173 | 29616 | 259 | 2.198925 | 5.69521575 | Phaeodactylum tricornutum CCAP 1 | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0154 | NR | XP_002178802.1 | 556484 | g29590 | i0 | 34.7 | 0.833976833976834 | 72 | 47 | 83.4 | 0 | 39 | 254 | 119 | 190 | XP_002178802.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] | diamond | 216 | 43.9 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 32125418 | 32125418 | PRJNA1143173_P_NODE_5618_length_362_cov_4.058824_g5592_i0 | PRJNA1143173 | 5618 | 362 | 4.058824 | 14.69294288 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.87e-15 | NR | CAE7860305.1 | 2951 | g5592 | i0 | 54.2 | 0.596685082872928 | 72 | 33 | 59.7 | 0 | 360 | 145 | 939 | 1010 | CAE7860305.1 gdhA [Symbiodinium microadriaticum] | diamond | 216 | 82.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 32505070 | 32505070 | PRJNA1143173_P_NODE_30919_length_255_cov_3.708791_g30893_i0 | PRJNA1143173 | 30919 | 255 | 3.708791 | 9.45741705 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1e-38 | NR | CAE7860283.1 | 2951 | g30893 | i0 | 69.4 | 2 | 85 | 26 | 100 | 0 | 255 | 1 | 1003 | 1087 | CAE7860283.1 18 [Symbiodinium microadriaticum] | diamond | 510 | 147 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum |
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);;