contig_metadata
13 rows where bioproject = "PRJNA983848", tax_kingdom = "Viridiplantae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 23919529 | 23919529 | PRJNA983848_P_NODE_122619_length_270_cov_1.583756_g116736_i0 | PRJNA983848 | 122619 | 270 | 1.583756 | 4.2761412 | Nephroselmis astigmatica | 259378 | Plants | Plants | 97.1 | 1.13e-15 | NTclustered | gi|371782113|emb|HE610145.1| | 259378 | g116736 | i0 | 85.87 | 6.22962962962963 | 92 | 11 | 34 | 2 | 180 | 270 | 3846 | 3756 | Nephroselmis astigmatica 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain NIES N-252 | blastn | 1682 | 97.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Nephroselmidophyceae | Nephroselmidales | Nephroselmidaceae | Nephroselmis | Nephroselmis astigmatica | ||
| 28131966 | 28131966 | PRJNA983848_P_NODE_155785_length_244_cov_0.912281_g149902_i0 | PRJNA983848 | 155785 | 244 | 0.912281 | 2.22596564 | Trebouxia sp. C | 2796353 | Plants | Plants | 43.5 | 0.0198 | NR | KAL3158193.1 | 3373144 | g149902 | i0 | 31 | 0.713114754098361 | 58 | 40 | 71.3 | 0 | 20 | 193 | 320 | 377 | KAL3158193.1 hypothetical protein ABBQ38_010449 [Trebouxia sp. C0009 RCD-2024] | diamond | 174 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 28637230 | 28637230 | PRJNA983848_P_NODE_56387_length_444_cov_1.051213_g50508_i0 | PRJNA983848 | 56387 | 444 | 1.051213 | 4.66738572 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 112 | 4.12e-26 | NR | XP_011401591.1 | 3075 | g50508 | i0 | 44.4 | 2.77702702702703 | 144 | 76 | 95.3 | 3 | 3 | 425 | 250 | 392 | XP_011401591.1 Peroxiredoxin-2 [Auxenochlorella protothecoides] | diamond | 1233 | 112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30468929 | 30468929 | PRJNA983848_P_NODE_156273_length_244_cov_0.912281_g150390_i0 | PRJNA983848 | 156273 | 244 | 0.912281 | 2.22596564 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 53.1 | 8.11e-6 | NR | KAK3276030.1 | 36881 | g150390 | i0 | 42.4 | 0.811475409836066 | 66 | 33 | 81.1 | 2 | 202 | 5 | 115 | 175 | KAK3276030.1 hypothetical protein CYMTET_15873 [Cymbomonas tetramitiformis] | diamond | 198 | 53.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 30500325 | 30500325 | PRJNA983848_P_NODE_92453_length_317_cov_1.508197_g86570_i0 | PRJNA983848 | 92453 | 317 | 1.508197 | 4.78098449 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 122 | 1.96e-33 | NR | KAI8104783.1 | 2696299 | g86570 | i0 | 64.4 | 1.98738170347003 | 104 | 37 | 98.4 | 0 | 3 | 314 | 14 | 117 | KAI8104783.1 hypothetical protein M9434_003335 [Picochlorum sp. BPE23] | diamond | 630 | 122 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 30727368 | 30727368 | PRJNA983848_P_NODE_87954_length_327_cov_1.027559_g82071_i0 | PRJNA983848 | 87954 | 327 | 1.0275589999999999 | 3.36011793 | Eukaryota | 2759 | Plants | Plants | 95.9 | 7.550000000000001e-21 | NR | KAG2423772.1 | 51695 | g82071 | i0 | 74.6 | 3.03669724770642 | 59 | 15 | 54.1 | 0 | 322 | 146 | 245 | 303 | KAG2423772.1 hypothetical protein HXX76_015048 [Chlamydomonas incerta] | diamond | 993 | 96.3 | 0.995846313603323 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 32017777 | 32017777 | PRJNA983848_P_NODE_117958_length_276_cov_1.536946_g112075_i0 | PRJNA983848 | 117958 | 276 | 1.536946 | 4.24197096 | Trebouxia sp. C | 2796353 | Plants | Plants | 61.6 | 2.69e-9 | NR | KAL0051365.1 | 2905655 | g112075 | i0 | 65.1 | 1.82608695652174 | 43 | 15 | 46.7 | 0 | 275 | 147 | 134 | 176 | KAL0051365.1 hypothetical protein WJX82_006297 [Trebouxia sp. C0006] | diamond | 504 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 |
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);;