contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 607596 | 607596 | PRJNA635874_P_NODE_43621_length_258_cov_1.627027_g43474_i0 | PRJNA635874 | 43621 | 258 | 1.627027 | 4.19772966 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 292 | 1.27e-74 | NTclustered | gi|545367280|ref|XM_005648425.1| | 574566 | g43474 | i0 | 87.16 | 81.2558139534884 | 257 | 33 | 99 | 0 | 1 | 257 | 466 | 210 | Coccomyxa subellipsoidea C-169 ribosomal protein S9 component of cytosolic 80S ribosome and 40S small subunit partial mRNA | blastn | 20964 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 4435291 | 4435291 | PRJNA635874_P_NODE_42244_length_262_cov_1.550265_g42097_i0 | PRJNA635874 | 42244 | 262 | 1.550265 | 4.0616943 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 135 | 2.31e-27 | NTclustered | gi|760445578|ref|XM_011401556.1| | 3075 | g42097 | i0 | 81.065 | 3.87786259541985 | 169 | 32 | 65 | 0 | 1 | 169 | 273 | 105 | Auxenochlorella protothecoides 40S ribosomal protein S11 partial mRNA | blastn | 1016 | 135 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 4435802 | 4435802 | PRJNA635874_P_NODE_64564_length_244_cov_0.900585_g64417_i0 | PRJNA635874 | 64564 | 244 | 0.900585 | 2.1974274 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 137 | 5.91e-28 | NTclustered | gi|2082248373|ref|XM_001695415.2| | 3055 | g64417 | i0 | 77.866 | 5.09426229508197 | 253 | 35 | 100 | 17 | 1 | 244 | 868 | 628 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g284250v5), mRNA | blastn | 1243 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9536641 | 9536641 | PRJNA635874_P_NODE_65148_length_244_cov_0.900585_g65001_i0 | PRJNA635874 | 65148 | 244 | 0.900585 | 2.1974274 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 156 | 1.63e-33 | NTclustered | gi|545373181|ref|XM_005650924.1| | 574566 | g65001 | i0 | 84.146 | 10.6475409836066 | 164 | 22 | 66 | 4 | 9 | 170 | 315 | 476 | Coccomyxa subellipsoidea C-169 chlorophyll a/b-binding protein partial mRNA | blastn | 2598 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 17185335 | 17185335 | PRJNA635874_P_NODE_34954_length_285_cov_0.853774_g34807_i0 | PRJNA635874 | 34954 | 285 | 0.853774 | 2.4332559 | Massjukichlorella minus | 2650457 | Plants | Plants | 460 | 3.69e-125 | NTclustered | gi|2473928430|ref|NC_072902.1| | 2650457 | g34807 | i0 | 95.789 | 99.540350877193 | 285 | 12 | 100 | 0 | 1 | 285 | 37374 | 37658 | Massjukichlorella minus clone BN2720 chloroplast, complete genome | blastn | 28369 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Massjukichlorella | Massjukichlorella minus | |
| 21010316 | 21010316 | PRJNA635874_P_NODE_56337_length_247_cov_0.885057_g56190_i0 | PRJNA635874 | 56337 | 247 | 0.885057 | 2.18609079 | Massjukichlorella minus | 2650457 | Plants | Plants | 377 | 3.24e-100 | NTclustered | gi|2473928430|ref|NC_072902.1| | 2650457 | g56190 | i0 | 94.309 | 44.4048582995951 | 246 | 14 | 99 | 0 | 1 | 246 | 188875 | 189120 | Massjukichlorella minus clone BN2720 chloroplast, complete genome | blastn | 10968 | 377 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Massjukichlorella | Massjukichlorella minus | |
| 22285031 | 22285031 | PRJNA635874_P_NODE_57938_length_247_cov_0.885057_g57791_i0 | PRJNA635874 | 57938 | 247 | 0.885057 | 2.18609079 | Volvox carteri | 3067 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|62751199|gb|AC156446.2| | 3067 | g57791 | i0 | 100 | 0.121457489878543 | 30 | 0 | 12 | 0 | 148 | 177 | 18459 | 18488 | Volvox carteri clone JGIAOBO-29H23, complete sequence | blastn | 30 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri |
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);;