contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1136505" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5387726 | 5387726 | PRJNA1136505_P_NODE_48205_length_456_cov_1.516971_g41346_i0 | PRJNA1136505 | 48205 | 456 | 1.516971 | 6.91738776 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 257 | 8.730000000000001e-64 | NTclustered | gi|2082236323|ref|XM_001689445.2| | 3055 | g41346 | i0 | 78.089 | 5.50657894736842 | 429 | 78 | 92 | 12 | 9 | 426 | 325 | 748 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g019250v5), mRNA | blastn | 2511 | 257 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 6662301 | 6662301 | PRJNA1136505_P_NODE_119866_length_263_cov_1.368421_g113006_i0 | PRJNA1136505 | 119866 | 263 | 1.368421 | 3.59894723 | Chlorella variabilis | 554065 | Plants | Plants | 148 | 2.9799999999999997e-31 | NTclustered | gi|552833685|ref|XM_005848518.1| | 554065 | g113006 | i0 | 86.131 | 0.520912547528517 | 137 | 19 | 52 | 0 | 1 | 137 | 141 | 5 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_15825) mRNA, partial cds | blastn | 137 | 148 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 6662361 | 6662361 | PRJNA1136505_P_NODE_49926_length_444_cov_1.490566_g43067_i0 | PRJNA1136505 | 49926 | 444 | 1.490566 | 6.61811304 | Scenedesmus acutus | 104103 | Plants | Plants | 224 | 8.6e-54 | NTclustered | gi|1943322736|gb|MT611452.1| | 104103 | g43067 | i0 | 85.135 | 5.49099099099099 | 222 | 30 | 50 | 1 | 1 | 222 | 498 | 716 | Scenedesmus acutus guanine nucleotide-binding protein subunit beta-like protein mRNA, partial cds | blastn | 2438 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus acutus | |
| 9212519 | 9212519 | PRJNA1136505_P_NODE_37928_length_558_cov_2.169072_g31096_i0 | PRJNA1136505 | 37928 | 558 | 2.169072 | 12.10342176 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 174 | 1.1199999999999999e-38 | NTclustered | gi|2082265902|ref|XM_043070515.1| | 3055 | g31096 | i0 | 82.673 | 4.42293906810036 | 202 | 29 | 36 | 4 | 101 | 299 | 381 | 183 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_15g635600v5), mRNA | blastn | 2468 | 174 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9212540 | 9212540 | PRJNA1136505_P_NODE_96228_length_294_cov_1.393665_g89368_i0 | PRJNA1136505 | 96228 | 294 | 1.393665 | 4.0973751 | Monoraphidium neglectum | 145388 | Plants | Plants | 279 | 1.15e-70 | NTclustered | gi|926783383|ref|XM_014044712.1| | 145388 | g89368 | i0 | 84.429 | 26.6156462585034 | 289 | 39 | 97 | 4 | 9 | 294 | 557 | 842 | Monoraphidium neglectum 26S proteasome regulatory subunit T1 mRNA | blastn | 7825 | 279 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 13038247 | 13038247 | PRJNA1136505_P_NODE_77751_length_332_cov_1.783784_g70891_i0 | PRJNA1136505 | 77751 | 332 | 1.783784 | 5.92216288 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 139 | 2.33e-28 | NTclustered | gi|2082237132|ref|XM_001689609.2| | 3055 | g70891 | i0 | 75.081 | 1.86144578313253 | 309 | 71 | 92 | 6 | 1 | 306 | 552 | 857 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g038400v5), mRNA | blastn | 618 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13785365 | 13785365 | PRJNA1136505_P_NODE_72531_length_345_cov_3.216912_g65671_i0 | PRJNA1136505 | 72531 | 345 | 3.216912 | 11.0983464 | Eukaryota | 2759 | Plants | Plants | 623 | 5.519999999999999e-174 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g65671 | i0 | 99.417 | 99.4144927536232 | 343 | 2 | 99 | 0 | 3 | 345 | 1270 | 1612 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 34298 | 623 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 14313463 | 14313463 | PRJNA1136505_P_NODE_68352_length_358_cov_1.508772_g61492_i0 | PRJNA1136505 | 68352 | 358 | 1.508772 | 5.40140376 | Chlorella variabilis | 554065 | Plants | Plants | 307 | 6.55e-79 | NTclustered | gi|552829255|ref|XM_005847597.1| | 554065 | g61492 | i0 | 85.473 | 14.9748603351955 | 296 | 41 | 82 | 2 | 64 | 358 | 28 | 322 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_48816) mRNA, complete cds | blastn | 5361 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 17609658 | 17609658 | PRJNA1136505_P_NODE_73494_length_343_cov_1.211111_g66634_i0 | PRJNA1136505 | 73494 | 343 | 1.211111 | 4.15411073 | Chlorophyta | 3041 | Plants | Plants | 364 | 3.6699999999999987e-96 | NTclustered | gi|926763009|ref|XM_014035103.1| | 145388 | g66634 | i0 | 90.809 | 89.1253644314869 | 272 | 25 | 79 | 0 | 72 | 343 | 308 | 37 | Monoraphidium neglectum Histone H4 mRNA | blastn | 30570 | 364 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 24510408 | 24510408 | PRJNA1136505_P_NODE_122280_length_260_cov_1.395722_g115420_i0 | PRJNA1136505 | 122280 | 260 | 1.395722 | 3.6288772 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 126 | 1.38e-24 | NTclustered | gi|2917929618|emb|OZ234906.1| | 3350044 | g115420 | i0 | 80.745 | 0.619230769230769 | 161 | 31 | 62 | 0 | 100 | 260 | 3910622 | 3910782 | Trebouxia sp. SL0000003 genome assembly, chromosome: 1 | blastn | 161 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 |
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);;