contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 808800 | 808800 | PRJNA811237_S_NODE_3681_length_377_cov_5.064024_g3441_i0 | PRJNA811237 | 3681 | 377 | 5.064024 | 19.09137048 | Micromonas commoda | 296587 | Plants | Plants | 344 | 5.29e-90 | NTclustered | gi|255078509|ref|XM_002502789.1| | 296587 | g3441 | i0 | 83.158 | 82.2122015915119 | 380 | 61 | 100 | 3 | 1 | 377 | 778 | 399 | Micromonas commoda predicted protein mRNA | blastn | 30994 | 344 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 3359718 | 3359718 | PRJNA811237_S_NODE_23183_length_179_cov_1.115385_g22943_i0 | PRJNA811237 | 23183 | 179 | 1.115385 | 1.99653915 | Ostreococcus tauri | 70448 | Plants | Plants | 132 | 1.89e-26 | NTclustered | gi|308802362|ref|XM_003078447.1| | 70448 | g22943 | i0 | 86.066 | 8.36312849162011 | 122 | 17 | 68 | 0 | 51 | 172 | 560 | 439 | Ostreococcus tauri Succinyl-CoA synthetase-like (OT_ostta03g05920), partial mRNA | blastn | 1497 | 132 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 3359763 | 3359763 | PRJNA811237_S_NODE_4563_length_338_cov_2.982699_g4323_i0 | PRJNA811237 | 4563 | 338 | 2.982699 | 10.08152262 | Volvox carteri | 3067 | Plants | Plants | 134 | 1.11e-26 | NTclustered | gi|302853854|ref|XM_002958394.1| | 3068 | g4323 | i0 | 82.781 | 37.2958579881657 | 151 | 24 | 44 | 2 | 12 | 161 | 243 | 392 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_77934), mRNA | blastn | 12606 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 6327586 | 6327586 | PRJNA811237_S_NODE_5525_length_310_cov_4.065134_g5285_i0 | PRJNA811237 | 5525 | 310 | 4.065134 | 12.6019154 | Eukaryota | 2759 | Plants | Plants | 134 | 1.01e-26 | NTclustered | gi|926782661|ref|XM_014044351.1| | 145388 | g5285 | i0 | 77.311 | 6.85161290322581 | 238 | 46 | 75 | 8 | 1 | 234 | 294 | 61 | Monoraphidium neglectum 40S ribosomal protein S15 mRNA | blastn | 2124 | 134 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 7601673 | 7601673 | PRJNA811237_S_NODE_23246_length_178_cov_3.790698_g23006_i0 | PRJNA811237 | 23246 | 178 | 3.790698 | 6.74744244 | Eukaryota | 2759 | Plants | Plants | 80.5 | 6.91e-11 | NTclustered | gi|66864277|gb|DQ015732.1| | 57475 | g23006 | i0 | 94.34 | 32.5561797752809 | 53 | 1 | 29 | 2 | 1 | 52 | 588 | 537 | Chlamydomonas pulsatilla strain UTEX 410 26S ribosomal RNA gene, partial sequence | blastn | 5795 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas pulsatilla | |
| 9736847 | 9736847 | PRJNA811237_S_NODE_1968_length_512_cov_7.788337_g1729_i0 | PRJNA811237 | 1968 | 512 | 7.788337 | 39.87628544 | Chlorella variabilis | 554065 | Plants | Plants | 300 | 1.62e-76 | NTclustered | gi|552840730|ref|XM_005850063.1| | 554065 | g1729 | i0 | 79.398 | 49.998046875 | 432 | 83 | 84 | 5 | 42 | 470 | 489 | 61 | Chlorella variabilis 40S ribosomal protein S18 (CHLNCDRAFT_34417) mRNA, complete cds | blastn | 25599 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 9736858 | 9736858 | PRJNA811237_S_NODE_22148_length_182_cov_1.195489_g21908_i0 | PRJNA811237 | 22148 | 182 | 1.195489 | 2.17578998 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 130 | 6.95e-26 | NTclustered | gi|2082247499|ref|XM_043062974.1| | 3055 | g21908 | i0 | 79.775 | 21.7252747252747 | 178 | 36 | 98 | 0 | 3 | 180 | 1170 | 1347 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g273300v5), mRNA | blastn | 3954 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9736896 | 9736896 | PRJNA811237_S_NODE_32008_length_164_cov_0.869565_g31768_i0 | PRJNA811237 | 32008 | 164 | 0.869565 | 1.4260866 | Mantoniella tinhauana | 3097027 | Plants | Plants | 65.8 | 1.76e-6 | NTclustered | gi|2735153292|gb|CP140077.1| | 3097027 | g31768 | i0 | 97.368 | 0.975609756097561 | 38 | 1 | 23 | 0 | 5 | 42 | 318524 | 318561 | Mantoniella tinhauana isolate LFS chromosome 16 | blastn | 160 | 65.8 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 12288166 | 12288166 | PRJNA811237_S_NODE_5690_length_307_cov_1.410853_g5450_i0 | PRJNA811237 | 5690 | 307 | 1.410853 | 4.33131871 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 176 | 1.63e-39 | NTclustered | gi|2082236323|ref|XM_001689445.2| | 3055 | g5450 | i0 | 78.092 | 24.4234527687296 | 283 | 58 | 92 | 4 | 27 | 307 | 512 | 232 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g019250v5), mRNA | blastn | 7498 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 14836985 | 14836985 | PRJNA811237_S_NODE_19372_length_192_cov_0.874126_g19132_i0 | PRJNA811237 | 19372 | 192 | 0.874126 | 1.67832192 | Micromonas commoda | 296587 | Plants | Plants | 71.3 | 4.56e-8 | NTclustered | gi|255072042|ref|XM_002499650.1| | 296587 | g19132 | i0 | 95.455 | 0.229166666666667 | 44 | 2 | 23 | 0 | 70 | 113 | 2412 | 2369 | Micromonas commoda kinesin motor domain partial mRNA | blastn | 44 | 71.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 16526371 | 16526371 | PRJNA811237_S_NODE_23293_length_178_cov_2.170543_g23053_i0 | PRJNA811237 | 23293 | 178 | 2.170543 | 3.86356654 | Eukaryota | 2759 | Plants | Plants | 152 | 1.4399999999999999e-32 | NTclustered | gi|1569651898|gb|MH328236.1| | 1191503 | g23053 | i0 | 82.659 | 29.9494382022472 | 173 | 28 | 97 | 2 | 5 | 176 | 233 | 62 | Ettlia sp. YC001 heat shock protein hsp90A (Hsp90A) mRNA, complete cds | blastn | 5331 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Ettlia | Ettlia sp. YC001 | ||
| 18660270 | 18660270 | PRJNA811237_S_NODE_5095_length_322_cov_1.333333_g4855_i0 | PRJNA811237 | 5095 | 322 | 1.333333 | 4.29333226 | Mantoniella tinhauana | 3097027 | Plants | Plants | 169 | 2.8799999999999996e-37 | NTclustered | gi|2735153286|gb|CP140071.1| | 3097027 | g4855 | i0 | 81.731 | 21.4254658385093 | 208 | 32 | 64 | 6 | 118 | 322 | 1405227 | 1405431 | Mantoniella tinhauana isolate LFS chromosome 10 | blastn | 6899 | 169 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 19935481 | 19935481 | PRJNA811237_S_NODE_4736_length_332_cov_2.035336_g4496_i0 | PRJNA811237 | 4736 | 332 | 2.035336 | 6.75731552 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 193 | 1.77e-44 | NTclustered | gi|2082238142|ref|XM_043059158.1| | 3055 | g4496 | i0 | 81.513 | 5.60843373493976 | 238 | 40 | 71 | 4 | 2 | 237 | 1231 | 1466 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g076350v5), mRNA | blastn | 1862 | 193 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19935492 | 19935492 | PRJNA811237_S_NODE_5976_length_301_cov_1.103175_g5736_i0 | PRJNA811237 | 5976 | 301 | 1.103175 | 3.32055675 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 167 | 9.59e-37 | NTclustered | gi|760447584|ref|XM_011402559.1| | 3075 | g5736 | i0 | 79.012 | 1.49169435215947 | 243 | 51 | 81 | 0 | 40 | 282 | 768 | 1010 | Auxenochlorella protothecoides Phosphate carrier protein, mitochondrial partial mRNA | blastn | 449 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 19935507 | 19935507 | PRJNA811237_S_NODE_9756_length_245_cov_2.530612_g9516_i0 | PRJNA811237 | 9756 | 245 | 2.530612 | 6.1999994 | Chlorella variabilis | 554065 | Plants | Plants | 222 | 1.59e-53 | NTclustered | gi|552830805|ref|XM_005847928.1| | 554065 | g9516 | i0 | 83.607 | 5.91020408163265 | 244 | 33 | 98 | 5 | 7 | 245 | 643 | 402 | Chlorella variabilis hypothetical protein (RACK1) mRNA, complete cds | blastn | 1448 | 222 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 21210958 | 21210958 | PRJNA811237_S_NODE_14237_length_213_cov_5.658537_g13997_i0 | PRJNA811237 | 14237 | 213 | 5.658537 | 12.05268381 | Micromonas commoda | 296587 | Plants | Plants | 183 | 6.369999999999998e-42 | NTclustered | gi|255072468|ref|XM_002499863.1| | 296587 | g13997 | i0 | 87.117 | 26.1408450704225 | 163 | 19 | 76 | 2 | 43 | 204 | 190 | 29 | Micromonas commoda predicted protein mRNA | blastn | 5568 | 183 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 21210986 | 21210986 | PRJNA811237_S_NODE_21077_length_185_cov_5.860294_g20837_i0 | PRJNA811237 | 21077 | 185 | 5.860294 | 10.8415439 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 189 | 1.15e-43 | NTclustered | gi|2082258180|ref|XM_043067316.1| | 3055 | g20837 | i0 | 91.852 | 123.027027027027 | 135 | 11 | 73 | 0 | 47 | 181 | 1868 | 1734 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_11g467567v5), mRNA | blastn | 22760 | 189 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21625626 | 21625626 | PRJNA811237_S_NODE_31597_length_164_cov_0.886957_g31357_i0 | PRJNA811237 | 31597 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | Plants | Plants | 56.5 | 0.001 | NTclustered | gi|926780023|ref|XM_014043032.1| | 145388 | g31357 | i0 | 100 | 2.31707317073171 | 30 | 0 | 18 | 0 | 131 | 160 | 635 | 606 | Monoraphidium neglectum hypothetical protein mRNA | blastn | 380 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 23761364 | 23761364 | PRJNA811237_S_NODE_25319_length_172_cov_2.902439_g25079_i0 | PRJNA811237 | 25319 | 172 | 2.902439 | 4.99219508 | Monoraphidium neglectum | 145388 | Plants | Plants | 97.1 | 6.57e-16 | NTclustered | gi|926782011|ref|XM_014044026.1| | 145388 | g25079 | i0 | 95.082 | 18.4476744186047 | 61 | 3 | 35 | 0 | 112 | 172 | 716 | 656 | Monoraphidium neglectum 14-3-3-like protein mRNA | blastn | 3173 | 97.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 23761423 | 23761423 | PRJNA811237_S_NODE_8819_length_255_cov_2.422330_g8579_i0 | PRJNA811237 | 8819 | 255 | 2.42233 | 6.1769415 | Monoraphidium neglectum | 145388 | Plants | Plants | 124 | 4.839999999999999e-24 | NTclustered | gi|926777351|ref|XM_014041696.1| | 145388 | g8579 | i0 | 77.725 | 13.1607843137255 | 211 | 41 | 82 | 6 | 7 | 214 | 1 | 208 | Monoraphidium neglectum 60S ribosomal protein L38 mRNA | blastn | 3356 | 124 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 25035237 | 25035237 | PRJNA811237_S_NODE_19980_length_189_cov_1.678571_g19740_i0 | PRJNA811237 | 19980 | 189 | 1.678571 | 3.17249919 | Micromonas pusilla | 38833 | Plants | Plants | 87.9 | 4.45e-13 | NTclustered | gi|303273383|ref|XM_003056007.1| | 564608 | g19740 | i0 | 83.158 | 0.502645502645503 | 95 | 16 | 50 | 0 | 93 | 187 | 416 | 322 | Micromonas pusilla CCMP1545 component of splicing factor SF3B (MICPUCDRAFT_49441), mRNA | blastn | 95 | 87.9 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 25450203 | 25450203 | PRJNA811237_S_NODE_15140_length_209_cov_1.293750_g14900_i0 | PRJNA811237 | 15140 | 209 | 1.29375 | 2.7039375 | Eukaryota | 2759 | Plants | Plants | 219 | 1.71e-52 | NTclustered | gi|760450068|ref|XM_011403801.1| | 3075 | g14900 | i0 | 86.139 | 52.822966507177 | 202 | 28 | 97 | 0 | 8 | 209 | 58 | 259 | Auxenochlorella protothecoides Peptidyl-prolyl cis-trans isomerase CYP18-4 partial mRNA | blastn | 11040 | 219 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;