contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA437204" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 432455 | 432455 | PRJNA437204_P_NODE_35161_length_338_cov_1.743396_g34862_i0 | PRJNA437204 | 35161 | 338 | 1.743396 | 5.89267848 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 128 | 5.15e-25 | NTclustered | gi|545366316|ref|XM_005648006.1| | 574566 | g34862 | i0 | 87.5 | 23.2573964497041 | 112 | 12 | 33 | 2 | 126 | 236 | 1597 | 1487 | Coccomyxa subellipsoidea C-169 putative ABC transporter partial mRNA | blastn | 7861 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 432594 | 432594 | PRJNA437204_P_NODE_42301_length_318_cov_1.624490_g42002_i0 | PRJNA437204 | 42301 | 318 | 1.62449 | 5.1658782 | Volvox carteri | 3067 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|302830901|ref|XM_002946971.1| | 3068 | g42002 | i0 | 96.97 | 0.283018867924528 | 33 | 1 | 10 | 0 | 107 | 139 | 29 | 61 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_103245), partial mRNA | blastn | 90 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 433524 | 433524 | PRJNA437204_P_NODE_90721_length_249_cov_0.875000_g90422_i0 | PRJNA437204 | 90721 | 249 | 0.875 | 2.17875 | Chlorella variabilis | 554065 | Plants | Plants | 110 | 1.32e-19 | NTclustered | gi|552833980|ref|XM_005848567.1| | 554065 | g90422 | i0 | 78.09 | 1.61044176706827 | 178 | 36 | 71 | 3 | 4 | 179 | 357 | 181 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_30648) mRNA, complete cds | blastn | 401 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 4258618 | 4258618 | PRJNA437204_P_NODE_105984_length_246_cov_0.861272_g105685_i0 | PRJNA437204 | 105984 | 246 | 0.861272 | 2.11872912 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 148 | 2.75e-31 | NTclustered | gi|2082259086|ref|XM_001697336.2| | 3055 | g105685 | i0 | 82.927 | 17.7723577235772 | 164 | 28 | 67 | 0 | 83 | 246 | 528 | 365 | Chlamydomonas reinhardtii ribosomal protein S14 (CHLRE_11g480150v5), mRNA | blastn | 4372 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 4917452 | 4917452 | PRJNA437204_P_NODE_11364_length_511_cov_1.216895_g11066_i0 | PRJNA437204 | 11364 | 511 | 1.216895 | 6.21833345 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 2.31e-5 | NTclustered | gi|741870561|ref|NC_026009.1| | 3075 | g11066 | i0 | 97.297 | 30.6379647749511 | 37 | 1 | 7 | 0 | 320 | 356 | 32599 | 32563 | Auxenochlorella protothecoides mitochondrion, complete genome | blastn | 15656 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 6809562 | 6809562 | PRJNA437204_P_NODE_120446_length_242_cov_1.047337_g120147_i0 | PRJNA437204 | 120446 | 242 | 1.047337 | 2.53455554 | Chlorella variabilis | 554065 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|552843247|ref|XM_005850723.1| | 554065 | g120147 | i0 | 96.97 | 0.136363636363636 | 33 | 1 | 14 | 0 | 194 | 226 | 2862 | 2830 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_140286) mRNA, complete cds | blastn | 33 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 10636950 | 10636950 | PRJNA437204_P_NODE_64809_length_273_cov_1.190000_g64510_i0 | PRJNA437204 | 64809 | 273 | 1.19 | 3.2487 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 298 | 2.92e-76 | NTclustered | gi|2082250514|ref|XM_001690394.2| | 3055 | g64510 | i0 | 87.645 | 15.5091575091575 | 259 | 28 | 94 | 4 | 9 | 265 | 1372 | 1116 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g329700v5), mRNA | blastn | 4234 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 11910794 | 11910794 | PRJNA437204_P_NODE_14630_length_464_cov_1.240409_g14331_i0 | PRJNA437204 | 14630 | 464 | 1.240409 | 5.75549776 | Chlorella variabilis | 554065 | Plants | Plants | 296 | 1.89e-75 | NTclustered | gi|552834565|ref|XM_005848699.1| | 554065 | g14331 | i0 | 79.391 | 25.2564655172414 | 427 | 82 | 91 | 6 | 41 | 464 | 522 | 99 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59648) mRNA, complete cds | blastn | 11719 | 296 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 14460789 | 14460789 | PRJNA437204_P_NODE_128452_length_241_cov_0.916667_g128153_i0 | PRJNA437204 | 128452 | 241 | 0.916667 | 2.20916747 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|2082235797|ref|XM_043058228.1| | 3055 | g128153 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 185 | 212 | 369 | 342 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g007550v5), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14461844 | 14461844 | PRJNA437204_P_NODE_6772_length_627_cov_2.377256_g6478_i0 | PRJNA437204 | 6772 | 627 | 2.377256 | 14.90539512 | Dunaliella salina | 3046 | Plants | Plants | 272 | 4.39e-68 | NTclustered | gi|333691276|gb|JF346104.1| | 3046 | g6478 | i0 | 82.188 | 19.7846889952153 | 320 | 53 | 51 | 4 | 27 | 344 | 527 | 844 | Dunaliella salina receptor of activated protein kinase C 1 mRNA, complete cds | blastn | 12405 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 14462031 | 14462031 | PRJNA437204_P_NODE_76912_length_254_cov_8.027624_g76613_i0 | PRJNA437204 | 76912 | 254 | 8.027624 | 20.39016496 | Monoraphidium neglectum | 145388 | Plants | Plants | 104 | 6.28e-18 | NTclustered | gi|926777351|ref|XM_014041696.1| | 145388 | g76613 | i0 | 77.128 | 0.740157480314961 | 188 | 37 | 73 | 5 | 63 | 247 | 185 | 1 | Monoraphidium neglectum 60S ribosomal protein L38 mRNA | blastn | 188 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 15734895 | 15734895 | PRJNA437204_P_NODE_24493_length_382_cov_2.355987_g24194_i0 | PRJNA437204 | 24493 | 382 | 2.355987 | 8.99987034 | Polytomella parva | 51329 | Plants | Plants | 449 | 1.11e-121 | NTclustered | gi|1861356407|gb|MT377431.1| | 51329 | g24194 | i0 | 87.728 | 97.8324607329843 | 383 | 45 | 100 | 2 | 1 | 382 | 410 | 29 | Polytomella parva clone 0016300141 tubulin alpha chain (TBA) mRNA, complete cds; plastid | blastn | 37372 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 18284186 | 18284186 | PRJNA437204_P_NODE_40855_length_322_cov_1.236948_g40556_i0 | PRJNA437204 | 40855 | 322 | 1.236948 | 3.98297256 | Monoraphidium neglectum | 145388 | Plants | Plants | 67.6 | 1.08e-6 | NTclustered | gi|926791998|ref|XM_014049019.1| | 145388 | g40556 | i0 | 91.667 | 4.81987577639752 | 48 | 4 | 15 | 0 | 9 | 56 | 1471 | 1424 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 1552 | 67.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 18941248 | 18941248 | PRJNA437204_P_NODE_43535_length_315_cov_1.867769_g43236_i0 | PRJNA437204 | 43535 | 315 | 1.867769 | 5.88347235 | Eukaryota | 2759 | Plants | Plants | 60.2 | 1.76e-4 | NTclustered | gi|2082236599|ref|XM_043058554.1| | 3055 | g43236 | i0 | 97.143 | 12.7714285714286 | 35 | 1 | 11 | 0 | 157 | 191 | 361 | 327 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g025950v5), mRNA | blastn | 4023 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19559311 | 19559311 | PRJNA437204_P_NODE_83496_length_250_cov_2.581921_g83197_i0 | PRJNA437204 | 83496 | 250 | 2.581921 | 6.4548025000000004 | Chlorella variabilis | 554065 | Plants | Plants | 211 | 3.53e-50 | NTclustered | gi|552811974|ref|XM_005843541.1| | 554065 | g83197 | i0 | 83.478 | 9.988 | 230 | 34 | 91 | 4 | 9 | 236 | 797 | 1024 | Chlorella variabilis casein protein kinase 2 alpha subunit (CHLNCDRAFT_37369) mRNA, complete cds | blastn | 2497 | 211 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 20833836 | 20833836 | PRJNA437204_P_NODE_19597_length_414_cov_7.686217_g19298_i0 | PRJNA437204 | 19597 | 414 | 7.686217 | 31.82093838 | Monoraphidium neglectum | 145388 | Plants | Plants | 241 | 7.91e-59 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g19298 | i0 | 82.9 | 62.8719806763285 | 269 | 44 | 65 | 2 | 40 | 307 | 357 | 90 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 26029 | 241 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 22109478 | 22109478 | PRJNA437204_P_NODE_56158_length_288_cov_1.153488_g55859_i0 | PRJNA437204 | 56158 | 288 | 1.153488 | 3.32204544 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 143 | 1.54e-29 | NTclustered | gi|2082242458|ref|XM_001703248.2| | 3055 | g55859 | i0 | 78.667 | 2.68055555555556 | 225 | 40 | 77 | 6 | 68 | 288 | 1374 | 1154 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g172950v5), mRNA | blastn | 772 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22110031 | 22110031 | PRJNA437204_P_NODE_84978_length_250_cov_0.870056_g84679_i0 | PRJNA437204 | 84978 | 250 | 0.870056 | 2.17514 | Choricystis parasitica | 41300 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|723446927|ref|NC_025539.1| | 41300 | g84679 | i0 | 94.595 | 0.148 | 37 | 0 | 15 | 1 | 11 | 47 | 68351 | 68317 | Choricystis parasitica culture-collection SAG:17.98 chloroplast, complete genome | blastn | 37 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Choricystis | Choricystis parasitica |
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);;