contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA512103" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1760742 | 1760742 | PRJNA512103_P_NODE_12902_length_304_cov_0.956863_g12490_i0 | PRJNA512103 | 12902 | 304 | 0.956863 | 2.90886352 | Labyrinthula sp. | 1678526 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 7.2e-37 | NR | QOW07434.1 | 1678526 | g12490 | i0 | 73.1 | 2.76315789473684 | 93 | 25 | 91.8 | 0 | 20 | 298 | 8 | 100 | QOW07434.1 NADH dehydrogenase subunit 7 [Labyrinthula sp.] | diamond | 840 | 138 | 1 | Eukaryota | Sar | Bigyra | Labyrinthulida | Labyrinthulaceae | Labyrinthula | Labyrinthula sp. | |||
| 8139460 | 8139460 | PRJNA512103_P_NODE_4507_length_723_cov_2.879822_g4144_i0 | PRJNA512103 | 4507 | 723 | 2.879822 | 20.82111306 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 288 | 1.9e-94 | NR | YP_005090289.1 | 2829 | g4144 | i0 | 62.1 | 19.2448132780083 | 232 | 88 | 96.3 | 0 | 6 | 701 | 40 | 271 | YP_005090289.1 cytochrome c oxidase subunit III [Heterosigma akashiwo] | diamond | 13914 | 288 | 1 | Eukaryota | Sar | Raphidophyceae | Chattonellales | Chattonellaceae | Heterosigma | Heterosigma akashiwo | |||
| 15788957 | 15788957 | PRJNA512103_P_NODE_32813_length_165_cov_0.896552_g32401_i0 | PRJNA512103 | 32813 | 165 | 0.896552 | 1.4793108 | Triparma | 722752 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.1e-25 | NR | GMI08560.1 | 1606542 | g32401 | i0 | 92 | 4.54545454545455 | 50 | 4 | 90.9 | 0 | 11 | 160 | 77 | 126 | GMI08560.1 hypothetical protein TrVE_jg6717 [Triparma verrucosa] | diamond | 750 | 102 | 1 | Eukaryota | Sar | Bolidophyceae | Parmales | Triparmaceae | Triparma | Triparma verrucosa | |||
| 15789054 | 15789054 | PRJNA512103_P_NODE_4113_length_777_cov_3.453297_g3764_i0 | PRJNA512103 | 4113 | 777 | 3.453297 | 26.83211769 | Thraustochytriidae | 33674 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 4.7499999999999987e-95 | NR | AAG23676.1 | 42467 | g3764 | i0 | 58.9 | 1.78378378378378 | 231 | 90 | 87.3 | 2 | 40 | 717 | 9 | 239 | AAG23676.1 cytochrome c oxidase subunit 2 [Thraustochytrium aureum] | diamond | 1386 | 291 | 0.993127147766323 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Thraustochytrium | Thraustochytrium aureum | |||
| 17063598 | 17063598 | PRJNA512103_P_NODE_3714_length_836_cov_1.437103_g3390_i0 | PRJNA512103 | 3714 | 836 | 1.437103 | 12.01418108 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 286 | 9.63e-91 | NR | GBG24767.1 | 2315210 | g3390 | i0 | 56.4 | 1.97727272727273 | 275 | 119 | 98.7 | 1 | 834 | 10 | 86 | 359 | GBG24767.1 Coronin-like protein [Hondaea fermentalgiana] | diamond | 1653 | 286 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 24712511 | 24712511 | PRJNA512103_P_NODE_6160_length_562_cov_2.191033_g5761_i0 | PRJNA512103 | 6160 | 562 | 2.191033 | 12.31360546 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.1e-66 | NR | ACS27121.1 | 2829 | g5761 | i0 | 65.4 | 31.6281138790036 | 179 | 62 | 95.6 | 0 | 10 | 546 | 239 | 417 | ACS27121.1 NADH dehydrogenase subunit 5 [Heterosigma akashiwo] | diamond | 17775 | 228 | 0.991228070175439 | Eukaryota | Sar | Raphidophyceae | Chattonellales | Chattonellaceae | Heterosigma | Heterosigma akashiwo | |||
| 26918992 | 26918992 | PRJNA512103_P_NODE_4102_length_779_cov_1.753425_g3753_i0 | PRJNA512103 | 4102 | 779 | 1.753425 | 13.65918075 | Labyrinthula sp. | 1678526 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 1.4e-47 | NR | QOW07447.1 | 1678526 | g3753 | i0 | 45.3 | 0.978177150192555 | 254 | 113 | 91.7 | 4 | 777 | 64 | 7 | 250 | QOW07447.1 ATP synthase F0 subunit a, partial [Labyrinthula sp.] | diamond | 762 | 168 | 1 | Eukaryota | Sar | Bigyra | Labyrinthulida | Labyrinthulaceae | Labyrinthula | Labyrinthula sp. | |||
| 27266833 | 27266833 | PRJNA512103_P_NODE_11223_length_341_cov_1.373288_g10811_i0 | PRJNA512103 | 11223 | 341 | 1.373288 | 4.68291208 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 2.0500000000000003e-27 | NR | GBG25317.1 | 2315210 | g10811 | i0 | 82.5 | 0.501466275659824 | 57 | 10 | 50.1 | 0 | 164 | 334 | 57 | 113 | GBG25317.1 Ubiquitin-conjugating enzyme family protein [Hondaea fermentalgiana] | diamond | 171 | 109 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 27929998 | 27929998 | PRJNA512103_P_NODE_24385_length_191_cov_1.035211_g23973_i0 | PRJNA512103 | 24385 | 191 | 1.035211 | 1.97725301 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 1.5600000000000002e-21 | NR | GBG24679.1 | 2315210 | g23973 | i0 | 69.6 | 0.879581151832461 | 56 | 17 | 88 | 0 | 11 | 178 | 122 | 177 | GBG24679.1 Aspartate aminotransferase, mitochondrial [Hondaea fermentalgiana] | diamond | 168 | 96.3 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 28245502 | 28245502 | PRJNA512103_P_NODE_6886_length_515_cov_1.804721_g6481_i0 | PRJNA512103 | 6886 | 515 | 1.804721 | 9.29431315 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.45e-41 | NR | GBG31757.1 | 2315210 | g6481 | i0 | 45.3 | 1.84660194174757 | 161 | 82 | 90.9 | 2 | 6 | 473 | 3 | 162 | GBG31757.1 60S ribosomal protein L27 [Hondaea fermentalgiana] | diamond | 951 | 147 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 29540134 | 29540134 | PRJNA512103_P_NODE_19690_length_217_cov_1.077381_g19278_i0 | PRJNA512103 | 19690 | 217 | 1.077381 | 2.33791677 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 6.01e-4 | NR | GBG34315.1 | 2315210 | g19278 | i0 | 37.7 | 0.732718894009217 | 53 | 33 | 73.3 | 0 | 12 | 170 | 8 | 60 | GBG34315.1 Hypothetical Protein FCC1311_105382 [Hondaea fermentalgiana] | diamond | 159 | 47.4 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 29697710 | 29697710 | PRJNA512103_P_NODE_9990_length_376_cov_6.189602_g9578_i0 | PRJNA512103 | 9990 | 376 | 6.189602 | 23.27290352 | Thraustochytrium aureum | 42467 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 3.4600000000000005e-27 | NR | AAG23688.1 | 42467 | g9578 | i0 | 78.9 | 1.13297872340426 | 71 | 15 | 56.6 | 0 | 284 | 72 | 5 | 75 | AAG23688.1 ATP synthase F0 subunit 9 [Thraustochytrium aureum] | diamond | 426 | 105 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Thraustochytrium | Thraustochytrium aureum | |||
| 29871477 | 29871477 | PRJNA512103_P_NODE_30211_length_170_cov_1.074380_g29799_i0 | PRJNA512103 | 30211 | 170 | 1.07438 | 1.826446 | root | 1 | Root_unresolved | Root_unresolved | 75.5 | 3.58e-14 | NR | GFH45819.1 | 426638 | g29799 | i0 | 61.5 | 16.6764705882353 | 52 | 20 | 91.8 | 0 | 158 | 3 | 7 | 58 | GFH45819.1 argininosuccinate synthase [Chaetoceros tenuissimus] | diamond | 2835 | 75.5 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 30425147 | 30425147 | PRJNA512103_P_NODE_12853_length_305_cov_0.972656_g12441_i0 | PRJNA512103 | 12853 | 305 | 0.972656 | 2.9666008 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0395 | NR | XP_067182747.1 | 310047 | g12441 | i0 | 40.5 | 0.413114754098361 | 42 | 25 | 41.3 | 0 | 83 | 208 | 141 | 182 | XP_067182747.1 membrane associated with a RING finger [Cryptosporidium bovis] | diamond | 126 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 30819288 | 30819288 | PRJNA512103_P_NODE_22834_length_198_cov_1.000000_g22422_i0 | PRJNA512103 | 22834 | 198 | 1 | 1.98 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 2.1699999999999998e-23 | NR | XP_012894128.1 | 12968 | g22422 | i0 | 72.9 | 1.78787878787879 | 59 | 16 | 89.4 | 0 | 187 | 11 | 116 | 174 | XP_012894128.1 Dihydroorotate oxydase [Blastocystis hominis] | diamond | 354 | 99.4 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 30850809 | 30850809 | PRJNA512103_P_NODE_33934_length_163_cov_0.912281_g33522_i0 | PRJNA512103 | 33934 | 163 | 0.912281 | 1.48701803 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.12e-8 | NR | KAG5190125.1 | 303371 | g33522 | i0 | 58.3 | 3.6441717791411 | 48 | 20 | 88.3 | 0 | 10 | 153 | 55 | 102 | KAG5190125.1 ribosomal protein S25 [Tribonema minus] | diamond | 594 | 57.4 | 0.993031358885017 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 31419720 | 31419720 | PRJNA512103_P_NODE_18836_length_224_cov_1.045714_g18424_i0 | PRJNA512103 | 18836 | 224 | 1.045714 | 2.34239936 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.27e-27 | NR | YP_448707.1 | 2876 | g18424 | i0 | 76.1 | 15.2142857142857 | 71 | 17 | 95.1 | 0 | 222 | 10 | 102 | 172 | YP_448707.1 NADH dehydrogenase subunit 5 [Dictyota dichotoma] | diamond | 3408 | 115 | 0.991304347826087 | Eukaryota | Sar | Phaeophyceae | Dictyotales | Dictyotaceae | Dictyota | Dictyota dichotoma | |||
| 31483291 | 31483291 | PRJNA512103_P_NODE_20016_length_214_cov_2.096970_g19604_i0 | PRJNA512103 | 20016 | 214 | 2.09697 | 4.4875158 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 4.54e-20 | NR | XAL83106.1 | 568390 | g19604 | i0 | 64.6 | 7.28971962616822 | 65 | 23 | 91.1 | 0 | 205 | 11 | 167 | 231 | XAL83106.1 NADH dehydrogenase subunit 7 [Leukarachnion sp. ATCC PRA-24] | diamond | 1560 | 92.8 | 0.995689655172414 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 31878663 | 31878663 | PRJNA512103_P_NODE_24517_length_190_cov_1.574468_g24105_i0 | PRJNA512103 | 24517 | 190 | 1.574468 | 2.9914892 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00396 | NR | GBG34049.1 | 2315210 | g24105 | i0 | 38.3 | 1.87894736842105 | 60 | 36 | 93.2 | 1 | 5 | 181 | 515 | 574 | GBG34049.1 Hypothetical Protein FCC1311_102722 [Hondaea fermentalgiana] | diamond | 357 | 44.7 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 32005456 | 32005456 | PRJNA512103_P_NODE_31218_length_168_cov_0.873950_g30806_i0 | PRJNA512103 | 31218 | 168 | 0.87395 | 1.468236 | Nitzschia inconspicua | 303405 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0102 | NR | KAG7362074.1 | 303405 | g30806 | i0 | 41.9 | 0.767857142857143 | 43 | 25 | 76.8 | 0 | 168 | 40 | 201 | 243 | KAG7362074.1 FMN-dependent dehydrogenase [Nitzschia inconspicua] | diamond | 129 | 43.1 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia inconspicua | ||
| 32337461 | 32337461 | PRJNA512103_P_NODE_14999_length_266_cov_1.230415_g14587_i0 | PRJNA512103 | 14999 | 266 | 1.230415 | 3.2729039 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 9.04e-33 | NR | NP_037607.1 | 4787 | g14587 | i0 | 76.8 | 3.65413533834586 | 82 | 19 | 92.5 | 0 | 21 | 266 | 92 | 173 | NP_037607.1 NADH dehydrogenase subunit 7 [Phytophthora infestans] | diamond | 972 | 127 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32637611 | 32637611 | PRJNA512103_P_NODE_10340_length_366_cov_1.321767_g9928_i0 | PRJNA512103 | 10340 | 366 | 1.321767 | 4.83766722 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 2e-31 | NR | GBG25401.1 | 2315210 | g9928 | i0 | 56.8 | 0.967213114754098 | 118 | 44 | 91 | 1 | 341 | 9 | 9 | 126 | GBG25401.1 60S ribosomal protein L12 [Hondaea fermentalgiana] | diamond | 354 | 119 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana |
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);;