contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1001940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 147092 | 147092 | PRJNA1001940_S_NODE_203581_length_152_cov_3.522936_g202527_i0 | PRJNA1001940 | 203581 | 152 | 3.522936 | 5.35486272 | Ankistrodesmus stipitatus | 3109 | Plants | Plants | 110 | 7.27e-20 | NTclustered | gi|2320865241|gb|OM683276.1| | 3109 | g202527 | i0 | 89.535 | 2.22368421052632 | 86 | 9 | 57 | 0 | 1 | 86 | 92 | 7 | Ankistrodesmus stipitatus voucher CCMA-UFSCar 277 translation elongation factor Tu gene, partial cds; chloroplast | blastn | 338 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Ankistrodesmus | Ankistrodesmus stipitatus | |
| 1421527 | 1421527 | PRJNA1001940_S_NODE_184682_length_159_cov_3.387931_g183628_i0 | PRJNA1001940 | 184682 | 159 | 3.387931 | 5.38681029 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 78.7 | 2.17e-10 | NTclustered | gi|545367990|ref|XM_005648729.1| | 574566 | g183628 | i0 | 87.879 | 6.94339622641509 | 66 | 8 | 42 | 0 | 1 | 66 | 611 | 676 | Coccomyxa subellipsoidea C-169 40S ribosomal protein S8 partial mRNA | blastn | 1104 | 78.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 5250260 | 5250260 | PRJNA1001940_S_NODE_32585_length_366_cov_7.343653_g31534_i0 | PRJNA1001940 | 32585 | 366 | 7.343653 | 26.87776998 | [Myrmecia] bisecta | 41462 | Plants | Plants | 237 | 8.940000000000001e-58 | NTclustered | gi|255506491|gb|GQ168957.1| | 41462 | g31534 | i0 | 95.333 | 77.6393442622951 | 150 | 5 | 84 | 2 | 217 | 366 | 262 | 115 | Myrmecia bisecta strain SAG 2043 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 28416 | 237 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 15027351 | 15027351 | PRJNA1001940_S_NODE_196232_length_154_cov_4.801802_g195178_i0 | PRJNA1001940 | 196232 | 154 | 4.801802 | 7.39477508 | Coccomyxa | 41891 | Plants | Plants | 248 | 1.5e-61 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g195178 | i0 | 96.053 | 96.0584415584416 | 152 | 6 | 99 | 0 | 3 | 154 | 1316 | 1467 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 14793 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 15027442 | 15027442 | PRJNA1001940_S_NODE_58112_length_284_cov_5.161826_g57058_i0 | PRJNA1001940 | 58112 | 284 | 5.161826 | 14.65958584 | Eukaryota | 2759 | Plants | Plants | 520 | 5.98e-143 | NTclustered | gi|359385177|emb|FR865588.1| | 51685 | g57058 | i0 | 99.648 | 99.7816901408451 | 284 | 1 | 100 | 0 | 1 | 284 | 604 | 887 | Chlamydomonas bipapillata genomic DNA containing 18S rRNA gene, ITS1, culture collection CCAP 11/47 | blastn | 28338 | 520 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chloromonas | Chloromonas asteroidea | |
| 15449126 | 15449126 | PRJNA1001940_S_NODE_157113_length_173_cov_1.846154_g156059_i0 | PRJNA1001940 | 157113 | 173 | 1.846154 | 3.19384642 | Coccomyxa viridis | 1274662 | Plants | Plants | 106 | 1.1e-18 | NTclustered | gi|2663407678|emb|OZ004252.1| | 1274662 | g156059 | i0 | 88.764 | 3.59537572254335 | 89 | 7 | 51 | 3 | 1 | 88 | 42714 | 42628 | Coccomyxa viridis genome assembly, organelle: mitochondrion | blastn | 622 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 15450499 | 15450499 | PRJNA1001940_S_NODE_56973_length_287_cov_3.483607_g55919_i0 | PRJNA1001940 | 56973 | 287 | 3.483607 | 9.99795209 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 87.9 | 7.27e-13 | NTclustered | gi|2917929619|emb|OZ234907.1| | 3350044 | g55919 | i0 | 98 | 0.174216027874564 | 50 | 1 | 17 | 0 | 238 | 287 | 3558188 | 3558139 | Trebouxia sp. SL0000003 genome assembly, chromosome: 2 | blastn | 50 | 87.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 16302015 | 16302015 | PRJNA1001940_S_NODE_182673_length_160_cov_2.461538_g181619_i0 | PRJNA1001940 | 182673 | 160 | 2.461538 | 3.9384608 | Coccomyxa | 41891 | Plants | Plants | 263 | 5.629999999999999e-66 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g181619 | i0 | 96.25 | 78.68125 | 160 | 6 | 100 | 0 | 1 | 160 | 1301 | 1142 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 12589 | 263 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 19271478 | 19271478 | PRJNA1001940_S_NODE_125876_length_193_cov_2.880000_g124822_i0 | PRJNA1001940 | 125876 | 193 | 2.88 | 5.5584 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 209 | 9.33e-50 | NTclustered | gi|2917929619|emb|OZ234907.1| | 3350044 | g124822 | i0 | 91.946 | 0.772020725388601 | 149 | 12 | 77 | 0 | 45 | 193 | 150469 | 150617 | Trebouxia sp. SL0000003 genome assembly, chromosome: 2 | blastn | 149 | 209 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 21822346 | 21822346 | PRJNA1001940_S_NODE_103238_length_213_cov_2.329412_g102184_i0 | PRJNA1001940 | 103238 | 213 | 2.329412 | 4.96164756 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 165 | 2.31e-36 | NTclustered | gi|545365417|ref|XM_005647625.1| | 574566 | g102184 | i0 | 80.93 | 8 | 215 | 35 | 99 | 5 | 2 | 213 | 358 | 147 | Coccomyxa subellipsoidea C-169 ribosomal protein L5 mRNA | blastn | 1704 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 23098030 | 23098030 | PRJNA1001940_S_NODE_122659_length_196_cov_1.254902_g121605_i0 | PRJNA1001940 | 122659 | 196 | 1.254902 | 2.45960792 | uncultured Trebouxiophyceae | 167235 | Plants | Plants | 291 | 3.3e-74 | NTclustered | gi|1735341974|gb|MN419174.1| | 167235 | g121605 | i0 | 96.591 | 34.6479591836735 | 176 | 4 | 89 | 2 | 1 | 175 | 412 | 586 | Uncultured Trebouxiophyceae clone EukCL56 large subunit ribosomal RNA gene, partial sequence | blastn | 6791 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Trebouxiophyceae |
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);;