contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA728642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26714063 | 26714063 | PRJNA728642_P_NODE_11381_length_300_cov_1.317181_g11110_i0 | PRJNA728642 | 11381 | 300 | 1.317181 | 3.951543 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 2.03e-22 | NR | XP_001024898.1 | 312017 | g11110 | i0 | 76.5 | 1.02 | 51 | 12 | 51 | 0 | 253 | 101 | 48 | 98 | XP_001024898.1 thioredoxin domain protein [Tetrahymena thermophila SB210] | diamond | 306 | 94.4 | 0.995762711864407 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26957221 | 26957221 | PRJNA728642_P_NODE_14162_length_267_cov_1.587629_g13891_i0 | PRJNA728642 | 14162 | 267 | 1.587629 | 4.23896943 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.33e-11 | NR | GMF44391.1 | 1490495 | g13891 | i0 | 51.1 | 1.03370786516854 | 92 | 34 | 98.9 | 3 | 266 | 3 | 93 | 177 | GMF44391.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 276 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 27020700 | 27020700 | PRJNA728642_P_NODE_18082_length_245_cov_0.895349_g17811_i0 | PRJNA728642 | 18082 | 245 | 0.895349 | 2.19360505 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 4.13e-31 | NR | KAL4444520.1 | 5901 | g17811 | i0 | 85.5 | 1.68979591836735 | 69 | 10 | 84.5 | 0 | 17 | 223 | 520 | 588 | KAL4444520.1 hypothetical protein ABPG74_016813 [Tetrahymena malaccensis] | diamond | 414 | 125 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 27400100 | 27400100 | PRJNA728642_P_NODE_9443_length_331_cov_1.775194_g9172_i0 | PRJNA728642 | 9443 | 331 | 1.775194 | 5.87589214 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 3.7299999999999985e-43 | NR | XP_001027598.1 | 312017 | g9172 | i0 | 56.9 | 2.92749244712991 | 109 | 46 | 97.9 | 1 | 329 | 6 | 32 | 140 | XP_001027598.1 kazal-type proteinase inhibitor 1 [Tetrahymena thermophila SB210] | diamond | 969 | 147 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27442143 | 27442143 | PRJNA728642_P_NODE_17003_length_248_cov_0.880000_g16732_i0 | PRJNA728642 | 17003 | 248 | 0.88 | 2.1824 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 6.6299999999999996e-40 | NR | AAB05610.1 | 5911 | g16732 | i0 | 82.9 | 1.98387096774194 | 82 | 14 | 99.2 | 0 | 1 | 246 | 34 | 115 | AAB05610.1 P-type ATPase, partial [Tetrahymena thermophila] | diamond | 492 | 144 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27621124 | 27621124 | PRJNA728642_P_NODE_18764_length_243_cov_0.905882_g18493_i0 | PRJNA728642 | 18764 | 243 | 0.905882 | 2.20129326 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 5.32e-8 | NR | XP_001016706.1 | 312017 | g18493 | i0 | 81.3 | 0.395061728395062 | 32 | 6 | 39.5 | 0 | 1 | 96 | 290 | 321 | XP_001016706.1 hypothetical protein TTHERM_00191290 [Tetrahymena thermophila SB210] | diamond | 96 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27810627 | 27810627 | PRJNA728642_P_NODE_18644_length_243_cov_1.276471_g18373_i0 | PRJNA728642 | 18644 | 243 | 1.276471 | 3.10182453 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 3.97e-12 | NR | XP_001033037.3 | 312017 | g18373 | i0 | 66 | 0.654320987654321 | 53 | 17 | 65.4 | 1 | 46 | 204 | 93 | 144 | XP_001033037.3 SNF7 family protein [Tetrahymena thermophila SB210] | diamond | 159 | 69.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27904894 | 27904894 | PRJNA728642_P_NODE_18325_length_244_cov_0.900585_g18054_i0 | PRJNA728642 | 18325 | 244 | 0.900585 | 2.1974274 | Triparma columacea | 722753 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 1.07e-18 | NR | GMI41761.1 | 722753 | g18054 | i0 | 75.6 | 1.10655737704918 | 45 | 11 | 55.3 | 0 | 2 | 136 | 241 | 285 | GMI41761.1 hypothetical protein TrCOL_g9120 [Triparma columacea] | diamond | 270 | 87.8 | 1 | Eukaryota | Sar | Bolidophyceae | Parmales | Triparmaceae | Triparma | Triparma columacea | |||
| 28041833 | 28041833 | PRJNA728642_P_NODE_17145_length_247_cov_1.660920_g16874_i0 | PRJNA728642 | 17145 | 247 | 1.66092 | 4.1024724 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 5.02e-4 | NR | KRX05618.1 | 266149 | g16874 | i0 | 86.4 | 1.62753036437247 | 22 | 3 | 26.7 | 0 | 134 | 69 | 129 | 150 | KRX05618.1 Cyclophilin-like peptidyl-prolyl cis-trans isomerase domain [Pseudocohnilembus persalinus] | diamond | 402 | 47.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 28094607 | 28094607 | PRJNA728642_P_NODE_17185_length_247_cov_1.327586_g16914_i0 | PRJNA728642 | 17185 | 247 | 1.327586 | 3.27913742 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00615 | NR | XP_001011223.2 | 312017 | g16914 | i0 | 48.9 | 0.546558704453441 | 45 | 22 | 54.7 | 1 | 38 | 172 | 877 | 920 | XP_001011223.2 hypothetical protein TTHERM_00145830 [Tetrahymena thermophila SB210] | diamond | 135 | 45.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28220728 | 28220728 | PRJNA728642_P_NODE_7526_length_373_cov_1.026667_g7255_i0 | PRJNA728642 | 7526 | 373 | 1.026667 | 3.82946791 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 1.97e-35 | NR | XP_001025570.1 | 312017 | g7255 | i0 | 70 | 0.723860589812332 | 90 | 27 | 72.4 | 0 | 343 | 74 | 1 | 90 | XP_001025570.1 alternative oxidase [Tetrahymena thermophila SB210] | diamond | 270 | 133 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28978798 | 28978798 | PRJNA728642_P_NODE_15328_length_255_cov_1.620879_g15057_i0 | PRJNA728642 | 15328 | 255 | 1.620879 | 4.13324145 | Ectocarpus siliculosus | 2880 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0154 | NR | CBJ33190.1 | 2880 | g15057 | i0 | 48.9 | 0.552941176470588 | 47 | 24 | 55.3 | 0 | 254 | 114 | 72 | 118 | CBJ33190.1 TPR repeat-containing protein [Ectocarpus siliculosus] | diamond | 141 | 43.9 | 1 | Eukaryota | Sar | Phaeophyceae | Ectocarpales | Ectocarpaceae | Ectocarpus | Ectocarpus siliculosus | |||
| 29262620 | 29262620 | PRJNA728642_P_NODE_15209_length_256_cov_2.153005_g14938_i0 | PRJNA728642 | 15209 | 256 | 2.153005 | 5.5116928 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 5.6e-32 | NR | XP_001024688.2 | 312017 | g14938 | i0 | 85.5 | 0.890625 | 76 | 11 | 89.1 | 0 | 255 | 28 | 1154 | 1229 | XP_001024688.2 ABC transporter family protein [Tetrahymena thermophila SB210] | diamond | 228 | 127 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29294403 | 29294403 | PRJNA728642_P_NODE_13149_length_278_cov_1.004878_g12878_i0 | PRJNA728642 | 13149 | 278 | 1.004878 | 2.79356084 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 3.1500000000000002e-49 | NR | XP_001027342.1 | 312017 | g12878 | i0 | 85.9 | 0.992805755395683 | 92 | 13 | 99.3 | 0 | 277 | 2 | 190 | 281 | XP_001027342.1 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 276 | 168 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29546828 | 29546828 | PRJNA728642_P_NODE_17870_length_245_cov_1.703488_g17599_i0 | PRJNA728642 | 17870 | 245 | 1.703488 | 4.1735456 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 4.98e-7 | NR | XP_001032819.3 | 312017 | g17599 | i0 | 82.8 | 0.355102040816327 | 29 | 5 | 35.5 | 0 | 129 | 43 | 838 | 866 | XP_001032819.3 kinesin motor catalytic domain protein [Tetrahymena thermophila SB210] | diamond | 87 | 56.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29609808 | 29609808 | PRJNA728642_P_NODE_16330_length_250_cov_0.870056_g16059_i0 | PRJNA728642 | 16330 | 250 | 0.870056 | 2.17514 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 6.55e-9 | NR | KRX09532.1 | 266149 | g16059 | i0 | 34.7 | 0.9 | 75 | 49 | 90 | 0 | 248 | 24 | 1101 | 1175 | KRX09532.1 Longin-like domain [Pseudocohnilembus persalinus] | diamond | 225 | 62 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30779028 | 30779028 | PRJNA728642_P_NODE_18734_length_243_cov_0.905882_g18463_i0 | PRJNA728642 | 18734 | 243 | 0.905882 | 2.20129326 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.63e-34 | NR | XP_001007594.1 | 312017 | g18463 | i0 | 91 | 0.827160493827161 | 67 | 6 | 82.7 | 0 | 43 | 243 | 286 | 352 | XP_001007594.1 cytosol aminopeptidase [Tetrahymena thermophila SB210] | diamond | 201 | 132 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30810612 | 30810612 | PRJNA728642_P_NODE_15974_length_251_cov_0.865169_g15703_i0 | PRJNA728642 | 15974 | 251 | 0.865169 | 2.17157419 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.15e-25 | NR | XP_001023312.1 | 312017 | g15703 | i0 | 82.8 | 0.764940239043825 | 64 | 11 | 76.5 | 0 | 3 | 194 | 2260 | 2323 | XP_001023312.1 HEAT repeat protein [Tetrahymena thermophila SB210] | diamond | 192 | 109 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30810613 | 30810613 | PRJNA728642_P_NODE_16194_length_250_cov_0.870056_g15923_i0 | PRJNA728642 | 16194 | 250 | 0.870056 | 2.17514 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 6.47e-36 | NR | XP_001011080.1 | 312017 | g15923 | i0 | 80.7 | 0.996 | 83 | 16 | 99.6 | 0 | 249 | 1 | 200 | 282 | XP_001011080.1 thioredoxin glutathione reductase [Tetrahymena thermophila SB210] | diamond | 249 | 136 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31601085 | 31601085 | PRJNA728642_P_NODE_16196_length_250_cov_0.870056_g15925_i0 | PRJNA728642 | 16196 | 250 | 0.870056 | 2.17514 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.22e-10 | NR | KAL4464681.1 | 5901 | g15925 | i0 | 91.2 | 0.408 | 34 | 3 | 40.8 | 0 | 89 | 190 | 1 | 34 | KAL4464681.1 hypothetical protein ABPG74_011242 [Tetrahymena malaccensis] | diamond | 102 | 63.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 31664042 | 31664042 | PRJNA728642_P_NODE_17377_length_247_cov_0.885057_g17106_i0 | PRJNA728642 | 17377 | 247 | 0.885057 | 2.18609079 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 9.46e-7 | NR | KAL4463047.1 | 2486642 | g17106 | i0 | 67.6 | 0.449392712550607 | 37 | 12 | 44.9 | 0 | 163 | 53 | 550 | 586 | KAL4463047.1 hypothetical protein ABPG72_009190 [Tetrahymena utriculariae] | diamond | 111 | 55.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 31759029 | 31759029 | PRJNA728642_P_NODE_19277_length_242_cov_0.911243_g19006_i0 | PRJNA728642 | 19277 | 242 | 0.911243 | 2.20520806 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 1.06e-19 | NR | KAL4485360.1 | 2486642 | g19006 | i0 | 57.9 | 0.942148760330578 | 76 | 31 | 94.2 | 1 | 229 | 2 | 1 | 75 | KAL4485360.1 hypothetical protein ABPG72_008536 [Tetrahymena utriculariae] | diamond | 228 | 90.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 32497243 | 32497243 | PRJNA728642_P_NODE_13199_length_277_cov_1.509804_g12928_i0 | PRJNA728642 | 13199 | 277 | 1.509804 | 4.18215708 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00633 | NR | GFH45699.1 | 426638 | g12928 | i0 | 33 | 4.73285198555957 | 88 | 53 | 95.3 | 2 | 265 | 2 | 271 | 352 | GFH45699.1 hypothetical protein CTEN210_02173 [Chaetoceros tenuissimus] | diamond | 1311 | 45.4 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 32613081 | 32613081 | PRJNA728642_P_NODE_18140_length_245_cov_0.895349_g17869_i0 | PRJNA728642 | 18140 | 245 | 0.895349 | 2.19360505 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 2.45e-15 | NR | XP_001018694.2 | 312017 | g17869 | i0 | 62.7 | 0.820408163265306 | 67 | 15 | 82 | 1 | 202 | 2 | 6 | 62 | XP_001018694.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] | diamond | 201 | 79.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32644305 | 32644305 | PRJNA728642_P_NODE_5520_length_438_cov_0.876712_g5249_i0 | PRJNA728642 | 5520 | 438 | 0.876712 | 3.83999856 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.7299999999999996e-41 | NR | 2XZN_5 | 5911 | g5249 | i0 | 76.2 | 0.691780821917808 | 101 | 24 | 69.2 | 0 | 436 | 134 | 18 | 118 | 2XZN_5 Chain 5, Ribosomal Protein S26e Containing Protein [Tetrahymena thermophila] | diamond | 303 | 144 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32739224 | 32739224 | PRJNA728642_P_NODE_17760_length_246_cov_0.890173_g17489_i0 | PRJNA728642 | 17760 | 246 | 0.890173 | 2.18982558 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 9.51e-12 | NR | XP_001018543.2 | 312017 | g17489 | i0 | 87.5 | 0.390243902439024 | 32 | 4 | 39 | 0 | 158 | 63 | 24 | 55 | XP_001018543.2 ubiquitin-conjugating enzyme E2 [Tetrahymena thermophila SB210] | diamond | 96 | 67 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;