contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1694439 | 1694439 | PRJNA416866_P_NODE_10082_length_207_cov_0.876712_g9938_i0 | PRJNA416866 | 10082 | 207 | 0.876712 | 1.81479384 | Coccomyxa viridis | 1274662 | Plants | Plants | 89.7 | 6.45e-19 | NR | CAL5220529.1 | 1274662 | g9938 | i0 | 73.2 | 4.1304347826087 | 56 | 15 | 81.2 | 0 | 168 | 1 | 316 | 371 | CAL5220529.1 g2561 [Coccomyxa viridis] | diamond | 855 | 89.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 11898506 | 11898506 | PRJNA416866_P_NODE_7910_length_230_cov_1.289941_g7766_i0 | PRJNA416866 | 7910 | 230 | 1.289941 | 2.9668643 | Tetradesmus obliquus | 3088 | Plants | Plants | 156 | 3.97e-44 | NR | WIA42672.1 | 3088 | g7766 | i0 | 89.5 | 1.98260869565217 | 76 | 8 | 99.1 | 0 | 2 | 229 | 27 | 102 | WIA42672.1 hypothetical protein OEZ86_008632 [Tetradesmus obliquus] | diamond | 456 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 27707869 | 27707869 | PRJNA416866_P_NODE_5924_length_268_cov_1.391304_g5780_i0 | PRJNA416866 | 5924 | 268 | 1.391304 | 3.72869472 | Raphidocelis subcapitata | 307507 | Plants | Plants | 65.5 | 1.09e-10 | NR | GBF92640.1 | 307507 | g5780 | i0 | 42.7 | 2.45149253731343 | 82 | 47 | 91.8 | 0 | 260 | 15 | 42 | 123 | GBF92640.1 hypothetical protein Rsub_05009 [Raphidocelis subcapitata] | diamond | 657 | 65.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 27755860 | 27755860 | PRJNA416866_P_NODE_7504_length_236_cov_1.828571_g7360_i0 | PRJNA416866 | 7504 | 236 | 1.828571 | 4.31542756 | Eukaryota | 2759 | Plants | Plants | 60.5 | 1.92e-8 | NR | KAG2435375.1 | 51695 | g7360 | i0 | 44.7 | 3.99152542372881 | 47 | 26 | 59.7 | 0 | 35 | 175 | 26 | 72 | KAG2435375.1 hypothetical protein HXX76_007447 [Chlamydomonas incerta] | diamond | 942 | 60.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 27928444 | 27928444 | PRJNA416866_P_NODE_7485_length_237_cov_0.892045_g7341_i0 | PRJNA416866 | 7485 | 237 | 0.892045 | 2.11414665 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 82.8 | 1.94e-16 | NR | GAX86553.1 | 1157962 | g7341 | i0 | 52.4 | 3.1012658227848098 | 82 | 34 | 100 | 3 | 1 | 237 | 207 | 286 | GAX86553.1 hypothetical protein CEUSTIGMA_g13960.t1 [Chlamydomonas eustigma] | diamond | 735 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28071262 | 28071262 | PRJNA416866_P_NODE_2345_length_447_cov_1.813472_g2202_i0 | PRJNA416866 | 2345 | 447 | 1.813472 | 8.10621984 | Eukaryota | 2759 | Plants | Plants | 159 | 5.6e-46 | NR | CAD7698002.1 | 121088 | g2202 | i0 | 53.2 | 21.8120805369128 | 156 | 60 | 97.3 | 2 | 446 | 12 | 59 | 212 | CAD7698002.1 unnamed protein product [Ostreobium quekettii] | diamond | 9750 | 160 | 0.99375 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 28228944 | 28228944 | PRJNA416866_P_NODE_8626_length_219_cov_1.949367_g8482_i0 | PRJNA416866 | 8626 | 219 | 1.949367 | 4.26911373 | Trebouxia | 13786 | Plants | Plants | 97.1 | 1.32e-24 | NR | KAL0020376.1 | 2905654 | g8482 | i0 | 69.1 | 4.68493150684932 | 68 | 21 | 93.2 | 0 | 2 | 205 | 4 | 71 | KAL0020376.1 hypothetical protein WJX79_009890 [Trebouxia sp. C0005] | diamond | 1026 | 97.8 | 0.992842535787321 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 28465308 | 28465308 | PRJNA416866_P_NODE_3686_length_346_cov_1.828070_g3543_i0 | PRJNA416866 | 3686 | 346 | 1.82807 | 6.3251222 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 75.1 | 4.73e-13 | NR | KAG1659219.1 | 1653778 | g3543 | i0 | 39.4 | 3.8757225433526 | 109 | 61 | 94.5 | 2 | 20 | 346 | 262 | 365 | KAG1659219.1 hypothetical protein FOA52_008988 [Chlamydomonas sp. UWO 241] | diamond | 1341 | 75.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 28749354 | 28749354 | PRJNA416866_P_NODE_11807_length_201_cov_0.914286_g11663_i0 | PRJNA416866 | 11807 | 201 | 0.914286 | 1.83771486 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 47.8 | 3.59e-4 | NR | KAI8105049.1 | 2696299 | g11663 | i0 | 40.6 | 2.65671641791045 | 64 | 35 | 95.5 | 1 | 194 | 3 | 218 | 278 | KAI8105049.1 hypothetical protein M9435_000221 [Picochlorum sp. BPE23] | diamond | 534 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 28970407 | 28970407 | PRJNA416866_P_NODE_5828_length_270_cov_2.181818_g5684_i0 | PRJNA416866 | 5828 | 270 | 2.181818 | 5.8909086 | Eremosphaera viridis | 163307 | Plants | Plants | 81.3 | 1.46e-15 | NR | AML77887.1 | 163307 | g5684 | i0 | 48.1 | 1.75555555555556 | 79 | 40 | 87.8 | 1 | 242 | 6 | 398 | 475 | AML77887.1 putative LOV domain-containing protein [Eremosphaera viridis] | diamond | 474 | 81.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Oocystaceae | Eremosphaera | Eremosphaera viridis | |
| 29033773 | 29033773 | PRJNA416866_P_NODE_4168_length_323_cov_1.790076_g4025_i0 | PRJNA416866 | 4168 | 323 | 1.790076 | 5.78194548 | Tetradesmus obliquus | 3088 | Plants | Plants | 46.2 | 0.00594 | NR | WIA19020.1 | 3088 | g4025 | i0 | 35.1 | 1.328173374613 | 77 | 42 | 71.5 | 3 | 75 | 305 | 1499 | 1567 | WIA19020.1 hypothetical protein OEZ85_003681 [Tetradesmus obliquus] | diamond | 429 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29507022 | 29507022 | PRJNA416866_P_NODE_10730_length_205_cov_0.888889_g10586_i0 | PRJNA416866 | 10730 | 205 | 0.888889 | 1.82222245 | Monoraphidium minutum | 39955 | Plants | Plants | 50.1 | 6.09e-5 | NR | KAI8468927.1 | 39955 | g10586 | i0 | 56.5 | 2.01951219512195 | 46 | 18 | 67.3 | 1 | 55 | 192 | 1351 | 1394 | KAI8468927.1 MAG: glycosyl hydrolases family 31-domain-containing protein [Monoraphidium minutum] | diamond | 414 | 50.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 29507032 | 29507032 | PRJNA416866_P_NODE_5050_length_291_cov_2.434783_g4906_i0 | PRJNA416866 | 5050 | 291 | 2.434783 | 7.08521853 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 62.8 | 1.18e-9 | NR | KAG7666851.1 | 1650286 | g4906 | i0 | 54.8 | 3.63917525773196 | 62 | 27 | 63.9 | 1 | 188 | 3 | 34 | 94 | KAG7666851.1 hypothetical protein KSW81_000618 [Chlorella desiccata (nom. nud.)] | diamond | 1059 | 62.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 29949288 | 29949288 | PRJNA416866_P_NODE_5131_length_289_cov_2.048246_g4987_i0 | PRJNA416866 | 5131 | 289 | 2.048246 | 5.91943094 | Volvox africanus | 51714 | Plants | Plants | 92.8 | 1.5e-19 | NR | GIL62576.1 | 51714 | g4987 | i0 | 50 | 0.996539792387543 | 96 | 44 | 98.6 | 2 | 4 | 288 | 77 | 169 | GIL62576.1 hypothetical protein Vafri_16759 [Volvox africanus] | diamond | 288 | 92.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 30170236 | 30170236 | PRJNA416866_P_NODE_1612_length_547_cov_1.353909_g1471_i0 | PRJNA416866 | 1612 | 547 | 1.353909 | 7.40588223 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 85.1 | 1.46e-15 | NR | GAX78013.1 | 1157962 | g1471 | i0 | 34.3 | 0.943327239488117 | 172 | 80 | 81.7 | 6 | 476 | 30 | 274 | 435 | GAX78013.1 hypothetical protein CEUSTIGMA_g5455.t1 [Chlamydomonas eustigma] | diamond | 516 | 85.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30297249 | 30297249 | PRJNA416866_P_NODE_10652_length_205_cov_0.888889_g10508_i0 | PRJNA416866 | 10652 | 205 | 0.888889 | 1.82222245 | Monoraphidium minutum | 39955 | Plants | Plants | 42 | 0.0147 | NR | KAI8470570.1 | 39955 | g10508 | i0 | 65.5 | 0.424390243902439 | 29 | 10 | 42.4 | 0 | 113 | 199 | 2 | 30 | KAI8470570.1 MAG: hypothetical protein J3K34DRAFT_468978 [Monoraphidium minutum] | diamond | 87 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 30423493 | 30423493 | PRJNA416866_P_NODE_1913_length_496_cov_1.427586_g1771_i0 | PRJNA416866 | 1913 | 496 | 1.427586 | 7.08082656 | [Myrmecia] bisecta | 41462 | Plants | Plants | 149 | 2.0999999999999999e-38 | NR | KAK9817796.1 | 41462 | g1771 | i0 | 76.3 | 1.24596774193548 | 97 | 23 | 58.7 | 0 | 494 | 204 | 546 | 642 | KAK9817796.1 hypothetical protein WJX72_002302 [[Myrmecia] bisecta] | diamond | 618 | 149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30739014 | 30739014 | PRJNA416866_P_NODE_10854_length_204_cov_1.307692_g10710_i0 | PRJNA416866 | 10854 | 204 | 1.307692 | 2.66769168 | [Myrmecia] bisecta | 41462 | Plants | Plants | 45.8 | 0.00184 | NR | KAK9814278.1 | 41462 | g10710 | i0 | 54.3 | 1.85294117647059 | 35 | 15 | 51.5 | 1 | 105 | 1 | 125 | 158 | KAK9814278.1 hypothetical protein WJX72_003319 [[Myrmecia] bisecta] | diamond | 378 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30770857 | 30770857 | PRJNA416866_P_NODE_9274_length_211_cov_1.280000_g9130_i0 | PRJNA416866 | 9274 | 211 | 1.28 | 2.7008 | Coccomyxa viridis | 1274662 | Plants | Plants | 75.1 | 9.7e-14 | NR | CAK0780179.1 | 1274662 | g9130 | i0 | 69 | 0.597156398104265 | 42 | 13 | 59.7 | 0 | 210 | 85 | 492 | 533 | CAK0780179.1 hypothetical protein CVIRNUC_004959 [Coccomyxa viridis] | diamond | 126 | 75.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 30913833 | 30913833 | PRJNA416866_P_NODE_2334_length_448_cov_2.025840_g2191_i0 | PRJNA416866 | 2334 | 448 | 2.02584 | 9.0757632 | Viridiplantae | 33090 | Plants | Plants | 174 | 9.27e-48 | NR | KAK9817796.1 | 41462 | g2191 | i0 | 67.2 | 1.75446428571429 | 125 | 41 | 83.7 | 0 | 417 | 43 | 518 | 642 | KAK9817796.1 hypothetical protein WJX72_002302 [[Myrmecia] bisecta] | diamond | 786 | 174 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30928741 | 30928741 | PRJNA416866_P_NODE_10754_length_205_cov_0.888889_g10610_i0 | PRJNA416866 | 10754 | 205 | 0.888889 | 1.82222245 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 63.5 | 1.05e-9 | NR | XP_011395923.1 | 3075 | g10610 | i0 | 53 | 0.965853658536585 | 66 | 30 | 95.1 | 1 | 10 | 204 | 633 | 698 | XP_011395923.1 Aminopeptidase N [Auxenochlorella protothecoides] | diamond | 198 | 63.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 31371372 | 31371372 | PRJNA416866_P_NODE_8416_length_222_cov_1.590062_g8272_i0 | PRJNA416866 | 8416 | 222 | 1.590062 | 3.52993764 | Trebouxia sp. C | 2796353 | Plants | Plants | 76.6 | 3.18e-14 | NR | KAL0050420.1 | 2905655 | g8272 | i0 | 58.6 | 4.02702702702703 | 58 | 24 | 78.4 | 0 | 24 | 197 | 43 | 100 | KAL0050420.1 hypothetical protein WJX82_010895 [Trebouxia sp. C0006] | diamond | 894 | 76.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 | |
| 31497843 | 31497843 | PRJNA416866_P_NODE_5416_length_281_cov_1.745455_g5272_i0 | PRJNA416866 | 5416 | 281 | 1.745455 | 4.90472855 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 121 | 1.3199999999999999e-31 | NR | RMZ56279.1 | 3075 | g5272 | i0 | 70.9 | 4.66548042704626 | 86 | 25 | 91.8 | 0 | 277 | 20 | 53 | 138 | RMZ56279.1 hypothetical protein APUTEX25_002469, partial [Auxenochlorella protothecoides] | diamond | 1311 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 31561145 | 31561145 | PRJNA416866_P_NODE_7536_length_236_cov_0.965714_g7392_i0 | PRJNA416866 | 7536 | 236 | 0.965714 | 2.27908504 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 141 | 7.099999999999999e-38 | NR | GAX78472.1 | 1157962 | g7392 | i0 | 84.6 | 0.991525423728814 | 78 | 12 | 99.2 | 0 | 3 | 236 | 317 | 394 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 234 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma |
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);;