contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6069580 | 6069580 | PRJNA983848_P_NODE_105705_length_293_cov_2.018182_g99822_i0 | PRJNA983848 | 105705 | 293 | 2.018182 | 5.91327326 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 58.4 | 5.84e-4 | NTclustered | gi|545359120|ref|XM_005644997.1| | 574566 | g99822 | i0 | 97.059 | 0.453924914675768 | 34 | 1 | 12 | 0 | 167 | 200 | 1386 | 1353 | Coccomyxa subellipsoidea C-169 carbonic anhydrase partial mRNA | blastn | 133 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7649482 | 7649482 | PRJNA983848_P_NODE_102426_length_298_cov_14.088889_g96543_i0 | PRJNA983848 | 102426 | 298 | 14.088889 | 41.98488922 | Eukaryota | 2759 | Plants | Plants | 544 | 3.7499999999999997e-150 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g96543 | i0 | 99.663 | 99.6543624161074 | 297 | 1 | 99 | 0 | 1 | 297 | 587 | 883 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 29697 | 549 | 0.990892531876138 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 10200213 | 10200213 | PRJNA983848_P_NODE_61128_length_416_cov_1.755102_g55246_i0 | PRJNA983848 | 61128 | 416 | 1.755102 | 7.30122432 | Trebouxiophyceae | 75966 | Plants | Plants | 63.9 | 1.85e-5 | NTclustered | gi|371782132|emb|HE610164.1| | 33092 | g55246 | i0 | 95 | 15.6947115384615 | 40 | 2 | 10 | 0 | 363 | 402 | 37 | 76 | Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1 | blastn | 6529 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 12446501 | 12446501 | PRJNA983848_P_NODE_133870_length_257_cov_1.532609_g127987_i0 | PRJNA983848 | 133870 | 257 | 1.532609 | 3.93880513 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 263 | 9.92e-66 | NTclustered | gi|2082243702|ref|XM_043061450.1| | 3055 | g127987 | i0 | 86.809 | 47.3540856031128 | 235 | 31 | 91 | 0 | 23 | 257 | 976 | 742 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g204250v5), mRNA | blastn | 12170 | 263 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 12750775 | 12750775 | PRJNA983848_P_NODE_164270_length_231_cov_4.259494_g158387_i0 | PRJNA983848 | 164270 | 231 | 4.259494 | 9.83943114 | Prototheca | 3110 | Plants | Plants | 412 | 8.22e-111 | NTclustered | gi|1158987632|gb|KX353637.1| | 3112 | g158387 | i0 | 100 | 51.4372294372294 | 223 | 0 | 97 | 0 | 1 | 223 | 356 | 578 | Prototheca zopfii strain HSH93851 28S ribosomal RNA gene, partial sequence | blastn | 11882 | 412 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca zopfii | |
| 19122814 | 19122814 | PRJNA983848_P_NODE_105515_length_293_cov_3.363636_g99632_i0 | PRJNA983848 | 105515 | 293 | 3.363636 | 9.85545348 | Trebouxiophyceae | 75966 | Plants | Plants | 161 | 4.33e-35 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g99632 | i0 | 88.148 | 9.82252559726962 | 135 | 16 | 46 | 0 | 156 | 290 | 5552 | 5418 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 2878 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum |
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);;