contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331695 | 331695 | PRJNA1215813_P_NODE_5581_length_329_cov_0.972656_g5501_i0 | PRJNA1215813 | 5581 | 329 | 0.972656 | 3.20003824 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 291 | 6.03e-74 | NTclustered | gi|2082247365|ref|XM_043062922.1| | 3055 | g5501 | i0 | 84.564 | 93.5987841945289 | 298 | 40 | 90 | 5 | 1 | 295 | 1883 | 1589 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g269950v5), mRNA | blastn | 30794 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1606553 | 1606553 | PRJNA1215813_P_NODE_6182_length_314_cov_1.082988_g6102_i0 | PRJNA1215813 | 6182 | 314 | 1.082988 | 3.40058232 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2082261417|ref|XM_043068617.1| | 3055 | g6102 | i0 | 100 | 0.184713375796178 | 30 | 0 | 10 | 0 | 133 | 162 | 637 | 608 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g534300v5), mRNA | blastn | 58 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1606564 | 1606564 | PRJNA1215813_P_NODE_7442_length_287_cov_2.186916_g7362_i0 | PRJNA1215813 | 7442 | 287 | 2.186916 | 6.27644892 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 163 | 1.18e-35 | NTclustered | gi|760448344|ref|XM_011402939.1| | 3075 | g7362 | i0 | 77.695 | 68.8606271777004 | 269 | 58 | 93 | 2 | 6 | 273 | 1 | 268 | Auxenochlorella protothecoides 60S ribosomal protein L15 partial mRNA | blastn | 19763 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 7985247 | 7985247 | PRJNA1215813_P_NODE_9367_length_253_cov_0.866667_g9287_i0 | PRJNA1215813 | 9367 | 253 | 0.866667 | 2.19266751 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 198 | 2.7899999999999998e-46 | NTclustered | gi|545360614|ref|XM_005645617.1| | 574566 | g9287 | i0 | 84.135 | 39.3557312252964 | 208 | 29 | 81 | 4 | 48 | 253 | 1776 | 1571 | Coccomyxa subellipsoidea C-169 EMP/nonaspanin domain family protein partial mRNA | blastn | 9957 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 10535591 | 10535591 | PRJNA1215813_P_NODE_3009_length_436_cov_1.837466_g2929_i0 | PRJNA1215813 | 3009 | 436 | 1.837466 | 8.01135176 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 58.4 | 0.001 | NTclustered | gi|2917929622|emb|OZ234910.1| | 3350044 | g2929 | i0 | 97.143 | 2.66284403669725 | 35 | 0 | 8 | 1 | 207 | 241 | 1793428 | 1793461 | Trebouxia sp. SL0000003 genome assembly, chromosome: 5 | blastn | 1161 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 11249158 | 11249158 | PRJNA1215813_P_NODE_2129_length_508_cov_47.002299_g2049_i0 | PRJNA1215813 | 2129 | 508 | 47.002299 | 238.77167892 | Eukaryota | 2759 | Plants | Plants | 918 | 0 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g2049 | i0 | 99.407 | 101.972440944882 | 506 | 3 | 99 | 0 | 3 | 508 | 1886 | 1381 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 51802 | 922 | 0.995661605206074 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 13085480 | 13085480 | PRJNA1215813_P_NODE_8011_length_277_cov_1.877451_g7931_i0 | PRJNA1215813 | 8011 | 277 | 1.877451 | 5.20053927 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 219 | 2.3699999999999998e-52 | NTclustered | gi|2082240937|ref|XM_043060180.1| | 3055 | g7931 | i0 | 80.866 | 92.884476534296 | 277 | 53 | 100 | 0 | 1 | 277 | 633 | 357 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g142687v5), mRNA | blastn | 25729 | 219 | 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);;