contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4462004 | 4462004 | PRJNA667863_P_NODE_9824_length_259_cov_1.344086_g9790_i0 | PRJNA667863 | 9824 | 259 | 1.344086 | 3.48118274 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 174 | 4.83e-39 | NTclustered | gi|760437194|ref|XM_011397364.1| | 3075 | g9790 | i0 | 83.246 | 3.07335907335907 | 191 | 30 | 73 | 2 | 8 | 197 | 432 | 243 | Auxenochlorella protothecoides 40S ribosomal protein S3a partial mRNA | blastn | 796 | 174 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 5737297 | 5737297 | PRJNA667863_P_NODE_10345_length_256_cov_1.120219_g10311_i0 | PRJNA667863 | 10345 | 256 | 1.120219 | 2.86776064 | Volvox carteri | 3067 | Plants | Plants | 141 | 4.83e-29 | NTclustered | gi|302833676|ref|XM_002948356.1| | 3068 | g10311 | i0 | 84.138 | 53.7734375 | 145 | 23 | 57 | 0 | 31 | 175 | 732 | 876 | Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl3), mRNA | blastn | 13766 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 5737542 | 5737542 | PRJNA667863_P_NODE_9685_length_259_cov_3.107527_g9651_i0 | PRJNA667863 | 9685 | 259 | 3.107527 | 8.04849493 | Chlorella sorokiniana | 3076 | Plants | Plants | 182 | 2.88e-41 | NTclustered | gi|81157942|dbj|AB240142.1| | 3076 | g9651 | i0 | 80.769 | 7.35521235521236 | 234 | 43 | 90 | 2 | 1 | 233 | 1823 | 2055 | Chlorella sorokiniana EF-2 mRNA for elongation factor 2, partial cds | blastn | 1905 | 182 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 7012530 | 7012530 | PRJNA667863_P_NODE_1746_length_412_cov_1.710914_g1712_i0 | PRJNA667863 | 1746 | 412 | 1.710914 | 7.04896568 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 228 | 6.1299999999999984e-55 | NTclustered | gi|760444070|ref|XM_011400802.1| | 3075 | g1712 | i0 | 77.806 | 27.8349514563107 | 392 | 72 | 93 | 11 | 1 | 384 | 400 | 16 | Auxenochlorella protothecoides 40S ribosomal protein S9-1 partial mRNA | blastn | 11468 | 228 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 12113213 | 12113213 | PRJNA667863_P_NODE_13270_length_247_cov_1.752874_g13236_i0 | PRJNA667863 | 13270 | 247 | 1.752874 | 4.32959878 | Monoraphidium neglectum | 145388 | Plants | Plants | 147 | 9.96e-31 | NTclustered | gi|926794628|ref|XM_014050334.1| | 145388 | g13236 | i0 | 80.711 | 27.8259109311741 | 197 | 30 | 78 | 8 | 55 | 247 | 384 | 192 | Monoraphidium neglectum ribonucleoprotein-associated protein mRNA | blastn | 6873 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 12113327 | 12113327 | PRJNA667863_P_NODE_5270_length_298_cov_1.600000_g5236_i0 | PRJNA667863 | 5270 | 298 | 1.6 | 4.768 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 52.8 | 0.028 | NTclustered | gi|2082265387|ref|XM_043070277.1| | 3055 | g5236 | i0 | 96.774 | 0.104026845637584 | 31 | 1 | 10 | 0 | 213 | 243 | 1609 | 1639 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_14g626000v5), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17212092 | 17212092 | PRJNA667863_P_NODE_6234_length_286_cov_1.112676_g6200_i0 | PRJNA667863 | 6234 | 286 | 1.112676 | 3.18225336 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 294 | 3.98e-75 | NTclustered | gi|224593220|gb|FJ715708.1| | 3055 | g6200 | i0 | 85.512 | 91.6538461538462 | 283 | 39 | 99 | 2 | 1 | 282 | 21 | 302 | Chlamydomonas reinhardtii strain CC1690 translation elongation factor-like protein mRNA, partial cds | blastn | 26213 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22311305 | 22311305 | PRJNA667863_P_NODE_1758_length_411_cov_0.911243_g1724_i0 | PRJNA667863 | 1758 | 411 | 0.911243 | 3.74520873 | Chlorella variabilis | 554065 | Plants | Plants | 224 | 7.909999999999999e-54 | NTclustered | gi|552829322|ref|XM_005847613.1| | 554065 | g1724 | i0 | 79.077 | 99.7080291970803 | 325 | 66 | 79 | 2 | 87 | 410 | 537 | 214 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_134066) mRNA, complete cds | blastn | 40980 | 224 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 23586859 | 23586859 | PRJNA667863_P_NODE_9699_length_259_cov_2.672043_g9665_i0 | PRJNA667863 | 9699 | 259 | 2.672043 | 6.92059137 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 226 | 1.31e-54 | NTclustered | gi|545358305|ref|XM_005644675.1| | 574566 | g9665 | i0 | 82.677 | 95.5907335907336 | 254 | 44 | 98 | 0 | 5 | 258 | 1059 | 806 | Coccomyxa subellipsoidea C-169 26S proteasome AAA-ATPase subunit RPT6a mRNA | blastn | 24758 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 24860245 | 24860245 | PRJNA667863_P_NODE_4980_length_303_cov_1.669565_g4946_i0 | PRJNA667863 | 4980 | 303 | 1.669565 | 5.05878195 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 392 | 1.46e-104 | NTclustered | gi|18122|emb|X61624.1| | 3055 | g4946 | i0 | 90.066 | 99.3564356435644 | 302 | 30 | 99 | 0 | 1 | 302 | 1363 | 1062 | Chlamydomonas reinhardtii atp2 (atpB) mRNA | blastn | 30105 | 392 | 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);;