contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1160375 | 1160375 | PRJNA657343_P_NODE_46901_length_154_cov_3.295238_g46877_i0 | PRJNA657343 | 46901 | 154 | 3.295238 | 5.07466652 | Eukaryota | 2759 | Plants | Plants | 278 | 1.92e-70 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g46877 | i0 | 99.346 | 92.1363636363636 | 153 | 1 | 99 | 0 | 2 | 154 | 523 | 371 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 14189 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 8276238 | 8276238 | PRJNA657343_P_NODE_24907_length_191_cov_1.492958_g24883_i0 | PRJNA657343 | 24907 | 191 | 1.492958 | 2.85154978 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 183 | 5.5799999999999996e-42 | NTclustered | gi|1102971032|gb|FJ196315.2| | 3075 | g24883 | i0 | 84.409 | 8.49214659685864 | 186 | 29 | 97 | 0 | 2 | 187 | 621 | 436 | Auxenochlorella protothecoides ribosomal protein S5 (RPS5) mRNA, partial cds | blastn | 1622 | 183 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 13914504 | 13914504 | PRJNA657343_S_NODE_3631_length_402_cov_11.495751_g3607_i0 | PRJNA657343 | 3631 | 402 | 11.495751 | 46.21291902 | Eukaryota | 2759 | Plants | Plants | 701 | 0 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g3607 | i0 | 100 | 94.1044776119403 | 379 | 0 | 94 | 0 | 24 | 402 | 872 | 494 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 37830 | 701 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 14652038 | 14652038 | PRJNA657343_P_NODE_34912_length_169_cov_1.483333_g34888_i0 | PRJNA657343 | 34912 | 169 | 1.483333 | 2.50683277 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 89.8 | 1.08e-13 | NTclustered | gi|2082253177|ref|XM_001694173.2| | 3055 | g34888 | i0 | 81.579 | 1.46745562130178 | 114 | 15 | 64 | 4 | 31 | 139 | 372 | 260 | Chlamydomonas reinhardtii ribosomal protein S25 (CHLRE_08g382500v5), mRNA | blastn | 248 | 89.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 16463217 | 16463217 | PRJNA657343_P_NODE_9993_length_268_cov_1.378995_g9969_i0 | PRJNA657343 | 9993 | 268 | 1.378995 | 3.6957066 | Eukaryota | 2759 | Plants | Plants | 163 | 1.09e-35 | NTclustered | gi|1861356259|gb|MT377357.1| | 51329 | g9969 | i0 | 78.295 | 46.384328358209 | 258 | 52 | 96 | 4 | 12 | 267 | 566 | 311 | Polytomella parva clone 0016313597 elongation factor 2 (Ef-2) mRNA, complete cds; plastid | blastn | 12431 | 163 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella parva | |
| 21562472 | 21562472 | PRJNA657343_S_NODE_21797_length_193_cov_1.548611_g21772_i0 | PRJNA657343 | 21797 | 193 | 1.548611 | 2.98881923 | Eukaryota | 2759 | Plants | Plants | 357 | 3.1499999999999996e-94 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g21772 | i0 | 100 | 99.8238341968912 | 193 | 0 | 100 | 0 | 1 | 193 | 281 | 89 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 19266 | 357 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. |
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);;