contig_metadata
17 rows where bioproject = "PRJNA407368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3632558 | 3632558 | PRJNA407368_S_NODE_4363_length_273_cov_456.741803_g4261_i0 | PRJNA407368 | 4363 | 273 | 456.741803 | 1246.90512219 | Eukaryota | 2759 | Plants | Plants | 475 | 1.2499999999999999e-129 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g4261 | i0 | 98.168 | 100.234432234432 | 273 | 4 | 100 | 1 | 1 | 273 | 779 | 508 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 27364 | 475 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 3632599 | 3632599 | PRJNA407368_S_NODE_8343_length_176_cov_3.251701_g8241_i0 | PRJNA407368 | 8343 | 176 | 3.251701 | 5.72299376 | Trebouxia | 13786 | Plants | Plants | 287 | 3.74e-73 | NTclustered | gi|1545969|emb|Z68705.1| | 53268 | g8241 | i0 | 99.367 | 89.7727272727273 | 158 | 1 | 90 | 0 | 1 | 158 | 1770 | 1613 | T.arboricola (SAG 219-1a) 5.8S, 18S and 26S rRNA genes | blastn | 15800 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia arboricola | |
| 6792857 | 6792857 | PRJNA407368_S_NODE_6826_length_202_cov_2.167630_g6724_i0 | PRJNA407368 | 6826 | 202 | 2.16763 | 4.3786126 | Auxenochlorella pyrenoidosa | 3078 | Plants | Plants | 363 | 7.149999999999999e-96 | NTclustered | gi|1201359271|gb|MF040793.1| | 3078 | g6724 | i0 | 99.01 | 90.6584158415842 | 202 | 2 | 100 | 0 | 1 | 202 | 641 | 842 | Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence | blastn | 18313 | 363 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 8734567 | 8734567 | PRJNA407368_S_NODE_8387_length_175_cov_157.547945_g8285_i0 | PRJNA407368 | 8387 | 175 | 157.547945 | 275.70890375 | Eukaryota | 2759 | Plants | Plants | 222 | 1.0599999999999999e-53 | NTclustered | gi|371782091|emb|HE610123.1| | 3107 | g8285 | i0 | 91.515 | 94.2857142857143 | 165 | 8 | 94 | 5 | 12 | 175 | 4967 | 5126 | Hydrodictyon reticulatum 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2243 | blastn | 16500 | 222 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Hydrodictyon | Hydrodictyon reticulatum | |
| 9343302 | 9343302 | PRJNA407368_S_NODE_6588_length_206_cov_21.000000_g6486_i0 | PRJNA407368 | 6588 | 206 | 21 | 43.26 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 292 | 9.75e-75 | NTclustered | gi|535783|dbj|D17810.1|CHLLSURRNA | 63676 | g6486 | i0 | 92.233 | 100.980582524272 | 206 | 16 | 100 | 0 | 1 | 206 | 2833 | 3038 | Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron | blastn | 20802 | 292 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 10009816 | 10009816 | PRJNA407368_S_NODE_7788_length_184_cov_11.858065_g7686_i0 | PRJNA407368 | 7788 | 184 | 11.858065 | 21.8188396 | root | 1 | Root_unresolved | Root_unresolved | 289 | 1.0999999999999999e-73 | NTclustered | gi|189909382|gb|EU725860.1| | 13787 | g7686 | i0 | 96.571 | 101.559782608696 | 175 | 5 | 95 | 1 | 1 | 174 | 1534 | 1360 | Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 18687 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 11284982 | 11284982 | PRJNA407368_S_NODE_4109_length_284_cov_49.533333_g4007_i0 | PRJNA407368 | 4109 | 284 | 49.533333 | 140.67466572 | Eukaryota | 2759 | Plants | Plants | 479 | 1.01e-130 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g4007 | i0 | 98.529 | 95.7746478873239 | 272 | 3 | 96 | 1 | 1 | 272 | 693 | 963 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 27200 | 479 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 13835235 | 13835235 | PRJNA407368_S_NODE_8051_length_180_cov_7.112583_g7949_i0 | PRJNA407368 | 8051 | 180 | 7.112583 | 12.8026494 | Eukaryota | 2759 | Plants | Plants | 89.8 | 1.16e-13 | NTclustered | gi|970567768|dbj|LC066339.1| | 51712 | g7949 | i0 | 100 | 28.4944444444444 | 48 | 0 | 27 | 0 | 1 | 48 | 1829 | 1876 | Stephanosphaera pluvialis gene for 26S rRNA, partial sequence, strain: UTEX 771 | blastn | 5129 | 89.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Stephanosphaera | Stephanosphaera pluvialis | |
| 15109471 | 15109471 | PRJNA407368_S_NODE_8052_length_180_cov_7.066225_g7950_i0 | PRJNA407368 | 8052 | 180 | 7.066225 | 12.719205 | Chlorophyta | 3041 | Plants | Plants | 202 | 1.4299999999999999e-47 | NTclustered | gi|371782088|emb|HE610120.1| | 1108793 | g7950 | i0 | 86.813 | 101.061111111111 | 182 | 22 | 100 | 2 | 1 | 180 | 4149 | 3968 | Oltmannsiellopsis sp. CCMP1240 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain CCMP1240 | blastn | 18191 | 202 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Oltmannsiellopsidales | Oltmannsiellopsidaceae | Oltmannsiellopsis | Oltmannsiellopsis sp. CCMP1240 | |
| 16384091 | 16384091 | PRJNA407368_S_NODE_2153_length_418_cov_861.766067_g2052_i0 | PRJNA407368 | 2153 | 418 | 861.766067 | 3602.18216006 | Trebouxia | 13786 | Plants | Plants | 619 | 8.79e-173 | NTclustered | gi|162134340|gb|EU123979.1| | 160068 | g2052 | i0 | 93.541 | 121.614832535885 | 418 | 23 | 99 | 3 | 5 | 418 | 2473 | 2056 | Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast | blastn | 50835 | 619 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia aggregata | |
| 16384116 | 16384116 | PRJNA407368_S_NODE_5813_length_224_cov_28.728205_g5711_i0 | PRJNA407368 | 5813 | 224 | 28.728205 | 64.3511792 | Trebouxia | 13786 | Plants | Plants | 379 | 8.039999999999998e-101 | NTclustered | gi|933918303|gb|KP282203.1| | 1229085 | g5711 | i0 | 97.727 | 98.0580357142857 | 220 | 5 | 98 | 0 | 1 | 220 | 478 | 697 | Uncultured Trebouxia clone AA6 23S ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 21965 | 379 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Trebouxia | ||||
| 16992531 | 16992531 | PRJNA407368_S_NODE_10534_length_151_cov_2.827869_g10432_i0 | PRJNA407368 | 10534 | 151 | 2.827869 | 4.27008219 | Eukaryota | 2759 | Plants | Plants | 79.7 | 9.81e-16 | NR | KAK2079309.1 | 3111 | g10432 | i0 | 80 | 18.8741721854305 | 50 | 10 | 99.3 | 0 | 150 | 1 | 241 | 290 | KAK2079309.1 70-kilodalton heat shock protein [Prototheca wickerhamii] | diamond | 2850 | 79.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 18266686 | 18266686 | PRJNA407368_S_NODE_4155_length_282_cov_10.766798_g4053_i0 | PRJNA407368 | 4155 | 282 | 10.766798 | 30.36237036 | Ostreobium quekettii | 121088 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|2306645722|gb|OK189530.1| | 121088 | g4053 | i0 | 94.444 | 0.127659574468085 | 36 | 1 | 12 | 1 | 1 | 35 | 66811 | 66846 | Ostreobium quekettii voucher Chloroplast genome chloroplast, complete genome | blastn | 36 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 20207887 | 20207887 | PRJNA407368_S_NODE_2796_length_359_cov_46.284848_g2694_i0 | PRJNA407368 | 2796 | 359 | 46.284848 | 166.16260432 | Trebouxia | 13786 | Plants | Plants | 628 | 1.2399999999999997e-175 | NTclustered | gi|171479768|gb|EU352794.1| | 53267 | g2694 | i0 | 98.329 | 102.871866295265 | 359 | 5 | 100 | 1 | 1 | 359 | 656 | 299 | Trebouxia jamesii strain UTEX 2233 large subunit ribosomal RNA (rrnL) gene, partial sequence; and unknown genes; chloroplast | blastn | 36931 | 628 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia jamesii | |
| 22758648 | 22758648 | PRJNA407368_S_NODE_4458_length_269_cov_111.212500_g4356_i0 | PRJNA407368 | 4458 | 269 | 111.2125 | 299.161625 | Eukaryota | 2759 | Plants | Plants | 305 | 1.71e-78 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g4356 | i0 | 98.276 | 65.0111524163569 | 174 | 3 | 65 | 0 | 85 | 258 | 1240 | 1413 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 17488 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 24033471 | 24033471 | PRJNA407368_S_NODE_979_length_642_cov_7.318108_g905_i0 | PRJNA407368 | 979 | 642 | 7.318108 | 46.98225336 | Eukaryota | 2759 | Plants | Plants | 206 | 4.629999999999999e-48 | NTclustered | gi|2724824305|gb|PP746556.1| | 91190 | g905 | i0 | 78.659 | 36.7725856697819 | 328 | 56 | 50 | 11 | 202 | 523 | 2842 | 2523 | Dicloster acuatus culture SAG:41.98 mitochondrion, complete genome | blastn | 23608 | 207 | 0.995169082125604 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 32887885 | 32887885 | PRJNA407368_S_NODE_800_length_725_cov_16.553161_g734_i0 | PRJNA407368 | 800 | 725 | 16.553161 | 120.01041725 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 139 | 6.22e-35 | NR | KAG1664378.1 | 1653778 | g734 | i0 | 81.6 | 0.31448275862069 | 76 | 14 | 31.4 | 0 | 580 | 353 | 164 | 239 | KAG1664378.1 hypothetical protein FOA52_004711 [Chlamydomonas sp. UWO 241] | diamond | 228 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 |
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);;