contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1930005 | 1930005 | PRJNA681822_P_NODE_288802_length_277_cov_1.377451_g287313_i0 | PRJNA681822 | 288802 | 277 | 1.377451 | 3.81553927 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 322 | 1.76e-83 | NTclustered | gi|545363365|ref|XM_005646756.1| | 574566 | g287313 | i0 | 88.148 | 10.1046931407942 | 270 | 32 | 97 | 0 | 3 | 272 | 299 | 30 | Coccomyxa subellipsoidea C-169 ribosomal protein L3 component of cytosolic 80S ribosome and 60S large subunit mRNA | blastn | 2799 | 322 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 1930041 | 1930041 | PRJNA681822_P_NODE_291822_length_276_cov_1.517241_g290333_i0 | PRJNA681822 | 291822 | 276 | 1.517241 | 4.18758516 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 510 | 3.48e-140 | NTclustered | gi|760443516|ref|XM_011400525.1| | 3075 | g290333 | i0 | 100 | 2.13768115942029 | 276 | 0 | 100 | 0 | 1 | 276 | 385 | 110 | Auxenochlorella protothecoides 40S ribosomal protein S10 partial mRNA | blastn | 590 | 510 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 3205761 | 3205761 | PRJNA681822_P_NODE_372163_length_254_cov_1.303867_g370674_i0 | PRJNA681822 | 372163 | 254 | 1.303867 | 3.31182218 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 331 | 2.6500000000000002e-86 | NTclustered | gi|760439914|ref|XM_011398724.1| | 3075 | g370674 | i0 | 100 | 0.704724409448819 | 179 | 0 | 70 | 0 | 76 | 254 | 2 | 180 | Auxenochlorella protothecoides Signal recognition particle 19 kDa protein partial mRNA | blastn | 179 | 331 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 4481467 | 4481467 | PRJNA681822_P_NODE_249664_length_286_cov_2.431925_g248175_i0 | PRJNA681822 | 249664 | 286 | 2.431925 | 6.9553055 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 291 | 5.15e-74 | NTclustered | gi|545366739|ref|XM_005648197.1| | 574566 | g248175 | i0 | 85.121 | 2.59090909090909 | 289 | 37 | 100 | 5 | 1 | 286 | 830 | 1115 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 741 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 4482523 | 4482523 | PRJNA681822_P_NODE_343364_length_262_cov_1.645503_g341875_i0 | PRJNA681822 | 343364 | 262 | 1.645503 | 4.31121786 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 479 | 9.249999999999999e-131 | NTclustered | gi|760446174|ref|XM_011401854.1| | 3075 | g341875 | i0 | 99.618 | 71.0038167938931 | 262 | 1 | 100 | 0 | 1 | 262 | 267 | 528 | Auxenochlorella protothecoides 40S ribosomal protein S2 partial mRNA | blastn | 18603 | 479 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 4999088 | 4999088 | PRJNA681822_P_NODE_364524_length_256_cov_1.683060_g363035_i0 | PRJNA681822 | 364524 | 256 | 1.68306 | 4.3086336 | Pithophoraceae | 926346 | Plants | Plants | 473 | 4.189999999999999e-129 | NTclustered | gi|1050773031|gb|KU727243.1| | 1883088 | g363035 | i0 | 100 | 100.015625 | 256 | 0 | 100 | 0 | 1 | 256 | 656 | 911 | Aegagropilopsis sp. WD1401 18S ribosomal RNA gene, partial sequence | blastn | 25604 | 473 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Pithophoraceae | Aegagropilopsis | Aegagropilopsis sp. WD1401 | |
| 6274527 | 6274527 | PRJNA681822_P_NODE_334785_length_265_cov_1.203125_g333296_i0 | PRJNA681822 | 334785 | 265 | 1.203125 | 3.18828125 | Eukaryota | 2759 | Plants | Plants | 209 | 1.36e-49 | NTclustered | gi|2030184183|gb|MZ045839.1| | 3077 | g333296 | i0 | 81.467 | 92.8377358490566 | 259 | 44 | 97 | 3 | 2 | 258 | 284 | 28 | Chlorella vulgaris isolate GCH12 small subunit ribosomal RNA gene, partial sequence | blastn | 24602 | 209 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 8309650 | 8309650 | PRJNA681822_P_NODE_49947_length_527_cov_2.792952_g48489_i0 | PRJNA681822 | 49947 | 527 | 2.792952 | 14.71885704 | Ulva prolifera | 3117 | Plants | Plants | 472 | 3.3499999999999996e-128 | NTclustered | gi|1915399073|gb|MN867373.1| | 3117 | g48489 | i0 | 83.629 | 91.4629981024668 | 507 | 78 | 96 | 3 | 22 | 527 | 531 | 29 | Ulva prolifera light-harvesting complex II protein (lhcbm-6) mRNA, partial cds | blastn | 48201 | 472 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 12131507 | 12131507 | PRJNA681822_P_NODE_156050_length_337_cov_1.276515_g154562_i0 | PRJNA681822 | 156050 | 337 | 1.276515 | 4.30185555 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 169 | 3.03e-37 | NTclustered | gi|760443892|ref|XM_011400713.1| | 3075 | g154562 | i0 | 98.936 | 0.27893175074184 | 94 | 1 | 28 | 0 | 1 | 94 | 1113 | 1206 | Auxenochlorella protothecoides DnaJ-like protein subfamily B member 14 partial mRNA | blastn | 94 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18507320 | 18507320 | PRJNA681822_P_NODE_394035_length_250_cov_0.870056_g392546_i0 | PRJNA681822 | 394035 | 250 | 0.870056 | 2.17514 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 54.7 | 0.006 | NTclustered | gi|2082270078|ref|XM_043072241.1| | 3055 | g392546 | i0 | 100 | 0.116 | 29 | 0 | 12 | 0 | 39 | 67 | 1641 | 1669 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_17g719900v5), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21058053 | 21058053 | PRJNA681822_P_NODE_417357_length_248_cov_0.880000_g415868_i0 | PRJNA681822 | 417357 | 248 | 0.88 | 2.1824 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 272 | 1.5799999999999996e-68 | NTclustered | gi|545373953|ref|XM_005651234.1| | 574566 | g415868 | i0 | 87.879 | 0.931451612903226 | 231 | 28 | 93 | 0 | 18 | 248 | 994 | 1224 | Coccomyxa subellipsoidea C-169 TBCC-domain-containing protein partial mRNA | blastn | 231 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 22331253 | 22331253 | PRJNA681822_P_NODE_280898_length_279_cov_1.354369_g279409_i0 | PRJNA681822 | 280898 | 279 | 1.354369 | 3.77868951 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 516 | 7.58e-142 | NTclustered | gi|760440844|ref|XM_011399189.1| | 3075 | g279409 | i0 | 100 | 1 | 279 | 0 | 100 | 0 | 1 | 279 | 292 | 14 | Auxenochlorella protothecoides Ubiquitin-40S ribosomal protein S27a-1 partial mRNA | blastn | 279 | 516 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 23606991 | 23606991 | PRJNA681822_P_NODE_303379_length_273_cov_1.540000_g301890_i0 | PRJNA681822 | 303379 | 273 | 1.54 | 4.2042 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 449 | 7.61e-122 | NTclustered | gi|760440080|ref|XM_011398807.1| | 3075 | g301890 | i0 | 100 | 1.66666666666667 | 243 | 0 | 89 | 0 | 31 | 273 | 991 | 1233 | Auxenochlorella protothecoides ADP,ATP carrier protein partial mRNA | blastn | 455 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 24121902 | 24121902 | PRJNA681822_P_NODE_160739_length_333_cov_3.669231_g159251_i0 | PRJNA681822 | 160739 | 333 | 3.669231 | 12.21853923 | Eukaryota | 2759 | Plants | Plants | 616 | 8.87e-172 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g159251 | i0 | 100 | 99.96996996997 | 333 | 0 | 100 | 0 | 1 | 333 | 899 | 567 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 33290 | 616 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 24882423 | 24882423 | PRJNA681822_P_NODE_475160_length_242_cov_0.863905_g473670_i0 | PRJNA681822 | 475160 | 242 | 0.863905 | 2.0906501 | Blidingia sp. DT1 | 2022611 | Plants | Plants | 315 | 2.52e-81 | NTclustered | gi|1220117795|gb|KY401415.1| | 2022611 | g473670 | i0 | 90.417 | 100.152892561983 | 240 | 22 | 99 | 1 | 3 | 242 | 1030 | 792 | Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence | blastn | 24237 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Blidingia | Blidingia sp. DT1 |
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);;