contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145134 | 145134 | PRJNA1000943_P_NODE_13301_length_247_cov_0.896552_g13163_i0 | PRJNA1000943 | 13301 | 247 | 0.896552 | 2.21448344 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 198 | 2.71e-46 | NTclustered | gi|545372299|ref|XM_005650575.1| | 574566 | g13163 | i0 | 86.022 | 126.821862348178 | 186 | 24 | 75 | 2 | 63 | 247 | 235 | 51 | Coccomyxa subellipsoidea C-169 hexaubiquitin protein partial mRNA | blastn | 31325 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 2274394 | 2274394 | PRJNA1000943_P_NODE_7102_length_307_cov_1.333333_g6964_i0 | PRJNA1000943 | 7102 | 307 | 1.333333 | 4.09333231 | Eukaryota | 2759 | Plants | Plants | 285 | 2.5899999999999997e-72 | NTclustered | gi|119416491|emb|AJ870436.1| | 37502 | g6964 | i0 | 83.548 | 99.6026058631922 | 310 | 45 | 100 | 4 | 1 | 307 | 386 | 692 | Polytomella sp. Pringsheim 198.80 mRNA for ATP synthase beta chain, mitochondrial precursor (atp2 gene) | blastn | 30578 | 285 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 3971443 | 3971443 | PRJNA1000943_P_NODE_2764_length_462_cov_1.403599_g2627_i0 | PRJNA1000943 | 2764 | 462 | 1.403599 | 6.48462738 | Monoraphidium neglectum | 145388 | Plants | Plants | 278 | 6.8e-70 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g2627 | i0 | 83.333 | 59.6623376623377 | 300 | 50 | 65 | 0 | 83 | 382 | 61 | 360 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 27564 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 6523510 | 6523510 | PRJNA1000943_P_NODE_5626_length_338_cov_1.758491_g5488_i0 | PRJNA1000943 | 5626 | 338 | 1.758491 | 5.94369958 | Chlamydomonas incerta | 51695 | Plants | Plants | 296 | 1.34e-75 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g5488 | i0 | 84.437 | 87.9940828402367 | 302 | 45 | 89 | 2 | 38 | 338 | 34 | 334 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 29742 | 296 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 8652386 | 8652386 | PRJNA1000943_P_NODE_4267_length_381_cov_1.266234_g4130_i0 | PRJNA1000943 | 4267 | 381 | 1.266234 | 4.82435154 | Eukaryota | 2759 | Plants | Plants | 346 | 1.49e-90 | NTclustered | gi|926791444|ref|XM_014048742.1| | 145388 | g4130 | i0 | 83.827 | 101.548556430446 | 371 | 53 | 97 | 6 | 13 | 381 | 2993 | 2628 | Monoraphidium neglectum adenosylhomocysteinase mRNA | blastn | 38690 | 346 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 9927236 | 9927236 | PRJNA1000943_P_NODE_1748_length_574_cov_13.922156_g1612_i0 | PRJNA1000943 | 1748 | 574 | 13.922156 | 79.91317544 | Chlamydomonadales | 3042 | Plants | Plants | 148 | 7.019999999999999e-31 | NTclustered | gi|15281670|gb|AF395510.1| | 77548 | g1612 | i0 | 76.923 | 34.787456445993 | 273 | 56 | 47 | 7 | 1 | 272 | 1191 | 1457 | Pteromonas angulosa strain SAG 64-3 voucher SAG:64-3 26S ribosomal RNA gene, partial sequence | blastn | 19968 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Phacotaceae | Pteromonas | Pteromonas angulosa | |
| 10348213 | 10348213 | PRJNA1000943_P_NODE_12849_length_248_cov_1.337143_g12711_i0 | PRJNA1000943 | 12849 | 248 | 1.337143 | 3.31611464 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 189 | 1.6399999999999996e-43 | NTclustered | gi|545365041|ref|XM_005647468.1| | 574566 | g12711 | i0 | 83.333 | 74.008064516129 | 204 | 34 | 82 | 0 | 25 | 228 | 347 | 144 | Coccomyxa subellipsoidea C-169 ribosomal protein L10e partial mRNA | blastn | 18354 | 189 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 11623681 | 11623681 | PRJNA1000943_P_NODE_13110_length_248_cov_0.891429_g12972_i0 | PRJNA1000943 | 13110 | 248 | 0.891429 | 2.21074392 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 244 | 3.45e-60 | NTclustered | gi|2082259086|ref|XM_001697336.2| | 3055 | g12972 | i0 | 84.615 | 56.8387096774194 | 247 | 36 | 99 | 2 | 1 | 246 | 436 | 191 | Chlamydomonas reinhardtii ribosomal protein S14 (CHLRE_11g480150v5), mRNA | blastn | 14096 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17996815 | 17996815 | PRJNA1000943_P_NODE_14375_length_244_cov_2.076023_g14237_i0 | PRJNA1000943 | 14375 | 244 | 2.076023 | 5.06549612 | Monoraphidium neglectum | 145388 | Plants | Plants | 148 | 2.7299999999999997e-31 | NTclustered | gi|926774123|ref|XM_014040082.1| | 145388 | g14237 | i0 | 81.768 | 15.077868852459 | 181 | 29 | 73 | 4 | 29 | 207 | 389 | 211 | Monoraphidium neglectum 40S ribosomal protein S13-2 mRNA | blastn | 3679 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 17996900 | 17996900 | PRJNA1000943_P_NODE_7915_length_293_cov_1.572727_g7777_i0 | PRJNA1000943 | 7915 | 293 | 1.572727 | 4.60809011 | Pseudendoclonium arthopyreniae | 926286 | Plants | Plants | 305 | 1.89e-78 | NTclustered | gi|312165803|gb|HM068616.1| | 926286 | g7777 | i0 | 98.83 | 100.058020477816 | 171 | 2 | 58 | 0 | 32 | 202 | 171 | 1 | Pseudendoclonium arthopyreniae strain SAG 467-2 23S ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 29317 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Kornmanniaceae | Pseudendoclonium | Pseudendoclonium arthopyreniae | |
| 19270673 | 19270673 | PRJNA1000943_P_NODE_14036_length_245_cov_0.906977_g13898_i0 | PRJNA1000943 | 14036 | 245 | 0.906977 | 2.22209365 | Chlorella variabilis | 554065 | Plants | Plants | 237 | 5.69e-58 | NTclustered | gi|552834449|ref|XM_005848670.1| | 554065 | g13898 | i0 | 85.526 | 60.469387755102 | 228 | 31 | 93 | 2 | 3 | 229 | 740 | 514 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_57527) mRNA, complete cds | blastn | 14815 | 237 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 19270711 | 19270711 | PRJNA1000943_P_NODE_3176_length_434_cov_3.554017_g3039_i0 | PRJNA1000943 | 3176 | 434 | 3.554017 | 15.42443378 | Acrosiphonia sp. SAG 127.80 | 2601987 | Plants | Plants | 477 | 5.8299999999999985e-130 | NTclustered | gi|290770762|emb|FN563074.1| | 2601987 | g3039 | i0 | 86.775 | 119.960829493088 | 431 | 53 | 99 | 4 | 1 | 430 | 3149 | 3576 | Acrosiphonia sp. SAG-127.80 plastid 16S rRNA gene (partial), ITS1 and 23S rRNA gene (partial), strain SAG 127.80 | blastn | 52063 | 477 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Acrosiphonia | Acrosiphonia sp. SAG 127.80 | |
| 20546302 | 20546302 | PRJNA1000943_P_NODE_2757_length_462_cov_2.354756_g2620_i0 | PRJNA1000943 | 2757 | 462 | 2.354756 | 10.87897272 | Chlorella variabilis | 554065 | Plants | Plants | 228 | 6.939999999999998e-55 | NTclustered | gi|552840730|ref|XM_005850063.1| | 554065 | g2620 | i0 | 79.154 | 19.4588744588745 | 331 | 67 | 71 | 2 | 131 | 460 | 468 | 139 | Chlorella variabilis 40S ribosomal protein S18 (CHLNCDRAFT_34417) mRNA, complete cds | blastn | 8990 | 228 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 21821934 | 21821934 | PRJNA1000943_P_NODE_12038_length_250_cov_2.350282_g11900_i0 | PRJNA1000943 | 12038 | 250 | 2.350282 | 5.875705 | Hazenia capsulata | 2202518 | Plants | Plants | 316 | 7.269999999999998e-82 | NTclustered | gi|17028245|gb|L42837.1|CMKCPRGOL | 2202518 | g11900 | i0 | 89.641 | 123.272 | 251 | 23 | 100 | 3 | 1 | 250 | 592 | 840 | Hazenia capsulata large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 30818 | 316 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Hazeniaceae | Hazenia | Hazenia capsulata | |
| 22676095 | 22676095 | PRJNA1000943_P_NODE_12058_length_250_cov_1.762712_g11920_i0 | PRJNA1000943 | 12058 | 250 | 1.762712 | 4.40678 | Eukaryota | 2759 | Plants | Plants | 165 | 2.79e-36 | NTclustered | gi|1861355669|gb|MT377085.1| | 51329 | g11920 | i0 | 86.184 | 64.376 | 152 | 21 | 61 | 0 | 5 | 156 | 1835 | 1684 | Polytomella parva clone 0016338189 heat shock protein 90c (HS90) mRNA, complete cds; plastid | blastn | 16094 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 24371072 | 24371072 | PRJNA1000943_P_NODE_6780_length_312_cov_3.259414_g6642_i0 | PRJNA1000943 | 6780 | 312 | 3.259414 | 10.16937168 | Pseudendoclonium arthopyreniae | 926286 | Plants | Plants | 492 | 1.45e-134 | NTclustered | gi|312165803|gb|HM068616.1| | 926286 | g6642 | i0 | 95.192 | 7.94871794871795 | 312 | 13 | 99 | 2 | 2 | 312 | 502 | 192 | Pseudendoclonium arthopyreniae strain SAG 467-2 23S ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 2480 | 492 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Kornmanniaceae | Pseudendoclonium | Pseudendoclonium arthopyreniae | |
| 24371079 | 24371079 | PRJNA1000943_P_NODE_7340_length_303_cov_1.356522_g7202_i0 | PRJNA1000943 | 7340 | 303 | 1.356522 | 4.11026166 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 248 | 3.3499999999999995e-61 | NTclustered | gi|2082261495|ref|XM_001692933.2| | 3055 | g7202 | i0 | 85.477 | 57.9009900990099 | 241 | 31 | 79 | 4 | 38 | 276 | 691 | 929 | Chlamydomonas reinhardtii ribosomal protein L8 (CHLRE_12g535851v5), mRNA | blastn | 17544 | 248 | 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);;