contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162733 | 162733 | PRJNA1025141_P_NODE_1501_length_676_cov_1.643449_g1442_i0 | PRJNA1025141 | 1501 | 676 | 1.643449 | 11.10971524 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 87.9 | 1.85e-12 | NTclustered | gi|2082265001|ref|XM_001689780.2| | 3055 | g1442 | i0 | 78.169 | 0.210059171597633 | 142 | 27 | 21 | 4 | 84 | 223 | 545 | 684 | Chlamydomonas reinhardtii ribosomal protein L35 (CHLRE_14g617900v5), mRNA | blastn | 142 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6540939 | 6540939 | PRJNA1025141_P_NODE_2366_length_531_cov_1.674672_g2305_i0 | PRJNA1025141 | 2366 | 531 | 1.674672 | 8.89250832 | Chlorella variabilis | 554065 | Plants | Plants | 316 | 1.6699999999999996e-81 | NTclustered | gi|552830805|ref|XM_005847928.1| | 554065 | g2305 | i0 | 77.593 | 58.1826741996233 | 540 | 109 | 100 | 6 | 1 | 531 | 917 | 381 | Chlorella variabilis hypothetical protein (RACK1) mRNA, complete cds | blastn | 30895 | 316 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 7815411 | 7815411 | PRJNA1025141_P_NODE_6647_length_310_cov_1.092827_g6586_i0 | PRJNA1025141 | 6647 | 310 | 1.092827 | 3.3877637 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 272 | 2.04e-68 | NTclustered | gi|760443472|ref|XM_011400503.1| | 3075 | g6586 | i0 | 86.345 | 65.9193548387097 | 249 | 34 | 80 | 0 | 16 | 264 | 3112 | 3360 | Auxenochlorella protothecoides Pyrophosphate-energized vacuolar membrane proton pump 1 partial mRNA | blastn | 20435 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 7815460 | 7815460 | PRJNA1025141_P_NODE_9727_length_250_cov_1.096045_g9666_i0 | PRJNA1025141 | 9727 | 250 | 1.096045 | 2.7401125 | Monoraphidium neglectum | 145388 | Plants | Plants | 196 | 9.88e-46 | NTclustered | gi|926791444|ref|XM_014048742.1| | 145388 | g9666 | i0 | 82.819 | 63.4 | 227 | 32 | 90 | 7 | 26 | 250 | 2027 | 1806 | Monoraphidium neglectum adenosylhomocysteinase mRNA | blastn | 15850 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 9090388 | 9090388 | PRJNA1025141_P_NODE_4168_length_398_cov_1.446154_g4107_i0 | PRJNA1025141 | 4168 | 398 | 1.446154 | 5.75569292 | Monoraphidium neglectum | 145388 | Plants | Plants | 117 | 1.33e-21 | NTclustered | gi|926772141|ref|XM_014039091.1| | 145388 | g4107 | i0 | 81.046 | 0.773869346733668 | 153 | 23 | 38 | 4 | 241 | 393 | 174 | 28 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 308 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 12483025 | 12483025 | PRJNA1025141_P_NODE_6530_length_313_cov_0.962500_g6469_i0 | PRJNA1025141 | 6530 | 313 | 0.9625 | 3.012625 | Eukaryota | 2759 | Plants | Plants | 241 | 5.82e-59 | NTclustered | gi|2082247947|ref|XM_001698013.2| | 3055 | g6469 | i0 | 81.481 | 80.444089456869 | 297 | 52 | 94 | 1 | 20 | 313 | 190 | 486 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g278222v5), mRNA | blastn | 25179 | 243 | 0.991769547325103 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17581945 | 17581945 | PRJNA1025141_P_NODE_2574_length_511_cov_1.655251_g2513_i0 | PRJNA1025141 | 2574 | 511 | 1.655251 | 8.45833261 | Eukaryota | 2759 | Plants | Plants | 259 | 2.7500000000000003e-64 | NTclustered | gi|2082260551|ref|XM_001702928.2| | 3055 | g2513 | i0 | 81.231 | 58.0665362035225 | 325 | 58 | 63 | 3 | 108 | 431 | 138 | 460 | Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA | blastn | 29672 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19288587 | 19288587 | PRJNA1025141_P_NODE_916_length_857_cov_1.678571_g868_i0 | PRJNA1025141 | 916 | 857 | 1.678571 | 14.38535347 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 353 | 2.11e-92 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g868 | i0 | 77.99 | 53.7537922987165 | 577 | 117 | 67 | 10 | 227 | 798 | 856 | 285 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 46067 | 353 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20563875 | 20563875 | PRJNA1025141_P_NODE_10137_length_249_cov_0.875000_g10076_i0 | PRJNA1025141 | 10137 | 249 | 0.875 | 2.17875 | Chlorella variabilis | 554065 | Plants | Plants | 148 | 2.7899999999999996e-31 | NTclustered | gi|552841639|ref|XM_005850301.1| | 554065 | g10076 | i0 | 79.343 | 2.29718875502008 | 213 | 42 | 85 | 2 | 15 | 226 | 274 | 485 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_59600) mRNA, complete cds | blastn | 572 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 20563932 | 20563932 | PRJNA1025141_P_NODE_2537_length_514_cov_2.664399_g2476_i0 | PRJNA1025141 | 2537 | 514 | 2.664399 | 13.69501086 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 217 | 1.69e-51 | NTclustered | gi|2082267188|ref|XM_043070972.1| | 3055 | g2476 | i0 | 79.87 | 8.76264591439689 | 308 | 53 | 59 | 8 | 136 | 440 | 432 | 131 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_16g660150v5), mRNA | blastn | 4504 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21839696 | 21839696 | PRJNA1025141_P_NODE_4638_length_377_cov_1.013158_g4577_i0 | PRJNA1025141 | 4638 | 377 | 1.013158 | 3.81960566 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 217 | 1.2e-51 | NTclustered | gi|2082262545|ref|XM_043068796.1| | 3055 | g4577 | i0 | 82.917 | 3.18567639257294 | 240 | 41 | 64 | 0 | 12 | 251 | 1929 | 2168 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g542800v5), mRNA | blastn | 1201 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24388832 | 24388832 | PRJNA1025141_P_NODE_1840_length_610_cov_1.581006_g1780_i0 | PRJNA1025141 | 1840 | 610 | 1.581006 | 9.6441366 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 342 | 3.2e-89 | NTclustered | gi|2082238813|ref|XM_001701728.2| | 3055 | g1780 | i0 | 78.439 | 83.6770491803279 | 538 | 106 | 87 | 9 | 78 | 610 | 767 | 235 | Chlamydomonas reinhardtii ribosomal protein L15 (CHLRE_02g091100v5), mRNA | blastn | 51043 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24388850 | 24388850 | PRJNA1025141_P_NODE_2880_length_482_cov_2.176039_g2819_i0 | PRJNA1025141 | 2880 | 482 | 2.176039 | 10.48850798 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 219 | 4.38e-52 | NTclustered | gi|2082240135|ref|XM_001699602.2| | 3055 | g2819 | i0 | 77.984 | 36.7157676348548 | 377 | 64 | 77 | 15 | 26 | 394 | 80 | 445 | Chlamydomonas reinhardtii ribosomal protein L27a (CHLRE_02g115200v5), mRNA | blastn | 17697 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;