contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10717236 | 10717236 | PRJNA550047_P_NODE_159829_length_345_cov_4.084559_g157869_i0 | PRJNA550047 | 159829 | 345 | 4.084559 | 14.09172855 | root | 1 | Root_unresolved | Root_unresolved | 82.4 | 1.15e-15 | NR | GBF88336.1 | 307507 | g157869 | i0 | 80 | 3.91304347826087 | 50 | 10 | 43.5 | 0 | 3 | 152 | 314 | 363 | GBF88336.1 cysteine synthase [Raphidocelis subcapitata] | diamond | 1350 | 82.8 | 0.995169082125604 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 15819093 | 15819093 | PRJNA550047_P_NODE_432233_length_253_cov_4.483333_g430261_i0 | PRJNA550047 | 432233 | 253 | 4.483333 | 11.34283249 | Trebouxia sp. C | 2796353 | Plants | Plants | 104 | 9.289999999999999e-24 | NR | KAL3157954.1 | 3373145 | g430261 | i0 | 68.1 | 0.818181818181818 | 69 | 22 | 81.8 | 0 | 250 | 44 | 401 | 469 | KAL3157954.1 hypothetical protein ABBQ32_012355 [Trebouxia sp. C0010 RCD-2024] | diamond | 207 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 22192707 | 22192707 | PRJNA550047_P_NODE_390678_length_268_cov_16.158974_g388706_i0 | PRJNA550047 | 390678 | 268 | 16.158974 | 43.30605032 | Tetrabaena socialis | 47790 | Plants | Plants | 117 | 2.4699999999999997e-30 | NR | PNH12586.1 | 47790 | g388706 | i0 | 62.5 | 5.91044776119403 | 88 | 33 | 98.5 | 0 | 266 | 3 | 80 | 167 | PNH12586.1 DNA-directed RNA polymerase II subunit RPB2 [Tetrabaena socialis] | diamond | 1584 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 26602914 | 26602914 | PRJNA550047_P_NODE_112101_length_345_cov_7.393382_g110141_i0 | PRJNA550047 | 112101 | 345 | 7.393382 | 25.5071679 | Symbiochloris irregularis | 706552 | Plants | Plants | 72 | 6.66e-12 | NR | KAK9797386.1 | 706552 | g110141 | i0 | 63.8 | 0.408695652173913 | 47 | 17 | 40.9 | 0 | 339 | 199 | 244 | 290 | KAK9797386.1 hypothetical protein WJX73_009647 [Symbiochloris irregularis] | diamond | 141 | 72 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 26776504 | 26776504 | PRJNA550047_P_NODE_540721_length_216_cov_22.188811_g538748_i0 | PRJNA550047 | 540721 | 216 | 22.188811 | 47.92783176 | Chlamydomonas | 3052 | Plants | Plants | 85.5 | 2.26e-17 | NR | KAG2440908.1 | 51695 | g538748 | i0 | 59.2 | 3.90277777777778 | 71 | 29 | 98.6 | 0 | 214 | 2 | 463 | 533 | KAG2440908.1 hypothetical protein HXX76_003761 [Chlamydomonas incerta] | diamond | 843 | 85.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 26888461 | 26888461 | PRJNA550047_P_NODE_356721_length_282_cov_9.196172_g354750_i0 | PRJNA550047 | 356721 | 282 | 9.196172 | 25.93320504 | Prototheca wickerhamii | 3111 | Plants | Plants | 108 | 5.22e-25 | NR | KAK2078324.1 | 3111 | g354750 | i0 | 100 | 0.563829787234043 | 53 | 0 | 56.4 | 0 | 2 | 160 | 129 | 181 | KAK2078324.1 hypothetical protein QBZ16_004193 [Prototheca wickerhamii] | diamond | 159 | 108 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 27282559 | 27282559 | PRJNA550047_P_NODE_57663_length_345_cov_15.948529_g55703_i0 | PRJNA550047 | 57663 | 345 | 15.948529 | 55.02242505 | Trebouxia | 13786 | Plants | Plants | 45.4 | 0.0121 | NR | KAA6414375.1 | 2608996 | g55703 | i0 | 80 | 0.869565217391304 | 25 | 5 | 21.7 | 0 | 148 | 74 | 336 | 360 | KAA6414375.1 MAG: hypothetical protein FRX49_13683 [Trebouxia sp. A1-2] | diamond | 300 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 27836116 | 27836116 | PRJNA550047_P_NODE_490984_length_233_cov_12.600000_g489011_i0 | PRJNA550047 | 490984 | 233 | 12.6 | 29.358 | Ulva flexuosa | 83791 | Plants | Plants | 107 | 7.05e-25 | NR | AZP40192.1 | 83791 | g489011 | i0 | 67.1 | 0.978540772532189 | 76 | 25 | 97.9 | 0 | 232 | 5 | 159 | 234 | AZP40192.1 hypothetical protein [Ulva flexuosa] | diamond | 228 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva flexuosa | |
| 28372753 | 28372753 | PRJNA550047_P_NODE_133746_length_345_cov_5.790441_g131786_i0 | PRJNA550047 | 133746 | 345 | 5.790441 | 19.97702145 | Monoraphidium neglectum | 145388 | Plants | Plants | 46.6 | 0.00504 | NR | XP_013895436.1 | 145388 | g131786 | i0 | 50 | 0.817391304347826 | 46 | 22 | 40 | 1 | 140 | 3 | 11 | 55 | XP_013895436.1 hypothetical protein MNEG_11545 [Monoraphidium neglectum] | diamond | 282 | 46.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 28404536 | 28404536 | PRJNA550047_P_NODE_383746_length_271_cov_10.020202_g381774_i0 | PRJNA550047 | 383746 | 271 | 10.020202 | 27.15474742 | Tetradesmus obliquus | 3088 | Plants | Plants | 60.8 | 2.23e-8 | NR | WIA28747.1 | 3088 | g381774 | i0 | 65.8 | 0.420664206642066 | 38 | 13 | 42.1 | 0 | 264 | 151 | 91 | 128 | WIA28747.1 hypothetical protein OEZ86_011281 [Tetradesmus obliquus] | diamond | 114 | 60.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 28909516 | 28909516 | PRJNA550047_P_NODE_597408_length_198_cov_27.640000_g595435_i0 | PRJNA550047 | 597408 | 198 | 27.64 | 54.7272 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 46.6 | 1.39e-4 | NR | BDA48992.1 | 2315456 | g595435 | i0 | 54.5 | 0.666666666666667 | 44 | 20 | 66.7 | 0 | 8 | 139 | 49 | 92 | BDA48992.1 hypothetical protein COCOBI_13-1020 [Coccomyxa sp. Obi] | diamond | 132 | 46.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 29193957 | 29193957 | PRJNA550047_P_NODE_186789_length_344_cov_15.191882_g184828_i0 | PRJNA550047 | 186789 | 344 | 15.191882 | 52.26007408 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 63.5 | 3.39e-9 | NR | GMH34917.1 | 3041901 | g184828 | i0 | 53.2 | 0.409883720930233 | 47 | 22 | 41 | 0 | 3 | 143 | 147 | 193 | GMH34917.1 hypothetical protein BSKO_02778 [Bryopsis sp. KO-2023] | diamond | 141 | 63.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 29351934 | 29351934 | PRJNA550047_P_NODE_599989_length_198_cov_6.752000_g598016_i0 | PRJNA550047 | 599989 | 198 | 6.752 | 13.36896 | Coccomyxa viridis | 1274662 | Plants | Plants | 55.1 | 9.04e-7 | NR | CAL5221844.1 | 1274662 | g598016 | i0 | 69.4 | 0.545454545454545 | 36 | 10 | 54.5 | 1 | 3 | 110 | 481 | 515 | CAL5221844.1 g4103 [Coccomyxa viridis] | diamond | 108 | 55.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 29509457 | 29509457 | PRJNA550047_P_NODE_239090_length_300_cov_19.625551_g237121_i0 | PRJNA550047 | 239090 | 300 | 19.625551 | 58.876653 | Dunaliella salina | 3046 | Plants | Plants | 43.5 | 0.0381 | NR | KAF5834351.1 | 3046 | g237121 | i0 | 57.6 | 0.33 | 33 | 12 | 31 | 1 | 124 | 32 | 229 | 261 | KAF5834351.1 hypothetical protein DUNSADRAFT_9014 [Dunaliella salina] | diamond | 99 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 29509583 | 29509583 | PRJNA550047_P_NODE_496750_length_231_cov_14.265823_g494777_i0 | PRJNA550047 | 496750 | 231 | 14.265823 | 32.95405113 | Symbiochloris irregularis | 706552 | Plants | Plants | 116 | 1.79e-30 | NR | KAK9808432.1 | 706552 | g494777 | i0 | 75 | 0.987012987012987 | 76 | 19 | 98.7 | 0 | 229 | 2 | 96 | 171 | KAK9808432.1 hypothetical protein WJX73_004832 [Symbiochloris irregularis] | diamond | 228 | 116 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 30267987 | 30267987 | PRJNA550047_P_NODE_432052_length_253_cov_5.394444_g430080_i0 | PRJNA550047 | 432052 | 253 | 5.394444 | 13.64794332 | Chlorella vulgaris | 3077 | Plants | Plants | 102 | 4.169999999999999e-23 | NR | KAI3424684.1 | 3077 | g430080 | i0 | 54.3 | 0.960474308300395 | 81 | 37 | 96 | 0 | 245 | 3 | 456 | 536 | KAI3424684.1 hypothetical protein D9Q98_008074 [Chlorella vulgaris] | diamond | 243 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 31026107 | 31026107 | PRJNA550047_P_NODE_500555_length_230_cov_9.178344_g498582_i0 | PRJNA550047 | 500555 | 230 | 9.178344 | 21.1101912 | [Myrmecia] bisecta | 41462 | Plants | Plants | 42.7 | 0.0322 | NR | KAK9810336.1 | 41462 | g498582 | i0 | 63.6 | 0.991304347826087 | 33 | 12 | 43 | 0 | 4 | 102 | 264 | 296 | KAK9810336.1 hypothetical protein WJX72_008917 [[Myrmecia] bisecta] | diamond | 228 | 42.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 31151907 | 31151907 | PRJNA550047_P_NODE_340215_length_289_cov_4.328704_g338245_i0 | PRJNA550047 | 340215 | 289 | 4.328704 | 12.50995456 | Volvox africanus | 51714 | Plants | Plants | 77 | 5.97e-14 | NR | GLI60693.1 | 51714 | g338245 | i0 | 50 | 0.747404844290657 | 72 | 36 | 74.7 | 0 | 217 | 2 | 854 | 925 | GLI60693.1 hypothetical protein VaNZ11_002897 [Volvox africanus] | diamond | 216 | 77 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 31373704 | 31373704 | PRJNA550047_P_NODE_151676_length_345_cov_4.617647_g149716_i0 | PRJNA550047 | 151676 | 345 | 4.617647 | 15.93088215 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 58.5 | 3.34e-7 | NR | GAX81521.1 | 1157962 | g149716 | i0 | 58 | 0.434782608695652 | 50 | 21 | 43.5 | 0 | 3 | 152 | 492 | 541 | GAX81521.1 hypothetical protein CEUSTIGMA_g8949.t1 [Chlamydomonas eustigma] | diamond | 150 | 58.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 31468825 | 31468825 | PRJNA550047_P_NODE_573796_length_206_cov_6.413534_g571823_i0 | PRJNA550047 | 573796 | 206 | 6.413534 | 13.21188004 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 54.7 | 1.41e-6 | NR | BDA43931.1 | 2315456 | g571823 | i0 | 70.6 | 1.98058252427184 | 34 | 10 | 49.5 | 0 | 205 | 104 | 297 | 330 | BDA43931.1 Chloride transport protein 6 [Coccomyxa sp. Obi] | diamond | 408 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 31595354 | 31595354 | PRJNA550047_P_NODE_495676_length_232_cov_4.018868_g493703_i0 | PRJNA550047 | 495676 | 232 | 4.018868 | 9.32377376 | Coccomyxa viridis | 1274662 | Plants | Plants | 134 | 2.33e-34 | NR | CAL5221045.1 | 1274662 | g493703 | i0 | 81.3 | 3.9051724137931 | 75 | 14 | 97 | 0 | 8 | 232 | 354 | 428 | CAL5221045.1 g3168 [Coccomyxa viridis] | diamond | 906 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 31753145 | 31753145 | PRJNA550047_P_NODE_346097_length_286_cov_17.868545_g344126_i0 | PRJNA550047 | 346097 | 286 | 17.868545 | 51.1040387 | Micractinium conductrix | 554055 | Plants | Plants | 64.3 | 1.63e-9 | NR | PSC67415.1 | 554055 | g344126 | i0 | 64.6 | 2.16083916083916 | 48 | 17 | 50.3 | 0 | 176 | 33 | 497 | 544 | PSC67415.1 Regulator of telomere elongation helicase 1 [Micractinium conductrix] | diamond | 618 | 64.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 31816438 | 31816438 | PRJNA550047_P_NODE_435697_length_252_cov_0.865922_g433725_i0 | PRJNA550047 | 435697 | 252 | 0.865922 | 2.18212344 | [Myrmecia] bisecta | 41462 | Plants | Plants | 52.8 | 1.24e-5 | NR | KAK9818037.1 | 41462 | g433725 | i0 | 56.8 | 2.61904761904762 | 44 | 19 | 52.4 | 0 | 134 | 3 | 788 | 831 | KAK9818037.1 hypothetical protein WJX72_006047 [[Myrmecia] bisecta] | diamond | 660 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32133076 | 32133076 | PRJNA550047_P_NODE_527238_length_221_cov_10.189189_g525265_i0 | PRJNA550047 | 527238 | 221 | 10.189189 | 22.51810769 | Coccomyxa viridis | 1274662 | Plants | Plants | 51.6 | 1.17e-5 | NR | CAL5227277.1 | 1274662 | g525265 | i0 | 46.2 | 1.41176470588235 | 52 | 28 | 70.6 | 0 | 158 | 3 | 94 | 145 | CAL5227277.1 g10208 [Coccomyxa viridis] | diamond | 312 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 32890597 | 32890597 | PRJNA550047_P_NODE_547040_length_214_cov_17.666667_g545067_i0 | PRJNA550047 | 547040 | 214 | 17.666667 | 37.80666738 | Prototheca wickerhamii | 3111 | Plants | Plants | 119 | 2.01e-29 | NR | KAK2080282.1 | 3111 | g545067 | i0 | 100 | 0.827102803738318 | 59 | 0 | 82.7 | 0 | 21 | 197 | 57 | 115 | KAK2080282.1 hypothetical protein QBZ16_000135 [Prototheca wickerhamii] | diamond | 177 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii |
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);;